Data Management, Architecture, Modeling and Data Governanace.
Resume:
Mike Ladochi
Troy, MI *****
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 processed.
Superior 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, nominal forms and type II data.
Solid experience in Healthcare, Automotive and other industries.
INVENTORY OF 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
ML Solutions/Beaumont Health Systems, Troy, MI
Data Engineer 2/2017 – present
Contractor working in CyberSecurity to integrate acquired hospital systems into the Beaumont Health Systems network.
Review, modify and test SSIS jobs to incorporate to new system requirements.
Perform parallel testing
Provide documentation of current systems and their modifications
Tyler Technologies, Troy, MI
Data Engineer 10/2015 – 2/2017
Responsible for all functionality of the Public Safety database including: maintenance, optimization, creation and modification of data tables, stored procedures and functions.
Coordinated and designed changes with developers
Maintained change log utilizing Agile methodology
Implemented data modeling using ER/Studio.
Maintained and modified SSIS and SSAS jobs for Data Analytics
ARROW STRATEGIES/DIPLOMAT PHARMACY, Flint, MI
Data Engineer 12/2014 – 9/2015
Assisting in the design, development and implementation of a new Data Warehouse utilizing MS SQL Server 2014.
Work 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.
Created written specifications for data mappings.
Coded and implemented ETL jobs utilizing Talend for Data Services (version 5.6.1) ETL tool to load Data Warehouse.
Utilizing Collibra Data Governance tool for Master Data Management.
Gained knowledge of Prescription dispensing services, Patient care and Payor processing.
TOTAL HEALTH CARE, Detroit, MI. 9/2013 – 10/2014
I.T. Project Manager
Responsible for the coordination of multiple of I.T. projects amongst various teams within the organization including
Serving as the liaison for both McKesson Risk Manager and Vital products. Coordinated data mapping, extract creation and implementation.
Analyzed and created data profiling to report abnormalities within the data.
Oversee and implement Call Center changes.
Managed the implementation and ongoing changes for the Affordability Care Act and Health Michigan Plan programs. Includes vendor interaction and file development and sharing.
Coordinating EDI interactivity with multiple vendors involving EDI 834 and EDI 837 files.
Ad hoc SQL queries to create miscellaneous reports and files utilizing Toad.
Performed DBA function to model and implement Oracle data tables and changes.
Coordinate efforts and documented tasks to migrate from ICD-9 to ICD-10.
Research and analysis of outstanding issues.
CONTROL POINT CORPORATION, Troy, MI. 5/2011 – 8/2013
Subject Matter Expert – Database Systems
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.
JAWOOD AT BLUE CROSS BLUE SHIELD OF MICHIGAN, Detroit, MI 6/2010-5/2011
ETL Delivery Lead
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.
COMPUWARE CORPORATION, Detroit, MI 12/2009-6/2010
Systems Analyst
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.
TEKPARTNERS AT WALT DISNEY WORLD, Orlando, FL 10/2008-7/2009
Conversion Developer
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.
R.L. POLK & CO., Southfield, MI 10/2004-3/2008
Technical Project Lead
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.
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.
COMPUWARE CORPORATION, Farmington Hills, MI 1/2000-10/2004
Lead Systems Analyst, Interactive Voice Response (IVR) Systems
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.
STANDARD FEDERAL BANK, Troy, MI 7/1986-1/2000
Subsidiary of ABN AMRO
Lead Technical Specialist, Branch Automation Systems (1999)
Application Group Manager and Conversion Specialist (1996)
Special Projects Manager (1993)
Lead Programmer/Analyst (1986 - 1987)
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 incorporate 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.
EDUCATION
BA, Business Administration, major: Finance
Walsh College of Accountancy and Business Administration
ADDITIONAL TRAINING
Data Warehousing Concepts
Introduction to PL/SQL, Introduction to SQL (Oracle)
RDBMS Database Principles
SQL for the Windows Environment
Viewing and understanding XML
Six Sigma Green Belt certification - Global Productivity Solutions
Contact this candidate