Senior Consultant
Ernst & Young(EY)
Total years of experience :10 years, 2 Months
> Data analytics program delivery management for a Canadian public/government healthcare institution
I have the project delivery of two projects of the program. 1. Survey data transformation & analytics 2. Spend data analytics - The key project activities include - Healthcare survey data transformation project for 300+ hospital data sets in the province, survey data analytics, spend analytics and business intelligence dashboard development. Tools used - SQL, Tableau Desktop, SSIS, MS Excel, MS Access, MS PowerPoint
> Sourcing diagnostics for a leading Canadian Power & Utility company - Lead a team of data analysts in data extraction from source systems, data pre-processing, data transformation and confirmation of data of diverse content, structure and quality.
I have re-designed the existing taxonomy tree of 70+ categories to 30+ categories using UNSPSC taxonomy to enable better spend visibility. Python based item classification toolkit were used to categorize and consolidate the spend categories in the data sets.
Spend intelligence dashboards were developed to share insights to the client. Tools used - SQL, Tableau Desktop, Python based Text analytics, MS Excel, MS Access, MS PowerPoint
>Taxonomy, Spend intelligence & reporting assessment for a leading Telecom company in Qatar
As a lead SMR, I was diagnosing the client PTP practices; spend data sets and existing taxonomy tree (category tree) to understand the present data flows, data structures, reporting processes and bench marked them with leading industry practises. A detailed benchmarking report were prepared and submitted to the CPO as a deliverable of the project.
> North American Supply Market Intelligence & Category Market handbook development for a leading European railcar manufacturer
Lead a regional strategic sourcing effort to identify potential North American supply base (of 300+ suppliers) across sourcing commodities for the client. As a team we have managed to run 100+ RFx events and their evaluation, developed 33 market handbooks with category insights (incl. Market dynamics, Supplier competitive intelligence, Porters five forces, TCO etc.) within a limited time period. Created QIA template assisted the client in supplier QIA scheduling and feedback sessions. Tools used - Gartner, D&B reports, MS Excel. MS Access, MS PowerPoint
> Procurement transformation for a leading Indian tire manufacturer company (onsite project)
Lead the Procure-to-Pay as-is process diagnostics and PP maturity assessment at the client site and prepared and collaborated with the key client stakeholders for procurement performance improvement.
> Vendor risk management support as a part of IT risk transformation of a leading US Health Insurance client - As a project manager I was responsible for identifying best fit analytics solutions for the vendor risk management project team.
MS excel reports were extracted from SAP BI tool and macros were developed consolidate vendor master data files.The interactive executive committee dashboards were prepared using Tableau.Python based text mining solution used to transfer data from existing ERP format to new ERP format.Tools used - T-SQL, MS Excel macros, Tableau Desktop, Python based Text Mining
> Business intelligence dashboard development and deployment for internal audit analytics solution
Managed a group of BI analysts, lead the requirement gathering/backlog development, created 150+ interactive live dashboards using Tableau desktop, published Tableau server, which is widely used across the clients.
> Analytical solutions/product development support
Worked as a lead Sr. Business analyst for the analytical solution development team. The key activities were - initial client discussion, lead joint design workshop sessions, requirement gathering or recommend wireframes, technical consultation to client, sprint planning, conduct product demo sessions, Attend test case developments and UAT review sessions.
Strategic Sourcing:
I have worked along with various Global and Regional Procurement Directors, Category Managers and key client stakeholders to develop the sourcing strategy, project planning and project execution
Experienced in defining the right sourcing process for the category and ensuring compliant sourcing process
Spend Analytics:
Performed various simple and complex spend compliance reporting to identify spend leakage and improve spend compliance within the procurement organization
Experienced in Pareto analysis, ABC Analysis, spend and supplier concentration analysis, Payment Term analysis and developed multi-dimensional reports to identify sourcing opportunities and across sourcing categories
I have worked on MS Excel and MS Access based Spend tools, Emptoris Spend Analyzer and Business Intelligence(BI) tools to extract the spend data and to analyze the spend
Industry and Market Intelligence Reporting:
Experienced in identifying the Industry and market intelligence (Market Size, Market overview, Identifying TCO for the Market, applying Porters five forces to identify market competitiveness etc.) for the defined product or services, reviewed the market intelligence and benchmarked the sourcing requirements to assist the in-house Sourcing / Category strategy
Experienced in Research sites such as Gartner, Dow Jones, IDC and other relevant open sources (Govt. websites, Corporate Associations, Institutions) to gather Market Intelligence for the product and services
Supplier Identification and Analysis:
Worked on identifying the right source of supply for various direct and indirect category products and services
I have completed 100+ supplier profiles (One pager) and presented them to client stakeholders, to get their buy in from them to shortlist the suppliers for the e-Sourcing projects or for
Spot buy processes
E-Sourcing management (RFx and e-Auction):
As a part of e-Sourcing management, I had the privilege to closely work with cross functional teams and category managers to develop developing the best RFx/e-Auction strategy, design project timeline and defining RFx questions and templates required for the RFx project
I have designed, developed and managed 60+ e-Sourcing projects including RFI, RFP and RFQ for various products and services, via Emptoris e-Sourcing tool
I have worked on 40+ e-Auction project with an average savings of 4% from the baseline spend and experienced in forward auction project as well
Proficient in supplier engagement in e-sourcing project: The activities include - develop Confidentiality Agreement(CA) for supplier liaising with legal team, communicating the project scope to suppliers and getting the signed CA from them, training them on the e-Sourcing tool, manage and monitor the supplier participation in e-Sourcing tool and helping them submit their proposal / bids as per the defined timeline
Expert in e-Sourcing Administration activities: Buyer User creation and administration, Supplier Profile Creation, Supplier User creation and administration etc.
Category Management Activities:
Significant sourcing exposure to indirect categories (Logistics, Travel, Packaging, MRO, IT, Office Supplies and equipment, Promotional items etc.) and their category strategy Matrix
Active participant in Global, Regional category meetings and category review calls of the Client
Designed and developed category scorecards for the global and regional category managers on a biannual / quarterly basis to review the category strategy
Designed, developed and KPI’s for Supplier performance management (SPM) and redefined SPM with the internal team.
Conducted Buyer survey via Emptoris for internal client stakeholders to understand the supplier performance management, procurement management etc.
Prepared Master Contract template for one of the client
Genpact had offered a plethora of opportunities to learn and they are: 100 Million GE Energy sourcing project, expediting process, Procurement process, Order management process, Accounts payable process etc.
I have attended several LEAN and Six sigma training sessions and developed VSM form the existing process
Conducted various training sessions on MS Office, C, C++, SQL, etc.
I have completed Senior Professional in Supply Management(SPSM) , international certification offered by Next Level Purchasing Oraganisation, USA
Bsc. Mathematics was a graduation course offered by Calicut University, which had a duration of 3 long years