Sign in

PL/SQL developer

Toronto, Ontario, Canada
September 10, 2018

Contact this candidate


Ying Wu

Tel: 647-***-****


To obtain an Oracle PL/SQL Developer position.


Over 10 years of professional development experience in delivering large-scale high quality performance-critical software development in the area of Windows and Web application programs

Strong experience on Database design and development in Oracle and SQL Server.

Strong analytical skill and attention to detail.

Perform unit test and assemble test.

Proficient at CMMI 5 and SDLC

Excellent analytical, research and problem-solving skills

Good ability to work independently or as a member to meet project deadlines

Strong team, interpersonal and communication skills

Excellent quick-learning and continuous-learning ability

Technical Skills

Programming Languages: PL/SQL, Powerbuilder,, ASP/, VBA, JSP, JavaScript, JQuery, HTML, XML, CSS

Database: Oracle(9i,10g,11g,12c), SQL Server2000/2005, Sybase, SQL Anywhere

Development Tools: PL/SQL, PowerBuilder, MS Visual Studio 2005/2008/2015, SSRS, SSIS, AJAX, Web Service, Word, Excel, Team Foundation Server, MS Project, windows 2005/2008

Professional Experience and Projects

Senior Application Software Developer 2011.6-2017.7

BMO Financial Group

Developed functions, stored procedures, package, materialized views and views in Oracle 11g and Oracle 12c.

Maintained and enhanced existing Insurance applications to meet performance and quality goals.

Maintained Metrics reporting SSRS application.

Perform unit testing to ensure quality and to minimize the number of defects found by QA

Provide production and user acceptance testing application support to complex technical problems on all assigned applications and technology that serve each business unit by analyzing problems, implementing solutions and developing new procedures surrounding support.

Implement new systems or enhancements by reviewing programs written by team members, establishing and executing system test procedures, developing implementation plans, developing the required program and system documentation and ensuring all functionality has been delivered as required.

Prepared QA promotion form and Production Promotion from.

Performed problem solving in the production environment such as performance issue and network issue.

Conduct performance tuning according to production issue.

Conducted effective communications within the project team

Prepared System builder guide to upgrade application server and database server.

Environment: PowerBuilder 11.5, Oracle 11g/12c, SSRS, windows, Linux, Visual Studio Team System 2008/2013//2015

Program Analyst--Contract

Olympus Canada Inc. 2009-2010

Created and designed the system architecture and the preliminary system design documents

Designed logical and physical models of the systems

Developed data mappings and data transformations with SQL stored procedures and SQL DTS/SSIS packages

Developed database views, functions, stored procedures and jobs

Reviewed the design documents, test checklists, source code with peers to prevent the issues.

Provided second level application support for team members in Technology Infrastructure

Performed problem solving in the production environment

Conducted effective communications within the project team and with the customer, suppliers and manufacturing

Environment:: C#, ASP.Net, AJAX, Web Service, SSRS, SSIS, Visual Studio 2005, MS Office, Visio, UML, VSS, SQL Server 2005

Software Engineer

Accenture Delivery Center 2005 – 2008

Analyzed the software requirements/feasibility/architecture, worked out system specification document (SSD), estimated development level of effort (LOE), and defined inter-module API

Supported and enhanced existing applications to meet performance and quality goals

Conducted Release Audit, included: reviewed design documents, test documents and execute test cases.

Designed, created Stored Procedures, Table, Views and Functions

Performed detailed analysis, designed of proposed application changes

Provided support to marketing, testing and other departments

Communicated with team members, tester, SQA, SEPG for the defect prevention and defect analysis during each milestone

Prepared and sent the report include : daily report and defect report

Reviewed, analyzed, and modified programming systems, including coding, testing and debugging

Followed efficient and repeatable software design methodology to ensure solutions are delivered with highest quality

Environment::, ASP.Net, JavaScript, JSP, HTML, AJAX, MS Office, Windows Vista, Visual Studio 2005, SQL Server 2005, Oracle 9i, Oracle Form

System Engineer

Sound Computer Co., Ltd 1999 – 2005

Identified and analyzed client requirement, worked out the ERP System workflow and system architecture

Estimated development level of effort and created system specification document

Reviewed the primary documents with customers to figure out the risk management checklist

Generated project Level performance report, collected and analyzed project metrics report

Performed detailed analysis, designed of proposed application changes

Environment: Power Builder, ASP/ASP.Net, JavaScript, HTML, Oracel8i/9i, Sybase, SQL Anywhere


Bachelor of Automation Heilongjiang University, China Sep 1995 ~ Aug 1999

Professional Training

CMM, CMMI QAI Global Institute Sep 2005

Contact this candidate