Download PDF

Summary

Empowering Informed Decision-Making: Elevating Business Intelligence Strategies for Senior Management Excellence. Innovative and result-oriented with 11 years of Consulting experience with a passion for data analytics. Highly experienced in implementation and managing data analytics projects. Strong skills in team building, communication, and presentation, as well as a quick learner, self-motivated, and adaptive as per evolving project requirements.

  • More than 11 years of experience in Analysis, Design, and implementation of BI applications (Analytics dashboards).
  • Expertise in Managing the team’s daily information delivery, including but not limited to data provisioning, profiling, and quality controls, building and maintenance of frameworks and cubes, design and building of reports and dashboard solutions.
  • Experience with agile visualization tools (e.g. Tableau, Power BI, Domo, Graphana)
  • Knowledge of the Supply chain business, Sales and marketing.
  • Being a key driver in the execution of the overall vision and strategic plan for the department
  • Monitoring all relevant KPIs and initiating required action to correct issues as they arise. 
  • Experienced in conducting statistical analysis like multivariate analysis, Hypothesis testing.
  • Primarily experienced in analysis, design, and development of business applications by utilizing multiple BI, Analytics & Data Science Technologies like Tableau, SQL, Power BI, Alteryx, SSRS, SSAS, Power Apps, Power Automate, Snowflake, ADF, DAX Studio, Tabular Editor, MS Excel.
  • Integrated data from multiple sources and prepared data for visualization and analysis.
  • Working with AWS services (EMR, Lambda, S3, EC2) to handle multi-TB data to analyse and churn out the KPI’s into Parquet files.
  • Utilizing the Parquets to develop the KPI reports and helping teams to make informative decisions. 
  • Experience with Configuring, scheduling, and distributing reports.
  • Good knowledge of Data Warehousing, Data Modelling/Designing concepts, and hands-on experience on ETL flows.
  • Worked on all activities related to high level design of ETL DTS package for integrating data from multiple heterogeneous data sources using Alteryx and SSIS.
  • Extensive usage of MS office and the functionality of Excel such as lookups, macros, statements etc.
  • Proven history of utilizing strong analytical skills, attention to detail to turn complex requirements into working systems.
  • Always worked in close association with stakeholders for many major implementation projects.
  • Knowledge of industry best practices and experience in different Industry Sectors like FMCG, Electronics, Telecom, Agri, Retail, Automobile.
  • Experience in Enterprise Resource planning, product design and development and a total of 3 Full Life cycle implementation experience of a Decision support system.
  • Involved through all phases of requirements gathering, gap analysis, blue printing, functional/Technical Specs, Development, Go-Live, rollout and post implementation support of  BI Systems. 
  • Excellent knowledge in implementation of relational database and data warehousing systems and data marts. knowledge on data modelling using dimensional data modelling - star schema and snowflake.
  • Excellent communication and project management skills to communicate with business stake holders and influence the data driven decisions.
  • Expert in writing SQL queries and matching records as per unit testing

Professional Experience

R Systems. (Cox Communications, Impossible Foods)
Apr'21Till Date

Lead BI Consultant

  • Developing Sales analytics through analyzing POS data and developing forecasting models for future projections.
  • Manage the team’s daily information delivery, including but not limited to data provisioning, profiling, and quality controls, building and maintenance of frameworks and cubes, design and building of reports and dashboard solutions.
  • Monitoring all relevant KPIs and initiating required action to correct issues as they arise.
  •  Coaching staff to improve and maintain a high level of quality at work (including personal development).
  • Developing Resource utilization and actual vs Projected Billing reports in comparison with the project planning and execution.
  • Understating the future requirements for human capital and building the forecast for hiring managers.
  • Pulling data from Prime Viera, SAP workday, intuit work force, SAP Success factor and Jira tickets to build a comprehensive report on the project timeline for CXO reporting.
  • Conduct complex data analysis to identify business trends, patterns, and insights.
  • Develop and implement advanced statistical models and algorithms to support business decision-making.
  •  Work with large datasets and use various data analysis tools.
  • Design and develop dashboards, reports, and visualizations to communicate insights to stakeholders.
  • Ensure accuracy and reliability of reporting systems and data.
  •  Collaborate with cross-functional teams including business analysts, data engineers, and business leaders to understand data requirements and provide actionable insights.
  •  Work closely with business stakeholders to define key performance indicators (KPIs) and metrics.
  •  Working with AWS services to handle multi-TB data to analyze and churn out the KPI’s into Parquet files.
  •  Utilizing Parquets to develop the KPI reports and helping teams to make informative decisions.
  •  Establish and maintain data quality standards and governance processes.
  •  Ensure compliance with data privacy and security policies.
  •  Identify opportunities for process improvement and automation in data-related workflows.
  • Stay abreast of industry best practices and emerging technologies in business intelligence and analytics.
  • Expertise in creating and maintaining functional and technical documentation for the project.
  • Designed and lead real time BI architecture that involved Installation, Configuration, Upgrades, Performance tuning, Load balancing and Capacity planning for the Enterprise Architecture in Tableau.
  •  Worked with multiple Enterprise teams to set up environments (Dev, QA, UAT and Prod) which include sizing (Horizontal/ Vertical), scaling (Current and Future needs), performance tuning etc.
  • Understanding the data structures of both No-SQL and SQL databases and create appropriate data models to facilitate efficient data retrieval and analysis in Tableau.
  • Developing Models using Tabpy in tableau for time series forecast, Clustering and Etc.
  • Creating the Tasks and planning the sprint in Jira.
  • Integrated jira with Tableau to create seamless workflows between project management and data visualization activities. For example, Jira tickets can be linked to specific Tableau dashboards or reports, allowing stakeholders to track
