SUMMARY

• Result oriented professional with 13+ years of IT experience with 9+ years of experience in Analysis, Design, Development, Administration, Security and Ongoing production support in Cognos 10.2.1 and Informatica on Windows and Linux Env.
• Extensive experience on different Cognos 10.2.1 products ( Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Active Reports, Workspace, Workspace advanced, Dynamic cubes).
• Experience in installation and configuration of Cognos 10.2.1, Cognos 8.X BI.
• Sound working domain knowledge in Banking, Pharma, Property and Casualty Insurance, HR, Utility, Retail, Gaming, Education, Healthcare and Government.
• Ability to effectively communicate with various business groups to gather requirements and prepare functional and technical documents.
• Data modeling experience using Cognos Framework Manager and well convergent with concepts of Star - join Schema/Snowflake modeling, FACT & Dimensions tables and Logical & Physical data modeling.
• Strong proficiency in different SDLC methodologies including Agile and linear models.
• Expert level with developing OLAP models, using Power plays Transformer.
• Strong skills developing DMR models in Framework Manager and Multidimensional reports in Report Studio
• Delivered solution-oriented complex reports using Report Studio and development of ad-hoc reporting interfaces using Query Studio and analysis of reports from cube packages using Analysis Studio.
• Experience in designing and developing of indexes, views, materialized views, triggers, functions, stored procedures and packages with performance tuning for development, test and production environments.
• Experience working at State Govt projects at New Mexico, Missouri, District of Columbia, South Carolina and Common wealth of Massachusetts.
• Basic knowledge of DB2 UDB database.
• Good Knowledge of Cognos TM1 10.2
• Capable of working in groups as well as independently with excellent communication skills.
• Good in trouble shooting with quick turnaround in fixing the issues.

TECHNICAL SKILLS

BI Tools: Cognos 10.2.1, Cognos 8.4 BI, Business Objects XI Rel 2.0

Planning and Forecasting: Cognos TM1 10.2

Visualization: Tableau 8.2.

ETL Tools: Informatica 9, Data stage 7.5, Microsoft SSIS 2010.

Data Bases: Oracle 11G, SQL Server 2010, Teradata V2R6, DB2 8.0

OS: Windows 8, Linux 3.15.

Web Servers: Apache web server, IIS 7.0.

Languages: C, HTML, SQL, PL/SQL.

Scripting: Unix Shell, VB Script.

Internet Technologies: HTML, DHTML, ASP, Java Script and VB Script, XML.

ERP: Oracle EBS 12, Peoplesoft 8.0.

PROFESSIONAL EXPERIENCE

Confidential

Senior Cognos Consultant

Responsibilities:

• Worked with the Business to define the scope of the reporting component and involved in organizing and attending functional design sessions for various reporting components
• Designed and developed using best practices for performance of Reports using features like (Conditional Formatting, Conditional Page layout, multi-level queries using joins, union data sets, Drill Through, Tabular SQL and variables).
• Developed FM modeling Layer with Star and Snowflake schema groupings, Parameter Maps for enhanced performance to implement macros to build the dynamic functionality to enforce dynamic behavior.
• Strong knowledge on appropriate relationships between Query Subjects and Define Determinants as and when required.
• Designed and developed Headcount cube using Transformer with package as the source.
• Developed Script to schedule the Cubes to build on transformer Servers and will be executed with Control-M jobs.
• Designed and Developed solar dashboard for residential and commercial customers using portal pages and workspace.
• Used Active reports to create notification dashboard to analyze user’s usage and send notifications to mobile devices.
• Maintained interactive and bursting versions for each report and bursting the reports based on Dept.
• Analyze and comparing the reports data with analysis studio with selected filter conditions.
• Worked onbug fixingand enhancements to existing Cognos reports inReport Studio& models in Framework Manger Identifying root cause, prioritizing of problems and resolve break fixes.
• Installed & configured the Cognos 10.2.1 BI Environment, Administering the Servers, Troubleshooting, security, maintenance and Performance Tuning of servers.
• Start and stop, back up, restore of the servers to troubleshoot issues identified by business while Cube build or Job failure.
• Worked on creating mappings and workflows using Informatica for Headcount database and further created Cube, which is a replacement for existing system using flat files.
• Worked as part of ETL support team to handle 24/7 support and maintainance of Jobs and workflows.

Environment: Cognos 10.2.1 BI, Active Reports, Workspace, Transformer, Report Studio, Analysis Studio, Framework Manager, Oracle 11g, Informatica 9, SQL Server Management Studio 2010, Control-M.

Confidential

Senior Cognos Consultant

Responsibilities:

• Interacted with different business teams to collect the requirements for reporting analysis. Analyzed current business processes, assess opportunities for redesigning these processes.
• Used Framework Manager to build models, packages, Query Subjects, Query items, Relationships, Calculations, Filters, Functions, Folders, data Sources and published packages to Cognos connection.
• Created various complex reports which involve drill through definitions, conditional formatting, JavaScript’s, conditional blocks used in the Forecast Accuracy, Time&Revenue, Project Type Distribution using Report Studio.
• Used the Transformer model in the Framework Manager and published the packages consumed by report studio reports.
• Performance tuning of the existing report studio, dimensional reports and cubes.
• Involved in Production Support and Maintenance of existing cubes, reports, Tableau dashboards.
• Responsible for providing access to users and stakeholders across all environments.
• Migration of worksheets, User Management and Environment Maintenance in Tableau 8.2.
• Worked onbug fixingand enhancements to existing Cognos reports inReport Studio& models in Framework Manger.
• Worked onAnalysis Studioto develop multi-dimensional reporting. Analysed Business requirements from the analysts.
• Scheduled the reports on a daily, weekly or monthly basis as per user’s request.
• CreatedActive Reportwhich provides an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.
• Created Dashboards in Cognos Workspace Advanced using chart widget, crosstab widget and Formatting layout by drill up and drill down and Applying conditional formatting to the dashboard.
• Created Indexes and Views using SQL to enhance the performance of the reports.
• Involved in the Cognos administration like creating new data source connections, handling the deployment of reports from development to production server and responsible for troubleshooting Cognos BI Server issues.
• Involved in creation of various Tableau 8.2 worksheets using various visualization techniques.
• Created Sites, Projects, Views, worksheets, views, and data sources in Tableau 8.2 across multiple environments.
• Provided End User training in Workspace Advanced and Tableau.
• Involved in creation of technical specification documentation and actively involved in unit testing of multiple applications.
• Performed unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
• Coordinated with Offshore team to manage day to day activities and project deliverables to meet the project timelines.

Environment: Cognos 10.2 BI, Tableau 8.2, Active Reports, Workspace, Transformer, Report Studio, Analysis Studio, Framework Manager, Oracle 11g, SQL Server Management Studio 2010, SSIS, MetaManager, ITSM

Confidential

Senior Cognos Consultant

Responsibilities:

• Worked closely with the Business Analyst & System Analyst on the client side to define the scope of the reporting component. Actively involved in organizing and attending functional design sessions for various reporting components.
• Translated the notes gathered during these design sessions into functional design documents that were later used for report development.
• Shared the duties of developing metadata models using Cognos Framework Manager for enterprise wide reporting.
• Developed the model in line with best practices suggested by Cognos. Model was developed with a Database Relationship Layer, Business Layer and Presentation Layer.
• Developed Dashboards for various Business groups using Report Studio.
• Developed highly analytical reports that track Environmental risk activity like Crude rate, adjusted rate, Confidence Interval.
• Many of these reports were developed using highly beneficial features of Cognos such as Drill Through, Conditional Rendering, Style Formatting, Component Reference components, Embedding HTML Components for Webigeo Maps.
• Geospatial mapping tool Webigeo is used to integrate with Cognos in the delivery of business intelligence solution.
• Provided production support with the issues occurring in the environment for daily, monthly reports.
• Involved in the Cognos administration like creating new data source connections and creating packages, handling the deployment of reports from development to production server and also handling the user permissions on the packages and folders.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Performed unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
• Assisted in integration, systems, acceptance, and other related testing as needed.
• Identifying root cause, prioritizing of problems and resolve break fixes

Environment: Cognos 10.2 BI, Webigeo, Business Workspace, Transformer, Report Studio, Analysis Studio, Framework Manager, Oracle 11G.

Confidential

Senior Cognos Consultant

Responsibilities:

