Sql Server Resume Profile
Summary
I am a Guidewire and Microsoft certified developer with over 25 years of professional experience in all phases of the SDLC. I have extensive experience in Microsoft distributed n-tier application architectures. Over the last two years, I have been assimilating the Tomcat, Eclipse, Java platform differences required in the Guidewire studio / Gosu development environment. I also have interest in the Apple development environments and have begun personal projects for OS X and iOS using Xcode and Swift. My years of experience allow me to quickly ramp into projects and become a productive and pivotal member of the team. I distinguish myself with a rigorous continuing education discipline including a keen interest in design patterns, coding practices and coding paradigms. My industry experience includes accounting, banking, brokerage, insurance, healthcare, public utilities, real estate, and telecom.
Technologies
- Microsoft, Guidewire 7, OSX, iOS
- jQuery, Javascript, Gosu, Java, Objective C, C , C 4.0, Swift, VB, T-SQL, PLSQL
- Visual Studio, Xcode, Guidewire Studio, Eclipse, Expression Blend, IIS, TomCat
- WPF, WinForms, Silverlight, XAML, ASP.NET, CSS, HTML
- WCF, LINQ, XML, XSLT, MTS, MSMQ, COM, COM , DCOM, ADO.NET
- SQL Server, Oracle, DB2, MS Access, SQL Station, PLSQL, Crystal Reports
- Git, CVS, SVN, SourceSafe, Visio UML, Rational Rose, Quality Center, Photoshop, Illustrator
- Independent Consultant Software Developer / Architect Confidential
- Description A phased replacement of Rockhill policy administration system with the Guidewire policy center and billing center applications
- Architecture 3 tier web application based on a Guidewire framework with an ORM mapper to SQL repository augmented by enterprise services to HPX and core SA accounting functionality
- Technologies Guidewire studio, Gosu, C , Java, XML, SQL Server, SVN, Visio, Version One, Quality Center
- Confidential Description Ms Web Portal to deliver core SA PAS functionality to hundreds of independent agents nationwide
- Architecture 3 tier ASP.net web farm application with SQL Server repository and mainframe interfaces
- Technologies ASP.Net 3.5, jQuery, Javascript, XML, AJAX, LINQ, C , VB, ADO, SQL Server, Visio, QC
Confidential
GL Allocation
- Description Loads transmission settlement data from RTOs to the PeopleSoft General Ledger
- Architecture 3 tier web farm application with multiple supporting web and windows services
- Technologies ASP.Net 3.5, C , WCF, ADO.Net, Enterprise Library, Oracle, PLSQL, Visio, Quality Center
SSF
- Description Managed the data flow of West Pool Settlements for delivery to internal systems.
- Architecture 3 tier web farm application with supporting windows service
- Technologies ASP.Net 3.0, C , ADO.Net, Enterprise Library, Oracle, PLSQL, Visio, Quality Center
BQMaps
- Description Maps external broker quotes to internal structures for consumption in SAS models feeding 5 internal trading floor systems
- Architecture Windows Presentation Foundation WPF application with one touch deploy
- Technologies WPF, XAML, C , ADO.Net, Enterprise Library, PLSQL, Oracle, Visio, Quality Center
- Confidential Description Data aggregation and submission from internal systems to Regional Transmission Organizations
- Architecture 3 tier web farm application with supporting windows service
- Technologies ASP.Net 1.1, C , ADO.Net, Enterprise Library, Oracle, PLSQL, Visio, Quality Center
- Confidential Description Web Portal for aggregation of plant emission data.
- Architecture 3 tier web farm application
- Technologies ASP.Net 1.1, C , VB.Net, ADO, DB2, IBMSQL, Visio
- Confidential Description Produces the source information to be utilized by the SAS environment to calculate VAR.
- Architecture 3 tier logical design 2 tier physical implementation
- VB6 code, 6,000 lines Oracle PLSQL stored procedure code.
- Technologies .Net Framework 1.0 1.1, VB.Net, ADO.Net, Oracle, PLSQL, Visio
Risk
Description Built internal website to post Internal Audit surveys and capture responses from business line management. Responses are correlated to previous year audits and accessed risk for assured compliance with the Sarbanes Oxley Act.
Energy Trading Value at Risk
- Description Data aggregation and statistical analysis program to, aggregate and categorize daily trading data to correlate, assign and report relative financial risk using modern portfolio theory.
- Architecture 3 tier logical design 2 tier physical implementation
- Delivered Vision scope document, UML based requirements document, 400 page design document, 100,000 lines VB6 code, 30,000 lines Oracle PL/SQL stored procedure code.
- Technologies VB6, ADO, COM, Oracle, PLSQL, SQL Station, MS Project
Confidential
SQL Server, VB.Net
- Description The Ohio Tuition Trust Authority OTTA Investment Administration product is responsible for the administration of the State of Ohio 529 College Advantage Savings Plan. OTTA requested a redesign of its 10 year old investment management software and supporting database.
- Confidential Small Business Server Install and IT Support
- Description Install small business server network to facilitate the automation of patient data aggregation and reporting via a server based line of business application.
Confidential
Company Website
- Description Presentation of monthly phone bills to end customers via the company website. Web based sales bundle / package presentation. Automated web to line of business communication. Automated 3rd party credit scoring for new customer sign ups. Delivered 30,000 lines VB6 MTS code, 10,000 lines SQL Server stored procedure code.
- Technologies VB, C , ATL, ADO, COM, CDO, MTS, MSMQ, XML, SQL 6.5, Oracle, PLSQL, Rational Rose
Confidential
Investment Corrections
Description Reallocation of investment earnings with regulatory oversight, Extracted data from LOB applications to SQL Server database with MS Excel presentation tier, Banking analysts corrected data and reloaded to LOB apps
Confidential
Consolidated Bill Presentation
Description Expanded monthly phone bill presentation to include 3rd party billing.
