SUMMARY

• Working as Senior Cognos Developer with close to 9 years of IT experience analysis, design, testing, development and implementation of client/server applications.
• Experienced in designing and implementing each phase involved in DWH and BI SDLC (Software Development Life Cycle).
• Hands on experience of implementing end - to-end BI solution using Cognos, MSBI, Oracle BI, Informatica and Datastage.
• Experience of leading large team in onsite model or onsite-offshore model of project implementation.
• Expertise in Requirement gathering, Administration, Designing, Development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 6 / 7/Report Net/ 8.x/10.x.
• Having knowledge on tools such as Sybase power designer to build data models.
• Experience of Cognos 10.2.1 (Framework Manager, Cognos connection, Report Studio, Workspace, Workspace Advanced and Event Studio).
• Experience in creating Tableau Dashboard.
• Experience with Cognos 10.2.1 Dynamic Cubes.
• Experience with Triggers on Cognos for scheduling.
• Expertise in designing, modeling and architecting Data warehousing Concepts in OLTP/OLAP System. Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Utilized Best Practices and Proven Methodology in data modeling, ETL and other BI development process
• Implemented Security in Cognos using Windows Active Directory.
• Expertise in Framework Manager Modeling (DMR and Relational Models) and Complex Report building with Report Studio
• Expertise in creating Dash board reports and using Java Script in Report studio
• Created Ad-Hoc reports using Query studio and Trained power users to use Query Studio for Ad-Hoc reporting.
• Very good experience in customizing the Cognos connection portal.
• Experienced in installing and configuring Cognos 8.4 and Cognos 8.2 on Apache and IIS web servers.
• Experienced in Designing Business Objects XI Universes.
• Experienced in Designing Reporting Solutions in SSAS and SSRS (Microsoft Analysis Services and Microsoft Reporting Services).
• Experienced in writing PL/SQL scripts, T/SQL scripts and Shell Scripts.
• Experienced in tuning reports and SQLs.
• Interacting with the End users on a regular basis for gathering the requirements and resolving issues pertaining to the reports.
• Deploying models and reports from Development to Production and administering users/groups/roles
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.

TECHNICAL SKILLS

Primary Skills: Datawarehousing (ETL and OLAP).

Operating Systems: Unix(AIX), Windows Xp

Languages: PL/SQL

ETL Tools: SSIS 2012, Informatica 7.2, OWB 10g, Datastage 7.5

OLAP Tools: Cognos 8 Transformer, Microsoft Analysis Services (MS SQL Server 2005)

Reporting Tools: Cognos 10.2, Cognos 10.1,Cognos 8.4, Cognos 8.2, Cognos 8.1,Cognos ReporNet 1.1 MR2, Business Objects XI, Microsoft Reporting Services (MS SQL Server 2005), Tableau 8.1

Scripts: Unix Shell Scripts

Databases: Oracle 10gR2;MSSQLServer 2012

Configuration Tools: Microsoft Visual SourceSafe.

Domain Knowledge: Communication and Manufacturing

Documentation: MS Office and MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Simi Valley, CA

Sr. Cognos Developer

Responsibilities:

• Requirement analysis and rationalization of reporting solutions.
• Involvement in design and development of Cognos/BI Meta Data Models in Cognos Framework Manager, Transformers, Dynamic Cubes.
• Involvement in development of Cognos/BI Reports and Dashboards.
• Design and development of Cognos Workspaces.
• Responsible for development and maintaining SSIS mappings and control flows to extract and load data.
• Tableau Workbook design
• Tableau Reports and Dashboards design
• Migrated SSRS 2008 and SQL reports to Cognos 10.2 version.
• Effectively made changes to DATA-MODEL to support various reports by gaining significant increase in performance.
• Development of Cognos Reports and Dashboards.
• Defined Views and Materialized views for simplifying reporting queries and performance also effectively made use of Query re-write where that change in view or objects has a significant impact on downstream system
• Performed Query optimization to maximize performance.
• Worked with business analysts in gathering business requirements, obtaining clarifications and approvals during functional analysis, data validations and interface testing.
• Ensured that the deliverables are delivered on time to the customer as agreed with the timeframes to ensure that the work will be completed on time.
• Enhancements, Maintenance & system development activities which include formulating the development strategy, preparing the Design & Models as per defined in Process and Procedures and identifying key business scenarios.
• Interacting with all the other interfaces of the project to understand the data flow between multiple interfaces
• Designing technical specifications for various modules. Analyzing technical constraints and compatibility with existing machines. Providing possible solution for hardware replacement if required.
• Brainstorming with the SME’s on Cognos/BI Framework. Implement this approach with the current systems.
• Implement Cognos/BI design methodology to the current project.
• Prepare queries to generate the Cognos BI Report as per the Keane standards

Environment: Tableau 8.1,Cognos 10.2.1, Cognos 10.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio, Workspace, Workspace Advances), Cognos Dynamic Cubes, Cognos Transformer, oracle10g (SQL, PL/SQL), Flat files, Toad, SQL Developer, SSRS, SSIS.

Confidential, Mac Lean, VA

Sr. Cognos Developer

Responsibilities:

• Gathered & analyzed the end-user business requirements.
• Design and Architect Reporting Solutions using Cognos 10.1 and Cognos 8.4 Suites,
• Performing Report Rationalization during requirement gathering.
• Installed and configured Cognos 8.4.1 on window server Environment.
• Worked with Framework Manager to create Projects, Models and Packages and publish them to theCognos8 Servers
• Implemented Third Party Security with Windows AD (Active Directory) and use those in creating Data Level, Object level Security in Framework Manager Models.
• Implemented single sign on in windows AD environment.
• Used Dimensional modeling (DMR) and Relational Modeling techniques technique to develop FM models
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager
• Design and create Multi Dimensional Cubes using Transformer, so that all key performance indicators can be analyzed.
• Created HTML Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created Cube, Dimension Views, Partitioned cube, added Drill Through capability, Cube Group using various data sources in Transformer.
• Created Technical design document for Report studio reports based on Functional specifications.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in Report Studio.
• Involved in designing the Drill UP and Drill Down reports according to the customer needs.
• Designed complex reports and advanced reports according to Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Analyzing all reports and Standardize these reports using Power Prompts and Charts
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports
• Created Scorecards and Metrics using Metric studio
• Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making using Metric Studio
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Developed stored procedures, triggers and complex packages using PL/SQL.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Trace, Stored Outlines.

Environment: Cognos 10.1, Cognos 8.4.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Cognos Transformer, oracle10g (SQL, PL/SQL), Flat files, Toad, SQL Developer, Oracle Power Builder.

Confidential, Herndon, VA

Sr. Cognos Developer

Responsibilities:

• Designing Cognos Framework manager Model for the Data Marts.
• Implementation of Framework Manager Model in Cognos 8.1.
• Implementation of Short-Circuit Logic in Framework Manager.
• Implementation of Data Level, Object Level and Package Level Security in Framework Manager Model.
• Creation of Model Query Subjects, Embedded and Model Filters.
• Developed FM Model against STAR, SNOWFLAKE and Fact Constellation Data Models.
• Creation of Packages and publishing the same.
• Educating business users on how to make use of the Cognos Package/Namespace in Cognos Query Studio.
• Creation of Complex Reports in Report Studio.
• Made use of Value Prompt, Text Box Prompt, Date Prompt, Select and select search Prompts. Almost made use of all it’s properties and feature.
• Created complex report by making use of Style Variable, Render variable and Block Variables in Report Studio.
• Made use of Java Scripts (HTML Items) in Report Studio.
• Writing of stored procedure in Oracle PL/SQL to import and use that as Query Subjects in Framework Manager Model to fulfill specific purpose.
• Creation of Model Query Subjects, Embedded and Model Filters.
• Developed FM Model against STAR, SNOWFLAKE and Fact Constellation data Models.
• Created DMR in Framework Manager Model against relational Data Source.
• Creation of Packages and publishing the same.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Involved in complete Software Development project life cycle.
• Installation & Configuring the Cognos 8.4 on Windows Environment and Configured with LDAP.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Developed the List reports, Crosstab reports, Chart reports, Master detail and Drill through reports.
• Working experience with different date functions like YTD,QTD,MTD in Report Studio
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Created Executive Dashboards, complex reports using Report Studio.
• Developed a prototype to demonstrate the benefits of Performance Indicator Reports that was developed in Metric Studio
• Modifying the existing report based upon the change request by the user.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Worked with Analysis Studio to develop multi dimensional reporting.
• Coded and implemented PL/SQL packages.
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Carried out Testing by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas
• Created documentation for the complete project life cycle and Mentored the End Users and Provided the Technical Support.

