RAVI

New Delhi, INDIA

EXPERIENCE (8.10 Years in Data Analytics, Visualization, Warehousing, Machine Learning, and Architect)

Present Employer

Lead - Data Analyst Jan 2022 – Present

• Created many self-serve platforms on Power BI for key stakeholders to view data from multiple sources as well as slice-and-dice it, hence saving over 40% of team bandwidth
• Introduced KPIs for high level management that is being used to track daily, weekly, and monthly progress.
• Introduced Forecast report that helps to focus on given target by week and month
• Performed Exploratory Data Analysis and created a Machine Learning Model with 99% average accuracy to predict rides based on major KPIs. It helps Operations team to focus on major areas and analyze the impact on overall successful rides
• Created Unsupervised Machine Learning Model to divide Bangalore in various clusters and provide insights to meet the demand in various areas or increase supply as per demand
• Created Machine Learning Model on imbalance data to predict weather a driver will counter quote on a ride or not with 80% average accuracy
• Creating Logical and Physical Data Model and Data Architecture

XCEEDANCE CONSULTING INDIA PVT LTD – Gurgaon, Haryana

Team Lead/Data Architect Jan 2019 – Dec 2020

• Led a team of 10 developers to develop UCD (Universal Customer Database) for GEICO. The platform was used on daily basis for publishing Power BI reports and data analysis, it contains data from various heterogenous sources like excel, flat file, SQL Database XML files etc.
• Built and provided end to end Data Warehouse Solutions.
• Involved in creating Logical and Physical Data Model and Data Architecture
• Created Algorithm to provide Single Customer View from various heterogenous data sources using SQL and SSIS, which hold 60% weight in the overall project
• Responsible to enhance query retrieval time (performance tuning), write SQL Scripts and SSIS packages to load data in stage, transform clean and then move to target tables
• Perform Unit testing for Data Warehouse and Data Mart
• Mentor team on technical aspects and work on the Solution Design Documents, involved in in-inhouse

training, workshops, SQL knowledge sharing sessions

XCEEDANCE CONSULTING INDIA PVT LTD – Gurgaon, Haryana

Senior Analyst Programmer Jan 2014 – Dec 2018

• Data maintenance support to Enterprise Data Warehouse Team - Berkshire Hathaway Specialty Insurance (BHSI)
• Development/Transformation of 40+ KPI Reports from Excel, SSRS, Tableau to Power BI which includes daily, weekly, monthly, and quarterly reports
• Made and managed plan for moving technical solutions to client hand-off
• Developed and delivered process reports, requirements documentation and presentations
• Prepared formal queries for various reporting requirements
• Involved in building strategy and deployment of automation projects
• Fulfil ad-hoc analytic and reporting requests, KPIs using various BI tools
• Responsible for data gathering cleaning, validation quality, exploratory data analysis

INITIATIVES & CERTIFICATES

Freelance | Python3, PyPDF2, OpenCV, Tesseract OCR, NLP

• Worked as a Freelancer for a Logistic company to build a python-based model to detect text information from various scanned documents basis on given coordinates.

Text Extractor | Python3, PyPDF2, OpenCV, Tesseract OCR, Spacy, NLP, NLTK

• Developed a Python based model to identify characters from unstructured data and store data in an excel file in the given format. It was developed for Operations team that minimized their work by 30%

Resume Insight | Python3, PyPDF2, Spacy3, AWS Textract, NLP

• Built a Python based model to bring percentage of similarity between various job descriptions and resume across domain.

Forecast Prediction | R, r studio, Time Series

• Created a Time Series model in R to predict fore