Sql Server Developer Software .Net Engineer Project

Bryan D. Shaw 832-***-**** abm39i@r.postjobfree.com

Bryan D. Shaw

**** ******* *****

Sugar Land, Texas 77498

832-***-**** abm39i@r.postjobfree.com

ROFESSIONAL OVERVIEW

P

Team Leader handling analysis, design, development, implementations, enhancements,

testing, deployment, training, maintenance and documentation of information systems in

the energy, transportation, risk management and financial industries. Coordinated various

projects in all phases of the software development lifecycle in different industries as a Senior

Developer or a Database Administrator and as the go to person for all architecture and

development needs. An expert in systems integration and relational databases.

Primary Roles •

Senior Technical Consultant

•

Senior Software Architect

•

Lead Developer

•

Database Administrator, Data Warehousing

Primary •

SQL Server Analysis, Reporting and Integration Services 2008

Te •

C# .Net, 2003, 2005, 2008

ch •

MS SQL Server 6.5, 7, 2000, 2005, 2008

nol •

VB.Net, VB Script, Java Script, COM+

ogi

•

Visual Basic 3 6

es

•

ASP, ASP. Net

•

HTML, XML, DCOM, COM, SOAP, SMTP, ODBC, ADO, OLE, DDE

•

SharePoint 2007, Windows SharePoint Services 3.0, HYSYS, Unisim, PI, ChartFX

•

Delphi 1 8

•

PerformancePoint Server 2007

Key Industries Oil & Gas, Energy, Transportation, Risk Management Solutions, Finance

Crystal Reports, MAS 500, COBOL, CICS, CQ/CS, ALGOL, Sybase 5 10, Watcom SQL

Other

Key Engagements

Page 1

Bryan D. Shaw 832-***-**** abm39i@r.postjobfree.com

Major Oil Sr. Technical Designed, developed, tested, deployed, supported, maintained

and documented a data mapping and integration system

Compan Consultan

that takes real time petroleum plant information (PI),

y t

conditions the data, pushes the data through HYSYS and

Unisim models, stores the results in MS SQL Server

database table, then presents those results using Visual

Studio 2008, ChartFX and SharePoint 2007.

Designed, developed, maintained, documented and deployed dynamic,

Senior

Financial

database driven thin client GUI forms to capture real time deals and the

Company Software

written confirmation of those brokered deals for natural gas, electricity,

Architect

emissions, crude oil, refined oil products, liquefied natural gas, weather,

coal and retail power.

Lead Designed, developed, maintained, documented, tested and

Service

deployed a transportation management system that tracked

Corporati Developer

on vehicles, drivers, training, accidents, insurance, locations,

pools and other equipment.

Education Professional Training/Certifications

•

Bachelor of Science,

Stephen

F. Austin State University May

•

Certificate from TeKnowlogy in Transact SQL

1984 •

Certificate from Dale Carnegie Training

•

Certificate from Best Software in MAS 500 Customization

Geographic locale

Military

•

Field Artillery Captain United States Army, Wurtzburg,

Houston, Texas. 50% Travel Available

•

Germany

PROFESSIONAL AND BUSINESS EXPERIENCE

Perficient, Inc. http://www.perficient.com May 2007 –

Present

Sr. Technical Consultant

CLIENT: KIPP Austin Public School District http://www.kipp.org

Developed a Business Intelligence Internet Dashboard system for a charter public school district for under privileged

children. Developed dimensions, hierarchies, attributes, named sets, calculations and URL actions using SQL Server

Analysis Services 2008 (SSAS) for use in reports, key point indicators, data collection forms and charts. Selected as

Support Lead after the project was delivered.

Responsibilities:

•

Designed, developed, tested, deployed, supported and maintained time sensitive calculations, dimensions, hierarchies,

attributes, URL actions and dimensional relationships in a data warehouse to support the presentation of reports and

key point indicators using SQL Server Analytical Services 2008.

•

Designed, developed, tested, deployed, supported, maintained and documented Key Point Indicators, Scorecards,

Time Aware Dashboards and accompanying Analytical Grids and charts with URL actions using PerformancePoint

Server 2007 and SQL Server Analytical Services 2008. These dashboards are integrated with SharePoint Services

2007.

Page 2

Bryan D. Shaw 832-***-**** abm39i@r.postjobfree.com

•

Designed, developed, tested, deployed, supported and maintained time sensitive reports using SQL Server Reporting

Services 2008 integrated with SharePoint Services 2007. Users are able to subscribe to reports.

•

Designed, developed, tested, deployed, supported and maintained data transformation packages using SQL Server

Integration Services 2008. Administrators are able to start jobs using SharePoint Services 2008.

•

Designed, developed, tested, deployed, supported and maintained data collection forms using InfoPath integrated with

MOSS 2007. Used web services developed in Visual Studio 2008 C# as the data transport layer.

CLIENT: allegiant http://www.goallegiant.com

