SUMMARY

An accomplished Business Intelligence IT professional with an MBA and proven expertise in Business Intelligence, Data Warehousing, Data Analysis Performance Metrics, Enterprise Reports Development and Systems Administration, through the application of Management Operations Science principles. Developed a wide range of analytical reports using Crystal (SAP Business Objects), Cognos, Brio, SQL, Microsoft Office tools, Oracle BI Publisher and Databases. Three years experience in Retail Entertainment, six years in Telecommunication, five years in Hi-Tech Defense Manufacturing and over five year in governmental organizations.

TECHNICAL SKILLS

• Crystal Reports Development
• Business Objects Enterprise System Administration
• Cognos
• MS SQL
• MS Excel
• MS Access
• MS Project
• MS Word
• Hyperion
• Lotus Notes
• Brio Query Explorer
• Power Point
• TOAD
• Principles of Facilitation
• Managing IT Projects
• Oracle SQL & Oracle PL/SQL
• Oracle BI Publisher
• Developing Procedures and Documentation
• Advanced Telephony
• Visio
• HiQube

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX May, 2005
(Subcontracted from MIRATEK Corporation through HNTB)
Business Objects Enterprise Sr. System Administrator and Crystal Reports Developer
Responsible as System Administrator for SAP Business Objects Enterprise and Developing and Maintaining a wide range of Crystal Reports for all levels of entire organization.

• Configure, organize and maintain Business Objects Enterprise reports environments
• Conducted a Crystal System migration from Crystal Reports and Enterprise Version 10 to Business Objects XI R2 and Crystal Reports 11.5
• Configure database connections from MS SQL, Oracle databases and other proprietary application databases in Windows environment
• Crystal Reports development, utilizing arrays and various aspects of Crystal Reports features
• Develop reports for integration into applications running reports via URL and third party applications
• Conduct on-going System Administration duties such as reports publishing configuration, scheduling, and setting up users security groups and report group hierarchies
• Conduct on-going additional System Administration duties including Business Objects server and Crystal Reports service pack updates and system patching maintenance as recommended and required
• Miscellaneous Technical Support as needed to support organizations requirements
• Conducting on-going Crystal Reports and Business Objects Enterprise training for other staff members Business Objects XI R2 and Crystal Reports 11.5
• Provide recommendations for software and services to assists in budget preparation as needs
• Monitor, maintain analyze, troubleshoot, and diagnose system and report issues with third party teams, subject matter experts, and colleagues.

Confidential, Dallas, TX September, 2002 to April, 2005
Systems Analyst
Creating a wide range of scheduled and ad-hoc reports for use by all segments of organization utilizing Crystal Report, Crystal Enterprise, Lotus Notes, Access, Essbase, Hyperion JD Edwards and MapInfo. Extract data from various sources to create Crystal reports and deployed with Crystal Enterprise. Set up and maintained user ID and security access levels within Crystal Enterprise. Created and maintained various databases for reports and other application including GIS applications.

• Trained and supported over 250 Crystal reports users.
• Served as Subject Matter Expert (SME) on projects that required reporting, including Data Marts
• Utilized View Time Security (VTS) and Parameters to reduce number of reports from 256 to 92
• Resourcefully optimized most reports to run more efficiently at 40% or better and provide more accurate information
• Provided analysis to identify opportunities to reduce store construction cost by 5% and react to low performing new stores early enough to implement proactive recovery measures.

Confidential
Data Warehouse and Crystal Reports Consultant January, 2002 to August, 2002
Created a wide range of periodic and ad-hoc reports to propagate Executive and Management KPI (Key Performance Indicators) dashboard websites utilizing Crystal Report 8.5 SQL 2000 and ASP.

• Provided recommendations in the design and development of Data Warehouse for developing reports.
• Analyze and optimize Relational Databases and Data Warehousing environments for reports.
• Utilized Stored Procedures in SQL Server 2000 to create Crystal reports to be deployed with ASP.
• Created and maintained tables in SQL Server 2000
• Utilized Access and Excel to analyze and process data and reports per customers' requests
• Interfaced regularly with end users to gather requirements for creating and modifying reports.
• Reports provided company-wide sales visibility to executives, management and shareholders.

Confidential, December, 1996 to December, 2001
Sr. Systems Analyst (August, 1998-December, 2001)
Assumed increasing levels of responsibilities including creating, maintaining, analyzing, tracking and using Statistical Process Control (SPC) charts and other Management Operation Science principles and concepts to provide timely technical and statistical metrics for management to track and manage IT departments who support and serve internal customers.

• Determined the need for performance measuring tools to measure and track IT groups as management implements new processes, policies and decisions.
• Developed a wide range of measuring tools resulting in significant departmental improvements in productivity, efficiency and customer satisfaction.
• Saved 45% in daily production time by automating several daily reports and metrics. Provided pro-active analysis to head-off potential challenges.
• Used Excel to develop over 500 reports, SPC and Pareto Charts.
• Developed over 500 Crystal reports since 1997 with versions 6, 7 and 8 for all levels of the company. Used Brio Enterprise to develop reports and SPC charts.
• Focal trainer for company-wide Crystal, SPC and metrics issues.
• Developed and maintained IT Balance Score Card.

Systems Analyst Project Office (1998)
Promoted to measure and monitor internal and outsourced development projects to ensure on time within budget completion of projects.
Systems Analyst Help Desk Support Center (1997-1998)
Promoted to provide vender business application systems support by analyzing, researching and resolving user issues. Assisted security administrator in resolving business application security issues. Prepared and provided management with periodic metrics and charts, depicting departmental performance.

Business Solutions Analyst (1996-1997)
Developed detailed analysis of business plans to support the mission and goals of a conversion project. Served as a key support resource for the conversion Project Managers and team. Provided data analysis with various periodic metrics and charts for management and teams to monitor project performance, which optimized team performance and productivity.

Confidential, February, 1996 to November, 1996
Business Process and Systems Analyst
Worked with a group of consultants to plan and implement an Imaging Workflow project. Tracked the project and reported progress to team members and internal departments.
Facilitated cross-functional business process re-engineering teams through research, analysis and measurement of business processes and best practices. Served as IT liaison and consulted with SME's in all levels of the organization to disseminate information and initiate business improvement processes.

Confidential, March, 1995 to February, 1996
Budget Analyst
Analyzed and monitored budgets of eight city departments. Department budgets ranged from $2 million to $90 million. Reported departments\' adherence to over $200 million in budgets to the City Manager\'s Office. Prepared monthly expenditure and revenue projections. Prepared the following year\'s proposed budget for each department and presented to the City Council for questions and approval.

Confidential, March, 1990 to January, 1995
Production Scheduler/ Cost Analyst (1993-1995)
Assumed additional responsibilities to schedule and track materials and parts on the shop floor with MRP II. Supported upper management with spreadsheet reports on production, shipments and labor cost. Developed spreadsheets for employees to create reports and graphs to track and control production costs.

MIS Project Lead/ Data Collection System Administrator/ Labor Reporting Coordinator (1991-1993) Promoted to lead a project team of 12 to implement an IBM OS/2 Bar Code Data Collection System. Implemented on a minuscule budget of $300,000 and required personal resourcefulness in conjunction with key team members. Provided the developers with requirements for customization. Worked with Shop Floor personnel, MIS, Payroll and HR to ensure accurate data reporting for both exempt and non-exempt employees to meet federal regulations. Used OS/2 Query Manager to extract data to create reports. Was on call to address problems relating to 50 terminals and two servers. Established and maintained a training program for employees and enforced labor reporting policies. Authored labor reporting manuals and assisted government auditors with labor information. System paid for itself in 15 months and greatly improved data accuracy.

MIS Project Coordinator (1991-1992)
Coordinated a team of 16 with a Project Manager to convert a Unisys MRP system to an IBM CAS 2.0 MRP II system. Tracked project and reported progress to upper management. A $2.5 million project which saved the company the expense of supporting two different mainframes.

Implementation Project Lead and System Administrator (1991)
Led a project team of 9 to implement a Unisys based bar code shop floor data collection system. Collaborated with software engineers and provided input for customization. Authored the system user manuals and trained users. System Administrator for the 23 Data Collection terminals and a server.

Manufacturing Budget Coordinator (1990)
Supervised departments\' adherence to budgets and reported performances to upper management. Applied learning curves to reduce production cost by 27% and saved over $100 thousand annually.

EDUCATION

Graduate Certificate, Telecom Management

MBA
BS Industrial Technology