Experience

Silver Creek Software

• United States
• Information Technology & Services
• 1 - 100 Employee

• Senior Software Developer

  • Dec 2020 - Present

  Project: Alberta Environment and Parks account - Wildfire enterprise project (including FIRES, IMIS and CAS applications) in Alberta provincial government industry. • Developed, maintained and enhanced PowerBuilder applications by using PowerBuilder 2019, Oracle SQL and PL/SQL. • Met and discussed with the client regarding the change requirements and recommended modifications. • Prepared for Acceptance and Production releases, and deployed it to Acceptance and Production environments on Citrix. • Prepared change requirement specifications for user sign-off. • Assisted the internal testers and the client acceptance testers with the test for applications. • Wrote the change migration documents and release notes for the applications. Technical Environment: • Appeon PowerBuilder 2019, Oracle 12g, Oracle 19c, SQL, PL/SQL, Oracle SQL Developer. • Git-GUI and Microsoft TFS for source code version control. • Microsoft Teams, Windows 10, Unix, Citrix. Show less



Lanbase Information Technology Inc.

• Senior Software Developer

  • May 2015 - Dec 2020

  Project: Financial management systems and Taxation information projects. • Developed and maintained complex business applications using Java and Oracle. • Provided back end support by writing Stored Procedures, Functions, Triggers, and Views in PL/SQL. • Involved in bug fixing and enhancements of the application. • Reviewed codes and suggested changes to improve maintainability. • Created test cases, conducted unit testing and integration testing for functionality. • Assisted with user acceptance testing and training. • Assisted technically to team members. Show less



Graham Management Service LP

• Calgary, Canada Area

• Senior Software Developer

  • Jun 2014 - May 2015

  Project: Enterprise projects in construction industry. • Design, code, test and implement new modules for the applications. • Support multiple applications by fixing bugs or adding additional features. • Build the new dynamic datawindows and reports for the applications. • Design and make changes for the data models. • Performed extensive testing and quality assurance for the system applications. Technical Environment: • Powerbuilder 12, 12.5, PowerDesigner 12. • SQL-Server, SQL, Transact-SQL, SQL Server Management Studio. • HarPB source control, SCM software change management tool. • Windows 7, Windows Server 2008, Windows Server 2012. Show less



Fujitsu Consulting (Canada) Inc.

• Alberta, Canada

• System Analyst and Developer

  • May 2011 - Jun 2014

  Project: Alberta government enterprise projects in government industry. • Analyze application problems and recommend modifications. • Produce and maintain program code using Powerbuilder10 (Include PFC) and Oralce SQL, PL/SQL. • Design and build application components based on user requirements. • Prepare functional specifications for client review and sign-off. • Perform systems testing with the clients. Provide support during various phases of testing. • Review requirements with the cleints and provide time estimates for task completion. • Write the change migration documents and release documents for the systems. • Write, revise and test the application program code. • Make Acceptance and Production builds, and deploy the Acceptance and Production release. Technical Environment: • Powerbuilder 10.2, Oracle 10g, SQL, PL/SQL, Oracle Designer, Toad 9.5. • StarTeam source control, Hummingbird connectivity. • TextPad, Ipswitch WS_FTP Pro, Search and Replace. • Windows XP, Windows Server 2008, Unix, Solaris. Show less



AGAT Laboratories Ltd.

• Calgary, Alberta, Canada

• Senior Software Developer

  • Dec 2010 - May 2011

  Project: Laboratory Information Management Systems (include Utilities system, Client Master System, Work Order system, Invoice system, Bomb system) in Laboratory industry. • Maintained and upgraded Laboratory Information Management Systems by using Powerbuilder(include PFC), Oracle SQL, PL/SQL. • Re-organized and enhanced the applications’ structure and code, created new Version for Laboratory Information Management Systems. Make the systems easier maintainable and more stable. • Fixed the applications’ issues quickly and successfully, took the main responsibility to resolve the tough issues. • Meeting with the end users to discuss the business requirements, and designed, developed new modules and functions for new requirements. • Researched the latest web application development technologies and methodologies, researched the framework and design patterns for future’s rewriting .Net version Laboratory Information Management Systems. • Build and deployed the Laboratory Information Management Systems for all AGAT Laboratories locations across Canada. Technical Environment: • Powerbuilder, Oracle Database, SQL, PL/SQL, Toad • .Net including Nhiberbate, C#, Microsoft visual studio. • Numara Track It System, ObectCycle source control, Windows XP, Windows7. Show less