• Analyzed the business functional requirements and worked with the business units to define the strategy of the business and created IBM centralized reporting capability.
• Created multiple relational models and DMR models based on the requirements.
• Created Framework packages with various security settings and published onto cognos connection.
• Created Database layer, Business layer in the model by defining appropriate relationship between query subjects.
• Defined package level, object level securities to allow users create calculations over the query items.
• Modified Power Cubes by adding new Dimensions, Levels and Measures.
• Designed summary and detail reports which involves the key functionalities of the report studio like conditional blocks, conditional layouts. Designed reports which involve drill down, drill up and drill through functionalities in report studio.
• Developed analytical reports for Enrollments, Scholarships, Completions, SAT, Programs, Courses & Faculty.
• Created drill through definitions in the reports based of the cubes to drill down to detail level of the data.
• Created dashboard-style reports combining list, cross-tabular, and chart displays to give executives an "at-a-glance".
• Responsible for troubleshooting Cognos BI Server issues.
• Administering user access to reporting applications which includes setting up cognos security by assigning users to the groups and roles defined in the cognos Namespace.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.
• Scheduled and distributed reports using Schedule Management In cognos connection.
• Performed unit testing and documented test cases and detail design of the project

Environment: Cognos 10.1.1 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight advanced, Power play Transformer), Oracle 11g.

Confidential, Uncasville CT

Senior Cognos Developer/Admin

Responsibilities:

• Communicate with the internal business users to gather requirements and systems analysis of business process and create functional and Technical specification documents.
• Involved in Technical Architecture to set up new servers for Cognos development, UAT and production environment and upgrading from Cognos 8.4 to Cognos 10.1.
• Managing user access and Cognos capability mapping through LDAP groups.
• Generating ad-hoc reports from audit database regarding usage, user count, report or cube build failure tracking etc when demanded by projects.
• Debugged and suggested solutions for problems in existing Report designs
• Used Cognos Best Practices for creating FM Packages, Reports, Dashboards and cubes.
• Created Dashboards in Cognos Business Insight for Slots by Applying filters and Configuring widget controls to customize the dashboard.
• Created Dashboards in IBM Cognos Business Insight Advanced for Slots using chart widget, crosstab widget and Formatting layout by drill up and drill down and Applying conditional formatting to the dashboard.
• Conducted User training for Business Insight Advanced users.
• Created Analysis studio reports using Nested crosstabs, context filters, Drill through.
• CreatedActive Reportswhich made offline analytics easy to get truly portable business intelligence.
• Created Reports with Conditional Formatting, Conditional Page layout, Master-detail, Drill Through, Scheduling.
• Performance tuning by analyzing and comparing the turnaround times between Teradata SQL and Cognos.
• Manage tasks and effort for enhancement releases and other critical support activities.

Environment: Cognos 8.4, 10.1.1 BI (Life Cycle Manager, Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight advanced, Power play Transformer), Oracle 11g, Teradata V2R6.

Confidential, Washington, DC

Senior Cognos Consultant

Responsibilities:

• Analysis of the business requirements, understanding client's data warehousing requirements and system analysis of business process.
• Collaborate with business users to capture and document their analytical requirements.
• Strong experience with client interaction, understanding business applications, business data flow, data relations to gather Requirements and create functional and Technical specification documents.
• Translate requirements into flexible semantic layers using solid semantic layers, deploy solutions that provide easy to build ad-hoc analyses and visualizations.
• Interacting with the users for understanding of Data Analysis of Fixed assets module and deriving its underlined table structure.
• Identifying the relationships between Fixed Assets, G/L, Receivables module tables and designing facts and Dimensions from Oracle EBS system.
• Used Cognos Best Practices for creating FM Packages, DMR and Reports. Followed Kimball’s methodologies for star schema design.
• Developed various fixed asset property reports including Monthly G/L Posting, Depreciation Summary, Book Value Report and Asset Acquisitions reports.
• CreatedActive Reportswhich made offline analytics easy to get truly portable business intelligence.
• Performed Cognos administrative tasks including security, user accounts, software installations and deployments
• Created Dashboards in IBM Cognos Business Insight Advanced for Fixed assets using chart widget, crosstab widget and Formatting layout by drill up and drill down and Applying conditional formatting to the dashboard.
• Developed interactive Dashboards using in-report prompts, custom portal pages and inter-portlet communication techniques
• Skilled at training users to use Query Studio, Analysis Studio and Business Insight Advanced.
• Created several Reports with Conditional Formatting, Conditional Page layout, Master-detail, Drill Through, Scheduling.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.

Environment: Cognos 10.1.1 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight advanced, Power play Transformer), Oracle EBS 12.1, Oracle 11g, Toad.

Confidential, Windsor CT

Cognos Lead

Responsibilities:

