SUMMARY

• Around Seven years of IT experience in the System Analysis, Design, Development, Implementation and Testing of Database,Datawarehousing using Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Experience in ETL & Business Intelligence using Ascential Datastage 7.5/8.1(DataStage Manager, DataStage Designer, DataStage Director, Parallel Extender), creating Fact Tables, Dimension Tables using Star Schema Modeling.
• Used Datastage Manager to import/export datastage projects and jobs and to define table definition in the repository.
• Extensively made use of stages like Sequential files, Hash files, Link Collector, and Link Partitioner, ODBC, DB2, Transformer, Aggregator, Sort, Join, Merge, Change Capture in Datastage Designer.
• Used Datastage Director to debug, validate, schedule, run and monitor Datastage jobs.
• Excellent experience in Relational database (RDBMS), Oracle, SQL Server, Teradata, and MS Access.
• Played an integral part in the building of a multi - server, multi-database enterprise Data warehouse using DataStage ETL (extact, transform and load) tools and SQL Server to load legacy business data.
• Integral in the design and implementation of data warehouse through Datastage ETL (extact, transform and load) configurations utilizing multiple Oracle and SQL Server databases.
• Experienced in Quality Assurance for Data Warehousing projects creating Test Plans, Test Objectives, Test Strategies, and Test Cases. Ensuring the Data in data warehouse meets the business requirements.
• Strong understanding of Data Warehousing concepts Experience.
• Proficient in all stages of SDLC (Software Development Life Cycle).
• Capable of working under high stress environment with resource constraints.
• Excellent analytical, communication, and facilitation skills with the ability to gain consensus across multiple teams.

TECHNICAL SKILLS

ETL Tools: IBM WebSphere DataStage8.1(Designer, Manager, Director and Administrator), Ascential DataStage 7.5.

Languages: C, C ++,PL-SQL, Unix.

Operating Systems: UNIX, Windows 98/NT/2000 and MS-DOS.

RDBMS: SQLServer2005/2008, DB2, Teradata.

Reporting Tools: Cognos.

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

Datastage Developer

Responsibilities:

• Responsible for the development of Datastage Parallel Jobs.
• Responsible for the design of ETL Jobs.
• Interact with business staff, leads and all levels of management.
• Followed waterfall model for SDLC.
• Execute SQL queries in DB2.
• Work with Microsoft Access to execute the queries.
• Used different performance tuning methods in Datastage jobs for better performance.
• Prepared the functional design document and ETL process flow document.
• Performed the Unit testing for datastage jobs.
• Developed complex mappings in Datastage to load the data from various sources using different stages like Join, Merge, Lookup, Change Capture, Remove Duplicates, Funnel, Filter, Copy, Peek, Aggregator, Modify, and Transformer Stages.
• Prepared the technical design document for each job and developed the ETL mappings.
• Interact with mappers and testers regarding the mapping document and the code.
• Helped testers in executing the test cases.
• Develop, prepare and use test data/cases to verify accuracy and completeness of ETL.
• Prepared the Unit testing document with test plan.
• Importing and Exporting repositories across the projects, Datastage Components and table definitions using Datastage Designer.
• Optimized the SQL queries for better performance.
• Handled various functional and technical issues in the system.

Environment: Datastage 7.5, DB2, Unix.

Confidential, Milwaukee, WI

Datastage Developer

Responsibilities:

• Responsible for the development of Datastage Jobs.
• Responsible for the design of ETL Jobs.
• Interact with SMEs to gather and develop business requirements and worked with team to develop and implement creative solutions to solve business problems.
• Interacted with business staff, leads and all levels of management.
• Followed Agile methodology for SDLC.
• Used hash file stages in Datastage jobs for better performance.
• Prepared the functional design document and ETL process flow document.
• Performed the Unit testing for datastage jobs.
• Developed complex mappings in Datastage to load the data from various sources using different transformations like Join, Merge, Lookup, Change Capture, Remove Duplicates, Funnel, Filter, Copy, Peek, Aggregator, Modify, and Transformer Stages.
• Prepared the technical design document for each job and developed the ETL mappings.
• Designed, tested and did performance tuning for both Datastage jobs and SQL queries.
• Develop, prepare and use test data/cases to verify accuracy and completeness of ETL. programs/objects as well as proactively ensuring that unintended issues do not arise as a result of the implementation of developed solutions.
• Prepared the Unit testing document with test plan.
• Importing and Exporting repositories across the projects, Datastage Componets and table definitions using Datastage Designer.
• Optimized the SQL queries for better performance.
• Handled various functional and technical issues in the system.

Environment: Datastage 8.1, Teradata, SQL Server, Unix.

Confidential

Datastage Developer/ Tester

Responsibilities:

• Responsible for the development of Datastage jobs.
• Development experience with SQL server 2005/2008, DB2.
• Experience with Datastage server and parallel jobs.
• Responsible for understanding Business Process.
• Direct and design the ETL process involving data quality and testing.
• Responsible for documenting user requirements and translated requirements into system solutions.
• Written complex queries to facilitate the supply of data to other teams.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Developed Unit test cases and test plans.
• Created and executed test cases for DME claims data foundation project.
• Conducted peer review of test cases and provided feedback on areas of improvement.
• Used SQL queries to retrieve data from Enterprise Data Warehouse (EDW)/Teradata and validated them.
• Executed Informatica jobs for testing project functionalities.
• Communicated the testing status and issue logs with Development team and Mappers.

Environment: Datastage 7.5, SQL 2005/2008, DB2.