SUMMARY:

• SDLC: Over 7+Years of IT experience with expertise in Analysis, Design, Development, Customization, Implementation and Testing of various Software applications and generation of reports using Various Databases in the financial, Sales, Insurance domain and HealthCare.
• Cognos BI: Over 7+ years of extensive experience in working with Cognos 10.x,Cognos 8.x, Report Net 1.1, Report Studio, Query Studio, Analysis Studio, Impromptu, Transformer, Power play, Cognos 8 (Framework Manager, Report studio, Query Studio, Analysis Studio and Cognos connection). Installed and configured Cognos 8.2 BI, BI modeling, Report Studio, Query Studio and Analysis Studio. Cognos8.3, Cognos 8.2, Report Net, Query Studio, Report Studio, Impromptu, Transformer, Power play, upfront, scheduled the Reports based on the database events using Triggers.
• Worked as CognosTM1 Developer/Data Analyst and provided Financial Planning Solutions using Cognos TM 19.5.2/10.2 applications (Architect, Contributor, Perspectives and TurboIntegrator) from requirements through design and testing, implementation and production support.
• Dash Board & Securities: Designed and developed dynamic dashboards to evaluate the Company’s performance. Implemented Row Level Security, Object Level Security, Package Security, Folder Security and created user classes as per the requirement. Created complex Lists, Cross Tabs, Charts and Repeater in Report Net and Cognos 8.
• Data Migration: Migration of reports from Cognos 7 to Cognos8.2.1. And upgraded from Report Net to Cognos 8.2, migrating the Business Objects universes to Cognos Framework Models and reports. Designed and Developed Projects, Packages, Reports using Framework Manager, Query Studio and Report Studio, Analysis Studio.
• Data Modeling: Experience in Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical data modeling, Erwin 7.3/4.0/3.x and Oracle Designer
• Data Warehousing: Experience in deployment, scheduling, automated report bursting & delivery via email. Design and building cubes in Power play Transformer. Good knowledge of ETL and Active and Passive Transformations, Teradata and tools Teradata Administrator, Teradata SQL Assistant, Teradata Performance Monitor.
• RDBMS: Database experience using Oracle 10g/9i/8.x, DB2, MS SQL Server, MS Access, Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and SQL Server, Relational database design concepts and in depth knowledge of OLAP solutions and DB2, and Windows server 2003/2000, SQL Server2008/2005, TOAD, AS/400, Access Manager, IIS, Oracle Streams, Active Directory, Oracle Access Manager Sybase IQ.
• Testing: Experience in developing Test cases, developing Test scripts and analyzing bugs using extensive knowledge in Manual, QTP and Test Director.
• Worked with Cognos Go Office reports.

TECHNICAL SKILLS:

Programming: C, C++, VBScript, ASP SQL, PL/SQL, SQL*Plus, Visual Basic 6.0/5.0, Java 2.0, HTML, DHTML, UNIX Shell Scripting

Cognos BI Tools: Cognos 10.2/8.4, Report Net1.1, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Manager, Metrics Designer, Cognos EP Series (Impromptu, Power Play, Transformer, Cognos IWR administration, Power Play Enterprise Server and Upfront), Business Objects XI

Data Modeling: Data Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling, Erwin 4.0/3.5, Oracle Designer, Datastage 7.0/7.5, Ab Initio, Framework Manager, System Architect 2001, and Rational Rose

Operating Systems: Windows NT/2000/XP/98/95,AIX and UNIX

Web/Scripting: HTML, DHTML, VBScript, and JavaScript

Front Ends: Visual Basic, Power Builder, Developer 2000

RDBMS/DBMS: Oracle 11G DB,10G/8i/9i, MS SQL Server 2008/05/, Windows 2003/2000, T - SQL,DB2,TeraData, TOAD, Sybase

Testing Tools: Manual Testing, QTP and Test Director

Ms Power Point, VISIO and Ms: Office

PROFESSIONAL EXPERIENCE:

Confidential

Senior Cognos BI Consultant

