SUMMARY

• Certified IBM Cognos 10 BI Author Consultant with over 8 years of experience in Designing and Development of Relational database applications, Data Warehouse, BI Applications on multiple domains like Financial, Banking,Manufacturing, Fleet Management, Health Care and Pharmaceutical industries.
• Extensive experience in BI Modeling/Report Authoring using Cognos 8 (Report Studio, Analysis Studio, Query Studio, Metric Studio, Cognos Connection, Framework Manager),Cognos ReportNet,Cognos Series 7 (Impromptu, Impromptu Web Reports, Metrics Manager), OLAPCube development using Cognos PowerPlay and Transformer, and implementing security using Cognos Access Manager.
• Expertise in Business requirements gathering and designing Functional and Technical documentation.
• Strong experience on creating complex reports with Report Studio to customize the functionality by using Filters, Prompts, Master Detail Relational ships, Drill through definition and Conditional Formatting.
• Expertise in developing ad - hoc reports using Query Studio, creating complex analysis quickly by using Analysis Studio, analyzing metrics and other performance measures within an organization by using Metric Studio.
• Experience in designing interactive Dashboards with user friendly capabilities such as Prompts, Navigation and drill-down using Cognos Report Studio.
• Hands on experience on creating Physical Layer, Performance Layer, Presentation Layer while developing the models in Framework Manager.
• Extensive experience on Cognos Transformer for building Multidimensional Cubes.
• Experience with DMR Models, Cube data sources in Cognos Framework Manager and published to analyze Crosstab reports with Analysis Studio.
• Experience with importing metadata from various sources such as DB2, Oracle, MS SQL Server, and existing Cognos 8 Models files into Framework Manager.
• Performed interactive and batch operations and also involved in developing custom portal tabs.
• Excellent knowledge on Data Mart Architecture, Data Modeling and Dimension Modeling using Star Schema, Snow-Flake Schema and worked on both OLAP and OLTP databases.
• Extensive experience on Production Support and Troubleshoot/Test Issues with existing Reports and Cubes.

TECHNICAL SKILLS

BI Tools: Cognos 10.1, Cognos 8.x BI Suite (Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Connection), Access Manager, Cognos 10 Go Office,Cognos Impromptu 7.x, Cognos Report Net 1.1 MR1 and MR2, SSRS, MotioCI, MotioPI.

ETL Tools: Informatica, SSIS, Data Stage.

Data Modeling: Framework Manager, PowerPlay, Star-Schema Modeling, Snowflake-Schema Modeling, Fact and Dimension tables, Pivot Tables, Erwin.

Databases: MS SQL Server 2008/2005/2003 , Oracle 10g/9i/8i, MS Access, DB2

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

Web Servers: IIS, Apache and Tomcat

Applications and Operating system: MS Office Suite, MS Visio, Windows 2000/2003/XP/7, Windows NT 4.0, UNIX, TOAD

PROFESSIONAL EXPERIENCE

Confidential, OH

Sr. Cognos Report Developer

Responsibilities:

• Analyzed and reviewed business requirements and technical specification documents for report development.
• Extensively involved in troubleshooting of complex reports.
• Modified the existing report designing according to the new business requirements.
• Created List, Cross tab and various graphical presentation of reports.
• Incorporated different reporting functionalities such as Master Detail, Cascading prompts, Drill down and Drill-Through into multiple reports.
• Created multiple prompt pagesusing Java scripts to validate the data on each report for narrowing the report output.
• Extensively implemented complex reporting functionalities using Conditional formatting, Conditional blocks using multiple variables and parameters.
• Created multiple Layout Component Objects and incorporated into the reports.
• Created multiple report templates which help developers to create new reports according to the company standards and created ‘Read Me’ documents.
• Created multiple UTP documents for report testing.
• Involved in performance tuning of complex reports and analyzed Cognos SQL with native SQL.
• Created multiple complex reports by using complex queries,detail and summary filters.
• Created and modified dashboard reports for business managers.
• Participated in building customer portal site with web development team.
• Worked on third party tool Motio to control different versions of the Cognos reports in Cognos 8.4.1 and Cognos 10.1.
• Involved in automated testing of Cognos reports using Motio.
• Developed complex reports which serves multiple business requirements in a single report.
• Created ad-hoc reports using Cognos Query studio.
• Used Framework Manager to analyze the models, packages and published packages to the Cognos server
• Scheduled and Distributed reports through schedule management in Cognos connection.
• Provided production support for the reports and involved in activities including program analysis, testing and system enhancements.

