SUMMARY:

• Skilled and dedicated BI Developer with over 10 years experience in Financial Trading, Oil & Gas, Energy Utility, Real Estate and Retail industries.

TECHNICAL SKILLS:

Skills: MS .NET: C# 6yrs, VB.NET 2yrs MS SQL Server: 10 yrs Sharepoint 2yrsMS SQL Server Integration Services 4yrs MS Excel VB/VBA 4 yrsMS Proclarity 4 yrs Oracle PL\SQL 2yrs MS SQL Server Analysis Services 4yrs WCF 1yr Web Services 4yrs XML\XSL 3yrs Dynamic Languages: Javascript 2yrs, Powershell 2yrs, Ruby 1yrs, Perl 3yrs Web Development: ASP.NET 3yrs\ASP 5yrs

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

Responsibilities:

• MMI BI System Extended VLDB\Cube (1TB): Windows 64Bit, ETL, Query Optimization. Many schemas, part Inmon (ODS) and Kimball methodologies. Primary: tuning performance of crucial queries - Technologies include: MS SQL 2008 BI Stack (SSMS,SSIS, SSAS, SSRS, Sharepoint, Excel), PowerShell, C#, MDX, SharePoint)

Confidential

SSIS Developer

Responsibilities:

• Chevron Technical Portal Lead SSIS and SSAS developer on portal to integrate data and disparate tools into one location for drilling and production engineers. Created packages retrieving data from WebServices and many DB backends to land into datamart or expose through webservice. Frequently worked closely with Data Architect and other team members to perform spikes and create deliverables of stored procedure patterns against MSSQL and Oracle backends. Researched and identified data quality issues. Introduced team to beneifits of using Powershell to run ETL to wrap runs with .Net CMDLine Shell. Provided support\ on SSAS to other teams. Technologies include: MS SQL 2005 BI Stack (SSIS, SSAS, Proclarity, Excel), Oracle 9i, PL\SQL, TOAD, PowerShell, C#, MDX, WCF, SharePoint, IIS.

Confidential

BI Developer / DBA for Sales Data Warehouse

Responsibilities:

• Dropped cube refresh time from 6hrs to 30min. Implemented SQL performance tuning, cube partitioning, and attribute-relationships to take MDX calcs to next level. Generated SameStore metrics within cube using MDX scripting. Implemented calculations to normalize measures skewed when comparing open to closed periods. Implemented pre\post ETL\Cube status emails. Created XQuery SSIS component and C# .Net extentions for calling rest-ful webservices exposing datamart and SSRS Technologies include: MS SQL 2005 BI Stack (SSIS, SSAS, SSRS, Proclarity, Excel), PL\SQL, PowerShell, C#, XML+XQuery+XSL, MDX, MS ADO.Net Entity Framework, MS ADO.NET Dynamic Data Services, Web Services, ASP.NET, IIS

Confidential

.Net developer

Responsibilities:

• Maintained and Developed Asp.Net screens following SDLC methodology for large application with complex in-house framework. Automated tests with Ruby IE library. Created, maintained and tutored others on SSIS packages. Creates and maintained advanced stored procedures. SQL performance tuning Technologies: Asp.Net, C#, SQL Server 2005 & 2000, stored procs, MS UIP Application Block, Remoting. Ruby/WATIR, Javascript, MS SQL 2005 Integration services, SQL CLR Stored Procedures and Functions.

Confidential

BI Developer

Responsibilities:

• Web Service Metrics Data Warehouse. Designed near-real time cubes -- refreshing every 30mins - from Web Storefront XML log data using SSIS jobs and custom SSIS XML components. Created front-end reports in Reporting Services. Technologies include: SQL Server 2000 and 2005, Reporting Services, MS SQL 2005 Integration services and Analysis Services, XML+XSL, Web Services.

Confidential

.Net Developer

Responsibilities:

• RAID Configurator ASP.NET application adjunct to classic ASP e-commerce site. Allowed configuraton and validation of RAID on new server orders. Selected MS BizTalk Rule Engine, XML and Schematron schema validation to allow modeling and validation to be separate concerns handled via web services calls from an ASP.NET front-end. Method eliminated monolithic If-Then-Else code-logic Technologies include: BizTalk 2004 Rules Engine, Asp, Asp.Net, Schematron, .NET VS2005 Whidbey, XML+XSL.

Confidential

Sr. BI Developer

Responsibilities:

• Meter Data Acquisition System is used recoup lost revenue by aggregating SCADA information of energy sold to Texas ERCOT electric grid. Created Gas and Electric meter reading OLAP Cubes, ETL processes, SQL stored procs, datamarts and ASP.Net reporting interfaces. MDAS won Computer World Magazine’s competition for Best Practices in a BI Reporting App for it's use of free SQL Server / Office components. Technologies include: C#, VB.NET, ASP.NET, ASP,Javascript, ADO.NET, ADOMD.NET, Office Web Components, MS SQL Server 2000, MS SQL Analysis Services, ETL Tools, MDX,. XML, XSL, Java.Net integration

Confidential

Programmer/Analyst

Responsibilities:

• User liaison and maintenance work. Maintained ASP investor relations and Off-Shore Production Reporting data-entry sites. Technologies Used: ASP.NET, ASP, VB.NET, C#, SQL Server 2000, OLAP, XML+XSL

Confidential

Web Developer

Responsibilities:

• Assisted in development of modules of their classic ASP based contract estimation and tracking application. Technologies used: ASP, Javascript, Visual Studio, SQL Server 2000. Jan ‘03 - Mar ‘03

Confidential

Database \ Web Developer

Responsibilities:

• Team development of Internet/Intranet web applications in VB.NET. Shared knowledge of C#. Created ASP.Net / SQL OLAP application to drop query times against a ORACLE data warehouse (26million rows of data) to 10secs. Created code generator to generate (CRUD stored procs, Business Objects, ASP.NET screens) from SQL server schema information tables. Led VSS/.NET Source Control integration project. Troubleshot IIS servers. Technologies used: C#, ASP.NET, VB.NET, Visual Studio 6. SQL 2000, Oracle PL\SQL, SQL Analysis Services, XML+XSL, IIS, XHTML

Confidential

Lead OLAP developer

Responsibilities:

• Created and maintained SSAS cubes working with business: Power Gen/Load, Weather, Gas Flow, Gas Price, Pipeline Flow Volume. Ad-Hoc reporting, Mapping, Excel automation macros. Mailbox polling. Technologies include: C#, ASP.NET, VB.NET, Visual Studio 6, MS SQL 2000, MS SQL Analysis Services, XML+XSL, COM+, PL\SQL, XML+XSL, IIS, ASP, Javascript, Excel VBA, PERL, Platts publications, PowerMap, SVG.

Confidential

CRM developer

Responsibilities:

• Coordinated work of three contractors on CRM application (CIMS). The app was built upon Exchange, Outlook 2000, SQL server and IIS 4/5. Most of its 300 users were in the sales and executive organizations. Sales users enter customer sales contact data into Outlook forms which were pumped into SQL server with batch extract apps. From there Mgmt. could view reports and query sales activity from an intranet web site. User liaison. Created the source control installation, and authored a knowledge base of production issues.