Business Intelligence Sql Server

Dadarao Mitakaree - * Years Exp SQL / Celonis

Developer

SQL / Business Intelligence / Celonis Process Mining Consultant

**********@*****.*** +91-766******* LinkedIn Location: Pune, Maharashtra

PROFESSIONAL SUMMARY

SQL Developer and Business Intelligence Consultant with 7+ years of experience in SQL Development, Data Modeling, Reporting, Process Mining using Celonis EMS (On-Premise & Cloud), and GCP BigQuery. Proficient in database development, performance optimization, reporting tools (SSRS, SAP Analytics Cloud), and complex data integration for business insights. Skilled in SQL Server, BigQuery, Celonis EMS, and reporting system migrations. TECHNICAL SKILLS

Databases / Cloud Technologies:

SQL Server 2016+, Oracle 11g, GCP BigQuery (Cloud Database) Database Development / Languages:

SQL, T-SQL, PL/SQL, PQL (Celonis Query Language)

Stored Procedures, Functions, Views, Triggers, Performance Optimization, Data Modeling Reporting Tools:

SSRS, SAP Analytics Cloud (SAC), Celonis EMS (On-Premise & Cloud), Winward Reports Cloud & Process Mining Platforms:

GCP BigQuery, Celonis EMS (On-Premise & Cloud)

Development & Deployment Tools:

SSMS, SQL Profiler, Visual Studio, TFS, TeamCity, Azure Data Studio 1

PROFESSIONAL EXPERIENCE

VOIS India Pvt. Ltd. (Vodafone Group) Deputy Manager

August 2023 – Present

Domain: Business Intelligence, Process Mining

Responsibilities:

- Led Celonis EMS implementations for on-premise and cloud versions across Vodafone BI initiatives. - Delivered successful migration of Celonis EMS Reports to SAP Analytics Cloud (SAC) for improved reporting capabilities. - Developed SQL Procedures, Views, Functions, and Triggers for backend processing and performance improvements. - Managed backend reporting and complex data processing through GCP BigQuery. - Performed database optimization to enhance reporting performance on both SQL Server and BigQuery. - Built reporting KPIs using SQL, PQL, BigQuery SQL.

- Supported end-to-end reporting system upgrades and migrations within tight timelines. Technologies Used:

Celonis EMS, SAP Analytics Cloud, GCP BigQuery, SQL Server, Visual Studio, TeamCity GeoAMPS India Pvt. Ltd. SQL / MSBI Developer

May 2019 – July 2023 (4 Years)

Domain: Infrastructure, Asset Management

Responsibilities:

- Developed robust SQL Server database solutions including stored procedures, views, functions, triggers, and handled performance tuning. - Delivered SSRS and Winward Reports for business reporting across 15+ clients. - Designed and maintained optimized database objects for enterprise data management systems. - Handled production issue resolutions, query tuning, and deployment via TeamCity. - Collaborated closely with BA and QA teams to ensure data accuracy and reporting quality. Technologies Used:

SQL Server, T-SQL, SSRS, MSBI, Winward Reports, Visual Studio, TeamCity ZCON India Pvt. Ltd. SQL Developer

April 2018 – April 2019 (1 Year)

Domain: ERP Products, Reporting

Responsibilities:

- Designed and developed SQL objects (Procedures, Views, Triggers) for ERP systems. - Delivered SSRS-based reporting solutions to improve business reporting. - Performed backend performance optimization and issue resolution.

Technologies Used:

SQL Server, T-SQL, SSRS

2

PROJECT HIGHLIGHTS

Project Role Key Achievements

Celonis EMS

Modernization (VOIS)

Deputy

Manager

Migrated On-Premise Celonis EMS to Cloud EMS

and optimized backend reporting with BigQuery

SAC Reporting Integration

(VOIS)

Deputy

Manager

Migrated Celonis EMS Reports to SAP Analytics

Cloud (SAC) and optimized reporting KPIs

ERP SQL Development

(GeoAMPS / ZCON)

SQL

Developer

Designed and optimized backend SQL structures;

delivered robust reporting via SSRS

EDUCATION

Bachelor of Engineering (B.E.) – Computer Science, Pune University (2014 – 2017) Diploma in Electronics and Telecommunication, MSBTE, Latur (2011 – 2014) 10th Standard, Maharashtra State Board (2011)

PERSONAL DETAILS

Date of Birth: 01st Sept 1995

Marital Status: Married

Languages Known: English, Hindi, Marathi

Location: Pune, Maharashtra

•

•

•

•

3

Contact this candidate