SUMMARY:

InfoSphere (Websphere / Information Analyzer / DataStage / QualityStage) Architect / Developer / Administrator with proven track record of successful implementations in multiple IT projects. Specialization in design, development and deployment of batch and real - time solutions for Confidential (Master Data Management)Data Integration, SAP, ERP (Enterprise Resource Planning), CRM (Customer Relationship Management), Data Warehouse, Data Mart and BI (Business Intelligence) applications utilizing Confidential InfoSphere QualityStageDataStage, Information Analyzer, Business Glossary, Data Architect, FastTrack, Metadata WorkbenchOperations Console, Metadata Asset Manager Administrator, DB2, and Websphere Information Services Director( Confidential ).

EXPERIENCE:

Instructor

Confidential

Responsibilities:

• Taught Virtual Classes for Confidential .
• Taught Confidential courses InfoSphere Advanced QualityStage, Information
• Analyzer Essentials and InfoSphere Information Server Administrative Tasks.

QualityStage and ETL Developer

Confidential

Responsibilities:

• Developed from scratch standardization and duplicate identification of item descriptions using Quality Stage.
• Designed and coding ETL processes.

InfoSphere Lead and Administrator

Confidential

Responsibilities:

• InfoSphere Administrator (9.1.2 and 11.3) for Information Platform/ Confidential projects.
• Created a duplicate analysis of the Vendor and Product data bases utilizing Quality Stage Standardization, Quality Stage name and address Match and
• Data Stage.
• Used Information Analyzer to create over 100 data rules for the Data
• Quality Assessment project.
• Used Business Glossary, Data Architect, Metadata Asset Manager and Fast
• Track to setup and get business lineage for business and technical terms.

InfoSphere - DataStage QualityStage Information Analyzer Lead

Confidential

Responsibilities:

• Took over a forecasting project and used Data Stage to create forecasting spreadsheets for the corporate planners.
• Converted jobs from 7.5 to 8.7 when appropriate to finish the project. Created management reports to compare forecast and sales to budget.
• Developed a duplicate identification report utilizing Quality Stage in a few weeks that an outside service company quoted to take a few months and $350,000.Installed InfoSphere
• 8.7 onto windows 2008 servers. Designed and implemented the administration and infrastructure to support utilizing InfoSphere to complete the ETL for an Oracle R12 Confidential implementation.
• Profiled Oracle i11 tables and other legacy sources and worked with Functional Analysts to gather information to be used for ETL design.
• Created jobs and sequences (scripts) to help in the successful completion of the implementation effort.
• Created multiple duplicate identification and match reports for the stakeholders to use in cleaning up the source data before being loaded into Oracle R12.

InfoSphere lead

Confidential

Responsibilities:

• Designed and implemented the administration and infrastructure to support utilizing InfoSphere to complete the ETL for an SAP implementation.
• Employed procedures, standards and guidelines to insure the efficient and successful completion of the ETL development.
• Completed profiling requirements and worked with
• Functional Analysts to gather information on current legacy systems data quality condition.
• Reviewed mapping requirements and led the team that completed the realization (implementation) stage of the SAP data conversion project.
• Lead developer involved in troubleshooting, training and mentoring new InfoSphere developers.
• Created jobs and sequences (scripts) to help in the successful completion of the implementation effort.
• Created Conceptual, Logical and Physical model for the employee data warehouse using InfoSphere

DataStage developer

Confidential

Responsibilities:

• Designed, coded, tested and implemented DataStage programs to move information from the Commercial
• Customer Data Base to the SalesForce.com data base.
• Designed, coded, tested and implemented DataStage jobs to move all associated tables from the Commercial Data Base to the Results staging data base located on a distributed computing cloud.
• Utilized SQL explorer to verify successful population of the Oracle data base tables.

Quality Stage lead

Confidential

Responsibilities:

• Migrated Confidential RTI application from 7.5 to 8.1.
• Utilized the Confidential Websphere Information Services Director ( Confidential ) to create and deploy WEB services for new 8.1 application.
• Replaced some 7.5 stages (DataStage and QualityStage) with 8.1 when appropriate.
• Suggested changes for application in 8.1 to take advantage of the 8.1 architecture.

InfoSphere Lead

Confidential

Responsibilities:

• QualityStage Investigation stage and Websphere Information Analyzer. Completed the Detailed Business
• Requirements document working with the Stakeholders of the Business Intelligence Reporting project.
• Followed Confidential ’s methodology in every phase of the project. Created the Individual ID data base Data
• Migration ETL design document utilizing Websphere DataStage and QualityStage. Created the project plan, monitored the progress on all tasks while working closely with the data modelers and data base administrators to create the conceptual, logical and physical design of the Individual ID DB2 database.
• Created the QualityStage match specifications while training Confidential employees in QualityStage and
• DataStage concepts and programming.
• Worked closely with the Data Confidential to create ongoing profiling and quality control of the newly created Individual ID data base.

ETL architect, designer and coder

Confidential

Responsibilities:

• Created an Information Quality Strategy document and assisted State Farm associates in the presentation of that document to stakeholders of the enterprise customer master.
• Member of the Business Intelligence (BI)
• Software Services Department. Directed the Enterprise-wide effort to create a Data Quality Improvement process.
• Responsible for designing subsystems utilizing Confidential QualityStage, Trillium TS Discovery, and TS Quality.
• Led the reevaluation of the Enterprise BI data cleansing tools.
• Successfully completed the management of Matching, Key Persistency (Daily Update), Consolidation