OBJECTIVE

• To obtain Confidential position in SAP BPC Functional Consultant that will utilize my current skills and offer an opportunity for growth.

TECHNICAL SKILLS

Databases: ORACLE, MS - ACCESS, VISUAL BASIC, dB III +, dB IV, Ad WareSQL*PLUS, PL/SQL, Hyperion Planning, People-soft, GEAC, HCRS, COGNOS

Languages: SQL, COBOL, FOXPRO, CLIPPER, LOTUS 1-2-3, COLD FUSION, INTRO TO “C”

Software: Excel, ACCESS, MS-Word, Word Perfect, Power Point, Peachtree, Microsoft 2000, AS-400, MS-DOS, Ad Clock, Quick Books, CARS(I-MANY), Hyperion, JAMIS, CODA, BPC, FICO, ECC

O.S: DOS, Windows 95, Windows 98, Window ME

Internet: Netscape, AOL, HTML, Fiber Optic Cable

PROFESSIONAL EXPERIENCE

Confidential

SAP BPC Functional Consultant

Responsibilities:

• Review state Medicaid invoices for Fee for Service, MCO, JCODE & Supplemental and log invoices received into Medicaid Control Log.
• Maintain good communication with internal management team regarding any issues which may lead to over stated units, reduced reimbursement and/or claims incorrectly reported by states.
• Track findings and share information which impact quarterly finance accruals and forecasts with the relevant departments.
• Analyze claim level detail to mitigate leakage - dispute units which are not rebate eligible.
• Review, analyze, and compare to transactional detail available for other government programs; prepare results for Manager s review.
• Prepare invoices and utilize OCR system to ensure each labeler detail is correct with scripts, units, and rebate amount for each submission before uploading into Revitas system.
• Assist manager in applying interest for payments and entering payment information into Oracle, as well as ensuring all payments are properly documented and accounted for.
• Maintain communication and work with state to notify of disputes found and/or propose findings for correction.

Confidential

SAP BPC Functional Consultant

Responsibilities:

• Gather the requirements for blue print and build the reports based on Functional spec requirements
• Experience in extracting data from ECC System
• Worked on maintenance of dimension members and dimension properties
• Build and implement SAP BPC reports using models (Consolidation, Finance and IRP) within the BPC.
• Build reports to allow users to select dimension settings and rerun reports based on those settings.
• Build reports to allow users to select worksheet generation by selecting various Profit Centers.
• Allow business to distribute multiple reports Confidential one time using book publishing or book distribution.
• Reports display various groupings of data by time periods (individual months or multiple months)
• Reports include account grouping subtotals and variance calculation columns.
• Reports require EPM Formatting standards.
• Build the Test-Scripts for the reports implemented
• Work and processed the open defects related to reports submitted to the business owners
• Build and implement input templates for International Revenue group
• Design input template to allow system to accept straight user input and totals

Environment: SAP BPC, SAP 730, ECC, EXCEL, EPM Office Add-In Excel

Confidential

Financial Data Analyst

Responsibilities:

• Perform reconciliations and analysis between data files and financial systems, identifying data related issues, categorizing issues and documenting recommended data corrections to allow reconciliation to take place effectively within Sales, Account Receivable and Customer Rebates.
• Processed Financial Business specifically related to Sales, Customer Invoicing, Rebate Calculations and Account Receivable
• Performed reconciliations from source data files to company general ledger
• MS Excel and SharePoint is used to access data for credits, checks, QAD CB, CARS Rebates data
• Retrieve data for QAD, CARS rebates & Chargeback using SAP
• Process each entities mapping files and Trial balance, Categorize and address any issues when upload data to SAP
• Correspond with reject list to respective entities to adjust any mapping issue or formatting issues
• Run Financial Validation Report through SAP using LEGALCONS tools and submit financials for approval
• Upon approval process data using ICMATCHING to process any intercompany data
• Perform Chargeback cleanup and other backfill work to support the business team
• Analyze and process rebate claims using Model N Production
• The duties of this position include, but are not limited, to the following areas:
• Utilize SAP FI/CO modules for Revenue activities
• Determine all GL accounts for reconciliation based on analysis of business transactions.
• Reconcile transactions from Revenue Management System (data pulled from repository) to Financial data Confidential the account, customer, and product levels.
• Review all financial transactions (General Ledger, Accounts Receivable, Accounts Payable) for relevance to GP pricing
• Follow reconciliation procedures for reporting errors and all documentation for compliance and auditing purposes
• Accounts Receivable: Customer groups, customer master data, payment terms and interest calculation, incoming payments, closing operations, and integration with SD.
• Monitoring day to day accounting, closing of periodic books of accounts and its review, review of general account balances and ensuring its correctness.
• Ensuring books of accounts are kept in accordance with the statutory requirement.
• HANA and SAP FICO Financial reports extraction.
• Integration with MM and SD: Integration of FI with MM (P2P) and SD (OTC) modules Billing and Revenue account determination.
• General Ledger Accounting (FI-GL): Chart of Accounts, Accounts groups, Creating G/L
• Account and creating an account in the company code area(FS00)
• Worked on the interface between external revenue system (CS/MN) to SAP system.
• Maintaining the revenue account determinations & revenue recognition which is useful in integrating AR-SD.

