TECHNICAL SKILLS:

PROGRAMMING LANGUAGES/DATABASES: Visual Studio 2013, SQL Server 2012,TFS 2013, Windows 7/8, IIS 7.0, Microsoft Office 2010,, SSIS 2012, SSRS 2012, VB.NET, C# .NET, ORACLE8i/9i, P/L SQL, SyBase 11, Crystal Reports 11, Install Shield, SQL Navigator, PLSQL Developer, adTempus,Telerik Web Controls

OPERATING SYSTEMS: Windows 7/8, Windows Server 2012, UNIX

PROFESSIONAL EXPERIENCE:

Senior Software Developer

Confidential, Houston, Texas

Responsibilities:

• Talisman Global Financial Tax Management System.
• The main purpose of this System is the timely filing of Corporate Tax Retruns and Payments in over 81 Countries where Confidential conducts its Businesses.
• This Intranet System extracts the data from One Source Oracle database to SQL Server Databases to support the activities of Tax Personell at the Head Office and the Regional Offices. Data stored in the SQL Server database is presented to the Users via an ASP.net front end and SSRS Reports.
• SQL Server Consolidation Project. The Production Database SQL Server 2005, Staging Server and Developmemt Servers SQL 2008 R2 databases were upgraded to SQL Server 2012. Tested over 200 SQL Server Jobs and Stored Procedures to verify the upgrade to the new Environment.
• Audit Controversy Project - Tax Returns are filed in all the Countries where the Business is conducted. Government Authorities conduct Audits of the Tax Returns and object when necesssary. These Audit Controversies are handled by the Legal and Tax Deparments. 900 Audit Controversies in over 70 Countries are tracked by the system. Made enhncements to the Web Site to import data from Excel Spreadsheets to SQL Tables.

Senior Software Developer

Confidential, Houston, Texas.

Responsibilities:

• Infinity Application Support and Development. Infinity is a very complex application developed by Ibix and licensed by HCC. It uses Windows Forms, Web Forms, and Web Services. The Users of this system are located in the USA, UK, and Spain. They access the Windows Forms Applications using a Citrix Server. Web based applications and SSRS reports are accessed using Intranet Portals. Over five exceptions are generated by the Error Logging application each week. These Error Logging incidents have to be investigated and resolved within three business days. Solutions for these issues are first resolved in the Development Environment. The code is then promoted to the UAT Environment and it is validated by the UAT Group. Once the code is validated in UAT, it is then promoted to the Production Environment on a weekly basis or on an escalated basis as needed. HCC is SOX complaint and all steps have to be meticulously documented for audit purposes. The Web Forms are developed in ASP.Net. The code behind the forms is VB.Net or C#.
• Infinity uses SSRS for End User and Management Reporting. It uses SSIS for data transformation between the new system and legacy AS400 systems. There are over five hundred SSRS reports and over four hundred SSIS package to support. New SSRS reports and SSIS packages are developed and deployed as needed. Batch jobs are executed using adTempus.
• HCC IT practices Agile Software Development with TFS as the foundation. Tag up meetings are held on a daily basis which keeps all the Developers on the Team in sync with each other.
• As the Senior Software Developer in charge of Change Management, processed over five Change Management Tickets (normal and escalated) per week. Coordinated the Changes between the Developers, the Database Group, and the Infrastructure Group. Parsed the Stored Procedures/Functions to verify that the code submitted by Developers did not have any syntax errors. Executed the code in the Development Environment to verify the changes in the Database. Also made sure that the Stored Procedures/Functions were checked into the TFS Source Control System. Created audit trails in TFS that the documented the data before and after the implementation of the changes.
• Investigated and resolved over 2 Production Support Calls per week. Modified Stored Procedures/Functions, SSIS packages, and SSRS Reports as needed and promoted them to UAT and Production through the CM Process. Used Microsoft Lync sessions to share the screens with End Users to resolve support calls.
• Participated in the 24/7 On Call Rotation program. Everyone in the IT group is required to take support calls one week per month on a rotating basis when the IT Support Center is not available after regular business hours and weekends (Monday through Sunday).
• New Product development - Once the weekly CM Process was completed, participated in development of new features using User Stories and Test Cases. Worked with the QA Group to facilitate the QA Testing Process.

