Ying Wu

647-***-****, ** Gould Lane Thornhill Ontario L4J 9B5 * adchrg@r.postjobfree.com

Objective

To obtain an Oracle Application Developer/Migration Specialist position.

Qualifications

More than 10 years of solid experience in the full software development life cycle including requirement analysis, coding, testing, data analysis and business intelligence reporting, system maintenance and support.

Over 10 years of development experience in Database design and development in Oracle (PL/SQL) and SQL Server.

Worked on multiple domains like Banking, Insurance, and Hedge Fund Investment.

Strong experience in Procedure, Function, Triggers, Packages with PL/SQL and T-SQL.

Solid background in OOP/OOD, Database Development, Database Modeling, Data Integration, Data Warehousing and BI

Proficient in ETL using SQL Server Integration Services (SSIS) in implementing data warehouse ETL process in multiple data source environment as well as data migration

Excellent analytical, research and problem-solving skills, a quick learner

Extensive experience in Waterfall as well as Agile/Scrum environment, a strong communicator

Technical Skills

Programming Languages: PL/SQL, T-SQL, PowerShell, Excel, VBA, PowerBuilder, Python, ASP.net, C#.net, JavaScript, JQuery, HTML, XML, CSS

Database: Oracle(9i,10g,11g,12c), SQL Server, Access, Postgres, Sybase

BI tools: Crystal report, SSRS, Power BI,SSIS

Development Tools: Oracle PL/SQL, Toad, PowerBuilder, MS Visual Studio, Crystal Report, CA Workload Automation ESP, Linux, Windows, Team Foundation Server, GIT,MS Project, JIRA, Confluence

Professional Experience and Projects

Oracle Database Developer - Contract 2019.2—2019.12

The Citco Group Limited

Designing, developing, maintaining and deploying business intelligence solutions

Developed and executed complex stored procedures, packages, functions, materialized view in Oracle data warehouse.

Designing, developing and testing Crystal Reports based on business requirement.

Setup report tables in Oracle warehouse.

Developing complex ETL processes for data warehouse loading from internal or external datasources.

Tuning, debugging complex stored procedures, packages, functions and cursors

Perform unit testing to ensure quality.

Good understanding of Oracle SQL and PL/SQL to convert Oracle code to Postgres.

Conducted troubleshooting and problem solving for production issues.

Environment: Oracle PL/SQL, Oracle OLAP, SAP Crystal report, Toad, Excel, JIRA, Confluence, windows, Visual Studio Team System, Postgres, GIT

Senior Application Software Developer 2011.6-2017.7

BMO Financial Group

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

Developed stored procedures and views for data input to Sportfire.

Create logic and ETL jobs for data Analysis, data matching, Data Mapping.

Prepared System builder guide to upgrade application and Oracle database.

Maintained Metrics reporting SSRS application.

Maintained jobs on command batch scripts and Oracle jobs.

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

Conducted performance tuning according to production issue.

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 applications and technology that serve each business unit by analyzing problems, implementing solutions and developing new procedures surrounding support.

Implemented new 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.

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

Conducted effective communications within the project team

Environment: Oracle PL/SQL 11g/12c, SSRS, SSIS,SFTP, windows, Linux, Visual Studio Team System, CA Workload Automation ESP, PowerBuilder 11.5.

Program Analyst--Contract

Olympus Canada Inc. 2009-2010

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

Development experience of web-based applications using C#, VB.NET, ASP.NET, AJAX, JavaScript, HTML/CSS

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

Maintained the metrics report.

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, Crystal Report, 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:: C#.net, ASP.Net, JavaScript, JSP, HTML, AJAX, MS Office, Windows Vista, Visual Studio 2005, SQL Server, 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: PowerBuilder, ASP/ASP.Net, JavaScript, HTML, Oracel8i/9i, Sybase, SQL Anywhere

Education

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

Professional Training

CMM, CMMI QAI Global Institute Sep 2005

Contact this candidate