Shriram Ramesh Dahotre Resume
Shriram Ramesh Dahotre
B.E. – Computer Science
E-Mail: ShriramDahotre@gmail.com
Mobile: +91-9923137011
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.
Informatica (Version 8.6.1)
SAS Enterprise Guide 4.2
Teradata SQL Client 12.0
Data
SAS Tools (Version 9.1)- SAS/BASE, SAS/Macros, SAS/Stored Procs, SAS/ODS, SAS/WRS,
Warehousing
SAS Procs - Print, Means, Report, SQL, Tabulate, Sort, Format, Import, Export, Transpose, Gplot ,
Tools
Gchart, Gbarline.
Also Trained in MS BI suite- SSIS, SSRS, SSAS.
Basic knowledge of Interacting with Unix Servers.
Languages
C, Java, JavaScript, DotNet (C#, Asp.net, Ado.net)
Known
Operating
Windows XP
System
Database Teradata, Microsoft SQL Server 2005
Configuration
Management Visual Source Safe (VSS)
Tool
Certifications
Exam S: PowerCenter 8 Mapping Design.
Exam U: PowerCenter 8 Advanced Mapping Design.
AHIP: Fundamentals of Healthcare - Part A.
Shriram Ramesh Dahotre Resume
Awards & Recognitions
On – The Spot Award for Q2’10.
Q2 INSTA Award 2011.
Work Experience (10 years)
Organization: Infosys Dec 2008 – Present
Client WELLPOINT Inc. (Formerly, Anthem Corporation), USA
Designation: Technology Analyst
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.
Responsibilities 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.
Got On Spot Award and INSTA Award for Excellent Performance in Projects.
Successful release of Senior Data mart.
Achievements:
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
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.
Responsibilities: Creating SAS reports Using WRS.
To create Reports using SAS Addin function of the xls.
Other responsibilities include –
o Interacting with onsite coordinator for updates and requirements.
o Interacting with client every week sharing updates on development and providing them the
Best Solutions which enhances their business Growth.
o Handling Adhoc Analysis Tasks.
Shriram Ramesh Dahotre Resume
Business Practice Individual Business Market
Project Name Infomart Analytics
Technology SAS, SQL, Teradata
Role Business Analyst
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
Responsibilities
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
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.
Responsibilities
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
