SUMMARY

• 9 years of Experience in IT of which 4 Years of experience in System Analysis, Design and Development in the field of Data warehousing, Data Integration, Data Cleansing, Data Profiling and Business Intelligence as ETL Datastage Developer
• Experience with special emphasis in ETL methodologies in all the phases of the Data warehousing life cycle and with knowledge in Data warehouses, Decision Support Systems, Operational Data Stores and OLTP/OLAP technology.
• Worked extensively on IBM InfoSphere DataStage 8.5 and 8.1 using Components like DataStage Designer, DataStage Director, DataStage Administrator Information Server.
• Excellent experience in working with large data feeds and heterogeneous systems like Oracle, SQL Server, DB2, XML files, COBOL/Mainframe files and Flat files.
• Pervasive knowledge of IT industry domains such as Banking, Finance, and Insurance.
• Proficient in all stage of development lifecycle, QA process, Test Strategies like Functional, Regression, Database, Integration, Co-Existence and Performance Testing.
• Proven track record in troubleshooting of DataStage jobs and addressing production issues like performance tuning and enhancement.
• Excellent knowledge of studying the data dependencies using Metadata stored in the DataStage Repository.
• Played multiple roles - Programmer Analyst, Application Developer , Module Leader Front Line Manager .

SOFTWARE

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer / DataStage Consultant

This project aimed at developing a product which will be universal and generic in its approach and will combine sources and can be implemented across 84 countries. The purpose of this project is to implement a single Group Enterprise Warehousing strategy by reducing the cost to company, improving the customer services , maintaining transparency in the customer details globally. Some of business modules are Deposits, Customers, Credit cards, mortgage, core assets and loan and Product etc. The data from heterogeneous sources are analyzed , integrated , transformed into homogenous source for easy access and maintain the history via data marts.

Responsibilities

• Understood the technical specifications and develop data stage jobs for Extraction Transformation, Cleansing and Loading process of DW.
• Profiling and analyzing data from different sources, addressing the data quality issues, Transforming and processing of data and loading the data into Teradata.
• Implemented Survive stage Match Stage for data patterns data definitions
• Captured data from a variety of sources including DB2, Flat Files, Mainframes and other formats.
• Extensively worked with Data Stage Shared Containers for Re-using the Business functionality.
• Used extensively Reject Link, Job Parameters, and Stage Variables in developing jobs.
• Drafting technical documents like Overview documents, migration and deployment documents for every code release.
• Involved in Migration of Data stage code from DS 7.5x2 to DS 8.5.
• Automation is done by using batch logic, scheduling jobs on a daily, on a weekly and yearly basis depending on the requirement using Autosys.
• Created database tables and used PL/SQL procedure for validation report, Balancing report, Audit report
• Involved in various reviews and meetings including Internal and external code review, weekly status calls, issue resolution meetings and code acceptance meetings.
• Assisted SIT testing team, UAT team and Production team during code release with code walk through and presentations and Defect identification, reporting and tracking.

Environment: InfoSphere DataStage 8.5, Oracle 11g, Fixed width files, COBOL files, Sequential files , DB2, XML files

Confidential

ETL Developer / DataStage Consultant

EmblemHealth is a health maintenance organization HMO and health insurance company based in New York City. It is a 10 billion company with 3.4 million members. The merger of Group Health Incorporated GHI and Health Insurance Plan of New York HIP resulted into Emblem Health. I was primarily involved with EHDIMDW Emblem Health Dimension Data warehouse project which integrates both HIP and GHI data into a single Data warehouse. Also worked on HIX Health Information Exchange project which involves exchange of health information with the NY State of Health.

Responsibilities

• Developed jobs using Information Server DataStage 8.1 and8.5 for loading the data into staging and warehouse.
• Extended data analysis of source systems for the purpose of data migration, transformation, integration and cleansing.
• Analyzed business requirements, user and system requirements.
• Created DataStage Naming convention and Standards document for the project.
• Prepared JIL files for scheduling DataStage jobs in Autosys scheduler.
• Performed performance tuning of DataStage jobs to improve the extraction, transformation and loading time of data.
• Used DataStage Director and its run-time engine to validate, run and monitor the resulting executable versions.
• Performance tuned the jobs to cut the Extract, Transform and Load time significantly.
• Developed unit test cases, unit-tested the jobs before migrating the code to QA and Production boxes. Review of test cases job design.

• Worked with Cobol files and flat files as Sources. Implemented Data Warehouse including architecture, development, testing and performance tuning.

Environment: InfoSphere DataStage 8.1 and 8.5, Oracle 11g, Fixed width files, COBOL files, HP Quality Center and Application Lifecycle management.

Confidential

Datastage Developer / DataStage Consultant

