PROFESSIONAL SUMMARY

• IBM-certified Cognos Reports developer with over eight years of experience in a wide range of industries and business models. Ability to plan and execute starting from requirements gathering to implementation, testing, deployment and maintenance of BI and ETL applications.
• Strong background in building relational and dimensionally modeled relational metadata models using Framework Manager and Cubes using Transformer.
• Extensive work on developing various kinds of reports using Cognos Report Studio, Analysis Studio, Query Studio, PowerPlay, Crystal Reports and BO WebI.
• Developed Dashboards over Cognos Workspace and Business Insight and using reports from report studio and Cubes.
• Hands on Experience on Data Warehousing development using ETL tools such as Informatica Power Center 6, Data Manager
• Experience in Installing and Configuration of Cognos 8 on client-server architecture.
• Hands On experience on Cognos Administration including deployments, migrating reports, managing user accounts and assigning access rights through the Cognos Server linked to standard LDAP.
• Interactive participation in requirements, technical/business meetings, testing and UAT
• Extensive experience in writing, testing and debugging of SQL.
• Experience in coordinating with various teams, reviewing tasks in detail, tracking project status and reporting/presenting the same to client.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Cognos Consultant

Financial Management System Reports/Dashboard Development

Project goal is to create standard reports that can be burst and sent to CFO, CIO and business analysts. Developed a interactive dashboard and Ad-hoc tools for the business analysts. The reports and Dashboard mainly provided crucial information on portfolio performance and evaluations. Enhanced existing reports that provide information about claims, cash-flows and insurance.

Responsibilities:

• Gathering report requirements from the Users and planning the reporting designs accordingly.
• Coordinating with the DB/ETL teams to fix data discrepancies/gaps.
• Proposed Materialized Views to be created in DB for best performing reports and produced SQL for the same.
• Developed dashboard styled reports with multiple pages and views using conditional blocking.
• Created complex canned reports on Report Studio and implemented functionalities like Master-Detail, Conditional rendering and drill-through as per the requirements.
• Installed Heat Map, Tree Map and bubble visualizations and created charts to analyse the risk at CUSIP ID level.
• Used Bursting functionality to send location specific reports to the Users through separate emails.
• Developed Active reports using various controls for high level summarized data for the executives.
• Collecting and sharing best practices and tips in Framework Manager modelling, Transformer and Cube Refresh and Report Authoring.
• Integrating reports over web portal through report URIs.
• Used Parameter maps with macros to produce simplified report design and best performing reports.
• Created/modified, deployed and published Framework Manager packages in various environments.
• Developed Transformer models using Framework Manager Package for faster analysis on Analysis Studio.
• Created analysis packages based on Transformer power cubes to use in analysis studio analysis.
• Automated the Cube refresh using a batch script that executes in the nightly batch queue.
• Testing and validating the reports against database tables using SQL Navigator.
• Deployed the packages to QA and Production environments as part of the project life cycle.
• Coordinate with IBM support with any issues on Cognos reporting.

Environment: Cognos 10.2.1/10.2.1.1, Framework Manager, Transformer, Visualizations, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Business Insight Advanced, SVN, Oracle, SQL Navigator.

Confidential

Cognos Lead

Risk and Compliance Reports Development

Project goal is to redesign and automate the compliance reports over cognos BI. I was assigned for the development and maintenance of all alerts reports.

Responsibilities:

• Developed one point reporting solutions for investigators, team leads and executives to track the compliance through Alerts reports and performance through investigator performance reports.
• Create a DMR metadata model in framework manager for the new set of reports.
• Developed dashboard styled reports with multiple pages and views using conditional blocking and provided sorting, slicing-dicing and search options on the report page.
• Created Dashboard Reports using Active Reports functionality.
• Provided reports with drill down and drill through capabilities to navigate between various levels of details inside the report and navigate between reports.
• Developed Active reports using various controls for high level summarized data for the executives.
• Created/modified, deployed and published Framework Manager packages in various environments.
• Testing and validating the reports against database tables using SQL Developer.
• Created the ETL mapping doc based on stored procedures which works as a data dictionary and technical requirements for ETL for new data warehouse.
• Backup for database POC in monitoring jobs and deep analysis on data issues.
• Created scripts with various test cases for the UAT.
• Provided technical support as a mentor to other developers.
• Actively participating in User Acceptance Testing.

