Data Analyst

SWETA SHRESTHA

*******@*****.***

**+ years of experience in US healthcare data analysis and data operation work

TECHNICAL SKILLS

Proficient in: SQL/PLSQL, T-Sql, Oracle 9i/10g/11g, Microsoft SQL Server 2008, MS Access

Programming languages: C/C++, Visual Basic, Java, ASP

Experience working with secure sites and sensitive data

Tools: MS Office, Remote Desktop, Tortoise SVN, SQL Tools, WinSCP, VNC Viewer

Project Management: Software Project Management, Software versioning and release management, software development lifecycle, CMMI process implementation

EXPERIENCE

1.Data Operations Analyst (July 2014 – till now) in Verscend Technologies - Revenue, Quality & Compliance

Responsibilities:

Worked as a key team member in Verscend Technologies Quality Intelligence team with Clients like Medica Health Plan.

Worked on Retrieval and Abstraction project for the clients like Blue Cross Blue Shield Rhode Island, Public Consulting Group and Cook Childrens Health Plan.

Communicate with client in regularly basis regarding the client data

Assisting the team members with technical issues related to the tasks.

Monitor the work going on in the teams and give suggestions on improvement areas.

Act as a mentor to junior team members, guiding and helping them in their daily work

Deliver client specific custom reports within stated turnaround times

Documentation of translation notes in case of special need

Prepared Client specific custom translation scripts and client specific custom reports

Data Analysis on US HealthCare Data and problem solving ability with the client data issue.

Data Validation and Verification for the custom scripts prepared.

SQL/PLSQL and T-SQL Scripting

2.As a Senior Software Engineer (April 2010 – June 2014) in Verscend Information Technologies, Nepal (Subsidiary of Verscend Technologies Inc., USA)

Responsibilities:

Work on US HealthCare data with the domain expertise in QI & MI product suites

Work on internal development projects and client specific runs for processing NCQA Certified HEDIS measures and analyze results.

Responsible to analyze and problem solving in the client major data issues.

Communicate with MN team daily basis through mails regarding clients’ issues or any updates in weekly calls.

Perform Data validation and ensure accuracy and quality of data to be compliant with the HEDIS Standard Input Specifications.

Client data processing with Quality Engine to calculate NCQA Certified HEDIS measure results.

Conduct analysis on their HEDIS measure results.

Data mapping and modification as per the changes made in file format as per its layout specifications

3.As a Software Engineer (April 2008 – March 2010) in Verscend Information Technologies, Nepal (Subsidiary of Verscend Technologies Inc., USA)

Responsibilities:

Worked as a Team Lead in Sightlines Medical Intelligence with Clients like Lockton Benefit Group, Mercer Consulting.

Prepared Client specific customized Import and standard Scrub Scripts

Data Analysis on US HealthCare Data and Data Transfer

Data Validation and Verification

SQL/PLSQL and T-SQL Scripting

Prepare client specific customized reports and communicate with WPM regarding the issues.

4.As Associate Software Engineer (August 2007-March 2008) in Verscend Information Technologies, Nepal (Subsidiary of Verscend Technologies Inc., USA)

Responsibilities:

Prepare import scripts for U.S. HealthCare Client Data loading.

Data Analysis

Data Processing

Preparing Scrub Scripts to fit the client data in the standard format.

5.As Management Trainee (Software) (Feb 2007 – July 2007) in Verscend Information Technologies, Nepal (Subsidiary of Verscend Technologies Inc., USA)

Responsibilities:

Assisting Senior VIT Employees in Client Project WellCare with Database Programming and Data Analysis on US HealthCare Database.

6.As Junior Programmer (May 2006 – Jan 2007) in Inficare Unlimited Technology

Responsibilities:

Making user manual

Designing front end user interfaces

Coding, Testing and maintaining the entire software like –

o International Labor Organization (ILO)

oChild Management Software of Nepal Rugmark Foundation

o RNAC Flight Movement

oFARRMS (recently known as Pioneer Solutions Nepal (Pvt.) LTD.

KEY PROJECTS

1.Quality Intelligence (QI) (Jan 2012 – till now)

Verscend Technologies Quality Intelligence has been providing quality services by reporting and sharing the commitments to healthcare quality improvement.

Responsibilities:

SQL/PLSQL programming using SQL Tools for both client data processing and other internal projects

T-SQL using SQL server 2005/ 2008 for processing client data and in some internal project development

Perform Data validation to compliant with the HEDIS data standard.

Client data processing with Quality Engine to calculate NCQA Certified HEDIS measures and analyze results.

Conduct analysis on their HEDIS measure results.

Data mapping and modification as per the changes made in file format as per its layout specifications

Communicate with MN team daily basis through mails regarding clients’ issues or any updates and we have weekly calls with them.

2.Sightlines Medical Intelligence (SMI) (Aug 2007 – Dec 2011)

Projects, I was involved focused mainly on data analysis of US Health Care, which involved data import, preparation of business logic and detail data analysis and problem solving techniques.

Responsibilities:

Scripting and unit testing Import and Scrub Scripts in SQL/PLSQL and T-SQL

Data analysis of imported data and prepare standard business logics.

Data verification and data validation

Analyzed raw data for Implementation Clients and performed regular analysis, developed and implemented standard business rules in raw data for monthly maintenance

Communicating with Project manager in Waltham regarding existing data issues and problems facing through in-house online monitoring tool (OAM)

Major Client: Lockton Benefit Group (one of the biggest Brokers in US), Nutur (Nurtur’s position as a leader in health and wellness), Mercer Consulting and many more.

3.Other Projects:

a.Project: International Labour Organization (ILO) Software

Responsibility: to develop software for the management of child and Adult Baseline Information along with their Tracking Information (for both Head Office and its partners)

Tools used: Visual Basic, SQL Server (for Head Office Software),

MS Access (for its partners).

b.Project: International Money Express (IME) Website

Responsibility: to do the testing of the entire website with the intention to make the product operate according to the specification mentioned.

Tools used: ASP, MS Visual InterDev

Web Server: Internet Information Services (IIS)

c.Project: RNAC Flight Movement

Responsibility: to create stored procedures, forms and test the system.

Tools used: PHP and MS SQL Server

Web Server: Internet Information Services (IIS)

d.Project: FARRMS (recently known as Pioneer Solutions Nepal (Pvt.) LTD. office)

Responsibility: to create forms, reports and user manuals for the application.

Tools used: PHP and MS SQL Server

Web Server: Internet Information Services (IIS)

EDUCATION

1.B.S. in Computer Science (BCA, Purbanchal University, Nepal 2003)

2.BCA Honors, Purbanchal University, Nepal 2004

3.Enrolled in EMBA program but had to dropout as I was moved to US office by my company.

CERTIFICATION

1.Health Insurance Portability and Accountability Act (HIPAA) certified

2.Security Awareness with Privacy Principles 103: Verisk Analytics

3.Communication Skill, Telephone Skill and Personality Development Course

Contact this candidate