SUMMARY

• 8+ years of total IT experience in the Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP) using Datastage.
• Extensive experience in Ascential Datastage 11.3/8.1/8.0.1/7.5//7.1 using Components like Datastage Designer, Datastage Manager, Datastage Director, Datastage Administrator, Quality stage, Information server and Parallel Extender. Designed Mapping documents ETL architecture documents and specifications.
• Analyzed the Source Data and designed the source system documentation.
• Participated in discussions with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues.
• Development of detailed specifications for data management scripts.
• Document the developed code for promotion to production environment
• Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Set up development, QA & Production environments.
• Migrated jobs from development to QA to Production environments.
• Defined production support methodologies and strategies.
• Design Technical specifications and Mapping documents with Transformation rules.
• Strong background in ETL tools, such as parallel Extender and Information Server
• Extensive experience in Dimensional modeling techniques.
• Experience in Converting the Business Logic into Technical Specifications.
• Extensive experience in loading high volume data, and performance tuning
• Written data stage routines for data validations.
• Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning.
• Strong Experience in Quality Assurance using various environments like System integration testing, Process scenario testing, User acceptance testing and Operation readiness testing.
• Experience with high - end programming experience using PL/SQL, SQL*Loader, ODBC, SQL Navigator, Toad, Developer 2000, Unix Shell Scripting, Win NT and Sun Solaris.
• RDBMS experience with Oracle 9i/8i, SQL Server, DB2 including database development, PL/SQL programming.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Transfer data from one computer to another through a network through FTP Protocols.
• Development of Logical and Physical data warehouse models to represent business needs and designed Dimensional models for data mart creation, allowing flexible high performance reporting of core data
• Having good understanding of ERISA Planning and Fund Transfer Pricing in the field of banking, Finance and Human resource management in various Industries.
• Having good knowledge of ETM ( Enterprise Tax management)

TECHNICAL SKILLS

ETL Tools: Datastage 11.3,8.0.1,7.5.2/7.1 (Administrator, Manager, Designer, Director, Parallel Extender/Orchestrate, Information Server, QualityStage) MVS

OLAP Tools: Business Objects 6.5.1

Operating Systems: Sun Solaris 8/7.0, IBM AIX 4.3 and Windows NT 4.0/2000/2003

Languages: Java (JDK 1.2/1. 1.6), Korn Shell Programming, Perl, PL/SQL.

Database: Oracle 9i/8i/7.3, SQL Server 2000/2005/2008 , DB2, Sybase and MQ Series

GUI: Visual Basic 5.0/6.0

Web Server: Apache Web Server, Java Web Server, Web logic Server, IIS

Other: Humming board, cyber fusion, SQL Assistant, MS Visio, Erwin, TOAD, Pattern Action Language (PAL), Autosys, Control M, TWS ER Win.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. ETL Specialist

Responsibilities:

• Data profiling is done on various source systems to identify and accommodate the required data from these various source systems into the EDW.
• Worked with Subject matter experts for Data Requirement Documents(DRD)
• Created a data dictionary to map the business requirements to attributes to design logical data model implementing star schema.
• Designed Translate values (common generalization of attributes) to maintain uniformity across the EDW.
• Involved in Creating Technical Design documents and Unit and Integration Test Plans for development and testing activities.
• Developed a very complex Data validation and error handling jobs.
• Created Jobs to classify the data into subject areas as source jobs.
• Created Jobs to load the data into EDW from various subject areas as Target jobs.
• Automated the entire ETL flow using autosys.
• Used Various Standard and created Custom Routines to use in DataStage jobs.
• Extensively worked with DataStage Shared Containers for Re-using the Business functionality.
• Created Generic jobs using RCP to extract data from various source systems.
• Extensively wrote user-defined SQL coding for overriding for Auto generated SQL query in DataStage.
• Written batch Job Controls for automation of Execution of data Stage Jobs.
• Defined Stage variables for data validations and data filtering process.
• Worked on performance tuning to address very critical and challenging issues.
• Co-ordinate with SIT and UAT team to fix the Test Problem Reports.

Environment: IBM Information server (Data Stage and Quality Stage 8.0.1), Oracle10g, TeraData V2R6, PL/SQL, AIX, OBIEE, Autosys, Borland Starteam.

Confidential, New York City, NY

Sr. Datastage Developer

Responsibilities:

• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Provide the staging solutions for Data Validation and Cleansing with Datastage ETL jobs.
• Performed data conversion from Mainframe files, DB2, Oracle and Flat Files
• Used the Datastage Designer to develop processes for extracting, transforming, integrating, and loading data into Enterprise Data Warehouse
• Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources.
• Used various Parallel Extender partitioning and collecting methods.
• Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute the Datastage Parallel jobs.
• Created re-usable components using Parallel Shared containers.
• Defined Stage variables for data validations and data filtering process.
• Tuned Datastage jobs for better performance by creating Datastage Hashed files for staging the data and lookups. Used Datastage Director for running the Jobs.
• Written Data stage routines in order to achieve business logic.
• Extensively written shell scripts in different scenarios.
• Implemented Debugging Methodologies with Break Point Options.
• Designed and implemented slowly changing dimensions methodologies.
• Transfer data from various systems through FTP Protocols.
• Written data stage routines for data validations.
• Written batch Job Controls for automation of Execution of data Stage Jobs.

Environment: DataStage 8.0.1, Oracle 10g, DB2 UDB 9.0, AIX 5.1, Mainframe system

Confidential, Fullerton, CA

ETL Datastage consultant

Responsibilities:

• Involved in all Phases of project as a senior ETL Resource, which includes Analysis, Design, Development, coding, testing, Implementation, support and Documentation.
• Designed Data Stage parallel jobs using designer to extract data from various source systems, Transformation and conversion of data, Load data to data ware house and Send data from warehouse to third party systems like Mainframe.
• Extensively used Processing Stage like Lookup Stage to perform lookup operations based on the various target tables, Modify stage to alter the record schema of the input data set, Funnel Stage to combine various datasets into a single large dataset and Switch stage to trigger the required output based on a specific condition.
• Designed jobs Using complex stages like Transformer, Change Capture, Change Apply, Remove Duplicates, Join, Lookup, Merge, Funnel and Aggregator
• Worked on Autosys to schedule jobs
• Developed Sequence Jobs Using Datastage Sequencer, dependency analysis (which indicates weather Job to run sequentially or in Parallel.
• Used several data stage Sequence stages like Job Activity, Execute command, Sequencer, Exception Handler, Wait for a file activity, Terminator activity, Notification activity.
• Created Shared Containers to increase Object Code Reusability and to increase throughput of the system.
• Regularly did the Data Quality Checks on the source system.
• Experience developing complex transformations, surrogate keys, routines, dimension tables and fact tables.
• Implemented Star-Schema models for data mart. Identified the grain for the fact table. Identified and tracked the slowly changing dimensions and determined the hierarchies within the dimensions.
• Worked on coding (stage variables, derivations and constraints) business logics in transformation stage.
• Extensively used Hash files to improve the performance of Referential Lookups.
• Using parameterized metadata for sequential file (schema file), loaded into multiple tables using a single DataStage job.
• Used DataStage Manager for creating new job categories, metadata definitions, and data elements, import/export of projects, jobs and DataStage components, viewing and editing the contents of the repository as well as writing documents.
• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs and debugging them.
• Did the detailed profiling of operational data to get better understanding of the data that can be of analytical purpose for business objects.
• Worked on SQL and defining user Defined SQL’s in Oracle stages for better job performance.
• Performed ETL Performance tuning to increase the ETL process speed.
• Have addressed production, UAT issues, proper action was taken accordingly based on priority and requirement
• Developed Scripts to transfer flat file between two different servers.
• Developed Operational Manual Documentation.
• Associated with other team workers for implementation of data stage best practices for better performance.

Environment: Data stage 7.5.1, oracle 9i, Toad for Oracle, AIX, Putty, winscp and Autosys

Confidential, Deerfield Beach, FL

Sr. Datastage Developer

Responsibilities:

• Used various Parallel Extender partitioning and collecting methods.
• Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute the Datastage Parallel jobs.
• Created re-usable components using Parallel Shared containers.
• Defined Stage variables for data validations and data filtering process.
• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Provide the staging solutions for Data Validation and Cleansing with PL/SQL and Datastage ETL jobs.
• Performed data conversion from Oracle, Flat Files to Data Warehouse.
• Used the Datastage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Developed Job Statistical Report for auditing purpose.
• Worked on Performance measures often accessible from claims data.
• Written data stage routines for data validations.
• Written batch Job Controls for automation of Execution of data Stage Jobs.
• Implemented Autosys for scheduling Datastage Batch Jobs.
• Developed Shell Scripts for file watcher and file archiving process.
• Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources.
• Tuned Datastage jobs for better performance by creating Datastage Hash files for staging the data and lookups. Used Datastage Director for running the Jobs.
• Designed and implemented slowly changing dimensions methodologies.

Environment: DataStage 7.5/PX, Oracle 9.2, SQL Server 2000, PL/SQL, AIX 5.1