Supply Chain Analyst
Since November 2014
PROJECT: Supply Chain Planning Role: Business Analyst -Supply Chain Management. Client: Federal Mogul Motor Divisionfor EMEA Region Applications: SAP Logistics & Procurement, MS Excel, Power Query, Power Pivot, MS Access, VBA, Every Angle, BEX Analyzer, Lotus notes Responsibilities: Source data need to be extracted from SAP ECC, SAP BW & Every angle. Use customized transactions for extracting Line fill rate by Customer, Vendor Supply & Forecast Data, Customer Past Due, Material Status, Expedite Data at Plant level, Net Negative availability at Plant Level, Inventory data. Some of Scheduled reports are: o Blocked Invoices: o Inventory reports: Inventory Quality report, Inventory Outlook; Inventory Outlook Finance o Fill Rate:Fill rate France, Fill rate MTD, Fill rate Bible o Vendor Performance:Vendor Shipping /Past due report o Net Negative availability & Evolution report o Customer Performance:Key Customer Fill Rate report, Customer Backorder report o Goods return:Update the status of the material to be returned after checking the status from SAP System and mention the comments respectively. o Supply Value Plan(SVP) o Demand Over Capacity(DOC) o Adhoc Reports: Modifying template Monthly/Quarterly/Yearly for respective reports Additional Responsibilties: Developed Powerpivot report for Net negative evolution over the period of last 52 weeks, by consolidating data in datamodel using power query, and generate the evolution report using power pivot in excel. Develop Access Tables for Product Hierarchy&Masterdata and build Queries and Macros to automate the Report generation Process. Developed Macros to split one main report to multiple reports based on Vendor & convert them to PDF. Cretaed complex function to reutilize & avoid manual validation of data every week. Remodel the Fillrate report from Weekly report to have Historical Data for YTD & MTD Analysis
June 2009 --- November 2014
DATA VALIDATION: (SAP MATERIAL MASTER) Create Material for the New Items need to be Include/Changed in the System using MM01/02 T-Code. Pull Reports from SAP System Using SQVI Queries , Analyze the Part Number and Mark the Part Numbers which are incomplete/Invalid in the System. Also validate the Part numbers in the System wrt the Manufacture Price Files/Sources. Mark the Duplicate Part Number in System Existing in the Multiple Plants (Country Wise Branches) Update the Modified Part Numbers in the SAP SYatem Using LSMW . CIN(Common Item Number): Linking Item number across countries of the same brand and assign the common item number. Knowldege of data extraction and Manufacture Part Number Nomenclature analysis. DATA CLEANSING: Cleaning the existing data like Part numbers, Description, Catalog Numbers existing in Manufacture Legacy Inventory and removing the Duplicate entries in the system. DATA CATEGORISATION: Assign Standard Product Hierarchy codes for the Part number. Which involves detail level of Sourcing and Product Knowledge. DATA NORMALISATION: Identify the Latest and Exact Manufacture name as per the Manufacturer Latest Updates. This process involves assigning Correct manufacture name and Brand Names based on their Global Presence. Responsibilities: Build Rule Documents and Process documents required for each Process. Explain the Process methods & techniques to the subordinates.
Clinical Research Coordinator
September 2007 --- June 2009
MS-Excel, Manual Testing on the Inhouse Tools. An Application Outsourcing Project Management Office (AOPMO) is a centralized unit of the leadership team dedicated to Project Management activities. Specific activities executed by the PMO: Administering the project plan and providing information to the management and Tracking project performance, schedule budgets and reporting to the leadership team. Role & Responsibilities * Monitoring the release version and preparing dashboards for the engagement team based on the Performance Level. * Providing project staffing activities by coordinating with IDC resource management groups. * Closely working with SQA team to identify and minimize the data issues. * Creating Weekly/Monthly DCN IDC Summary reports which comprise of performance metrics of the project for analyzing the overall performance of the project against the targets & the achieved figures. * Metricising the data from the measures provided by the Project Team. * Working closely with SEPG team to sort out the reason for variance in the effort/Schedule of the Project team Performance. * Plotting and comparing the trend (for last 4weeks/6months) of the Weekly/Monthly performance of individual Project to help the project team to show the progressing level in the performance. * Consolidating the different Delivery centers Monthly metrics reports to represent the organizational performance to the Top Management. * Creating Monthly Dashboard, which highlights the overall performance of the project to support the Management Decisions. * Preparing Control Charts for the Core metrics of the project on a period of quarter year to check limits are between the organizational UCL & LCL. * Automating the some of the sections using links, Pivot tables, Vlookup functions and Macros. Additional Roles: Manual testing on the Automation Tool developed for the Consolidated Reporting.
June 2006 --- July 2007
Project Details: CNN Content Management (MRO Project) As QC Team Member Requirements: UNSPSC Tool, UOM (metric & Imperial), SMD (Reference), MS Excel, MS Access. * Enrichment of MRO products includes Mechanical & Electrical Manufacturing goods & supplies. * Files are categorized based on Noun, Modifiers or Keywords. * Templates are being filled based on Modifier ID recommended by clients. * Cleansing the data with the given Manufacturer Name/Part Numbers. * Checking for consistency in the complete file based on the requirements & Standards. MGH Content Management. (Healthcare Project) As QC Team Member Client: GHX Healthcare Products Service provider. Requirements: UNSPSC, SMD, MS Excel, Standard UOM reference. * Classification of products using UNSPSC tool. * Sourcing of products according to part number in the manufacturer/vendor site. * Enrichment and filling of attributes related to the product. * Normalizing the Description with the Enriched Data. * Long & Short Descriptions are Prepared according to the Specifications.
December 2004 --- April 2006
MRO PRODUCTS CLASSIFICATION & DATA ENRICHMENT
Skills and Expertise
Analytical skills Analyze data
BE in Electrical and Electronics from Vidya Vikas Institute of Engineering and Technology*,Mysore in 2004
PUC in PCME from Sharada Vilas PU College*, Mysore in 2000
SSLC in MATHS from Sree Cauvery School*, Mysore in 1998