SUMMARY

• A Certified Cognos Professional with 8+ years of experience in Information Technology in Analysis, Design,Devlopemnt and Implementaion of Data warehousing Using Cognos BI Reporting Tools Like Cognos 10.x, 8.x BI Suite(Framework Manager,Report Studio,Analysis Studio,Query Studio,Event Studio,Transformer and Adminstartion, WorkSpace and workSpace Advanced, Go Office and Go mobile).
• Strong Experience in all phases of Software Development Life Cycle - gathering requirements, Development, testing, performance tuning and support.
• IBM Cognos Certified Designer and Developer in Building Metadata Models, Report Authoring, Multidimensional Reports, Administration and OLAP cubes.
• Experience in Installation and Configuration of Cognos 10.2, 10.1, 8.x, Cognos Go Mobile & Go Office tools, Cognos Report Net environment and Setting up the Security.
• Excellent Functional Knowledge in Banking, Insurance, Retail and Manufacturing domains.
• Well versed in Data warehouse concepts like Star Schema, Snow flake Schema’s.
• Created FM Models and published packages to Cognos Connection for Reporting using Framework Manager.
• Implemented data, object and Package level Security in Framework Manager and Cognos Connection to restrict access.
• Strong experience in developing report studio reports fromRelational, Dimensional and TM1 Cube packagesas a source usingCognos MDX functions.
• Expertise in creatingMulti Dimensional cubes using PowerPlay Transformer..
• Extensive Experience in Creating Dashboard Reports, Portal pages, Complex Reports involving Drill through, Master-Detail, Bursting, Conditional Formatting, Page sets, Conditional blocks, Variables, Multiple Prompt Templates, Bookmarks..Etc...
• Extensively worked on Cognos Admin Tasks such as Data Source Creation, User Security, Scheduling, Creating user roles, groups.
• Experience in developing Active reports with advanced functionalities like Data Deck, Tab controls, Radio and Button bars.
• Expertise in Creating Multiple Prompt page templates using cascading prompts, Macros, filters, calculations and generated different kind of reports including multilingual reports using Report studio.
• Expertise in developing reports and models from single and heterogeneous databases Oracle, SQL Server, DB2 and MS Access.
• Createdcomplex statistical and financial reports,trend over time reports, ranking, and forecast reports, Executive DashboardsusingReport Studio.
• UtilizedBest PracticesandProven Methodologyin modeling data,Dashboard Reports and otherBI developmentprocess.
• Experience in using HTML & Java Script in Cognos Report Studio reports as per requirements like tabbed reports, dynamic sorting, hide and show, default prompt selections.
• Experience working in Onsite/Offshore Model.
• Experience in working Agile Software Methodology, Waterfall Model which helps the businesses responds to unpredictability.
• Help Project leaders / Team members by providing them with periodic report on project activities for Effective Coordination & communication within the team.
• Manage project team, assign tasks to the team members and groom other junior members for higher responsibilities.
• Enthusiastic, knowledge - hungry, self starter, eager to meet challenges and quickly assimilate newest and latest technologies, skills, concepts and idea.

TECHNICAL SKILLS

BI Tools: Cognos 10.2, 10.1, 8x (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio,Cognos Administration, Power Play Transformer, Go Mobile, Go Office, Workspace, Workspace Advanced, Business Insight)

Data Bases: SQL Server 2000/2005/2008 R2, DB2, Teradata, Oracle

Platform: Windows Server 2000/2003, XP.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Environment: Cognos v 10.2, SQL Server 2008 R2, Teradata (FM,Report Studio & Query Studio, Transformer, Administration, Go Mobile)

Responsibilities:

