SUMMARY:

• 14 + years of IT experience involving various aspects of Reporting. Well versed with complete software development life cycle process including requirement analysis, documentation, development, testing, implementation, and post - production support.
• IBM Certified Cognos professional with over 14 years of experience in Analysis, Design, Development, Testing and Implementation of reports.
• Certified Tableau Desktop Specialist.
• Expertise in BI reporting using COGNOS Suite 7.3 / 8.4.1 / 10.1.1/10.2.0/10.2.2 and IBM Cognos Analytics 11.0.9/ 11.1 R5 / 11.1.7.
• 4 + Years’ experience in Cognos Analytics developing Reports and Dashboards.
• 6 + Years’ experience in Cognos 10.x BI Suite (Framework Manager, Cognos connection, Report Studio, Analysis Studio, Query Studio, PowerPlay Transformer and Event Studio).
• 3 + Years’ experience and expertise in Cognos 8.x BI Suite (Framework Manager, Cognos connection, Report Studio, Analysis Studio, Query Studio and PowerPlay).
• Expertise in Framework Manager Modeling and building Complex Reports.
• Expertise in Relational and Dimensional (DMR) Modeling.
• Expertise in Report building using Report Studio, Analysis Studio, Query Studio and Event Studio.
• Expertise in creating Dashboard reports and using Java Script in Report studio.
• Understanding of Data warehouse concepts and ETL Process Flow.
• Experienced in Transformer model design and PowerPlay cube building.
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment and from Cognos 8 to Cognos 10 Environment.
• Experience in databases such as Oracle, SQL SERVER and IBM DB2.
• Experience in writing SQL, PL/SQL Packages, Stored procedures, Functions, Triggers, Cursors as per teh business needs.
• Experience in conducting requirements walk through, test plan reviews, and comprehensive involvement in user acceptance testing.
• Proficient in documenting Report Specifications, test scenarios, test plans, and test cases.
• Successfully handled offshore-onsite model as a Team lead.
• Experience in interacting with end users at different geographical locations to gather requirements.
• Proficient in Microsoft Office suite including Word, Excel, PowerPoint, Visio, Outlook.
• Excellent interpersonal and communication skills, professionally competent and result-oriented with strong problem-solving skills.

TECHNICAL SKILLS

Operating Systems: Windows 10, Windows 8, Windows 7, Windows XP, Windows 2000

Programming Languages: PL/SQL, CORE JAVA

BI Reporting Tools: IBM Cognos Analytics 11.0.9/11.1 , Cognos 10.x Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio), Cognos 8.4.1 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio, PowerPlay, Transformer), Cognos Impromptu 7.3, PowerPlay 7.3 and SQL Plus (Ver. 7.0), Tableau Desktop

Databases: Oracle 9i/10g/11i/12c/18c, SQL Server 2008, IBM DB2 9.1/10.1, IBM Db2 on CLoud

Management Tools: Microsoft Office Suite (Visio, Word, Excel, PowerPoint and Outlook), JIRA, Autosys, HPQC, e-Room, PVCS, Action Request System (ARS), Service Now, Rally, Jama, MOVEit, IBM Box, Motio CI

PROFESSIONAL EXPERIENCE

Confidential

Sr. Cognos Developer

Environment: IBM Cognos Analytics 11.1.7, DB2 on Cloud, DBeaver, Jira, Motio CI, Windows 10, IBM Box, IBM Cognitive Support Platform (CSP) - Salesforce

Responsibilities:

• Develop and maintain Cognos Data Modules to report on Kyndryl Ocean Reporting.
• Create external data sources and integrate them with teh Data Module and update them based on periodic changes.
• Meet with SME’s to gather requirements on contract novation reporting requirements.
• Collaborate with data architect to identify teh data components and understand business rules to be used for teh development of reports.
• Create and maintain reports based on identified requirements.
• Engage with external vendors (EY and Sirion) for Contract Disposition data.
• Provision users by adding them to teh Blue groups for Cognos report access.
• Perform integration testing of data by comparing it against source and target for all transformations.
• Unit test reports and validate for data quality.
• Migrate reports from Development to Production using Motio.
• Assist users on Cognos Reports generation and data questions.
• Triage data quality issues and notify to data base team.
• Manage file upload to production through IBM Cognitive Support Platform (CSP) tickets.
• Update Jira board to track teh progress of requirements.
• Provide status updates to teh respective stake holders for tracking and reporting.

