SUMMARY:

• A seasoned IT professional with solid experience in data management disciplines including analysis, design, architecture, modeling and implementation of databases, data warehouses and ETL processes.
• Superior analytical and communication skills (written, verbal and presentation) providing the ability to coordinate activities between technical and business users as well as external sources and vendors.
• Fluent in data modeling, star schema, snowflake schema, dimensional model, nominal forms and type II data.
• Experience with many types of Datamarts, Datastores, Operational Data Stores (ODS) and hubs.
• Solid experience in Healthcare, Automotive and other industries.
• Currently studying Data Sciences.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center (Source Designer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor), SSIS, DataStage, Talend

Misc Tools: Toad, Embarcardero ER/Studio, Erwin, SQL Management Studio

Databases: Oracle 11g/10g/9i, SQL Server, DB2, Access, Flat Files, Unisys DMSII, MySQL

OLAP Tools: Oracle Discoverer

Hardware & OS: OS/390, Windows, Parity VOS

Software & Languages: MS - Office, SQL, PL/SQL, SQL Loader, Report Writer, Oracle Discoverer, Crystal Reports, Dataflux Data Profiler

Project Management: Microsoft Project

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

Data Engineer

Responsibilities:

• Contractor working in CyberSecurity to integrate acquired hospital systems into the Beaumont Health Systems network.
• Review, modify and test SSIS jobs to in corporate new system requirements.
• Perform parallel testing
• Provide documentation of current systems and their modifications
• Recommend enhancements

Confidential, Troy, MI

Data Engineer

Responsibilities:

• Responsible for all functionality of the Public Safety database including: maintenance, optimization, creation and modification of data tables, stored procedures, triggers and functions.
• Coordinated and designed changes with developers
• Maintained change log utilizing Agile methodology
• Drove data model design using ER/Studio.
• Maintained and modified SSIS and SSAS jobs for Data Analytics
• Interacted with business users and other technical teams throughout the development life-cycle analyzing problems and clearly articulating solutions.

Confidential, Flint, MI

Data Engineer

Responsibilities:

• Transformed business requirements into the design, development and implementation of a new Data Warehouse utilizing MS SQL Server 2014.
• Worked directly with Data Modeler to recommend model changes to improve processing efficiency.
• Embarcadero ER/Studio utilized to review and update models.
• Heavy data analysis and profiling to understand source data and report anomalies.
• Multiple source systems including SQL Server 2008, Oracle and flat file inputs.
• Documented designs, specifications and flow diagrams to assist in development, support and analysis of problems.
• Coded and implemented ETL jobs utilizing Talend for Data Services (version 5.6.1) ETL tool to load Data Warehouse.
• Utilized Collibra Data Governance tool for Master Data Management. Created data dictionaries and documented ETL transformations.
• Gained knowledge of Prescription dispensing services, Patient care and Payor processing.

Confidential, Detroit, MI

Project Manager

Responsibilities:

• Served as the liaison for both McKesson Risk Manager and Vital products. Coordinated data mapping, data extract creation and implementation utilizing Oracle SQL.
• Analyzed and created data profiling to report abnormalities within the data.
• Managed and implemented Call Center changes.
• Managed the implementation and ongoing changes for the Affordability Care Act and Health Michigan Plan programs. Included vendor interaction and file development and sharing.
• Coordinated EDI interactivity with multiple vendors involving EDI 834 and EDI 837 files.
• Created Oracle Ad hoc SQL queries to create miscellaneous reports and files utilizing Toad.
• Performed DBA function to model and implement Oracle data tables and changes.
• Coordinated efforts and documented tasks to migrate from ICD-9 to ICD-10.

Confidential, Troy, MI

Subject Matter Expert Database Systems

Responsibilities:

• ETL Lead primarily responsible for the collection of defense information to support Logistics Analysis by extracting information from various Department of Defense databases and systems including LIW, Army ILAP, OSMIS and FedLog.
• Embarcadero ER/Studio utilized as the data architecture tool to create, maintain and document databases.
• SSIS was utilized to perform the transformation and loading of data into SQL Server 2008 R2 data structures. Created jobs and numerous SQL queries to extract and load data.
• Created cubes for data mining for SSAS.
• Major areas supported include Condition Based Maintenance (CBM) and Commonality.

Confidential, Detroit, MI

ETL Delivery Lead

