Post Job Free

Resume

Sign in

Sql Server Manager

Location:
Charlotte, NC
Salary:
55Hr
Posted:
June 07, 2016

Contact this candidate

Resume:

James Braxton Perry, II

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

Charlotte, NC 28269

acu43g@r.postjobfree.com

704-***-**** (h) 704-***-**** (c)

Objective: To be the best middle and data tier programmer and stay on the leading edge of design.

Experience

Apex Systems – Wells Fargo Wholesale Technologies.

Contract October 2015 ~ May 2016

The contract focused on mailing and reporting for large commercial mortgages.

This contract focused on Oracle requiring me to bring my Oracle and SQL Server skills to parity.

After becoming familiar with the code I wrote up opinion papers on challenges on moving the various systems to Microsoft Azure.

I finished an MVC website beginning to end where previously I had only worked on the back end processing at the Comdyn / Colefax project. I used open source Dapper in the place of entity framework.

Also during that time I took advantage of training offered by Apex through O’Reilly’s Safari Online. I covered advanced c#, Oracle, Python and neural nets for artificial intelligence.

The project ended prematurely because of business conditions in commercial lending. They felt they could continue to use current tools for a few more years and I agree with them.

Comdyn – Colfax Fluid Handling

Contract August 2015 ~ *October 2015

This contract focused on coordinating database changes and Entity Frame 6 model changes in a rapidly moving project.

New skills include Azure system management and Azure Blob Storage.

*Note I normally turned in 120 hour every two weeks. This contract was short and intense by design.

Bank of America– End User Computing

Contract April 2015 ~ August 2015

This contract focused on using multithreaded windows services to import items into a multi petabyte HP Autonomy Data Warehouse and removing items when legally allowed.

This was done with C# and SQL Server. The project itself was cancelled.

Apex Systems - Wells Fargo Securities – Capital Markets

Contract June 2014 ~ March 2015

In the second contract under another manager, I worked with the same ASP.NET and Telerik technologies.

My current project uses advanced Entity Framework 4.3, extensive LINQ, formviews and a complete business rule stack to implement a legal compliance system.

The first project was to touch up a web site that helps finalize initial public offerings and bond issuances. The team brought it from classic ASP to ASP.NET 4.0.

Advantage Technology - Wells Fargo Securities – Capital Markets

Contract Sept 2013 ~ April 2014

At Wells Fargo Securities I focused on the BMS (Brokerage Management System) website and the BMS Utilities that performed ETL services for files coming in from CME, GMI, ICE US, ICE EU and Credit Suisse.

The program balanced a variety of instruments including bonds, bond swaps, derivatives, securities. Many of our clients were hedge funds for whom we did custom processing and reporting. I improved the performance of each exchange import and balance / reconciliation by over 80%.

The technical side of the work required ASP.NET, extensive Telerik custom controls, SQL, SSIS, SSRS and Excel.

The subject matter side required understanding the interactions of CME, GMI, Broadridge, ICE US, ICE EU and Credit Suisse.

Environment

VS 2012, SQL Server 2012 R2, ASP.NET 4.0

Telerik Studio

Rad Grid, Rad Grid Filter, Rad Date Control

C# ASP.NET

Multi-tier internal website

SQL Server

Lead developer for advanced SQL work

Optimize queries and stored procedures

ETL Translation work

AMTdirect Charlotte NC Senior Programmer / Analyst

Sept 2012 ~ September 2013

AMTdirect writes web and cloud based software for commercial real estate. The software can be used from either the perspective of the landlord or tenant.

I specifically worked with percent rent calculation and complex report batch processing. I have also worked through the body of TSQL code to enhance speed and error logging. I am handed the newest hardest work.

I have worked and completed multiple pages and projects start to finish.

Environment

VS 2012, SQL Server 2008 R2, ASP.NET 4.0

Telerik Studio

Rad Grid

oPaging, sorting, searching

Ajax controls

oThe various controls to limit the harsh full post back refreshes

Smart input boxes

C# ASP.NET – Current Work

Programming N Tier public facing multi-tenant website.

Use of web services for load balanceing.

VB.NET Middle Tier

Support of older BL and DAL work done before the transition to C#

SQL Server

Lead developer for advanced SQL work

Optimize queries and stored procedures

Exago eWebReports

We use Exago so that customers can write their own custom reports on the website itself.

Senior Report Writer

Third party liaison to work through detailed programing issues

The Remi Group, LLC Charlotte NC Senior Programmer / Analyst

May 2010 ~ Sept 2012

Six month overlap with Comdyn

The Remi Group is a post warranty equipment insurance company. They insure equipment ranging from MRI machine to copiers in enterprise encompassing packages.

I specifically worked in risk assessment, policy renewal, invoice processing and accounting issues.

Environment

VS 2010, SQL Server 2008 R2, ASP.NET 4.0

VB.NET Win Forms.

Programming N Tier internal enterprise system tracking all accounts, sales, and claims

The product uses the CSLA enterprise architecture by Rockford Lhotka. CSLA is very advanced enterprise architecture with multiple undo and redo methods in every derived object.

ComponentOne Controls

Win form Grid and multi-tab controls on over 70% of the pages.

SQL Server / SSIS / SSRS.

Lead developer for advanced SQL work and Reports

Integration of enterprise system to Great Plains

VB.NET / ASP.NET.

Maintenance programming on client facing web site that allows self-service enterprise reporting.

The website is also N Tier

Tableau Analytics Software

Create and support dashboards

TSQL behind the dashboards

Data mart planning and nightly data migration

The Comdyn Group, LLC Charlotte NC Senior Programmer / Analyst

September 2007 ~ October 2010