• Involved in the full project life cycle of planning, development and implementation stage across Cognos applications.
• Strong experience with client interaction, understanding business applications, business data flow, data relations to gather the requirements and create functional and Technical specification documents.
• To handle the requirement, we started developing the Framework Manager Models using multiple data sources and these models were published as multiple packages to the Cognos report servers for building the cubes and the reports.
• The data modeling was done using the Star Schema model and the database layer and the business layer were created in the model defining the relationship between the query subjects.
• Used Cognos Best Practices for creating FM Packages, DMR and Reports. Followed Kimball’s methodologies for star schema design.
• Created appropriate user classes, groups, database signons in Access Manager to provide different levels of authentications and privileges.
• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting using the Rendering and Conditional Variables.
• Developed the Dashboard and Scorecard reports using Cognos Report Studio and Metric Studio respectively.
• Created analysis reports/graphs using a DMR (Dimensionally modeled relational) package.
• Involved in the Cognos Administration like creating new Data source Connections and Creating Packages, handling the Deployment of reports copying from Development to Production server and also handling the user permissions on the Packages and Folders.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Provided production support with the issues occurring in the old environment for daily, monthly reports.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Involved in daily scrum meetings and sprint planning meeting.
• Created test plans, cases and scripts from Use Cases and other user requirements.

Environment: Cognos 8.4 BI, Cognos 8.4 Transformer, Analysis Studio, Metric Studio, Framework Manager, SSIS.

Confidential

Senior Consultant

Responsibilities:

• Involved in the full project life cycle of planning, development and implementation stage across Cognos applications.
• Strong experience with client interaction, understanding business applications, business data flow, data relations to gather the requirements and create functional and Technical specification documents.
• Used Cognos Best Practices for creating FM Packages, DMR and Reports. Followed Kimball’s methodologies for star schema design.
• Set Data and Object level security inside FM package before publishing to Cognos Connection.
• Created several Reports with Conditional Formatting, Conditional Page layout, Master-detail, Drill Through, Scheduling,
• Security and other complex features.
• Extensively worked on bursting reports to 10 Districts, 9 Troops, 110 Counties and 962 Cities by naming them as per
• Prompt selection.
• Resolved abruptly terminating reports by Configuring Dispatcher URL, Edited the Cognos system files to hide some of the Cognos features from Cognos Users.
• Created appropriate user classes, groups, database signons in Active Directory to provide different levels of authentications
• And privileges.
• Changed advanced settings for Excel and PDF format, increasing the logging level for tracking the user activities.

Environment: Cognos 8.4 BI, Framework Manager, Report Studio, Active Directory, IIS 6.0, Oracle 10g.

Confidential, Atlanta GA

Sr Cognos Developer

Responsibilities:

• Responsible for gathering report requirements, creating functional and Technical specifications.
• Involved in Technical Architecture to set up new servers for Cognos development, UAT and production environment and migrating from Cognos Report net to Cognos 8.4.1.
• Migrated Packages, reports from Cognos report net to Cognos 8.4.1.
• Created dashboards using Report Studio in order to organize the information to change the display type and collaborate with insights about the business performance.
• Created Dashboards in Cognos Connection by Applying filters and Configuring page controls to customize the dashboard.
• Implemented security for Data access, Object level access and Package access.
• Created User Groups, Roles to implement the Cognos Security.
• Created Burst, master detail, conditional formatting, and drill through reports.
• Administration of Cognos Server/Environment including performance tuning and Issue resolution.
• Analyzed, designed and Implemented Multi dimensional cube for Claims analysis.
• Created Dashboard using Go Dashboard for Audit analysis and trained user community.
• Used Dimensional modeling DMR and Snow flake Schema modeling technique to develop models
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Processed and summarized data in the application layer and generated summaries of that data.
• Involved in the design and development of indexes, views for performance up gradation wherever required based on the requirement.
• Followed the best practices in development of packages, reports and cubes.
• Created Adhoc reports using Query studio using custom groups and combined filters.
• Created Analysis studio reports using Nested crosstabs, context filters, Drill through.
• Created several Reports with Conditional Formatting, Conditional Page layout, Master-detail, Drill Through, Scheduling,
• User Management, Security and other complex features.
• Imparted guidance and mentoring in Cognos report development best practices.
• Worked on Onsite offshore team environment.

Environment: Cognos 8.4 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Power play Transformer), SQL Server 2008.

Confidential

Cognos Developer

Responsibilities:

