Resume

Sign in

Application Systems Analyst Programmer

Location:
Missouri City, TX
Posted:
November 04, 2019

Contact this candidate

Resume:

**** * **** *****

Missouri City, TX *****

832-***-**** (C)

adarev@r.postjobfree.com

OBJECTIVE To obtain a position in Application supporting, Database Programming and Report Writing

STATUS Permanent Resident in the U.S.

CAREER SUMMARY

•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.

SKILLS

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

EXPERIENCE

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

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

(SCRUM) methodology.

12/2007 – 04/2008 Web Application Analyst, Perry Homes, Houston, TX

www.perryhomes.com

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

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

Supported an intranet site using ASP, JavaScript, and XML with Oracle database and created Crystal Reports. The application provides the ability to view square footages, sales amount, and sales per square foot for each department within a store. It helps store managers arrange space of each department productively in their stores and provides the ability of square footage maintenance through the interface.

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.



Contact this candidate