SUMMARY:

• 12+ years of experience working with Datastage 7.5.2, 8.0.1,8.1,8.5,11.5 Teradata R6, R12 and Oracle v11, v12. Used Datastage 7.x, 8.x, 11.x in various data warehousing applications involving complete Software Development Lifecycle model from analysis, design, development, testing, maintenance and enhancement requests of large data warehouse projects.
• 13 years of experience in Telecom, Retail and Logistics domain with providing Business Intelligence design solution to Customer Relationship Management, Campaign data, Advertisement data, Point of Sale, Inventory Management, Logistics for various business processes.
• Extensive experience in designing Datastage 7.x, 8.x, 11.x jobs to effectively meet business needs and deliver best performing design solutions.
• Highly experienced in SQL performance tuning and debugging of existing SQLs in ETL process.
• 8 years of experience using Teradata R6, R12 SQL Assistant and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and 5 years of experience using Oracle 11g, 12c
• Well versed in creating UNIX wrapper scripts for executing Datastage jobs and implementing run control functionalities like recording input/output record counts, processing times, sending email notifications for job status etc.
• Well versed in creating Mainframe jobs using Job Control Language (JCL).
• Extensively used ETL, ELT methodologies for supporting data extraction, transformation and load processing, using Datastage, Oracle and Teradata.
• Extensive experience on various Database Stages, File Stages, Webservices Stages, Debug/Development Stages and Processing Stages like Join, Funnel, Merge, Transformer, Lookup, Filter, Sort, Sequential File, Dataset, Remove Duplicate Stages etc to develop Server, Parallel and Sequence jobs.
• Experienced in extracting, transforming and loading (ETL) data from databases and text files.
• Excellent skills in retrieving the data by writing complex SQL Queries.
• Worked under distinct phases of code promotion from development, user acceptance testing environment to production.
• Provided analysis, resolutions to UAT defects and production issues under stringent timelines.
• Involved in Functional review, Design Review, and Code review, Peer reviews, Deployment plan reviews
• Involved in training the team on Datastage.

TECHNICAL SKILLS:

ETL Tools: Datastage 7.5.2, 8.0.1, 8.1,8.7, 11.5

Databases: Teradata R6, R12, Oracle 11g, 12c

Version Controls: Tortoise SVN, Virtual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Unix, Linux and Windows

Programming Languages: Unix/Linux Shell scripting, PL/SQL, C, C++

Modeling Tools: Microsoft Visio

Query Tools: Teradata SQL Assistant, Oracle SQL Developer, Toad

