SUMMARY:

• SAP certified Lead Consultant/ Sr. Business Analyst with over 17 years of professional experience including 14+ years in enhancement, upgrade, implementation, rollout projects and production support with focus on SAP ERP/ S/4 HANA Financials, Sales and Distribution and Supply Chain processes
• Proficient in communicating with business/ stakeholders, studying, analyzing business processes and requirements, gap analysis, identify changes, defining scope, solution definitions, translating business requirements into (SAP) technical terms
• Expertise in documenting As - Is & To-Be, business processes (BPDs), procedures (BPPs), business requirements (BRDs), functional specifications (FSDs), configuration rationales (CRs), training materials, best practices
• Hands on experience in all phases of projects- Project Preparation/ Requirement Analysis/ gathering, Business Blueprint/ design, Realization/ Configuration/ Development, Unit and Integration Testing, Final Preparation/ Cutover, End User Training, Go Live Support/ Production Support/ Hyper Care
• Proven excellent Project Management/ Team Lead skills while working with diversified team across the globe- Onsite/ Off-Shore on more than 17 full life cycle end to end Waterfall/ ASAP/ SDLC and Agile/ scrum projects which involved enhancements, upgrades, implementations, roll outs in the areas of Finance (FI), Sales and Distribution (SD), Materials Management (MM), Financial Supply Chain Management (FSCM); successfully demonstrated strong analytical, attention to detail and problem solving skills
• Hands on experience in SAP S/4HANA implementation, end to end integration between SAP and Non-SAP applications through middleware (SAP PI/ Process Integration, SAP XI/ Exchange Infrastructure), OpenText VIM; performing and managing Testing and Cutover activities, End User Training and Support
• Specialized in SAP modules General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Asset Accounting (AA); Intercompany Reconciliation (ICR); integration aspects of SD (Sales & Distribution), MM (Material Management), with Finance & Controlling; Mergers & Acquisitions (M&A); Master and Transactional Data Migration (Vendor, Customer, Bank, Asset, Material, GL); business processes Order to Cash (OTC), Procure to Pay (P2P)
• Knowledge/ experience in US GAAP, IFRS, US Sales/ Use Taxes, Vertex, Withholding Taxes, SCOR, Profit Center Accounting (PCA), Cost Center Accounting (CCA), Profitability Analysis (PA/COPA), New GL, Product Costing, Cash Management, PPM (Portfolio and Project management) and PS (Project Systems), LIV, IM, Solution Manager (Solman), BPC, BCS, ECCS (Consolidation), SAP Business Warehouse (BW) Reporting, Workflow, MTO, MTS, Trade applications Blacksmith Forge and CBS (Computerized Business Solutions)
• Self-starter, workaholic, sincere, enthusiastic, quick learner, adaptive and passionate to the new technologies, excellent written and verbal communication skills, good presentation and interpersonal skills with ability to work independently or perform in a team

TECHNICAL SKILLS:

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

SAP: RICEFW, ICR Tool, SPL, Report Writer/ Painter, GXS (G lobal E x change S ervices) / OpenText/ PI/ XI, EDI, IDOC, XML, eCATT, LSMW, Lockbox, APP, Dunning, Treasury, Group Currency, Multi-currency, IHC, POB, BTE, BAdI, User Exit, BAPI, Security, BPC, BW, PCA, CCA, PA, New GL, Simple Finance, FI, SD, MM, FSCM, LIV, IM, PS, OpenText VIM, Winshuttle

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

Other: Blacksmith Forge, CBS, Agile, Scrum, Vlookup, Pivot, Macros, SQL, Financial Modeling, Visual Basics (VB), Adobe, QuickBooks

PROFESSIONAL EXPERIENCE:

Confidential, Commerce, CA

SAP FICO Lead

Responsibilities:

• Analyzed OpenText Vendor Invoice Management (VIM) upgrade scope, requirements including custom developments to address performance and other production issues
• Planned, executed, managed and controlled Project Schedule and Quality
• Performed Unit & Integration testing for PO and Non-PO invoices through EDI/ Idoc & ICC channels utilizing OpenText VIM Workplace, Business Process Center and VIM Analytics, Winshuttle
• Developed Cutover plan, conducted and monitored successful cutover and Go Live
• Created OpenText user training materials, best practices, trained users & provided Post Go Live support
• Worked independently with Business users to identify, prioritize and define business requirements for SAP enhancements and change requests in the FICO modules, and reviewed requirements, specifications, business processes and recommendations related to proposed solution
• Performed analysis of business and user needs, documentation of requirements, and translation into system requirement specifications
• Worked on multiple, simultaneous projects and assisted with project management as well as the planning, testing, and implementation of new software enhancements, and coordinated development, integration testing, and production cutover.
• Ensured completion of all deliverables according to user expectations and within schedule, budget and quality constraints, assisted with development of training materials for end-users
• Supported Accounts Payable, Fixed Asset Accounting, Banking, and the Controller’s Office by resolving production support issues, identifying and addressing the root causes be it internal to SAP, in the inbound or outbound interfaces, or related to business process / user-training