Radiare Technologies ,Bangalore (TGF Geneva, Switzerland)
Jun'20Mar'21

BI Architect

  • Identify opportunities like tail spend, payment term optimization, cost benchmarking and external commodity market fluctuations and work with global category managers to explore, plan and implement relevant solutions
  • Analyzing and forecasting the drug requirement for future supply across the high impact areas.
  • Implemented End to End Enterprise Data warehouse projects using BI Tools like Tableau.
  • Creating Data Models in Power BI for various business requirements.
  • Developing Usable data sources in tableau for business users.
  • Assisting COE team to build the Competency pool across the organization.
  • Developing Tableau dashboards to assess the risk associated with allocation for spending across the geographies.
  • Assisting to create the procurement life cycle in tableau for client.
  • Writing SQL queries to fetch the data from different data sources.
  • Parameterizing the tableau data sources for live data connections to optimize the dashboard performance.
  • Assisting and creating data marts for the BI solutions.
  • Applying industry best practices to the data model to deformalize the data available in data lake.
  • Tracking the progress of project using Jira and building the knowledge documentations in confluence. 
  • Customized workflows, issue types, fields, and notifications can be configured to align with the Tableau project's unique requirements.

Aldar Properties
Aug'19Jun'20

Principle Consultant

  • Provide technical leadership and guidance to the BI engineering team.
  • Collaborate with cross-functional teams to align BI initiatives with business goals.
  • Architect and design scalable and efficient BI solutions.
  •  Evaluate and implement new technologies to enhance BI capabilities.
  •  Maintain data integrity through appropriate follow-up and adjust data governance model as needed.
  •  Ensure successful deployment of CRM processes and tools in all relevant functional areas.
  • Liaise with corporate headquarter functions to align procedures, gather info and share best practices.
  • Accurate processing of rebates and tracing data according to schedule agreed with management.
  • Manage and control relevant external vendors to ensure seamless process integration.
  • Documenting and maintaining all relevant procedures and workflows.
  • Extract, Clean & transform data from multiple data sources both structured and unstructured.
  •  Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
  • Restricted data for users using Row level security and User filters.
  •  Developed Tableau workbooks from multiple data sources using Data Blending.
  •  Generated context filters and data source filters while handling huge volumes of data.
  • Built dashboards for measures with forecast, trend line and reference lines.
  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Developed complex BI reports, Dashboards, Project Management, Change/Incident Management, Maintenance, Upgrade, Fix pack/Service pack installations, and root cause analysis.
  • Migrating and implementing centralized BI platform for all functions in organization.
  • Experienced in Developing Performance dashboards, Score cards, Metrics, what if analysis, for all the functional areas including Finance, Change management, Order management, HR, Inventory & Warehouse Management, supply chain, and Sales/Marketing.
OLAM, Chennai
Nov'17Mar'19

