IT Professional

Shanon Higbee

Phone: 319-***-**** email: ******.******@*****.***

SUMMARY

Over 15 years experience, innately analytical, highly adaptable, critical thinker and complex problem solver able to thrive in fast-paced and challenging roles as an Analyst, Developer, Data Expert and Project Manager. TECHNICAL SKILLS

• MEDITECH NPR and Data Repository (DR) in

Client Server and Magic 5.2 – 6.x

• SQL Server 7 – 2016, Oracle 7 – 11g, MySQL

• SQL, T-SQL, PL/SQL

• SSMS, SQLPlus Worksheet, SQL+, TOAD

• SSRS, SSIS, Visio, Report Builder

• Visual Basic, Visual Basic.net, Visual Studio.net

• SAP Business Objects, Crystal Reports

• MS Office, VBA

• Advanced Access and Excel

• MS Project, Trello

• SDLC, Agile, Scrum, RAD

• ADP Transporter

• Kronos: Workforce Central, Connect, Timekeeper

• Forward Advantage Communication Director

• Midas+, Picis, netLearning, Halogen, FormFast

HIGHLIGHTS

• Highly skilled and proven ability to mine, analyze and interpret raw data, identify patterns, trends and correlations, and present findings in meaningful form

• In-depth knowledge of databases, data capture, modeling, manipulation, validation, and reporting

• Extensive data analytics, metrics reporting and visualization via Excel, Access, SAP Business Objects and Crystal Report, Business Intelligence tools, charts, graphs, pivot tables, SQL queries, stored procedures, Meditech NPR, Meditech Data Repository

• Knowledge of statistics and experience using statistical packages for analyzing datasets and disseminate findings for regulatory reporting, process improvement, trending, forecasting, and corporate growth

• Experience in analysis, design, development, integration, implementation, testing and support

• Skilled in defining, analyzing and documenting requirements, workflows, and process improvements

• Ability to identify, document, and communicate project tasks, timelines, risks, milestones and project status while encouraging project progression, tactfully holding task owners accountable, and remaining mindful of mitigation opportunities

• Exceptional troubleshooting skills and a talent for developing innovative solutions to uncommon, complicated or problematic scenarios

• Strong communication and soft skills to effectively and efficiently liaise with all organizational levels EDUCATION

Bachelor of Science Computer Information Systems (2005) Baker College, Flint, MI ~ Graduated Summa Cum Laude. GPA: 4.0 AAS Programming (2000)

Southeastern Community College, W. Burl., IA ~ Graduated with High Honors. GPA: 3.92 HONORS AND AWARDS

• Excel Service Hero Award (Employee of the Month) – July 2010

• Summa Cum Laude – 2005

• President List – 2003 – 2005

• Dean List – 1998 - 2000

MEMBERSHIP AND VOLUNTEER EXPERIENCE

• Southeastern Community College Academic Advisory Committee

• Employee EXCEL Task Force

• Battered Women’s Shelter computer support

• Assisted first grade students with using PCs

• Church Marketing Committee Member

• Volunteer at local Christian School

• Assistant Girl Scout leader

• YMCA/YWCA Child Care

• Story Time Volunteer at Elementary Schools

Shanon Higbee

Phone: 319-***-**** email: ******.******@*****.*** EMPLOYMENT

Consultant: Senior Financial Analyst, F1 Solutions January 2017 – Present

• Design, develop, and execute data extracts, mapping, validation and trending via SSMS, Access and Excel for County operated Health System including Acute Care, Family Practices, Urgent Care, Specialty Clinics

• Create, alter, and execute Stored Procedures, Views, and Queries in MS SQL Server via SSMS

• Automate manual process of marrying up data from 5 disparate sources used to generate complex Excel worksheets

• Create updateable PowerPivot tables used as data sources within Excel for financials Consultant: Meditech Analyst and ETL Consultant, CTG, May 2016 – January 2017