Confidential, Glendale, CA

Sr. Business Analyst/ Cutover/ SAP FICO/SD

Responsibilities:

• Worked on GLS project for smooth migration of Nestle Professional master/ transactional data, programs, interfaces, batch jobs etc. from split SAP ERP systems (Operations, Commercial and Finance) to consolidated environment on the SAP S/4 HANA platform
• Analyzed and determined the scope of FI, AP, AR, SD, MM related data and interfaces for migration to SAP MONO (S/4HANA based ERP system) for Nestle Professional business
• Created Test Plan for testing all in scope data, interfaces involved in upstream and downstream systems
• Conducted Unit and End to End System Integration testing, reconciliation and prepared documents
• Prepare extensive cutover plan for in scope master and transaction data transfer, executed Cutover
• Provided all necessary documentation, Post Go Live support

Confidential, Glendale, CA

Sr. Business Analyst/ Integration Lead

Responsibilities:

• Analyzed Nestle Professional (NP) business systems and processes, conducted As-Is and To-Be analysis through direct interactions with Business in workshops/ online sessions, prepared As-Is To-Be/ GAP documents
• Documented business requirements, created Business Blue Print document, prepared system landscape diagrams, conducted GAP study for retiring legacy system ISW and Blacksmith Forge applications, discussed and documented solutions approaches
• Prepared Functional Specification documents for ABAP, XI and Idoc changes in various interfaces including Off-Invoices SD Pricing Conditions interface, GBI Interface, Product/ Material Master interface, Price List interface, Customer Master and Customer Hierarchy Interface etc., conducted review meetings with technical and Business team
• Worked closely with ABAP, PI/XI, GXS (OpenText)/ EDI team for all ABAP/ GXS (OpenText)/ PI/XI/ Idoc design changes in the inbound and outbound interfaces and conducted Functional Unit Testing, System Integration Testing, analyzed root cause and suggested fixes for defects, prepared test documents
• Worked on Blacksmith Forge trade application and CBS data integration applications for Blacksmith to SAP End to End testing and analysis- created Off Invoices, Distributor and Operator contract programs, Manual, Auto Pay Billbacks and Deductions/ Dispute Management in Blacksmith Forge, conducted testing for data postings in SAP and in Blacksmith and utilized Data Integration Viewer (DIV) in Blacksmith Forge for data validations and reporting
• Tested and validated data transmission from Blacksmith to SAP and vice-versa along with third party tool CBS for all different interfaces utilized for Nestle Professional business
• Led the team of functional analysts working on SAP- Blacksmith Forge integration through couple different interfaces to ensure successful and on time delivery of interface changes and testing tasks
• Prepared cutover detailed plan for Customer Master, Material Master, Customer Hierarchy and Price List legacy data, tracked cutover activities during Go Live and performed reconciliation after cut over
• Prepared data reconciliation matrix between Legacy & SAP using SAP Business Warehouse (BW) reporting
• Provided Go Live and Post Go Live support, worked on KPIs tracking during Sustain phase, analyzed, Worked on Hyper care tickets for testing, validating and resolving the issues

Confidential, Redmond, WA

Lead Business Analyst

Responsibilities:

• Worked on Automating Intercompany Netting AR/AP In-House Cash (IHCC) (SAP Treasury) Settlement & Clearing Process in Centralized payment system (covering SAP FSCM, Treasury)
• Analyzed the requirements and design the solution to automate intercompany P2P and OTC processes which involved automatic creation of FI documents with common references from SD and MM sides, Automatic Payment Program (APP) enhancements for house bank (IHCC) balance check (FSCM module) before executing the payments to vendors to avoid overdraft situations
• Analyzed the requirement and designed solution through configure/ customize the system for AR sub-ledger auto clearing of intercompany IHC payment transactions which involved configuration of EBS account symbols, posting rules, transaction types, search string, note to payee user exit enhancement, BTE configuration
• Prepared Configuration Rational, Visio process flow diagrams and design documents to configure and customize/ design the SAP Treasury- IHCC module to have capability of IC Netting/ auto clearing of customer and vendor open invoices by auto posting of Internal Bank Statements (EBS) using EDI/ Idocs (e.g. INVOICE, PAYEXT, FINSTA), for user exit/ BTE enhancement needed for reversal of Payment Orders in IHC intercompany transactions, ICR (Intercompany Reconciliation) tool enhancements to properly capture auto AP/ AR sub-ledger matching
• Prepared the Functional Specification Document for user exit enhancement needed for reversal of Payment Orders in IHC intercompany transaction
• Explored the possibility of user exits, BTEs to add enhancement in APP program for balance check
• Enhanced ICR (Intercompany Reconciliation) tool to properly capture auto AP/ AR sub-ledger matching which involved configuration/ customization of intercompany reconciliation areas
• Created test scripts, test cases and conduct unit and end to end system integration testing (SIT)
• Provided assistance in User Acceptance Test (UAT) and Post Go Live production support

