EXECUTIVE SUMMARY

Around *+ years of experience in Software Design, Development, Analysis, Testing, Data and Business Intelligence tools such as Cognos, QlikView, SSRS, Power BI and Tableau.

Around 8 years of strong experience in visualization and dashboarding using Cognos & Other BI tools such as Tableau and QlikView.

Strong experience in Cognos Administration.

Strong SQL and Oracle Knowledge, Oracle Certificated SQL developer and Associate Oracle Database SQL Developer

Experience in OLAP Cubes, report development on OLAP cube sources, Active reports.

Strong Knowledge in Data warehousing concepts like Star schema, snowflake, and relation data models.

Strong knowledge in Cognos 11 (Analytics), 10 & 8 Series including Report Studio, Analysis Studio, Framework Manager, Business Insight, Business Insight advance, Metrics Studio, Event Studio, Report Net Series tools and Cognos Connection.

Expert in designing and developing Dash Boards and SQL tuning.

Experience in writing Java scripts in Cognos reports.

Good analytical and communication skills, ability to work independently and good team player.

Education:

Master of Business Administration

Bachelor of sciences in Computer Science.

Software Skills:

Databases: Raven (cloud source), Oracle 11c, 8i, 9i, MS SQL Server, MS SQL 2000, MS Access, Netezza

Micro Soft Suite: Excel, word, Access

Reporting Tools: Cognos 11 (Analytics) Series, 10.x, 8.x, Tableau, QlikView 12

Testing Tools: Selenium Automation Testing, HP ALM, JIRA

Certifications:

Certified professional in

Oracle Certified Associate ‘Oracle Database SQL’

Dated: Feb 28,2018, Certification #: 256500491OCASQL12C

Business Intelligence/Technology Lead - Infosys Mar 2021 – Current

Client - Macys Atlanta (GA)/Remote

Marriott International is an American multinational diversified hospitality company that manages and franchises a broad portfolio of hotels and related lodging facilities. Marriott International is the third largest hotel chain in the world. It has 30 brands with 7,003 properties in 131 countries and territories around the world.

Responsibilities:

Design & Development for Cognos Reports, Dashboards, Events using Cognos Analytics

Data Modeling using Cognos Framework Manager and Cube designer.

Successfully debugged and trouble shooting of existing Business Objects, OBIEE, SSRS and Power BI reports.

Leading offshore onsite model, successfully managed 6-member offshore team.

Requirement gathering, documentation and high/low design documentation for reporting needs.

Design and development of report enhancement for existing Cognos, Tableau and Power BI reports.

Cognos Server management, deployment and server related trouble shooting.

Validating and unit testing Cognos reports and cubes.

Dashboard design using multi data sources and Cognos tool.

Successfully created advanced dashboards visualization interactions using Cognos analytics.

Frequent status update to Client and Supervisor.

Supported 24/7 to monitor and resolve the issues.

Use Lifecycle manager to compare report outputs and report specifications between different environments.

Operational and analytical reporting using Google Cloud Big Query.

Dashboards and Ontime Reporting by combining Oracle, SQL server and GCP data sources.

Cognos Cube Design and Development.

Data Sets and Data module creation.

Migrating the reports from Cognos 10.2 to Cognos 11 (Analytics) and testing the deployed reports using Cognos Life Cycle Manager.

Products and tools: Cognos Analytics - 11.1.3, Framework Manager, Oracle database, Teradata, SQL Server, GCP (Google cloud big query), Business Objects, OBIEE, SSRS, Power BI.

Energy Harbor (DXC) Feb 2020 – Mar 2021

Cognos & BI Developer Ohio (Remote)

FirstEnergy Corp is an electric utility headquartered in Akron, Ohio. Its subsidiaries and affiliates are involved in the distribution, transmission, and generation of electricity, as well as energy management and other energy-related services. Its generation subsidiaries control more than 16,000 megawatts of capacity, and its distribution lines span over 194,000 miles. FirstEnergy ranked 219 on the Fortune 500 list of the largest public corporations in the United States by revenue, First Energy uses Cognos and QlikView as Enterprise level Reporting and Analytical Tool.

Responsibilities:

Developed Complex reports & Dashboards using Framework Manager packages, Direct SQL, Data Models and Data Marts.

