SUMMARY:

• Over 7 years of IT experience entirely in data warehousing projects with IBM Datastage as ETL tool, Oracle, DB2 & Teradata as databases and UNIX as Server platform.
• Experience on designing, developing, debugging Datastage Server as well as parallel jobs on versions 7.5, 8.1, 8.5 & 8.7
• Experience on reading and writing to several file formats like .xml, .xlsx, .csv, .txt & .dat both delimited and fixed width from datastage
• Extensive experience working on C++ functions used for creating Parallel Routines in datastage.
• Experience working on Sequential Files, Datasets, Join, Lookup, Merge, Aggregator, Modify, Transformers, Surrogate key generator, Funnel, Change Capture, Copy, Sort, Remove Duplicates, Peek, Row Generator, Vertical Pivot, XML Input, XML Transformer, FTP stages in Datastage
• Experience on Datastage Administrative tasks like Creating users, Groups assigning roles, Server restart, Job Unlocking.
• Experience on several Performance tuning techniques on Data stage Jobs as well as on Database Tables.
• Excellent performer in all cycles of Software development Life Cycle from Requirement gathering, Design, Build, Test, Review, Analysis and Deployment
• Expertise on UNIX shell scripting for file FTP’s, File modifications, Datastage job scheduling.
• Experienced in troubleshooting Datastage Jobs and fixing production issues
• Lead the team of novice engineers to successfully implement 2 of major Datastage migration projects from DS v7.5 Server to DS v8.1 Parallel jobs, project constituted of 7k hours.
• Deep understanding of DW/BI concepts and life cycle.
• Experienced working on several scheduling tools like Control - M, Autosys

TECHNICAL SKILLS:

Data: Warehousing Datastage v 7.5, 8.1, 8.5, 9.1

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Bridge Tables, SCD, Logical Data Modeling, ERwin, Oracle Designer

RDBMS: Oracle,DB2,Teradata

Programming: SQL, PL/SQL, UNIX Shell Scripting

Environment: Windows (95, 98, 2000, NT, XP), UNIX

Other Tools: TOAD, Aquadata, MS-Office suite (Word, Excel, Project and Outlook), Control-M, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Rhode Island, Cranston

ETL Developer/Lead

Responsibilities:

• Work with data modeling team & Business Analysts to gather business requirements and pass on the information on offshore team
• Understanding the ETL designs & working on code development
• Working on multiple projects within RDP system and understand requirement for the projects
• Attend project related meetings
• Clarify queries of offshore team related to mapping and testing

Enviroment: Datastage 8.7,11.3, Unix, DB2, Unix Shell Scripting, Autosys, Team management & Project Estimations

ETL Lead, Analyst, developer, System Support

Responsibilities:

• Working with the project team members to develop a reliable project plan and ensure the timely delivery of the project deliverables.
• Working with the SME's and business user to define requirements and address any issue occur in the conversation/testing phase.
• Collaborate with different teams to promote consistent ETL technical build, implementation and support processes and ensure best practices are used in developing the ETL codes.
• Provide technical oversight and leadership to support other developers working on ETL problem resolution.
• Partner with other application development teams to ensure scalable and stable ETL integration applications.
• Lead the ETL team to implement 2 migration projects from DS Server Edition v7.5 to Parallel Edition v8.1(including 370 DS jobs), And 1 data warehouse development Project for Clients Sales Reporting across Time, Products, and Areas.
• Supported and stabilized the key ETL cycles of actuaries.
• Proposed error handling and Performance improvement solutions to gain business to the client
• Migrated Datastage jobs from v7.5 to 8.7
• ETL Design, Review, Domain understanding, Client Communications and Providing Technical Solutions, requirements translations & estimation preparations.
• Actively working on datastage job optimizations and encouraging team to improve performance during peak load on servers.
• Leaded the team of 5 for two of major datastage migrations from server v7.5 to parallel v8.1 and from parallel v8.1 to v9.1.
• Responsible for datastage job design flow, troubleshooting, datastage environment setup, data analysis, Job reviews, deployment & support
• Managed Security, Active Sessions, Logs, Unlock Jobs, Datasets, Scratch, Schedules and Assets from Web Console
• Designing and coding the data transformation interfaces to meet the data transformation needs with optimum performance.

Environment: DataStage 9.1, Oracle, Control-M, Unix Shell Scripting

ETL Developer/Lead

Responsibilities:

• Understand the Teradata toolkit to load data into Acquisition & Source System History Layer
• Design/Build jobs to load data into core based on mapping sheet. This is based on FSLDM model.
• Understanding the requirement from onshore and developing jobs on data stage.
• Responsible for end to end delivery of different source systems
• Reviewing the delivery and ensuring timely and defect free delivery.
• Understanding dependencies among various source systems and schedule them accordingly in autosys.
• Responsible for Fixing defect in SIT & UAT phase of the project.
• Responsible for migrating components among various environment(SIT & UAT) of project.
• Guiding new team members about process and flow of project.

Environment: DataStage 8.1(Parallel Edition), Teradata, Unix Shell Scripting, Oracle, Datastage Parallelism concepts, Parallel stages & Software versioning processes

ETL Developer

Responsibilities:

• Changing datastage job to make it compatible to run on teradata
• Analyzing data type issue related to migration.
• Running whole process end to end to make sure data is going fine.
• Analyzing and solving defects raised by testing team.