PROFESSIONAL PROFILE

I have extensive experience in business and system analysis across multiple platforms using the full software development life cycle. I have worked in the role of Data Warehouse Specialist, ETL developer and Informatica administrator requiring subject matter expertise when dealing with mainframe sources used in loading to business intelligence Oracle tables. In the last two years, I have provided production support to various subject areas including an external lab pharmacy system which was an internet source, Pharmacy and external pharmacy claims systems whose source reside on the mainframe. In a production support role, I was expected to react quickly to problem resolution to daily, weekly, and monthly processing cycles. Over this period, I have established an exemplary record of providing successful system support and delivering business value for mid-level to large business intelligence applications. While in the ETL development role, I helped build a BHI (Blue Health Intelligence) system for Blue Cross Blue Shield of Michigan.

EDUCATION

Master's degree - Software Engineering
Bachelors Accounting/Data Processing
Associates Degree

FUNCTIONAL QUALIFICATIONS
Business applications: External Lab Value, Customer, Pharmacy (Medco/MedImpact), Pharmacy Carve out
Microsoft Tools: XP, 2000, NT, MS Excel, Word, Project, PowerPoint, VISIO
Platform/Environment: PC/LAN, Oracle 10g, UNIX, IE 6.0
Data Manipulation/Editor: WS-FTPRO, SQL*Plus, Toad

Description Years

Informatica PowerCenter development 4
Informatica PowerCenter 8.1.1 4
Unix (Linux) shell scripts 2
Oracle 1
Complex SQL 2
Strong written and verbal communication skills 20
Experience in developing/executing unit and system
test plans 10

Preferred Skills:
Informatica Performance tuning 1
Experience with OBIEE (Oracle Bus Int Ent Ed.) 4
Experience with SAP and PowerExchange for SAP 4

Data Warehouse Specialist, Confidential,Detroit, Michigan, (Employee)
Jan 2002 to March 2009

• Developed Informatica mappings for BHI (Business Health Intelligence) systems. to load medical claims data from the source to various staging levels like CRF, IDS (Acquire and Manage Framework) and from staging tables to the respective Dimensions and Fact table of EDW.
• Application SME (subject matter expertise) to Medical claims implementation.
• Application SME (subject matter expertise) to Pharmacy claims implementation.
• Provided expertise with the Informatica Power Exchange process for several subject matter areas such as medical claims, membership, and provider systems.
• Provided expertise during the Informatica power exchange upgrade to 8.6.
• Migrated 180+ mappings to Informatica ETL tool as part of my duties as Informatica Administrator.
• Set up accounts for new contractors and employee using Informatica Repository manager as part of my duties as Informatica Administrator.
• During weekly processing, I was required to backup and reset the Informatica server which eventually became an automated process.
• Studied the existing jobs in OSCAR DB2 mainframe applications and helped create business requirements documentation for critical medical claims financial balancing to the general ledger system.

Environment:

• Informatica Power Center version(s) 8
• Informatica Power Exchange
• Unix
• TOAD
• SQLPLUS
• COBOL
• Endevor
• Microsoft: Excel, Powerpoint, VISIO

• Developed DB2 claims tables for OSCAR (Outcome Support Cost Allocation Reporting) system.
• Created DB2 programs to load/insert and delete rows from the DB2 tables as part of their monthly Medical claims maintenance process.
• Documented the design flow of the monthly Medical claims maintenance process.
• Developed DB2 claims tables for OSCAR (Outcome Support Cost Allocation Reporting) system.
• Provided assistance to the DBA (database administrator) and DA (data administrator) in designing and building the DB2 environmen(s).
• Created the business data requirements to the programmers that was crucial to the development of OSCAR system.

Environment:

• Informatica Power Center version(s) 8
• Informatica Power Exchange version 8.6
• Unix
• TOAD
• SQLPLUS
• COBOL
• Endevor
• Microsoft: Excel, Powerpoint, VISIO

Programmer Analyst/Team Leader,Confidential,Detroit, Michigan, Dec 1997 - May 1999, Contracted through Ajilon.

• Worked as production support person for Stroh's nationwide mainframe inventory system.
• Assumed the Team leader position and was responsible for all phases of the Stroh's inventory system.
• Collaborated with Unix/Oracle developers in analysis, design, specifications, coding, testing of new system to replace the mainframe system.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces.
• Received introduction to Unix/Oracle based operating system during a system redesign during which I wrote some shell scripts and \'C\' programs.

Environment:

• VI Editor
• Unix
• DB2
• COBOL
• Panvalet
• Microsoft: Excel, Powerpoint, VISIO

Programmer Analyst, Confidential,Aug 1995 to May 1999, (Employee)

• Application SME (subject matter expertise) to Kmart's Inventory system.
• Responsibilities included the analysis, design, documentation, specing, flowcharting, coding, testing, debugging, maintenance and support of the Inventory replenishment system using the Inforem package.
• Provided production support expertise to 24 x 7 inventory system(s).
• Developed inventory subroutine to collect statistical information on in-store product(s) such as price, weight, and sku number.

Environment:

• DB2
• COBOL
• Panvalet
• Microsoft: Excel, Powerpoint, VISIO

Programmer Analyst, Confidential, (Troy, Michigan), Mar 1994 to Aug 1995 (Employee)

• Application SME (subject matter expertise) to Handleman Inventory system.
• Responsibilities included the analysis, design, documentation, specing, flowcharting, coding, testing, debugging, maintenance and support of the Inventory replenishment system using the Inforem package.
• Tested and validated new software coding developed by previous programming team.
• Provided production support expertise to 24 x 7 inventory system(s).

Environment:

• Datacomm
• COBOL
• Librarian