Programmer Analyst Resume Profile

Sr. Developer

Innovative, results-oriented management professional with over 26 years of visible achievements providing leading edge technological solutions having extensive qualifications in all aspects of systems administration, management and maintenance, network/server operations and hardware/software solutions.
Exceptional skills in implementation of teams and systems to provide business solutions which increase operational efficiencies. Deliver bottom-line results through effective design, development and execution of systems to reduce or save costs.
Able to effectively focus teams toward performance an excellence through hands-on leadership style and excellent communication skills. Proven track record in streamlining operations through automation, custom applications, and comprehensive designs/process that business units can fully understand and relate.

Core Management Competencies

Technical

OOD

Management

PL-SQL/Oracle

Visual Basic/Basic

Sybase/SQL Server

Java

C/C

Perl/CGI

PowerBuilder

Technical Expertise

PROFESSIONAL ACCOMPLISHEMENTS

Confidential

Sr. Programmer Analyst / SQL Server/MySQL DBA

Confidential

Sr. Programmer Analyst / SQL Server DBA

SOA and EAI Lead. Created new estimating system for Big 6 Advertising firm.
Provided full cycle account processing from estimating to full accounting support through interfaces to their Elite accounting system.
Migrated accounting system and all custom programs from Informix/Unix to SQL Server.
Created Estimating system for the Web in Perl CGI/JavaScript front-end with a Perl SQL Server backend, HTML, DHTML.
Application had complex controls involving AJAX calls, tabs, and document management.
Created JSON parser on SQL Server for a message queue. JQuery, Prototype, JavaScript, Stored Procedures, Table Valued Functions, Scalar Functions.
Agile Development

Confidential

Data Migration - PowerDesigner was used to reverse engineer the Informix Database and produced create statements for SQL Server. Then dbschema Informix tool was used to create tab delimited files for import. Then SSIS was used to import the files.
ETL to transform Informix data, EDI, to SQL Server
Conversion of C programs to T-SQL
Restructuring Data Warehouse and processes - many of the processes written in Informix was done in such a way that most of the data warehouse activity was a batch process with extracts of aggregated data processed nightly. Since SQL Server was able to handle the near real time processing through Table Valued Functions, much of the processes were converted to near real time. Only the largest aggregation of data was left batch and those were converted to SSIS

Confidential

Marketing/Accounting System

Full SDLC Software Development Lifecycle - A new Development, Test, and Production Environment was created to facilitate the new marketing system. All changes were logged to Bugzilla, with pushes to Test for each major release, then pushed to production for final release. This involved coordination with users, identifying stored procedures, triggers, table valued functions, and scalar functions to push at the appropriate time.
SOA Service oriented Architecture - There was no concept of work flow initially so I worked with users and Rational Rose to map the many steps to the user processes. I created process queues in JSON since both Perl/CGI and JavaScript worked exceptionally well with JSON constructs. The queues were all T-SQL. Users could request new charge accounts, new clients, approval on Statements of Work, creation of accounting groups, etc, and all were fed to processes queues in which other users could accept or reject their requests. It maintained full traceability to the initial request.