Confidential, San Francisco, CA

Business Finance Analyst

Responsibilities:

• Analyzed business requirements to provide different solution options to enhance the overall Budget/Forecast Suite (BFS) suite which performs periodic budgeting and forecasting for corporate properties/ assets/ business units
• Provided a high-level design overview with pictorial representation 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 and present a comparative analysis between classic approach and BPC approach
• Enhanced functionality of the forecast/budget tool to allow for input at a lower expense category level
• Created data sets to integrate with all Budget, Actual and Forecast data including building cost, square footage, occupancy allocations, etc. for ad-hoc reporting, dashboards, prepared high level Functional Design Document (FSD) for the solution approaches, test scripts and cases
• Provided production support to PPM (Portfolio and Project management) and PS (Project Systems) tickets

Confidential, Redmond, WA

Sr. Business Analyst/ Lead

Responsibilities:

• Worked on various projects- Evergreen (Post Merger integration- Data Migration), TIP (Treasury Integration Project), CapEx (Inv. Mgmt/ IM, Project Systems/PS), SAP vNext - Group Currency Conversion, ICR (Intercompany Reconciliation) Implementation, Australia GST Tax Implementation, Vertex 'O' Series 6.0 upgrade, MSNBC Divestiture, Skype Rollout & Data Migration and production support

Sr. Business Analyst/ Lead

Responsibilities:

• Led the full life cycle mass data migration project (Evergreen Project) on post-merger integration roadmap of Microsoft-Nokia involving Finance, Procurement and Sales data migration including Vendor, Customer, Bank, Asset and GL master and transactional data migration
• Analyzed GL, Vendor Master, Bank Master, Customer Master, Assets Master, Material Master and Transactional (AR/ AP/ GL invoices), Sales Orders/ Purchase Orders 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 configuration 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
• Conducted PoC to analyzed feasibility of various data migration tools like LSMW, BDC, eCATT, Winshuttle and provided recommendations based on architectural approach, business needs, time, cost and value
• Utilized agile methodology for additional requirements, participated in multiple sprints sessions, daily standouts, task boards, storyboards for successful and optimal way of addressing the project needs
• Prepared functional specification documents with Visio process flow for Vendor master, Customer Master, Assets Master and transactional data migration/ upload using BAPIs, BDC which included auto transformation based on data mapping provided and mapping rules defined; for security roles/ authorization needed to execute transactions
• Dealt with complex situations 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, worked in FSCM Credit Management, Collection Management areas for data flow, impact testing
• Created download and upload, data mapping templates, assisted business owners for data mapping
• Prepared test scenarios, test scripts, test cases, conducted System Integrated Testing (SIT), helped in UAT, contributed in cutover plan, activities checklists, transport management and provided post go live support

Sr. Business Analyst (FICO/ FSCM)

Responsibilities:

• 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
• Configured and customized FSCM IHC external payments 'Pay on Behalf' (POB)/ Payment Factory, EBS, account symbols, posting rules, transaction types, search string, note to payee
• Created Payment Method mapping between Treasury and AP including ACH/ SEPA, WorldLink WIRE, SWIFT
• Created test scenarios, test cases and executed end to end testing SIT for external payment process, EBS, EDI, IDocs, XML, assisted in UAT

Business Finance Analyst

Responsibilities:

• Analyzed the business requirements and 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, workflow process
• Created process and data flow diagrams using Visio which involved various upstream and downstream instances and complex process of approval, prepared Functional Design Document (FSD) and Test documents
• 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 SAP Business Planning & Consolidation (BPC) 10.1 for creating forecast dashboards, CapEx reports related to Budgeting & Forecasting for Actual, Committed, Plan, comparing actual vs. forecasted and analyzing trends, utilized Dashboard Designer, EPM Report Editor, Formatting sheet to address the reporting requirement
• Worked on UI tool to initiate a workflow (Data Warehouse Workbench), establishing data flow between EPM client Excel & BPC, different interfaces/ upstream/ downstream systems hookups
• Created Test scripts and test data for End to End testing and supported UAT

