Summary

• Cognos Certified Professional with over 8 years of total IT industry experience analysis, design, testing, development and implementation of client/server applications.
• Expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 6 / 7/ 8 and Cognos ReportNet.
• Extensively worked with Cognos Tools such as Cognos 8 Suite(8.1/8.2/8.3/8.4), Cognos Reportnet 1.1.MR3, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Power Prompts, and Analysis Tools such as Cognos Transformer & Power Play 7.x/6.x, Access Manager and Server Installation & Maintenance.
• Expertise in Cognos 8 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio ,Event Studio and Query Studio).
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages), Security, Packages and Complex Report building with Report Studio.
• Installed and Configured Cognos 8.3 in single server Environment.
• Experience in the installation and administration of Cognos ReportNet 1.0/1.1MR2 in a distributed environment.
• Expertise in Report building using Report Studio, Query Studio and Analysis Studio.
• Experience in Transformer model design and Power play cube building.
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
• Having knowledge on ETL tools like Informatica.
• Worked with senior academic and administrative officers in support of financial management.
• Having good knowledge of Data Modeling Concepts (Normalization, Star Schema, and Snowflake Schema).
• Sound knowledge of Oracle 10g, Oracle 9.x/8.x/7.x, DB2, PL/SQL, MS SQL Server 2000/2005(including stored procedures, database triggers and SQL programming).
• Experience in interacting with end users to gather requirements for reporting.
• Coordinated with the client representative to resolve any functional and technical issues faced by the project team.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.

CERTIFICATIONS:

TECHNICAL SKILLS:

Reporting Tools: Cognos 8.1/8.2/8.3/8.4 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio) Cognos EP Series 7.3, Cognos Impromptu 7.3, Power Play 7.3, IWR, Upfront.
ETL : Informatica, SSIS.
Databases: Oracle 8i/9i/10g ,SQL Server 2000/2005, DB2.
Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX, linux.
Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS).

PROFESSIONAL EXPERIENCE:

• Involved in Requirement gathering from Business Users.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Designed and Developed the Framework Manager models and Published into the

Cognos Connection.

• Designed & developed the reports using Cognos 8 Report Studio, Query Studio, Analysis Studio reports.
• Worked as an administrator on Cognos suit of products.
• Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Involved in working with cubes and developed various dashboard reports.
• Extensively worked on Analysis Studio to develop multi dimensional reporting.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Map Reports Using Report Studio and Query Studio.
• Created complex dashboards with pie charts, crosstab and Multi prompts in Report Studio.
• Developed various reports using functionalities like Render Variables, Conditional Blocking, Cascading Prompts, and Conditional Formatting.
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Used SQL Server Management Tool to check the data in the database as compared to the requirement given.
• Exposure on Cognos development Software development kit like SDK in order to customize reports.
• Coordinating with Development Team tasks& Deliverables and working on high priority issues.
• Involved in writing Complex SQL queries to improve the performance of the report.

Designed Database Tables, Indexes, Keys, Database Triggers and Stored Procedures in Oracle. 

Testing reports using review checklists for Quality Assurance before delivering to the end users. 

• Involved into move to Deployment to UAT and Production.

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

Confidential. Sept’07 – Mar’09
Domain: Financial.

Role: Cognos Developer.

Responsibilities:

• Analyzed Business requirements from the analysts.
• Customized Cognos Connection with appropriate reports and security measures.
• Interviewed business community to identify business, data, and delivery requirements.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Involved in Designing models using Framework Manager and deployed packages to the Report Net Servers.
• Implemented Framework manager security for Data access, Object level access and Package access.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Created Drill- through reports and Customized Reports with Prompts.
• Involved in working with Cascading Prompts, Conditional Formatting, and Conditional Blocking.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members.
• Scheduled Reports using Cognos Connection.

Wrote some complex SQL queries to enhance the performance of the cognos reports.

• Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Prepared User documentation to train users and functionality of each report.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.

Environment: Cognos 8.2, Reportnet1.1 MR2, Cognos Series 7(Cognos Power Play 7.3, Cognos Transformer7.3, PPES, Access manager, Impromptu, IWR), Oracle 9i/10g,SQL Server 2000/2005 ,windows 2000, UNIX 5.0.

Confidential, VA. Jan’06 to Aug’07

Domain:Insurance.
Role: Cognos Consultant.

Responsibilities:

• Involved in Gathering Requirements and the reporting issues from the End users.
• Analyzed Business requirements from the analysts.
• Interacted with Development and Management Teams.
• Involved in Desiging models using Framework Manager and deployed packages to the Report Net Servers.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Modeled metadata from SQL Server 2005 data source for use in Report studio and Query Studio using Framework Manager in ReportNet.
• Developed various reports like List, Cross tab, Chart and complex reports using various functionalities like Master-Detail, Drill through Capabilities, Multi Prompts, Conditional Formatting.
• Created custom templates and custom toolboxes for the use of reporting.
• Involved in creating Query Prompts, calculations, Conditions & Filters.
• Customized Cognos Connection with appropriate reports and security measures.
• Involved in Query Optimization, and Developing Prompt pages and Conditional variables.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• As Cognos Impromptu administrator, I was taking care of catalog related issues such as: Creation & Modification of catalog.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Moved projects from development to QA and then Production servers.
• Involved in the Testing of the reports and updating the Bug Tracking Tool.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members.

Environment: Cognos 8.0 BI Suite, Cognos Framework Manager, Cognos Impromptu 7.3, Cognos Report net 1.1, Cognos Power Play 7.3, Cognos Transformer 7.3,SQL Server 2005, Windows 2003 Server.

Confidential, Newark ,NJ. Jan’04-Dec’05
Domain:Financial.
Role: Cognos Developer.

Responsibilities:

• Worked on framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos server.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Developed complex reports and simple reports using Report studio.
• Created prompts, filters, sub reports and conditions.
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Extensively worked in Scheduling and Deploying (Staging to Production) Reports.
• Worked on complex reports using Tabular Objects, Static Prompt conditions.
• Involved in designing and building the Poweplay cubes using Transformer.
• Built Power Play Reports based on these cubes and published to ReportNet Server.
• Administering the business users in the portal based on the requirements.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Developed Stored Procedures and Database Triggers in PL/SQL.
• Designed extensive sample business Reports to cater the needs, which can meet their future demands on behavioral, trend analysis.
• Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports.

• Responsible for overseeing the Quality procedures and Software configuration management related to the project.
• Production Support, which involves solving user problems.

Environment: Cognos ReportNet1.1 MR2 (Framework Manager, Query Studio, Report Studio) Power Play Enterprise Server 7.3, Transformer 7.3, DB2, Windows 2000.

Confidential May ’02 – Dec’03
Role: SQL/PLSQL Developer.

Responsibilities:

• Involved in a team in designing the database schema for the metadata for storing the informative queries that are generated dynamically.

• Involved in creation of schema objects like tables, indexes, views, stored procedures, functions, triggers and synonyms.

• Tuned SQL queries and performed code debugging using SQL Navigator.
• Involved in testing, Code Walkthroughs and Reviews.
• Managed space, users, database objects, profiles and security.

• Involved in testing the database for the queries that are generated and handled the performance issues effectively.
• Involved in documenting the entire technical process.

Environment: Oracle 7.3/8i, SQL, PL/SQL, SQL* Loader, Toad, Windows NT.