SUMMARY

• IBM Certified Cognos Developer with over 9+ years of IT experience focusing on Business Intelligence and Data Warehouse Applications.
• Hands on Experience in Power BI/QlikView to create visualizations for several initiatives.
• Experience in creative Visualizations using Tableau for several POCs.
• Good Knowledge in Integration of Abinitio with Cognos.
• Strong exposure in IBM Cognos Analytics (Framework Manager, Reporting, Dashboard, Visualization, Maps, Event Studio, Data Module, Cognos Connection).
• Experienced in Performance Tuning, Application Development and in resolving all BI Production support issues on various platforms, using Data Warehouse tools including IBM Cognos 11/ 10.2/10.1/8.4 .
• Strong Exposure in MicroStrategy Dossier.
• Experience in ERWIN Data modelling for various Database Types.
• Experience in JSON, Java scripts for Cognos Reports and use of Python/Batch scripts via Autosys.
• Experience in working in Agile Kanban/Scrum Teams.
• Good experience in creating Dimensional and Relational model using Framework Manager and Transformer.
• Well - versed in understanding OLTP data and in developing OLAP multi- dimensional cubes and analyzing Power Play Transformers.
• Good Hands on Experience in Microsoft SQL Server Analysis Server (MSAS Cubes).
• Strong complex reporting skills - complex Drill-Through, Discontinuous Cross- Tabs, Summary Reports and Burst Reports.
• Good knowledge on Cognos Admin Activities as enabling security, publishing Model packages and providing object access to users through LDAP and AD Security user groups.
• Experienced in Data Warehouse Concepts, Methodologies on ODS, Banner ODS and Banner ERP, Data Marts, Star and Snowflake schemas, Data Lake.
• Experience in working in Archer Application used as an enterprise Audit Framework Tool.
• High initiative, self- motivated with excellent communication, analytical and presentation skills, willingness and ability to quickly adapt to new environment and learn new technologies

TECHNICAL SKILLS

• IBM Cognos BI V11.x, V10.x & V8.4, Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Cube, QlikView, Tableau, Power BI, DB2 UDB V8, DB2 V9, SQL Server 2012/2014/2016 , Oracle 12c Data Warehouse, Business Intelligence, Data Analytics, Cognos Workspace and Workspace Advance, Cognos Administration, Advanced Query Tool V10, Autosys.
• Windows XP, Windows 7, Windows 10
• SQL, PL / SQL, UNIX Shell Script

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Design and Develop Cognos Framework Manager model using tables, views, stored procedures and published to different Cognos server;
• Develop and design code for reports with Query Subject from Stored Procedures, views which are published through Framework manager model as packages;
• Develop various Burst reports using Cognos Event Studio and delivering Dynamic report outputs.
• Develop multiple dashboards/visualizations in QlikView and Power BI for Higher Management using Cognos Reports as source.
• Involve in data error and bug fixing activities for the existing reports and dashboards;
• Develop multiple management dashboards in Tableau as a POC.
• Develop multiple dashboards using MicroStrategy Dossier.
• Design and develop different types of complex dashboard and score card for business user.
• Develop various dimensional (DMR) and relational reports by deploying lists, crosstabs, charts, union, joins, burst, drill up/down reporting techniques.
• Generate reports using various sophisticated analytical mechanism such as drill through definition, master-details, crosstab, graphs and charts etc.
• Develop active reports so that user can see data by dynamic value selection.
• Write complex programming in IBM Cognos using different types of statistical functions for more sophisticated data analysis.
• Automation of Python Scripts for Cognos Process improvements.
• Define Developer and Test Methodology to carry out the development schedule;
• Analyze and Design document for the Impact and Risk involvement for all the new releases;
• Use Autosys for various trigger-based jobs scheduling architecture including dependencies.
• Collect requirements from business analyst and translated them to technical specs;
• As part of data science analyze the existing database and data warehouse / DataMart for report requirements.
• Involved in defining the source definitions and Target Definitions and created mapping.
• Involve in various types of data mining for business transformation.
• Create SQL and procedural language (stored procedures) as per business requirement;
• Validate stored procedures and deployment testing before releasing to stakeholders

Tools: and Technology used: Cognos BI 11, 10.2 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Analysis Studio, Active Reports, Cognos Cube Designer etc.), Transformer, Oracle 12c, SQL Developer, Autosys, Windows 2007 & UNIX server.

Confidential

Design and Develop Cognos Framework Manager

Responsibilities:

• Planned, and successfully implemented the cross functional projects within defined budgets and timelines.
• Created the changes and tasks for implementation process.
• Provided the What If Analysis facility to users to get desired output by changing parameters.
• Reviewed Business Requirement Document (BRD) for Completeness, Gather and analyze financial planning, budgeting and reporting requirements.
• Designed Relational and DMR models using Framework Manager and deployed packages to the Cognos Connection.
• Generated multiple Enterprise reports using Cognos from SQL Server Data Mart and included various reporting features such as group by, drilldowns, drill through, sub-reports.
• Created database layer and business layer, defining start schema by creating appropriate relationship between query subjects in Framework Manager.
• Applied Security at the package level, query subject level and the query item level.
• Created various complex List Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding various types of Prompts, Filters, Calculations, Summaries and Functions/Macros.
• Delivered Advanced Multidimensional Reporting solutions using Report Studio.
• Developed Dashboard Portlets and integrated multiple Cognos reports onto a single Dashboard Page.
• Customized Reports by writing complex custom SQL.
• Designed, Created and managed jobs scheduling.
• Extensively used Analysis Studio, Query Studio and Report Studio for Report design in Cognos BI version 8.4
• Designed multidimensional models in Framework Manager.
• Understood data and business logic underlying the business requirements.
• Created Projects, Models, and Packages using Cognos Framework Manager and published Packages to Cognos Connection.
• Created and established Joins / cardinality between the tables in the application layer.
• Designed and applied conditions and based on business functionality as per requirements.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Created charts, lists and crosstab reports using Report Studio and ad hoc reports using Query Studio.
• Administration involved implementing security, managing users, User groups and roles in the organization.
• Worked on bursting reports for the web users.
• Created Multidimensional Cube in Cognos transformer using Framework Manager Packages and iqd files as data source.
• Created and supported Cognos Transformer models and cubes. Involved in implemented security at transformer level by creating custom views.
• Worked with business partners in understanding business requirements to create design and technical documents.