SUMMARY

• 21+ years of overall experience including 10 years as SAP FI - CO consultant in implementation, Rollout & conversion projects, Customization, Configuring and CO Reporting in SAP R/3, ECC 6.0 and S4 HANA Central Finance. Excellent working experience in testing, documenting, user training, support and COPA allocations and BI reporting encompassing different work environments and in diverse industries like Oil & Gas, Banking, IT Hardware & Manufacturing.
• Experience in E2E Implementation covering Blue Printing, Fit-Gap Analysis, facilitate Design, functional specifications, preparation of test cases, training documents, Unit Testing, UAT, Cutover, Hypercare and production support projects for Fortune 500 MNC.
• Finance Experience - GL, Accounts Payable, Accounts Receivable, Credit Management and Bank.
• Controlling Experience - Business Allocations, Profitability Analysis, Segment-wise reporting, Cost & Profit Center Accounting.
• Worked on a very large data conversion & migration project for Capex & Opex items.
• Proficient in interacting with Solution Architects & ABAP developers for finalizing right IT solutions and translating Business requirements into technical & functional specifications for custom developments, Enhancements, BAPI, Process automations and Business & Operational performance reports.
• Worked on RICEF objects including design of complex reports and Enhancements. Drafted functional specifications providing table logic and detailed design for reports and coordinated with technical team for development of Objects.
• E2E Testing experience including framing Test strategy, unit testing, user acceptance testing, regression & integration testing (worked on HP-QC ALM 12.55)
• Worked with diverse teams across different time zones, Offshore-Onshore model with customer 1st mindset and strong team player.
• Project management experience including managing timelines, resources, prioritizing activities, monitoring milestones, Gantt chart analysis, PoAP, reworking project to changing project scope, timelines and resource availability, managing team issue logs &, Conducting Blueprint Workshops.
• Certified SCRUM Master with working experience in both AGILE & Waterfall ways of working.

TECHNICAL SKILLS

ERP System: SAP ECC 6.0, MFG Pro

S/4 HANA: Finance (1511 and 1809)

SAP FI Modules: General Ledger/New General Ledger/ Special Purpose Ledger, AP, AR, Asset Accounting

Controlling: Cost Element/Cost Center Accounting, Profit Center Accounting and Profitability Analysis (CO-PA) Business Allocations, Internal Reporting.

BI Reporting Tools: Power BI, Dashboard Designer

Project Management/Agile: MS VSTS

Applications: MS Word, PowerPoint, Excel

Others: HP QC(Testing), HP Service Now(Transportation requests), Balsamiq (Mock-up creation) Sharepoint 2013 (Security administration) Alteryx (Data blending)

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA - FICO Consultant

Responsibilities:

• Review & capture existing reporting, gather functional/reporting requirements and analyse the same.
• Translate requirements to technical & functional components that would be used for developing reports.
• Manage the DHT and ensure data accuracy in it.
• Review Chart of Accounts to identify obsolete GL accounts for clean-up.
• Ensure timely availability of COPA files and other input data for allocations and validate the same for data accuracy.
• Prepare training manual for adjustment entries and its impact extension ledgers and consolidation reports.
• As SCRUM master responsible for preparation of Sprints, Backlog planning/refinement, Daily SCRUM calls & Sprint retrospective.

Confidential

Responsibilities:

• As part of the Blueprint team, was fully responsible for requirement gathering & analysis. Conducted interviews with process owners and facilitated workshops with stakeholders to gather requirements and analysed the same to identify gaps.
• Jointly with Project Manager created the Business Requirement Document for discussions with Decision Review Board to obtain sign-off.
• Translate the Business requirements to technical & functional components that was used for developing reports.
• Adherence to Cost Data rules for master data.
• Performed ETL to convert and migrate data from legacy.
• Finalized penalties and additional costs for small and urgent orders with Lubes team and worked with technical team to automatically remove discounts for such orders.
• Configuring Ledgers (both leading & non-leading) and extending the Chart of Accounts to participating LE’s.
• Worked jointly to set up Ledgers, Extension Ledgers & Currencies
• Validation of Master data upload to ensure adherence to Cost Data rules and to align with US GAAP.
• Activation of Material ledger
• Set up of Asset accounting, validating master data and working with team to migrate transactional data.
• Worked with BI development & technical team to develop customized Management reporting on Business Process Management, P&L and Gross Margin Analysis.
• As SCRUM Master was responsible for preparation of Sprints, Backlog planning/refinement, Daily SCRUM calls & Sprint retrospective.
• Prepared cutover strategy and supported cut-over activities.
• Responsible for E2E Testing - Co-ordinate Regression & Integration testing, Perform Quality testing, Creation of UAT test scripts, maintain testing docs in HPQC, facilitate UAT, ownership of defects log, defect fixing and obtaining sign-off.
• Review and approve transportation requests between different environments via HP Service Now
• Documentation and End-user training.
• Monitor Hypercare and ensure seamless handover to support team.