Developed a Windows Presentation Foundation demonstration for the Republic of Angola. These included animated

buttons, zoom in, zoom out, high detailed graphics. Charts and graphs animated to drill down and up summarizing and

detailing various infrastructure project by country, state and region. Detailed information on the progress, stage and budget

available. Touch screen enabled software that was easy to use.

Responsibilities:

•

Designed, developed, tested, animated buttons, graphics, tool bars, country, state and region animations. Button

animations with zoom in and out abilities using C# 2008, XAML and SQL Server 2008.

Page 3

Bryan D. Shaw 832-***-**** abm39i@r.postjobfree.com

CLIENT: Shell Global Solutions, Inc. http://www.shell.com/home/content/global_solutions/

Led a 12 person global team in five countries doing analysis, design, development, implementation, enhancements, testing,

quality assurance, document, deploy, support and maintain of a real time natural gas and petroleum off shore platforms and

refining plant simulation system utilizing Visual Studio 2008 C#, Microsoft SQL Server 2005, SharePoint 2007, Unisim

Design 2.0, Office 2008 and proprietary in house software system. This simulation system allows plant and off shore

platform operators to monitor current condition and predict conditions in the future using ChartFX charts, XML reports and

Excel spreadsheets.

Responsibilities:

•

Designed, developed, tested, deployed, supported, maintained and documented seventeen workflows using C# 2008,

ADO 2008, XML and SQL Server 2008.

•

Designed, developed, tested, deployed, supported, maintained, documented and trained other developers on a new

database and data access layer that allowed for the dynamic creation of all aspects of the SharePoint 2007 User

Interface; to include the order of the pages, page layout, site navigation, alert notification, ChartFX chart configuration

and presentation, security, event definitions and configuration, event entry, error reporting, workflow history, data export

and other user tasks using C# 2008, ASP.NET 2008, XML and SQL Server 2008.

•

Served as the Team Project Lead for a globally diverse team.

•

Responsible for the final delivery to the client on time and within budget.

•

Responsible for delegating tasks to the rest of the implementation team on an as needed basis.

•

Upgrading software systems to the latest versions of InSite, iCat, HYSYS, Unisim, SQL Server 2008

•

Testing and verifying model results during stress periods and using extreme data inputs to ensure model stability

throughout user defined events that are injected into the model and then analyzing the data results for accuracy of the

predictions throughout the natural gas refining plant.

•

Designed a defect and enhancement tracking system using SharePoint 2007 so that our global team could maintain

constant communication on various issues with the system as it went through acceptance testing and migration

procedures.

•

Developed a detailed migration plan to deploy this 20 server global system in a remote location and at the customer

site with little downtime. Tested every server for full functionality and reliability.

•

Provided 24/7 user support for over six months. Developed extensive support handover documentation and trained the

support personnel on all aspects of all of the technologies that are being utilized throughout this global system.

•

Proposed a central core project to provide a base line for the Lagosa group, so that the default, off the shelf

functionality would be defined, it would provide a demonstration project that the regional leads and business analysts

could present to customers, it would have a defined cost and amount of effort required to deploy and the entire team

would actually know what features were included within the core Lagosa product. Funding has now been provided to

realize this proposal.

•

Worked closely with a remote process engineer to identify various modeling, data and process issues within the Unisim

and HYSYS models. Communicated effectively with the engineer about the modeling tool in a very short amount of

time, without having any knowledge or experience with the tool before this project.

•

Conducted workshops for the Real time Operations group to demonstrate the various technologies utilized by the

Lagosa system. Trained several personnel in the actual operation and integration procedures performed by the Lagosa

implementation team.

•

Wrote seven documentation templates and seven statements of work that were crucial to delivering this technology to

other plants in the future.

•

Technologies used included: C# 2008, 2005, ASP.NET, SQL Server 2008, 2005, 2000, XML, HTML, ChartFX,

SharePoint 2007, Windows SharePoint Services 3.0, MS HYSYS, Unisim, PI, Office 2008

Page 4

Bryan D. Shaw 832-***-**** abm39i@r.postjobfree.com

Page 5

Bryan D. Shaw 832-***-**** abm39i@r.postjobfree.com

AMEREX Brokers, LLC May 2001 – April 2007

Senior Software Architect http://www.amerexenergy.com/

Led a 10 person global team in three countries doing requirements gathering, analysis, design, development,

implementation, enhancements, testing, deployment,maintenance, support and training of a real time energy brokerage

contract entry and confirmation system utilizing Visual Studio 2003 C#, C++, ADO.Net, Microsoft SQL Server 2005, SSRS

and Delphi 8.

Responsibilities:

•

Developed, maintained and supported a real time, dynamically rendered, energy commodities trading system. Solely

responsible for adding new commodities and data entry objects to the system within minutes of request being received.

Used Delphi 5 8, C# .Net, 2003, 2005, ADO.NET, SQL Server 7, 2000 and 2005.

