Missouri City, TX *****
OBJECTIVE To obtain a position in Application supporting, Database Programming and Report Writing
STATUS Permanent Resident in the U.S.
•10+ years of experience as an application supporter, report developer.
•Strong experience in SSRS, Power BI, Crystal, Tableau and BO report.
•Extensive experience in SQL Server and Oracle database programming.
•8 years of experience in ASP.NET, VB.NET, ADO.NET, C#.NET
•2 years of MVC5, Telerik Kendo, Bootstrap, JQuery, Agile, Cloud, REST and Soap
•Able to work closely with customers to determine requirements and implement applications that successfully address needs.
•Excellent experience in oil/gas energy and finance software support and develop.
Reporting: SSRS, BI, Crystal, BO, Tableau.
Languages: SQL, PL/SQL, ASP.net, VB.net, Java Script, CSS, XML MVC, C#, PowerShell Script
Tools: VS 2017, 2015, 2013, 2010, TFS, VSTS, Toad.
Database: SQL Server 2014, 2008, Oracle, MS Access.
Methodology: Agile (SCRUM)
EDUCATION M.S. Computer Sciences University of Houston
06/2008 – 12/2018 Senior Application Specialist, Energy Transfer, Houston, TX
PCTS web application
PCTS is a VB.NET intranet web application with SQL Server 2014. This system imports data from Oracle database daily through a SQL Linked Server by a complicated Stored Process and a SQL Job. The system provides a bunch of advanced SSRS Reports to end users. PCTS also exports data into a spread sheet monthly through SSIS and a SQL job. My responsibility includes getting requirements, designing, creating application and reports, and daily maintenance.
Connect-It is an ASP.Net web application. It is a repository for all data related to interconnection projects used by many different user groups. It includes many phases of projects, such as, project scope, site visit notes, estimate, requirements, etc. My main responsibility is to support and enhance the application, writing sophisticated SQL stored procedures and building Crystal reports.
Unmetered Gas Loss
Unmetered Gas Loss is an ASP.Net web application with SQL Server 2014 and SSRS client side report (.rdlc) report. It tracks loss gas for measurement group. The system exports data daily to FlowCal using SSIS. My role is to support and enhance the application. It includes gathering customers’ requests, fix bugs, and add SSRS reports.
Compliance Tracking System
Compliance Tracking System is a web application of task scheduling. It allows users to create, edit, and delete various tasks, which will be reoccurring weekly, monthly, quarterly, or yearly. As tasks come in, the system will send out email notifications to the users. This is a project using MVC entity framework with Telerik Kendo and SQL Server 2014 backend.
I started the project from gathering detail requirements, designing user interface, then implementing business logic, writing various SSRS reports, and testing the application. The whole development life cycle was implemented through Agile
12/2007 – 04/2008 Web Application Analyst, Perry Homes, Houston, TX
Enhance and support company web site. The web site was built with Content Management System (CMS) and C#.NET and Cloud db. CMS is a different system from traditional to develop web sites.
09/2004 – 12/2007 Application Analyst/Developer, RBC Builder Finance, Houston, TX
Exception Engine Report
Exception Engine Report is a Crystal Report to catch all the errors in TCL while entering data into TCL. It involves heavily in writing advanced stored procedures.
GeneSYS is a web application with Crystal Report. It manages all phases of loan origination workflow, including submission, approval, completion and tracking. It involves creating a Renewal module using ASP.NET, which communicates to the original ASP application.
08/2000 – 05/2004
Analyst Programmer, Shell, Houston, TX
Space Management Project
Retail Rent Calculation System (RRCS)
Supported a web application (ASP, Oracle, Oracle develop 2000, Crystal Reports) to automate the rent renewal process for retail locations. Functionalities include loading input data from CMS, calculating and approving rental renewal contracts, and uploading renewal contracts back to CMS. The automated calculation process included in this application decreased potential for errors and increased efficiency.