Peter Gobishetty

AREAS OF EXPERTISE

Software compliance | Program & Project Management | ServiceNow dashboards | Data Forensic | Stakeholder Management | Automated Executive Push reports | Data Driven Insights | Process Improvements | Cisco’s Partner Channel Programs | Data Visualization | QBRs KPIs Scorecards | Gray Market Analysis | Bookings and Revenue reporting | ServiceNow Workflow management | Brand Protection Data Profiling Techniques | Planning and Capacity Management for Compliance Support Team | Customer Success Specialists – Key Performance Indicator Metrics Dashboard

TECHNOLOGIES

MS SQL Server Scripting | SQL Server Integration Services (SSIS) is a Microsoft SQL Server |Business Objects Desktop Intelligence | MS access | Excel VBA | Visual Basic for applications scripting | Software Development and Deployment | Tableau | RDBMS Oracle 11g | Teradata | Operating System Unix | Windows | Client server architecture | Active X Objects, ADO’s – Active Data objects | OO4O – Oracle Objects for OLE | ODBC- Open Data Base Connectivity | Dynami-Cube - an interactive OLAP tool | SAP BO | Service Now Workflow Management | Salesforce Cisco Sales Module | SQL | CCW/CCWR Cisco Commerce Workspace | EDWTD | SAP HANA | Snowflake | Alteryx

A seasoned and detail-oriented business, data, and reporting business IT analyst with 15+ years of experience in interpreting and analyzing data that drives important business decisions. Advanced knowledge of business intelligence tools, experienced in confirming the accuracy of data and developing, managing, and understanding complex datasets. Domain expertise includes specialized reporting, workflow management, dashboard design with advanced BO, Tableau, Alteryx, Snowflake, VBA, SFDC, ServiceNow and SQL scripting.

PROFESSIONAL EXPERIENCE

Cisco, San Jose CA | November 2018 – July 2024

Sr Business Intelligence Data Analyst

OPEX Headcount | ATR Midsize Coverage Dashboard | Renewals and Growth Req DB: Technologies: Snowflake, SAP HANA, Tableau, Alteryx, VBA (MS EXCEL), SQL

• ATR (Available to Renew): Creation of views in Snowflake for the purpose of creating Tableau dashboard for stakeholders to view subscription data on ATR (Available to Renew) over a period and used data modelling techniques to simulate %’s across various portfolios like Midsize and premium etc.,
• OPEX Head Count: Created an OPEX Head Count dashboard to represent the current state of HC across various theaters and portfolios and broken down by Actual Blue Badge (FTEs), Actual red Badge, Open Backfills, Open Incremental, Future acceptance, Expected Attritions, Expected Net Transfers, Pending Approval Backfill, Pending Approval Growth. Data Mapping of various attributes by using lookup tables. Headcount data was extracted from the upstream SAP HANA environment.
• Capacity Forecasting Tool: Acquired data from various data sources and flat files and was responsible for the development and launch of the Capacity Forecasting Tool. The tool (SQL server/SQL Tableau) provides greater confidence in planning and capacity management and case volume forecasting for the Compliance Support Team (CST)
• Customer Success Specialist (CSS) Metrics: Extracted, interpreted, and analyzed SFDC data to identify key metrics and transform raw data into meaningful, actionable information that allows management to monitor the performance of Customer Success Specialist (CSS).
• Software Compliance Executive Dashboard: Conducted monthly/quarterly data extraction, transformation, and load (ETL) processes of multiple compliance data and Bookings data files in preparation for consolidation and uploading into the dashboard for Stakeholder QBR’s, KPIs and Finance reporting. CCW/CCWR Data extracts for pulling Product related information.
• Sales Team Status Review Push reports: Created complex monthly push reports using advanced capabilities in Excel to extract data from ServiceNow workflow management data and provide an Executive level summary and detailed drill-down reporting on the status of the End Customer reviews with a diagrammatically represented chart to show the current review stage.

•

Gray Market Analysis - Tool: Developed and supported an in-house tool to process and report gray market data using some very complex data mining and data mapping techniques. Cisco’s Commerce data was used as the SSOT to determine the ownership ‘Last Known End Customer’ for a particular Serial Number. The disposition of the device was determined using Installed base data considering RMA (Return Material Authorization) and other relevant attributes.

A user-friendly tool was built using the C/S ODBC architecture with SQL server as the back end and Excel as the Frone end. The tool was well received by the Brand Protection group that primarily protects all IP portfolios.

Cisco, San Jose CA | January 2007 – June 2018

Sr Data Analyst – Partner Channels Programs

• Own the product roadmap for channels programs. Effectively support each regional stakeholder of the Channels / Cisco Capital applications who is responsible to execute Worldwide strategy at the country level and to Identify process improvements. (automated/systems as well as through communications/training).
• Develop analytics solutions using Tableau, SQL and other Business Intelligence tools and trained offshore/onshore resources. Analyze large amounts of data for a wide range of analysis activities including resource investments, business results, gross margin, geo/customer segment trends, etc. Work with the leadership team on portfolio analysis and provide visibility to portfolio investments, priorities, and ROI. Develop key business metrics and KPIs to measure the achievement of business goals and drive analysis and management reporting of these metrics, trending, YoY analysis, ranking, Growth metrics, maintaining a repository of Partners outlook numbers, rebate calculation and historical data. SQL scripting and Business Intelligence tools such as Tableau, OBIEE, SAP Business Objects were used to accomplish these initiatives.

•

Good understanding of SaaS, XaaS, Software Annualization Enablement, Subscriptions & Revenue Recognition- Measures- ACV – Annual Contract value: TCV: Total Contract Value, Software/ Contracts, and renewals; CCW/CCWR upstream data ingestion for Subscription data.

•

Case Management (Remedy), user stories, grooming sessions, Data Mart maintenance, Data integrity/backup, Code development, Bug Fixes, Code enhancements, Business analysis, Business Requirement Document (BRD), User Stories, review FSD’s – Functional Specification Document,

3Com, Santa Clara CA | March 2004 – Dec 2006

Sr Developer

3com Commission system: Worked on development and Production support for an Executive Dashboard and Commission system. 3com Commission system is used to process and generate Commission reports and Leader board reports for 3Com Sales representatives worldwide. Date is fed from both Sales-in and Sales-out data and allocation rules applied based on different criteria and commissionable amount is assigned to the rep’s using this application.

Blue Cross and Blue Shield of Rhode Island /Perot Systems | November 2002 – December 2003

Sr Programmer Analyst

Med + Choice risk adjuster: The purpose of this application is to extract Med+Choice risk adjuster data and create a file of the data in the CMS required format, to comply with CMS regulations and to insure proper premium payments to BCBSRI.

LGRS (Large Group rating system): The goal of this project is to help ensure that target revenue is realized in conjunction with net to reserve goals and minimize individual group rate change variability year to year Enables linkage between premium rates and claims cost for better cost management Improve efficient calculation of premium rates within underwriting and actuarial.

Master of Science, Statistics, Madras Christian College, University of Madras, India.