•

Designed, developed and maintained forward looking analysis and trend reports for natural gas, electricity, emissions,

crude oil, refined oil products, liquefied natural gas, weather, coal and retail power regional and spot markets.

•

Designed, developed, maintained and deployed DCOM application servers. Used Delphi 5 8, C++ 6.

•

Automated the exporting of deals into accounts receivable system and the accompanying reconciliation reports to

support all of the company commodities being traded and distributed them to specific companies and general ledger

accounts by sales desk. Used C# 2003, 2005, XML, ADO.NET, SQL Server 2000, 2005.

•

Designed and developed a dynamic database driven energy commodities brokerage confirmation reporting and

transmission system for both email and faxing. Used C# 2005, ADO.Net and SQL Server 2005.

•

Served as the Database Administrator for the global corporation.

•

Developed and maintained installation projects to deploy software written in house to offices worldwide.

•

Setup computer hardware with appropriate security settings to run the application servers.

•

Responsible for the tracking of broker commissions.

•

Developed and designed dynamic invoices using OLE Automation for Excel and Word.

•

Developed a series of stored procedures and functions to dynamically report deal confirmations as well as database

maintenance tools.

•

Designed ASP.Net pages to capture emission credits and maintained ASP pages to capture customer deal information

and produce deal confirmations.

•

Wrote extensive documentation, procedures, flowcharts and help systems.

•

Upgraded the corporate accounting system several times.

•

Assisted in solving various accounting business issues.

•

Provided in depth data analysis and ad hoc reporting system in response to customer and government inquiries and

subpoenas.

•

Developed reports to ensure compliance with Sarbanes Oxley Act of 2002.

•

Technologies used included: C# 2005, 2003, .NET, C/C++, VB 6, VB.NET, Delphi 5 8, ASP, ASP.NET, MS SQL Server

7, 2000, 2005, VB Script, Java Script, HTML, XML, DCOM, COM, COM+, SOAP, SMTP, ODBC, ADO, OLE, DDE,

SSRS, ETL, DTS, Win 2003, NT, XP Pro, Best MAS 500.

Consolidated Service Corp, LLP September 1997 April 2001

Lead Developer

Led a 5 person team doing analysis, design, development, implementation, enhancements and testing of a transportation

management system utilizing Delphi 3 5, Visual Studio .NET, Visual Basic 6, Sybase 11, Watcom SQL, Microsoft SQL

Server 7 and Crystal Reports.

Responsibilities:

Page 6

Bryan D. Shaw 832-***-**** abm39i@r.postjobfree.com

Developed all of the database transaction routines utilizing cached updates and runtime construction of SQL

•

statements. This provided quick transaction times and light network traffic.

Provided extreme flexibility when porting to different SQL engines.

•

Developed over 35 GUI forms with data validation, searches and record integrity, over 30 stored procedures and over

•

100 database tables.

Designed and developed reports for vehicles, drivers, training, accidents, insurance, locations, pools and other

•

equipment.

Assembled, modified, maintained and installed the VCL.

•

Developed installations programs and their extensions.

•

Trained and supervised ten developers.

•

Technologies used included: C# .Net, C/C++, VB.NET, VB 6, Delphi 3 5, Sybase SQL Server 11, Sybase SQL

•

Anywhere 5, 6 and 7, MS SQL Server 6.5, 7 and 2000, Watcom SQL, HTML, SML, SMTP, ODBC, BDE, ADO, DTS,

Win NT, 2000, 95 and 98.

Triple Point Technology, Inc. March 1997 – September 1997

Software Developer http://www.tpt.com/

Participated in a 12 person team doing development, implementation, enhancements and testing of an energy trading risk

management system that directly interfaced with accounting systems utilizing Delphi 3 and Sybase 11.

Responsibilities:

Developed alpha version electricity and natural gas commodities trading system.

•

Designed the database tables, triggers, rules, defaults, constraints and referential integrity.

•

Developed GUI forms to perform physical trades, swaps, listed trades and options trading, while reporting the trading

•

position real time throughout the trading network.

Technologies used included: Delphi 2, 3, Sybase 11, ERWin, Win NT, ODBC, BDE.

•

Bank United Mortgage August 1996 – March 1997

Software Developer

Participated in a 40 person team doing requirements gathering, analysis, design, development, implementation,

enhancements, testing deployment and training of a mortgage commission tracking system utilizing Delphi 2 and Sybase

11.

Mr. Shaw cCompleted a Delphi project within the first six weeks of employment without having any knowledge of Delphi

prior to joining the organization. This system was used to track commission for national mortgage brokers, loan officers and

wholesalers.

Responsibilities:

All phases and aspects of the project.

•

Technologies used included: Delphi 1 and 2, Sybase 11, Win NT, Win 3.11 and 95, ODBC, BDE.

•

Page 7

Contact this candidate