PROFESSIONAL SUMMARY:

• More than 9 years of extensive experience in FICO and Data Integration / Migration.
• About 3 years’ experience in SOX Compliance and Readiness.
• Overall 16+ years’ experience in various roles like SAP Consultant, Business Analyst, Public Accountant and Financial Planning and Reporting Accountant.
• Expert in SAP Data Services (Data flows, Scripts, complex transforms, data integration), Winshuttle (Query, Transaction, Forms), Innowera (Runner / Program).
• Excellent in design, creation, and implementation of workflows, data flows, scripts and performing simple and complex transforms in dataflow using different data integrator, platform and data quality transforms including Address cleansing and De - duplication.
• EHP7 upgrade.
• Experience in Rapid Data Mart (Sales, AP, PP) using Data Services.
• Experience in working with BODS Adapters like SalesForce.com to create jobs to read data from SFDC and load into ECC after De-duplication and Cleansing.
• Expert in writing Macros and use of VBA for Excel.
• Experience in resolving on-going maintenance issues and bug fixes, and performance tuning of reports.
• Outstanding communication and interpersonal skills, ability to learn new environment and tools very quickly, good analytical reasoning.

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Manager SAP Applications

Responsibilities:

• Responsible for Maintaining SAP Applications: ECC, BW, BPC, GRC.
• SOX Compliance, Audit readiness and support.
• Compliance with IT policies and Monthly SOX controls.
• Configuration, testing and promotion of changes in FICO, MM, P2P.
• Lead production support team.

Confidential, Plano, TX

Sr. Consultant

Responsibilities:

• Manage team and support the FI, MM, BW Basis and Security function.
• Provide FICO support.
• Performed Function role in FI/CO, AR, AP and AA modules.
• Worked with Basis team to identify add-ons during creation of the stack.
• Maintained Documentation and performed unit testing and QA testing.
• Managed the UAT process by helping users in performing the tests, maintaining a log of issues and resolving the issues.
• Performed transformation, validation and load of Master and Transaction data into ECC 6.0 using Winshuttle, Innovera and LSMW.
• Participated in acquisition meetings and provided guidance on the methods to load the master data.
• Performed Scheduling / sequencing of the objects so as to fit the project within an excessively challenged timeline.
• Created and provided templates to the acquired entity to provide the transitioning master / transaction data for Customers, Vendors, Material, Assets under construction, Fixed Assets, Internal Orders, Intercompany-relationships,
• Installed and Used Data Services 4.2 to do Address Cleansing (US Address cleansing based on USPS directories) and de-duplication (based on name-address match transform) of Vendor Master.
• Provided De-duplication suggestions by using Match Transform in conjunction with Address Cleansing, to determine the duplicates, which will not be loaded into target.
• Provided mapping of the correct Partner Functions in the load template.
• Recorded Winshuttle Transactions and ran loads for Vendor Master and Extending Vendors to different company codes.
• Provided analysis of Vendors eligible for deletion.
• Search term standardization.
• Provided templates for populating the data for Assets under construction and Fixed Assets.
• Provided functional help on creating new depreciation key for assets.
• Loaded AUC (AS91) and FA(AS01) using Winshuttle.
• Helped in doing the UAT by providing Excel based reconciliation of load data with the assets loaded in SAP.
• Worked with MM Lead to do the Material Master Load using LSMW.
• Provided de-duplication suggestions by standardizing Material Description.
• Performed loading of Intercompany Customers, Intercompany vendors, Intercompany partners (OBYA).
• Developed Report to extract the notes maintained on the Vendor Master record. (SAP OSS) using GUI Scripting in Winshuttle.
• Automation of FI-reports by scheduling jobs in SAP.
• Planned Values for Internal Orders.
• Configuration of Bonus Depreciation.
• Additional Asset load
• Automation of OB52
• Creation of addition depreciation key for Assets with scrap value.
• Added additional criteria (Name1) or vendor name search
• Configured payment method to record payments using credit cards.
• Blueprinting and GAP analysis of AP, FA, GL Misc. AR, MM for conversion to AX.
• Performed analysis of Design documents and provided suggestion to secure the interests of business users.
• Performed Scheduling and sequencing of loads.
• Designed the UAT scripts (FI, AP, Misc. AR and GL) to ensure completeness of all scenarios for testing.
• Performed Data Load and reconciliation in UAT system for
• Vendor Master
• Vendor Certificates.
• Financial Dimensions
• Budget Registry entries
• Fixed Assets master data
• Accumulated Depreciation
• Depreciation Journals
• Helped in preparing the data load for Open AP, Open AR. Open PO.

Confidential

Sr Consultant

Responsibilities:

