Profile: Rajkumar Shivathare Page * of *

Profile

Rajkumar Shivathare

Data Architect Business Intelligence Data Warehousing SAP Native HANA Data Modeling Tableau SAP Business Objects Webi Data & Analytics Data Management MIS Applications & Reporting Master Data Governance Email-ID: adg7gd@r.postjobfree.com

Contact No.: +91-996******* / 996-***-****

Total Work Experience: 18+ years

• 12+ years as Business Analyst

- Lead offshore Business Intelligence, Data Warehousing, Data Modeling, Data Analytics, Data Visualizations application development team.

- Define & Design technical roadmap for consolidating/integrating data from multiple sources for better Data Analytics & Data mining solutions.

- Consolidate & analyze BRDs, KPIs to provide support as Business Analytics for better BI solutions.

- Provide subject matter expertise to design, develop, implement complex data architecture solutions

& Data Models (Star & Snowflake), Dimensional & Statistical Data Modeling.

- Design & Implement Business Intelligence, Data Warehousing, Data Management (Master, reference & transactional), Data Governance, Data Visualization solutions with best quality on time.

• 3.5 years as Software Developer

- Desktop, 3 tiers & object-oriented, MIS application development using VB6, VBA based on databases MS Access, MS SQL & Oracle.

• 2.6 years as Mechanical Design Engineer (CAD)

- Design & development of 2D drawings, 3D mechanical models with I-DEAS9, AutoCAD Qualification: B.E. Production

• B.E. Production with first class (62%) from K.B.P. College of Engineering Satara, Shivaji University Kolhapur in 1997.

• H.S.C. with first class (74.5%) from K.V.M. Wai, Shivaji University Kolhapur in 1993.

• S.S.C. with first class (69%) from Dravid High School Wai, Pune board in 1991. Professional Courses/Online Certifications:

• Post Graduate Diploma in Software Technology during Dec-1998 to July-1999.

• Tableau 2018 + 2019: Tableau DS Online Certification

• SAP HANA Implementation, Modeling & Reporting

• Lean Six Sigma Green Belt from VarSigma

Software Development Skills:

• DW-BI Reporting Tools: - SAP Native HANA Data Modelling 2.0, Tableau 2018.3, Microsoft Power BI, Crystal Reports, SAP Business Objects Webi 3.1 & 4.0, SAP BODS, Oracle BI Publisher (XMLP).

• Applications: - Business Intelligence, Data Warehousing applications design, development, maintenance

& reporting, MIS Application & Reporting, Data Modeling using Erwin

• Programming Tools: - C, C++, Java basics, VB6.0, VBA & Macros, Linux, Python

• Web Dev Tools: - HTML, DHTML, ASP (VB Script, Java script)

• Database: - SAP HANA, Oracle, MS SQL, Teradata, MS Access. Areas of Interest with basic knowledge: - R, Big Data & Hadoop, Data Science, SAP BW, SAP MDM & MDG, SSIS, SSRS, SSAS

Profile: Rajkumar Shivathare Page 2 of 3

Work Experience:

A) SRS Infoway, Bangalore, India

- Period: - Aug 2020 till now as Data Architect contracted to Infosys.

- Responsibilities:

Data Modeling (Logical, Physical) using ER/Studio

Provide SME support to SAP HANA Data Modeling & BI reporting team.

Analyze & translate Business requirements to BRDs, development reviews, integration testing.

Provide support to enterprise management system & BI applications. B) Mettler-Toledo India Pvt. Ltd., Mumbai

- Period: - April 2016 to Nov-2019. (3.5 Years) as Deputy Manager – DG Technical Analyst

- Project: Passive Governance Data Quality checks implementation

- Responsibilities:

Lead offshore passive master data governance & data visualization team.

Provided support as Solution Architect/Business Analyst for SAP Native HANA, Dashboard designing using Tableau & Master Data Governance Data Quality checks & policies implementations for Customer, Contact Persons data from SAP MDM, SAP CRM & SAP ECC.

Data Wrangling, Business Intelligence reports, development and publication of Excel web part on SharePoint site for reporting of Weekly & Monthly KPI/SLA dashboards based on SNOW tickets, MDM data requests raised in SAP CCT & SAP MCT tools using Excel web parts (Pivot tables, Pivot charts, VBA & Macros)

SAP Native HANA Data Modeling & semantic layers for optimal performance, Data Loading

(ETL) using SLT, Data Provisioning, Analytical Privileges, Calculation Views, Table Functions, Procedures & performance tuning, HANA Lifecycle management, HANA Development etc.

Delivering ad-hoc requests of Data management, analysis, reports by using Agile scrum methodologies, stakeholder management.

Travel to Poland, Switzerland for team meetings, requirement gathering & UAT process. C) Accenture Services Pvt. Ltd., Mumbai

