SUMMARY

• Over 7 Years of career reflecting experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems that included ETL Tools like Confidential Infosphere DataStage 8.7/8.5/8.1/7.5 and Informatica Power Centre 9.1/8.6
• Good knowledge of Data Warehousing development life cycle - Engagement, Analysis, Design, Development, Testing, User documentation and Deployment.
• Extensive experience in multi-dimensional business analytics, data architecture, data migration with multiple environments (OS/databases) & large data warehouse environments.
• Strong knowledge of data warehouse architecture and designing star schema, snowflake schema FACT and Dimensional Tables.
• Experience in Physical and Logical Data modeling using Erwin data modeler.
• Extensive experience in dealing with high volume data, performance tuning and enchainment in the production environment.
• Good experience in developing strategies for Extraction, Transformation, Loading data from/to various sources into data warehouse and data marts using tools ETL tools like Datastage and Informatica power center.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension, surrogate key assignment and change data capture.
• Experience in usage of Information Analyzer, Metadata workbench and Business Glossary using REST API.
• Experience in usage of QualityStage for standardization and cleansing the data.
• Experience in designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema, physical and logical Data modeling using Erwin in implementing Decision Support Systems.
• Efficient in various phases of the software development lifecycle.
• Efficient in coordination of overall development of solutions and 24/7 support.
• Exceptional verbal and written communication skills, excellent team player.

PROFESSIONAL EXPERIENCE

Confidential, Littleton, MA

Sr.Datastage Developer

Responsibilities:

• Defined the Primary keys and foreign keys for the Entities.
• Defined the query view, index options and relationships.
• Drop index, Create Index to improve performance of DataStage Jobs.
• Extracted data from source systems transformed and loaded into Confidential DB2 database according to the required provision.
• Involved in system analysis, design, development, support and documentation.
• Used Confidential Datastage Designer to develop jobs for extracting, cleaning, transforming and loading data into data marts/data warehouse.
• Developed several jobs to improve performance by reducing runtime using different partitioning techniques.
• Used different stages of Datastage Designer like Lookup, Join, Merge, Funnel, Filter, Copy, Aggregator, and Sort, Transformer etc.
• Involved in writing Test Plans, Test Scenarios, Test Cases and performed the Unit, Integration, system testing and User Acceptance Testing.
• Used stage variables for source validations, to capture rejects and used Job Parameters for Automation of jobs.
• Worked on the logical and physical design of the Data warehouse. Identified sources/targets and analyzed source data for dimensional modeling.
• DataStage jobs were scheduled, monitored, performance of individual stages was analyzed and multiple instances of a job were run using DataStage Director.
• Provided 24/7 production support. worked with multiple off shore team in a daily bases to provide support as needed.

Confidential, Tampa - FL

Sr.Datastage Developer

Responsibilities:

• Actively participated in the system design, coordinate with business groups in order to define the requirements.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Developed parallel jobs between multiple source systems.
• Developed complex jobs using various stages like Transformer, Lookup, Join, Merge, Aggregator, Modify, Filter, Switch, Funnel, Slowly Changing Dimensions, Pivot, 5. DB2/UDB Connector, Dataset, Sequential File, Row Generator, Column Generator, Peek, Head and Tail Stages.
• Setup UNIX groups and defined UNIX user profiles and assigned privileges.
• Monitored data stage jobs with DataStage Director.
• Set up development, QA & Production environments.
• Extensively worked in improving performance of the jobs by avoiding as many transforms as we can.
• Worked on DataStage Version control to do Change Control.
• Exhaustively involved in unit and integration testing.
• Defined production support methodologies and strategies.
• Designed Technical specifications and Mapping documents with Transformation rules.
• Participated in the review of Technical, Business Transformation Requirements Document.
• Developed job sequencers and implemented restartability using various checkpoints.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement.

Confidential, Wilmington - DE

Sr.Datastage Developer

Responsibilities:

• Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into Confidential Database. Used QualityStage components like Data Rules, Standardized Stages and MNS (Multinational Standardization). Also involved in converting server jobs into parallel jobs.
• Used various Parallel Extender partitioning and collecting methods.
• Developed complex jobs using various stages like Transformer, Lookup, Join, Merge, Aggregator, Modify, Filter, Switch, Funnel, Slowly Changing Dimensions, Surrogate Key Generator, Pivot, Oracle Connector, DB2/UDB Connector, Dataset, Sequential File, Row Generator, Column Generator, Peek, Head and Tail Stages.
• Setup UNIX groups and defined UNIX user profiles and assigned privileges.
• Monitored data stage jobs with DataStage Director.
• Set up development, QA & Production environments.
• Migrated jobs from development to QA to Production environments.
• Defined production support methodologies and strategies.
• Defined backup recovery process for datastage projects.
• Defined & implemented datastage jobs process monitoring.
• Defined shell scripts for file watcher and file archiving process.
• Designing Functional specifications as per the Business Logic
• Design Technical specifications and Mapping documents with Transformation rules.
• Participated in the review of Technical, Business Transformation Requirements Document.
• Coordinate with other internal groups including Quality Assurance, Product Operations, and Production Support.

