SUMMARY

• IT Professional with over 14 years’ experience in all phases of Software Development Lifecycle including Requirement gathering, Analysis, Design, Prototype, Development, Testing, Deployment, Delivery, Support and training.
• Extensive experience of over 9 years in Cognos x ( Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Active Reports, Workspace, Workspace advanced, Dynamic cubes).
• Sound working domain knowledge in Banking, Pharma, Property and Casualty Insurance, HR, Utility, Retail, Gaming, Education, Healthcare and Public sector.
• Proficient in analyzing and translating business requirements documents to technical specs and report mock ups.
• Data modelling experience using Cognos Framework Manager with concepts of Star - join Schema/Snowflake modelling, FACT & Dimensions tables and Logical & Physical data modelling.
• Expertise in working with various heterogeneous and legacy sources like Oracle, DB2, Teradata, Flat files into staging area.
• Experienced in using agile methodology for planning, scheduling and control of post-production support and enhancement activities.
• Expert level with developing OLAP models using Power plays Transformer, DMR models in Framework Manager, Multidimensional reports using MDX Functions 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 in 24X7 production support, ETL executions and resolving root causes.
• Experience working at State Govt projects at New Mexico, Missouri, District of Columbia, South Carolina and Common wealth of Massachusetts.
• Good understanding of Project Management process.

TECHNICAL SKILLS

BI Tools: Cognos 10.2.2, Cognos Analytics 11.0.5

Visualization: Tableau 10.2, Qlikview 12.1

ETL Tools: Informatica 10.1

Data Bases: Oracle 11G, SQL Server 2010, Teradata 15

OS: Windows 10, Linux 3.15.

Web Server: Apache web server, IIS 7.0.

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

Scripting: UNIX Shell.

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

Application Management: HP Quality center 11.

Incident Management: Service Now, ITSM Remedy.

Versioning: PTC Integrity MKS client.

Scheduling: Autosys 11.1.

PROFESSIONAL EXPERIENCE

Confidential, IL

Cognos Architect

Responsibilities:

• Installation and configuration of all the suites of Cognos 10.2.2 BI products and setting up Content store database, Active directory configuration.
• Worked with the business users in identifying and defining the product requirements and directions.
• Setting up the Content store by creating content databases in Oracle 11g
• Set up Audit tables, Audit Report in Cognos Environment to analyze the Report Usage.
• Ensured the overall health of the Cognos Application
• Configured new users and projects within the Cognos environment.
• Applied maintenance releases, upgrades and hot fixes as required
• Design, implement, and maintain Cognos Application security
• Good working experience with IBM Cognos Analytics on Cloud.
• Demonstrated experience with working with the Cognos vendor on product related issues affecting the client base.
• Involved in gathering Business Requirements and prepared the requirements specification documents.
• Developed complex report layouts/multi-page List, Chart, Crosstab reports using features like Conditional blocks, cascading, Master - Detail, Drill Through, Filters in Report Studio to meet business requirements.
• Creating the Framework Manager model suitable for the reporting structure.
• Created the user defined classes in report studio and override the existing classes for formatting of the report.
• Created and scheduled jobs and reports in Cognos Connection according to delivery schedules set by the users.
• Used set operations like union and joins at query level in report Studio to display data as required by business.
• Enhancing and modifying the reports as per the Change Requests.
• Resolved data mismatch issues between Supply chain cubes and source tables.
• Coordinated with Offshore team to manage day to day activities and project deliverables to meet the project timelines.

Environment: Cognos 10.2.2 BI, Cognos Analytics 11.0.5, Meta manager 5, Report Studio, Framework Manager, Transformer, Oracle 11G, MKS client, Service now, Autosys 11.1.

Confidential, AZ

Cognos Architect

Responsibilities:

• Worked with the Business to define the scope of the reporting component and involved in functional design sessions for various reporting components and created technical designs and system use cases.
• 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 schema, Parameter Maps for enhanced performance, implemented macros to build the dynamic functionality to enforce dynamic behavior.
• Ensured clear query paths by resolving ambiguous relationships and loops. Have Strong knowledge on appropriate relationships between Query Subjects and defined Determinants 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 executed with Control-M jobs.
• Designed and Developed solar dashboard for residential and commercial customers using portal pages and workspace.
• Worked on Active reports to create notification dashboard to analyze user’s usage and send notifications to mobile devices.
• Developed AMI Dash Board reports in Report Studio using Active Report.
• Maintained interactive and bursting versions for report and bursting the reports based on Dept.
• Worked onbug fixes, enhancements for reports, dashboards, models by identifying root cause and resolve break fixes from User Acceptance Testing.
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Tested reports and dashboards in Cognos Analytics 11 Dev Environment for their functionality.
• Created mappings and workflows using Informatica for Headcount database and created Cube, which is a replacement for existing system using flat files.
• Trained end users effectively to use Analysis studio, workspace advanced, to build and customize their Ad-hoc reports and dashboards.
• Worked as part of ETL support team to handle 24/7 support and maintenance of Jobs and workflows.

Environment: Cognos 10.2.1 BI, Cognos Analytics 11, Motio CI, Active Reports, Workspace, Transformer, Report Studio, Analysis Studio, Framework Manager, Oracle 11G, Informatica 9.6, SQL Server Management Studio 2012, Control-M.

Confidential, MA

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, ITSM

Confidential, MA

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.

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

Confidential, SC

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, Active reports, Business Insight, Business Insight advanced, Power play Transformer), Oracle 11g.

Confidential, Washington, DC

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, MO

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 znd 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, 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 turnaround 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, NYC, NY

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.