SUMMARY:

Volunteer

• Health Insurance Counselor
• Assist in Medicare supplement and Medicare Part D plan, medical bill questions, appeal assistance and education on Medicare benefit information.

TECHNICAL SKILLS:

• Microsoft Office: mail merge, insertion of tables, red lining
• Microsoft Excel: if - then, concatenate, v-look up formula, pivot tables, macros, date formulas, creations of graphs and linked formula across spreadsheets
• Microsoft Access: wrote, updated and ran queries and databases for department use
• Great Plaines. SAP, Cognos
• AS400, and RX Claims systems
• IEX and CMS systems

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst/Product Owner

Skills:

• Microsoft Excel: concatenate, v-look up, pivot tables, creation of graphs, date formulas, and linked formula across spreadsheets, pivot table, control charts,
• Microsoft Access: created a database, with queries, and modules
• Project management organization properties: created RRTM’s, BRD and sprint cycles.
• Scrum Master and Product Owner

Responsibilities:

• Created and implemented weekly metric
• Project managed department metrics database
• Support, compile and report key information
• Project management department needs and requirement on company wide projects and processes
• Streamlines and updated process and technology in department

Confidential

Senior Quality Business Analyst and Audit Coordinator

Skills:

• Microsoft Excel: concatenate, v-look up, pivot tables, creation of graphs, date formulas, and linked formula across spreadsheets, pivot table, control charts
• SQL server query
• Microsoft Access: update and ran queries and created and updated multiple database
• Project management organization properties.

Responsibilities:

• Support, compile and report key information
• Assigning audit samples, ensuring that monthly quota are met, and month end process are closed according to outlined deadlines
• Use data to identify trends, patterns and opportunities for the business and clients
• Produce, publish and distribute scheduled and ad-hoc client and operational reports relating to the development and performance of products

Confidential

Senior Business Analyst

Skills:

• Microsoft Excel: concatenate, v-look up, pivot tables, creation of graphs, date formulas, and linked formula across spreadsheets, pivot table, control charts
• SQL server query
• Microsoft Access: update and ran query and created and updated multiple database
• Project management organization properties.

Responsibilities:

• Support, compile and report key information
• Drive processes and technology improvement initiatives for the products, using standard project methodology (requirements, design, test, etc.)
• Use data to identify trends, patterns and opportunities for the business and clients
• Engage users in analysis and evaluation of functional models and prototypes; identify dependencies and priorities. Evaluate technology applications for use by the user community
• Produce, publish and distribute scheduled and ad-hoc client and operational reports relating to the development and performance of products

Confidential

Senior National Operation Analyst

Skills:

• Microsoft Excel: concatenate, v-look up, pivot tables, creation of graphs, date formulas, and linked formula across spreadsheets, pivot table, control charts
• SQL server query
• Microsoft Access: update and ran quarries and created and updated multiple database
• Microsoft Office: mail merge, insertion of tables
• Six Sigma yellow belt certified

Responsibilities:

• Identify metrics that are outliers by utilizing statistical analysis software and the six sigma
• DMAIC process to present findings/proposed solutions
• Generate qualitative and quantitative standardized reports for managers
• Coordinate the activities of 2000+ agents across 50+ sites to handle 50 million calls annually
• Real-time reporting and monitoring of 300+ call queues
• Gather data on impacts due to system issues, weather, reporting, and other BCP events
• SME of core member process
• Interim vendor manager to 80+ agents at an off-shore vendor site.

Confidential

Pharmaceutical Industry Operation Analyst

Skills:

• Microsoft Excel: concatenate, v-look up, pivot tables, creation of graphs, date formulas, and linked formula across spreadsheets
• Microsoft Access: wrote, update and ran query and created and updated multiple database
• Microsoft Office: mail merge, insertion of tables, red lining
• Negotiator certificates

Responsibilities:

• Implementing and analyzing pharmaceutical contracts.
• Analyze healthcare formularies against contract’s requirements.
• Analyze and assign late fees per contract requirements.
• Reconciliation of quarterly rebate payments while work with pharmaceutical companies to ensure discrepancies are addressed.
• Analyze and testing of processes and systems to ensure medical claims are processing correctly.
• Analyze contracts to ensure department is able to implements contracts and audit risks are addressed

Confidential

Rebate Specialist II

Skills:

• Microsoft Excel: concatenate, v-look up, pivot tables, creation of graphs, macros, date formulas and linked formula across spreadsheets
• Microsoft Access: wrote, update and ran query
• Microsoft Office: mail merge, Insertion of tables

Responsibilities:

• Creating, implement and analyzing market share rebate forms and payments.
• Calculations of rebate payments and settlement agreement.
• Auditing all contracts for the department to ensure contracts were entered correctly and compliant Sarbanes Oxley.
• Working with sale representative and vendors to ensure forms are filled out correctly and payments have been received.
• Lead on department process manual.

Confidential

Production and Marketing Assistant

Skills:

• Microsoft Excel: concatenate, pivot tables, and linked formula across spreadsheets
• Microsoft Office: mail merge, insertion of tables
• Project management certificate

Responsibilities:

• Contacting vendors to obtain and tracked content product
• Coordinator of three outside content vendors including A&E/New video
• Coordinator in charge of in coming content of books, videos and product for the company
• Created and updated multiple databases for the company, created and updated databases for video masters, content material and contract agreements
• Coordinator of video masters, agreements with vendors and talent agent
• Subject matter expert for royalties, vendor’s payments and tax information
• Quality control of products going to customers
• Coordinator of a program to convert VHS titles to DVD format

Confidential

Accounting Clerk

Skills:

• Microsoft Excel: concatenate, v-look up pivot tables, and linked formula across spreadsheets
• Microsoft Office: mail merge, insertion of tables

Responsibilities:

• Working with vendor’s pertaining to invoices, royalties and payments
• Filing vendor invoices and transactions.
• Tracking, entering and faxing PO’s to correct departments and vendors.
• Preparing, mailing and filing invoices and payments and refunds.
• Working with the customer service department to refund to customers overpayments.
• Updating and tracking company inventory monthly.