SUMMARY

• Around seven years of Information Technology experience with extensive functional and technical focus in Data Warehousing, Data Modeling, Business Intelligence (BI), System Development Life Cycle (SDLC), OLAP and Reports Generation.
• Extensive experience with Cognos 10, Cognos 8, Cognos Report Net 1.1 MR3, Cognos Impromptu, IWR (7.X/6.X), Cognos Transformer and Cognos Power Play (7.x/6.X).
• Expertise in creating complex reports in Cognos Report Studio such as List reports, Cross - tab reports, Drill through Reports, Master-Detail Reports and Cascading Reports and involved in reports Performance Tuning.
• Created Multidimensional Models in Framework Manager from various data sources such as Oracle, SQL Server, DB2, SAP BW Info Cube, Siebel data and published package to Cognos Connection.
• Experience with Cognos Workspace Advanced and Active reports.
• Expertise in creating Dash board reports in Report Studio and Scorecards in Metric Studio
• Experience in Framework manager for creating metadata models (Relational and DMR), folders, filters and publishing packages.
• Implemented Cognos Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Experience with Deployment, Content Administration, Users and User Class Creation and Scheduling of Reports.
• Worked extensively with Power Play Transformer and client to design models and analyze the Power Cubes.
• Strong knowledge in the area of Cognos Architecture and Administration.
• Good Understanding of Developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Good understanding of workflow of SSRS, SSIS, and SSAS
• Extensive Experience in SQL Server, Oracle, Teradata and DB2 for building and implementing data warehouse
• Experience in all stages of Software development life cycle (SDLC) which includes requirement analysis, design, development, testing and documentation.
• Involved in QA team for Integration Testing and Production Support.
• Excellent communication, interpersonal, problem solving skills and good at working independently as well as in teams.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos10, Cognos8 (8.1,8.2,8.3,8.4), ReportNet 1.1(MR3,MR4), Cognos 7.x Report Studio, Query Studio, Framework Manager, Analysis Studio, Event Studio, Data Manager, Access Manager, Transformer, PowerPlay, PowerPlay Web, Upfront, Impromptu Administration & Cognos Access Manager

Databases: Oracle (10g,8i,9i), MSSQL, Server(2000,2005, 2008), DB2, MS Access, Teradata

Querying Tools: SQL*Plus, TOAD

Data Modeling: Logical and Physical Data Modeling, Star Schema, Snow-Flake Schema, Data Modeling, Erwin 4.0/3.5, Visio

Operating Systems: Windows(03,98,NT,2000,XP,Vista,7), UNIX(IBM AIX, HP-UX), DOS

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

PROFESSIONAL EXPERIENCE

Confidential, Fairhaven, MA

Sr. Cognos Developer

Responsibilities:

• Involved in requirement gathering from Business Users to understand business processes in order to report on business requirements
• Analyzing specifications provided by internal clients/business users
• Designing and developing multiple reports using various templates such as list reports, cross-tab reports, and chart reports
• Authoring reports in report studio in accordance with business requirements by implementing features such as prompts, conditional formatting, bursting, and rendering
• Creating drill-through reports and associating them with summary reports for detailed reporting
• Utilizing HTML & JavaScript to customize Cognos reports per business requirements
• Worked on complex reports using Static Prompts, MDX functions, Unions and Join conditions
• Worked with Cognos Workspace Advanced enabling users develop simple reports themselves
• Involved in designing of data model in framework manager
• Worked extensively with internal ETL team
• Performed deployments across different cognos environments
• Regular interaction with end users for feedback, enhancements, and resolution of issues pertaining delivered reports
• Monitoring and troubleshooting of daily, weekly and monthly jobs including cubes and reports
• Involved with testing reports using review checklists for Quality Assurance before delivering to the end users
• Migrated reports from Cognos 8.4 to Cognos 10.1.1
• Built multi-dimensional cubes using transformer
• Involved in monthly data-loading using SSMS Studio

Environment: Cognos 10.2, Cognos 8.4 (Report Studio, Framework Manager, Query Studio, Business Insight, Analysis Studio, Metric Studio, Cognos Workspace Advanced) Powerplay Transformer 7.4, XML, HTML, Oracle 10g, SQL Server 2005, Windows Server.

Confidential, Bloomfield, CT

Sr. Cognos Developer

Responsibilities:

• Involved in the whole process of Cognos Upgrade from Cognos 7 series, Cognos 8.3 to Cognos 10
• Responsible for the Two Finance applications upgrade to Cognos 10
• Involved in understanding the Business needs and Customer requirements by participating in the Design Phase, User Requirement Gathering.
• Understanding the existing security structure of the company and implemented organizational security for Cognos environment (Folders, Models and Reports etc).
• Involved in the discussion of various issues related to Cognos 10 upgrade
• Design and Test the security for the Cognos 10 environment
• Migrated nearly 120 reports from Cognos 8.3 to Cognos 10
• Migrate cubes with the new security system from Cognos 7 series to Cognos 10
• Modified List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Developed Multi-dimensional models (cubes) using Transformer
• Created Special Categories, User Class Views, Securities.
• Deploying models and reports from Staging to Production and administering users/groups/roles.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Generated IQD files in Framework manager and designed Power play models in Transformer
• Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Cognos 10, Cognos 8.3 Suite (Framework Manager, Report Studio, Analysis Studio, Query Studio, Metric Studio), Power play Transformer, Power play cubes, Cognos Access Manager, Oracle, DB2, SQL Server2005

