John Lott Email & Phone Number

Greater Atlanta Area

Greater Atlanta Area

Greater Atlanta Area

• Develop and maintain SSIS packages to support revenue cycle management
• Ensure claim data submitted to the Centers for Medicare & Medicaid Services meets requirements and aligns with data in PRGX systems
• Collaborate with Healthcare Management teams to design and implement plans addressing missed revenue opportunities across all lines of business –Medicare Part A, Medicare Part B, DME, Home Health, Skilled Nursing.
• Support processes and applications used to manage claims processing, payment, and revenue generation
• Work with Recovery Audit Contractors (RACs) to identify and correct data inconsistencies in the RAC data warehouse

Greater Atlanta Area

• Communicated with customers to determine requirements and suggest solutions to empower them to effectively run their manufacturing processes
• Planned, prioritized, led and managed small implementation projects
• Documented system design, execution and end-user requirements
• Assisted customers with the integration of Business, Control, and Manufacturing Execution Systems across their organization

Greater St. Louis Area

• Daugherty Business Solutions, Consultant (Jan 2010 – Apr 2012)Bradford and Galt, Consultant (Feb 2009 – Jan 2010)
• Provided accurate feedback to all customers regarding questionable and/or missing Beer Process Analysis (BPA) data using knowledge of the front-end application, existing stored procedures and triggers, data flow as.
• Supported QA and Engineering teams at 18 domestic and international breweries with database/application malfunctions, updates, configuration, code changes, and reporting
• Documented and validated processes of managing daily access requests and identified areas of possible improvement for increased efficiency
• Retrieved and analyzed data from relational databases to determine root cause of data discrepancies
• Managed a constant inflow of daily customer inquiries maintaining clear and frequent communication from initial receipt through problem resolution

Greater St. Louis Area

• Used advanced Excel skills to handle ad-hoc reporting requests (including pivot tables, if-then analysis, lookup functions, linked tables, and graphs)
• Responsible for day-to-day management of analytics system to ensure data tracking and reporting functioned optimally
• Used SSIS to merge data from varied sources into SQL Server
• Created and maintained key reports, dashboards and analysis utilizing Visual Sciences (Omniture) and Google Analytics
• Identified, investigated, and resolved inconsistencies in data to ensure reporting integrity

Greater Atlanta Area

• Designed, developed, implemented and maintained MS Access database applications
• Created custom dynamic spreadsheets using Excel and Jet Reports to provide management with real time data from our Navision DB
• Troubleshot and resolved hardware, software, and connectivity problems
• Scheduled and maintained network wide data backups and retrieval (Retrospect)
• Responsible for the ordering and maintenance of IT related inventory
• Honored with the company’s “Best Professional Development” award for contributions through my first year of employment

Greater Atlanta Area

• Gained experience with SQL and standard data management practices