Environment: Cognos 10.1, Cognos 8.4.1, Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos Power Play Transformer, Cognos Connection, Cognos 10 Go Office,Oracle SQL Developer, TOAD, MS SQL Server, SQL, PL/SQL, Oracle 10/11g, MotioCI, MotioPI and Windows 7/2003 server.

Confidential, NY

Sr.Cognos Developer

Responsibilities:

• Analyzed Business requirements from the analysts.
• Created and modified various List Reports, Grouped Reports, Cross Tab Reports and Drill-Through Reports.
• Developed reports using various functionalities like Master Detail, Conditional Formatting, Conditional Blocks and Multiple Prompts.
• Working closely with ETL developers in building data marts as per the requirements.
• Created Global Graphical reports to view and analyze company’s corporate performance.
• Implemented various Prompts, Parameters, Filters, calculated measures, aggregations, conditions and created reports using sub-queries and multiple queries.
• Developed Prompt Pages, Cascaded Promptsand also worked on the customization of prompt parameters.
• Testing and improving report performance, performance tuning of complex reports on report level.
• Customized Cognos Connection with appropriate reports and security measures.
• Developed relational and dimensional models in Framework Manager by defining the relationships between query subjects maintaining the data integrity.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports.
• Involved in Migration of Cognos BI applications from version 7.x to 8.4.
• Migrated Cubes from Cognos 7.4 version to Cognos 8.4.
• Resolved the issues occurred when migration of reports from previous versions to the Cognos 8.4.
• Using Framework Manager to build Models, Packages and publish packages to the Cognos Server.
• Scheduled Reports and Power Play Cubes to run on Daily, Weekly and Monthly basis.
• Handled Security and Administration in Cognos connection portal.

Environment: Cognos 8.4.1, Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos Impromptu 7.4, Cognos Power Play, Transformer 7.4, Cognos Connection, Oracle SQL Developer, MS SQL Server, SSIS,SQL, PL/SQL, Oracle 10g and Windows NT/4.0.

Confidential, Dorchester, MA

Sr. Cognos Consultant

Responsibilities:

• Interacted with business users to gather business requirements and designed functional and technical documentation.
• Designed and developed the Framework Manager Models and Published into server for further use in the report authoring process.
• Built models containing namespaces, level hierarchies, query subjects, query items and members from scratch as well as from imported metadata.
• Created Stored Procedure query subject with a prompt value into the model while creating a package in Framework Manager.
• Developed Multidimensional Models (Cubes) using CognosPowerPlay Transformer.
• Created stand-alone filters and embedded filters while creating a model by using Cognos Framework Manager.
• Designed & developed reports using Report Studio, created ad-hoc reports using Query Studio and helped business user in creating Analysis reports using Analysis Studio.
• Developed Simple List, Nested Cross tab, Chart, Drill through reports.
• Created complex reports with advanced features such as Master detailed sections, Conditional formatting, Page Set, bursting, Render&Boolean variables using Report Studio.
• Used Drill-up/down and Drill through functionalities to give a detailed and analytical report.
• Applied Cascading Prompts functionality in runtime for narrowing the final results for better understanding of the requirement.
• Created Dash Board Reports using Report Studio MDX functions and added to the portal page.
• Scheduled and distributed reports to the end users by schedule management in Cognos Connection.
• Developed Stored Procedures and Database Triggers in PL/SQL.
• Generated SQL/MDX & analyzed Cognos SQL, Native SQL to troubleshoot the report issues.

Environment: Cognos 8.4 BI Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager, Transformer, PowerPlay, MS SQL Server 2008, SSIS, Oracle 9i, SQL, PL/SQL, Windows XP.

Confidential, Pittsburgh, PA

Sr. Cognos Report Author

Responsibilities:

• Constantly interacted with the business users, attended several meetings in understanding the requirements better for development of application.
• Created standard Calculations, Filters, Data Source Query subjects, Model Query subjects in Framework Manager as per the Business Requirements, which minimize the report complexity.
• Generated OLAP Cubes in Cognos Transformer and analyzed the data using Cognos PowerPlay.
• Developed complex reports using Cognos Report Studio.
• Created Query calculations, Layout calculations, Filters and Prompts for usage in various reports.
• Generated multi object reports such as Lists, Crosstabs, Charts, Images and HTML applications using Report Studio and ad-hoc report using Query Studio.
• Extensively worked with different kind of prompts like Select and Search Prompt, Cascading Prompt, Date Prompt and Values Prompt.
• Created reports in Analysis Studio to verify the data is legitimate against the Drill through report in Report Studio.
• Created Templates, Dashboards, standard reports, and ad-hoc reports using Query Studio and Report Studio.
• Created complex reports which involved multiple Queries, Prompts, Filters reports against multiple databases.
• Created Master Detail Reports, Drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Developed Models in Framework Manager and created .iqd files to use them as source in Transformer’s while building Cubes.
• Provided solutions and implemented efficient ways to improve the performance of the reports.
• Created burst table & reports and made them available for appropriate users.

Environment: Cognos 8.2 BI Report Studio, Query Studio, Analysis Studio, Framework Manager, Transformer, PowerPlay, MS SQL Server 2005, Informatica Power Center, Windows XP.

Confidential, Bethesda, MD

Cognos Consultant

Responsibilities:

• Designed Metadata Models using Framework manager and published packages in to the Cognos Content Store.
• Analyzed existing Reports, created new and enhanced .cpf files for Framework Manager to accommodate future growth in reporting requirements.
• Created new Query Subjects and arranged in different folder structure for business view.
• Developed Multidimensional Models and Cubes using Cognos Transformer.
• Published packages and managed securities.
• Created Row level security for all Framework structures.
• Formulated Joins, resolved relationship &Cardinality in Framework Manager.
• Created predefined Filters in the Metadata Models.
• Generated Lists, Crosstabs, and Chart report by using Report Studio.
• Customized reports by applying Sections, converted a List report to a Crosstab report by using pivot function, and reused the objects within the same or another report to save the time.
• Developed complex reports having many Calculations, Variables, Prompts etc. in Report Studio.
• Involved in the performance tuning of SQL queries.
• Involved in investigating, modifying code modifying using Oracle PL/SQL and code review.

Environment: Cognos 8.2, Report Studio and Query Studio, Analysis Studio, Framework Manager, Netezza, Oracle 8i, SQL, PL/SQL, Data stage, Windows XP.

Confidential, Peoria, IL

Cognos Developer

Responsibilities:

• Involved in gathering Business requirements from business analysts and users.
• Interacting with Development and Management teams, providing Technical Assistance to Developers.
• Used Framework Manager to build Metadata Model, which could be used by Report Developers to generate custom reports.
• Created, published and modified several packages in Framework Manager according to the business needs.
• Developed Standard Reports, Dashboard Reports, Charts, Drill through Reports, Master Detail Reports, Bursting Reports using Report Studio and Query Studio.
• Created Query Prompts, Calculations, Filters and Conditional Formatting.
• Scheduling and distributing reports through Schedule Management in Cognos Connection.
• Query optimization, Performance tuning of reports and model.
• Trained users on Query Studio for ad-hoc reporting.
• Involved in migration of Cognos code (Reports/Models/Frameworks) from one environment to another using migration utilities imcat2xml, migtoc8.
• Involved in implementing security authentication using LDAP and NTLM.

Environment: Cognos 8.1, Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos Connection, PowerPlay, Transformer, Access Manager,LDAP, NTLM, imcat2xml, migtoc8, DB2, MS SQL Server, Oracle 8i/9i, SQL, PL/SQL, Windows XP.

Confidential, Auburn Hills, MI

BI Consultant

Responsibilities:

• Actively involved in meetings with the user group and designed Business Requirement Documents (BRD).
• Involved in gathering Business Requirements for models directly from the users.
• Created, modified and published Framework Manager Models on ReportNet Server.
• Applied MultipleFilters, Prompts by using parameters, Calculations and Conditional formatting and created CRN Reports.
• Created various reports like List, Crosstab using Cognos ReportNet.
• Involved in deployment and maintenance of the Cubes, Packages and Reports in development, test and production environment.
• Created Models by using PowerPlay Transformer.
• Created DMR Models by using Dimensions, Hierarchies and Levels.
• Involved in scheduling and administering the Cognos ReportNet reports using Schedule management in Cognos Connections.

Environment: Cognos ReportNet 1.1 MR2 (Report Studio, Query Studio, Framework Manager, Cognos Connection), PowerPlay, Transformer, SQL Server 2003, SQL,Windows XP.

Confidential

Report Analyst

Responsibilities:

• Created new Catalogs for reporting using Cognos Impromptu.
• Generated customized reports by using Filters, Prompts, Calculations and Functions.
• Created standard ad-hoc reports using Cognos Impromptu.
• Tested the Joins, inbuilt filters and calculations are working correctly and documented all of the work for submitting it to the users for verification.
• Distributed copies of data using Local snapshots, Remote snapshots, Thumbnails and Hot files to improve report performance.
• Created some complex reports using master-detail relationship terminology.
• Created and monitored multiple shared catalogs using Cognos Impromptu.
• Worked with system analyst to understand the flow of data and developed Framework Manager Models.

Environment: Cognos Impromptu 6.1, Impromptu Web Reports 6.1, Cognos PowerPlay 6.1, Cognos Transformer 6.1, DB2 and Windows 2003.