Business Reporting Analyst Resume




Title
Business Reporting Analyst

Primary Skills
Report Development, Experienced in writing SQL Statements for Oracle, SQL Server, DB2, and Access

Location
US-FL-Jacksonville

Posted
Dec-16-08

RESUME DETAILS
Objective:
The objective is to secure an analyst position where my experience in database development, operations, and accounting can be employed to increase the productivity and profitability of an organization by utilizing my understanding of management information systems and insistence on the highest level of data integrity.


Career Highlights:

? Developed key activity tracking applications and managerial reporting. Experienced in using Oracle, SQL Server, DB2 and Access Databases. Experienced in the use of Hyperion, BRIO, Crystal Writing software, and Fidelity's PASSPORT. Developed VB (and VBA) procedures for office automation. Worked with Easytrieve writing reports against the mainframe.
? Analyzed a wide variety of financial and operation records related to financial reporting, statistical reporting, auditing payroll records, compensation analysis, and general ledger reconciliation.
? Effective and efficient communication with top-level executives - CEO, Senior Directors, CFO, Controller, Accounting Managers, and Human Resource Management.
? Experienced at training operations, accounting, and human resource professionals on advanced techniques and functions in spreadsheet and database applications.
? Assisted a number of internal clients through the reorganization and automation of processes resulting in reducing man-hours and delivering information in more effective manner.


Employment Summary:

2008 - National Audit / Business Analyst
? Responsible for the development and support of multiple database reporting applications including the automating of dashboards: used for reporting operational and financial results to internal and external clients.
? Worked with all levels of the organization on stream lining processes whereby creating cost savings and more efficient processes.
? Developed power point and other graphical presentations for both senior management and external client meetings.

2005 to 2007 - Kemper, a Unitrin Company / Data Analyst II
? Responsible for reporting approximately $1 billion of premium related to property and casualty insurance to ISO and TICO, this is approximately 20 million records annually. Activity involved the management of multiple company portfolios and coordinating with sister companies on complex transactions and reporting requirements involving both commercial and private insurance portfolios.
? Reduced time that it took to complete reporting; from weeks to less than a day per stat plan. Developed Edit Packages for the review of data against Bureau Requirements eliminating the need for costly re-work. Worked with Hyperion developing reports.
? Built database applications to manage multi-million dollar suspense accounts, to manage projects, and to perform critical reporting functions. Database applications were utilized to reduce suspense accounts from almost $ 100 million to less than $ 1 million.
? Responsible for the development of project plans involving multi-layered systems from developing the project, obtaining management approval, development of business case, high level and functional business requirements, cost analysis, test plans, and approval and implementation of projects.






Cris E. Creswell Page 2


2003 to 2005 - First American National Default Outsourcing / Reporting Analyst:
? Developed and administered various Microsoft Access databases specializing in the processing of loans in foreclosure and bankruptcy, managed a variety of requirements for national clients with multiple lines of business.

DEVELOPMENT EXPERIENCE included but was not limited to:
o Input extracts utilizing BRIO attached to ORACLE DATABASE remote servers accessed through CITRIX at the client site in New Jersey.
o Input extracts utilizing Fidelity Passport attached to DB2 though internet connection.
o Manipulation of data extracts involving creation of tables and views in SQL SERVER database located in Chicago.
o Creation of tables, queries (including union statements), forms, reports, macros, and modules for performing daily, weekly, and monthly reporting needs.
o Creation of report scheduler for outputting reports to shared drive, created a summary report with Hyperlinks to direct users to reports, and automated orders to external vendors through Emails.

1998-2003 -- Various Contracting Assignments Completed
Projects involved working in mortgage banking, finance, insurance, retail, and transportation industries.

? Developed through business resumption mission critical reports for organization lost in a major reorganization. Developed Crystal Reports against Oracle, SQL Server and local Access database applications. Resulted in providing information essential in re-establishing the ability for this firm to bill $1.0 million in revenue monthly.

? Developed Microsoft Access database applications and spreadsheets for the purpose of creating step schedules that were fed into People Soft Human Resource modules needed for the population of 2003 pays schedules for over 100,000 employees located throughout the Store, Warehouse, and Manufacturing Operations for South East Regional Retail Grocery Chain.

? Responsible for reconciliation of payroll systems for major transportation companies; results included recovery of $2 million in overpayments to train employees.

? Directly affected profitability of business unit through reconciliation and creating multiple use spreadsheets which reduced the time multiple users were spending in reconciliation efforts. Resulted the booking of $3 million in receivables not previously recognized.

1992-1998 -- Merrill Lynch Credit Corporation / Investor Accountant
? Performed reporting activities related to non-conforming multiple mortgage based investor portfolios with balances of upward of $3 billion and monthly remittances of $40 million.


Education:

Ohio University -- Bachelor of Business Administration, coursework centered on Cost Accounting and Industrial Engineering

Florida Community College of Jacksonville Completed coursework in Computer Networking, Visual Basic 6.0 and VB Net Programming, Oracle Database Administration (2 courses), SQL and PL/SQL Programming

Certifications
See above

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »


Resumes in Jacksonville, FL | Resumes in Florida

View other Business Reporting Analyst resumes, System / Network Administrator resumes