Environment: Cognos 10.2/8.4/8.3, Transformer 8.3, Report Studio, Query Studio, Cognos 8 RTM SDK, JDK 1.4/1.5, Oracle 10g/11g, Siebel, Erwin 4.0, TOAD, PL/SQL, UNIX, AIX

Responsibilities:

• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Developed logical & physical modeling as per business requirements using ERWIN 3.5
• Designed and developed snow flake /star schemas for better understanding of models using ERWIN.
• Built Framework Manager Models (Relational, DMR) for Standard Reporting and Adhoc Analysis.
• Built Framework Manager Models and Published IQD’s which are used as Data sources in Cognos Transformer to build a cube.
• Enhanced the Framework Models and Transformer Model to suit the user requirements.
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail.
• Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validating the Prompts using Java Script.
• Gathered information, Designed, Developed Dashboard reports to meet the business requirements.
• Involved in creating OLAP hierarchy, Dimensions, formulas & power cubes using Cognos Powerplay Transformer and Reports using Power Play/Analysis Studio.
• Created highly Complex Reports using OLAP Cubes as Data Source for Multi-Dimensional Analysis.
• Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues.
• Performed Unit testing on Dev and supported the users on UAT and Production.
• Involved in Performance Tuning of Cognos Models/Reports.
• Manage TM1 data through TM1 Reports.
• Developed and Maintained technical documentation of the implementation.
• Assisted the users on Production for the latest enhancements and production fixes.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups.
• Involved in creation of Active Dash Board reports using Report Studio/Cognos Workspace.
• Involved in migration of Models/Cubes/Reports from Cognos 8.4 to Cognos 10.2.
• Used Cognos Lifecycle Manager to validate the reports and check the report performance.

Confidential, NY

Sr. Cognos Consultant

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio), Oracle 9i/10g, Teradata, Cognos Access Manger, Windows 2003 Server, AIX.

Responsibilities:

• Installed and Configured Cognos 8.4 in single server Environment.
• Administration involved Installation and configuration of COGNOS servers, implementing security, managing users, user groups and roles in the organization.
• Interact with the business users and documented their query, business analysis and reporting needs.
• 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.
• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Created packages in Framework Manager to publish cubes to Analysis Studio.
• Customized Cognos Connection with appropriate reports and security measures
• Created Cognos 8.4 Transformer cubes using Framework Manager packages and Report Studio reports as datasource.
• 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.
• Implemented security for Data access, Object level access and Package access.
• Created User Groups, Roles to implement the Cognos Security, using Directory Server.
• Used filters for efficient data retrieval.
• Modifying the existing report based upon the change request by the user.
• Creating Dash Board Reports from cube using Report studio and adding it to the portal page using HTML Items for critical performance metrics Operations, Sales, Human Resources, Information Technology, Standards using MDX functions.
• Migrating Powerplay Client HTML reports that are tabular and pivot oriented and convert them to pictorial/dashboard oriented reports for executive management sales.
• Created batch script to update and publish cognos8.4 powerplay cubes daily.
• Used global filters to update the content across multiple objects in a portal page.
• Used Enhanced suppression in Cognos 8.4 Report Studio by suppressing reports against dimensionally-modeled relational, and OLAP sources.
• Created drill through reports from multidimensional summary reports to detail relational reports.
• Resolving the Performance issues of the Reports.
• Deployment of reports from Development to Production.
• Experience with conditional blocks and conditional layouts.
• Experienced with migration of Cognos code (reports/models/ frameworks) from one environment to another.
• Sound Skills on Developing Score Card Applications using Metric Manger and Metric Studio
• Upgraded reports from 8.3 to 8.4.
• Trained business users on Query Studio for ad hoc reporting.

Confidential, Austin TX

Senior Cognos Consultant

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio),Transformer, Oracle 10g,Informatica8.1,Oracle Streams, Active Directory, Oracle Access Manager, OID, Solaris, Sun One I Planet, Web Logic 10.2, Erwin, PVCS, Teradata.

