Tracy Sexton Email and Phone Number

Substitute teacher for all age ranges from Pre-Kindergarten through High School

Responsible for preparing the daily deposit, completing price changes, receiving direct freight shipments, processing as-is and store use merchandise, maintaining store sales records, maintaining human resources and payroll records, customer service on the sales floor through superior product knowledge and one-on-one interaction, and cashiering

Advanced Analytics and InnovationPartnered with project management and IT as the business lead on large scale project to design and develop a web based application used by the valuation team of the actuarial departmentThe scope of the project included the following: Creation of a SQL database that included data from several data warehouses to be available by business day 1 for enrollment and business day 2 for claims. Design and implementation of a web based application utilizing an Excel model to extract data, perform calculations and write the results back to the database. Generate enterprise wide reports in Excel utilizing original claims and enrollment data as well as results from the application.Collaborated with business to streamline a complex Excel valuation model.Translated the customer’s business process and requirements into a business requirements document.Developed and executed test plans and managed user acceptance testing for the successful implementation of application and enhancements.Developed and maintained a defect tracker using SharePoint.Trained valuation team to use and leverage new application to improve efficiency.Provided verbal and written project communications/updates of statuses and issues.

Healthcare Pricing, Model Development and MaintenanceKey participant in 3-year project to rewrite company's proprietary actuarial rating system.Coordinated work of programmers, actuaries and lead-underwriters in planning, development, beta testing and implementation of new model.Point person for programmer. Assisted with troubleshooting of programming code to ensure it produced actuarially sound results.Conducted brainstorming sessions with all company underwriters on what they wanted from a new system.Coordinated rollout of new rating tools, including beta testing by Underwriting and market reasonableness by Marketing Strategy.Extensively worked with ICD9, CPT, and DRG coding to price health care benefits appropriately.Coordinated data analysis to determine area factors, age/gender factors, industry rating factors and trend factors.

Performed all office duties for marine construction company, including accounts payable and receivable, monthly and quarterly taxes, estimates, and detailed drawings for permits. Developed and modified several spreadsheets for payroll and job costing.Designed proposal templates