Doug Marcis Email & Phone Number

Greater Chicago Area

Leading and growing the IT Services division.

Chicago, Il

Chicago, Il

• Assisted all consultants in improving their technical knowledge • Led corporate demos and corporate innovation • Managed customer relationships and architect projects • Assisted in internal resource management

Chicago, Il

• Managed a Chicago team to ensure quality deliverables • Worked with the customer and the developer to gather requirements • Helped customers by giving recommendations on best data and views for analysis

• Optimized performance of existing analytic applications • Guided Junior Consultants and Interns during projects • Created documentation for deployments and projects • Created proposals for potential future customer implementation of analytic dashboards

Assisted in the technical implementation of a Multi-payer Claims Database for the Department of Health and Human Services. The Multi-payer Claims Database incorporated Medicare, Medicaid, and Commercial medical claims into a common data warehouse to allow for comparative effectiveness research. Worked with Oracle SQL Developer, Toad, Teradata, and Unix. • Analyzed source data and used my knowledge of claims data to create source to target mappings on data sources that were incorporated into MPCD. • Led the testing team on validating data integration code for all data sources within MPCD. • Helped automate data validation reporting to ensure a quicker turnaround. • Led User Support and Operations after implementation of MPCD. Coded Data Validation Rules for the State of Alaska Management Administrative Reporting Subsystem.Assisted in Project Management after go-live implementation of the State of New Hampshire Enterprise Management Administrative Reporting Subsystem/Enterprise Fraud and Abuse Detection System

Greater Chicago Area

Worked with customers to develop top-tier QlikView Applications. • Coded data load scripts and ETL scripts to combine data from multiple data sources. • Enhanced existing load scripts to maximize load time performance. • Implemented QlikView optimized data models to ensure optimum application performance. • Worked with QlikView Server and Publisher to roll out multiple dashboards to multiple users. • Used QlikView macros to create an automated report generator that made field selections and sent the results to QlikView reports and/or Excel Spreadsheets. • Created data validation applications to ensure the data in QlikView and data from the data source contained the most recent data. • Used VBScript and Java Coding to automate the sending of emails to a specific sales member and their manager once a potential client was identified in their territory.

Greater Chicago Area

Created a company to help meet the needs of multiple clients. We originally focused on Computer Aided Drafting using AutoCad and then evolved into developing QlikView business intelligence applications. Our clients were Broadway Electric, F.H. Paschen, Pagoda Electric, Kru-Marc Inc, Argo Electric and Natural Synergies.For our CAD area we worked on:• Shop Drawings• Site Utilization Plans• As-Builts• RFI or Change Order updates• Pre-Installation Drawings• Pre-Project Organization and Planning

Greater Chicago Area

• Assisted the Information Systems and Operations Management (ISOM) department for a class “Computer Concepts/Applications”• Graded all homework assignments with regards to Microsoft Access and Microsoft Excel• Held office hours to help students with assignments and projects every week

Greater Chicago Area

• Worked with Project Managers to create As-Builts using Computer Aided Drafting for projects• Created site-utilization plans for upcoming projects• Created an MS Access DB to assist in analyzing subcontractors available for bid

Master Of Business Administration (Mba), Management Information Systems, General

Bachelor Of Science (B.S.), Computer Science