Pankaj Kapkoti

• Support leadership team with reporting, analysis, and business presentations to inform divisional strategies.
• Manage team performance by implementing measurable metrics to track delivery of supporting requirement artifacts.
• Install based analysis and ad-hoc report generation.
• Dashboard Building

As a Sr. Strategy Product Manager within the AWS Partner Organization, my primary responsibilities were focused on leveraging data to drive business growth and support the adoption of AWS products and services. I played a key role in the following areas:

• Independently leading work streams to track and resolve revenue data hygiene issues, ensuring accurate representation of partners' impact on AWS's revenue.
• Automating and transitioning over 20 reports that tracked the health of the channel business, resulting in significant time savings of approximately 40 man-hours per month.
• Create and maintain standardized reporting tools, delivering business health results to various stakeholders, including senior management.
• Influence product and cross-functional teams to identify data opportunities to drive impact.
• Taking the lead in designing, developing, maintaining, and delivering metrics used to monitor the health of the AWS Partner Organization, while also owning the process of generating actionable insights reports.
• Developing a partner revenue deprecation strategy that facilitated the global adoption of the latest version, reducing the operational burden of maintaining multiple versions by 40%.
• Establish key success metrics and reporting standards for different deals, ensuring effective measurement and reporting of business performance.
• Contributing to the development of product roadmaps and strategies aimed at enhancing operational tools, applications, and partner reporting systems/processes to support the rapid growth of the business and achieve revenue and market development objectives.
• Assessing large datasets, extracting meaningful insights, and presenting them in both narrative and visual formats, such as dashboards, to various internal teams and executive stakeholders.
• Effectively communicating data trends and analysis findings through written and verbal means, supporting business planning and program progression activities.

In this role, my focus was on utilizing my product management and data analytical skills to extract actionable insights, optimize reporting processes, and support the overall growth and success of the AWS Partner Organization.

IBN: Sales, Strategy & Planning

• Generated reports for project progress and performance.
• Design, build, and launch collections of sophisticated data models and visualizations that support multiple use cases across different products and domains.
• Create KPIs, employ data mining, analysis, and visualization for operational performance tracking and reporting.
• Automated ETL processes, making it easier to wrangle data and reducing the time by as much as 40%.
• Performed end-to-end data analysis, collaborating with engineers to interpret data, generate reports, and identify root causes of metric changes.
• Requirements Analysis, Write, update and maintained project documentation.
• Created and automated data visualizations to present insights and tell compelling stories.
• Pipeline Acceleration – Identify missed opportunities before forever gone.
• Targeted campaigns to promote cross-sell and upsell.
• Create and manage data pipelines (ETL, Automation)
• Build and present Sales/Business Performance Insights.
• Sales campaigns success metrics. Customer & seller behavioral analytics.

Customer Partner Services Install Base Ops : IB Ops strives to improve customer experience by maintaining accurate install base data at scale in perpetuity and enabling cross-functional stakeholders to drive their respective business objectives with speed and improved confidence.

• Install based analysis and ad-hoc report generation.
• Analyze diverse data sources to extract valuable statistics and insights, supporting investigations, containment activities, and continuous improvement initiatives.
• Optimize pipelines, dashboards, frameworks, and systems to facilitate easier development of data artifacts.
• Identify and analyzed trends and patterns in complex data sets, presenting findings through dashboards and reports to provide a comprehensive understanding of the operational story.
• Develop and automate analytic capabilities, build dashboards.
• Data processing automation & data warehousing.
• Mentor team members by giving/receiving actionable feedback

Digital Worldwide Sales Strategy

Digital Sales Strategy's primary focus includes setting the strategic direction for digital selling, driving the implementation for go-to-market initiatives, developing the long-range strategic business plan, and leading sales operations, inclusive of sales/partner training, sales compensation, managing Cisco's customer experience centers around the globe, and producing sales recognition events.

• Managed and enhanced existing data visualizations, pipelines, and dashboards to ensure accurate and up-to-date information.
• Automate analyses and develop pipelines using SQL, Python, and Tableau to streamline processes and increase efficiency.
• Create automated questioner for data impact assessment using VBA, SQL and Python.
• Analyzed open orders, backlog, and sales data to provide sales team with insights.
• Create automated solutions for customer 360 (web scrapping).
• Cleaning unstructured data (corpus preparation, tokenizing, stemming) for further analysis.
• Collaborate with key cross-functional stakeholders to drive improvements in underlying data systems, enhancing overall data infrastructure and capabilities.

CPS Business Capabilities & Support

uCRM (Unified Customer Relationship Management) Onboarding: On-boarded 30+ teams/processes onto Salesforce based CRM platform to enable case creation, expedite case automation, intelligent routing and key metrics reporting. Operational outcome of ~41% operational savings in cost and efficiency.

• Onboarding business/teams onto CRM platform
• Mobility: Managed CPS Support mobile application.
  Portal Simplification: Increase in CSC portal adoption to 51% by Cisco Customers/Partners.
• Define and manage SLA for all data sets in allocated areas of ownership.
• Interfacing with RMO (Release teams) for Release planning, contingency plans, data migration.
  Offsite Resource Management, closing Project with proper documentation, training and handover to Run-The-Business teams.
• Conducted UAT sessions with the EU / APAC / US / Canada teams.

Data Foundation, Reporting & Analytics

The Data Foundation, Reporting & Analytics initiative is an initiative under Project Pareto aimed at turning data into a competitive differentiator for Cisco sales.

• Requirement gathering, Analysis, Application Design and Database Design for new request.
• Client coordination, data analysis and change impact analysis.
• Responded to specific BI requests from Sales personnel, creating data packets with requested information in easily understandable formats.
• Deploy predictive analytics models to forecast future trends.
• Develop data mining algorithms to identify and classify patterns in data.
• Improve logging frameworks and collaborate with data infrastructure to address issues and enhance data efficacy.
• Automation using VBA macros in Excel, BO and MS Access, SQL Server.
• Updated and developed scripts and queries to extract and analyze data from multiple sources.
• Handled massive quantities of business intelligence data, personally managing as much as 10 terabytes.

Global Center for Quality Management (GCQM)

• Developed VBA-based reporting tools, resulting in ~76% reduction in person-hours.
• Ensured Canada SBM ecommerce website quality by conducting audits, maintaining minimum 98% standards.
• Generated resource utilization, productivity, and business review reports on a weekly, monthly, and quarterly basis.
• Delivered impactful business review presentations to stakeholders.
• Proficient in MS-Access/SQL for data storage and analysis.
• Streamlined processes through VBA automation and data validation.
• Collaborated cross-functionally to gather requirements and implement effective reporting solutions.
• Identified optimization opportunities, contributing to process improvements.
• Strong analytical skills in identifying trends and insights from data.