SUMMARY

• 10 years of experience in the field of Information Technology and consulting with specialization in Data Warehouse/Business intelligence applications, ETL (Teradata, Datastage,Oracle,DB2), Data integration, Data migration and Platform migration
• Proven experience in Analysis, Design, Data Mapping, Extraction, Transformation and Loading, Testing, Reviewing, Verification and Validation, Quality management and Implementation of various Data Warehouse, ETL &BI Projects.
• Expertise in building Data warehouse and have strong experience in Dimensional data modeling ( Star schema & Snow - Flake schema), Identification of fact and dimension tables, Normalization, Physical and Logical data modeling
• Expertise in implementing Type-1,Type-2,Typ-3 and Type-4 SCD dimensions
• Extensive experience in Parallel Enterprise Edition and Server Engine, Cluster and Grid systems
• Expertise with ETL Teradata(12,13.1) TPT utitlities,FastExport,Fastload,Mload,Tpump and Bteq
• Experience with ETL Datastage and Quality stage tool(8.1,8.5,8.7 & 9.1) and ETL data stages like Transformer, Sequential File, Datasets, DB2 UDB connectors, Oracle Connectors, ODBC, Join, Aggregator, Remove Duplicates, Sort and CDC, Surrogative key Generator, Filter, XML input and XML output stage, routines
• Extensive experience in development, debugging, troubleshooting, monitoring and performance tuning of Datastage Parallel jobs using Datastage Designer, Datastage Director, Datastage Manager and Datastage Administrator
• Experience in Datastage Administrator to create/modify/delete projects and cleanup projects
• Expertise in Platform migration projects like migration of mainframe jobs functionality to Datastage jobs.
• Expertise in Data integration, Data Migration of multiple data sources like Mainframe, DB2, Oracle & Teradata into ODS and EDW
• Extensive Experience in fine tuning of SQL queries,Bteq, programming in PL SQL stored procedures, functions and triggers
• Expertise in Unix Commands and Korn shell scripting
• Experience in version control tool like Clear Case,SVN and Scheduling jobs using Autosys,TWS,Cronacle,CA7
• Experience in Data modeling using MSVisio
• Experience in technical leadership and management for large projects from requirement gathering through implementation, Have guided teams on tasks throughout the SDLC, and ranging from data modeling through ETL and Reporting.
• Trained in Hadoop Technologies like HDFS/PIG/Hive/Map reduce and Informatica

TECHNICAL SKILLS

Operating Systems: Red Hat Linux, Windows XP/9X, MVS OS-390

Data Warehouse/ETL Tool: IBM Info sphere Datastage, Quality stage, Fast Track, Business Glossary 8.1,8.5,8.7,9.1

Data Bases: DB2 10,IMS-DB,Oracle 10g, Tera Data V13.1,14.0

Data Base Tools: Toad for DB2,Toad for Oracle10g,Tera Data SQL assist, SQL Plus,SQL Loader

File Systems: Sequential files, Datasets, VSAM,GSAM

Languages: C,Unix Shell Programming(Ksh),PLSQL,COBOL,JCL,Bteq

Scheduling Tools: Autosys,CA7,Tivolo Work Load Scheduluar,Datastage Director,crontab

Version Control: Clear Case, Sub version

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

ETL (TeraData, Datastage) Senior Developer

Responsibilities:

• Participate in JAD sessions for requirement understaning
• Translate requirements into system solutions and develop implementation plan and schedule.
• Participate in identification and analysis of the source data for performing ETL operations
• Prepare High-level design and Low Level design and get approval from work group meetings
• Working with DBA for creating Dimensions and Fact tables
• Extracting and Loading data into Teradata database using TPT utilities from Unix
• Writing Teradata Bteq queries in batch and interactive
• Work with DBA for fine tuning of SQL queries
• Working with Datastage Administrator to create new project
• Involved in design and development of sequencer and parallel jobs using Designer
• Imported table definitions using the Datastage Manager.
• Performed extraction, transformation and loading of data using different types of stages Teradata Connector, SCD, CDC, Diff, Copy, join, lookup, Row generator, Column Generator, Funnel, Transformer and Pivot stage, TeraData connector
• Used the Datastage Manager for importing, exporting and packaging Datastage jobs
• Migrating code using UHG customized tool
• Developed Unix scripts to execute Datastage Jobs
• Developed TWS scripts for scheduling datastage jobs
• Used stage variables in performing the derivations for the transformer stage.
• Work with Datastage Architect for fine tuning of Datastage parallel jobs performance improvement
• Reviewing code with Datastage Architect for code approval
• Migrating code into production
• Fixing the production changes till warrenty period

Confidential, Minneapolis, MN

ETL (Teradata,Datastage) Senior Developer

