Sr.sap Fi/co Consultant Resume
Detroit, MI
PROFESSIONAL SUMMARY
- Senior SAP FI/CO Consultant with 10 years of IT experience 7 years SAP experience playing various key roles in design, development, and implementation of business applications.
- Expert level Project Management skills that includes working with user community understanding their business needs and developing strategies to implement them.
- Work experience includes combination of conceptual design of systems and collecting business requirements from users.
- Responsibilities included the project preparation, understanding the existing business and requirement gathering, organizing workshops.
- Analyzing AS-IS process and suggesting the best practices and appropriate solutions for the whole Financial Accounting through Gap analysis.
EDUCATION
- MS (Computer Science), Long Island University, Brooklyn Campus , New York City
- BS (Computer Science), Jawaharlal Nehru Technological University, Hyderabad , India
TECHNICAL SKILLS
- ERP : SAP R/3 FI/CO, Solution Manager
- OLAP : SAP BW 3.1C/3.0B/2.1C
- Languages : ABAP/4, C, C++, SQL, PL/SQL.
- RDBMS : Oracle 7.X, 8i, MS-SQL Server, MS Access.
- Operating Systems : Windows 95/98/NT/2000, UNIX, LINUX
- Reporting Tools : BEx Analyzer and Web Application Designer.
- Web Technologies : HTML, DHTML, ASP.
- Front End Tools : Visual Interdev 6.0, Visual Basic 6, Developer 2000
SAP Expertise Areas
- Completed 4 full life cycle implementations using ASAP methodology.
- Experienced in Configuration and Customization
- FI expertise includes General Ledger (FI-GL), New General Ledger (FI-GL) Accounts Payable (FI-AP) ,Accounts Receivable (FI-AR), Credit Management, Asset Accounting (FI-AA) and Special Purpose Ledger (SL). Taxation Procedures - TAXUSJ, VAT configuration, interface configuration of third party software Vertex, Sabrix .FI integration with other SAP modules particularly Material Management (MM), Sales and Distribution (SD) and Production Planning (PP).
- CO expertise includes Cost and Revenue Element Accounting (CO-CEL), Cost Center Accounting (CO-CCA) Profit center Accounting (CO-PCA), CO-Internal Orders (CO-IO). CO-Product costing (CO-PC), Profitability analysis (CO-PA) and, Project Systems (PS).
- Proficient in LSMW, CATT program and Info pack.
PRJECTS
Confidential,Detroit, MI (Full Life Cycle Implementation)
Duration: January 2011 – Current
Role: Sr.SAP FI/CO Consultant
Software: SAP ECC 6.0
Description:
General Motors, one of the world\'s largest automakers, traces its roots back to 1908. With its global headquarters in Detroit, GM employs 209,000 people in every major region of the world and does business in more than 120 countries. GM and its strategic partners produce cars and trucks in 31 countries, and sell and service these vehicles through the following brands: Baojun, Buick, Cadillac, Chevrolet, FAW, GMC, Daewoo, Holden, Isuzu, Jiefang, Opel, Vauxhall, and Wuling. GM\'s largest national market is China, followed by the United States, Brazil, the United Kingdom, Germany, Canada, and Russia. GM\'s OnStar subsidiary is the industry leader in vehicle safety, security and information services.
Responsibilities in FI/CO:
- Studied and analyzed the enterprise structure of existing systems and business processes related to General Ledger, Cost Element Accounting, Cost Center Accounting, Profit Center Accounting, and Profitability Analysis (COPA).
- Analyzing AS-IS process and suggesting the best practices and appropriate solutions for the whole Financial Accounting through Gap analysis for SAP ECC 6.0.
- Designed SAP system for General Motors for North America.
- Worked on Vin by Vin Revenue Recognition (VbVRR) .Recognizing revenue generated by VIN.
- Worked on Limited Risk Lease (LRL) for Canada and Multi Element (ME) for U.S.
- Worked on RICEF objects for inbound interfaces to SAP, Out bound Interfaces from SAP and Enhancements.
- Worked on Functional Design documents (FDD) for interfaces, reports.
- Worked on exchange rate interface maintaining average rates for North American co. codes.
- Worked with Technical team to resolve the issue for all interfaces, enhancements and reports.
- Used LSMW for creating master data for General Ledger (GL) account, Cost Centers, and Profit Centers.
- Created derivation rules in COPA module.
- Did a data mapping from COPA to BW
- Created summarization levels for COPA data extract to BW.
- Helped BW team in creating COPA data source to BW.
- Worked with BW team to develop GL, Financial and COPA reports.
- Worked on Unit, Integration and performance testing.
- Developed test scripts for Unit, Integration testing and executed all the test scripts using quality center tool.
- Worked with the technical team in resolving defects came from testing.
- Worked on performance testing with technical teams for Average, Peak, and Hi peak loads of interfaces which are coming to SAP.
- Working knowledge quality center tool.
- Knowledge of Vehicle Management System (VMS) for Automotive industry.
- Developed UAT (User acceptance testing) scripts and manuals for end users.
- Trained users on SAP.
- Helped users in reconciling legacy data to SAP.
- Worked on validating data loads for Sales model code (Materials), Vehicles.
- Worked on cut over activities
- Did Go – Live.
Confidential,Arlington, VA (Full Life Cycle Implementation)
Duration: March 2010 – September 2010
Role: Sr.SAP FI/CO Consultant
Software: SAP ECC 6.0
Description:
The AES Corporation is a global power company with generation and distribution businesses.Through diverse portfolio of thermal and renewable fuel sources, AES provide affordable and sustainable energy in 30 countries. Workforce of 27,000 people is committed to operational excellence and meeting the world\'s changing power needs.
Responsibilities in FI/CO:
- Studied and analyzed the enterprise structure of existing systems and business processes related to General Ledger, Accounts Payable, Accounts Receivable, Banking, Taxes, Asset Accounting, Cost Element Accounting, Cost Center Accounting, Profit Center Accounting, and Internal Orders.
- Analyzing AS-IS process and suggesting the best practices and appropriate solutions for the whole Financial Accounting through Gap analysis for SAP ECC 6.0.
- Implemented SAP FI/CO for 32 company codes across US using ASAP methodology.
- Designed SAP system for WIND businesses using global template.
- Created BPD’s (Business Process Documents) for FICO modules.
- Configured the system using global template.
- Helped MDM team in configuring enterprise structure which includes Creating Company Code, fiscal year variant, posting period variant, assigning currencies, assigning chart of accounts and controlling area.
- ECC 6.0 New GL: Configured the SAP system for the New GL Functionality. Activated new GL.Created leading ledge and 4 non – leading ledger’s (US GAAP,Local GAAP,Local Tax,IFRS)
- Configured intercompany relation using OBYA.
- Worked on mapping legacy GL accounts to SAP accounts.
- Helped MDM team in creating GL accounts using MDM (Master Data Management) tool for 32 Co. Codes.
- Accounts payable: Created vendors, configured payment program which includes creating house banks, account id’s, ranking orders and payment methods.
- Designed and created FDS (Functional Design Specification) for new checks for Citi, Comerica and Bank of America accounts.
- Configured EDI partner profile and payment methods to house bank.
- Accounts Receivable: Mapped legacy customers to SAP .Created customers in SAP. Configured tolerance groups for customers.
- Banking: Configured Electronic bank statement for all the bank accounts.
- Set up VAN connection (Fides & Citi bank) interface from SAP to Banks to send electronic payments and receive electronic statements
- Configured search strings for Electronic bank statement.
- Asset Accounting: Worked with team member in configuring chart of depreciations, depreciation areas, derived depreciation for all the parallel ledger postings, take over date, settlement profile.
- Taxes: Configured Input & Output taxes codes for US (State/county/city/district) for sales and purchases.
- Cost Center: Designed cost center hierarchy for the Wind business.
- Created cost centers through upload program.
- Profit Center: Designed profit center structure to meet the business requirements.
- Created profit centers through upload program
- Internal Order: Worked on capital internal orders.
- Settling internal order to AUC (Asset under Construction) to fixed asset.
- Worked with business user to develop functional specifications for BW reports.
- Worked with testing team on Unit, Integration and Regression testing.
- Did User acceptance testing & training (UAT).
- Worked with business users on data mapping from legacy system (Solomon) to SAP.
- Worked with business users in filling the data in load templates for GL balances, Vendor balances, Customer balances, outstanding checks & deposits, Assets, Cost center, profit center actual and plan data.
- Performed pre validation of data and data cleansing activities.
- Performed MOCK1, 2, 3 data conversion.
- Did Go – Live.
- Worked post go live activities in validation and reports for user sign off.
- Worked on post production support for issue resolution in hyper care period
Confidential, Columbus, OH
Duration: July 2008 – December 2009
Role: Sr.SAP FI/CO Consultant
Software: SAP ECC 6.0
Description:
Big Lots is nation\'s largest broad line closeout retailer, Big Lots has the power to negotiate the best deals in the business. We sell a broad range of high-quality, brand-name products, including consumables, seasonal items, furniture, house wares, toys, electronics, home décor, tools and gifts.
Responsibilities in FI/CO:
- Responsibilities included the project preparation, understanding the existing business and requirement gathering, organizing workshops.
- Analyzing AS-IS process and suggesting the best practices and appropriate solutions for the whole Financial Accounting through Gap analysis for SAP ECC 6.0.
- Conducted the Workshop’s documented processes throughout the blue print stage.
- Created PDD’S (Process Definition Documents) for business process.
- Designed and Created Inbound and Out bound Interfaces for General ledger Accounting, Accounts Payable, Asset Accounting, Cost Element Accounting and Cost Center Accounting.
- Designed and created enhancements for Duplicate Invoice Check Accounts Payable and adding Segment and State fields Asset Accounting Modules.
- Designed and created data conversion strategies for Accounts Receivable and Asset Accounting modules which included open AR conversions and asset master data conversion.
- Created functional specification for custom repots in FI modules.
- Configured the system for Asset Accounting Module and Accounts Receivable.
Confidential,Chicago, IL
Duration: February 2008 – June 2008
Role: Sr.SAP FI/CO Consultant
Software: SAP ECC 5.0
Description:
Altivity Packaging is a leading producer of coated-recycled boxboard and manufacturer of primary packaging products including folding cartons, bag packaging and flexible packaging for a variety of consumer and industrial companies. Altivity also produce a full-line of high quality, decorative gift boxes for the mass market gift department stores and retail establishments.
Responsibilities in FI/CO:
- Worked on merger of Field Container to Altivity Packaging.
- Configured the system for the merger.
- Supported business community in day to day activities like Asset Master record creation. Asset Acquisition from Project System, Asset retirements by scrapping , Asset transfers within the co. codes and Asset transfers between the co. codes, Depreciation run and month end closing activities.
- Helped the business in creating projects, WBS elements and settling the WBS elements to fixed assets.
- Resolved business related issues in AM and PS modules.
- Helped the management to run the reports for Tax and Book audit.
- Resolved the configuration related issues.
- Good knowledge & experience of Asset Management integration with Project System module.
- Worked on bringing the data from legacy system to SAP
- Mapped the existing legacy system (FAS) Fixed Assets to SAP
Confidential,WA
Duration: August’2007 – October’ 2007
Role: Sr.SAP FI/CO Consultant
Software: SAP ECC 6.0
Description:
Corbis is a creative resource for advertising, marketing and media professionals worldwide, helping to bring creative work to life with the highest quality photography, footage and rights services. Corbis serves more than 50 countries worldwide.
Responsibilities in FI/CO:
- Responsibilities included the project preparation, understanding the existing business and requirement gathering, organizing workshops.
- Analyzing AS-IS process and suggesting the best practices and appropriate solutions for the whole Financial Accounting through Gap analysis for SAP ECC 6.0.
- Conducted the Workshop’s documented processes throughout the blue print stage.
- Created PDD’S (Process Definition Documents)for business process
- Configured the system for AA(Asset Accounting)
- In Asset Accounting (AA) configured chart of depreciation, depreciation areas, asset classes, created screen layouts for asset master record, asset acquisitions, asset retirements, asset transfers.
- Configured Controlling area settings to address management accounting requirements of organization
- Performed Unit and Integration Testing.
- Created BPP’s (Business Process Procedures) and Training manuals.
- Conducted the UAT (User Acceptance Testing).
- Trained Super/User’s on SAP FI/CO.
- Worked with Security Team in defining user security roles.
- Worked with Basis Team in moving the transports from Dev (development) client to QA and Prd (Production) client doing the system validation and checks.
- Created the Functional Spec. for Data Migration.
- Created LSMW program for Data Migration.
- Performed the data loads for all the company codes.
- Did pre Go-Live activities.
Confidential,St.Louis, MO
Duration: December’ 2006 – June’ 2007
Role: Sr.SAP FI/CO Consultant
Software: SAP R/3 4.6c
Description:
Monsanto is an agricultural company. Monsanto has multiple locations around the world. The locations are variously administrative and sales offices, manufacturing plants, seed production facilities and research centers – all part of the corporate focus on agriculture and supporting farmers.
Responsibilities in FI/CO:
- Studied and analyzed the enterprise structure of existing systems and business processes related to General Ledger, Asset Accounting, Cost Element Accounitng, Cost Center Accounting, Project Systems integration with AA module and Archiving.
- Configured new company code for General Ledger, Asset Accounting ,Cost Element Accounting and Cost Center Accounting for SAP 4.6c
- Configured global settings and settings for GL master data and transactional data.
- Assigned the new co. code to Special Purpose Ledger (FI-SL), Created number ranges.
- Configured US chart of Depreciation, Mapped the existing Account Determination, Number Range Interval. Asset class and Depreciation Areas.
- Worked on Transfer of assets like Inter Company Transfer and Intra Company Transfers.
- Worked on retirement of asset scenarios like Retirement by Scrapping.
- Working knowledge of creating different kind of profiles related to PS Module, WBS elements, Network and their Activities, cost planning and cost centers.
- Supported the user’s PS related issues in day to day business activities.
- Developed the CATT program for data load changes.
- Created Cost Centers and Cost Elements.
- Configured CO Versions.
- Configured Derivation rule in CO-PA.
- Worked on Archiving project.
- Helped the archiving team to configure archive objects.
- Tested archive objects FI_SL_DATA, PCA_ITEM and IDOC are which includes validating the data before archiving and after archiving.
- Worked on Internal Orders.
- Worked on project to pull sub ledger balances from SAP system.
- Worked on developing Functional Design Specifications to develop custom programs and enhancements.
- Provided support to the end users in solving issues in asset accounting module.
- Involved in User Testing and Training.
- Experience working with Solution Manager
Confidential, Charlotte, NC
Duration: August’ 2006 – October’ 2006
Role: SAP FI/CO Consultant
Software: SAP R/3 4.7
Description:
Coats, the world\'s largest manufacturer of industrial sewing thread and consumer needlecraft products.
Responsibilities in FI/CO:
- Responsibilities included the project preparation, understanding the existing business and requirement gathering, organizing workshops.
- Analyzing AS-IS process and suggesting the best practices and appropriate solutions for the whole Financial Supply Chain Management through Gap analysis,
- Documentation and other processes throughout the blue print stage.
- In Accounts Payable identified the types of vendors and the mode of business and Branches and head office issues, trading partner.
- In Accounts Receivable Suggested the best solutions SAP can deliver for the types of
customers, Lockbox configuration. Identified some special requirements for customer
payments, outgoing Invoices and credit, debit memos.
- Gathered the requirements for Dunning and Account Receivable reports.
- Worked in SD-Billing for credit card processing and also for pricing procedures.
- In Taxes Gathered the requirements on existing tax system.
- Conducted workshops on Input & Out put taxes.
- In Vertex Worked on the Vertex tax tool to automate the tax process for the organization.
- In Product Costing Analyzed the existing process of product costing by visiting the plants
and understood the whole manufacturing process through which decisions are taken what
type of costing is to be used for the products.
- Conducted blueprint workshops for whole Product costing (Standard Costing) for the
products up to WIP calculation, variance settlement for Discrete manufacturing.
Confidential, Kohler, WI
Duration: April’ 2006 – May’ 2006
Role: SAP FI/CO Consultant
Software: SAP R/3 4.7
Description:
Kohler Co. is a worldwide leader in plumbing products. Unparalleled product design and innovation have led the way to a diverse portfolio of respected brand names with operations on six continents. As a team member involved in the Enhancements and Production Support on
FI/CO Modules.
Responsibilities in FI/CO:
- As part of Production Support on SAP ‘s Enterprise Version 4.7 successfully solved the
critical issues arising from dialy business activities.
- Solved the various challenging Business Process issues in Finance and Controlling Modules
- Worked on Credit Management Issues.
- Redefined customer returns process in order to capture and reflect exact inventory status and automate customer credit process
- Resolved credit issues relating to open sales orders and open deliveries.
- Involved in correcting the credit accounts of customers.
- Developed Custom reports for comparing FI and COPA values.
- Worked with business and super users to develop specifications for various product cost planning and cost center custom reports and worked with the technical in developing and testing these reports
Confidential,Columbus, OH
Duration: January’ 2006 – March’ 2006
Role: SAP FI/CO Consultant
Software: SAP ECC 5.0
Description:
Limited Brands is a worlds most admired companies in the specialty retail industry.
As a team member involved in the Customization and Production Support of the Banking and Cash Management (BCM) and Sales Audit (SA) of FI/CO Modules. Interacted with Clients Business Users for requirements.
Responsibilities in FI/CO:
- As a part of Production Support on SAP’s new version 5.0 successfully solved the critical issues arising from different banking issues and daily business activities.
- Supported on the ongoing Phase II implementation for Sales Audit (SA).
- Solved the various challenging Business Process issues in Cash Concentration, Cash Position, and Liquidity Forecast.
- Resolved the Configuring issues for Posting Rules for different Banking Activities, Mapping of External transaction codes
- Master data, business transactions, Cash flow, Electronic bank reconciliation, Check deposit. Configuration of relevant settings i.e. Settings for Treasury, Electronic Bank Statement, Bank Reconciliation, GL and Sub Ledger Master Data Settings,
- GL -Bank Account Integration Manual Check Post Processing running of test scripts
- Worked on populating transaction codes to identify the line items
- Increased the tolerance limit of Auto Clear Program.
- Worked on prior day check file issues
- Involved in ACH scenarios
- Successfully resolved the issues of the tedious Month End Closing Process.
- Developed BCM Metric to identify number of manually cleared items to automatically cleared one.
- Developed BCM reports as per the user requirement like Bank Balancing Report, RED X for BAI file, and Store over Short Report and report to check POS items.
- Identified a new report which increases efficiency of the system.
- Involved in solving the all issues from Real-Time integration of Treasury module with SA modules
- Involved in checking the Internal Controls and Self Audit.
- Experienced in working in Sarbanes Oxley Environment.
- Conducted training programs for team members and end users. Also developed training concept decks, end user documentation, cheat sheets and process narratives.
Confidential,Detroit, MI
Duration: July’ 2005 – October’ 2005
Role: SAP FI/CO Consultant
Software: SAP R/3 4.7
Description:
Covansys Corporation is a global consulting and technology Services Company offering industry-specific solutions, strategic outsourcing, and integration services.As a team member involved in the customization and implementation of the CO Module. Interacted with Client Business Users for requirements.
Responsibilities in FI/CO:
- In Accounts Payable (AP) Supported AP Team.
- Worked on vendor master records, account groups, defined client
- Specific payment terms, vendor invoices, manual incoming/outgoing payments, automatic Configured House banks, Payment methods, Payment terms and Payment run Configuration.
- Implemented the Check and Wire transfer payment process and customized the forms for checks and wire transfer.
- Worked closely with MM for AP.
- In Asset Management (AM): Handling of Fixed structured and valuated Assets,
- Customizing Chart of Depreciation
- Creation of Depreciation areas, Depreciation keys, asset classes.
- Configured and customized asset master as per the user requirement.
- Worked on Statistical (rebillable) and internally developed software assets.
- Captured Purchase Order (PO) number in asset master from Material Management (MM) and Sales Order number from Sales and Distribution (SD).
- Acquired assets through Purchase Order (PO) and with Vendor
- Performed Planned , Unplanned , Restart and Repeat Depreciation runs
- Created and settled asset under construction (AUC)
- Worked on Intra-company asset Transfers.
- Retirement of assets With Customer, Without Customer and by Scrapping.
- Worked on parent child relation (Asset Super Number) scenarios.
- Tracking of assets through asset number, asset class, cost center, location and plant.
- Performed the Fiscal year change and Year end closing.
- Standardized and organized the report structure, developed the reports as per the user requirements.
- Designed and developed Business Process Procedure’s (BPP’s) and Test Script’s for user training.
- Conducted User Testing after the implementation and supported the client in post launch
session.
- Performed Integration testing, Unit testing.
- Performed legacy data transfer from Legacy System to SAP through LSMW program.
- Go-live and Support.
Confidential,Dallas, TX
Duration: April’ 2005 – June’ 2005
Role: SAP Practice
Description:
- General Ledger (FI-GL), New General Ledger (FI-GL) Asset Accounting (FI-AA), Accounts Payable (FI-AP), Accounts Receivable (FI-AR) and Special Purpose Ledger (SL). Taxation Procedures – TAXUSJ.
- Cost and Revenue Element Accounting (CO-CEL), Cost Center Accounting (CO-CCA), CO-Internal Orders (CO-IO). CO-Product costing (CO-PC), CO-Profitability analysis (CO-PA) and Profit center Accounting (CO-PCA),
Confidential, Chicago, IL
Duration: January’ 2005 – April’ 2005
Role: SAP Practice
Description:
- SAP BW (3.1c) in Info Cubes, Info Objects and Info Sources. Generated various Reports using Bex Analyzer.
Confidential,New York City
Duration: September’ 2004 – January’ 2005
Role: Project work for the completion of MS
ARMS (Account and Transaction Management System)
Software: ASP, VB Script, Java Script, DHTML and MS Access
Description:
The Purpose of this project is to analyze, design and develop web based banking software which can be used by the staff of the bank to perform different account related operations like ‘Account Management’, ‘Transaction Management’ etc. and also provide the customers with an easy, efficient and convenient way to maintain and manage their accounts and transactions thus reducing the customer assistance expenses of the bank.
The following components were developed as part of this project
1. Account Management: This component consist of three sub components
- Account Creation (Creating new account)
- Account Maintenance (Change of address, Change of name etc.)
- Account Closure (Closing of the account)
2. Transaction Management: This component has two sub components
- Deposits (Depositing money into different accounts)
- Withdrawals (Withdrawing money from the accounts)
3. User Maintenance: This module will have three sub components
- Create User
- Update User
- Delete user
Confidential,New York City
Duration: January ‘2003 – November ‘2004
Software: Microsoft Word, HTML
Description:
Assisting students and faculty with WebCT .WebCT have allowed in serving students whom we never would have seen in the face-to-face classroom
- The ability to easily identify, use, and re-use exceptional online content is a high priority for higher education institutions today. WebCT’s Digital content solutions make it possible for institutions to fully leverage high-quality online course content, increase the adoption of e-learning institution-wide, and boost student satisfaction with the online learning environment.
- As an important extension of e-learning systems, WebCT offers e-Packs, that are ready to use in WebCT. E-Packs provide the ideal starting point for faculty to get up and running quickly with high-quality course content. Faculty has immediate access to robust content supplements and media-rich course material that are fully customizable to meet their unique needs.
Client: School of Education, Long Island University, New York City
Duration: January ‘2003 – May ‘2003
Software: Microsoft Word, Microsoft Excel
Description:
Design and Development of Excel sheets and charts in “Project Educate” for school of education, which helped the faculty to see the progress of students in each year
Confidential,Hyderabad, India
Duration: January ‘2002 – April ‘2002
Role: Project work for the completion of BS
Software: Oracle 8i, V.B 6.0
Description:
This initiative was aimed at maintaining Database for Raj Metal Industries to promote the brand recognition and cross sell the products.
The following were accomplished as part of this campaign:
- Design and implementation of an Oracle database
- User Screens to Add/Update/Delete the Customer Information and Sales Information.
- Reporting of Customer and Sales information