Brad Winchester Email & Phone Number

St. Louis, Mo, Us

St Louis, Missouri, United States

• Managed a healthcare data analytics team to support value-based contracting within Medicaid, Medicare, and Ambetter• Provided daily issue support, root cause analysis, and validation of monthly production run (over 4,000 reports) for provider offices nationwide• Worked closely with business partners to define new requirements for report enhancements and fixes• Held daily and weekly Agile scrum activities to manage team• Performed ad-hock provider analytics

Greater St. Louis Area

• Led a business application software team creating web, desktop, ETL, database, reporting, and business intelligence solutions for three departments supporting over 150 users.Fraud Waste & Abuse (FWA)Responsible for three case manager solutions: Memento, Perspective, and an in-house custom developed solution. Maintained a fraud hot tip hotline database, Teradata SQL templates, and CMS/client reporting to assist the FWA team with targeting/reporting outlier members, physicians, and pharmacies. Responsible for a letter automation/faxing system utilizing Right Fax, nightly batch jobs, and fulfillment services. Participated in target audits for government entity initiatives related to law enforcement.Client Audit ServicesManaged various solutions (C#, ASP.NET, MVC, SQL Server) to automate audit processes to drive FTE efficiencies, centralized workflows, and government/client reporting while working with multiple tight deadlines with department audits. Responsible for supporting the reporting and data needs of clients, the Center for Medicare & Medicaid Services (CMS), and other government entities. Annually, saved the department over 500+ FTE hours.Retail Pharmacy AuditManaged, developed, and maintained a daily desk audit workflow solution with 20+ users that generates several million in annual revenue. The system consumes claim data from the Teradata data warehouse into SQL Server. The ETL consisted of SSIS packages, complex queries, and stored procedures. The rich client front end was developed with Microsoft Access within the industry NIST standards. The reporting was managed with C#, ASP.NET, SSRS, Word & Excel automation.• Met with several internal business partners to gather requirements for each project/enhancement • Managed and professionally mentored a team of up to 11 employees• Held regular developer progress/ stand-up, code review, and best-practices meetings with team

St Louis, Missouri, United States

• Led business side application development software team (5 developers)• Recipient of Incub8 2016 award for new technology innovation including advanced SQL targeting, QR codes, dynamic letter generation, and automated fax scan• Migrated legacy stand-alone systems into a consolidated department web platform• Helped integrate MEDCO claim data and audit processes into existing Express Scripts solutions for Retail Pharmacy Audit, Client Audit, and Fraud Waste & Abuse departments • Provided various technical training and product demonstrations• Technical liaison for internal and external vendors/clients

St Louis, Missouri, United States

• Developed home delivery drug pricing application to help to increase security and manage daily price changes utilizing Microsoft Access and SQL Server objects (stored procedures and complex views)• Created an FWA investigator utility for the physician, member, and pharmacy outliers using Microsoft Access, SQL Server, SSIS packages, and stored procedures which aids the department to identify potential prescription fraud and generate/manages required documentation • Maintained and enhanced legacy audit application with monthly updates developed in Microsoft Access and SQL Server• ADP Security Clearance Certified

Greater St. Louis Area

Anheuser-BuschDeveloper/Team Lead at Anheuser-Busch (Contractor)• Created software business applications to help aid National Retail Sales and Marketing groups analyze data• Processed monthly Nielsen and IRI data to generate demographic reports based upon current sales trends (including over 1,600 PowerPoint Presentations for new potential targets)• Developed monthly Access database processes and Access/Excel reports (50+) to help Category Managers analyze retail sales data for Military, Applebee’s, Texas Road House, AM/PM, Circle K & Pump N Pantry retails• Provided daily technical support to entire National Retail Sales

Greater St. Louis Area

Project: BJC Healthcare – Staff Management and Skills Assessment • Aided development to create IT Human Resources desktop and web application. Software was needed to manage employees, contractors, salary, titles, skills, reviews, and compensation • Designed form layouts to work with the business flow • Built VBA mechanism to process title and merit increases for salary & hourly employees • Created/enhanced numerous reports with dynamic criteria queries• Utilized custom C# encryption/decryption for reviews

Greater St. Louis Area

Tyco Healthcare Mallinckrodt Pharmaceuticals • Provide application development and technical support for sales management software - Brand and Addiction Treatment pharmaceutical divisions• Performed analysis by interacting with end-user to gather requirements• Access/SQL Server database design including tables, store procedures, views, packages • Generated Excel reports and SQL Server/Access queries to analyze and report trends of regional sales performance• Process monthly updates of physicians, trial scripts, and NDC script data to assist physician targeting• Work with management to analyze and report trends of territory, district, and regional sales performance

Greater St. Louis Area

Programmer• Developed custom mainframe Ez-Letter JCL code for direct mail projects• Maintained and created font and images library used for OCE and Siemens high-speed printers developed using Elixir software

Bachelors Of Science In Business Administration – Business Management

Education record