Data Analyst Health

MONISHA SUSAN MANI

E-Mail ID : adjmso@r.postjobfree.com

Mobile : +1-206-***-****

Linkedin URL : Linkedin/Monisha-Susan-Mani

·Experienced Data Analyst/SQL Analyst/Data Quality Analyst/Analyst with 3years of experience in IT, Medical, service and insurance of US health care industry

·SQL skills including but not limited to creating queries, procedures, database triggers to collect profile and scan data.

·Hands-on experience with MS SQL Server, MySQL database environment.

·Experience in DBA activities like Database Backup/Restore preparation.

·Experienced in data mapping, data modeling and collecting multiple data metrics for marketing, performance, ROI and customer-level engagement projects.

·Research health care trends and changing regulations that may impact provider coding behaviors (health data, population health, risk adjustment, health care initiatives,EMR) .

·Validate clinical reporting results to ensure what is being reported accurately reflects client needs/expectations/goals and Query client specific data base using SQL

·Business Intelligence experience including requirements, data analysis, designing /modeling relational DB, transformation and conversion, report development and prototyping, root-cause analysis, reverse engineering and data reconciliation, ETL process, Meeting SLA.

·Worked on data validation, report validation using excel, SSRS (SQL Server Reporting Services)

·Strong time-management skills and ability to work within tight deadlines and client support.

·Good analytical and communication skills and ability to work independently with minimal supervision and contributing productively as a team member.

PROFESSIONAL EXPERIENCE:

Organization

Designation

Duration

Pactera EDGE

Data Analyst 1

October 2020 -Present

ABCO Advisory Services India Private Limited

Data Analyst

July2015 – April2016

ABCO Advisory Services India Private Limited

Junior Data Analyst

July 2013-July 2015

TECHNICAL SKILLS:

Operating Systems

Windows, Linux

Databases & Tools

MySQL, MS SQL Server,SQLite

ETL

Data Manager

Reporting Tools

Microsoft SSRS, Tableau, Microsoft Excel (pivot tables, lookup functions, formatting etc.)

Web Technologies

XML/HTML/DHTML/CSS

Ticketing Platforms

Jira, Sales force, Clarizen

Languages

SQL, Python

Microsoft suite

Microsoft Excel, Power point, word, one note, outlook

EDUCATIONAL QUALIFICATION:

Qualification

University/ Board

Institution

Year of Passing

BE- Bachelor of Engineering

(Computer science Engineering)

Visvesvaraya Technological University

Shirdi Sai Engineering College, Bangalore, India

2013

WORK SUMMARY:

PROJECT 1

AI AND SPEECH TECHNOLOGY

Company

Pactera EDGE

Client

Microsoft

Environment

Compliant Speech Annotator

Duration

October 2020-Present

Role

Part Time Data Analyst

DESCRIPTION

AI and Speech Technology, utilizes data inputs based out of transcribed audio scripts to feed various AI and machine learning models

ROLES AND RESPONSIBILITIES

·Analyze the data in audio scripts then, transcribe and data entry them according to the PII, child speech, robotic speech, distorted speech, blank speech.

· Listen to the audio recording and insert tags when necessary (background noise or additional voices)

PROJECT 2

CRIMSON CONTINUUM OF CARE (CCC)

Company

ABCO Advisory Services India Private Limited, India (Optum company)

Client

Major Hospitals in US

Environment

MS SQL Server 2008 SSRS, SSIS, MS Access, Excel, Excel Data Analysis features, Excel VBA, MS Word

Duration

Dec 2013 – April2016

Role

Data Analyst/Junior Data Analyst

DESCRIPTION

Crimson Initiative is an end-to-end software solution that intelligently evaluates a broad range of measures to provide a comprehensive physician performance analysis. Using the Crimson Initiative, you can quickly and effectively assess overall performance of one or more physicians based on a common set of criteria.

ROLES AND RESPONSIBILITIES

·Corrected any data entry error to prevent later issues such as duplication or data degradation and Analysis of case scenarios in the database using SQL

·Research health care trends and changing regulations that may impact provider coding behaviors (health data, population health, risk adjustment, health care initiatives,EMR) .

·Validate clinical reporting results to ensure what is being reported accurately reflects client needs/expectations/goals and Query client specific data base using SQL

·Having hands on working experience in business application which includes Insurance, Medical, Service provider in US Health care industry

·Extensive experience in design, development and implementation of databases, tables, views, stored procedures, triggers of the client as per their requirement.

·Investigated and addressed issues to enhance usability and improve functionality and interpret anomalies in data results

·Created various Excel documents to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources.

·Give clinical/healthcare insight/input to assist in helping solve data issues as they arise

·Developed database objects, including tables, views and materialized views using SQL.

·Researched and resolved issues regarding integrity of data flow into the client databases.

·Participated in requirements meetings and data mapping sessions to understand business needs.

·Developing technical solutions by defining, analyzing and documenting various clients’ requirements for business problems and to advance the hospitals revenue efforts

PROJECT 3

CRIMSON POPULATION RISK MANAGEMENT (CPRM)

Company

ABCO Advisory Services India Private Limited, India(Optum Company)

Client

Major Hospitals in US

Environment

MS SQL Server 2008 SSRS, SSIS, MS Access, Excel, Excel Data Analysis features, Excel VBA, MS Word

Duration

July2013 – Dec 2013

Role

Junior Data Analyst

DESCRIPTION

Crimson Population Risk Management helps hospitals manage total cost and quality for defined populations including self-insured employee plans and inform risk-based contract negotiations with payers. CPRM provides access to aggregated medical, pharmacy claims data and identifies high risk individuals and individuals by chronic condition to allow for care management program planning.

ROLES AND RESPONSIBILITIES

·Responsible to develop scripts which is essential for file process and data validation.

·Responsible to develop stored procedures, triggers, views etc., in MS SQL Server 2008.

·Responsible for performance tuning.

·Develop components of databases, data schema, data storage, data queries, data transformations, and data warehousing applications.

·Analyzing Problems in the system and making recommendations for system improvement

·Responsible for Designing and developing new systems with an emphasis on minimized maintenance requirements, as well as performing maintenance and enhancement of existing systems.

·Responsible for interfacing with end-users for the purpose of design and implementation of new systems/functionality and troubleshooting problems with existing systems.

·Developing custom reporting solutions using SQL Server

·Actively participate in group technology reviews to critique work of self and others.

·Write documentation and communicate database design.

·Developing technical solutions by defining, analyzing and documenting various clients’ requirements for business problems and to advance the hospitals revenue effort.

INITIATIVE

ACTIVITY TRACKER

Environment

SQL Server 2008,MS Visual C# express

Duration

July2013 – April2016

Role

Data Analyst/Developer

·

DESCRIPTION

It’s an application built internally to track the time taken for project activities of each employee

ROLE AND RESPONSIBILITIES

·Responsible to write C# codes for the application and the procedures that supports the backend job.

·Developing custom utilization reports for the internal company needs.

PERSONAL VITAE:

Date of Birth : 03rd June, 1991

Nationality : Indian

Languages Known : English, Malayalam, Hindi, Tamil

Contact this candidate