Multi-skilled Business Intelligence (BI) Specialist with 7 years of experience in Airline, Telecommunication, Banking, and Retail Industries.

SUMMARY

Technical Skills:

• Worked through the full life-cycle of several BI/DW projects, from requirement gathering, planning, designing, development, to testing, deployment, maintenance and support.
• Expertise in designing, implementing and delivering BI architecture, framework and solutions to businesses by using BI tools and techniques.
• Hands-on experience in writing SQL, PL/SQL scripts, stored procedures, and views in support of BI applications and reporting needs.
• Strong data analysis and modeling ability to translate business requirements into relational or dimensional data model structure.
• Solid knowledge and experience in designing, developing and maintaining metadata layers for BI applications, mainly using Cognos Framework Manager and BO\'s Universe.
• Expertise in constructing various types of reports, using BI reporting tools such as Cognos Report Studio.
• Solid knowledge of relational and dimensional database concepts, OLAP cubes, Data Modeling, Query Writing, Report Development, and Oracle Data Warehouse Architecture.
• Extensive knowledge of Software Development Life Cycle (SDLC) with different types of models and methodologies, Data Management Methodology, and Business Process Re-engineering (BPM).

Soft Skills:

• A self-starter and team player with excellent analytical and problem-solving skills.
• Strong written and oral communication skills.
• Strong presentation and interpersonal skills, act as the liaison between business unit and IT.
• Able to prioritize and execute tasks under pressure and proactively in a fast paced environment with multiple deadlines.
• Experience working in team-oriented, collaborative environment.

TOOLS AND TECHNOLOGIES

• Business Intelligence Tools: Cognos 10.1., Cognos 8 BI v8.3 (Framework Manager, PowerPlay Transformer, Report Studio, Analysis Studio, Query Studio)
  Brio Intelligence 6.5 (BrioQuery)
  Business Objects 6.5/5.1
• Programming Languages: SQL, PL/SQL, JAVA, C#
• CASE Tool: UML, Data Flow Diagram, ER Diagram, SSADM, MS-Visio, MS-Project, MS-Office Suite, IBM Rational Requisite Pro
• Data Modeling Tool: ERwin, Cognos Framework Manager, B.O. Universe
• Web Design Tool: Macromedia Suite-Dreamweaver 8/ Fireworks 8/ Flash HTML, XML, CSS
• Development Methodologies: SDLC, Waterfall Model, Spiral Model, OOAD, OOP, RUP (Rational Unified Process), RAD (Rapid Application Development), XP (Extreme Programming)
• Database Platform: Oracle RDBMS10g/11g, SQL Server 2000, MS-Access, Oracle Enterprise Manager

PROFESSIONAL EXPERIENCE

Confidential (Hong Kong) Dec 2011 – Mar 2012
Systems Solutions Development & Integration
Senior Solution Analyst

Confidential is the IT and Business Process Outsourcing flagship of Confidential, the premier telecommunications provider in Hong Kong. This project was for Hong Kong Customs and Excise Dept. Intelligence Unit – Central Information Repository System Data Warehouse (CIRS-DW).

Responsibilities:

• Customize Cognos UI based on Customs\' special needs, especially security concerns.
• Troubleshooting Cognos 10.1 development issues, performance tuning, and also doing some administrative jobs, such as user access permission settings.
• Design and develop semantic layer, metadata, dimensional models for reporting and analysis usage.
• Design, code, test and document dynamic reports and dashboards.
• Involved in Load Test, Stress Test and UAT test.
• Cognos skill training and knowledge transfer to some co-workers and users.

Confidential (Hong Kong) Nov 2008 – June 2011
Cargo Revenue Accounting (CRA) System Replacement Project
Analyst Programmer-BI Platform

This project was about replacing Confidential Revenue Accounting (CRA) system with web-based vendor product for Financial Service Dept. I was responsible for setting up BI Platform and providing technical direction and expertise to facilitate end users to make better business decisions and improve their daily operational performances.

Responsibilities:

