SUMMARY

• SAP FICO Functional Analyst with 9 years of experience in SAP Financial Accounting (FI) and Controlling (CO) including studying, analyzing business processes, requirements, gap analysis, solution design, documentation - As-Is & To-Be, functional specifications (FSDs), configuration rationales (CRs), business requirements (BRDs), training materials, best practices and support
• Worked as SAP Project Manager/ Lead/ Finance Analyst/ Business Analyst on more than 11 Waterfall full life cycle ASAP/ SDLC End to End and Agile projects, full life cycle implementations, rollouts in FI, SD, MM, FSCM, LIV, IM, PS and acted as an end-user in Finance and related modules- AP, AR, GL and MM
• Involved in various implementation phases- process design, blue print, configuration, unit and integration testing, end user training and production support in GL, AR, AP, AA, PCA, CCA, PA, New GL, PPM, PS
• Knowledge and experience in US GAAP, IFRS, Order to Cash (OTC) and Procurement to Pay (PTP), Make to order (MTO), Make to cash (MTC), Lockbox, eCATTS, EDI, IDOCS, Master and Transactional Mass Data Migration (Vendor, Customer, Bank, Asset, GL), PPM (Portfolio and Project management) and PS (Project Systems), Solution Manager (Solman),
• Excellent Project Management skills with ability to manage on-site and off-shore teams across the globe
• Strong analytical and problem solving skills, attention to detail, excellent written and verbal communication skills, good presentation and interpersonal skills with ability to work independently or perform in a team
• Workaholic, sincere, enthusiastic, quick learner, adaptive and passionate to the new technologies

TECHNICAL SKILLS

ERP: ECC 6.0 (Ehp 6/5), ECC 5.0, SAP R/3 (4.6B, 4.6C & 4.7), ECCS

SAP R/3: ICR Tool, SPL, Report Writer/ Painter, WRICEF, EDI, IDOC, eCATT, LSMW, Vertex

Office: MS- Project, Visio, Access, Excel, Word, PowerPoint, OneNote, SharePoint, Outlook, VSTF

Others: QuickBooks, Adobe, Vlookup, Pivot, Macros, Financial Modeling, Database, VB

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

SAP Finance Analyst

Responsibilities:

• Analyze business requirements in order to provide the different solution options to enhance the overall Budget/Forecast Suite (BFS) suite which performs periodic budgeting and forecasting for corporate properties/ assets/ business units
• Provide a high level design overview to automate and enhance the identification/ tracking/ reporting of changes in occupancy costs & square footage based on selected time periods for budget, actual and forecast
• Enhance functionality of the forecast/budget tool to allow for input at a lower expense category level
• Create data sets to integrate with all Budget, Actual and Forecast data including building cost, square footage, occupancy allocations, etc. for ad-hoc reporting
• Leverage a single-application or a few applications for FP&A to perform budgeting, forecasting and reporting when possible. Improve functionality and/or consolidate several budget tools/applications currently being utilized
• Prepare high level Functional Design Document (FSD) for the solution approaches
• Provide production support to PPM (Portfolio and Project management) and PS (Project Systems) tickets

Confidential, Redmond, WA

SAP Finance Analyst

Responsibilities:

• Worked as Lead on full life cycle mass data migration project (Evergreen Project) on Microsoft’s Nokia acquisition which included Vendor, Customer, Bank, Asset and GL master and transactional data migration
• Analyzed GL, Vendor Master, Bank Master, Customer Master, Assets Master and Transactional mass data migration requirements and conducted gap analysis between Microsoft and Nokia legacy systems with regards to master data setup and their business operations
• Worked on addressing configurational and process differences, data mapping and data transformation rules including but not limited to Payment Methods, Payment Terms, Withholding Taxes (classic/ extended), Reconciliation Accounts, Assets Classes, Depreciation Area, Depreciation Key
• Analyzed feasibility of various data migration tools like LSMW, BDC, eCATT, Winshuttle and provided recommendations based on business needs, given time frame and longevity of the solution
• Prepared functional specification documents for developing custom programs for Vendor master, Assets Master and transactional data migration/ upload using BAPIs, BDC which included auto transformation based on data mapping provided and mapping rules defined
• Dealt with complex situations like handling bank master, IBAN, international versions, classic vs extended withholding taxes, payment terms, payment methods, migrating high sensitive (confidential) data etc.
• Worked on data validation and proofing strategies before and after migration and conducted reconciliation
• Created download and upload templates, prepared test scripts, test cases, conducted System Integrated Testing (SIT), helped in UAT, participated in cutover plan and provided post go live support
• Worked on Treasury Integration Project (TIP) which involved ICR tool enhancements
• Worked on extending Intercompany Reconciliation (ICR tool) set up for external data sources including additional configuration and customization of ICR tool, Special Purpose Ledger (SPL) set up in sender system, helping BASIS team for RFC connection set up for receiving external data in receiving system
• Worked on CapEx project on Investment Management (IM)- Project Systems (PS)
• Provided approach and functional design to address the requirements of Appropriation Request (AR) to Internal Order (IO) creation in Investment Management (IM) module which involved various levels of approvals in non-SAP interface
• Worked with external interfaces ‘MSApprove’, ‘BizTalk’ for data fields analysis and mapping to facilitate smooth communication and data sharing between SAP and external interfaces through RFC
• Worked on full life cycle implementation of SAP vNext - Group Currency Conversion project
• Conducted upstream downstream analysis to analyze Group Currency impacts on custom programs, (reports, interfaces), Function Modules (FM), Remote Function Calls (RFCs) and prepared documents, reports on findings and updated WRICEF sheet accordingly
• Supported SAP SLO team with analysis, tests, documentation for smooth and accurate Group Currency activation and data conversion activities
• Prepared/ modified functional specification documents for the solution approaches to GC impacts, conducted SIT, assisted in data validations, proofing, UAT and supported post go live
• Worked as Project Manager and Lead Finance Analyst on full life cycle implementation of SAP Intercompany Reconciliation (ICR) project to configure and set up ICR tool in SAP
• Customized Intercompany Reconciliation (ICR) for Process 001 (Reconciliation of Open Items in General Ledger), Process 002 (Reconciliation of G/L Account Line Items) and Process 003 (Reconciliation of Open Items in Accounts Receivable and Accounts Payable), checked settings for preparation in sender systems, defined reconciliation process detail attributes, assigned companies to be reconciled, maintained number ranges for group reference numbers, defined rules for document assignments, defined sets, set up object groups and subgroups, defined possible status for documents
• Created Special Purpose Ledger (SPL) for ICR Process 002, assigned global companies to the ledger, defined fields status variants, ledger selection rules, fields movement, assigned activities to the global companies and customized other required settings in regards to ICR
• Defined user exit, created ZTVARVC for special purpose ledger selection rule involving ABAP code, logic
• Provided assistance in balance carry forward, data transfer to SPL and worked on custom program to transfer some modified historical data which was not possible using standard transfer functionality
• Assisted in creating OSS message for the issue found in SPL rule selection where sort key driven FI assignment values could not be passed through user exit to update the ICR tables
• Designed Wrapper program to enhance ICR standard functionality to address specific need of Business to introduce Reconciliation GL Account as selection criteria for Process 003 (Customer/ Vendor)
• Analyzed ICR reporting requirements and provided standard ICR reports, Report Writer/ Painter developed reports and designed custom ABAP reports for specific needs of Business
• Prepared Configuration Rationale, Cut Over document, Operations Guide, FSDs, report mockups, training materials, best practices on ICR and worked with Business to define various reconciliation rules for ICR tool for automatic and manual reconciliation and addressed ICR tool enhancements like adding Group Currency field to ICR
• Worked on full life cycle implementation of Australia GST Tax project as Functional Lead
• Discussed with business to analyze very specific business needs of Australian GST tax imposition to customers which applied on purchases of specific combinations of products/ PFAMs (Products Families) which collectively created VOIP featured equipment/ facilities
• Conducted GAP analysis between upstream system (MS Sales) and SAP by analyzing data classification and fields mapping and GBI (General Billing Interface) design and provided recommendation based on SAP standard tax configurations and its limitations in regards to the requirements
• Analyzed Pricing Procedure and Condition Records for current process of taxation in Australia and US and provided recommendations with different options to use existing one or going for new one
• Configured specific Installment Payment terms and Dis count Payment Terms for VOIP products, prepared FSDs, test documents, conducted SIT and assisted in UAT and post deployment needs
• Worked on Vertex 6.0 Upgrade tax project
• Analyzed transactions (T-Codes), programs, standard and custom RFCs which call Vertex usage and prepared a report to include in master test plan, conducted System Integrated Testing (SIT)
• Created test scripts and prepared test data for Finance and Supply Chain Management (FSCM), FI, MM, SD transactions which call Vertex tax engine to determine the proper jurisdiction and tax rates
• Automated test scripts and test configuration using tool eCATT including automation of complex end to end test scenarios like Order-to-Cash, Procure-to-Pay using Solution Manager (Solman)
• Worked on MSNBC Divestiture project for SAP FI data support for divestiture of NBC from Microsoft
• Analyzed the fields required in various reports like AP Vendor Master Report, AP Payment History report, Open PO reports etc. and provided solution by building queries on various tables like LFB1, LFA1, LFBK and ADR6 etc., supported Business for all other data, reporting needs including AR
• Performed support duties including day to day production support consisting of researching, analyzing, and resolving production issues in GL, AP, AR, AA and SCM areas in SAP. For example, worked with developer to create 2 new Z programs- ZRFSEPA02, ZRFSEPA03 (according to OSS Msg. 175960) for GL Account conversion from OIM to non-OIM and vice versa and conduct testing, assisted in creating OSS messages on issues found in Group Currency, ICR etc. and supported SAP Help team for their quarries, worked on LSMW for customer master data upload and created COPA reports
• Worked on FI-MM-SD integration related issues including inventory movement related account, billing and revenue account determination, Interfaces design and testing
• Performed super user functions for the client that included month end checklist verification, opening / closing periods, Z programs, Z table updates which were run as part of ME /YE close, rerunning of failure jobs, data extracts and creating reports for audit compliance requests
• Addressed master data related issues like creation, changes to master data, blocking, unblocking and changes to GL accounts, cost centers, profit centers, implementing business processes, Asset acquisitions or removals, coordinating security needs, and implementing new client account / cost center requests and analyzing development requests impact on current reports and applications
• Maintained training materials/ support/ operations guides to include any new functionality or changes in processes, addressed end user issues, shared best practices and trained users as needed

