We provide IT Staff Augmentation Services!

Consultant / Sql Developer Resume

2.00/5 (Submit Your Rating)
Hire Now

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, Transact - SQL, Stored Procedures, Functions (Table and Scalar), Triggers, SSIS Load and Extract Packages, XML, XQuery

CLIENT/SERVER: Excel macros and UIs, VBA, FileSystemObjects, VBScript, HTML, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential

Consultant / SQL Developer

  • 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. (Half 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.

Skills used: SQL Server 2012, XML, XQuery, SSIS, SVN

Confidential

Consultant / SQL Developer

  • Follow the Agile development methodology.
  • Work with team members on database design strategies.
  • Create databases and code all stored procedures and functions.
  • Work with other SQL developers on improving performance.
  • Work with junior developers on improving development skills.
  • Develop strategies for backend test driven development.

Skills used: SQL Server 2012, SSIS, Excel VBA

Confidential

Consultant / SQL Developer

  • 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.

Skills used: SQL Server 2008, SSIS, Excel VBA

Confidential

Consultant / SQL Developer

  • 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.

Skills used: SQL Server 2005, Excel VBA

Confidential

Consultant / SQL Developer

  • 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 training support staff.

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

Confidential

Consultant / Application Developer

  • Use the DTS object model to write load procedures for retail data.
  • Create all tables and stored procedures.
  • Write a VB front end for picking a report style, options and details.
  • Write Excel macros for generating charts and reports.

Skills used: VB 6, SQL Server 2000, DTS, Excel VBA

Confidential

Consultant / Web Developer

  • Meet Ford’s compliance requirements such as Sarbanes-Oxley, secure communications with SSL, Internet and Intranet facing Firewalls (DMZ), and Ford’s single login for all websites.
  • 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 training all the users on the new system.
  • Code custom tools for analyzing web logs and SQL Trace logs in great detail.
  • Administrative skills require Windows 2003, SQL Server 2000, and IIS 6.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship