Ravender Rana
New Delhi
Summary
Experienced Power BI Developer with 8+ years of experience in creating Enterprise level Report based on specific requirements. Adaptable, diligent and knowledgeable in Power BI and Business Intelligence.
Overview
9
9
years of professional experience
Work History
Lead Power BI Developer
PyzenLabs
01.2024 - Current
- Collaborated with cross-functional teams to identify data sources and streamline data collection resulting in a 25% reduction in report development time.
- Developed a self-service dashboard for the sales team resulting in a 40% increase in data-driven decision making.
- Responsible for data sourcing, collection and management for several insurance companies, operating in the health, travel, and luxury industry.
Power BI Developer
Congruex Asia-Pacific LLP
03.2021 - 01.2024
- Masterminded a range of custom Power BI dashboards to help visualize complex data sets, bringing about trend identification and process improvement for stakeholders.
- Improvised ETL methodologies using MS SQL to import data into Power BI, resulting in a significant boost in data reliability.
- Expedited the designing process of interactive dashboards and systemized reports with Power BI.
Senior Analyst
Polestar
01.2021 - 03.2021
- Develop and maintain interactive and visually appealing reports and dashboards using Power BI.
- Design and maintain data models that support reporting and analytics requirements.
- Work closely with stakeholders to understand their data needs and objectives.
Data Analyst
Snapdeal
09.2020 - 01.2021
- Collect and gather data from various sources, including databases, spreadsheets, and external datasets
- Proficiency in data visualization tools and software, such as Power BI, or Excel.
- Produced monthly reports using advanced Excel spreadsheet functions.
Software Engineer
OrangeMantra
08.2019 - 09.2020
- Create and optimize SQL queries to extract, update, and manipulate data efficiently.
- Integrate data from various sources into databases, including data transformation and ETL (Extract, Transform, Load) processes.
- Create and maintain SQL-based reports, ad-hoc queries, and data visualizations for end-users.
MIS Executive
V5 Global
02.2019 - 08.2019
- Analyze data to identify trends, patterns, and insights that can be used for strategic decision-making
- Develop and maintain automated processes and scripts to streamline data collection and reporting
- Create visually appealing and easy-to-understand data visualizations, such as charts and graphs, to aid in data interpretation.
Sr. Executive
Aegis Limited
12.2016 - 02.2019
- Analyze data to identify trends, patterns, and insights that can be used for strategic decision-making
- Generate reports and dashboards using relevant software (e.g., Excel,business intelligence tools) to communicate key performance indicators and metrics to management
- Maintain comprehensive documentation of data sources, processes, and methodologies used in MIS activities.
MIS Executive
Premier Allied Services
12.2015 - 12.2016
- Collect, validate, and maintain data from various sources
- Maintain and manage databases for storing and retrieving information
- Use reporting tools and software to generate meaningful insights from data.
Education
Master of Computer Application - Computer Science And Programming
IGNOU
New Delhi01.2023
Bachelor of Computer Application - Computer Science And Programming
IGNOU
New Delhi01.2018
Skills
- MS SQL
- Python
- Power BI
- Data Modeling
- SSAS
- Power BI Services
Accomplishments
- Microsoft Certified: Azure AI Fundamentals
- Microsoft Certified: Power BI Data Analyst Associate
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Timeline
Lead Power BI Developer
PyzenLabs
01.2024 - Current
Power BI Developer
Congruex Asia-Pacific LLP
03.2021 - 01.2024
Senior Analyst
Polestar
01.2021 - 03.2021
Data Analyst
Snapdeal
09.2020 - 01.2021
Software Engineer
OrangeMantra
08.2019 - 09.2020
MIS Executive
V5 Global
02.2019 - 08.2019
Sr. Executive
Aegis Limited
12.2016 - 02.2019
MIS Executive
Premier Allied Services
12.2015 - 12.2016
Master of Computer Application - Computer Science And Programming
IGNOU
Bachelor of Computer Application - Computer Science And Programming
IGNOU
Similar Profiles
Manvendra KumarManvendra Kumar
Manager- Finance & Costing at Genpact India Private LimitedManager- Finance & Costing at Genpact India Private Limited
Rohit PajhalRohit Pajhal
Director Network Operations at Indian Air ForceDirector Network Operations at Indian Air Force
Mehak LalitMehak Lalit
Senior Process Associate at Genpact Pvt. Ltd.Senior Process Associate at Genpact Pvt. Ltd.
JAI PUNDHIRJAI PUNDHIR
Assistant Technical Officer at InterGlobe Aviations Ltd. "Indigo Airlines"Assistant Technical Officer at InterGlobe Aviations Ltd. "Indigo Airlines"
Swapnil DeoSwapnil Deo
Lead Power BI Developer at EY GDSLead Power BI Developer at EY GDS