SUMMARY:

• Over Seven years of experience with Confidential Hundred companies in System Analysis, Design, Development, Testing and implementation and over Five Years in the fields of Data Warehousing, Data Integration, Data Migration and Developing Client server application using IBM Info sphere Data Stage (11.3/9.1/8.5/8.1.1/8.0.1/7.5.2/7.5.1 ),SAP BW, Teradata, DB2, SQL procedural language and Shell Scripts. Industry experience in Banking & Financial Services, Marketing, Refinery and Retail.
• Seven plus years of professional experience in IT Development, extensively in ETL design and development projects, Conversions and Integration projects, Business Intelligence projects with Confidential 100 companies.
• Expertise on various tools and technologies like Data Stage 11x/9x/ 8x/7x both on Server and Parallel Edition, SAP Data services Teradata, SAP, SQL Server 2008/2005 and UNIX.
• Experienced in ETL architecture design and performance tuning of ETL applications.
• Good hands on Data Modeling and design of the Data warehouses/Data marts.
• Experience in submitting proposals, gathering requirements, nail downing the complexities, defining the load strategies, and design, develop and deploy the ETL applications.
• Expertise in integrating the ETL processes with external systems like SAP, Onboarding systems.
• Good knowledge in Data Stage Administration (Installation/Debugging), Setups, Capacity Planning, Migrations and code version upgrades.
• Good understanding on Data Stage Internals and its core architecture including the latest version 9x/8x.
• Good hands on IBM Information suite 8.5/8.7/9.1/11.3/11.5
• Good hands on SAP admin client in 11x/9x V
• Experience in performance tuning and optimization of SQL queries.
• Experience in writing Unix Shell Scripts and automation of ETL process.
• Expertise in preparing the project documentation like technical specs, mapping docs Run book, Migration Check list, test plans etc.
• Experience in leading the team and comfortable on working Offshore/Onsite model projects.
• Experience on preparing estimates, Resource Planning, task distribution, status tracking, leading the team, taking responsibility and meeting deadlines.
• Good Knowledge on Agile Methodology (scrum) and waterfall methodologies.
• Good Knowledge on Finance, Banking, Manufacturing, Retail and Insurance domains.
• Excellent Project Management skills, Team skills along with Inter - personal & Communication skills

TECHNICAL SKILLS:

ETL Tools: IBM Infosphere DataStage 11.5/11.3/9.1/8.7/8.5/ 7.5/7.1 (Manager, Designer, Director, Administrator), IBM Infosphere Information Analyzer,DataStage Version Control.

SAP Tools: SAP Data Services, Information Stewards, BAPI

Databases: DB2, Teradata 12.0, SQL Server 08/12, Oracle 10g/9i.

Languages: SQL, PL/SQL, C/C++, UNIX Shell Scripting.

Scheduling tools: Autosys, Tidal, CA7, Crontab and Datastage Scheduler.

DB Tools: Beaver, Teradata SQL Assist, QMF, TOAD 10.6/9.55, SQL*Plus, Oracle developer.

Operating Systems: Windows8/7/03/00/NT, Windows server, Macintosh (Lion), Red Hat Linux 4.0/6.0.

Other Tools: Slack#, Lean Kit, SAPLGPAD, OneNote, MS VIZIO 2010, Putty, Ultra edit, FileZilla/Wisp, Excel etc...

WORK EXPERIENCE:

Confidential

Sr. ETL (Data stage) Developer, Bentonville, Arkansas

Responsibilities:

• Designed the ETL processes using Data Stage to load data from Teradata, DB2, Informix, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Oracle Data Warehouse database.
• Expertise in agile methodologies,
• Migrating 1200+ Data stage jobs from V9.1 to V11.5
• Gathering requirements from client. Implementing projects from End to End.
• Expertise in offshore onsite model. Coordinating teams. Following up things.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional), Wait for file, Email Notification, Sequencer, Exception handler activity.
• UNIX script writing or changing existing with respect to new environment/Requirement.
• Closely working with Business Intelligence, SAP BI, SAP Basis, DI Admin, Mainframe, and Teradata/DB2 DBA Teams.
• Involved in each and every step of project planning and analysis.
• Used Data Stage Parallel Extender stages namely Datasets, Sort, Lookup, Change Capture, Funnel, Peek, and Row Generator. SCD
• SAP R/3 pack used to extract data directly from SAP DB2 Database.
• SAP (ABAP/BAPI/IDOC) stages experience.
• Data migration from DB2 Mainframe to Teradata. Handled Billions of records.
• And also have experience in SAP BI stage.
• Extensively worked with Teradata connector. Loaded high volume of data into Teradata Database.
• Stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used the Data Stage Director and its run-time engine to monitor the running jobs.
• Involved in performance tuning and optimization of Data Stage mappings using features like partitions and data/index cache to manage very large volume of data.
• Involved in parameterize all the Data Stage Jobs (Parallel).
• Experience on working with Mainframe CA7/ scheduling tool.
• Worked closely with Data stage Admin, SAP BI & SAP Basis teams.
• Organized data in the reports by using Filters, sorting, Ranking and highlighted data with Alerts.
• Involved in data validation using Excel.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis
• Extensively worked on Error handling, cleansing of data and performing lookups for faster access of data.
• Involved in Unit testing, System testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Involved in all steps of development and deployment processes.
• Coordinated with offshore team on daily basis.