- Period: - April 2010 to April 2016. (6 years) as Team Lead

- Project: Business Intelligence & Data Analytics reporting

- Responsibilities: -

Provide support as Business Analyst for Business Intelligence & Data Warehouse application development using tools like SAP BO Webi 4.0, advanced MS Excel and Oracle BI Publisher.

Data Visualization using Tableau for Finance & Retail business based on data consolidated in Teradata, Oracle, SSAS OLAP cubes, Data Analysis using VBA & Macros.

Data Modeling using Erwin, Data Wrangling, Data Integration, Data Analysis, MIS reporting.

Creation of SAP BO Webi reports, SAP Native HANA calculation views, financial CO-PA reports based on data from SAP BO Universe, SSAS cubes.

Design data models and semantic layers for optimal performance, SAP BO Universe Design, contexts creations, creation of Objects & Classes, derived tables, prompts, hierarchies & loop less Universe.

Performance tuning, coding using Oracle 11g PL/SQL of procedures, functions, cursors, Indexes, Views, Triggers, Data Loading (ETL) using SAP BODS activities.

Collaborate with internal and external stakeholders to understand data structures & business rules, Create report mock ups (POC).

Worked for various clients like EMC2, Walmart (Retail), Loblaws (Retail), Royal Mail Group

(Service), Allstate Insurance, JPMC (Finance) & SC Johnsons etc. D) Pyramid IT Consulting Pvt. Ltd., Mumbai

- Period: - Oct 2009 to April 2010. (6 Months) as Team Lead

- Project: Business Intelligence & Data Warehousing application development

- Responsibilities: -

Enterprise Data Warehouse (EDW) maintenance & enhancement, Data Wrangling using Oracle PL/SQL procedures & functions, Data Modeling (Star & Snowflake) using Erwin.

DWH Reporting using Oracle BI publisher (XMLP), Excel (VBA & Macros).

Database performance tuning and Query Optimization Profile: Rajkumar Shivathare Page 3 of 3

E) Geometric Ltd., Pune

- Period: - March 2008 to Feb 2009. (11 Months) as Sr. Software Engineer

- Responsibilities: -

DELMIA (Digital manufacturing & Simulation tool from Dassault Systems) customization requirement analysis and implementation.

Solution development as per standards using Visual Basic 6, VBA, Macros, PL/SQL Scripting F) Rolta India Ltd., Mumbai

- Period: - Oct 2006 to March 2008. (17 Months) as Sr. Executive L-2

- Responsibilities: -

Enterprise Data Warehouse (EDW) application development & maintenance using VB6, SQL Server. Geo-Media for GIS information & reporting using Crystal Reports. ETL activities like Data Extraction, Integration, wrangling, cleansing, transformation & loading to central data warehouse for Business Intelligence reporting & Data Analysis.

Adhoc data analysis & automation using VBA & Macros. G) Vidyut Metallics Pvt. Ltd., Thane

- Period: - Jun 2005 to Jan 2006 (7 Months) as Design Engineer (CAD).

- Responsibilities: -

Designing & detailing of SPM tools used for manufacturing of dual head blades, Industrial blades, assembly & packaging machines, printing machines, QC and Inspection machines. H) Bainite Machines, Mumbai

- Period: - Jan 2003 to Dec 2004. (24 Months) Jr. Design Engineer (CAD/CAM).

- Responsibilities: -

Design & detailing of rubber processing machines using AutoCAD 2006

Create 3D models, detail drawings & 3D assemblies using I-DEAS9 from 2D drawings. I) Greenrose Computer Services Pvt. Ltd., Thane

- Period: - Nov 2000 to Jul 2002 (21 Months) as Software Developer.

- Responsibilities: -

Development of N-Tier MIS Software (GRAINS) using Visual Basic 6.0, VBA & Macros, M.S. Access, MS SQL.

Database design, data modeling, backup & restore, performance tuning

VB data reports, HTML Reports, MIS reports using Crystal Reports. J) Assans InfoTech Pvt. Ltd., Navi Mumbai

- Period: - Feb 1999 to Oct 2000 (21 Months) as Trainee Software Developer.

- Responsibilities: -

Development of interactive education CD-ROMs of subjects like Mathematics, EVS, Physics, Chemistry, Geography and History suitable for students I to X using Micro media flash SWF animations, VB6, HTML for illustrations.

Personal Information

Birth Date: 5’Th June 1976

Marital Status: Married

Address: AL5/16/13, Shantidoot Apartment, Sector 5, Airoli, Navi Mumbai, Maharashtra- 400708

Contact No.: +91-996******* / 996-***-****

Email-ID: adg7gd@r.postjobfree.com

LinkedIn ID: https://www.linkedin.com/in/rajkumarshivathare-996-***-****/ Passport No.: L9946792

VISA: European Schengen Visa – Business C Type valid till Jan-2021.

Contact this candidate