Consultant / System Architect Resume

SUMMARY:

Extensive experience as a lead SQL developer with additional web and application development. This includes mentoring, code review, performance tuning and standards. Projects tend to include analysis, data warehouse modeling, systems design, presentation, proof of concept and SDLC / Agile.

TECHNICAL SKILLS:

DATABASE: SQL Server 2012, Transact - SQL, Stored Procedures, Functions (Table and Scalar), Triggers, SSIS Load and Extract Packages, XML, XQuery

CLIENT/SERVER: Excel macros and UIs, VBA, ADO, ActiveX DLLs, FileSystemObjects

WEB: ASP, VBScript, HTML, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential

Consultant / System Architect

Skills used: SQL Server 2012, XML, XQuery, SVN, Mingle.com

Responsibilities:

As System Architect, develop a solution and then write and present Power-Point presentations about it. This includes requirements, system diagrams, use cases and walkthroughs.
Follow Agile development methodology including daily scrums, code reviews, frequent releases and backlog management.
Team lead for 5 SQL developers, 3 java developers, 3 QA. (Most were offshore.) This includes writing requirements, assignments, time estimates and project planning.
Rollouts require careful planning on 400 distributed and synchronized databases.
Write SQL code generators that make triggers and stored procedures on hundreds of tables.
Write dynamic stored procedures for converting results to XML for transport and then back into results using XML data type methods and XQuery.
Develop automated test scripts for the database and backend.
Performance tuning through Dynamic Management Views.

Confidential

Consultant / SQL Developer

Skills used: SQL Server 2012, SSIS, Excel, Git

Responsibilities:

Confidential

Consultant / SQL Developer

Skills used: SQL Server 2008, SSIS, Excel Macros

Responsibilities:

Develop a data warehouse for estimating the value of products.
Develop all SSIS packages for loading and extracting feeds.
Write efficient functions for calculating present values using floating interest rate projections.
Develop Excel macros with user interfaces for generating charts.
Work closely with outside vendors on project planning and file transfer agreements.
Work closely with operations to plan out timelines, resource requirements and rollout and to also shorten the SDLC process.
Work with management to improve the project management process.
Use the INTEX Wrapper API to generate RMBS cashflow projections.

Confidential

Consultant / SQL Developer

Skills used: SQL Server 2005, Excel Macros

Responsibilities:

Develop SQL stored procedures mainly for reporting.
Develop functions to distribute loan payments among the collateral using a weighted average so that they balance to the penny.
Develop a dynamic table structure that does not require dynamic SQL.
Work closely with users and BAs to shorten the SDLC process.
Responsibilities include project plans, time estimates, tech specs and test plans.
Develop Excel macros for generating dynamic reports.

Confidential

Consultant / SQL Developer

Skills used: SQL Server 2005, Transact-SQL, DTS, Stored Procedures, VBScript, Excel macros, Actuate

Responsibilities:

Develop stored procedures to load feeds into the data warehouse.
Modify stored procedures to track their performance.
Improve the efficiency by removing cursors and improving indexing.
Responsibilities include making deployment packages and writing specs, project plans, coding and testing.
Work closely with system support, BAs, and external clients.
Develop monitoring and emergency applications for production support staff.
Develop more efficient management solutions for production issues.
Develop documents, Power Point presentations and videos for support staff.

Confidential

Consultant / Application Developer

Skills used: VB 6, SQL Server 2000, Excel and DTS Object Models

Responsibilities:

Confidential

Consultant / Web Developer

Skills used: ASP, JavaScript, VBScript, VB 6, HTML, IIS 6, SQL Server 2000

Responsibilities:

Work with Systems Administrators to set up proper development, testing and disaster recovery environments.
Set up a source code control environment and proper code change migration procedures.
Coordinate the decommissioning of sections covered by other company websites. This required finding, contacting, coordinating and all the users on the new system.
Code custom tools for analyzing web logs and SQL Trace logs in great detail.