PROFESSIONAL PROFILE:

• 10 years of business analysis requirements gathering, custom application development, advanced relational database design, and report writing with several programming platforms to include SQL, VBA, C#, and .NET.
• 10+ years of supervisory, people management, workforce resource planning and leadership experience.
• 10+ years of time sensitive and task - oriented project coordination and management experience.
• 10+ years of business systems support, administration and maintenance.
• 10+ years of financial analysis, budgeting, forecasting and vast accounting experience, with a solid history of identifying opportunities to gain business efficiency through process improvement and/or the development of custom applications.
• 10+ years combined experience with vendor and/or consultant direct contact interaction.
• 8+ years hands on experience working with OLAP technology and/or Business Intelligence Analytics tools to include.
• 8+ years of experience training power users/end-users in custom or packaged software applications.
• 5+ years of price modeling/forecasting, revenue management and varied market-based analysis.

SUMMARY OF SKILLS AND PROFICIENCIES:

• MS Power BI, Business Objects 6.1B Reporting, COGNOS 10.1 Reporting, Crystal Reports, MicroStrategy, Birst Oracle, Hyperion Essbase Reporting, SAP (ERP/CRM), Mars Reporting, Co2o Reporting, SAP Financial Software, Teradata Warehousing/SQL Assistant, Aurora XMP Power Modeling and Price Forecasting Software, GPCM Gas Pricing Model, Kronos WFM/Time and Attendance, IEX Workforce Software, FTP(File Transfer Protocols), IEX Workforce Management Software, MS Visio, Rally, MS Project and Gemini Project Request Tracking tools.
• Expert MS Excel, Expert MS Access, Advanced MS PowerPoint, Expert Formula, Macro, and VBA.
• Certified in SQL Programming and Database Design (Kimball Methodology) through Confidential
• Exceptional business acumen, analytical thinking and process improvement skills.
• Exceptional technical aptitude and ability to learn complex applications quickly.
• Advanced process modeling through requirements gathering and the development of complex visual aids.
• Proficiency with leading SDLC and AGILE project management methodologies.
• Extensive end-user training module creation, organization and training facilitation experience.
• Extensive meeting facilitation and presentation experience.

PROFESSIONAL EXPERIENCE:

IT Hardware/Software Business Analyst/PM

Confidential, Dallas, Tx

Responsibilities:

• Perform lead analyst/project management role on IT hardware/software implementations.
• Successfully completed over 100+ projects completed for 23 clients with 100+ Five star service ratings.
• Windows 365, Several POS systems, MS BI Stack & Power BI, Tableau, Informatica and many more.
• PC’s, Laptops, Routers, Switches, POS hardware, CCTV components.

Sr. Business Analyst

Confidential, Irving, Tx

Responsibilities:

• Led business users, developers, and analysts through data/reporting migration from Microstrategy to Birst reporting.
• Developed process flows and implemented service and support processes for ETL and Business Intelligence Reports.
• Responsible for requirements gathering, documenting and rebuilding of 100+ reports from MicroStrategy to Birst.
• Performed UAT testing for all Sales and Inventory related Business Units.
• Performed ad-hoc Analysis and complex report building for Executive level staff.

Sr. Business Analyst/Solutions Integrator

Confidential, Tulsa, Ok

Responsibilities:

• Managed all points of technical integration for a large capital project (+$300k), for annual sales and budgeting process software development.
• Provided operational support to database developers, programmers and project team analysts.
• Created all technical specifications based on the collection of business requirements.
• Performed On-Call system de-bugging skills for critical systems to include informatica, Oracle, and SAP databases.

Founder/Consultant/Analyst

Confidential, Tulsa, Ok

Responsibilities:

• Pursued sole proprietorship of a technical staffing solutions endeavor, alongside of client/partner.
• Provided project management guidance on several technology tool implementations for sales, marketing and forecasting.
• Introduced and implemented the AGILE project management methodology and Pivotal Tracker as the chosen tool for tracking AGILE projects.
• Severed as database administrator for all company databases, and liaison for vendor databases.
• Designed, developed, and documented several custom business applications to include Power BI visualizations, SQL query-based reports, GUI developed applications, and web-based development.
• Implemented a customer traceability tool to assist with marketing services to customers with economic energy needs.
• Served as company product support liaison and system administrator for all technical software’s.

Business Intelligence Senior Analyst/Supervisor

Confidential, Tulsa, Ok

Responsibilities:

• Supervised the Business Intelligence Business Analyst and Sales/Marketing Analyst groups, supporting trending and predictive analysis in effort to recommend business strategies that enhance revenue and/or cost savings in accordance with divisional and corporate goals using SQL based OLAP/Multidimensional Database technology.
• Coordinated with Business Unit Directors on developing requirements and complex analysis for implementation of corporate business strategies; utilizing the Microsoft BI Stack to include Power BI.
• Provided expertise to sales and marketing business units in determining data requirements, strategies, and appropriate software to ensure the organization has the information, tools, and systems to effectively support the business categories in line with strategic and tactical plans.
• Oversaw and participated in the development of the necessary OLAP developments, SQL queries, Power BI visualizations, and SSRS reports using current coding and reporting standards. Utilized Data Warehouse or relational database design (Kimball Methodology) where appropriate.
• Led several Mobile software development projects, to include several data collection forms, reporting tool implementations and resource guides.
• Led several SDLC and AGILE projects as Project Manager or Senior Business Analyst.
• Designed developed and implemented a project request tracking system used to track end-user request and developer/analyst productivity through project life cycles. The tool has given the entire organization visibility into project status’ and BI team productivity reporting.
• Introduced and implemented the AGILE project management methodology and Pivotal Tracker as the chosen tool for tracking AGILE projects.

BI Business Analyst/Project Manager

Confidential, Tulsa, Ok

Responsibilities:

• Authored several white papers and business process mappings as supporting informational documentation to MRO technology and/or data configuration changes and implementations.
• Worked extensively with Revenue Management and Information systems to define revenue management data definitions, metrics and reporting packages through a data warehouse/database migration.
• Performed hands-on project supporting data exploration using SQL based business intelligence tools OLAP based tools.
• Established and implemented BI pertinent best practices, standards, and processes.
• Designed and implemented a corporate wide Cognos based MRO/Operations Performance, Safety, Quality and Planning Business Intelligence Dashboard Reporting Tool, currently in use at all Confidential airport stations.
• Implemented and exercised project management and business intelligence development best practices and standards.
• Coordinated project efforts on several large IT systems/reporting development projects as the methodology SME.
• Led several projects as Project Manager executing Agile and SDLC project management methodologies on several dashboards/reporting related IT projects.
• Responsible for hiring and providing ongoing support to Cognos programmers and developers.
• Served as workforce manager and workload planner for a team of 12 business intelligence solution developers and analysts.
• Served as Systems Administrator, Trainer and end-user Support of Gemini (Project Request, Workforce management and Tracking Tool).
• Performed detailed and in-depth business analysis of IT inter-departmental personnel position functions, and business processes. The analysis included data warehouse mapping and the implementation of detailed data integrity standards; report writing requirements and specifications.
• Converted Confidential reporting from mainframe-based reporting to multi-dimensional based Business Objects BI reporting.
• Served as Business Objects reporting development subject matter expert to developers and end-users.
• Facilitated and delivered training of the TLE reporting and tracking system to Confidential leadership staff to include Superintendents, Human Capital Partners, Principals and their direct reports.

Business Systems Analyst/Power Modeler

Confidential, Tulsa, Ok

Responsibilities:

• Analyst, programmer and developer of a custom/packaged power modeling and forecasting scenario solutions in Aurora XMP Power Modeling.
• Served as Confidential product support liaison and system administrator for the Aurora XMP energy price forecasting software.
• Designed, developed, and documented several custom business applications in project and strict timeline-oriented formats.
• Served as project lead for several company-wide application development projects.
• Designed and restructured the Accounting and Finance Hyperion Essbase System 9 and Business Objects reporting as part of the Business Objects and Hyperion company-wide system upgrades to OLAP technology.
• Developed, redesigned and automated formatting of several accounting billing variance, A/R and reconciliation reports.
• Performed mass data mining and formatting projects for the Williams legal department.
• Originated and developed an MS Access, MS Excel and PowerPoint highly efficient mass data management and automated energy price charting presentation tool.
• Created an MS Access Critical Activity Risk Analysis Tool for the Exploration and Production department.
• Designed and developed an MS Access and MS Outlook Federal Lease Expansion Measures Tracking and Reporting Tool.
• Developed and maintained the company wide MS Access and MS Outlook FERC compliance notification system.
• Led and facilitated several technical supplemental education training courses for several business units.
• Backup analyst and support for the GPCM Gas Pricing Model.

Reporting Analyst

Confidential, Tulsa, Ok

Responsibilities:

• Served as Analyst, Administrator and support for several complex custom and packaged software applications.
• Performed highly complex troubleshooting of intricate end-user related issues of business solutions software such as Hyperion, Crystal Reports, and Business Objects.
• Administering employee user group accounts for several Sabre and Confidential based software’s including reporting and database software’s such as Oracle financials and Hyperion Essbase.
• Providing advanced technical trouble shooting of PC software and hardware issues for Confidential and several of its affiliates.
• Performing moves adds and changes of new equipment for entire Confidential and Confidential base.

Database Information Analyst

Confidential, Tulsa, Ok

Responsibilities:

• Provided company-wide analysis and systems support for Business Objects and COGNOS to include the development of use guidelines, system upgrade testing, report development support and highly complex database and report building.
• Performed training of Business Objects and developed training guide for end-users.
• Managed scheduled reporting batch job assignments and corresponding broadcast reporting traffic.
• Evaluated corporate and executive level reporting needs and developed custom reporting solutions based on the business needs of several departmental entities within the company.
• Worked as technical reporting liaison for many software support vendors and data support groups.
• Assisted in development and upkeep of companywide Oracle based data warehouse.
• Managed reporting and data tracking aspects of Alamo and National Car Rentals worldwide travel agent rewards program.
• Identified the need for efficiencies, synergies, and consistencies in reporting within the company.