Ravi Bhushan
Bengaluru
Summary
With 6+ years of industry experience and 5.11 years of experience in data Analysis, I have honed my skills in Data Analytics, focusing on data analysis, data warehousing, and data Visualization. I have been responsible for manipulating raw data from various sources, establishing data governance policies, and maintaining data integrity and security. My proficiency in SQL server, Power BI, ETL and Python has been instrumental in my roles. I have worked on MDM processes, helping organizations make decisions based on single versions of truth. My experience extends to working with enterprise scale relational databases and ensuring data quality. I have also designed and implemented DAX expressions to support analytical requirements and worked on Business Intelligence tools like Tableau & Power BI.
Overview
7
7
years of professional experience
Work History
Senior Engineer
IQVIA
Bengaluru
05.2024 - Current
- Create and maintain Power BI models, reports, and dashboards.
- Worked closely with end users to understand requirements and translate them into effective visualizations.
- Expertise in Power BI, including DAX queries, and experience leading end-to-end data visualization projects.
- Implemented RLS (Static and dynamic) and scheduled refresh.
- Proficient in writing complex SQL queries for data manipulation, data cleaning, processing, modeling, and expertise in SQL performance tuning and end-to-end process optimization.
- Experience working in Data Warehouse concepts and well-versed in Star Schema and Snowflake.
- Built processes, metadata, dimensions, and fact tables to support data transformation, structure, and workload management.
- Working experience in project and client management.
Senior Software Engineer
Virtusa
03.2022 - 04.2024
- Responsible for manipulating raw data from various sources to be in a loadable format to database
- Establishing data governance policies, standards, and procedures to maintain data integrity and security
- Working on MDM processes to help organizations make decisions based on a single version of truth and true information
- Defining and reporting KPI’s for key tasks and activities
- Designing and implementing DAX expressions to support analytical requirements
- Extracting, transforming, and loading (ETL) data from various sources into PowerBI, ensuring data quality and integrity
- Data Extraction, Data Cleansing, Data transformation using Python
- Design and developed simple to complex visualization (PowerBI and Tableau), including user access management, security, and performance tuning
- Understanding of Star schema, Snowfake schema, OLAP & OLTP database models
- Resolving production tickets or iTasks on ServiceNow according to user requirements
- Supporting ad hoc requests and delegating based on Plan admin, Tagging etc
- Designing Auditing frameworks using Teradata to identify errors and fix those errors after manual data collapsing
Data Analyst
Proziod Analytic Pvt Ltd
08.2018 - 02.2022
- Company Overview: Energy Domain
- Handled multiple clients based in AU & NZ and dealt with Energy domain such as Electricity, Gas & Water
- Extracted data from the platform and performed data cleansing, data analysis to create a meaningful insight
- Proficient in working on relational databases SQL (Joins, Subquery)
- Interacted day to day with Energy retailers, Meter data Suppliers and stakeholders
- Maintained KPI's on Google sheets to track and optimize daily and weekly goals
- Proficient in data visualization to create insightful dashboards using PowerBI/Tableau
- Monitored and maintained existing data to ensure it remains clean, accurate, consistent, and impactful
- Onboarded new customers with site details, address, tariff codes
- Analyzed historical trends and prepared the RFP's (Request for Proposals) for multiple clients for Auction
- Worked on FileZilla to push the huge data through File transfer Protocol
- Energy Domain
Digital Interaction Executive
24 7.ai
02.2018 - 08.2018
- Responsible for giving support to clients for E-commerce
- Involved in providing emails & chats and resolving customer issues
- Handled end to end support for client through emails
Education
B.Tech/B.E. -
Nmiet
01.2016
XIIth - English
01.2012
Xth - English
01.2009
Skills
- Business Intelligence(Power BI)
- ETL (Power Query)
- M Language
- SQL
- Jira
- Dax
- RLS
- Gateway
- Scheduled Refresh
- Data analytics
Social Link
https://in.linkedin.com/in/ravi-bhushana64b4b5b
Languages
- English
- Hindi
Total Work Experience
6 Years 6 Months
Courses Certifications
- Tableau certified
- Microsoft Power BI for Business Intelligence
Timeline
Senior Engineer
IQVIA
05.2024 - Current
Senior Software Engineer
Virtusa
03.2022 - 04.2024
Data Analyst
Proziod Analytic Pvt Ltd
08.2018 - 02.2022
Digital Interaction Executive
24 7.ai
02.2018 - 08.2018
B.Tech/B.E. -
Nmiet
XIIth - English
Xth - English
Similar Profiles
Nilotpol KumarNilotpol Kumar
Medical Project Coordinator at IQVIAMedical Project Coordinator at IQVIA
Sumayya NazneenSumayya Nazneen
Associate Medical Data Review Manager at IQVIAAssociate Medical Data Review Manager at IQVIA
Liam ScullionLiam Scullion
Manager, Regional Lead Pharmacist at IQVIAManager, Regional Lead Pharmacist at IQVIA
Elizabeth AndrewElizabeth Andrew
Senior Talent Acquisition Consultant at IQVIASenior Talent Acquisition Consultant at IQVIA
Hemendu JoshiHemendu Joshi
Lead Technology Manager – Creative Technology & Innovation Management at UnileverLead Technology Manager – Creative Technology & Innovation Management at Unilever