PROFESSIONAL SUMMARY:

• Managed complex projects in various capacities where I was responsible for all components of project finance & delivery including Resource Management and Personnel Development, Project Management and Execution, Solution Architect / Subject Matter Expert/Design Expertise, Methodology Development, and communication to the stakeholders.
• Maintained a project plan with effort estimates, work breakdown structure and schedule for all efforts, project risk and mitigation plan, identifying and documenting alternatives out of negotiations with the teams.
• Managed cross - functional & cross-organizational team of consultants throughout the implementation phases while monitoring the design, development, implementation, SIT, UAT cutover tasks, and requirements-based and project-based issues and track to resolution.
• Worked with different levels of management throughout an organization while managing multiple projects simultaneously. Also, responsible for the weekly status reports to project sponsors clearly describing the accomplishments, future milestones, Issues & risks.
• Experienced in formal project management methodologies using either Waterfall or Agile methodologies.
• My consulting experience spans diverse industries including Manufacturing, Retail, Hi-tech, Automobiles, consumer goods, financial services, after market Services, HVAC, energy and Resource management across global clients like Arrow electronics, Emerson, Toshiba, Rheem, Graphic Packaging International, Ball Inc, Ricoh USA, Modern Karton (Turkey), Guangzhou Paper (China) etc . Also, led Demantra support and enhancement team for reputed clients like Apple Inc.
• Successfully managed end-to-end business transformation programs encompassing MDM tools like Informatica, Oracle PDH; DW tools like TD, Hadoop, Data lake; reporting tools like Tableau, APCC, micro-strategy; WMS tools like Oracle WMS, High Jump; Sales management tool like SFDC and various versions of (R12/11i) of Oracle ERP Modules, Honeywell’s Optivision solutions, JDE and SAP modules.
• Excels at leading teams and establishing consensus between disparate functions, cultures, and levels throughout organizations. Managed team of varying size, the biggest team was of 48 personnel.
• Managed multiple programs in parallel ranging from 1 million USD to 4 million USD.

PROFESSIONAL EXPERIENCE:

Role: Delivery Lead

Responsibility:

• Managing 3 projects which are divided in 4-8 sprints and each sprint has Grooming / build capacity of more than 250 story points per sprints.
• Managing Scope, Project milestones, Risk, Issues, communication, finance, budgeting, CR etc.
• Managing team of 27 resources including managers, architects, Informatica developers, TD developers, testers & scrum master.

Accomplishments:

• Accurately estimated the story points, resource requirement, delivery schedule leading to zero slippage on project schedule and financials.
• Pro-actively managed the requirement analysis, development, testing and categorization of defects and new enhancement in an appropriate buckets.
• Coordinated the technical analysis to ensure that parallel testing are scoped properly and timely escalated the issues which has the potential of derailing the overall project schedules.

Business Process Improvement

IT Business Solution

• A single view of data created by mapping product with supply chain materials.
• A set of business rules are identified to match and merge the duplicate records into one golden record.
• An exception based process to enable the business users to map the SKU to golden records.
• IDD screens were created to support bulk loading process of data sourced from multiple data system.
• Match / merge and trust rules were configured to generate the golden records
• GUIs were created to review the exceptions and map it manually to the golden records
• Message-based web services were used to publish the XML files to destination system on near real-time basis.
• Rest API will be used to download product data from Product Information Management
• Splunk tool is used to generate the validation reports using system logs
• Data Lake & Micro strategy is utilized for business and comparison report between MDM and planning tools like CAS, UFP etc.

Role: Project Director

Responsibility:

• Played dual role of program manager and functional leader where responsible for managing Scope, Project milestones, Risk, Issues, communication and also, managed the requirement & solution.
• Managed team of 5 including project manager, Functional & Technical consultant and testing team

Business Process Improvement

IT Business Solution

