EXPERIENCE

Confidential

Cognos Architect

• Lead for Cognos financial reporting implementation of IBC Independence Blue Cross SAAS integration.
• Create WBS and plans to update Cognos architecture to meet new reporting requirements for all financial revenue projects.
• Collaborate with technical resources to build or improve data structures used for Cognos reporting.
• Model data sources into Cognos models using Framework Manager for all financial revenue projects.
• Design and develop reporting solutions using the Cognos 10 toolset.

Confidential

Cognos Developer

• Design and develop Cognos operational reports and dashboards for the U.S Department of Energy National Energy Technology Laboratory.
• Architect new database objects in the Oracle reporting data warehouse.
• Upgrade Cognos platform, reports, and dashboards from version 8.4 to 10.1
• Create multi-layer data models using Cognos Framework Manager.

Confidential

Utility Operations Manager

Interface with utilities and energy suppliers to resolve billing, contractual, or regulatory issues.

Senior Business Analyst

• Lead analyst for Texas regulatory changes for nodal implementation. A 1M project to integrate regulatory changes into products, pricing models, and billing systems. Accountable for eliciting and documenting business requirements, developing and conducting test plans, developing system designs and process changes. Created WBS for BA activities.
• Lead analyst for US Power forecasting integration. A 1M project that integrated legacy systems into new US Power forecasting system. Took project that was 6 months behind schedule and put it into production in 3 months. Led requirements elicitation and documentation, data mapping, and technical design efforts. Defined test scenarios and data requirements for testing. Developed SQL to validate data.
• Interviewed end users to develop and formally document application test cases for server migrations to new data center.
• 2009 Platinum Award Nominee and July 2009 IT STAR finalist.
• Master's Certificate in Business Analysis BABOK through the University of Pittsburgh's Joseph M. Katz Graduate School of Business Center for Executive Education and PMCentersConfidential.

Senior Data Analyst

• Extracting large datasets from various sources, provided load analysis of large C I customer electricity usage for accurate pricing and forecasting.
• Interpret utility load profiling methodologies into system requirements and enhancements for pricing and billing systems.
• Designed and developed Microsoft Access/VB application to analyze and forecast Portfolio customer accounts and pools. Reduced short-term forecast development to minutes.
• Define operational data requirements. Analyze and validate 3rd party EDI data for correctness.

Confidential

Sr. Systems Analyst - Consultant

• Successfully architected new system processes, interfaces and database objects for an Oracle based billing system and data warehouse. Wrote technical specifications and process flows for system and database modifications. Developed WBS for system changes. Wrote and conducted test plans for system changes. Led change review meetings with business owners and developers.
• Modified existing Cognos logical model and reports to meet business needs.

Confidential

Microstrategy Administrator

• Administered Microstrategy Business Intelligence software and servers. Implemented and maintained change management process for production environment. Installed software patches and upgrades. Ensured software up-time and performance. Tuned slow running reports. Recommended report or architecting changes to resolve query response issues.
• Architected logical objects in Microstrategy from Oracle data warehouses and other data sources.

Confidential

Senior Data Analyst

• Under tight deadlines, extract and transform large energy usage datasets from SQLServer, Excel, flat files, and web pages. Using retail energy business experience, quickly analyze data and develop customer electricity usage profiles for pricing and forecasting.
• Developed MS Access/VB application to alert company of customers over or under their contracted usage limits.
• Developed prototype for electricity usage data warehouse using Microsoft Analysis Services, Reporting Services, DTS packages, and Visual Studio .NET.

Confidential

Systems Analyst

• Quickly resolved customer receiving, inventory, and shipping software issues for MARC Global Warehouse Management System.
• Diagnosed and documented Oracle Forms, Oracle Reports, and PL/SQL application bugs. Collaborated with developers to fix application bugs.
• Monitored support cases and provided timely updates to customers. Led weekly support conference calls with Nike and Reebok.

Confidential

Database Administrator

• Implemented new Syteline ERP modules and functionality. Architected and integrated new expense report process that captured over 100,000 of unbilled revenue and reduced days to cash from months to weeks. Implemented new project accounting module to capture milestone revenue. Integrated project module with Microsoft Project Server 2003 to allow project managers to quickly update completed tasks and milestones on-line.
• Implemented RF devices and bar coding inventory on manufacturing floor to improve accuracy and reduce inventory levels.
• Worked with internal customers to define and develop custom programs and reports using SQL, COM, Progress 4GL, and Crystal Reports.
• Implemented software and database audit and control standards for SOX compliance. Implemented change management processes and procedures utilizing Visual Intercept and Visual SourceSafe.
• Assisted accounting department with monthly/yearly balancing and closing. Implemented FRx financial reporting software. Developed financial reports using FRx.
• 2003 Presidential Excellence Award finalist.

Confidential

Oracle Database Engineer

• Designed and developed Oracle databases for custom n-tier enterprise applications using Designer 2000, ERWin, and TOAD. Assisted Oracle, ASP and Cold Fusion developers with database design, database programming, query tuning, and application rollout. Designed and wrote PL/SQL triggers, stored procedures, and Unix shell scripts. Developed and enforced database security policies.
• Responsible for mapping and building ETL layer for moving data from legacy systems into new databases.

Confidential

Database Administrator

• Administered a custom Sybase sales order and licensing database. Responsible for defining end-user data reporting requirements, writing SQL queries using DBArtisan, and providing time-sensitive reports to sales personnel.
• Developed a sales and licensing data warehouse for improved data retrieval. Built web portal for online data retrieval and reporting.
• Documented logical and physical design of business critical databases and applications with DBArtisan. Led group meetings and documented with Visio, current company work flows and procedures.
• Administered Remedy ARS software and database for internal issue call tracking.

Confidential

Application Consultant

Provided customer help desk support for Syteline ERP software. Installed and upgraded Progress databases. Conducted internal training for new Syteline functionality.

Confidential

Senior Systems Analyst

• Working on large Banner CIS integration projects, conducted software GAP analysis with end-users. Wrote functional specifications and developed cost estimates for client modifications to Banner CIS. Provided other consultants with Banner CIS functional knowledge for process flow documentation and business process re-engineering.
• Led data conversion analysis and ETL for legacy data migrations.
• Developed and ran Mercury WinRunner automated test scripts.
• Developed cost control and tracking reports for project managers.
• Provided pre-sales functionality expertise for overseas sales opportunities.

Confidential

ERP Administrator

• First live Banner CIS client. Lead analyst for Banner CIS integration. Worked with all internal customers to develop and document functional specifications for customized programs and reports.
• Led end-user training of Banner CIS software. Streamlined and implemented new business processes to utilize Banner CIS. Documented new SOP's.
• Led QA testing effort of custom programs and reports. Maintained source control of custom programs and reports.

Confidential

Application Consultant

On-site Banner CIS trainer and application consultant. Developed lesson plans and conducted on-site customer training. Developed and wrote user manuals. Developed and executed software QA test scripts.