Rajeshwari.G

***-****/****** **-*******-V*E *H*

Mobile: 778-***-****

Email id:ac8o4p@r.postjobfree.com

Objective:

Seeking statistical analyst/consultant position in a growth oriented firm requiring experience in statistical modeling and programming, assessing business requirements, and involving large scale interactions and market focus.

Profile:

Close to 5 years of experience as a business analyst in Insurance domains. I have been involved in continuous customer interactions to understand business issues and suggest optimizations. I am well organized with a track record of self-motivation, team spirit, learning and initiative to achieve both personal and corporate goals.

Tools and Technologies:

SAS 9.3

SAS EG

SAS Studio

SQL

Tableau

R Studio

Python

Excel

Aginity Work Bench

Amazon Web Services

Cognos Report. Studio

Mainframes

Data Base:

I

IDW Netezza DB2

SDLC Methodologies: Agile –Agile tools: JIRA

Educational Details:

Master of science from Gitam university –Visakhapatnam(India)-2010

Bachelor of Science srisarada degree college –Hyderabad(India)- 2008

Board of secondary and intermediate education - Hyderabad(India)-2005

Professional Experience:

WNS Global Services pvt.ltd(Bengalore-india) (Client:Suncorp-Australia) August 2013 – Apr 2018

My role includes understanding business requirements in depth, and analyzing and interpreting data to make meaningful conclusions from the results.

Developing, maintaining and monitoring complex reports on a daily, weekly, monthly,half-yearly&yearly basis using SAS 9.3, SAS SQL and SAS Macros SAS E-guide, Netezza, Cognos, Tableau,Excel.

Report Automation using SAS Macros and Netezza

Developing various excel and pivot tables, vlookup,index/match

Creating pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.

Generating the adhoc reports to solve client inquires.

Migrating SAS Codes to SAS Studio in Cloud Environment using AWS

Creating reports based on metrics like strike rate, Age of debtors performance, and the customer delight using SAS Report procedures, SAS ODS.

Hands on experience of working with BI tools as Cognos, SAS and Visualization tool Tableau.

Creating and maintaining detailed documentation to ensure accurate execution of reports/projects

Interacting with key stakeholders based out of client site for scoping initial requirements and refining them as the project progresses.

Develop and implement data Quality control and monitoring solutions to develop data Quality

Interacting with the client team based in austrelia&handling issues which are which are related reports and addressing ad-hoc request for specialised reports.

Liaise with onshore/offshore stakeholders to define problem statements, design the relevant analytical solution and ensure effective implementation of the solution

Perform and document data analysis, data validation, data mapping/design, produce data samples/prototypes and produce ad-hoc reports. Obtain and analyze data by accessing multiple sources

Detailed Project Descriptions:

Project #1:

Name

SAS Migration Project

Description

This project dealt with migrating Existing SAS Codes to new

platform which is AWS Cloud from on premise

Organization

WNS – Suncorp

Duration

From June 2016 Apr 2018

Environment

Database: Netezza,DB2,IDW

Tools: SAS 9.3,SAS EG,SAS Studio, AWS Workbench

Analysing the data sources in different SAS Codes which were used for reporting Setting up Workbenches in Amazon Work Space

Moving the data required for reporting to SAS Workbenches

Remediating the SAS codes to be compatible with SAS EG & Cloud Environment Validating and Reconciling the

Project #2:

Name

Vero/Aami Packages

Description

This project deals with Capturing the Sales performance

based on different metrics, including region, Brokers,

BDMs, Occupations

For different brands of suncorp namely Vero,Aami

Organization

WNS – Suncorp

Duration

From January 2016 May 2016

Environment

Models/Techniques : Descriptive & Diagnostic

Database: Netezza,IDW

Tools: SAS, Aginity Work Bench, MS Excel,Tableau

Responsibilities:

Understanding client’s requirements

Extracting Data from different sources and transforming as per needs

Developing Templates and showcasing it to business in excel

Representing results in Tableau and PowerPoint presentation

Project #3:

Name

Ad-Hocs Requests

Description

Different Ad-hoc requests based on client requirement

such as:

Amex customer extraction

ESL Data Extraction for Monitor

Data Source Remediation

Commercial Insurance Strike rate for different

Brands

Building Tableau Dashboard for Vero Sales

Organization

WNS – Suncorp

Duration

From January 2015- Dec 2017

Environment

Models/Techniques : Reporting/Descriptive

Database: Netezza,IDW

Tools: SAS,Tableau,SQL,Aginity Workbench

Responsibilities:

Understanding client’s requirements

Extracting Data from different sources and transforming as per needs

Developing Templates and showcasing it to business in excel

Representing results in Tableau or excel or PowerPoint presentation

Contact this candidate