SUMMARY:

• Senior Business Analyst / BI Data Analyst with over fifteen - years of experience in data analysis, reporting, implementation, project management, and operations support.
• Key liaison between management, end users and development teams executing financial and ad-hoc report generation, requirements gathering and training.

TECHNICAL SKILLS:

Software: Expert Excel, SSRS, PowerPivot, Power View, Business Objects BO BI, Crystal Reports

Databases: HRIS, RDBMS, SQL Server 2008, 2010, Tableau, IBM Cognos BI

Applications: Enertia, SharePoint Site Admin, SAP BO BI, MM, FI & CCS, PeopleSoft 8.4

Industries: Energy, Oil & Gas, Healthcare, Texas Deregulated Electric Market, Utilities, and Education

Operating Systems: Windows Vista, XP, ORACLE, Mac OS X

Methodologies: Project Management, CBAP, BI, SDLC, Root Cause Analysis, AGILE

SQL / SSRS SAP: FICO, BI, B1, MM Spotfire 7.0 and SAS

AREAS OF EXPERTISE:

• SharePoint Site Admin Project Planning & Test Plans Training Development
• Expert Excel and Access Process Change Management Data Warehouse Creation
• Project Management PowerPivot & Power View Enertia & WellView
• Organizational Development Visio and MS Project Requirements Gathering
• Report Development Excellent Data Analytics ERP System Analysis

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SENIOR BUSINESS ANALYST IT / DATA ANALYST

Responsibilities:

• Successfully leveraged SSRS, PowerPivot, Power View and other tools to extract and analyze data for BI Projects
• Developed SQL queries to pull data from numerous databases creating reports and views for various business units
• Used SQL Server 2010 for initiatives loading data into Excel and Access for analysis and BI reports to management
• Identified business opportunities and enhancements in reporting for projects, reports and analyses
• Ensured SOX compliance and data governance policies for Enertia users including researching and modifying security roles, classifications and defining user allowed functions and usage according the SEC and other federal agencies
• Helped improve data dashboard and report visualization reporting by 15% to senior management using Tableau and Spotfire 7.0. Collaborated with Business Intelligence team for key cross functional teams related to tends
• Worked with management in Accounting, Land and Production divisions meeting SOX compliance in ERP (Enertia) and using new functionality to improve efficiency by 21% in Revenue Accounting and Land Administration
• Attended management and team meetings to gather requirements, project plans and documentation existing state versus future state identifying gaps in system capabilities for upstream oil & gas processes

Confidential, Houston, TX

SENIOR BUSINESS ANALYST / PRODUCT MANAGER / DATA ANALYST

Responsibilities:

• Applied SQL skills to views and queries to pull data from existing data sources for proof of concept
• Defined business rules and data governance for new global compliance application including technical specifications related to multiple centers of excellence around the globe
• Improved system architecture and data warehouse performance for projects related to international compliance
• Managed resources and direction of new compliance solution reducing the risk of Federal import and export regulatory fines within existing systems architecture in development of new business capabilities
• Contributed as a key player in vendor relationships management and providing end-user and training documentation. Worked with C-level executives and vice-presidents overcoming project obstacles and delays.
• Executed best practices to correct and improve business processes related to international freight forwarding, warehousing, denied party screening, classification and governmental compliance guidelines.

Confidential, Houston, TX

PART-TIME INSTRUCTOR - SOFTWARE APPLICATIONS

Responsibilities:

• Trained adult students in technical development classes with progressive coursework leading to Office Specialist or Medical Coding Specialist certifications; administered assessment testing and grading for all Microsoft Office Applications - Word, Excel, Access, PowerPoint, Keyboarding, Windows and Office Management Skills.
• Managed educational development curriculum for adult students with rigorous coursework leading to general education diploma (GED) and using career advancement referrals; Ensured adult learners meet 80% or higher of Texas Education Agency and federal standards evaluating assessments and providing reporting via PeopleSoft

Confidential, Houston, TX

REPORTING DATA ANALYST