Confidential, Houston, TX

SAP Finance Analyst

Responsibilities:

• Worked on various configurations, customizations and SDLC projects which involved business process studies, defining/ analyzing business requirements, gap analysis, documentation, testing and support
• Worked on the project for ‘Import vendor GR/ IR reconciliation process integration’
• Discussed requirements with business, conducted analysis and prepared documents
• Prepared functional specification, test scripts and cases, conducted unit and integration testing, helped users in User Acceptance Test (UAT) and provided post go live support
• Worked on developing a custom program for ‘Posting import vendor invoice’
• Created FSD, test documents, conducted SIT, supported UAT and post go live
• Worked on creating an ABAP report for ‘MR Invoice Reduction Reconciliation Report’
• Created FSD, test documents, conducted SIT, supported UAT and post go live
• Configured and customized GL, AA, IO, CC/ CEA, PCA, COPA and prepared configuration rationales
• In General Ledger, configured and customized G/L account master records, chart of accounts, field status groups, automatic account determination, financial statement versions, G/L display configuration, validations and substitutions, configured settings for New GL, defined categories of GL accounts, integration with CO and AA, activated document splitting, defined document splitting rule and assigned the method
• In Asset Accounting, configured and customized organizational structure, country specific settings, asset classes, account determination, depreciation areas, depreciation keys, screen layouts, transaction types, as transferring variants for automatic inter-company asset transfer, cross-system depreciation areas, settlements for assets under construction (AUC) and postings of transactions in asset accounting and transfer from legacy systems
• In Cost Center/Cost Element Accounting, configured and customized the cost elements/cost centers, costing sheets, reconciliation ledgers, standard hierarchy, activity types, statistical key figures, assessments, distributions
• In Profit Center Accounting, configured and customized the basic settings, maintaining profit center hierarchy, assignments, CO objects to Profit Centers, distribution and assessment of costs, planning and development of Reports, profit center planning and budgeting
• In Internal Orders, configured and customized the order types, settings for the settlement of internal orders and maintained budget profile and planning profile, availability of budgetary control and monitored budget
• Worked on integration of FI/CO with MM and SD for Inventory valuation, Movement types, GR and Invoice verification, order management, pricing, delivery and transportation and billing
• In Profitability Analysis (CO-PA), configured Operating Concern, Operating Concern Attributes, created characteristics and value fields, master data settings- characteristics values, hierarchy, characteristics derivation, valuation, planning, actual values flows, profitability reports creation
• Worked on FI-MM integration (OBYC) and FI-SD integration (VKOA) on account determination
• Provided functional support for FI, CO, SD, MM, IM, LIV, WMS including configuration, maintenance, enhancements, report development, quality assurance and other activities as required
• Created reports in COPA to report profitability by Customer, Product and Market and Report Writer and Report Painter reports by Customer/Profit Center/Product/Period
• Worked on Vendor Master data upload using LSMW
• Worked on Supply Chain (SCM) related tickets, fixes, enhancements in monthly/ quarterly releases including testing and helping users in UAT and successful deployment
• Worked closely with members of business functions (Finance, Accounting, Operations, and Services) to facilitate effective solution implementations, prioritize and manage completion of support tickets by FI/CO support metrics and provided knowledge transfer of system functionality to Super Users, Subject Matter Experts, End-Users and various other functional organizations and IT department