• Gathered and analyzed business requirements to identify and understand source data systems. Performed data analysis, translated business requirements into technical specifications, and proposed BI solutions to meet the business needs.
• Designed and developed different levels of physical/logical data models using Erwin, and also built metadata layers using Cognos Framework Manager to serve different reporting needs.
• Created and maintained all the BI related Extract, Transformation and Loading (ETL) jobs by writing custom programs, views and stored procedures in Oracle PL/SQL scripts.
• Worked with business analyst to ensure that data entry, retrieval, change and delete functions meet business requirements for the project completion.
• Worked closely with the internal team (HK and GZ) and vendors (India) to understand the current reporting system/tools, customer reporting process, and overall reporting needs.
• Acted as the report application expert and administrator, using Cognos Report Studio to develop and ensure up-to-date customer reports and report enhancements. Continually defined, designed, tested, and deployed new reports.
• Worked with senior managers to define performance management requirements and then translated them into graphical reports/dashboards.
• Be responsible for end-user training on BI platform and provided technical support through all the release cycles.
• Developed, maintained, monitored and tuned performance of the data mart database.
• Performed Cognos administrative tasks, such as setting up user, granting access right, and security issues. Troubleshoot Cognos problems, diagnosed and resolved application bottlenecks and tuned for performance.
• Supervised the BI tool selection process (Cognos vs. Brio), including the development of the Request for Information, Proof of Concept and evaluation documents.
• Involved in various implementation tasks, such as UAT and post-cutover support.

Confidential, Cincinnati, OHMay 2007- Sep 2008
EIS 2.0 Application-Individual Role-based Scorecard / RPM Reporting
BI Developer /Analyst

This project was about integrating information workflow by applying Individual Role-based scorecards, which can tie to employee\'s job function and performance. And I was mainly responsible for business process re-engineering, work flow analysis, data flow analysis and created all related documentations. And also was involved in developing metadata models and constructing canned reports using Cognos 8.

Responsibilities:

• Conducted As-Is analysis of current system, identified business problems and opportunities, performed feasibility studies and proposed several BI solutions to the steering committee.
• Created detailed requirements documentation, including data flows, work flows, use cases, business rule assumptions, report samples, logical data models and other details required to translate business needs into high-level technical specifications to be implemented by the development team.
• Performed thorough and detailed data analysis to understand the quality of the source data and determine the appropriate logical data model for the implementation into the data warehouse.
• Collaborated with business team to re-design key business processes using use cases, workflow diagrams and data flow diagrams in order to improve business performances.
• Partnered with the data warehouse architect to ensure the model developed integrates well with the overall model for the data warehouse.
• Worked closely with ETL developers and DBA to design and develop dimensional models; and prepared metadata models using Framework Manager for reporting purposes.
• Participated in constructing canned production reports for RPM professionals with report authors.
• Be responsible for validating technical designs created by developers against functional specifications.
• Developed test cases and plans, and assisted with system testing.

Confidential, Phoenix, AZ May 2006-May 2007
EDW/BI Enhancement Project
Business Analyst

With the expansion of the banking business, more and more new functions need to be integrated into the existing EDW. This project was about consolidating existing and newly added data warehouse and data mart assets into the new EDW infrastructure. I was responsible for requirements analysis, needs assessment, cost-benefit analysis, and alternative analysis, and also involved in establishing the logical foundational data model for the enhanced EDW.

Responsibilities:

• Proactively communicated and collaborated with external and internal customers to analyze information needs, business requirements and functional requirements, and delivered related documentations.
• Collaborated with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Performed gap analyses between current and future applications; conducted feasibility studies, cost and benefit analysis, and business impact of the new application.
• Assisted project manager to do the project planning, such as defining the scope of the expected new system, identifying the resources, assigning responsibilities to teammates, and making the project schedule using gantt chart.
• Work closely with users and DBA to establish the logical foundational data model for the enhanced EDW.

Confidential Chicago, IL Nov 2005-May 2006
CRM/Marketing Solution (Internship)
Business Analyst

Responsibilities:

• Worked with CRM consultants to create CRM strategies and implementation plan; provided technical support from data warehouse design\'s perspective.
• Supported the CRM tactics by re-designing some key dimensions, such as customer dimension table, combined customer data from multiple data sources in order to provide single, integrated view of each customer.
• Deployed several web-based applications, such as online catalog/ inventory, which provides online detailed information for all the products.

Confidential, Shenzhen, ChinaJuly 2003-July 2004
Business Objects Developer

I was responsible for the design and development of reporting and analytic ability of the data warehouse. Additionally, I assisted users to use B.O. to do various ad-hoc queries and analysis.

Responsibilities:

• Created and maintained multiple Universes, Classes, Objects and Hierarchies for multidimensional analysis in Business Objects Designer.
• Worked with business analysts to resolve inconsistencies using Aliases/Contexts to maintain Universe Integrity.
• Be responsible for generating different types of ad hoc queries and professional sales/ financial reports using Business Objects.
• Assisted sales managers to analyze key reports, using B.O. features like slice and dice, dill up/down/thru, prompts and filters, etc.
• Applied data mining skills to discover customer buying patterns, in order to help target valued/potential customers.
• Designed and developed OLAP cubes for optimizing reporting.

EDUCATION

• Master of Science in Marketing Communication.
• Bachelor of Science in Electrical Engineering.