Business and Reporting Analyst

ADRIENNE FANGMAN

**** ** ****** **.

Grain Valley, MO 64029

Email: ***************@*****.***

Phone: 816-***-****

JOB OBJECTIVE

A position where my business intelligence and data warehouse knowledge help support the organization through report generation, application development, data analysis and system analytics.

Summary of Knowledge

SAP Crystal Reports XI

SAP Business Objects BI

MicroStrategy

Cognos

Tableau

SSRS

AutoCAD

PeopleSoft

TOAD

SQL Developer

OLAP/Essbase Cubes/Universes

Report Miner

Omniture

Microsoft Word, Excel, Access, PowerPoint, SharePoint

Databases: Oracle, SQL Server, DB2

Work Experience

APRIL 2004 - APRIL 2014

SPRINT: SYSTEM AND REPORTING ANALYST - BUSINESS INTELLIGENCE AND DATA WAREHOUSING

Responsibilities

Develop queries, reports and data analysis for multiple departments including Finance, Legal, Supply Chain, Site Operations (shipping and receiving, conference room scheduling, Fedex/Kinkos printing services, campus amenities, art department, and security) Marketing, Online Communities, Regulatory Audits and SOX 404 controls, Treasury, Online Order Entry Systems, Real Estate, Travel/Expense and Human Resources.

Participate in all phases of enterprise projects for assigned data warehouse systems.

Analyze and develop solutions to business issues including reviewing and writing of all relevant documentation, including stakeholder, functional and technical design requirements.

Determine operational objectives by studying business functions; gathering information; evaluating output requirements and formats.

Monitor department and external vendor specific data being submitted to executives on a weekly, monthly and quarterly basis.

Create web traffic reports based on the volume of data being exported and imported into various internal and external websites.

Insure the data warehouse systems were in accordance with data governance standards.

Participate in internal and external quarterly process audits to remedy any deficiencies and validated results.

Recommend controls by identifying problems and then writing improved procedures.

Manage report alters and provided guidance to staff and users regarding changes or modifications to reports and systems.

Gather requirements and generate ad-hoc or management specific reports.

Assist in database application and design.

Generate Excel reports to reference previous action taken on current data feeds. Aided with synchronization when client requested publication of data.

OCTOBER 2000-APRIL 2004

KFORCE.COM (SPRINT): REPORT DEVELOPER/DATA ANALYST

Responsibilities

Gather and document customer requirements for reporting and data analysis

Produce and distribute recurring reports

Support departmental /enterprise wide needs for ad hoc reporting, OLAP and Essbase cubes

Develop and maintain detailed instructions and procedures to produce standardized monthly reports.

Conduct defined audits and troubleshoot discrepancies to ensure report accuracy

APRIL 2000 - OCTOBER 2000

KFORCE.COM (SPRINT): REAL ESTATE TECHNOLOGY HELP DESK

Responsibilities

Work with customers to offer solutions to resolve problems on the HRIS systems

Receive, research and answer customer inquiries and requests for all applications and networks

Provide support for all AutoCAD drawing issues and changes

Provide technical expertise and guidance regarding the resolution of customer problems and complex software/hardware installation requirements nationwide

1998-2000

APS TECH - TECHNICAL SUPPORT REPRESENTATIVE

Responsibilities

Train new employees.

Tier 2 support for an operations center with multiple corporate and college accounts during 24/7 operation.

Provide general support of AS/400 systems.

Guidance for application packages and escalation processes including contacting Level 3 support with complex problems during off hours.

References available upon request

Contact this candidate