Resume

Sign in

Data Analyst in Healthcare

Location:
Chicago, Illinois, United States
Posted:
February 02, 2018

Contact this candidate

POOJA SOLANKI

E-Mail Id :- ac4bei@r.postjobfree.com

CELL :- 302-***-****

HIGHLIGHTS

Over 5+ years of experience as Data Analyst in Healthcare domain working with Patient, Billing and scheduling data

Experienced in database management and extensively used query tools like SQL and Excel

Hands-on Experience with SQL (DDL, DML, Views, Joins, sub-querying)

Worked on data migration/import and data import from heterogeneous data sources like Excel, Flat files

Experienced in Data warehouse, such as dimensional modeling, star/snowflake schema and fact and dimension table identification

Experience in Stakeholder management, requirement elicitation

Experience in conducting change management, Requirement workshop sessions

Involved in mapping source system data to target system and validated

Performed Data scrubbing, Data staging and data validation in preparation of pushing data to production environment

Changed the scope of Pediatrics and Surgery Dept. logs by creating databases, statistical graphs/charts and forms.

Hands on experience in Software development methodologies such as Waterfall and Agile.

Practical Knowledge in creating, documenting, prioritizing and managing EPICs, user stories, funcationalities and features by using JIRA

Experience in writing Business Requirements Documents (BRD), Use Case Specifications, Functional Specifications, Requirement Traceability Matrix (RTM) as the Deliverables of a different project

Hands on Experience in UML for creating Use Case, Activity Diagrams, and Sequence Diagrams

Excellent knowledge of Health Insurance Portability and Accountability Act (HIPAA) transaction, code set rules such as EDI 837, 835, 270, 271, 276, 277 and ICD9-ICD10

Motivated individual and team player with excellent communication, interpersonal skills with an attitude to learn or explore new areas of technology

SOFTWARE

SDLC Methodologies

Waterfall, Agile, Spiral, RUP, and Prototyping, Iterative and increincremental model

BI Tools

Tableau, qlikview

Database/Migration tools

Excel, SQL, flat files, EDI, ETL

Languages

SQL, oops concepts

Requirement Management tool

JIRA, trace cloud

Business modeling tools

Visio, Smart Art

Domain Snapshot

Ban Health Care, Insurance

WORK HISTORY

Medical Center of Plano - Texas May 2013 – Dec 2017

Healthcare Data Analyst

Description: Medical center of Plano is a hospital located in Texas. The Project involves designing and developing web application based on customer’s requirements and generation of multiple kinds of reports.

Responsibilities:

Worked closely with a diverse group of stakeholders and elicited the project requirements

Created and managed user stories and corresponding acceptance criteria by using JIRA tool

Collated, documented and analyzed medical data based on clients and medical professional’s requirements

Formulated procedures for data extraction, transformation, and loading of healthcare data.

Prepared monthly, quarterly, annual metrics and ad hoc reports for executive management and board of directors

Involved in database management, performance measurement and performance tuning for database

Environment: MS Visio, SQL, Windows 2000, MS Office, UML, Tableau

AFAS Software, Aruba May 2012 – Apr. 2013

Revenue Cycle Management Department

Revenue Cycle Management Analyst / Coordinator

Facets tables SQL data pulls for Provider and Member level revenue analysis.

Facets tables SQL data pulls to identify chronic condition suspects for pursuit via off-site physician chart reviews.

Prepared Monthly Executive Dashboard for Finance Dept.

Data import, sturcturing, organizing data from oracle to excel.

Data comparison and validation in SQL as per business rules.

oEnvironment: Java, SQL, MS Office

Walmart Pharmacy, Merrillville, Indiana 2010 – 2011

Pharmacy Technician

Help maintain smooth operation of the pharmacy by working alongside the healthcare providers in an effort to create the best customer experience for the patients.

Maintaining inventory levels, anticipating needed supplies and medications, placing orders, answer telephones regarding requests, filling bottles with prescribed medications, and referring inquiries to the pharmacist.

Maintain a safe and clean pharmacy by complying with all the procedures, rules, and regulations.

EDUCATION SUMMARY

XAVIER UNIVERSITY SCHOOL OF MEDICINE, Oranjestad, Aruba

Doctor of Medicine

WALDEN UNIVERSITY, Minneapolis, MN

Bachelor in Healthcare Management



Contact this candidate