DataStage Developer Resume

Title
DataStage Developer

Primary Skills
IBM Infosphere suite 8.1,DataStage 7.5x/7.1

Location
US-TX-Houston (will consider relocating)

Posted
Sep-29-09


PROFESSIONAL SUMMARY
Over 5 years career reflecting experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems that includes ETL Tools like IBM Infosphere DataStage 8.1, DataStage 7.1 and 7.5x. Extensive domain experience in Credit/Risk, Supply & Trading for Banking, Oil and Gas industries and has knowledge in Finance.

? IBM Certified Solution Developer -- WebSphere IIS DataStage Enterprise Edition V7.5
? Awarded ROLL OF HONOR from Satyam Learning Center for DataStage Competency excellence.
? Has experience in Migration, Integration, Development and Implementation of ETL Systems using strong project management methodologies by combining technical and leadership skills effectively with focus on process efficiency and productivity.
? Extensive experience in Data Modeling [Star Schema], multi-dimensional business analytics, data architecture, data migration with multiple environments (OS/databases) & large data warehouse environments.
? Efficient in all phases of the development lifecycle, coherent with Performance Tuning, Unit Testing, experience in design and implementation of Server and Parallel jobs including Job Sequencers.
? Understands project work plans and has developed/participated in the development of work plans/schedules.
? Excellent written and verbal communication skills, ability to communicate across a diverse range of internal and external contacts.
? Aptitude to effectively adapt to rapidly changing technologies and methodologies and apply them to technological and/or business needs.

TECHNICAL SKILLS:

Tools & Utilities: IBM Infosphere suite 8.1, DataStage 7.5x/7.

Databases: Oracle 9i and SQL Server 2005.

Operating Systems: IBM AIX 5.2/5.1, HP-UX V11.0, Windows XP/NT/2000/98

Languages: C, C++, Visual Basic, SQL, PL/SQL

Version Controls: MS Source Safe and DataStage Version Control

EDUCATION:

Masters in Computer Applications (MCA) in SCSVMV University, India.

PROJECTS PROFILE:

Mahindra Satyam
Sept 2006 -- Till Date

1) Chevron Corporation, Houston, USA
Dec'06 -- Till Date

CHEVRON is one of the world's largest integrated energy companies and it has Business activities in more than 100 countries. Chevron is engaged in every aspect of the oil and natural gas industry, including exploration and production, manufacturing and also investing in renewable and advanced technologies.

Module 1: ProjectOne
August 2009 -- Till date
Role: ETL Lead and Onsite Coordinator
Technology: DataStage 7.5.2, Microsoft SQL 2005, DB2 and JD Edwards.

ProjectOne is part of Chevron Oronite Company, LLC which handles this project with huge data migration, decommissioning and other development activities. This particular module is to migrate the data from DB2 to SQL Server 2005.

Contribution:

? Part of all System Design Discussions related to the interfaces.
? Installed DataStage 7.5.2 client components.
? Overall responsibility for the Engagement execution.
? Responsible for Preparation of Design Documents / Test Case Specifications / Performance Review and Coding and getting it signed off from client.
? Plan and conduct the conference calls from off-shore.
? Plan and distribute the work among the off-shore team mates.
? Plan, Co-ordinate and Arrange Knowledge Transfer from our client - Aon to current team members to understand the Application.
? Experience with meta-data based ETL processes and the design and implementation of meta-data
? Executed all data migration programs and loads, verifying the data has been migrated to the satisfaction.

Module 2: ATLAS
March 2009 -- July 2009
Role: ETL Lead and Onsite Coordinator
Technology: IBM Infosphere DataStage 8.1, Microsoft SQL 2005, Flat Files, Linux and Visual Source Safe.

Global Analytics & Risk Metrics (GARM) will create a single common data repository and platform to view and analyze trading, inventory and risk data globally. It will enable trading, logistics, risk control, credit, and other employee groups to make more informed decisions, manage market risk, and support business revenue growth.

Contribution:

? Part of all System Design Discussions related to the interfaces.
? Installed IBM Infosphere DataStage 8.1 client components.
? Experience in data read/write, filtering and merging, data transformations, error handling, process design and logging.
? Experience in Data Modeling as well as reverse engineering using MS Visio.
? Evaluate, redesign and modify existing Job logic to improve overall system performance.
? Responsible for requirement gathering and Preparation of Detail Technical document.
? Overall responsibility for the Engagement execution.
? Onsite-Offshore Co-ordination.

Module 3: LYNX
Dec 2006 -- March 2009
Role: ETL Developer
Technology: DataStage 7.5.2 Enterprise Edition, Microsoft SQL 2005, XML Files, Flat Files, Linux and Visual Source Safe.

The Information Architecture (IA) project is a foundational element of the Lynx project. The purpose of the IA project is to support Supply Chain Management (SCM) consisting of data management, integration of systems & tools, and reporting functionality

Contribution:

? Experience contributing to project task prioritization, planning, estimating, work assignment, & quality assurance at every stage of a project.
? Evaluate, redesign and modify existing Job logic to improve overall system performance.
? Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse data marts.
? Used different types of Stages like Sequential File, Funnel, Copy, Join, Lookup, Merge, Transformer, RDBMS and ODBC for developing different Jobs.
? Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts.
? Understanding the business rules completely as per the Functional Spec, Technical Spec and implements the data transformation methodology.
? Major Accomplishments: Created a WaitforFile Activity jobs, Interface Notification, within 3 week window after technical proof of concept initiatives.

2) Barclays Bank, UK
Sep 2006 -- Nov 2006
Role: ETL Developer
Technology: DataStage 7.5, Oracle 9i and Linux.

The project involved the outsourcing of HR Analytics to Barclays Bank. Responsibilities included day-to-day support for all users & production support in DataStage.

Contribution:

? Designed and fine tuned DataStage PX jobs for loading Stock Ledger history with performance as a key factor.
? Designed and developed DataStage Shared Contained jobs for all the common modules (e.g. generation of surrogate key) to allow reusability of code.
? Designed and developed common modules for error checking (e.g. to check if the reject records output file is empty and to check if there are duplicate natural keys in a given table)
? Designed and developed common modules for error checking (e.g. to check if the reject records output file is empty and to check if there are duplicate natural keys in a given table)
TAKE Solutions, INDIA
April 2004 -- Aug 2006

1) Web Pay
May 2005 -- July 2006
Role: ETL Developer
Technology: DataStage 7.5, Teradata V2R4, Erwin and Linux

Design of ETL part of a data integration team that led conversion of an existing payroll system to a web based automated system for TAKE Solutions. Conduct business analysis and document requirements for unifying the interface and data structure of the web pay applications.

Contribution:

? Responsible for definition, design, development and testing of processes and programs necessary to extract the data from client's operational databases, transform and load into Data warehouse.
? Used DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
? Used DataStage Director to schedule running the server jobs, monitoring scheduling and validating its components.
? Used DataStage Manager for managing DataStage repository (view and edit), define custom routines & transforms, Import and export items between different DataStage systems or exchange metadata with other data warehousing tools.
? Experienced tester capable of developing and executing integrated system test plans.




2) Mastoura Contracting Company, Rahima, Saudi Arabia
June 2004 -- March 2005
Role: ETL Developer
Technology: DataStage 7.1, SQL Server 2000 and Windows XP Pro

Business Avenues Project for TAKE Solutions:

Mastoura Contracting Company, Rahima, Saudi Arabia was looking for new business avenues, wanting to increase customer base and attract more investments. A system has been developed to provide clear picture of the strengths of the company in order to take effective decisions and build good customer relationship.

Contribution:

? Created source to target mapping documents from staging area to ODS and from ODS to various Data Warehouse.
? Creating validation and loading the rejected records into the relevant tables and send to the users for re-submitting.
? Mapped the data elements from the old ODS to the new one designed.
? Understanding the business rules completely as per the Functional Spec, Technical Spec and implements the data transformation methodology.

PERSONAL PARTICULARS:

? Current Location in USA: Houston, Texas
? Immigration Status: Authorized to work on H1B Visa


Reference will be provided upon request

Certifications
IBM Certified Solution Developer -- WebSphere IIS DataStage Enterprise Edition V7.5


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Houston, TX | Resumes in Texas

View other DataStage Developer resumes