We provide IT Staff Augmentation Services!

Sap Tax Consultant Resume

2.00/5 (Submit Your Rating)

Professional Summary:

  • Seven years of experience in the IT industry encompassing excelling experience in implementing, configuring, and customizing, SAP R/3 with multiple full life cycle implementations, analysis & production support.
  • Accomplished SAP Global Tax Consultant with a strong affinity for technology and acute business sense for the application of emerging technologies to add value and expand markets
  • Global experience includes exposure to UK GAAP, IFRS, HGB, Mexican and Japanese GAAP along with US, Canadian, European, Brazilian and Mexican Taxation principles
  • A finance professional with experience and expertise in planning and analysis, e-procurement, and financial systems implementations, including the development and implementation of team tools to streamline and improve the annual plan process and provide process owners with the ability to succinctly analyze and supply financial data to upper management.
  • Implemented the FICO modules towards analyzing trends, Costs, Revenues, Expenses, Cash Flow Forecasting, General Ledger Ratio Measurements, Financial Commitments, and Obligations Incurred to predict future revenues and expenses, to improve the corporations internal control, objectives, procedures, and operations efficiencies.
  • Expertise with definition of functional requirements, process improvement, and project scope definition, blue printing, gap analysis, configuration, testing, documentation, full life cycle implementation and support.
  • Preparation of documentation and flow charts, describing interfaces, collecting of master data, testing and reviewing training documentation.
  • Experience in creation of business blueprints for processes and specifications of requirements.
  • Experience in Analyzing business requirements, Configuration, Testing and End User Training.
  • Advanced skills in GL, AP, AR, FA, Treasury, Special Purpose Ledger, Taxation, Product Costing, Cost Center Accounting, Activity Based Costing, Profitability Analysis, Profit Center Accounting and Production planning.
  • Excellent Configuration skills in Asset Accounting, General Ledger, Accounts Payable, Accounts Receivable, Cost Center Accounting, Internal Orders, Profit Center Accounting and Profitability Analysis, Data Conversion
  • High learning curve with the ability to embrace new tools and technologies with ease and to seamlessly integrate skill set into the project implementation life cycle.
  • Experienced in migration from legacy systems to SAP R/3 by using LSMW & GLSU
  • Integration of FI with core applications including CO, PP, MM, SD (Invoicing, Billing and Pricing)
  • Extensive experience with SAP interfaces in the FI and CO areas that include bolt-on products such as Vertex/ Taxware tax and Payware for credit card managements.
SAP R/3 SKILLS:

Financial Accounting (FI) : Asset Accounting, Enterprise Structure, General Ledger, Accounts Payable, Accounts Receivable, Bank Accounting and Special Purpose Ledger
Controlling (CO) : Cost Element Accounting, Cost Center Accounting,
Internal Orders, Profit Center Accounting and Profitability Analysis
Reporting Skills : Report Writer & Report Painter
Integration : FI integration with SD, MM and Overhead Cost Controlling

TECHNICAL SKILLS:

ERP : FICO 3.1 H, 4.0 to 4.6 C, 4.7, ECC 5.0, ECC 6.0
Databases: : Oracle, Excel, Access
OperatingSystems : Windows 95/98/NT/2000/Millenium/XP
Modeling Tool : Rational Rose, MS Visio
OfficeTools : MS Word, MSExcel, MSPowerPoint, MSAccess

Professional Experience:

Confidential, Atlanta GA Jun'11 onwards
Vertex Migration Consultant
Description: McKesson Corporation is the largest health care company in the world, with sales of $106.6 billion in 2009.McKesson is based in the United States and distributes health care systems, medical supplies and pharmaceutical products. Additionally, McKesson provides extensive network infrastructure for the health care industry; also, it was an early adopter of technologies like bar-code scanning for distribution, pharmacy robotics, and RFID tags. McKesson was partially on SAP and moving the rest of its organizations from Peoplesoft and Taxware to SAP and Vertex respectively. The exemption certifications in Taxware's STEP system totalling about 20,000 exemptions for 5 companies had to be extracted from a unix based version of Taxware with no web toolkit in place. The challenges included obtaining exemption certifcates that were hosted on Peoplesoft for tax exempt customers as well as extracting rules in a format that could be used to mass load exemptions in Vertex's Tax Decision Maker (TDM)

Confidential, San Diego CA Feb'11 – May'11
Vertex “O” Series Consultant

Description: CareFusion is a global, medical technology corporation serving the health care industry. The company specializes in two areas: reducing medication errors and helping prevent health care-associated infections. The company had just implement ECC and CRM for the Carefusion entity which had been spun off Cardinal Health recently. Being an FDA regulated consumer, they implemented the
Vertex “O” series to obtain more visibility in the exemption certificate application process.