Confidential, Oakland, CA

Senior DataStage Developer

Responsibilities:

• Participated in gathering of business requirements and carry out a suitable data Model for DataMart and Data Warehouse.
• Used Parallel Extender for splitting and organizing the data into subsets and to achieve better job performance.
• Expensively involved in Extraction, Transformation and Loading (ETL) stages.
• Responsible for analyzing and understanding Metadata and data.
• Responsible for setting-up Confidential DataStage DEV, TEST and UAT Environments.
• Designed and developed DataStage Data flow integrating multiple sources.
• Drop index, Create Index to improve performance of DataStage Jobs.
• Participated in discussions with Project Manager, Team leader, Group Members and Technical Manager Regarding any Technical and/or Business Requirement issues.
• Writing documentation for detail transactions data for operational data store.
• Transformations including aggregation and summation construct from operational data source to Data warehouse.
• Created Database Views to use the code whenever it required.
• Extensively worked with SQL Server Joins, Inner Join, Outer Join, Full Outer Join and Left Outer Join.
• Developed job sequencers and implemented restart ability using various checkpoints.
• Extensively worked on DataStage Director, Designer and DataStage Administrator.
• Used DataStage Designer for developing various jobs to extract data from different sources and loading data into temp tables for validation testing and Production run.
• Developed PX jobs in using different stages likeChange Capture, SCD, Aggregator, Join, Merge, Lookup, Source Dataset, External Filter, Row generator, Column generator and Peak stages.
• Used DataStage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Involved in Unit Testing, SIT and UAT Worked with the users in data validations.
• Extensively worked in improving performance of the jobs by avoiding as many transforms as we can.
• Involved in the development of Common Error Management to capture and handle the error records.
• Preparing documentation for unit, regression, integration, and final end - to - end testing.
• Involved in the unit testing, regression testing, and integration testing for transition data.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Developed jobs between operational sources to Operational Confidential tables.
• Data Warehouse is implemented using sequential files and db2, Oracle Tables.
• Developed DS Routines for checking transaction code types.
• Writing documentation for detail transactions data for operational data store.
• Transformations including aggregation and summation construct from operational data source to Data warehouse.
• Developed job sequencers and implemented restart ability using various checkpoints.
• Extensively worked on DataStage Director, DataStage Manager and DataStage Administrator.
• Used DataStage Designer for developing various jobs to extract data from different sources and loading data into temp tables for validation testing and Production run.
• Used DataStage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Used DataStage Manager for managing DataStage repository (view and edit), define custom routines & transforms.
• Involved in Unit Testing, SIT and UAT. Worked with the users in data validations.
• Extensively worked in improving performance of the jobs by avoiding as many transforms as we can.
• Extensively worked on DataStage Version control to do Change Control.
• Worked on datasets to source data.
• Involved in Designing and developing universes for generating reports from warehouse databases.
• Developed UNIX shell scripts to automate the Data Load processes through AutoSys.
• Collecting the statistics for each load and implementing the exception handling as part of the load process.

Confidential, Minneapolis, MN

ETL Developer

Responsibilities:

• Actively participated in the system design, coordinate with business groups in order to define the requirements.
• Documented user requirements, translated requirements into system solutionsand develop implementation planand schedule.
• Developed parallel jobs between multiple source systems.
• Used Parallel Extender to create jobs using stages like Aggregator, Transformer, sort, merge, join, lookup, remove duplicate and filter stages.
• Developed job sequencers and implemented restart ability using various checkpoints.
• Extensively used Nested condition, Notification activity, sequencer and routine activities in sequence job.
• Design of MQ Series Objects and support for Administration in Development.
• Developed automation and monitoring Scripts in conjunction with BMC Patrol for MQ Failover, Disaster recovery, backup and error handling.
• Worked on Quality Stage for standardizing the Data
• Took project backups and implemented version control through CVS.
• Performed import and export DataStage jobs and various components through DataStage manager.
• Identifying suitable dimensions and facts for schema.
• Complex designing and mapping.
• Involved in system testing and unit testing.
• Used DataStage director to schedule and run jobs on daily, weekly, monthly.
• Responsible for supporting and managing database activity during the development process.
• Extensively worked on data validation and cleansing tools like QualityStage, Audit Stage, and Profile Stage.
• Worked on standardization of files to audit the input data and make sure that the data is valid.

Confidential, Columbus, OH

Datastage Developer

Responsibilities:

• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement.
• This required a detailed understanding of the data sources and researching possible solutions.
• Used DataStage as an ETL tool to extract data from sources systems, aggregate the data and load into the Teradata database and worked with ODS.
• Implemented multi and fast load methods for loading of data.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Implemented table partitions for parallel load processing.
• Involved in defining technical and functional specifications for ETL process.
• Used both Pipeline and Partition Parallelism for improving performance.
• Extensive use of Control M for job scheduling
• Used lookup stage with reference to Oracle tables for insert/update strategy and updating of slowly changing dimensions (SCD’s)
• Involved in performance tuning of the ETL process and performed the data warehouse testing.
• Modified the DS jobs to improve performance.
• Excessive usage of DS Director for monitoring Job logs to resolve issues.