Moody's Investors Service is a Credit rating agency which performs international financial research and analysis on commercial and government entities. The company also ranks the credit-worthiness of borrowers using a standardized ratings scale. The company has a 40 share in the world credit rating market. My responsibilities at Moody's involve converting and migrating data from multiple legacy sources viz. Oracle, SQL Server, XML files, CSV files, Excel Sheets and flat files into DB2 using DataStage. This involves understanding the business process, mapping specifications, business requirement documents and use cases. They also include rigorous integration and performance testing of the jobs and the system during and post development.

Responsibilities

• Worked with Business Analysts to understand the business process and requirements and transform them to technical specifications.
• Developed jobs using Information Server DataStage 8.1 for Converting data from legacy systems into DB2 target database.
• Converted Customer data from multiple sources into the target DB2 database.
• Converted Billing data into the target DB2 database.
• Implemented best practices and standards in the Project.
• Performed Unit testing and performance testing of the jobs and tuned the jobs to cut the load time.
• Involved in knowledge transfer and transitioning of the requirements and the overall conversion process.

Environment: InfoSphere DataStage 8.1, DB2, Oracle 11, SQL Server 2005, XML files, CSV files, fixed width files, Rapid SQL, Red Hat Linux.

Confidential

Module Lead/ Senior Software Engineer

DWP PSCS Department of Work and Pension of United Kingdom-ISCS is an application developed and maintained by the Information Technology Services Agency ITSA of the Department of Social Security. Its purpose is to assist the Benefits Agency BA in providing pension benefits to their citizens who has crossed 65 years. The ISCS runs on IBM mainframes at four Area Computer Centers ACCs . On-line services to BA local offices are provided by day and Batch services run during the night. The end user screens are done in PHP,HTML to make the screen more user friendly for the older citizens. Even then database used is DB2 temporarily the records are stored in MySQL and each day a batch is run to move the records to DB2 .

Responsibilities

• Developed unit test cases, unit-tested the jobs before migrating the code to QA and Production boxes.
• Responsible for managing scope, planning, tracking, change control, aspects of the project
• Analysed of Business requirements and Specifications
• Coded online and batch programs using COBOL, VME COBOL, CICS, DB2, VSAM, JCL PWB, ALTADATA ITS
• Prepared of test cases, Unit testing and regression testing
• Responsible for effective communication between the project team and the customer
• Translated customer requirements into formal requirements and design documents
• Established Quality Procedure for the team, monitor and audit to ensure team meets quality goals
• Performed the role of a team lead managing the work allocation, mentoring, ensure co-ordination amongst the team members, gain confidence of the onsite SMEs/leads/business
• Participated actively in team/customer meetings and ensure co-ordination between onsite/offshore team. Made sure the commitments made to the client , quality of deliverables are met

• Mentored the team in technical/business areas and help them resolve issues related to it
• Reviewed work status and assist the team in all phases of the software engineering cycle as and when required

Environment: IBM - Mainframes - COBOL, VME COBOL, CICS, DB2, VSAM, JCL, PWB, ALTADATA, ITS.

Confidential

Software Engineer

JSAPS - Department of Work and Pension of United Kingdom-JSAPS is an application developed and maintained by the Information Technology Services Agency ITSA of the Department of Social Security. Its purpose is to assist the Benefits Agency BA in providing financial support to its job seekers and some bereavement allowance to widows and dependants. The knowledge transition has been taken onshore for 2 months in UK.

Responsibilities

• Delivered new and complex high quality solutions to clients in response to varying business requirements
• Translated customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Prepared of High Level Design document, Low Level Design Document and Program Specification etc.
• Prepared of Job flow diagrams and Entity relationship diagrams
• Prepared of Estimate for the requirements sent by onsite
• Involved in Coding new modules , Bug fixing and Test plan preparation
• Involved in Testing the developed modules, Review of deliverables
• Established Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment

IBM - Mainframes Online and batch processing, COBOL, VME COBOL, CICS, DB2, VSAM, JCL, PWB, ALTADATA, ITS., MQ-series

Confidential

TMS - Ticket management system - is used to track the status of tickets raised in any application. It's compatible to any application as it's designed so. It stores all the tickets raised by costumers and help to track the status, technician allocated and the priority details too.

Key Responsibilities

• Analysed of the existing modules to be developed or enhanced
• Performed new modules coding
• Changed code of existing programs
• Prepared of Unit test reports for the Unit testing to be done
• Involved in Unit testing and Logging the Unit test reports for various conditions
• Supported System integration testing and User acceptance testing
• Prepared Quality related documents through out the SDLC process.

Environment: PHP, MySql, HTML, Javascript.

Confidential

Teaching Faculty

Worked as a Teaching Faculty in Zing Info Solutions.

Key Responsibilities:

• Software - Teaching faculty
• Taught Software Engineering and Computer courses
• Assisted Students to perform academic projects using IBM Mainframe technologies

Environment: COBOL, CICS, JCL, DB2, VSAM

Confidential

IBM Mainframe Trainee

Undergone Training on IBM Mainframe Technologies COBOL, CICS, JCL, DB2, VSAM

Environment: COBOL, CICS, JCL, DB2, VSAM.