Consultant Resume Fort Worth, Texas - Hire IT People

SUMMARY:

Consultant

Confidential, Fort Worth, Texas

Assisted Data Warehouse Group with conversion of legacy data into Oracle data marts for Eclipse.
Ad - hoc development to assist integrating legacy systems with new ERP - Eclipse implementation.
Modification to legacy code as required for application enhancement or production support fixes.
Generated new ETL process to duplicate standards for 810 - Invoices on the legacy system.

Confidential

Consultant - EDI/ETL

Solo project to generate EDI 811 invoice data files for clients. For this data conversion/modeling I functioned in multiple SDLC roles.
As a BA, I ensured all business requirements were met from beginning to end.
Next was the application development, utilized Unix Shell scripts, Oracle SQL for file creation.
Functioned in DBA role to handle the data modeling (schema setup, index, view, and packages)

Consultant

Confidential, Fort Worth, Texas

Worked on proof of concept project tying PDX application software with Kaiser Permanente propriety requirements.
Functioned in QA role and Data Warehousing conversion SME. Overall goal was to in corporate PDX pharmacy application into KP’s processing and populating data into schema’s for data mart reporting - healthcare and financial systems specifically.

Confidential

Consultant - EDI/ETL

Finished several stalled projects relating to data conversion between internal departments.
Developed automation procedures to handle processing of CPIMARML module of Health Plan (auto open and close functionality). Utilized SQL Server DTS packages, as well as command line batch processing incorporating SQL code.
Developed ETL integration interface between Health Plan and new claims system (HSP) for dealing with authorizations for health care. Recreated existing manual process in VB and Windows batch scripts.
Developed data conversion solution for OPPE reporting project which fulfilled several Federal/State agency reporting requirements. SQL Server SSIS packages were generated as well as new jobs under the SQL Job Agent scheduler.
Developed ETL integration solutions to the new Care Management system (Acuity).
Worked as SME on 2 projects with several departments & vendors regarding upgrade to EDI 5010 for health-care transactions and the upgrade on ICD10 codes within those transactions.
Developed integration solution to handle printing issues for NCR - Kiosk check-in procedures.
Provided training and mentoring as required for continued production support of each project.