Sr. Datastage and Mainframe project Lead. Resume Example

Dodd Frank 14Q:

• The Federal Reserve is collecting information for purposes of Capital Assessments and Stress Testing information, various data which is stored within our source systems: CDW, FTP, MCC, and CARM are known as FR Y-14Qs (Quarterly's).
• CDW (Credit Data Warehouse) will implement a systematic process to create the quarterly FRY 14Q Commercial Real Estate and Corporate Loan Data Collection schedules.
• To accomplish this, additional fields from various data sources will be sent to and stored in CDW.
• Dodd Frank 14Q wall street reform is a consumer protection act which was signed in response is to late 2000 recession to bring more stability in financial systems.
• The Federal Reserve is collecting information for purposes of Capital Assessments and Stress Testing information, various data which is stored within source systems: CDW, FTP, MCC, and CARM are known as FR Y-14Qs (Quarterly's).

Responsibilities:  

• Involved in analysis, planning, design, development, and implementation phases of projects using Infosphere datastage and Quality Stage v9.1 and Mainframes.
• ETL Process: Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables.
• Developed complex ETL jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Complex Flat File(CFF), Datasets, Sequential File, Aggregator and Modify Stages.
• Created queries to compare data between two databases to make sure data is matched.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Created shared container to incorporate complex business logic in job.
• Scheduling and monitoring the ETL jobs using Control M in UAT and production environments.
• Created and modified batch scripts to Connect Direct(CDT) the files from ETL server to mainframe server.
• Created Job Sequencers to automate the job.
• Created new and modified existing UNIX shell scripts to run Datastage jobs and necessary scripts for datastage project.
• Created parameter set to assign a value to job at run time.
• Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources.
• Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.
• Providing the logical data model design, generating database, resolving technical issues, and loading data into multiple instances.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Mainframe Process : Developed JCL to perform first pass logic that validates the source system files to makes sure that input files are complete and valid.
• Developing the COBOL-DB2 programs to load input files from ETL and other loan systems.
• Prepared the jobs using JCL to run COBOL-DB2 programs and Scheduled them in production using CA7.
• Generate quarterly reports using Commercial Real Estate and Corporate Loan Data and sends them Federal Government.

Environment:

• Staging: Datastage v8.1, Oracle 10g, Unix scripting, RTC for version control, Control M for DS jobs scheduling.
• Mainframes: COBOL, JCL, DB2, SPUFI, IBM-File Manager, IBM-Debug tool, Endevor for version control, CA7 for mainframe jobs scheduling.

Corep(Common Reporting):

• The European Banking Authority (EBA) is mandated the adoption of the revised Common Reporting (COREP) framework across all European entities beginning December 31, 2011.
• HSBC was required to report group results on this basis starting with the quarter ending 31st December 2011.
• The key impacts of COREP are that it requires additional granularity in reporting, additional reports, and the requirement that summary results be supported by granular underlying detail.
• Responsibilities: Analyzes requirements, and translates business requirements into product designs.
• Documented technical specifications and functional specifications.
• Designing the work flow or job flow for the new requirements.
• Coding, Unit testing and production implementation of Datastage and mainframe batch jobs.
• Carrying out Impact analysis and research on the affected system In charge of having the cycle completed within the specified SLA.
• Ensure the problem get fixed and enhanced of the system based on the business needs.
• Have good experience using DOS commands in file transfer and interacting to other systems.
• Good coordination with onsite and offshore team members.
• Involved in data conversion that includes extracting full data from system.
• Batch Cycle monitoring and supporting Production Batch.
• Creating and delivering the adhoc reports based on user requirements.

Environment:

• Staging: Datastage v8.1, Oracle 10g, Unix scripting, RTC for version control, Control M for DS jobs scheduling.
• Mainframes: COBOL, JCL, DB2, SPUFI, IBM-File Manager, IBM-Debug tool, Endevor for version control, CA7 for mainframe jobs scheduling.

Credit Data Warehouse(CDW):

• Credit Data Mart design is intended to store data to meet reporting requirements for Assessing Capital Adequacy in Relation to Risk.
• It will satisfy requirements set forth by the USA Federal Reserve letter SR 99-18, by the New Basel Capital Accord for both the Standard and IRB approach, as well as internal area, entity and group reporting.
• The Data Mart will store Credit data for Commercial products at a detailed level, Retail products at a "rolled up" portfolio level, as well as Treasury and Factoring Credit data.
• Credit Data Warehouse (CDW) is one of the project having complex Risk Weighted Asset (RWA) calculations that aid business in calculating Wholesale credit risk.
• As a part of risk calculations HSBC uses internally formulated RWA calculation logic that is specifically designed for risk calculations in HSBC US Bank.
• Credit Data Warehouse (CDW) stores the information about Commercial Credit Customers, their Facilities, Credit Instruments and Collateral.
• This data is feed for many regulatory projects including Common reporting (COREP), Dodd Frank(The Dodd Frank Wall street Reform and Consumer protection Act is a regulatory act that was signed in response to the late 2000 recession to bring more financial stability).
• Responsibilities: Coordinating to Test Support Activities and involving in 24/7 Production Support.
• Preparing Batch scripts and running Batch jobs intended for different Test scenarios.
• Resolving different type of issues interrelated to test support and production support.
• Refreshment of data in test regions with production data.
• Day-To-Day operational activities support in a Test Environment.
• Setting up the test environment for major enhancements.
• That includes refreshing /loading test environment with production data.
• Involved in resolving the issues related data loading, running Runstats and Reorgs against data in test environment.
• Make sure all DB2 tables, VSAM files and all other required files available for testing.
• Responsible for providing support and maintenance of the Application in and Test Environments.
• Preparing jobs in Test environment and running in CA7 scheduler as per the production script.
• Coordinating with development team to make sure all test results verified and passed in the test environment.
• Familiar with all IBM utilities File Manager, Debug, Performance analyzer, Endevor, QMF and SPUFI).
• Working on enhancements to fix the production problems.
• Understanding the new requirements.
• Analyzing the impact of the existing system for the new requirement.
• Coding, Unit testing and production implementation of the project in Mainframe environment.

Environment:  

• COBOL, JCL, VSAM, DB2, SAS, REXX, and CA7.