Environment: Cognos 10.2, Framework Manager, Cognos Connection, Report Studio, Oracle, SQL Developer

Confidential

Reporting SME/Cognos Lead Developer

Delivery Support

Confidential is one of the World's largest Financial Services Company. My work is concerned with providing all the reporting services to the eBusiness LOB. I am responsible to provide the weekly, monthly and quarterly reports to the Project Managers, Resource Managers and Directors of the eBus LOB.

Responsibilities:

• Gathering requirements from Business Users and Analysts.
• Creating Professional and Ad-hoc reports for the end users.
• Developed different types of reports using objects like List, Cross-tab, Chart, Drill-Thru, Master-Detail and Active Reports.
• Developed Active reports using various controls and variables to make reports interactive to users.
• Created Projects and Tickets Exception Reports to improve the quality of the data being input in PlanView, which is used for Cognos Reporting.
• Implementing changes requested to Framework manager metadata model.
• Deploying and publishing Framework Manager packages in various environments.
• Assisted in various Admin tasks like moving packages and modifying access during upgrades.
• Developing and maintaining cubes over transformer.
• Publishing Cubes over cognos server for user analysis on PowerPlay Web Explorer.
• Used Bursting functionality to send user specific data to all the PMs.
• Worked on complex reports using Conditional Formatting and sub queries.
• Testing and validating the reports with building SQL on SQL Server.
• Creating reports and analyzing data over MS Access and SQL Developer.
• Creating and modifying standard reports over Business Objects WebI.
• Ad hoc reporting and data analysis over BO WebI.
• Supported the ETL planning and process over Data Manager.
• Consolidating reports from multiple data sources using MS Access.
• Working on Excel for Business Analysis.
• Actively participating in User Acceptance Testing.
• Created new jobs and scheduled reports using Cognos Connection.
• Documented the Production reports.

Confidential

Senior Cognos BI Developer/BA

Cognos Implementation Project

Constant Contact is an email marketing company. The goal of this project is to implement Cognos 8.4 for all the company reporting requirements. I was assigned to install Cognos 8.4 over a two tier architecture, integrate cognos with LDAP. Created the Accounting and Finance reporting. Phase 1 of the project involved in Installation and configuration of Cognos 8.4. Phase 2 involved in developing the Framework Manager Metadata models, canned reports on Cognos Report Studio. Reports were redeveloped from the logic of Hyperion and Crystal Reports. Also, new reports were developed over Cognos 8.4. Phase 3 of the project involved in developing the flat model into a DMR model and developed the Self Service reporting process over Query Studio.

Responsibilities:

• Extensively worked with the business analysts to gather requirements, documenting HLD and LLD, providing estimates and to ensure that the technical aspects of Cognos tool are met.
• Involved in meetings with the business users, Project Department and TDM.
• Installing and configuring various cognos tools on two tier architecture.
• Worked on Cognos Administration functions including managing content manager settings, Activities, Data Sources, setting dispatcher and server settings including routing keywords, maintaining Cognos Directory and Cognos reporting security.
• Tuned server performance by adjusting the level of logging, grouping dispatchers in configuration folders, setting the dispatcher load balancing mode, maximizing usage during peak hours and setting queue time limits.
• Involved in creating/updating relational and DMR models, applying security and publishing packages using Framework Manager.
• Created various types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Developed standard reports, ad hoc reports, events, jobs, dashboards and Portals for the end users.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Developed complex period to date reports with various calculations and sub-queries.
• Deployed projects across various environments like Development, QA and Production.
• Passing parameters from Metric Studio to Report Studio.
• Created Portal page, scheduled an entry using Jobs, worked on specifying Run Histories and Report Outputs.
• Liaison between the Development Teams and Cognos Corporation in resolving the issues Involved in developing a query model.

