SUMMARY:

Database applications developer with extensive experience developing interfaces, reports, and processes for a wide range of companies including Confidential and Confidential organizations. Proficient in designing and supporting database application processes including ETL data loads in Microsoft SQL Server and SQL Server Integration Services using the Microsoft Business Intelligence platform. Broad experience designing and implementing applications and interfaces using the Microsoft .Net Framework.

TECHNICAL SKILLS:

• Microsoft Business Intelligence - SQL Server Integration Services / SSIS - 9 years
• Microsoft SQL Server - 15 years
• Microsoft SQL Server Reporting Services / SSRS / Crystal Reports XI - 7 years
• Microsoft Business Intelligence - SQL Server Analysis Services / SSAS / MDX - 1 year
• Microsoft .Net, ASP.Net - 7 years
• Microsoft Azure SQL -1 year
• Microsoft Excel / VBA / Add-Ins - 8 years
• Microsoft TFS - 5 years
• Oracle 10g - 5 years
• Ipswitch iMacros - 1 year
• Allegro - 2.5 years
• Morningstar Commodities Data/LIM - 5 years

PROFESSIONAL EXPERIENCE:

Confidential, Frisco, TX

Senior Applications Developer

Responsibilities:

• Designed, implemented, and supported ETL processes using SSIS and SQL Server Data Tools to import data from various internal and external data sources into key company databases including the company’s work order and inventory management system. Implemented a logging and error handling process to improve existing SSIS processes.
• Developed the ETL data migrations for a major company project to move from a legacy Microsoft AX ERP system to an Oracle ERP system.
• Designed, enhanced, and optimized dozens of SQL Server stored procedures and processes that provided the backend logic for various .Net applications and web services.
• Developed a process using SQL Server as part of a proprietary internal payroll application to identify issues with the payroll process. Resulted in an estimated 30% reduction in cost to process the payroll.
• Created various SSRS Reports for different business groups. Provided various other ad hoc data requests for executive and accounting business users on an ongoing basis.
• Maintained and enhanced custom Payroll and Human Resource applications written in C# .Net.
• Worked with the Power BI team to create a dashboard for executive reporting including designing the data models for various Power BI reports.

Confidential, Houston, TX

Commercial IS Analyst

Responsibilities:

• Designed an ETL process to bring data from various databases within the company into one central data warehouse using SSIS. Worked with a team to integrate this UI into the Allegro trading software.
• Created dozens of SSRS reports for various business units. Reports were a combination of SQL Server reports from a SQL Server 2012 database and SSAS reports utilizing MDX.
• Provided ongoing production support for several areas within the Allegro trading software application. This included extensive enhancements to the ICE interface which supports the flow of hundreds of trades weekly within the Allegro trading software using C#.
• Maintained and enhanced a custom accounting process within the Allegro software using C#.
• Worked with the Business Intelligence team to design and maintain SSAS cubes for the organization. Designed and supported some of the ETL processes written in SSIS 2012 which populated the cubes. Assisted with setting up partitioning processes after the nightly and weekly processing of the cubes.

Confidential, Houston, TX

Senior Applications Developer

Responsibilities:

• Created and maintained dozens of SSIS packages using Microsoft SQL Service Business Intelligence Development Studio 2005 and VB.Net applications to retrieve data from external data sources and vendors and put it into a SQL Server 2005 database.
• Performed extensive work designing and supporting processes using SQL Server 2005 jobs, SQL Server Integration Services, stored procedures, and functions.
• Developed a CLR for a SQL Server 2005 server to access quotes via LIM, a Morningstar company.
• Developed and supported interfaces and ASP.Net front ends to feed data into the company’s global commodities trading applications from external sources including the NYMEX and various energy ISOs including MISO, CAISO, and ERCOT. These interfaces were written using SQL Server 2005, VB.Net 2008, C#.Net 2008, and SOAP Technologies utilizing web services.
• Built and maintained reports for Back Office and Middle Office departments using Excel 2007 VBA, SQL Server 2005, and Oracle packages.

Confidential, Houston, TX

Senior Applications Developer

Responsibilities:

• Implemented dozens of data retrieval processes and feeds from various ISOs and fundamentals sources via Microsoft SQL Server SSIS 2005.
• Developed a data mining system to pull data from various database sources and store in a primary data retrieval system for the Market Fundamentals group using SQL Server 2005. Created an ASP.Net 2005 front end web application to access this data and create models.

Confidential, Houston, TX

Applications Developer

Responsibilities:

• Implemented and supported a highly visible custom application in Visual Basic 6.0 to track the PNL for the physical gas trading business.
• Created data imports to retrieve data automatically from the various ISOs and other data providers using DTS 2000, .Net 2005, SQL Server, and VB 6.0. Provided production support for various other reporting applications and SQL Server DTS Packages and processes.

Confidential, Houston, TX

Consultant

Responsibilities:

• Developed financial reports and data analysis tools for several Fortune 100 energy clients using Visual Basic 6.0, SQL Server 2000, Microsoft .Net 2003, and Open Link Endur technologies.
• Developed a series of reports for client using Endur AVS and Seagate Crystal Reports.
• Worked with a team, at another client, to convert existing reports for the client to a new reporting format using Visual Basic 6.0, SQL Server, and Crystal Reports.