Mark Torres Email & Phone Number

SUMMARYAn Information Technology professional with extensive experience in the Health Insurance industry, from both the insurer and the provider perspectives. Known for in-depth accomplishments in Data Transformation, Analysis, and Reporting and Business Process Analysis. Uses a consultative approach with internal customers to draw out and clarify requirements for data gathering, analysis and reporting. Applies rules identified during requirements gathering to relate data from different sources in order to present results in a manner that facilitates customer reporting of metrics, and decision making based upon results. Core competencies include:Consultative Approach / Team Player / ResourcefulSelf-Motivated / Focus On Requirements / All Project Life Cycle PhasesTechnical Depth and Breadth / Complex Data Analysis / Identify and Correct AnomaliesKEY ACCOMPLISHMENTSCreated a SQL Server Business Intelligence database using Microsoft SSIS and Alteryx to extract and analyze Ambulatory Surgery Center data collected from systems including Amkai Office, AdvantX, and Centricity. Related data from multiple dimensions, including scheduling, billing, clinical documentation, operating room and staff utilization, preference card utilization and case costing.Managed an inventory system for 11 ASCs (IOS Corp's ENVI), which included over 70,000 items. Implemented the ENVI to Amkai Office interface to send inventory information to Amkai and to receive usage information from performed cases. Used the CData's ODBC connector to extract data from ENVI into SQL Server to confirm the interface was working correctly.Used Excel to present BI information using SQL queries to pull data and combine it with DAX commands prior to presentation. Evaluated and installed Tableau Server. Designed and built a series of proof-of-concept presentations using the data from the BI database.

Listed skills include Ssis, Crystal Reports, Microsoft Sql Server, Metrics Reporting, and 44 others.