Vishwa Ranjan

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.

Power Availability Report Automation | VBA Macros, Power BI, SQL, DAX.

• Designed and implemented an automated system for generating Power Availability Reports for ENB, ESC, and large facility sites across India. This solution aimed to improve reporting efficiency, accuracy, and timeliness through the use of VBA macros, Power BI, and advanced Excel techniques.
• Developed VBA macros to automate data extraction, processing, and report generation within Excel, significantly reducing manual effort.
• Created interactive Power BI dashboards to visualize power availability trends, metrics, and KPIs, providing stakeholders with real-time insights.
• Built user-friendly forms for parameter inputs, allowing users to customize reports based on specific needs.
• Integrated data from various sources, including SQL databases, CSV files, and other external systems, ensuring seamless data consolidation for reporting.

Inventory Data Management Dashboard | SQL, SSIS Packages, 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.
• Utilized SQL and SSIS packages for data integration, transforming and loading data from various sources into the inventory database to ensure accurate and up-to-date information.
• Designed and implemented Power BI dashboards using DAX to visualize inventory metrics, trends, and KPIs, offering stakeholders actionable insights into inventory status and movements.
• Leveraged Python for backend data processing, handling complex business logic, and automating inventory data updates.
• Developed VBA Macros to automate report generation and data extraction, reducing manual effort and enhancing reporting efficiency.

SMPS Unreachability Report Automation and Dashboard | VBA Macros, Power BI, SQL, DAX.

• Developed an automated SMPS Unreachability Report and dashboard to monitor and analyze the connectivity status of SMPS devices, enhancing reporting accuracy, timeliness, and data insights.
• Utilized VBA to automate the extraction, processing, and transformation of raw data, streamlining the reporting process and minimizing manual intervention.
• Implemented SQL for querying and integrating data from various sources, ensuring a consolidated and accurate dataset for analysis.
• Designed interactive Power BI dashboards with DAX to visualize SMPS unreachability trends, key metrics, and real-time updates, providing stakeholders with actionable insights.
• Significantly improved operational efficiency by automating data workflows and delivering real-time visibility into SMPS device status through the dashboard.

Awarded by Reliance Jio Infocom Limited as the Best Employee for the First Quarter of 2024.