SIVCO Inc.

• Calgary, Alberta, Canada

• Java Developer

  • May 2010 - Aug 2010

  Project: Environmental Safety Suite including Chematix, Biologistix, Inspection, Training Records, Oars, Radioactive in university research industry. • Maintained and upgraded Environmental Safety Suite by using HTML, JSP, JSTL, JavaScript. • Developed and maintained Environmental Safety Suite by using Java, Java Servlet, J2EE and IBM Rational Application Developer (Eclipse). • Designed and developed Environmental Safety Suite by using IBM DB2 SQL, PL/SQL. • Testing Environmental Safety Suite in IBM WebSphere Application Server environment. • Create and generate PDF reports by using iText PDF library. Technical Environment: • HTML, JSP, JSTL, JavaScript, Java, EJB, J2EE, iText PDF. • IBM DB2 Database, SQL, PL/SQL. • CVS source control, Windows XP, Windows Vista, Unix. Show less



CGI Information Systems and Management Consultants Inc.

• Calgary, Alberta, Canada

• Software Developer

  • May 2008 - May 2009

  Project: PVR(Production Volume Reporting),PAS(Production Accounting Solution),DAS(Database Alert System) in Oil&Gas industry. • Maintained and upgraded Production Volume Report system by using PowerBuilder10.2, Oracle SQL, PL/SQL (Including Oracle 9i, 10g version). • Developed, maintained and upgraded Production Accounting System by using, Java1.6, HTML, JSP, XML, Struts, Tomcat and Eclipse and Oracle SQL, PL/SQL, and Java Enterprise Patterns. • Designed, Maintained, upgraded Database Alert System by using Java, NetBeans and Oracle Database. • Wrote, revised, integrated program code by using Test-Driven-Development technique. • Developed software system in Agile Methodology and Software Development environment. Technical Environment: • PowerBuilder10, Oralce9i, Oracle10g, Toad. • Java 1.6, J2EE, SQL, PL/SQL, Eclipse, NetBeans. • PVCS, CVS and Subversion(SVN) source control, Windows XP, Unix. Show less



Lanbase Information Technology Co. Ltd.

• GuangZhou, China (included continued support from Alberta in 2006,2007)

• Senior Software Developer, Team Leader

  • Nov 2001 - Dec 2007

  Project: Government Taxation and Financial Management enterprise projects. • Analyzed, designed, developed and maintained financial management system by using Powerbuilder (Including PFC), Oracle database, SQL-Server, Sybase Database. • Analyzed, designed, developed and maintained software system by using Javascript, HTML, XML, XSL, JSP, Java, J2EE, IBM WebSphere and Jboss. • Maintained, upgraded software systems according to users’ requirements. • Wrote, revised, integrated and tested software program code. • Wrote requirement specification documents for projects. • Researched and evaluated latest software development tools and popular database products. • Analyzed client’s complex requirements into related components which can be solved through the application of computer technology. • Provided technical support for support team and clients. Technical Environment: • PowerBuilder6.5, PowerBuilder7, PowerBuilder9, PowerBuilder10, Oracle SQL, PL/SQL. • Oracle8.17, Oracle9i, Oracle 10g, SQL-Server, MySQL, Toad, PL/SQL Developer. • Java 1.4, Javascript, HTML, XML, JSP, Java, IBM WebSphere and Jboss. • Windows98, Windows2000, Unix, Solaris. Show less



NetAGE Development Co. Ltd.

• HongKong, China

• Software Developer

  • Aug 1996 - Oct 2001

  • Designed, developed the application foundation class by inheriting Powerbuilder PFC. • Optimized program code and arithmetic for software systems, made systems running faster. • Wrote technical documents and training manuals for software applications. • Analyzed and designed application logical and physical specifications for software systems. • Created the Table Structures, Package, Procedure, Funtion, Trigger, View etc on database back-end side. • Provided maintenance, updating, client support and enhancement to new and existing systems. • Installed, configured and maintained Oracle database systems. Technical Environment: • PowerBuilder5.0, PowerBuilder6.5, PowerBuilder7.0, SQL, PL/SQL. • Oralce7.3, Oracle8.05, SQL-Server, PL/SQL Developer. • Windows 95,Windows 98,Windows NT, Client/Server environments. Show less