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; • Design and develop Framework Manager models and Report Studio reports using IBM Cognos 10.2.2 and Cognos 11• Develop and maintain Reports sourcing from TM1 cubes and Cognos Power cubes.• Cognos system administration including privileges, content managing, reports and Event Studio scheduling, Cognos BI Server upgrade.• Explore Cognos functionalities and implement them to the company's BI environment, such as, Reports Bursting, multiple dispatchers for load balancing. • User training on self-service Analysis Studio and Query Studio.

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 packages and procedures to load data from multiple sources to ODS and use Informatica to dimensional data mart. Monitor and analysis production data ETL loading issues. SQL performance turning for both ETL and reporting. Ensure the timely delivery from China side in good quality.RDS China team was started from scratch since late 2014. As the team leader I achieved to recruit 7 members, the successful code-level knowledge transfer - over 100,000 lines of PL/SQL code from US team, build up the collaboration mode between two sides, and consolidate the standards of process. All these achievements are highly recognized by managers from both sides as well as my team members.

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 quality perspective, lead the discussion of business reporting and analysis, design and coding for data warehouse ETL and tables, generate the BI report with Cognos Report Studio, guide users to build their own reports based on the Cognos FM model and cubes I created, provide quick ad-hoc data service with SQLs (normally response within 1 hour), for example, during company executive meetings, maintain Cognos BI environment, communicate with external auditors (PWC and government) when auditing, and etc. Through the hard work I was the go-to person in the company when any data are requested for both IT and business.In charge of data in finance, sales and risk management of the company, the key of all my work is data, including: Communications and analysis of business users' reports and data requirements in terms of sales, risk management, finance and HR KPIs.  the ETL (mainly PL/SQL procedures) development from source systems to the oracle ODS and data warehouse in daily (automatically scheduled) and monthly (manually triggered) baises. perform monthly business colsure operation for both sales and finance. Fact tables and snapshot tables are genreated during this operation, which was the key for all monthly reports. everyday ad-hoc data extraction from oracle database/data warehouse for all stakeholders for further analysis and reporting. cognos 8 reports generations - over 50 interactive cognos reports.  cognos meta-data (Framework Manager) modeling and OLAP cube (Transformer) development  assisting financial anayst manager using excel for some data analysis reporting to executives.

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 development for external Flex dashboards. Also generate testing data during development. The PIC project was cancelled after 9 months I joined, then I was transferred to Java team to build web application.

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 report generation and ad-hoc reporting support.  Bug fixing of reported system errors and pitfalls.  User communications for new business requests with HTML and Oracle PL/SQL, for example, ACCC pricing project and customer information integration.  Fine tune system performance in terms of SQLs and PL/SQL packages.

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 Business Objects, Brio, Informatica, Oracle PL/SQL, and MS SQL Server. In addition, for APJ Sales Data Mart DCC, not only perform technical delivery but also act as coordinator and communicator.

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 7 BI Series, Hyperion Essbase, Brio, etc. Totally involved 3 projects, namely, the Credit risk management datamart of Bank of Beijing, the data warehousing and BI of Xi'an City Commercial Bank, the reporting platform reconstrucation and migration of Shanghai Pudong Development Bank and related reports developing and implementation.

Master'S Degree, Information Systems And Management

Bachelor'S Degree, Systems Engineering