SUMMARY:

• Close to Nineteen (19) years of Finance & IT experience that includes over five (5) years in SAP BPC functional, Five (5) years in SAP FI/CO and over nine (9) years in business and finance. Pursuing in BPC 10.0 Software Development. Have been involved in three (3) full life cycle implementations, one (1) upgrade and two (2) implementations in SAP BPC NW EPM having solid experience in Planning, Forecasting and Budgeting. Two (2) full life cycle implementations in SAP FI/CO functional and worked extensively in FI/CO and integrations with SD, MM, PS modules and SAP BPC NW. Worked for the clients/industries in the pharmaceuticals, chemicals, telecom and, manufacturing industries.
• Created Customer Specific Environment and Required Models as well as other Models
• Created Multiple Reports and Input Schedules using EPM 10 Excel Add - in and worked on SAP EPM Reporting and Input forms on Rolling forecasts and budgets
• Designed and developed EPM solutions for Financial, Headcount, CAPEX planning
• Defined and configured Dimensions, Dimension Members and their properties along with Creation of member access profile, Task profile creation, Team creation and Full integration
• Experience with Inter-Company Eliminations, Currency Translation, Balance Carry Forward and Business Process Flow to provide consistent and standardized application
• Writing functional requirements and associated test cases. Designed and implemented applications for Planning, Reporting, and Budgeting including application set creation and dimension build.
• Worked with onsite/ Offshore teams, assign tasks, follow-up, monitor status of task.
• Worked in Full life cycle implementations, Rollouts, Support and Upgrade projects.
• Extensive experience in configuration and testing of FI/CO modules -GL, AR, AP, Fixed Assets, Treasury.
• Integration of FI with MM and SD with Procure to Pay and Order to cash Cycles
• Through understanding of SAP system from business process, cross functional and integration viewpoints.
• In-depth knowledge in configuration, implementation, ASAP methodology, system design and development and gathering user requirements
• Cost Center Accounting Configuration, setting of controlling area, cost elements, cost centers, valuation profiles, field status groups, internal orders, WBS elements
• Profit center accounting configuration, setup, Profit center hierarchies, Product Costing, Profitability analysis, Profit center-based Balance sheets & P&L statements
• Special emphasis on Data Migration specifications with BDC, Legacy System Migration workbench (LSMW) for data uploads for various SAP Projects
• Excellent in working with posting validations, substitution rules, forms, interfaces (ALE & EDI), user-exits, and reporting tools
• Active member in conducting the team meetings, Customer feedback meetings & self-assimilation programs.
• Knowledge in identifying, testing and documenting of SAP application controls in compliance with Sarbanes Oxley Act (SOX).
• Reported to Director of Finance, handled 6 branches accounting processes and preparation of balance sheet reconciliations and journal entries.
• Managed team of 5 members in Finance operations and responsible for Payroll, Billing, Account Payable, Accounts Receivable, General Ledger and Journal Entries.
• Brought on to strategically restructured financial reporting process in accordance with organizational changes. Served as a key member in the introduction, installation, and integration of new financial reporting system in the organisation.
• Lead and manage a team of professionals, including selection/hiring, objective setting, performance management, coaching/development and .
• Successful in meeting new challenges and finding solutions to meet the needs of the customer.

TECHNICAL SKILLS:

SAP Systems: SAP R/3 4.6C, 4.7, ECC 5.0, ECC 6.0, BPC 10.0

Operating Systems: Win NT, Windows 2000, & 2003, Linux

Accounting Packages: ApplicationsOther ApplicationsQuick Books, Wings, Tally, MYOB, Prologic & FidelioMicrosoft Office 2007, 2010, 2013 & 2016, MS-VisioClarity, XM, Smart Stream, Salesforce, SharePoint, JIRA

PROFESSIONAL SUMMARY:

SAP Consultant (Data Validation/Testing)

Confidential - TX

Responsibilities:

