SUMMARY

• A growth driven self - motivated Datastage / Mainframe Analyst with over 10.1 years of progressive experience in the Business Information Management sphere.
• Offering a rich mixture of business and technical expertise in Mainframe, ETL和报告, 直系银行/金融和保险领域.
• 有咨询方面的工作记录, 需求分析, 设计, 发展中, 测试, 集成和实现新颖的端到端业务解决方案, 与关键业务需求保持一致, 在严格的期限内, 王牌商业公司.
• 10.1 years of working experience for Confidential Consultancy Services both at onshore and offshore in various capacities.
• 4.1 Years of ETL Data Stage Experience and 6 Years of Mainframe Experience
• Very strong experience with various migrations and acquetions projects in both Data Stage and Mainframe.
• Strong design experience to independently turn Physical Data Model into Data Stage job design.
• Strong Data Stage implémentation skill to complete implementation within tight Project Schedule.
• Expert level knowledge of relational databases (especially DB2 and Oracle) and worked on Flat files
• Experienced in Full Life Cycle 发展 of building a Operational Data Store for large technology projects including Analysis, 设计, 发展, 测试, 维护和文档.
• 良好的Unix shell脚本技能.
• Extensively Worked on Job Sequences to control the execution of the job flow using various activities like Job Activity, 电子邮件通知, 定序器, 日常活动和执行命令活动
• Complete team co-ordination involving task allocation among team members and holding frequent discussions to monitor progress of project work
• Extensively worked on Parallel Jobs using Various Stages like Join, Lookup. 查找文件集, 改变捕捉, 过滤器, 漏斗, 复制, 排序, 文件集, 顺序文件, 数据集, Oracle企业, 合并, 聚合器, 删除重复的阶段, 主舞台, 存储过程阶段, CFF阶段.
• 有良好的转换项目经验, Data migrations and Mainframe to ETL technology transformation projects.
• Good experience with Client Interaction, On shore - Offshore working model.
• 具有良好的分析和解决问题的能力.
• 良好的人际关系，书面和口头沟通能力. Multilingual, highly organized, detail-oriented professional with strong technical skills.
• 对软件开发生命周期的各个方面充满热情, 从设计到开发, 部署, 生产支持和数据质量 & 数据管理.

技术技能

操作系统: Unix, Win95/NT/2000/XP, IBM大型机Z/OS

语言/脚本: Unix Shell脚本，SQL,PL/SQL,COBOL,JCL,Eazytrieve

数据库: IBM - DB2, Oracle 11g

ETL工具: IBM Info Sphere数据阶段8.7(管理员, 经理, 设计师, 导演), Tectia终端和文件传输,XML Spy,TFS,Eclipse

主机配套工具: FILE-AID, 优良, DB2I, Spufi之类, SDSF, 改变人, Expeditor(批处理和在线), Abend-Aid, 特别行政区, CA7, QMF, 的NDM

其他工具: Microsoft Visio, Ultra Edit, Clear Case IBM Data Studio 3.1,用于DB2的TOAD, SQL Developer for Oracle, 质量中心, Maximo,补救措施,分享Point CHANGEMAN,CA7,联系

方法: 瀑布模型，敏捷

领域经验: 保险，银行和金融服务，零售

专业经验

保密,夏洛特

数据分析师

职责:

• Working with client and IT management and staffto establish and maintain consistent data element definitions across computing environments
• 与业务分析师合作, 解决方案架构师, 和系统分析师为客户设计解决方案
• 创建/完善技术规范.
• 分析和开发逻辑数据设计、数据模型.
• 定义数据验证规则/标准
• 了解数据需求, 数据类型, 可能的值，并理解Web服务中的数据结构
• Identifying the ACORD XML tags/JSON structure for each of the new data elements
• Creating Request Data Mapping for the identified data elements with transformations for Real time interface
• Creating the Response Data Mapping for the identified data elements with transformations for Real time interface
• Creating the Data Mapping for all new data elements with transformations for batch interface
• Working with the middleware and application teams to address all the Data Quality & 数据集成问题
• 创建示例请求XML/JSON请求实时接口
• 为实时接口创建示例响应XML/JSON响应
• 为批处理接口创建样例Request XML
• 为实时接口创建SID
• 为批处理接口创建BID
• Review the Data Mapping and BID/SID with the middleware and application teams
• Producing the necessary documents to ensure transition to support team once development is complete

保密,夏洛特

技术主管

职责:

• 项目策划及监察
• 设计ing system technically and Writing Technical Specifications of project
• 在Visio中创建高级和低级ETL流程图
• 设计ing concept template jobs and shared containers to help reduce the development time
• Created POCs for extracting data from complex source XML repeating tags
• 创建和处理较大的EBCDIC文件
• 为不同的功能创建了例程吗
• 控制体系结构的ETL开发, 常见的模块, 顺序控制和主要关键接口
• ETL作业和序列性能调优
• 项目中所有TCS开发模块的文档
• 用设计方法教育团队, 性能监控技术, Bug修复和对问题的及时响应
• Create master controlling sequence jobs using the Data Stage Job Sequence.
• 用于从存储库导入元数据的数据阶段管理器, 新的工作类别和创建新的数据元素.
• Used Data Stage Parallel Extender parallel jobs for improving the performance of jobs.
• Dealt extensively with data from Mainframe, DB2, XML, Flat file and SQL Server sources.
• Used Data Stage Director to validate schedule run and monitor the data stage jobs
• 使用Universe Basic开发用户自定义例程和变换.
• 在作业属性中使用的作业前/作业后子程序.
• 负责性能调优
• Used Data Stage for 发展中, programs for scheduling data loading and transformations
• Developing shell scripts to automate file manipulation and data loading procedures
• 维护了错误日志/审计跟踪.