Environment: Cognos 8.4/8.2,Oracle 10g, Informatica 8.1

Confidential, Raleigh, NC

Sr. Cognos Developer

Responsibilities:

• SPOC for handling critical incidents in support
• Gathered & analyzed the end-user business requirements.
• Design and Architect Reporting Solutions using Cognos 8.4 Suites,
• Worked with Framework Manager to create Projects, Models and Packages and publish them totheCognos8 Servers
• Implemented Third Party Security with Windows AD (Active Directory) and use those in creating DataLevel, Object level Security in Framework Manager Models.
• Implemented single sign on in windows AD environment.
• Used Dimensional modeling (DMR) and Relational Modeling techniques technique to develop FM models
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager
• Created HTML Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created Cube, Dimension Views, Partitioned cube, added Drill Through capability, Cube Group using various data sources in Transformer.
• Created Technical design document for Report studio reports based on Functional specifications.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in Report Studio.
• Involved in designing the Drill UP and Drill Down reports according to the customer needs.
• Designed complex reports and advanced reports according to Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Analyzing all reports and Standardize these reports using Power Prompts and Charts
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports
• Created Scorecards and Metrics using Metric studio
• Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making using Metric Studio
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Developed stored procedures, triggers and complex packages using PL/SQL.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Trace, Stored Outlines.

Environment: Cognos 8.4.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Cognos Transformer, oracle10g (SQL, PL/SQL), Flat files, Toad, SQL Developer, Oracle Power Builder

Confidential, Minneapolis, MN

Sr. Cognos Developer

Responsibilities:

• Developed Framework Manager Models with Physical layer and Presentation Layer
• To cater the various businesses needs (Folders, Filters, and Macros)
• Implemented Third Party Security with LDAP and use those in creating Data Level security,
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab)
• Prepared User documentation to train users and functionality of each report
• Designed and implemented of Cognos IMB enterprise planning solutions
• Involved in Migrating reports from Impromptu/CRN to Cognos 8.
• Involved in building the Cubes and optimizing the cube creation.
• Extensively worked on Cognos Planning - Creating Models in Analyst by using various built-in-functions.
• Importing the model from analyst to contributor, creating saved selections, access tables, e-list, user classes and user rights.
• Provide a prototype of the exact model which we actually build and get a sign off on the functionality.
• Creating a common library for the model which we are actually building.
• Published cubes and created Power play Reports for the web users.
• Played as a good mentor to the newly joining team by giving knowledge transition in both technical and functional areas.
• Worked on and resolved Unix related issues.
• Performed major upgrades of unix utilities tool kits for windows 98,NT
• Responsible for overseeing the Quality procedures and Software configuration management related to the project
• Production Support which involves solving user problems.

Environment: Cognos Reportnet 1.1 MR2 (Framework Manager, Query Studio, Report Studio), Power Play Enterprise Server 7.3, Transformer 7.3, Oracle 8i

Confidential, Phoenix, AZ

