John Lawson
Business Intelligence Developer
Summary
Project Execution - Effectively manage diverse tasks, with varying degrees of complexity, within a wide range of environments; evaluate situations, assess emergent needs, and implement solutions in a prompt and efficient/effective manner.
Resource Coordination – I possess a proven ability to anticipate as well as identify unique requirements or potential roadblocks in all situations. Continually develop back-up plans to minimize risk and deliver exceptional results; streamline communication and implementation channels to effectively meet client and organizational needs.
Integrity - I have a demonstrated track record of outstanding service; a calm, dependable professional who devotes every effort to achieving the best results.
Overview
19
19
years of professional experience
4
4
years of post-secondary education
Work History
Clinical Reporting Consultant
Revuud, Inc/Vandalia Health-CAMC
5 2023 - Current
- Work with the Business Intelligence Team and the Tiger Team with the required report writing needed for the project assigned.
- Worked within Cerner environment performing modifications on variety of reporting including Cerner Analytics Library and Power Insight reports.
- Did some work on DSS queries and stored procedures within MS SQL Server environment.
Tableau Developer
Revuud Inc./Duke Health
05.2023 - 10.2023
- Optimized dashboard performance by utilizing best practices in data extraction, filtering, and aggregation techniques.
- Empowered stakeholders with real-time access to actionable insights by developing dynamic visualizations tailored to their needs.
Senior Operations Analyst
Clover Health
10.2021 - 03.2023
- Invited to join Clover team full time, continued support as well as design for reporting products
- Used multiple reporting/visualization tools to create new reporting as well as support existing reporting infrastructure along several lines of business
- Within my team, was tasked with onboarding new team members with required tools/software to perform required role.
Senior Reporting Consultant
Provisions Group
04.2021 - 10.2021
- On staffing contract, assigned to Clover Health as report developer
- Worked in multiple database environments (Postgres, Oracle, Snowflake) as well as multiple front end client applications (HealthEdge Claims Payor, Athenahealth EHR, Salesforce)
- Supported multiple lines of business, (claims, pharmacy, payment integrity, clinical operations.)
Reporting Analyst
TransTech Staffing Solutions
12.2019 - 03.2021
- Assigned to HCSC/Blue Cross Blue Shield of IL
- Provide support and development of both ad hoc and operational reporting requests for Government Line of Business within Data and Analytic Solutions department
- Worked in both SQL Server as well as Teradata database environments.
Business Intelligence Developer
JourneyCare
02.2019 - 09.2019
- Continued support and development of Microsoft SQL Server Reporting Services (SSRS) reporting with one of the largest hospice and palliative care agencies in Illinois
- Supported prior Power BI implementation for business users
- Used Microsoft Azure DevOps for documentation and tracking of project development.
Business Intelligence Developer
Medix IT
09.2018 - 02.2019
- Brought in as contractor at JourneyCare, one of the largest hospice and palliative care agencies in Illinois
- Designed/modified/published custom reports used by the agency on a daily, weekly, monthly and/or ad hoc basis using SQL reporting services (SSRS)
Clinical Systems Reporting Consultant
MEDMATICA CONSULTING ASSOCIATES
03.2016 - 02.2018
- Leveraged expertise to determine and devise appropriate high-quality leading-edge IT solutions for major healthcare organization enterprise architecture
- Oversaw maintenance of healthcare database management solutions
- Interacted extensively with clients to deliver proactive response and superior service
- Effectively managed workflow and prioritized tasks
- Provided legacy IT support to Soarian Clinicals reporting environment throughout migration of Virtua to Epic EHR system
- Developed new templates to enhance support and reporting within Soarian Clinicals
- Facilitated implementation of new Crystal Reports application in Business Objects environment to deliver essential data to end users
- Ensured all new and existing software applications met stringent client requirements.
Clinical Systems Analyst
INGALLS MEMORIAL HOSPITAL
01.2011 - 01.2016
- Collaborated with end-users, professionals within Informatics Department, and other personnel todetermine most effective IT solutions to enhance delivery of patient care
- Managed and maintained EMR applications, including Soarian Clinicals
- Developed robust reporting tools for use by end-users
- Implemented Event Driven Routing to create reports delivering essential data
- Incorporated IT solutions to develop stored procedures to assist in managing ER patient data
- Implemented Tibco iProcess application to mange and improve coordination of workflows
- Created new system to effectively manage filing and bursting rules for documents migrating between Soarian Clinicals and Siemens Enterprise Document system (EDM) for eHIM
- Provided additional support to all clinical and ancillary systems, including Siemens Syngo Workflow and Picsis OR applications
- Used SQL Server Integration Services (SSIS) to export data related to emergency department discharges in Soarian Clinicals database for import into Soarian Financials system to facilitate timely closure of ED encounters in financial system.
Reporting Analyst
MDA LENDING SOLUTIONS
01.2006 - 01.2011
- Maintained and supported Business Objects Enterprise applications for more than 50 clients
- Assessed client needs and ensured all user requests were consistently met
- Collaborated with SMEs to develop and implement new reporting procedures in Oracle, SQL Server MySQL and MS Access environments.
Education
BS - Computer Information Systems
DEVRY UNIVERSITY
Chicago, IL 01.2000 - 05.2004
Skills
Tableau (Certified Data Analyst)
Timeline
Tableau Developer
Revuud Inc./Duke Health
05.2023 - 10.2023
Senior Operations Analyst
Clover Health
10.2021 - 03.2023
Senior Reporting Consultant
Provisions Group
04.2021 - 10.2021
Reporting Analyst
TransTech Staffing Solutions
12.2019 - 03.2021
Business Intelligence Developer
JourneyCare
02.2019 - 09.2019
Business Intelligence Developer
Medix IT
09.2018 - 02.2019
Clinical Systems Reporting Consultant
MEDMATICA CONSULTING ASSOCIATES
03.2016 - 02.2018
Clinical Systems Analyst
INGALLS MEMORIAL HOSPITAL
01.2011 - 01.2016
Reporting Analyst
MDA LENDING SOLUTIONS
01.2006 - 01.2011
BS - Computer Information Systems
DEVRY UNIVERSITY
01.2000 - 05.2004
Clinical Reporting Consultant
Revuud, Inc/Vandalia Health-CAMC
5 2023 - Current
Similar Profiles
Cory FrameCory Frame
Director of Surgical Services at Charleston Surgical Hospital CAMC Vandalia HealthDirector of Surgical Services at Charleston Surgical Hospital CAMC Vandalia Health
Siera RuckerSiera Rucker
Surgical Technologist at MonHealth System/Vandalia HealthSurgical Technologist at MonHealth System/Vandalia Health
Rebecca WhiteRebecca White
Registered Nurse Campus Float. at Davis Medical Vandalia HealthRegistered Nurse Campus Float. at Davis Medical Vandalia Health