Summary:

• 6+ years of professional experience in IT industry including development and implementation of Data Warehousing and Business Intelligence Applications using Cognos 8,10 Suite, Report Net, Cognos10.X , 8.X, 7.x/6.x.
• Experience working with Cognos 8.x Business Intelligence. (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio and Cognos Connection)
• Well-versed in developing reporting applications using Cognos 8 Components like Framework Manager, Report Studio, QueryStudio, Metric Studio, Analysis Studio, CognosConnection, Metric Manager, DataManager.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in Relational, Dimensional and Multidimensional modeling
• Sound Skills on Dash Board Report building using Report Studio and Analysis Studio, Adhoc reporting using Query Studio.
• Experience with Framework Manager Modeling (Physical Layer, Business Layer and Packages) and publishing packages into cognos connection.
• Goodexperiencein creating data marts using Data Manager.
• Strong Knowledge with Transformer model design and Power play cube building.
• Experience in implementing security in Impromptu Web Reports (IWR) and Frame work Manager &Cognos Connection.
• Knowledge in Data Warehousing Principles and Concepts
• Involved in Migrating Reports from Cognos EP Series 7.3 reports, cubes to Cognos 8.
• Experienced with Multiple Relational Databases including Oracle, MS SQL Server and DB2 and Client/Server application development.
• Excellent SQL, PL/SQL Querying skills and exposure on Query tuning and creating stored procedures/functions.
• Have excellent knowledge Building TM1 Cubes
• Excellent Team coordinating Skillswith theDevelopmentTeamand Deliverable dates.

Qualification:
Bachelor of Engineering in Computer Science and Information Technology.

Technical Skills

Business Intelligence Tools

Cognos 8.x (Framework manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Scheduler, Portal Administration),Cognos SDK, CognosReportNet 1.1(Framework Mricanager, Report Studio, Query Studio), Cognos EP 7 series (Impromptu, Power play, Upfront, transformer, Access Manager, Report Administration).

RDBMS

Oracle 10g/9i/8i, SQL Server2005/2000, DB2 and MS Access.

Programming Languages

C, Java, SQL, PL/SQL

Web / Scripting

HTML, JSP XML, Java Script

Data Modeling

Star Schema Modeling, Snow Flake Modeling and FACT & Dimensions

Testing Tools

Manual Testing, Unit level testing

Operating Systems

Windows 95/98/2000 Server, XP, NT, 2003 server and UNIX

Confidential,Apr2011 – Present
BI ANALYST, Troy, MI

Responsibilities:

• Involved in installing and configuring Cognos10.1/8.4 BI and worked with modeling, Report Studio and Analysis Studio.
• Worked extensively on creating Models using Framework Manager and publishing the packages on Cognos Connection for reporting purposes.
• Created DMR models using Framework Manager.
• Created filters and prompts within the Model for improving performance of the Model.
• Deployed the packages and reports from Dev to QA and Prod.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Set security for individual reports in Cognos Connection.
• Used Analysis studio to drill down on cubes and perform business analysis.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality using Analysis studio.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Created standard and Ad hoc reports using Cognos Query Studio.
• Developed reports in Report Studio upon requests from business users
• Busted Reports to various Recipients within the organization using Report Studio.
• Created Query Prompts, Tree prompts, Query calculations, Conditions & Filters.
• Developed Complex reports in Report Studio using Complex SQL queries
• Created list reports, cross tab reports, chart reports, Master detail reports, Drill through reports and reports with lot of conditional formatting using Report Studio.
• Involved in creating Test plans, Unit testing and UAT of the Report Studio reports.
• Created Power play Cubes using Power play Transformer generated Power play Reports.

Environment:Cognos10.1/ 8.4/8.3 Report Studio, Query Studio, Cognos Connection , FrameworkManager, Power play Transformer , Cognos Scheduler, Oracle 10g

Confidential, Durham, NC Apr 2010 – Dec 2010
SENIOR COGNOS DEVELOPER,

• Involved in gathering the business requirements from the Users and documenting it for reporting needs.
• Research on collected business requirements and translate business requirements into system specifications and develop reports as per the client requirements.
• Building models in IBM Cognos Framework Manager (Database Layer, Logical Layer, Presentation Layer) and publishing packages.
• Created Data Level, Object level, Package level and Row level Securities in Framework Manager Models.
• Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio.
• Created various Prompts, Filters, and Calculations and used Conditional Formatting as per the requirement.
• Worked on Data Analysis, Validate reports and find data quality issues.
• Scheduled the reports in Cognos Connection and distributed them via mail.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• To maintain numerous pre-existing reports and a fully functional multi user Portal Dashboard.
• Built multi-dimensional reports using Analysis Studio.
• Involved in building OLAP Transformer Cubes using multiple data sources like IQD\'s, Packages and Reports.
• Publishing Cubes and Packages for the web users.
• Customizing user class security views in Cube by user classes / Roles.
• Created Technical design document for Report studio reports based on Functional specifications.
• Created and performed the Unit and Integrity test cases and assisted the testing team in System Test and Production move process.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Provided the documentation and tutored the End Users how to use Different types of studios.
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Troubleshoot Cognos Server Environment for the better performance.

