Professional Experience

Senior Business Analyst

Confidential

• Conducted multiple projects using the seven steps of sourcing, creating RFI, RFP's to lead cost saving for PepsiCo.
• Consolidated global RFI/RFP data for the POS category. Data normalization and analysis of volume of data including the creation of pivots, vlookup, hlookup and other commands in excel.
• Followed the Global Procurement's 7 step sourcing process to make templates of Requests for Information, Request for Quotation, Request for Proposal
• Developed RFIs, RFPs for these items and went through a detailed RFP involving more than 40 suppliers for each category. Worked on SAP Ariba
• Circulated RFI's to all 40 suppliers and based on responses from these suppliers, shortlisted the suppliers from 40 to 20
• Sent RFP's to the shortlisted 20 suppliers requesting their bids on the racks listed in the RFP.
• Shortlisted the top 3 suppliers after evaluating their bids in the RFP. Shortlisting was done based on the lowest bids and multiple negotiations with these suppliers. The top 7 suppliers were given a chance to show their presentation to PepsiCo stakeholders.
• Was part of stakeholder engagement, supplier engagement and contract negotiations.
• Was part of making contracts and getting a sign in by all the suppliers.
• Developed key metrics for sourcing Point of Sale Metal racks from 40 suppliers across Europe, Russia, South America and Asia. Created Executive dashboards to compare and analyze data from 40 suppliers
• Developed templates and tracking mechanisms to ensure the global sourcing teams are managing categories of spend in a best-in-class, professional manner.
• Tracked, analyzed and communicated requirement change requests, enhancements, and defects.
• Provided effective project status using dashboards, budget reports and Gantt chart updates on a weekly basis
• Developed global commodity strategies, input pricing models, commodity and currency market tracking
• Created 'swim lane' documents that were used to break down complex business process flows.
• Performed current and future state analysis to collect trend data to anticipate and identify changing conditions, which resulted in preparing and implementing innovative corrective actions and used to create concise business requirement documents.

Seven Steps of Sourcing in Advertising Media category:

• Before: Suppliers were charging excessively for advertising and media services to PepsiCo.
• Seven Steps Sourcing: Used Seven Steps sourcing methodology, circulated RFI's and RFP's to shortlist the most suitable suppliers. Broke down the suppliers cost into component costs, gathered cost visibility and asked the suppliers to fill out this info in the RFIs. This information was useful in shortlisting the suppliers.
• After: Cost saving of more than 35 in the category was observed.

Seven Steps of sourcing in Social Analytics

• Suppliers were providing social analytics services to PepsiCo. They were collecting data and providing analysis from social networking websites such as facebook, linkedin, twitter etc about the image of PepsiCo in social media.
• Developed RFI and RFP to shortlist suppliers

Result: PepsiCo has more reliable information about their brand in the social media.

• Operations Head, ITC India Ltd., June 2006 to March 2013 ITC is one of India's foremost private sector companies with a market capitalization of US 35 billion and a turnover of US 7 billion. ITC is rated among the World's Best Big Companies, Asia's 'Fab 50' and the World's Most Reputable Companies by Forbes magazine and among India's Most Valuable Companies by Business Today.
• Operations Manager, ITC Ltd: Process Improvement and Supply Chain Stabilization: Involved in various business operations helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service, documenting the business process by identifying the requirements and gathering system requirements. Improved the productivity of the machines and helped make ITC printing and packaging very successful in cartons manufacturing.
• Operational Excellence: Focus on Operational excellence strategy
• Strategy deployment: Good quality, lowest price, ease of purchase, effective service and support
• Performance management: Improved performance by monitoring Supply chain metrics
• Process Excellence: Improved processes using Six Sigma methodology
• High performance work teams: Nurtured teams to produce results
• ERP evaluation and implementation SAP Benchmarking, Re-engineering and Change Mgmt. using ERP as a Vehicle for ITC Packaging and Printing Implementation Partners: Lauterbach Partner and SAP India
• Led a team in Process Improvement and Process Mapping leading to successful implementation of SAP in a record time of 5 months. Implementation Partners: Lauterbach Partner and SAP India
• Extensive Vendor evaluation, process mapping, gap analysis, configuration and customization according to business needs. Tool used for process mapping: Mega. Provided User Acceptance Training.
• Streamlined the Supply Chain Processes of ITC to help them in their Supply Chain Roadmap.
• Onsite end to end implementation of SAP. Conducted GAP analysis prepared Requirement Document for Management approval for ERP Systems business solution packages.
• Tested the functionalities of the ERP system implemented by the implementation partner also preparing a Gantt chart for ERP implementation of the entire lifecycle.
• Process Mapping - As Is and To Be for Supply Chain Processes Consolidation of desired state process maps and stakeholder recommendations after interviewing 50 process owners of different processes. Extensively travelled to interview various process owners.
• Involvement of users and Process Owners in signing off the desired state process maps and in final evaluation of ERP Vendors Sending out RFP to vendors Evaluation of responses, Gap Analysis, Vendor Selection, Final selection of ERP
• Business Object Oriented Modeling, RFP Preparation, Vendor Selection for software products
• Process owner for SD and PP module implementation