• Design, develop, and execute data extracts, mapping, and validation via SSMS, Meditech NPR (C/S and Magic) and Excel

• Lead Data Analyst for merger of multiple medical facilities operating on disparate HIS platforms

• Lead Data Analyst on health informatics team during initial stages of multi-facility (Acute Care, Private Practice, Specialty Facilities) HIS conversion moving from NextGen, Meditech C/S, Meditech Magic, and Meditech DR and converting to a single Epic HIS

• Create, alter, and execute SQL Server Stored Procedures, Views, Tables, Functions, and Queries via SSMS and TOAD

• Design, develop advanced reports and data extracts for regulatory reporting, system conversions and business decisions Consultant: Picis Report Writer, Analyst, ETL Consultant, CSI Healthcare IT, May 2015 – May 2016

• Perform data mapping, validation, and trending using tools such as SSMS, Microsoft Access and Excel

• Design, develop and support advanced reports and data extracts for regulatory reporting and business decisions

• Create, alter, and maintain complex Crystal Reports and extracts via SSMS, SSRS and Crystal Reports

• Create, alter, and maintain multiple complex Crystal Reports, SQL Queries, Stored Procedures, and Views HIS Programmer Analyst –Iatric Systems, Boxford, MA (2011 - 2015) Iatric Systems is a healthcare technology company dedicated to leveraging our integration experience to provide products and services that bring the right data to the right people at the right time. Roles: NPR Report Writer, Project Manager, Technical and Business Analyst

• Design and develop multiple complex MEDITECH NPR (Client Server and Magic) and Data Repository programs including ADP payroll, tax and W2 extracts for regulatory reporting

• Retrieve MEDITECH DR data using SSRS for Iatric Systems’ “DR Resource Center” package development with a focus on Human Resources, Payroll, and Employee Health Records

• Determine requirements from all business levels, create project plans and manage projects from conception to maintenance

• Create project specifications and contractual quotes Systems Analyst –Great River Medical Center, West Burlington, IA (2003-2011) Great River Medical Center is a regional medical center offering acute and intermediate care to residents of Iowa, Illinois and Missouri. Roles: Project Manager, Technical and Business Analyst, Technology Liaison, Lead Developer

• Develop Automation Client using VB.net and Office Automation to meet business needs such as quality performance monitors, patient safety indicators and payroll verification

• Create .Net applications with SQL Server and MS Access backends to dynamically create HTML files with linked CSS’s. Projects include a Physician Credentialing and Medical Privileges facility reference and Corporate Phone Directory.

• Manage system upgrades such as Kronos, Picis Quality Management, Physician Credentialing, MEDITECH 5.64 conversion

• Design and develop multiple complex MEDITECH C/S NPR programs including Physician Medication

• Ordering, Patient Discharge Instructions and Medication Reconciliation these were shared with MEDITECH and were the top most downloaded C/S programs

• Implement electronic form management solution, FormFast, for forms automation and forms library

• Assisted Clinical Documentation team with designing, building, modifying and maintaining Meditech clinical applications for the Acute Care facility (PCS, CPOE, Pdoc)

Applications Developer –American Ordnance LLC, Middletown, IA (1999–2003) American Ordnance LLC (AO) is a premier manufacturer of ammunition to the United States Military. AO is a Day & Zimmermann, Inc. company. Roles: Project Manager, Lead Developer, Designer, Technical and Business Analyst

• Design and develop custom HR and Labor system to eliminate PeopleSoft

• Design, develop, and maintain system to electronically collect labor, cost, and payroll information. Activities included programming data terminals and VB applications that interface with Oracle.

• Develop tools to monitor real-time staffing, quality performance and downtime indicators such as TNT Monitoring, production throughput, and staffing ratios

• Collaborate with department leaders to create functional specs and user interfaces

• Create numerous Oracle database objects including; tablespaces, tables, synonyms, indexes, constraints, sequences, triggers, views, roles, packages and stored procedures

Contact this candidate