TECHNICAL SKILLS:

PROGRAMMING LANGUAGES/DATABASES: Visual Studio Community Edition 2015, Visual Studio 2013, SQL Server 2014, T - SQL,PL/SQL,TFS 2013, Windows 7/8/10, IIS 7.0, Microsoft Office 2010, Excel VBA, SSIS 2012, SSRS 2012, VB.NET, VB6, C# .NET, LINQ, ASP.Net MVC5, Javascript, CSS3, HTML5, Jquery Entity Framework, Bootstrap js,Knockout js,Angular js,WCF, Web API, WPF, MVVM, ORACLE 8i/9i/10g/11g, P/L SQL, SyBase 11, Crystal Reports 11, Install Shield, SQL Navigator, SQL Developer, SQL Profiler, adTempus, Telerik Web Controls, QSI LIMS

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

PROFESSIONAL EXPERIENCE:

Senior Dot Net Software Developer

Confidential, Houston, Texas

Responsibilities:

• Re-engineered Web Forms ASP/ADO/SQL Server Application to a Web Forms ASP.NET/C# ADO.NET Entity Framework middle tier and a SQL Server back-end Application.
• Used Javascript to pass data between Forms and Form validation.
• Created label generation, scan to locations, scan to box, check out/in from active file rooms, archive center management, and retention management forms.
• Users can query loans (active or archived) and submit requests for actual files or on demand imaging. Available images can be viewed.
• Mortgage Loan Processing Document Tracking- Collateral and service (credit) files and their associated documents, can be received “in” and tracked throughout their servicing life. This can include tracking of these items to and from the custodian, investors and servicing. Correct location and a history of where these items have traveled will always be at your finger tips.
• Document attributes, such as recorded, re-recorded, original, or copy can also be tracked for each key document. Users can also easily identify missing documents and create document exceptions.
• File tracking - OPUShas all the traditional records tracking capabilities of the OPUS RIM system. This includes bar code label generation, scan to locations, scan to box, check out/in from active file rooms, archive center management, and retention management. Users can query loans (active or archived) and submit requests for actual files or on demand imaging. Available images can be viewed.

Senior Dot Net Software Developer

Confidential, Houston, Texas

Responsibilities:

• This N-Tier Intranet System extracts the data from One Source Oracle database to SQL Server Databases using SSIS jobs.
• Created, Tested, and Deployed SSIS Electronic Data Transformation Packages.
• Imported data from Oracle Database tables and Excel spreadsheets into SQL Server 2012 Database.
• Performed Front-end Development using ASP.Net MVC 5, C#, HTML, CSS, JavaScript and Telerik Rad Controls.
• Telerik RAD Grid Control and Telerik RAD Drop-down list controls are used throughout the application to display, edit, and add information to the SQL Server Database using TSQL stored Procedures.
• Developed, Tested and Deployed SSRS Financial Income and Expense Reports .
• SQL Server Upgrade and Consolidation Project. The Production Database SQL Server 2005, Staging Server SQL 2008 R2 and Development Servers SQL 2008 R2 databases were upgraded to SQL Server 2012. Tested over 200 SQL Server SSIS 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 necessary. These Audit Controversies are handled by the Legal and Tax Departments. 900 Audit Controversies in over 70 Countries are tracked by the system. Made enhancements to the Web Site to import data from Excel Spreadsheets to SQL Tables.
• Upgraded ASP.Net to MVC5/Entity Framework. Upgraded ASP.Net Web Services to WCF.

Senior Dot Net Software Developer

Confidential, Houston, Texas

Responsibilities:

• Infinity Application Support and Development. Infinity is a very complex application developed by Ibix and licensed by Confidential .
• 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. Confidential is SOX complaint and all steps have to be meticulously documented for audit purposes.
• The Web Forms are developed in ASP.Net, HTML, CSS, JavaScript. The code behind the forms is 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.
• Confidential 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).
• 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 Dot Net Programmer

Confidential, Houston, Texas

Responsibilities:

• Develop new Web Form Applications using ASP.Net, HTML, CSS, JavaScript. Add new functionality to .Net Windows Forms Applications. Replace ACCESS VBA and Excel VBA Applications with Net Windows Forms, WPF, and .Net Web Forms Applications. Implement ASP.Net Web Forms based Laboratory Information Management System (LIMS - Quality Systems International).
• Support 30+ Users at 6 locations. Maintain .Net Windows Forms Applications using C#, 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.
• 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 a hourly basis using SQL Server Jobs and Stored Procedures.
• 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 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 Dot Net Software Developer

Confidential, Houston, Texas

Responsibilities:

• N-Tier Intranet Application developed using ASP.Net 2.0, C#, 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, 200-250 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.
• 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
• 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/C#/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.

Dot Net 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).

Dot Net Software Developer

Confidential, Houston, Texas

Responsibilities:

• Tested, debugged, and completed an intranet (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.

Dot Net Software Developer

Confidential, Houston, Texas

Responsibilities:

• These products are available as .NET versions and Non .NET versions. The Non .NET versions use Rich Client (Visual Basic 6.0/ADO) or Thin Client (ASP/ADO) with SQL Server 2000 or Oracle (8i/9i) Databases.
• The .NET versions use Rich Client (Windows Forms/ADO.NET/VB.NET) or Thin Client (Web Forms/ADO.NET/VB.NET) with SQL Server 2000 or Oracle 9i Databases. All versions use Crystal Reports 9. Some of the Clients using this software include Washington Mutual, Dell, Wells Fargo, Boeing, U. S. Library of Congress and the U. S. Customs Department.
• 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/C# 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 Washington Mutual.
• 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.