Sales Manager

Namrata J

********.***@*****.***

Phone: 949-***-****

Career SummarySAP BPC Solutions Consultant with 7.5 years of total IT experience having in-depth technical, functional and management experience Over 4.5 years of SAP BPC/BW implementation expertise in SAP EPM BPC and SAP BWSuccessfully completed 3 full life cycle implementations, several support and maintenance assignments using SAP Business Planning and ConsolidationsActively pursuing certification with SAP America on Predictive Analytics for Retail - Point of Sale dashboard and Financial Predictive Analytics dashboard for RDS (Rapid Deployment Solution)Demonstrated experience in identifying and addressing client needs. Actively participating and interfacing with clients understanding business requirements, providing resolutions, managing engagements for preparing concise, accurate requirements documents while balancing project economics management with the occurrence of unanticipated issuesMasters in Business Administration with specialization in Finance and Bachelors in Accounting

Skills Profile

SAP BPC 10.0Expertise in SAP BPC NW 10.0 – Planning/Budgeting/Forecasting and ReportingDesigned and configured Sales Revenue and Sales Expense Planning Model and generated P&L Statement, Net Sales Value and Balance SheetHands on experience in SAP BPC NW 10.0 – Consolidations and ReportingDesigned and configured data model for Consolidations, IC Matching, Ownership & Rate ModelsExperience in providing IFRS based Legal Consolidated financial statements for Legal and Managerial Consolidation projects. Hands-On experience in Intercompany Eliminations, Ownership Eliminations, Reconciliations and Currency Translations. Experience using Consolidation Monitor, Controls Monitor & Ownership Manager.

SAP BPCExpertise in BPC using SAP NetWeaver and Microsoft 7.5 platform. In depth knowledge in designing optimized data model using applications, dimensions, properties, script logic, business rules, member formulas and worksheet logic.Successfully implemented Transformation, Mapping, Conversion and Validation of data from different sources Extensively used EvDRE and related functions for designing reports & input schedule.Designed business process flow, work status. Expert in handling rate, hierarchies, process chains, BPC security, audit, work status and BADI. Delivered pre sales BPC demos, solution presentation to senior finance and executive steering committee. Expertise in conducting workshops and interviews to document the blue print

SAP BW Experience in SAP BW 7.3 processes - Data Modeling, Extractions, Data Staging, Loadings, Transformations and ReportingPerformance tuning experience using Aggregates, BW Accelerator, Transports, OSSKnowledge of data extraction process from SAP ECC into BW and BPC

SAP BOBJ Expertise in SAP Business Objects XI 3.1, Universe Designer, WebI and dashboard building through Xcelsius

Client: Hershey’s, PA Feb’12 to Present

Role: SAP BPC Solutions Consultant

ResponsibilitiesFull life cycle implementation of SAP BPC 10.0 NW Planning/Budgeting/Forecasting and Reporting projectScope includes allocation, currency conversions and generating reports such as P&L Statement and Balance SheetWorked with Business users to identify AS-IS and propose TO-BE solutionsExtensively worked with finance and accounting team to gather requirements by conducting white board sessions, creating prototypes, developing functional specifications and analyzing existing forecasting and planning spreadsheetsConducted design phase exit review sessions and presented solution to executive committeeWorked with business to identify hierarchies for GL Account, Cost Center, Profit Center and alternate hierarchiesModels and Dimensions: Creating and maintaining custom models, dimensions, dimension properties, dimension hierarchies for entity, account, product and time. Created MgmtRptg (Management Reporting), Sales Revenue, Sales Expense and Rate models. Reporting model to generate P&L Statement, Net Sales Value reports and included information on Sales Volume, Cost of Goods Sold (COGS) and other expensesData collection: Importing data via flat files and performed transaction data load using Data ManagerData Manager: Using transformation processes (Mapping, Conversion and Validation) to move data into from flat files in to BPC. Modified data manager packages (Dynamic Script) to meet the client requirementScript Logic: Using script logic for calculation and allocation and moving data from one model to another. Activities included scoping, filters, loops, variables, record statement and writing to databaseDesigning and creating allocation logic to simplify allocation process and utilize master data structures and custom allocation processes to allocate dollars across cost objectsCreating Business Process Flows (BPFs) to monitor progress of users, send email notifications, and assure consistency and uniformityWork Status: Using work status for tracking, locking and monitoring the job completion.Working on security set up. Creating task profiles, member access profiles to allow users to perform task and access assigned data.Reports: Developing dynamic report templates, layout, input schedules templates and comment sheets.Organizing data for approximately 50 reports on Revenue, Sales, COGS, OPEX & other expenses for Corporate Power Users.Responsible for Optimization of Models on regular basis.Guided users through best practice approaches to Automate BPC data loads from BW using Data manager packages, Transformation files, Package links

Client: Myron Manufacturing Corp, NJ Jul ‘11 – Jan ‘12

Role: SAP BPC & BOBJ Consultant

ResponsibilitiesFull life cycle implementation of SAP BPC 10.0 NW Consolidation and ReportingProject scope included IC Matching, IC Booking, IC Eliminations, Ownership Elimination using Equity, Proportionate & Full/Purchase Methods, adjustments though Journals & Currency TranslationConducted workshops for blue printing design to carry out Currency Translation and Intercompany eliminations, adjustments and to automate Consolidation project. Worked with Corporate Finance team to gather Consolidations requirements, workshop sessions to capture functional requirements and delivered blue printing design, Hierarchy and Dimensions. Carried out data collection process to identify GL source fields, Rate application data, loaded data into Dimensions, Models from flat file. Configured Business Rules to carry out Account transformation and Balance carry forward.Extensively worked with Finance team during Close to troubleshoot issues in BPC and BW. Performance Tuning of Applications, Concurrent Lock, optimized processes to stabilize BPC environments. Configured Security tasks, teams, member Access profiles. Configured Work status to lock the data during quarter end close; enabled Audits. Developed BPF for Consolidation close process and Forecast for Revenue planners. Delivered P&L, Balance sheet Reports and Input Schedules as per US GAAP, IFRS, and Managerial reports from Finance and Consolidation areas using EVDRE, MDX and SQL. System and Integration Testing, troubleshooting and Admin Configuration

