Resume

Sign in

Sas Project

Location:
Pune, Maharashtra, India
Salary:
69320
Posted:
April 21, 2021

Contact this candidate

Resume:

Shriram Ramesh Dahotre

B.E. – Computer Science

E-Mail: adlu0a@r.postjobfree.com

Mobile: +91-992*******

Objective

To work with a dynamic and result oriented organization which provides a challenging career and actualizes my skills and abilities in the field of DWBI.

Academic Qualification

Qualification

Degree

Year

Board/University

Percentage

Graduation

B.E

2008

University of Pune, Pune

67.4%

XII

HSC

2004

Maharashtra State Board

77.3%

X

SSC

2002

Maharashtra State Board

81.2%

Technical Proficiency

Technology

DWBI – Work experience in ETL and Reporting Tools.

Data Warehousing Tools

Informatica (Version 8.6.1)

SAS Enterprise Guide 4.2

Teradata SQL Client 12.0

SAS Tools (Version 9.1)- SAS/BASE, SAS/Macros, SAS/Stored Procs, SAS/ODS, SAS/WRS,

SAS Procs - Print, Means, Report, SQL, Tabulate, Sort, Format, Import, Export, Transpose, Gplot, Gchart, Gbarline.

Also Trained in MS BI suite- SSIS, SSRS, SSAS.

Basic knowledge of Interacting with Unix Servers.

Languages Known

C, Java, JavaScript, DotNet (C#, Asp.net, Ado.net)

Operating System

Windows XP

Database

Teradata, Microsoft SQL Server 2005

Configuration Management Tool

Visual Source Safe (VSS)

Certifications

Exam S: PowerCenter 8 Mapping Design.

Exam U: PowerCenter 8 Advanced Mapping Design.

AHIP: Fundamentals of Healthcare - Part A.

Awards & Recognitions

On – The Spot Award for Q2’10.

Q2 INSTA Award 2011.

Work Experience (8 years)

Organization:

Infosys

Dec 2008 – Present

Client

WELLPOINT Inc. (Formerly, Anthem Corporation), USA

Designation:

Technology Analyst

Responsibilities

Develop and Deliver Data Marts in various business practices of leading a Health Care company using the ETL Tool Informatica.

Develop and Deliver Business Portals for Individual business Market of leading a Health Care company using the Analytic and Reporting Tool SAS.

Involved in providing new architectural solutions/designs for complex business requirements.

Interacting with Client with requirements gathering and analysis.

Currently acting as a backup Lead for the SAS Team.

Interacting with Onsite Coordinators on a daily basis.

Leading the Offshore Team during Client Interaction and gathering the requirements and providing better solutions to the client helping them in their business growth.

Responsible for the Configuration Control of documents at Project level.

Mentoring and Training the new Joiners on SAS and CC role.

Sharing the Technical and Business Knowledge with Team on regular basis.

Achievements:

Got On Spot Award and INSTA Award for Excellent Performance in Projects.

Successful release of Senior Data mart.

Successful delivery of the SAS Portals gaining client and Onsite trust.

Completion of Various External Certifications related to Informatica and Healthcare Domain.

Project Assignments

Business Practice

Individual Business Market

Project Name

Infomart – BI Solutions

Technology

SAS V 9.1, SAS WRS, SAS Infomaps

Role

SAS Analyst & Team Lead

Responsibilities:

Building Standardized Reporting modules created from InfoMart data, provide management reports and dashboards to help Individual Business leaders better manage the business.

Provided a solution using SAS & Mainframe files to the Client which helped them in eliminating an external Vendor thus helping them in monetary Gain.

Performing Role as Backup Lead for 6 members Team.

Mentor and Train the new Joiners in SAS and Business Knowledge.

Works involve creating SAS graphs, tabular reports, KPIs, charts using SAS macros, stored procs.

Creating SAS reports Using WRS.

To create Reports using SAS Addin function of the xls.

Other responsibilities include –

oInteracting with onsite coordinator for updates and requirements.

oInteracting with client every week sharing updates on development and providing them the Best Solutions which enhances their business Growth.

oHandling Adhoc Analysis Tasks.

Business Practice

Individual Business Market

Project Name

Infomart Analytics

Technology

SAS, SQL, Teradata

Role

Business Analyst

Responsibilities

Worked as a Bridge between Development Team and the Reporting Team.

Helped the development Team in designing of the Star Schema of the project.

Analyzing data as per business requirements which helped Client in making Imp Business decisions.

Involved in designing and developing a SAS Dataset of various Dimensions and Measures which is directly being used by the Client and End Users.

Involved in the UAT for the Datamart.

Coordinating with the Onsite lead on a daily basis, sharing updates.

Handling Adhoc Analysis Tasks.

Business Practice

Individual Business Market

Project Name

Senior Business Mart

Technology

Informatica 8.6.1,Teradata

Role

Software Developer

Responsibilities

Key member in the RA Phase of the project wherein Identified source and target elements, impacted elements etc.

Helped team in the Designing Phase of the Project.

Involved in the Build & unit testing phase of Membership track.

Interacting with onsite coordinator for updates and requirements.

Extra Curricular Activities

Participating in the fun activities organized in Office.

Active Participation in the Social Activities like School Kit Donation Drive, Teaching underprivileged children etc.

Conducting Team building events at unit level.

Participated in Badminton and Tennis Competition.

Winner of Knowledge management (KM) Activity organized at Project Level.

Hobbies / Interests

Trekking and Exploring new places.

Watching Sports.

Movies.

Playing Badminton, Tennis, Snooker

Music.

Personal Profile

Date of Birth

18th April, 1986

Gender

Male

Languages Known

English, Hindi, Marathi

Marital Status

Single

Passport Number

Will be produced on Demand



Contact this candidate