Girish N

Pricing-Procurement-Negotiation-MIS-Advance Excel

PROFESSIONAL STATEMENT
 A goal-oriented professional with 10 years of experience in MIS Analysis & Reporting, Purchasing and Business Analysis in Trading/Service industries
 Expert in Billing/ Invoicing, Revenue Management
 Expertise in Mapping Budget / Revenue / Forecast, Financial, Operations & MI analysis & reporting, Trends & Variance analysis Budget & actual costs for all work orders, project expenses tracking using trends & forecasts
 Strong working knowledge on KPI Designing, Presentations, Graphs, Analysis, SOP’s etc
 Strong Knowledge in Procure to Pay & Order to cash, MIS Analysis & Advance Excel
 Ability to managing large number of clients’/customers’ data & analyze according to business requirements
 Analytical, problem-solving with excellent interpersonal, communication and organization skills with proven capabilities in team management & stakeholder relationship management
 Expert in building SOP’s, Exception Trackers, Reports Trend Analysis
ORGANISATION EXPERIENCES
Company: Zafco- Jebel Ali Airport Free Zone Dubai, UAE
Designation: Team Leaer for Pricing
Duration: March 2017 to Feb 2019
Key Responsibilities:
• Directing team of 5 members to analyze & maintain Supplier Prices for Purchase order & Selling prices for sales order creation in SAP on different levels across globe in SAP SD Module
• Single Point of Contact for Material creation in SAP (MM Module SAP)
• Reporting analysis on Sales Trend & data insights to improve sales
• Market Research on vendor and alternative suppliers & getting quotes
• Place Order in SAP monitoring the stock leaves & report out the Inventory reports to sales, Directors to liquidate stocks with promotional offers
• Competitive Analysis on RFQ’s from different vendors, report out the analysis to procurement manager before negotiation & take approval
• Maintaining better Vendor Relationship
• Strive for the best Quality, Lead time & Price from the vendor
• Reporting analysis on Sales Trend & data insights to improve sales
• Have monthly review on the Costing & Prices with GP% with Directors
• Understand the market moving products & indentify the alternative brands to backup
• Negotiating with suppliers on Brand Development clause, as per the requirement of a particular market in MEAF
• Develop Pricing & Promotion Strategy on the obsolete inventory
• Maintaining Relationship management with vendors
• Preparing order Report on monthly basis with Forecasting the sales
• Reporting out Sales, GP Reports, Inventory Report, ASP, Profit Variance report to the management
• Preparing the Ad hoc reports as per management requirements
• Conducted Price Analysis for different regions based on the incoterms (FOB, DDP and CFR) along with Competitive Analysis for different aspects
• Support business & process improvement projects requiring improved pricing data & intelligence
• Collaborate with other functional areas to support key pricing-related data requirements
• Brainstorming with team on improvement ideas, Identify and Implement solutions
MIS Reporting Responsibilities:
• Comparison of RFQ’s to understand the best quote as per the requirement & assisting purchase team to find competitive price with better Lead time, Quality
• Extracting QLIK reports & generating YTD & Monthly Sales & Performance report for MEAF Markets under different sales person, sales group & region
• Publishing Inventory reports of different plants to Sales, Directors & Ordering team to liquidate stock & avoid obsolesce
• Extracting SAP Sales Reports & generating the Margin Report for Directors with ASP
• Identify trends, risks, opportunities and developments in different regions and present findings to senior management in a structured manner
• Competitive analysis on different Brands of Tires & Batteries based on different incoterms
• Generating inventory report on weekly basis to highlight the stocks to liquidate on different parameters
• Proposing the new Prices with different Pricing Strategies to meet Margin on sales
• Develop integrated revenue and cost break up analysis, projections, reports, and presentations to Directors
Project in SAP
Delivered a project on SAP in automating the Vendor price update, with different costing structure involving different business Modules, right from preparation of BRD, involving discussions with Directors and Management in understanding Background, Business Objects, Scope etc. to prepare the FRD and TRD. Setting realistic milestones and deadlines for the project completion and updating Management frequently on the progress. Coordinated with ABAP & SD Consultants in setting expectations, constant monitoring & performing UAT’s in identifying the bugs, raising change logs etc. to achieve deadlines.
Project impact
• Reduction in time of vendor price update
• Increase in Accuracy
• Reduction in complexity of cost calculation
• Reduction in dependence
Other Responsibilities:
• Setting Goals
• Drive productivity and efficiency
• Ensure SLA (Service Level Agreement) management
• Monthly Process Review & Audit
• Providing Feedback
• Driving Brainstorming Sessions to Solve issues & Drive Projects
Company: ECO Diamonds FZE - Dubai Airport Free Zone Dubai, UAE
Designation: MIS Analyst
Duration: March 2016 to March 2017
Key Responsibilities:
 Directed a team of 4 Associates for generating management reports
 Generation Consolidated & Region wise YTD & MTD sales reports on sales of Jewelaries & Diamonds
 Generating Inventory report on a daily basis for different regions across globe
 Generating Comparative Analysis report on weekly basis
 Proposing new reporting solutions to meet management requirements
 Providing ad-hoc analysis to management as per the requirement on Qlik & Excel
 Maintaining the trend analysis on sale of goods on different products to analyze the purchase patterns on region wise
 Preparation of presentation pitch for directors as per the requirement & inputs for meetings
 Providing maximum incites to management helping their decision making

