Manager Data
Resume:
William Ngai
*******@*****.***
Objective
Seeking a challenging position as a Developer/Architect in Cognos 8 series, ReportNet 1.x, Impromptu to
further add value with my skills while making a positive contribution to the organization.
Professional Summary
5+ years of software development life cycle (SDLC) including requirements gathering, analysis,
design, development, testing and maintenance with specialization in Cognos Business
Intelligence Tools
Extensive experience in BI Report Authoring using Cognos 8 Suite, Cognos Reportnet 1.1,
Cognos Impromptu, Cognos Transformer, Cognos Power Play
Strong Experience in Installation and Configuration of various Cognos tools like Cognos 8 suite,
Cognos Reportnet 1.1, Cognos Impromptu etc.
Proficient in designing and creating metadata models in Framework Manager as per the
business requirements and specifications.
Skilled in creating Star Schema groupings and resolving Fact to Fact Relationships.
Proficient in design, development and maintenance of Report Studio reports.
Proficient in publishing packages to Cognos Connection and setting up the appropriate security
settings for the different user groups.
Installed and Configured Cognos 8 series.
Automated Reports and generated Documents using Scheduler.
Fine-tuned models in Framework Manager and Power Play Transformer cubes to optimize
performance.
Published reports to Upfront using Power Play Enterprise Server and IWR.
Provided extensive End-User Training and Support for Cognos Tools.
Possess strong working knowledge of trouble-shooting and problem analysis methods for
technical applications from end user perspective.
Excellent communication and interpersonal skills.
Experience in designing Business reports according to the needs of various Business end users
Experience in developing Dashboards in Cognos 8
Implemented security for Data access, Object level access and Package access
Created User Groups, Roles to implement the Cognos Security
Experience in development of various kinds of reports like List, Cross tab, Chart, Repeater etc in
Cognos 8, Reportnet 1.1 and impromptu which involved Multiple Prompts, Filters, multi-page,
multi-query reports against multiple databases
Experienced in extracting data from ODS and data warehouse while building models in the
Framework Manager
Experienced in using OLAP cubes as a source for Framework Manager Models
Migration of reports from Cognos Impromptu to Cognos 8 and Cognos Impromptu to Reportnet
1.1
Working experience in Oracle 8i/9i, SQL, PL/SQL, Windows XP/2000/98/95
Developed PL/SQL jobs including Packages and Procedures to load data from data sources to
data ware house
Hands on experience in building OLAP Models and Cubes in Cognos Power play
Experience in Trouble Shooting and debugging the code of the Cognos Reports
Hands on experience in preparing detailed Report Technical Design documents
William Ngai
*******@*****.***
Experience in developing Project process related documents as per the CMMi standards
Excellent communication and interpersonal skills and ability to work effectively in a team as well
as individually
Technical Skills
Programming C, C++, Java, SQL, pl/SQL, Perl Script
Operating Systems Windows /95/98/NT/2000/XP, Linux
Database Oracle8i/9i/10g, MS Access, MS SQL Server, DB2
Reporting Tools Cognos 8.x BI, Cognos ReportNet, Framework Manager, ReportStudio, Query Studio, Metric
Studio, Cognos Connection, Impromptu, PowerPlay, Powerplay Transformer, Metrics Studio,
Impromptu Web Reports (IWR), Upfront, Cognos Access Manager, Architecture, Cognos
Script Editor, Cognos Configuration, Visualizer, Scheduler, Power Prompts.
ETL Tools Informatica Power Center 6.1
Web Technologies HTML, XML, JavaScript, VBScript
Web Servers Apache Tomcat, IIS, Netscape Enterprise Server 4.0
Networking LAN, TCP/IP, SMTP, POP3, FTP, Telnet
Processes RUP, WaterFall Model, JAD, XP
Work Experience
Cardinal Health, Columbus, OH
Feb 2008 – Present
Sr. Cognos Architect
Cardinal is the second-largest drug distributor in the United States, and is the largest provider of
specialized nuclear medications used to treat cancer and heart disease. The project involved developing an
architectural solution for complex dashboards and reports for the Marketing Department. The project also
involved designing OLAP cubes for statistical analysis and future projections.
Summary of Tasks
Gathered and analyzed user requirements.
Analyzing the specifications provided by the clients
Understanding the functionality of the reports
Installation and Configuration of Cognos Impromptu Admin Ver7.3 and Cognos 8.3 software
Installation of migration utility tools
Migrated catalogs and reports from Cognos 7.3 to Cognos 8.3
Interaction with the Management and Development teams for creating the Framework Model
Designed the model according to the business requirements by creating a Presentation Layer
Worked extensively on creating the model and publishing the package on cognos connection for
reporting purposes
Providing Report and Query Studio access to Super Users, Developers, and Sustain groups to
continue ongoing report development
Verified relationships and cardinalities of the different tables imported from the data sources.
Created Star Schema grouping to enhance the query processing time and organize the model.
William Ngai
*******@*****.***
Updated the Framework Manager Model by adding new query subjects and resolving ambiguous
joins.
Carried out Bursting of reports to specified user groups in Cognos Connection.
Created ad hoc reports using Query studio and complex reports using Report Studio.
Developed Cascading prompts to filter data dynamically and conveniently locate the data the
users are trying to locate.
Created Dashboards on multi-page portal pages and setup communication among the different
portal pages.
Created Drill-down/Drill-up reports from Dimensional packages to allow users to switch between
lower-level data sets and higher-level data sets.
Created metrics dashboards and scorecards to compare operational performance to strategic
plans.
Used metrics designer to update extracts in the Metric Store.
Developed Master-Detail relationship reports to combine two reports into one using a common
query item as the link between the reports.
Created complex cubes in Transformer with dimensional filtering and complex calculations
(Actuals vs Target comparisons).
Created cube groups and custom views in Transformer as per the client’s needs.
Created special relative time categories, manual levels, sub-dimension and exception
dimensions.
Created complex Analysis by using slicers and member functions in Report Studio.
Applied Conditional Formatting to highlight exceptional data for the main business indicators.
Created Cross Tabs, Nested Cross Tabs, Lists and Charts.
Developing Business reports as per the requests from Business end users
Developing specification documents for reports as per client requirements
Design & development of the reports using Cognos Impromptu/Cognos 8
Design & development of multiple reports using various templates like list reports, cross-tab
reports and chart reports
Interacting with the End users on a regular basis for resolving issues pertaining to the reports
Performance tuning by analyzing and comparing the turnaround times between impromptu
reports and reportnet reports
Environment: Cognos 8.3 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos
Connection), Transformer, Power Play, Metrics Studio, Metrics Designer Cognos Series 7.3 (Impromptu,
IWR, Power Play), Oracle 10g, Windows XP, Toad, Active Directory.
WellPoint, Indianapolis, IN
Sept 2006 – Nov 2007
Sr. Cognos Architect
WellPoint, Inc. is the largest health benefits company that delivers a number of leading health benefit
solutions. The project I was involved in was to install and configure Cognos 8 series, and building and
developing of models, cubes, and reports. The project also involved performing data analysis on
functional report requirements, recommending solutions for development, and developing reporting
objects and targets.
William Ngai
*******@*****.***
Summary of Tasks
Gathered and analyzed user requirements.
Involved in Installation and configuration of Cognos Series 8.2
Installed ReportNet to Cognos 8 migration tools.
Migrated existing reportnet report and model to Cognos 8.2
Involved in creating OLAP hierarchy, dimensions, formulas & power cubes using Transformer
Used Power Play Enterprise Server to deploy Powerplay reports, cubes and created necessary
settings to drill through from cubes
Created packages using Frame Work Manager for reporting in Report Studio and Query Studio
Created Ad hoc and canned reports using Cognos Report Studio, Query Studio and Cognos
Power Play
Created drill through reports for drilling through from PowerPlay Cubes to Report Studio
reports
Created complex reports involving Prompts in Report Studio
Created Dashboards in Report Studio involving a mixture of data coming from both the database
and PowerPlay cubes
Involved in Cognos administration activities like creating and maintaining user groups, exporting
cubes, packages and reports from Dev to Prod environments, scheduling cube builds, publishing
the cubes on PowerPlay enterprise server, scheduling reports etc
Developed different types of Reports using Cognos 8.2 and Framework Manager.
Created complex reports using Report Studio including conditional blocks, conditional
formatting, stored procedures, and materialized views.
Created Fact and Dimension builds in Informatica.
Scheduled the ETL jobs to run on a timely basis.
Gathering the requirements from the client and preparing the prototype.
Studying the business requirement document, interact with the client and prepare the system
design document.
Involved in the installation and configuration of ReportNet 1.1 and up gradation of existing
Cognos EP series reports to Cognos8
Prepare the reports using prompts, cascading prompts, filters and variables in report studio.
Developing Cognos 8 reports and fixing the defects in migrated reports from ReportNet to
Cognos 8.
Designing Daily, Weekly and Monthly Scorecards based on the Metrics and Dimensions and
enhancing them for different shifts.
Designing Scorecards with color coding.
Designing drill through Scorecards and assigning different charts to the reports.
Creating reports(Simple list, Grouped list, Cross tab and Grouped Cross tab)
Conversion of crystal reports into Cognos Reportnet.
Writing of SQL statements required to run the report faster.
Comparing the report data with database using TOAD.
Responsible for managing the Cognos security strategy and provide BI Audit reports.
Involved in end user training and Documentation.
Heavily involved in creating Technical Design document to describe the detailed
architectural design for the system which is based on input from the Infrastructure and Design
requirements.
William Ngai
*******@*****.***
Environment: Cognos 8.2 (Report Studio/Query Studio/Analysis Studio/Framework Manager),
Transformer, PowerPlay, ReportNet 1.1, PL/SQL Developer, Oracle 10g, Oracle9i, MS Access/Excel,
Access Manager, SQL Server 2000/2005, Informatica Power Center 6.1.
Dow Chemical, Midland, MI
May 2005 – August 2006
BI Developer/Business Analyst
Dow is a diversified chemical company that combines the power of science and technology with the
“Human Element” to constantly improve what is essential to human progress.The main objective of project
was evaluation, installation and development of end user reports for the finance department.The project
also involved performing data analysis on functional report requirements, recommending solutions for
development, and developing reporting objects and targets.
Summary of Tasks
Involved in the entire project life cycle from evaluation, installation and development of end user
reports.
Gathered and analyzed user requirements.
Installed and Configured Cognos 8 series.
Used Framework Manager to model metadata from different Oracle data sources for use in Report
Studio and Query Studio.
Created both Dimensional and Relational models in Framework Manager and published the
packages to Cognos Connection.
Verified relationships and cardinalities of the different tables imported from the data sources.
Created Star Schema grouping to enhance the query processing time and organize the model.
Created shortcuts in the business view to resolve recursive (loop joins) relationships and multiple
valid relationships in the model.
Updated the Framework Manager Model by adding new query subjects and resolving ambiguous
joins.
Added certain attributes to the AD LDAP to allow for certain parameters to be visible in Cognos.
Carried out Bursting of reports to specified user groups in Cognos Connection.
Created ad hoc reports using Query studio and complex reports using Report Studio.
Designed Prompt pages with interval prompts on them to efficiently locate trends in business charts
with respect to time.
Developed Cascading prompts to filter data dynamically and conveniently locate the data the users
are trying to locate.
Created Drill-down/Drill-up reports from Dimensional packages to allow users to switch between
lower-level data sets and higher-level data sets.
Developed Master-Detail relationship reports to combine two reports into one using a common query
item as the link between the reports.
Created Conditional Formatting to highlight exceptional data for the main business indicators.
Created Dashboard Reports, Cross Tabs, Nested Cross Tabs, Lists and Charts.
Created Conditional Block reports to dynamically hide or show report objects and provide the end
user the option to view the data in different formats.
William Ngai
*******@*****.***
Created appropriate User classes, users, database signons in Access Manager to provide different
levels of authentications.
Scheduled reports in Cognos Connection to use off peak hours effectively.
Built multi-dimensional cubes from multiple data sources including both structural and transactional
data sources using Transformer.
Utilized the LDAP browser to quickly browse through records in the LDAP tree.
Created appropriate manual levels and special categories in the Transformer model.
Declared shared levels into unique levels in the dimensional model so that transformer can properly
relate the data between the different data sources.
Externalized Framework Manager query subjects into IQD files to be used in Transformer and
Power Play for reporting purposes.
Created Sub cubes for user groups using Power Play.
Provided End User training and Support for Cognos Connection, Query Studio, and Report
Studio.
Environment: Cognos 8.1 (Report Studio, Event Studio, Query Studio, Analysis Studio, PowerPlay,
Transformer, Access Manager), LogiXML, Oracle 8, Toad, DB2, SqlServer, PL-SQL, MS Project,
Active Directory.
Lowe’s, Mooresville, NC
August 2004 – March 2005
Cognos Developer/Business Analyst
Lowe's is one of the largest providers of home building supplies throughout North America. Lowe's
operates more than 1,650 stores in the United States and Canada.The main goal of the project was to
provide the decision makers insight on to how they are performing interms of Profit and loss, Inventory,
and Sales.
Summary of Tasks
Gathered and analyzed user requirements.
Modeled business data according to the business rules and policies.
Worked directly with end users gathering reporting requirements.
Created Multi-dimension cubes using Power Play Transformer to create reports in Power Play.
Inserted appropriate manual levels in the Transformer model.
Performed Model and Power Cube maintenance by deleting inactive categories and matching source
and model columns.
Generated Business mix reports, Trend over time reports, Forecast reports and Variance reports using
Power Play.
Participated in discussions with the senior management to better understand the business
requirements.
Implemented drill-through from Power Play cubes to Impromptu reports.
Created Impromptu catalog and HotFiles in order to generate various group reports.
Developed data specific Impromptu reports with various filter conditions.
Extensively used cascading prompts, drill-through, sub-reports, summaries, conditional formats,
grouping and association features of Impromptu to generate efficient and user-friendly reports.
Created Impromptu catalog and hotfiles in order to generate reports.
William Ngai
*******@*****.***
Extensively used cascading prompts, drill-through, sub-reports, summaries, conditional formats,
grouping features of Impromptu to generate efficient and user-friendly reports.
Published Impromptu reports using Impromptu Web Reports server to Upfront Web Portal.
Modified already created Impromptu Catalogs to reflect changes in the business.
Created multidimensional cubes using Impromptu Query Definition files and Multiple Data Sources
in PowerPlay Transformer.
Implemented drill-through from PowerPlay cubes to Impromptu reports.
Created Trend Over Time Reports and Forecast Reports using PowerPlay.
Time scheduled the reports publishing using the Cognos Scheduler.
Created joins in Impromptu for metadata information in the catalogs.
Developed Impromptu query definition files and imported them into Transformer for creation of
cubes.
Provided End User training and Support for Power Play.
Environment: Cognos 7.1 (Impromptu, PowerPlay, Transformer, Upfront, IWR, PPES, Scheduler), SQL
Server 2000, Oracle 8, Windows Server 2003.
Time Warner, Charlotte, NC
July 2003 – June 2004
Cognos Developer/Consultant
Time Warner Inc. is a leading media and entertainment company, whose businesses include interactive
services, filmed entertainment, television networks and publishing. The main objective of project was
evaluation, installation and development of end user reports for the finance department.
Summary of Tasks
Worked directly with end users gathering reporting requirements.
Participated in discussions with the senior management to better understand the business
requirements.
Created Impromptu catalog and HotFiles in order to generate various group reports.
Developed data specific Impromptu reports with various filter conditions.
Extensively used cascading prompts, drill-through, sub-reports, summaries, conditional formats,
grouping and association features of Impromptu to generate efficient and user-friendly reports.
Created joins in Impromptu for metadata information in the catalogs.
Developed Impromptu query definition files (IQDs) and imported them into Transformer for creation
of cubes.
Created Sub cubes for user groups using PowerPlay Transformer.
Implemented drill-through from PowerPlay cubes to Impromptu reports.
Published Impromptu, PowerPlay reports and cubes to Upfront using IWR and PPES.
Time scheduled the report publishing using the Scheduler.
Optimized the cube performance by auto-partitioning and caching.
Scheduled reports to use off peak hours effectively.
Setup and maintained user ids, passwords and user classes using Access Manager.
Provided End User training and Support for Impromptu and PowerPlay.
William Ngai
*******@*****.***
Environment: Cognos EP Series 7.1 (Impromptu, PowerPlay, Impromptu Web Reports, PowerPlay
Enterprise Server, Transformer, Upfront, Access Manager), Oracle 8, Windows 2000
Education
Wilfrid Laurier University
Honours Bachelor of Science in Computer Science
Contact this candidate