Framework Model design using various data source including DQM.

Designed and developed Cognos event studio to trigger reports based on events.

Installing and Configuring Cognos Servers (2 Application, 2 Gateways and 1 Content Store)

Folder Level security setup for Cognos objects

Data source setup on Cognos dispatchers

Trouble shoot Cognos environment issues.

Designed Cognos navigation documentation for end users.

Design Development of Powerplay cubes and redesign Qlik View reports into Power play cubes using Cognos Transformer and Cognos package data source.

Shell Scripts to build cubes.

Validating and unit testing Cognos reports and cubes.

Cognos report automation using AutoSys.

Requirement gathering, designing low- and high-level documentation.

Design and Developing Qlik view reports.

Testing and deployment developed QlikView reports between multiple environments.

Migrating Cognos reports to Qlik View platform.

Co-ordinating with End users and Offshore team.

Scheduling tasks in QMC (Qlik View Management Console)

Coordinating with Qlik view team to understand the Cognos applications.

Frequent status update to Client and Supervisor.

Products and tools: Qlik View V12, QMC, Cognos 10.x, Framework Manager, Oracle database, SQL Server, SAP, WinSQL.

Marriott (TCS) Sep 2019 – Feb 2020

Cognos Support Consultant Gaithersburg, MD

Marriott International is an American multinational diversified hospitality company that manages and franchises a broad portfolio of hotels and related lodging facilities. Marriott International is the third largest hotel chain in the world. It has 30 brands with 7,003 properties in 131 countries and territories around the world.

Responsibilities:

Experience in Design and Developing Cognos reports.

Experience in Service Now Incident Management related to Marriott SRW (Cognos) applications.

Co-ordinating with End users and Offshore team.

Monitoring Marriott (SRW, MRW, MRDW) applications and Co-ordinate with other teams to resolve the issue.

Frequent status update to Client and Supervisor.

Supported 24/7 to monitor and resolve the issues.

Use Lifecycle manager to compare report outputs and report specifications between different environments.

Products and tools: Cognos 11.1.3, Framework Manager, Oracle database, service now Incidents management.

FINRA Sept 2018 – June 2019

Cognos Analytics Visualization Developer Wall Street, NY

Financial Industry Regulatory Authority, Inc. (FINRA) is a non-governmental organization that regulates member brokerage firms and exchange markets, acts as a self-regulatory organization. FINRA is the successor to the National Association of Securities Dealers, Inc. (NASD) and the member regulation, enforcement, and arbitration operations of the New York Stock Exchange.

Development Responsibilities:

Analyzing business requirements and creating design documentation.

Created POC (proof of concepts) on Cognos Analytics Dashboards.

Developed Tableau reports for risk analysis and examinations.

Successfully created advanced dashboards visualization interactions using Cognos analytics.

Developed Data Sets & Data Modules from flat files such as Excel and csv files.

Design and Development of Framework Manager packages for Analytics Reports and Dashboards

Implemented advanced techniques to refresh reports and dashboards on timely basis to meet live stream data requirements.

Embedded Analytics reports into Dashboards.

Created drill-thru dashboards.

Successfully rewritten Tableau reports and dashboards to Cognos Analytics environment.

Experience in writing Embedded Java script into the Cognos Reports.

Design and Development of Cognos power play cubes using Transformer and IQD as data sources (Time based and incremental cube build)

Work with cross-functional teams effectively to deliver project work on time.

Unit testing Dashboards and Reports against data sources.

Products and tools: Cognos 11.0.11/ 11.1, Framework Manager, Tableau Desktop 10.x, RAVEN database, Aqua Studio, Excel/csv data files,

LK Technologies NJ March 2016 – May 2018

Cognos/Tableau Developer Newark, NJ

Responsibilities

Worked on Agile and waterfall methodologies.

Developed Standalone and ad hoc reports for business users.

Developing Active disconnected reports to end users

Created Tableau Desktop Dashboards

Successfully migrated Cognos 8 Series reports to Cognos 10 Series.

Migrating the reports from Cognos 10.2 to Cognos 11 (Analytics) and testing the deployed reports using Cognos Life Cycle Manager.

Dashboard design, development, Sql tuning for reports and cubes.