Senior Programmer

Confidential, Houston, Texas

Responsibilities:

• Develop new .Net Web Form Applications. Add new functionality to .Net Windows Forms Applications. Replace ACCESS VBA and Excel VBA Applications with . Net Windows Forms and .Net Web Forms Applications. Implement ASP.Net Web Forms based Laboratory Information Management System (LIMS).
• Support 30+ Users at 6 locations. Maintain .Net Windows Forms Applications, ACCESS 2003/2007/2010 Applications, Excel 2003/2007/2010 VBA Applications, Crystal Reports, Active Reports and SQL Server Stored Procedures.
• GCWDA operates 5 Waste Water Treatment Plants (Bayport, Washburn Tunnel, Forty Acre, Blackhawk, and Odessa) that process the Waste Water from Industrial (Oil & Gas Refineries) and Municipal (City of Pasadena, City of Odessa) Customers. GCWDA also operates a Central Laboratory that accepts, tests, and reports the Water Samples taken from these Facilities. The IT systems at GCWDA operate on a 24/7 basis and they are a part of the Texas State Disaster Recovery System.
• Applications Developed and supported by the IT Department are
• Facilities Management System (FMS) and Laboratory Information Management System (LIMS). Vendor supplied systems are Laboratory Information Management System (LIMS), Eden Financial Accounting System and CAD Systems. These systems are deployed on Sixteen Windows 2008 Servers.
• LIMS .Net Web Forms Project
• GCWDA systems track pollutant levels when the water is received at the Facilities (Influents) and again when the treated water is released from the Facilities (Effluents). Tests are required to be performed, documented, and reported to the TCEQ and the EPA on a Monthly, Semiannual and Annual basis.
• Replaced 14 legacy ACCESS 2000 applications with .Net applications. There are over 30 ACCESS applications that have to be upgraded to .Net
• Designed and created lookup tables, data tables, and Stored Procedures to support the ASP .Net pages. Lab results can now be accessed via the Intranet on real time basis. Created data transfers between SQL Servers at the Central Lab and to the Facilities. Data is transferred on hourly basis using SQL Server Jobs and Stored Procedures.
• Facilities Management System Enhancement Project
• FMS uses Windows Forms frontend and a SQL Server 2008 backend. Used Visual Studio 2005/Visual Studio 2008 to Add/Modify over 15 new Crystal Reports, Active Reports, and Excel Export programs. Created and deployed set up packages as required. Collected User requirements and created appropriate Data Entry Screens and Reports.
• Completed the following Ten to Twelve week Projects.
• Water Treatment Permit Processing
• DMR reporting to TECQ
• Bank Card Upload Interface to EDEN Financial Accounting System
• Pretreatment Report
• .Net Application Email integration with Microsoft Outlook
• TCEQ Compliance Dashboard
• Compliance Coordinators and Plant Managers have to monitor Pollutants Levels on a daily basis. If the pollutant levels exceed the Minimum Detection Levels (MDL) immediate action is required to correct chemical levels.
• At the Central Office, the current system shows the Pollutant Levels one Treatment Plant at a time.
• The dashboard shows Pollutant Levels at all of the Facilities on a single screen. Data is gathered from Five SQL Severs. The output from the analysis is available as Crystal Reports and Excel spreadsheets for further analysis.
• Prospect Director Reengineering Project
• Prospect Director is a Windows based software package that manages the upstream exploration and development business process. This system collects and displays drilling activities and investment information using a Dashboard. Managers can then track the progress of activities associated with each Exploration Project.
• This product is originally developed using ASP.Net/SQL Server 2000 which uses out-of-the box Microsoft web controls and ASPX pages with user controls. Reengineering involves using the Master Page / Content page approach that would allow quick customization of the product. Out-of-the box controls are replaced by Component Arts Grid, Menu, Tabstrip, Dropdown Listbox, Text Box and TreeVeiw Controls. Telerik controls are used for Splitting the page and Data upload. Apose.Cells product is used for importing and exporting Microsoft Excel files.
• The development environment uses Visual Studio 2008, SQL Server 2008 client, SQL Server 2005 backend and Windows 2003 Server. Recoded over 20 ASPX pages in the new Master Page / Content page design. Added SQL Datasources and the supporting Insert, Select, and Update SQL Statements. Used Microsoft Range, Compare, and Regular Expression Validation Controls to validate the data in the Text Boxes.
• Unit tested each page and then performed integration test with the main product.