Confidential, Plano, TX

Sr. Cognos Technical Consultant

Responsibilities:

• Interacted with business analyst to gather business requirements and designed functional and technical requirements documentation.
• Developed models in Framework Manager and deployed packages to the Cognos Connection.
• Customized data by adding filters at both the Framework Level and Report Level.
• Implemented all business logic in Framework Manager by creating prompts, folders, calculated columns, joins and naming convention.
• Migrated nearly 250 reports from Cognos 8.3 to Cognos 10.1.
• Created Dashboards comprising of list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, various types of prompts, calculations, complex expressions, and conditional formatting.
• Worked on creating and analyzing the complex reports like Cross tab, drill-thru reports.
• Page explorer, query explorer and variable explorer were used to manage the content of the reports.
• Bursting the reports in various formats, such as html, PDF, excel on the server based on the sales area and different levels of administration
• Assisted in creating executive dashboard for management level reports using Report Studio.
• Used layout component reference in page header, page footer and prompt page for uniformity across the reports.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Created various IQD in Framework Manager and from this IQD’s as source, integrated to Power Play Transformer to create various models and build cubes.
• Analyzed cubes from cube packages using Analysis Studio.
• Designed, developed, and tested Power cubes and deployed them in to production
• Worked with user profiles to ensure security by restricting user access to data based on the individual user.
• Set security for individual reports in Cognos Connection.

Environment: Cognos 10, Cognos 8.3 (Report Studio, Framework Manager, Query Studio, Business Insight, Analysis Studio, Metric Studio) Powerplay Transformer 7.4, XML, HTML, Oracle 10g, SQL Server 2005, Windows Server.

Confidential, New York

Sr. Cognos Developer

Responsibilities:

• Involved in Installation and Configuration of Cognos 8.4 BI environment including Framework manager, Report Studio, Analysis Studio, Event Studio and Query Studio.
• Worked on Cognos 8.4 Framework Manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos Connection Portal.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements
• Provided data security, object security and package access in Framework Manager, and also secured the folders by setting up access permission in Cognos Connection.
• Designed and Developed List Reports, Crosstab Reports, Charts by using Cognos 8.4 Report Studio and Query Studio
• Created Power Play cubes with data level security based on the user profile
• Built Prompt Macro at the Framework level
• Created Query Prompts, Calculations, Conditions, Filters and drill ups/down reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Implemented Conditional formatting, Bursting and scheduling of the reports.
• Involved in performance tuning of the application using governor settings in framework manager and transformer models.
• Created and customized the data in data sources in Transformers using Packages generated at Framework level.
• Developed the Multidimensional Cubes with various Dimensions, Levels and Measures including time dimension with different hierarchy which enabled Drill Up and Drill Down capabilities.
• Refreshed cubes on demand and implemented Security in Power Play Transformer.
• Created reference documentation for some of the important tasks to be performed in cognos environment.
• Involved with development and testing of Reports.

Environment: Cognos 8.4 (Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Connection), PowerPlay Transformer, Oracle 10g/9i, Teradata 12, PL/SQL, UNIX, Windows 2002/XP.

Confidential

Cognos Developer

Responsibilities:

• Developed and Published Packages in Framework Manager
• Generated reports using Cognos Impromptu tools querying database.
• Created Filters, Conditions and Prompts in Catalog.
• Resolved reports (Impromptu, Power play and Report net) data discrepancy issues.
• Customized data by adding calculations, summaries and functions.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Burs.
• Maintained Cognos applications (Impromptu, Power play) by Installing and configuring on Citrix servers and desktops remotely.
• Scheduled and monitored daily/weekly power play cube builds.
• Customer’s first point of contact for BI Cognos related support/issues.
• Added users, user sign on, user membership, user’s data source access.
• Implemented security for Data access, Object level access and Package access.
• Created User Groups, Roles to implement the Cognos Security, using Directory Server.

Environment: Cognos Powerplay 7.3, Transformer 7.3 Cognos Report Net 1.1, Power play Enterprise Server 7.3, Upfront 7.3, Impromptu Administrator 7.3, Access Manager 7.3, and TOAD.

Confidential

Cognos Developer

Responsibilities:

• Developed drill through reports, developed filters, conditional formats and prompts using Prompt manager.
• Created various Impromptu reports (List, Cross-Tab and Drill through) and Power play Reports and Published Impromptu reports and Power play reports to Upfront.
• Developed standard filters, prompts, calculations, and conditions in Catalog.
• Updated Impromptu Catalog by adding tables and creating new joins.
• Wrote different stored procedures, triggers in PL/SQL as per functionality
• Involved in installing applications such as Impromptu user 7.2 & Power play user 7.2.
• Created join conditions, table aliases and views for the user requirement.
• Generated IQDs are used as data sources in power play Transformer to generate Transformer models.
• Scheduled Impromptu web reports in upfront.
• Connected to Remote Data Bases using Data Links and pulled required data.

Environment: Cognos Power play 7.2, Upfront 7.2, Power play Enterprise Server 7.2, SQL*PLUS, Developer 2000, Windows, Impromptu Administrator 7.2, Access Manager 7.2, TOAD, Oracle 7x, PL/SQL, Transformer 7.2