PROFESSIONAL SUMMARY

• Around 8yrs of extensive experience using DataStage 7.0/7.5/7.5.1A/8.1/8.5
• IBM Certified Solution Developer Info sphere Data stage v8.5
• Extensive experience of working with different Connector Stages
• Extensively worked on various Stages like Transformer, Joiner, Lookup, Merge, Sort, Filter, Aggregator, Copy, Remove duplicates, Funnel, Change capture, Data Set, Sequential File and Oracle stages
• Good understand of SQL, PL/SQL and Query Executions.
• Extensive working knowledge of DataStage Director
• Experience in understanding the Business requirements and translating them into detailed design along with Technical specifications.
• Expertise in DataStage issue resolution, debugging and application performance tuning.
• Scripting and coding experience including utilizing Ksh, SQL, PL/SQL procedures/functions, triggers and exceptions
• Extensive knowledge of Shared containers and Re-Usable components in DS
• Developed and used scripts in DS Job-Control command line operators through Orchestrate shell
• Broad understanding of dimensional data modeling like Star schema, Snow flake schema, fact and dimension table design
• Ensure that user requirements are effectively and accurately communicated to the other members of the development team and Facilitate communications between business users, developers and testing teams.
• Strong Organizational and communication skills

TECHNICAL SKILLS:

ETL Tools: IBM WebSphere DataStage 8.5/8.1/7.5/7.5.1A, Informatica 9.1

Reporting Tools: Microstrategy, Cognos 8.4 BI, BO

Databases: Oracle 11g/10g/9i/8i, DB2 8.1, Vertica, Netezza

Operating Systems: Unix/Linux, MS DOS, Win 7 Professional, Win 9x, Win XP and Win NT

Database Tools: Aginity Netezza Workbench, Nexus Query Chameleon 7.1.3

Languages: PL/SQL, SQL PLUS, Java/J2EE, Java Script, C, C , Shell Scripting

Internet: HTML, XML

Other Tools: Autosys, Quality Center, TWS

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer

Responsibilities:

• Design and implement ETL solutions using the Linux and Vertica
• Design and develop summary data models, Transformations and loading strategies for business data
• Participated in design and implementation of Snowflake schema
• Participate in technical discussions and understanding the Business requirements and translating them into detailed design along with Technical specifications
• Created complex scripts using bash shell embedding vsql scripts
• Develop the Mapping documents for the Dimensions, Facts and Hierarchy Tables
• Prepared technical design, tests Unit/System , and supported user acceptance testing
• Migrated the unix scripts that were embedding the logic using nzsql to use vsql.
• Migrated existing jobs from development to production platforms
• Developed the Scripts to automate the Execution of the above Jobs
• Implemented and tested Packages, triggers, Procedures, functions at Database level using PL/SQL
• Deployed the above Jobs into Production
• Extensively worked on Performance tuning to increase the throughput of the data load.
• Participated in Daily Weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings
• Performed the testing of the scripts and reports in SIT/UAT.
• Developed TestCases and defects using Zephyr during SIT and UAT
• Tested the reports using Business Objects Deski and Webi

Environment: Linux, bash, Vertica Analytic Database v7.0.1-2, Netezza 6.0, Informix, Flat files, Aginity Netezza Workbench, Nexus Query Chameleon 7.1.3, DbVisualizer, Squirrel, putty, winSCP, Business Objects Deski/Webi

Confidential

Senior ETL Developer

Responsibilities:

• Design and implement ETL solutions using the IBM Information Server Suite
• Design and develop summary data models, Transformations and loading strategies for business data
• Participate in technical discussions and understanding the Business requirements and translating them into detailed design along with Technical specifications
• Created complex data stage jobs in Enterprise Edition using various stages like Transformer, Joiner, Lookup, Sort, Filter, Aggregator, Copy, Remove duplicates, Funnel, Change capture, Data Set, Sequential File and Oracle stages
• Develop the Mapping documents for the Dimensions, Facts and Hierarchy Tables
• Prepared technical design, tests Unit/System , and supported user acceptance testing
• Migrated existing jobs from development to production platforms
• Developed the Sequencer Jobs for overall Execution of the above Jobs
• Developed the Scripts to automate the Execution of the above Jobs
• Deployed the above Jobs into Production
• Extensively worked on Performance tuning to increase the throughput of the data load.
• Participated in Daily Weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings
• Performing data lineage and associated documentation
• Providing technical assistance and guidance to both technical and non-technical business users
• Develo p and maintain required project documentation and best practice solutions

