SUMMARY

• 12 years of IT experience providing technical leadership on Data Warehousing projects involving Profiling, Design, Development, Integration, Implementation, Maintenance, Testing, and Production Support of Applications.
• Strong skills in IBM - DataStage 7.5/8.5/11.3 & 11.5, Netezza and IBM DB2,Teradata and Debugging, Performance tuning.
• 10 Data Warehouse/ Data Mart development and implementations of Data warehousing projects.
• Proficiency in defining ETL design and integrating data from disparate source systems and disparate data formats including Requirements gathering, Source system analysis, Data Quality, ETL-QA, Performance Tuning, Maintenance and Production Support using DataStage, Db2 and Unix Shell scripting .
• Experience in all the stages of SDLC like Business Requirements Analysis, Software development, Testing, Production Support, Documentation and the Software Requirements Specifications.
• Lead a team of 5 to 10 people and guided data stage/ELT developer on technical design, Preparation of test data, Resolution of defects across all phases of Testing(Unit/System/Regression/UAT)and development of ETL/ELT packages for Prod Deployment and Control M schedules
• Expert in fulfilment of data warehouse project tasks such as Planning, Requirement gathering, Identifying sources, allocation of resources and execution of projects including planning of implementation activities.
• Experience in Performance tuned for different subject areas by implementing aggregates, aggregate join indexes, compression, statistics, and SQL re-writes; along with foundation table modifications including Index changes.
• Independently handled the upgrade of DataStage Version from 8.5 to 11.3
• Experience in Direct connect concept to process the real-time data processing.
• Experience in DataStage server jobs and Parallel jobs.
• Execusley worked on various stages in DataStage Oracle Enterprise, Copy, Modify, Lookup, Transformer, Sort, Funnel, Shared Containers, Local Containers, Join,, Sequential file, Remove Duplicates, Hashed File, Aggregator, Transformer, Sort, Link partioner, XML and Direct connect stages.
• Knowledge on UNIX scripting and ControlM scheduling tools.
• Knowledge in both Devops and Agile methodologies.
• Certified DataStage Professional.

TECHNICAL SKILLS

ETL Tools: DataStage 7.5,8.5,11.3&11.5

Relational Databases: Oracle, DB2, Teradata & Netezza

Languages: SQL

Scheduling: ControlM

Operating Systems: Windows 95/NT/2000/XP, Red Hat Linux, Unix and DOS 6.2.

Data Modeling Tools: MS Visio

Migration toll: TFS

PROFESSIONAL EXPERIENCE

Confidential

DataStage developer & Support,Tech Lead and Architect

Responsibilities:

• Actively involved in the SDLC cycle for the Project
• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Worked with the Business Analyst Team and prepared Documents relevant to the given specification according to the system specification.
• Identified and documented detailed business rules and Use Cases based on requirements analysis
• Provided general design consultation regarding Best Practices and EDW approaches.
• Worked on DataStage tools like DataStage Designer and DataStage.
• Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.
• Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and scheduling tools.
• Developed Job Sequences and scheduling jobs based in Director.
• Involved in Code Migration to SIT, UAT & Prod Regions and provided the required support.
• Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
• Working on Direct connect concept to process the real-time data processing.
• Performed a detailed Analysis on the process flow of the project and prepared the analysis document for certain change requests.
• Experience in Application Development programs end to end from Requirements gathering till Go-live, Warranty Support and Production Support.
• Review on Exiting system to Improve the Entire system(Performene tuing and Process improvements).
• As part support, Daily Monitor the Batch process and Test the Data backup and Restore process.

Environment: DataStage11.5, Netezza, UNIX, Microsoft Office and Windows 7

Confidential

DataStage developer,Tech Lead and Architect

Responsibilities:

• Actively involved in the SDLC cycle for the Project
• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Worked with the Business Analyst Team and prepared Documents relevant to the given specification according to the system specification.
• Identified and documented detailed business rules and Use Cases based on requirements analysis
• Provided general design consultation regarding Best Practices and EDW approaches.
• Worked on DataStage tools like DataStage Designer and DataStage.
• Design DataStage jobs from XML File to DB2 database.
• Developed DataStage common jobs which generate common output for Multiple Source.
• Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.
• Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and scheduling tools.
• Developed Job Sequences and scheduling jobs based on dependencies using Control M.
• Involved in Code Migration to SIT, UAT & Prod Regions and provided the required support.
• Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
• Working on DataStage 8.5 to DataStage 11.3 migration.
• Working on Direct connect concept to process the real-time data processing.
• Performed a detailed Analysis on the process flow of the project and prepared the analysis document for certain change requests.
• Experience in Application Development programs end to end from Requirements gathering till Go-live, Warranty Support