保密,夏洛特

技术主管

职责:

• Responsible for reviewing functional specifications and preparing technical design framework for ETL.
• Interacted extensively with client/onsite team to resolve technical and infrastructural issues.
• 回顾LLD & 根据需求规范文档编制HLD文档.
• Interacted with Business Partners to understand the business requirements, 分析和设计集成方法.
• 使用Datasets执行ETL编码, 顺序文件, 变压器, 排序, 合并, 已编译的聚合器阶段, 调试和测试.
• Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• Used Data Stage 设计师 tools for creating Parallel jobs and importing and exporting the jobs.
• 使用数据阶段作业序列按顺序执行作业.
• Used Quality stages for enrich data to meet business objectives and data quality management standards.
• 已创建数据阶段作业，用于构建加载数据的业务规则.
• 使用Data Stage Director来运行和监视作业的状态.
• 将表/文件定义导入Data阶段存储库.
• Controlled jobs execution using sequencer, used notification activity to send email alerts.
• 参与性能调优和增强.
• Used Autosys job scheduler for automating the regular BAU Calendar schedule cycle in both production and UAT environments.
• Coordinating with Release Management, 数据管理 and Configuration Management.
• 确保与第三方供应商的技术关系.
• 支持银行的验收测试需求.
• 与陆上和海上团队进行每周状态会议.

保密,德州

技术主管

职责:

• Involved in Analyzing the existing mainframe programs and creating the Requirement documents.
• 使用COBOL/DB2、JCL和Eazytrieve进行大型机编码.
• Used CA7 Scheduler to schedule and execute the jobs based on the calendar schedule.
• 使用SDSF/特别行政区来运行和监视作业的状态.
• Responsible for reviewing functional specifications and preparing technical design framework for ETL.
• Interacted extensively with client/onsite team to resolve technical and infrastructural issues.
• 回顾LLD & 根据需求规范文档编制HLD文档.
• Interacted with Business Partners to understand the business requirements, 分析和设计集成方法.
• 使用Datasets执行ETL编码, 顺序文件, 变压器, 排序, 合并, 已编译的聚合器阶段, 调试和测试.
• Extensively used stages available to redesign DataStage jobs for performing the required integration.
• Used DataStage 设计师 tools for creating Parallel jobs and importing and exporting the jobs.
• 使用DataStage Job Sequences按顺序执行作业.
• Used Quality stages for enrich data to meet business objectives and data quality management standards.
• 创建DataStage job来构建加载数据的业务规则.
• 使用DataStage Director来运行和监视作业的状态.
• 将表/文件定义导入Data阶段存储库.
• Controlled jobs execution using sequencer, used notification activity to send email alerts.
• 参与性能调优和增强.
• Used Autosys job scheduler for automating the regular BAU Calendar schedule cycle in both production and UAT environments.
• Coordinating with Release Management, 数据管理 and Configuration Management.
• 确保与第三方供应商的技术关系.
• 支持银行的验收测试需求.
• 与陆上和海上团队进行每周状态会议.

保密,夏洛特

技术主管

职责:

• Involved in Analyzing the existing mainframe programs and creating the Requirement documents.
• 使用COBOL/DB2、JCL和Eazytrieve进行大型机编码.
• Used CA7 Scheduler to schedule and execute the jobs based on the calendar schedule.
• 使用SDSF/特别行政区来运行和监视作业的状态.
• Responsible for reviewing functional specifications and preparing technical design framework for ETL.
• Interacted extensively with client/onsite team to resolve technical and infrastructural issues.
• 回顾LLD & 根据需求规范文档编制HLD文档.
• Interacted with Business Partners to understand the business requirements, 分析和设计集成方法.
• Coordinating with Release Management, 数据管理 and Configuration Management.
• 确保与第三方供应商的技术关系.
• 支持银行的验收测试需求.
• 与陆上和海上团队进行每周状态会议.
• 参与灾难恢复过程.
• 领导离岸定期存款团队

保密,夏洛特

技术主管/团队成员

职责:

• 的NDM的创建/实现 & FTP流程.
• 运行时改进/自动化
• CA7调度异常
• 更新JCL, PROC和Parms以解决问题
• ABENDS -重新运行和重新启动
• 争用解决
• 性能改进
• 对软件工件进行评审
• 为指定项目进行财务报告
• Creation and assignment of tasks to the team members and delegation of work for timely completion.
• 在所有项目管理相关的质量活动中使用IPMS.
• 执行配置管理.
• 带领离岸小组

机密，威斯康辛州绿湾

技术主管/团队成员

职责:

• Discussions with RMS Confidential team based on the System Requirements
• 文档，以涵盖减少CPU时间的功能, 操作上, 技术问题和工作范围

机密，威斯康辛州绿湾

程序员/团队成员

职责:

• Involved in Analyzing the existing mainframe programs and creating the Requirement documents.
• 使用COBOL/DB2、JCL和Eazytrieve进行大型机编码.
• Used CA7 Scheduler to schedule and execute the jobs based on the callendar schedule.
• 使用SDSF/特别行政区来运行和监视作业的状态.
• Responsible for reviewing functional specifications and preparing technical design framework for ETL.
• Interacted extensively with client/onsite team to resolve technical and infrastructural issues.
• 回顾LLD & 根据需求规范文档编制HLD文档.
• Interacted with Business Partners to understand the business requirements, 分析和设计集成方法.
• Coordinating with Release Management, 数据管理 and Configuration Management.
• 确保与第三方供应商的技术关系.
• 支持银行的验收测试需求.
• 与陆上和海上团队进行每周状态会议.
• 参与灾难恢复过程.
• 领导离岸定期存款团队