DAVIDSON MUGAMBI.

eb6ejz@r.postjobfree.com

Phone Number: +1-908-***-****

Professional Summary

• 6 years of IT experience, with 5 years in Design, Development and Implementation of Data Warehouses as an Datastage developer. Worked in all the phases of Data Warehousing life cycle for Data Warehouses and Data marts using Data Stage (Ver8.5/8.1/7.5.x), designing and developing jobs using DataStage Designer, DataStage Manager, DataStage Director and DataStage Administrator

• Experience in working with large data warehouses, mapping and extracting data from legacy systems, TeraData/Informix/Oracle/DB2/SQL Server databases

• Worked extensively on different stages like Transformer, Aggregator, Merge, Join, Copy, Lookup, Lookup File set, Filter, Change Capture, Oracle Enterprise, Column Generator, Dataset stages for Data cleansing and Data Transformation

• Experience in Datastage technologies

• Strong experience in Oracle 11g/10g/9i/8i, UDB DB2 7.x, SQL Server 6.5/7.0, MS Access 7.0/97/2000, Sybase, Teradata, and PL/SQL

• Expert in coding SQL, PL/SQL stored procedures, Triggers and Packages

• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema

• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing

• Knowledge of UNIX and developed UNIX shell scripts

• Familiarity in incorporation of various data sources like Oracle, Teradata, Informix, MS SQL Server, and DB2, XML and Flat files into the DataStage

• Actively involved in the Complete Project Life Cycle from user requirements, Analysis, Design, Development and implementation

• Experience providing On call Production Support 24/7 Monitoring Datastage Jobs, Business Objects reports, responsible for Scheduled Loads and Servers

• Excellent communication skills coupled with ability to mentor on site resources effectively

Technical skills

ETL Tools IBM and Ascential Datastage (Enterprise Edition) 8.5/8.1/7.5

Databases Oracle 11g/10g/9i/8i/7i, SQL Server, MS-access, DB2

Languages PL/SQL, Shell script, C, C++, XML

Data modeling tools Erwin 4.1

Tools SQL Plus, SQL Loader, MS Office, Designer 2000

Operating system Windows NT/2000/2003, IBM AIX 4.1, Solaris 2.8/Sun OS5.8

Hardware IBM PC, IBM Mainframes, HP 20

PROFESSIONAL EXPERIENCE

IMS Health/Novartis, East Hanover, NJ May 2011– To Date

DataStage Developer:

IMS Health is an end-to-end solutions provider integrating unparalleled information, analytics, consulting and services thus playing a central role in supporting high-quality, cost-effective healthcare in North America, Europe and Asia.

Our team was involved in Design, Development and Implementation of Integrated Data Store which contained data pertaining to pharmaceutical products, pharmacies, Hospitals, Health Insurance plans and sales. It will at the same time provide automatically generated reports to the salespeople to facilitate their tasks and give an account of the entire daily, weekly and monthly to other end user and executives.

Responsibilities:

• Designed DataStage jobs for the extraction, transformation and loading of data into the IDS Data warehouses.

• Identified source systems, their connectivity, the related tables and fields and ensured that data was appropriate for mapping.

• Generated Surrogate ID’s for the dimensions in the fact table for indexing and faster access of data.

• Used Stage Variables, Transforms, Subroutines of DataStage Jobs.

• Worked with parallel job message handler for demoting or removing warning messages from the job log.

• Imported and exported repositories across different servers using DataStage Manager.

• Worked with offshore teams dealing with production requirements.

• Extensively used the Sequential File stage, Complex Flat File Stage, Hashed File Stage, Modify, DataSet, Filter, Funnel, Join, Lookup, Merge, Copy, Aggregator, and Change Capture during ETL development.

• Simplified the existing transformer logic in the jobs to make them perform better.

• Participated in the review of Technical, Business Transformation Requirements Documentation.

• Created job sequences and job schedules to automate the ETL process.

• Worked with DataStages Teradata connector, Teradata Enterprise and Teradata Multiload.

• Documented the changes made to the jobs, the comparative performances of the old and new jobs and the test plan that was used to test the jobs.

Environment:

IBM Info Sphere DataStage 8.5: Designer, Director, Administrator. Windows XP, Oracle 11g, SQL Server, SQL *Plus, Teradata, DB2, Korn Shell Scripts, Toad,