Environment: Data stage 8.5, Oracle 11g, Vertica 5.1.1, Netezza 6.0, DB2, Flat files, IBM UNIX AIX 5.3, Aginity Netezza Workbench, Nexus Query Chameleon 7.1.3, DbVisualizer

Confidential

Datastage Developer

Responsibilities:

• Study and analyze the existing system
• Analyze and identify performance bottlenecks within the code
• Recommend solutions for the points identified in the above effort
• Understand the existing projects/ jobs, preparing documentation and fixing the bugs.
• Participate in technical discussions and understanding the Business requirements and translating them into detailed design along with Technical specifications
• Created complex data stage jobs in Enterprise Edition using various stages
• Develop the Mapping documents for the Dimensions, Facts and Hierarchy Tables
• Performing export and import of Datastage components, table definitions and routines
• Used Data stage Director to clear the job logs, job resources and status files
• Extensively implemented Slowly Changing Dimensions for loading Dimension tables
• Prepared technical design, tests Unit/System , and supported user acceptance testing
• Migrated existing jobs from development to production platforms
• Developed the Sequencer Jobs for overall Execution of the above Jobs
• Developed the Scripts to automate the Execution of the above Jobs
• Performance tuning and debugging bottlenecks in Oracle, Vertica, Netezza and databases
• Extensively worked on Performance tuning to increase the throughput of the data load.
• Involved in Unit, Integration and UAT
• Participated in Daily Weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings

Environment: Data stage 8.5, Vertica 5.1, Netezza 6.0, DB2, Flat files, UNIX, Windows Server 2003, TWS Tivoli Workload Scheduling , Aginity Netezza Workbench, Nexus Query Chameleon 7.1.3, DbVisualizer 8.0.8, FileZilla Client, Putty, Microstrategy 9.0.2

Confidential

ETL Developer

Responsibilities:

• Created standard Datastage framework for loading Dimensions, Hierarchies and Fact tables
• Modified the existing jobs to accommodate 5 different DataSources and also worked on extraction, cleansing, validating and integration of data from several datasources
• Participated in Technical discussions on the Proof of Concept Design and Development
• Discussed with Data Modelers and Business Analysts to understand the business logic of the Performance Management Warehouse
• Developed the Mapping documents for the Dimensions, Facts and Hierarchy Tables
• Designed the schema and created DDL Scripts for ETL Metadata tables to store the run time metrics of the Datastage Jobs
• Designed the jobs in Data stage 8.1. Provided hands-on participation, technical guidance and leadership to support existing Datawarehouse applications, involving Data stage
• Worked on Change data capture CDC for updating target. Developed reusable jobs using Dynamic Meta data using run time column propagation
• Performing export and import of Datastage components, table definitions and routines
• Used Data stage Director to clear the job logs, job resources and status files
• Experience in complete life cycle of Design, Development, Maintenance and Documentation of Conversion Process. Worked with Datasets, Lookup, Merge, Joiner, Funnel, Transformer
• Extensively implemented Slowly Changing Dimensions for loading Dimension tables
• Prepared technical design, tests Unit/System , and supported user acceptance testing
• Migrated existing jobs from development to production platforms
• Involved in setting up the ETL standards and helped the client to use ETL best practices
• Identified performance bottle-necks and suggested improvements
• Developed the Sequencer Jobs for overall Execution of the above Jobs
• Developed the Scripts to automate the Execution of the above Jobs

Environment: Data stage 8.1, Oracle 10g, Flat files, UNIX, Java/J2EE, Websphere, Erwin 4.2,

MS Word, Excel, Cognos 8.4 BI, HP Quality Center 10.0, WinSCP, WinCVS 2.0