Cognos Developer Resume Dallas, Texas - Hire IT People

SUMMARY

8 years of experience working with Cognos as a Developer and Analyst.
Extensive experience creating and maintaining Cognos reports and Framework manager model (for entire SDLC).
Good communication and client facing skills, experience in analysis and testing.Understanding of relational databases.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Cognos Developer

Responsibilities:

Responsible for analysis, design, development of Technical Integration Solutions for Hospital Operations in DevOps, Agile environment. Understanding of relational databases.
Responsible for Developing/Updating Framework Manager models from Foundation to Presentation layer.
Model aggregated data from source systems to business rules.
Kimball methodology (Star Schema) used for creating Dimensional Metrics, Measures, Fact, KPI’s which were exported from Netezza data source (data marts) and Relational database (Oracle).
Made incremental enhancements, QA Testing as needed. Assist in development of software technical documentation.
Develop/Debug/Maintain Report/Dashboard: Identified Root Cause Analysis. Updated/Created tables/views or COGNOS FM query subjects/ Publishing the package and refreshing the report. Reported calculation/filter/code update as needed.

Confidential, Lewisville, Texas

Systems Analyst

Responsibilities:

Responsible for Creating Reports/Portals/Dashboards for entire school district from Foundation to Presentation layer.
Used Relational and Dimensional modeling from Data warehouse (Multi - Dimensional cubes) + Transactional databases.
Responsible for Developing/Updating Framework Manager models for Student Information System, Human Resource Department, Payroll Dept., and Budgeting.
Models created from disparate systems (like Kronos database, Student System and Finance System) Published packages from development and migrated to production. Deployed report from DEV-TEST-PROD.
Used Report Studio, created advanced reports encompassing Student and Financial area.
(Drill-down/Drill Through reporting) Distribution of reports to various campus principals.
Workspace Advanced Workspace used to create Dashboards.
Transformer used to create cubes. Experience with OLAP/OLTP concepts and terminology .
Packages used to create Dashboards including Attendance, Discipline, Enrollment, Grades etc.
Measured how different dimensions affect facts/measures. Data Marts are created using Kimball methodology.
Multiple facts were used to create integrated cubes.
COGNOS Administration - Assigned users to groups and roles.
Gave permissions and access to assigned users for reports (Authentication).
Helped migration of COGNOS 8.4 to COGNOS 10.2. Testing and Maintenance Support.
Used Audit database for client use, employee use reports.

Confidential, Irving, Texas

Business Analyst

Responsibilities:

Responsible for generating Monthly Reports using MS Access and MS Excel. Reports involve Analyzing/Tracking Orthopedic Assessment. Identified Implemented Savings from Operational Information, Savings By Total Spent Category, and Savings by Region. Production time reduced from 1 week to 1.5 days.
Responsible for Designing and Developing Contract Value Assessor Tool for Hips and Knees Portfolio, providing Functional Equivalents for each part no. The tool is now available on the website for members to use which gives the one or more equivalent part no for the file they input. The tool was the first in the industry for Hips and Knees to identify selected contracts savings.
Designed and developed Part LOOKUP Database to find a part and section for Ortho Line Items. MS Access/VBA was used. Used as an Inter-Departmental Database.
RFP generation: Designed and developed an entire database for Request for Proposals is created wherein.
Over 80 Pricing studies and RFP have been produced. Success Stories.
Orthopedic Assessments generated using Excel and MS Access to identify Savings by Tier to members.
Reports Generation for Portfolio Executives using MS Access and BRIO.