We provide IT Staff Augmentation Services!

Senior Consultant Resume

SUMMARY:

Seasoned Data Reporting / Business Intelligence Analyst offering a focus in Extract, Transform and Load (ETL), Data Quality and Integrity Assurance, Data Analysis, Reporting and Application Development. Seeking an opportunity as a Data Reporting Analyst / Business Intelligence Analyst.

TECHNICAL SKILLS:

SAS (Mainframe / Base SAS, Enterprise Guide. 4, AMO) - T-SQL, SSIS, SSRS

Advanced MS Access: Advanced MS Excel

Tableau (BI/Analytics) self-learned- VBA, VB 6.0 and ASP.Net

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant

Responsibilities:

  • Assisted Confidential with the technical and analytical skills necessary to support their clients’ needs in the practice areas of provider, health plan, life sciences and technologies services.
  • Learned client’s business requirements to identify, analyze and interpret patterns in the data and communicated these findings through effective presentations and reports.
  • These reports helped clients in improving the quality of their products.
  • Collaborated with business analyst to refine requirements for business performance monitoring including operational and financial metrics.
  • Designed and developed reports to signify performance deviations and anomalies.
  • Performed innovative analysis including custom data mapping and pattern detection techniques on claims data to facilitate the overpayment recovery process for a healthcare insurance carrier.

Confidential

Senior Medical Informatics Lead

Responsibilities:

  • Collaborated with Triad’s management to explore the creative use of data and advanced modeling techniques to promote more effective product development, sales, bidding strategies and treatment protocols for enhanced patient outcomes.
  • Explored business information to identify new trends, strategies and opportunities for improved quality of service to Triad’s customers.
  • Presented data findings and interpretations in a compelling manner that helped the audiences understand, gain insights and take action on analytical findings.
  • Managed and trained staff to develop several automated processes using advanced MS EXCEL, MS ACCESS and SQL to enhance operational efficiency and the quality of data.

Confidential

Practice Management Consultant

Responsibilities:

  • Assisted HealthCare providers to streamline and automate their processes through Consultancy, Data Analysis, Reporting and Software Solutions.
  • Performed a baseline practice analysis to evaluate the effectiveness of the current Systems and procedures and determine how the reimbursement potential could be maximized.
  • Explored and recommended the most cost effective Practice Management solution based on the medical practice’s requirement that consisted of Patient Scheduling, Electronic Health Records, Patient Payment Plans, Reimbursement Collection and Customer Correspondence.
  • Provided specialized services including Practice Management Setup, Data Transfer, EDI Registration, Electronic Claims Filing and Follow-ups, Receivables Reconciliation and Customized Reports.

Confidential

Programmer

Responsibilities:

  • Suggested and implemented a more effective approach of processing the data file through the rate assessor software by breaking it down by individual states.
  • This approach enhanced the efficiency of the process by 100% because previously the process was timing out due to the large data size.
  • Designed new look-up tables and the data flow diagram to facilitate data extraction and reporting for Spectrum product for Commercial Lines Rate Engines.
  • Supported the Enterprise Research Analytical Platform (eRAP) for Corporate, Claims, Commercial Lines and Personal Lines Actuarial department.
  • Additionally, assisted clients at all segment levels for SAS Enterprise Guide version 4, Add-in Microsoft Office.

Confidential

Consultant/Programmer

Responsibilities:

  • Designed and developed statewide critical incident reporting application by consolidating data and processes from different regions within the state.
  • In addition, automated manual processes at Confidential through designing several MS Access databases and applications.
  • Used SAS and ACCESS to design and develop regional Utilization Management reports for Commissioner’s Executive Group both on regular and ad-hoc basis.

Confidential

Database Design Specialist

Responsibilities:

  • Developed and maintained applications to facilitate Confidential 's Health Management Programs, Provider Credentialing, NCQA accreditation, HEDIS testing and Quality Improvement initiatives
  • Developed an auditing process for the Credentialing database to synchronize it with the Legacy system data. The new process improved accuracy by 75%.
  • Developed automated processes to export MS Access data in MS Excel format for the outside vendors on a regular basis; automation decreased transmission time by 90% and cut processing costs by 95%.
  • Collaborated with doctors, nurses, and other healthcare professionals to custom-build databases to meet their challenging requirements and at the same time optimize database efficiency and ease-of-use.

Confidential

Statistical Analyst

Responsibilities:

  • Led 8-month project with the IS data-team to establish the corporate Data Warehouse, data extraction procedures and analytic queries to facilitate corporate-level reporting initiatives including Utilization Management and Quality Improvement.
  • Designed several MS-Access applications with nurses and other healthcare professionals to improve the quality of services for CHF, Asthma, Diabetes, Hypertension, Complaints, Appeals & Grievance, HEDIS, Prenatal and Case-Management programs.

Hire Now