Environment: IBM Info Sphere Data Stage 9.1/11.5 (Designer, Director, Administrator),SAP BW PACK, BAPI Stages, Quality Stages, MF DB2,Teradata 12.0, Beaver, QMF, JIRA, SLACK, Lean kit, Shell Scripts, CA7 scheduler.

Confidential

ETL (Data stage) Developer/Administrator

Responsibilities:

• Designed the ETL processes using Data Stage to load data from Informix, SAP DB, Oracle, Flat Files (Fixed Width) and XML files to staging database and from staging to the multiple target stages.
• Migrating 2000+ Parallel, Sequence, Server Data stage jobs from 7X to 8X/9X Versions.
• Experience in trouble shooting and performance tuning on existing processes.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional), Wait for file, Email Notification, Sequencer, Exception handler activity.
• Modified all UNIX scripts with respect to new environment. And created new scripts to automate processes.
• Hands on using web console.
• Closely working with Business Intelligence team, Testing and Database teams.
• Involved in each and every steps of project plan and analysis.
• Used Data Stage Parallel Extender stages namely Datasets, Sort, Lookup, Change Capture, Funnel, Peek, and Row Generator. SCD
• And also have experience in SAP BI stage
• Hands on connector migration tool usage.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used the Data Stage Director and its run-time engine to monitor the running jobs.
• Involved in performance tuning and optimization of Data Stage mappings using features like partitions and data/index cache to manage very large volume of data.
• Involved in parameterize all the Data Stage Jobs (Parallel).
• Experience on Control scheduling tool.
• Organized data in the reports by using Filters, sorting, Ranking and highlighted data with Alerts.
• Involved in data validation using Excel.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis
• Extensively worked on Error handling, cleansing of data and performing lookups for faster access of data.
• Involved in Unit testing, System testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Involved in all steps of development and deployment processes.
• Coordinated with offshore team on daily basis.

Environment: IBM Info Sphere Data Stage 7X/8X/9X (Designer, Director, Manager, Analyzer),Informix, Oracle 10g/11g, SQL Server 05/08/12, SQL*Plus, Shell Scripts, Control scheduler.

Confidential

ETL (Data stage) Developer, Bentonville, Arkansas

Responsibilities:

• Designed the ETL processes using DataStage to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Oracle Data Warehouse database.
• Migrating 1200+ Datastage jobs from V8.0 to V9.1.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional), Wait for file, Email Notification, Sequencer, Exception handler activity.
• Modified all UNIX scripts with respect to new environment.
• Closely working with Business Intelligence team.
• Involved in each and every steps of project plan and analysis.
• Used Data Stage Parallel Extender stages namely Datasets, Sort, Lookup, Change Capture, Funnel, Peek, and Row Generator. SCD
• And also have experience in SAP BI stage
• Stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used the Data Stage Director and its run-time engine to monitor the running jobs.
• Involved in performance tuning and optimization of Data Stage mappings using features like partitions and data/index cache to manage very large volume of data.
• Involved in parameterize all the Data Stage Jobs (Parallel).
• Experience on Mainframe CA7/ scheduling tool.
• Worked closely with Data stage Admin, SAP BI & SAP Basis teams.
• Organized data in the reports by using Filters, sorting, Ranking and highlighted data with Alerts.
• Involved in data validation using Excel.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis
• Extensively worked on Error handling, cleansing of data and performing lookups for faster access of data.
• Involved in Unit testing, System testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Involved in all steps of development and deployment processes.
• Coordinated with offshore team on daily basis.

Environment: IBM Info Sphere DataStage 7X/8X/9X (Designer, Director, Manager, Analyzer), Oracle 10g/11g, Teradata 12.0, SQL Server 05/08/12, TOAD 9.6, SQL*Plus, Shell Scripts, CA7 scheduler.

Confidential

ETL (Datastage) Developer

Responsibilities:

• Designed the ETL processes using Data Stage to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Oracle Data Warehouse database.
• Used Data Stage Parallel Extender stages namely Datasets, Sort, Lookup, Change Capture, Funnel, Peek, and Row Generator. SCD
• Stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used the DataStage Director and its run-time engine to monitor the running jobs.
• Involved in performance tuning and optimization of DataStage mappings using features like partitions and data/index cache to manage very large volume of data.
• Used TOAD to view, create, delete and load data from and to Oracle tables. Used mainly to check the SQL queries before implementing them in Data Stage OCI and ODBC stages for extracting/loading/deleting the data in the Oracle tables.
• Involved in parameterize all the DataStage Jobs (Parallel).
• Organized data in the reports by using Filters, sorting, Ranking and highlighted data with Alerts.
• Involved in data validation using Excel.
• Migrated 2000+ jobs from Datastage 8.1 to 8.7.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis
• Extensively worked on Error handling, cleansing of data and performing lookups for faster access of data.
• Involved in Unit testing, System testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Involved in all steps of development and deployment processes.

