PROFESSIONAL SUMMARY:

• Having 6+ years of experience in IT industry with a strong background in Analysis, Design and Development in the field of Database, Data Warehouse, Data Modeling and implementation of Cognos applications.
• Experience with the Cognos 8 BI tools (Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Transformer) both as a Developer and Administrator.
• Involved in Metadata modeling using Framework Manager, creating Projects, Models, Packages, Security, Parameter mapping and Complex Reports building with Report Studio.
• Experience in working with Active Reports and Business Insight.
• Implemented Security at different levels in Framework Manager and Cognos Connection in restricting access.
• Developed List, cross tab, drill through, master - detail, chart and complex reports which involved Multiple Prompts, multi-query, Burst Reports against database.
• Analyzed multidimensional data and generated reports using Analysis Studio.
• Experience in Upgrading Dev, QA and Prod environment from Cognos 10.1.1 to Cognos 10.2
• Installed and Administered Cognos products (10.2) in both gateways and dispatchers in distributed environment (Dev and QA).
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
• Experience in implementing security requirements for data mart and packages solutions using ReportNet.
• Involved in customizing interface as per end user productivity using SDK.
• Involved in Relational and Dimensional (DMR) Modeling.
• Developed Reports using Cognos 10.1 New Features. Build Reports using External Data in Report Studio.
• Developed Reports using Cognos Analytics 11.0.3.0 and tested some of the New Features.
• Experience in building Multidimensional models for distribution using Transformer.
• Good Experience with MDX Functions in Report Studio using Multi-Dimensional Sources.
• Involved in full life-cycle Data Warehouse activities,including defining project roles and responsibilities, detailing project plans, requirements gathering and specification, logical and physical database design in both relational and dimensional, reporting requirements specification, and implementation / ongoing support tasks.
• Expertise in Data Warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Extensively worked on Relational Databases like Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005/2008 and DB2and database access tool TOAD.
• Involved in customizing reports using Java Scripts.
• Developed and prepared new and enhancement of existing Cognos 8 applications.
• Experience in creating complex Packages, Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Joins, SQL, and SSIS.
• Knowledge on ETL tools like Informatica.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS:

Cognos Analytics 11.0.3.0: Cognos 10.2 BI: Cognos 8BI: Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis studio and Event Studio, Business Insight, Active Reports, SDK.

Cognos ReportNet: Report Studio, Query Studio, Cognos Connection and Framework Manager.

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, HIS, Apache).

Operating Systems: Windows 7/VISTA/NT/ XP/ ME/ 2000/ 95/ 98, LINUX/UNIX.

MS: SQL Server 2000/2005, Oracle 10g/9i/8i, DB2, Teradata.

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

PROFESSIONAL EXPERIENCE:

Confidential, IL

Sr. Cognos Developer

Responsibilities:

• Gathered Business requirements and designed functional and technical requirements documentation for Globalization of Reports.
• Built a DQM Modelwith Relational Data using Framework Manager to support the multiple languages for Report Globalization and Deployed Packages to the Report Servers.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Defined data sources and their associated connections in COGNOS Connection.
• Set up the Security at the package level, query subject level and the query item level.
• Upgraded Dev, QA and Prod environment from Cognos 10.1.1 to Cognos 10.2.1
• Installed and Administered Cognos products (10.2) in both gateways and dispatchers in distributed environment (Dev and QA).
• Involved in installation of Framework Manager Configurations to point to Dev and Production servers.
• Installed, Configured in Cognos BI 10.2.1.1.
• Installed & Configured Cognos Analytics (Cognos 11.0.3.0) in a sandbox environment for compatibility testing.
• Setup a UAT Cognos Analytics (Cognos 11.0.3.0) for testing by end users by Migrating all the content formCognos BI 10.2.1.1.
• Involved in load balancing of gateways and performance tuning setting in Cognos portal.
• Involved in Customer UAT in Dev, QA and Prod environment.
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level.
• Managed scheduling of reports, public and my folders and distribution lists, users, groups and roles using COGNOS Connection in COGNOS 10.2.1
• Developed an SDk script to stop and start the query Service based on the Report load
• Developed complex List Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Involved in converting existing Dashboard Reports in to Active Reports.
• Used Various MDX Functions like Set, tuple, members, closing Period, parallel Period, union, caption, filter, format, descendants, ancestor in Report Studio using Multi-Dimensional Sources to develop complex reports.
• Well-versed with most of the MDX functions
• Good Experience with MDX Functions in Report Studio using Multi-Dimensional Sources.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Customized Reports by writing complex custom SQL.
• Deliver Advanced/ Complex reporting solutions such as Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos 10.2.1
• Customized Reports using HTML and JAVA SCRIPTS.
• Created Transformer models for Multidimensional analysis.
• Addressing the Performance and other Production issues with the Cognos 10.2.1 reports.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: Cognos 10.2 .1Suite,Cognos 11.0.3.0 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio), Informix, DB2.

Confidential, Downers Grove, IL

Sr. Cognos Developer

Responsibilities:

• Gathered Business requirements and designed functional and technical requirements documentation.
• Set up the Security at the package level, query subject level and the query item level.
• Involved in load balancing of gateways and performance tuning setting in Cognos portal.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Defined data sources and their associated connections in COGNOS Connection.
• Created Packages in Framework Manager by importing metadata from different data sources.
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level.
• Managed scheduling of reports, public and my folders and distribution lists, users, groups and roles using COGNOS Connection in COGNOS 10.1
• Developed complex List Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Involved in converting existing Dashboard Reports in to Active Reports.
• Good Experience with MDX Functions in Report Studio using Multi-Dimensional Sources.
• Involved in developing score card Applications using Metric Manager and Metric Studio.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Customized Reports by writing complex custom SQL.
• Experienced with Third Party Security Sources, Secure Socket Layer (SSL) configuration within Cognos.
• Deliver Advanced/ Complex reporting solutions such as Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos 10.1
• Customized Reports using HTML and JAVA SCRIPTS.
• Developed and prepared new and enhance existing Cognos applications.
• Created Transformer models for Multidimensional analysis.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Addressing the Performance and other Production issues with the Cognos 10.1 reports.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: Cognos 10.1 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio), DB2, SQL Server2005/2008, Cognos Access Manger.

Confidential, Naperville, IL

Sr. Cognos Developer

Responsibilities:

• Gathered Business requirements and designed functional and technical requirements documentation.
• Developed database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Set up the Security at the package level, query subject level and the query item level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Designed and developed the Framework Manager models and published into the Cognos connection.
• Created Packages in Framework Manager by importing metadata from different data sources.
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level.
• Developed complex List Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Involved in converting existing Dashboard Reports in to Active Reports.
• Good Experience with MDX Functions in Report Studio using Multi-Dimensional Sources.
• Involved in developing score card Applications using Metric Manager and Metric Studio.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Customized Reports by writing complex custom SQL.
• Experienced with Third Party Security Sources, Secure Socket Layer (SSL) configuration within Cognos.
• Deliver Advanced/ Complex reporting solutions such as Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos 8.
• Developed and prepared new and enhance existing Cognos applications.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Addressing the Performance and other Production issues with the Cognos 8 reports.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Installation of Cognos 8 BI Tools and Framework Manager, setting Cognos configuration and integrating different components.

Environment: Cognos 8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio), DB2, SQL Server2005/2008, Cognos Access Manger.

Confidential

Sr. Cognos Developer

Responsibilities:

• Gathered Business requirements and designed functional and technical requirements documentation.
• Developed database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Set up the Security at the package level, query subject level and the query item level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Designed and developed the Framework Manager models and published into the Cognos connection.
• Created Packages in Framework Manager by importing metadata from different data sources.
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level.
• Developed complex List Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Involved in converting existing Dashboard Reports in to Active Reports.
• Developed Reports using Business Insight.
• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Involved in developing score card Applications using Metric Manager and Metric Studio.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Developed reports using Cognos JAVA SDK by java scripts at the back end.
• Customized Reports by writing complex custom SQL.
• Experienced with Third Party Security Sources, Secure Socket Layer (SSL) configuration within Cognos.
• Deliver Advanced/ Complex reporting solutions such as Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos 8.
• Developed and prepared new and enhance existing Cognos applications.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Addressing the Performance and other Production issues with the Cognos 8 reports.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Installation of Cognos 8 BI Tools and Framework Manager, setting Cognos configuration and integrating different components.

Environment: Cognos 10.1, 8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio), DB2, SQL Server2005/2000, Cognos Access Manger, Windows 2003 Server.

Confidential

Database/ Cognos Developer/Admin

Responsibilities:

• Involved in Installation and Administration of Cognos Series 7 Tools.
• Created Catalogs using Cognos Impromptu 7 to generate reports
• Created different types of reports like Drill through reports, Sub reports, and List reports using Cognos Impromptu
• Created users and changed their profile as per the requirement.
• Created standard filters, Calculations, Prompts and Conditions in Catalog.
• Enhanced existing reports and created new reports as per requirements.
• Queried data from different database tables as per the requirement
• Created DB links in database to generate Impromptu reports using two databases
• Developed complex reports in cross-tab having many sub-groups with sorting.
• Some reports have been converted to Tabular-SQL for better performance.
• Created database for production environment in Oracle.
• Created users, roles and privileges on the Oracle databases.
• Created user groups, roles, privilegesusing Business Objects Supervisor.
• Created and configured database for development and production environments in SQL Server.
• Created tables in SQL Server 6.5.
• Developed stored procedures and database triggers using PL/SQL.
• Database and log backups and restoration, backup strategies, scheduling the backups. Backing up System and User Databases and restoring them when necessary.
• Monitor & tune SQL scripts. Creating upgrade scripts for production Database and supporting it.
• Performance monitoring and tuning of SQL servers.
• Setting up the monitoring triggers on NT for SQL Server Databases.
• Designed and implemented databases across the organization, ensuring high level of data availability.
• Involved in evaluating and selecting all technology components such as software, hardware and networking capabilities for database management systems and applications.

Environment: PowerPlay, Power Play Transformer, PowerPlay for Excel, Upfront, Excel, Sybase, DB2, Oracle, TOAD, Windows NT, SQL Server 2000, Visual Basic 5.0/6.0, Developer 2000, SQL* Plus, PL/SQL, Oracle 7i, Windows XP and Windows NT 4.0