Responsibilities

  • Assisted in resolving a $10 million billing issue due to expired forms in exemption certificates
  • Resolved failed tax documents that did not update the Vertex Tax ledger due to consistency failures
  • Resolved max tax issues for invoices destined for Florida and Tennessee
  • Analysed XML messages in the SIC log sent in by both CRM and ECC systems
  • Assisted in customization call from CRM to invoke the Distribute Tax functionality in Vertex for tax only adjustments
  • Created Data extracts for reconciliation of SAP General Ledger and Vertex Tax Journal
  • Created Customer, Exemption Certificate and Product Hierarchy Mapping data documents for Mass Uploads in Production environment
  • Recommended additional servers for load balancing for night batch jobs
  • Verified invoice and sales order taxability using Transaction Tester

Confidential, Perrysburg OH Oct'10 – Jan'11
SAP Tax Consultant

Description : Accenture is a global technology services company currently assisting Owens Illinois in implementing SAP. Combining unparalleled experience, comprehensive capabilities across all industries and business functions, and extensive research on the world\'s most successful companies, Accenture collaborates with clients to help them become high-performance businesses and governments Confidential is a Fortune 500 company that specializes in container glass products. It is one of the world\'s leading manufacturers of packaging products, holding the position of largest manufacturer of glass containers in North America, South America, Asia-Pacific and Europe While legally known as Owens-Illinois Inc., the company changed its trade name to O-I in 2005 to group its global operations under a single, cross-language and cross-culture brand name. Approximately one of every two glass containers made worldwide is made by O-I, its affiliates, or its licensees. The company\'s headquarters were previously located in One SeaGate, Toledo, Ohio, a local landmark. The headquarters were moved in late 2006 to the Levis Commons complex in the suburb of Perrysburg, Ohio. After implementing SAP for its operations in Europe and North America, Owens Illinois is currently implementing SAP for its operations in Latin America which includes Argentina, Brazil, Colombia, Ecuador, Peru and Venezuela

Responsibilities:

  • Created functional specifications for XML Reporting for Ecuador
  • Creation of Condition types and access sequences for VAT configuration for Latin American countries in SAP
  • Configuration for Argentina Taxation - Impuesto al Valor Agregado (IVA)
  • Configuration for Brazil Taxation - Imposto Sobre Produtos Industrializados (IPI)
  • Configuration for Colombia Taxation - Impuesto al Valor Agregado (IVA)
  • Configuration for Ecuador Taxation - Impuesto al Valor Agregado (IVA)
  • Configuration for Peru Taxation - Impuesto General ala Ventas(IGV)
  • Configuration for Venezuela Taxation - Impuesto al Valor Agregado (IVA)

Confidential– Bacardi, Miami FL Jun'10 – Sep'10
SAP FI Tax Lead Consultant

Description : Confidential is a family-controlled spirits company, best known as a producer of rums, including Bacardi Superior and Bacardi. The company sells in excess of 200 million bottles per year in nearly 100 countries. They were currently on JD Edwards and are migrating to SAP for a standard ERP solution.

  • Handling of all Taxes for the United States, Canada, Mexico and Puerto Rico
  • Handling of Liquor Excise Taxes by condition types in SAP
  • Liasoning with Sabrix and Vertex Vendors for Pre-sales RFP
  • Creation of configuration (COE) elements andmaintained them in Solution Manager
  • Handling of Property Taxes by Asset Accounting
  • Federal and State Income Tax reporting from SAP towards IRS Form 1120 U.S. Corporate Income Tax Return
  • Recommendations for capturing of Taxes and Freight as part of Asset Cost build-up .
  • Configuration for Withholding Taxes 1099 Federal and State Tax reporting and 1042 Foreign Vendor/ Non-EmployeeReporting

Confidential– MillerCoors, Milwaukee, WI May'10
SAP Vertex Tax Consultant

Description: SABMiller and Molson Coors enter a joint venture to create MillerCoors, whose remarkable brand strength and highly talented people form a high-potential new brewing company with a unique foundation of great beer brands. The company already had a bolt-on in place, Vertex “Q” series. Apart from the standard SAP configuration to communicate with Vertex, the rules within Vertex had to be customized as well.

Confidential– Spring, TX Mar'10 – Apr'10
Sabrix Tax Consultant