Client: Flextronics International, CA Mar ’10 to Jun ‘11

Role: SAP BPC Consultant

ResponsibilitiesFull life cycle implementation of Integrated Financial Planning of SAP BPC MS 7.5 which helped the client to increase the ability to react to business changes while increasing accuracy and lowering the cost of the planning process. Scope included Allocation, Currency Conversions, Reports and Planning options viz. Spread, Trend and Weight.Worked with Business users to capture reporting and input forms requirements and produced blueprint design specifications. Configured application set, applications, dimensions, loaded dimensions and applications with data from flat file, converted data from external system key figure model into account based data model. Worked with planning team to identify the drivers that influence Sales Revenue and Costs and built them in account dimension in BPC.Configured security using users, teams, tasks and member access profiles. Customized Data Manager Packages, Conversion files, Transformation files, Report Templates, Input Schedules for Adjustments.Configured Business Process Flow to automate Planning process. Configured Work Status as per technical design and worked on migration and cutover activities

Client: Americold, GA Apr ‘09 – Mar ‘10

Role: BPC Support Associate/BW Consultant

ResponsibilitiesAbility to perform hands-on configuration in the BPC 7.5 (MS) modules, including integration points to Finance & ControllingCreated detailed functional specifications for the current project and to accommodate enhancements and maintenance items.Worked closely with other team members to develop new and innovative business applications using BPC and Business Objects solutionsCollaborated with FP&A, Accounting, IT and other business partners on a daily basis. Presented recommendations and solutions to executivesPrepared and maintained BPC process and system documentation and end user training materials.Created reports and provided assistance on month-end, quarter-end and year-end close process Responsible for helping to manage both the BPC Planning application and BPC Consolidations application Evaluate new/enhanced SAP BPC functionality Maintaining dimension members and regular maintenance of the systems Coordination with business users and the IT department to ensure optimal system performance Troubleshoot errors and problems within the financial consolidation system Support end users by providing ad-hoc and classroom trainingProvide day-to-day maintenance and support for BPC Systems (execute clear, load, copy, default formula processes) and users supportDevelop reports and input templates, and update report library based on master data changesWork with other team members to provide validated solutions, user acceptance testing and implementation of BPC system updates and business enhancementsFamiliar with SDLC Project Methodology and SOX requirementsProvided tips on solving problems quickly and effectively; making customer issues a priority.

Client: John Deere Apr ’08 – Mar ‘09

Role: SAP BW Support Associate

ResponsibilitiesRequirements, Blue print, Data Model design, realization, go-live support of CO-PA for BW 7.0Worked on data model, mapping documents, BW objects development including CO-PA data source, Infocubes, Process Chains, BEX Reports and carried out data load from ECC into BW. Developed BEx Queries to reconcile BW data against R/3 as well as with ext. systems

Client: Mphasis (An HP company) Dec ’06 – Mar ’08

Role: Systems Business Analyst, Finance

ResponsibilitiesLiaised with functional unit process owners and users to identify, define and document operational needs and objectives, current operational procedures, problems, input and output requirements, and levels of systems accessIdentified business requirements and developed the ERP Global Blueprint within the areas of Accounting, Finance, General Ledger, Tax, Accounts Payable, Electronic Bank Statement, Financial Reporting, Closing Process, and Profitability Analysis (Cost Based).Comprehended complex business requirements and translating them into a functional system design document under the guidelines of SDLC documentation frameworkCreated models to identify, validate, document and communicate requirements and organize them into a comprehensive and understandable to-be state to ensure that the business stakeholders understand both the requirements and the results of changes to the systemProvided references for users by writing and maintaining user documentation, manuals and reference material; providing help desk support and training usersAnalyzed and evaluated existing business functions and processes related to general accounting, accounts receivable/payable, specially funded, inventory, enterprise accounting, budget planning, formulation, and management, and procurement activities. Trained and documented information and created user manuals and reference materialsConducted and facilitated user trainings and User Acceptance testing.

HDFC Ergo General Insurance Company Mar ‘05 – Nov ‘06

Role: Assistant Manager, Finance

ResponsibilitiesIn depth knowledge of Accounting Standards and Principles and Indian GAAPBalanced and reconciled accounting records, including journals, ledgers, streamlined banking statements, shared services payroll interface and financial reports.Responsible for year-end audit, year- end close out, financial statements preparation and year- end reporting.Monitored all expenses including daily, monthly and quarterly reports. Also, ensured expenditures are charged to correct department ID, subprogram and program.Responsible for accounting/finance records retention.Recorded all accounts receivable entries and payments into official accounting records and internal records.Daily reconciliation of bank ledger with accounting activitiesWork with executive staff to drive implementation of monthly close and reporting processWork with executive staff to drive annual audit processComplete month-end close tasks ensuring strict adherence to the closing schedule.Assist in preparation of consolidated financial statements.Manage variance analysis, reconciliations, and other month end activities.Manage accounting staff to ensure work- loads are properly allocated and completed in a timely manner.Develop management reports for the regional and corporate to support decision making.Ensure Sarbanes Oxley (SOX) compliance tasks are followed and complete periodic compliance reviews.

Contact this candidate