Business Intelligence Scrum Master

Profile: Rajkumar Shivathare Page * of *

Classified as Confidential

Profile

Rajkumar Shivathare

Manager Data Modeling Business Intelligence Data Warehousing

Data Visualization Data & Analytics

Email-ID: ************@*****.***

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

Total Work Experience: 22+ years

• 18+ years as Lead Data Analytics, DWH-BI Reporting, Data Modeler

- Design & Implement Business Intelligence, Data Warehousing (On premise & cloud), Data Modeling, Data & Analytics applications.

- Migration of legacy Enterprise data warehouse applications to cloud (AWS, SAP HANA) platforms.

- Connect with business stakeholders to gather functional & non-functional requirements & provide high level technical solutions.

- Define & Design technical roadmap/data flows & process maps for consolidating, standardization of data ingested from multiple sources for efficient Data Analytics, DWH & Data Mining application developments.

- Continuously analyze & Improve performance of existing DW-BI Reports, Data & Analytical dashboards, streamline entire data flow process to support current & future needs.

- Provide SME support to design, develop, implement complex data architecture solutions & Logical, Physical Data Models (Star & Snowflake, Data Vault) using Erwin, ERStudio.

- Define & Prioritize tasks to meet stakeholders’ requirements.

- Ensure PII data management is done as per GDPR & HIPAA data regulations.

- Participate in leadership & decision-making meetings for risk management & efficient data strategy.

• 3 years as Software Developer

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

• 2.6 years as Mechanical Design Engineer (CAD)

- Design & development of 2D drawings, 3D models & assemblies’ 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 from Gebbs Software Education - Thane

• Lean Six Sigma Green Belt from VarSigma

Software Development Skills

• Development Tools: - ERwin 2021 R1, SAP Native HANA Data Modeling, Tableau 2018.3, Analysis for Office, Advanced Excel, SAP BO Webi, Oracle BI Publisher (XMLP).

• Application Process: - Business Intelligence Reporting, EDW, ELT process, Dashboards & Visualizations using Tableau, Data Analytics & Modeling (Erwin, ERStudio), Data Quality, Data Governance, Data & AI.

• Programming Tools: - VB6, VBA & Macros, PL/SQL.

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

• Database: - Snowflake, Databricks, SAP Native HANA, Oracle, MS SQL Server, Teradata, MS Access.

• Cloud platform & application hosting: AWS

• Business Domains: Manufacturing, Consumer Goods and Services, Training & Education, Retail Profile: Rajkumar Shivathare Page 2 of 3

Classified as Confidential

Work Experience

A) Accenture Strategy & Consulting, Mumbai - India

- Period: - Nov-2021 till date as Manager - Data Modeling

- Dimensional, Relational & Data Vault modeling to provide Integrated, cleansed & standardized data.

- Integrate, standardize & maintain curated data in snowflake & Databricks Data lakes, Data Warehouse & Data Marts.

- Creation of different objects like compute warehouse, stages, tables, UDFs, SnowPipe, Events, Tasks, views and data sharing for detail analysis in snowflake.

- Manage Business Intelligence, Data Warehousing, Data Modeling & Data Engineering teams to implement Dimensional & Data Vault model on Snowflake, Databricks & AWS S3.

- Migration of legacy data storage system used for BI reporting and dashboards to new cloud-based snowflake/databricks database and create various data & insights, data & analytics, cost effective solutions.

- Ensure PII data is managed as per GDPR & HIPAA regulations, enforcing data governance rules for data usage, storage, distribution with consent of data owners.

- Provide centralized data platform for various stakeholders to source data for further analysis in data science and AI implementation.

- Plan & execute project activities in multiple sprints and conduct SCRUM meetings to review progress

& timely reporting to business stakeholders.

B) IndigoChart, Mumbai - India

- Period: - July-2021 to Oct-2021 (4 Months) as Managing Consultant - Data Engineering

- Analyze existing legacy Business Intelligence reporting system and upgrading to new AWS cloud- based Snowflake database system for better performance & cost-effective solutions.

- Data Modeling using SqlDBM for cloud-based Snowflake database.

- Loading data from stages to tables, creation of views and data marts. Rebuilding of BI reports based on snowflake DB.

C) Mettler-Toledo India Pvt. Ltd., Mumbai - India

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

- Project: Passive Governance Data Quality checks implementation

- Lead offshore passive data governance & data visualization team.

- Performed real time replication of data from operational data source like SAP ECC, SAP CRM, SAP MM applications to SAP Native HANA.

- 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 ECC, SAP CRM & SAP MDM.

- Enhanced quality of master data stored in SAP source systems to great extent for better resource allocation and better planning.

D) Accenture Services Pvt. Ltd., Mumbai - India

- Period: - April 2010 to April 2016. (6 years) as Team Lead - Business Intelligence & Data Analytics Reporting

- Project: - Business Intelligence & Data Analytics reporting

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

- Data Modeling using ERwin, Data Wrangling, Data Integration, Data Analysis, MIS Reporting.

- Design data models and semantic layers for optimal performance using ERwin, SAP BO Universe.

- Collaborate with internal and external stakeholders to understand requirements, data structures.

- Asist business analyst in creation of new Data & Analytics, BI reports, enhancement for better performance of existing reports and dashboards.

E) Pyramid IT Consulting Pvt. Ltd., Mumbai - India

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

- Business Intelligence & Data Warehousing application development 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 of Stored Procedures, Functions & Views. Profile: Rajkumar Shivathare Page 3 of 3

Classified as Confidential

F) Geometric Ltd., Pune - India

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

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

- Automation solution development using Visual Basic 6, VBA, Macros, PL/SQL Scripting. G) Rolta India Ltd., Mumbai -India

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

- Enterprise Data Warehouse (EDW) application development & maintenance using VB6, SQL Server.

- MIS reporting using Crystal Reports, Data Modeling (ERwin) & ELT activities like Data Loading, Transforming, Integration, wrangling, cleansing to central EDW for BI Reporting & Data Analysis.

- Integration of water and natural resource information collected at various locations across India to centralized and standardized data warehouse and make data available for detail Data & Analytics, Data Science related further analysis.

H) Vidyut Metallics Pvt. Ltd., Thane -India

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

- Design & detailing of SPM tools used for manufacturing of dual head blades, Industrial blades, assembly & packaging machines.

I) Bainite Machines, Mumbai - India

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

- Design & detailing of rubber processing machines used in manufacturing of automobile tyres using AutoCAD 2006.

- Create 3D models, 3D assemblies, mechanism for virtual motion animation using I-DEAS9 from 2D drawings.

J) Greenrose Computer Services Pvt. Ltd., Thane - India

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

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

- Requirement gathering, stakeholder management, UAT of MIS reporting software.

- Database design, UI design, data modeling, backup & restore, performance tuning.

- Creation of various MIS finance reports, Data & analytics reports like YTD, daily outstanding, invoices and attendance, unit test results, student’s feedback, marketing data analysis like course, timeslot demand analysis, students course enquiry & enrollment analysis. K) Assan’s InfoTech Pvt. Ltd., Navi Mumbai - India

- Period: - Aug 1999 to Oct 2000 (15 Months) as Trainee Software Developer

- Development of interactive education CD- using Micro media flash SWF animations, VB6, HTML.

- Developed desktop based educational & interactive games for better understanding and assessment of subject.

Personal Information

Birth Date: 5’Th June 1976

Marital Status: Married

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

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

Contact this candidate