Confidential

Responsibilities:

• As a key member of the implementation team with expertise on both legacy system and SAP, worked closely with designing the solution.
• Jointly worked with configuration team to configure Enterprise structure, basic settings for company code (Fiscal year variant, Posting Period Variant, Document types & number ranges, Document Field Status Variants, Tolerances).
• Adopt the design of Chart Of Accounts, Company Codes, GL Accounts, Profit Centers, Cost Centers and its hierarchies.
• New GL environment for 1 OU - Segment reporting, Profit Center Accounting and Intercompany processes and Interfaces
• Responsible for Transactional data migration from legacy system (Capex Bay tool) including data conversion and ETL.
• Verified the business-critical table record counts and all financial and controlling reports as part of several mocks and validated by business sign off.
• Configure, test and implement various approval workflows for audit compliance.
• Evaluate functionality changes/enhancements in upgrades and work with technical & infrastructure to manage roll-outs.
• Prepare, test and troubleshoot, validate implementation setups and review customer reports post migration.
• Owned the UAT testing and Business sign-off.
• Owner of Data Harmonization Tool post migration.
• Responsible for timely resolving of defects & maintaining defect log.
• Prepared Cutover Strategy and worked with Data migration team for master data and transactional data loads in Finance, AP, AR and Fixed Assets, Planning data.
• Part of Hypercare team and hand-held support team for post-production support for 3 months.
• As part of Blueprinting, conducted workshop with LoB process owners and Finance reporting team to gather requirements and current gaps.
• Worked closely with implementation partners to test interfaces and external sources of data from LATAM flows seamlessly and documented the data and work flow.
• Worked with Cost Data Rules team to ensure Chart of Accounts terminology adheres to reporting standards.
• Worked with Report development team and segment heads to ensure there is standardization of reports.
• Co-ordinated with Basis consultants for performance monitoring
• Facilitated with OU Accountants and Master data team for unwanted GL accounts blocking & clean up.
• Performed unit testing, System integration testing and coordinated user acceptance testing covering FA, AP, CO - Segment Financials and COPA submodules. Used HPQC for test scripts creation, results & defect logs.
• Performed parallel reporting of Group reporting for 2 months in both Legacy and S4 HANA, identified gaps and worked with respective teams to resolve issues.
• Transportation request management via HP Service Now
• End user training for forecast data loads in SAP BPC
• Managed cut-over activities
• Part of the Hyper-care team and production support for 1 month before seamless handover to 3rd party vendor.
• As part of requirement gatherings, conducted interviews & workshops with OU Accounts team, frequent travelers (to understand user experience) and Concur development teams.
• Created the Business Process and Interface workflow documents and nice to have features as preferred by end-users.
• Worked with third party vendors in building inbound/outbound interfaces and support model for 3 years.
• Worked with technical team to create automated flow of travel expenses into various SAP cubes & allocation to cost centers when required
• Performed Unit testing and created UAT scripts in HPQC.
• Identified a large and diverse tester base for a robust testing on all devices (Desktop, Tab & Mobile)
• End-user training and seamless handover to support team.

Confidential

Upgrade & Production support

Responsibilities:

• Work with vendors to monitor progress of L1 tickets, escalate when needed and iron out issues for timely closure.
• Responsible for Period close and periodical reconciliation of A/P and A/R Subledgers.
• Support Quarter close & Year end activities
• S4 Consultant for troubleshooting day to day issues.
• Investigate issues causing blocks in Payables/Receivables & identify the root cause.
• Manage changes in Credit limits and credit control
• Support Business users for issues in submitting Plan and Latest Estimation into SAP BPC.
• Responsible for reconciliation of plan/LE submitted numbers in BPC.
• Evaluate functionality changes/enhancements in upgrades and work with technical & infrastructure to manage roll-outs.
• Assist Release Management teams and hierarchy changes from time to time.
• Responsible for Data Rules & final reviewer of Migrations to different environments.
• Maintenance of monthly exchange rates.
• Analyzed and identified the old differences in Profit center & Cost centers and worked with respective teams to correct entries and/or write off.
• Full owner of Downstream Business Allocation Tool that allocates common costs every month for various plants, refineries & businesses.
• Monitor Control M for any failures and timely escalation for resolution of issues
• Responsible for data accuracy & timely availability of COPA files post Business allocations
• Worked with technical team for enhancements: Payment notifications, Account statements, dunning letters, open item list and Balance confirmations
• Support Release management in testing including creating test scripts, performing integration and regression tests for every release in QC.
• Assist end-users in timely submission of Plans & rolling forecast numbers in SAP BPC and resolve any issues
• Worked with third party vendors and end users to reduce the number of IT tickets by training end users on troubleshooting issues.
• Review and approve all transportation requests for the LoB via HP Service Now.
• Suggest process improvements and provided necessary training to end users.
• Responsible for gathering requirements and writing the Functional design specifications along with tables details and logic for custom developments and enhancements and co-ordinate with developers.
• Support Transportation requests between various environments
• Raise IT tickets and follow up with respective support desk for restoration of failed applications.
• Train local teams in creating Test-scripts.
• Functional Site Owner (SharePoint) of web-pages that maintains MI report related communications
• Follow approved approvals & processes to make changes in allocations
• Facilitate Testing window and co-ordinate User Acceptance Test for Change requests.
• Work with Integration teams & Vendors to fix downstream issues.
• Responsible for year-end finance Big Bang process.

Confidential

Responsibilities:

• Responsible for requirement gathering and analysis including scheduling interviews and conducting workshops to finalize requirements.
• Preparation of Functional Specifications and Business Requirement Document.
• Work with Solution architect & Designers to brainstorm and finalize solution and data model.
• Finalize KPI’s & its definitions, create epics and user stories.
• Creation of Sprints, sprint review and sprint retrospective, maintain project progress status in Microsoft VSTS.
• Co-ordinate with IT teams comprising technical team and front-end developers to ensure output meets the business requirements.
• As Scrum master, chair daily stand-up calls.
• Work with Security teams to arrive at role-based access & Interface teams to ensure all interfaces for external data source is robust.
• Responsible for test scripts creation, defect management & maintaining testing documentation in HPQC
• Perform Unit testing and facilitate UAT.
• Documentation and End-user training.
• Managed Hypercare support for 2 cycles & facilitate d seamless handover to support team

CR Enhancement

Responsibilities:

• Review & capture existing reporting, gather functional/reporting requirements and analyse the same.
• Review and capture technical design requirements for integration and reporting to build the technical components of the system.
• Standardization of existing legacy reporting (240 reports) into 9 reports and showcase proposed solution to obtain sign-off from VP.
• Implement Segment Security rules to enhance and protect data access within SAP for managed user access to sensitive data.
• Oversee development, testing and deployment of C5 analysis reports using Dashboard designer.
• Work with IT teams to build an automated interface of COPA files into LUBES cubes.
• Work with SAP through SR to troubleshoot software and database level issues in FI modules.
• As Project Manager responsible for timely delivery within agreed budgets.
• Training end users on best practice to post entries.
• Facilitate UAT testing & Sign-off.
• Handled enhancements and changes.

Confidential

CR Enhancement

Responsibilities:

• Reviewed Business processes in ECC 6.0 and identified list of standard processes and transactions to be tested from the functionally.
• Identified and prepared the list of all Z transaction codes and custom developments, forms, interfaces, Enhancements to be tested.
• Performed Business process testing in FI/CO and fixed assets modules for version 6.0.
• Configuration of reconciliation accounts and alternative reconciliation accounts.
• Create and assign of Vendor and customer reconciliation accounts
• Configuration of number ranges.
• Setting up of House banks
• Extend profit Center and Cost center settings to be consistent with other OU’s
• Extend chart of depreciation, Asset classes and depreciation areas depreciation methods and depreciation keys to make it consistent with global best practices.
• Configured Cost Center Accounting, Profit Center Accounting.
• Configuration of COPA and Downstream Business allocation files
• Drafted functional specifications and for reports and interfaces and worked with developers for development of Objects.
• Worked on Dunning Letters with printing & Email options.
• Worked with BI team on providing R/3 tables for developing FI reports like ageing reports, DSO etc.
• Preparation of UAT scripts, documentation of results, manage defect log and closure of defects.
• Extensively worked on RICEF objects, providing the field mappings of data base tables, design of various complex reports, interfaces, data loads Enhancements and conversion objects for the rollout projects of Genentech.
• Worked on accounts receivables, Down Payments, Payment terms, Correspondence, Foreign currency valuation issues
• User training on AP & AR entries
• Worked on production issues in Accounts payable - Automatic payment program and payment files.

Confidential

Business Analyst & Projects Co-ordinator

Responsibilities:

• Owned the PoAP for Global Commercial business
• Gather initial high-level requirements and prepare charter
• Assign BA’s from the team for different projects
• Sole interface between GC Business and different IT teams like Solution Architect, Designer, Developers, Compliance, Integration, Security, Support teams and third-party vendors.
• Periodical update on various projects to process head
• Review progress of projects with IT teams
• Facilitate and chair calls between Business and IT teams to overcome issues and smoothen project progress
• Validating design/solutions developed by IT teams/Third Party BW Data Architects to ensure they meet the agreed Business and performance requirements
• Super User for SAP BW
• Facilitated Robotics Process Automation (RPA) of daily reporting using NICE tool.
• Explore continuous improvement of Processes and automating MI reporting that includes identifying, facilitating and executing GB & LEAN projects thereby saving FTE.
• Coach and Mentor 10-member team: Ensure timely and right delivery, review meetings, assist career management, performance discussions & handle underperformers.
• Support the Learning & Development team by facilitating Trainings on behavioural & soft skills and Resilience sessions.
• Developed a Learning Portal for Shell Oil & Gas Downstream Business in SharePoint 2013 with exposure to an audience of 600 FTE’s.
• Sharepoint 2013 administrator: Functional Site Owner (FSO) for internal site with exposure 5500 FTE’s and contractors.
• Designed Visual Management for team and facilitated monthly tracking.
• Information Systems used: SAP BI4, SAP BPC, Dashboard Designer, LUMIRA, Alteryx, Sharepoint 2013, Excel Financial Modelling.

Confidential

Assistant Manager

Responsibilities:

• Successfully transitioned the Risk & Regulatory reporting support activities from Confidential NA & attained BAU status in less than a year.
• Automated the Preparation & submission for onward filing of Daily Estimated Net Capital with NYSE.
• Risk weighting of Assets & Calculation of RWA charges on Off Balance sheet & On Balance Sheet Trades as per Basel I norms for Confidential USA Inc.
• Set up interface between Hyperion 9.0 and legacy systems to source data for Preparation of Bank of England Country Exposure & FFIEC 009 returns for filing with FRB for 7 entities of Confidential North American Region.
• Developed various reports for Balance sheet reconciliation using Hyperion Essbase
• Developed several product-wise profitability reports using COGNOS.
• Perform ETL of Credit Default Rate (CDR) data from legacy system into Oracle Financials.
• Created an automated reconciliation between Sub/General ledger of Derivative products.
• Plan off-shore Migrations by preparing training plans & co-ordinate travel plans in consultation with Business Partners.
• Initiated & Mentored LEAN projects to automate routine daily reports resulting in substantial savings of FTE
• Monthly Dashboard calls with Business Partners to understand requirements/improvements & action plans to meet the same.

Confidential

Senior Finance Analyst - Finance Planning & Analysis

Responsibilities:

• Quarterly Forecast & monthly outlook.
• Monitoring & reporting performance against budgets & variance analysis.
• Monthly Analysis of Headcount, Capex & discretionary spends.
• Provide monthly margin, revenue assurance and cost management.
• Contribute to team metrics & SLA deliverables by achieving stated productivity & accuracy goals on continuous basis.
• Handle finance queries & act as Finance interface for PG group.
• Maintenance of Baseline & incremental depreciation register.
• Approvals for Discretionary spend, Capex & Employee expenses.
• Weekly dashboards on Opex spend to ensure optimum usage of budgets.
• Drive cost efficiency by conducting regular trainings to budget holders and users.

Confidential

Executive/ Assistant Manager

Responsibilities:

• Was part of the Operations team to prepare Project Charter.
• As part of Blue-printing, gathered requirements for all stake holders, conducted a detailed study of existing legacy systems and performed a fit-gap analysis.
• Compiled a list of required customizations and customized reports.
• Worked with implementation partners in configuring General ledger, Sub-ledgers and Costing components.
• Configured and set up the whole Credit Management process including credit limits and credit lock & controls.
• Automated month-end accruals journals process
• Worked with development team to customize Business-wise Financials and consolidation for annual reporting and for various MIS reports to be used by Operations team.
• Developed unapplied payment matching process for Accounts receivables.
• Built Inter-company business process encompassing Inter-company invoicing, payments/collections, balances, netting off and reconciliation.
• Worked with Deutsche bank to implement an automated payment & direct debit process
• Set up the stock matching process to match physical and system stock every quarter.
• End user training for logistics to updating cost-roll ups for changes in product formulas.
• User training for Accounts team
• Created cutover strategy and assisted implementation partners in cutover activities.
• Post go-live support on AP, AR, Costing & Plan submission issues.