Resume

Sign in

Data Analyst

Location:
Woodbridge Township, New Jersey, United States
Posted:
January 24, 2018

Contact this candidate

Hanuh Agrawal

Email ID

ac354w@r.postjobfree.com

Contact No

+1-203-***-****

Summary

Total Experience

** *****

Currently working as Data Analyst for Tata Constancy Services –with Client AIG, New York, USA.

Experience in Data warehouse design, Data Intelligence and Data Mining.

Experience with Analytics tool like SAS EG 7.1, Tableau

Expertise in Data warehousing design, Data Mining.

7 Years of Experience in SQL and PL-SQL

Oracle Certified Associate (OCA).

Hadoop Framework with Pig and Hive programming.

Hands Experience on Database tools like SQL Developer, SQL Management Studio

5 year of Experience in Enterprise reporting tool SAP -Business Objects.

Exposure to other Reporting tools like Crystal Reports.

Extensively worked on different versions of oracle DB from 9i to Oracle 11g

Have 4 years of IT Experience in Finance Domain and Insurance Domain

Have 3 years of IT Experience in Telecom Domain

Conducted trainings on Business Objects and SQL Pl/SQL.

Quick learner, good team member, perseverant and energetic with good Communication Skills.

Employment History

Company Name

Designation

Start date

End Date

Tata Consultancy Services

Consultant

Oct 2011

Till Date

Keane India Limited

Consultant

Sep 2010

Sep 2011

Tech Mahindra

Senior Technical Associate

Dec 2009

Sep 2010

Satyam Computers Services Ltd

Senior Software Engineer

Jan 2008

Dec 2009

Domain Expertise

Domain

Company

Experience

Insurance

AIG

1 year

Finance

Financial Hedging GE-Treasury

4 Years

Telecom

AT&T, Nokia Siemens Networks

3 Years

Education

ACCA

1 Years

Technical Expertise

Primary Skills

Experience

Secondary Skills

Experience

Data warehousing

7 Years

SAS EG 7.1

3 years

Data Analysis

5 years

Business Objects

4 Years

SQL Developer

7 years

Tableau

1 year

PL/SQL

7 years

Crystal Reports

2 years

Oracle DB

7 Year

Java

2 years

Education

Degree

Course

College / University / Institution

Year of Passing

Bachelor of Technology

Electronics

Uttar Pradesh Technical University

2007

Engagement Overview

1. Project Name

Rater Data Mart Preparation

Start Date

Jan’16

Client

AIG

End Date

On Going

Project Location

New York, NY

Team Size handled (If applicable)

NA

Project Description

Rater Data mast is a project to gather data from more than 100 raters. With each rater having different parameters and open for un-validated data entry. Data-stage, ETL tool is put in use to make the data meaningful and consistent for Actuary reporting.

Role / Responsibilities

Data warehouse Designer

Contribution:

Writing SAS Programs to fetch raw-data from Raters.

Creating DataStage Jobs for Transforming the data

Discussing the final reporting needs of the client

Analyzing the Data for reporting and creating additional requirement and value adds

Finalizing DWS design changes and addition of measures and dimensions

Creating and updating Business requirement document as more raters are added

Attending client meetings to convey technological constraints and deciding timelines

Creating aggregate tables for faster retrieval.

Presenting Demos to the client.

2. Project Name

International Tax report Automation

Start Date

Jun ‘14

Client

GE Treasury

End Date

Jan’16

Project Location

Stamford CT

Team Size handled (If applicable)

3

Project Description:

GE has businesses spread to many countries and different countries have different tax structure. Large numbers of regulatory reports are prepared for that called Tax reports. Most of these reports being highly technical and hence cumbersome to change were run on old excel based system. Project was to transform the complete tax reporting structure and automate the reporting process.

This project included the update of existing data warehouse and fetching data from it model and creating a report based on that.

Role / Responsibilities

Data Analyst

Contribution:

Studying the source data for the reporting needs

Identying the measures and dimentions for the data

Creating the datastage jobs to fetch the data from systems

Creating data transformation jobs to

Daily meetings with client and understanding the benefits of creating these reports

Understanding international tax laws and formulas

Creating report template with the sample data.

Identifying the missing data source and including them in the data-warehouse

Creating UAT test cases

Engaging Development team and making them understand each and every functionality of the report

Engaging QA team and making sure all functionality is covered and no non required bug is raised.

3. Project Name

SUT and VAT

Start Date

Jun ‘14

Client

GE Corporate

End Date

Jan’12

Project Location

Noida, India

Team Size handled (If applicable)

Project Description:

GE corporate is where various taxes like Sales and User Tax and Value added taxed corded. They have a terabyte size of Data warehouse that is fed monthly with all tax related data.

I use to analyze the source system for reporting needs and make fields available to Data warehouse for reporting. I use to data mining to make help out the meaningful also used to crate reports on reporting tool Called Business Objects and maintain the overall Tax reporting system

Role / Responsibilities

Data Analyst and Report Developer

Contribution:

Daily meetings with client and understanding the benefits of creating these reports

Identifying the user needs and creating VAT and SUT reports.

Identifying the missing data source and including them in the data-warehouse

Writing PLSQL triggers for auto update of tables.

Creating test cases

Engaging QA team and making sure all functionality is covered and no non required bug is raised.

Environment: Oracle 11g, Business Objects, Datastage

Previously to the above mentioned projects I have worked on many projects from Jab 2008 to Aug 2013 with clients like NSN technologies, ACCA, AT&T, Qatar bank that gave me exposures to many technological platforms like Java, Oracle ADF, and Crystal Reports and helped me acquired invaluable Multi-Domain IT knowledge.

Personal Details

Gender

Male

Location

New York, USA



Contact this candidate