Environment: : IBM InfoSphere DataStage 7X/8X (Designer, Director, Manager, Analyzer), Oracle 10g/11g, Teradata 12.0, SQL Server 05/08/12, TOAD 9.6, SQL*Plus, Shell Scripts, Tidal enterprise scheduler.

Confidential, Concord, CA

DataStage Engineer

Responsibilities:

• Working with SQL Server, Oracle and Linux along with IBM DataStage.
• Responsibilities may include but are not limited to: Formulate and define project scope Develop, analyze and maintain current and future business processes.
• Used DataStage Parallel Extender stages namely Datasets, Sort, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Maintaining the functional and non-functional requirements gathering, analysis, and verification and acceptance process.
• Used TOAD to view, create, delete and load data from and to Oracle tables. Used mainly to check the SQL queries before implementing them in Data Stage OCI and ODBC stages for extracting/loading/deleting the data in the Oracle tables.
• Ensuring issues are identified, tracked, reported on and resolved in a timely manner.
• Extensively worked with IBM Data Stage V 8.1/8.5/8.7(Building Sequences, jobs) as an developer
• Extensively worked with IBM Data Stage V 7X/8X Designer, Director, Manager, Administrator, Console, Orchestrate, Metadata and also Quality Stage.
• Utilized automation tools to schedule, execute and monitor Data Stage jobs
• Develop and execute, in conjunction with the Data Stage Leads, Quality checks and Release schedules
• Designed and coded functions of the application in accordance with the Data Stage standards and architectural guidelines
• Executed test plans and documented results and discrepancies
• Prepare applicable Data Stage interface supporting documentation
• Extensively working on MS Access Databases (2003,2007 version)
• Good understanding on FTP, SFTP scripts on Unix environment
• I am self-starter and highly motivated.
• Ability to work with minimum direction
• Assists in enforcement of project deadlines and schedules
• Takes input from supervisor, project manager and team members and appropriately and accurately applies comments/feedback
• Consistently delivers high-quality services to the business, stake holders and vendors
• Exhibits confidence and an extensive knowledge of emerging industry practices when solving business problems
• Ability to quickly gather information and learn enough background to participate on project team
• Organize work to ensure that it is carried out efficiently and effectively
• Closely worked with Micro strategy team.
• Escalates issues to team lead for discussion when appropriate
• Able to handle conflict and issues in a constructive and objective manner.

Environment: IBM WebSphere DataStage9.1/ 8.1/8.5 & 8.7 (Designer, Director and Administrator), Linux, SQL Server V 2005/08/12, Oracle 11g R2,Toad for Oracle 11.5, Putty, Wisp (FTP Tool),Windows 2000 Server, Windows XP.

Confidential, Sensing, MI

DataStage Developer

Responsibilities:

• Designed the ETL processes using Data Stage to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Oracle Data Warehouse database.
• Used DataStage Parallel Extender stages namely Datasets, Sort, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used the DataStage Director and its run-time engine to monitor the running jobs.
• Involved in performance tuning and optimization of DataStage mappings using features like partitions and data/index cache to manage very large volume of data.
• Used TOAD to view, create, delete and load data from and to Oracle tables. Used mainly to check the SQL queries before implementing them in Data Stage OCI and ODBC stages for extracting/loading/deleting the data in the Oracle tables.
• Involved in parameterize all the DataStage Jobs (Parallel).
• Organized data in the reports by using Filters, sorting, Ranking and highlighted data with Alerts.
• Involved in data validation using Excel.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis
• Extensively worked on Error handling, cleansing of data and performing lookups for faster access of data.
• Involved in Unit testing, System testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.

Environment: IBM Info Sphere Data Stage 8.1.5/8.5 (Designer, Director, Manager, Analyzer), Oracle 10g, Teradata 12.0, TOAD 9.6, SQL*Plus, Shell Scripts.

Confidential

Data Warehouse Developer

Responsibilities:

• Gathered the requirements from the Business Analysts and Project Managers.
• Documented data sources and transformation rules required to populate and maintain data warehouse content.
• Designs, implements and supports data warehousing.
• Implements business rules via stored procedures, middleware, or other technologies.
• Defines user interfaces and functional specifications.
• Responsible for verifying accuracy of data, and maintaining and supporting the data warehouse.
• Familiar with standard concepts, practices, and procedures within a particular field.
• Relies on experience and judgment to plan and accomplish goals.
• Performs a variety of tasks.
• Typically reports to a manager.
• Involved in the development and implementation of ad-hoc reporting system using Business Objects.

Environment: SQL, PL/SQL, Oracle, SQL Server, MS office, UNIX, Linux.