SUMMARY OF QUALIFICATIONS

• Five years of IT experience in Design, Development and Implementation of Data warehouses as an ETL Lead/Developer.
• Profound experience in leading teh teams during teh course of project development to maintenance.
• Experience in gathering business requirements, technical specifications, documenting them, and converting them into robust system designs.
• Worked in all teh phases of teh Data Warehousing life cycle for Data Warehouses and Data marts using Data Stage (Parallel Extender) 9.1/8.0/7.5/7.0, Oracle, DB2, Netezza and Teradata.
• Experience using Datastage tool set including Datastage Designer, Datastage Director, Datastage Manager and Datastage Administrator.
• Experience in Infosphere Quality stage and performed address cleansing using AVI stage by integrating wif teh Postal Address validation.
• Expertise in using real time stages including XML packages and message queues. Worked extensively on XML Input, XML Output, MQ Connector Stage and WISD stage.
• Strong noledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Experience in SQL, SQL*PLUS, Toad and developed Stored Procedures, Functions, Triggers and Packages.
• Extensive noledge of Data Modeling techniques and worked through many styles of Data Models.
• Sound noledge of UNIX and extensively developed UNIX shell scripts.
• Involved in troubleshooting, Performance tuning and Performance monitoring.
• Experience in CA7, Control - M and Autosys scheduling tools.
• Sourced from disparate data sources IBM DB2, Oracle, SAP and SQL Server and loaded into Oracle and Teradata and Netezza DW.
• Experience in providing 24/7 On-call Production Support by Monitoring ETL Jobs and responsible for Scheduled Loads.
• Strong writing and documentation skills for teh management, development and control of documentation.

TECHNICAL SKILLS

ETL Tools: DataStage 7.0, 7.5.1, 7.5.2, 8.0,8.5,9.1

Database & Tools: Teradata V2R5, V2R6, Teradata BTEQWIN 6.0, Oracle 9i/10g9i/8i/8.0/7.0, DB2, MS Access 7.0/97/2000/2003, DB2, Netezza

Scripting: UNIX Shell Script

Scheduling tools: Autosys, Control-M, CA7, CA Workload Automation Desktop Client

Operating Systems: Linux, Windows, MS-DOS, UNIX

Programming Languages: C, C++, Java (Core and Advanced), HTML, XML, BASIC, SML

Web Skills: HTML, XML

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential, New Albany, OH

Responsibilities:

• Involved in requirement analysis of teh projects
• Played a lead role by gathering information from various technology partners for setup.
• Held various meetings wif teh project stake holders, business analysts and end users to lay out mapping documents for teh developers.
• Involved in loading teh source data into Netezza production tables using ODBC, Transformer, Lookup, Join, Sequential File, Sort Stage, Modify and Remove Duplicate Stages.
• Worked on CA Workload Automation Desktop Client Scheduling tool (ESP) to schedule teh ETL jobs based on dependency and priority.
• Peer reviewed teh code and helped teh team by creating template jobs and sequences.
• Designed ETL audit process for stage and EDW loads.
• Involved in code migration from Development to Testing as well as Production Environments.
• Responsible in making timely delivery of teh modules.
• Created audit reporting of teh dimensions based on teh daily loads from source systems, Created audit reporting for Sales matrix as well as inventory matrix.
• Worked on multiple clean up tasks by querying teh data from XMETA repository.
• Impact analysis for existing code while enhancements were done for projects dat involved Change Requests.

ETL Developer

Confidential, Hartford, CT

Responsibilities:

• Played a lead role in teh project composed of twenty developers.
• Created Processes using Datastage 8.5, DB2, Oracle 11 and Netezza.
• Estimated teh project right from teh requirements gathering.
• Developed Data stage jobs by replacing teh audit logic implemented in teh oracle triggers.
• Involved in loading teh source data into Netezza production tables using ODBC, Transformer, Lookup, Join, Sequential File, Sort Stage, Modify and Remove Duplicate Stages.
• Developed UNIX scripts to trigger Data stage job sequences.
• Peer reviewed teh code and helped teh team by creating template jobs and sequences.
• Responsible in making timely delivery of teh modules.
• Built macros which helped in testing atomization as well as code atomization wif XML export of teh data stage sequence, which were imported into teh designer as dsx.
• Created multiple support documents, which would be helpful during teh maintenance of teh project.
• Responsible in Onsite coordination wif teh client.
• Created testing scenarios, testing templates and support documents.

ETL Developer

Confidential, Parsippany, NJ

Responsibilities:

• Played a lead role in teh project besides giving solutions for teh requirements.
• Involved in teh project right from requirements gathering.
• Developed UNIX Scripts for File validations and Data Validations.
• Used teh ABAP Extract stage as source to extract teh reference data.
• Computed extensive transformation logic wifin teh ETL jobs to balance teh GL (General Ledger) data using stages like (Sequential file, Dataset, Copy, Aggregator, Join, Look up, Funnel, Filter, Remove Duplicates, ABAP Extract and Transformer Stage.)
• Created various Shared Containers for teh code reusability wifin teh projects.
• Created Job Sequences wif Start Up on failure option.
• Daily activities involved on-site and offshore co-ordination besides assigning teh work to teh team members and getting status updates.
• Created FDD (Functional Design Documents), TDD (Technical Design Documents), KDD (Key Decision Documents), Source to Target Mapping Documents, Issue Resolution Trackers and Unit Test Case Document.
• Delivered teh project constricting to teh timelines during teh course of testing in different environments and tan to teh Production.
• Design new applications (proprietary tools), developed prototypes and analyze business procedures to refine data and convert it to programmable form for electronic data processing.

ETL Developer

Confidential, Dublin, OH

Responsibilities:

• Played a key role in leading all modules of teh project.
• Analysis and design of ETL processes.
• Created source to target mapping and teh logical flow diagrams to make teh ETL design simpler.
• As a lead my role involved in assigning teh work to teh team members, getting regular updates and making sure teh project is aligned properly wif teh timelines.
• Extensively worked on Database stages for data extraction, transformer stages for data transformation and finally load data into teh respective tables in a normalized form.
• Extensively worked wif Datastage Designer for developing various Datastage parallel jobs using Sequential file, ODBC, Oracle Enterprise, Copy, Aggregator, Join, Look up, Funnel, Filter, XML output, XML input and Transformer Stage.
• Extensive use of teh Surrogate Key function in order to assign Customer ID’s to teh Customers.
• Developed Shared Containers and created reusable components for local and shared use in teh ETL process.
• Developed UNIX scripts to kick off Datastage jobs.
• Created Job Sequencers involving message handling and remedy mailing in case of failures.
• Extensive use of AVI stage where teh addresses of teh customers belonging teh North and South America were verified, corrected and changed. Teh whole application was built as a web service.
• Used teh MQ connector stages to read XML’s from a message queue parse teh XML’s using teh real time XML stages and tan load teh data into respective tables.

ETL Developer

Confidential, Bentonville, AR

Responsibilities:

• Analysis and design of ETL processes.
• Worked in History conversion project and handled huge amounts of data.
• Identified / documented data sources and transformation rules required to populate and maintain data warehouse content.
• Worked extensively on different stages like Transformer, Aggregator, Merge, Join, Copy, Lookup, Lookup File set, Filter, Change Capture, Oracle Enterprise, Column Generator, Dataset stages for Data cleansing and Data Transformation.
• Troubleshot jobs, fine tuned ETL jobs and SQL for better performance.
• Created job sequences and scheduled jobs using Control-M.
• Worked on huge amounts of data (20-30 TB) as a part of history conversion.
• Migrated data from SQL server to Teradata Database.
• Developed UNIX shell scripts and used BTEQ, Fastload, Multiload, and Fast Export utilities extensively to load to target database
• Extracted data from flat files on UNIX and loaded teh target DB2 tables on IBM Mainframe system.
• Extensively used teh Batch Pipes for teh faster load of teh tables.
• Involved in Unit testing of individual components and Integration testing final components.
• Scheduled and monitored jobs on CA7 scheduler
• Generated XML files by using teh XML output stage as a part of Delta process

Programmer Analyst

Confidential, Boca Raton, FL

Responsibilities:

• Involved in designing architectural diagrams and developing logic flow charts.
• Developed UNIX shell scripts lick off teh Data Stage Jobs.
• Defined teh program specifications for teh data migration programs, as well as teh necessary test plans used to ensure teh successful execution of teh data loading processes.
• Developed UNIX shell scripts and used BTEQ, Fastload, Multiload, and Fast Export utilities extensively to load to target database.
• Involved in troubleshooting, Performance tuning and Performance monitoring.
• Extensively worked wif Datastage Designer for developing various Datastage parallel jobs using Sequential file, ODBC, Oracle Enterprise, Teradata Enterprise, Teradata API, Teradata Multiload, Aggregator, Join, Look up, Pivot, Funnel, Filter, XML output, XML input and Transformer Stage
• Extensively used teh transformer stage to implement business logic.
• Was involved in ETL production support. Prepared teh Operational documents & troubleshooting documents.
• Generated XML files as per teh business requirement.
• Part of 24/7 production support team.