Vishwa Ranjan
Data Analytics Engineer
Mumbai
Summary
Results-oriented and strategic Assistant Manager with over 4 years of experience, in people management within the Networking domain. Skilled at leading teams to extract valuable insights from data, enhancing business operations, and driving organizational success. Adept at managing large teams and fostering a data-driven culture while ensuring alignment with business goals. Proficient in advanced reporting tools, data governance, and analytics methodologies. Strong leadership, analytical, and project management skills, coupled with a keen ability to communicate complex data insights effectively.
Overview
4
4
years of professional experience
3
3
Certification
Work History
Data Analytics Engineer
Reliance Industries Limited
03.2021 - Current
- Performed complex variance analysis and optimized SQL queries for data accuracy across multiple relational databases, leveraging advanced SQL Server and Azure SQL Database capabilities.
- Aggregated unstructured data from 20+ sources, developing interactive Inventory and KPI dashboards in Power BI, and automating data extraction with Python to ensure real-time insights.
- Automated reporting processes using VBA, Python, and Azure Logic Apps, reducing manual effort by 90% and significantly improving reporting efficiency, operational agility, and team productivity.
- Applied advanced SQL and Python techniques for data cleaning, transformation, and validation, optimizing query performance and ensuring the integrity and accuracy of reports.
- Developed automated tracking reports for fuel utilization and battery backup, using Azure Synapse Analytics to reduce fuel waste by 15%, extend battery life by 10%, and enhance network uptime and cost efficiency.
- Presented findings from in-depth data analysis to senior leadership, crafting clear, concise reports and visualizations tailored to their specific business needs, enabling informed, data-driven decisions.
Education
Bachelors in Technology - Computer Science & Engineering
Dr. K. N. Modi University
Jaipur, India07-2020
Indian School Certificate -
St. Francis School
Varanasi, India03-2016
Indian Certificate of Secondary Education -
St. Francis School
Varanasi, India03-2014
Skills
- Language : Python and SQL
- Analytical Tools : Excel, Power Query and Matlab
- Visualization : Power BI, Tableau and Google Studio
- Cloud Data Warehousing : Microsoft Azure
- Database Management : Microsoft SQL
- Scripting Language : VBA Macros
Accomplishments
Inventory Data Management Dashboard | SQL, SSIS, DAX, Power BI, Python, VBA Macros
- Developed a comprehensive Inventory Management Dashboard for managing data related to DG, SMPS, and batteries, aimed at providing real-time visibility, tracking, and management of these critical components.
- Developed with SQL, SSIS, Power BI (DAX), and Python, integrating data for real-time tracking and reporting.
- Automated data processing and report generation using Python, VBA Macros and Power BI.
Fuel Utilization |SQL, Python, VBA Macros, Power BI, Azure
- Automated fuel utilization tracking across telecom sites with VBA Macros, Python, and SQL.
- Integrated data from Azure SQL Database, creating Power BI dashboards for real-time fuel consumption insights.
- Automated battery backup time calculations using SQL and Python, integrating historical and real-time data for accurate forecasting.
Battery Backup Time Calculation |SQL, Python, VBA Macros, Power BI
- Automated battery backup time calculations using SQL and Python, integrating historical and real-time data for accurate forecasting.
- Created real-time Power BI dashboards to visualize battery health, backup status, and predictive analytics on remaining battery life.
- Implemented automated tracking and alert systems to monitor battery degradation and ensure SLA compliance.
Certification
- Power BI Data Analyst Associate Certification – Microsoft.
https://coursera.org/share/98c34d84c6ad0da8a50db5457cd65447
- Robotic Process Automation – UI Path
https://coursera.org/share/a8ab80fe45099c3572c4b780ac9bb4cb
- Preparing Data for Analysis with Microsoft Excel – Microsoft
https://coursera.org/share/5295a7893cc04204fddff9a721a24bf6
Additional
Awards: Awarded by Reliance Jio Infocom Limited as the Best Employee for the First Quarter of 2024.
Languages: English, Hindi, German.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Full TimeWork Location
On-SiteRemoteHybridImportant To Me
Career advancementFlexible work hoursTeam Building / Company RetreatsPersonal development programsCompany CultureQuote
How many ideas have there been in the history of the human race that were unthinkable ten years before they appeared?
Fyodor Dostoevsky
Languages
English
Upper intermediate (B2)
Hindi
Upper intermediate (B2)
Similar Profiles
SAIDULU BANDARISAIDULU BANDARI
Manager (Reverse Logistics Operations) at Reliance Industries Limited (Reliance Digital)Manager (Reverse Logistics Operations) at Reliance Industries Limited (Reliance Digital)
Saurabh DwivediSaurabh Dwivedi
Capability Development Specialist at Reliance Security & Risk Management Academy, Reliance Industries LimitedCapability Development Specialist at Reliance Security & Risk Management Academy, Reliance Industries Limited
Tejaswini UgaleTejaswini Ugale
Buyer (P&C) at Reliance Industries Limited (Aarvi Encon Limited)Buyer (P&C) at Reliance Industries Limited (Aarvi Encon Limited)
Deepak CDeepak C
Zonal Manager (HRBP) at Grab A Grub Services Private Limited (Subsidary of Reliance Industries Limited)Zonal Manager (HRBP) at Grab A Grub Services Private Limited (Subsidary of Reliance Industries Limited)
Ishaan KumarIshaan Kumar
Senior Cloud Engineer at BounteousSenior Cloud Engineer at Bounteous