Confidential, commonly referred to as Confidential, is an American multinational information technology corporation headquartered in Palo Alto, California, USA. HP is one of the world\'s largest information technology companies and operates in nearly every country. HP specializes in developing and manufacturing computing, data storage, and networking hardware, designing software and delivering services. Major product lines include personal computing devices, enterprise servers, related storage devices, as well as a diverse range of printers and other imaging products. HP markets its products to households, small- to medium-sized businesses and enterprises directly as well as via online distribution, consumer-electronics and office-supply retailers, software partners and major technology vendors
HP is a technology company that operates in more than 170 countries around the world. They had both Sabrix and Taxware for their transactional tax automation needs, with Sabrix handling the global tax
Calculation barring the United States and Canada. The Czech Republic and the Netherlands had to have their VAT (value added taxes) calculated in both local and foreign currency to satisfy local regulations. Being on multiple non–SAP systems as well, these parameters had to be passed to Sabrix for the tax calculation as well.

Confidential– Avaya, BaskingRidge, NJ Dec'09 – Mar'10
SAP EU Tax Consultant

Description: Avaya is a global leader in enterprise communications systems.The company provides unified communications, contact centers, and related services directly and through its channel partners to leading businesses and organizations around the world. The 2010 VAT Package is a new European rules taking effect in 2010 which makes significant changes regarding the rules on place of supply of services to businesses (B2B) and consumers (B2C), regulations for cross-border VAT refunds, the administrative cooperation, and the exchange of information between EU Member States. These new rules will affect U.S. companies that sell or purchase services in Europe, and can result in tremendous savings in their business expenses over previous years. Individual EU countries are able to interpret and apply the new rules differently regarding how some services performed are treated from a VAT point of view in their respective countries. The primary changes that will occur with the 2010 VAT Package rules will be to levy VAT on services at the actual physical place where the customer is located. This change can result in U.S. companies receiving significantly greater VAT savings compared to previous years. However, many individual EU countries will require advance VAT registration before business transactions take place in order to receive any VAT refund or savings. There were substantial changes to be made on the ERP system to be compliant for the same.

Confidential – Fort Worth, TX Feb'09 –Nov'09
SAP FI IDoc Consultant

Description: Confidential, formerly known as the Burlington Northern and Santa Fe Railway, is an American freight railroad company headquartered in Fort Worth, Texas; it is one of four remaining transcontinental railroads, and one of the largest freight railroad networks, in North America. They were on legacy systems and to achieve consistency in the landscape, they decided to implement SAP throughout the organization. They also had to key in invoices manually that were faxed in by suppliers for which they implemented Optical Character Recognition/ Intelligent Character Recognition (OCR / ICR) applications -FileNet which is basically a workflow system which reads, understands and processes incoming fax images of the invoice without the need to predefine the structure of various faxes, and generates the same in SAP

