Sap Senior Co Consultant Resume
Holtville, NY
SUMMARY:
- 14 plus years of professional experiences which includes 10 Plus years of SAP Implementation experience in Financial Accounting (FI) & Controlling (CO) areas in all phases of Global End-To-End SAP implementation Projects.Designing and testing system improvements to increase productivity and reduce costs
- 10 Plus years of Functional Experience in SAP FICO and Industry Best Business Practices.
- Extensive working experience across various industries like Consumer Goods, Chemical, Pharmaceutical, Gas and Energy, Auto, Manufacturing
- Extensive experience in Business Analysis, GAP Analysis, Requirement Gathering, and Solution Delivery. Identify various integration process.Identy GAPS in early stages for an ahead of the schedule project delivery.
- Experienced with ASAP methodology including Business Process Reengineering, Feasibility Analysis, Configuration, Testing, and Training
- Expert trainer for business and end users as well as to SAP consultants in SAP FI/CO
- Good understanding with to write FD and work with developers for drafting functional and technical specifications
- Lead implementation project in Onsite Offshore Model establishing a 24/7 support and implementation model
- Excellent communication, presentation and interpersonal skills, a total team player. Self-starter with drive, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver results, even under pressure.
TECHNICAL:
- ERP Applications : SAP R/3 4.6B, 4.6C, 4.7, 5.0, 6.0 ,Business All In One
- SAP R/3 Tools : LSMW,Report Painter, Report Writer,BC Sets, Cats
- Cross Applications : EDI,ALE,IDOC,PI,CRM,BI,SOLMAN (Solution Manager),Portal,NWB
- Documentation tools : MS Word, MS Publisher, RWD InfoPak, MS Excel, MS PowerPoint,
- MS Visio
- Operating Systems : Windows 95/98/2000/NT/XP,OSX,Wiondws7
- Database : MS SQL Server, MS Access, Oracle
- Web Technologies : Flash, Dream weaver, Microsoft Front Page
- Testing Tools : Mercury QAT,HPQC,Solman,Doors,Share Point, Compass
PROFESSIONAL EXPERIENCE:
Client: Confidential,Holtville, NY
Role: SAP Senior CO Consultant Duration: Nov 11 to till date
Responsibilities/Deliverables:
- Product Costing SME:Trilogy Project Data Transformation requirement: System must transfer the Item costs from SAP (Transformation) to R12 Oracle for the following regions America,Asia,Europe,South America r
- Trilogy Descope Project Requirement : Daily standard cost updates for the existing items & new items as when creates in SAP and Quarterly Cost for the all the items updated in the quarterly cost roll interface from SAP to Oracle R12
- Customer Requirements ,Functional Specification, Peer review, FD Approvals, Technical specification ,TD Review and its approval
- Data conversion for item cost to 33 plants including following regions -Asia,EME,South America, North America
- RFC for Change Requests, Review Requirements (CR) and compare with design documents and identifying the GAPs and issues
- Development in Dev system as per the Functional specification and Unit testing with test data
- Unit Test Plans ,Unit Test result capturing and its Approvals from IT Leads
- Cross system Testing and its approval from Functional leads and Interface testing between SAP and Oracle R12 systems
- SIT test plans and steps for the SIT cycles and its approval from the IT and Functional Leads
- Helping ABAP team test cases and test data for code testing and remediation
- Design Requirements Functional ,CRQ,Incident,and technical
- Customer requirements mapping fields with oracle to SAP Design requirement (DR,CR)
- Review existing batch jobs and User roles ,its analysis and recommendation
- Review Costing folders, batch jobs, Fix scripts FTP flat files
- FD(DR),TD,,Desisgn requirement changes (IT Doors) getting approval from Sox compliance team
- Stand alone testing, ,E2E testing, Defect tracing ,Defect resolution,SIT, Cross track Testing, CAT (HPQC)
- Test Master data creation for Testing cycles SIT1,SIT2,SIT3,SIT3+,JDMODM testing etc;
- Cost runs for the single items and multiple items at plant level to test the updated cost for JDMODM items and non JDMODM items
- Approval process for unit testing and SIT testing (HPQC testing Tool)
- Sox compliance documentation (Compass )
- Costing runs, Yearend closing,Quartlery closing, Job schedules, RFC monitoring AGILE interface,
- Release rollout plan RRP for Product system environment,CAT,Rehearsal system
- Hyper care support after go live, Ticket (BMC) resolution Incident creation,CRQ,SPD
Client: Confidential,New Brunswick, NJ
Role: SAP CO Consultant Duration: April 11 to Oct 11
Responsibilities/Deliverables:
Requirement: The system must calculate a consolidated cost that excludes the intercompany profit of materials sourced from other SAP plants in a fully indented costed bill of materials
- Configuration Design documents focuses on the Product Costing functionality to be implemented for SAP ERP Central Component (ECC) v6.0 as part of the Visibility to Profitability project :
- CO-PC: A new costing variant (ZZZZ) has created and used in conjunction with an additional costing run that will calculate consolidated cost. The ZZZZ variant will be a copy of the existing C001 variant with a new costing type. The new costing type (Z9) will use the group valuation in the update section.
- The new costing variant (ZZZZ) tested both individual cost calculation and with a costing run for multiple materials
- CO-PC-ACT: Material ledger has been activated for all plants using the group valuation defined in the currency type.
- A new costing variant ZCL1 has created to calculate standard cost for clinical materials only. The costing variant will use a new costing type which will be defined with ‘No Update’ and group valuation. This will allow the cost estimates to be store in ECC and then passed to BW for reporting requirements.
- Design of a user exit or substitution rule needed to calculate the value of LC3 when a manual entry is entered into ECC or a manual journal entry upload takes place utilizing the JET tool for inventory movements
- The change to the ECC system for the internal requirements based upon field status for the fields which will now be required for certain accounts as part of the manual journal entry process. The current SAP program which performs the edit on the field values is SAPMF05A.
- Material master data elements must be updated to support calculation of consolidated cost- SPK, with quantity Structures, Material Origin, Origin Group, Price unit, Costing View.
- Configuration and Functional design documentation, peer review and approval
- Test Scripts, Unit testing the Business requirements and SIT testing and its approval
Client: Confidential,Skillman, NJ
Role: SAP RTR Team Member Duration: June 2010 to March 2011
Responsibilities/Deliverables:
- URS review with Business and gets its approval from the Business Users
- Writing Functional Specification Price Volume Mix Report ,In Transit Report, Budget Squeeze Report
- COPA:Price volume Mix report is COPA based both planned values and actual values at SKU and PCA level
- In transit Report is OPCO and SLC intercompany reconciliations
- Budget squeeze report is budgeting actual and planned values to new versions
- Templates configuration for KEPM Planning-Deduction percentages, High Gross values, list prices, sales adjustments, sales returns, standard cost
- FD Peer Review with IT and Business its approval and review with Technical team
- Technical Design peer Review and its approval for the development work in DEV system
- Test plans preparation and its approval from IT leads and Unit testing and its approval to move the code to Sit Instance
- SIT and CAT testing and Business approval the UAT
- Defects Resolutions using (Mercury QC) and Batch job set up and schedules the jobs 3 reports
- COPC:Month end closing IT support as per the Month activities related to Product costing., Creating Costing Run,Determining Material Prices,Consumption Revaluation,Closing Postings,Confirming Costing Result,CO-PA Periodic Revaluation,Marking Material Price,Releasing Material Price
- Profitability Analysis (COPA): KEPM Designs: Planning methods,Layouts,Reports,Planning levels, Planning versions, Derivations rules, Integrated Planning, data uploads from excel
Client:Confidential, Manhattan, NY
Role: Functional SAP RTR Consultant Duration: July 09 to May 2010
Responsibilities/Deliverables:
- As is studay,To Be mapping, Workshops, To be documentation and its approval
- CO-PC-Product Costing/ML/AC (Implementation) :Product costing Planning including cost component structures, Costing sheet, Costing variant, valuation variant, costing types, ,
- Activity types, Result analysis, Allocation structures, Settlement profiles,WIP,Variance keys, Target cost version, variance keys, posting rule,WIP,valuation methods, Result analysis version
- Discrete manufacturing process with production orders with make to stock/make to order
- Master data preparation in Test cycles: material master , activity types, cost centres,activity type planning,templte loads ,over heads loading,PIRs,BOM,Routings
- Loading and validation of the planned prices from business and multiple costing runs for testing
- Period end closing: Product cost estimation, Make to stock, Make to orders, Production order, Material withdrawals,WIP calculation, Costing Run and releasing cost estimates,GR,Overhead calculations, Variance calculations,WIP, Settlement Calculations
- Creating Costing run, Single/Multi level Material prices Determinations, Consumption Revalution,closing postings, confirming costing results,copa periodic revalution,marking material prices, releasing material prices, material price analysis, releasing prices material price updates periodically,SP ,Periodic prices calculations
- Configuration documentation, Test Plans, Unit testing, Integration testing, CAT testing,Approvals,Peer Review and sign off
- Functional Design specification for Update Standard prices to Subsidiaries from Master Plant) and review technical design document and SLA
- Cost Roll-Quarterly cost roll tasks as per predefined sequence and IT support
- Configured CCA by creating cost centers, activity types, statistical key figures, cost center standard hierarchy, cost center categories, document numbers, validations and substitutions, overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations.
- Create internal orders, Set Planner Profile, Plan costs for order, Check Settlement Rules, Execute Settlement of planned costs for order, Confirm Correct Settlement
- Activity type planning,Budgeting, planning statically key figures, Cost Element planning, plan distribution, Internal Activity planning, plan assessment, activity input planning, indirect activity allocation, plan reconciliation, planned price iteration,
- Testing & Training: Unit testing, SIT cycles 1, 2, 3, 4, CAT.
- End User Training: Held various workshops to train business users in Mock wise
Client:Confidential, CA
Role: SAP PTR Team Duration: July 2008 to June 2009
Responsibilities/Deliverables:
Configuration Overhead Controlling, Maintain Controlling Area, Maintain Controlling Area - Basic Settings Assign Company Code,Maintain Versions, Maintain Number Ranges for CO ,Documents, Maintain Allocation Structures, Maintain Allocation Structures Assignments,Maintain Allocation Structures - Source (CE-Group),Define Order Types. Configured CCA by creating cost centers, activity types, statistical key figures, cost center standard hierarchy, cost center categories, document numbers, overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations. Create Planning Layouts for Cost Element Planning / Cost Centers., Create Planning Layouts for Activity Type Planning, Create Planning Layouts for Statistical Key Figure Planning, Create Planning Layouts for Cost Element Planning / Internal Orders, Maintain User-Defined Planner Profiles, Define Assessment Plan, Define Assessment Actual Maintain Allocation Structures, Maintain Allocation Structures Assignments, Maintain Allocation Structures Source, Maintain Allocation Structures - Settlement Cost Elements, Maintain Settlement Profiles, Define Order Types Create Profit Center Group, Change Profit Center Group,Assign Standard Hierarchy to Controlling Area,Create and Activate Profit Centers,Create Dummy Profit Centers,Assign Profit Centers to Cost Centers,Assign Segments to Profit Centers,Assign Profit Center to Material- Create R& D Internal Order ,Set Planner Profile,Plan costs for R& D order,Check Settlement Rules,Execute Settlement of planned costs for R& D order, Confirm Correct Settlement
- Check Version Validity for Current Budget Period ,Copy Previous Year Actuals or Budget ,Option 2: Copy Previous Year Budget
- Transfer Planned Depreciation from Assets,Set Planner Profile ,Download Cost Elements to Microsoft Excel for Income/Expense Budget
- Update Budget Values for Income and Expense Excluding Operations ,Upload Cost Elements for Income and Expense Excluding Operations
- Plan Statistical Key Figures,Execute Plan Assessment,Final Planning Steps: Operating Cost Center Budget,Final Planning Steps: Copy AOP to Active Version,Lock AOP and Active Version for Planning
- SOP through Long-Term Planning/Capacity,Transfer Planned Activity Requirements for Production ,Plan Activity Based on Capacity
- Plan Reconciliation ,Change to Calculate Rates Based on Capacity (Optional) ,Accept Scheduled Labor and Overhead Activity for Manufacturing Cost Centers
- Plan Direct Labor Expenses, Plan Direct Overhead Expenses,Download Cost Elements to Excel for Income/Expense Budget,Update Budget Values for Operation Cost Budget
- Upload Cost Elements for Income and Expense Excluding Operations,Plan Statistical Key Figures
- Check Plan Assessment: Plan Assessment: Quality costs,Activity Price Calculation,Confirm Accurate Calculation of Price
Client: Confidential,Rochester, NY
Role: Sr. FI Functional Consultant
Responsibilities/Deliverables: Duration: Jan 08 to June 2008
Client: Confidential, Indianapolis, Indiana
Role: Sr. COPA Functional Consultant Duration: Feb 2007 Oct 2007
Responsibilities/Deliverables:
- Profitability Analysis (COPA): Creating Operating Concern,Maintaining Characteristics,Maintaining User-Defined Characteristics
- COPA:Maintaining Value Fields, Define Characteristic Derivation,Valuation,Assign Value Fields,Valuation Strategies,Set Up Valuation Using Material Cost Estimate,Assign Costing Keys to Material Types
- Maintain Versions ,Plan Settlement: Receiving Version in CO-PA ,Maintain Revaluation KeysDefine Planning Levels ,Define Planning Packages ,Define Planning Methods (Parameter Set)
- Create Plan Assessment ,Flows of Actual Values ,Direct Posting from FI/MM ,Define PA Transfer Structure for Settlement
- Maintain PA Transfer Structure for Direct Posting ,Transfer of Overhead ,Contribution Margin Planning,Define Variables for Reports ,Define Forms for Profitability Reports ,Create Profitability Report
- Variables for report, forms for report, create reports, Planning Verisons,Layouts,Planning Methods, Excel Uploads,COPA master data, Transfer structures, COPA flows
- Copying Last Year’s Sales Data ,Displaying Data ,Increasing Sales and the Dependent Values by Percent ,Downloading Sales Quantities
- Editing and E-mailing the Spreadsheet ,Uploading Sales Quantities for AOP Update ,Reviewing Quantities for AOP Update before Distribution ,Distributing Product Group Quantities Top-down to Customer/Product Level
- Reviewing Updated Sales Plan Quantity by Customer/ Product to Agree Distribution ,Updating Sales Plan Quantities by Customer/ Product to Agree Distribution
- Transferring Sales Quantities to Sales and Operations Planning ,Valuation ,Executing Plan Assessment Cycle for Profitability Analysis ,Executing the Profitability Report
- Configuration doucmentaion,Test plans, Assembly test, Component testing and CAT testing support
Client:Confidential,Nashville, TA
Role: Sr. CO Functional Consultant Duration: July 2006 to Dec 2006
Responsibilities/Deliverables:
- Configured CCA by creating cost centers, activity types, statistical key figures, cost center standard hierarchy, cost center categories, document numbers, overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations.
- Allocation of quality costs to production cost centers,Period-end closing activities started for production orders,Actual assessment of all cost center costs to profitability analysis (COPA) is run,Analyze costs and revenues for your products,Cost Element planning,Internal Activity planning,Planning Statistical Key Figures,Cost planning using a Template,Overhead allocation using a Costing Sheet,Overhead allocation using a Template, cost estimates
- Unit and integration testing for the assembly cycles and component testing cycles
- Test plans and its approvals from the IT leads and Business CAT system coordination
Client: Confidential, Yuba City, CA
Role: Sr.COPC Functional Consultant Duration: Jan 2005 to May 2006
Responsibilities/Deliverables:
- Product costing Planning including cost component structures, Costing sheet, Costing variant, valuation variant, costing types, ,
- Activity types, Result analysis, Allocation structures, Settlement profiles,WIP,Variance keys, Target cost version, variance keys, posting rule,WIP,valuation methods, Result analysis version
- Discrete manufacturing process with production orders with make to stock/make to order
- Master data preparation in Test cycles: material master , activity types, cost centres,activity type planning,templte loads ,over heads loading,PIRs,BOM,Routings
- Create costing run,Execute costing run,Review errors,Analyze proposed standard prices,Repeat annual operating plan scenarios,Edit cost run and execute,AOP - revenue cost of sales transfer,Create frozen costing run,Execute costing run,Mark as future planned price,Release standard cost estimate and revalue stock at start of new fiscal year
- Run Assessment Cycle for Quality Costs ,Record Purchase-Order Related AP Transactions,Release Blocked Invoices
- Closing Operations in Sales and Distribution Are Complete for Inventory Movements., IT Support to Ensure Goods Movements Are Complete
- Production Transactions Are Complete,Open New MM Period,Actual Overheads Calculation Production Order
- Period-End Closing With Partially Delivered Production Orders,Calculation of Work In Progress (WIP),Review WIP Calculations,Production and Process Order Variance Calculation
- Settle Variances,Analyze Variances,Close Completed Production Orders,Production Order Information System
Client: Confidential,India
Role: Sr. FI Functional Consultant Duration: April 2004 to Dec 2004
Responsibilities/Deliverables:
- Implementation involving the following Finance and Controlling module areas: Complete enterprise and G/L Structure, Automated integration with Accounts Payables and Receivables, Cost Elements, Cost Centre, Internal Order, Profit Centre, reporting and analysis
- Analyzed document flow, validation procedures, and completed a AS-IS study
- Blueprinted existing processes in the form of flow diagrams followed by creation of SAP Business processes and configuration of SAP as per the requirements
- Taxation: Indian Localization with VAT,Sales Tax, Service Tax
- Configured and customized General Ledger, creation of G/L accounts, screen layout rules, automatic account assignments, financial statement version, validation and substitutions
- Configured and customized Account Receivable and Accounts Payable modules: including creation of Vendor and Customer Master Records.EBS,Bank Interfaces files, Manual Bank statements, Payment methods,automataic payment methods,MM and SD integration with Finance
- Indian Localization with CIN-Excise-Excise groups, Chapter ids, Excise Registrations, company code setting, plant settins,Series groups, Account determination, Excise accounts groups per excise trassationsTransactions types, Excise utilization, Excise registrations,
- EWT Basic settings, Business place, withholding types for invoice posting, withholding types for payment posting, withholding tax codes, activation of withholding taxation, assignment of company code, define withholding accounts ,TDS certificates,challan,bank challan updating etc, Sales Tax, Service Tax
- Treasury: Configured House Banks, Payment Programs, Automatic Payment Methods, and Alternate Bank Selections for Payments. Checks Management, checks printing and defining void reason codes.
- Data Migration: Master Data Objects Including GL master data, Vendor Master Data, Customer Master Databank Master Data, Cost elements, cost centers, Profit centers,acivity types, work centers
- Transactions Data conversion:Gl Balances, Vendor open items, customer open items, Asset legacy balances,GRIR open items
- Enhancements & RICEF:Reprots,Interfaces,Conversion& Forms
- Testing & Training: Design, configuration, unit testing, integration testing, UAT, end user training and cut-over
- Provided Production Support and End-User demo training sessions.
Client: Confidential,India
Role: FI Functional Consultant Duration: June 2003 to March 2004
- Responsibilities/Deliverables:
- ASAP Methodology End to End Project Description/Scope:Implementation, Production Support and Development Template.
- GL:Chart of accounts, Baseline Configurations, Accounts Groups, MM, SD, PP, GL Integrations, account determination in MM,SD,PP,AM
- Configuration of A/R and A/P modules: Terms of payment, Open item Management, configuring account assignment for Overpayments/Underpayments and Cash Discounts, Reason codes configuration, Residual & Partial payments, Charge-off, Deduction Management, Credit management, Tolerance groups, Document Reconciliation, Dunning Procedure, Account group creation, Line layout configuration
- Banking: Configured APP, Cash management to monitor payment flows and liquidity, Banking configuration, Electronic/Manual Bank statement processing, Payment advices, Exchange rates
- Indian Localization with CIN-Excise-Excise groups, Chapter ids, Excise Registrations, company code setting, plant settins,Series groups, Account determination, Excise accounts groups per excise trassationsTransactions types, Excise utilization, Excise registrations,
- EWT Basic settings, Business place, withholding types for invoice posting, withholding types for payment posting, withholding tax codes, activation of withholding taxation, assignment of company code, define withholding accounts ,TDS certificates,challan,bank challan updating etc, Sales Tax, Service Tax
- Fixed Asset Module: Chart of Depreciation, Asset Clasess,Screen Layout and Account Determination, Defining Multi Depreciation Areas as per business requirments,Depreciaton keys, Assignment of Gl Accounts, Valuation ares,Depreciation methods, Depreciation Keys, Asset Master Data, load file preparations, business acceptance
- Data Conversation legacy assets, cut over data in including master data and transactional data, Load File validations, Data conversation issues and load files issues resolutions ,Load validations from business, Business acceptances, Change requests, Assisted in configuration of Cost Element and Cost Centre accounting.
- Functional Design for the Accounts receivables aging analysis report and Vendor Payments analysis report ,Vendor ledgers, Cash Book, Bank Book
- Documentation:Configuration,Unit testing, Integration testing, Test plans, User manuals etc
- Testing & Training: Design, configuration, unit testing, integration testing, UAT, end user training and cut-over
Client:Confidential, India
Role: FI Functional Consultant Duration: June 2002 to May 2003
Responsibilities/Deliverables:
- ASAP Methodology End to End Project Description/Scope:Implementation, Production Support and Development Template.
- A/R and A/P modules:GRIR,LIV,FI-AR Integration, FI-AP integration, Terms of payment, Open item Management, configuring account assignment for Overpayments/Underpayments and Cash Discounts, Reason codes configuration, Residual & Partial payments, Charge-off, Deduction Management, Credit management, Tolerance groups, Document Reconciliation, Dunning Procedure, Account group creation, Line layout configuration
- Banking: configured APP, Cash management to monitor payment flows and liquidity, Banking configuration, Electronic/Manual Bank statement processing, Payment advices, Exchange rates
- Indian Localization with CIN-Excise-Excise groups, Chapter ids, Excise Registrations, company code setting, plant settins,Series groups, Account determination, Excise accounts groups per excise trassationsTransactions types, Excise utilization, Excise registrations, VAT
- EWT Basic settings, Business place, withholding types for invoice posting, withholding types for payment posting, withholding tax codes, activation of withholding taxation, assignment of company code, define withholding accounts ,TDS certificates,challan,bank challan updating etc, Sales Tax, Service Tax
- Fixed Asset Module: Chart of Depreciation, Asset Clasess,Screen Layout and Account Determination, Defining Multi Depreciation Areas as per business requirments,Depreciaton keys, Assignment of Gl Accounts, Valuation ares,Depreciation methods, Depreciation Keys, Asset Master Data, load file preparations, business acceptance
- Data Mapping,Defition,Functional specs for data conversation all FICO Master and Transactional objects
- Data Conversation for legacy assets, cut over data in including master data and transactional data, Load File validations, Data conversation issues and load files issues resolutions , Data Load validations from business, Business acceptances, Change requests,.
- Functional specifications for customer and vendors reports, Data conversion (Aging analysis, Customer ledger, vendor ledger reports),Technical Design ,Transport Request, Change request, Change order,UAT,Unit Testing, Component Testing
- Testing & Training: Unit testing, integration testing, UAT, end user training and cut-over
Non-SAP Experience:
- Having 4 plus years of experience in Financial and costing application in business systems prior to the SAP financials in domain
Education & Certification:
- Bachelor of Commerce