Data Analyst Sales
Resume:
William Yeb
Roswell, GA
**************@*****.***
https://www.linkedin.com/in/william-yeb
data analyst/Developer
Contributing to excellence and profitability by capturing numbers and turning them into solutions
Bring information to user on their finger tips and to generate analytical reports for decision makers, thoroughly understanding database structures and experiencing work with complex data.
Respond promptly to deadlines to both internal and external customer requests with accurate and well-researched information on the first time
Data Requirements Process Improvement Negotiations Trend Analysis Acquisition Support
Professional Experience
IBX
Analytic Consultant • Alpharetta, GA May 2017 to November 2017
A subsidiary of Alliant Employee Benefits
Developed programs transferring data from Scout – a national platform for insurance pricing - and from insurance carriers directly for small accounts to the specifications of bid processes. The programs work with complex bid process without manual interventions.
Built database to capture and report the enrollment management tracking and census data. The programs make easy for users to capture data in one place and monitor the daily activities.
Prepared statistics reports, capturing the big winners and losers for the carriers working with us, cost savings we could deliver to our clients for the last three years from a complex data structure.
HANGER INC
Sr. Data Analyst • Gaithersburg, US 2003 – January 2017
The largest provider of prosthetic & orthotic services in the US (over 50% of market share for services) and has contracts with over 2,600 health insurance companies. Sr. Data Analyst
Collected the data requirements from all the national level client companies. Produced customized company reports, using advanced excel spreadsheets, to compare the national numbers to the local market level on their books of business. The reports were used to monitor and adopt best practices for all sites.
Prepared monthly and quarterly revenue reports illustrating commercial and hospital revenue trends. These reports allowed management to compare year over year costs and how service fees compared to medicare fees which increased yearly revenues.
Developed a fee schedule model to use in comparing various health insurance fees with medicare. Consequently, end users had reliable and timely fee information to negotiate with clients.
Created a unique internal coding system to accurately report the monthly AR balances for key commercial insurance accounts. This significantly improved the account collections and the relationships and loyalty of the client companies.
Developed 'upon request' ad-hoc reports for insurance companies including United Healthcare, CIGNA, Aetna, & Kaiser. Reports included comparing medical products by volume units and cost, key financial and CFO requests, and other product pricing comparisons.
Built and calculated highly accurate quarterly compensation reports for sales directors which led to a high level of trust and eliminated staff hours.
MARSH
Benefits Consultant • Boston, US 2002 – 2003
Evaluated health & welfare benefits to find optimum solutions for clients.
Researched and compared pricing among various healthcare providers to present to the client.
Negotiated with insurance carriers on behalf of client, saving money for them.
UNITED HEALTH GROUP
Marketing Analyst • Rockville, US 1999 – 2002
The largest healthcare insurer in the country with over 54 million members nationwide.
Performed weekly database analysis of multiple systems, during an acquisition, to merge the product data which quickly allowed for market share expansion in dental product in Untied Healthcare markets.
Created an expense account for twenty staff members so that their reporting of business expenses were more timely, accurate, and reduced inputting time.
Built and calculated highly accurate quarterly compensation reports for marketing and sales staff which led to a high level of trust and eliminated staff hours.
Developed monthly market share reports by state and market to analyze trends.
CIGNA
Presales Specialist • Boston, US 1996 – 1999
Global healthcare service company servicing 15 million medical customers producing $38 billion in revenues.
Maintained quality control for the company and its clients by serving as the liaison between sales and underwriting and negotiating a win win solution for all. This increased the up-sell of products and the retention of clients.
Education
University of Phoenix
Masters of Business Administration Business Administration
Roosevelt University
Bachelor of Science Mathematics
North Central College
Bachelor of Art Accountancy
Technical Skills
Oracle Business Intelligence Enterprise Edition
Expert level with Access, Excel, OBIEE, SQL, VBA.
Salesforce
Contact this candidate