We provide IT Staff Augmentation Services!

Enior Programmer Analyst - Etl/sql Developer Resume

4.00/5 (Submit Your Rating)

Addison, TexaS

SUMMARY:

  • Over twenty eight years of full life cycle development experience in the computer technology industry.
  • Twenty five years of experience in database development and maintenance of an enterprise level financial accounting systems.
  • Seven years of high performance ETL/SSIS/SSRS work.
  • Experienced in leading effective teams to resolve complex issues successfully and possesses experience in multiple front - end GUI/Internet languages coupled with strong database skills.

SOFTWARE:

Development Tools: SSIS, SSAS, C#, VB.net, C++, Visual Basic 6.0, SQL Server, Oracle, FrontPage, MS Active X Controls, MS Access, MS Active Server Pages, Informix-4GL, HTML

Operating Systems: MS-Windows 7, MS-Windows XP, MS-Windows NT, MS-Windows 98, MS-Windows 2000, MS-DOS, SCO-Unix

Reporting Tools: Crystal Reports, SSRS

RDBMS/Tools: SQL Server 2005/2008/2000 Informix, DB4

Testing Tools: Rational Robot/SQA

PROFESSIONAL EXPERIENCE:

Confidential

Senior Programmer Analyst - ETL/SQL Developer, Addison, Texas

Responsibilities:

  • Extensive requirements with SQL Server stored procedures and views
  • Develop and maintain financial and mortgage/foreclosure processing data for use in governmental reporting. These processes were development in SQL2005-2015/SSIS using variables, configurations and expressions.
  • Developed an SSRS system that maintains SQL Jobs allowing programmers access to protected bank systems through a managed interface.
  • Created a generic data driven SSIS system to replace and increase download from AS400 performance of all of the SSIS packages of the mortgage servicing unit.
  • Created and maintained SSAS star schema data warehouses for complex reporting.
  • The primary task was to move data from the AS400 into SQL Server 2005/2008 tables via SSIS to create complex governmental report outputs using SSAS with an Excel Pivots as the final display.
  • Create web applications that connect the ASP.net/C# front ends to SQL Servers.
  • Developed C# Winforms and console applications for automation functionality

Confidential

Senior Database Developer, Carrollton, Texas

Responsibilities:

  • Created and maintained complex accounting software using stored procedures, functions and TSQL.
  • Maintained a 24/7 99.9% availability system software system.
  • Performed architectural redesign of systems to simplify process and increase performance of databases using primarily SQL Server 2005/2008
  • The primary task was to convert law changes in IRS, State and Local Tax codes as interpreted by the business analyst and develop these changes into web-based applications that correctly calculated, printed, filed tax documents.
  • The style of application was to have a ASP/ASP.net frontend attached to several SQL Server 2005/2008 stored procedures for display, updating and calculating the overall complex tax forms.

Confidential

Senior Programmer Analyst/Team Lead, Dallas, Texas

Responsibilities:

  • Led a team of 3 in the design, development, installation, and implementation of education management software using Visual Basic 6.0, SQL Server 7.0, DB4 and Crystal Reports 7.0.
  • Converted files into DB4 tables for movement of data from mainframe systems into current system.
  • The primary task was to install and convert school/student data for the Carrollton Independent School District into a functioning data management system.

Confidential

Senior Programmer Analyst/Technical Lead, Dallas, Texas

Responsibilities:

  • Led a team in full lifecycle development of logistics software systems.
  • Performed database design using SQL Server 6.5 - 7.0 and Microsoft Access 7.0, and coding using Visual Basic 5.0/6.0, Delphi 4.0, stored procedures, and Crystal Reports 6.0.
  • Supported implementations, performed troubleshooting, testing and debugging, and instructed other programmers to accomplish programming objectives.

Confidential

Programmer Analyst, Dallas, Texas

Responsibilities:

  • Performed design, development, and maintenance for a Warehouse Management System and Yard/Dock Trailer Management System for the food service industry.
  • Developed applications in Visual Basic 5.0, Visual Basic 4.0, created stored procedures in SQL Server 6.5, and maintained Access databases.
  • Constructed Microsoft Active Server Pages, HTML, and Crystal Reports 6.0 in Windows 95 and NT.

Confidential, Dallas, Texas

Programmer Analyst

Responsibilities:

  • Performed enhancements to a proprietary Transportation Management System (TMS) for Confidential 500 grocery/retail customers using Informix-4GL.

We'd love your feedback!