Manager Developer

WICKY HE

** ********* ****., ***********, **, M*W 2K5

416-***-**** *******@*******.***

OBJECTIVE

Seeking a position as a Cognos Developer

SUMMARY

7+ years of total IT industry experience analysis, design, testing, development and implementation of client/server applications4+ years of Cognos 8&10 experience in data modeling(Framework Manager), Cube design(Transformer & Powerplay) and report development(Query Studio, Report Studio and Analysis Studio) as well as system installation, configuration, administration and performance turningExcellent ability to gather and understand business requirements and translate into IT solutions with the use of CognosGood analytical skills along with Cognos development, extensive knowledge with Cognos reporting packages and Complex Report building including List, Crosstab, Drill through, Master-detail, Dashboard reports Expertise in Framework Manager Modeling (Physical Layer, Logical Layer, Business Layer, Packages, DMR) Expertise in relational and dimensional modelingExperience in Transformer model design and Power play cube buildingExperience in data bases such as Oracle 10g/9i,SQL Server 2005/2003Familiar with Data Warehouse project lifecycle including ETL processAbility to meet deadlines and handle multiple tasks, flexible in work schedules, commitment towards learning, possess good communication and interpersonal skills

TECHNICAL SKILLS:

BI Tools and Technologies:

Cognos 8&10 BI Suite (Transformer, Power play, Framework Manager, Query

Studio, Report Studio, Analysis Studio), SQL, PL/SQL, SSIS, SSRS and SSAS

Database: Oracle 10g/9i, MS SQL Server 2005/2003

Applications:

Toad, SQL Developer, (Request Tracker) Ticket System, VersionOne,

MS Word, MS Excel, MS PowerPoint

Operating Systems: Window 2003 Enterprise Server, XP, 2000

PROFESSIONAL EXPERIENCE

Cognos Developer, Openlane Inc., Toronto, September 2011- Present

OPENLANE is a leading Internet-based business-to-business automotive remarketing company. OPENLANE provides a variety of services including closed and open auctions, automated end-of-term and remarketing processes to automobile manufacturers, captive finance companies, lease and rental companies, financial institutions and wholesale auto auctions.

Cognos Reporting is used to generate reports for internal end-users and external client end-users which including: Mercedes-Benz Financial, Toyota, GM Financial, Honda Finance, Ford Motor, Suzuki Motor,, Audi Financial, BMW Financial, GE Commercial Finance, Chase Auto, Daimler Chrysler, MINI Financial, Mitsubishi Motors, Nissan Motor, Porsche, Subaru, Volkswagen Credit and World Omni Financial etc..

Built and maintained Framework Manager models, designed, created and developed reports Created and updated Cognos reports by Report Studio, Cognos Framework Manager, Analysis Studio, and Query Studio( projects: GM Financial Private Label Program; Hyundai/Kia Private Label Program; FinanciaLinx Open Auction (OA) Program etc.)Defined data and user class security for reports and packages(Migration Openlane with ADESA BI Reporting System)Participated in the migration of Cognos 8 to version 10, automated the Cube Creation and migration to Cognos 10Performed system analysis, design, programming, testing, and walkthroughs following SDLC methodology Assisted the business analyst in analyzing and completing reports specifications based on business requirementsDevelops and supports decision support system, including report creation and any form of user data delivery requirementWorked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio

Environment: Cognos 8.4&10 BI Suite (Framework Manager, Report Studio, Query Studio and Analyst Studio), Cognos Power Play 7, Cognos Transformer, Oracle 10g,Toad, SQL Developer,RT (Request Tracker) Ticket System.

Cognos Developer, MPR Consulting Inc., Toronto, December 2010- September 2011

MPR Consulting Inc. is a full service Information Technology solutions provider specializes in designing and implementing Business Intelligence, Planning and Data Management solutions and e-business, systems integration, custom application design and computer programming services.

Project: Guthy-Renker is one of the largest and most respected direct marketing companies in the world, with distribution in 61 countries. Guthy-Renker has discovered and developed dozens of well-loved, high quality consumer products in the beauty, skincare, entertainment and wellness categories.

This project is to develop relational and OLAP models using Cognos8 Framework manager models and develop Dashboards using Report Studio, develop reports using Analysis studio, Perform Administration tasks, design Transformer models, building and maintaining cubes.Participated in the development of user requirements for data to be extracted for reportsUnderstanding of customers needs and providing potential solution and ensure that the solution meets business requirementDeveloped powerful dashboards by setting the channel for global filtering across the reports Implemented Framework Manager security for Data access, Object access and Package accessCreated Cube query package in framework manager and designed Power play models in Transformer, create custom view security apply to cube with best practiceDeveloped drill through, drill up, and drill down reports for the end users for analyzingDeveloped conditional rendering as well as layout reports for easy analyzing and reading of Excel reports Created Master-Details Reports and set Page break for bursting the reports to corresponding departments Applied conditional rendering for hide and seek, alternative colors for Cognos reportsCreated Cognos Reports with Tree Prompts for advanced prompt selection

Environment: Cognos 8.3 BI Suite (Framework Manager, Report Studio, Query Studio and Analyst Studio), Cognos Power Play 7, Cognos Transformer, SQL Sever2005 Datastage 7

Cognos Developer, TDK China Co .Ltd. China, March 2008- May 2010

Interacted with business analyst and project lead to define and confirm reporting data requirements including security strategy, business rules, and translated business requirements into technical specificationCreated Power Cubes for multidimensional analysis in sale marketing subject area Designed models using Framework Manager and published packages to the report ServersImplemented Star Schemas and Dimension Hierarchy in Framework ManagerCreated database layers and business layers, defined appropriate relationship between query subjects in Framework Manager Developed List, Crosstab, Drill through, Master-detail, Chart and complex reports which involved Multiple Prompts, Multi-query, Cubes in Report Studio, Burst Reports Provided sales data and reports for sales and management through Enterprise Data Warehouse integrating operational data with sources of data such as the Order Management, Customer Relationship Management (CRM) system, Customer care, and Purchasing system

Environment: Cognos 8.1 BI Suite (Framework Manager, Report Studio, Query Studio and Analyst Studio), Cognos Power Play 7, Cognos Transformer, MS SQL Server 2005/2003,Oracle 9i Datastage 7

Computer Application/IT Support, JET Ltd., China, September 2001- January 2008Collected information to analyze and evaluate existing or proposed systems/applicationsDeveloped, debugged and maintained applications and routines to meet business needsCreated, defined and maintained technical documentation templatesAdministrated and maintained company's internal systems; Configured and set-up of all new server systems required internally for the company's activitiesFirewall administration and overall responsibility for company IT security Maintained current and accurate inventory of technology hardware, software and resourcesAssisted in the development, implementation and maintenance of a disaster recovery planDocumented and log architecture and configuration implementation and changesSupported users in the use of computing equipment Supported customers for the installation and maintenance

EDUCATION

Data Warehouse -Business Intelligence

Victoria College, Toronto, Canada 2010

Computer Science

JiLin University, China 1998

REFERNCES

Available upon request

Contact this candidate