Navkant Thakur

Software/Report Designer/Developer (Contract) - Transocean Offshore Inc

Houston, TX 77077

ad089u@r.postjobfree.com

+1-713-***-****

APPLICATION/WEB/SOFTWARE/REPORTS DESIGNER/DEVELOPER position through which my professional experience and technical education can be utilized to the benefit of a progressive organization. Authorized to work in the US for any employer

Work Experience

Software/Report Designer/Developer (Contract)

TransCanada Pipelines - Houston, TX

October 2015 to April 2016

NAESB 3.0/FERC 809 Gas day modification

As per the new rules, introduced by NAESB and FERC (NAESB 3.0 and FERC 809), I helped TransCanada introduce and implement new rules to their in-house software(CNSS and CA), website, reports, and database, designed specific for two of their clients (Northern Border Pipeline and Bison Pipeline). I helped TransCanada by modifying some specific parts of the software, including Enter Nominations, Nominations Download, Nominations Details, Batch Reports, Nomination Reconciliation Report and Cycle Close. I also helped modifying their Oracle Reports and Powerbuilder Reports, stored procedures and functions in database.

I used Powerbuilder 12.6, including data-windows, as frontend and reports generation, Oracle Reports and Oracle 10g as backend for the in-house software. I also used Visual Studio 2008 (ASP.NET) and SCADA (PLC), connected through secure ODBC connection, to pull volume and points information been released or delivered from one RTU to another and displayed the information on info-posting website view by the clients'.

Responsible for:

● Coding, maintenance and troubleshooting and Manual testing different modules designed in Powerbuilder 12.6, Visual Studio 2008

● Integration of the code from other team associates

● Development of documentation

Environment: Visual Studio 2008, ASP.NET, Powerbuilder 12.6, Oracle 10g, SQL, PL-SQL, Oracle Reports, SCADA, ODBC.

PC Technician and Desktop Support

DIRECTRON.COM - Houston, TX

January 2015 to September 2015

Worked at Directron.com's wholesale division as PC Technician and Desktop Support assembling desktops and imaging the operating systems over the network. Been on vacation to India December 2013 - October 2014 Software/Report Designer/Developer (Contract)

Lloyd's Register - Houston, TX

November 2012 to November 2013

Lloyd's Register Technical Services

I joined Lloyd's Register as a software developer to help Lloyd's to modify/repair and fine-tune queries in MS Access based tool that LR uses to transfer client's data that they receive in MS Excel workbook from the client. MS Access is linked to clients' database through ODBC and run some data validation queries and finally exported to client's (Oracle/SQL Server) production database. I helped Lloyd's Register design and develop a custom inspection report (which is a government document) for one of their clients using SSRS (Report Builder 2.0/3.0) against client's SQL Server database. I created a Stored Procedure, and number of Views that were called by the Stored Procedure called by the Report passing required parameters. I also helped Lloyd's deploy the report to the Report Server.

I also created a tool for Lloyd's Register using MS Excel (VBA for Excel) to pull specific data from an existing Oracle database of a new client and dumped the data in the required format in various MS Excel worksheets categorized per requirement.

I created another tool for Lloyds using VB.NET which helps Lloyd's connect to any Oracle database they need to, scan database for tables that have BLOB column/s. and extract all the contents of BLOB columns, zip all the extracted files and store the zipped file to the specified path by the user. Responsible for:

● Coding, maintenance and troubleshooting and Manual testing different modules designed in Visual Studio 2008 including VB.NET

● Integration of the code from other team associates

● Development of documentation

Environment: MS Access 2003/2010, Excel 2010, SQL Server 2005/2008, Oracle 10g, SSRS (Report Builder 20./3.0), T-SQL, VBA for Excel 2010, VB.NET 2010. Web Developer (Contract)

MercerHR - Houston, TX

July 2011 to December 2012

MercerHR Services

As a Web Developer, at MercerHR Services, I helped Mercer configure and maintain their clients' (HONDA, PANASONIC, ARBY'S and HBFULLER) Human Resources web sites using C# and ASP.NET in Visual Studio 2008 and IIS7. Last year, I helped Mercer in upgrading their Oracle Database from 9i to 10g and this year helped configure their web sites in the database. I used TOAD 10 to access, update and modify web sites' respective schemas in Oracle 10g. . I used XML Spy 5 to customize all the web sites' related XML/XSL files and published them to development server, test server, CSO server and finally to the production server. Responsible for:

● Coding, maintenance and troubleshooting and Manual testing different modules designed in Visual Studio 8 including ASP.NET, VB.NET and C#.NET

● Integration of the code from other team associates

● Development of documentation

Environment: Visual Basic 6, Visual InterDev 6, Oracle 10g, VB.NET, ASP.NET, ADO.NET, C#.NET, XML, Javascript, HTML, CSS, VSS, IIS 7, XMLSpy, TOAD 10, Borland Starteam, HTML Help Tester at Microsoft

Seminars at Microsoft

January 2012 to November 2012

At Microsoft, I gained great experience in the pre-release technologies (e.g. Visual Studio 2010/2012/2013, MS Office 2010/2012/2013, MS Azure, SQL Server, etc ). I have also been testing Microsoft technologies, including Windows 7, MS Visual Studio 2010/2012/2013, MS Office 2010/2012/2013, and Windows 8.

Web/Report/Software Developer (Contract)

The Aldridge Company - Houston, TX

March 2011 to July 2011

ADCI/Tristar Freights

The Aldridge Company provides IT Services to the companies that don't have their own IT Dept. the IT services they provide, include Website designing, developing and troubleshooting, hardware and network services and troubleshooting and hosting websites. I helped Aldridge to troubleshoot and solve existing issues with ADCI's website which is primarily designed using PHP and Access as their backend.

I am taking care of website and web app for Tristar Freights which is designed in ASP.NET using Visual Studio 2005 and SQL Server 2005. I have also helped Tristar edit and modify their existing reports that are generated using Crystal Reports 11.

Responsible for:

● Coding, maintenance and troubleshooting and Manual testing different modules designed in Visual Studio 2005 including ASP.NET

● Learned and implemented PHP solution to clients website

● Development of documentation for the clients

Environment: ASP.NET, SQL Server 2005, Crystal Reports 11, PHP, Access 2007. Web Developer (Contract)

MercerHR - Houston, TX

July 2010 to December 2010

MercerHR Services

I started contract with my previous client, MercerHR Services, as a Web Developer, to help them develop and maintain Human Resources Web Sites for four out of their numerous clients for 2011 Open Enrollment process. This year I was given responsibility of five clients (AldineISD, KatyISD, Arkema, HBFuller and Chevron-Phillips). The first three clients' Human Resources web site is designed in classic ASP and HBFuller and Chevron-Phillips Human Resources web site is designed in C# and ASP.Net. Mercer, this year upgraded their database to Oracle 10g and I accessed, modified and updated the database using TOAD 10. I used XML Spy 5 to customize all the web sites' related XML/XSL files and published them to development server, test server, staging server and finally to the production server. Working with Mercer for two years helped me understand, experience, and implement the waterfall methodology. I used Visual Interdev 6 to customize web sites designed in classic ASP and Visual Studio 2005. Responsible for:

● Coding, maintenance and troubleshooting and Manual testing different modules designed in Visual InterDev 6 with classic ASP and Visual Studio 2003/2005 including ASP.NET, VB.NET and C#.NET

● Integration of the code from other team associates

● Development of documentation

Environment: Visual Basic 6, Visual InterDev 6, Oracle 9i, VB.NET, ASP.NET, ADO.NET, C#.NET, XML, classic ASP, HTML, CSS, VSS, IIS, XMLSpy, TOAD 7.0, Borland Starteam. Scada/Cygnet/VBA for Excel, Access/Report/C#/VB.NET Developer (Contract) Spectra Energy - Houston, TX

December 2008 to July 2009

AGT/MNP

Spectra Energy lays, controls and maintains Oil and Gas pipeline from Gulf of Mexico to East Canada and East Canada to West Canada. I am part of team of 25 programmer and developers creating and maintaining system software to control and maintain the entire Oil and Gas pipeline. I designed the graphical interface for number of Meters and RTUs for a part of the pipeline (AGT) and the entire pipeline

(MN&P) using a third party proprietary software for Oil and Gas pipelines called Cygnet. The entire pipeline data communication is transferred from point "A" to Point "B" using SCADA. I was also responsible to code and maintain real-time reports pulling information from SCADA system, connecting using the ODBC through Cygnet in Excel using VBA for Excel and getting information not only to Excel but also storing information in Access. I created and coded for the tools to download and upload (Meters and RTUs) points to and from the monitoring center to Meter and vise-versa, using VB.Net and C#.NET. I also enhanced the functionalities for the existing tools, systems and reports for better and faster execution. I also maintained issue database and re-routed issues to the responsible teams (Database, Graphics, etc.) to be taken care of while testing the screens online.

Responsible for:

● Coding, maintenance and troubleshooting and Manual testing different modules designed and Developed VB.NET and C#.NET

● Coded using VBA for Excel and VBA for Access to create real-time reports in Excel connecting to Cygnet through ODBC connection.

● Integration of the code from other team associates

● Development of documentation

Environment: VBA for Excel, VBA for Access, VB.NET, C#.NET, SQL for Access, SCADA, Cygnet, VBA, XML. Web Developer (Contract)

MercerHR - Houston, TX

July 2008 to December 2008

MercerHR Services

Mercer Human Resource, create, host and maintain Human Resources websites and web services, and client-server applications for numerous companies all around the World. I am using Visual InterDev 6

(classic ASP) as front end and Oracle 9i as back end for the web sites development. Mercer is making transition to .NET where all the web services and client Web Sites are developed using C#.NET. While web sites are designed and developed using VB.NET and ASP.NET. ADO.NET is being used to communicate between front end and back end. I am part of a team of 15 developers and use Visual InterDev (for classic ASP), TOAD 7.0 to view the Oracle 9i database/schemas/tables. I get a CR (Change Request) from my Client Team and I check-out CR related files (which includes either classic ASP files or .NET files, XML files or the .js files etc.) from Visual Source Safe make changes to the base code or the data in the database, test them and check-in the files and post the files to Web Farm and push the updated code or tables to the production web site. I update the CR on Borland Starteam and let the Client Team know about the changes and close the CR. Responsible for:

● Coding, maintenance and troubleshooting and Manual testing different modules designed in Visual InterDev 6 with classic ASP and Visual Studio 2003/2005 including ASP.NET, VB.NET and C#.NET

● Integration of the code from other team associates

● Development of documentation

Environment: Visual Basic 6, Visual InterDev 6, Oracle 9i, VB.NET, ASP.NET, ADO.NET, C#.NET, XML, classic ASP, HTML, CSS, VSS, IIS, XMLSpy, TOAD 7.0, Borland Starteam. Web / Software Developer (Contract)

Shell Oil/Trading - Houston, TX

September 2007 to January 2008

RMPQ

One of the official websites of Shell calculates and displays prices and quotes of all the petroleum products that Shell, has to offer. This website allows and helps the Risk Managers to give customers prices and quotes depending on current prices from NYMEX (New York Mercantile Exchange) and maintain the related tables in the Database. The web site uses classic ASP as the front-end and Oracle 9i as the back- end. Shell is shutting down this website, but, there are some tools that Shells Risk Managers still use. I am designing, developing and coding a client-server application, replicating the tools and functionalities of the website that the Risk Managers require. I used Visual Basic 6 as the front-end and an existing Oracle Database as the back-end. This new application will be used by all the Risk Managers as and when Shell decommissions the website. This application saves entire screen data figures in three different places, in an Excel file, in Oracle database, SQL Server 2003 and a local MS Access database. I created and updated all the Stored Procedures in SQL Server and Oracle databases to incorporate enhancement in the application. I used VBA for Excel to transfer data from the application to Excel spreadsheet. I also learnt and code with WDDX and WDDX related functions, methods variables and constants, to connect this client-server application to NYMEX server to pull the real-time product prices. Responsible for:

● Designing, Developing, Coding, maintenance and troubleshooting and Manual testing different types of Modules including their COM/DCOM

● Created and Updated Stored Procedures in Databases

● Integration of the code from other team associates

● Development of documentation

● Kept in constant touch with the Risk Managers and the web site maintenance team to have a better understanding of the functionality, control flow and formulas.

● Learnt and implemented Shells Power Business and Trading procedures in order to incorporate SOX rules and regulations to Trade and Exchange.

Environment: Visual Basic 6, VBA for Excel, VBA for Outlook/Outlook Express, classic ASP and ODBC, Oracle 9i, FrontPage 2000, Visual InterDev 6, WDDX. Software Developer (Contract)

CounterforceUSA - Houston, TX

May 2007 to September 2007

AIMS (A-Link Information Management System)

AIMS is an in-house, accounting application (compare to MS Great Plains) developed for Counterforce USA, alarm, security and surveillance company, which uses Visual Basic 6 w/VBA as front-end, SQL Server 2005 (Enterprise Manager and Query Analyzer) as back-end and Crystal Reports 8.5 and 11 as the reporting tool. The forms in AIMS have ASP pages w/VBA for Outlook and Outlook Express, embedded in the web browser object. This application is used by departments such as Dealer Relations, Contract Processing, Acquisitions, Quality Assurance, Customer Service, Collections, Billing and Accounting. Each department have there own set of menus leading to their GUI which have ASP pages embedded. AIMS has credit card processing and internal messaging system as well. I am mainly responsible for maintenance and troubleshooting their everyday troubles and bugs. I have worked and fixed one of the major programming issues with their credit card processing which was going on for some time. I have also worked on their web site as well which uses classic ASP w/VBA for Outlook and Outlook Express as front-end and SQL Server 2005 (Enterprise Manager and Query Analyzer) as back-end and modified some of the Stored Procedures. I created number of Financial and Business analytic reports from scratch using T-SQL commands and Crystal Reports 11 and scheduled the reports to be generated automatically in Business Objects 11. I also worked on their web site (www.Counterforceusa.com) and added new features, as per request of the GM and graphics giving the web site a more dynamic and attractive look. I used classic ASP for modification on the pages, which depending on existence of the data in the database

(SQL Server), displayed the data or presented a text box for the user to enter the data. I used Fireworks for the graphic and animation designing.

Responsible for:

● Developing, coding, maintenance and troubleshooting and Manual testing different types of Modules including their COM/DCOM

● Integration of the code from other team associates

● Development of documentation

Environment: Visual Basic 6.0 w/COM/DCOM, ADO, VBA for Outlook Express and Outlook, VBA for Word, VBA for Excel, classic ASP and ODBC, Dreamweaver, Fireworks, SQL Server 2005 (Enterprise Manager and Query Analyzer), and Crystal Reports 8.5 & 11, Business Objects 11. Software Developer (Contract)

Transocean Offshore Inc - Houston, TX

November 2006 to March 2007

Global Reporting System-Rig / Online (GRS-Rig/GRS-Online) Global Reporting System is an application used to report daily reports from the Oil Rigs to the Headquarter

(OnLine) and vise-versa. GRS is dual side application, which functions on Rig side and OnLine side. I was mostly working on the Rig side which uses VB6 w/VBA for Outlook Express as front-end and Access XP as a back-end and uses Remote Data Objects (RDOs) using ODBC to connect front-end with the back-end and conducting Manual testing the new code. I was mainly responsible for handling import and export of the data from Oil Rigs to Headquarter (OnLine) and back and also conducting Manual tests. Transocean is releasing new version of the software with new functionalities and some bug fixes. I was also responsible for coding of a new functionality of importing and exporting of data of an oil well from Rig to OnLine and back and other new functionalities. I also designed, developed and coded number of log forms which displays information about imported and exported files and lists of files and also keep track of each file in transaction. I also worked on their OnLine side which partly used Java as front-end and Oracle 8i and/ or Oracle 9i as back-end, and just like Rig side application, OnLine side also uses VB.NET and ASP.NET with ADO.NET and ODBC for data connectivity. I was also responsible for coding of new (Dynamic Link Libraries) DLLs and Classes used in importing the files received from Rig to OnLine and store all data and information in the Oracle database. I used Crystal Reports 10 and CDO sets to design, re-design and print all the data reports.

Responsible for:

● Designing, developing, coding and Manual testing different types of Modules including the COM/DCOM

● Integration of the code from other team associates

● Development of documentation

Environment: Visual Basic 6.0 w/COM/DCOM, RDO and ODBC, VB.NET, ASP.NET, ADO.NET, VBA, Access XP and Oracle 8i/9i, PL/SQL, and Crystal Reports 10, Java. Skills

• .NET (6 years)

• SQL Server (5 years)

• Oracle (6 years)

• HTML (8 years)

• DHTML (8 years)

• XML (5 years)

• javascript (6 years)

• AJAX (5 years)

• VBA of Excel (2 years)

• Visual Studio 6 (6 years)

• ASP.NET (6 years)

• C# (4 years)

• VB.NET (3 years)

Additional Information

COMPUTER SKILLS:

Languages:

Visual Basic 6 with COM & DCOM, Visual Studio 2005/2008/2010 including VB.NET, ASP.NET, ADO.NET, C#.NET, VBA for Outlook or Outlook Express, VBA for Word, VBA for Excel, classic ASP, SAP Powerbuilder 12.6, Business Object/Crystal Reports 8.5 & 10 & 11, Data Reports, C, C++, SQL * PLUS, SQL, T-SQL, WDDX, WML, XML, HTML, DHTML, VB Script, JavaScript, AJAX, java. Databases / Source Control Applications:

Oracle 8/8i/9i/10g/11i, SQL Server 7.0, 2000, 2003, 2008 (Enterprise Manager, Query Analyzer etc.), MS Office 9x/XP/2000/2003/2007/2010, Access 9x, 2000, XP, FoxPro 2.6b, IBM DB2/400, MS Dbase IV Operating Systems:

Window 95/98/XP/Vista/7/8/10, Windows 2000, Window NT(Server & Workstation), DOS Other Software:

Cygnet, TOAD 7.0, XMLSpy, Nokia Tool Kit, WINWAP, Front Page 2000, Dreamweaver, JASC, Paint Shop Pro.

Contact this candidate