Resume

Sign in

Sql Server Manager

Location:
Katy, Texas, United States
Posted:
January 27, 2018

Contact this candidate

Resume:

Jeff Pan

(Status: US citizen)

**** ******* **** **., ****, TX 77494

Phone: 713-***-****

E-mail: ***********@*****.***

Objective Seeking a challenging career in software engineer/developer/analyst position using my project development, programming and analytical skills to design, develop varies application/system for industries, commercial and engineering fields.

Education Professional Java 2 Training, and certified from Sun Microsystems, February, 2002.

M.S.E.E. Texas A&M University System (Prairie View), May, 1995. GPA: 3.5/4.0

Qualification *15 + years software development/programming/analysis experience.

* Achieved Sun Certified Programmer for the Java 2 platform (SCP).

* Expert on N-tier client/server application (design, programming, implementation).

* Deep knowledge and rich experience of Object Oriented Design/Programming.

* Rich database design, development, tuning and data analysis experience.

* Rich experience on web application (web server and web client).

* Excellent performance on project life cycle (planning/design/development/testing/delivery).

* Strong ability of handling/trouble-shooting on production issues under pressure.

* Good communications skills and relationship with peer, management, customer.

* Strong analytical ability on oil/gas/power business and industrial/commercial experience.

* Rich knowledge and skill of Web Service, messaging and data warehouse technology.

* Rich knowledge of SOLID, SDLC, RAD and experience in a variety of software environment.

Skills

* Language/technology:

-MS .NET Framework 4.0+, Visual C/C++, C# (WCF, WPF, EF, LINQ), ASP.NET, VB.NET, ADO.NET, Perl, CGI, UNIX Shell script, Windows batch script.

-Java (J2EE w/EJB, JSP, Servlet, MVC/Struts/JSTL, Swing, JavaBean, JMS, JDBC, JNDI, RMI, JNI, Applet, WebLogic, Javadoc, Log4j).

-SQL(T-SQL, PL/SQL, ANSI-SQL, SQL Profiler, OLTP,SSIS, SSAS) w/MS SQL Server, Sybase, Oracle(w/ SQL*PLUS, SQL*NET, SQL*LOADER, PRO*C, Oracle Developer)

-Visual Basic (w/COM, DCOM, COM+, MTS), ODBC, VBA, OLEDB.

-ASP.NET (w/ WEB API), XML XSL, XSLT, Tag Library, HTML, DHTML, CSS, JavaScript\TypeScript (including JQuery, JSON, Angular, Bootstrap, NODE), AJAX, VBScript, Ruby/Rake, UI\UX design, UI Web.

-Reporting Tools: Crystal Report, Impromptu, MS SSRS, and Business Objects.

-Visual C# (WCF w/ Web Services, Remoting service; WPF w/ MVVM, Prism, Unity), ASP.NET w/MVC, Razor, VB.NET, ADO.NET, DevExpress, Infragistics.

-Web Services (w/SOAP, WCF, REST).

-Data Warehouse (w\ OLAP, Apps).

-Team Foundation Server, MS Visual Source Save, MSTest, NUnit.

-RUP, UML/Rational Rose, PVCS, ClearQuest, CVS, SSL.

-MSMQ, (good knowledge of Rabbit MQ).

-EDI/X12.

-UC4, TIDAL (Auto scheduler).

-Knowledges: Cloud computing (Azure, CloudFundry).

* Database: MS SQL Server (w\T-SQL), Oracle (w\PL-SQL), Teradata, MS-Access.

* Platform System: MS-Windows/All versions, UNIX.

* Application/Web Server: BEA WebLogic, MS IIS, Apache, Tomcat.

* Tools/IDE: MS Visual Studio, MS Office family, Citrix, Crystal Report, JBuilder, PowerBuilder, ERWin, MS Team Foundation Server(TFS), JIRA (Bug Tracker).

* Protocols: HTTP, FTP\SFTP, TCP/IP, SMTP, SOAP.

* Proficient on OOP, OOD, SDLC, SOLID, Agile, SCRUM.

Experience Charles Schwab Corp. Consultant (Contractor) (05/2017 – 10/2017)

Short Sale Web Application

* Developing system (.NET Framework 4.0+, ASP.NET \ MVC \ C# \ LINQ \ Angular \ UI\UX Design, Bootstrap \ JQuery \ HTML5 \ CSS3 \ XML \ XSD \ Web service \ Windows services \ MSMQ), MS Visual Studio 2015, SQL Server 2016, TFS, MS Unit Test, Teradata).

Financial Data Transfer system among Mainframe system, Windows Server \ SQL Server, third party system as well as multiple big banks, Wall Street companies.

Security Lending Web Application

* System maintenance \ Enhancements \ Trouble-shooting \ Analysis \ Improve application performance \ Debugging \ Trouble-shooting (ASP.NET \ MVP \ JQuery, C#, SOA-Service-oriented architecture, Web Services \ Window Services \ MSMQ), MS Visual Studio 2015, SQL Server 2016, TFS, Teradata, FTP\SFTP.

Corporate Treasury Data Transfer system

* Develop \ Upgrade the system between Mainframe and SQL Server 2016 w\SSIS\SSRS\SSAS.

* Software Development methodology (Agile \ SCRUM \ Sprint control \ JIRA).

Intel Corp. Consultant (Contractor) (10/2016 – 05/2017)

Production Process Planning System

* Developing supply chain system (Winform\WPF\Intel Framework ISA, UI \ UX Design, controller class, model class, WCF web service objects, Data objects, DB objects – tables, views, stored procedures design, coding, .NET Framework 4.0+, MVC, C#, LINQ, WCF Web service, Entity Framework, SOA (Service-oriented architecture), MS Visual Studio 2015, SQL Server 2014, SQL Profiler, CTE, UDF, SP, SSRS, SSIS, SSAS).

* Production support for manufacturing planning system (Debugging \ Trouble-shooting, improve application performance, day to day operation support, data transfer support, modelling support, reporting support).

* Technology: MS VS2015, TFS, NUnit, Ruby\Rake, Subsonic, Infragistics, CCTray, SVN, SAS.

* SDLC (SCRUM, project sprints process control).

Kinder Morgan Inc. Sr. Analyst\Developer (8/2012 – 9/2016)

Natural Gas Pipeline System:

* Developing enterprise level flagship natural gas transportation systems (page, view, controller class, model class, web service objects, DB objects – tables, views, stored procedures design, coding, upgrading w/ UI \ UX Design (4 years), ASP.NET, MVC, VB.NET, .NET Remoting service, ADO.NET, MS SQL Server).

* Analysis, tuning, improve application performance, debugging, trouble-shooting on interfaces w/multiple applications (including gas pipeline system, gas field production system, and enterprise ERP system) for supporting CO2 business.

* Daily production support w/VB.NET at front tier, MS SQL Server at back tier.

* Support multiple data transactions among different enterprise systems\applications (w\MS SQL Server 2012, Oracle 11g, Enertia, Lawson)

* Developing engineering software license usage reports w/Data Warehouse\Data Cube.

* Technology: MS Windows Server, IIS, SQL Server 2008 (w/ ADO.NET, T-SQL, SSIS\DTS), Visual Studio 2012, WinForms\WPF\XAML\MVVM, Crystal Reports, Infragistics, Citrix, SSRS, VBA.

* Data Warehouse (w\ OLAP, OPENiT App).

* Development tools (MS Team Foundation Server, JIRA)

* Through business requirement document (BRD) review process as well as technical code review process, proficient on development quality assurance, customer satisfaction.

El Paso Corp. Sr. Analyst\Developer (8/2007 – 8/2012)

Project: Integrating\Rewriting a New Natural Gas Pipeline System from multiple systems:

* Rewriting enterprise level flagship web application (UI \ UX Design, Mid-tier, Back-tier Design, w/ MS SQL Server (1-1/2 year).

* Design w/BU experts and BU analysts, translating business needs to technical solutions. Improve application performance \ data transaction performance.

* Support multiple data transactions among different enterprise systems, applications, databases.

* WCF (.NET Remoting service through C++ middle tier to databases; Communication through MSMQ, Named Pipe, HTTP, TCP to multiple enterprise systems, applications)

* Technology: MS Windows Server, IIS, SQL Server 2005 (w/T-SQL, C#, ASP.NET, WCF, WPF, Entity Framework, MVC), Visual Studio C#, ADO.NET (w/CSS, HTML/XML/XAML, JavaScript – NODE, JQUERY, JSON, Angular; AJAX), UC4.

* Development tools (MS Team Foundation Server, source code control).

* Through business requirement document (BRD) review process as well as technical code review process, proficient on development quality assurance, customer satisfaction.

Natural Gas Pipeline System:

* Analysis, tuning, debugging, trouble-shooting on rewritten (C#, ASP.NET, DevExpress, Infragistics) enterprise level flagship web application.

* Daily production support w/C#, ASP.NET at front tier, MS SQL Server at back tier.

* Proud of created efficient, reliable, easy to maintain natural gas pipeline nomination and confirmation module interface of gas pipeline system with EDI\X12 transaction.

* Support mission critical batch job transactions with UNIX scripts.

* Technology: MS Windows Server, IIS, SQL Server 2005 (w/T-SQL, OpenXML, DTS), Crystal Reports, Visual Studio C#, ASP.NET, ADO.NET (w/HTML/XML, JavaScript), EDI\X12, UC4.

* Development tools (MS Team Foundation Server)

El Paso Corp. Contractor (11/2006 – 8/2007)

Natural Gas Pipeline System:

* Analysis, tuning, debugging, trouble-shooting on enterprise level web application.

* Daily production support w/JAVA front tier, C/C++ middle tier, MS SQL Server back tier.

* Daily support a PowerBuilder application of ANR Natural Gas Pipeline system.

* Technology: MS Windows Server, IIS, SQL Server 2005 (w/T-SQL, OPENXML, DTS), JADE (w/J2EE, HTML/XML,SPRING), MKS Tool, UNIX Scripts, Windows batch script.

Weatherford International. Developer (04/2005 – 11/2006)

Oil Field Production System Web Application project:

* Design, analysis, construction, tuning, debugging, trouble-shooting on enterprise level application (Web pages design, middle tier business objects design, data processing, stored procedures design, etc.)

* Integrating web application w/prosperity database and MS SQL Server.

* Achieved efficient interface design with multiple kinds of RTUs.

* Technology: Microsoft Windows Server, IIS, SQL Server 2000 (w/T-SQL, OPENXML, DTS), Visual Studio C++, C#, ADO.NET (w/HTML/XML, javascript).

* Development tools (MS Visual Source Save)

PriorityIT Inc. Developer (06/2004 – 01/2005)

Web Application project:

* Design, analysis, construction, tuning, trouble-shooting on web application (Pages design, middle tier business objects design, data processing, stored procedures design, etc.)

* Integrating web application w/web services, phone system, reporting services, printing services and COM components.

* Technology: Microsoft Windows 2000 server, Windows XP, IIS, SQL Server 2000 (w/T-SQL, OpenXML, DTS), Visual Studio 2003, MS Reporting service, Visual Source Safe, C#, ASP.NET, ADO.NET (w/HTML/XML, javascript).

Project for Xisico USA, Inc., Houston, TX (03/2003 – 05/2004)

B2B E-Commerce project:

* Design (conceptual, evaluate, analysis and modeling) business to business e-commerce portal application (forms and classes: web pages, user controls, business objects design, configurations).

* System construct, database design/admin, data conversion processing, implement, testing, deployment supporting, trouble-shooting the web application.

* Warehouse management (sales, purchasing, shipping, inventory controlling, customer relationship, advertising etc.), system upgrading, maintenance, implementation, documentation.

Technology: ASP.NET, ADO.NET, VB.NET, C#, MS Visual Studio 2000, MS IIS, SQL Server 2000(w/T-SQL), DTS, Crystal Report, HTML/XML/XSL, CSS, Javascript, Oracle(w/PL/SQL), PowerBuilder(w/PFC, InfoMaker), Windows 2000.

Koch Industries, Inc., Houston (08/1999 – 01/2003)

Position: Delinea Corporation Consultant (Application Development & Production Support @ Gulf South Pipeline Company – A Division of EKLP Account)

Client/Server project: Pipeline Gas Exchange System (01/01-02/03)

Platform: MS Windows NT/2000, UNIX; DBMS: Sybase Enterprise Adaptive Server.

Major Development Tools: PowerBuilder(w/PFC), RapidSQL, Rational ClearQuest, PVCS.

* Implement/maintain stored procedures for day to day operation of natural gas pipeline production.

* Research, analyze and solve the production critical issues for the system.

* Create, modify, and enhance objects of front end in most sub systems.

* Create new stored procedures and analyze/trouble-shoot on stored procedures.

* Define, analyze, design and construct application objects on new sub-system (such as Critical Period system).

* Achieve application/system/database performance tuning, optimization.

* Test/evaluate system upgrading issues.

Web project: (1) Nomination/Confirmation/Scheduling (2) Imbalance Trading (3) Gas Volume Allocation (4) Capacity Release (5) Information Posting (6) Rates Service (7) Common Business/Utility Object Components

Platform: MS Windows NT/2000, UNIX; DBMS: Sybase Adaptive Server Enterprise.

Application/Web Server: BEA WebLogic, SilverStream, MS IIS.

Development Tools/Skills: VisualCafe, J2EE (w/EJB, JSP, Servlet, Struts, RMI, JMS, JavaMail, JavaBean,) HTML, XML, XSL, Crystal Report/Enterprise, RapidSQL, PVCS, ClearQuest/Rose, MS(Visual Basic, Visual C ASP, InstallShield.

* Application back-end and front-end: design, analyze w/J2EE design patterns; Programming and testing w/ object oriented technology -- develop session/entity/message beans (ui, workflow, locator, remote call, service, dao, navigation, communication, message, utility, model) by using EJB, Struts, Servlet, JSP, JavaScript, XML, XSL.

* Design and build new reports and analyze and identify any issue on reports.

* Trouble-shooting problems/exceptions on web application and database processing.

* Design, build, analyze and tune stored procedures.

* Convert C / C++ codes into JAVA codes on J2EE structure.

* Re-write / mediate JAVA application from SilverStream to Weblogic w/J2EE structure.

* Configure /set application server using JDBC, JNDI w/database and intranet/internet network socket/protocols.

* Query complex data set for production and marketing analysis.

Project: Customer Relationship Management application (CRM) (02/01-02/03)

Platform: MS Windows NT/2000, UNIX; DBMS: Sybase Enterprise Adaptive Server.

Application/Web Server: BEA WebLogic, Apache.

Major Development Tools/Skills: VisualCafe, Crystal Report, RapidSQL, Rational ClearQuest, PVCS Version Manager, Perl.

* Define, analyze, design and construct source files.

* Create and modify stored procedures to working with Perl programming.

Position: Software Developer/Analyst (Application Development & Production Support @ Koch Midstream Company)

Client/Server project: TransEnergy Management System (TMS) (08/99-02/01)

Platform: MS Windows NT; DBMS: MS SQL Server.

Major Development Tools: PowerBuilder (w/PFC), MS Enterprise Manager, C++/C, PVCS.

* Implement TransEnergy Management System front end and stored procedures for day to day operation of natural gas midstream processing.

* Research, analyze and trouble-shoot production critical issues for the system.

* Define object’s changing request to the system provider.

Client/Server project: Producer Processing System (PPS) (08/99-02/01)

Platform: MS Windows NT; DBMS: MS SQL Server.

Major Development Tools: PowerBuilder (w/PFC), MS Enterprise Manager, C++/C, PVCS.

* Implement/maintain stored procedures for day to day operation of natural gas PPS.

* Research, analyze and solve production varies issues for the system.

* Create, modify and enhance application objects and reports in all sub systems.

* Design, build, analyze and tune stored procedures for the system.

* Solve varies critical issues on the system for Y2K project.

* Implement data processing, data formatting with EDI.

* Remote support with Citrix.

Client/Server project: Intergy Gas Accounting System (08/99-08/00)

Platform: MS Windows NT; DBMS: MS SQL Server.

Major Development Tools: PowerBuilder (w/PFC), MS Enterprise Manager, WISQL, PVCS.

* Support, analyze and solve issue for the natural gas accounting system.

* Trouble-shooting stored procedures for the natural gas accounting system.

ASP project: Federal Regulation Information Application (08/99-02/01)

Platform: MS Windows NT; DBMS: MS SQL Server.

Web Server: MS Internet Information Server.

Major Development Tools: ASP, HTML, COM, JavaScript, MS Enterprise Manager, WISQL.

* Support (analyze/trouble-shoot) the information system.

* Enhance/modify web pages.

Research web project: Online Producer Processing System (PPS) (01/00-02/01)

Platform: MS Windows NT; DBMS: MS SQL Server.

Application server/web server: SilverStream, MS IIS.

Major Development Tools/Skills: Java w/JBuilder, SilverStream, Dreamweaver, JavaScript, VBScript, HTML/DHTML, MS Visual Intedev.

* Define, analyze and design main pages.

* Research, analyze and evaluate the web application with system requirement.

Project: Midstream Management Application (08/99-02/01)

Platform: MS Windows NT; DBMS and Tools: MS Access, MS Excel

* Research, analyze and solve production issues for the system.

* Help user of business group to use the system.

SQL Systems, Inc., Houston (02/1999 – 06/1999)

Position: Consultant (Application Development Contractor) @Chase Bank of Texas, Consumer Credit Operation Center Account

Client/Server project: FIAT System

Platform: MS Windows NT; DBMS: MS SQL Server.

Major Development Tools: PowerBuilder (w/PFC), MS Enterprise Manager, WISQL.

* Remediate the system of the bank to meet the requirement for US government.

* Solve varies critical issues on the system for Y2K project.

EnForm Technology, LLC, Houston (12/1998 – 02/1999)

Position: Consultant (Application Development Contractor)@Engage Energy Account

Client/Server project: Electrical Power Trading System

Platform: MS Windows NT; DBMS: MS SQL Server.

Major Development Tools: PowerBuilder (w/PFC), MS Enterprise Manager, WISQL, PVCS.

* Mediate, analyze and trouble-shoot application objects and stored procedures.

MI Systems, Inc., Houston (08/1998 – 11/1998), (05/1998 – 06/1998)

Position: Consultant (Application Development Contractor)@BP Amoco Account)

Client/Server project: (1) Payroll System (2) Transportation System (3) Project Management System (4) Common Objects Library

Platform: MS Windows NT, UNIX; DBMS: Oracle(w/SQL*Plus,SQL*Net), Sybase SQL Server.

Major Development Tools/skills: PowerBuilder (w/PFC),, WISQL, PVCS, SMTP, VB.

* Research, analyze and solve varies issues for the systems.

* Create, modify and enhance application objects in varies sub systems.

* Design, analyze and trouble-shoot stored procedures and packages for the systems.

* Solve varies critical issues on the systems for Y2K project.

* Build interface between PowerBuilder application and SAP R3 system.

TransEnergy Management, Inc., Houston (07/1998 – 08/1998)

Position: Consultant (Application Development Contractor)

Client/Server project: TransEnergy Management System (N-Tier)

Platform: MS Windows NT; DBMS: MS SQL Server, Oracle.

Major Development Tools: PowerBuilder (w/PFC), MS Enterprise Manager, WISQL, SQL*PLUS.

* Implement/maintain/trouble-shoot stored procedures for the software.

* Research, analyze and solve varies issues for the systems.

MI Systems, Inc., Houston (04/1997 – 04/1998)

Position: Consultant (Application Development Contractor to CSC@SCI Account)

Client/Server project: (1) Employment Management Application (2) Tele-Collection Application of Horizon System for Service Corporation International(SCI)

Platform: MS Windows, UNIX; DBMS: Sybase SQL Server, MS Access.

Major Development Tools: PowerBuilder (w/ObjectMastroe), MS Access Application, MS Enterprise Manager, WISQL, Impromptu Report, Visual Basic, Lotus Notes.

* Design, analyze and construct application structure and objects.

* Design data model of varies sub system on database.

* Analyze and trouble-shoot complex issues.

Innovative Business Solution, Inc. Houston (01/1997 – 03/1997)

Position: Consultant (Application Development Contractor)

Client/Server project: (1) Oil/Mineral Field Ownership Application (2) Oil/Mineral Field Lease Management System

Platform: MS Windows, UNIX; DBMS: Oracle(w/SQL*PLUS, SQL*NET, Pro*C etc.).

Major Development Tools/skills: PowerBuilder (w/PFC, Infomaker Report), PL/SQL.

* Design, develop and construct application objects and reports.

* Implement data management, create and modify stored packages, procedures and triggers.

American Optimal System, Inc. Houston (06/1995 – 12/1996)

Position: Developer/Programmer

Project: Manufacture Application

Platform: MS Windows, UNIX; DBMS: Oracle(w/SQL*PLUS, SQL*NET, Proc*C etc.).

Major Development Tools/skills: PowerBuilder(w/PFC), PL/SQL, ERWin, Shell script, C/C++.

* Design, develop data model and application as well as database on-going maintenance for inventory control, shipping, QA control, processing, engineering, sales and purchase.

* Implement data management, create and modify stored procedures, packages and triggers.

References Available upon Request.



Contact this candidate