Responsibilities:

  • Re-configured the oncoming OCR / ICR IDocs for Vendor Invoices for missing fields related to invoice amounts, taxes, contract, assignments for Network activities, Project systems and Cost Centers
  • Image-enabling the SAP Accounts Payable application to facilitate the successful storage, retrieval, and archiving of documents
  • Configured the conversion and export of data that has finished the completion stage, export of image files and export of data
  • Replaced the expensive manual process of keying in data from the invoice with the (OCR / ICR system\'s high-speed content recognition
  • Configured the system to recognize Invoice's and the fields according to keywords and key terms situated anywhere on the page, such as shipper, from, sender, etc
  • Enabled the quality check of recognized characters and entry of unprecedented character recognition and error detection
  • Empowered faster and more efficient processing and minimum human intervention to reduce labour costs and increased data integrity

Confidential – Ontario, CA Oct'08- Dec'08
Sr. SAP Vertex Tax Consultant

Confidential is the world leading provider of solutions for the creation, management, delivery and access of video, for the Communication, Media and Entertainment industries. The company already had a bolt-on in place but decided to move to Vertex “O” series for a more customized and web-enabled solution. Apart from the standard SAP configuration to communicate with Vertex, the rules within Vertex had to be customized as well.

Responsibilities:
  • Responsibilities included interacting with client s business process team; collect all the business requirements and creation of use-cases/flow-charts using Visio
  • Integrated SAP with the web-enabled Vertex's SAP Integration Component (SIC).
  • Managed Exemption Certificates in the new Vertex “O” series Exemption Certificate Manager (ECM).
  • Configured SAP to passdelivering country (origin), the tax class of the ship-to partner, the tax class of the material being shipped, the tax calculation date and the jurisdiction codes from the ship-to-party (ST) (customer), ship-from (SF) address (plant), point of order
    acceptance (POA) and point of order origin (POO) towards determination of nature of taxes
    (Sales and Use tax) and Tax rates
  • Set up the physical locations for “situs” determination using the Vertex Tax Decision maker (TDM)
  • Redirected SD (Order-to-Cash/Quote to Cash) and MM-PU (Purchase-to-Pay/Order to Pay) master data links to Vertex.
  • Setting up of user defined tax codes.
  • Generation of Vertex Register Reports for detail and totals for taxes, taxable sales, and exempt sales sequenced by state, county, city, and district taxes for the required billing period
  • Configured Rules for the Vertex Tax Decision Maker (TDM) to handle Customer Tax Exceptions, Product Tax Exceptions and Jurisdiction Exceptions
  • Mapping of Organization Product codes with Vertex product codes using Vertex Taxability Mapping Tool (TMT) for quicker handling ofstate-based product exceptions
  • Configuration of European Union VAT (EU VAT) for United Kingdom and 12 member states using Calculation Procedures.
  • Assisted and guided in determination of situs overrides and standard rate overrides.
  • Creation of Functional Specifications and maintained them in Solution Manager
  • Assisted Tax department in customization of Vertex Sales Tax Returns (STR) towards auditor and IRS requirements.
  • Created functional specifications for user exit FYTX0002 for overriding system default for POO and POA (Point of Order Origin and Point of Order Acceptance)
  • Creation of Test plans for functionality testing.

Confidential, Dallas TX Jul' 08 – Sep'08
SAP Tax Consultant

Description: Confidential is an American low cost airline based in Dallas, Texas. It is the largest airline in the United States by number of passengers carried domestically per year and (as of December 31, 2007) also the largest airline in the world by number of passengers carried. It is also the 6th largest U.S. airline by revenue. They were on legacy systems and to achieve consistency in the landscape, they decided to implement SAP throughout the organization. Guidance to legitimately reduce their overall tax burden and minimize/delay cash outflows for taxes was also provided in accordance with provisions of Financial Accounting Standards Board Interpretation (FIN) No. 48, Accounting for Uncertainty in Income Taxes, was also provided

Responsibilities:

  • Handling of Fuel Excise Taxes and Aviation Kerosene taxes by mirroring in SAP
  • Handling of Payroll Taxes, and excess per diems by integration with BSI including
    • Withholding Tax
    • Employer Unemployment (FUTA)
    • Employer and Employee Social Security
    • Employer and Employee Medicare
  • Integrated SAP with Vertex's Transaction Processing System (TPS).
  • Configured SAP to passdelivering country (origin), the tax class of the ship-to partner, the tax class of the material being shipped, the tax calculation date and the jurisdiction codes from the ship-to-party (ST) (customer), ship-from (SF) address (plant), point of order
    acceptance (POA) and point of order origin (POO) towards determination of nature of
    taxes (sales and use tax) and Tax rates
  • Set up the physical locations for “situs” determination using the Vertex Tax Decision maker (TDM)
    • Configured Rules for the Vertex Tax Decision Maker (TDM) to handle
  • Customer Tax Exceptions – Identification of customers and customer classes with tax exceptions
  • Product Tax Exceptions - Identification of products and product categories with tax exceptions
  • Jurisdiction Exceptions – Identify jurisdictions with exceptions and locally administered jurisdictions
  • Directed SD (Order-to-Cash/Quote to Cash) and MM-PU (Purchase-to-Pay/Order to Pay) master data links to Vertex.
  • Creation of configuration (COE) elements andmaintained them in Solution Manager
  • Setting up of user defined tax codes.
  • Generation of Vertex Register Reports for taxes, taxable sales, and exempt sales sequenced by state, county, city, and district taxes
  • Mapping of Organization Product codes using Vertex Taxability Mapping Tool (TMT) forstate-based product exceptions
  • Assisted in determination of situs overrides and standard rate overrides
  • Handling of Property Taxes by Asset Accounting
  • Federal and State Income Tax reporting from SAP towards IRS Form 1120 U.S. Corporate Income Tax Return
  • Handling of Airline Taxes Federal ticket tax (FTT), Federal segment tax (FST)

Passenger facility charge (PFC) and Federal security service fee (FSSF)

  • Recommendations for capturing of Taxes and Freight as part of Asset Cost build-up (Currently, SAP GAP) towards Maximum Property Tax savings.
  • Creation of Process Design Documents (PDDs) for Withholding Taxes 1099 Federal and State Tax reporting and 1042 Foreign Vendor/ Non-EmployeeReporting
  • Creation of Functional Specificationsfor Escheat System Interfaces and maintained them in Solution Manager

Confidential – Portland,OR Mar' 08 – Jun'08
Sr. SAP FICO Tax Consultant

Description: As the world's leading truck manufacturer, Confidential division develops and produces vehicles within a global network under the brands Mercedes-Benz, Freightliner, Sterling, Confidential. In North America, Freightliner is the long-haul truck leader known for efficient business solutions and is also a key player in the medium-duty market, offering a range of highly productive vehicles for short-haul and services. Vehicle chassis from Freightliner Custom Chassis are used by some of the most respected names in the delivery, motor home and bus industries. The company had an instance of SAP 4.7 Financials on the North American side and another instance SAP 4.7 instance on the Mexico and Brazil side with Financials and Sales and Distribution which are linkedby Application Link Enabling (ALE). The two South American nations follow the VAT (Value Added Tax) form of taxation and the tax configuration had to be supervised/verified for the internal development team.

Responsibilities:
  • Demonstration of Inflation Index Adjustment functionality to revaluate inventory based on currency fluctuations and inflation indices.
  • Demonstration of Market Price Determination functionality to revaluate inventory based on recent market prices.
  • Verification of Foreign Currency Conversion in accordance with FASB 52 Guidelines
  • Tax code configuration verification for Mexico Taxation, Impuesto al Valor Agregado, IVA which is a kind of Value Added Tax (VAT) and varies by location and nature of transaction.
  • Configuration of European Union Value Added Tax (EU VAT) for United Kingdom, Germany, Ireland, Netherlands and France using Calculation Procedures, Condition Types and Process Keys
  • Creation of Functional Specificationsfor Interfaces and maintained them in Solution Manager
  • Verification of Goods and Service Tax (GST), Provincial Sales Tax(PST) and

Harmonized Sales Tax (HST) for Canadian taxation.

  • Verification of Tax links from SD and MM-PU to Vertex for calculation of Sales and Use Taxes for intra – US transactions. Authentication of the Tax Register File tocreate returns by use of INSOURCE application.
  • Configured Rules for the Vertex Tax Decision Maker (TDM) to handle
  • Customer Tax Exceptions
  • Product Tax Exceptions
  • Jurisdiction Exceptions
  • Generation of Vertex Register Reports for taxes, taxable sales and exempt sales
  • Verification of tax code configuration for Imposto Sobre Produtos Industrializados (IPI), Imposto s. Circulação de Mercadoria e Serviços (ICMS), Substituição Tributária and
    Imposto Sobre Servicos (ISS) for Brazilian taxation.
  • Verification of tax code configuration for COFINS(Contribuição para o Financiamento da Seguridade Social) and PIS (Programa de Integração Social) which are federal taxes charged on gross receipts on the import of goods and services from overseas for local Brazilian taxation
  • Verification of tax code configuration for Imposto Sobre Servicos na Fonte (ISSF), Imposto de Renda Retida na Fonte (IRRF) for Brazilian Statutoryrequirements.
  • Verification of configuration of Nota Fiscal generationfor Goods Movement for Brazil
  • Assist with the preparation of the quarterly and year end foreign tax information packages used in the preparation of the Company's US tax reporting and US GAAP reporting including the documentation and support of the foreign entities' deferred taxes and FIN 48 positions accounting for uncertain tax positions, including recognition and measurement of their financial statement effects.

Confidential– Dallas, TX Sep' 2007 – Feb'2008
SAP Finance Team Lead

Description: Confidential is a leading provider of Network, Visual Display and IT solutions. They were partially on SAP systems and partially on legacy systems. The organization had as many as seven business units which had to report to both American and Japanese headquarters with a closing and consolidation process requiring substantial amounts of resources and advanced preparation. The organization decided to implement SAP ECC 6.0 using the GSAP methodology throughout the organization toleverage the expedited closing and parallel accounting offered by the new General Ledger.

Responsibilities:

  • Activation of New General Ledger and definition of leading/non-leading Ledgers for reporting To SEC and NEC Japan according to US GAAP and Japanese GAAP respectively
  • Definition of currencies for Leading ledgers and segments towards segmental reporting.
  • Definition of characteristics for Document Splitting for the New General Ledger Accounting and activation of document splitting.
  • Defined Account Determination for real time integration with Controlling for reconciliation postings.
  • Enhancement of additional account assignments for open items
  • Balance carry-forward of accounts managed on an open-item basis and reconciliation accounts for customers, vendors and others.
  • Transferring of balance carry forward for balance sheet accounts not managed on an open-item basis.
  • Transfer of documents from the old General Ledger to the New General Ledger.

Taxware Consultant/ Business Analyst Jun' 2007 – Aug'07
Confidential– Philadelphia, PA

Description: Confidential is a leader in the global research laboratory industry with worldwide sales in excess of $3 billion US dollars. VWR\'s principal customers are major pharmaceutical, biotechnology, chemical, technology, clinical, food processing and consumer product companies, universities and research institutes, governmental agencies, environmental testing organizations, and primary and secondary schools. They were currently on an outdated version of Taxware (3.4.1) andwere behind the latest version (3.5.5) by about six releases. They had a custom home-built Order Entry system (ESS) delivered by Industry Matematik International (IMI). Being a non-standard ERP solution, and having reporting solutions from a different vendor (Insource), the impacts on their system processes while upgrading their Taxware had to be looked into as well.

Responsibilities:

  • Assisted the Project Manager in defining the scope and statement of work.
  • Mapping of AS–IS and TO-BE processes.
  • Creation of process flows and contextual diagrams of system architecture
  • Outlining the changes in Taxware to the Business and culling of relevant changes.
  • Assisting Developers in communicating requirements of Taxware parameters and redirection of existing applications.
  • Estimation of effort in upgrade and modification of existing system (Function Point Estimation)
  • Liasoning with System administrator in selection of version specific directories for Taxware installation, system and Taxaudit files
  • Validation of Goods and Service Tax (GST), Provincial Sales Tax(PST) and

Harmonized Sales Tax (HST) for Canadian taxation.

  • Ensuring the integrity of their product code mapping to Taxware's product codes
  • Discussing with Business the need for freight reporting in specific states and modification of Taxware parameter files.
  • Restricting Taxware Directory access towards SOX compliance.
  • Discussing the possible impact of Max Tax Law changes in Arkansas and Tennessee with the client on their business.
  • Creation of Test plans for functionality testing.
  • Creation of training material and knowledge transfer to the client
  • Instruction of Accounting Department towards manual creation of Quarterly reports from the New Taxaudit file

SAP FICO Consultant (Sole Resource for BPNA Ops.) Feb' 2007 – Apr'07
Confidential - Toledo, OH

Description: Confidential is a British manufacturer of glass and is an OEM supplier of automotive windshields to BMW and Mercedes Benz. The company had just rolled out a single instance of SAP in North America and had post production issues with integrating with their Brazilian units. Brazil utilizes the VAT (Value Added Tax) form of taxation. Whereas in most countries, goods are taxed during a sale, taxes are levied in Brazil for goods movement. This necessitates the creation of a Nota Fiscal, which is a
Legal document that must be accompanied by each goods delivery and contains all the tax information.

Responsibilities:
  • Verification of tax code configuration for Imposto Sobre Produtos Industrializados (IPI),Imposto s. Circulação de Mercadoria e Serviços (ICMS), Substituição Tributária and
    Imposto Sobre Servicos (ISS) for Brazilian taxation.
  • Verification of tax code configuration for COFINS(Contribuição para o Financiamento da Seguridade Social) and PIS (Programa de Integração Social) which are federal taxes charged on gross receipts on the import of goods and services from overseas
  • Verification of tax code configuration for Imposto Sobre Servicos na Fonte (ISSF), Imposto de Renda Retida na Fonte (IRRF)
  • Configuration of European Union Value Added Tax (EU VAT) for United Kingdom, Germany, France, Sweden and Denmark using Calculation Procedures, Condition Types and Process Keys
  • Verification of GL accounts for Tax Liabilities.
  • Verification of configuration for automatic Nota fiscal triggering during invoice creation, goods movement and sales order creation.
  • Demonstration of manual Nota Fiscal creationby Nota Fiscal writer
  • Tax reporting customization for Decl. de Informações do Imposto sobre Produtos Industr. (DIPI), Registro de Apuração do (IPI) and Registro de Apuração do (ICMS)
  • Knowledge Transfer to client and documentation of configuration processes.

Confidential, Atlanta, GA Sep'06- Nov'06
SAP FICO Consultant,

Description: Confidential is the leading provider of innovative solutions for the global sleep and respiratory markets. They were currently on an older version of SAP 4.7 andwere behind the latest version ECC 6.0 new release of the New Unified General Ledger. With waning support for the existing General Ledger as well as other modules including Profit Center Accounting (EC-PCA) and having tedious and lengthy closing processes, they decided to migrate to the New General Ledger.

Responsibilities:

  • Assisted the Project Manager in defining the scope and statement of work.
  • Mapping of AS–IS and TO-BE processes.
  • Creation of process flows and contextual diagrams of system architecture
  • Activation of New General Ledger and definition of leading/non-leading Ledgers for reporting to SEC and VWR Europe according to US GAAP and UK GAAP respectively
  • Definition of currencies for Leading ledgers and segments towards segmental reporting.
  • Definition of characteristics for Document Splitting for the New General Ledger Accounting and activation of document splitting.
  • Enhancement of additional account assignments for open items
  • Balance carry-forward of accounts managed on an open-item basis and reconciliation accounts for customers, vendors and others.
  • Transferring of balance carry forward for balance sheet accounts not managed on an open-item basis.
  • Transfer of documents from the old General Ledger to the New General Ledger.
  • Defined Account Determination for real time integration with Controlling for reconciliation postings.
  • Creation of User Training material and knowledge transfer to the client

Confidential, Minneapolis, MN Apr'06 - Aug' 06
SAP FI/CO Analyst,

Description: Confidential its business by making major acquisitions and take over bids.The company's warehouse and customer base was no longer confined to a finite geographical location.The existing pre-configured tax codes in SAP wasno longer able to meet their needs. Hence, they decided to move towards an external tax calculation package, the Vertex “O” series.

Responsibilities:

  • Assisted Project Manager in creation of milestones towards:
    • Analysis and planning
    • Installation and integration.
    • Testing
    • Setting up and maintaining of taxability data
    • Collection, accrual and remission of tax
    • Reporting and auditing
  • Integrated SAP with the “O” Series SAP Integration Component (SIC) to connect to the third party package.
  • Configured SAP to pass crucial parameters towards determination of nature of taxes (Sales and Use tax) and tax rates
  • Redirected SD and MM-PU master data links to Vertex.
  • Setting up of user defined tax codes.
  • Reverted the user exit FYTX0002 tosystem administered default values (the ship-from jurisdiction maintained on the plant as the POA, and the ship-to jurisdiction maintained on the customer as POO)
  • Mapping of Organization Product codes with Vertex product codes.
  • Determination of GL accounts for Tax Liabilities.
  • Assisted Tax department in customization of Vertex Sales Tax Returns (STR)
  • Creation of Test plans for functionality testing.
  • Creation of training material and knowledge transfer to the client.

Confidential, Benton Harbor, Michigan Aug'04-Mar' 06
SAP FI/CO Consultant,

Description: Confidential is the world\'s leading manufacturer and marketer of major home Appliances.The company markets Confidential, Maytag, KitchenAid, Jenn-Air, Amana, Brastemp, Bauknecht and other major brand names to consumers in nearly every country around the world. Confidential global procurement and product development leveraged SAP to help their operations reduce costs, improve efficiencies and introduce a continuous stream of relevant innovation to consumers.

Responsibilities
  • Customized settings for clearing, posting in foreign currencies, exchange rate differences and gains and losses on valuation, realization and translation. Prepared Functional Specifications for technical team for developing customized reports and interfaces.
  • Configured (GL-AP) house banks, payment terms, automatic account determination/FBKP, open item management, reduced in-house processing load by implementing lockbox functionality. Design and configure all banking interfaces, create all file formats using the DME (Data medium exchange).
  • Configured automatic account determination with regard to inter company posting, MM, and SD including Revenue account determination, Revenue recognition.
  • Made settings for Special G/L transactions, Down Payments, Bad Debts Reserves
  • Participated in creating documentation and training key users.
  • Grouped Customers to defined Credit Control Area and Dunning Areas, and configured recurring entries for automatic G/L postings
  • Configured Tolerance limits and managed A/R reconciliation account for sub-ledgers and payment settlement and customized payment terms for customers
  • Configuration of Nota Fiscal generationduring Invoice Verification, Goods movement and Sales Billing for Brazil
  • Configured Tax Procedure Settings, Tax codes for including 1099 and 1042 reporting, terms of payment and interest calculation, integration with Taxware

Controlling:

  • In Cost Element Accounting created Primary and Secondary Cost elements, created Cost Element Groups, maintained Cost Element Attributes, Costing Sheet etc.
  • In Cost Center Accounting created cost centers, activity types, statistical key figures, Cost Center Standard Hierarchy, cost center categories, document numbers, maintained default account assignments and automatic account assignments, validations and substitutions, overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations. In cost center planning developed planning area, planning layout and planner profile.
  • Configured basic settings and master data of PCA.
  • Assignment to Profit Centers all objects which store data which is relevant for profits to a profit center
  • Used parallel valuation approaches/transfer prices, made necessary settings in Customizing for the component General Controlling.
  • Performed activities in order to transfer prices specifically in Profit Center Accounting.
  • Configured settings necessary for the entry and allocation of plan data in Profit Center Accounting (Basic settings for Planning, Manual Planning, Profit planning)
  • Made settings necessary for creating and allocating actual data in Profit Center Accounting.
  • In Profitability Analysis (CO-PA) configured both costing based CO-PA and account based CO-PA, created characteristics and value fields, used various derivation techniques and rules, configured valuation using product costing and costing sheet. Defined various reports. Configured CO-PA planning, including creating planning levels plan package and planning methods.
  • Executed report determining the difference between the material stock accounts in Materials Management and Financial Accounting.
  • Valuated materials in the valuation area using the material ledger. Assigned currency types to the currency and created material ledger types and allocated currency types to each of these material ledger types. Configured Dynamic Price Changes and defined Movement Type Groups for Material Ledger and Material Update Structure.

Confidential, Charlotte, N.C., Feb'03-Jun' 04
SAP FI/CO Consultant,

Description: SPATCO's information systems had undergone changes and represented a patchwork of
several additions and modifications, apart from being loosely integrated across functional areas. There was duplication and information inconsistency. SPATCO marched ahead from legacy systems with an integrated real-time information system worldwide that improved the visibility and consistency of information

Responsibilities:
  • Configured Company codes, Created and maintained Chart of Accounts, Financial Accounting Global Settings through ASAP process.
  • Configured Document types, Posting Period Variants, Fiscal Period Variants and Financial Statement Versions
  • Created G/L Master Records and Reconciliation Accounts for Sub Ledgers
  • Configured Employee and Vendor Tolerance Groups, customized Account Groups, Field Status Groups and Posting Keys
  • Configured House Banks, Bank Accounts, Check Lots and Void Reason Codes
  • Configured settings for Automatic Payment Program and for Interest Calculation on Account Balances and Line Items
  • Configured House Banks, Bank Accounts, GL structure, Posting Rules for Automatic Assignment
  • Configured Bank Statement processing and Mapping external Transaction Codes to Posting Rules.
  • Validated postings from Sales Order document flow to FI including tax postings in Vertex and performed invoice verification.
  • Configured Liquidity Forecast, Cash Management Position and Cash Concentration. Created Planning Level and Planning Groups and Assigned Internal MM and SD transactions to Planning Levels.
  • Worked with MM and SD Team to Configure Automatic Account Assignments
  • Configured Tax Procedure Settings and integration with Taxware

Controlling:

  • Configured Cost and Profit Centers, CCA Allocations, Primary and Secondary Cost Elements, Activities, Statistical Key Figures and Substitutions
  • Configured the Operating Concern, Characteristics and Value Fields for CO-PA Analysis
  • Set Various Characteristics and Key Figures to Design User Defined Reports to present Complex Data Analysis in Structure using Report Painter Tools
  • Documented the Vital Changes, Performed the System Tests and Trained the members in the client team on New System Functionality
  • In Product Costing configured the settings for new plants that used process manufacturing and enabled calculation of standard cost for valuation of manufactured products. Facilitated the cost center planning and budgeting process to calculate activity prices of various operations. Mapped the cost component layout for calculation of direct and indirect costs for product costing purposes and created overhead cost sheet with relevant overhead groups to absorb overheads. Worked on the integration touch points of product costing with production planning (PP-PI) using a process setup that included process orders, master recipes, routings, bill of materials (BOM) and resources. Configured the settlement rules for settlement of variances between target and actual costs.
  • Valuated materials in the valuation area using the material ledger. Assigned currency types to the currency and created material ledger types and allocate currency types to each of these material ledger types.
  • Involved in writing Integration Testing Scripts as well as User Acceptance Testing Scripts and supported the client in Post Launch Session and worked on Post Production Issues

Confidential, Springdale, AR Mar'02-Dec' 02
FI/CO Consultant,

Responsibilities:

  • Business Process Activities: Studied the AS-IS processes and suggested the TO-BE processes using ASAP Methodology/Tools.
  • Business Solution Development: Mapped the To-Be business processes/scope and mapped the same to SAP R/3.
  • Participated in Defining Management Strategies for Implementing SAP R/3 FI/CO
    Module General Ledger (FI-GL) Posting period variant, GL account accounts, field status variant, recurring entries, multiple currencies, inflation, exchange rate valuation, document type and posting keys, financial statement versions, regrouping, integration with MM and SD
  • Configured Asset Accounting Module (FI-AA). Account Determination of Transactions like retirements and transfers. Capitalization of Assets via Internal Orders for Capital/Project Appropriation Requests.
  • Investment Measures for budgeting and planning of capital costs and depreciation.
    Profit Center Accounting: (CO-PCA) Mapped Profit Centers to External Organizational Units.
  • Defined Master Records for G/L, A/R and A/P. Configured the Payment Program for Automatic Payment to Vendors. Configured the Lockbox, Terms of Payment and Dunning program for A/R. Configured the Employee Tolerance Groups for Clearing against a Customer
    Account .Customized Accounting Transactions for G/L, A/P, and A/R such as Account
    Assignment Models and Recurring Entries.
  • Configuring and Customizing Product Cost Planning (material costing with and without Quantity Structure) and Cost Object controlling including product cost by order (product cost collectors and cost object hierarchies), by period (manufacturing orders) and by sales order. These configurations and customizations also involved costing variants, valuation variant, cost component structures, cost component splits, costing sheets
  • Set up the Cost Centers, Profit Centers and Primary and Secondary Cost Elements
    Defined the Statistical Key Figures and Standard Hierarchy. Configured the Operating Concern, Characteristics, and Value Fields for CO-PA analysis.
  • Valuated materials in the valuation area using the material ledger. Assigned currency types to the currency and created material ledger types and allocate up to three currency types to each of these material ledger types.

Educational Qualification:

  • MBA (Finance)
  • B.S, Computer Science

We'd love your feedback!