Confidential

Sr. Cognos Developer

Environment: Cognos 11.1 R5, Oracle 18c, SQL Developer, Jama, Rally, Service Now, Osteka, MOVEit, Windows 10

Responsibilities:

• Meet with Business Units to understand teh individual subject areas to formulate requirements for SMART Dashboards that drive decision making.
• Conduct brainstorming sessions with BA to finalize requirements for SMART dashboards based on Business Unit insights.
• Create report specifications document for dashboards and drill through reports for SMART.
• Collaborate with data architects to identify teh data components and understand business rules to be used for development of reports and dashboards.
• Prepare data mapping documents based on teh discussions with DA team.
• Develop dashboard components and teh respective drill through reports to align with requirements and present teh draft version to Business Units to finalize teh requirements.
• Improvise teh dashboard based on business unit feedback and lock teh requirements.
• Maintain RSD’s in box for version control.
• Create report specifications, data component mapping and develop multiple DART reports aligning to teh approved BRD.
• Perform data validations for all reports and dashboard components by creating database queries and comparing to Cognos result set.
• Unit test reports and dashboards and execute teh test cases in Jama and maintain teh evidence in MOVEit as it contains PHI.
• Performance tuning of dashboards.
• Defect triage and closure for defects raised during SIT testing.
• Identify data gaps and raise defects in Rally for Data Warehouse team to resolve.
• Track teh progress of user stories and tasks and defect status in Rally for Status reporting to Client.
• Assist testing team by preparing SQL queries based on ETL mapping documents and execute them for database validations for data testing.
• Triage data validation issues with ETL, DA and testing team to identify gaps and tracking to closure.
• Perform regression testing of reports and dashboards in SIT for UAT migration.
• Assist peers with defect triage and resolution.
• Interact with various teams on a regular basis to meet SLA’s.
• Attend sprint planning sessions and status calls.
• Provide status updates to teh respective stake holders for tracking and reporting.

Confidential, New York, NY

Cognos Developer

Environment: Cognos 10.2.2 (Framework Manager, Report Studio, Query Studio, Event Studio, SDK), Oracle 12c, JIRA v6.4.11, Informatica 9.6.1, Autosys, Asana, GIT Repository, Windows 7, Tableau POC.

Responsibilities:

• Gather requirements from stakeholders for new reports.
• Analysis and feasibility study of teh requirements.
• Develop them into deliverable reports.
• Create report views and batch jobs for teh newly developed reports in Report studio.
• Create agents in Event Studio and schedule them through Autosys.
• Create/Update query subjects and define relationships in Framework Manager and publish Packages as and when new columns/tables are added to teh data warehouse.
• Perform Regression Testing for Packages before production migration.
• Request new AD groups when new owners are created for row level security.
• Create and maintain Folders for various user groups by providing desired permissions through AD groups.
• Analyze issues reported for existing reports and provide fix or clarification for data issues.
• Prepare Database Scripts for custom reporting requirements.
• Upload Database Scripts through GIT Repository for database changes and for scripts version control.
• Support daily batch cycles by monitoring Cognos Batches/Agents through Autosys and resolve failures/issues.
• Create Custom reporting groups as per report requirements.
• Analyze and report issues with data to Data Warehouse team and other upstream systems.
• Interact with data warehouse team to get a better understanding of data and relationships.
• ETL Production Support for daily batches.
• Decommission of reports and batches based on desk changes.
• Provide weekly status updates to teh respective stakeholders through Asana and weekly status meetings.
• Coordinate with report owners for User Acceptance Testing and signoff.
• Update and track teh report development status through JIRA tickets.
• Provide UAT support to users.
• Analyze issues reported during UAT and tracking them to closure.
• Perform release procedures and documentation through JIRA.
• Implemented Tableau POC and created visualizations and dashboards using sample data from teh data warehouse.
• Knowledge Transfer Sessions/ Cross s.

