Summary

Multi-skilled Business Intelligence (BI) Specialist with 7 years of experience in Airline, Telecommunication, Banking, and Healthcare Industries; 5 years of business/system analysis experience in Property & Casualty Insurance Industry.

Skills & Abilities

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, 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, such as Agile Methodology.

Ø  Be the liaison between IT development team and Business teams to gather, analyze, evaluate, and document the business, functional, technical, non-functional, data mapping requirements.

Soft Skills:

Ø  A self-starter and team player with excellent analytical and problem-solving skills.

Ø  Strong analytical and 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.

Professional Experience

American Modern Insurance Group (Amelia, OH)                                                                          Mar 2013 –  Current

American Modern Insurance Group, Inc. provides niche solutions for manufactured homes; rental, seasonal, vacant and owner-occupied homes; collector vehicles, boats, motorcycles; and select commercial lines particularly schedules of rental property. American Modern is licensed in all 50 states and insures more than 1.7 million policyholders.

Business System Analyst

Business Transformation Project - Guidewire (2015-current)

Environment: Guidewire Policy Center/Billing Center/Claim Center

                         Data Warehouse - Oracle

                         ETL - Data Stage

                         BI Tool - Cognos 10.2

Responsibilities:

Ø  Gather, analyze, evaluate, and document the business, functional, technical, non-functional, data mapping requirements.

Ø  Be the liaison between IT teams and Business teams.

Ø  Work with internal and external customers and IT partners (designers and developers) to develop and analyze business requirements and translate them into functional requirements.

Ø  Work with business users to identify/re-engineer business processes and creates models that help analyze business problems.

Ø  Provide support for testing teams.

Ø  Analyze and document the “as-is” and “to-be” business and technology processes to identify gaps.

Ø  Proven ability to follow some form of software development life cycle (SDLC). Apply agile methodology for business transformation project Sprint planning.

Ø  Track, manage, and report issues and scope changes on projects. Closely monitor state rollout progress and adjust schedules accordingly.

Ø  Use workflow, use cases, data flow, etc to document different processes and requirements.

Ø  Strong communication skills, build the good relationship with business and IT colleagues during projects.

Ø  The featured employee on company’s intranet.

Hill-Rom Company Inc  (Batesville, IN)                                                     

Jan 2013 – Mar 2013

Hill-Rom is a worldwide healthcare equipment provider company, which has approximately 6500 employees. The company’s extensive product and service offering include patient care beds, stretchers, therapeutic surfaces and devices, patient flow systems, nurse communication systems, headwalls and facility assessments.

ETQ Data Warehouse Integration

BI data modeler (Contract Position)

Environment: Database-Microsoft SQL Server 2008

                       BI Tool- Cognos 10.1

Responsibilities:

Ø  Requirement gathering and analysis with QA colleagues.

Ø  Design and build metadata models using Cognos 10.1 Framework Manager.

Ø  Build relational and dimensional models based on different reports requirements.

Ø  Testing and maintain data models.

PCCW Solutions Ltd.  (Hong Kong)                                                                                                          Dec 2011 – Mar 2012

PCCW Solutions is the IT and Business Process Outsourcing flagship of PCCW Group, 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).

Systems Solutions Development & Integration

Senior Solution Analyst (Contract Position)

Environment: Database-Oracle 10g

                       BI Tool- Cognos 10.1

                       ETL Tool- Data stage

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.

Cathay Pacific Airways Limited. (Hong Kong)                                                                                        Nov 2008 – Jun 2011

This project was about replacing the Airline’s Cargo 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.

Cargo Revenue Accounting (CRA) System Replacement Project

Analyst Programmer-BI Platform

Environment: Database-Oracle 10g

                       BI Tool- Cognos 8.2

                       ETL-SQL Stored procedure

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.

Convergys Corporation, Cincinnati, OH                                                                                                 May 2007- Sept 2008

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, workflow analysis, data flow analysis and created all related documentation. And also was involved in developing metadata models and constructing canned reports using Cognos 8.

EIS 2.0 Application-Individual Role-based Scorecard / RPM Reporting

BI Developer /Analyst

Responsibilities:

Ø  Conducted As-Is analysis of the 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, workflows, 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 of 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.

Wells Fargo & Co, Phoenix, AZ                                                                                                           May 2006-May 2007

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.

EDW/BI Enhancement Project

Business Analyst (Contract Position)

Responsibilities:

Ø  Proactively communicated and collaborated with external and internal customers to analyze information needs, business requirements and functional requirements, and delivered related documentation.

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

AwareToys, Inc. 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 for data warehouse design.

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

China Mobile Limited, Shenzhen, China                                                                                                  Jul 2003-Jul 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.

Models Education

Illinois Institute of Technology-Stuart Graduate School of Business Chicago, IL                                                      

Sept 2004-Nov 2006

Master of Science in Marketing Communication

South China University of Technology

Guangzhou, China                                                  

Sept 1999-Jul 2003

Bachelor of Science in Electrical Engineering

Awards

Ø  Toastmaster Competent Communicator

Ø  Toastmaster Competent Leader