PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Master Data/Business Analyst

• Supported synchronization of master data across multiple systems including SAP.
• Supported internal controls and audit information requests.
• Troubleshooted and resolve any master data issues that impacted operational issues.
• Maintained and updated reporting procedures.
• Maintained good communication with business partners regarding master data requests.
• Supported Master Data Management processing and validations for Items, Customers, Pricing, Discounts .

Confidential, Woodcliff Lakes, NJ

Data Analyst (Temp)

• Analyzed trends in dealership retail performance to improve and drive retail performance.
• Analyzed impact of the progressive sales process models
• Using formulas, researched key performance indicators (KPI) to ensure process effectiveness and performance.
• Developed a trending analysis to determine future programing needs.
• Interacted with regions to ensure dealer monitoring for both BMW and MINI.
• Provided program support for Dealer Performance Coaching (DPC), Market Reviews, Performance Improvement Plans, Sales Strategy, Executive, Field and Dealer Communications

Confidential

Master Data/SAP Analyst

• Served as the subject matter to improve SAP and be the focal point f or SAP reporting and BI reporting
• Ensured that all data is maintained in SAP with complete accuracy while enforcing data standards.
• Assisted in the coordination of new product roll - outs that needed to be completed in a timely manner.
• Run recurring reports to initiate clean up opportunities, using Pivot tables and formulas.
• Troubleshoot and resolve any master data issues that impacted operational issues.
• Maintained and updated reporting procedures.
• Maintained good communication with business partners regarding master data requests.

Confidential, Jersey City, NJ

Financial Reporting Analyst (Temp)

• Prepared and developed detailed ad-hoc analysis and reporting for better decision-making.
• Created and anal yzed Access queries extensively for internal/external reporting.
• Distributed weekly/ monthly reports for organizational purposes.
• Using Pivot Tables and formulas, p repared timely and accurate reporting such as Investor, Line of Business Stats, Expense, Exposure, Spend, Aged Cases, Dashboards and other specialized reporting.
• Maintained and updated reporting procedures.
• Created dashboards that showed management a visual snapshot of complex data analysis.
• Maintained the organization of reports and any ad hoc requests, tracked and distributed a schedule/queue that ensures the team provides timely analysis of all deliverables assigned to them.

Confidential, New York City, NY

Financial Analyst (Temp)

• Performed ad hoc repor ting.
• Analyzed Gross Written Premium for their main product lines.
• Cash flow analysis using the total YTD Forecast vs. Plan for the lines of business.
• Updated an analysis of the Net Investment Income Forecast vs. Plan with the Net Written Premium using a leverage ratio resulting in a STAT surplus.
• Using XPLAN/SAP data, provided an analysis of MTD/YTD of direct expense allocation for the business programs and open brokerage.
• Analyzed data from HFM to the IBNR report, comparing the Net and Ceded Affiliate/Non-Affiliate that is then allocated to the 3 main entities.
• Analyzed Underwriting and Investment Schedule for the companies’ expenses using trial balance data.

Confidential, Haworth, NJ

Financial Analyst (Temp)

• Analyzed time sheets to ensure accuracy using an in-house Microsoft Access program.
• Prepared the budget for various departments from Oracle and using pivot tables on a monthly basis.
• Monthly analysis, using pivot tables and formulas, to show the main breaks, orders, and services.
• Updated the consumer spending report by retrieving data through Oracle and using Pivot Tables.

Confidential, Park Ridge, NJ

Pricing Analyst (Temp)

• Priced rental vehicles for Hertz’s leisure brand, using internal strategies to compete with competitors.
• Handled ad hocs on a daily basis.
• Based on the frequency of strategies the price rates of car rental would need to be changed manually.
• Processed an Excel macro file, that maintained all the strategies overnight to certain locations.

Confidential, Woodcliff Lakes, NJ

Financial Analyst (Temp)

• Reconciled cash proof reports for each cash account detailing current month sales, accruals, receipts, reversals to credits and deposits for journal entry and non-journal entry items.
• Provided P&L’s that detailed their revenue, direct cost, indirect cost, and monthly cash flows.
• Performing ad hocs as needed.
• Retrieved data from the warehouse, using Cognos and Essbase, for further budget analysis.
• Analyzed monthly projections, fixed assets and depreciation projections for each expense account at each site.

Confidential, Franklin Lakes, N J

Financial Analyst

• Booked journal entries during month end close.
• Supported account team and management with ad hoc requests.
• Tracked clients accruals during month end manually through BI-Query or automated system.
• Maintained documentation of Sarbanes-Oxley to comply with regulations for audit purposes.
• Prepared various mail and retail drug pricing and reports for clients as contractually required or as requested to show the client how they can improve their service with Medco.
• Developed reports that showed if the client was in exposure or surplus.
• R eviewed new contract terms and updated the system as necessary for month end accruals.
• Using Essbase, Pivot Tables and formulas, built daily reports for senior management approval of accruals showing any variances from the last report to the current report.
• Using Access, tracked client rebate payments and target pricing including terms, pricing points, calculations and due dates.
• Provided support in reports to show the client was in good standing with account receivables.
• Ensured client and account management satisfaction with accurate and timely resolution of all client issues and special requests.
• Identified and suggested new methods for improvement which was approved by upper management.