SUMMARY

Information & Data Management professional with more than 6 years of experience within the business data analysis, data migration & system integration capability. My analysis experience has spanned across projects with clientele in Healthcare and Banking clients, and Investment Management

SKILLS:

IBM InfoSphere DataStage 8.7(Designer, Director),Oracle 11g/9iUNIXPUTTYMS AccessMS WordMS Power Point

EXPERIENCE:

DataStage Developer

Confidential, New York, NY

Responsibilities:

• Use of SQL to profile data and provide data sheets based on the workrequests.
• Executed DataStage jobs and made sure proper files were beinggenerated in Cognos, also made sure to verify database was loadedcorrectly with the new data.
• Used DataStage Designer to create the table definitions for the CSV andSequential files, import the table definitions into the repository, import andexport the projects, release and package the jobs.
• Created ETL processes to extract data from landing Oracle Database,transformed data based on business requirement and load it to the properdatabase table.
• Executed Sequence Jobs which had restart ability, check points andimplemented proper failure.
• Designed and developed parallel jobs using DataStage Designer as perthe mapping specifications using appropriate stages.
• Used DataStage Director and its run - time engine to schedule running thesolution, testing and debugging its components, and monitoring theresulting executable versions.
• Worked on troubleshooting, performance tuning, performance monitoringand enhancement of DataStage jobs.
• Performed unit testing and system integration testing in development andUAT environments.
• Used Cognos tool to verify if the files were generated accurately.

Datastage Developer

Confidential, Malvern, PA

Responsibilities:

• Recognized business needs, evaluated business and technicalalternatives, suggested solutions and took part in their implementation.
• Imported metadata from repository, created new job categories
• Used DataStage Designer to create the table definitions for the CSV andSequential files, import the table definitions into the repository, import andexport the projects, release and package the jobs.
• Created ETL processes to extract the source data from DB2 Enterprisedatabase
• Developed job sequences to execute a set of jobs with restart ability,check points and implemented proper failure actions.
• Used DataStage Director and its run-time engine to schedule running thesolution, testing and debugging its components, and monitoring theresulting executable versions.
• Worked on troubleshooting, performance tuning, performance monitoringand enhancement of DataStage jobs.
• Wrote several complex SQL queries to test the ETL process.
• Worked with Control M for setting up production job cycles for daily,weekly, monthly loads with proper dependencies.
• Designed and developed parallel jobs using DataStage Designer as perthe mapping specifications using appropriate stages.

Data Integration Developer

Confidential, Lake Forest, CA

Responsibilities:

• Recognized business needs, evaluated business and technicalalternatives, suggested solutions and took part in their implementation.
• Perform data cleansing activities based on writing SQL patches,investigating ETL jobs to address data gaps.
• Imported metadata from repository, created new job categories, routinesand data elements using Datastage Manager.
• Used DataStage Designer to create the table definitions for the CSV andSequential files, import the table definitions into the repository, import andexport the projects, release and package the jobs.
• Created ETL processes to extract the source data from the healthcarecompany database and load it into the enterprise-wide data warehouseafter cleansing, transforming and integrating.
• Used Quality Stage to coordinate the delivery, consistency, removing dataanomalies and spelling errors of the source information.
• Designed and developed parallel jobs using DataStage Designer as perthe mapping specifications using appropriate stages.
• Developed job sequences to execute a set of jobs with restart ability,check points and implemented proper failure actions.
• Used DataStage Director and its run-time engine to schedule running thesolution, testing and debugging its components, and monitoring theresulting executable versions.
• Worked on troubleshooting, performance tuning, performance monitoringand enhancement of DataStage jobs.
• Worked with Autosys for setting up production job cycles for daily, weekly,monthly loads with proper dependencies.
• Performed unit testing and system integration testing in development andUAT environments.
• Wrote several complex SQL queries to test the ETL process

ETL Developer

Confidential, Mettawa, IL

Responsibilities:

• Worked as ETL DataStage consultant for a project from design untilproduction and support.
• Reviewed and validated the existing job code and designed anddeveloped new jobs for the future releases.
• Worked with offshore developers to co-ordinate the ETL work andrequirements and reviewed the code developed at offshore.
• Worked on a parallel project for DataStage upgrade from version 7.5 toversion 8.1.
• Developed UNIX scripts to run the Datastage job and other file validations.
• Performance tuning of DataStage jobs and the SQL used inside the job.