Cognos Developer

Responsibilities:

• Designed & developed reports from the Data warehouse using Cognos report studio, Query Studio Studio reports.
• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Involved in defining Relationships and Cardinality between query subjects
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata in Frame work manager.
• Created Multi-Dimensional Models (DMR) and published the packages using Framework Manager and then generated reports based on these packages.
• Provides technical expertise in the development and maintenance of basic to moderately complex Accounting reporting applications, data marts, and reports. In some cases the reports will be used in day-to-day production and in other cases the reports will be used audit the accuracy of a large accounting system conversion.
• Responsible for technical maintenance and enhancements of multiple existing Accounting reporting applications, data marts, and reports in adherence with change management protocol.
• Participates in the identification/development of business requirements with our Accounting Director and our Accounting Project Team and may provide business consultation for the design phase to support the development of basic to moderately complex reporting applications, data marts,and reports.
• Involved in the generation of different types of reports for different sets of data to target customer segments, which can be changed in many ways to Slice and Dice and drill-through data for further multi-dimensional OLAP analysis.
• Developed reports using various functionalities like Drill through, Master Detail, Conditional Formatting, Conditional Blocks and multiple Prompts in Boards.
• Working experience with different date functions like YTD,QTD,MTD in Report Studio
• Extensively worked on Analysis Studio to develop multi-dimensional reporting.
• Designed OLAP Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, sorting, summaries, grouping, Drill Down, Drill Up).
• Developed Reports with multiple Cognos Viewers and multiple Cognos Reports Integrated into a Single Page Report.
• Used impcat2xml tool to migrate the catalogs. Imported the xml files to Framework Manager to make appropriate models.
• Created Dashboards with the selection criteria defaults by user role to help pre-select a subset of data that is most critical and most relevant for the users.
• Created HTML and Java Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos
• Involved in the entire project of migrating reports and cubes from Cognos 7 to Cognos 8.2 and creating project documentation for future use
• Developed stored procedures, triggers and complex packages using PL/SQL.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Trace, Stored Outlines.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Provided the Documentation and tutored the End Users how to Use Different types of studios.

Environment: Cognos 8 Suite (Cognos Connection, Framework Manger, Metric Studio, Report Studio, Query Studio, Analysis Studio, Powerplay Transformer), Reportnet, Sql Server 2005, PL/SQL, Oracle ERP, Cognos Access Manger, Windows 2003WB 8i/9i, Oracle 8i/9i, Discoverer 3i

Confidential

Cognos Developer

Responsibilities:

• Created Multiple Reports with Cognos Impromptu and Power Play.
• Created LIST, Group and Cross tab reports with Drill Through functionality
• Created business Mix and Reports for Comparison
• Created Multi-Dimensional Cubes using Power play Transformer for multidimensional (IQD) reports.
• Drill Down and Drill Through functionalities were used in the cubes and reports
• Data retrieval, Multidimensional analysis, Power Play structure. Reporter Operations such as Sum and Average, Intersection, Exception Highlighting, Sorting, Ranking etc.
• Developed some power prompt pages using Java script to enable the features for the end users to use radio buttons and able to select multiple prompts on the same page
• Developed solution models for Ad-hoc reports.
• Involved in optimizing power Cubes.
• Developed Impromptu Web Reports and published them into Upfront.
• Outstanding Onsite support.
• Implemented Star Schema Grouping and Dimensional Hierarchy in Framework Manager Model.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP)
• Designed & developed reports from the Data warehouse using Cognos 8.4 report studio, Analysis Studio reports.
• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Involved in defining Relationships and Cardinality between query subjects
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata in Frame work manager.

Environment: Reportnet 1.1 MR2,Cognos Impromptu 6.1, Cognos Power play 6.1, Cognos Transformer 6.1, Impromptu Web Reports 6.1, Cognos Upfront 7.0, Notice Cast 7.0, Oracle 8i, Windows 2000