• Communicate with the internal business users to gather and document the requirements for Cognos reports in version 8.4 BI.
• Developed and Published Packages in Framework Manager.
• Created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Maintained Content Manager for Cognos8.4.
• Created calculations and filters in the Framework manager model.
• Modified packages to generate reports for better analysis.
• Worked on MDX queries for Multidimensional reports used in Report studio.
• Create Drill through and Master Detail reports using Conditional Formatting, Conditional Page layout, Sections, page breaks.
• Scheduled bursting reports and distribution of Cognos 8 reports using portal administration.
• Created appropriate dimensions and manual levels in the Transformer model.
• Optimized the cube performance by partitioning and caching.
• Modified existing Cubes as per requirement.

Environment: Cognos 8.4 BI, Cognos Data Manager, SQL Server 2005.

Confidential, Tampa FL.

Cognos Developer

Responsibilities:

• Communicate with the internal business users to gather and document the requirements for Cognos reports in version 8.4 BI.
• Developed and Published Packages in Framework Manager, Connecting and testing the data source,
• Created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Create Master Detail reports using Conditional Formatting, Conditional Page layout, Sections, page breaks.
• Created Drill- through reports and Customized Reports with Prompts.
• Created complex Dashboard using report studio having charts and graphs.
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Created test plans from Use Cases and other user requirements.

Environment: Cognos 8.4 BI, SQL Server 2005

Confidential, Santa Fe NM

Cognos Developer

Responsibilities:

• Analyzed the specifications provided by the clients and Developing Technical Design Documents for reports as per client requirements.
• Installed & configured the Cognos 8.4 BI Environment, Administering the Servers, Troubleshooting, and Performance Tuning.
• Created separate views to retrieve specific information.
• Created a single federated view combining the individual views.
• Developed and Published Packages in Framework Manager, Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Created cubes in Transformer using Framework Manager IQD's, packages and report studio reports.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models.
• Customizing Cognos Connection Portal based on user specifications.
• Designed and setup Cognos security using LDAP.
• Developed Dashboard reports using Cognos Report Studio which has count of programs and further drill through for details.
• Worked with Stored Procedure Query Subjects in FM and Reports.
• Created Drill- through reports and Customized Reports with Prompts.
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Created test plans from Use Cases and other user requirements

Environment: Cognos 8.4 BI, SQL Server 2005, VSAM, DB2 9.0.

Confidential, New York

Cognos Developer

Responsibilities:

• Communicate with the internal business users to gather and document the requirements for Cognos reports in version 8.2 BI.
• Involved in Analysis, Design, Development, Migration, Testing and Maintenance of reporting environment.
• Hands on experience of Kimball approaches to data mart implementation using Framework manager.
• Worked on logical and physical modeling like normalization, star schema, data flow diagrams and workflow diagrams.
• Used frame work manager to develop relational as well as dimensional model. Implementing best practices, using disparate data sources. Also worked in multi user modeling environment.
• Worked on multiple data sources to create C Level dashboards, complex reports, drill through, conditional formatting, using manual sql and set operartors.Implemented bursting using cognos report studio.
• Used conditional and dynamic formatting techniques to present the data in a format specified.
• Involved in Query Optimization, Developing Prompt pages, User defined functions and Conditional variables.
• Perform Cognos Administration tasks including the Scheduling and Deploying of metadata and reports from development environments to production environments.
• Modeled dimensional information using DMR methodology in Framework Manager and published Package for comparing Fiscal year Analysis Reports in Analysis Studio.
• Worked with Java programmer for bursting the reports to different users based on security using Cognos SDK.
• Used cube optimization techniques to reduce cube build time in Power Play Transformer
• Worked on Cognos Administration for content management, System Administration, Data management, Security administration.
• Prepared Test cases for SIT/UAT, conducted User Sessions to end user.
• Debugged and suggested solutions for problems in existing Report designs
• Execute the month end process. Production and distribution of daily, weekly and monthly reports, as defined by the business.
• Proficient with database performance management, writing PL/SQL stored procedures.
• Experience writing and executing shell scripts.
• Worked with business users for report validation and knowledge transfer.

Environment: Cognos 8.2 BI, Oracle 10G, Apache, AIX.

Confidential, Detroit

Cognos Developer

Responsibilities:

• Communicating with the business users to comprehend the requirements on converting the business process requirements into technical specifications.
• Manage tasks and effort for enhancement releases and other critical support activities.
• Review and approve offshore code changes that are implemented as a part of releases or support activities.
• Preparing the OLAP Reporting Design Document for reports.
• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Implemented security for Data access, Object level access and Package access.
• Developed and Published Packages in Framework Manager.

Environment: Cognos Report net 1.1 MR3 & Cognos 8.2 BI, BAE Web logic, Oracle 9i.