Customer Service Data

Amit Kumar

House No. **, *nd Floor, Railway road, Vill- Gurgaon

Mobile: 098******** Email: **************@*****.***

Seeking a challenging Analyst - SAS Reporting career in the field of Data Analytics and Management.

Synopsis

Graduate in Economics over 6 Years of cross functional experience in the areas (Last 2.9 Years in SAS), Data Management, Development, Implementation and Installation.

Currently working as a SAS Programmer (Bus OPS Specialist Analyst).

An Out-of-the-Box Thinker, working towards continuous improvement in processes, streamlining workflow and creating a teamwork environment.

Excellent written & oral communication, inter-personal, liaison and problem solving skills.

Career Highlights

UHG Captive India SAS Programmer (Reporting Analyst) Since 2nd APR 2013

Brief Profile:

Experience of 2.9 years as SAS Programmer with good skills in SAS BASE, SAS MACROS and SAS SQL, SAS GRAPH and ODS.

Familiarity with cleansing, validating, and manipulating complex data using DATA-STEP PROGRAMMING, SAS PROCEDURES and SAS FUNCTIONS

Sorting and merging multiple large datasets to obtain curtailed summary tables and listings

Knowledge of SAS STAT procedures like PROC FREQ, PROC MEANS.

Generated daily, weekly and monthly reports using Proc Report and SQL DB2, Galaxy.

Well versed with Excel based modeling, proficient in PowerPoint and can manage big datasets.

Highly motivated, creative and energetic team player with exceptional skills in Reporting, Analysis, Operations Management, Customer Service, Data Management and Development

Project: - Decision Support Analysis May’13- Present

The project involved analyzing complex and critical transactional data of Healthcare. The objective of this to produce actionable information for the client to review and strategize up-coming –marketing scheme.

Which Plan should take away from market

Which plans is selling like a hot cake

here are certain variable like Copay, Coins, Deductible, OOP there are customer liabilities So, which plan has maximum frequency of the plan

Evaluating investment on per medical plan including marketing staff etc

Creating and automating business reports using SAS for various process.

Project: - Chiropractic provider June’14-present

Purpose of Report is to develop Control report for Chiropractic Provider Pick process change identified during Non-Covered Service Project

Manipulating data from server for Last 26 weeks, starting from the Sunday of the current week.

Develop a claim level report of total claims denying because "Chiropractic Provider Rendering Physical Therapy and/or E&M Services (Potential Provider Pick Error)" as well as adjustments.

Data manipulating from COSMOS Galaxy Data, 26 Week Trend, Denied Claims Only

STARS & CITURS Appeals (associated to denied claims)

Responsibilities:

Creating and automating business reports using SAS for various departments for a faster and valuable analysis to provide recommendations and suggestions to improve the overall business of the company and help them take strategic decisions.

Making changes to the code as part of the maintenance and developing new codes for data extraction

Converted external flat files into SAS data sets

Used INFILE statement options to control processing when reading raw data files

Performed Data Cleaning & Validation using data step and SAS functions

Used SAS Functions to manipulate character and numeric data

Extensively used PROC PRINT and PROC TABULATE to generate reports

Notable Contributions:

Perform Medical Insurance analysis and reporting.

Extracted data from the database using SAS/Access, SAS SQL procedures and created SAS data sets and user tables.

Data merging using proc sql/SAS

Worked on creating SAS Data sets from flat files and merging/appending data.

Maintained and enhanced existing SAS reporting programs for file validations.

Data processing and validations on the SAS datasets using edit check programs

to generate output formats in HTML,CSV, EXCEL, XML, PDF or RTF.

Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall business strategies.

Automating the codes using SAS macro.

Implementing the change requests raised by the business partners for suppressing and unflagging the policy holders.

Extracting data using DB2 and Galaxy database

After Graduation Joined UnitedHealth Group in the September 2009 as a claim associate

UHG Captive India Sr. Associate OCT 2011 to MAR 2013

Notable Contributions:

Handling appeal and finding cause of appeal.

Auditing claims and giving feedback to original R.A

Writing letter directly to the customer or provider in case of denial of claims and making payment.

Audited and reviewed the cases of the junior processors to ensure them on the right track.

To meet expectations in terms of Turn around Time timeline and Professionalism.

Analysing errors and checking updates from client. Taking care of error rebuttal process.

Technical Skills

Programming Language : SAS, fox pro, VBA

Operating System : Windows XP/2000/NT/2003 Server, DOS/UNIX.

Databases: : SQL SERVER/MS Access

Statistical Analysis: : SAS/BASE, SAS/MACROS, SAS/ODS, SAS/SQL, SAS/STAT

Other tools: : MS Office Suite – MS Excel, MS Word, MS Access,

MS PowerPoint.

Academia

Graduation (Economics.) From Bundelkhand University in year 2009 with Marks 69%

Intermediate with Statics, Economics from S.P.Y College. (Gaya) in year 2006 with Marks 59%)

Matriculation with all subjects from RHS Bambhai in year 2001 with marks 63%

Personal Dossier

Father’s Name : Sh. Awadhesh Sharma

Date of Birth : 02nd January 1986

Gender : Male

Marital Status : Married

Nationality : Indian

Phone. No. : 098********

E-mail ID : **************@*****.***

Linguistic Abilities : English & Hindi

Declaration

I do hereby declare that the statements mentioned are correct and true to the best of my knowledge. I shall be pleased to furnish any additional information if you wish to have.

Amit Kumar

Contact this candidate