Environment: DataStage, DB2, UNIX, Microsoft Office and Windows 7

Confidential

DataStage Lead Developer

Responsibilities:

• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Identified and documented detailed business rules and Use Cases based on requirements analysis
• Identified/documented data sources and transformation rules required to populate and maintain Data Warehouse content.
• Wrote system specifications by collecting business requirements and translating user requirements in to technical specifications.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Designed ETL jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts using DataStage Tools. This includes error processing, reprocessing logic, count match logic, and restart ability logic.
• Worked extensively on different stages such as Sequential file, lookup, Aggregator, Transformer, Join, Pivot, Sort,Filter,DB2 for developing jobs.
• Extracted data from the databases to load it into a single data warehouse repository
• Designed reusable logic utilizing Shared Containers in DataStage Designer.
• Responsible for defining the naming standards for data warehouse
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation
• Performance tuned ETL jobs as part of simplification of Enterprise Data warehouse.
• Developed Job Sequences and scheduling jobs based on dependencies.
• Involved in Code Migration to SIT, UAT & Prod Regions and provided the required support.
• Experience in Application Development programs end to end from Requirements gathering till Go-live, Warranty Support.

Environment: DataStage, DB2, UNIX, Microsoft Office and Windows 7

Confidential

DataStage developer and DataStage Lead

Responsibilities:

• Preparing Unit Specification Documents and Design Specification based on Business requirement.
• Developed simple & complex Data stage jobs.
• Design, Build & Test parallel jobs to extract files from UNIX systems using Sequential file.
• Used the Data stage stages Oracle Enterprise, Copy, Modify, Lookup, Transformer, Sort, Funnel, Shared Containers, Local Containers Join,, Sequential file, Remove Duplicates.
• Design, Build & Test sequencer jobs to run all the parallel jobs (Extract, Transform and Load Oracle in sequence.
• Developed Job Sequences and scheduling jobs based on dependencies.
• Preparing Technical-inspection Summary documents
• Unit testing.
• Preparing Unit test case documents.
• Run the Unit test case
• Performance tuned ETL jobs as part of simplification of Enterprise Data warehouse.
• Involved in Code Migration to SIT, UAT & Prod Regions and provided the required support.
• Experience in Application Development programs end to end from Requirements gathering till Go-live, Warranty Support.

Environment: DataStage, Oracle, UNIX, Microsoft Office and Windows

Confidential

DataStage developer

Responsibilities:

• Analysis the user requirements.
• Data load in to staging area.
• Cleaning data in stage area.
• Design, Build & Test server jobs to extract files from UNIX using FTP stage.
• Used the Data stage stages FTP, ODBC, Hashed File, Transformer, Sort, Aggregator, Sequential file, Orica bulk load.
• Design, Build & Test sequencer jobs to run all the server jobs (Extract, Transform, Load Dimension data, Load fact data in sequence).
• Unit testing
• Preparing Unit test case documents.
• Run the Unit test case
• Performance tuned ETL jobs as part of simplification of Enterprise Data warehouse.
• Involved in Code Migration to SIT, UAT & Prod Regions and provided the required support.
• Experience in Application Development programs end to end from Requirements gathering till Go-live, Warranty Support.

Environment: DataStage,MsAccess, Unix, Microsoft Office and Windows

Confidential

DataStage developer and ETL lead

Responsibilities:

• Analyzed reporting requirements in detail with the project stakeholders
• Prepared Data Mapping Documents and Designed the ETL jobs based on the BRD
• Developed simple & complex Data stage jobs.
• Design, Build & Test parallel jobs to extract files from UNIX systems using Sequential file.
• Used the Data stage stages Oracle Enterprise, Copy, Modify, Lookup, Transformer, Sort, Funnel, Shared Containers, Local Containers Join,, Sequential file, Remove Duplicates.
• Developed Job Sequences and scheduling jobs based on dependencies.
• Preparing Technical-inspection Summary documents
• Unit testing.
• Preparing Unit test case documents.
• Run the Unit test case
• Involved in Code Migration to SIT, UAT & Prod Regions and provided the required support.

Environment: DataStage,Teradata, Unix, Microsoft Office and Windows