Environment: Cognos 8.3/8.4, Framework Manager, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Analysis Studio, Hyperion 9, IIS Web Server, DB2, Toad.

Confidential

Senior Cognos BI Developer

Interaction Management Project

In this project, I have worked for the corporate reporting requirements. It included development of new reports and dashboards over Cognos 8.2 and 8.4 environments to support the Investment Banking Product line Managers with CRM. Improvements were done to the existing reports to make the business environment more convenient for the departments like Retail, Banking, Wealth Management and Credits.

Responsibilities:

• Extensively worked with the business analysts to gather requirements, documenting HLD and LLD, providing estimates and to ensure that the technical aspects of Cognos tool are met.
• Involved in meetings with the business users and Project Department.
• Involved in creating/updating relational and DMR models, applying security and publishing packages using Framework Manager.
• Developed standard reports, ad hoc reports, events, jobs, dashboards and Portals for the end users.
• Developed packages based on client requirements in SSIS involving flat files, excel and OLE DB connections with SQL Server of back end DB
• Error and event handling, managing precedence constraints and check points in SSIS.
• Developed complex period to date reports with various calculations and sub-queries.
• Created Trend over Time reports to identify developing trends and quickly react to them.
• Validated reports for data using Pl/SQL.
• Extensively worked on Perl scripting.
• Worked on Cognos Administration to manage content manager settings, Activities, Data Sources, dispatcher and server settings.
• Tuned server performance by adjusting the level of logging, grouping dispatchers in configuration folders, setting the dispatcher load balancing mode, maximizing usage during peak hours and setting queue time limits.
• Maintaining the Users, Groups and Roles on Access Manager and Cognos reporting security.
• Created Test cases for UAT and responsible for bug fixes and report deliverables.
• Developed multi-dimensional OLAP cubes in PowerPlay Transformer using various data sources and published in Cognos Connection.
• Liaison between the Development Teams and Cognos Corporation in resolving the issues Involved in developing a query model.

Environment: Cognos 8.2/8.4, Framework Manager, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Analysis Studio, Event Studio, Metrics Studio, Access Manager Administration 7.3, Power Play, Transformer, AIX UNIX, Apache Web Server, MS Access, SSIS 2005.

Confidential

BI and ETL Developer

A provider of business analytics and market research for the pharmaceutical industry. The project involved in installation and implementation of Cognos 8.2 version, migration of entries from ReportNet to Cognos 8 and developing new metadata models and reports on Cognos 8. Created several packages in SSIS for new data fields needed for BI reporting.

Responsibilities:

• Involved in installing and configuring Cognos 8 BI suite tools.
• Migrating reports from Reportnet to C8.
• Creating, configuring, executing and deploying packages in SSIS.
• Extensive work on SSIS package development including control flow elements, variable functions and looing.
• Testing the Server, managing Cognos Connection Portal and tuning the System Performance in Cognos Administration.
• Installed the required migration tools on the source computers for migrating reports from CRN to Cognos 8.2.
• Developed the metadata layer in Framework Manager and applied DMR functionality to support financial reports for the management.
• Developed standard Reports, Dashboards and Portals.
• Creating several data sources and arranging the migrated entries like packages, cubes and new reports in Connection.
• Developing drill through definitions among packages.
• Responsible for the weekly refresh of cubes.
• Created reports by writing SQL in Report Studio and validated reports for data using custom T-SQL
• Developed stored procedures for aggregate tables for better performing reports.
• Testing existing reports for accuracy and performance and worked on query optimization.
• Participated in User Acceptance Testing UAT .
• Responsible for bursting reports depending upon different levels of administration.

Environment: Cognos 8.2, Framework Manager, Cognos Connection, Administration, ReportStudio, QueryStudio, Analysis Studio, Cognos SDK, Cognos Scheduler, Access Manager, SQL Server, SSIS 2005, IIS Web Server.

Confidential

Business Analyst

