Management Sap
Resume:
NAVENDU TRIPATHI
**** - *** ********* ******, ***********, ON L5B 4B1 CANADA Tel: +1-416-***-**** Email: *******@*****.***
EXECUTIVE SUMMARY:
• 12+ years work experience with 4+ years of strong SAP FICO and SAP BPC Solutions Consultant experience with
two full cycle implementation in experience with ASAP methodology including Business Process Re-engineering,
feasibility analysis, configuration, testing and integration of FI/CO with SD and MM, and SAP BPC/BW
implementation
• Experienced in SAP BPC 7.5 and 10.0 Net Weaver and Microsoft versions in planning and consolidation
• FICO (4.6 and ECC6)
Strong FI expertise in General Ledger FI-GL, Accounts Payable FI-AP, and Accounts Receivable FI-AR and Asset
Management
Worked on ECC 6.0 New GL Functionality and Document splitting
• SAP BPC 10.0
Hands on experience in SAP BPC NetWeaver 10.0 – Prototyped Consolidation and Planning Applications,
familiar with Consolidation Central, Controls Monitor & Ownership Manager
Proto typed Ownership Elimination to calculate Ownership and minority interest, familiar with Consolidation
methods, Consolidation Rate and Financial Interest rate calculation
Extensively worked with Finance users to design and automate Revenue, Spend, Expense Planning,
Forecasting and Budgeting applications in BPC
• Extensive Project experience in configuring and implementing
• Strong knowledge preparation of training manuals, for end user training.
• Profound knowledge on SAP Data Management, data governance, data quality, database integration, data model,
data extraction, data services, data dictionary
• Designed, architected and developed predictive analytics dashboards (Sales Predictive Analytics, Financial
Predictive Analytics and Scenario Based Liquidity and Cash Management Planning) using leading practices and
design principals
• Involved with the system conversion ACCPAC to SAP
• Extensive experience in IFRS and SOX
• Complete knowledge of the principles, practices, procedures of accounting and financial records, and
transactions
• Strong ability to motivate teams to produce quality materials within tight timeframes and simultaneously manage
several projects
• Strong interpersonal skills and business analysis skills
• Highly organized with an eye for details and extra superior time management skills
• Motivated by goal-oriented and customer-focused working environments
TECHNICAL SKILLS:
• Business/Reporting Skills: Crystal Reports, Hyperion, Creation of Reporting Tools, MIS Tools, Metrics, SAP Business
Objects Dashboards (Xcelsius) and Scorecards
• Functional Skills: SAP-FICO R/3 Versions (4.6) & ECC 6.0 and SAP BPC 7.5 and 10.0
• Software Suites: MS-Project, MS-Visio, MS-Excel, MS-Access, MS-PowerPoint, and SQL MS- Dynamics,
Hyperion Planning, Hyperion Essbase, ACCPAC and JD Edwards ERP system
• Data manipulation skill: Linking, pivot tables, lookups, formulas, filtering, macros and SQL
• Technical Skills: SDLC, Database Modeling, Web, Internet, Process Modeling, Programming
Concepts
EXPERIENCE:
SAP-BPC Application Consultant (Oct-2011 – Till Date)
Performance Analytics Corporation, Ontario, Canada
Performance Analytics is a technology and services company focused on delivering Enterprise Performance Management
solutions for financial and operational reporting.
Responsibilities:
• Worked with Business users in identifying current “ AS-IS” process and then provided a “TO-BE” solution.
Page 1 of 5
NAVENDU TRIPATHI
1814 - 135 Hillcrest Avenue, Mississauga, ON L5B 4B1 CANADA Tel: +1-416-***-**** Email: *******@*****.***
• Extensively worked with Finance and accounting team to gather Requirements, white board sessions, carried out
Proto types, developed Functional specifications and analyzed existing forecasting, Planning spread sheets.
• Extensively worked with Finance team during Close to troubleshoot issues in BPC and BW.
• Delivered Cash flow, P&L, Balance sheet Reports and Input Schedules as per US GAAP, IFRS, and Managerial
reports from Finance and Consolidation areas using EPM, MDX and SQL.
• Built environment and training materials for on boarding of new users post go-live
• Dimension management such as creation, maintenance and members additions and deletions. Model management
such as creation, maintenance, addition of model.
• Currency translation functionality maintenance with required Dimensions, properties, model, script logic, business
rules and process chain maintenance.
• Creation of BPC Audit reports, comments and transport.
• Creation of journal template and journal entries.
• Configured Work status to lock the data during quarter end close; enabled Audits. Developed BPF for Consolidation
close process and Forecast for Revenue planners.
• Achieved fastest Quarter-end close by tuning the Process Chains to load data from ECC to BW and then to BPC.
• Developed and delivered administrator, end-user training and UAT
ILC Telecom, Ontario, Canada (Apr 2004 – Sep 2011)
Senior Business Analyst (Jul 2009 – Sep 2011)
Responsibilities:
In-house project involving customization of SAP ECC 6.0 and BPC 7.5 (Later 10.0) implementation across all enterprises
in US/Canada. I was involved in analyzing the requirements of company and configuration in Financial, Controlling
modules and BPC Solutions Architect.
The project was structured in two phases:
- Phase I involved detailed mapping of the existing business processes, design of the 'To Be' processes and defining a
detailed project scope.
- Phase II involved configuration and testing of the processes designed in Phase I.
During these two phases, worked on following areas for BPC and FI/CO modules:
• Process Design: 'As is process' mapping for extensive mapping of the existing financial business process. Details of
FI processes were captured for the company and were classified in business area.
• Gap analysis: Gaps were identified between SAP standard processes and desired process scenarios and process
changes and/or workarounds were suggested.
• Finalization of the To Be processes: The To Be processes were finalized and validated.
• Structure Organization: Designed the SAP FI/CO organization structure. It had to be designed taking into
consideration statutory reporting requirements for multiple legal entities through which company operates,
organizational control requirements which required reporting across legal entities and future plans for spinning off of
business lines.
• Chart of Accounts: Helped the company to rationalize their chart of accounts by mapping existing accounts to the
company Global Chart of Accounts supplied for the implementation. Also, additional accounts had to be added to
provide for dual reporting.
• Functional Requirements Specifications (FRS): Complete FRS procured and documented, mapped, and verified
against existing User Requirements Specifications (URS) documents.
• Creating organization structure -- Financial Accounting (FI) Enterprise Structure: Configuration and customizing
Company code, Creating GL account codes and Chart of Accounts, Configuration of Global settings, Configuration of
GL automatic clearing, Configuration of Foreign currency valuation, HST/PST/GST.
• New General Ledger: Activation of New GL Accounting, Defining ledger for GL Accounting, Integrating the GL with
subcomponents, Document splitting, Segmentation and Parallel Accounting, Controlling Component Transfer
postings, Integration with Asset accounting.
• Closing and Reporting: Run and reconcile all incoming interface, start control and clearing reconciliation, run
customer billing and vendor payments, approval of all parked documents, Run final sales figure and dunning reports,
Page 2 of 5
NAVENDU TRIPATHI
1814 - 135 Hillcrest Avenue, Mississauga, ON L5B 4B1 CANADA Tel: +1-416-***-**** Email: *******@*****.***
Open new period,close old sales and material periods, Run all settlements in CO, Creating management accounting
reports with Report painter.
• Testing and scripts: Conducted testing and preparing scripts for these tests, analyzed the results and re-configured
the settings wherever necessary.
• Training: Prepared training material and gave end user training to the process owners in GL, AR, AP and CO as well
as to Core Team Members and also maintained detailed documentation.
• Support: Provided Post Go Line Support to users, helped users in solving their problems in live environment and
reconfigured settings wherever requirement changes.
SAP BPC:
• Completed BPC data model architecture to automate Revenue, Spend, Finance and Head Count Planning from
SAP ECC
• Solution Blue printing design to carry out Currency Translation and Intercompany eliminations, adjustments and
to automate Consolidation project
• Extensively worked with Finance team during Close to troubleshoot issues in BPC and BW
• Worked with business to identify hierarchies for GL Account, Cost Center, Profit Center and alternate Hierarchies,
implemented conversion, transformation files and loaded into BPC
• In BPC Consolidation, carried out multiple level eliminations using IC Elimination and carry out the adjustments to
produce the IFRS Reports
• Achieved fastest Quarter-end close by tuning the Process Chains to load data from ECC to BW and then to BPC
• Configured Business Rules and Script Logic to carry out Currency Translation
• Based on the Business Requirements developed Consolidated Balance Sheet, Consolidated Cash flow,
Consolidated Income statement and Trail balance reports out of BPC
• Customized FI-GL BW Extractors to load actual data for Planning and Consolidation into BPC
• 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 Cash flow, P&L, Balance sheet Reports and Input Schedules as per US GAAP, IFRS, and Managerial
reports from Finance and Consolidation areas using EPM, MDX and SQL
• Carried out data collection process to identify GL source fields, Rate application data, loaded data into Dimensions,
Applications from ECC, Flat file and Hyperion system
• Configured Business Rules to carry out Account transformation and Balance carry forward
Conversions:
• Loads of the G/L balances, budgets, SKF, Asset, customer and vendors, AR invoices
• Reconciliation of the sub-ledgers (Asset, AR), data consistency verification
• Provided SAP FI/CO tuning and troubleshooting including the identification and resolution of performance related
issues
• Strictly followed SOX rules for the Support Phase
• Provided extensive support to the business users regarding business issues arising out of SAP FICO
• Configured the Automatic Payment Program for A/P including Partial Payment.
• Export Data to Excel for Further Analysis /Support Documentation Storage
• Dunning Letters for Faxing or Email /Management Reports
Senior Finance Analyst (Internal Control) (Apr 2004 – Jun 2009)
Responsibilities:
• Directed financial management functions including development of monthly/quarterly financial statements, financial
forecasts, budgets, payroll, billing, and collections
• Reviewed documents and records to ensure the adequacy of internal controls (Sarbanes-Oxley Act) and
compliance with company policies and procedures
• Directed financial audits and provided recommendations for procedural improvements.
• Experience on IFRS implementation projects
• Produced and reconciled various reports to meet GAAP and statutory requirements
• Developed financial models, including long-term forecasts for accounts payable, sales forecasts, capital
expenditure forecasts, key measurement ratios and graphs
Page 3 of 5
NAVENDU TRIPATHI
1814 - 135 Hillcrest Avenue, Mississauga, ON L5B 4B1 CANADA Tel: +1-416-***-**** Email: *******@*****.***
• Developed and trained highly skilled accounting and financial management team to achieve established objectives.
• Administered all financial management systems, evaluated and integrated new applications
• Provided the Department Heads with their monthly expense performance vs. Budget
• Analyzed variances in monthly and quarterly costing reports
• Maintained weekly cash flow management and reporting activities
• Directed and coordinated the proper and timely recording of all financial transactions, month-end closings of
financial statements and legal entity on a monthly basis with exception reporting
• Managed accounting function and systems (including GL, AR, AP, Fixed Assets) to maximize efficiency, including
distributing monthly revenue and expenditure to the departments
• Managed the preparation of the official annual report of actual revenues, transfers, and expenses
Achievements:
• Successfully represented deposit in negotiation with customers, gaining 625k
• Strategically restructured financial reporting processes in accordance with organizational changes
• Introduced advance shipments and saved courier/shipments charges by 85%
• Reduced overheads by 28% over 3 years
• Recruited and trained 2 accountants to join the team
• Reduced days receivable from 30 to 21 days; 21 to 14 days and 14 to 7 days
Senior Finance Analyst (2000 – 2004)
AVIS Rent A Car, UAE
The multinational premier car rental and leasing company. Avis has diversified activities which include car rental, long term
and short term leasing, bus transportation, limousine services and other ground transportation services and a work force
of 1200+ employees.
Responsibilities:
• Analyzed financial information (e.g. financial statements, financial ratios, interest payments, etc.)
• Performed and directed audit engagements on various types of operational, financial, and risk audits
• Performed internal quality audits to ensure that assigned locations are in compliance with corporate documented
procedures as they relate to the ISO-9001 standard
• Coordinated with internal and external auditors
• Worked with the Department Heads to prepare their detailed annual budget
• Created budgets and forecasts for the management group
• Monthly, quarterly and annually sales forecasting
• Prepared monthly executive presentation that highlighted the key drivers of expense variances vs. the budget, prior
forecast and prior months
• Operated expense analysis of finance, HR and control centers
• Analyzed gross margin and studied feasibility for high value orders
• Reconciled year-end journal entries up to finalization and calculation of amortization
• Analyzed monthly P&L of seven business regions against budgets and reported to regional business managers
• Database Management System to create MIS – providing assistance for Y2K testing
• Coordinated monthly payroll functions for 1200+ employees
• Ensured compliance with accounting deadlines
Achievements:
• Received “Best employee of the year” award
• Implemented paperless invoices via web based imaging system; resulting in 85% decrease in offsite storage costs,
25% increase in processing volume
• Reduced printing, distribution, and paper costs by introducing intranet between all 64 offices in UAE
• Gained reputation as an IT guru, handled 65% of IT network troubleshooting and general IT support work, saved
thousands of dirham on external IT consultation services
Page 4 of 5
NAVENDU TRIPATHI
1814 - 135 Hillcrest Avenue, Mississauga, ON L5B 4B1 CANADA Tel: +1-416-***-**** Email: *******@*****.***
EDUCATION:
• Pursuing CPA
• Masters of Commerce (M.Com)
• SAP BPC 7.5 and 10.0, Clone Skills Inc. USA
• SAP FICO, Version 4.6C and ECC 6 SAP FI course, IIBS Canada
• Diploma in Oracle
• Diploma in Computer Programming & Application
Page 5 of 5
Contact this candidate