Confidential, San Diego, CA

Financial Analyst

Responsibilities:

• Managed daily accounting operations including Accounts Payable and Accounts Receivable
• Performed monthly forecasts for revenue, expenses and cash flows and prepared management reports on actual vs. forecasted, prepared operation budgets
• Performed scenario analyses to align operational and financial resources with growth objectives
• Involved in general and accounting operations using QuickBooks and MS-Access database
• Performed month-end reconciliation with bank accounts
• Helped business in automating processes to ensure faster operations and reduction in costs by creating MS Access database, automating invoicing system using VS and MS Access, developing models for data entry sheets, break-even calculators for different products/ services etc. using MS-Excel financial modeling and advanced features of MS Access and Excel like vlookup, pivot, macros, queries
• Created automated reports on outstanding balances from the customers to set reminders for collection on timely manner in order handle receivables efficiently
• Managed sales team activities and performance using Leads 360 software and Excel based models
• Analyzed company’s financial needs and work with management to raise capital, wrote Business Plan for investors with Power Point presentations and created monthly repayment schedules for investors for different investment amounts (e.g. 25k, 50k, 100k) and ROIs

Confidential

SAP Finance Analyst

Responsibilities:

• Configured FI global settings, account groups, tolerance groups, field status groups, fiscal year variants, and posting period variants
• Defined chart of accounts, global parameters for different company codes, dunning procedure, automatic payment program, and tax procedures
• Created GL master records, customized automatic account assignment settings for posting keys, defined document types and number ranges, configured GL transactions
• In Accounts Payables (AP) and Accounts Receivables (AR), configured and customized vendor / customer master records, account groups, account determinations, tolerance groups, country / company code specific payment methods, terms of payment, automatic payment programs for outgoing payments, dunning, bank settings, correspondence, check management, reason codes, interest calculations, discount calculations, special GL transactions and credit control areas, lock box configuration
• Created customer master data, customers groups, client specific payment terms and interest calculations, payment terms, incoming payments, and clearing methods, worked on credit management through credit control areas, assigned credit limit to the customers and customer groups
• Worked on creating and modifying sales area data for customer master, pricing conditions for sales invoices, created vendor list, tolerance groups, number ranges, maintained vendor master data and executed the changes as needed to process open items
• Worked on legacy customer and vendor master data uploads to SAP system using LSMW
• Worked on integration of FI with SD and MM modules, and executed the recurring documents, open and close posting periods, foreign currency valuation, and balance sheet accounts
• Configured and customized cash Journal and other related areas, House Bank, payment method, automatic payment, check payments and all other related areas in Cash and Bank Accounting
• Worked on creating controlling areas, assigned controlling areas to the company code, setup cost indicators in controlling area, allocation activity types, cost elements at the controlling level, and cost element master data, configured primary and secondary cost elements, created cost centers, cost center hierarchy and assigned cost elements to various cost centers
• Worked on writing functional specifications, configuration rationales, user training materials

Confidential

Accountant/ Financial Analyst

Responsibilities:

• Managed AR and AP, prepared general ledger and monthly bank reconciliations
• Performed monthly, quarterly and annual Forecasts for revenue, expenses, income, Cash Flow and investment and prepared management Reports on Budgeted Vs Actual based on forecasts
• Analyzed financial and operational information (e.g. financial statements, financial ratios, key performance indicators, sales forecasting platform, integrated budget model, product pricing and management reports), generated trends and prepared spreadsheets, graphs, and charts using advance features of MS-Excel (Macros, VLookup, Pivot Tables/ Charts etc.) to illustrate financial trends
• Prepared monthly, quarterly and yearly Budgets and Pro-forma Financial Statements and plans of action for investment based on financial analyses
• Assessed Business Strategies, Product Trends, Market Competition and made recommendations