Responsibilities:

• Participate in identification and analysis of the source data for performing ETL operations
• Converting E-R data model into Dimensional data modelling.
• Developing modifying any changes in data mappings.
• Preparing Dimensional data modelling using MS Vision
• Working with DBA for creating Dimensions and Fact tables
• Working with Datastage Administrator to create new project
• Involved in design and development of sequencer and parallel jobs using Designer
• Imported table definitions using the Datastage Manager.
• Performed extraction, transformation and loading of data using different types of stages Teradata Connector, SCD, CDC, Diff, Copy, join, lookup, Row generator, Column Generator, Funnel, Transformer and Pivot stage, Teradata connector
• Used the Datastage Manager for importing, exporting and packaging Datastage jobs
• Developed Unix scripts to execute Datastage Jobs
• Developed Cronacle scripts for scheduling datastage jobs
• Used stage variables in performing the derivations for the transformer stage.
• Work with DBA for fine tuning of Teradata Bteq SQL queries
• Work with Datastage Architect for fine tuning of Datastage parallel jobs performance improvement
• Reviewing code with Datastage Architect for code approval

Confidential, Charlotte, NC

ETL (TeraData, Datastage) Senior Developer

Responsibilities:

• Participate in identification and analysis of the source data for performing ETL operations
• Prepare High-level design and Low Level design and get approval from work group meetings
• Working with Datastage Administrator to create new project
• Involved in design and development of sequencer and parallel jobs using Designer
• Imported table definitions using the Datastage Manager.
• Performed extraction, transformation and loading of data using different types of stages DB2 Connector, SCD, CDC, Diff, Copy, join, lookup, Row generator, Column Generator, Funnel, Transformer and Pivot stage, TeraDataMload connector
• Used the Datastage Manager for importing, exporting and packaging Datastage jobs
• Developed Unix scripts to execute Datastage Jobs
• Developed Autosys JILs for scheduling datastage jobs
• Writing Bteq queries in batch and interactive
• Work with DBA for fine tuning of SQL queries
• Reviewing code with Datastage Architect for code approval
• Responsible for production support of ETL process.
• This responsibility includes migrating data mapping to testing and monitoring, troubleshooting, bug fixing and restarting Workflows at different intervals.

Confidential, Charlotte, NC

ETL (Datastage, Oracle, DB2) Developer

Responsibilities:

• Responsible for analyzing the business requirements for the migration of data from the legacy
• Responsible for Data mapping using Fast Track
• Responsible for updating business terms in Business Glossary
• Responsible for performing data conversion design and for data conversion development
• Data Conversion is implemented using source sequential files, datasets DB2 tables, oracle tables and the target Oracle tables
• Worked extensively with almost all Parallel Stages like Copy, Join Merge, Lookup, Row Generator, Column Generator, Modify, Funnel, Filter, CDC, Switch, Aggregator, Remove Duplicates and Transformer, Stages etc.
• Involved in the Performance Tuning of the Datastage jobs using different methodologies like configurations of environment variable file, designing and editing configurations
• Ensuring all data is converting from EBCIDIC to ASCII format
• Worked with DBA’s to create Indexes on Source and Target tables
• Ensuring Qrep facility available for Databases between two regions using Golden Gate software
• Created Design Documents and Unit Test cases with test Results Documents.
• Generating surrogative keys using Surrogative key stage
• Using stage variable, system variables and constraints
• Involved in creation of parallel jobs using parallel extender to improve the performance of jobs.
• Extensively used IBM info server (8.1) designer for developing the code.
• Used the Datastage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse.
• Worked with IBM support to fix various bugs by applying the patches in the Datastage Client machines.
• Involved in partitioning data in for fast performance of a query and also used various partitions in the Datastage for better operations.
• Worked with DBA for improving DB2 and Oracle query performances
• Worked with Datastage Architect to improve performance of Datastage jobs

Confidential

ETL (Teradata, Datastage) Developer

Responsibilities:

• Extraction, Transformation and Loading using Datastage Designer.
• Scheduling and monitoring sessions and batches.
• Developing and modifying any changes in mappings.
• Involved in design and development of sequencer and parallel jobs using Designer
• Imported table definitions using the Datastage Manager.
• Performed extraction, transformation and loading of data using different types of stages
• Used the Datastage Manager for importing, exporting and packaging Datastage jobs
• Used stage variables in performing the derivations for the transformer stage.
• Responsible in part of production support for the ETL process. This responsibility includes migrating data mapping to testing and monitoring, troubleshooting, bug fixing and restarting workflows at different intervals.
• Writing Teradata Bteq queries and oracle queries
• Creating Technical Design Doc and Creating Unit Test Plan Scenarios.