SUMMARY

• 12+ years of IT experience with 9+ years of experience in Analysis, design, coding, testing, implementation, document and ongoing production support for Cognos 10.2, 8.x, 7 on multiple database platforms.
• Extensive experience on different Cognos 10.2 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, Cognos 8.X BI, & 7 Series.
• Great breadth of knowledge about how to implement Business Intelligence solutions across the many different functional areas of an organization.
• Sound working domain knowledge in Banking, Pharma, Property and Casualty Insurance, HR, Retail, Gaming, Education, Healthcare and Government.
• Ability to effectively communicate with various business groups to gather requirements and prepare functional and technical documents.
• Experience inOLTP/OLAPSystem Study, Analysis and ER Modelling, Maintaining Database Schemas likeStar SchemaandSnowflake Schemaused in relational and dimensional modelling and Kimball methodology.
• Strong proficiency in different SDLC methodologies including Agile and linear models.
• Expert level with developing metadata models in Framework Manager following best practices
• 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 using Audit database native to Cognos to understand resource usage and implement performance measures.
• Experience with Multiple Relational Databases including Oracle, SQL Server, Teradata and IBM DB2.
• 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.
• Experience in designing and developing of indexes, views, materialized views, triggers, functions, stored procedures and packages.
• Experience working at State Govt projects at New Mexico, Missouri, District of Columbia, South Carolina and Common wealth of Massachusetts.
• Experience in developing Project process related documents as per the CMM i standards.
• 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.2, Cognos 8.4 BI, Business Objects XI Rel 2.0

Visualization: Tableau 8.2.

ETL Tools: Informatica 8, Data stage 7.5, Microsoft SSIS 2010, Cognos Data Manager.

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

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.

Tools: MS Office, Visio, Erwin, TOAD, VSS.

Operating Systems: Windows XP, UNIX, Linux.

ERP: Oracle EBS 12, Peoplesoft 8.0.

PROFESSIONAL EXPERIENCE

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.
• Developed and tuned complex PL/SQL queries for better performance.
• 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.
• 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.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.
• Assists 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, 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

Developer

Responsibilities:

• To interact with the Clients and On-site coordinator on a regular basis for resolving issues pertaining to the data delivered and change requests
• Initial analysis and understanding of Specification documentation and report layouts, Synchronizing Catalogs with latest views, adding the joins wherever necessary.
• Create Calculations and prompts at Folder levels, designed the Report formats and developed reports using Impromptu, and Developed multiple Impromptu reports and Documented as per client requirements.
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Involved in developing design documents and mapping documents.
• Modified the existing ETL code (Mappings, Sessions and Workflows) and the shell scripts as per the user requirements.
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance, as the volume of the data was heavy.

Environment: Oracle 9i, Informatica, Cognos 7.1 mr3, 7.3 mr2

Confidential

Developer

Responsibilities:

• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Involved in developing design documents and mapping documents.
• Modified the existing ETL code (Mappings, Sessions and Workflows) and the shell scripts as per the user requirements.
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance, as the volume of the data was heavy.

Environment: Informatica 7.1, Oracle 9i.