Data Analyst
Resume:
MATTHEW RICKERT
**** ******** ***** #*, **********, Kentucky 40220
****.*******@*****.***
BUSINESS | DATA ANALYST
QUALIFICATIONS PROFILE
Task-oriented, results-driven, and dynamic professional, with extensive background in business analysis within the healthcare industry. Adept at gathering, analyzing, and producing data in a clear, concise, and functional format; with expertise in utilizing data extraction, analytic and reporting abilities in order to render effectual assistance to the management in every phase of the decision-making process. Proven track record of effectiveness in adapting to changing technologies. Demonstrate excellence in composing functional requirement specifications, collaborating with developers on creating design and data specifications, and designing end user reference materials. Exhibit expert communication in written and oral, organizational, interpersonal, and problem-solving skills. Knowledgeable in implementing effective strategies and efficient business development operations in order to attain client satisfaction.
TECHNICAL ACUMEN
Microsoft Office Suite: Excel, PowerPoint, Visio, SharePoint, PowerPoint, FrontPage, and SQL Query, SQL Server 2005, 2008 and 2008 R2; Analyzer, SQL Management Studio; Pivot Tables and Charts; and Access Db Development, Level III Help Desk Support
CAREER HIGHLIGHTS
- Participated in the development of a program through Kindred healthcare to evaluate pharmaceutical purchases for overpayment.
- Successfully turned around and recovered more than $1M for 5 consecutive years consisting of overpayments to the wholesaler.
- Played a pivotal role in augmenting rebates by over $0.5M annually for 5 consecutive years.
- Oversaw and maintained the productivity of sales staff through creating queries and reports in accordance with the metrics set by the management.
- Formulated and submitted management reports to be utilized in implementing decision-making process in order to continue the growth of the department.
- Managed 30 insurance recovery specialists through the utilization of the Access database.
- Kept track of the entire process of purchasing for 31 LTC and 60 acute care pharmacies and contributed to the development of internal framework in compliance with the contract.
CAREER OVERVIEW
Technology Applications
- Composed specifications of various business and technical documents to be presented to the extract transform and load (ETL) developers to be utilized in data extraction projects.
- Performed inquiries for SQL 2008 R2 server in order to conduct data testing.
- Led efforts in generating and implementing Access database to be utilized by 25 sales professionals.
Business Operations / Administrative Functions
- Monitored the documentation of all data for the internal management of three separate teams, such as Pfizer, Eli Lilly, and Roche, which were contracted by pharmaceutical manufacturer.
- Created monthly internal reports of the business and presided over meetings with the President, Director and Manager of the Pharmacy Department.
- Devised a system database used to manage, monitor, and forecast potential rebate occurring on a quarterly basis.
- Initiated the calculation of the market share for key contracted drugs in order to drive market share to enhance rebates.
Staff and Client Relations
- Worked closely with the management on processing ad hoc reports on a daily basis.
- Presided over the development of national client portfolio and contributed in sustaining strong relationship with clients in order to reduce depreciation.
- Collaborated with internal upper management in controlling key data on external and internal clients in order to boost staff productivity.
- Sustained communication with national insurance clients through providing monthly production reports.
WORK CHRONOLOGY
KENTUCKY DEPARTMENT OF EDUCATION (THROUGH NTT DATA)
TECHNICAL ANALYST MAR 2012–PRESENT
HEARTLAND PAYMENT SYSTEMS – JEFFERSONVILLE, IN (OCT 2009–DEC 11)
BUSINESS ANALYST | RETENTION MANAGER JAN 2011–DEC 2011
BUSINESS ANALYST OCT 2009–JAN 2011
KENTUCKIANA ASTHMA AND ALLERGY – LOUISVILLE, KY
PHARMACY TECHNICIAN DEC 2008–JAN 2009
RX CROSSROADS – LOUISVILLE, KY
BUSINESS ANALYST DEC 2007–DEC 2008
THE RAWLINGS COMPANY – LOUISVILLE, KY
BUSINESS ANALYST – PHARMACY DIVISION AUG 2005–DEC 2007
KINDRED HEALTHCARE – LOUISVILLE, KY
SENIOR PURCHASING ANALYST – PHARMACY DIVISION FEB 2001–DEC 2005
EDUCATION AND CERTIFICATION
Associate of Science in Paramedic Science | GPA: 3.8
U.S. Coast Guard School of Paramedic Science, Petaluma, CA
Certificate in Surgical Technology | GPA: 3.9
Nationally Certified Surgical Technologist
Jefferson Technical College, Louisville, KY
Degree/ Coursework
St. Louis University –College of Business, St. Louis, MO
TRAINING
“Executrain” Courses: Advanced MS Access and Advanced MS Excel
Contact this candidate