John Jiang Email & Phone Number

-Design, development and maintenance of Gifts Loyalty RBC Rewards programs for Royal Bank of Canada. -Automate processes and build data integration solutions using SSIS, such as, Extract Engine for automating exporting files. -Stored procedure/query performance tuning, Database development, ETL, DataWarehouses (OLAP and OLTP), Data modeling and analysis using PowerDesigner.-Analyze, troubleshoot and resolve data-related issues.-Create end-to-end reports using IBM Cognos BI studio.-Agile methodology and SVN/GIT for source control.

Vancouver, Canada Area

-Created the reporting system from scratch, which includes setting the vision, gathering requirements, gaining business consensus, coding, testing, performing evaluations, mentoring development resources(two team members), deliver solutions, training and documentation. -Solved the problems strategically. It refers to being able to look at the larger picture of what reporting is trying to achieve and driving decisions at a higher level. -Developed hundreds of stored procedures/tables/functions/views using SQL Server 2008R2 and 2012 in large volume databases with live sensitive data. -Created and maintained reports using SQL Server Reporting Services (SSRS) and ASP.NET(Crystal Reports) for world's largest retailers including Costco, Walmart, Staples, CVS, etc. The reporting system consists of more than one thousand online and automatic reports based on five different tiers (company, retailer, vendor, consumer and third-party) for different purposes. -Focused on financial billing and audit reports in terms of data accuracy. -Optimized T-SQL scripts and stored procedures to improve report performance. -Generated ad-hoc report/queries for executive/account/marketing/project managers in a timely manner, and communicated technical issues to business leaders and managers in a clear and concise manner. -Worked with Systems Administrators, release managers, Technical Analysts and other technical staff in resolving problems with reports.