COGNOS ENGINEER Resume Goleta, CA - Hire IT People

TECHNICAL SKILL SET:

Cognos 8 & 10
Analysis/Event/Metric/ SQL Server 2000
Windows XP
Vista
Excel
Word
Query/Report: Oracle 9i/8i
DB2
Windows Server 2003 Access
SharePoint
Studios/Cognos Connection
Teradata
Informatica and Windows 7
Unix Project Manager
Visio
Framework Power Center 6.x/5.x HTML and XML
Manager/Transformer
IBM Cognos Development Suite
QlikView
Oracle and Netezza Databases
ServiceNow
Salesforce
Kintana/PPM Case Tracking
Consona/Knova Knowledge Base
Centauri
CA Service Operations Insight
Avaya/CMS Call Data
Asset Center
Jira
Reference Table Manager
Canva1

WORK EXPERIENCE:

COGNOS ENGINEER

Confidential, Goleta, CA

Responsibilities:

Combine the actual and target data to one consolidated table.
Import data source objects from database in Framework Manager.
Create relationship between objects and create Alias object if need.
Create model query objects and also create relationship and set determinants.
Create the DMR model for report using including dimension and measure, publish the package.
Creating template for the reports, creating reports based on the package.
Collecting business requirement with different business unit and aligns the balance between different stake holder’s opinions, High level design, Design the data warehouse with Star Schema.
Design the table structure which is most suitable for the report development and performance.
Build the fact table as snapshot or Accumulating Snapshots depending on the requirement.
Tune the performance by bridge table if necessary.
Using TM1 creating dimensions to make the cube for user to input target data.
Using TM1 to make the cube for user to load actual data.
Writing rule for cube calculation.
Add List, Crosstab, and Charts to the report and set the layout.
Add complicated logical or layout to the report like drill through, drill up - down, conditional layout.
Create the work space based on different report.
Put the prompt page report in the global area.
Writing javascript in the report to make some default setting.
Using ArcGIS to create map chart for customers, Unit Test, Deployment, User Document, User Training, Bug Fix
Collaborated with managers to provide reporting solutions to meet their needs. Gathered requirements, developed and tested solutions, and moved solutions to our production environment.
Developed, implemented and trained managers regarding self-serve tools such as Ad Hoc reporting, Analysis Studio (Cube, OLAP), Query Studio and QlikView. This increased the availability of self-serve data to our customers and allowed the reporting team to build more complex reporting solutions.
Collaborated with management and peers to improve distribution of 800+ reports by creating jobs that would run after daily ETL loads. Worked with peers and managers to confirm unused reports. This increased the speed and accuracy of our report distribution.
Developed critical reports for various IT ISO 20K audits. These reports helped the Incident and Problem Management teams get ISO certified in a 5 month period.
Maintained and updated 800+ reports in production environment.
Interact with executives and technical staff to capture and understand business user requirements and define project scope.
Gather and assess needs from internal business units; create custom solutions to resolve issues and develop functional specifications for IT group.
Create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to decision makers.
Develop complex reports in Report Studio using nested crosstabs, creating various charts through union and nesting capabilities, share layout components, page set, master-detail relationship, prompts, parameters, filters, and conditional processing.
Involve in development of ad-hoc reporting interfaces using Cognos Query Studio.
Create List Reports and Cross Tab Reports and Drill Through reports.
Schedule and burst the reports using the scheduling and bursting capabilities of Cognos.
Create new groups and roles in Cognos 8, added users to roles and granted access permission in Cognos Connection.
Closely work with Enterprise Data Warehouse engineers to refine data and metadata (ETL).

We provide IT Staff Augmentation Services!

Cognos Engineer Resume

Goleta, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship