Cognos BI Developer Worked on all phases of data warehouse lifecycle, from gathering requirements to testing, implementation and support.
*Experience working with Cognos 11/10.x Business Intelligence Reporting Suite.
*Experience with the Enterprise level Cognos administration and Framework Development support, which includes the installation, configuration, administration and maintenance of a business-critical Cognos product set in a 24x7 production environment.
*Experience in creating models and implementing the Security using User Classes in Cognos Administration.
*Experience with Framework Manager Modelling (Physical Layer, Business Layer, Packages) and Complex Reports building with Report Studio.
*Developed and tested Complex reports (List, Cross tab, Charts, Maps, Drill-through, Master-Detail and Cascading) using Report Studio.
*Worked on Transformer for Modeling of the corporate data for building up of Multidimensional Cubes.
*Knowledge of data warehouse techniques and practices, including BI Reporting, relational modeling, OLAP, Star schema & Snowflake schema.
*Experience in designing, developing and testing ETL processes using Oracle Data Integrator (ODI).
*Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules.
Tools: Oracle 12c/11g, SoapUI, MS Access/Excel, DB2, and SQL Server, Toad.
Operating Systems: Windows 2007/2008/2012, UNIX.
Work History
Cognos BI Developer / Admin12/2015
to 01/2017 Commonwealth of Massachusetts (Department of Revenue – Chelsea,
MA
Analyzing and reviewed business requirements and Technical Specifications for Report development.
Developing the ETL flows to get data from Operational Data Store and loading it to data warehouse using the ELT tool Oracle Data Integrator with different Knowledge Modules and developing Informatica mappings for legacy data warehouse.
Imported tables in to the Framework Manager from different data sources like SQL Server and Oracle and created relationship between the dimensions and facts.
Created Dynamic data source name in Cognos Framework Manager using parameter maps which is useful when migrating packages and reports between different environments.
Developed Complex reports using Report Studio which includes various report types ranging from simple lists, crosstabs and chart through complex dashboards, drill-through, master-detail and conditional formatting.
Created multipage reports involving prompts, cascading prompts, conditional rendering and conditional highlighting.
Involved in troubleshooting of Complex reports by identifying Query subjects, Query items that needs to be fixed.
Worked on third party integration from Cognos to Pega and wrote requests in SoapUI to get appropriate response.
Tested reports which were created by writing SQL queries and testing them in Toad.
Created Dashboards using Cognos Workspace and trained end user on how to create and execute dashboards using Cognos Workspace.
Deployed the packages and reports from Dev to QA and QA to production environments.
Implemented Object level, Package level, Folder level security on Cognos by creating new security Groups and Roles.
Implemented Data level security in Cognos Framework manager by using parameter maps.
Scheduled and Distributed reports through schedule management in Cognos connection.
Trained end users on Query studio on how to create Adhoc reports in Cognos.
Environment: Cognos 11/10.x (Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration, SDK), IBM Rational Team Concert, Oracle Data Integrator(ODI), Oracle 12c, Windows 2007, Toad, Microsoft Excel, SoapUI.
Cognos Developer03/2015
to 11/2015 Xerox – Sacramento,
California
Gathered User requirements and reviewed them from a technical perspective and conducted meetings with end users to establish business rules, schedule deliverables and identify potential issues that could impact the development effort.
Created Oracle Data Integrator Mapping and Packages to perform ETL tasks for loading data into the Data Warehousing using source data from Oracle OLTP Database, and flat files.
Created Standard Reports like List , Crosstab Dashboard Reports using the business rules and filters.
Actively written batch scripts as part of deploying and running Power Cubes on Unix prod box.
Developed ad-hoc reports, drill through reports and created master detail relationship to burst a crosstab report using Report Studio.
Designed model using power play transformer and created multiple cube views.
Created JavaScript's for different Date condition's prompts that needs to be satisfied while running reports.
Deployed the packages and reports from Dev to QA and QA to production environments.
Created reports by using different dimensional functions available in Cognos Report Studio.
Created cubes in Transformer using Framework Manager IQD's packages and report studio reports as a source.
Modified power cubes by adding new dimensions, levels and measures.
Performed basic administrative tasks such as scheduling and delivering reports in different formats (for example HTML, PDF and Excel).
Documentation of the report results and updated daily with the testing results.
Participated in testing of the developed reports and reported the defects.
Environment
Coordinated with systems partners to finalize designs and confirm requirements.
Report Developer01/2014
to 09/2014 GTL Americas Ltd – Dallas,
Texas
Created reports in Cognos from the drive testing data that is provided.
Developed reports in Cognos report studio using different charts that are available like Trend Lines, Bar graphs, Stacked Charts, Pie Charts and Inline Charts.
Created dashboards from the reports that are created which give end user a better idea of the network coverage at different locations for the drive testing data.
Tested the reports that are created by writing manual SQL scripts and executing them in Toad.
Environment
Education
Master of Science: Electrical EngineeringUniversity of Texas at Dallas-
Richardson,
Texas
Bachelor of Science: Electronics and CommunicationSRM University-
ChennaiElectronics and Communication