Environment: Cognos 8.4 Bi Suite (Framework Manager, Transformer, Cognos Connection, Query Studio, Report Studio, Metric Studio and Event Studio), Oracle 10g, Teradata, Toad, Windows 2003 Server.

Confidential,GA Jan 2009– Mar 2010
COGNOS DEVELOPER

Responsibilities:

• Built models using Framework Manager and published the package.
• Accessed published package using Cognos Connection.
• Prepared Unit Test Cases and performed testing in the development environment.
• Reports were triggered by DB Stored Procedures.
• Created Query Subjects in Framework Manager as stored procedure source with parameter mapping.
• Maintained and published Framework Model.
• Analyzed existing Crystal reports and incorporate the calculation in the Framework Model.
• Initially the Framework Manager Query Subject was pointed to SQL Server2000 as database and all the reports have been developed. In final, the same Framework Manager is deployed to Oracle 9.1 and all the ReportNetreports made to run successfully on both the platform.
• Created drill-thru reports and cross-tab reports in Report Studio.
• Involved in the design and development of CRN reports in Report Studio.
• Created complex reports with sub-queries and sub-sub-queries.
• Created reports that included ReportNet functionality such as prompt pages, cascading prompts, conditional filters etc.
• The report was designed as a “Master-Detail” report as every manager could have several objectives, strategies and resources.
• Reports output have been designed to carter for both PDF and HTML formats.
• Tested the reports and migrated to UAT for the second level of testing.

Environment:Cognos Report Net 1.1, SQL Server, Oracle 9i, PL/SQL, Crystal Reports XI, OLAP,

• Windows XP.

Responsibilities:

• Involved in Installation & Configuration of Cognos 8 tools in distributed environments on Windows.
• Involved in requirement gathering and Developed technical specification documents based on functional requirements.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Design and developed the Framework Manager models and Published into server.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases. Used filters for efficient data retrieval.
• Developed Multi-dimensional models (cubes) using Transformer.
• Developed models in framework manager and created iqd’s to use them as source to transformer (to build cubes).
• Created Special Categories, User Class Views, Securities.
• Extensively worked on cube refreshing on monthly basis & worked on Data Validations.
• Design & development of the reports using Cognos 8 Report Studio, Query Studio and Analysis Studio.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Modifying the existing reports based upon the change request by the user.
• Creation of Dash Board Reports using Report studio MDX Functions and adding it to the portal page using HTML Items.
• Understanding the existing security structure of the company and implemented organizational security for cognos environment (Folders, Models and Reports etc). Implemented SSO between the company internal portal and Cognos.
• Added Data Security, Object and Row level Security according to the requirements.
• Involved in deployment to UAT and Production.
• Troubleshoot Cognos Server Environment for the better performance.
• Environment: Cognos 8.4.1 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio and Event Studio), Cognos SDK, Oracle 10g/11g, Custom Java Authentication Provider (CJAP) , Web Sphere Data Stage version 8.0.1 (Designer, Director, Administrator), Power play cubes and Windows 2003 Server.

Client: GlaxoSmithKlineNov 2006 – Mar 2007

Responsibilities:

• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created standard and Ad hoc reports using Cognos Impromptu designed catalogs and defined User Classes, security and privileges.
• Created User Classes who needed to access the data in the catalog.
• Assigned password to User Classes, assigned various kinds of accesses to Tables and Folders.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality.
• Created Multidimensional reports by implementing Multi Dimensional Cubes using PowerPlay and Transformer.
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and PowerPlay reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Created Impromptu Web Reports and published them on the Web server and later on Upfront.
• Deployed cubes and reports on PowerPlay Enterprise Server and also Published to Upfront.
• Monitored the PowerPlay cubes using PPES.
• Used Access Manager to meet the security requirements of the reports and cubes on the Upfront.
• Troubleshoot Cognos Server Environment for the better performance.
• Environment: Cognos EP Series 7, Oracle 8i, Window 2000, Informatica 6.0.

Confidential,India ª
Client: Kirloskar Oil Engines Limited (INTERNSHIP) Jan 2006 – Oct 2006

Responsibilities:

• Involved in creation and updating of catalogs and integrate data on to oracle.
• Queried data from different database tables as per the requirement.
• Customized data by adding calculations, summaries and functions.
• Generated reports using Cognos Impromptu tools querying database.
• Involved in creation of Imr reports and IQD’s (Impromptu Query definitions).
• Created User Classes who needed to access the data in the catalog.
• Assigned password to User Classes, assigned various kinds of accesses to Tables and Folders.
• Environment: Cognos 6.0, Oracle 8i, Windows 2000.