Enior Programmer Analyst - Etl/sql Developer Resume
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.