Contract Software Developer

Confidential, Houston, Texas

Responsibilities:

• Personnel Resiliency Database Project
• N-Tier Intranet Application developed using ASP.Net 2.0, Vb.Net 2.0, ADO.Net 2.0, TSQL, SQL Server 2005, IIS 6.0, and Windows Server 2003.
• The website consists of 15 ASP.Net Forms supported by 51 Stored Procedures on SQL Server 2005.
• About 1500 users enter their information into the system points of contacts are using reports based on this information. Coordinators run reports for relocation, emergency response, etc. Support functions such as Travel, and reports that are required for their emergency response.
• Gridview control was used to simulate legacy Excel spread sheet based information. The system consolidated over 50 spreadsheets into a centralized intranet based access with Excel look and feel. Prepared and executed test plans for development and acceptance testing.
• PRDB was successfully used for the first time during 2008 Hurricane season. A second phase is now planned to expand the system to provide additional functionality.
• GETS (Government Emergency Telecommunication System) Cards Project
• Critical Personnel are issued GETS Cards for priority access the Telecommunications Systems and Cell Phone Network during Emergencies. This User information has to be kept current with the U. S. Government at all times.
• A Centralized Gridview/ASP .Net/ADO .Net/SQL Server 2005 based interface was developed to replace the distributed Excel spreadsheet system. This part of the system will also be updated in the second phase of PRDB.

Confidential, Houston, Texas

Responsibilities:

• KM Pipeline Billing Systems are grouped as Front Office, Middle Office, and Back Office. The Front Office group is responsible for Contracts Administration and Tariff Rates. The Middle Office group is responsible for the collection of Pipeline Operational Data. The Back Office is responsible for the calculation of Billing Amounts and Invoicing the Customers who use the Pipelines and Storage facilities. The Back Office Systems use the operational data provided by the Middle Office against the Contracts and Tariff Rates setup by the Front Office to calculate the charges to the Customers.
• Expansion of the Pipeline to the west of the Rockies required a enhancements to all of these systems to accommodate new Customers and Federally regulated transportation and storage charges.
• Presentation layer consists of ASP.Net and the Data Store is Sybase. The Sybase processes run 24x7 to provide real time information to internal and external Customers.
• The entire system will be converted to SQL Sever 2005 over the next three years.
• Worked on two Projects - Rockies Express Pipeline Billing and Invoicing enhancements Project and Sybase to SQL Server 2005 conversion Project . In the first Project, made enhancements to over 15 stored procedures and created 2 new stored procedures. Performed Unit Tests. In the second Project, migrated over 20 stored procedures from Sybase to SQL Server 2005

Confidential, Houston, Texas

Responsibilities:

• Application Development - Network Servers Inventory Management system. Collect and manage technical information on over 60 Servers located at more than 50 locations around the world. Developed the system using ASP.Net/VB.Net/ADO.Net/SQL Server 2000. Master Pages, User Controls, Custom Controls, AJAX extended Controls, GridView Control, and Microsoft Data Access Blocks.
• Tested and debugged applications on VMWare virtual servers to be used for development and acceptance testing. Tested and debugged Human Resources Inspector Certification and Federal Regulations Compliance Course Management System. The application tracks and schedules the courses required to be taken by the Inspectors. Performed support activities on Legacy applications which used VB6, COM+, and ASP.

Contract Software Developer

Confidential, Houston, Texas

Responsibilities:

• The Project consists of re-engineering an ACCESS/SQL Server 2000 application to a .NET / SQL Server 2000 application (12,000+ Development Hours) (Windows Forms, C#1.1/Visual Studio 2003/SQL Server 2000). A web service generates over 60 Crystal Reports in the PDF format. The requests are submitted to the web service via a Web Form front end. The main application has over 50 screens to Add, Update, and Delete Technical Datasheets. It uses a UI layer (Infragistics - Text Box, Combo Box, Grid, Expandable Grid, and Tab Controls), a Business Objects Layer, and a Data Access Layer (Microsoft Data Access Blocks). Over 200 T-SQL stored procedures were developed to replace the queries and procedures from ACCESS).

Contract Software Developer

Confidential, Houston, Texas

Responsibilities:

• Tested, debugged, and completed an intra-net (ASP.NET 1.1 /C# 1.1/SQL Server 2000/Visual Studio 2003) application which tracks World-wide Airport/Ticketing/Currency information. Performed unit test and modifications on 3 complex ASP .NET screens to verify changes made to the base tables. Updated stored procedures.
• Developed, tested, and completed an Email Component (C# 2.0 /Visual Studio 2005) which handles Email via the SMTP Server. The component was developed using the new System.NET.Mail name space to take advantages of the improved object model in 2.0. The component handled Text, HTML, and Multipart emails. The email content was captured in XMLDocument object from which XML strings were generated.
• Attachments to email were stored in a Collection and sent with the email. Implemented Exception Handling using the best practices methodology required by IT department to provide consistent error tracking among all applications. Developed a Testing Program using both Windows Forms (C# 2.0) and Web Forms (C# 2.0) to generate and send email.
• Developed and Tested a Gift tracking component using (C# 2.0/ADO .NET 2.0/Visual Studio 2005) which stored and manipulated information stored in an XMLDocument object. The information from this XML Documents was then used to update tables in the SQL Server Database and send email to the Buyer and Recipient of the Gift. The component accepted input from programs or from XML files.

Contract Software Developer

Confidential, Houston, Texas

Responsibilities:

• Senior Team member of a Software Team that developed a Post Funding Mortgage Processing Application using .NET. This project has six Team members and delivered software consisting of over 30,000+ billable hours in three phases over a period of 2.5 years. It is being used by over 300 end-users in 3 Regional Loan Processing Centers. Front-end - IE 6 Middle Tier- ASP .NET/ADO.NET/VB..NET and Backend - Oracle 9i. Created and deployed over 50 Crystal Reports using the Crystal Reports which use ADO .NET in a disconnected mode. The Oracle Database has over 50 million records. Each team member participated in creating Specifications, Test Plans, Coding, Testing, Implementation, and End User support until the Release was taken over the Software and DBA support group at Confidential . .
• Developed Oracle 9i PL/SQL stored procedures and views in PL/SQL using PLSQL Developer. Fine-tuned to the performance of queries by adding indexes and using the Explain Plan. Created materialized views to store and analyze historical data.
• ColorTrax Vertical Market Software Re-engineering Project.
• Re-engineered two versions of the ColorTrax Product. Upgraded the Rich Client VB6/ADO/Oracle 8i application to .NET Rich Client version consisting of Windows Forms/ADO .NET and an Oracle 9i or SQL Server back-end.
• Upgraded the Thin Client ASP/ADO to a Thin Client .NET application. The thin Client application is a MS Explorer 6 front-end with a Web Forms ASP.NET/ADO.NET/C# .NET middle tier and an Oracle 9i or SQL Server back-end.

Senior Contract Developer

Confidential, Houston, Texas

Responsibilities:

• Developed, tested, implemented, and supported an Intra-net application to process monthly volume sales incentive program to be used by Marketing Reps in the Regional Offices. This program used an IE5 front-end (HTML, Java Script), IIS middle tier (ASP/ ADO), and Oracle 8i back-end (Stored Procedures). Incentive program parameters were stored as a SQL text in the Oracle tables. Stored procedures obtained the monthly fuel sales volumes from the SAP-SIMON data warehouse and processed the incentive amounts. Dynamic SQL is used process the SQL text statements in PL/SQL procedures. Complex formulas were used in the financial calculations. Marketing Reps reviewed incentives. Approved incentives were sent in the form of Credit Memos to the SAP Accounts Receivable module.
• Developed, tested, implemented, and supported an Internet data entry system for 1600+ Wholesalers. This program used an IE5 front-end (HTML, Java Script), IIS middle tier (ASP, SQL, ADO), and Oracle 8i/SQL Server back-end (Stored Procedures/Triggers). Stored Procedures calculated End of Month rebates for Open Dealers using the fuel sales data from the SAP-SIMON data warehouse. Contract Administrators reviewed the rebates, made any manual entries, and sent the data to SAP for payment.
• Enhanced, tested, and supported an Enterprise-wide Visual Basic/Oracle Client Server/Telephony/Web system. In 1998, this system was a 16bit VB Client Server system with 3 Users, 2 Developers, and processed rebates of $2 million per month. The rebates were sent to SAP using FTP. In 1999, added Lucent Technology Inter-active Voice Response telephone data entry interfaces and upgraded the software to 32 bit VB. Added Contract generation and printing capabilities. By the end of 1999, this system had 15 Users, 4 Developers and it processed rebates of $5 million per month. Performed Y2K tests and monitored the system roll-over to 2000. In 2000, added Web data entry interfaces. Provided Enterprise data access via the Citrix Server. By the end of 2000, the system had 27 Users, 5 Developers and it processed over $12 million per month. In 2001, six new types of Contracts were added and the VB code was modified to include Object Oriented Programming Techniques. Programming duties included VB coding, writing Oracle Stored Procedures, Optimizing SQL Queries, and using MS-ACCESS VBA code / Crystal Reports to provide Management Reports, and testing new code.
• Developed and implemented a Tool using MS-ACCESS. The tool allowed the support personnel to trouble-shoot rebate payments inquiries, reconcile SAP Bank transactions with Contract data in the Production Database. Provided monthly, quarterly, and annual rebate payment data via EXCEL Spread Sheets.

Senior Contract Developer

Confidential

Responsibilities:

• Non-programming duties included Internal (50+ Users) and External Customer Support (1600+Users), trouble shooting rebate payment problems, gathering User requirements, developing specifications and estimates for software enhancements, making presentations to Management, Preparing Disaster Recovery Plans, Server Migration Testing, Organizing the Developer Group, interviewing and training new Developers.

Contract Developer

Confidential, Houston, Texas

Responsibilities:

• This application utilized a VB5 front-end and a Sybase 11 back-end. It program allowed the Customer Service Representatives to inquire Account Information and enter Customer’s requests for Mutual Fund Transfers, Fund Performance Reports, and Retirement Investment Allocations. Sheridan Designer Widgets, RDO, VsFlexGrid, Rich Text Box, and FileNet controls were utilized. Used SQL to extract information from Sybase Tables. Coded, Tested, and Implemented Stored Procedures using T-SQL.
• Sales Automation System - VB3 to VB5 upgrade and Year 2000 compliance Project
• Converted over 15 Applications from VB3 to VB5. This project encompassed programs on Laptop Computers, Desktop Computers at the Regional Offices, and Programs at the Home Office. A variety of controls such as Sheridan Designer and Data Widgets, True Grid, ChartFX, ImageFX, VsElastic, Penop, WinTab and FileNet were used in these programs. All of these controls, the associated events and methods, and WINDOWS API’s had to be converted from 16 bit to 32 bit.. The applications performed advanced operations such as Signature Capture, Uploading and Down-loading data from the Main Frame Computer, and filing documents into the FileNet Document Imaging System. Used SQL to Add, Update, and Delete records in MS-ACCESS databases.

Contract Developer

Confidential, Houston, Texas

Responsibilities:

• Converted a Nuclear Power Plant Inspection Planning System from VB3 to VB4 16/32 bit. The application originally ran only on Window 3.11 systems. Enhanced, tested, and implemented the software on Window 95 and Windows NT bases systems. Upgraded the Crystal Reports from Version 4.0 to Version 5.0. Utilized SQL extensively to Insert, Select, Update, and Delete records in MS-ACCESS databases. Wrote complex Select SQL Statements to feed data into management and NRC compliance reports generated by the system. Prepared setup files using Installshield.