Responsibilities:

• Worked with Business Units to provide data feeds to customers.
• Utilized Informatica to create ETL workflows and data mappings.
• Created miscellaneous SQL queries to test and validate data.

Confidential, Detroit, MI

Systems Analyst

Responsibilities:

• Worked with the General Motors’ ERP Team to provide an ERP Solution supporting the business intelligence application. Created miscellaneous queries and reports to promote data quality. Integrated security card data into a centralized database.

Confidential, Orlando, FL

Conversion Developer

Responsibilities:

• Developed conversion programs and methodologies to transform existing resort and reservation data into new database structures.
• Analyzed existing source data and worked with Data Architect using ERStudio to interpret the physical and logical data models. Data is stored in DB2 on AS/400.
• Utilized IBM DataStage to create conversion programs and Embarcadero ER Studio for data modeling, DataFlux used to profile data
• Wrote UNIX scripts to create queries to run on the file server.

Confidential, Southfield, MI

Technical Project Lead

Responsibilities:

• Lead the technical migration of all software and processing from an IBM mainframe environment to a UNIX platform utilizing Oracle databases. Analyzed existing source data and worked with Data Base Administrators (DBA) using ERStudio to develop the physical and logical data models. Created SQL Load scripts to load data into Data Marts. Utilized MS-Project to track project progress for various initiatives.
• Wrote PL/SQL code to update and extract data.
• Developed Informatica ETL Mappings to migrate data from mainframe and flat file applications to Oracle applications. The total storage space of the Master Data Warehouse exceeded 13 petabytes.

Confidential, Farmington Hills, MI

Lead Systems Analyst, Interactive Voice Response

Responsibilities:

• Responsible for the implementation of a new call center infrastructure for the Detroit Headquarters relocation including vendor selection, system design through to implementation. Requirements included connectivity to multiple global call centers.
• Responsible for the design, development and on-going support of Call Center Interactive Voice Response (IVR) applications and the progression to an expanded Customer Relationship Management (CRM) system featuring web, e-mail and voice functionality. Utilized CTI interfaces to legacy mainframe systems to route calls to 300 agents nationwide employing remote ACD technology.
• Designed, developed and implemented a new voice system enabling professional staff employees to call and enter assignment information interfacing to legacy systems. This system provided new reporting which resulted in the elimination of two full-time positions contributing to significant cost savings and quicker turnaround.
• Planned, designed and implemented replacement Help Desk application utilizing ACD functionality to facilitate call queuing.
• Maintained and enhanced Human Resource IVR application to allow employees to choose benefit elections as well as to review their current selections. This application interfaced to the corporate Human Resource Oracle based system significantly reducing live agent telephone inquiries and eliminated manual paperwork processes.
• Responsible for the configuration of Windows NT IVR server hardware, Dialogic telephony boards, and Parity VOS development software. Designed their connectivity to NEC 2400 PBX and ACD systems, IBM OS/390 legacy applications, Oracle and Microsoft SQL Server.
• Team Lead for ACD and IVR implementations for Compuware’s Detroit Headquarters site.

Confidential, Troy, MI

Lead Programmer/Analyst

Responsibilities:

• Held multiple positions beginning with Standard Federal Bank as a Programmer/Analyst working up to an I.T. Manager at the Vice President level when Standard Federal Bank was acquired by ABN-AMRO.
• Highlights include the conversion of Standard Federal’s credit card portfolio from a third-party processor to an in-house system which required bringing in the appropriate software and working with vendors to insure that all conversion efforts met user requirements. The system was expanded and improved through the years to include both purchase and authorizations real-time processing.
• Led development and implementation of Interactive Voice Response (IVR) system to allow customers to access account information utilizing both touch tone and voice recognition technology. Assisted in vendor selection and customer marketing initiatives.
• Developed, designed and implemented in-house Online Exception processing system based on user requirements resulting in significant cost savings.
• Implemented a replacement wire transfer system. Responsible for vendor selection, interface design, development and implementation between BTOS client/server and Unisys mainframe systems as well as requirements with the Federal Reserve Bank of Chicago.
• Worked on many bank (approximately 17) acquisitions where I performed due diligence, data mapping, gap analysis and created appropriate programming and methodologies to in corporate acquired institution’s data into existing systems. Played a major role in learning ABN AMRO systems to convert Standard Federal data into the acquiring systems.