Summary

Senior COGNOS Developer with extensive experience in full cycle of COGNOS BI reporting, Framework Manager modeling, Oracle 11g Database, and COGNOS administration. Hands-on experience with PL/SQL, Toad, Report Analysis Query Studio, Active Pages, Workspaces, DMR, plus strong analytical skills and project leadership experience in-depth knowledge of Medical and Financial applications detail-driven solution-oriented with multi-tasking, planning, and organizational skills. Extensive experience in translating user business requirements to technical specification and agile development methodology.

TECHNICAL SUMMARY

PROFESSIONAL EXPERIENCE

Developed and maintained COGNOS reports, data models, and Oracle SQL scripts for many applications. Performed COGNOS administrator role to manage users/groups/roles for objects and capabilities. Planned and implemented COGNOS upgrade installation and configuration from 10.1 to 10.2.1 in Linux servers of DEV/TST/PRD environments. Created Dash Board and reports to monitor COGNOS Audit database. Transitioned relational data models to DMR for drill down reports.

• Created Dimensional Data Model from Data Warehouse in Framework Manager. Developing complex QA reports in
• COGNOS 10.1 for department of Enterprise Quality Assurance. Assisted data mapping and ETL process using Informatica. Participating team meeting for project progress.

Developed and maintained COGNOS and BO reports, data models, and complex Oracle SQL scripts for a Clinical Trial Application Systems. Created and maintained Logical Data Models and SQL scripts for COGNOS reports.

COGNOS Report Development Administration

• Developed COGNOS reports from collecting user requirements, building data model/packages, developing reports, performing UAT, migrating packages/reports from DEV, TST, then PRD.
• COGNOS reporting technique included Report Studio, Query Studio, Analysis Studio, LIST, Crosstab, Master Details, Drill Through, Repeater, Scheduling, Bursting, Grouping, PageSet, Pagination, Cascade Prompt, Foreign Languages, and Conditional Formatting.
• Framework Manager data modeling included Data Source connection, Database view, Business view, Dimensional view, Determinants, Hierarchies, Cubes, DMR, MDX, Star Schema, Scope Relationships, and Package publishing.
• COGNOS administration experience included COGNOS 8.4 installation, COGNOS configuration, IIS, OpenLDAP, Content Administration, Dispatchers and Services, Performance Tuning, SDK in VB6, Providing Report Access URL for Applications, Report versioning, Oracle 11g installation, COGNOS samples installation.
• COGNOS documentation included creation of user requirement specification, E/R diagrams, logical data model, reporting standard, report/model check-in/check-out guidelines.
• Oracle database experience included installation, PL/SQL, Materialized View, Functions and Procedures, Packages, Triggers, Commit Rollback, Toad, Data Modeler, Normalization, Functional Dependency, Outer Joins, Dimensional Model, and Star Schema.
• COGNOS 10 experience included Active Reports in self-contained mht format, Workspace, Workspace Advanced, Transformer PowerPlay.
• Experienced knowledge of RDBMS, Windows 2003/2008 servers, Unix Shell, COGNOS Data Manager.
• Project Management experience used Agile Scrum Methodology, Team Foundation Server, and TeamPulse to trace project progress and team performance, SharePoint 2010 for centralized source control and sharing.

Business Objects WEBI Report Development

• Reproduced COGNOS reports in SAP BusinessObjects using Webi XI and Crystal Reports.
• Reproduced Framework Manager data models in BO Universe using Universe Designer.
• Coordinated with users, quality assurance, and IT to perform validation test of new reports.
• Led a project team for the conversion of COGNOS to WEBI reports.
• Lead a team comprised of users, QA, QC, and DBA to support Application Systems and Database upgrades.

• Led a team that supported month-end closes of financial data for 200 international hotels.
• Supported Accounting Systems running against Oracle database in all international hotels.
• Developed guidelines for international hotels to assure systems and database were running healthy.
• Identified performance impacts on the remote access infrastructure. The scope of evaluation included networking, application environments, terminal servers, Oracle database, and UNIX servers.
• Created Database Disaster Recovery plan and provided training for all international hotels.
• Created team budget, managed actual expenses and provided forecast.
• Provided and implemented backup/restore procedures for databases.
• Led a team to maintain and support 130 financial COGNOS reports for Ritz Carlton hotels.
• Used IBM DataStage ETL to load external CSV data files into Oracle data warehouse defined the data process flow to populate the data automatically using Maestro jobs.
• Generated weekly and monthly COGNOS reports bundled in PDF file and delivered to users' mailboxes.
• Developed Oracle SQL scripts to analyze and identify data accuracy.
• Redesigned the data model in Framework Manager to better align with the business process, data load, and report performance.
• Developed project plans to estimate timelines assess impacts, assign resources, and manage the progress during implementation.
• Provided support of financial data month-end close for international hotels. Created tools to help increase the accuracy and facilitate the process of month-end close and year-end budget process.
• Collected requirements, analyzed, designed, developed, implemented, deployed, and supported company customized general ledger, accounts payable, and budget applications.
• Designed and created software components and modules to implement various functionalities, using Microsoft .NET framework and development tools such as VB.NET.
• Developed a budget application tool allowing users to import, input, compare, allocate, and export budget data in a format ready to be loaded into other financial systems. The application tool uses Microsoft Access as the database and VB6.0 for the interface. User manual were created when distribution.
• Designed a chart of account COA validation and translation tool that provided for the management of account mapping. The application tool used Microsoft Access as the database and VB6.0 for the interface.