Summary

• Detail-oriented and result driven BI Professional with around 7 years of experience in populating and maintaining Enterprise Data Warehouse and subject area specific Data Marts using IBM DataStage ETL tool.
• Working Experience in Insurance, Retail, Finance, Banking and Semiconductor industry, Automotive industry.
• Experience with Requirement Gathering, Analysis, Testing and Enterprise data Integration covering all phases of SDLC
• Experience includes Enhancement, Performance tuning and Production Support and Maintenance.
• Worked on Parallel extender Parallel processing of data extraction transformation application
• Highly focused on delivering releases, meeting deadlines with a quality development applying policies, procedures and standards relating to the ETL process development.
• Actively involved in coordinating and interacting with a large team consisting of customers, business manager, technical leads, Project Manager, Business Analysts, Testers and Developers Onsite/Offshore
• Ability to analyze, diagnose and resolve complex programming independently
• Experienced in developing both Server and Parallel jobs running on a UNIX platform
• A detail oriented, resourceful with expertise in analyzing, deploying and supporting Siebel applications possessing
• Technical experience includes designing Integration Object, Business Service, Data mapping, Unit Testing, Configuration
• Understanding with Relational Database Modeling and Dimensional Modeling Star and Snowflake schema
• Expertise in working with various operational sources like DB2, Oracle, Teradata, SQL Server and Flat Files
• Experience with Unit and System integration testing
• Experience in development of DataStage job sequencers for complex processes
• Ability to work on SAP Environment. Have basic understanding on navigating through SAP environment.
• Experience with various Scheduling tools like Control M, ActiveBatch, Autosys
• Excellent communication and interpersonal skills, problem solving skills, flexible, self-direct and energetic person, ability to work with minimum supervision, and a team player

Technical Qualifications

ETL Tools: IBM DataStage 9.1/8.5/8.1.1, Ascential DataStage 7.5

Database Systems: Oracle, IBM DB2, SQL Server, Netezza

Databases Tools: SQL Loader, SQL Navigator, Squirrel, SQL Developer

Data Modeling Tools: Enterprise Architect 9, Microsoft Visio, TOAD

Scheduling Tools: Control-M, ActiveBatch, Autosys, Tivoli

Versioning Tools: Borland StarTeam, SVN, Ascential Version Control

Application Software: MS Project, MS Office Suite, OpenOffice Suite, MS Visio

Operating System: Windows, UNIX, Linux

Professional Experience

Confidential

Datastage Developer

Responsibilities:

• Worked closely with users, business analysts and team members to understand business requirements and the design of technical solutions. Ensured that specifications and requirements are complete and accurately reflect requirements
• Analyzed and resolved testing and production issues by determining their validity, identifying causes, developing various courses of action to address business requirements, and implementing them
• Performed system analysis, design, coding, testing and implementation for the entire systems development cycle
• Performed review and analysis of the detailed system specifications related to the DataStage ETL and related applications to ensure they appropriately address the business requirements
• Evaluated impact of proposed changes on existing DataStage ETL applications, processes and configurations
• Worked on parallel extender
• Designed and developed the generic ETL utility to load data from MySQL database to Teradata
• Developed, prepared and used test data/cases to verify accuracy and completeness of ETL programs/objects as well as proactively ensuring that unintended issues do not arise as a result of the implementation of developed solutions
• IBM' Succeed for change management: Used to submit request to move code to production environment and other service requests
• Worked on the interface between Siebel other applications to accomplish the business needs.
• Responsible for moving code from one environment to another. DEV to TEST and then to PROD
• Ensured the stable operation of ETL processes in the production environment to agreed service levels

Environment: IBM Infosphere DataStage 9.1/8.5, MySQL, Oracle 11g, BMC Control M, Unix

Confidential

DataStage Consultant Offshore coordinator

Responsibilities:

• Worked on Agile development project for Life Insurance Underwriting Analytics integrating Front office data into data warehouse.
• Actively participated in requirements gathering and analysis, data modeling, ETL design, code review and provide possible solution addressing problems
• Worked closely with Business analysts and Business users to understand the requirements and build the technical specifications.
• Worked on transforming text data to XML and parsed XML data using XML packages
• Created Shared Containers and Local Containers and used them in jobs
• Worked on testing jobs on IBM Information Server 8.5 on sand box
• Worked on Maintenance and Support project enhancing jobs to optimize performance
• Managed and coordinated the offshore team on day to day development tasks with responsibilities such as providing solutions for the issues/troubles/technical difficulties that offshore team has on top of design documents
• Extensively worked on active and passive stages like DB2 connector, Oracle connector, ODBC stage, Pivot, Transformer, Change Capture, Remove duplicates, Lookup, Join, Modify , Complex Flat files CFF , Filter etc.
• Extensively used Control-M scheduler to schedule DataStage jobs
• Worked with internal resources during development phases to ensure appropriate knowledge transfer
• Reviewed and recommended test cases/scenarios to testing teams

Environment: IBM Websphere DataStage and QualityStage 8.1.1/8.5, Oracle 10g, IBM DB2 9.7, Oracle 11g, SQL Server 2005, Squirrel SQL Client, BMC Control-M 7.0, Putty, Borland StarTeam, IBM AIX 6.1, Windows XP, Windows Server 2008 R2 Enterprise

Confidential

DataStage Developer

Responsibilities:

• Primarily responsible for integration data from different geographical regions to Business Data warehouse
• Collaborated with Data Architect to gather requirements, conduct analysis on data and prioritize requests
• Developed new technical specifications from functional specifications
• Worked with Data Modeler to create Source to Target mappings
• Worked on SAP. Extract data from SAP tables and load to flat file. The files are then used for downstream ETL Processing
• Created both Server and Parallel jobs
• Designed, developed job sequences to run multiple jobs
• Performed data profiling using IBM Information Analyzer. Profiling done on flat files
• Responsible for creating unit test cases and appropriately documenting them
• Documented ETL Process following the standard naming conventions, business vocabulary, transformation rules and related enterprise consistency specifications
• Created sequences to sequentially execute the designed jobs. Used Execute Command Activity Stage, Notification Activity Stage, FTP stage, job activity and sequencer stages to implement these sequences
• Used Restartable option to re-run the sequence from the point at which it left off

Environment: IBM InfoSphere DataStage QualityStage 8.5, Business Objects, Putty, SAP R/3, UNIX HP-UX, SQL Developer, Tivoli Workload Scheduler

Confidential

DataStage Consultant

Responsibilities:

• Collaborated with Project lead and Business Analysts to gather requirements, conduct analysis and prioritize requests
• Developed new technical specifications and was involved in updating the current design specifications based on the changes that occurred during development process
• Enhanced existing jobs and addressed production issues
• Worked with Data Modeler to create Source to Target mappings
• Created database scripts for Oracle and worked on setting up TEST environment
• Data Reconciliation Methodology: Reconciled Staging area Oracle with source SAP
• Worked on SAP ECC: Scheduling background jobs and manage loads from SAP to Oracle staging
• Performed impact analysis on DataStage jobs, Oracle Stored Procedures and Packages
• Developed Proof of Concept POC for DataStage to SSIS migration
• Resolved end user reporting problems through collaboration
• Created both Server and Parallel jobs
• Designed, developed job sequences to run multiple jobs

Environment: Ascential DataStage 7.5, Windows 2003 Server, Windows 7, ActiveBatch v6 Admin Scheduler, Oracle 10g, SQL Server, SQL Developer, SAP ECC/ R3, Putty

Confidential

DataStage Developer

Responsibilities:

• Worked with Business Analysts and prepared Technical Specification documents
• Used DataStage Director v7.5 for executing, analyzing logs and scheduling the jobs
• Used different Partitioning methods Auto, Hash, and Entire to ensure an even load across all processors
• Used DB2 API, ODBC and SQL Bulk loader to read and write data into different databases
• Used Data Set stage to manage data within a job to improve the performance of the parallel jobs
• Created jobs using Copy stage rather than transformer stage for simple operations such as renaming columns, dropping columns, changing the order of the columns and for implicit type conversions
• Used Lookup, Join and Merge stages widely in parallel jobs to join two or more data sets
• Used Funnel stage to copy multiple input data sets into a single large data set
• Used Sort stage to remove duplicate rows from the input da sets
• Used different types of Activities to control the flow of execution of jobs
• Used Routine activity to call any routine in the DataStage repository
• Actively participated in the team meetings to gather the business requirements and developing the Specifications
• Created job schedules to automate the ETL process
• Worked with DataStage Designer for importing metadata from repository, new job categories and creating new data elements
• Migrated projects from development to QA and then to PROD environments
• Developed Autosys jobs for scheduling and running the DataStage jobs in Production Environment.
• Responsible for supporting the daily batches
• Responsible for on-call support to the daily batch processes
• Worked as DataStage Administrator to create/modify/delete projects, add DSN entries and cleanup projects and Implemented security among DataStage users and projects

Environment: Ascential DataStage 7.5 Designer, Director, Manager and Administrator, SQL Server 2005, SQL, Autosys 4.5