9 years of IT experience in Datawarehousing concepts, BI tools and Operations Monitoring Experience in Business Intelligence/Data Warehousing Proficiency with Cognos BI (preferably 10.2.2.) product suite (Report Studio, Analysis Studio, Query Studio, Framework Manager, and Transformer) and Cognos 11.x version
Hands-on experience with Framework Manager dimensional modeling and Transformer cube design and development 8+ yrs. IBM Cognos experience & 5+ Years of Oracle as Backend & 3+ Yrs of Tableau reporting experience
Experienced in creating worksheets, dashboards in Tableau Desktop using measure, dimensions, calculated fields, parameters, sets, groups Experienced in using features like LOD, joins, data blending, scheduled refresh while creating dashboards
Worked on different components and versions of Cognos as well as Tableau Experienced in Manufacturing, Finance-banking, Healthcare and Logistics based business domain
Experienced in different SDLC models namely Agile, Kanban and Waterfall
Overview
9
9
years of professional experience
Work History
Senior Cognos Developer
Tata Consultancy Services
Pune
07.2024 - Current
Working on Cognos 11.x Analytics to develop and enhance reports for the Transport and Logistics-based domain.
Proficient in the design, development, and deployment of Cognos reports, dashboards, and Transformer cubes.
Experienced with designing and maintaining relational databases.
Efficiently troubleshoot, debug issues, along with strong analytical and problem-solving skills.
Cognos and Tableau Report Developer
Atos-Syntel
Pune
12.2018 - 07.2024
Primarily worked on Cognos 11.x version to develop and alter reports in Report Studio, create packages in IBM Framework Manager, creating transformer cubes, and scheduling them.
Proficient in developing List, Cross tab, Chart report in Report Studio. Created Drill-through and Master-Detail Relationships, prompts, and joins. Developed Data-Models using Framework Manager and published packages to Content store.
Experienced in Cognos Admin Console to migrate and deploy reports, create AD groups, provide access to reports and users, create data sources, monitor Cognos server and content managers, perform monthly cleanups, and performance tune the reports.
Also worked on resolving incidents with Cognos report execution, data issue, report studio issue
Worked as a Tableau developer in Healthcare Domain, created dashboards, stories, workbooks and different visualizations including Pie, Bar, Map etc along with the understanding of dual axes, blended axes, and trend lines.
Created calculated fields, parameters, sets, groups for enhancing the dashboards
Develop, design, and maintain Tableau dashboards and analytics
Collaborated with data engineers to optimize ETL processes, improving data refresh.
Ability to work in a team environment as well as lead the team, adaptive, and a quick learner.
Oracle SQL Developer
Accenture
Pune
08.2017 - 10.2018
Worked as a SQL Developer for IFRS9 project in Finance/Banking Domain using FDW architecture
Involved in development of new tables, dynamic views, transformation logic as well as modifying and optimizing the existing codes
Composing new SQL logics for creation of attributes and calculation of metrics as per details given by client in Functional requirement
Creating and committing code through Metadata manager and maintaining file versions in CVS
Creating Technical Detail Document (TDD) for business use
Managing defects and Incidents through Application Lifecycle management (ALM) tool.
Cognos Report Developer
Accenture
Pune
11.2015 - 08.2017
Developing reports in Cognos, performing ETL operations on data, creating and publishing packages in Framework manager for business use
Creating and managing user groups, directories and access and mapping them to corresponding reports in Cognos, analyzing multidimensional data through powerplay cubes, creating new cubes for detailed functionality
Worked on Oracle database
Tools: IBM Cognos, IBM Datastage, Powerplay, IBM Transformer, IBM Framework Manager
Involved in frontend report development and Cognos admin activities as well as support activities like maintenance and bug fixing
Involved in cleanup and maintenance activity of data though ETL tool
Analyzing System requirements, Technical Requirements, Contributing towards automation
Providing support for all types of Incidents and month end and year end support.
Education
Bachelor of Engineering in Electrical Engineering -
Sinhagad Institute of Technology
Lonavla
01.2015
Skills
IBM Cognos Analytics BI
IBM Framework Manager
IBM Transformer Cubes
Tidal Scheduling Tool
Application Operations
Extract Transform Load (ETL) - Informatica
Oracle SQL Developer
Tableau (Business Intelligence Software)
SQL (Programming Language)
Application Lifecycle Management and Service Now
Technical Detail Documentation (TDD)
Leadership and Management
Team Building
Languages
English
Accomplishments
Received the Outstanding Performance Achievement award as Individual for pro-actively cleaning and synchronizing lower envs with Prod
Received SPOT awards for adhoc appreciations, Quarterly Silver award for cross-skilling, taking additional team responsibilities and situational leadership
Received Customer appreciation for identifying areas of automation, reducing backlogs and process improvisations which lead to cost and effort savings
Timeline
Senior Cognos Developer
Tata Consultancy Services
07.2024 - Current
Cognos and Tableau Report Developer
Atos-Syntel
12.2018 - 07.2024
Oracle SQL Developer
Accenture
08.2017 - 10.2018
Cognos Report Developer
Accenture
11.2015 - 08.2017
Bachelor of Engineering in Electrical Engineering -
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services