Pramod Swamy Email & Phone Number

Dubai, United Arab Emirates

Dubai

- Helping Company Improve its Performance by capturing right KPIs and suggest insights through Dashboards that would improve customer experience- Cross functional expertise by collaborating with different departments within KITOPI to gather their reporting needs and implementing the same with available tools and resources- Tracking key performance metrics like Topline Revenue, Brand Sales, Discounts, Speed of service & Customer Feedback rate.- Design and implement analytical solutions by leveraging BI Tools like Power BI, Looker to Build Dashboards for Business.- Hands on experience in SQL, VBA, LOOKML, DAX queries.- Helping Brands under KITOPI improve sales and profits by suggesting key hidden insights from the performance trackers and Dashboards.- Resolving service requests (Adhocs) raised by individuals and help them solve business problems.

Dubai

- Helping businesses improve the Sales and Distribution of AB-Inbev products by setting up challenging targets for the sales teams and tracking their performance at a daily/weekly/monthly/quarterly level.- Collaboratively working with the European country counterparts to plan & manage the process of gathering data pertaining to sales outlets- Target tracking- monitoring targets(actuals) achieved- Track planned v/s achieved target performance on a daily/weekly basis- KPI Alignment (before the quarter starts) with the in-country counterpart, Sales Manager and country head to understand/discuss the process of sales targets and achievement- Gathering field sales & sales data from Salesforce for undertaking target setting/tracking- Preparation of monthly/quarterly sales targets & tracking target achievement.- Tools used: Salesforce, Excel/VBA, MS SQL Server.

• Gathering, understanding and analyzing client’s business requirements and creating customized dashboards for measuring online metrics using Adobe Analytics(Omniture).• Interacting with client directly to understand business requirements and share intelligent insights through Scheduled daily / Weekly / Monthly dashboards• Owned the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions.• Analysing Pipeline and funnel metrics like Responses, MQL, Leads etc.• Live chat analysis• Deep dive analysis of account behaviors through Social media engagement.• Performing deep dive analysis to identify the root cause for the errors and to measure the daily deliverables• Preparing Presentations and Data for Senior Leadership team based on their business requirements• Automating excel based reports using VBA there by reducing manual error and efforts.• Tools used: Adobe Analytics, Sprinklr, Excel/VBA, MS SQL Server.

Bangalore

• Product Price Index insights :- Analysis on Tesco UK's pricing strategies versus its competitors• To extract, Collate and present data using Excel, VBA, SQL(Teradata) and provide meaningful solutions by integrating different data sources in uncovering the hidden insights and strategic opportunities for my client’s business• Conversion of the business requirement into data specification• Design/suggest insights to meet the business requirement• Provide comparison between Client Business and their competitors by monitoring and analyzing data trends• Handling ad-hoc requests for specialized reports and delivering result on time

Bangalore

• Responsible to generate daily SLA reports and help operations team.• Weekly reporting included generation of metrics for higher management.• Preparing reports country wise to support operations in decision making effectively at country level.• Goal sheet generation to report the monthly and YTD metrics details with comparison to the YTD goals.• Preparing stack rank on monthly and quarterly basis.• Supporting operations team with data as requested on ad-hoc basis.• Solving trouble tickets that are raised by operations for data validation.

Bengaluru, Karnataka, India