Qing Yang Email & Phone Number

Frenchs Forest, Sydney, Australia

• Act as the key ETL and BI developer of the company mainly work on the SQL Server data warehouse ETL and Cognos BI reporting. Details as below:
• Building and maintaining SSIS packages, SQL stored procedures on SQL Server databases for data and ETL requirements for various source systems including JDE, CSV and etc;
• Tuning on any identified ETL process or reports performance issues; Monitor daily ETL (Chained by SentryOne) and fix any fatal issues.
• Write complex SQLs for quick response of ad-hoc data export and reporting requirements by senior management.
• Building quick Data Mart in dimensional model for different business subject areas and create reports and analysis.
• Users' data and reporting requirement gathering and analysis;

Nanjing, Jiangsu, China

Responsible as China team leader and senior engineer for Schenker American's Regional Data Store (RDS) ETL and reporting. Details include: Requirement analysis and discussion with US side. Projects and Change Requests resource planning and solution design. Lead the ETL team for PL/SQL code generation, code change and testing. We use Oracle PL/SQL.

Nanjing, Jiangsu, China

Fullerton Guarantee is a financial company with complete business systems and DW/BI for the support of management decision making and daily business operations. The near 3 years' experience gave me a complete exposure of a DW/BI environment. I took part in setup company's data warehouse standards and models, transaction system design from DW and data.

Nanjing, Jiangsu, China

Responsible for the R&D of the company's Performance Intelligence Center (PIC) product SAP Business Objects component for monitoring telecom equipment performance. Details include, Oracle modeling for tables and views, BO universe creation, BO Web Intelligence reports design, Crystal Xcelsius dashboards design, webi report block web service interface.

Melbourne, Australia

carsales.com.au is Australia's No.1 auto classifieds information provider. The website and associated management systems were used to be built by Oracle mod PL/SQL for both frontend and backend. Job responsibilities:  Support Carsales web applications through issue tracking system in Oracle data and web application environment. HTML and plain-text based.

Shanghai City, China

For the first half year, as a level 4 support I mainly handle user new requirements, change requests and bug fixing of HP’s internal APJ Information Warehouse and Siebel CRM data mart in terms of front-end reporting and back-end ETL. Then I successfully delivered two DW applications in HP's Data Center Consolidation (DCC) Project. Tools used here were.

Shanghai City, China

Amarsoft is a leading solution provider of credit risk management in financial organizations around China. The related data warehousing is also an essential part of the whole solution, as it facilitates the risk avoidance and decision making. My job is mainly about back-end data processing and front-end OLAP implementation. Tools related are PL/SQL, Cognos.

Master'S Degree, Information Systems And Management

Bachelor'S Degree, Systems Engineering