Confidential

• Managed the Support Intensity Scale project for SIS assessment standardization across the State of Michigan. Administrator of the SIS online application which included training users, account creation, and security. Worked closely with PCE and AJ Boggs Company to fully integrate SIS online into ODIN.
• Represented OCCMHA on the state health care data exchange project called CC360. Became the first PIHP to gain access to the front end system. Managed access, data retrieval, and analysis for Medicaid health care data received from the state.
• Management of the iDashboard application which allowed users to make data driven decisions from visually powerful charts and graphs using SQL backend databases. Created ETL packages in SQL Server Integration Services SSIS that allowed iDashboard charts to load faster for enhanced end user experience. Built rich interactive dashboards displaying alert based key indicators. Received best practice during state audit.
• Key member on the costing work group. Designed, programmed, and delivered Excel macro enabled workbooks for year-end costing process. Implemented revenue payment reports for Finance department. Created database functions, stored procedures, and views. During a state audit received best practice for development of these tools.
• Aided in designing and developing dimensions and measures for financial and demographic data cubes for cross departmental analysis.
• Closely worked with DBA to monitor data integrity of tables in warehouse.
• Manager of the Benefit Manager Workgroup. Members from each core provider attended meetings and trainings that revolved around setting up insurance fee schedules in ODIN, setting up contracts and fee schedules, running spend down reports, MPHI lookups, and analysis of people who fell off Medicaid.
• Revenue Payment file analysis for Healthy Michigan. Worked with finance department to parse out the payment file by payment type.
• Created and developed ASP.NET web application which allowed user to select certain clinical procedure code and modifier combinations for a given time period that returned a costing data grid which user could export to Excel. This application was used for quick analysis of codes, units, and costs to determine future funding and budgeting.
• Developed technology trainings for staff at OCCMHA which included iDashboard trainings, Cube trainings, and most recently Excel trainings for the Rights Department.
• Installed, configured, and administered SQL Server Reporting Services SSRS 2012. Built parameter based departmental reports with Report Builder. Set up departmental directories with security based groups.
• Member of the Procedure Rate and ODIN user work group.

Project Manager of the on-line Recipient Rights and Due Process training tests that allowed Oakland County Community Mental Health Authority OCCMHA to track state mandated trainings. Created ETL packages to extract data and load into data warehouse. Designed and created SSRS reports for management to use during state audits. Received best practice in state for this project and the test was adopted by other counties.

• Key member in the design of new Electronic Health Record EHR system. Managed a bi-weekly provider data conversion workgroup from multiple clinical applications across the county. Developed project plan goals, tasks, targets and dependencies with Gantt chart web part. Created SharePoint site so external providers had access to project plans, agendas, meeting minutes, and collaboration documents.
• Worked with DBA to map EHR application tables to a normalized data warehouse. Participated with the planning and design of data warehouse using Ralph Kimball methodologies. Handled urgent data requests from management by querying data from application tables until warehouse was developed.
• Administered SPSS for key users in Quality Management. Installation, configuration, and setting up data connections in SPSS.
• Microsoft Great Plains technical support for server / client upgrades. Created web app for Great Plains that allowed power users in Finance department to unlock user accounts.
• Launched SharePoint Second Opinion portal which allowed state auditors to monitor processes for when a consumer is denied services. Integrated InfoPath form with secure web based access for data collection into our warehouse with routing and alerting. Used by internal and external agencies.
• Created web based tool that allowed Finance department to update Attachment A contract amounts in warehouse table that was used for financial reporting and financial dashboards.
• Designed and developed a purchase management vendor tracking web application that was used by the Contracts department for keeping track of existing vendors and what services they provided.

• Responsibilities included Active Directory user account administration, creating and maintaining account policies, the handling of confidential data and archiving data, issuing security cards for smartcard building access, creating VPN accounts, configuring routers for remote VPN with RSA secure ID key fobs, network share security settings, creating login script for printers, drives, and group policies.
• Created a help desk web portal that allowed the storage of electronic documentation, IT policies, licensing agreements, and trainings.
• Responsible for backups of all servers and creation of a data recovery plan. Generated images of each server and updated configuration files nightly. Set up process to store data backups at off-site storage facility managed by Iron Mountain.
• Implemented a hosted help desk application to keep track of tech tickets and provide management with reporting needs.
• Installed, configured, and administered SharePoint for interdepartmental collaboration. Responsible for SharePoint backups and recovery, site creation, user administration, SQL Analysis Services data cubes integration.
• Helped build network infrastructure during relocation to new building switches, servers, phones, cabling, security system that allowed users to connect to domain and access files and applications on move day with no outages or downtime. Received award from Executive Director for outstanding efforts for this project in November 2003.
• Installed and configured Crystal Enterprise for internal reporting needs. Developed data sources for end users to build their own web based reports. Received accolades from executive management and the Board of Directors for implementing the first ad-hoc web based reporting tool for Oakland County Community Mental Health.
• Key member developing the IT strategic plan and budget and received management buy in regarding IT strategic plan.

Confidential

Systems Engineer

Network Technician for Oakland County Community Mental Health. Responsible for creating ghost images for computers. Switched LAN from 10mbs switches to fiber gigabit switches. Created user accounts, exchange accounts, and helped create login scripts. Implemented TPC/IP printing. Active Directory administration for five sites and 300 users.

• Migration Specialist for Ford Motor Company. Responsible for the installation of Office 2000 suite throughout Michigan and Ohio. Installation of Profile Maker, creating user profiles, resolving printing errors, connectivity to the network, and basic troubleshooting.
• Received Microsoft Certified Systems Engineer certification December 27, 2000.

Confidential

Computer Technician

• Responsible for using network monitoring tools to keep track and record network speeds at Borders Books and Music headquarters. Maximized connection speeds by identifying and decreasing unnecessary network LAN and WAN traffic. Increased subnet reliability by reviewing network closet configurations, added universal power supplies to prevent surges/brownouts, replaced incorrect sized patch cords with quicker cat5 cable, upgraded out of warranty switches with new fiber switches.
• Performed computer audits for The State Bank in Fenton and created a report in Excel based on these findings.
• Responsible for installing customized software for Oakland County Community Mental Health. Set up systems for users. Solved basic LAN troubleshooting problems.
• Purchasing Agent
• Responsible for purchasing hardware, software, and cable infrastructure equipment.
• Worked with existing sellers to create a more accurate request for proposal form which reduced the time it took to get product requirements and options. Quicker turnarounds for purchase orders resulted in increased customer satisfaction. Worked with Great Plains to check in the purchase orders as they were received which increased order accuracy.
• Researched and found new suppliers in the market that lead to increased competition, lower costs, and more product availability. Created relationships with a new cable supplier very close to our company that made fiber cables same day which reduced cabling crew downtime.
• Researched the latest developments in the marketplace and new innovations from vendors.

Confidential

Store Manager

• Opened and closed store, scheduled staff, submitted payroll, purchased merchandise, received orders, cashed out registers.
• Prepared nightly deposit and coin bank orders.
• Ensured shelves were fully stocked and product was rotated properly.
• Accounted for daily price adjustments of stock and daily price auditing.
• Provided support for pharmacy department, called in the pharmacy order, filled prescriptions when necessary.
• Merchandized and marketed promotional items and ensured correct levels of inventory in stock rooms.
• Assisted with issuing money orders and quarterly inventory audits of controlled liquor.
• Scheduled monthly meetings with departmental heads and addressed employee suggestions or complaints.
• Coordinated with district manager on seasonal item displays and shared creative ideas to increase store revenue and cut down on shrinkage.