SUMMARY:

• Cognos IBM Certified Professional with 13+ years of total IT industry experience analysis, design, testing, development and implementation of client/server applications
• Having 13 +years of Data Warehousing technological experience in BI Reporting tool Cognos series and experienced in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using Cognos 8.4 &10.2 Suite (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Go office), CRN 1.2, Cognos IMR 7.1.2.4, and Analysis Tools such as Cognos Transformer & Power Play.
• Having Experienced in OLAP Tool Transformer for build the Cube and MDX Reporting. in Development, designing, deployment. and Production Support and Maintenance, Encashment. Migration /Upgrade Cogon’s Administration
• Having 3 Years of experience in providing architectural solutions.
• Having Tableau Expertise in Administration, designing, development and deployment.
• Have experience in implement IBM open page with Cognos Administered user, user groups, and scheduled instances for reports in Cognos
• Having Experience in Dashboard and Managing scalability and capacity requirements for the Cognos solution for Customer And having2 Years Exp in Cognos Controller.
• Having 3+ Years’ Experience in IBM Cognos Analytics version 11
• Solid experience with Cognos 11/10.1/8.4 and Cognos TM1 .11, managing user Security using Active Directory etc. to create and manage User profiles, groups and roles.
• Expertise in Integrating Cognos with Big Data such as Impala (Claudera), Amazon Redshift.
• Clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on BI Life Cycle Development.
• Expertise in performancebenchmark for the Cognos server, by performing performance testing using Motio PI, Motio CI and Life Cycle Manager
• Extensive Knowledge of Cognos SDK
• 3+ Years Experience in ETL Informatica Power center 9.6
• Experience in Business analysis role involved requirement gathering and delivery on time.
• Experience in Cognos 10 .2 BI Tools (Business Insight, Active Reports, Business Insight Advanced, Cognos Workspace, Cognos Workspace Advanced,), And Dynamic Cube designer designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS 7/ 8, 10.1.2 and Cognos Report Net and Cognos 10.2
• Experience in Managing Offshore - Onsite model projects, T&M Projects, Fixed Bid Projects. Strong understanding of Agile software development and Waterfall methodology
• Good in planning, scoping, scheduling, budgeting and Delivering and Having High-level leadership and mentoring ability. Good in interpersonal and communication skills, Team building and motivating team members.
• Understanding in using Oracle queries and awareness in SQL server
• Strong development and analytical skills, proficiency in root cause data analysis, and Experience in Cognos 8.4 to 10.2 Migration, Created Power cubes Using Power play Transformer and published as package for Studios. Experience in Cognos And Tableau Production Support project
• Extensive Knowledge on other BI Report Business Object and Qlikview Reporting Tool Good understanding of ETL process and RDBMS Concepts and A self-starter willing to tackle new and challenging problems and able to work in a fast-paced environment, with strong problem solving skills.

TECHNICAL SKILLS:

