Michael Vlk Email & Phone Number

Brentwood, Tn

• Key team member for supporting CMS reporting for Meaningful Use. Provided support for existing 2013 processes and heavily involved in analysis and development for 2014. Created a detailed reverse engineered analysis of existing systems to aid design for a new Teradata / MicroStrategy solution.• Development of code to move data from MS SQL based clinical applications to a new Teradata Data Warehouse. Includes creation of TSQL scripts to pull data into staging and BTEQ scripts to load to Teradata tables.

Brentwood, Tn

• Support existing systems to move and present data between multiple financial and clinical systems.• Maintenance of existing ETL processes utilizing MS SQL 2008, SSIS and SSRS. Systems include the use of complex TSQL stored procedures and Change Data Capture capabilities.• Direct interaction with clients and end users for troubleshooting and needs analysis.

Brentwood, Tn

• Developed and prioritized solutions for operational changes needed to support both internal and external customers with a strong focus on overall strategy for company-wide solutions.• Designed systems, policies and procedures in coordination with the infrastructure team for an environment that included both physical systems and a large cloud presence in AWS.• Served as operational and development representative for all new/existing client implementations and meetings to set expectations and insure deliverables are met.• Mentored junior and senior level staff for leadership roles and professional development.

• Coordinated ETL and design efforts with Data Warehouse group for standardization according to data governance and master data management initiatives. • Worked with Application Development team to coordinate data needs and provide guidance for process improvements and enhancements.• Designed internal data systems; including architecture of reporting, rules engine, campaigns, population management, patient activity and other mission critical functions with an emphasis placed on scalability and code reusability through stored procedures and functions to maximize limited resources.• Recommended and implemented third party tools to enhance development; using products such as Red Gate SQL Toolbelt, Pragmatics Works Task Factory and BI xPress and AdeptSQL Diff.

• Created an automated, multi-step ETL process to move multiple disparate data sources into our internal standard specification with integrated quality metrics to ensure problems could be detected and corrected in each component. • Designed and developed a dynamic claims adjudication process to identify and handle multiple claim issues to be handled during the ETL process; such as duplicates, reversals, adjustments and other common issues, providing transformed data for other internal systems.• Utilized MS Access to create additional tools to monitor and manage ETL process workflow and allow multiple persons to participate, monitor and validate the data throughout the process.• Created and maintained a production schedule to ensure all client data was processed in a timely manner and distributed to all downstream systems to meet contractual obligations and project schedules.

• Designed and developed of an initial ETL process to bring in Patient, Pharmacy and Medical Claim Data from multiple data sources. • Managed and executed the production schedule for all incoming files. • Researched and resolved all data issues.

• Provided direction, business knowledge and technical support to an offshore Indian company as the Data Lead and Team Co-Lead for an offshore pilot initiative to test the feasibility of offshore contractors for internal development projects; which included a protracted onsite visit to provide direct training and education.• Developed an innovative, dynamic forms-based engine for the Deloitte Client Acceptance Application to automate the paper process used to approve new client relationships as part of the onboarding process. • Enhanced and supported RTrak, Deloitte’s CRM application used by 17,000+ users to manage client relationships, track opportunities and forecast client work. • Directed and executed all data layer (SQL) work for the Performance Management Goals application in coordination with all business and technical team members.• Drastically reduced manual processes and error by designing and programming the OffMgr Application, a SQL-based application used for tracking staff-related information for 3,000+ Chicago employees, which enabled sharing and notification for multiple internal support departments.• Created and maintained local applications to automate a variety of manual processes for Deloitte’s client support staff. • Responsible for all SQL development for the legacy CRIS system, including periodic change requests, on going maintenance and integrating the app with other developing systems.• Provided Chicago area SQL server maintenance.

Senior SQL Developer

Ran internal network and managed two staff members. Prior position included Senior lead for external IT consulting.