Responsibilities:

• Successfully leveraged SQL in pulling data from various databases performing data analysis for global operations
• Leveraged expert Microsoft Excel, Access, and PowerPoint skills on multiple projects for senior management; used advanced formulas, macros, VLOOKUP, and RDMS application development methods.
• Used Excel, Access, Crystal Reports and Tableau in ad-hoc report generation using financial and statistical techniques
• Analyzed index and mutual fund assets for ERP (Eagle PACE) business reporting ensuring overall data integrity and data quality in daily and weekly reconciliation of period end-to-end data migration for senior investment analysts.

Confidential, Houston, TX

BUSINESS ANALYST

Responsibilities:

• Supported senior management in Capacity Optimization group in production and applications support, leveraging services and procedures for various upstream organizations needing transport. Frequent adhoc requests using SAP MM, FI, PM and CO modules for various projects using.
• Executed daily / weekly mid-stream reporting for senior management in data exchange and integration projects.
• Included in in-depth group sessions with System Planning, System Control, Capacity Optimization, Contract Administration, Marketing, Business Development, FERC Regulatory and Compliance, SOX Compliance, Legal Affairs, Financial Planning, Project Finance, Field Operations, Natural Gas Storage and Liquids Optimization.

Confidential, Houston, TX

BUSINESS ANALYST II

Responsibilities:

• Leveraged SQL scripts for analysis of TX Deregulated Electric Market transactions improving production across technical environments for various business units and risk teams. Completed introductory training in IBM Cognos BI.
• HRIS reporting for BMO group using SAP for monthly reporting of absences, compensation, vacation, and benefits
• Trained in using Tableau for data analytics for retail electric market and natural gas prices in Texas and nationally.
• Project lead on various IT projects leading to 15% reduction in asset utilization and 10% increase in production data efficiency across various systems. Identified root causes, developed solutions requirements, and assisted with testing of migrated IT solutions. Executed superior communication, project management and facilitation skills daily.
• Ensured over $1.5M in monthly service order revenue as market expert using SQL, Spotfire, SAP Business Objects and administration of multiple SharePoint Sites; assisted in disaster recovery of systems; identified asset recovery items related to electric generation and storm recovery.

Confidential, Houston, TX

SENIOR DISTRIBUTION GAS CONTROLLER

Responsibilities:

• Mastered all requirements as technical expert and senior natural gas controller of local distribution system meeting nominations and annual goals of less than 1% variation from 100% execution of control processes.
• Executed daily collaboration with all levels of management and employees in Gas Engineering, System Operations, Service Centers, and Line Location ensuring orders processed properly in SAP - CCS realizing 14% decrease in errors; Monitored SCADA system preventing gas outages using ESRI ArcGIS for Greater Houston region.
• Managed digital records of engineering specifications of gas mains and lines for residential and commercial meters, and trained new hires in SCADA monitoring of over 150 gas city gates and regulator stations in South Texas region

Confidential, Houston, TX

GIS DATA ANALYST

Responsibilities:

• Managed multiple projects pertaining to gas engineering focused on operating map plotting; included main corrections for Gas Distribution system and electrical system elements for transformers and pole placement. Resolved unidentified or incomplete placement of facilities and plots into ESRI ArcGIS using desktop technology training; coordinated analysis reporting, regional map replacement, and final transfer into AutoCAD.
• Reviewed postings of completed work orders for accuracy and follow-up with Gas Control, Gas Engineering, and New Business Development departments; Developed corporate Scenario Planning process to help facilitate a common framework for executive management and business unit leadership in the emergency management.

Confidential, Irvine, CA

RETURN MERCHANDISE AUTHORIZATION (RMA) COORDINATOR & OEM LGOISTICS MANAGER

Responsibilities:

• Managed four-person team of contractors in hard drive testing for various failure points ensuring replacement in compliance with forty-eight hour turnaround conditions; Logistics manager for over $12 Million in materials and products to various locations in Malaysia, Japan and United States using ORACLE logistics and failure testing RDMS.