• Experienced Computer Systems Analyst with diverse industry experience in Data warehousing applications. Professional expertise includes systems applications, planning and information protection analysis. Big picture thinker with the ability to wear many hats.
• Motivated team leader with 10 year's software design and development experience.

EXPERIENCE / SUMMARY

• 10 Years' experience in Data warehousing ETL environment Extraction, Transformation, and Loading utilizing IBM Data Stage 7.5, 8.x , IBM Mainframe programming

• IBM Certified Solution Developer - InfosphereDataStage v8.0 Certification

• Extensive experience in Migration, Integration, Development and Implementation of ETL Systems using strong project management methodologies by combining technical and leadership skills effectively with focus on process efficiency and productivity.

• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.

• Experienced in managing and leading teams.

• Experienced with relational and dimensional data modeling, star schema, reverse engineering.

• Worked extensively on different types of transformations stages Change capture, Modify, Peek, Tail, Head, Sequence generator, Aggregator, Column Export, Look up, joiner stages.

ACCOMPLISHMENTS

• IBM Certified Solution Developer - InfoSphereDataStage v8.0.

• Extensive experience in Migration, Integration, Development and Implementation of ETL Systems using strong project management methodologies by combining technical and leadership skills effectively with focus on process efficiency and productivity.

• Experienced with relational and dimensional data modelling, star schema, reverse engineering.

• Worked extensively on different types of transformations stages Change capture, Modify, Peek, Tail, Head, Sequence generator, Aggregator, Column Export, Look up, joiner and FTP Stage.

SKILLS PROFILE

KEY AREAS AND STRENGTH

• Worked individually as well as in Team Environments
• Experience in software development and unit testing.
• Experience in Data warehouse concepts and ETL tools.
• Experience in Black box, Regression and Integration testing and production implementations.
• Functionality and Performance Test Plan preparation.
• Performance Test Result Analysis and Suggestions.
• Good interpersonal and communication skills
• Good Leadership qualities
• Good Test Management skills

ASSIGNMENTS

• Worked in collaboration with Data Warehouse architects to design and develop Data Warehouse solutions. Work with Business Analysts and Functional Team members to translate Business requirements into technical specifications.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Assisted in the design of an efficient, reliable ETL mechanism for updating the Data Warehouse and downstream systems
• Developed mappings with performance, accuracy and efficiency in mind.
• Developed data Mappings between source systems and target components using Mapping Design Document.
• Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts.
• Developed Several Parallel jobs to improve performance by reducing the runtime for several jobs.
• Extensively worked with DS Director and DS Designer.
• Documented the development of programs, Logic, Coding, and Testing.
• Guide off shore development team.
• Involved in code walk thru with the fellow developer to follow the guidelines for best practices.
• Unique ability to understand and long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.
• Database DB2.

• ETL Software

• IBM Info sphere Data stage Parallel Extender v7.5 8.5,

• Worked in collaboration with Data Warehouse architects to design and develop Data Warehouse solutions. Work with Business Analysts and Functional Team members to translate Business requirements into technical specifications.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Assisted in the design of an efficient, reliable ETL mechanism for updating the Data Warehouse, Data Marts and downstream systems
• Developed mappings with performance, accuracy and efficiency in mind.
• Developed data Mappings between source systems and target components using Mapping Design Document.
• Developed robust mappings with built in reconciliation and error handling.
• Worked extensively on different types of transformations Change capture, Modify, Stored procedure, Peek, Tail, Head, Sequence generator, Aggregator, Column Import, Column Export, Inter Processor, Quality Stage, and FTP Stage.
• Used Link Partitioner to Portion Data in order to enhance performance of DataStage jobs and Link Collector to collect portioned data together.
• Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts.
• Developed Several Parallel jobs to improve performance by reducing the runtime for several jobs.
• Extensively worked with DS Director and DS Designer.
• Documented the development of programs, Logic, Coding, and Testing.
• Interacted with off shore development team.
• Involved in code walk thru with the fellow developer to follow the guidelines for best practices.
• Unique ability to understand and long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.
• Database
• DB2.
• ETL Software
• IBM Info sphere Data stage Parallel Extender, 8.0, 8.1

• Interacted with the business users to understand functional requirements, document their expectations and translated to design models and solutions to transform the batch jobs, Database and Scheduler.
• Worked on conversion of impacted programs from Mainframe based system to Clerity environment
• Prepared the estimates and detailed plan for migration
• Analysed the existing configuration of ETL and Mainframe jobs and approach for moving the systems to the new environment
• Collected impacted ETL and any Mainframe interactions and prepared component list
• Created test plans for Unit, System, Integration and End to End testing. Reviewed test plans and implementation plans.
• Done Unit, System, Integration and End to End testing for the impacted components in the new environment, Database and Scheduler.
• Identified defects and raised defects/issues in Quality Center for effective defect management and resolved defects with the help of infrastructure teams.
• Done extensive multiple iterations of Mock testing and Performance testing for each component.
• Created deployment plan for various applications and worked with the application support to ensure smooth migration with minimum business impact
• Implementation coordination of the jobs in the new server, Database and Scheduler environment. Validated of the configuration changes and identified post implementation issues.
• Provided warranty support after the migration to ensure changes are working fine
• Applications
• HAL Health, Annuities and Life mainframe system
• Database
• SQL, DB2
• Language
• InfosphereDatastage 8.5,Datastage 7.5, UNIX, Winscp, Putty, CAWA, IBM Data Studio, Service Manager, Mainframe ESP batch scheduler

• Design, develop and test datastage jobs by utilizing core stages like transformer, joins, merge, lookup, oracle, ODBC, surrogate key stage, filters, modify aggregation, peek, complex flat file, funnel etc. Managed version controls using job compare and impact analysis.
• Performed key transformations using loop processing,dynamic transformer,link variables,system variables,sort stages etc.Fine-tuned jobs to minimize sorts and repartitions.
• Used different parallel extender partitioning techniques like key based partitioning techniques hash and modulus and non-key based partitioning techniques round robin and entire techniques for performance enhancements.
• Worked on efforts estimation, resource estimation, size and volume estimation and infrastructure and database size estimation for the project. Conducted quality assurance activities such as datastage code reviews.
• Worked on performance improvements of Datastage jobs by tuning the SQL queries and job design.
• Prepared test plans and done Unit testing, System testing, Integration testing and End to End testing for minor enhancements
• Prepared Weekly and Monthly status reports to keep track of the code changes, batch issues and major accomplishments
• Mentored and guided the team members for effective management
• Applications
• IMAGE AS400 Claims handling system
• ICE Integrated Claims Environment J2EE Application as front end to IMAGE to handle Bank of America credit consumer claims.