Data Analyst/Consultant
Resume:
Mark S. Pelkey
Greater Atlanta Area
***********@*******.***
www.linkedin.com/in/mpelkey
Report Developer and Data Analytics Professional with extensive experience in healthcare reporting development and data analysis. Core strengths are in coding and development using SQL Server, MS Access queries and Cognos Reportnet BI. Recognized among peers and management as a knowledgeable and capable professional who can be relied upon to complete complex tasks and projects. Discovered process errors and corrected resulting in substantial cost savings to both company and clients.
Key qualifications include:
Extensive heatlhcare data analysis
Experienced and skilled with report development and presentation
Presenting analysis in useful and actionable bullet point summary format
Highly qualified and adept written and verbal comunication skills
Technical Skills
SQL Server MS Access
Cognos Reportnet BI MS Excel
MS Word MS PowerPoint
GeoAccess Cognos Impromptu
Paradox Data Junction
Hadoop and Python (completed online courses)
Experience
Optum, Inc./(Alere Health LLC), Marietta, GA 2006 - 2017
IT DT Analytics Consultant 2007 - 2017
Managed and assisted with development and troubleshooting in reporting for Disease Management programs for Blue Cross Blue Shield of North Carolina and several other clients. Types of reports produced included weekly and monthly snapshots, bursts, Quarterly Performance Reports and Client Dashboards.
Developed reporting for several Biopharma clients on their patient drug therapy programs using SQL Server queries. Managed reporting responsibilities for as many as 10-12 programs concurrently. Types of reports produced include Call Center Utilization activity, Marketing Territory Analysis and Quarterly Dashboards to give the client and idea if their out bound call program was performing as intended.
Maintained consistent high quality and accuracy of information given in reports delivered, with a > 95% record of meeting or exceeding deliverable deadlines.
Client Data Services Business Analyst 2006 - 2007
Assisted with new client implementations, as well as provided a support function to ensure that data is complete, correct and of high quality and required reporting deliverables to each client can be met.
Performed analysis of contracted vendor medical and pharmacy claims data, ensuring the presence and quality of essential data elements necessary for Matria (Alere) to translate into standard code for use in their Disease Management programs.
Improved data matching accuracy of several crosswalks that were built for translating a client's file feed with the Matria standard file format. For one of the largest clients, Metlife made updates to the crosswalk that increased the matching percentage by over 10%.
Wellpoint Anthem/(Blue Cross Blue Shield of Georgia), Atlanta, GA 2000 - 2006
Senior Data Analyst 2003 - 2006
Analysed healthcare provider demographic, contracting and paid claims information. Managed the production of contracted provider directories to analysis of healthcare products offered by providers.
Performed in-depth analysis of medical claims data by market, product or provider.
Created graphical and analytical reports of providers according to specialty and coverage by geographic area.
Network Data Analyst MedSNAP Program 2000 - 2003
Managed and reported on statistical information regarding selected Atlanta area healthcare provider networks, based on specialty.
Generated standard reporting packages on monthly or quarterly basis, as well as interpretation of data as it pertains to cost trending views by provider, CPT/ICD9 billing or population group.
Provided analysis and presentation of aggregate medical claims information and network financial performance before board representatives to track performance by provider.
Previous experience at
CNA Health Partners (now known as Healthscope, Inc.), Atlanta, GA
Primary Care Network Manager
Managed and coordinated participating provider network issues such as requests for contracting, credentialing, fee schedule rates and information.
Delivered accurate and actionable claims data reporting to client human resource managers and network board members.
Senior Data Analyst
Scheduled and produced standard data reporting packages, as well as ad-hoc reports for use by Network Manager prior to board meetings.
Investigated and reported any claims data trending information for selected healthcare primary care networks. Reconciled financial reporting for selected networks. Assisted IT department with local networking, software upgrades, printing and communication issues.
Military Experience
United States Air Force - Computer Operator/Communications Specialist
Awards: The Air Force Achievement Medal
Honorable Discharge
Education
MBA; Business/Concentration in Information Systems Management Coles College of Business; Kennesaw State University Kennesaw, GA
BS; Studies Social Science Pre Law; Computer Operator/Communications Specialist Michigan State University East Lansing, MI
Contact this candidate