Confidential

Sr. BI Analyst

Environment: Cognos Analytics 11.0.9, Cognos 10.2.2 (Report Studio, Query Studio), Microsoft SQL Server 2014, Oracle 11g, vFire, PeopleSoft 8.9, Windows 7

Responsibilities:

• Requirements elicitation by meeting with report owners and PeopleSoft nVision SME’s and other stakeholders.
• Analysis of PeopleSoft nVision reports to understand teh BODA mapping rules that are being used in various reports and prepare teh Caption mappings to be created in MEGA database.
• Analysis of teh data in FACT and DIMENSION Tables and report issues to FAST database team.
• Engage in discussion with FAST team for a better understanding of teh data.
• Define mapping rules to eliminate calculations that are currently being used in PeopleSoft to improve teh report performance.
• Develop reports in Cognos 10.2.2(Report Studio) and in Cognos Analytics 11.0.9 upon migration from Cognos 10.2.2 to Cognos 11.0.9.
• Used Custom grouping, Conditional Formatting, Conditional Block and Cascading Prompts, Complex calculations for grouped subtotals, Singletons etc. for teh various reports being developed.
• Used Page set to combine Summary and detailed pages into a single report based on a prompt value.
• Helped teh FAST database team in creating Captions and identifying teh mapping rules for various Drill BIT reports.
• Combined multiple nVision report layouts into a single Cognos report by using Prompts and Render variables.
• Ensure that teh SOX requirements are met for all teh SOX reports that were being developed.
• Update and track teh report development status through vFire tickets.
• Test teh reports in Cognos 11.0.9 that were earlier developed in Cognos 10.2.2 after teh migration.
• Analyzed teh performance of reports and request FAST team for additional indexes for performance improvement.
• Perform Cognos report reconciliation against nVision reports and Drill BIT application.
• UAT support to users.
• Analyze issues reported during UAT and tracking them to closure.
• Cognos Report walkthrough to users for halping them understand teh new reports.
• Fix issues or GAPS that are identified during requirement analysis in teh nVison reports, in teh new Cognos Reports that are being developed and notify them to PeopleSoft report development team to get them fixed in PeopleSoft.
• Provide weekly status updates to teh respective stakeholders.
• Coordinate with report owners for User Acceptance Testing and signoff.

Confidential

Sr. Cognos Developer

Environment: Cognos 10.2.0 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio and Event Studio), Cognos Access Manager, IBM DB2 10.1, Windows 7

Responsibilities:

• Maintenance and enhancement of Workers Compensation Reporting.
• Gather and analyze teh change requirements for regulatory reports and document them.
• Discuss with interfacing technical support team to understand teh regulatory reporting requirements and to keep teh reports in sync with teh legacy system reports.
• In corporate teh regulatory report changes in a timely manner.
• Apply teh new data filters and conditions for teh regulatory report changes to teh existing regulatory reports.
• Perform data analysis to understand teh source for new internal reports requested.
• Create ad-hoc Reports using Query Studio.
• Develop teh requested new reports in Report studio using functionalities like Render Variables, Conditional Blocking, Cascading Prompts, and Conditional Formatting.
• Implement teh changes in validations/edits in teh existing reports.
• Data comparison of Cognos reports and legacy application reports.
• Scheduled new reports developed using Event Studio as per requirement.
• Customize Cognos Connection with appropriate reports and security measures.
• Perform Change Management activities for implementations.
• Generate Cognos Reports and perform data comparisons for specific users upon request.
• Provide teh workers compensation policy information on ad hoc request to internal business users.
• Analyze Workers Comp Policy information for bureau criticisms raised in legacy system.
• Evaluate report validations/edits and analyze failed reports upon occurrence.
• Perform report reconciliations.
• Prepare and execute test scripts and test cases.
• Coordinate with internal business users for User Acceptance Testing and signoff.
• Prepare User Manual for new reports developed and trained teh business users to effectively use teh reports and also develop own reports in Query Studio.

