DATA ANALYST Resume Springfield, MO - Hire IT People

TECHNICAL SKILLS:

Healthcare: Epic Hyperspace, Clarity SlicerDicer,Beacon.

Reporting tools: SAP Business Objects/webi Reports, QlikView, Tableau.

Business Modelling Tools: Salesforce, SharePoint.

Database & ETL tools: Microsoft SQL, Oracle SQL developer, SSIS, SSRS.

Programming Languages: Java, Python, CSS, HTML. MS Office Application Word, PowerPoint, VisioInfoPath, Advanced Excel (VLOOKUP, Pivot tables)

WORK EXPERIENCES:

Confidential, Springfield, MO

DATA ANALYST

Responsibilities:

Completed ad hoc requests and presented/reported results to organizational leadership.
Used SQL, Oracle SQL developer and python to extract data from various sources such as Clarity, EPIC Reporting Workbench and SAP Business Objects for various physicians, providers and management.
Used ETL tools SSIS SSRS to consolidate and transform the data.
Analyzed large data sets and organize information into charts, graphs, tables and reports using QlikView and excel.
Used QlikView for data visualization to improve data insights, narrate a story, and help business make better, data - driven decisions.
Generated reports through MS Access, MS Excel and MS SQL.
Used SSIS, SSAS ETL to create packages for payer reports (Aetna, UHC, Medicare).
Knowledge of ICD, CPT, HIPPA and Population Health Guides and claims data

Confidential, San Francisco, CA

DATA ANALYST

Responsibilities:

Used InfoPath to create many forms for the website such as simple approval forms, time cards and edited the various SharePoint list items.
Documented data lineage capture processes and develop guidelines and best practices.
Worked with Data analyst to populate data for the FCA and BSA.
Researched data software to be used in the future.
Identified the problem with the current process and creating a detailed analyzed solution with the team.
Worked with multiple stakeholders and LOB to understand the project requirements.
Utilized InfoPath to make the process flow smoothly.
Mapped out the processes and putting into InfoPath.
Revamped documents around FCA, finance, and credit team
Translate business requirements to Technical and non- technical team member.

Confidential, Pleasanton, CA

DATA ANALYST

Responsibilities:

Analyzed, reviewed, and validated the data according to new revenue standard ASC 606.
Manipulated data, extracting desired information and present data to senior management.
Performed Root Cause Analysis, Ad-hoc Analysis for discrepancy in customer’s billing
Transferred the data from salesforce to workday.
Assisted with preparation of other written reports, major deliverables, identifying trends in cost, revenue and other materials for clients.
Monitored neglected Leads, Opportunities, Accounts, and Contacts as appropriate in Salesforce.
Used VLOOKUP, Pivot table to manipulate in the excel.
Liaison with development team, finance team for the planning of the projects.

Confidential, Hay Ha ward, CA

BUSINESS ANALYST INTERN

Responsibilities:

Gathered business requirements from stakeholders and translated them into detailed requirement specifications.
Used SDLC (System Development Life Cycle) methodology Waterfall.
Prepared Business Requirement Document (BRD) and Software Requirement Specification (SRS).
Worked with development team and product development team to solve their queries.
Worked with testing team to develop test schedules and plans in the applications.
Scheduled meeting, planning agendas, prioritize the tasks and keep a record of MOM.
Collected and documented nonfunctional requirements related to data security for the data loads as wells as reporting layer.
Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams (UML).