CA Sumit Gautam Mishra
Senior Consultant- SAP FICO
*-*************@*****.***
Executive Summary
o Finance professional with 9 years experience including 5.5 years in
IT and 3.5 years of functional experience encompassing a wide range
of skill set, roles industry verticals.
o Experience with analysis, design, development, customizations and
implementation of SAP (ERP) Applications.
o Strong Functional/Configuration knowledge of SAP FI. Worked
extensively in the areas of FI like FI-AP, FI_AR, FI-GL, FI-AA, FI SD
and FI- MM Integration, Intercompany Transactions, Electronic Bank
Statements, Taxation-TAXUSX (External Vertex) and TAXUSJ.
o Worked extensively on design and architecture for client requirement
in SAP and translating business requirements to technical
requirements and architecture.
o Wide range of industry exposure during audits like Banking, Real
estate, Insurance Aviation, Manufacturing & Hospitality industry.
o Worked on ASAP methodology, Understanding of "As Is "Business
processes. Worked on Blue printing, Design, Build, Test, Training and
Cutover Activity. Data and System validation for pre Go-live and post
Go-live.
o Strong Techno-Functional knowledge in writing Function specification
documents; Working on interface files and setting validation and
substitution rules, IDOC processing etc
o Worked in Multiple SAP Roll Outs in various regions as per the Global
Template.
o SAP AMS engagements-Worked in all stages of AMS engagements from
transition to steady state
o Experiences with Unit Testing (UTR), User Acceptance Testing (UAT),
Regression Testing, Integration Testing, Performance Testing.
SAP Skills
ERP: SAP R/3 4.7c/, ECC 5.0/ECC 6.0 (FI, CO, SD, MM, GL, New GL, AR, AP,
AA, IO, CCA, PCA, Banking,GM,FM)
Professional Experience
NOV 08 - Present, Senior Consultant SAP- FICO IBM GBS, Columbia, South
Carolina, USA
Presently I am working in the role of Senior Consultant SAP FICO and I am
responsible for all the FI related issues arising in SAP Application in the
areas of General Ledger, Accounts Receivable, Accounts Payable, Inter
Company Transactions, Asset Accounting, Funds Management, and Grants
Management
SAP Projects
State of South Carolina Project, Columbia, South Carolina September 2012
till date.
The South Carolina Division of State information Technology (DSIT), a
Division of SC State Budget and Control Board, is responsible for the
operation and support of South Carolina's SAP Enterprise Resource Planning
(ERP) system.
Role & Responsibilities- SAP FICO Lead
o Managing a team of 5 members working on-site and offshore (India)
o Reporting to PMO for the day to day activities and projections for
the week ahead.
o Handling all the management reporting as per the project requirement
and ensuring that work is performed as per the defined SLA's and
norms laid down for the AMS Finance team.
o Resolving the issues assigned to Finance Team and giving valuable
inputs to the work done by team member
o Direct face to face interaction with Client and catering their
requirements.
o Providing first hand support to crucial requirements from day to day
operations.
o Performed support role for client's business users to solve their day
to day system problems.
o Working on the Enhancements (DR's) and configuration Changes (CR's)
assigned to our team
Estee Lauder Project July 2009 to Aug 2012
Estee Lauder Companies Inc. this technologically advanced, innovative
company has gained a worldwide reputation for elegance, luxury and superior
quality
Estee Lauder products are sold in more than 135 countries and territories
with over 25,000 products in the brand portfolio.
IBM was awarded a Global Blue Print, detailed design, implementation hyper
care and the production support for the Estee Lauder Companies Inc.
During my tenure of more than three years I had an opportunity to work in
the various phases of the project and in various capacities.
1.1 Estee Lauder Global AMS Finance Team April 2011 to August 2012 Melville
New York
Roles & Responsibilities- SAP FI Onsite Lead.
o Handled all the management reporting as per the project requirement
and ensuring that work is performed as per the defined SLA's and
norms laid down for the AMS Finance team.
o Working on Development requests and the change request arising from
the markets which have already go live.
o Handled all the client communication and worked as the point of
contact for all the communication from the offshore team
o Represented team in the change control meeting for moving defect
related to the changes in the production.
o Worked with the Sales and Distribution team on Development request of
the creation of the New Billing Type
o Worked on the Development request of the creation new customer
invoice form.
o Core team member for the Global Intercompany command center which
monitors all the issues and developments in the Estee Lauder
Intercompany Scenarios.
o Taken a lead to Prepare QRG (Quick Reference Guide) Document to
strengthen the power user community and to reduce the inflow of the
incidents created.
o Implemented CIP's (Continuous Improvement Plan) for the process
improvements which reduced the inflow of the incidents by 20 percent
in the Finance area.
o Provided Hyper care at the time of Go live and documented all the
knowledge transfer sessions.
1.2 Estee Lauder Global Roll out Implementation Project July 2009 to April
2011 Noida, India
Roles & Responsibilities- SAP Finance Implementation Team Member
o Worked in Design team for the setting up the intercompany factoring,
reverse factoring and netting process.
o New Gl configuration- Document splitting set up, Setting up non
leading ledger and localization
o Electronic Bank Statement Configuration.
o Worked from Functional Team in forms Designs as per the Regional
Requirements with technical team- SAP Smart forms and Adobe forms.
o Configuration of A/R and A/P module: Credit management, Tolerance groups,
Open item clearing, account group creation, line layout configuration for
sort key, terms of payment, configuring accounts for outgoing
payments/incoming payments and open item clearing, reason codes
configuration, Configuring Automatic Payment Program, interest
calculations on open items, Foreign Currency valuation.
o Asset accounting configuration: Setting up Asset classes, Depreciation
Areas, Depreciation Keys, and Automatic Account Assignments etc.
o Development of the Functional Specs for the new development and custom
objects and fixing the defects arising during the course of
implementation.
o Worked with the technical team in the interface design and testing as per
the business requirements from the third party applications.
o Handled go live from the Melville, New York at the time of Go Live
and provided the knowledge transfer to AMS team
SAP Functional Implementation Project- IBM Internal. Nov 2008 to June 2009
This was the IBM internal End to End implementation project
Key Responsibilities Included.
o Business Process mapping and creation of as is documents.
o GAP Analysis
o Blueprinting
o Independently handled the end to end Accounts payable process.
o Testing- Unit Testing, Integration Testing & Regression testing.
o Preparation of End user Training Material.
Nov 07 - Nov 08, Business Analyst, R Systems International Ltd, Noida Delhi
NCR, India
R Systems is a CMM Level 5 & PCMM Level 5 Information Technology Company
having global presence across several countries.
TMA Resources Inc Data Integrity Project. Nov07- Nov08
ERP solution for Member centric organizations (Versions TIMSS 5, TIMSS 6 &
Personify)
Roles and Responsibilities- Business Analyst
. Ensuring all the financial transactions routed in systems of clients
based in U.S.A, Canada & U.K are in compliance with their reporting
requirements.
. Auditing database of client for financial integrity and advising
solutions to fix the errors scenarios.
. Ensuring quality of project deliverables and management of issues
related to quality.
. Looking into Accounting aspects during data migrations projects and
checking the integrity of financial data.
. Preparing reports for client on Deferred Revenue, Revenue, Invoicing,
shipping, Accounts Receivables & Payable, Inter company Transactions
etc.
. Client interaction for requirement gathering, risk assessment,
finalization of functional specifications and responding and providing
solutions to clients on the accounting related issues on basis of
service tickets raised
. Key Achievements- Worked towards the process of improvement of
Standard Data Integrity Scripts for correction of financial data and
took initiative for the creation additional scripts with help of
programmers which helped in the reduction of delivery time to a
considerable extent & increased productivity of Data Integrity Team.
Handled all the client communication & calls in all the Data Integrity
Projects, Version Upgrade & in Process Reviews at the time of
enhancement.
Demonstrated strong problem solving skills by resolving the service
tickets raised by clients before the delivery timelines and received
the client appreciation for the same.
Feb 07 - July 07, Team Developer BA Continuum Solution Pvt Ltd (N.B.S of
Bank of America), India
. Part of Financial Reporting Team in Finance & Accounting Knowledge
Centre.
. Independently working on MIS Report
. Balance Sheet Analysis and analyzing deviations in compliance of
applicable standards prescribed (US GAAP) and reporting the same.
. Variance Analysis between Plan & Actual Nos.
. Analyzing non interest Exp of Bank and preparing monthly reports on
it.
. Preparing ADIM Reports for the analysis of salary, joining & Attrition
Details and reporting the same to Bank of America Business Units.
. Successfully handled reports from dry run to production at the time of
process migration.
Aug 04 - Feb07,Audit Manager Kumar Gaurav Agarwal & Co Chartered
Accountants New Delhi
. Ensuring statutory compliances
. Preparing Audit Reports Statutory & Internal
. Debtor Analysis & Ageing (Accounts Receivable)
. Creditors Analysis ( Accounts Payables)
. Direct Tax Advisory services to clients.
. Stock Audits.
. Ensuring the Compliance with Indian GAAP
. Tax Audits.
. Bank Audits- primarily in the area of advances & deposits
Education:
. Bachelor's of Commerce- 2001, DDU Gorakhpur University, India,
. Chartered Accountant- 2006, Institute of Chartered Accountants of
India.
. Certificate in International Financial Reporting Standards (IFRS) in
2011 from ACCA U.K
Awards
. Represented Gorakhpur University in Inter University National Debate
organized by National Cooperative Development Corporation of India at
Ujjain MP India and awarded for the speech on "Impact of Globalization
on Cooperative movement in India"
. Won Award in Nationals at the National Youth Parliament organized by
Ministry of Human Resources, Government of India.
. Secured First Rank in Board Exams in Commerce Stream held by CBSE from
in the Eastern UP region and received accolades from School and
various social organizations in Gorakhpur region.
. Gave multiple Singing Performances on Behalf of School at National
Television on multiple occasions and awarded for that.
. Selected by Popular Vote for School Captain for two years.
. Won multiple Awards at High School Level for Singing, Poetry and
Debates in Internal and External competition organized by various
organizations.
Personal Details
o D.O.B- July 1, 1981
o Gender- Male
o Marital Status-Married
o US Visa Status- H1B
[pic]