SUMMARY:

Specialization in full software development life cycle (SDLC) application and database development with particular emphasis on data - driven interfaces and associated metrics reporting, ETL including data analysis, automated data migration, conversion, cleansing, mapping.

TECHNICAL SKILLS:

Languages and Technologies:  .Net Framework 4.5, / ASP.Net Web forms with MVC, C#.Net and VB.Net Windows Forms and Web Forms, ADO.Net, HTML, CSS, SQL Server, Telerik and AJAX Developer tools, Visual Studio, ASP Classic, SQL Server Management Studio (SSMS), SQL Server Report Design and Reporting Server (SSRS), SQL Server Integration Confidential (SSIS), TOAD, ADO, DAO, OLE, ODBC, SQL Developer/Navigator/Plus, Crystal Reports, Visual Basic for Applications (VBA), Microsoft Office Suite, Visual Source Safe (VSS), Team Foundation Server (TFS), Visual Studio Team Confidential (VSTS)

Databases: SQL Server (T-SQL), Microsoft Access, BTrieve, Pervasive, Oracle 9i/10g/11 (PL/SQL)

PROFESSIONAL EXPERIENCE:

Application Developer

Confidential, Houston, Texas

Responsibilities:

• Designed VB.net windows forms, ASP.Net web forms, master pages, user controls, classes, reports, and stylesheets using C#.Net with Telerik and AJAX controls, HTML, CSS, Microsoft Reporting, and Team Foundation Server (TFS) for turnaround management web application and windows forms mapping application
• Created and modified classes and methods in C#.Net and VB.Net to automate web based data and image upload and download to SQL Server database using ADO.Net to execute SQL Server stored procedures
• Developed and modified SQL Server 2012 stored procedures, tables, and views for use in web application.
• Built and deployed C# console application for daily scheduled server data transfers to external devices Database Manager, Programmer / Analyst at NASA in Houston, Texas 9/15 - 10/16
• Configuration management, database design, normalization, security, development and maintenance of Environmental Office Interface Application
• Developed Training module: designed relational database, created custom Microsoft Office fluent ribbon displaying buttons and groups based on user security levels, implemented database object security for users based on roles, authored functions and procedures, created queries, forms and reports
• Confidential and supported handheld scanner integration, performed device troubleshooting and SOP’s.
• Implemented Configuration Management documentation for database issues to provide for multiple developer access and integration, issue and problem resolution, and creation of supporting file structures.
• Provided IT Applications support on NASA contract including analysis, development, testing, and documentation of IBIS tool and its T-SQL tables, queries, procedures, as well as the VBA code, queries, forms, and structure.
• Performed end to end testing, complete code review, documented issues, and recommended solutions. Programmer / Analyst in Houston, Texas 8/13 - 7/15
• Energy Consultant for ExxonMobil, NRG, Nalco, Deerborne Energy, Air Liquide, and Sunnova
• Created automated accounting reports from SalesForce data using SQL Server and VBA to output to Excel
• Scoped mapping protocols using SQL Server Management Studio (SSMS), designed SQL Server Integration Confidential (SSIS) fuzzy lookups, queries and procedures for multiple source consolidation
• Built and tested Access applications, PL/SQL queries, procedures and packages, data mappings, and wrote user instructions to validate SAP HR/Payroll data against original data; completed two months ahead of schedule
• Configured data mappings in Access front-end to automatically convert and batch process SAP data to Oracle in Excel format to Word documents of manufacturing instructions uploaded to SharePoint and SAP systems
• Designed, enhanced, and modified Access applications for well and field volumes data using SQL queries and procedures via VBA with output to Word and Excel for periodic reconciliation of accounting and financial data

Contract Programmer / Analyst

Confidential, Houston, Texas

• Confidential applications, batch Confidential, PL/SQL queries, procedures and packages using Toad for well and field volumes data accounting including ad-hoc reporting in Spotfire, Excel, Oracle, and VBA with output to HTML
• Performed quality control and user acceptance testing, produced and Confidential application documentation and user help guides, published release notes and implemented releases with version control.
• Created an Access application to automate manufacturing instructions and periodic reconciliation reports in VBA and SQL Server with output to Excel, via ODBC connections to Oracle and ADO connections to SQL Server
• Confidential and enhanced SQL server databases including user, schema, and permission maintenance; normalized data, enforced referential integrity, implemented backups, administered patches and upgrades.
• Supported IQMS as Oracle/Crystal Reports technical liaison; created and modified Crystal Reports for inventory, accounting, and customer service; authored user guides, release notes, and application documentation

Contract Senior Developer / Analyst

Confidential Houston, Texas

• Modified and enhanced Access applications for investor accounting and cash management systems utilizing VBA via ADO and ODBC connections to Access and Oracle databases and via PL/SQL in Toad/SQL Navigator/Plus
• Created test plans for user acceptance and quality control testing, performed debugging, authored release notes and business documentation for applications, and implemented release of applications.
• Created VB.net COM add-in DLL for enterprise wide deployment for Word 2003 forms, that included modules, and toolbar to automate removal of whitespace from specific documents
• Modified and enhanced Excel and Access applications and reports for acquisition and asset management, accounting, and project estimates written in VBA using ADO, with output to Access, Excel, and Word
• Normalized Access data, restructured tables in purchasing system by categorizing products to replace multiple forms and reports with single data - driven form and report written in VBA, output to Word and Excel
• Analyzed requirements, met with users and management to facilitate design, and implement products; provided applications support and troubleshooting, user training, and managed software licensing
• Authored scope documents, functional and technical specifications, test plans, and application release notes, as well as training documents and user help documentation written HTML using CSS.
• Enhanced Access and Excel reports and Access applications scheduling, project, construction cost, and turn around management using VBA via DAO, ADO, and ODBC connections to Access and SQL Server databases
• Performed data migration and automated conversions that included data verification and error handling for Excel, Access, and SQL Server data utilizing custom SQL, VB.Net, VBA, and VBScript, from text files and Excel data

Consultant - Programmer / Analyst

Confidential Houston

• Confidential of Access application and reports for sporting management written in VBA with ADO connections that produced dynamic output of metrics in Excel
• Developed Access applications and reports to support engineering and project management, materials management, and departmental metrics using SAP data imported to Access and SQL server databases via VBA
• Automated conversion and migrated SAP data to SQL Server and Access using VBA with DAO, ADO, and ODBC connections for dynamic output to Excel for pivot tables that refresh data on demand
• Authored HTML user help and work instructions to support data migration automation, functional and conversion processes

Contract - Lead Application Developer / Analyst

Confidential, Houston, Texas

• Consolidated multiple financial applications to a single Access application via ODBC, OLE, DAO, and SQL Server connections to improve maintenance and increase user performance and satisfaction
• Created and Confidential Access and VB applications and reports written in VB and VBA with OLE, ODBC, and DAO output to Microframe Project Manager (MPM), Project, Word, Excel, Crystal Reports, and HTML
• Created and Confidential Access applications for Earned Value Method Systems (EVMS) cost accounting, contract acquisition estimates, budgets, reconciliations, project schedules, procurement, and logistics, quality assurance and control, six sigma, software licensing, human resources, facilities, configuration and engineering management
• Created periodic reports in Access for contract deliverable 533, SF294 and SF295 reports, and HUB zone reports
• Automated routine data conversion and transfers using Access between MPM, FMS, Deltek, and SAP, and automated data transfers between SQL Server, Oracle systems, Access, and Excel
• Created VBA add-in from C extension to automate creation and maintenance of ODBC connections to MPM
• Software deployment and testing using SMS for MPM, Oracle, SQL Server and Microsoft Office Suite installation and upgrades; performed troubleshooting and resolved problems; documentation and user training.
• Led team of financial users and developers to analyze requirements for upgrade of Deltek to SAP and PeopleSoft systems; coordinated test and deployment efforts and achieved results timely and under budget
• Participated on team to author scope documents, met with users and management to facilitate implementation of software; created test plans, certified deployment, and trained end users in applications and upgrades