SUMMARY

• Having 6+ plus years of experience in Software Development involving Requirement Analysis, Design, Documentation, Development, and Production/ Maintenance of Business Applications.
• Having 6+ years of strong technical expertise and competence in handling Data Warehousing OLAP tools.
• Strong Experience in Complex Dashboard development & Developing Report Requirements.
• Expertise in configuring Cognos BI 8.x/10.x through Cognos Connection as Cognos Adminstrator against SQL and Oracle Content store.
• Develop Metadata Models in Framework manager in Cognos 8.x/10.x.
• Expertise in develop complex ad hoc and standard reports using Query Studio/Report Studio.
• Sound Skills in Report Studio in building complex reports using Master Detailed, Drill Through, Conditional Formatting and Custom Prompts using Java Scripts.
• Developed Cognos Reports in Cognos 10.1.1 - Active Reports, Business insight, New Features.
• Develop Dynamic Reports using MDX Functions in Report Studio.
• Developed Multi-Dimensional Models using Transformer 8.4.
• Designed & Developed Transformer Cubes/ Scheduling/Security/Views.
• Strong Experience in Data Validation using SQL Scripts, PL/SQL Stored Procedures/Functions.
• Migrated Cognos Reports from different versions.
• Sound noledge in Databases like Oracle, SQL Server 2008, Teradata and DB2.
• Integrated with Third Party security using LDAP, Access Manager and Active Directory.
• Strong Experience in interacting with Business Users in developing Requirements.
• Experienced with Multiple Relational Databases including Oracle, MS SQL Server, and DB2.
• Experience with Installation and Configuring Cognos Environment on Windows.
• Strong Knowledge on Data Mart Architecture, data modeling and dimension modeling using Star Schema and Snow-Flake Schema.
• Self-motivated and enjoy working in a technically challenging environment.
• Possess excellent communication and interpersonal skills.

TECHNICAL SKILLS

Reporting Tools: Cognos 8.x/10.x, Cognos Impromptu 7.4, Power Play7.4

Databases: Oracle 8i/9i/10g, MS SQL Server 2005/2008.

Oracle Tools: SQL*Plus, Toad, SQL*Loader.

Languages: SQL, PL/SQL Programming, Java.

Operating Systems: Windows 98/2000/2003/2008/ NT/XP/7.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. Cognos Developer/Admin

Responsibilities:

• Developed functional specifications and report prototypes based on the user requirements.
• Created Models, Packages in Framework Manager Based on the user Requirement.
• Developed and modified the Framework Manager models and Published into server.
• Scheduled Cognos Reports from Cognos Administration.
• Created personal folders, personalized pages and custom views on Cognos connection portal.
• Generated Externalized Queries IQD’s and created Cubes using Transformer 8.4.
• Scheduled Jobs and distributed among user groups through bursting.
• Migrated Reports/cubes from Cognos 8.4 to Cognos 10.1.
• Enhancing and creating IQD’s based on the user requirements.
• Worked with DBA’s to get the necessary Tables in to reporting environment.
• Developed complex crosstab, list and drill-through reports to meet the business requirements against Relational and dimensional models.
• Developed Dashboards based on the user group requirements.
• Customized data by adding prompts, filters, calculations, summaries and functions
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Developed complex reports using the joins and unions between the queries. Implemented the custom reporting specifications like, Tree Prompts, Dynamic Sorting, Header - Footer freeze, Row count selection, Hiding the Prompts on the report page when not used etc.
• Implemented the multi-level drill through reports which resulted in the 16 drill through reports for each report.
• Got trained in Cognos version 10.1 on Active reports, Business Insight advanced, charting engine and other new features in Cognos 10. Migrated few reports and packages from Cognos 8 into Cognos 10 and tested the performance on the new platform.
• Design & development of the reports using Cognos 10.1 Report Studio, Query Studio and Analysis Studio.
• Creation of Dash Board Reports and adding it to the portal page using HTML Items
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Modifying the existing reports based upon the change request by the user.
• Involved in deployment to UAT and Production.

Environment: Cognos 10.1/8.4 (Cognos Configuration, Cognos connection, Framework Manager, Transformer, Query studio, Report studio, Analysis Studio, Event Studio), SQL Server2005,Oracle, Windows 2003/2008.

Confidential, Itasca, IL

Sr. Consultant

Responsibilities:

• Involved in requirement analysis and documenting the user requirements.
• Design and developed the Framework Manager models and Published into server.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed Relational/DMR Framework Manager Models and Metric Models to define metadata packages.
• Develop complex drill-through and drill-down reports to provide users with summary and detail information used to drive decision -making.
• Developed complex reports and Dashboards using the Unions and Joins in Report Studio. Handled Dashboard development and deployment for dashboards of high complexity with multi-level collective views.
• Burst reports based on Nation, Area, District, Territory and Brick codes, using the Report Bursting option in Report studio.
• Developed Dash board reports with graphical charts and numerical data using the DMR modeling, which enables to drill down and drill up and helps analyzing the dash board data.
• Customized the queries and report pages in the report, so dat the report output fits into the MS Excel spread sheets. Helped the users with the Excel functions and capabilities to analyze and play with the data.
• Worked on SQL optimization to enhance the system performance.
• Developed the Standard report templates, report specification and design, detailed dashboard and report design from high-level specifications, including visual layouts, master-detail and drill-down/drill-through relationships.
• Applying security to reports and to control user views; developing burst reports
• Developed List, cross tab, drill through, master-detail, chart and complex dash board reports which involved Multiple Prompts, conditional formatting, Filters, multi - page, multi-query reports, which resulted in significant decrease of man-hour requirements while increasing the accuracy and amount of data presented
• Developed complex reports using the joins and unions between the queries. Implemented the custom reporting specifications like, Tree Prompts, Dynamic Sorting, Header - Footer freeze, Row count selection, Hiding the Prompts on the report page when not used etc.
• Customized Cognos Connection Developed Portal Tabs, Security and Portlets.
• Involved in deployment to UAT and Production.
• Troubleshoot Cognos Server Environment for the better performance.

Environment: Cognos 8.2/8.4 (Cognos Configuration, Cognos connection, Framework Manager, Query studio, Report studio, Analysis Studio), SQL Server, Oracle.

Confidential, San Diego, CA

Cognos Developer/Admin

Responsibilities:

• Created detail technical design document which specify the reports and tools along with the SQLs, the logics and method of delivery.
• Created a Framework Manager model and imported the required metadata, created a business view dat contains model query subjects and shortcuts.
• Involved in understanding the Business needs and Customer requirements by participating in the Design Phase, user requirement gathering.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Designed the Framework Manager Model with all the necessary joins, filters and calculations for reports.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Involved in effort estimation based on the complexity of the business and the report design.
• Understand the security model and implemented the Row-Level Security according to the requirements.
• Resolving the Performance issues of the Reports.
• Implemented security for Data access, Object level access and Package access.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Schedule management - Daily, Weekly, Monthly, and Quarterly and Yearly reports.
• Migration of Cognos code (reports/models/ frameworks) from 8.2 to 8.4.
• Testing reports using review checklists (SQL Scripts) for Quality Assurance before delivering to the end users.
• Installation and Configuration of the servers in Distributed environment (Web, Application and Data servers).
• Administering the Servers - Installation, configuration, roles, Privileges and Performance Tuning of the Servers.
• Understanding of Cognos BI security model and implement the security (Data Security, Object and Row level Security) according to the requirements.
• Managing Multiple Dispatchers, Content managers and Content Store in Multi-server environment.
• Responsible for back up Cognos 8 BI data and tune the Cognos 8 BI Environment.
• Tested reports for data validation and performance tuning.

Environment: Go Dashboards, Cognos 8.2/8.4 (Cognos Configuration, Cognos connection, Framework Manager, Query studio, Report studio, Analysis Studio), Oracle, SQL, PL SQL.

Confidential

Cognos Developer/Admin

Responsibilities:

• Analysis of the requirements for the creation of CRN reports.
• Involved in the design and development of CRN reports in Report Studio.
• Developing Standard Reports, List, Crosstab, Charts, Drill-through Reports, Master Detail Reports, using Report Studio and Query Studio.
• Created query prompts, calculations, conditions and filters in Report Studio.
• Developing prompt pages and conditional variables using Report Studio.
• Experience with conditional blocks and conditional layouts.
• Created the data sources in Cognos Connection.
• Upgraded the existing (Cognos ReportNet 1.1 MR2) Models and Packages to Cognos 8 BI environment.
• Converted the existing ReportNet 1.1 reports to Cognos 8 BI reports.
• Maintain Cognos software (Upgrade, apply patches etc).
• Involved in deployment of applications to production.
• Troubleshoot the errors during the upgrade process.
• Manage Cognos Portal and all content in the portal.
• Interacting with the Cognos support team and creating & following-up the cases in the cognos support site.

Environment: Cognos 8.0 (Cognos Configuration, Cognos connection, Framework Manager, Query studio, Report studio, Analysis Studio), SQL Server2003/2005, Windows XP.

Confidential 

Associate Software Engineer

Responsibilities:

• Involved in design phase, gathered requirements from users and developed report specifications including report documentation
• Extensive Interaction with users to develop catalogs and various reports.
• Involved in creation and modification of various catalogs and reports.
• Designed and developed Impromptu Catalogs by connecting to databases to get the required tables and built business views.
• Developing Multi-Dimensional Analysis and Business Reports using Cognos Power Play and Power Cubes using Cognos PowerPlay Transformer.
• Creation of multiple dimensions, alternate drill through and creating special categories in Transformer.
• Used drill down, slice and dice and change displays.
• Created Impromptu Reports (list, crosstab) including sub-reports & drill-through reports.
• Implemented filters, calculations and prompts in Impromptu reports.
• Created reports with multiple prompts.
• Generated reports and distributed among user groups through bursting.
• Used SQL query to test the result of the reports with the database.
• Provided production support after implementation

Environment: Cognos ReportNet 1.0, Cognos Impromptu7.2, PowerPlay Transformer 7.2, PowerPlay Enterprise Server,