GAURAV BHADOURIA

Mobile: +91-979*******

E-Mail:

To obtain a challenging analytics position where I can bring my strong analytical skills, technical skills and expertise to the forefront to drive business decisions as well as help in grooming personal development to achieve the operational and organizational goals.

PROFESSIONAL SUMMARY

Data Analyst Tata Consultancy Services Limited Feb 2016 – Till date Having total experience of 5 years with Tata Consultancy Services Ltd. with current designation as IT Analyst in Data Analytics, Reporting and Data Warehousing projects and maintaining Business intelligence solutions by providing consultancy to the client for their business problems and effectively implementing the best analytical solution which includes Requirement Understanding, Architecture Design, Agile Work Model, Development and Testing (Unit Testing, System Testing, Regression Testing) and Reporting. Technical Skills:

Tools: Tableau, Jira, Mission Control, GitHub, Microsoft Teams, MS Excel, CA Workload Automation.

Programming Languages: UNIX (Putty).

Database Languages & Tools: Netezza (IBM Pure Data): PL/SQL, SQL

ETL: Basic Informatica (Powercenter).

AWS services: S3,Glue scripting, Redshift ( PostgreSQL) EXPERIENCE FORTE

Since Jul’16 Tata Consultancy Services Ltd. I.T Analyst PROJECTS

Analytical Data Ware housing & Reporting Projects (BI)

MTM Changes ( Product Hierarchy)

Position: Developer/Lead

About the Project:

This is enhancement project which evolves around the product hierarchy changes. In our existing system we are storing the product related information. So we have to maintain all the downstream application with this change

Responsibilities:

i. Involved in analyzing the client requirements and preparing the design documents. ii. Testing the entire changes and tested code in simulated production environment. iii. Providing Knowledge Transition Session for offshore DevOps team after each iteration. iv. Skills and Tools: SQL, IBM Pure Data (Netezza), Tableau

Patient Affordability Program

Position: Developer/Lead

About the Project:

This system is created to keep the patient related information at centeric location (DataMart) and then does the reporting to analyze the cost spend by the company on patients. Data deals with vouchers, copay cards etc.

Responsibilities:

v. Involved in analyzing the client requirements and preparing the design documents. vi. Developed the backend (DataMart). Receiving many feeds from different vendors. vii. Developed front end report for end users to identify the cost Bourne by the company on yearly/quarterly/weekly basis and the various counts viii. Testing the entire changes and tested code in simulated production environment. ix. Providing Knowledge Transition Session for offshore DevOps team after each iteration. Skills and Tools: SQL, IBM Pure Data (Netezza), Tableau

State Price Transparency Reporting

Position: Developer

About the Project:

This system intends to create an analytic solution to automate pricing process to determine what requirements are needed by each state.

Responsibilities:

i. Involved in analyzing the client requirements and preparing the design documents. ii. Involved in making Business rule file by identifying various states business rules. iii. Developed front end report for end users to identify the compliance of price changes with respect to State price laws.

iv. Testing the entire changes and tested code in simulated production environment. v. Providing Knowledge Transition Session for offshore DevOps team after each iteration. vi. Skills and Tools: SQL, IBM Pure Data (Netezza), Tableau

Payer Re-Write Reporting

Position: Developer

About the Project:

This system intends to consolidate 5 Payer workbooks into 1 workbook to enhance the visualization by using standardized views that are visually appealing and allowing user to gain insight on key metrics

Responsibilities:

i. Involved in analyzing the client requirements and preparing the design documents. ii. Involved in making consolidated workbook by using various Tableau charts. iii. Testing the entire changes and tested code in simulated production environment. iv. User Acceptance Testing and Production support from offshore for the developed code with clients data for clients acceptance.

Skills and Tools: SQL, IBM Pure Data (Netezza), Tableau ACADEMIA

2019 M.C.A (Masters of Computer Application) from Sastra University, Thanjavur (Tamil Nadu) with 7.2 CGPA

2015 B.C.A (Bachelors of Computer Application) from Bundelkhand University, Jhansi with 72% 2012 12th from Kendriya Vidayalaya, Jhansi CBSE with 62% 2010 10thfrom Kendriya Vidayalaya, Missamari (Assam) CBSE with 82% TRAININGS / WORKSHOP ATTENDED

Successfully undergone the following trainings on:

Successfully completed the 6 weeks of Java certification from APTECH institute.

Successfully completed the 45 days of PHP certification from DataSoft Institute. ACHIEVEMENTS

Bagged the few on the spots awards in office.

Got the appreciation from the vice president and senior management of the client side

Represented School cricket Team at District level in Cricket in 2012.

Member of the school basketball team and represent at Regional level in 2010 Positive Traits and Strengths

Positive Attitude towards work with an urge to improve at every point of time

Quick and flexible learner and trained to work in dynamic and collaborative work environment

Have excellent communication and analytical skills. Capable of guiding and helping team to achieve project goals.

Self-motivated with “Can Do Attitude”

.

PERSONAL DOSSIER

Date of Birth: 16th October 1994

Address: D-164/777, Janta Colony, Etawah

Contact this candidate