American International Group [AIG], Fort Worth, TX Aug 2009 – April 2011

DataStage Developer:

American International Group, Inc. (AIG) is a leading international insurance organization serving customers in more than 130 countries. AIG companies serve commercial, institutional and individual customers through one of the most extensive worldwide property casualty networks of any insurer. In addition, AIG companies are leading providers of life insurance and retirement services in the United States.

Our team was involved in Design, Development and Implementation of Integrated Data Store [IDS] and Historical Data Store [HDS] which contained data pertaining to Automobile Insurance with Policy, Quote, Claims and Receivables as dimensions.

Responsibilities:

• Designed DataStage jobs for the extraction, transformation and loading of data into the IDS and HDS Data warehouses.

• Identified source systems, their connectivity, the related tables and fields and ensured that data was appropriate for mapping.

• Generated Surrogate ID’s for the dimensions in the fact table for indexing and faster access of data.

• Used Stage Variables, Transforms, Subroutines of DataStage Jobs.

• Worked with parallel job message handler for demoting or removing warning messages from the job log.

• Imported and exported repositories across different servers using DataStage Manager.

• Participated in Design and implementation of Star and Snowflake schemas.

• Worked with offshore teams dealing with production requirements.

• Improved job performance by gathering the performance statistics of the jobs in the production server using DataStage Director.

• Extensively used the Sequential File stage, Complex Flat File Stage, Hashed File Stage, Modify, DataSet, Filter, Funnel, Join, Lookup, Merge, Copy, Aggregator, and Change Capture during ETL development.

• Simplified the existing transformer logic in the jobs to make them perform better.

• Worked on different partitioning methods (Round Robin, Entire, Hash by Field, Modulus and Range) and collection methods (Round Robin, Order and Sort Merge) in processing sequential data.

• Participated in the review of Technical, Business Transformation Requirements Documentation.

• Trouble-shoot the designed jobs using the DataStage Debugger.

• Created job sequences and job schedules to automate the ETL process using Autosys.

• Worked with DataStages Teradata connector, Teradata Enterprise and Teradata Multiload.

• Documented the changes made to the jobs, the comparative performances of the old and new jobs and the test plan that was used to test the jobs.

• Monitored and resolved the ticketing issues that arouse during the implementation of the jobs.

• Used UNIX shell scripts and commands to run the jobs.

Environment:

IBM Info Sphere DataStage 8.1: Designer, Director, Administrator, Information Analyzer, Windows XP, UNIX, Oracle 10g, SQL *Plus, Teradata, Toad, ODBC, DB2, Autosys, Erwin 4.5.2.

Aetna Better Health, Chicago, IL Jul 2007 - Jul 2009

Datastage Developer.

Aetna Better Health works with people in an integrated managed care organization in Illinois is among the largest health care organization in the United States. The Health Plan and Hospitals operate under state and federal non-profit tax status, while the Medical Groups operate as for-profit partnerships or professional corporations in their respective regions.

The project was to design, develop and maintain a data warehouse for their vendor's data, internal reference data and work with their DBA to ensure that the physical build adheres to the business model blueprint.

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.

• Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.

• Used Quality Stage to check the data quality of the source system prior to ETL process.

• Worked closely with DBA's to develop dimensional model using Erwin and created the physical model using Forward Engineering.

• Worked with Datastage Administrator for creating projects, defining the hierarchy of users and their access.

• Defined granularity, aggregation and partition required at target database.

• Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.

• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the SQL Server database.

• Imported table/file definitions into the Datastage repository.

• Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign DataStage jobs for performing the required integration.

• Extensively used DataStage Tools like Infosphere DataStage Designer, Infosphere DataStage Director for developing jobs and to view log files for execution errors.

• Controlled jobs execution using sequencer, used notification activity to send email alerts.

• Ensured that the data integration design aligns with the established information standards.

• Used Aggregator stages to sum the key performance indicators used in decision support systems.

• Scheduled job runs using DataStage director, and used DataStage director for debugging and testing.

• Created shared containers to simplify job design.

• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.

• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.

Environment:

DataStage 7.5.1 Enterprise Edition, Quality Stage, Flat files, Oracle 9i, SQL Server -2005/2008, Erwin 4.2, PL/SQL, UNIX, Windows NT/XP

Contact this candidate