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.• Built ETL processes for operational metrics dashboards.• Created new email standard for delivery of internal email reports instead of attaching reports to emails.• Spearheaded the creation of documentation to track production jobs running in batch.• Perform data extraction and data manipulation based on specifications.• Maintain large data sets, combining data from many data sources used in analytics and reporting.• Lead server migration project which involved modifying and testing over 100 COB algorithms.• Work with business leaders and analysts to support development and maintenance of analytic processes.• Identify and implement process improvement and automation initiatives.• Analyze healthcare claims to identify data integrity issues.• Handle data transfers across servers and platforms via SFTP/FTP/SCP/Expect.• Produce reusable SAS macro code for repetitive programming tasks.• Perform unit, system and regression testing providing quality assurance.• Documented system processes and acted as mentor to team members.

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 access to high-quality, cost effective healthcare providers and facilities. Responsibilities included the development and maintenance of stand-alone data marts that provide indispensable assistance to the departments’ day-to-day requirements.Key Contributions:• 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.• 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.• Documented complex process flows.

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.• Created in-depth technical documentation to manage the complex change management, development, testing, validation, and deployment requirements.• Communicated outstanding challenges, software contention hurdles, and project statuses with team leads and management team.

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 reporting solutions. Also responsible to process, extract, cleanse, transform, and load data from the mortgage legacy system to various data warehouses. Was Team Lead for MIS with a support staff of 4 to 5 employees and contract staff. Delegated and mentored MIS staff and acted as a “go to” person for MIS team.Key Contributions:• 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 Street investor• Provided data analysis, technical support, and ad-hoc data to the Legal Department• Supported technical analysis, data feeds, and interfaces in support of corporate data warehousing• Maintained year-end 1099 data processing and verification associated with outside Mortgage Brokers earnings.• Supported the regulatory compliance system which produces HMDA (Home Mortgage Disclosure Act) information to validate non-discrimination lending in mortgage approval• Database management of mortgage loan and servicing data. Accountable for daily batch support, data integrity, database management, and trouble-shooting data concerns

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 for persons working with Human Immunodeficiency Virus (HIV) and Acquired Immunodeficiency Syndrome (AIDS). Clearinghouse collects, classifies, and distributes up-to-date information and provides expert reference assistance to HIV- and AIDS-prevention professional.Key Contributions:• 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