SUMMARY

• Expertise in Business Intelligence solutions and implementation
• Solid background in gathering business requirements, documenting functional specification and design specification
• Vast experience with database, data warehouse design and development
• Extensive skills in ETL design and development
• Strong analytical skills
• Excellent interpersonal and professional communication skills

TECHNICAL SKILLS

Business Intelligence Tools:

IBM Cognos BI: ReportNet, Cognos 8.1, 8.2, 8.3, 8.4, 10.1, 10.2, 10.2.1 Cognos Workspace, Cognos Workspace Advanced, Query Studio, Analysis Studio, Report Studio, Event Studio, Metric Studio, Framework Manager, Transformer

SAP BusinessObjects BI: 3.1, 4.0 InfoView/Launch Pad, CMC, UDT, IDT, Desk Intelligence, Web Intelligence, Dashboard

Microsoft BI: SQL Server 2005, 2008, 2012 SSIS, SSRS, SSAS

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Administrator

• Administrating Cognos production environment install, configure, upgrade, migrate, manage users, security setup, resolve all technical and performance issues
• Modified Framework models and Cognos reports based on business user's request
• Leading Cognos 10.2 upgrade project installed and configured Cognos 10.2 and migrated/upgraded Cognos 8.3 content
• Created Cognos training document and training Cognos users
• Designed and developed dashboards to audit Cognos systems, users and performacne
• 24x7 production support for Cognos systems and reporting issues
• Worked with IBM support for Cognos technical and upgrade issues

SAP Business Objects administrator

• Administrating Business Objects 3.1 production environment install, configure, upgrade, migrate, manage users, security setup, performance
• Designed and developed reports to audit Business Objects systems, users and performance
• 24x7 production support for Business Objects systems and reporting issues
• Administrated Business Objects 4.0 systems for Thermo Customer 360 project install, configure, upgrade, security model setup, performance
• Worked with SAP support OSS messages for Business Objects upgrade and development issues

ETL architecture, design and development

• Re-architectured, re-designed and automated ETL process for Thermo's monthly sales data load using SSIS source data are Oracle, SQL server, DB2, SAP ECC, SAP BW, CSV and Excel files
• In charging of 80-90 Thermo sales data monthly load and validation, adding new feeds based on requests
• Re-designed and automated SAP ERP/ECC extract based on sales org code and profit center hierarchy using SSIS
• Project lead to prototype the methods directly extract data from SAP BW through BW Open Hub Service
• Prototyped extracting SAP BW data using Cognos setup scheduled Cognos job to deliver BW data to a shared drive, then trigger SSIS program to load data to the destination

Report/Dashboard design and development

• Always explore new BI features from newly released BI tools to enhance visualization and performance of the report/dashboard
• Created Cognos 10 sales active reports based on country/region/division and deployed to iPhone and iPad
• Designed and developed sales dashboards comparing three years sales monthly by region, country, division using Cognos
• Created daily, monthly dashboards to audit Cognos and Business Objects systems and users
• Created queries/reports/dashboards based on the business user's request
• Created Cognos reports based on SAP BW data sources
• Prototyped Cognos reports based on mutiple FM models
• Designed and devleoped Cognos report based on the data from FM model and MS Excel data

Confidential

Principal Business Intelligence Engineer

• Provided leadership in all technical aspects of Cognos 8 Business Intelligence solution/implementation for BrixView.
• Designed, developed and supported the overall Cognos framework model.
• Installed and configured Cognos 8 Business Intelligence in Windows and Linux environment.
• 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.
• Lead Cognos8.3 upgrade project, including install, configure all components, creating PowerCubes using Transformer, setting up automatic rebuild the PowerCube and automatic update of the PowerCube connection. Evaluating Cognos ETL tool Data Manager.

Confidential

Senior Software Engineer

Reporting team leader for OpenPages major Financial Controls Management application release.

• 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 200-page Report Author's Guide.

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.

Support and training

• Designed, developed and delivered well-defined sales demo.
• Trained support team, service team, sales team and education service team. Wrote supporting documentation.
• 24x7 global support related to reporting issues.

Confidential

Software Engineer III

• 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.

Confidential

Senior Database Engineer

• 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.

Confidential

Software Engineer

• Developed WPP Wireless Prepaid Cellular Phone Billing Application. Responsibilities included writing Oracle PL/SQL stored procedures with software logic and interact with Oracle 7.x.
• Integrated Motorola HLR Triggers Protocol into ODC's SCE Service Creation Environment application. Wrote UNIX scripts to perform integration test in UNIX environment with MHTP server simulator.
• Designed and developed Meetme Conference telephony application prototype for company R D.

Confidential

Database designer

• Designed and implemented a student registration process application using Microsoft Access and Word.
• Created Microsoft Word's macro through ODBC to get information from Access for different form letters.
• Provided database related technical support for Graduate School of Engineering staff.