• Analyze business requirements for the development of multiline data validation quality checks.
• Extract information from Source systems and validate with DSOs and Models.
• Creation and execution of detailed test plans to validate data against functional and quality assurance requirements.
• Assist development team for fixing the defects through the creation of case studies and detailed test plans to validate the data.
• Build and maintain proper documentation, produces and guidelines.
• Establish data quality processes and compliance with master data standards.
• Troubleshoot issues with data quality as identified by customers.
• Collaborate with business process owners to get an understanding of current processes and systems that has a direct impact on the quality of the data.
• Work with stakeholders and the technical team to establish and manage match/merge that identify duplicate data across data sources and align required action such survivorship and trust rules in accordance with the organization’s data governance procedures.
• Work with Consolidation team to setup Master Data and hierarchies.
• Validation and testing Financial Reports, Management Reports and Input Packages.

SAP BPC Consultant

Confidential - WI

Responsibilities:

• Configure Environments, Models, Dimensions, Business Rules.
• Configure Master Data - Cost center, Account hierarchies.
• Configure currency translations - Rate of exchange upload, Rate Types and dimensions.
• Interco Elimination journal entries in consolidation system and investment in subsidiaries
• Setup Consolidation Business Rules, US Eliminations and Journal Entries posting.
• Worked on Transformation and conversion file and loaded data to BPC.
• Validated transaction data in BPC with finance teams and fixed issues.
• Worked on Dimension to modify property for reporting purpose.
• Utilize Hyperion Planning and Financial and reports to facilitate Consolidation Reporting processes.
• Created and Maintained Input Templates and Report Templates in 10.1using EPM Editor & dynamic formatting as per user requirement for their consolidation process.
• Develop Actual and Consolidation Reports in BPC from Hyperion Retrieves.
• Created BPC Reports and Input Forms using EPM Add-In and using EPMFunctions.
• Worked on month end closing consolidation Reports, created Income Statement and Balance Sheet Reports and Yield Report.
• Creating Functional and Technical specification for Report and BPC Admin.
• Worked in Data loads for all the historical data and validation with source systems.
• Created and Maintained Input Templates and Report Templates in 10.0 using EPM Editor & dynamic formatting as per user requirement for their consolidation process.
• Used EPM functions while developing Input Template & Reports like EPMContextMember, EPMSelectMember, EPMMemberProperty, EPMMemberOffset etc.
• Worked on development of Application Sets, Applications and Dimensions including maintenance of dimension members and dimension properties.
• User Security such as team, task profile, member access profile creation and restricting user access by activity for reports only and specific to region.
• Prototype the consolidation functionalities., Prepare documents, process flows. Prepare functional, technical specification for reports.
• Prepared Document and guided team to prepare Management Book (Book Publication).

SAP BPC Consultant

Confidential - NY

Responsibilities:

• Involved in complete life cycle implementation and Interacted with the management and business Decision-makers to identify business requirements.
• Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Designed and developed Inventory, Sales, Purchase data models and the reports.
• Created and Maintained Input Templates and Report Templates in 10.0 using EPM Editor & dynamic formatting as per user requirement for their consolidation process.
• Created planning input schedules and reports such as Finance, planning, HR planning, and Sales planning.
• Developed Business Process Flows (BPFs) for various functions like Budgeting, Sales planning and assigned Security and Work Status to the BPFs.
• Worked on Transformation and conversion file and loaded data from BI to BPC.
• Validated transaction data in BPC with BI & finance teams and fixed issues.
• Worked on Dimension to modify property for reporting purpose.
• Used EPM functions while developing Input Template & Reports like EPMContextMember, EPMSelectMember, EPMMemberProperty, EPMMemberOffset etc.
• Responsible for creation of Region specific work processes, reports and input schedules.
• Worked on development of Application Sets, Applications and Dimensions including maintenance of dimension members and dimension properties.
• Use of Push Buttons with embedded functionality to enable the user to perform certain BPC functions
• User Security such as team, task profile, member access profile creation and restricting user access by activity for reports only and specific to region.

SAP BPC Consultant

Confidential, CA

Responsibilities:

