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.
• 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 3.1, Crystal Reports. TM1(Architect, PerspectiveTurbo Integrator and Web)

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

Presentation Tools: Ms Power Point, VISIO and Ms-Office

PROFESSIONAL EXPERIENCE

Confidential, RTP, NC

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

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.
• 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, Greenwich, NYC

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.

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, Hartford, CT

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, Bridgewater, NJ

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: COGNOS7.2: Impromptu, Power Play, Transformer, Access Manager, Access2K, DB2, SQL, Excel 2k, Windows 2000.

Responsibilities:

• Cognos Impromptu formulation of join strategy.
• Created and maintained catalogs, prompts, calculations and conditions using Impromptu Administrator.
• Created templates for standard reports using. Impromptu.
• Created list reports, sub-reports and cross-tab reports using Impromptu Administrator.
• Created hierarchies to provide drill-down options for end-users.
• Created various calculations and prompts in reports and created drill through reports.
• Created cubes and explored the multi dimensional Cube data into powerful Impromptu reports.
• Formatted the reports, created cascading prompts, summary and detailed filters.
• Drill-through is done from Cubes to Reports and Reports to Reports.
• Created reports to monitor Sales Forecast, inventories on-hand, and periodical performance.
• Develop data marts using Cognos Transformer to create OLAP cubes. Mapping the business needs and accordingly creating the cubes using Cognos script Language.
• Designing and developing Excel 2000 spreadsheets, data extraction from Access 2000.
• Design and create custom reports in Cognos Power play like drill through, list, cross tab, charts reports.
• Create joins, filter and calculations. Created alternate drill through in Power cubes. Optimized the cube performance and the report response time.
• Published cubes and OLAP reports using Upfront Server.
• Provide systems support to users and other developers.

Confidential

Programmer Analyst

Environment: Oracle 7.3/8.0, PL/SQL 8.0, SQL Server, Sybase, Visual Basic 5.0/ 6.0, JAVA, JSP, Crystal Reports and Windows NT.

Responsibilities:

• Involved in Business Analysis, Design and Development
• Performed Normalization and Logical Database Design
• Created Stored Procedures, Functions, and Packages to manipulate the database and to apply the business logic according to the user specifications.
• Involved in hard coding of SQL & PL/SQL scripts.
• I did Performance tuning for rapid execution of SQL & PL/SQL Scripts.
• Developed GUI interface in Java using Applets, HTML, JDBC and JavaScript.
• Created Stored Procedures, Functions, Packages, Triggers, Tables, Views and Synonyms
• Accessed data from the database using RDO Controls and Remote Data objects
• Created the VB Forms for Data Capturing using Active X Data Objects.
• Created Active X DLL's using Class Builder Utility and generated different Crystal Reports.
• Generated lot of Crystal Reports.