PROFESSIONAL SUMMARY:

• Over around 5+ years of f IT experience in Analysis, Design, Development and Implementation and Testing of software applications in data warehousing and Client/Server environment.
• Strong experience on IBM InfoSphere Data Stage 8.5/9.1 and 11.5v(Data Stage Administrator, Data Stage Designer, Data Stage Director)
• Hands on experience on scheduling tool Control - M 7 and 8.0 versions.
• Experience in integration and loading into various databases Oracle 10g, DB2.
• Experience in working in Dimensional Data modeling, Star Schema modeling, Snowflake modeling, Fact tables, Dimension tables, OLAP, Query Intensive database designs, Performance tuning.
• Experience in Creating, Compiling and Run jobs using Data Stage Designer, View job status, job log, and scheduling jobs using Data Stage Director.
• Expert in Creation of Sequence Jobs using Job Activity, Wait for File Activity, Exception Handler, Sequencer, Terminator Activity, etc.
• Experience in Using Dynamic job parameters for file names and passwords to validate at run time.
• Responsible for documenting user requirements and translated requirements into system solutions.
• Expertise in Data Warehousing/ETL programming and fulfillment of data warehouse project tasks such as data extraction, validations, transforming and loading.
• Excellent experience in different stages of the projects such as requirement analysis, Performance tuning at job/project level, data conversion.
• Involved in Documentation of ETL process following the standard naming conventions used in Data Stage.
• Strong background collaborating with customers, end-users utilizing excellent communication skills.
• Ability to multi-task various projects and prioritize work tasks.
• Good Knowledge in UNIX Commands.
• Exceptional communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilizing the same in a productive manner.
• Self-motivated, Confident, Leadership skills, Fast learner and quick adopter to new environment

PROFESSIONAL EXPERIENCE

Confidential, Tx

Responsibilities:

• Analysis and design of ETL processes.
• Generating xml files
• Understood the technical specifications and developed Datastage Parallel jobs for Extraction Transformation and Loading process.
• Worked extensively on different types of stages like Hierarchal, Aggregator, Transformer, Merge, Join, Lookup, Sort and Containers for developing job.
• Developed jobs in PX for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance.
• Analyzed the jobs and project to enhance its performance using the standard Techniques

Confidential

Responsibilities:

• Involved in detail analysis of the tables present in staging and external databases and the logic behind external table columns populated from staging tables.
• Analysis of the stored procedures and Unix scripts based on the business keys.
• Preparation and documentation of the work flows which were key inputs for the Datastage team to understand the staging logics and stored procedures in detail.
• Worked extensively on different types of stages like Sequential file, Aggregator, Transformer, Merge, Join, Lookup, Sort and Containers for developing job
• Sequential file stage and Oracle connector stage were widely used to extract inputs from flat files, sequential files in Datastage Designer
• Responsible for unit testing which is a 3 run Manual testing of Datastage jobs.
• Comparison of logs in source (logs stored after executing stored procedures in system generated folders) with target(Logs generated after execution of Datastage jobs in Director client).
• Test whether the data in the reports generated by Epiphany UI is matching with data in Epi channel Mart tables and the merchant data generated in the campaigns is perfect when compared with the Mart table data.
• Preparation of testcase documents and to execute them.
• Recording the output data for each input as a sample of 10 records for each testcase.
• Actively involved in SIT and UAT.

Confidential

Responsibilities:

• Understand and analyse the business requirement documents, discuss with the business analysts regarding the requirements and develop the data stage jobs as per requirement.
• Estimate the efforts required for the ETL development.
• Develop the ds jobs and sequencer jobs as per requirements by follow the specified guide lines and standards.
• Extract data from variety of sources such as oracle tables, flat files and transform the data as per requirements and then load into DWH tables.
• Prepare unit test cases for doing unit testing and data validation.
• Review of test cases and results. o Performance testing for datastage jobs and sequencer jobs.
• Assist to UAT testing team during UAT testing, fix the defects if any found and then reporting & tracking.
• Involve in deployment of datastage code to other environments.
• Involve in various reviews and meetings including internal and External code reviews, Daily status calls, Issue resolution meetings.
• Drafting technical documents like ETL overview documents for every code release.

Confidential

Responsibilities:

• Review of design documents and raising clarifications in tracker
• Developing data stage jobs as per the requirement by using various stages like transformer, join, change capture, look up, aggregator, sequential file, data set etc.
• Scheduling the jobs as per required schedule through control-m scheduling tool.
• Performed unit testing .
• Performed peer code review
• Prepared documents like: