We provide IT Staff Augmentation Services!

Technical Business Analyst & Developer Resume

Houston, TX

SUMMARY:

  • Interviewed business leaders, users and key IT personnel to document the requirements of the Energy Accounting system, which replaced the in - house VB application for managing trades and meter data
  • Wrote the Request for Proposal, evaluated the responses and developed a scoring methodology to choose the ideal product
  • Created a Conceptual System Design document that included a design for integrating this new system with existing systems (iTron IEE, Siemens Spectrum SP7, Allegro Horizon, MV90)
  • Created integrations between EAS with the other enterprise systems using Microsoft C#.net utilizing SOAP interfaces
  • Successful, Agile implementation and rollout of a highly customized version of the Energy Accounting software
  • Agile / JIRA / Confluence
  • Similar to the EAS implementation, I gathered and documented the requirements and evaluated the vendors’ RFP responses
  • Responsible for designing and building the integration between ETRM/Allegro and the other SMUD systems
  • Integrated Allegro with Siemens EMS Spectrum SP7 EMS, Power Settlements SettleCore, OSISoft PI, Kiodex via C# SOAP interfaces
  • Wrote heavy SQL queries and stored procedures while researching dara issues

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Technical Business Analyst & Developer

Responsibilities:

  • Led the development and operations of an energy market settlements and meter data management system in C#.NET, SQL Server SSIS & SSRS.
  • Integrated with external trading partners (Generators, PJM, ERCOT) over a REST API with JSON, XML & CSV transactions.
  • Documented functional requirements and contributed to the development of a meter data management system built with MySQL, MongoDB, node.js, JavaScript, RabbitMQ & React.
  • Built a reporting solution using Power BI and SSIS that compared incoming payment lockbox transactions to the invoices in the billing system
  • Agile project management environment with JIRA, Confluence & GitHub
  • Utilized JIRA & Confluence to track backlog, sprints, user stories.

Confidential, Charlotte, NC

Technical-Functional Business Analyst

Responsibilities:

  • Developed enhancements to the Excelergy / Nexant ABP Utility Billing system in C# and XML
  • Developed a process for the mass-update of billing determinant data stored in BLOBs on SQL Server
  • Developed Excel 2016 macros and to extract data from the billing system into an Excel workbook, manually modified, then loaded into a SQL Server 2012 database
  • Designed and built a system used to compare datasets between Confidential and external trading partners (Energy Services Group - ESG).
  • Utilized SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) for complex ETL and rendering
  • Wrote SSIS custom task scripts in C#

Confidential, Little Rock, AR

Oracle Utilities Confidential Developer/Analyst

Responsibilities:

  • Techno-Functional Business Analyst supporting Confidential ’s move to MISO (Midwest Independent System Operator) control area
  • Researched and documented the requirements for adapting existing systems to work with MISO
  • Created & updated Confidential Rates and Riders as needed for MISO Business Service and requirement documentation
  • Wrote Oracle PL/SQL and VB.NET code to reconcile meter data between Confidential Billing Expert and Confidential GenManager
  • Provided Application Production Support concurrently with development
  • Utilized CVS for source code control and TOAD for UNIX-based Oracle PL/SQL development
  • Provided Windows system and SQL Server administration functions, installed software
  • Managed several Excel workbooks containing configuration information for the Rates & Riders, built macros to pick-and-choose data elements to be loaded into the Confidential Oracle database

Confidential

Solution Architect

Responsibilities:

  • Developed an ASP.NET application and web services (C#) for retrieving and posting nationwide sales tax rates
  • Defined the technology strategy, architecture and quality
  • Developed a SQL Server 2008 R2 database for online transactions and tax base data
  • Used Informatica PowerCenter v9.1 ETL to load tax rates for each State received in various Excel formats
  • Developed Business Requirement and Functional Design documentation
  • Established a SharePoint site to track SDLC documentation and approval workflow
  • Built several reports using SSRS (SQL Server Reporting Services)
  • Utilized Team Foundation Server (TFS) for source code control and release management, Windows, Exchange and SQL Server administration

Confidential

Business Analyst

Responsibilities:

  • Provided subject matter expertise for the Smart Metering program in its early phase
  • Documented the existing as-is process for IDR metering and VEE (Validation, Estimation, Editing) Rules
  • Wrote Business Requirement documentation capturing the desired capabilities of an integrated work order management system
  • Utilized a custom SharePoint SDLC site to track project artifacts, documentation and approval workflow
  • Lead in gathering & documenting requirements for a Field Meter Diagnostic portable device

Confidential

Techno-Functional Business Analyst & Developer

Responsibilities:

  • Supported the Sungard-Zainet implementation by working with the business users to gather requirements
  • Researched and documented Confidential ’s inventory of vendor products and custom-built processes
  • Focused on quick-wins and custom-built processes that needed adjustment to support the Oracle upgrade and integration with EAI/Zainet
  • Developed a new SSRS SQL Server Reporting Services site to replace an Oracle Forms/Oracle Reports system
  • Utilized Subversion for source code control, TOAD for Oracle PL/SQL development and batch scripts to automate data import and export

Confidential

Techno-Functional Business Analyst

Responsibilities:

  • Developed an automated process to download market-settlement data by accessing web services published by ERCOT TML/MIS
  • Created a SQL Server 2008 R2 database by using the DDL provided by ERCOT
  • Used SSIS (SQL Server Integration Services) to load the Retail (SCR727) and Wholesale (CODE/MODE) settlement data extracts into the data warehouse
  • Used SSRS (SQL Server Reporting Services) to build complex reports from the settlement data
  • Used Tableau to create a dashboard to visualize data load progress and meter data comparison variances
  • Automated the PGP encryption/decryption of EDI transactions (814 enrollments, 867-meter data, and 810 invoices) by using batch scripts
  • Windows and SQL Server administration functions (server maintenance, backup management, performance enhancements/settings, software install, hardware administration, storage administration)

Confidential

Techno-Functional Business Analys

Responsibilities:

  • Managed the Confidential Pricing Expert/Billing Expert v3.54 and Siebel 6 installation
  • Upgraded Confidential to version 4.53
  • Developed Confidential -to-Siebel 8 integration components in VB.NET
  • Developed Siebel Script to interface with UNIX-based SAS.
  • Maintained Rules Language and cost factors to support day-to-day operations and changing market conditions, prices, loss factors, load profiles
  • Created new rate riders using DataManger / Rules Language to estimate the cost of TDSP Wires Charges tariff changes
  • Developed several Rules Language-based reports utilized by the Pricing Team to analyze historical usage and edit if necessary
  • Built several reports using SSRS (SQL Server Reporting Services) and Excel
  • Developed and deployed a new .NET application providing the Pricing Analysts the previously unavailable ability to independently manage, test and deploy Confidential ’s factor value collections
  • Developed a Microsoft Language Services add-in for Confidential integration into Visual Studio
  • Established a formalized change-control and testing process for enhancements and data-changes
  • Provided Production Support for the Confidential /Siebel pricing system
  • Utilized Visual SourceSafe for version control and release package management and TOAD for Oracle PL/SQL development
  • Worked with heavy, complex Excel spreadsheets that included VLOOKUPs and Pivot Tables. Converted pricing requests modeled in Excel spreadsheets into Confidential Contracts

Confidential

Solution Architect

Responsibilities:

  • Responsible for the ERCOT Texas Nodal Market implementation of the Confidential GenManager product at Confidential
  • Documented Confidential ’s as-is shadow settlement process.
  • Interviewed analysts, reviewed production data & reports, mapped shadow settlement workflow with Visio backed by a detailed description of each step within the workflow.
  • Designed an end-to-end shadow settlement solution based upon Confidential ’s GenManager product
  • Attended ERCOT TPTF/Nodal and COPS working group meetings.
  • Analyzed the scope and impact of Nodal Protocol Revision Requests and presented summaries with opinions to Confidential and Confidential .
  • Followed the ERCOT Nodal market implementation progress and timeline. Attended EDS conference calls on behalf of Confidential and Confidential .
  • Facilitated process challenge sessions with leads from each of Confidential ’s operations & technology groups
  • Created the functional design for Confidential ’s near-term post-analytics processes (two-market LMP arbitrage, RUC post-mortem, CRR strategies)
  • Facilitated iterative requirement gathering sessions to translate their abstract concept into written form.
  • Received extensive Confidential product training; ERCOT Nodal Market training

Confidential

Sr. Business Analyst

Responsibilities:

  • Analyzed ISO Business Service requirements expressed with complex algebraic formulas
  • Configured the Confidential Confidential settlements product with the formula specifications for creating settlement statement line items
  • Analyzed wholesale settlements calculation SIRs (Bug Reports) submitted by Confidential ; gathered supporting data in complex multi-page Excel spreadsheets that stored the context in which the error scenario could be reproduced
  • Adjusted Confidential settlement calculations to match the PJM Business Service specifications
  • Provided onsite representation for Confidential T&D while onsite at PJM

Confidential

Solution Architect

Responsibilities:

  • Led the implementation of a retail energy transaction clearinghouse product at two client
  • Provided sales support to Confidential to ensure all required market processes were covered in the product to be delivered
  • Facilitated Joint Application Development sessions with the clients. Created technical design documentation for Confidential ’s developers.
  • Provided onsite ERCOT subject matter expertise to Juice Energy. Created whitepapers explaining the mechanics of complex market processes.
  • Built several reports using SSRS (SQL Server Reporting Services)

Confidential

Techno-Functional Business Analyst

Responsibilities:

  • Led the requirements and design phase of a Confidential BillingExpert FME (Financial Management Extensions) Implementation
  • Investigated the business logic in the existing .ASP Financial Collections system to extract the base set of requirements
  • Identified and interviewed individuals responsible for billing and collections to refine requirements and created the Conceptual System Design
  • Created technical design documentation for the configuration of FME, and its integration with TIBCO and Siebel
  • Installed the Confidential Customer Choice Suite and BillingExpert. Configured the collections workflow objects to specification.
  • Developed a C#.NET wrapper around the Confidential API that accepted XML TDSP invoice data received from TIBCO
  • Contributed to the design of a SOA-based infrastructure that enhanced the existing TIBCO-based integration
  • Upgraded BillingExpert and PricingExpert from 3.54 to 4.5. Worked with the vendor to build a test and parallel operations environment. Made modifications to PLSQL based on object name changes that surfaced during the upgrade.

Confidential, Baltimore

Techno-Functional Business Analyst

Responsibilities:

  • Provided retail billing process and Confidential expertise to a business process re-engineering project (Keystone Project)
  • Performed an inventory, assessment and gap-analysis of current systems, data flow and corresponding business processes
  • Developed the mid/high-level technical design for the Confidential BillingExpert solution replacing ~80 billing applications & processes
  • The systems required extensive integration with external trading partners and processed hundreds of millions of transactions monthly
  • Provided production support for the VB6-based billing system (ECIMS) by writing new billing code to support the Great Lakes market.

Confidential

Product Manager

Responsibilities:

  • Responsible for creating the conceptual design for a market-participant version of LPSS (Load Profiling and Settlement System)
  • Built product roadmap presentations, business and functional requirement documentation. Estimated capital cost and sales forecast dollars.
  • Wrote technical specifications for its integration into the existing Confidential product suite. (MDM Meter Data Manager and BillingExpert)
  • Conducted competitive intelligence research and developed marketing collateral
  • Analyzed existing LPSS Rules Language and stored procedures from existing products to identify reusable code and integration points
  • Provided energy settlement subject matter expertise during sales meetings

Confidential, Houston

Business Analyst / Developer

Responsibilities:

  • Documented functional requirements and created technical design for a gross margin financial forecasting application
  • Worked with accounting analysts to document the as-is environment and requested improvements
  • Identified and implemented modifications to their Excel-based forecasting system that included complex workbooks with macros, links and VLOOKUPs. Reduced processing time 75%.
  • Designed and developed a BI solution to reconcile financial and volumetric settlement differences between Constellation and ERCOT
  • Installed and configured SQL Server 2005 and SQL Server Integration Servers. Used SSIS to extract data from an Oracle based custom CRM & billing system. Worked through data quality challenges with the source data.
  • Developed SSIS translation maps for the TX SET 867 EDI transactions. Created custom C#.NET components to identify out-of-sync conditions between the different sources of data.
  • Processed 1.4 billion transactions during implementation
  • Created several Excel reports that estimate the financial impact of data discrepancies

Hire Now