Sr. Business Analyst

Responsibilities:

• Conducted upstream downstream analysis to analyze Group Currency impacts on custom programs, (reports, interfaces), Function Modules (FM), Remote Function Calls (RFCs) developed for Local and Transaction Currencies 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, created test cases and executed end to end SIT, assisted in data validations, proofing, UAT and post go live support

Sr. Business Analyst (FICO)/ PM

Responsibilities:

• Worked as Lead FICO Analyst on full life cycle implementation of SAP Intercompany Reconciliation (ICR) project to configure and set up ICR tool in SAP
• Managed requirement workshops, defined scopes, solution definitions and stakeholders’ expectations, conducted the gap analysis and provided recommendations
• Configured/ 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
• Created user exit, BTE, 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, provided standard and Report Writer/ Painter developed reports
• Analyzed custom reporting requirements, compared and analyzed Intercompany EC-CS (Consolidation) data/ reports, designed custom ABAP ICR reports- IC bal. summary, detailed, dividend, ICR to GLT0 recon
• Worked on security roles/ authorizations required for running ICR tool for super users, batch user etc.
• Prepared Master Test Plan, test scripts and test cases to properly test end to end configuration and enhancements
• Prepared Configuration Rationale, Cutover document, MS Visio data flow/ process flow and design diagrams, 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 using BAdI, BTEs
• Prepared Business Process Procedure (BPP) documents, training materials for end to end intercompany process including Process flow Visio diagrams, Prepared customized ICR dashboards and trained super users
• Created Cutover plan, activities checklists, discussed and planned transport management, legacy shutdown, black out period, contingency plans, post go live reconciliation procedure and managed cutover for a smooth transition to production, assisted in balance carry forward, data transfer to SPL through standard and custom programs

Sr. Business Analyst

Responsibilities:

• Discussed with stakeholders 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, discussing with Architect 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 Discount Payment Terms for VOIP products, prepared FSDs, created Visio flow diagrams
• Created Master Test Plan (MTP) including scope, approaches, test types, test procedures, test schedules with milestones, bug tracking and reporting, regular/ periodic overall test status reporting, risks and dependencies
• Conducted SIT, prepared test documents and assisted in UAT and post deployment

Business Analyst/ Test Lead (FICO)

Responsibilities:

• Worked on Vertex Indirect Tax (US Sales, Consumer Use, Retail, VAT, GST) ‘O’ Series 6.0 project
• Checked configuration settings with Vertex- ‘Vertex Tax Link’ installation, RFC connection setup between SAP and Vertex (Tax Link), SAP Integration Component (SIC), Tax Procedure (TAXUSX), Tax Codes
• Conducted Vertex functionality tests for Tax Area Ids (Jurisdiction codes) retrieval based on Customer, Vendor Master, Cost Centers, Plants, Delivery Address; Tax rates and amounts retrieval for Sales Orders, Billing, POs, AP Invoices, analyzed tax decision data based on customer, vendor, material/ service and usage, analyzed all transactions, programs, standard and custom RFCs which call Vertex
• Prepared Master Test Plan (MTP) including scope, approaches, test types, test procedures, test schedules, bug tracking and reporting, overall test status reporting, risks and dependencies
• Conducted System Integrated Testing (SIT), created test scripts, test cases for FSCM, MM, SD, FI transactions which call Vertex to determine tax rates and amounts and used Vertex UI tax tools (Transaction Tester, Rate Area Lookup, Tax Area Lookup) to validate the results
• Automated test scripts and test configuration using tool eCATT including automation of complex end to end test scenarios like Order-to-Cash (OTC), Procure-to-Pay (PTP) using Solution Manager (Solman)

Business Analyst/ Tester

Responsibilities:

• 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

Business Analyst/ Tester

Responsibilities:

• Worked on global roll out and Skype data migration project on Post merger integration of Microsoft-Skype which included Finance data migration including Vendor, Customer, Bank, Asset and GL master and transactional data
• Worked on addressing configuration and process differences, data mapping and data transformation rules
• Created FSD, performed Vendor and Customer data transformation and upload in SAP using LSMW/ Winshuttle
• Conducted data validation and proofing before and after migration and performed reconciliation
• Created download and upload templates, prepared test scripts, test cases, conducted System Integrated Testing (SIT), helped in UAT, contributed in cutover plan and activities and provided post go live support

Business Analyst

Responsibilities:

• Performed production support duties consisting of researching, analyzing, and resolving production issues in GL, AP, AR, AA and SCM, assisted in creating OSS messages on issues reported, worked on LSMW/ Winshuttle for customer/ Vendor master data upload, COPA Top-down Distribution, COPA reports, Lockbox, EBS, Idoc, XML issues, FSCM (Credit and Collection) and FI-MM-SD integration related issues including inventory movement related account, billing and revenue account determination, Interfaces design and testing
• Worked on couple Agile/ Sprints objects for small enhancement needs, prepared FSDs, configured/ customized, created test cases and conducted end to end testing
• Performed super user functions, month end checklist verification, opening/ closing periods, Z programs/ table updates ran 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, workflow issues, Maintained training materials/ support/ operations

Confidential, San Diego CA

Business 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 as lead on projects involving implementation and enhancements, discussed requirements with business, conducted analysis and prepared documents
• Created project schedules, did resource planning, managed On-site/ Off-Shore resources including tasks allocations and tracking, conducted periodic project and milestone meetings with business and IT teams
• Represented IT team while acting as liaison between business and IT and handled all the team level communications, managed change requests and tracked and monitored risk/ issues
• Created Master Test Plans including test schedules, bug tracking and reporting, overall test status reporting
• Created Business Process flows diagrams using Visio and prepared BPD/ BPP for complex Supply Chain Source/ P2P and Deliver/ OTC processes interaction with involved various interfaces and multiple stages of approvals
• Worked on the objects for ‘Import vendor GR/ IR reconciliation process integration’ and ‘Posting import vendor invoice’ enhancements and an ABAP report for ‘MR Invoice Reduction Reconciliation Report’
• Prepared functional specification, process flow and system context Visio diagrams, test scripts and cases, conducted unit and integration testing SIT), helped users in UAT and provided post go live support

Confidential, San Diego, CA

Business Finance Analyst

Responsibilities:

• Configured and customized GL, AR, AA, IO, CC/ CEA, PCA, COPA, prepared blue print doc, configuration rationales, conducted testing, data conversion, participated in cutover activities, UAT training, post go live support
• 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 transactions postings in asset accounting and transfer from legacy
• 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 IOs and maintained budget profile and planning profile, availability of budgetary control and monitored budget
• Worked on integration of FI with MM for Inventory valuation, Movement types, valuation class/ valuation modification, general modification, transaction key, account determination, GR and Invoice verification, order management, workflow settings for PO release, 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, top-down distribution
• Worked on FI-SD integration (VKOA) on Access sequence, Account Key, Account determination
• Provided functional support for FI, CO, SD, MM, IM, LIV/ 3-way match, WMS including configuration, maintenance, enhancements, report development, quality assurance, Vertex Pock
• Worked on COPA Top-down Distribution, 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 Lockbox configuration and processing (including bank file formats SWIFT MT 940, BAI/ BAI2), Electronic Bank Statement (EBS), XML, Idoc issues, Vendor Master data upload using Winshuttle, ICR tool feasibility PoC, Automatic Payment Program (APP), Dunning, Supply Chain (SCM) related tickets, fixes, enhancements in monthly/ quarterly releases including testing and helping users in UAT and 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
• Conducted end to end testing (SIT), prepared test scenarios, and test cases, participated in cutover

Confidential, San Diego, CA

Business Finance 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, month-end reconciliation with bank accounts
• Involved in general and accounting operations using QuickBooks and MS-Access database
• Helped business in automating processes to ensure faster operations and reduction in costs using MS Access, automating invoicing system using VB 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
• 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, San Diego, CA

Business Consultant

Responsibilities:

• Analyzed possible opportunities to grow the businesses and community of Chula Vista Broadway area, provided forecasts for the budget needed to support the sustainable growth by analyzing historical trends
• Facilitated formation of non-profit Broadway Business Association (BBA); provided documents like Bylaws, Article of Incorporation; and assisted with effective functioning of BBA in future, provided project documentations

Confidential

Business Finance Analyst

Responsibilities:

• Implemented ASAP methodology - gathered requirements for new implementation, created process flow documents using Visio, blue print doc, test cases, conducted data conversion and participated in cutover activities
• 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, 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, 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
• 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 transactions postings in asset accounting and transfer from legacy
• Created customer master data, customer’s 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
• 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, Lockbox, House Bank, payment method, automatic payment program (APP), 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
• Prepared functional specifications documents (FSDs), configuration rationales (CRs), BPDs, user training materials
• Created Test scripts and test cases, conducted end to end testing (SIT), assisted in UAT, participated in cutover

Confidential

Business Finance 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
• Assessed Business Strategies, Product Trends, Market Competition and made recommendations
• 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