Dsl Project Lead Resume
Houston, TX
SUMMARY:
- Project Lead of SAP and SME in SAP Finance, Controlling,COPA, Project Systems & Funds Management for 12+ years and 5 years of Bank IT experience.
- Implemented SAP ERP in MNCs like Confidential Houston TX, Confidential Chicago IL, Confidential NJ, Confidential Australia, Liberty Insurance South Africa, Makro Technologies Newark NJ, Heubach Color Germany - Austria, Confidential, NJ.
- ERP Architect - Experienced to offer Service Oriented Architecture/Solution in mapping the data into Central ERP System from heterogeneous Systems.
- Implemented projects of Legal Mergers at Plant Level and Corporate level.
- Implemented Migration Activity in case of Up gradation projects into Simple Finance.
- Implemented BI PROJECTS in getting integrated with other Modules FI CO & Modelling the data.
- Expert at Accounting and Costing domain, certified CAIIB.
- Well experienced in SAP Methodologies. Good in ASAP Methodology and Agile.
- Good at System Analysis and design. Can drive the Projects and teams with ease owing to wide experience.
- Good at understanding the Integration aspects and will try to fix the issues in coordination with teams.
- High level expertise in Transforming the Legacy Process into ERP software to reduce the cost long run.
- Well Experienced in the BPOs and CTMs in SAP Processes. Conducted several Academies at SAP Authorized Centers like Siemens and Atos Germany.
- Capable of Driving the Business into IFRS a new Reporting system and to have a quicker adaptability.
- Good at Identifying the GAPS and expertise in Impact Analysis and well designed work around.
- Good at conducting pre-sales activity in converting the potential customers into our strength area.
- Conducted all the activities related to IT in the Banking industry in any EXPO and attending International seminars.
- Experience designing and developing ERP application featuring Sales Accounting, Inventory Control, Logistics, Payroll, Front Office Management and Financial Accounting;
- Extensive experience working on Accounts, Finance, Tax and Audit of high responsibility - Finalization & Consolidation of Financial Statement of Accounts & Audit adhering to GAAP, SOX, Tax compliance.
- Extensive knowledge of Software Development Life Cycle (SDLC), methodologies and test processes and Software Testing Life Cycle (STLC)
- Worked on preparing Functional Specification Templates for implementing new process/enhancement of existing functionality/modification of existing process.
- Experienced in functional configuration with the SAP Financial Accounting & Controlling (FI-CO), emphasis on General ledger, Accounts Payable, Accounts Receivable, FI-MM /SD/PP integration. New GL and document split concepts. Asset Accounting, Configuration of House Banks, Manual Bank Statement. Electronic Bank Statement. Revenue recognition process. Configured Input/output taxes and EWT and VAT. Lock box and Tax configuration. Project System Configuration with IM and WBS.
- Legacy Data Migration (GL master, vendor master, customer master, Asset master, open items, account balances, asset transactions), LSMW tool & BDC. Worked on Report painter.
- Gap analysis and solution definition. Worked on interfaces using RFP, BAPI, IDOC/EDI
- Documentation - (Business Blueprint, Configuration document, manual, testing. In the technical upgrade project and enhancement project created the test scenarios with business user interaction and handled unit and integration testing with HPQC & ABAP programs.
- Expert in New General Ledger Accounting. Expertise in configuring Leading and Non Leading and document splitting. Final Mapping of every thing to the Document Type. Enabling ZERO balance A/C.
- Expertise in configuring Accrual and Deferral Engine for to fully automate the P&L items reposting.
- Good at configuring Cockpit Closing. Will be configured at Controlling area and Co code level taking the standard template provided by SAP. Same can be configured for all other modules too.(non financial)
- Expertise in handling and configuring Cross company code transactions in Finance and Asset Accounting.
- Good at configuring Inter Company Transactions to produce a consolidated company report. We will avoid all cross company Income and stocks while producing the report at consolidate Corporate level. The Income is recognized only the product is sold finally to a third party Customer.
- Very good skill at configuring validation and substitution at co code level. User exits are also used for the purpose. Nearly 350 steps are coded under the Validation.
- To save the user time we have effectively used Default Values, Change control.
- Customer and Vendor sensitive fields are configured to have the dual control while changing the Master data especially.
- Park and hold documents are used as to save time as well as to implement workflow.
- Sample documents, Recurring documents and screen variants are used to save time.
- Location wise, currency wise Cash Journals are configured with dedicated GL Accounts.
- Foreign Currency Valuation with Valuation Area and Methods has been configured for all open items and customer and vendor GL accounts. GR IR accounts are kept outside the scope.
- In view of Business Requirements will automate the Process of Correspondence by configuring the required no of Corresponds Types and Variants and Script Forms.
- To make Balance sheet more and more realistic we have done Value Adjustments and Regroupings.
- Pioneered in configuring Payment Medium DMEE and effectively configured the Auto payment program even to suit customers. Spl. Gl Transactions are also mapped. There done the Integration between APP and BCM for to make more meaningful payment groups. Debit Balance check has also been enabled.
- TAX REPORTING IN USA has been done with all special focus in even client. Jurisdiction tax has been implemented to handle the state tax and Federal Tax.
- Cost calculated and posted as per the requirement and can go for manual posting too.
- Integration and reporting structure center Accounting (CCA), Profit center Accounting (PCA), Cost Elements, and Internal Orders, Assessment and distribution cycles and other CO objects. Profitability analysis (COPA), Direct & Indirect activity allocation. Cost sheet for over heads. Internal orders budgeting and settlements.
- Expert in Cost by Order & Cost by Period Product Costing Implementations. Costing sheet expense based and quantity based be designed.
- WIP and Variance are and cost assignment will be planned and configured among CO-OM, CO-PC, CO-PA, CO-CEL & EC-PCA.
- Good at structuring and generating and executing Report Painter Reports.
- COPA INTIGRATION with Sales Order management and Transfer of Over Heads.
- Configured Direct Postings in COPA and value flow from Cost Object of CO to COPA.
- Good design skills to facilitate the Value flow from the cost objects and Sale Order by configuring the characteristic fields and value fields effectively to have many a profitability segments.
- Very much specialized in configuring Real Time Integration of FI - CO. Object specific Co code wise variant and the account determination will be configured.
- Implemented Funds Management with Budget and Availability Control.
- Good at Joint Venture Accounting for the Petroleum Industry for Up Stream Functionality.
- Good at Designing the Work Flows coordinating the Coding team and ensuring SOAX compliance.
- Good at designing User Roles and comparisons across all the modules in SAP with main objective being SOAX compliant and will always avoid conflicting roles and un necessary over laps.
- Will be good at designing the FIRE FIGHTING ROLES cross module and setting the work flow.
- Very good knowledge in Debugging, searching for Bapis, BAdIs and User exists.
- Expertise in Data Migration using LSMW and BDCs and good at guiding the ABAP team on IDOCs.
- Master data Governance with SAP MDG.8. Solution manager. Knowledge in S4 Hana Finance.
- Having good skills in directing the Informatica Team on Data Transformations and Monitoring of Mapping Files and Load Procedures and Functional Documents connected.
TECHNICAL SKILLS:
- Working knowledge on Tools-Writing Scripts & User manual
- Project dashboard & Ticketing
- HPQC, MS-Office, SharePoint
- GRS, Remedy & One Note
- Working knowledge on following Languages/Packages/Reports/Databases
- Application developments
- SQL, PL SQL, Visual Basic
- Crystal Report, Fox Base, FoxPro
- Oracle & MS-Access
PROFESSIONAL EXPERIENCE:
Confidential, Houston TX
DSL Project Lead
Environment: SAP FICO
Responsibilities:
- Analyzing one to many and many to one scenarios in Profit ctr and cost ctr accounting while mapping.
- The update with reg. to Profit ctr. Currency has been taken care of to facilitate the Balance Sheet Analysis at Profit Center level in a selected currency.
- Costing Based COPA - Due care has been taken to see all the value fields and Characteristics are Mapped and the Profitability segments are maintained properly to facilitate Management Analysis.
- The Product Related Characteristics like Product, Division, Material Group and Material Prising Group have been mapped.
- The Customer related Characteristics Customer(Sold Party), Customer Group, Sales District, Industry, ship to party and ship to country have been mapped.
- Sales Organization, Distribution channel, Sales Personnel, Sales Office and sales Group are mapped as Characteristics.
- Specially we have mapped value fields like COGS, Admin Over Head, Price Variance, Material Discount, Accrued Bonus, Production Labor Variance, Machine Variance and Input Variance etc.
- Standard cost and the actual cost and the Variance has been migrated.
- Should co-ordinate that all the teams like Informatica, Finance, Material and Production etc. are working on the same pace with reg. to Design document and meet the time lines as said in the Project Charter.
- Need to facilitate scheduled interactions among client teams and our teams.
- Identifying the Fields that need mapping after studying the system on either side.
- If it is one to many then sufficient care need to be taken to split the transactions and reconciliation should also take place.
- Split of journal entry need to be automated in case of the Legacy figures are greater than the 11 digit of SAP transactions without losing the line item Id.
- The cost ctr JV attributes are to be in place before we load the cost centers or WBS elements.
- New GL- Item categories and document Types for New GL are created and mapped.
- Valuation Area and Valuation Methods for the sake of Foreign Currency Valuation have been created.
- Delta Forex valuation has been adopted.
- Revenue Recognition has been configured for the sake of Joint Venture Accounting.
- Inhouse Cash has been configured.
- BCM has been done for to make the APP more effective.
- Configuration of transactions like acquisitions, retirements, transfers, inter-company transfers, write-offs and capitalization of assets under constructions.
Confidential, Chicago IL
FICO and FSCM Cluster Lead
Environment: SAP ERP 6.04
Responsibilities:
- Aging Analysis has been done for both Customers and Vendors.
- Very Detailed Trade Deal Analysis with reg. to Rebates and Discounts.
- A regular time bound reconciliation has been planned bill wise to assess the Rebates vis a vis the Credit Memos.
- Real Time Integration has been in place to see the FI CO gets reconciled on day to day basis.
- The Assessment and Distribution cycles are configured to be run on monthly basis and a report gets generated to know the value flow in Controlling.
- A regular reconciliation of Asset Accounting and Financial Accounting has been carried out.
- In Product Costing a regular MRP Planning and periodic Standard cost runs and scheduled maintenance of KP26 values vis a vis the capacity planning.
- Different cost scenarios like Manufacturing cost, Cost of Sales and over head cost and Fixed cost and variable cost reports are generated for fine tuning the Product costing.
- Regular settlement of WIP and Variance periodically to ensure actual cost being assed perfectly to see the Standard cost falls very near to the Actual cost so that the variance is kept at minimal.
- KE30 and Ke24 reports are generated on regular basis.
- The clusters are 1 GL-AR-AP-AA 2 TD-CASH&BANKING 3 CO. Worked in all the 3 clusters and attended the issues as per SLA. The ticketing tool used is Remedy.
- FSCM Cr. Management and Dispute management and Collection Management Delta implemented.
- IHC has been configured for the entire North America Region.
- Asset Impairment has been configured as a work around.
- RLM a mini project on Legal Merger of Plants has been undertaken
- NRTs are being handled for the tax code extensions, Name change in different languages.
- Asset Impairment as a work around provide using the Unplanned depreciation.
- Asset Life Cycle has been completely hadled by configuring acquisitions, retirements, transfers, inter-company transfers, write-offs and capitalization of assets under constructions.
Confidential
FICO Lead & FSCM, FICA consultant
Environment: SAP ERP 6.00
Responsibilities:
- Facilitate High Level discussions on CREDIT portfolio involving FI SD and CRM BPOs.
- Organizing regular Programs for groups of CTMs specific to Business Partner Attributes.
- Customer synchronization among FI-SD, CRM & FSCM Modules.
- Finalizing Credit Management, Collection Management & Dispute Management Design.
- Finalizing the IHC strategy.
- Analyzing the key aspects of Risk Management.
- Derivative configuration.
- Mappings BCM to APP Finalization.
- New Value Fields are created in Costing Based COPA
- New COPA Based condition types have been designed in the pricing procedure.
- Product costing Planned costing variant has been changed to be very near to Standard cost Variant.
- Cost Sheet Quantity based has been configured for the Oils SBU
- New cost components have been configured to be shown under Cost of Sales scenario.
- The settlement of Variance for every Production order has been configured for Material and Activity.
- For OILS SBU ML has been to configured for the cake product to sum up the actual cost to the top.
- Accounts Payable & Accounts Receivable - Configured account groups for Customers and Vendors, defined screen layout per activity for customers and vendors, configured payment terms, created number ranges for Vendors/Customers-assign no. ranges to Vendor/Customer account group, tolerance for Vendors/Customers, month end closing
- Configured Automatic Payment Program, House banks and Bank accounts, special GL transactions like Down Payment Made or Down Payment Received, Configured Automatic Payment Program
- Asset Accounting Asset acquisitions, retirements, transfers, inter-company transfers, write-offs and capitalization of assets under constructions.
Confidential
Lead dedicated support
Environment: SAP ERP 6.0 and 4.7
Responsibilities:
- Provide support to clients as per AMC Contract. Leading the Offshore help desk team which provides remote support on mySAP ERP 6.0 and 4.7 to Pharmaceutical and engineering industries.
- Configuration of the new changes required to address additional business process requirements of the client.
- Resolution of issues related to business processes within SLA Timelines.
- Preparation of the Functional Specifications for the development of new objects.
- Preparation of Software Change Request (SCR) and Customizing Change Request (CCR) documents for program and customizing modifications.
- Worked on New General Ledger Configuration as well
- Defined leading and non leading ledgers, defined different segments for segment reporting
- Classified G/L accounts for document splitting
- Created customer master data, customer groups, customer field status, terms of payment and assigned credit control area to the company code.
- Worked on special purpose ledger for the Intercompany process.
- Define multiple payment method for ACH, Wire Transfer, checks and for foreign currency.
- Creation of House banks and payment methods, for new vendor master data.
- Set up the Integration of FI with MM and SD through Automatic Account Assignment.
- Provided production support to custom master data by maintaining customer MICR (Magnetic Ink Character Recognition) data and maintained bank key, bank account, alternative payer.
- Worked on Fixed Asset Depreciation and Intercompany Revenues, Payables and Receivables, Balance Sheets and income statements and Retained Earnings accounts.
- Worked with SD and MM teams for all Intercompany related Billing and Invoicing
- Worked with Master Data team to manage “Trading Partner” field for Customer and Vendor Company Codes etc.
Confidential
FICO Lead
Environment: mySAP ERP 6.0
Responsibilities:
- Provide support to clients as per AMC Contract. Leading the Offshore help desk team which provides remote support on mySAP ERP 6.0 to Pharmaceutical Solution Inc (PSI) Jeddah KSA.
- Configuration of the new changes required to address additional business process requirements of the client.
- Resolution of issues related to business processes within SLA Timelines.
- Preparation of the Functional Specifications for the development of new objects.
- Preparation of Software Change Request (SCR) and Customizing Change Request (CCR) documents for program and customizing modifications.
- Continuously interacted with the accounting department while creating necessary primary and secondary cost elements to ensure that all the relevant cost data gets captured
- Configured costing sheet in consultation with the cost center manager to enable them to plan irregular costs
- Assigned cost center to the standard hierarchy, configured cost center categories with appropriate block indicators for plan and actual data
- Interacted with the accounting department to identify the scenarios for assessments and distributions
- Configured the assessment and distribution cycle as per requirements
- Designed CO-PA based on costing based approach
- Analyzed the client requirement for profitability reporting and configured the characteristics and value fields accordingly
- Created derivation rules for characteristics and configured CO-PA planning
- Configured Controlling modules including Cost Element Accounting, Cost Center Accounting, Internal Order Accounting and Profit Center Accounting
- In PCA, designed and configured the hierarchy for various responsibility units by means of Profit center Accounting.
Confidential, Johannesburg, SA
FI Lead
Environment: SAP ECC 6.0
Responsibilities:
- We have designed overall strategy of data upload using Data Extraction in BI and Interfaces and file upload programs in SAP to meet the reporting requirements and also Finance for external reporting as well as the MIS.
- Worked on EBS upload and auto clearing of the customer items.
- Worked on data uploads from compass to SAP in specific.
- Implemented Treasury Derivatives and BCM.
Confidential
FICO Team Lead
Environment: SAP version ECC 6.0
Responsibilities:
- Involved as FICO TEAM LEAD in Implementation of SAP 6.0 Version.
- Master Data Collection and closely interacting with the Implementing Team.
- Played a key role in business requirement gathering & analysis designs application integration development and testing. Successfully customized modules based on business needs and requirements.
- Involved in freezing the Organization Structure.
- Designing and Reviewing of the Phase Documents.
- Conducted Workshops on FI/CO for Users - G/L Masters, Asset Master, and Cost Centers Codification, business processes cycles, Data Management etc.
- Actively participated in Joint Application Development and significantly contributed to user interaction amongst the technical and business management teams. and Development of the New Entrants in the Company
- Handing the Cross-Module Issues with FI, SD, MM, PP & QM.
- FUNDS MANAGEMENT - Implementation of Fund Area and fund center and cost centers and commitments.
Confidential, New Jersey
FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Designing the Finance and Controlling Organizational Structures and accordingly implementing Enterprise structure.
- Configuring Chart of Accounts with Account Groups and various Accounts suitable to customers, Vendors and Assets.
- Configured AR and AP with all Special GL Accounts, master data, credit management, payment terms, cash application.
- Configured the automatic payment program for outgoing payments handling different payment methods including ACH and check.
- Setup financial statement versions and other closing procedures.
- Customer and vendor master data upload.
- Creation of cost elements and cost centers.
- Created cost center (CCA) and profit center (PCA) hierarchies and related master records.
- In cost center accounting (CCA) created cost centers, cost center standard hierarchy, statistical key figures, master data groups, validations and substitutions, reconciliation ledgers, assessments, distributions, allocations using cycle-segment method for periodic reposting, activity types and planning them on different cost centers, planned and actual activity price calculations.
- In cost element accounting created primary and secondary cost elements, created cost element groups, maintained cost element attributes, assigned the cost elements to various cost centers, activating the reconciliation ledger and maintaining accounts for automatic reconciliation posting.
- In profit center accounting (PCA) configured the basic settings, maintained profit center standard hierarchy, exchange rate types, statistical key figures, distribution and assessment of costs.
- Distribution and assessment in relevant cost centers and profit centers. Integration of sales and distribution (SD) and materials management (MM) modules with FI.
- Unit, integration and regression testing of system. Preparation of End user documentation. Complete Functional Requirements Specifications (FRS) procured and documented, mapped and verified against existing User Requirements Specifications (URS) documents.
Confidential, Newark, NJ
FICO Consultant (Implementation)
Environment: SAP ECC 6.0
Responsibilities:
- Study of AS-IS, TO-BE and Gap Analysis
- Determination of Organization Structure in SAP
- Configurations of FI sub modules - General Ledger, Accounts Receivable, and Accounts Payable.
- Creation of Chart of Accounts, interest calculations, Bank Transactions like Automatic payments, etc,
- Creation of vendor/customer masters, bill of exchange transactions, interest calculations etc.,
- Configuration of Asset Management
- Creation of standard Hierarchy, Cost Center Budgeting, Profit Center Accounting etc.,
- Thorough to Module team members on the transactions and Key Reports Preparation of User Manuals
- Period End Activities
- Reconciliation of SAP Data with Legacy Data for the transition period.
Confidential, New Jersey
FICO Consultant member of Annual Maintenance Contract
Environment: SAP ECC 6.0
Responsibilities:
- Major Emphasis on User roles without conflict and all worldwide plant and Company code access are given following matrices and an approval in the method of work flow is mandatory.
- Auto Creation of cost elements and from GL accounts and the Balance sheet Inventory accounts are made category 90 for the sake of Project Systems R&D Projects.
- Process Order in make to stock scenario with cost sheet and cost component structure has been configured along with 3 costing variants.
- Created cost center (CCA) and profit center (PCA) hierarchies and related master records.
- In cost center accounting (CCA) created cost centers, cost center standard hierarchy, statistical key figures, master data groups, validations and substitutions, reconciliation ledgers, assessments, distributions, allocations using cycle-segment method for periodic reposting, activity types and planning them on different cost centers, planned and actual activity price calculations.
- In cost element accounting created primary and secondary cost elements, created cost element groups, maintained cost element attributes, assigned the cost elements to various cost centers, activating the reconciliation ledger and maintaining accounts for automatic reconciliation posting.
- In profit center accounting (PCA) configured the basic settings, maintained profit center standard hierarchy, exchange rate types, statistical key figures, distribution and assessment of costs.
- Distribution and assessment in relevant cost centers and profit centers.
