Report Analyst Resume Plano, TX - Hire IT People

SUMMARY:

Data Warehouse Developer with wide - ranging experience in Data Warehouse creation and support, Business Tool Creation, Business Analyst, Business Optimization, Programming, Report Creation, Customer Service and Operations.
Excellent written and communication skills with capability to multi-task in a fast-paced environment without compromising service quality. Experienced Professional and quick learner that works well under pressure and thrives in an atmosphere of challenge.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Report Analyst

Responsibilities:

Contract at Pepsico’s Business Intelligence Services group using Scrum methodology to create Data Warehouse from HP Service Manager Program.
Business Objects subject matter expert for team.
Creating and managing all Universes, Webi Reports, Explorer Reports, Xcelsus Dashboards and Tableau Dashboards from new Data Warehouse using Business Objects 4.0 and 4.2.
Creating ad hoc reports and new universes and Webi Reports from other business tools used by Company.
Help support Business Intelligence team with problems with previous reports that have been created and help with old reports created with Crystal Reports.

Confidential, Amarillo, TX

System Specialist

Responsibilities:

Supported IT at facility that manufactured aircraft for US military also assisted a project that modified Data Warehouse using an Oracle database, Business Objects Data Services ETL, Business Objects XII. Modified ETL, Data warehouse and Universes to use new data sources cutting over to SAP and Kronos from mainframe programs. Also assisted on a project that upgraded reporting tool to Business Objects 4.0.
Created and modified reports using Webi, Crystal Reports and Xcelsius reports. Also used Qlikview to create dashboards.
Used PL SQL Developer to extract data for ad hoc report requests.
Trained site personnel on use of Business Objects 4.0 and how to create reports using the Business Objects Webi reports and how to use different universes.
Primary support for data warehouse, universes, ETL and reports to fix problems and make modifications.

Confidential, Washington, DC

Data Warehouse and ETL Developer

Responsibilities:

Supported project for Dept of Labor changed the front end tool from Oracle Discoverer to SAP Business Objects XII, created the Universes, Webi reports to replace 5 of Data marts also created all 15 Xcelsius dashboards and 2 Crystal Reports that was not available in the Discoverer tool. Also created one new Data mart using Oracle10g database, Oracle Warehouse Builder10gR2, SAP Business Objects.
Directed activities that include; designing Performing Extraction Transform Load (ETL) process, data mapping and work flow and report dissemination using Oracle Warehouse Builder10gR2.
Supported development activities that include: staging tables, Dimensions, fact tables, target tables, indexes, procedures, triggers and packages in Oracle10g database using Toad.
Managed data warehouse sub-systems that collect data from various agency programs and initiatives.

Confidential, Richardson, TX

Senior Analyst

Responsibilities:

Forecasted 12-month resource requirements with 95% accuracy each month for installation, integration, field engineering, and engineering resources by state for cellular switching, data and cell site products for the United States area by getting data from multiple sources using SQL queries, Transact SQL and Visual Basic macros in a Access database, created standards to calculate hours needed to do work. Ensured availability of appropriate number of resources for future projects by having monthly meetings with resource managers with charts and data displayed in Excel and PowerPoint slides.
Reorganized MS SQL database for job assignments and milestone dates through implementing the enterprise manager; authored special reports writing SQL queries intended to decrease resources required to do this work using web interface. Created and maintained data warehouse for Plexus tool that scheduled and tracked work