• Extensively worked on Cognos Framework Manager, Report Studio, Query Studio, Multidimensional Cubes and Transformer.
• Actively interacting with the Global Users /clients/ project team for requirement gathering, Knowledge transition and prepared technical design documents, specifications prior to reporting.
• Imported tables, views and stored procedures from SQL server database into Framework Manager and created relationships and standalone, embedded filters, calculations in the model.
• Created Data source Query Subject, Model Query subject and SP query subjects and applied all the securities as per the business requirements.
• Created durable FM model with 3 layer approach with all the business rules and published package to cognos connection.
• Created Standard reports, Active and Dashboard reports for Go Mobile Users so they can access and interact with reports and dashboards on their mobile device while they are offline or online.
• Assisted the business users to create Various Adhoc reports in Workspace and Workspace Advanced
• Created various types of reports like Dashboards, Complex Cross tabs, Drill through reports, for various sales and marketing teams and Functions/Global Marketing Businesses users.
• Worked on the Active Reports to provide the interactive behavior outputs to the users. Created tabbed reporting with complex calculations/formatting.
• Created Report Studio reports using Conditional formatting, conditional blocks, Render variables, Conditional Variables etc
• Created Multi dimensional cubes using power play transformer to easily analyze the data in analysis studio.
• Using Report studio developed reports like Crosstab, Grouped lists, Charts, dashboard reports.
• Using Token, Slicer prompts, Advanced Dimensional functions for Dynamic selection of the Group/Regional Packs.
• Created Prompts, Cascading prompts, Date Range Reports, to dynamically select the values by the user.
• Created drill through reports, master-detail reports using parameterized filters.
• Using report studio advance technology options created commentary reports where user can submit/review the comments.
• Involved in the creating of DMR Reports/cubes from existing Packages and reports.
• Performed the administrative duties of scheduling, creating Roles, User Groups etc
• Troubleshooting and tuning of FM Relational Models, DMRs and reports for better performance.
• Created Adhoc Reports Using query studio.
• Performed the administrative duties of scheduling, creating Roles, User Groups, etc
• Used Ranked to show Top or Bottom performers in client business.
• Involved in UAT Testing, Peer Reviews of developed reports.
• Ensure reports and reporting application are provided and developed in time and according to customer requirements.

Confidential, OH

Environment: Cognos v 10.1, SQL Server 2008 R2 (FM,Report Studio & Query Studio, Transformer, Administration)

Responsibilities:

• Involved in Development of New report packs, and resolving all data related issues between Source DB and Cognos BI report packs.
• Assisting the BI support/Admin team for User accesses, Roles, groups and Admin tasks.
• Interacting with the Global Users /clients/ project team for requirement gathering, Knowledge transition and for all the Knowledge gaps at different Levels.
• Involved in creating of FM Models from the SQL Server DB as back end source for reporting and published the package to cognos connection.
• Created various types of reports like Dashboards, Complex Cross tabs, Drill through, for various Insurance and sales teams and Functions/Global Marketing Businesses users.
• Created Report Studio reports using Conditional formatting, conditional blocks, Render variables, Conditional Variables etc
• Created Multi dimensional cubes using power play transformer to easily analyze the data in analysis studio.
• Using Report studio developed reports like Crosstab, Grouped lists, Charts, dashboard reports.
• Using Token, Slicer prompts, Advanced Dimensional functions for Dynamic selection of the Group/Regional Packs.
• Created Prompts, Cascading prompts, Date Range Reports, to dynamically select the values by the user.
• Created drill through reports, master-detail reports using parameterized filters.
• Using report studio advance technology options created commentary reports where user can submit/review the comments.
• Involved in the creating of DMR Reports/cubes from existing Packages and reports.
• Performed the administrative duties of scheduling, creating Roles, User Groups etc
• Troubleshoot and tuned FM models and reports for better performance
• Created Adhoc Reports Using query studio.
• Performed the administrative duties of scheduling, creating Roles, User Groups, etc
• Used Ranked to show Top or Bottom performers in client business.
• Involved in UAT Testing, Peer Reviews of developed reports.
• Ensure reports and reporting application are provided and developed in time and according to customer requirements.

Confidential

Environment: Cognos v8.x,TM1 9.5.1 (FM,Report Studio & Query Studio, Administration)

Responsibilities:

