Candidates About

Ping Xu

SUMMARY

• Expert in Business Intelligence (BI) architecture, solution and implementation
• Vast experience in Extraction, Transformation and Load (ETL) strategy, design, implementation and automation
• Extensive skills in database, data warehouse design and development on SQL Server and Oracle
• Vast experience on integration and interoperability of multiple BI related applications
• Strong analytical skills and excellent interpersonal and professional communication skills
• Highly motivated, result-driven, accurate and quality minded

EXPERIENCE

Senior System Analyst / Business Intelligence Administrator

Thermo Fisher Scientific |  Greater Boston Area

2008 – Present (7 years)

Business Intelligence Data Integration

·         Lead data integration by designing and implementing ETL process for finance and sales data. Role includes gathering business requirements, functional design, process development, testing and deployment

·         Lead re-architect and re-design of existing ETL processes for automation

·         Managing monthly sales data loads from different divisions and regions

Lead Business Intelligence Analyst

·         Lead analyst responsible for the automation of sales data validation reports using MS SSIS and Tableau

·         Designed and developed finance and sales dashboards and reports using Tableau, Cognos and Business Objects

·         Created product line hierarchy visualized map using Tableau

• Corss revenue/sales data analysis between Oracle HFM (Hyperion Financial Management), SAP ERP system and Corp Sales DataMart

Business Intelligence Administrator

·         Business Intelligence application administrator for Cognos, Business Obejcts and Tableau. Role includes installing, configuring, upgrading, migrating BI applications. Managed users, security model setup, performance and 24x7 production support

Business Intelligence Vendor Selection

·         Evaluated several BI visualization reporting vendors. Worked directly with vendor on proof of concept solutions

Principal Business Intelligence Engineer

Brix Networks | Greater Boston Area

2007 – 2008

• Led all technical aspects of Cognos 8 Business Intelligence solutions and implementations
• Designed, developed and supported the overall Cognos framework models
• Installed and configured Cognos 8 Business Intelligence in Windows and Linux environments
• Designed and developed executive dashboards and management reporting to support decision-making.
• Created customizable reporting packages and individual content portals to the specific needs of clients
• Project leader delivering two customer Business Intelligence solution projects
• Worked with Cognos support for developing and managing cases
• Led Cognos8.3 upgrade project, including installation, configuration of all components and created PowerCubes using Transformer

Senior Software Engineer

OpenPages | Greater Boston Area

2004 – 2007

Reporting team leader for OpenPages major Financial Controls Management application

• Responsible for gathering business requirements from cross-functional teams
• Authored and implemented report functional specification and design specification
• Installed and configured the application and Cognos ReporNet, Framework Manager
• Designed and developed  multi-lingual (English, French, German, Japanese, Simplified Chinese, Spanish)

Cognos reports

• Performed unit test, performance test, bug tracking and code review for the reports
• Documented report best practice and created a Report Author’s Guide

Support and training

• Designed, developed and delivered well-defined sales demo
• Trained support, service, sales and education service teams. Wrote supporting documentations
• 24x7 global support

Business Intelligence (BI) application evaluation and deployment.

• Thoroughly evaluated and compared 4 Business Intelligence applications (Cognos ReportNet, BuisnessObjects, Hyperion Performance Suite, SQL Server 2005 Analysis Services) for OpenPages application reporting integration.
• Helped the company to make decision on choosing the best Business Intelligence tool.

• Created the first Dashboard report for OpenPages CommandCenter which lead to dramatic sales increase.
• Integrated Cognos and BusinessObjects report engines into the OpenPages application.

Software Engineer III

Boston Communication Group | Greater Boston Area

2002 – 2004

• Created reports specified by product management and report operations using FOCUS script.
• Developed reports to support existing financial, operational, trend batch and intranet reporting.
• Applied a software development cycle of analysis, coding, testing, documenting and release building for the reports.

• Upgraded Business Intelligence and reporting platform WebFOCUS application from v4.3.5 to v5.2.3 in production. Responsible for installing, configuring and testing iWay server, WebFOCUS application, Oracle 9i data warehouse connections, exporting and importing all online reports.
• Thoroughly evaluated Oracle9iAS Discoverer for future use with Oracle data warehouse and data mart.
• Upgraded and tested EDA server from v3.3.2 to v5.1 in UNIX for production.

Senior Database Engineer

Adero / COLT Internet Group | Greater Boston Area

1999 – 2002

• Designed logical and physical data models for Adero Internet GlobalWise customer care and billing system based on requirements from sales, marketing and business departments.
• Implemented the first version of GlobalWise customer care and billing system with SQL server and Transact-SQL.
• Initiated statistical method for analyzing database and data warehouse size based on collected and parsed intranet log files.
• Developed Oracle PL/SQL and Oracle Reports that support automated running bills (including bandwidth, pageview, flat fee, pre-pop, gigabyte, reseller, streaming, and e-commerce bills).
• Developed online real time reports to access the data in data warehouse.
• Provided bills and usage reports for finance, sales, business and marketing departments using Oracle Report.
• Implemented business and information processes to ensure the data integrity and accuracy.
• Analyzed customers’ usage data to enhance billing method.
• Implemented Colt Stream 1.0 and Colt Edge 1.0 on-site billing and usage report using Oracle 8i and Oracle Report.
• Designed and developed Colt intranet Time Tracking System using Oracle 8i and ColdFusion. This system allows employee to input and track their time spent on each product/project online, and managers to review the details or budget for each product/project online.
• Improved COLT Customer Care website’s front end images using Flash 5 and Photoshop 6.

EDUCATION

• MS in Information Systems, Northeastern University, Boston MA.