SUMMARY

• 15 plus years of IT experience in Data Warehousing as an Architect, Lead and Senior Cognos Consultant in multiple industries (Finance, Insurance, Pharma, University, Health...)
• Strong abilities and Hands on experience in requirement gathering, analysis, design, development, testing, implementation and production support of BI applications.
• Expertise in using various IBM Cognos BI Suite (Framework Manager, Report Studio, Query Studio, Cognos workspace, Cognos Workspace Advanced, Cognos Active Reports, Cognos Microsoft EXCEL and Dashboard), Cognos Powerplay Transformer.
• Good Knowledge in building Active reports for users to use offline and on mobile devices.
• Experience in using IBM - Cognos Analysis for Microsoft Excel for creating Monthly and Budget presentation reports for Management.
• Expertise in defining the multi-tiered Cognos Architecture, Performance tuning, Security infrastructure and Deployment.
• Created Data level security, Object level Security in the model, to secure the packages.
• Created multiple layer report, providing a comprehensive and detail report with Drill through facility and Master Detail relationship.
• Worked on all stages of Software Development Life Cycle including Enhancements and Training End Users.
• Worked closely with managers to develop Cognos reports that add value to their daily operations.
• Served as a bridge between the onshore and offshore teams, handling the majority of the communication.
• Efficiently managed time to work on different projects and delivered the reports on time.
• Outstanding team player, ability to work quickly based on the Priority, managed multiple projects and able to work independently.

TECHNICAL SKILLS

Reporting Tools: Cognos 11 / 10.x / 8.x, Framework Manager, Cognos Workspace, Cognos Workspace Advanced, Cognos Active Reports, Dashboards, Cognos for Microsoft Excel, Cognos SDK 8.4, Cognos TM1, Powerplay Transformer

Database: Oracle 11g, MS SQL Server 2012, DB2.

Operating System: Windows / UNIX

Programming Languages: C, C++, SQL

Others: TOAD, Clear Case, Clear Quest, ServiceNow, GWCC

PROFESSIONAL EXPERIENCE

Confidential, Bala Cynwyd, PA

Sr. Cognos Consultant

Environment: Cognos 11 / Cognos 10.x (Framework Manager, Report Studio, Query Studio, Workspace Advanced), SQL Server 2012, Guide Wire Claim Center, ServiceNow

Responsibilities:

• Designed the FWM to bring DWH data from 2 different data sources and designed the FWM model (TMA).
• Created different Query for each data set and combined in report studio using Joins and Union.
• Created Dashboard Reports using different types of charts and other report layouts to show multiple results together in the same place.
• Compared the report results against database for data issues and assisted QA team for invalid test cases.
• Developed complex Reports using different features like Drill through, Master detail relationship and cross tab tables, complex List grouping with multiple page breaks (FICOH)
• Compared the Cognos report result with GWCC.
• Re write: Converted the reports from one package to another package and tested the report result against database and also with the existing reports (PHLY Sakura Reporting)
• Defects are tracked in different Quality Control system: ServiceNow, Quality Control - Application Life Cycle Management, Foot Prints.
• Updated the report based on the BRD changes and defects raised.
• Efficiently managed time to work on three different projects and delivered the reports on time.
• Document and upload all the changes in the Defect Tracking System and as well as in the report for Future Reference.

Confidential, Teaneck, NJ

Sr. Technical Consultant

Environment: Cognos 11/ 10.x (Framework Manager, Report Studio, Query Studio, Workspace Advanced), Cognos Active Reports, Dashboard, IBM Cognos for MS-EXCEL, SQL Server 2012 and Cognos TM1.

Responsibilities:

• Designed and Implemented new dashboards using portlets page and Cognos workspace Advanced.
• Developed Active reports for users to use offline and on mobile devices.
• Developed Monthly Profit & Loss presentation Reports using IBM - Cognos Analysis for Microsoft Excel.
• Developed Actual vs Budget, Actual vs Forecast Variance Analysis Reports for different time periods for different country groups.
• Successfully designed and implemented security on different levels.
• Scheduled daily Sales reports to respective sales representatives effectively.
• Developed Sales and Gross Margin Analysis Report in Cognos and verified against Cognos TM1 Cubes.
• Responsible for developing high level and detailed architecture and design documents.
• Developed Highly Interactive Reports for various Business groups using Cognos Active reports.
• Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Managed Level 1 support for day to day operations and issue of Enterprise data warehouse.
• Developed complex Reports using different features like slice & dice, Drill capabilities, Master detail and cross tab tables with multiple page breaks.
• Managed Package Migrations and Deployments from one Environment to another.