Major Clients:

BCBS TN / Rivertrust organization

Rivertrust handles Medicare / Medicaid claims appeals for TN and NJ.

I handled and improved day to day operations so that they could be done by one person.

I resolved dozens of deep bugs and performance issues latent in the program.

I built a service manager console to reduce tech support calls and give management more support power.

Web services were used to query and transmit individual cases.

Tools: VB.NET 2005, SQL Server 2005

Cellguard / Polypore INC

Cellguard makes advance thin film plastics used to make advanced batteries and devices.

I was the DBA, enhanced SQL performance and built up an advanced set of SSRS reports.

My work also integrated their enterprise system to Microsoft Great Plains.

Web services were written and used to query industrial machines and departmental servers for updates

between the nightly batch processing.

Tools: VB.NET 2005, SQL Server 2005

Medical Transcription software

The company sold internet based medical transcription

I worked on several pages through all three tiers.

The project had both Winform and ASP.NET sections.

Web services were used to extract voice files from cold storage.

Tools: VB.NET 2008, SQL Server 2008

BiTek inc.

BiTek writes software for municipal county tax offices.

I worked with advanced business layer programming and TSQL SSRS work.

Tools: VB.NET 2008, SQL Server 2005

Garretson Law Firm

Garretson Law handles paperwork for drug lawsuit settlements.

I completely wrote a website to handle the public facing lead collection and backend follow up management.

Tools: VB.NET 2005, SQL Server 2008

Check Into Cash

Check Into Cash is a payday lender with very complex legal requirements.

I worked with writing advanced testing units using Watin and NUnit.

Tools: VB.NET 2008, SQL Server 2003

Betco

Betco builds turnkey mini warehouse sites.

I worked on advanced HTML reporting and entity modeling.

Tools: VB.NET 2005, SQL Server 2005, SQL CLR, SSRS, SSIS

Comdyn Itself

I built many in house tools beginning to end to speed code development and test creation.

I helped start to finish on Comdyn’s time tracking system.

Tools: VB.NET 2008, SQL Server 2008, SSRS

Regions Bank Birmingham AL Senior Developer

March 2007 ~ September 2007

Regions bank had recently merged with several hundred branches of SouthTrust.

I worked to merge their CRM systems into an updated version of Regions current CRM.

SQL Server 2005 / SSRS / SSIS.

Redesigned the tables from a previous programmer's overly complex system.

Wrote the documentation to show table dependencies for each section of the technical specification to prove that my tables were complete.

Wrote the CRUD operations and SSIS import package to move data from the old system to the new.

Wrote an advanced hierarchy system describing the banks agent rank and rights in TSQL

C# / ASP.NET / AJAX.NET. (2.0 generation)

Created user screens with grid views, list views, and made extensive use of the AJAX.Net components

Enhanced the entity model for the overall application

Researched and debugged deep issues.

Wrote the model, data access layer, and entity laver of the bank agent hierarchy.

Web services were consumed to handle customer lookup and authentication.

Training Between Jobs

October 2006 ~ March 2007

While looking for work, I took time to retrain and refresh college courses through free online classes and podcasts.

I took great advantage of absolutely free noncredit class videos and course materials available at many colleges.

BMJ Holdings, Inc Charlotte NC

March 2005 ~ October 2006

Senior Developer

BMJ worked to develop a grid based .NET graphical rendering system

C# / ASP.NET

Created user interface and batch process management screens

Created core object layer to talk to the C++ object libraries.

MySQL

Created Tables, relations, CRUD Operators

Managed the clustering between the servers.

Crowell Systems Charlotte NC Developer

October 2004 ~ March 2005

Crowell Systems makes medical office software specializing in eye and allergy.

I handled tech support and light programming.

LINUX / PICK Database

Researched customer data issues and bugs

Made enhancements to the system and increased system robustness.

Wrote interfaces to Linux core OS systems

Vinroot for Governor Charlotte NC Senior Developer, IT Director December 2003 ~ October 2004

C# / ASP.NET

Built five themed websites as the campaign pushed political ideas.

Built a site to coordinate large scale fundraising among high dollar contributors'

SQL Sever 2000

All DBA Functions

Maintained core campaign data

Muratec-USA, INC Charlotte NC Senior Developer IT Manager

March 1998 – March 2003

Murata Wiedemann, now Muratec-USA, build metal forming and turning solutions.

I originally came to the company to finish an robotics interface abandoned by a previous programmer and became the IT manager supporting the needs of accounting and engineering.

The programming of this era was Delphi / VB 6.0 with experiences with AS/400 and SQL Server and the company’s first web sites.

I also started with .NET in it’s infancy.

Before Murata

Jobs before 1998 were pre object oriented and procedural languages. Most projects were classic FoxPro or FoxPro for windows with some VB 6.0 and Delphi 1.0.

Education

Professional

dbBasics Formal Microsoft Training 2002

Formal

Appalachian State University BS Computer Science 1994

Lees McRae College BS Mathematics 1992

Most electives on both degrees taken at the senior or graduate level when possible.

Also Background in

1..NET 1 – 4.5.1

2.SQL Server 2000, 2003, 2005, 2008 R2, 2012 R2

3.VB 6.0, FoxPro, Delphi ActiveX era languages

4.Can read and follow COBOL. Professional conversion experience

5.Robotics & Motion Control

6.Project Management, Consultant management

Continuing Education

1.Design patterns

2.SQL Server 2014 TSQL, SSIS, SSRS

3.CQRS – Command Query Responsibility Separation

4.Data Analytics beyond current employer’s needs

5..NET 4.5

6.Visual Studio 2013

7.Entity Framework



Contact this candidate