BI Tools: Cognos 7EP, Report Net MR 1.1, Cognos 8x, Cognos 10.1, 10.2, TM1, LCM (Life Cycle Manager, Business Objects, Qlik View, Tableau

Databases: Oracle 9.x/10g/11g, SQL Server, MySQL DB2, Informix, IBM Cognos Controller.

Domain: Insurance, Healthcare, Banking, Compliance and Federal Reporting Financial, Sales Manufacturing, HR

ETL: Knowledge on Informatica power center 9X, Data Stage, Remedy, Alteryx

PROFESSIONAL EXPERIENCE:

Sr. BI Reporting Developer / Data Analyst

Confidential, Pleasanton, CA

Responsibilities:

• Working with business stake holders, gathering requirements and managing the delivery.
• Used Sheet filters to produce multiple chart types in a single view.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types and Used Set function manual. And Created Advanced grouping function.
• Support Administration Report Backups and user security deployments.
• Having Experience in Cognos 8.4 to 10.2 Upgrades and patching Monitor system Environment,
• Identify Problem and troubleshoot and resolve issue and created Active reports
• Created various Prompts, Conditions and Filters to improve the report performance by means of Detailed and summary filters, created various reports in Report Studio reports
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
• Data source creation and modification Monitors performance on the application and Scheduling Reports according to the client Request
• Worked on complex reports involving Drill-Through Definitions, Multi-query, and Master/Detail relationships. Involved in creating security and deployment (exports and imports).
• Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized and added user classes based on the requests.
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc. Used Union/Join objects in Report Studio
• Used Set function manual and automation. And Created Advanced grouping function.
• Handling Performance Recording and analyzer
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Created various Prompts, Conditions and Filters to improve the report performance By means of Detailed and summary filters, created various reports in Report Studio reports
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Created rich Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Make recommendations relating to accounting and financial data processing systems to ensure effective and efficient financial operations
• Manage overall accounting function, providing oversight and direction to the accounting and finance team
• Actively participate in oversight on cost reduction efforts by identifying, evaluating and monitoring cost reduction opportunities
• Guide financial decisions by establishing, monitoring, and enforcing policies and procedure.
• Generated context filters and used performance actions while handling huge volume of data. And tableau dashboards for sales with forecast and reference lines. User Java Script API to customize the views, selects, filters, date and time. Created dashboards with combination charts for clear understanding. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.

Environment: Cognos 10X. Cognos FM 10x, Cognos Controller 10.31, Cognos Transformer Suite, ETL Informatica 9.5Oracle SQL

Sr.BI Cognos Consultant / Business Analyst

Confidential, Charlotte, NC

Responsibilities:

• Analyzing and gathering business requirements by working with Product owners and business users.
• Responsible for Preparing the Business requirements and details design documents for the Consumer/Non-Consumer & Voc Reporting Applications.
• Responsible for performing User acceptance Testing and Integration testing.
• Worked on framework manager to import metadata from multiple data sources.
• Worked on the Complex Active Reports to provide the interactive behavior.
• Developing BI dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
• Making enhancements of the report/Dashboards based upon the requirements of the user.
• Created reports & Dashboards using Tableau for Internal management team.
• Creating the Transformer and publishing the Cubes to Cognos Connection to be used for multidimensional analysis.
• Working on Cubes and cube-based report. Work closely with ETL team to ensure timeliness of data loads reflected in report.
• Troubleshoot issues with existing reports. Used Cognos Connection to administer and schedule reports to run at various intervals of time
• Implementing data level security according to various user classes.
• Streamlining existing processes, Upgrading of Cognos 10.1/10.2 reports to Cognos Analytics and driving standardization
• Bursting the reports in various formats, such as PDF, excel and sending via e-mail
• Refreshing cubes on demand and for core business processes
• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS)Accountable for creating financial Reports and Dashboards. Application has been designed driver-based planning - an approach that bases financial forecast on operational drivers supports Companies performance management. Created rolling forecast based budgeting, this will help FP&A team to plan ahead and more often and updated forecast with actuals. Developed several data input forms for Capex, Workforce and Financial statement planning.

Environment: Cognos 11. Cognos FM 11, ETL Informatica 9.5Oracle SQL

Sr. Cognos Consultant/Architect

Confidential, Austin, TX

Responsibilities:

