SUMMARY

• I have over 7 years of experience in Data Warehousing design, development, and testing.
• I am an experienced Datastage developer having hands - on development experience in versions 8.7 and 11.5 using Waterfall as well as Agile (Scrum) Methodology.
• I am proficient in Oracle and Teradata SQL and Unix scripting. I possess excellent communication, interpersonal and presentation skills.
• Proficient in Datastage parallel jobs using version 8.7 and 11.5
• Experienced in the use of Datastage Transformer, Aggregator, Lookup, Join, Pivot, Filter, SK, RemDup, Funnel, Copy, Peek, Dataset, Sequential File, Oracle Connector, Teradata Connector, Parameter Sets, Sort, and Change Capture stages
• Oracle SQL, Teradata SQL, PL/SQL, and SQL tuning
• Experienced in using Datastage Designer, Director, Administrator, and SQL development tools such as Teradata SQL Assistant, TOAD, and Oracle SQL Developer.
• Experienced in using appropriate partitioning strategy in the design of jobs
• Extensive experience in building sequence jobs with appropriate dependency and consideration for run optimization
• Hands-on experience in data profiling such as metadata, column value analysis
• Good knowledge on Data Warehousing concepts such as Facts, Dimensions, and various types of Slowly Changing Dimensions (SCD)
• Experienced in all phases of SDLC such as design/development, testing, deployment, and maintenance using Agile as well as Waterfall methodologies.
• Working knowledge of Data Vault Modeling that allows accurate interpretation of Data Models
• Proven track of developing clear, maintainable, and efficient code using ETL best practices and standards
• Experienced with the concepts of reusability, restartability/recoverability, maintainability, and performance in datastage job design and development
• Working knowledge of Runbook (Operational Manual) contents
• Production support
• Create/use technical specifications, source-to-target mappings, development standards, and develop datastage jobs
• Profiling of source data to evaluate the actual contents, structure, and quality of data
• Creating Unit Test scripts and conducting unit tests
• Reconciliation of data between source and target
• Supporting System Integration and User Acceptance Tests
• Implement deployment activities and provide post-production support
• Addressing performance issues by performance tuning long running jobs

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Responsibilities:

• Migration of over 3500 jobs and sequences for ADW from Datastage 8.7 to 11.5
• Performance tuning using staging strategy and CDC resulting runtime improvement of over 90%.
• Developed jobs and sequences for implementation of 50 CRs for the AHA, SPM, and AMOS projects using Agile development methodology.
• Created reconciliation scripts to test completeness and accuracy of data load between the Source to Staging and Staging to the Warehouse tables.
• Participated in peer reviews of the jobs and addressed the review comments
• Production support on rotation for ADW

Environment: Datastage 8.7 and 11.5, Oracle 11g, Teradata 16.1 and Linux

Confidential, Southfield, MI

Responsibilities:

• Analyzed the technical specification and the mapping document to determine the ETL design.
• Profiled the source data contents and the structure, the source and the target data models(Relationships, Constraints, Primary Keys (PK), Referential Integrity/Foreign Keys, Natural Keys, and other technical fields such as Surrogate Keys, Load/Update Dates etc.)
• Developed datastage jobs to load transient staging tables (truncate and load daily)
• Created unit test scripts
• Created reconciliation scripts to ensure data was loaded into the staging tables completely and accurately. This included row count reconciliation, comparison of hash total of numerical values, and comparison of code values between source and target.
• Developed jobs to load data from the staging tables to the Data Warehouse using SCD type 0 (Always insert) and SCD type 2 (maintaining history of changes) techniques.
• Creation rejection datasets from Lookup, transformer, and Connector stages to identify source data inconsistency and subsequent resolution.
• Participated in peer reviews of the jobs and addressed the review comments
• Prepared documents describing jobs and contributed Runbook.
• Developed Sequence jobs
• Applied ETL best practices in the development of datastage jobs. The objectives are to achieve reusability, Restartability/recoverability, maintainability, performance optimization, and last but not the least maintaining presentability of the jobs.

Environment: Datastage 8.7/11/5, Oracle 11g, and Unix

Confidential

Responsibilities:

• Analyzed the technical specification and the mapping document to determine the ETL design
• Profiled the data (in source sequential files) to understand the data contents and the structure
• Created reconciliation scripts to reconcile data between Source and Staging, Staging and Warehouse, and the Warehouse and the Aggregate tables.
• Developed jobs to load source data into the staging tables and Data Warehouse.
• Developed Sequence jobs and unix scripts to call the sequence jobs
• Collected rejection datasets using Lookup, Transformer, and Oracle Connector stages.

Environment: Datastage 8.7 Oracle 11g, and Unix