SUMMARY

• To obtain a challenging position as a Programmer/Analyst utilizing my .NET and SQL Server skills.

TECHNICAL SKILLS

Skills: VB.NET; C#.NET; SQL; T - SQL; SQL Server 2005; Team Foundation Server; Object Oriented

Programming/Design: Visual Studio 2008; Visual Studio 2008l; Third Party

Tools: /Libraries: SQL Prompt, Infragistics UI Controls; DevExpress UI Controls

PROFESSIONAL EXPERIENCE

Confidential

Senior Application Analyst

Responsibilities:

• Developed the Letter Automation Phase I project which was a console application written in VB.NET which would automate the task of extracting data from a SQL Server database and creating PDF files. Other technologies used include XML and XQUERY.
• Developed the Letter Automation Phase II project which was a console application written in C# which would automate the task of extracting data from a SQL Server database, creating CSV file(s), and then sending the file(s) by FTP. An incoming process would download files by FTP, extract the PDF files from a zipped file, and place them on a file share. Other technologies used include XML, LINQ to XML and a third party ZIP file library.
• Created test plans to be used by QA for testing
• Perform code reviews
• EDI transaction issue resolution specialist in Utilisense, the primary line-of-business system (VB.NET with SQL Server 2005 back end.
• CVS and TFS for source code control. MS Test was used for Unit Testing)
• Diagnose and fix recurrent issues in Utilisense and also create system upgrade/repair specification and requirements documents
• Create, modify, and enhance stored procedures, views, and tables
• Created several C# console applications to automate recurrent tasks
• Create ad-hoc reports for various business units

Confidential

Contract Application Analyst

Responsibilities:

• EDI transaction issue resolution specialist in Utilisense, the primary line-of-business system (VB.NET with SQL Server 2005 back end.
• CVS and TFS for source code control. MS Test was used for Unit Testing)
• Diagnose and fix recurrent issues in Utilisense and also create system upgrade/repair specification and requirements documents
• Create, modify, and enhance stored procedures, views, and tables
• Created several C# console applications to automate recurrent tasks
• Create ad-hoc reports for various business units

Confidential, Houston, Texas

Independent Contract Programmer

Responsibilities:

• Modified and enhanced an application to import data from text files to QuickBooks Enterprise using .NET 2.0 (VB.NET) and a third party API library
• As lead developer, developed the I-Tech Winforms application to manage customer information, quotes and record measurement data using VB.Net 9 (Visual Studio 2008, NET Framework 3.5, and ADO.NET 3.5, Infragistics UI Control)
• Used OOP/OOD for maintainability and organization of code
• Used open source applications and libraries for source control and development purposes (Subversion, TortoiseSVN, and VisualSVN)
• Created, modified, and enhanced SQL Server 2005 tables
• Worked with management and users to gather requirements

Confidential, Houston, Texas

Programmer

Responsibilities:

• Lead software developer on a project to convert an Access 2007 operations management database with 2 other developers to a 3-tiered Winforms application using VB.NET 9 (Visual Studio 2008, NET Framework 3.5, and ADO.NET 3.5, DevExpress UI Controls). Strong influencer of technical direction and tooling decisions
• Used open source applications and libraries for source code control and development purposes (Subversion, TortoiseSVN, VisualSVN, Sandcastle, LINQ to AD, NANT for builds)
• Used OOP/OOD for maintainability and organization of code. Developed unit tests to maintain quality and used MS Test to run tests
• Developed a VB.NET 2005 Winforms application to allow viewing of DDL trigger data which was in XML
• Modified and enhanced an operations management database written in MS Access 2007
• Created, modified, and enhanced SQL Server 2005 objects such as stored procedures, functions, triggers, tables, and views. Used T-SQL
• Worked with end users and all levels of management to gather requirements and train on implemented features
• Assisted in the development of change request procedures to document system changes
• Assisted in the troubleshooting of application problems and issues
• Created ad-hoc reports and queries for management and users

Confidential, Houston, Texas

Contract Programmer

Responsibilities:

• As part of a 3 member team, modified and enhanced an operations management database developed in Microsoft Access 2003 and a SQL Server 2000 backend
• Created, modified, and enhanced SQL Server 2000 objects: Tables, Views, Triggers, Functions, and Stored Procedures

Confidential, Houston, Texas

Contract Programmer

Responsibilities:

• As part of a 4 member team, enhanced and modified the GRS-Rig 5.x application which was used to track all aspects of drilling rig operations
• Visual Basic 6.0 was used as the front-end development tool and Microsoft Access 2002 for the back end Used Visual Source Safe 6.0 to maintain source code control
• Crystal Reports v10 was used as the reporting tool

Confidential, Atlanta, Georgia

Independent Contract Programmer

Responsibilities:

• Developed a contact and media campaign management system using Microsoft Visual Basic 6.0 and Microsoft SQL Server 2005, and Crystal Reports 11.
• Third party ActiveX controls were used to provide additional functions and features.
• In addition to coding, other activities performed were gathering of user requirements, database modeling using Microsoft Visio 2003, and database object creation: tables; stored procedures; triggers and views
• Developed a Microsoft Access 2003 database that interfaced with Microsoft SQL Server to manage the documentation of database objects: Tables, Stored Procedures, Views, and Triggers
• Optimized the database and SQL queries to increase database performance
• Created DTS packages to load and transform data from Excel files to the SQL Server database
• Developed assemblies in VB .NET 2005 which were used in the VB 6.0 application as COM components

Confidential, Houston, Texas

Contract Programmer

Responsibilities:

• Modified and enhanced an inspection order tracking database developed in Microsoft Access
• Modified and enhanced two invoice tracking databases developed in Microsoft Access
• Developed Lotus Notes agents to manage e-mail attachments using LotusScript.
• Used Microsoft Visio 2003 to create document agent process and flow.
• Developed the protocol and interfaced with vendors to insure compliance with the electronic reporting protocol
• Developed ad-hoc queries and reports for management and staff

Confidential, Houston, Texas

Programmer

Responsibilities:

• Worked with legal assistants, attorneys, and other staff to gather user requirements
• Modified and enhanced a worker’s compensation claim management database developed in Microsoft Access 2000
• Modified and enhanced a personal injury claim management database developed in Microsoft Access 2000

Confidential, Houston, Texas

Independent Programmer

Responsibilities:

• Interfaced daily with legal assistants, attorneys, and other firm staff to gather user requirements
• Modified and enhanced a worker’s compensation claim management database developed in Microsoft Access 2000
• Modified and enhanced a personal injury claim management database developed in Microsoft Access 2000
• Developed Microsoft Outlook 2000 macros using Visual Basic for Applications to insert records into a Microsoft Access 2000 database
• Developed a Microsoft Visual Basic 6.0 application manage client sign-up information
• Developed a Microsoft Outlook 2000 add-in to using Visual Basic 6.0 to insert e-mails into a Microsoft Access 2000 database