Harsh Patel
Irvine, CA *****
Cell Phone: 609-***-****
Email: ********@*****.***
Career Objective
I'm a highly experienced with every aspect of EPM, Planning Budgeting and Forecasting processes – from Benchmarking,
Performance metrics, long term strategic to daily operational plans and budgets. I am looking to build a career using SAP tools to
make programs better, people smarter, and businesses more successful.
Professional Experience
LAM Research, Fremont, CA 10/2014 – 02/2015
SAP BPC Solutions Consultant
SAP BPC 10.0 NW
• Led a team of 4 consultants throughout the project.
• Conducted sessions with the internal BPC team to understand current BPC templates.
• Implemented new changes requested by the Business users.
• Improved templates to ensure correct data is being retrieved.
• Created a new solution to improve performance by 50%
• Implemented all templates with performance improvements.
• Created a custom excel ribbon tab to include custom EPM buttons for ease of use.
• Created custom buttons to simplify complicated EPM process such as copy package.
• Ease of use allowed business user to perform tasks on the go.
• Created a Save process to reduce save time by 40%.
• Introduced troubleshoot email feature to simplify communication between users and IT.
• Created Inventory planning templates and reports.
• Used custom VB codes to create buttons on a Custom excel ribbon.
• Conducted unit testing on all templates to ensure quality.
• Conducted training sessions with the users to teach new changes and to show improvements.
NBCU, Universal City, CA 11/2013 – 10/2014
SAP BPC Solutions Consultant
SAP BPC 10.0 NW
• Conducted blueprint sessions with business teams to understand As-Is process.
• Created new design to replace As-Is process.
• Designed Labor Cost Forecasting process and templates based on blueprint sessions.
• Centralized Labor Cost Forecasting process throughout the company to allow corporate ability to run custom reports
based on Cost Centers and Profit Centers.
• Developed custom logic to support Accrual and Monthly Salary breakouts.
• Created hierarchies for Account, Cost Center, Org Unit, Position and Cost Object dimensions.
• Built complex Input templates to allow Labor planning during planning cycles and allow long range planning on yearly
basis.
• Built Accrual report to allow user to automate quarterly accrual process.
• Designed and built Labor distribution templates to allow users to allocate individual employees to different cost centers.
• Designed and Built custom Variance Reports such as Budget vs. Actual vs. Plan, by Wage types, Cost Centers, Profit
Centers and Trend reports.
• Created Work Status to lock versions based on Actual periods.
• Designed and maintained BW objects – Datasource, Info provider, DSO and Cube designs for DTP into BPC model.
• Created automated BW data loads and custom schedules
• Conducted one on one session with business users during development to ensure users understand the designs.
• Conducted Prototype sessions with all business users to show development of templates.
• Ensured all templates met the design requirements signed off by the business.
• Conducted training session to train business users to the new process and introduced the basic features of BPC.
• Supported the business during hyper care.
Coldwell Banker Residential Brokerage 06/2011 – 10/2013
Analyst
• Reconcile financial records and statements with General Ledger
• Reconcile bank statements using Flex.
• Prepare Receivables report during month end closings.
• Create Journal Entries during month end closing.
• Create a report of all outstanding receivables at month end.
• Create check requests to reimburse Vendors and Agents.
• Successfully resolve customer disputes resulting from discrepancies with payments, credits or invoices
• Prepare Tax Accrual entries.
• Keep track of Agent Receivables using Trident.
• Use Cognos for creating new reports to reduce task times.
• Run Oracle reports for research.
• Post vendor checks to ReloSpec REO System for record keeping.
• Legal Assistance Fee
• Create an accurate charge upload for 5000+ Agents.
• Lead the team to complete all processes within allocated time.
• Aging Reports
• Reduced Aging report preparation time by 75%
• Created new process to prepare Aging report
Skill set
• SAP BI, SAP BPC 10.0, 7.5,7.0,NW/MS, S,Enterprise Portal Functional Documentation,SAP EPM, WebUI
• Proficient at VB Code
• Expert on CustomUI
• BEx explorer analyzer
• Excel power user
• Bilingual in English and Hindi
• Highly developed interpersonal and presentational skills and excellent oral and written communications skills.
• Extensive experience with Microsoft Word, Excel, PowerPoint and Outlook.
Education
Bachelors in Accounting, Specialization in Finance
University of Massachusetts Dartmouth
Certification
GLD_14612HP10125 - RAMP Certified SAP BPC Consultant – SAP Business Planning and Consolidation 10.0
GLD_14612HP42055 - RAMP Certified SAP BI Consultant - SAP Business Intelligence with SAP BW 7.4 & SAP BI 4.1