Company: Genpact India Pvt. Ltd (GE Energy)
Designation: Management Trainee Billing Process (O2C Domain)
Duration: Oct 2009 to Jan 2016
Key Responsibilities:
 Directing 9-member team in O2C Domain under Billing
 Coordinating with CFM Team, Parts Research, Generation of RFQ’s, SO’s, Credits, Invoicing, Managing Disputes on SO’s Invoices, Revenue Management core responsibilities
 Generating different kinds of invoices i.e. Final Invoice for Time & Material, Recurring Invoice, Interim/Progress invoices etc. as per the Contractual Agreement (PO) with Customer in Oracle
 As a team, responsible to generate more than 1800 internal & External Invoices on monthly basis with $200 Million external revenue quarterly
 Contribution Margin Analysis for invoices (Ensuring COGS Liquidation in Oracle) for different businesses
 Generating and compiling a Monthly Sales report for GE Aero Energy
 Maintaining company’s confidential database (Cost, Operations, Production related).
 Preparing Business Dashboards Sales, WIP, Holds & Pipelines. (Invoice Holds, Disputes, Credits, WIP of Different regions across globe)
 Driving calls across globe in solving Issues on invoice & SO Disputes
 Identifying projects & Lean ideas through brainstorming sessions and driving them to completion
 Improved financial status by analyzing results, monitoring variances, identifying trends, recommending actions to management
 Creation and maintenance of databases (MS Access, MS Excel, Business Intelligence customized reports).
 Ensure deliverables & Monthly Metrics are met (Daily, Weekly, and Monthly MIS Reports & Dashboards)
 Interpret, analyze, and present data using MS Office (Excel, Word and PowerPoint)
 Compiling various reports to one format to present it in easily readable and interpretable format – which will enable Operations Team to act proactively
Awards & Certificates Links:
GB Certificate: https://drive.google.com/file/d/1lS4shF2V3mG8Jtm2DFV9EpeHB4ks3T5L/view?usp=sharing
Lean Certificate:
https://drive.google.com/file/d/187I7hoo8-RJdqEOyv8iZGkuN7Tkbjz4A/view?usp=sharing
Management Training Certificate:https://drive.google.com/file/d/1a6XelvKgIlSMmtWEsrpbnNH4iF9gt5x5/view?usp=sharing

Last Resume Update May 5, 2019
Address Dubai, United Arab Emirates
E-mail girish.dhanur@gmail.com
Phone Number 0526464102
Website https://www.linkedin.com/in/girishnanjundappa/

Contact Candidate