Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

My Experience

Certificates

Contact

Bhikadiya Pratik

SQL BI Reporting Analyst III

[email protected] +1 6476751131
Resume

Hello, I am

Bhikadiya Pratik.

3

PowerBI
Projects

1

Python
Project

1

Excel
Project

About Me

I have extensive experience in operational, financial, engineering, marketing, and product development analysis within supply chain logistics and product companies. Proficient in Python, R, SQL, Excel macros, C, HTML, Tableau, Power BI, Jupyter Notebook, and Data Bricks, I deliver actionable insights. My expertise includes databases like Databricks Delta Lake, Oracle, MySQL, SQL Server, and SQLite, along with AWS S3, Microsoft Azure, SSRS, and SSIS. I’ve led successful projects at Intuit TurboTax Canada, Green Shield, Canadian Shield Health Care Service, Arcelor Mittal, and Adani Ports, improving revenue, efficiency, and customer satisfaction.

At Intuit TurboTax Canada, I developed a robust ETL and data warehouse system, enhancing customer data analysis and business decisions. My certifications include Microsoft Certified: Power BI Data Analyst Associate and Google Data Analytics Certificate.

Key Skills

Mysql

Tableau

pyspark

Big data

Data bricks

My Projects

Business 360 BI Dashboard
Business 360 BI Dashboard
Opencv,Pytesserect,Pypdf , Regex Based Local OCR Engine to parse Medical documents of Hospital
Opencv,Pytesserect,Pypdf , Regex Based Local OCR Engine to parse Medical documents of Hospital
Sales and Marketing Analytics
Sales and Marketing Analytics
Empowering Telangana's Progress: Proficient Power BI Analysis and DAX Modeling
Empowering Telangana's Progress: Proficient Power BI Analysis and DAX Modeling
Analysis of Healthcare Service Delivery and Employee Punctuality
Analysis of Healthcare Service Delivery and Employee Punctuality
Databricks 𝗥𝗲𝗮𝗹-𝗪𝗼𝗿𝗹𝗱 Formula 1 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 Project
Databricks 𝗥𝗲𝗮𝗹-𝗪𝗼𝗿𝗹𝗱 Formula 1 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 Project

Domain/Function: Sports

My Experience

Canadian Experience & Internship

 May 2024-Till date

Intuit TurboTax Canada:  BI Analyst III

  •  Developed and maintained a robust ETL and data warehouse system using AWS, Spark, Redshift, Oracle PL/SQL, and Informatica, supporting marketing analytics with KPIs such as U/Vs, bounce rate, and impressions.
  • Analyzed large volumes of customer-centric data with Oracle SQL, Python, and R, driving a 20% revenue increase through insights on customer retention/acquisition, geo-targeting, and conversion funnel metrics.
  • Led cross-functional teams to leverage data-driven insights on A/B testing, page tagging, and clickstream data, resulting in a 40% growth in the highest customer segment and improved product experience.
  • Influenced key business decisions by presenting analytical findings to senior leadership, optimizing product placement and procurement for retail channels, resulting in over 3% annual savings in efficiencies.

JAN 2024-Apr 2024

Green Shield :  Capstone Project

  • Led operational analysis and resource optimization for Green Shield Canada, improving workforce management and technology usage, resulting in a 15% increase in transaction processing efficiency and the development of a user-friendly inventory management app.

Nov 2023-Dec 2023

Canadian Shield health care service : Sudbury -Visualization intern

  • Deployed a customized Power BI solution for Canadian Shield, yielding a 10% boost in employee adherence, a 20% increase in service delivery efficiency, and a 10% growth in client acquisition. This strategic approach, combined with technology integration and a focus on employee engagement, has elevated operational excellence and fostered sustained growth.

Other Experience

Apr 2022 – Dec 2022

Arcelor Mittal Nippon Steel India Pvt Ltd, Surat – Deputy Manager, Analyst

  • Prepared 20+ BI dashboards in Power BI for month-on-month business analysis reports.
  •  Integrated SQL with Power BI achieved a 30% boost in customer contract renewals through the strategic modeling and visualization of operational and financial data.
  • Derived optimal pricing strategies as per customer segmentation by analyzing data trends of 1-year for marketing and operation, using time series analysis in R to forecast future trends.
  • Operated closely with the engineering and business team using scrum/agile methodology.

Dec 2016 - Mar 2022

Adani Ports and Sez Ltd – Assistant Manager, Management Information System Analyst

  • Conducted comprehensive project and financial analysis utilizing Python, Tableau, and MySQL, yielding a 10% risk reduction and a 20% improvement in MIS visualization effectiveness.
  • Utilized Python and Excel to extract hourly equipment-specific data from PI and Liebherr Mi-com servers. Through Exploratory analysis identified 5 bottlenecks in machines within the maintenance department, leading to a substantial 15% increase in overall operational productivity.
  • Developed an energy management dashboard and implemented cost-saving strategies by deploying substation capacitor banks, yielding approximately $5,000 in monthly savings.
  • Effectively leveraged Actos and Adani IMS systems for streamlined freight management, leading to a 30% increase in auditing accuracy

 

Awards & Certificate

img

Get Job Ready: Power BI Data Analytics for All Levels 3.0

img

SQL Beginner to Advanced For Data Professionals

img

Excel: Mother of Business Intelligence

img

Python: Beginner to Advanced For Data Professionals

img

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Google Data Analytics

Google Data Analytics

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: Power BI Data Analyst Associate

Databricks Lakehouse Fundamentals

Databricks Lakehouse Fundamentals

Data Bricks Data engineer

Data Bricks Data engineer

Microsoft Certified: Azure Data Engineer

Microsoft Certified: Azure Data Engineer

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.