The data warehousing development for Baxter involves the development of a Data Mart which will feed downstream report, development of User Access Tool using which users can create ad-hoc reports and run queries to analyze data in the proposed Cube. The current project replicated the functionality incorporated in the underwriting Measures Cube, but with daily update, a more robust architecture, and enhanced reliability.

Responsibilities:

• Support the Development Teams in an Agile development environment for the Cognos related issues
• Coordinate all communications with the Database Management team.
• Developed report flow diagram using Visio.
• Created reporting and business rules according to user requirements and worked closely with the off-shore team on various requirements.
• Analyze the existing data sources to the Framework Manager and Transformer and document them.
• Extracting the data from different Data Sources and loading to data mart using Cognos Decision Stream.
• Worked on physical and logical modeling of data using Erwin.
• Worked on Perl scripting on UNIX.
• Develop and customize Reports over Report Studio, Query Studio, Analysis Studio and Powerplay.
• Scheduling and distributing Reports through Schedule Management in Cognos Connection.
• Optimize the reports performance.
• Worked on PowerPlay Enterprise Server for cube deployment on the web.
• Deployed Cubes and Reports on PowerPlay Enterprise Server and also Published to Connection.
• Liaison between the Development Teams, Business Analysts Team and Cognos Corporation in resolving the issues Involved in creating an ad-hoc query model for query studio users
• Develop, document, manage, and coordinate all user acceptance testing.
• Deployed reports to all different environment Dev, QA, Prod

Environment: Cognos 8, Framework Manager, Cognos Connection, ReportStudio, Teradata, System V Unix, Analysis Studio, QueryStudio, Cognos Scheduler, Erwin, Decision Stream 7.1.

Confidential

Reportnet Consultant

The project involved in creation and implementation of a reporting application using Cognos Reportnet for the Rebates division of corporate Novartis. I was involved in creation of metadata layer in Framework Manager, publishing packages to Reportnet Server and creating reports over Report Studio.

Responsibilities:

• Gathering business requirements from various users in Rebates department.
• Involved in Strategic Planning of Cognos ReportNet Framework Manager Model.
• Created models using Framework Manager in multiple namespaces by creating shortcuts, joins, star schema groupings, Calculations and filters.
• Created database connections to different data sources in Framework Manager.
• Designed the standard template for creating reports in Report Studio.
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio.
• Validating the reports using Pl/SQL on Oracle Database and obtain approval.
• Creating and Managing Jobs and Schedules.
• Involved in training end users in Cognos Connection and Cognos Query Studio.
• Attended Functional Testing and User Acceptance sessions, and worked on the feedback from the business users.
• Deployed the packages exporting and importing the packages using the Deployment functionality under Cognos Connection Portal.
• Provided production support for managed reports and users.
• Documented the whole reporting process.

Environment: Cognos ReportNet 1.1, FrameWork Manager 1.1, Cognos Connection, ReportStudio, QueryStudio, Oracle 9i.

Confidential

ReportNet Consultant

Confidential, a leading contract research organization CRO , provides clinical trials management, data analysis and data submission in all major therapeutic categories to several pharmaceutical manufacturers and biotechnology companies. Here, I was involved in the complete datawarehousing development to support the Clinical research.

Responsibilities:

• Designed packages using Framework Manager from various data sources of Oracle Clinical.
• Involved in Developing Informatica mappings for doing ETL of Facts and Dimensions.
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Worked on various reports like conditional reports, master-detail reports, reports with prompts and other complex reports.
• Created Reports through embedding SQL queries.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables and to debug SQL query issued during report execution.
• Created Dashboards for multiple views of Reports on the same Report page as per the user request.
• Created and improved existing impromptu catalogs.
• Extensively worked on MS Excel in front end reporting training sessions.
• Involved in creating security and deployment exports and imports .

Environment: Cognos ReportNet 1.1MR2, FrameWork Manager 1.1, Cognos Connection, Report Studio, Query Studio, Impromtu, Informatica Powercenter6, Toad, Oracle.