Experienced Information Technology Programmer Analyst
Phoenix, Arizona Area
Experienced Information Technology Programmer Analyst
Phoenix, Arizona Area
Provide rapid solutions to urgent business needs by utilizing my extensive problem solving skills, optimizing inefficiencies, and increasing productivity through process analysis and systems automation.
Programming: Visual Basic 6, VB.NET, VBA, Excel
Databases: SQL Server 2000/2005, Access
(Banking industry)
August 2007 — Present (1 year 4 months)
-Design and program SQL Server 2000 and 2005 back-end relational databases
-Code, test and maintain VB6, VBA and VB.NET front-end software applications
-Build dynamic reporting interfaces for mortgage, commercial, accounting/financial, appraisals, and loss mitigation departments
-Build systems for tracking and managing workflows across departments
-Streamlining various accounting processes for efficiency, accuracy, and accountability while implementing policies and guidelines
-Design, implement, and automate ETL solutions and data warehousing
-Identify requirements by establishing personal rapport, understand service requirements, design, develop and maintain applications and databases; evaluating client needs; analyzing requirements; developing software systems.
(Public Company; 1001-5000 employees; TM; Financial Services industry)
August 2006 — August 2007 (1 year 1 month)
-Develop/maintain applications automating mainframe tasks in VB6 and VB.NET
-Build relational database applications and reporting solutions using Access, SQL
-Create ad-hoc reports using VB6, Access, Excel
(Privately Held; 11-50 employees; Telecommunications industry)
February 2006 — August 2006 (7 months)
-Designed SQL Server databases to fit customer needs as backend data source and created front-end applications using MS Access and Visual Basic 6
-Created reports with MS Access and Crystal Reports, used T-SQL to automate data management through DTS packages and triggers
-Developed and implement specific project plans for each customer that cover product and facility definition and requirements; application, script, database and reporting requirements; training requirements and schedules
-Develop and test applications, scripts, databases and reports that satisfy the customer’s business requirements
(Privately Held; 11-50 employees; Computer Software industry)
November 2005 — February 2006 (4 months)
-Created enhancements and performed maintenance to existing software applications using Visual Basic 6, VB.NET, and SQL Server 2000
-Migrated existing VB6 applications to VB.NET
-SQL stored procedures, views, functions, triggers, and transactions
-Researched new development projects, designed proof of concepts, analyzed functionality and feasibility, implemented where appropriate
-Designed Crystal Reports to interface with SQL Server and MS Access data
(Sole Proprietorship; 1-10 employees; Information Technology and Services industry)
May 2003 — October 2005 (2 years 6 months)
-Developed applications using MS Access and SQL Server 7.0/2000 as backend database and coded front-end Visual Basic 6, VB.NET, and VBA solutions
-Migrated existing VB6 applications to VB.NET
-Improved/analyzed database design methodology/structure as well as implemented relational database design, performed normalization, optimized execution strategies, and ported to the web
-Created data mining applications and web crawlers to interface and connect old methods with new solutions allowing much more versatile use of acquired data and more simplified access
-Automated report generation producing using Access Reports and Crystal Reports
AA, Business - Special Requirements, 2006 — 2009 (expected)
Investing, boxing, weight-lifting