Erica Ware

Memphis, Tennessee

901-***-**** adhvpl@r.postjobfree.com

SUMMARY

Data and Systems Analyst

Highly accomplished, deeply driven, data systems professional with 10+ years’ experience working in multiple industries. Repeatedly successful in utilizing sales and marketing strategies to enhance growth through business insights, managing large client databases and reviewing/analyzing contractual and financial data to ensure compliance of state and federal regulations. Proficient in conducting training, research, and consulting with clients.

Technology Snapshot: Cognos, Tableau, Crystal Reports, KIRA, SQL, PL/SQL, Python, Power BI, Linux, Windows. Extensive use and knowledge of databases including ORACLE running on multiple platforms such as: LINUX, Unix, and Middleware (Cloud).

• Database Management • Client Need Analysis • Contract Management • HRIS

• Effective Communication • Technical Integration • Data Analysis • Agile (Scrum)

EXPERIENCE

Nielsen, Chicago, IL

Supplier Risk Analyst

09/20 – Present

Extremely thorough and detail-oriented analyses, which largely consists of manually adjudicating contracts to confirm that the perspective client meets the quality requirements of the company.

●Gather, process, and adjudicate contractual data reviewing business credentials prior to a monetary affiliation.

●Work closely with Professional Service (Sales), Finance, and Legal functions to help lead creation, modification, and finalization of appropriate sell side licensing agreements for customers and vendors.

City of Memphis, Memphis, TN

Benefits Data & Systems Analyst

09/19 – 05/20

Performs database and system administration training for corporate networks supporting over 500 employees.

●Provide Director with data visualization, analysis of benefits costs, trends, and strategies analytical and statistical reporting and research utilizing Power BI. Oversee interface files with outside vendors.

●Perform training and draft test plans for Oracle HCM system integration and stress tests, scripting, and troubleshooting. Work with Oracle and Workday EDI feeds daily and reports unusual activity to the supervisor.

Mainspring, Chicago, IL

Contract Analyst

04/19 – 09/19

Extractions and transformations of hospital contract data utilizing KIRA Systems. Extremely thorough and detail-oriented analyses, which largely consists of manually adjudicating contracts to confirm that the extracted data meets the quality requirements of the project.

●Gather clean and process unstructured data from medical contracts for negotiations. Perform contract management working with a large volume of documents and recognizing the types of agreements.

Transamerica, Memphis, TN

Virtual Insurance Consultant

04/16 – 04/19

Assist and train clients in planning, organizing, preparing, and researching their insurance policies. Also answer questions, gather information, provide quotes, underwrite, and sell policies. Oversee tracking, and monitor financial updates, contracts, watch lists, chargebacks and insurance files, and review and analyze financial, statistical, contractual, and operational data trends for clients utilizing Power BI.

●Promoted from intern to consultant for completing state licensing requirements and rating in top 5 associates in Memphis 1srt quarter of 2016.

●Assisted in technical and contractual transition from Oracle Sales Cloud to Salesforce Cloud.

●Initiated 2 key partnerships that resulted in 54% revenue growth within 2 years.

Black & Veatch, Memphis, TN

Project Support Analyst

07/13 – 06/15

Conducted core research and analysis, budget tracking and financial forecasting, project evaluation and monitoring, and maintained compliance with corporate and public regulations. Confirmed all calculations for monthly invoice, scheduled and coordinated domestic freight forwarder transactions, generated, and distributed reports, confirmed with accounting that all costs were balanced and in accordance with federal regulation for auditing purposes and chargebacks.

●Developed, produced, and analyzed financial statements within Oracle by region per company standards.

●Built and maintained multiple purpose Oracle databases for forecasting future financial performance.

●Liaised with contractors and vendors to ensure thorough understanding of contract terms and conditions.

●Ensured 30% of contracts were held by Minority Woman-Owned Business Enterprise (MWBE) continually per City of Memphis’ Office of Business Diversity and Compliance (RFP) specifications.

INTERNSHIPS

Transamerica, Memphis, TN

Virtual Program Design and Pricing Analyst Intern

06/15 – 03/16

Ensured contractual data integrity while assisting with SQL logic implementation into multiple databases.

●Created and maintained accurate models, pivot charts and reports, and developed forecasting tools and dashboards to analyze revenue variance, business pipeline and industry trends.

MASTERCLASS

Masterclass, Adjudication & Data Analytics

05/20 – 09/20

●Studied methods of adjudication, developed, and maintained data, Power BI Dashboards, Excel, and SQL database logic.

EDUCATION

Master of Business Administration - MBA, Computer Information Systems

2020

The University of West Alabama, Livingston, AL

Bachelor of Business Administration - B.B.A., Business Administration and Management

2017

LeMoyne-Owen College, Memphis, TN

CERTIFICATIONS

Microsoft Computer Software Certification Bloomberg Marketing Concepts Python & SQL

Oracle Fusion Global Human Resources Workday HCM Six Sigma White Belt

Contact this candidate