Lee Roper Email & Phone Number

Irving, Texas, United States

• Documented analytics stored procedures for data dictionary.
• Act as mentor and code reviewer for data engineers on the team.
• Merged branches in DACPAC environment for team members.

Irving, TX

• Developed advanced queries and stored procedures for analytics and ETL processes in SQL Server.
• Design interfaces for importing and mapping data files into standard tables.
• Built custom data analytics modules for clients and supported the backend processes for the user-interface.
• Helped implement a large healthcare payor by developing custom analytics and processes.
• Reviewed and investigated client issues with data and the user-interface

Frisco, Texas

• Develop complex reports using T-SQL in SQL Server Studio across multiple data platforms.
• Maintain and enhance Access-based tools
• Perform quality assurance testing following data outages and upgrades
• Answer ad hoc service request from internal clients in a timely manner

Dallas/Fort Worth Area

Provided ad-hoc analysis and metrics in client claims data which required usage and familiarity with Cotiviti and external client tools and data.

Dallas/Fort Worth Area

Responsible for day-to-day activities of two client service teams, which included project plan, implementation and milestone management, personnel allocation and development, client management, change orders and SLA adherence. Managed and support the largest client (38,000+ lives) and team within the workgroup. Created a team setting that encouraged both.

Dallas/Fort Worth Area

Responsible for monitoring and analyzing self-insured and fully-insured benefit plans, including trend analysis of plan experience, future cost projections, and calculating employee contributions to meet cost objectives.

Dallas/Fort Worth Area

• Automated the process for collecting and analyzing claims audit data by programming and maintaining proprietary software. Also developed databases for use in tracking audit results, clients, and vendors.
• Analyzed census and claims experience data for use in projecting clients’ benefit plan costs, verify network discounts, and identify utilization patterns.
• Developed RFPs soliciting bids for vendor services and analyzed responses.

Dallas/Fort Worth Area

Spent almost 11 years in the Arlington, TX service center, working as a customer service representatives and as a trainer.

Bachelor Of Arts (Ba), English Language And Literature/Letters

Bachelor Of Arts (B.A.)