PROFESSIONAL SUMMARY:

• Highly skilled professional with 14+ years of experience in IT industry of Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools.
• 13+ of experience and excellent knowledge in Cognos and its technologies.
• Developed reports with visualizations using Tableau 2019/2018 versions.
• Developed Reports/Dashboards using latest version of Cognos Analytics, Cognos 10 and Cognos 8 which includes Active Reports, Cognos Business Insight/workspace, Cognos Business Insight Advance/workspace Advance, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Transformer and Cognos TM1
• Created complex reports using Report Studio and Active Reports. Created ad - hoc reports using Query Studio. Analyzed Cognos Cube and DMR in Analysis Studio.
• Developed Dashboards with reports and charts using Business Insight/Workspace and Business Insight/Workspace Advanced.
• Reports developed in Report Studio and executing certain test cases and test scripts for data validations.
• Expertise in building Relational Models and DMR Models using Framework Manager.
• Created Multi-Dimensional Cube using Cognos Transformer and Cognos TM1.
• Migration experience of Cognos 8 reports to Cognos 10 using Life Cycle Manager.
• Upgraded to diff versions of Cognos 10 and migrated Cognos 10 to Cognos Analytics.
• Experience in Cognos Admin activities like Installation, implementing the Security by creating Groups through Cognos Connection and Client’s Active Directory or LDAP.
• EP Series 7 Tools such as Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Access Manager, Cognos ReportNet, Framework Manager.
• Experience in Migration from Cognos 7 series into Cognos 8 series by using migratetoc8 and depoytoc8 Cognos utilities.
• Extensive experience in building and maintaining large data warehouses in Financial, Insurance, Health Care, Retail, and Pharmaceutical sectors with Dimensional modeling, Data migration, Data cleansing and ETL Processes.
• Expertise in SQL, PL/SQL and Dynamic SQL for stored procedures and user-defined functions.
• Worked with Framework Manager for developing the Logical and Physical model.
• Worked with DB2, Oracle and SQL Server Stored Procedures, Triggers, Index, Table Partitions, Query Optimization/ Performance Tuning at report level and DB level.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Cognos Developer

Environment: IBM Cognos 10.2, 10.1, 8.4.1 (Report Studio and Query Studio, Active Reports, Business Insight/Workspace, Analysis Studio), Tableu 10.3 Desktop and Server, Framework Manager, Life Cycle Manager, Motio, Cognos Administration, DB2, DB2 Control Center, Brio/Hyperion, SPSS, SRM, TDW, AIX, Microsoft Office 2010/2013

Responsibilities:

• Lead the team of 4 people and worked as Sr. Cognos Developer. Reporting team status to the client and attending the day to day meeting. I created a scope of the Project with overall time estimation; co-op with clients keeping in mind overall project budget and delivery schedule.
• Developed Report Specifications for the client and designed Report Layout including report header, report appendix, prompt page. Created standard report specification document.
• Used Cognos 10.1, 10.2 and 8.4 for developing reports mainly using Report Studio, Active Reports, and Business Insight/workspace also with advanced feature.
• Developed large List Reports and Crosstab Reports mainly with Charts, Drill through, Condition Style and Dashboard.
• Created dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Connected Tableau Server to publish dashboard to a central location.
• Created visualization for server utilization for Confidential PCM team.
• Provided Drill through capability in Dashboard from charts and summary reports to the child reports. Built Landing Page for accessing all Reports from one location.
• Developed many Parent-Child (Summary/Master-Detail) relational reports with Condition Style and Condition variables to apply the color code to the utilization metric.
• Created many reports using Active Reports for scheduling purpose so that Client’s executives can perform different analysis offline.
• Migrate reports from Brio/Hyperion to Cognos.
• Created presentation for IBM Analytics Conference in Las Vegas for the current Project.
• Migrated the environment from Cognos 8 to Cognos 10 using Life Cycle Manager.
• Upgraded Cognos 10.1 to 10.2.
• Used Framework Manager to create Model and publish the package in TCR/Cognos Connection.
• Created DMR and Cube using Cognos Transformer for analyzing purpose using Analysis Studio.
• Used TCR/Cognos Connection for creating Report Views and Jobs for Scheduling. Used Cognos Administration for other admin related activities.
• Used DB2 Control Center for querying against TDW Database (DB2) mainly for Query Optimization and Investigation for the performance of the report. Used SRM and Axibase for further in mapping.
• Developed all the reports in Dev/Test Environment and deployed to the Production.
• Used IBM internal tool (TSRM) and Maximo for Bug Tracking and maintaining Incidents or Work Orders.
• Provided security to various folders for each category of reports by creating different groups for WLP Users and IBM Users.
• Got the IBM Cognos and Framework Manager provided by IBM at the beginning of the Project with other peers and later on trained them to developed some Ad-hoc Reports.

Confidential, Philadelphia

Programmer

Environment: IBM Cognos 10.2.1, (Report Studio, Query Studio, Event Studio, Cognos Workspace/Adv), Framework Manager, SQL Server 12-14, SQL Server Management Studio, Windows, Microsoft Office 2010/2013

Responsibilities:

• Worked as Sr. Cognos Developer as Fulltime Employee.
• Developed Complex Cognos Reports based on customers’ report specs.
• Developed Unique “Smart Reporting” concept called “Hub Reporting” to control or run all other reports from one master report by passing appropriate parameters.
• Reports having multi prompts, multi-queries with Union or Joins, Condition Style, Condition Block, Component Layout, Layout, Render Variable, Master-Detail reports using Drill Through.
• Developed large List Reports and Crosstab Reports mainly with Charts.
• Provided Drill through capability in Dashboard from charts and summary reports to the child reports using Cognos Workspace/ Adv.
• Created events using Event Studio to schedule reports/batch to run automatically based on refresh data in the database and set the email delivery to the executives.
• Used Framework Manager to create Model and publish the package in Cognos Connection.
• Managed deployment activities regularly for other teams as well.
• Installed and configure Cognos 10.2.2 in all 3 environments.
• Used Cognos Connection for creating Report Views and Jobs for Scheduling.
• Used Cognos Administration for deployment, configure database connection and provide security to the various user groups.
• Used SQL Server Management Studio for querying against SQL Server DB mainly for Query Optimization and Investigation for the performance of the report.
• Completed Cognos for Cognos 10 BI Reports.