Taxpayer Management Lead Resume
Harrisburg, PA
PROFILE SUMMARY
- 5+ years of SAP FI/CO & FI/CA functional experience mainly emphasis on the configuration, maintenance and testing of FI/CO & FI/CA using SAP ECC 5.0 and ECC 6.0 and a combination of 6+ years of SAP/Financial Analysis mainly emphasis on the Financial Statements/Ratio Analysis, Financial Modeling and Technical Analysis.
- Hands on implementation experience of 3 full life cycles with ASAP methodology including Business Process Re-Engineering, GAP Analysis, Configuration, Testing and Integration ofFI/CO with SD and MM.
- Extensive functional experience in FI-General Ledger (GL), FI-Accounts Payable (AP), FI-Accounts Receivable (AR), Profitability Analysis (CO-PA), Cost Center Accounting (CO-CCA),Profit Center Accounting (EC-PCA), Public Sector Collection and Disbursement (PSCD), Tax and Revenue Management (TRM) and FI-Contract Accounts Payable and Receivable(FI-CA).
- knowledge of business process flow in SAP tables.
- Skilled in the use of Ad Hoc Reporting tools.
- Strong knowledge of RDBMS Design, Development, and Implementation: Microsoft SQL Server (7.0/2000), Oracle, PL/SQL, Microsoft Access and Entity-Relational modeling.
- Excellent analytical and problem solving skills helped to provide new ideas to simplify the business and technical process.
- Strong interpersonal and communication skills, good team player, detail oriented and able to communicate to all organizational levels.
- High learning curve with the ability to embrace new tools and technology with ease.
Financial Accounting: General Ledger FI-G/L, Accounts Receivable FI-A/R, Account Payable FI-A/P, Public Sector Collection and Disbursement (PSCD),Tax and Revenue Management (TRM), FI-Contract Accounts Payable and Receivable (FI-CA), Dunning, Substitution and Validation, Credit Management, Automatic Payment Program, and Special Purpose Ledger FI-SL
Controlling: Cost Element Accounting CO-CEL, Cost Center Accounting CO-CCA, Profit Center Accounting CO-PCA, Profitability Analysis CO-PA, Internal Orders, Activity Types, Statistical Key Figures, Distribution and Assessment Cycles, Planning
Treasury: House Banks, Manual Bank Statement, Electronic Bank Statement, Exchange Rates, Lock box and Translation Ratios
Implementation: Business Analysis, Requirements Gathering, GAP Analysis and Solution Delivery, Enhancements, and Integration of various SAP ECC applications like SD and MM with FI/CO
SD/MM: Co-worked with SD/MM consultants to assure seamless FI/SD, FI/MM integration. Working knowledge of Sales Order, Purchase Order, MIGO, MIRO, Billing Document, Delivery, Confirm Picking, Goods Issued, GR/IR, Customer Master data, Material Master data, Vendor Master Data, BOM.
TECHNICAL SKILLSERP Applications: SAP ECC 5.0, ECC 6.0(EHP4 & EHP5)
SAP R/3 Tools: Report Painter, Report Writer, Solution Manager, BW/BI Extraction/Reporting.
Operating Systems: Windows 2000 & 2003 Server, Windows XP, Windows Vista, Windows 7 Red Hat Linux 9.0, Unix/Solaris, SUSE Linux.
Databases (DBs): Oracle, MS SQL Server.
Tools: SQL Navigator, SQL*plus, Crystal Reports, Remedy ARS 6.3, Peregrine Service Center 6.3.
Applications: MS Office suit: Microsoft Word, Excel, Access, PowerPoint, MS VISIO, MS Project, MS outlook and Adobe Photoshop 6.
WORK HISTORYCompany: Confidential, Harrisburg, PA
Period: January 2011 – April 2012
ERP: SAP ECC 6.0 EHP5 (Full Life Cycle)
Role: Taxpayer Management Lead (Focus: Entity Registration FI-CA)
Project: ITS (Integrated Tax System)
Implementation Partner: Accenture
Company Profile:
The PA Department of Revenue originated in 1927 and began operating in 1929. Its mission is to administer the tax laws of thecommonwealth in a fair and equitable manner. The Department of Revenue also administers the Pennsylvania State Lottery, which generates funds for programs that benefit older Pennsylvanians.
Thedepartment is responsible for collecting Personal Income Tax, Sales and Use Tax, all corporate taxes, Inheritance Tax, Realty Transfer Tax, Motor Fuel Taxes and all other state taxes. In addition, thedepartment collects the Local Sales Tax for Allegheny and Philadelphia counties, the Public Transportation Assistance Tax and funds for the Pennsylvania Intergovernmental Cooperation Authority.
Thedepartment also administers the Property Tax/Rent Rebate program and the Public Utility Realty Tax reimbursement, prepares the tax expenditure portion of the Governor’s Budget and licenses distributors and manufacturers of small games of chance.
Responsibilities:
Implement the configuration management plan as directed by the Functional Lead. Assist in the design of software configuration and customization to meet the business process design and application requirements.
- Responsible for Phase 1 Corporate Tax design, build, support, system testing and unit testing
- Acted as the functional SME for supporting client resources and consulting resources
- Delegated and assigned configuration tasks and tracked status of deliverables
- Monitored the end to end Entity Registration configuration deliverable.
- Reviewed and modified Entity Registration activities which included the configuration and set up of Business Partners, Contract Accounts and Contract Objects in the system.
- Identified, mapped and cross referenced business requirements to business processes.
- Administered end to end testing for Taxpayer Management.
- Worked with RICEFW lead to confirm Technical Design updates based on Functional Design modifications.
- Reviewed data mapping documents and addressed questions and concerns from the conversion team.
- Reviewed status reports and attended Management weekly status meeting.
Company: Confidential (Comptroller of Maryland, Annapolis, MD)
Period: November 2009 – December 2010
ERP: SAP ECC 6.0 EHP4 (Full Life Cycle)
Role: Taxpayer Accounting & Revenue Accounting Lead (Focus FI-GL, FI-CA)
Project: MITS (Maryland Integrated Tax System)
Implementation Partner: Accenture
Company Profile:
The Comptroller of Maryland Agency is the collector of revenue for state programs. Comptroller of Maryland is the provider of information technology services for most state agencies for the state of Maryland. It also regulates the State’s alcohol, tobacco and motor fuel industries.
Responsibilities:
Implement the configuration management plan as directed by the Functional Lead. Assist in the design of software configuration and customization to meet the business process design and application requirements.
- Responsible for Phase 1 Taxpayer Accounting/Revenue Accounting design & build, support & system testing, and unit testing
- Acted as the functional SME for supporting client resources and consulting resources
- Delegated and assigned configuration tasks and tracked status of deliverables
- Monitored the end to end General ledger configuration deliverable.
- Reviewed and modified Month End Year End closing activities to capture business process and requirements.
- Administered end to end testing for tax payer accounting and revenue accounting.
- Worked with RICEFW lead to confirm design updates based on modifications
- Performed RICEFW item transitions and updated RICEFW master document
- Reviewed status reports and attended Management weekly status meeting
Company: Confidential., Wilmington, DE
Period: December 2006 – November 2009
ERP: SAP ECC 5.0 (Full Life Cycle)
Role: FI/CO Functional Consultant (Focus AR, AP and GL)
Project: NATP (North American Transaction Processing)
Implementation Partner: Accenture
Company Profile:
World leading pharmaceutical company, with a world-class biologics capability.
Active in over 100 countries with a growing presence in important emerging markets including China; corporate office in London, UK; and major R&D sites in Sweden, the UK and the US.
Responsibilities:
- Configured interviews with users to gather requirements and to understand the flow of the As-Is system.
- Analyzed workflow to design solutions and designed the To-Be solution.
- Conducted GAP analysis, documented the findings, assessed scope of studies and suggested solutions through SAP for implementation and customizations.
- Configured General Ledger Accounts master records.
- Involved in configuring field status groups, Posting keys, Inter-company postings, financial statement versions.
- Defined and configured Vendor master data: Creating Vendor and Customer master data.
- Configured customer and vendor account group for domestic and one-time customer and vendor. Defined number ranges and customer tolerance limits.
- Configuration of house banks, Bank accounts, GL structure, posting rules for automatic assignment.
- In Automatic Payment Program for vendors configured paying company code data, country payment methods, and other factors needed for payment program.
- Configured all business transactions for Accounts Payable and Account Receivables including the Payment Program Configuration and Automatic Check Payment Advice and Payment Analysis Printing, Clearing of Vendor and Customer Open Items, Bank Master Data, House Banks for Payment Program, Credit Management, Periodic Processing, Correspondence.
- Configured the house banks, G/L accounts for Bank accountsand bank account reconciliation program. Defined forms of payment guarantee, defined and assigned payment guarantee, activated documentary payments per item category. Integration of MM and SD with FI account assignment.
- Worked on the different processes of OTC (Order To Cash) and P2P (Procure to pay).
- Worked on the whole flow of P2P (Procure to Pay) including the creation of the purchases order, good receipts, invoice receipt and outgoing payments.
- Solved different issues of GR/IR Mismatch.
- Defined accrual object categories, number range intervals, accrual types and methods.
- Worked on the custom report for calculating the accrual against the contracts.
- Configured settings for Controlling Area and Operating Concern, maintained Versions.
- Worked on SRM(Supplier Relationship Management) to create the purchase orders, created Account assignment models for recurring entries.
- Set the customer and vendor master data. Defined the field status for the groups.
- Define multiple payment method for ACH, Wire Transfer, checks and for foreign currency.
- Worked on Electronic bank statement (EBS),Pay, ACH payments and Wire Transfer.
- Configured ERS based invoices, Logistic invoice verification (LIV) and wrote the functional specification of different FRICEobjects.
- Configured tax , used calculation procedure TAXUSX to handle the US sales and use tax calculations
- Worked on the enhancement like positive pay, legal entity payment through different profit center as an entity using the document splitting.
- Configured Down payment, check forms and worked on EDI outbound and inbound 820,828.
- Defined Lockbox for better liquidity, depositing, crediting of checks, and reducing processing workload. Gathered business requirement, held meetings with Super users as well as internal IT resources in the process of Lockbox implementation.
- Followed project deadlines in a timely manner to go through scenarios related to meetings with different individuals involved in the project, configuring the lockbox, testing different scenarios,documenting process flow, transporting configuration to production environment, supported the client with issues related with lockbox processing.
- Interacted with different banks on Deciding the Destinationand origin as being the part of lockbox files formatting that will equivalence the standard SAP environment.
- Trained the key business users on the difference between “On account” posting, “Unprocessed” posting, and “partial” posting inBIA2format for better hit rate of matched invoices. Also, trained the users about Transaction codeFLB1to help them manually process the processing documents with formatting errors, processing payment advice notes, and changing, supplementing or deleting clearing information.
Company: Confidential, Prospect Heights, IL
Period: June 2005 – December 2006
Role: Treasury Analyst
Company Profile:
Confidential is one of the largest banking and financial services organizations in the world, have international network comprises in Europe, the Asia-Pacific region, the Americas, the Middle East and Africa. With listings on the London, Hong Kong, New York, Paris and Bermuda stock exchanges.
Responsibilities:
Extracted, processed, and validated data from Bank’s Transactional and Accounting Systems to Produce Periodic (Weekly, Monthly, and Quarterly) Treasury Reports
- Statutory reports: Balance sheet sensitivity to interest rates, derivatives credit risk, and pledging.
- Conformity reports: Asset concentration, asset quality, and capital requirement.
- Internal management reports: Liquidity ratios, current assets, liability maturity, and cash flow.
- Performed end-of-day maintenance operations on bank information systems.
- Familiarized with trading floor and back office operations.
- Generated financial and operational projections (i.e. expenses per headcount, expenses per department and project, capital expenditures).
- Worked on Balance Sheet Forecasting, Funding Strategies, Cost and Risk Analysis.
- Monitored expenses to ensure compliance with budget by performing monthly variance analysis. When not compliant, inquired about reason for discrepancy and resolved promptly.
- Reconciled financial records and statements with general ledger
Bachelor of Business Administrationin Finance,