Responsibilities:

• Modeled and Reported against a Dimensional Database which is in the form of a Star Schema.
• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Built Relational Models for Reporting and DMR for OLAP Style Analysis and Reporting using multi layer Approach and Modeling best Practices to meet the reporting requirements.
• Involved in Design and Development of Security Architecture to meet the Business needs.
• Ensured Ambiguous Relationships are resolved and implemented Model enhancement techniques to improve Model Performance.
• Created Model Query Subjects, Data Source Query Subjects, Stand alone and Embedded Filters to implement the Complex business Logic.
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Developed Hierarchies and Measures to support Adhoc Reporting, Multi Dimensional Reporting.
• Published Packages to Cognos Connection and implemented Package Level Security.
• Managing User ID’s and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Using Transformer cubes as data source import into Framework Manager, and created Models, packages for Analysis Studio.
• Created highly Complex Reports using OLAP Cubes as Data Source for Multi Dimensional Analysis.
• Automated the Monthly cube refresh Process using Command Line options and scheduled it using Windows Scheduler.
• Developed Report Templates for Standard and Adhoc reporting to make the Reports look Consistent.
• Developed List, Cross Tab and Chart Reports for different Views of Data.
• Implemented various reporting Techniques like Drill up, Drill down and Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail and secured the Reports and Folders to specific user groups.
• Deployed Packages, Reports to Test Environment using Content Administration.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups

Confidential, Fort Worth, TX

Cognos Developer

Environment: Cognos 8.2 (Report Studio, Analysis Studio), Cognos Series 7, Cognos Office Connection 8.1.0, Oracle 9i, Toad, Tivoli LDAP, Migration Utilities (Impcat2xml, Migratetoc8, Deploytoc8).

Responsibilities:

• Migrated Cubes, Reports from Version 7 to C8 using the migration utilities.
• Upgraded the environment from Cognos 8.1 to Cognos 8.2
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Used Dimensional functions to build crosstab reports from cube datasource.
• Built Power Play Reports in Report Studio and Analysis Studio based on cubes published to Cognos8 Server.
• Built Power Play Reports in Report Studio by replicating the powerplay functionality in Report Studio using dynamic Measure selection, Dynamic Sorting, ranking.
• Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Customize the Cognos connection portal using existing portlets and customized tabs.
• Worked on complex reports using Static Prompt and mdx functions and union conditions.
• Used Cognos Office Connection to publish the reports in Powerpoint and format them for business presentation.

Confidential

Cognos Developer

Environment: Cognos 8.3 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Analysis Studio, Event Studio, Transformer),Cognos SDK, Java Script, TOAD, Teradata, SQL Server

Responsibilities:

• Interacting with the End users to gathering the reporting requirements.
• Created Technical Design Documentation for Reports, Framework Models and Stored Procedures.
• Created Test Cases for Reports, Framework Models and Stored Procedures.
• Designed models using Framework Manager and deployed packages to the Report Net Servers.
• Implemented Security in Framework manager for Database level, Object based level and Package level.
• Created Database layer and Business layer defining appropriate relationship between query subjects.
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level.
• Creating .IQD files in Framework Manager and designed Power play models in Transformer.
• Extensively worked on building Transformer Models - dimension hierarchy, drill-down paths, calculated measures, roll up’s, Performance Tuning.
• Developed List, cross tab, chart, Drill through, master-detail, and complex reports which involved in Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database using Java scripts.
• Deploying the reports developed on the customer environment by arranging the Webex Sessions. the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Providing support during theUser Acceptance Testing.
• Scheduling Reports and Jobs to run periodically.
• Imported metadata from multiple data sources to build a model and publishing packages from Framework Manager to the Cognos connection.
• Extensively worked on relationships (cardinality) between query subjects to better represent the logical structure of the business and the user requirements.
• Implemented Star Schema Grouping and Dimension Hierarchy in Model.
• Created custom templates and custom tool boxes for the use of reporting.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Prepared User documentation to train users and functionality of each report.