Environment: MS Excel and SharePoint is used to access data for credits, checks, QAD CB, CARS (Revitas) Rebates data, COGNOS, SAP Business Object, Model-N Production, BODS (Business Object Data Services), SAP SD & FI/CO, HANA Interface

Confidential

Business Analyst

Responsibilities:

• Assisting the Government Pricing Department with Data Validation
• Archiving to TRIM and general Government Pricing Projects like working on Excel comparing results for different system such as CARS/MEDI, DDR, GPS.
• Analyze large sets of data using excel (Vlookups. Pivot Tables)
• Analyze Excel results and determine the variances
• Excel projects were to evaluate the correct Best Price, URA for all the system used by JNJ
• Other related tasks may be assigned as needed to meet timelines

Environment: Excel, COGNOS (Impromptu), CARS (I-MANY), Power Play, GPS, DDR, TRIM, Daily Med, JNJ Gateway Commerce

Confidential

Analyst

Responsibilities:

• Validate/audit Medicaid rebate claims to ensure that the State submitted accurate units/unit of measure as related to recommended product dosing, by analyzing claim level detail from State Program, DNA data, utilization trend data, and pharmacy/physician state reimbursement.
• For Supplemental, confirm PDL status and review all current contracts/agreements to determine proper treatment of rebates.
• Complete all aspects of the claim invoice processing, ensure that payment is accurate and prepare payment vouchers for claims submission to accounts payable in Confidential timely manner and as defined in the SOP.
• Develop and maintain all control documentation to support SOX compliance.
• Analyze and prepare proposals/settlements for all Medicaid, Supplemental, ADAP, SPAP and J-Code disputes. Monitor dispute resolutions & insure that proposals are accurate upon validation of State/Program utilization.
• Provide continual updates and maintenance of the Government Contracts User Guides (IFF Payment User Guide, PHS User Guide, CoC User Guide, etc.).
• Assist with audits, legal requests, ad-hoc reporting and special data requests.
• Provide operational support, (membership/product/pricing) updates to the Federal Contracts (FSS, BPA’s and PHS).
• Provide continual monitoring of all current Tracking Account Customers as well as renegotiation of new customers as required
• Provide operational support (rebate processing) for TRICARE Rebates.

Environment: Excel, HCRS, COGNOS (Impromptu), CARS (I-MANY), Power Play

Confidential

Analyst

Responsibilities:

• Responsible for the review of eligibility for the companies discount program (APEX).
• Manages APEX forms and reviews for completeness.
• Maintain and update characteristics in the CARS/IS computer system.
• Researches and analyzes chargeback issues and resolves discrepancies.
• Reconciles discrepancies in eligibility / Reconciles irregularities between submitted and actual discounts values
• Runs reports as needed.
• Partner with Rebate team and Customer Service (as needed) to ensure proper system set-up, accurate pricing terms and rebate terms
• Working with both GPO and Managed Care contracts.
• Analyze customer performance to determine the effectiveness of performance-based contracts. (Managed Care)
• Analyze quarterly (GPO - Group Purchasing Organization) baseline data to determine rebate payments.
• Ensure formulary complies with terms of the agreements.
• Analyze contract exceptions for interpretation in the system(s) for accuracy of calculations/process compliance.
• Manage all aspects of contracts including analyzing terms and conditions to appropriately set up contracts, plan membership maintenance, contract amendments and contract discount structure maintenance
• Perform membership analysis on GPO (Group Purchasing Organization) members to assign appropriate class of trade and contract eligibility. Randomly audit members to ensure members meet eligibility criteria.
• Review customer invoices to ensure compliance with contract terms and conditions. Load data into data pre-processor (ECP - internal s- Confidential data processing system) within two weeks of rebate submission receipt.
• Verify that all product and plan data submitted complies with contract requirements - interact with customers and account managers to resolve any data discrepancies
• Analyze and process quarterly GPO administrative fee payments.
• Analyze rebate payments utilizing reporting tools to compare quarterly sales, rebate, utilization and market share trends.
• Manage workload appropriately to ensure payments are made on time.

Environment: Excel, COGNOS, CARS (I-MANY), Power Play

Confidential, Parsippany, NJ

Financial Analyst

Responsibilities:

• Budgeting, forecasting, monthly actual reporting and variance analysis
• Provide financial analysis, reporting and planning
• Assist with the preparation of the monthly office metrics, regional packages
• Interface with management and alert them of significant variances to the plan
• Serve as the point of contact of US offices and department managers related to regional services, career development, and HR
• Assist with special projects as the need arises monthly G/L closing activities, including accruals create and maintain business partner relationships with clients

Environment: Hyperion Planning, ESSBASE, JAMIS, CODA, Power Point, Excel, COGNOS

Confidential, Parsippany, NJ

Senior Real Estate / Business License/ Personal Property Tax Accountant

Responsibilities:

• Prepare and review financial statements on Confidential monthly basis. Includes, but not limited to the following: comprehensive review of taxes paid, expenses, payroll entries, variance analysis and maintenance of supporting documents.
• Reviewing, evaluating and processing Real Estate Tax Payments & State and local business licenses
• Set-up of yearly & fiscal year Real Estate tax accruals
• Review of lease abstract for tax purposes & tax invoices/checks for payment
• Preparation of audit assessment notices for excessive increase in value
• Interaction with landlord, consulting firms, outside counsel, assessors & Zone controllers
• Working with team to prepare monthly closing statements including detailed account analysis and all required journal entries & supporting schedules.
• System Conversion: Assisted in acquisition of Budget Rent Confidential Car. Included auditing records, integration and application of numerous systems, and transferred all responsibilities of employees from Orlando.
• Analyze and prepare account reconciliation’s for the management team both international and domestic entities. Follow up with support and subsidiary schedules.
• Ad hoc projects and analysis performed Confidential management’s request.
• Responsible for Business Licenses for entire United States
• Preparation of over 200 state & local business license returns and process payments
• Researched for locations present in every City, Town or County
• If the location closed then ask them for refund and If the location is open then fill out the renewal form
• Move all the work from Orlando, FL to Parsippany, NJ (responsible for Budget accounts)
• Supervise one staff member for Business License related work responsibility

Environment: People soft, Walker, Citrix Server, Hyperion, COGNOS, GEAC, and Oracle

Confidential

Property Tax Accountant

Responsibilities:

• Preparing multiple state income tax returns
• Preparing state annual reports for 150 legal entities and filing / maintaining notice responses in state files
• Prepare tax provision schedules, perform account analysis related to tax reporting
• Contact with outside tax authorities and consultants, as required
• Processing of client distributions on Confidential quarterly, semi-annual or annual basis
• Process and monitor the property tax and business license payments and assessments
• Review and monitor payment and accuracy of property tax assessments and business licenses
• Handle and follow-up on the collections of dishonored checks.
• Identify the account by board of county commissioner, school district, and city commission (the mileage rates for the properties are set by them)
• Pay the penalties if delinquent (The amount due on delinquent payment is determined by date received, not by postmark)
• The discount is determined by postmark of payment; the total amount is due in March
• Enter bills for Confidential &T Solution, Confidential &T Global Network, Network and Non-Network bills into the PTS, COI-TOPS system

Environment: PTS, COI, TOPS, MS-WORD, EXCEL, POWER POINT

Confidential, Lawrenceville, NJ

Staff Accountant

Responsibilities:

• Supported the Corporate Finance Department in achieving business objectives.
• Reviewed and analyzed monthly data and presented findings to Manager.
• Assisted with forecasting, budgets, and variance analyses.
• Performed spreadsheet/financial modeling using Excel.
• Audit Expense Reports for accuracy and receipts, as well as, adhere to Corporate T and L Policy
• Code expense reports and vouchers to be entered into Ad-Ware Accounting System
• Enter vouchers and expense reports into Ad-Ware Systems
• Generate edit report for review prior to posting vouchers
• Post vouchers after edit has been reviewed and modification processed
• Communicate with vendors and employees as required
• Follow up expeditiously with all phone messages
• Respond expeditiously with all Confidential -mail
• Assist in the reconciliation of advance and clear balances as required
• Filling of vendor and expense vouchers
• Open mail daily and action taken accordingly