• Developed, Production Supported, Upgraded, Tested.
• Migrating Cognos Report to tableau.
• Updated the System Requirement Specification (Ticket) with the change requests.
• Worked on multiple work streams and handled the Cognos part of it.
• Created Relational and DMR model using Framework Manager
• Used DB functions and Implemented complex solutions in Cognos report Studio.
• Worked extensively on various types of reports like List Reports, Cross tab, Chart Report, Dashboard, Drill through Reports and different RS functionalities.
• Installed and configured the IBM Cognos Go Office
• Implemented Cognos Security (Row level and Object Level)
• Provided Cognos Training to the Business users to handle and created ad-hoc Reports.
• Unit tested the reports and make the report available for UAT users.
• Tuned the reports to improve the Report performance, Bug fixes on Prod report.
• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Built the Model using Framework Manager Model and worked extensively on creating the Model and publishing the package for Reporting purposes.
• Developed Prompt pages and Conditional Variables, Created Prompts like value, Textbox, Date & time, and cascading prompts.
• Created new calculations according to the report specifications.
• Performance tuned the Reports and Involved in unit testing of the reports.
• Developed various standard reports like list reports, cross tab reports and Drill through reports using report studio.
• Performance tuned the Reports and Involved in unit testing of the reports
• Provided support Analyzed the Report Test Data used for Unit and Integration Testing.
• Used Set function manual and automation. And Created Advanced grouping function. And Handled Performance Recording and analyzer.
• Created complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes

Environment: Cognos 11. Cognos FM 11, ETL Informatica 9.5Oracle SQL

Sr.BI Consultant/ Architect,

Confidential

Responsibilities:

• Define, Create, and manage business specifications, technical specifications, and another project documentation for applications development. And Performed and documented gap analysis.
• Support Administration Report Backups and user security deployments.
• Having Experience in Cognos 8.4 to 10.2 Upgrades and patching Monitor system Environment,
• Identify Problem and troubleshoot and resolve issue and created Active reports
• Created various Prompts, Conditions and Filters to improve the report performance by means of Detailed and summary filters, created various reports in Report Studio reports
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
• Data Source creation and modification Monitors performance on the application and Scheduling Reports according to the client Request
• Worked on complex reports involving Drill-Through Definitions, Multi-query, and Master/Detail relationships. Involved in creating security and deployment (exports and imports).
• Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized and added user classes based on the requests.
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc. Used Union/Join objects in Report Studio
• Handled Cognos admin activities granting access, managing extracts and Installations.

  Assist in business requirements gathering process, including working with end

• Users to interpret functional requirements into report specifications. Involving in writing complex SQL
• Queries to verify data from Source to Target Performed data validation testing writing SQL queries

Environment: Cognos 11, Framework Manager, SQLServer 8.3, Informatica 9.6

BI Team Lead

Confidential, NY

Responsibilities:

• End user reporting handling supporting requirements by developing Reporting solutions on the Tableau and Cognos BI platform. This role will work within the Corporate IT department and support day to day reporting needs for multiple businesses
• Involved in Development, Production Support, Upgrade, Testing. Updated the System Requirement Specification (Ticket) with the change requests.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Handling Tableau server Administration to publish dashboard to a central location for portal integration.
• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on EMPI databases and generated interactive dashboards. Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.

  Generated Dashboards 5zwith Quick filters, Parameters and sets to handle views more efficiently.

  Published Workbooks by creating user filters so that only appropriate teams can view it

• Implement Tableau 8.3 to 9.0 Upgrade.
• Handling Installation and server maintained and back up, User security, coordinate Different Project team
• Played role Onsite SME handling offshore team. Requirement gathering and involved Business Analysis, document creation, report functional documents.
• Design and support public folder reporting via Cognos Report Studio, Query Studio, including any user defined delivery methods.
• Accommodate new and existing business requirements. Assist in business requirements gathering process, including working with end Users to interpret functional requirements into report specifications. Provide support Analyzed the Report Test Data used for Unit and Integration Testing
• Used Set function manual and automation. And Created Advanced grouping function.
• Handling Performance Recording and analyzer
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Created various Prompts, Conditions and Filters to improve the report performance by means of Detailed and summary filters, created various reports in Report Studio reports

Environment: Cognos 11, Framework Manager, Tableau Desktop 8.3/9.0, Oracle, ETL Informatica 9.0

BI Team Lead/Architect

Confidential, Portland

Responsibilities:

• Worked in Development, Production Support, Upgrade, Testing. Updated the System Requirement Specification (Ticket) with the change requests.
• Support for User Acceptance testing and fixing defects. Fixed bugs were documented in the Excel sheet. And Successfully Migrated Cognos 8.4 to 102
• Generation of reports using Conditional Formatting, Cascading Prompts in Report Studio. Developed Drill Through, Master/Detailed Reports in Report Studio. And Support for User Acceptance testing and fixing defects. Fixed Defects were documented in the Excel sheet.
• Worked for Cognos Production Project Rebrand for Logo and other changes done for the Entire Project.
• As Cognos Administrator: Report and Model Migration and Deployed Reports from One Dev to UAT and UAT to Production.
• Data Source creation and modification Monitors performance on the application and Scheduling Reports according to the client Request
• Trouble Shooting the Problems and bringing back the server’s Up, Analyzing the impact and preparing the document
• Involved in Deployment of reports (Import/Export) in Cognos Connection. and in Unit Testing of the code.
• Responsibilities include supporting end user reporting requirements by developing Reporting solutions on the Cognos 8.4.1 BI platform. This role will work within the Corporate IT department and support day to day reporting needs for multiple businesses
• Design develop and support Cognos BI content including reports, cubes, Packages, dashboards, presentation portals etc.
• Design and support public folder reporting via Cognos Report Studio, Query Studio, including any user defined delivery method s.
• Cube building using Cognos Transformer, Coordinate/assist /develop Cognos framework manager model adjustments to
• Accommodate new and existing business requirements. Assist in business requirements gathering process, including working with end Users to interpret functional requirements into report specifications. Provide support Analyzed the Report Test Data used for Unit and Integration Testing
• Administer security permissions access relates issue support end user.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Involving in writing complex SQL queries to verify data from Source to Target Performed data validation testing writing SQL queries. Also involved in performance process testing.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Environment: IBM Cognos 8.4/ 10.2 Framework Manager, Cognos Controller, Cognos Transformer Suite, Oracle SQL, ETL -Informatica 9.0

Sr. BI Tableau Consultant

Confidential

Responsibilities:

• Worked in Development, Production Support, Upgrade, Testing. Updated the System Requirement Specification (Ticket) with the change requests.
• Support for User Acceptance testing and fixing defects. Fixed bugs were documented in the Excel sheet.
• Generation of reports using Conditional Formatting, Cascading Prompts in Report Studio. Developed Drill Through, Master/Detailed Reports in Report Studio. And Support for User Acceptance testing and fixing defects. Fixed Defects were documented in the Excel sheet.
• Worked for Cognos Production Project Rebrand for Logo and other changes done for the Entire Project.
• As cognos Administrator: Report and Model Migration and Deployed Reports from One Dev to UAT and UAT to Production.
• Data Source creation and modification Monitors performance on the application and Scheduling Reports according to the client Request
• Involved in Deployment of reports (Import/Export) in Cognos Connection. and in Unit Testing of the code.
• Responsibilities include supporting end user reporting requirements by developing Reporting solutions on the Cognos 8.4.1 BI platform. This role will work within the Corporate IT department and support day to day reporting needs for multiple businesses
• Design develop and support Cognos BI content including reports, cubes, Packages, dashboards, presentation portals etc.
• Design and support public folder reporting via Cognos Report Studio, Query Studio, including any user defined delivery methods.
• Cube building using Cognos Transformer, Coordinate/assist /develop Cognos framework manager model adjustments to
• Accommodate new and existing business requirements. Assist in business requirements gathering process, including working with end Users to interpret functional requirements into report specifications. Provide support Analyzed the Report Test Data used for Unit and Integration Testing
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Involving in writing complex SQL queries to verify data from Source to Target Performed data validation testing writing SQL queries. Also involved in performance process testing.

Environment: Cognos 8.4, Report Studio, Framework Manager, transformer 8.4 Oracle10g