• Performed Software landscape review and provided recommendation on architecture.
• Installed and configured SAP Data Services (4.1), Information Steward (4.1) in a distributed environment (Web server + App Server + Database server)
• Configured repositories, users and security
• Installed SAP Best Practices Data Migration for ERP/CRM with Migration services.
• Trained key users of Confidential on
• Data Services
• Architecture, deployment and Installation
• Data Services Management Console
• Data Services designer
• Data Services Transforms
• Data Conversion using Data Services
• Address cleansing, Name Address cleansing, Geo-coding
• Data Migration using SAP BPDM.
• Information Steward
• Data Quality Analysis
• Setting up Rules, Bindings and Scorecards
• Creation of Cleansing packages and integration with Data Services jobs.
• Cleansed, transformed and loaded Vendor master.

Confidential

Sr Consultant

Responsibilities:

• Data Migration from SAP and non-SAP sources to SAP-BW using SAP Data Services.
• Used SAP Financial Information Management to create and maintain mappings and maintenance of jobs.
• Participated in requirement gathering workshops to understand data structure and conversion requirements.

Confidential

Business Functional Analyst

Responsibilities:

• Worked on AS-IS / TO-BE process documents, MS VISIO Process flows, Integration testing, user training.
• Data conversion, loading and validation of Master data, AR/ AP Open Items and Purchase Orders during internal SAP implementation
• Gave End user training for creation of sales contracts, booking of revenue, T&E entry and validation of the end results.
• Configured additional Tax codes for new Jurisdiction.
• Post go live support:
• Incorrect tax codes appearing in different countries
• Invoice split logic
• Revenue and cost planning in SAP
• Automation of Commission calculation based on SAP reports.
• Enhancement to CATS based TE reporting tool.
• Helped analyze inconsistency in Sales contracts and Deployment records (custom HR infotype)
• UAT of SAP ESS (Employee Self-Service)
• Installation, maintenance and upgrade of SAP Data Services (4.0, 4.1, 4.2) SAP Information Steward (4.0, 4.1 and 4.2)
• Implementation of SAP BPDM (Best Practices in Data Migration) including Migration services.
• Implementation of SAP Rapid Data Marts (Sales, AP, PP) and Webi Reports.
• Set up connection to Sales Force Dot Com in Data Services and developed jobs for Automated Customer Master creation in SAP (Post cleansing and de-duplication).
• Set up SAP DQA using Data Services.
• Set up rules, scorecards, Match Review and Financial Impact analysis in Information Steward 4.2.
• Assisted SAP, AG in the QC of SAP Data Services 4.1.
• Pre-Sales Activity including Demo of O2C cycle: Creation of sales contracts, Creating Customer master records, creating sales orders, creating billing documents, posting cash receipts and managing AR.
• Also, I have extensively worked on the project scoping, resource requirement analysis, SOW RFP responses etc.
• Frequently I have also helped team members to learn the implementation of SAP Data Services, Information Steward, SAP DQA, developing & debugging SAP BODS jobs and also on the issues during project work.
• Reporting:
• Monthly performance measurement, resource utilization, bench cost, project profitability reports
• Worked on financial modeling and forecasts, designed and developed complex revenue and profitability reports.
• Designed and automated complex monthly invoicing routines.
• Monthly RRB -resource related billing through SAP (SD).
• Financial Modeling and Forecasting.
• Revenue Analysis by practice area, service type and contract type.
• Wrote more than 30 Macros for MS Excel to automate data capture for T&E, Cash Application, Printing of invoices, Month end reporting.

Confidential, Cedar Rapids, Iowa

Graduate Intern, Internal Audit

Responsibilities:

• Assisted in analysis of Attack and penetration testing of 15 SIDs using the AppDetective Pro* software.
• Tested controls on Revenue cycle using AutoAudit* (automated auditing software).
• Performed reconciliation and review of approved deviations to IT policy.
• Assisted in drafting tests and mapping of the tests with objectives and controls over fraudulent activities.
• Evaluation of HR On-boarding process.

Confidential, Columbus, IN

Financial Consultant

Responsibilities:

• Provided functional consultancy to develop reports of BizRights™ software of Approva systems for: SOD, User Profiles, Financial Controls.
• Performed QA of logic of the rules
• Performed validation testing of the rules output.
• Performed testing of internal controls at Cummins Inc.
• Determination of significant controls on the basis of Control Matrix for various cycles - Inventory, Direct / Indirect Expenses, Payroll, Fixed Assets, Revenue, Month Close.
• Drafted test plans and performed testing & documentation of results based on the Significant Control Analysis
• Testing of Small Independent Applications and Baseline reports for the accuracy of reporting.
• Management reporting - bi-weekly reporting to evaluate location performance.
• Technical / Automation - Automated the testing documentation by writing Macros in excel, thus saving time & cost and achieved standardization of the documentation
• Provided consultancy and performed due diligence audit for a private investment in a software consultancy company
• Refined HR policies with a special consideration to internal control and operating efficiency aspects

Confidential

Financial Accountant

Responsibilities:

• Successfully managed the acquisition of local operations of IT services company
• Successfully integrated, within 2 months, the operations, HR and chart of accounts of the acquired entity
• Handled month close and reporting of monthly results to the management. Also handled the routine accounting, intercompany reconciliations and audits
• Did automation and development of reports viz.- Automated MIS and accrual reports