Developing Active disconnected reports to end users.

low level and high-level documentation preparation for Cognos report development

design document preparation for Cognos reports

Framework Manager design and development

Communicating with IBM Cognos support to fix the Cognos issues.

Providing POC’s for business users.

Design & Development of Cognos Power Play cubes.

Converted Tableau reports to the Cognos Analytics.

Triggering Cognos reports and events based on custom based Events.

Successfully tested SSRS and SSAS report migration to Cognos

Running smoke tests in Cognos production environment.

Work with cross-functional teams effectively to deliver project work on time.

Cognos Tester Responsibilities:

Created manual and automated test plans and procedures.

Work with cross-functional teams effectively to deliver project work on time.

Testing Cognos reports on desktop and mobile platforms.

Successfully tested and completed Cognos 8 to 10 migration.

Developed, managed, and monitored TEST, CERT and PROD environment

Monitored the testing units periodically and reported the defects to the manager followed by adoption of remedial measures.

Wrote advanced SQL to test and compare Cognos reports manually.

Testing Cognos report sequence using jobs and schedule

Wrote testing codes and applied them to the relevant software.

Maintained test scripts, codes, ad-hoc testing in proper format.

Ensured completion of target work on time.

Automated testing using Cognos Lifecycle Manager.

Products and tools: Cognos 8.4 / 10.1 / 11, Cognos 7.x series, Framework Manager, Report studio, Oracle 12c, Toad, winSQL SSRS, SSAS, DB2, Teradata, SQL Server, Tableau Desktop 10.x

NYK Line Aug 2013 – Feb 2016

Cognos Developer Secaucus, NJ

Nippon Yusen Kaisha (NYK) is Japan's largest marine transportation company with operations spanning the globe. NYK and its group companies own and operate some 758 vessels that provide a broad range of shipping services that include container, cruise, tramp, and specialized transport services. The Company also offers logistics services in a highly integrated transportation network. NYK uses Cognos 8 to generate Standard and ad-hoc reports, cubes to find vessel performances, BL change, revenue performances, cost, net contribution etc.

Development Responsibilities

Analyzing the system to design and implement the marts suitable for Cognos reporting and cubes.

Communicating with business users, business analysts to analyze, design, develop the Cognos reports, dashboards and DMRs.

Designed and developed OLAP Cubes

Report development on OLAP Cube sources

Converted existing Actuate reports to Cognos 8 Report Studio reports.

Developed several new POC (proof of concepts) to show the new reporting concepts to Business.

Extensively worked on implementing dimensionally modeled relational data (DMR) and Excel, PDF, HTML formatting issues.

Reports created from Oracle PeopleSoft module data.

Worked on developing Dashboards and Tuning Reports for greater performance.

Designed Best practices for Cognos FM, Report Studio, and Analysis Studio.

Detailed design documentation for developed Reports, OLAP Cubes, Framework manager, Cognos best practices and server side architecture as per company policies and standards.

Sql Tuning to enhance the performance of the reports.

report migration from Cognos 8.x series to Cognos 8.4 series.

Administrative Responsibilities

Communicating with Cognos support to fix the unknown problems.

Scheduling and Administering Cognos Report studio reports in Cognos Connection.

Products and Tools: Cognos 8.1 MR1, MR2, 8.2, 8.3, 8.4, Framework Manager, Query Studio, Report Studio, Oracle 9i, 10G, 11

Intricity May 2012 – Mar 2013

Cognos Developer New York

Responsibilities

Developed Standalone and ad hoc reports for business users.

design document preparation for Cognos reports

Developing Active disconnected reports to end users

Analyzing the system to design and implement the marts suitable for Cognos reporting.

Communicating with business users, business analysts to analyze, design, develop the Cognos reports, dashboards and DMRs.

Running smoke tests in Cognos production environment.

Work with cross-functional teams effectively to deliver project work on time.

Worked on developing Dashboards and Tuning Reports for greater performance.

Developing Active disconnected reports to end users.

Low level and high-level documentation preparation for Cognos report development

Products and Tools: Cognos 8.1 MR1, MR2, 8.2, 8.3, 8.4, Query Studio, Report Studio, Oracle 9i, 10G

Contact this candidate