ESP, Cntrl: M, SoapUI and Big Data

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Lead ETL Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures and involved in full life cycle of the project.
• Developed FRD (Functional Required Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis
• Derived and Designed required Fact and Dimension tables to accommodate the data as per the user requirements
• Developed Logical and Physical database models to design OLTP system for insurance applications and forward engineered the DDLs
• Identified ETL specifications based on Business Requirements/Mapping Document.
• Defined ETL standards and Best Practices for the ETL team to use in ETL maps and processes
• Extensively developed complex maps to extract data according to the Transformation Business Rules and User requirements to extract data from various sources like Flat Files and SQL Server to Targets SQL Server and XML files.
• Conducted team meetings to gather the status from each team member, coming up with the meeting minutes and making sure that everyone in the team is very effective to meet the project deadlines.
• Coordinate/assist /develop Cognos framework manager model adjustments to accommodate new and existing business requirements.

Environment: Informatica Power Center 8.6, Erwin7.3.3, Oracle10g, SQL Server2005, Quality Center 9.0, Sun Solaris 10, Cognos8

Confidential - NJ

Lead ETL Developer

Responsibilities:

• Deliver ETL solution via DataStage to meet business and non-functional requirements.
• Translates business and functional requirements into technical design to meet stated business needs.
• Participate in technical architecture definitions to align solution with business needs.
• Perform Unit testing and system testing of developed applications across different platforms.
• Create Detail Design document highlighting the changes required to in corporate business needs.
• Create Unit Test document detailing the test cases to execute and anticipated results to be achieved.

Environment: - Datastage v8.7, v11.5, Linux Shell Scripting, Oracle v12, Mainframe Z os

Confidential, Hoffman Estates, IL

ETL Architect, Sr. ETL Developer

Responsibilities:

• Designed the ETL architecture for the re-write.
• Design and development of Datastage jobs to pull the data from source to staging.
• Design and development of Teradata SQL Scripts to load data from Staging to Target.
• Designed the process capable of running multiple scripts in parallel.
• Managed a team of 3 involving 1 Datastage developer and 2 Testers.
• Involved in extensive profiling of different source systems due to lack of documentation on legacy system.

Environment: - Datastage v8.1, Teradata R12, Unix Shell Scripting

Confidential, Lisle, IL

Lead ETL Developer

Responsibilities:

• Design and development of ETL Modules in Datastage to load the Retail Payment data into MBS System.
• Design and development of Unix FTP scripts to import files from Windows to Unix server.
• Design and development data validation jobs, to validate incoming data against DB2 tables.
• Design and development of Datastage jobs to access Web Services using WebServices Transformer stage.
• Implemented FTP scripts to push MOD files to MAINFRAME system.
• Implemented FTP script to post GL Data PeopleSoft system.
• Implemented robust restartability to handle all kinds of aborts and data issues.
• Implemented performance optimization by invoking WebServices in 4-Way partition parallelism and use of XML stage to parse the WebServices output.
• Performed unit testing, system testing, analyzed bugs encountered and implemented corrective changes.
• Created Unix wrapper scripts for execution of Datastage jobs with added functionalities like capturing job statistics, error log details
• Coordinated code deployment to production and jobs scheduling with the concerned teams.

Environment: - Datastage v8.0.1, Teradata R12, Unix Shell Scripting.

Confidential, Chicago, IL

ETL Architect

Responsibilities:

• Interacted with client for requirement specifications, created design documents on specs.
• Involved in extensive data profiling to analyze the data pattern, in order ensure optimum column definitions in Teradata system.
• Worked on complex queries to map the data as per the requirements.
• Design and development of Datastage 8.x jobs to load the Advertising data to EDW.
• Implemented performance tuning by replacing the Teradata Enterprise stage with Teradata Mload stage.
• Implemented generic FTP script to pull the data from Source system.
• Implemented Re-usability in Datastage with Shared container, parameter sets.
• Provided quick solutions to last minute requirement changes.
• Performed unit testing, system testing, analyzed bugs encountered and implemented corrective changes.
• Coordinated code deployment to production and jobs scheduling with the concerned teams.

Environment: - Datastage v8.0.1, Teradata R12, Unix Shell Scripting.

Confidential

Team Lead

Responsibilities:

• Design and development of processes using Datastage 7.x that would focus on transforming source data files from common staging area and provide feeds for impacted legacy application systems due to new CC&B systems with relevant data files.
• Involved in developing
• Creation of Process Control System (PCS) entries in Teradata for different feeds.
• Maintaining the PCS entries in sync across 5 databases (Dev, ST, SIT, PRE-PROD, PROD).
• Involved in design and development of Datastage jobs for several Custom downstream feeds.
• Validation of Teradata requests sent to the DBA.
• Validation and review of Datastage ETL jobs designed by team members.
• Developed detailed specification based on estimates and analysis as approved by client.
• Performed integration test/ System test/ Regression test for enhancements as and when required.
• Involved in creating wrapper scripts for executing Datastage jobs.
• Involved in creation of runbooks for automation of the Datastage jobs in CNTRL-M.
• Monitored and reported project status and service level metrics.
• Set up scheduling and exception-handling routines for ETL processes

Environment: Datastage v7.5.2, Teradata R6, Unix Shell Scripting

Confidential

Datastage Developer (Module Lead).

Responsibilities:

• Design of the feed type.
• Creation of the Metadata entries required for the Process Control System (PCS).
• Design and development of ETL process using Datastage 7.x.
• Involved in System Testing and System Integration Testing of the project.
• These separate segments were further joined based as their business significance and further transformations and cleansing logic was applied to produce stage table ready output files
• Involved in creating wrapper scripts for executing Datastage 7.x jobs, set up scheduling and exception-handling routines for ETL processes.
• Supported quality acceptance tests, and job cycles on Pre-production environments.
• Supported activities included debugging, troubleshooting, modifying, documenting, testing and fixing QC and Pre-prod issues.

Environment: Datastage v7.5.2, Teradata R6, Unix Shell Scripting, Oracle 9i

Confidential

Datastage Developer (Module Lead)

Responsibilities:

• Created high and low-level design documents based on business functionality of the DCTM Media module.
• Development of Datastage jobs to load the DCTM Media data into the Central Data warehouse.
• Further source files were joined and transformed as per business requirements and mapping documents.
• Development of BTEQ scripts to load the DCTM Media data into the Central Data warehouse.
• Migrating the DCTM Media data from Oracle environment to Enterprise Data Store in Teradata environment.
• Involved in creating wrapper scripts for executing Datastage jobs.
• Set up scheduling and exception-handling routines for ETL processes.
• Implemented unit testing and integration testing according to functional Specifications
• Fixed QC defects and migrated updated code across environments using SVN as version control tool.

Environment: Datastage v7.5.2, Unix Shell Scripting, Teradata R6, Oracle, Toad.

Confidential

Mainframe Production Support

Responsibilities:

• Analyzed functionality of existing JCL and SAS programs.
• Implementation of Change requests to existing JCL and SAS programs.
• Implemented the Mainframe job, which loads Campaign data to EDW using Teradata Mload script.
• Monitoring of Jobs running in Mainframes.
• Completing of data refresh in time.
• Handling daily, weekly, fortnight and monthly refresh.
• Providing resolution to dockets/tickets raised by business users.
• Providing solutions to Service requests raised by business user.
• Monitoring and reporting of project level metrics.

Environment: - Mainframe MVS/XA, JCL, SAS, Teradata R6, Oracle.