Parasurama Gouda Ediga
Bangalore
Summary
Performing the research and information gathering necessary to define, design, create, and document business requirements and specifications related to the development of reporting solutions Write and modify SQL queries and stored procedures, as well as develop other SQL database objects, according to business partner requirements and reporting management, to support overall corporate objectives. Support and enhance reporting by developing new reports and visualizations that provide insights to leadership through the gathering and analysis of large, complex data sets Manage and maintain the current report catalog, including automating manual reports and making improvements to existing reports Fulfill ad-hoc data and reporting requests in response to critical business needs
To obtain a challenging position where I can strive for excellence with dedication, a proactive approach, a positive attitude, and passion for my work. I aim to fully utilize my logical and reasoning abilities to meet organizational goals in the best possible way
Overview
14
14
years of professional experience
4
4
Languages
Work History
Reporting Analyst – EDM-Reporting
JoulestoWatts Business Solutions
07.2023 - Current
- Working with weekly and monthly MOF reports, which provide information about different types of accounts and assist stakeholders in entering GL details for specific accounts
- Working with BBBRC reports quarterly to provide week 12 and 13 daily backlog, along with bookings, billings, revenue, and bookings with preliminary carve-out (BL Carve)
- Working with billing-to-booking ratio reports quarterly to provide week 12 and 13 billing data against bookings
- PowerBI Projects:
- EBA to PowerBI Migration.
- NetApp planned to decommission the EBA tool and transition all EBA reports to Power BI. As part of this transition, the team needed to extract all the attributes used in EBA. As a member of the team, I created a macro that helped collect information about these attributes. We collected attributes to fulfill all the requirements for transferring EBA reports to Power BI
- As a part of transition, the total number of reports developed in Power BI and UAT done from EBI to Power BI and Power BI to Cloud for the following reports:
- Dashboard # of Dashboard Page # of Reports Views Created in PBI
- I CAT P2P Analytics 24 24 24
- ICAT analytics 3 21 21
- Travel Analytics 7 49 98
- IQRR Dashboard 1 2 12
- Total 35 96 155
- Tableau to Powerbi Migration:
- As a part of transition, the total number of reports developed in Power BI are as follows:
- Keystone CCV Dashboard
- PCS Business Review
- PCS Revenue reporting
- Worldwide Weekly Headcount Report
- I worked on the deployment process to publish reports from the development workspace to the production workspace, which were uploaded by teammates.
Business Analyst – Centralized MIS
Moder Solutions PVT LTD
06.2022 - 07.2023
- Designed and implemented reporting solutions for 20+ clients, covering a headcount span of approximately 1,600 employees
- Analysed data and reports using Power BI visualizations and Excel, providing actionable insights to stakeholders
- Assisted Operations Leaders in reducing buffer headcount by 10%. Improved team efficiency by streamlining and automating reports using Power BI and advanced Excel, resulting in savings equivalent to 1.2 FTEs.
- Led bi-weekly governance calls with Directors, VPs, and Senior VPs, as well as weekly calibration calls with other internal and external stakeholders, to present business updates and discuss reporting requirements
- Preparing and analysing daily, weekly, and monthly reports for revenue forecasting
- Involving in Billing Invoice preparation and revenue forecast analysis
- Manually collecting headcount data from different branches and preparing the global headcount report
- Group of Archwell solutions company
Business Analyst
First source Pvt Ltd.
03.2021 - 06.2022
- Regularly interact with multiple internal and external stakeholders to discuss and provide reporting solutions
- Extracting data from SQL databases by modifying queries according to client requirements
- Organized and prepared reports for various client processes
- Developed automated reporting resulting in reduction in effort and time.
- Created Power BI which provides the insights of Weekly, Monthly and Quarterly Actual and forecast Revenue Details, Staffing, Production TAT and Quality using DAX functions.
Sr.Consultant
Amazon Development Center (india) PVT
06.2020 - 03.2021
- Analysis of the functional requirement of the Business.
- Extracting the data from SQL database by Modifying the Queries according to the client requirement.
- Updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables, V-Lookup, H-Lookup, Mid functions, Length functions, Sum, Sum if, Sum ifs, count, count if, count ifs, Substitute and Concatenate
Senior Process Executive
Infosys Limited
04.2012 - 06.2014
- Process: Microsoft
- Streamlining processes / procedures to necessitate smooth processes & enhance productivity.
- Team handling.
- Preparing audit Reports, Production summary and Team Production details as on daily basis.
Executive Media Solutions (Official publisher of BSNL Telephone Directory.)
Getit info services pvt ltd under the contract of Team Lease
12.2011 - 04.2012
- Cold calling, fixing the appointments with customers.
- Getting advertisements for BSNL Telephone directory is published by BSNL at the end of every year.
- Cross selling of other online products of Get it info services.
- Making better understanding about online marketing for our customers and how it helps their business.
- Preparing daily sales reports (DSR) for my team and reporting to my manager.
- Building repo with existing customers by regular visiting and collecting information of any discounts in their business and putting discount ads free on our official site www.Getit.com
- Training new employees on how to build repo with customers and helping them on fixing the appointments.
Education
Master of Business Administration - Marketing
Visvesvaraya Technological University
08.2010
Bachelor of Science - undefined
Gulbarga University
06.2006
Higher Secondary - undefined
Government junior college
07.2000
Skills
Advanced Excel
VBA(Mid-Level)
Requirements Gathering
Declaration
I solemnly declare that the above information is correct to the best of my knowledge. Place: Bangalore Parasurama Gouda Ediga
Timeline
Reporting Analyst – EDM-Reporting
JoulestoWatts Business Solutions
07.2023 - Current
Business Analyst – Centralized MIS
Moder Solutions PVT LTD
06.2022 - 07.2023
Business Analyst
First source Pvt Ltd.
03.2021 - 06.2022
Sr.Consultant
Amazon Development Center (india) PVT
06.2020 - 03.2021
Senior Process Executive
Infosys Limited
04.2012 - 06.2014
Executive Media Solutions (Official publisher of BSNL Telephone Directory.)
Getit info services pvt ltd under the contract of Team Lease
12.2011 - 04.2012
Bachelor of Science - undefined
Gulbarga University
Higher Secondary - undefined
Government junior college
Master of Business Administration - Marketing
Visvesvaraya Technological University