Customer Support Data Analyst

***** ********** **. ******** *******, MI ***** - Email: ***********@*****.*** - Phone # 586-***-**** Kanari Abaas – Healthcare Analyst

Kanari Abaas

Objective

Seeking a challenging and growth oriented position that utilizes my education, experience, and skills CAREER SUMMARY

High skilled SQL Server and databases with 7 years of progressive experience

Advanced data analysis, design, and development skills

Microsoft Excel skills: advanced Pivot tables, mathematical formulas and other data features available with Excel

Strong analytical skills and experience in Analytical Information Management.

Acute knowledge of hardware, software, and systems engineering

Familiar with SSAS, SSIS, SSRS and database design and development in SQL Server

Excellent communication, presentation, and organizational skills

7 years experience of healthcare industry and providers/payers data/knowledge

Knowledge of EDI for healthcare (837& 835…).

WORK EXPERIENCE

Agile Healthcare Software

Healthcare consultation May 2015 - Present

Identify key metrics and develop value-add reporting

Assist in the creation and delivery of training materials

Create PowerPoint presentations with a high attention to detail and formatting

Reviews, analyzes, and evaluates business systems and user needs.

Documents requirements, defines scope and objectives, and formulates systems to parallel overall business strategies.

Identify trends and participate in problem-solving, investigation using Issue Resolution Methodology to make recommendations to the team

Collaborate with SMEs to develop new reports and report templates to support business needs(future state of Facets reporting)

Molina HealthCare Nov. 2012 –April 2015

Healthcare Analyst II

Responsible for developing reports for upper-level management to help them in their business decision making process with accuracy and in a timely fashion.

Responsible for design and development of analysis and reporting of claim, providers, authorization, members, financials, and clinical data using SQL server tools, statistics, and analytical techniques to fully understanding and trend the efficacy of the report.

Prepare monthly status reports, aid in corporate projects that deal with health care, compare medical budgeting to their prior analysis, and assist in customer service issues

Carefully reviewing report requests to get clear understanding of what is requested, gathering additional information as needed

Analyzing query results and clearly present findings both qualitatively and quantitatively to the requestor, strategically providing additional information that the end-user may need

Utilizing a robust QA process to present client with a finished product.

Interact with the business clients for report and ad-hoc data analysis requirement for the client’s request.

Agile HealthCare Software Aug. 2009 –Oct 2012

Data Analyst

41716 Grindstone Dr. Sterling Heights, MI 48314 - Email: ***********@*****.*** - Phone # 586-***-**** Kanari Abaas – Healthcare Analyst

Accumulated diverse skill set across various key roles in database analysis and numerous data integration project.

Responsible for database design and development of healthcare database for providers and payers. This involved requirements gathering, database design, table design, views, custom reporting and developing queries in SQL Server

Analysis and validate the analysis databases for Healthcare quality.

Developed custom analyses to support specific client needs and conducted analysis on client data as requested

Worked with the providers to develop specific views/dashboards and websites for the address their specific needs.

Expertise with analytical reporting using Excel features like pivot tables and chart.

Performed detail analysis of pharmacy, patients, and provides.

Basic knowledge of EDI (837 & 835) and their processing.

Developed internet sites to consume the database based on SQL Server 2008 R2.

Expertise with SSIS, SSRS, SSAS, SQL Management Studio, BI Development Studio, Report builder 3.0 to address client’s needs.

Lawrence Technological University (LTU) Nov 2006 – July2009 Student

Classes in database management, Enterprise Architecture, Information technology Life cycle and Design new Supply chain Management system.

GM Global Headquarters Renaissance Center, Detroit, MI Sept. 2004 - Aug2006 System Administrator

Creating and maintaining dealer profile to access the Billing & Accounts Receivable System

(BARS) with its seven subsystems

Creating and maintaining dealer profile to access the CVMS system to maintain and track the usage GM Corporation Company vehicles

Providing customer support for Bars and CVMS systems Network Medical Troy, MI Oct. 2002 – Nov. 2004

Programmer

Programmed and tested Medical Insurance Applications.

Periodically, update software for the Network Medical Clients

Identified and solved the client application issues using Talent and PC anywhere TECHNICAL SKILLS

Languages and Tools: SQL, SSAS, SSIS, SSRS, OLAP, Toad Data Point, Midinsight, TOAD, NATEZZA, and AGINTY

Technology tools: Provision, MS office, MS Word, Excel, MS Access, MS Power Point, Outlook, Quicken, Creative Solution, Lotus Notes, BARS, CVMS, PC Anywhere, NATEZZA, SQL Server, Toad Analysis, Toad Oracle, informatics

Operating Systems: Windows 7, 8, 2000, 2003, 2008, and 2012 EDUCATION

Master of Science in Computer Information system

University of Detroit Mercy, U.S.A, Detroit, MI, USA, (May, 1998) Keywords: Database development and management, Business architecture, process architecture IEEE 41716 Grindstone Dr. Sterling Heights, MI 48314 - Email: ***********@*****.*** - Phone # 586-***-**** Kanari Abaas – Healthcare Analyst

1058, ISO-IEC 15288, ISO 12207, SCOR, IEEE Std. 1062, CMM, ISO 9001, and Six-Sigma, enterprise IT architect (EITA), ITIL, TOGAF

Contact this candidate