Srishti Mittal
Lead Consultant SAP FI/CO
accepl@r.postjobfree.com
SUMMARY
. Over 6 years of extensive functional experience in SAP FI/CO (version
4.6, 4.7, and ECC 6.0)best practices encompassing eight projects, three
of which are full life cycle implementation from blue printing,
realization, go live to production support.. Has been part of
Implementations, Development & Production support projects and exposure
includes preparation of Project Blueprint, Configuration, Unit
&Integration Testing, Training, Documentation and Production support.
. Excellent configuration and training skills in General Ledger, Accounts
Payable, Accounts Receivable, Electronic Bank Statement (EBS), Bank
Accounting, Treasury-Cash Management (TR-CM), Cost Center Accounting,
Profit Center Accounting, & Internal Orders.
. Extensive experience in Procure to Pay (PTP) and Order to Cash (OTC)
processes. Excellent configuration skills in Electronic Bank statement
(EBS); Lockbox; and foreign exchange business processes.
. Excellent understanding of Business Processes relating to SAP Finance
(FI), Controlling (CO) and Integration with SD, PP, MM & HR modules.
Strong knowledge in GAAP and SOX Act.
. Experience in reports, conversions, interfaces, enhancements & forms
(RICEF).
. Well versed with integrating Vertex with SAP. Extensive experience in
conversions using LSMW and ECATT. Well versed with SAP security roles and
profiles.
. Extensive experience in delivering large and small group (one-on-one) end-
user training using MS visio templates.
TECHNICAL & SOFTWARE SKILLS
. ERP System: SAP 4.6, 4.7, an ECC 6.0
. SAP Financial: General Ledger/New General Ledger, Accounts Payable,
Accounts Receivable, Asset Accounting, Banking, Special Purpose Ledger,
Funds Management, Sales and Distribution, Material Management and
material ledger.
. Controlling: Cost Element/Cost Center Accounting, Internal Orders,
Product Costing (CO-PC), Profit Center Accounting (CO-PCA) and
Profitability Analysis (CO-PA).
. Applications MS visio, MS Access, MS Word, PowerPoint, Excel
. Platforms Dos, Microsoft Windows 95/98, 2000/NT/XP, Vista, Windows 7.0
. Database: My SQL, MS Access
EDUCATION:
. Bachelors of Science of Business Administration from Aspen University,
Denver, CO.
PROFESSIONAL EXPERIENCE
EDF Group Utility, San Diego, CA
June 2013 - Present
Role: Sr. SAP FICO Consultant
Implementation
Version: ECC 6.0
EDF Group is a utility company providing reliable energy efficient power
supply.
Responsibilities:
. Interaction with client business users for gathering and analysis of
requirements
. Handheld configuration tasks of the Organizational structure of G/L,
Account Group and Account type.
. Configured settings for Company code, posting period variant, assigned
document number ranges, tolerance groups for customers, vendors, G/L
accounts and users.
. Configured AP module including the vendor groups / number ranges,
automatic payment program, payment terms, withholding taxes and check
settings.
. Created and maintained customer master data along with customer
groups, payment terms, creation of house banks, assigning bank
accounts to house banks.
. Set up Treasury (electronic bank statement). Train users and document
step by step process for processing bank' BAI2 files in SAP.
. Configured required settings for asset classes, account determination,
screen layout rules, defining number ranges.
. Worked with Year End Closing and Month End Closing procedures.
. Verified the Test Scripts executed including the Month End Closing
Scripts
. Valuation of assets in different depreciation areas, asset under
construction, external asset acquisition.
. Configured the controlling area, Configured Cost Center Accounting
(CCA), maintained standard hierarchy, created cost centers, primary
cost element categories, secondary cost element categories, automatic
cost element creation, manual cost element creation, activated
reconciliation ledger.
. Used Report Writer to generate reports of profit center accounting (EC-
PCA) needed by the business owner.
. Created & Maintained Customer Master Data along with Customer Groups,
Payment Terms, Reporting, and AR Aging.
. Have worked on Partial and Residual Payment types.
. Met with mid-level and senior management to evaluate and or suggest
changes in processes that will enhance the use of SAP.
. Preparation of business process requirements, analysis and user
requirement specifications.
. Modifications of functional specifications and user exits to make them
compatible with the new version.
. Participate in super user meetings, preparation of meeting materials
and delivery of presentations using MS visio as required.
Valerus Houston, TX
Oct 2012 -
June 2013
Role: Sr. FI/CO Business Analyst
Environment: SAP R/3 ECC: 6.0
Implementation
Valerus maintains operation and Oil and Natural Gas distribution
centers in key locations around the world. They provide compression,
processing and treating services and more.
Responsibilities:
. Reviewed and analyzed Business Requirements and Business Processes and
mapped them with SAP.
. Regularly interacted with users to ensure proper understanding of the
Business Requirements and Functional specifications.
. Conducted GAP analysis, document findings, evaluated scope of studies
& suggested solutions through SAP for implementation and
customization.
. Configured chart of accounts, account groups, field status groups, and
posting keys, assigned these variants to company codes, created GL
Master records, reconciliation accounts for sub-ledgers, document
types, number ranges, invoices and payments, tolerance groups,
automatic account assignments, GL display (line item layouts, special
fields, sort variants, totals variants) and financial statement
version.
. Configured areas of AP, House Banks and Automatic Payment program
(APP). Involved in optimizing bank details for wire payments, check
lots, void reason codes and clearing inter-company vendor/customer
open items.
. Worked with MM processes like Logistics Invoice Verification (LIV),
credit debit memos, maintaining Material master data, material groups,
purchasing groups, purchasing info records, MM Pricing procedures,
etc.
. Developed and configured the Electronic bank statement procedure in TR-
CM module.
. Identified one-time Vendors and Customers and defined a separate
screen layout for them according to the requirement of the client.
. Made necessary settings for the account assignment model for Recurring
and Periodic entries, Bank master data, and House Banks for the
payment program.
. Managed multiple ledgers within the general ledger according to the
client requirements, worked on parallel accounting model following the
rules of New GL.
. Worked on EBS, Positive pay, ACH payments and Wire Transfer, and
configuring and customizing multiple payment methods and automatic
clearing.
. Created integrated asset acquisition and defined account assignment
type for Asset Account, Account Assignment Objects for the
Depreciation Areas.
. Configured the system to deduct a cash discount for payment of fixed
asset invoice automatically and in real time, to the corresponding
asset.
. Configured setting for revaluation of fixed assets, normal
depreciation run and posting of asset acquisition.
. Handed SAP finance related tickets to find the possible solution of
problems.
. Prepared Month End activities for managerial reporting purposes.
. Interaction with client business users for gathering and analysis of
requirements, written functional specifications.
Optimal Design Company, Chicago, IL
Feb 2012 - Oct 2012
Role: FI/CO consultant
Environment: ECC 6.0 (ASAP Methodology)
Optimal Design is a private company categorized under Engineering
Services. Optimal Design offers Land Engineering Services, Stress
Engineering Services, Temporary Engineering Services, Customer
Engineering Services and Engineering Services.
Responsibilities:
. Configured CO enterprise structure. Created cost center hierarchy,
cost elements (primary and secondary). Defined activity types and
statistical key figures for calculation of overheads.
. Configured COPA characteristics & value fields. Created reports out of
profitability segments.
. Configuring the basic settings, maintaining profit center hierarchy,
dummy profit center, assignments, CO-objects to Profit Centers,
distribution and assessment of costs, planning and development of
reports. Created profit center hierarchy and profit centers.
. Gathered and documented business requirements by conducting meetings
with key users and drafted business blueprint documentation. Performed
gap analysis, documented and prototyped between current business
practices and standard SAP functionality
. Designed and configured Enterprise structure with multiple company
codes (3 company codes), chart of accounts, reconciliation. Accounts,
fiscal year variant, created terms of payment and interest calculation
configuration, and reason code creation. Trained users in creating and
printing sales orders and bills.
. Configured credit management functionality. Created credit control
areas, credit risk categories and defined credit representatives
groups as per the client requirements. Prepared credit master and
assisted ABAP team in uploading credit master through LSMW.
. Configured and documented cross modular integration of FI/CO with
Sales and Distribution (SD), Material Management (MM) and Human
Resource (HR) and Payroll. Assigned G/L accounts to wage types
(&symbolic accounts) and cost centers to various positions in HR,
dealing with 3rd party vendors. Assigned G/L accounts to valuation
classes in MM and for revenue recognition in SD.
. Integrated A/P and A/R modules in FI with MM and SD respectively,
provided configuration support in MM, SD integration for account
determination of MM (Procure-to-Pay), and SD (Order-to-Cash).
. Responsible for year-end close and reconciliation of sub-ledger like
A/R, A/P and Fixed Asset.
. Developed entire Reporting for FI/CO environment (Multi-company/Multi
currency/Consolidation Reports).
. Configured automatic payment program for vendors and trained accounts
payable users in automatic payment program, vendor check printing and
creating master data. Configured FI-AP parameters for the paying and
sending company, house banks and payment methods. Configured vendor
down payment process and trained users in creating, posting down
payment and posting vendor invoice with the down payment request.
. Configured sales tax and use taxes procedures (TAXUSX), tax
jurisdiction code structure for third party tax system-Vertex. Trained
users in using vertex jurisdiction codes and tax codes.
. Configured of FI-Fixed Asset classes, depreciation areas, assigning
company codes to dep. areas, creation of screen layouts and no.
ranges, creation of dep. keys. Trained users in depreciation run,
buying and retiring assets.
. Configured all business transactions for accounts payable and account
receivables including the payment program configuration, automatic
check payment advice, payment analysis printing, clearing of vendor
and customer open items, and bank master data.
. Prepared functional specs for data conversion on customer master data,
vendor master data, G/L master data, credit master data, cost centers,
cost elements, G/L balances, vendor and customer balances. Loaded data
in SAP with LSMW.
Kyocera San Diego CA
Aug 2011 - Dec 2011
Role: Sr. FI/CO Business Analyst
Upgrade project from SAP version 4.7 to SAP ECC 6.00.
Environment: SAP R/3 ECC: 6.0
Responsibilities:
. Reviewed and analyzed the AS IS and all custom objects to test
. Participated in creation of testing strategy for upgrade
. Testing of all the transactions including interfaces and custom
reportings.
Tesoro Corporation, San Antonio, TX
July 2010 - Aug 2011
Role: SAP FICO Consultant
Version: SAP R/3 4.7, 6.0
Tesoro Corporation, a Fortune 150 company, is an independent
refiner and marketer of petroleum Products. Tesoro, through its
subsidiaries, operates seven refineries in the western United States with
a combined capacity of approximately 665,000 barrels per day. Tesoro's
retail-marketing system includes over 880 branded retail stations, of
which over 380 are company operated under the Tesoro , Shell , Mirastar
and USA Gasoline brands
.
Responsibilities:
. Studied And Understood the Changes in the Standard SAP System for the
new version and prepare change configuration scripts.
. Was a Team member of the customization and implementation group of the
FI/CO module.
. I was actively involved with upgrade team (4.7 to 6.0).
. Interacted with Business Users for Requirements Gathering and
Analysis.
. Prepared a document of all the changes made, bug fixes, revised the
Business Process Procedures to facilitate the changes during the
Upgrade.
. Supported all phases of a Project Life Cycle Including Analysis,
Design, Development, Testing, and Deployment of Solutions, as well as
Documentation, and End-User Training.
. Worked on integration testing extensively on end to end scenarios
involving cross functional modules MM & SD.
Activated costing based Profitability Analysis (COPA) to report
profitability by customer, product, and market. Monitored actual data flow
from SD Billing Documents and FI. Generated Profitability reports using
forms
. Did extensive configurations in Procure to pay process involving
Logistics Invoice verifications & MM-Purchasing.
. Configuration of New G/L and created Blue Print for New G/L, Plan of
Migration, Tested and Performed Migration.
. Activated New General Ledger, Created Leading and Non Leading Ledgers
for the different Company Codes and activated Parallel Accounting for
the Different Accounting Principles like US GAAP and other countries.
Modeling, development, and enhancement of SAP FSCM business scenarios
in Credit Management and Collections Management.
. Configured Material Cost Estimate with Quantity Structure and
calculated costs on Production Order, Standard and Modified Cost
Estimate and worked on Price Update.
. Configured Costing Variant, Valuation Variant, Cost Component Split,
Cost Component Structure, BOM and Route Settings.
. In Cost Object Controlling configured Product Cost by Order, WIP
calculation and Variance Analysis using Planned and Actual Costs
. Configured Cost Center Accounting (CCA), maintained standard
hierarchy, created cost centers, primary cost element categories,
secondary cost element categories, automatic cost element creation,
manual cost element creation, activated reconciliation ledger.
. Created Cost Center groups and Cost Centers, Primary and Secondary
Cost Elements.
. Used Report Painter, Report Writer for reporting during the
implementation of the project and developed reports.
Process Journal Entries thru the use of SAP 4.7 system & Month end
reporting.
Chubb Group of Insurance Companies, Warren, NJ
July 2009 - May 2010
Role: FI/CO Business Analyst
Environment: R/3 4.7, 5.0
For nearly 130 years, the Chubb Group of Insurance Companies has been
delivering exceptional property and casualty insurance products and
services to businesses and individuals around the world. Today, the
11th largest property and casualty insurer in the United States and have
a worldwide network of some 120 offices in 27 countries staffed by 10,100
employees.
Responsibilities:
. Analyzed and documented business requirements .Gap analysis,
configuration and end-user training. Creation of G/L accounts and
determining MM & SD automatic assignments.
. End user support and resolving production issues in G/L, A/P, A/R,
CCA,& PCA
. Technical specs for financial reporting and enhancement in existing
reports. Job setup for automated bill printing every night.
. Added characteristics and value fields to operating concern for
additional reporting. Developed profitability segments such as
customer groups, product groups, customer zip codes and product
hierarchies for analyzing profitability results. Mapped SD pricing
procedure and direct postings from FI/MM modules to value fields in CO-
PA.
. Worked with MM processes like Logistics Invoice Verification (LIV),
credit &debit memos, maintaining Material master data, material
groups, purchasing groups, purchasing info records, MM Pricing
procedures, etc.
. Managed investment trades and portfolio analysis.
. Configured FI-MM account determination assigning valuation areas to
valuation grouping codes, defining valuation classes, account grouping
and account determination.
. Integration of FI with MM and SD modules, Fine-tuning interfaces with
FI GL, AP, and AR including validation / substitution rules.
. Responsible for year-end close and reconciliation of sub-ledger like
A/R, A/P and Fixed Asset.
. Configured account assignment category for MM by Valuation Class. Used
various processing keys such as GBB and BSX for account determination.
. Configured Account Assignments for MM (OBYC) and SD (VKOA) for
integration purposes.
. Configured additional reason codes for customer under payment
processing. Resolved end user issues and training on customer master
and dunning procedure.
. Maintained CCA standard hierarchy, cost element groups, cost element
categories like primary cost element group and secondary cost element
groups, activity type groups and statistical key figures. Maintaining
settlement structures, configuration of assessment, distribution and
reposting and also segments and cycles. Cost center planning, manual
and automatic planning of SKF, activity types, accrual calculations,
setting planner profiles, planning areas, and creation of planning
layout using report writer/painter.
. AR-customer transactions, Master data, credit management credit limits
for customers, processing sales documents, automatic credit control
checks, settings for risk management check for receivables, payment
terms, Cash application, Incoming Payments, Dunning, Interest
Calculation, Open item clearing, Credit Management Lockbox processing,
Mapping Bank Lockbox format with Sap lockbox format, Customizing
payment advice notes. Classifying deductions with reason codes and
reason code conversion program. Processing unidentified, on-account
and partial payments and Clearing customer accounts through various
transactions.
. Hands on experience with EBS (Electronic Bank Statement), Credit
Management
Customized new vendor master data, payment terms, payment methods and
house bank details in Accounts Payable (AP).
. Defined posting keys and assigned business transactions for Manual
Bank statement and Check deposit.
. Successfully executed Month end, quarter end and Year end activities
. Configuration and Vendor master setup for Evaluated Receipt
settlements (ERS) with logistics invoice verifications.
KLA-Tencor, San Jose, CA,
July 2008 - June 2009
Role: FI/CO Business Analyst
Environment: R/3 5,0
KLA-Tencor Corporation is the world's leading supplier of process control
and yield management solutions for the semiconductor and related
microelectronics industries with $1.5b revenue.
Responsibilities:
. Worked on AP and Banking modules in SAP along with integration
testing.
. Involved in analyzing the Client's current Business process,
Gathering the Business requirement, designing the blue print for
the SAP specific reconciliation business process, Configuring system
. Involved in successfully completing the Unit & Integration testing
and solved the SAP & Business process issues in Go-Live Phases for
multiple scenarios with multiple currencies
. Developed a comprehensive analysis of client's current data usage,
Business process improvement and future needs. Utilized flow
diagrams for better understanding and documentation
. Led the discussions on Bank Reconciliation and file transmissions
with CITI bank technical officials
. Facilitated real time integration of AP, AR, SD & MM modules using
FI reconciliation functionality and documented the interdependencies
between business processes
. As a part of Go-Live Phase, responsible for documenting and
conducting the unit test (module) scripts to test the functionality
of the system with respect to the configuration design. Also
developed and performed Integration tests (cross-module) to test the
robustness of the system