Confidential

Sr. Cognos Developer

Environment: Cognos 10.1.1(Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Power Play Transformer), Oracle 11i, Windows 7

Responsibilities:

• Collaborated with Stakeholder at different levels to capture business objectives and reporting needs.
• Gatheird, analyzed and documented business requirements and technical specifications.
• Prepared BRD and conducted walkthrough sessions for user signoff.
• Identified teh tables and prepared teh mapping for teh new reports.
• Installed & configured teh Cognos 10.1.1 BI Environment, Administering teh Servers, Troubleshooting, and Performance Tuning.
• Developed and Published Packages in Framework Manager - Connecting and testing teh data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Created transformer models and created power cubes using teh model as teh source.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models.
• Customized Cognos Connection Portal based on user specifications.
• Designed Reports using most of teh Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Used HTML/Java Script in Cognos report studio reports as per teh requirements.
• Developed Dashboard reports using Cognos Report Studio.
• Worked with Stored Procedure Query Subjects in FM and Reports.
• Created Drill- through reports and Customized Reports with Prompts (List, Cross tab).
• Developed Dash Board reports in Report Studio using MDX Functions.
• Created Oracle PL/SQL Stored Procedures, Functions and Cursors for use by Framework Manager Packages and Report Studio reports.
• Worked with Analysis Studio to develop multi-dimensional reporting.
• Implementation of security at data level, Object level.
• Java Script for complex validation, navigation, communication and format customization.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and Cognos.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Actively involved with end users for UAT and Signoff.
• Involved in implementation and post production support.

Confidential

Sr. Cognos Developer

Environment: Cognos8.4.1 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer), Cognos 10.1.1 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer), Cognos Access Manager, Oracle 11i, Windows 7

Responsibilities:

• Analyzing teh specifications provided by teh clients and Developing specification documents for reports as per client requirements.
• Installed & configured teh Cognos 10.1.1 BI Environment, Administering teh Servers, Troubleshooting, and Performance Tuning.
• Used Framework Manager to import metadata from multiple datasources, to Design and Develop teh Framework Manager models.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Created Packages and published to teh Cognos Connection.
• Developed cubes in Transformer for analyzing teh performance of brokers, councils and BDM’s.
• Migrated reports from Cognos 8.4.1 to Cognos 10.1 Environment.
• Migrated PowerPlay Cubes from Cognos 8.4.1 to Cognos 10.1.1 Environment.
• Used HTML/Java Script in Cognos report studio reports as per teh requirements.
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Created multi-dimensional reports in analysis studio.
• Implementation of security at data level, Object level.
• Report reconciliations between Cognos 8 and Cognos 10.
• Report performance comparisons between Cognos 8 and Cognos 10
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Extensively involved in UAT and signoff, travelled to various user locations to assist in UAT.

Confidential

Cognos Developer

Environment: Cognos 8.4.1 (Transformer, Framework Manager, PowerPlay, Query Studio, Analysis Studio, Report Studio, Event Studio), Cognos Access Manager, Oracle 10g,SQLServer 2008, IBM DB2 9.1, Windows XP

Responsibilities:

• Developed Framework Manager Models with Physical layer and Presentation Layer to cater teh various business needs (Folders, Filters, and Macros).
• Implemented Third Party Security with LDAP and used those in creating Data Level and Object Securities in Framework Manager Models.
• Developed Complex Report Studio Reports using Bursting, Tabular Objects.
• Created Drill- through reports and Customized Reports with Prompts (List, Cross tab).
• Prepared User documentation to train users and functionality of each report.
• Production Support which involves solving user problems.
• Created IQD files from Framework Manager and designed PowerPlay models in Transformer.
• Involved in building teh Cubes and optimizing teh cube creation.
• Provided security for Cubes of various User classes.
• Published cubes and created PowerPlay Reports for teh web users.
• Played as a good mentor to teh new joiners in team by giving noledge transition in both technical and functional areas.
• Developed Stored Procedures and Database Triggers in PL/SQL.
• Designed extensive sample business Reports to cater teh needs, which can meet their future demands on behavioral, trend analysis.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports.
• Installed and Configured Cognos 8.4.1 in single server Environment.
• Responsible for overseeing teh Quality procedures and Software configuration management related to teh project.
• Production Support, which involves solving user problems.

Confidential, Jersey City, NJ

Cognos Developer

Environment: Oracle 9i, PL/SQL, Cognos Transformer 7.3, Impromptu 7.3, PowerPlay 7.3, Cognos 8.4.1 (Transformer, Framework Manager, PowerPlay, Query Studio, Analysis Studio, Report Studio), Microsoft Access, Windows XP

Responsibilities:

• Gatheird & analyzed teh end-user business requirements.
• Provided estimation of efforts required.
• Used Framework Manager to import metadata from multiple datasources, to design and develop teh Framework Manager models.
• Worked with relationships (cardinality) between query subjects to better represent teh logical structure of teh business and teh user requirements.
• Created list reports, cross-tab reports and chart- reports using multiple queries in a single report.
• Created various Report Studio reports using calculations, filters, prompts and conditional formatting, drill through.
• Rebuild Cognos 7 Catalogs and Reports in Cognos 8.4.1 Environment.
• Created PowerPlay cubes using Transformer (PowerPlay).
• Data retrieval, Multidimensional analysis, PowerPlay structure.
• Created Multi-Dimensional reports using PowerPlay.
• Created Cognos Impromptu Reports.
• Migrated Impromptu reports to Cognos 8 Environment.
• Migrated PowerPlay Cubes in Cognos 7 to Cognos 8 Environment.
• Validated report results with teh source data and authorized teh reports to production environment.
• Scheduled Reports and Jobs to run periodically.
• Worked on securing Cognos Connection and setup security by assigning users to teh groups and roles defined in Cognos Namespace.
• Created several drill through to several reports for providing better functionality.
• Provided technical assistance, and mentoring to Users and Business Partners.

Confidential

Cognos Developer

Environment: Oracle 8i, PL/SQL, Cognos Transformer 7.3, Impromptu 7.3, PowerPlay 7.3, Cognos ReportNet 1.1.1, Windows XP

Responsibilities:

• Gatheird teh requirements, analysis and preparation of design documents.
• Understand teh reporting needs.
• Prepared Functional Specification Document.
• Study existing system and review.
• Document teh process involved.
• Maintain Requirement Traceability Matrix.
• Imported metadata from multiple data sources to build a HR model and published packages in Framework Manager to teh ReportNet server.
• Created catalogs with teh halp of Impromptu utilizing relational databases.
• Developed impromptu reports with various functionalities (Drill -- through, Cascading prompts).
• Created templates utilizing Impromptu.
• Created ad hoc reports utilizing Cognos Query.
• Created user prompts, conditions and filters to improve report generation.
• Created PowerPlay cubes using PowerPlay Transformer to permit multi-dimensional cross sectioning and drill down analysis.
• Worked on securing Cognos Connection and setup ReportNet security by assigning users to teh groups and roles defined in Cognos Namespace.
• Enabled users to access teh distributed HTML reports through local network folders, intranet and via e-mail.
• Refresh teh PowerPlay Cubes and perform reconciliation of data.
• Prepared System Test Plan and Unit Test Plan.
• Performed System Testing, Unit Testing, Integration Testing and Regression Testing.
• Prepared test scenarios for User Acceptance Testing.
• Provided Weekly Status reports.