SUMMARY

• Cognos Certified Professional with over 8 years of total IT industry experience including 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 10/8/7 and Cognos ReportNet.
• Extensively worked with Cognos Tools such as Cognos 10.2.2/10.2.1/10.1.1/ Cognos 8 Suite (8.1/8.2/8.3/8.4 ), Cognos Reportnet, and Analysis Tools such as Cognos Powerplay Transformer, and Server Installation & Maintenance.
• Experience in Guidewire.
• Expertise in Cognos 10.2.2/10.2.1/10.1/8 BI Suite (Framework Manager, Cognos connection, Report Studio, Cognos Workspace Advanced, Cognos Workspace, Business Insight Advanced, 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 in a distributed environment.
• Expertise in Report building using Report Studio, Cognos Workspace Advanced, Cognos Workspace, Business Insight, Query Studio, Event Studio and Analysis Studio.
• Experience in Transformer model design and Power play cube building.
• Experience in Migrating reports from Cognos 8 to Cognos 10 Environment.
• Responsible for designing and implementing OLAP Reporting environment.
• Having knowledge on ETL tools like Informatica.
• Having good knowledge of Data Modeling Concepts (Normalization, Star Schema, and Snowflake Schema).
• Sound knowledge of Oracle 11g/10g, Oracle 9.x/8.x/7.x, DB2, PL/SQL, MS SQL Server 2005/2008(including stored procedures, Views, Materialized Views and SQL programming).
• Experience in interacting with end users to gather requirements for reporting.
• Excellent interpersonal and communication skills, technically competent and result - oriented with strong problem solving skills.

TECHNICAL SKILLS

Reporting Tools: Cognos 10.2.2/10.2.1/10.1.1/ 8.4/8.3/8.2/8.0 Suite (Framework manager, Report Studio, Query Studio, Cognos Workspace Advanced, Cognos Workspace, Business Insight, Analysis Studio, Cognos Connection, Event Studio) Cognos Powerplay Transformer, V10.

ETL: Informatica, Datastage, SSIS.

Databases: Oracle 8i/9i/10g/11g, SQL Server 2005/2008/2010 , DB2.

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX, linux.

Languages: HTML, XML and JavaScript.

Servers: Application Servers (Tomcat), Web Servers (IIS, IHS).

PROFESSIONAL EXPERIENCE

Confidential, Florida

Sr. Cognos Developer

Responsibilities:

• Understanding and analyzing the business requirements, reporting enhancements and issues reported by the end users and Developed technical specification documents.
• Involved in status meetings to discuss the work priority and meetings with the Business Analyst to discuss new requirements as well as the enhancements to the existing requirements.
• Designed and developed various kinds of complex dashboards and reports using Report Studio, Cognos Workspace Advanced, Cognos Workspace, Business Insight Advanced, Query Studio, and Analysis Studio.
• Modified and created existing/new metadata models using Framework Manager and Created Packages and published to the Cognos Connection.
• Created different query subjects like Model Query subjects, Data Source Query subjects, Stored Procedure Query subjects as per the business requirements in the Framework Manager.
• Modified and Enhanced the existing reports based upon the new requirements from the users.
• Developed various kinds of Reports like Lists, Crosstabs, Charts, Active Reports, Drill Through Reports, Master Detail Reports, Repeater Table using Report Studio and Query Studio.
• Developed various types of complex reports using different functionalities like Page Break, Sectioning, Cascading Prompts, Optional prompts, Bookmarks, Conditional Formatting, Render Variables, Drill through, Drill Down, Drill up, and Conditional Blocking.
• Developed OLAP and Excel Reports for SEC reporting.
• Worked on DMR metadata modeling in Framework Manager and published packages to Cognos connection.
• Involved in creating cubes using Cognos Power Play Transformer.
• Worked on Dashboards and Reports using Cognos V10 and which sets in Hana DB Environment.
• Worked on the Performance issues of the reports by analyzing and comparing the turn around times between SQL and Cognos.
• Worked closely with the ETL team to resolve data issues.
• Worked closely with the QA team involving in meetings and resolving issues reported during the testing process.
• Interacted with the Business Analysts and End users on a regular basis for resolving issues pertaining to the reports as a part of UAT.
• Involved in unit testing the reports and enhanced the performance of the reports by writing Complex SQL queries.
• Coordinated with the migration team to deploy the reports and packages from Development to QA, UAT and Production environments.
• Involved in Scheduling and distributing the reports using Cognos administration and Autosys jobs.
• Transferred technical knowledge specific to Cognos tools to other team members.

Environment: Cognos 10.2.2 Suite (Cognos Connection, Framework Manger, Report Studio, Cognos Workspace Advanced, Cognos Workspace, Business Insight, Query Studio, Analysis Studio), Cognos Powerplay Transformer, SQL Server 2008/2010, Oracle 11g, Windows 7, Informatica.

Confidential, Chicago

Sr. BI Consultant.

Responsibilities:

• Involved in Gathering requirements, analyzing the business specifications and the reporting issues provided by the End users and Developed specification documents for reports as per client requirements.
• Interacted with Development and Management Teams.
• Used Framework Manager to import metadata from multiple datasources, to Design and Develop the Framework Manager models.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Created Packages and published to the Cognos Connection.
• Scheduling and distributing the reports using Cognos administration.
• Designed and developed the reports using Cognos Report Studio, Query Studio, Analysis Studio and Event Studio.
• Created complex dashboards with crosstabs, charts, and Multi prompts in Report Studio.
• Developed various kinds of Reports like Charts, Drill Through Reports, Master Detail Reports using Report Studio and Query Studio.
• Developed various types of reports using functionalities like Render Variables, Conditional Blocking, Cascading Prompts, and Conditional Formatting.
• Involved in providing the Security to the reports, packages and folders in cognos Administration.
• Involved in Performance tuning of the reports by analyzing and comparing the turn around times between SQL and Cognos.
• Involved in testing the reports and enhanced the performance of the reports by writing Complex SQL queries.
• Involved in deploying code to QA, UAT and Production.

Environment: Cognos 10.1.1 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Office Connection), Oracle 10g, Cognos Transformer, SQL Server 2005.

Confidential, New York, NY

Sr. Cognos BI Developer

Responsibilities:

• 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.
• Used Cognos 8 Report Studio, Query Studio, Analysis Studio to design and develop various kind of 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.
• Developed Standard Reports and Scorecards using Lists, Crosstab Reports, Charts in Report Studio, Query Studio and Event Studio.
• Created complex dashboards with pie charts, crosstab and Multi prompts in Report Studio.
• Developed various reports using functionalities like Drillthrough, MasterDetail, 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.
• Involved in writing Complex SQL queries to improve the performance of the report.
• Designed Database Tables and Stored Procedures in Oracle.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved in Deployment to QA, 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, Minneapolis

Sr. 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.
• 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.
• 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, Framework Manager, Cognos Transformer, Cognos Series 7(Cognos Power Play 7.3, Access manager, Impromptu), Oracle 9i/10g, SQL Server 2000/2005, windows 2000.

Confidential

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 Designing 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 Transformer 7.3,SQL Server 2005, Windows 2003 Server.