Data Specialist Resume Pekin, IL - Hire IT People

SUMMARY:

Overall 20 plus years of experience in Information Technology.
4 years of experience with SSIS dealing with flat files, Excel, and relational databases.
More than 8 years of experience with ETL tool Informatica PowerCenter, data analysis, and design.
Dependable leadership qualities and strong writing skills with attention to detail.
Experienced developer with excellent analytical skills.

TECHNICAL SKILLS:

Databases: SQL Server 2008 & 2012 with TSQL, DB2 V7, Oracle 10G using Toad & Sybase

Programming Languages: ETL (Informatica PowerCenter V5.0, V7.1, V8.1, V8.6, & V9.1)

Visual Studio: 2008 & 2010 for SSIS and SSAS.

Tableau: V8.0, Cognos Impromptu V6.0 & V7.1, Cognos PowerPlay V6.0 & V7.3

Powerplay Transformer: V6.0 & V7.3

CONNX: 11.5 SP1 (Software for loading mainframe data to Sql Server)

Mainframe: PL/1, COBOL, Natural/Adabas

PROFESSIONAL EXPERIENCE:

Confidential, Pekin, IL

Data Specialist

Responsibilities:

Successfully added new DBOP columns to Excel with Pivot tables reports and changed source connections.
Created new Dev Environment to test & resolve issues with Commercial Agency & Personal Lines SSAS cubes.
Resolved issues with MYPI SSIS packages where policies where being dropped due to bad Classification code.
Completed SSIS Current Carrier project which dealt with file extracts of auto policies plus driver/vehicle info from the Data Whse to the client LexisNexis. This involved a one time flat file & daily update files to the client.

Confidential, Vernon Hills, IL

Data Analyst

Responsibilities:

Designed new Tableau reports for branch managers showing different type of loan dollars.
Resolved a 20 million dollars checking account out of balance issue which occurred after running the month end balancing.
Designed and implemented new SSIS packages and stored procedures for the BCU data warehouse.
Added new Calculations to the BCU data warehouse SSAS cubes using MDX logic.

Confidential, Lisle, IL

Senior IT Data Analyst

Responsibilities:

Worked with Informatica administrator to resolve time out issue occurring when uploading customer relation cases to SalesForce.com.
SME for Member Conversion Process which utilizes Infomatica ETL and a DB2 database.
Designed & installed new daily group eligibility file extract.

Confidential, Oakbrook, IL

Informatica ETL Developer

Responsibilities:

Designed, coded and tested ETL mappings for loading Clinical Resource Manager Mart inpatient data.
Modified & tested ETL mappings for database changes dealing with UHC Service Line.

Confidential, North Chicago, IL

Informatica ETL Developer

Responsibilities:

Designed new ETL mappings dealing with Global location numbers using PowerCenter 8.6 with Oracle version 10g database.
Worked with DBA to load China Customer flat file source data using Oracle’s External Loader.
Redesigned and tested Abbott Enterprise System mappings which are used to feed the Customer Master.

Confidential, Deerfield, IL

Informatica ETL Analyst

Responsibilities:

Designed, coded, & tested new ETL mappings for the Applied Business Cost system using Informatica PowerCenter 8.5 with Sql Server 2005 and Oracle version 10G database.
Resolved problems with Oracle hints causing override sql to abend in Informatica Lookup Transformations.
Wrote sql queries using Oracle Sql Developer which were used to determine missing Vendor Rebate dollars.

Confidential, Chicago, IL

Lead ETL Analyst & Cognos Administrator

Responsibilities:

Successfully tested all of the Merchandising Analysis Reporting System (Mars) ETL (35 Workflows) under new release of informatica Powercenter version 8.6.
Improved performance of slow running Cognos Impromptu Catalog reports by adding new indexes to SQL Server database tables thereby reducing run - time from 5 minutes to 30 seconds.
Upgraded Informatica Powercenter from version 5.0 to 7.1, resulting in ETL sessions running 40% faster.
Worked with Merchandising senior managers to develop new Ship Sales Powerplay cube which contained measures such as ship dollars, ship units, returns dollars & return units.