• Developed / Documented best in class Demand planning and review process from scratch which uses the information provided by Sales, Product engineering, Statistical Demand planner and Finance to generate Consensus Plan
• Revised inventory strategies and based it on supply chain volatility for the efficient movement of materials throughout the manufacturing and inventory cycle to ensure decreased on-hand inventory and increased inventory turns with no negative impact on the company’s performance.
• Developed Rough-cut capacity calculation model to be used across Americas, EMEA & APAC.
• Sales forecast driven planning is replaced by Demand-driven supply planning process.
• Planned metrics and KPI for the overall planning process. Also, created the models of the dashboard to be used during various phases of sales and operation planning.
• Managed the requirement gathering sessions and creation of functional and technical design documents.
• Designed Interfaces between Demantra and Oracle Order management, Inventory, MDM (Item, Customer), BOM, SFDC, MFG/PRO as client owns different IT landscape in different geographical location.
• Custom view to manage rough cut capacity plan at product family level in Demantra and managing the weekly production of production line through that view. It was supposed to be used for balancing the production between Itron production facility and contract manufacturers.
• Designed interface between Demantra and finance planning tool.
• Designed interface between Demantra and Sales management tool (Salesforce SFDC)
• Created technical design to calculate demand variation and time-phased safety stock.

Role: Technical Manager / Solution Lead

Responsibility:

• Played the dual role of team manager and functional leader where responsible for managing Scope, Project milestones, Risk, Issues, communication and also, managed the requirement and design.
• Managed time of 9 resources including DBAs, Business process consultant, project manager, Functional & Technical consultant and testing team

Business Process Improvements

IT Business solution

• Developed / Documented collaborative demand review process. Planned for a systematic feedback loop from Sales, Marketing, and Finance team.
• Process design for Attach rate based forecasting and inventory planning of Components.
• Process design for Supplies (Cartridges) forecast which varies with the life cycle of installed machines.
• Service parts forecasting was aimed at reducing the purchase of new parts and maximum utilization of Repair and refurbished parts.
• Master item creation and planning attributes were reviewed.
• A business process to merge CTO BOMs representing trade names variants were identified.
• Documented end to end implementation phases starting from requirement gathering session till Production migration.
• Innovative ETL design and hierarchy data model to facilitate data load for two LOBs into one data model
• Implemented the highly customized CTO solution for FG line of business. There were complicated customizations for inbound configurator & OM data load, attach rate calculations, Supply attach rate calculations, Supply forecasting which is driven by product life cycle.
• Developed custom collection process for downloading Service parts history shipped to Canada and LATAM along with field technician usage history.
• Interfaced with Salesforce.com to bring quotes with higher probability. Also, created an OBIEE report to show quantities with different probabilities.

Role: Technical manager

Business Process Improvements

IT Business solution

• Fine-tuned the process of consensus demand plan generation by including Customer shared forecast.
• Long-term Aluminum contract was based was tied to Bottom-up Demand forecast instead of Top-down Financial plan.
• Financial plan and Volume forecasting process were interlinked leading to more stable revenue forecast.
• Rules for stocking SKU and quantities defined to handle seasonal resource constraint. It was used to level the production plan, streamline the resource utilization, and avoid the frequent shutdown of lines and frequent overtime and underutilization of Human resource.
• Conducted requirement gathering sessions followed by solution analysis, design, development, testing and training.
• Customized Data integration between JDE Operational Data store and Demantra S&OP hierarchy data model
• Seamless custom data integration between Volume planning and Finance planning tool (Hyperion) was created.
• Integration between Oracle Planning and reporting tool.
• Created custom worksheet to view Volume forecast, Dollarized forecast, Production plan, inventory plan and dollarized view of supply time series side by side and at higher levels of product/customer/location/organization.

Reporting Specific Design/Development/Testing/Training:

• Implemented Demantra-APCC interface and ASCP-APCC interface
• Customization within APCC physical layer to create custom prompts using planning category code.
• To meet the business requirement of archiving certain planning attributes, ASCP tables are exposed to APCC.
• Created custom reports under Sales & Operation and SCA dashboard with a consolidated picture of Production, Sales, and Inventory.
• Created custom reports for Demand side with KPIs like MAPE (units, $), Bias, Diff: Finance/Volume plan, waterfall diagram (units/$)
• Custom reports for Supply side with custom prompts showing resource plan, Production plan, inventory plan with the supply KPIs like Production plan Vs actual (Note: Production migration was on Hold as ASCP implementation got extended)

Role : Functional Consultant

Business Process Improvements

IT Business solution

• Using Demantra S&OP tool, an end to end standard S&OP process demonstrated to multiple user groups including company executives to identify how well the application meets client’s needs and identify gaps.
• The Custom programs are created to import certain data stream from ASC and EBS instance.
• The Custom solution created to enable production rate calculation with input as target inventory. New series with a complicated server and client expression is defined as a part of above requirement.
• Trained end users on sales and operation planning module.
• Process of introducing new products in Demantra is streamlined -
• Trained users on the usage and benefits of Create Similar Product versus Member and chaining management functionality.
• Interface between Order management-WMS (Hi-jump). Hi-jump is used for Pick release and pick confirm processes including freight calculation and serial number (for a serial controlled item) and this information is sent back to oracle to ensure Inventory and invoicing processes are in sync.
• Interface between Order management and OTM (transport management) to create an optimized trip plan and ship method determination. Delivery schedule is updated back with trip details in Oracle
• Managed sales history conversion from legacy system (Data warehouse) to Demantra.
• Customized item and location hierarchies as per client’s requirement.
• Architected innovative solution to client specific requirement which encompasses Rolling profiles, Line of Business, worksheet, workflow functionalities, user securities etc.
• Designed and implemented a customized interface to publish forecast to ASCP.
• Worked on an improvement of forecast accuracy using causal factors and system parameters.
• NPI - Custom workflows are created to keep EBS item master data with NPI launched in Demantra.

Role : Demantra Lead

IT Business solution

• Lead for supporting Demand management and replenishment processes of retail stores and Hub through customized Demantra solution including customized staging layer to import data from Data warehouse (Informatica) to Demantra and export data from Demantra to SAP/Informatica
• Lead for managing life cycle of enhancements
• Managed support and enhancement team.
• Forecast engine load was distributed across multiple Linux box (7 Nodes) having 10 OS on each of them. An engine manager program used to work as Map reduce function and divide the data points across nodes which works in parallel mode and update the final forecast into DB.
• Established support structure including system, processes and team to support production system.
• Handled enhancement requests for client.
• Stabilized highly unstable Demantra system for Apple by increasing automation, proactive error identification and handling, tuning alert mechanism.
• Provided solution to enhancement request and solution to fix loopholes once for all.
• Trained onsite and offshore team on Demantra tool

Examples of few of the issues:

• Run time for Proport was decreased by 60% by using cyclical proport which process data in parallel.
• Worksheet performance was improved by worksheet layout re-engineering, optimization of system parameters and utilizing functionality like caching.
• Custom chaining programs were created to ease the load on planners
• Several custom codes were re-written and run time was decreased by 50-80%. Programs were re-written to use Oracle package dbms jobs in order to process data in parallel at partition level.
• Run time for a custom workflow consisting of BLE steps was decreased from 5.5 hrs. to 3.5 by parallelization introduced through container step, and finally to 30-45 mins.
• Distributed forecast engine registered on 7 Linux box was stabilized by tuning weblogic parameters (“out of memory” errors), DB parameters and by optimizing Demantra parameters like Branch multiple, number of CPUs, Bulk load threshold etc.

Role : Oracle VCP suite offshore lead (Demantra and ASCP)

Responsibility-Functional Lead

IT Business solution

• Lead for Attach rate based component and inventory raw material planning process enabled through Oracle VCP tools.
• Conducted requirement gathering sessions followed by solution analysis, design, development and testing.
• Supported technical team to strategize sales history data conversion.
• There were lot of complexities involved due to the coexistence of JDE and Oracle Application in the To- Be World as well.

Role : Oracle EBS lead (OM, Inventory Management, Advance Pricing)

Responsibility-Functional Lead

IT Business solution

• As a functional lead, I was responsible for design, development and testing of customized solution
• As an offshore functional lead, I handled release 3.1 which included lot of customizations around Order management, Inventory and Advance pricing modules of Oracle Application.
• Oracle EBS-based innovative solution was designed to address the functionality requirements and need for scalability and growth in all markets.
• Used order management functionality of service as Items and interfaced with Point of Service tools to automatically create orders with Shipped status.
• Used various feature of Advance pricing like volume based price break, modifiers, qualifiers etc. which is used during invoicing cycle.

Role : Oracle VCP Suite consultant (ASCP module)

Responsibility-Functional Lead

IT Business solution

• Responsible for implementation of unconstrained raw material and resource planning processes and mapping it to Oracle ASCP module.
• As an offshore functional consultant, I handled rollout activities of ASCP module.
• Handled solution optioning, fit gap analysis, created test plan, test scenarios and test scripts and executed the plan.

Role : Oracle VCP Suite consultant (Demantra Demand Management module)

Responsibility-Functional Lead

IT Business solution

• Implementation consultant for Demand management processes which includes complicated calculation and validation process for customer shared forecast against blanket sales agreement.
• Implementation consultant for customized Demantra Demand Management module
• Demantra functional lead for APAC region rollout.
• Responsible for Configuration of global instance.
• Handled various phases of implementation like requirements analysis, solution optioning, fit-gap analysis, feasibility analysis, impact analysis for APAC region rollout
• During global solution design, contributed in solution optioning, feasibility analysis and user testing phases.
• Coordinated the development activity of complicated customization. Also, owned the customization meant for importing customer forecast which passes through series of business validation rules before consensus forecast is generated using statistical and customer forecast stream. The design was spread across ASC instance (concurrent program and notification), Demantra worksheet (like parameter setup for business validation), workflows with BLE steps to evaluate client expression and save data in tables, and Demantra base tables like sales data and mdp matrix etc.
• Several import and export integration interfaces were designed to import time independent (mdp matrix) and time dependent data (sales data).

Role : Functional Consultant/Business Lead for Implementation projects

Responsibilities:

• Implementation of OptiVision package which includes analyzing As-Is and To-Be to identify the gaps and provide the solution to meet the business requirements
• Document creation - Solution document, functional design document, Test scenario, test plan, test script.
• Coordinating with technical team during development of design.
• Responsibly handled end to end life cycle of Business System implementation projects for global clients.
• Implemented integrated system with below functionalities:

Confidential

Role : Assistant Manager (Supply Chain planning and Production planning)

Responsibilities:

• Responsible for 1.5 lakh tons p.a. of production and its quality that accounts for 70% of total revenue of the unit.
• Managing production team of around 48 personnel
• Responsible for long/short term planning process of the facility.
• Managed one of the Asia’s best paperboard machine whose floor length is 600m, I was responsible for 1.5 lakh tons p.a. of production and its quality that accounts for 70% of total revenue of the unit.
• Managed production team of 32 operators and 8 shift managers. Responsible for creating shift/work schedule, work allocation, conflict resolution, skill development etc.
• Handled monthly demand plan for my LOB. Also, responsible for involving sales & marketing to review the plan, and involving material managers, utility managers, inventory managers to generate the consensus.
• Managed SCM of production line
• Managed raw material and other consumables requirements, capacity requirements of machines, inventory and logistics requirements in collaboration with various internal and external stakeholders like internal suppliers, Sales and marketing, Utilities, Warehouse, Logistics etc.
• Regularly published forecast to downstream process
• Regularly examined the supply and demand picture associated with the line of business
• Managed production cycle of portfolio of products.