Confidential

PeopleSoft ERP Implementation

• Onsite Project for Danske Bank, Copenhagen, Denmark
• Streamlined the HR and Payroll Processes of the customer to help them in their HR Roadmap.
• Onsite end to end implementation of PeopleSoft. Conducted GAP analysis prepared Requirement Document for Management approval for ERP Systems business solution packages.
• Tested the functionalities of the ERP system implemented by the implementation partner also preparing a Gantt chart for ERP implementation of the entire lifecycle.
• Process Mapping - As Is and To Be for HR and Payroll Processes Consolidation of desired state process maps and customer recommendations after interviewing 50 process owners of different processes. Extensively travelled across Denmark to interview various process owners.
• Involvement of users and Process Owners in signing off the desired state process maps and in final evaluation of ERP Vendors Sending out RFP to vendors Evaluation of responses, Gap Analysis, Vendor Selection, Final selection of ERP
• Tool used for process mapping: Websphere IBM Modeling Tool
• Utilized RUP to configure and develop process, standards, and procedures.
• Conducted Joint Application Development JAD sessions with stakeholders throughout SDLC to resolve open issues.
• Worked with QA team to design test plan and test cases for User Acceptance Testing UAT
• Coordinated work plans between project manager and client using MS Project.

Confidential

Help Desk teams

• Developed Solutions in the area of Enterprise Performance Management, Supply Chain Optimization, Balanced Scorecard, Spare Parts Portal, RFID Implementation, Warranty Management System and Engineering Calculation Tool for manufacturing industry.
• Developed a Root Cause Analysis report and Incident Report using MS Office. Ensured integrity of incident data through Weekly scrubbing session.
• Prepared Data for Weekly Operations Meeting using IT Metrics Values. Reported weekly system performance metrics R3 . Created, maintained and evolved documentation for change management process. Documented the SEV calls after every meeting. Actively participated in Domestic Maintenance Meeting. Updated Weekly Operational report on OneNote tool. Updated the Root Cause Analysis report every week on ITSEV. Used Remedy tool for Root Cause Analysis. Environment: PSERV, Remedy, Tech Events, Create Resolution Report Tool, IT Metrics, MS - Office, SQL, Windows, MS Access, Data analysis.
• Identifying operational risk or control problems at an early stage to ensure that immediate measures are taken to maintain quality and efficiency standards working with Business and Corporate Risk compliances
• Handled ISO, BRC and IQRS Level 8 Audits. Resolved customer complaints using six-sigma methodology. FMEA, CAPA and 8-D reporting.
• Led a three member team to develop strategic initiatives aimed at driving the growth of ITC Infotech in the Service Oriented Architecture SOA technology space.
• Championed IQRS Level 8 for ITC plant. Led a team of 40 managers to help the factory to be one of the first in India to achieve IQRS Level 8.
• Championed ISO 9001, ISO 14001, OHSAS 18001 BRC/IoP audits for ITC plant
• Developed metric reporting for weekly and monthly operations review using Minitab and Mircrosoft Office.

Senior Consultant Enterprise Architecture

Confidential

• Worked in advisory roles in the areas of Enterprise Application and Information Architecture
• Conducted detailed assessments of the existing IT architecture for clients and came up with issues and recommendations.
• Defined IT Strategy and Transformation initiatives for clients
• Used IBM Rational System Architect to model Enterprise Business Processes, Application Architecture views and Data Architecture views
• Supported pre-sales and practice building initiatives and contributed to practice documents and offerings

Technical Skills

• Databases Oracle 8i, MS Access, SQL Server, SQL, SQL Loader, TOAD
• GUI/Tools MS Project, Project Scheduler PS7 , Visio, MS Office Word, Excel, PowerPoint, Access , XML HTML
• Platforms Windows NT/2000, HP UNIX UNIX Shell Scripting
• Defect Tracking Quality Center QC , Clear Quest, Defect Tracker now Software Planner , RADAR Testing Tools LoadRunner, Quick Test Pro QTP
• Methodologies Agile, RUP, SDLC, Waterfall, Scrum, Six Sigma, CMMI, ITIL
• Other Skills Requirements Gathering Management, Application design, development and testing, Database Design, Application Migration.
• Configuration Tools Rational Clearcase LT, Visual SourceSafe VSS , Rational Requisite Pro
• C, C , Java, HTML, XML, VC , RDBMS - Oracle 9i, SQL Server 7.0.
• CMIE Database, MS-Office esp Microsoft Excel, Stat-Plus, Minitab
• Mega, Websphere IBM Modeling tool .