IDQ Developer / Data Analyst

Elizabeth Nicodemus

**** ********** ****, ********, ******* 47201

812-***-**** : ***********@*****.***

Summary

Starting an IT career in 1992, I've gone from simple data entry, through network

administration to find my strengths in data analysis, database development and

turning business needs into usable solutions. I've worked with global HR and

customer data in the manufacturing, distribution, warehousing, and

pharmaceutical industries. Most recently, I've supported MDM initiatives using

Oracle databases and Informatica Data Quality. I have a proven ability to pick

up new tools quickly and translate the needs of the business into solutions that

exceeds expectations.

Technology Highlights

Oracle SQL and PL/SQL 7 - 11g Unix/Linux

Informatica Data Quality 8 - TOAD 10

9.5 Remedy

IBM Information Server/WCC 7 MS Access 1.0-2003

Business Objects 5-6.2

Experience

Senior Technical Specialist - January 2007 to April 2013

KPIT Cummins/Cummins Engine - Columbus Indiana

Sole developer building a process in IDQ for cleansing and migrating global

customer data from Oracle 11i into 12i.

Work with the project team and data owner to gather requirements.

Analyze profiling results and make recommendations for improvements.

Build profiling, cleansing and validation plans.

Document the process and train production support on how to run the data on

demand.

Sole developer working with the North American Distributors to develop a process

for on-going data cleansing in preparation for a data migration.

Work closely with the distributors to identify problem areas, analyzing their

data and existing system limitations.

Create a weekly process presenting cleansing, validation and duplicate suspect

results to all the distributors.

Provide on-going support for data questions from the distributors.

Create unix scripts to run the process weekly via cron or Appworx.

Sole developer working with unstructured global customer data for the Engine

Business Unit.

Provide profiling, cleansing and validation reports in preparation for a data

migration.

Develop many custom rules for parsing and for other anomalies due to the source

mainframe limitations.

Build a re-usable staging area in Oracle for loading data from multiple source

systems using template tables for profiling and cleansing in IDQ or

QualityStage.

Primary analyst for installing, configuring and maintaining IBM Websphere

QualityStage and Customer Center on Solaris Websphere and Oracle servers.

Provide one-off profiling, validation and duplicate suspect reports to various

business areas such was Warranty and Global Supplier Management.

Build an Access Database to consolidate engine error data from spreadsheets and

text file logs for Six Sigma analysis.

Attended Informatica Data Quality version 9 training with Informatica in Reston

VA.

Completed IBM consultant mentorship on Websphere Customer Center at IBM in

Toronto.

Systems Analyst - October 2001 to January 2007

Eli Lilly & Company - Indianapolis Indiana

Major projects

Sole analyst working with PriceWaterhouseCoopers to implement Resource Expatriate

Management software.

Sole analyst working with GMAC to outsource Domestic Relocation.

Project team member working with MulleinTBG to outsource Executive Deferred Comp.

Project team member for implementing a new global Merit Delivery system. Primary

emphasis on unit and integration testing.

Build and maintain an HR Data Warehouse in Oracle containing HR data that was not

migrated to SAP. Build universes and reports for Payroll, Finance and Recruiting

to provide access to the data. Create an adhoc report structure.

Sole analyst in HRIT for the Business Objects upgrade from 5.1.2 to 6.2 and

migration of reports to Webi.

Analyze and fix interfaces to all Access Databases used in HR when implementing

SAP HR module.

Attended training for Business Object Administrator, Universe Developer, Advanced

Developer, Report Writer and Advanced Report Writer for version 5 as well as

Informatica PowerCenter 6.5.

Ongoing support

Provide support of all systems used by Global Relocation.

Maintain the weekly load of data from PeopleSoft into the HR Data Warehouse.

Provide Business Objects support to Human Resources.

Sole analyst providing system support for various areas such as Global Security,

Tuition Reimbursement, on-line surveys using 2Way, Merit Delivery, Lilly Daycare

Wait List.

Learn all HR systems with helpdesk support. Provide tier one and in some cases

tier two support for all HR systems as a temporary fill in for 6 months.

Self-Employed IT Professional 1099 - February 1997 to October 2001

Columbus/Bloomington area

Consult at Cummins Engine, Arvin Sango, Woods and Grooms Insurance on various

Access database projects.

Consult on the JobBOSS software at Griner Engineering in Bloomington IN.

Customize the user interface as well as create a custom database for storing data

specific to Griner. Create a daily spreadsheet dashboard for the owner, John

Griner, to see overviews of various aspects of his business.

Network Administrator - February 1992 to November 1996

Hahn Systems - Indianapolis Indiana

Write and maintain a product pricing Access DB for the sales force in the field.

Deploy and support 60 laptops to the field sales force.

Maintain pricing data for all products.

Install and configure a new Windows NT network and provide remote access to the

field.

Create and place all advertising.

Education

Bachelor of Arts: Industrial Design, 1990

Purdue University - West Lafayette, Indiana, United States

Contact this candidate