Loretta Mitchell Email & Phone Number

Frederick, MD, US

US

• Provide analytic development and support, custom reporting, and consulting for Optum Payment Integrity to identify over-payments or recoveries.Key Contributions:
• Provide data analytic development services to identify overpayments and recoveries for Coordination of Benefits (COB) and Subrogration teams in Optum’s payment integrity efforts.
• Redesigned and developed Subrogation ETL and reporting solutions.
• Function as lead developer for Subrogation analytics.
• Lead SAS algorithm development and maintenance projects per COB specifications for hundreds of algorithms. Instrumental in the automation of these manual algorithms into batch processing.
• Write SQL queries to fetch complex data from healthcare adjudication data marts.

Baltimore, MD, US

• Supported Networks Management Department with their analytics and corporate reporting needs. The Networks Management Department is responsible for maintaining CareFirst provider networks to assure that members have.
• Worked extensively with business analysts to improve the department’s analytics delivered to Senior Management and outside consultants.
• Utilized existing IT data warehouse reporting platforms to support business functions.
• Work directly with business analysts and management in understanding the information needs of the business and developing, modifying and maintaining data marts to meet these requirements.
• Created SOPs and standard documentation for existing business processes where none existed.
• Performed data cleansing and “value added” routines in order to streamline analytics development.

San Francisco, California, US

• Recruited to support multifaceted project to design and implement an interface between Fannie Mae and the Wells Fargo’s ‘Loan Processing System’ (LPS).Key Contributions:
• Completed detailed technical analysis of existing and newly developed programs.
• Duties included data handling, manipulation, presentation and security/confidentiality based on business specifications.
• Involved in the technology development and enhancements necessary to meet Federal regulatory compliance changes effecting the mortgage, banking, and financial industries during turbulent financial times.
• Analyzed 700+ batch and ad hoc MIS data feeds, interfaces, extracts and reports.
• Developed and deployed new data interfaces and reports.

San Francisco, California, US

• Acted as the lead developer for the Management Information Systems (MIS) development group for the 24/7 on-line application, Loan Processing System (LPS). Primarily responsible for designing and implementing data and.
• Worked extensively with business analysts to improve the department’s analytics delivered to Senior Management and outside consultants.
• Extensive experience handling task management and ad-hoc requests from clients and management.
• Created, tested, documented, and supported numerous automated data feeds for data warehousing, active interfaces, extracts, and reports
• Supported the phone application, CARS, Client Area Report System, to allow Brokers quick access to their financial information
• Flawlessly deployed the Wells Fargo, Mortgage Division, Secondary Marketing System (SMS) to production batch environment. The SMS system allows marketing staff to “pool” mortgage loans which are then sold to Wall.

US

• Worked as a programmer managing technology requirements and software solutions for the National Aids Information Clearinghouse (NAIC). The National AIDS Information Clearinghouse is a comprehensive information service.
• Designed, developed, tested, and deployed a clearinghouse application to manage NAIC clinical trials information
• Created database repository for the clearinghouse application
• Worked closely with business staff for on-line screen design and data collection requirements
• Implemented software enhancements
• Created data feeds and reports based on requirements