Senior Business Intelligence Consultant Resume Profile

Objective

Results-oriented business intelligence consultant, manager and leader with over 10 years IT experience. Over eight years' experience developing business intelligence tools and managing projects in challenging, fast-paced environments. Demonstrated ability t acquire new technical knowledge and skills rapidly. Innovative problem solver, able t see the business and technical sides of a problem. Proven leadership, negotiation and problem resolution abilities.

Expertise

Databases:	SQL Server 7, 2000, 2005, 2008 ,MYSQL ,Oracle 8i and 9, Informix, RedBrick
Software:	MS Office Word, Excel, Outlook, Access, PowerPoint , Sharepoint

Experience

Confidential

Senior Business Intelligence Consultant

Business Intelligence Architect for reporting system, utilizing SSRS 2000 ,2005 and 2008 and SharePoint, tools t assist internal operations managers and franchisees in driving revenue and profitability.
Some Reporting Highlights include Dashboard monitoring KPI, Revenue Per Bed, Member Life Time Value, Daily Performance
Other duties preformed include DBA, Business Analyst, Technical Architect, Data Architect, BI Architect, Trainer, and Presenter.
Creation of over 400 SQL Server 2000/2005 stored procedures for ETL processing.
Streamline existing SQL Server 2000/2005 stored procedures t retrieve data more efficiently.
Migrate all existing legacy reporting applications from Microsoft Access and Excel t SQL Reporting Services 2000 /2005 platform.
Creation and ownership of, Customer Demographic Mapping Project, Utilizes SQL 2008 SSRS and Map Point API , that generates approximately 2000- 3000 a quarter for the IT department utilizing customer source data such as address as well as revenue and other KPI's.
Perform data integrity checks t ensure consistency and accuracy of management information.
Support hub for legacy reports that were produced in Access and Excel.
Evaluate new reporting technologies such as Pentaho, QlikView, Microstrategy and Jasper.

Confidential

Service Delivery Manager

Provided Account Management for 31 Hotel and Travel Agency customers, providing daily business intelligence and technical support, as well as customer service and billing.
Handled escalations for first level customer service representatives that required immediate attention t data inconsistencies or errors.
Create and Maintain Supply Hotels and Demand Agencies Account Review Templates for Service deliver team that saved 3 - 4 days of existing account review process utilizing Bri and HYPERION Business Intelligence Tools.
Creation and analysis of Demand Revenue query for accounting t monitoring slippage and revenue variances for customers utilizing Bri and HYPERION Business Intelligence Tools.
Team Lead ERTS Reporting Production Support
Ensure, track and report t management that service levels for all internal and external customers were being met or exceeded on a monthly basis.
Mentored and managed a team of 7 production support analysts.
Development of new validation reports, using Hyperion/Brio, t speed validation of booking and payment files.
Ensure all customers and product documentation is up t date, organized and stored in an orderly fashion in both hard copy and on the network.
Senior Business Intelligence Analyst,Decision Support Services,
Creation and publication of ADHoc and Monthly reports using Brio/Hyperion.
Creation of monthly Cognos 7 data cubes for internal corporate dashboard.
Maintenance of the booking data mart, a complete data warehouse, for storing data from all Pegasus internal divisions including 7 distinct data sources.
Creation and Support of internal corporate dashboard of reports utilizing Cognos 7, Bri 6, SQL Server 2000. ASP.
Analysis of data produced in Brio/Hyperion reports t identify trends from senior management.
Manager Data Trending and Analysis
Management of day-to-day business intelligence operations.
Manage reporting project life cycle, which includes, design, development, testing and implementation.
Development of a new customer-reporting Portal using MS SQL Server 2000, Cold Fusion and ASP, tasks included design and creation of a customer reporting Data Warehouse using SQL Server 2000 with custom views, tables and stored procedures created for ease of querying.
Manage and Mentor 2 analysts in business intelligence technology

Confidential

Creation of an online business intelligence system utilizing Oracle 8i, ASP, vbscript, pl/sql, and Information Builders WebFocus. Provided detailed analysis t senior level and frontline management, regarding call center statistics and metrics.
Conducted business analysis and functional design documentation as well as construction of the reporting data mart in Oracle 8I, using pl/sql and WebFocus.
Customer base was approximately 20,000 end users and managers.
Developed training material t train other users on use of webfocus and reporting tools.

Confidential

Support Allstate agents and technicians performing new installations by migrating book of business and agency data files on existing AS400 server.

Provided desk side support t technicians and agents in call center with various computer related issues.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship