SUMMARY

• Over 9 years of total IT industry experience analysis, design, testing, development and implementation of Business Intelligence & data warehousing environments.
• Experience in Financial Services, Healthcare, Retail and IT sector.
• Excellent working knowledge of BI tools Cognos 8BI, Cognos Report Net 1.1/1.0 MR2 (Query Studio, Report Studio, Framework Manager, Cognos Connection), Cognos Series 7 (Cognos Impromptu, Cognos Power play), and Cognos 8.4.
• Strong Experience in developing Business models using Framework Manager and published packages to Cognos Connection in Cognos 8 and Report Net.
• Expertise in OLTP/OLAP system study, analysis, E - R modeling and developing Database schemas like Star Schema and Snowflake Schema.
• Experience in Deployment (Export, Import) using Framework Manager into Cognos Connection.
• Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Expertise in Ad-hoc Reports using Query Studio in Cognos 8 BI Suite and Report Net.
• Excellent skills in advanced Report Authoring which includes Conditional Formatting, using Filters and Report Validation.
• Analyzed multidimensional data and generated reports using Analysis Studio.
• Extensively worked on PowerPlay Transformer 7.x/6.x for Data modeling of the corporate Data for building multidimensional cubes.
• Created cubes tailored for widespread distribution by using dimension views and user class views.
• Extensive experience in creating Models and Packages in Cognos Architect.
• Extensive experience on Transformer Models for building Multidimensional Cubes.
• Used TOAD, AQT (Advanced Query Tool) and SQL Developer to run SQL queries and validate the data in Data Warehouse and Data Marts.
• Good exposure in Relational Databases (Oracle, SQL, SQL Plus and MS SQL server) for modeling and supporting analytical and reporting needs of Corporate Business.
• Good exposure in java SDK for creation customs security provider and grants permission to the users.
• Strong troubleshooting and production Support skills and coordination/interaction abilities with end users.

TECHNICAL SKILLS

BI Tools: Cognos 10.1.0/1, 8.4.1/8.4/8. x Suite Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio, Metric Studio, Cognos Transformer 8.4/8.3 (Multi-Dimensional OLAP), Report Net 1.1/1.0x, Cognos Business Insight Advanced, Cognos EP Series 7 (Impromptu, IWR, Power Play Transformer and Power Play Windows/Web), Cognos Administration, Access Manager, Cognos Connection, PowerPlay Studio, PowerPlay Client, Cognos PowerPlay Enterprise Server (PPES), Cognos Visualizer. Qlikview, Brio, Business Objects XI R2, Designer, Info View, Web-Intelligence XI, Xcelsius 2008/2011, Application Foundation 6.0/2.5 & Dashboard Manager, Crystal Reports, Broadcast Agent.

Scripting Languages: ASP, JavaScript

Databases: Oracle 9.x/10g/11g, SQL Server 2000/, DB2, MS Access

Querying/Reporting: T-SQL, SQL * Plus, SQL*Developer, TOAD, ORACLE

Web Portal Technologies: HTML, Visual Studio

Programming Languages: SQL, TSQL, XML, Cognos java SDK.

Data Modeling Tool: Cognos Framework Manager

Web Servers: IIS, Apache

Documentation Tools: Latex, MS Office (Including MS Project, VISIO)

Operating Systems: Windows.NET/2000/XP/ 2003/2000/98/95 , Windows Server 2000/2003, Linux Distributions-Red hat,Ubuntu

Database Connections: ODBC, JDBC

PROFESSIONAL EXPERIENCE

Confidential, NJ

Cognos BI Developer

Responsibilities:

• Interacted with Business Users for gathering Business Requirements to develop the reports.
• Generated packages in Framework Manager and published them to be used in creating reports in Cognos studios.
• Developed Standard Reports, list, cross tab, power play cubes, drill-through Reports by using Report Studio, power play studio and also delivered reports in different formats like PDF, XML, HTML and CSV.
• Enhanced the existing reports and cubes by addition of new dimensions and level1 and level 2 leaf categories in the power play studio.
• Modified the existing cubes by including the new dimensions for Dealer Sales Loyalty and Brand loyalty.
• Scheduling and Distributing Reports through Scheduler in Cognos Connection.
• Created power play studio Reports using Power Play cubes.
• Testing and improving Report Performance.
• Involved in importing and exporting of data (reports/package) from development to production using the deployment option in the Cognos connection portal.
• Created dynamic cubes and reports for the VIA 2.6 project (Vehicle installed Accessories.
• Performed report bursting by sending reports through emails.

Environment: AQT (Advance Query Tool), SQL Developer, Cognos 10.2.0/10.2.1 BI Suite (Framework Manager, Cognos Connection, Reports Studio, Query Studio, Analysis Studio, Business Insight Advanced), Cognos Transformer 8.4, Power play studio.

Confidential, MN

Sr.Cognos Developer

Responsibilities:

• Interacted with Business Users for gathering Business Requirements to develop the reports.
• Generated packages in Framework Manager and published them to be used in creating reports in Cognos studios.
• Developed Dashboards which consisted of Standard Reports, list, cross tab, charts, drill-through Reports by using Report Studio, Query Studio and also delivered reports in different formats like PDF, XML, HTML and CSV.
• Designed reports using slicers to filter dimensional data.
• Published reports in Cognos connection and implemented security to grant access to business group.
• Scheduling and Distributing Reports through Scheduler in Cognos Connection.
• Grant permissions to the users to access the Cognos reports using java SDK.
• Created custom security provider using java SDK.
• Scripted out administrative tasks using java SDK.

Environment: Cognos 10.1.0/10.1.1 BI Suite (Framework Manager, Cognos Connection, Reports Studio, Query Studio, Analysis Studio, Business Insight Advanced), Cognos Transformer 8.4, Teradata, SQL Assistant, Cognos Administration, Cognos java SDK.

Confidential, CA

Sr. Cognos Developer

Responsibilities:

• Gathering Business Process Requirements from business users, for the reports to be developed and transforming them into functional requirements.
• Migrating reports from Qlikview BI to Cognos BI.
• Expertise in designing and developing DMR and Relational models using star and snowflake schemas.
• Training users to use the Cognos connection to access their corresponding reports.
• Developed various reports like lists, cross tabs, charts, complex reports with conditional block, static choices in prompt etc.
• Expertise in using Query Studio for developing Ad hoc reports.
• Expertise in developing Dash Boards using Report Studio.
• Used joins to extract data from different tables.
• Working closely with the data modelers and providing them with queries, those are required to develop the facts & dimensions in the data model.
• Created calculations, filters, prompts and conditional formatting in Report Studio reports.
• Developed hide and show reports by using Conditional blocks and HTML Items.
• Expertise in creating reports by using Master Details, Drill through, Drill up and Drilldown.
• Performance tuning of the complex reports for better performance.
• Expertise in developing Prompt pages and Cascaded input prompts.
• Tested the Metadata model and relationships in Framework Manager.
• Moving/deploying reports from Development to testing and production servers using Content Administration.
• Follow quality standards and best practices for the development tasks.
• Created views and tables in Oracle Server database as a requirement for some Cognos reports.
• Installing and configuring of Cognos 8BI and Sun Solaris Server.
• Effectively involved in Unit Testing.
• Provided administration support and Development support for production issues.
• Worked on PL/SQL to generate stored procedure for data preparation.
• Scheduled and distributed reports using Scheduler in Cognos Connection.

Environment: Cognos 10.1.1/8.4/8.3 BI Suite (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), PL/SQL Cognos Transformer 8.4, Oracle 11g, SQL Server 2005/2008.

Confidential, Hoffman Estates, IL

Cognos Business Analyst/Developer

Responsibilities:

• Interacted with Business Users for gathering Business Requirements to develop the reports.
• Generated packages in Framework Manager and published them to be used in creating reports in Cognos studios.
• Developed Standard Reports, list, cross tab, charts, drill-through Reports by using Report Studio, Query Studio and also delivered reports in different formats like PDF, XML, HTML and CSV.
• Designed reports using slicers to filter data.
• Performed report bursting by sending the reports through E-mail.
• Scheduling and Distributing Reports through Scheduler in Cognos Connection.
• Created Analysis studio Reports using PowerPlay cubes.
• Defined agents using Event Studio.
• Testing and improving Report Performance.
• Involved in importing and exporting of data (reports/package) from development to production using the deployment option in the Cognos connection portal.

Environment: Cognos 8.4 BI Suite (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio) Cognos PowerPlay Transformer, Oracle 10g.

Confidential, Pittsburgh, PA

Cognos Consultant

Responsibilities:

• Installed and ConfiguredCognos8.4BIin a multi-tier Environment.
• Involved in Developing Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses’ needs (Folders, Filters, and Macros).
• Design and develop query models that support their tactical and strategic reporting needs
• CustomizedCognosConnectionwith appropriate reports and security measures.
• Created new jobs and scheduled reports using Cognos Connection.
• Design and develop logical dimensional models implemented in multi-dimensional databases or cubes and in the form of star schema database.
• Design, Develop, Build and Support metadata/ models and cubes in Transformer.
• Developed reports involving Multi Query, Multi page, Discontinuous cross tab, Graphical, Repeater, Union queries with a very high level of detail and formatting.
• Created custom prompt reports in Report Studio, Bursting reports to different user groups.
• DevelopedDash Board reportsinReport Studio.
• Trainedpower usersto useQuery StudioforAd-Hoc reporting.

Environment: Cognos 8.4, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection, PowerPlay Transformer, Informatica Power Center, SQL Server 2005, IIS Web Sever.

Confidential, CA

Cognos Developer

Responsibilities:

• Interacted with the Business users for requirement gathering.
• Installed & configured Cognos component such as the ReportNet.
• Created the list, cross tab, repeater and Drill-through reports, master-detail reports, prompts, complex calculations, formatting, conditional formatting, Bursting reports, charts and created the reports in different formats like PDF, XML, HTML and CSV.
• Created Cascade Prompts, Bookmarks, Query prompts, Filters, and Multilingual Reports Using Report Studio.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various IQD packages in Framework Manager and from this IQD integrated to power play transformer to create various models and cubes.
• Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.
• Configured access manager namespace in Cognos connection and created new users and user groups in access manager.
• Provided technical assistance, training and mentoring to Users and Business Partners

Environment: Congo’s Report Net 1.1 MR3 (Framework Manager, Report Studio, Query Studio), Oracle 9i, SQL Server 2000, SQL, Windows XP/NT

Confidential

Business Objects Developer

Responsibilities:

• Designed complex Web Intelligence and Desktop Intelligence Reports.
• Created and tested classes and objects to organize the universe.
• Created complicated reports including sub-reports, graphical reports and well formatted reports according to user requirements.
• Linked the universes to share the common objects between them.
• Created Alerts in various reports according to user requirements.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end user.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Involved in creating aggregate tables at different levels.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and predefined conditions to use in Business Objects.
• Involved in designing Business Objects Universes, Queries and Reports.
• Used Broadcast Agent to schedule the reports depending on the user profile.

Environment: Business Objects XI R2, Designer, Web Intelligence XI, Desktop Intelligence, Xcelsius, Crystal Reports, Info View, BO Live Office, Dashboards, Performance Management, SQL Tuning, SQL Server 2005, OLAP, Oracle 10g, RDBMS, SQL, Windows 2003/XP, SQL plus, SAP Business Objects suite.