• Worked on SAP BPC 10.0 NW Planning / Budgeting / Forecasting implementation from Blueprint to implementation and go-live.
• Designed Input schedules & Reports for Finance, Production, HR and Sales planning
• Created user security, Member access profiles for templates where ever it is required.
• Worked with customized process chains, Import Master & Transaction data via Process Chains (Data Manager Packages) into BPC.
• Involved in resolving the technical issues of the application. Proposing solutions proactively to avoid potential problems in application.
• Knowledge on business rules for: Carry forward balance, validation, Intercompany Elimination BW Business Content Activation for Finance Reports
• Prepared multiple reports for Plan Vs Actual Variance for difference models
• Involved in weekly and monthly maintenance procedures such as data reconciliation and informing the maintenance to the source system maintenance people
• Troubleshooting end user issues during month end closing.
• Worked with onsite/ Offshore teams, assign tasks, follow-up, monitor status of task.

SAP BPC Consultant

Confidential - DC

Responsibilities:

• Validated and checked new BPC10 environment delivered by Basis team. Validated (.\CPBM and.\POABC) directories for consistency and namespaces
• Configured Data Manager for new system (DM-Packages, updated links & configuration)
• Created environment and 5 new Models in accordance with BPML
• Created 15 new Dimensions to be used throughout the 5 new Models in DEV, QAS, PROD
• Worked on developing BPC reports for Consolidation of actuals & Cash Flow Forecasting and BPC Input schedules for consolidation of Budget
• Expertise in creation of Transformation and Conversion logic for data flow.
• Created Process chains and implemented them in Data Manager Packages to trigger from the BPC environment and the complete flow of data happens as required.
• Worked on creating the Report specifications and Design documents
• Daily trouble shooting of Incidents, Implementing changes and requests.

AP FI/CO / PS Consultant

Confidential

Responsibilities:

• Configured posting variants and fiscal year variants, settings for New General Ledger Accounting (G/L), screen layout rules, automatic account assignments.
• Configured and Customized vendor master records which includes Payment method creation in Vendor Master record.
• Involved in Asset Management Planning process for consolidation.
• Created new depreciation Keys, Transaction types, Period controls to facilitate the value change for book purpose.
• Involved in design, configuration and testing of Asset management processes integrated into New GL accounting.
• Assisted with loading of the Assets from Legacy System to new SAP Asset accounting module using LSMW
• Created and configured ‘Direct purchase’ and ‘capital in progress’ account under the procurement of assets activities.
• Created and configured Sales of assets, Asset Retirement, Asset transfer account in Asset accounting module.
• Performed unit and integration tests for one -to - one mapping of legacy to sap system.
• Configured Product cost planning by basic settings for material costing and material cost estimate with quantity structure.
• Worked on CO-PA Master Data related activities for characteristics and value fields along with Characteristic Derivations, derivation rules, maintenance of SD Conditions (On-Invoice) and PA conditions (Off-Invoice), adjustment for Transport and Warehousing Costs, closing activities for PA transfer to FI and Variance transfer from CCA to CO-PA.
• Constructed various CO-PA reports using CO-PA InfoCubes.
• Worked on integration of FI-SD and FI-MM with close cooperation from the Sales and MM teams.
• Developed Standard/Template WBS, Networks & Operative Projects for customer projects, proposals.
• Creating Milestones and assigning them to WBS Elements and Activities
• Handled Planning Functions like Date Scheduling, Resource Planning, Material Planning, Cost Planning and Revenue Planning.
• Assist in Work Package Creation, Budgeting, Earned Value Analysis. Configured Pricing Procedure Determination.
• Resource Planning, Capacity Leveling, Workforce Planning and addressed change requests; work on enhancements, Perform Mass Changes
• Assist Planners & Project Managers in Progress Analysis & Period-End Closing.
• Defined PS Security requirements & maintained PS Authorization profiles, PS Activity Groups/Roles, User Maintenance related to PS & assist in creating transaction variants.
• Downloading & Uploading of project schedule details to & from MS
• Excel & MS Projects (schedules of sub-contractors / vendors).
• Created & Implemented Test Scenarios for SAP PS module.

SAP FI Consultant

Confidential - CA

Responsibilities:

• Involved in requirement analysis and analyzing the existing system for AS IS study and functional and technical requirement gathering.
• Mapped the processes onto the SAP system and prepared the “To-be processes” document.
• Configured for vendor’s subject to withholding tax, interest calculations on item \ balance interest calculation, number ranges for forms, interest on arrears, account balance calculation on account balances / line items
• Defined expense accounts, revenue accounts for realized exchange rate difference, differentiated the accounts by currency, exchange rate gains, exchange rate losses and then posted to separate accounts for the individual currencies and foreign currency valuations
• Created and defined credit control areas to company code including pre-defined credit limits for customers
• Configured dunning program, dunning levels, dunning areas and dunning forms for each company at company code level. Configured payment terms for dunning, for over-due interest calculations, for down payments and automatic clearing of line items.
• Involved in the basic implementation and development of Blue Prints for the entire project lifecycle related to MM module covering the full “Procure to Pay” business process.
• Analyzed the existing legacy system; gathered functional requirements through user meetings, gap analysis, and participation in process improvement teams; produced the functional requirements document
• Designing business processes and identified areas to streamline processes in multiple functional areas. The scope of the work and responsibilities involved relating to SAP - Finance (FI)).
• Configured General Ledger - Created Master records, accounts groups, number ranges and G/L accounts for each company code, accounts maintenance and preparation to master files
• Customized screen layouts for document entry at account/document levels. Defined fiscal year variant, posting period variant, customized field status variant, customized line layout, sort variant, and total variant
• Configured interest calculation on account balances and line items
• Customized bank related accounting, bank master data, house banks and G/L accounts in different currencies for each bank account and Electronic Bank Statement(EBS)
• Configured and Customized Cash Management including Bank statements, Payment Programming, Payment Advises, Liquidity Forecasts, Bills of Exchanges
• Configured and Customized Cash Budget Management including commitment management
• Developed a plan and communicated with the client team on a regular basis to ensure successful execution of the plan
• Created work list for different user groups
• Helped in month end and year closing activities

NON-SAP Functional

Confidential

Responsibilities:

• Preparation of all financial reports, including Profit and Loss Statement, Balance Sheet and Statement of Cash Flows, as well as the year-end financial reports.
• Planned, organized and directed the functions of the accounting department, including accounts payable, accounts receivable, general ledger and financial reporting preparation.
• Performed complex general accounting functions, including preparation of journal entries, account analysis and balance sheet reconciliations.
• Investigated and resolved financial issues and communicated with customers/vendors about resolving financial disputes and with respect to accounts payable, and accounts receivable.
• Supervised invoice processing, purchase orders, expense reports, credit memos and payment transactions.
• Created / customized various financial reports for internal management
• Streamlined the requests of internal and external auditors and helped manage the flow of information and documentation to them thereby reducing the audit time.
• Developed online invoicing procedures with several customers in order to streamline the accounts receivable process, which reduced invoice turn-around by a minimum 10 days.
• Supervised and prepared performance reviews for a team of two senior accountants and three admin staff and trained new and existing staff on more efficient procedures.

Sr. Accounts Executive - Finance and Admin

Confidential

Responsibilities:

• Regular monitoring of the Bank, Account Receivables and Account Payables and prepared reconciliations periodically.
• Prepared forecast budgets and financial statements.
• Prepared monthly General Ledger reconciliation, including bank and ensured all accounting records were maintained in a timely and accurate manner; reviewed financial statements.
• Managed daily activities of Finance and Accounting Department (Payables, Receivables, Cashier, payroll) to achieve overall goals
• Prepared monthly closings, journal entries, bank reconciliation's, accruals and annual financial statements.
• Assisted with management of company cash flow of all vendor payables, cash flow analyses, and monthly reconciliations.
• Being a lead person worked with interim audit by coordinating and managing the provision of information to the external auditors.

Sr. Accountant

Confidential

Responsibilities:

• Served as Corporate Accounting POC for 6 branches in India, 2 warehouse locations and 2 overseas branches in resolving all sales, collections issues, customer concerns and completing cash reconciliations, chargeback resolutions, and customer returns.
• Calculated and prepared monthly Sales Tax and Commercial Tax Returns
• Processed and recorded of accounts payable and accounts receivable transactions and ensure that all invoices are paid accurately and prepared monthly reconciliations.
• Facilitate monthly branch transactions with head office, including billings and other entries and worked with Accounts Receivables team closely.
• Coordinate quarterly bank audits and annual independent financial audits.
• Coordinated regularly with Clients, Brach accounts staff regarding payment follow-ups.
• Prepared weekly & monthly sales & collections report and profitability Statements.
• Assist in preparing responses to external auditors on a yearly basis