• As part of SME team (L2) Involved Development of New report packs, and resolving all data related issues between TM1 and Cognos BI report packs.
• Assisting the L1 support team for User acceses, Roles, groups and Admin tasks.
• Interacting with the Global Users /clients/L3 project team for all the application support issues, Knowledge transition and for all the gaps at different Levels.
• Involved in creating of FM Models from the base TM1 cubes as back end source for reporting and published the package.
• Using report studio advance technology options created a commentary reports where user can submit/review the comments
• Involved in the creating of DMR Reports/cubes from existing Packages and reports.
• Using Report studio developed reports like Crosstab, Grouped lists, Charts, reports.
• Created Adhoc Reports Using query studio.
• Performed the administrative duties of scheduling, creating Roles, User Groups, triggers etc
• Troubleshed and tuned of FM models and reports for better performance.
• Created various types of reports like Complex Cross tabs, Drill through, Dashboards, for various Finance Operations and Functions/Global Businesses.
• Created conditional formatting, conditional blocks, Render variables, Functions, Conditional Variables etc
• Using Token, Slicer prompts, Advanced Dimensional functions for Dynamic selection of the Group/Regional Packs.
• Created Prompts, Cascading prompts, Date Range Reports, to dynamically select the values by the user.
• Created drill through reports, master-detail reports using parameterized filters.
• Used Ranked to show Top or Bottom performers in client business.
• Involved in UAT Testing, Peer Reviews of developed reports.
• Ensure reports and reporting application are provided and developed in time and according to customer requirements

Confidential, Atlanta

Environment: Cognos, 8.4.1, 8.3 (FM,Report &,Query Studio),Transformer 8.4,SQL Server 2005

Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Knowledge with Dimensional Data modeling, Star Schema/Snowflake Schema, Fact and Dimension tables.
• Report Design & Development of Multi Dimensional Reporting (DMR) reports that use various multidimensional functions.
• Designed and Implemented metadata models in Framework Manager.
• Implemented data level security to secure the data in reports and dashboards.
• Implemented report bursting to distribute reports more effectively.
• Successfully led the development of CBID Analytic Requirements.
• Imparting technical knowledge on Multidimensional report authoring to other team members.
• Coordinating with global teams and working on high priority issues.
• Mentored newly inducted team members by giving knowledge transition in both technical and functional areas.
• Coordinating with Onshore Team for project deliverables and working on high priority issues.
• Co-facilitate trainings to a typically small to medium group of users/team.
• Requirements Analysis and co-ordination with the client to freeze on the requirements.
• Designed and developed the PowerPlay models in Transformer.
• Created cubes in Transformer using Framework Manager Packages and report studio reports as a source.
• Enhancements/Changes to the Framework Manager Models.
• Developed Drill through, Bursting & Master-detail relationship reports, list reports, charts, crosstabs in Cognos 8.4.
• Used conditional variables, render variables, cascading prompts.
• Involved in performance tuning.
• Testing the reports for data accuracy, formatting and performance.
• Converted quite a large number of existing crystal reports to Cognos 8.1 Report Studio.
• Analyzed the SQL queries & stored procedures thoroughly of the existing crystal report to ensure the functionality is not missing and implemented the same in Cognos.
• Applied Query Calculations and Layout Calculations, conditions etc.
• Developed reports with conditional formatting to highlight the data.
• Also added new features to converted reports to enable more interactivity to users like prompt pages, conditional formatting etc.
• Developed drill through reports and burst reports.
• Tested the reports for data accuracy, formatting and performance.
• Involved in converting a few existing impromptu reports to Cognos 8.3 using Report Studio.
• Applied enhancements as per the client to the conversion reports to enable more features while running.
• Involved in conversion of complex SQL to Cognos reports using Report Studio.
• Applied complex query calculations and layout calculations, conditions etc.
• Testing the reports for data accuracy, formatting and performance.

Confidential

Environment: Cognos 8.2(FM,Report Studio, Analysis Studio, Query Studio)SQL Server 2000

Responsibilities:

• Using Report studio develop reports like lists, Grouped lists..
• Created different types of reports according to the Client requirements
• Created Prompts to dynamically select the values by the user.
• Created drill through reports, master-detail reports using parameterized filters
• Used Ranked to show Top or Bottom performers in client business.
• Prepare the PDF & Excel from IMR files for data matching with Cognos 8.3 reports.
• Testing Reports using review checklists for Quality Assurance.
• Created different types of reports according to the Client requirements.

Confidential

Environment: Cognos 8.2(FM,Report Studio, Query Studio), oracle9i

Responsibilities:

• Involved in design and development of Joins, filters, calculations in report studio.
• Using Report studio advanced reporting techniques like conditional formatting.
• Using Report studio develop reports like Cross tab, Grouped list and Charts
• Used Drill through operation done for different aspects of client business
• Created Prompts, Cascading prompts to dynamically select the values by the user.
• Applied bursting to burst the reports at region, district and territory levels
• Used Ranked to show Top or Bottom performers in client business.