Confidential

Cognos Senior Specialist

Environment: Cognos 10.2, Framework manager, Cognos SDK, DB2, SQL Server 2012, Rational Clear Case / Clear Quest.

Responsibilities:

• Responsible for delivering the BI solutions using the IBM Cognos 10 suite (Framework Manager, Report Studio, Query Studio).
• Responsible for developing high level and detailed architecture and design documents.
• Collaborate with technical resources to build and improve Agency wide Cognos reporting solutions.
• Working with different functional groups to translate business requirements into Business Intelligence report solutions.
• Updated Models using Cognos framework manager for reporting systems, end user ad hoc report needs.
• Acting as a First point of contact for any Production CHRMS Reports and advice suggestions and solutions based on the severity of the issue.
• Worked on Performance tuning of the CHRMS reports (both PMS and PPMS reports).
• Built a new mock-up Project for merging PMS and CityTime systems.
• Took training on Cognos SDK for analyzing NYCAPS report for ESS (Employee Self Service) system.
• Updated Clear Quest and Clear Case for all report moves from Development to UAT and Production environment.

Confidential, South Orange, NJ

Cognos Architect

Environment: Cognos 10.2, Framework manager, Oracle 9i, TOAD 8.5, Banner, Operational Data Store (ODS), Data Cookbook, Service Now .

Responsibilities:

• Worked with Project Manager in creating Planning and Estimation for the models and reports.
• Designed and built POC (Proof of Concept) reports in Cognos 10.2 and Oracle as the data source, to improve confidence level of the client.
• Actively involved with business users and Development teams for gathering information for creating the Framework Model.
• Documented the mapping document from Banner database to ODS (Operational Data Store).
• Designed the Model according to the Business Requirements, by importing the metadata from ODS.
• Created Data level security, Object level Security in the model, to secure the package from different Groups.
• Created filters within the Model for improving the performance of the Model.
• Migrated Financial Aid oracle reports (SQL) into Cognos report and verified the result against Banner Database.
• Developed complex reports with prompts, Conditional Variable, Mater-detail relationships, drill through, and reports using complex calculations.

Confidential, New York, NY

Cognos Architect /Administration and Development

Environment: Cognos 10.2, Framework manager, SQL Server 2008, Oracle 9i, TOAD 8.5, Rational Clear Case / Clear Quest.

Responsibilities:

• Played a key role in Requirements Gathering and Technical Design.
• Prepared Effort estimation and Design Documentation.
• Involved in Daily execution of the project, issue escalation, work allocation, review of deliverables and quality assurance.
• Developed and implemented various security enhancement and SQL Performance Tuning.
• Used Cognos Connection for organizing, security, scheduling and distributing reports. Created multiple layer report providing a comprehensive and detail report with Drill through facility.
• Involved in the Cognos up-gradation from 8.3 to 10.2
• Migrated all the manual reports from Multiple System to One System (TED) using Cognos Reports.
• Able to analyze, optimize and troubleshoot the native queries generated by ReportNet during report generation.
• Experience in installation, administration and maintenance of the Cognos 10.2
• Modified stored procedure, removed macro and implemented cube automation using Script.
• Managed 5 members offshore team, served as a bridge between the onshore and offshore teams, handling the majority of the communication.

Confidential

Lead Consultant

Environment: Cognos 8.4, Framework manager, Cognos Report Studio, Teradata and Oracle 10g

Responsibilities:

• Created stored procedures for Cognos Security implementation.
• Created various adhoc reports for the Business and modified existing SQL code to generate new reports
• Expertise in using Framework Manager to construct the metadata and infrastructure for star schemas and dimensional models.
• Managed 8 members team based on the onsite and offshore model.
• Worked closely with offshore team in coordinating the report development and testing
• Working with data warehouse users and report authors to develop system requirements, specifications, and designs.
• Worked closely with end users to understand and validate requirements and build reporting solutions that produce accurate, timely information in a format appropriate for the information consumers.
• Responsible for setting up the Dev and prod environment.
• Responsible for enhancement and maintaining the existing Cognos Reports.