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 Facility, and Hospice• 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 well as the brewing process• 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 • Interacted with development teams and internal customers (from Global Directors to brewery personnel) to identify requirements and design plans for system improvements• Created and maintained Business Object reports to provide AB Inbev Product Managers visibility of Application Support team metrics• Documented current system functionality and limitations to be used as requirements for future enhancements to administrative web applications

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