Lead Consultant

  • Led spend analysis, savings analysis for Strategic Sourcing Team (NA and EMEA Region)
  • Specialized in Categorizing the spend according to the UNSPSC Taxonomy and defining the organizational Taxonomy.
  • Initiated cost savings measures consolidating shipments to hit weight breaks and changing carriers for our inter-company imports resulting in projected annual savings of $600,000.
  • Developed comprehensive reports summarizing procurement spend and savings information to allow procurement management to focus on the largest cost opportunities and deliver strong results.
  • Led Tableau Development activity for various function in organization.
  • Automated the process of Financial Business Review Metrics from SAP BPI.
  • Automated the HR Analytics through tableau dashboards.
  • Automated Annual Financial publications for entire organization. (which is hosted in Organization official website)
  • Integration of SAP Bo reports inside the tableau dashboard using tableau web object and passing SSO credentials to SAP BO through tableau.
  • Developed dashboard for inventory loss management, to identify the loss by stages of inventory management.
  • Developed complete cashflow report in tableau for all products in OLAM.
Cargil Business Services, Bangalore
Dec'15Nov'17

Senior Analyst-Market Intelligence & Data Analytics

  • Leading market intelligence, data analytics and e-sourcing delivery to sourcing teams globally. Categories include Chemicals, Packaging, Ingredients, Plant Materials and Services and Corporate Materials and Services.
  • Managing stakeholders globally including category managers, finance reps and global leadership team
  • Supporting category teams with strategy development, negotiation, contract management and supplier performance management
  • Automated the travel cost analysis in tableau using various parameters.
  • Mapped the shipment routing tableau for delay analysis.
  • Using cluster analysis found the optimum landfill to dump the production waste from our plants.
  • Built product cost model in tableau to analyze the cost impact of sub products in main product.
  • Proactively analyzing market trends and finding opportunities for cost saving.
  • Developed & maintained Source-to-Pay training and enhance source-to-pay performance metrics.
  • Perform method improvements and innovations by actively identifying performance gaps through benchmarking.
  • Combine solution results with graphics to create presentations and reports for reporting both inside and outside of Procurement.
  • Playing SPOC role for all BI analytics reporting services.
  • Creation and maintenance of Power BI Dashboards from Tabular Model Cube.
  • Created Rich visualized Pie Charts, Tree Map, Tabular and Matrix Reports Using Power BI.
  • Creating Complex Calculation fields using LOD Functions and Table Calculations
  • Specialized in product research and cost estimation to the respective markets.
  • Applying best sourcing practices (Spot buying, select supplier, supplier consolidation through tail spend analysis) to the purchasing department to maintain optimum savings.
  • Maintaining the data bases and design, develop and maintain dash boards for Executives. Identifying the trends and explain the variances as per the analysis.
  • Engaging with Executives to gather the information to cater their needs. Periodic review of spend data across categories.
  • Analyzing trends involving multiple streams of data for a category of spend, studying the evolution of the category.
ITC, India
Nov'12Dec'15

Data Analyst

  • Conduct external market research including key industry, market and category/commodity information to assist in strategic purchasing decisions.
  • Proactively analyzing market trends and finding opportunities for cost saving.
  • Provide relevant industry cost information to buyers to assist them in negotiations.
  • Timely translation and communication of industry data into reports and charts and management of Internal and External Databases.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
    Worked closely with Business users. Interacted with ETL developers, Project
    Managers, and members of the QA teams.
  • Converted existing BO reports to tableau dashboards
  • Created different KPI using calculated key figures and parameters
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
  • Strong Dashboard design experience and passionate practitioner of effective data
    visualization. Familiarity with best practices around visualization and design.
  • Provided Production support to Tableau users and Wrote Custom SQL to support

Technical Skills

Tableau
Tableau Prep
MS Office Suite (Excel, Power Point, Word)
Machine Learning
Jira and Confluence
Python
Alteryx
MS Office Suite
AWS (EC2, Dynamodb, Timescale DB, Lambda, Kinesis, Event Bridge, S3, Glue, EMR)
Teradata
Snowflake
SSIS
Power BI
SSAS
SQL
SAP BODS

Core Competencies

Project Management
Requirement and User Engagement
Strategic Sourcing and Procurement
Spend Analytics
SDLC
Market Intelligence
Data Analytics
Supplier Consolidation
SAP System Knowledge

Education

McCombs School of Business
Jun'21May'22

PG-Diploma in Data Science and Business analytics

Jagdish Sheth School of Management (formerly IFIM Business School)
Jun'11May'13

PGDM - IB (International Business)

Visvesvaraya Technological University, Belgaum
Jun'07May'11

BE - Electronics and Communication Engineering