Project Manager Developer

Annie Song

Mobile: 647-***-****

Email: *****.***@*****.***

OBJECTIVE To obtain a position as a COGNOS Developer

HIGHLIGHTS OF QUALIFICATIONS11+ years IT experience including Business Intelligence, Enterprise Data Warehouse and Application Developments8+ years practical experience in COGNOS BI Solutions, including Framework Manager, Report Studio,Analysis Studio, Query Studio, Metric Studio, Administration, Transformer Strong knowledge of designing Complex reports, Dashboard using Report Studio and Ad Hoc reports using Query StudioStrong knowledge of Data Modeling, Cube designStrong knowledge about Data Warehouse concepts and methodologyStrong knowledge of Data Warehouse SDLC processes and standardsStrong knowledge of Dimensional modeling and Relational modelingOrganized, efficient, with strong analytical skills and problem solving skillsIBM Certified Designer for COGNOS8 BI Reports (COG-112)IBM Certified Developer for COGNOS8 BI Metadata models (COG-132)IBM Certified Administrator for COGNOS8 BI (COG-122)

TECHNICAL SKILLS

D/W Tools:

COGNOS10,COGNOS8.4/7, SSIS, SSAS, SSRS, Toad, VMware, SQL plus, CVS, Visio, ERWIN4.1/3.15,ClearCase,ClearQuest

Database:

Oracle 9i/ 10g/11g, SQL Server 2000, SQL Server 2005,DB2

Operating Systems:

Windows 98/XP/2000/2003/7, Unix/Linux

Language:

SQL, XML, HTML, JAVA, JavaScript, C/C++, VB.Net, VBScript

PROFESSIONAL EXPERIENCE

Davis + Henderson Limited Partnership Toronto 2010-Present

Role: BI Developer

ResponsibilitiesParticipated in user meetings to analyze and prepare the reporting requirements of usersDesigned and Created Framework Manager Models with multiple Namespaces, calculated columns, filters and Macros from different data source Resolved ambiguous relationships, organized folders, created filters, prompts and calculations according to the Business view Created various SQL for the test cases and also used some User-Defined SQL’s in Framework ManagerCoordinated with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needsCreated and published packages to suit the reporting needs of the usersDesigned and built Power Play cubes using multiple data sources by Power Play transformer and created Power Play reports using the developed cubeUsed Star Schema and Snow flake Schema modeling technique to develop modelsCreated Ad hoc reports using Query studioDesigned Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, sections, page breaks, Master-detail, Drill Through)Wrote with HTML/Java Script in COGNOS report studio reports based on the requirementsDeveloped the Dashboard reports using COGNOS Report StudioCreated Drill- through reports and Customized Reports Data analysis, query writing and designing test case for testing reports Involved in Performance Tuning of the reportsPrepared User manuals, Operational Guides, Planed and Conducted User trainingsInvolved in the COGNOS Administration like creating new Data source Connections and Creating user and groups, handling the deployment of reports, copying from develop server to production server and also handling the user permissions on the packages and foldersParticipated in daily Defect Review & Prioritization meetings with the Business analysts, project managerPerformed data validations, unit testing and preparation of unit test casesResolved issues resulting from user acceptance testing (UAT)Convert report from current Excel/VBA environment to COGNOS reportsUpdate scope statement as necessary during report development Created daily, weekly, or monthly reports according to delivery schedule

Tools: COGNOS10/8, Oracle11g/10g, Toad, SQL Developer, MS office, Win-XP, Win7, VMware, EXCEL

FILOGIX Limited Partnership Toronto Jan 2007-2010

Role: BI Developer

Responsibility:Analyzed the specifications provided by the clients and developed specification documents for reports Created Metadata models, made appropriate joins by resolving ambiguous relationships, organized folder, filters, prompts and calculations according to the Business view and published packages onto COGNOS ConnectionConnected and tested the data source, created database layer, physical layer and presentation layer, defined appropriate relationship between query subjects.Designed and Developed the Framework Manager models and published to server.Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through)Wrote with HTML/Java Script in COGNOS report studio reports based on the requirementsDeveloped the Dashboard reports using COGNOS Report StudioCreated Drill- through reports and Customized Reports with PromptsDeveloped multidimensional reporting using Analysis Studio Scheduled the saving, printing, or e-mail activities for reports Designed and built Power Play Cube using Power Play transformer and created Power Play reports using the developed cube. Performance tuning the reports by analyzing and comparing the turnaround times between SQL and COGNOS Participated in daily Defect Review & Prioritization meetings with the Business analysts, project manager Used Star Schema and Snow flake Schema modeling technique to develop modelsConvert reports from COGNOS Impromptu, Excel, or VBA to develop new reports in COGNOS Update scope statement as necessary during report development Resolve production issues for existing reports Modify or enhance existing production reports Define new data warehouse tables needed for reporting, including gathering requirements, documenting requirements, and user acceptance testing

Tools:COGNOS8.4/.3,Oracle10g,MS-office,Visio,WinXP,VMware,SQLServer2005,EXCEL

BEIDA JADE BIRD GROUP Beijing 2004-2006

Role: BI Developer

Responsibilities Participated in the User meetings to analyze and prepare the reporting requirements Participated in designing the database (physical and logical models) design using Erwin and mapping relations between the tablesForward and Reverse engineered the components of the maintenance management system to implement physical/logical data model of the system using Erwin Data ModelerCreated Metadata models, made appropriate joins by resolving ambiguous relationships, organized folder, filters, prompts and calculations according to the Business view and published packages onto COGNOS ConnectionCreated Impromptu Query definitions as sources data for creating Power Play cubes Created Complex reports with advanced formatting using Report Studio and Ad hoc reports using Query StudioScheduled the saving, printing, or e-mail activities for reports Designed and built Power Play Cube using Power Play transformer and create Power Play reports using the developed cubeParticipated in daily Defect Review & Prioritization meetings with the Business analysts, project manager Used Star Schema and Snow flake Schema modeling technique to develop models

Tools: COGNOS7/8, Oracle9i, MS-office, Visio, Win-XP, EXCEL

Found Technology Beijing 2001-2004

Role: R&D Developer

Responsibilities Designed and developed Bug Tracking System with VB.NET and MS SQL Server Created efficient and logical Oracle databases for electronic commercial system Designed and developed electronic commercial system with Java Created and executed project work plans and revised as appropriate to meet changing needs and requirementsdeveloped architecture, business logic and database structure of the projectCommunicated and enforced coding standardsManaged resources based on project scheduleEnvironment configuration and management, and Software Engineering Data Management

Tools: VB.net, SQLServer2000, Oracle 8/9i, MS-office, Windows2000 Server

EDUCATION & AWARDSMaster Degree in Computer Science, Beijing Business & Industry University 2001COGNOS10 IBM Training 2011IBM Certified Designer for COGNOS8 BI Reports 2010IBM Certified Developer for COGNOS8 BI Metadata models 2010IBM Certified Administrator for COGNOS8 BI 2010Oracle Certificate Associate(OCA) 2010Certificated Software Quality Analyst(CSQA) 2007Certificated Software Test Engineer(CSTE) 2006COGNOS8 IBM Training 2005CMM3 Management Certificated Training 2004Microsoft Certified Professional System Engineer 2000

References Available upon Request

Contact this candidate