ANURAG KUMAR

Phone: (M) +91-880******* Email: acqxba@r.postjobfree.com

Address: *-* ******** *****, **** E-15, Sector-61, Noida, India

To work in a challenging role with a milieu that would facilitate the maximum utilization and application of my broad skills and expertise in making a positive difference to the organization

synopsis

Strong analytical & problem-solving skills, effective written & verbal communication skills, interpersonal skills, organizational and multi-tasking skills, sound judgment and proficiency in tools and systems

Experience in developing program specifications and coded modules according to specifications and client standards

Provided production support through problems analysis and resolution to correct deficiencies through Automation of Reports.

Experience in requirements gathering and design for Reports, Database Structure, BI Setup, and Implementation etc.

Documented and executed statistical analysis plans, design report templates, calculate sample sizes, create randomization schemes/schedules.

Well-versed with SAS, MS Excel(VBA) and MS Access applications

Hands-on experience in Data Analysis, Producing Reports, Analysis Datasets, Summaries and TLG (Tables, Listings, Graphs)

Work proficiency Excel(VBA), SAS /BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH and PROC /SQL

Used SAS/MACROS to access, extract, modify, merge, and analyze data, and to generate statistical analysis outputs including tables, listings, graphs and reports

Profound knowledge on quality control, reliability testing & advanced statistical analysis.

Adept in co-ordinating multiple large-scale projects from inception to completion ensuring optimal utilization of resources leading to overall profitability

Ability to communicate effectively within a multi-disciplinary project team employees and external agencies to complete assigned tasks on time and within specifications

Core Strengths

SAS Programming

Excel(VBA) coding

Business Analytics

Data Analysis

Dashboard creation

MS. Access(Beginner)

Data Modeling

Software Development Life Cycle(SDLC)

Text Mining

Report Generation

MIS Reporting

Requirement Gathering & Analysis

Flexible & Adaptable

Troubleshooting Ability

Employment Chronicle

Reporting Analyst, Exl Service (Inductis), Noida (Since Mar ‘14)

Key Deliverables:

Experience in developing program specifications and coded modules according to specifications and client standards

Assisted in designing testing requirements and prepared test scenarios.

Responded and resolved production issues and client queries

Prepared Several Dashboards and Automation to avoid manual interaction and maintain accuracy.

Provided production support through problems analysis and resolution to correct deficiencies.

Documented and executed statistical analysis plans, design report templates, calculate sample sizes, create randomization schemes/schedules.

Prepared Excel tool to fetch data form Business Object(SAP) prepared report as per client requirement.

Managed large volume of data and derived analysis which helped client to improve their system.

Text mining to maintain smooth operation of their claim management system and monitor performance of their employee (WCS).

Projects Handled

Worker Compensation for Logistic Client (Since March ‘14)

Projection to identify the amount reserved for compensation for their employee in future.

Preparation of several Dashboards containing several graphs, table, and made several projection to identify and compare claim form last month and last three year, on the basis of their area, division, terminal, location, job type and body part loss etc.

Text mining to identify several different kinds of notes placed for claimant to maintain smooth operation of their claim management system and keep status track of their employee.

Text mining also helps for the performance monitoring of their “Worker Compensation Specialist”.

Reporting and keep trend of compensation amount paid for last few year.

Identify claim type on basis of all the payment made to claimant.

Version: SAS 9.2, MS. Excel (2010) MS. Access (2010)

Environment: SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/SQL

SAS Programmer, Astrol Infotechnologies, Noida (Since May’13 till Jan‘14)

Key Deliverables:

Efficiently handling and managing massive volumes of data (large SAS Data sets with upwards of tens of millions of records

Responsible for developing new programs and proofing the program to develop needed changes to assure production of a quality product

Design and develop programming systems making specific determinations about system performance

Involved in Software Testing and its implementation

Instrumental in providing recommendations to management concerning issues of programmer productivity and software development management

Involved in Debugging and in solving the technical issues

Projects Handled

Credit Scoring for Banks (Since Jun‘13 till Jan‘14)

Controlling risk is a delicate business.

Too much credit exposure can lead to high default rates and charge-off percentages, too little exposure often means lost business and revenue. SAS helps banks manage this balancing act with SAS Credit Scoring for Banking, which provides fast, accurate credit scoring for nearly all consumer-lending products.

Version: SAS 9.1.3

Environment: SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/SQL

Academia

Bachelor of Applied Science (Honors) BCAS, Delhi University 2013 69%

oMajor Specialization: Instrumentation and Industrial Quality Control

Trainings Attended

Fresenius Kabi Oncology Ltd (formerly owned by Dabur India)

Description: analysis of drug

Responsibilities:

Gained knowledge of project analysis and analytical modeling of drug release pattern and amount

Assisted in analysis of drug samples using Analysis of Variance (ANOVA)

Performed sensitivity analysis for amount of drug (ppm) and its release mechanism

Conducted ratio analysis and performance evaluation for group sample

Extramural Engagements

Volunteer with Delhi University's National Social Service Unit 2010-13

Personal Minutiae

Date of Birth: 20thApril, 1993

Linguistic Proficiency: English& Hindi

References: Furnished upon request

Contact this candidate