Professional Summary:

• 7+ years of extensive experience in IT industry as Cognos Developer which includes extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), OLAP, ETL tools, Product Development and Reports Generation.
• Extensive exposure to various business sectors such as Finance, Insurance, Pharmacy,Workforce Management and Healthcare.
• Hands on experience in COGNOS 8 (8.4/8.3/8.2/8.1) Suite (Framework Manger, COGNOS Connection, Report Studio, Query Studio, Transformer, Power Play Studio and Analysis Studio) with expertise in Metadata Modeling-Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.
• Extensively worked on Framework Manager in creating models and implementing 'best practices' while modifying relationships, resolving the loops in Relational data.
• Experience in developing and testing Complex reports (Multi-chart, Cross tab, Maps, Drill-through, Master-Detail, Multi-prompt and Bursting) using Report Studio.
• Thorough knowledge of creating Ad-Hoc Reports using Query Studio based on User requirements.
• Involved in Performance Tuning of Reports to reduce report execution time.
• Created reports from multiple data sources (Excel, SQL Server) to reflect the current business rules.
• Experience in migration of Cognos 7 reports to Cognos 8.
• Designed multi-dimensional cubes using Powerplay Transformer.
• Skills in developing SQL programming
• Excellent understanding of OLAP data processing methodology.
• Worked with Business Analyst and end users in understanding and preparing functional, technical specifications and designed documents.
• Experience in understanding and working with On-site Off-shore environment.
• Trained users and created user manuals onCognos 8.
• Excellent problem solving ability coupled with good communication skills to interact with end-users, customers, and team members.

Educational Qualification:

• Bachelor Degree in Engineering

Technical Skills:

Reporting Tools:Cognos 8.x,10.x- Report Studio, Query Studio, Analysis Studio, Event Studio. Web Servers:Internet Information Services(IIS)6.0/7.0 Modelling Tools/Methodology: Framework Manager, Transformer, Star schema, Snow-Flake Schema Database: MS-SQL Server 2000/2005, Oracle 7/8i/9i/10g/11g, DB2 UDB 8.x Operating System:

MS-DOS, Windows 2003/2008/XP, Windows7, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential, NJ Jan 2012-Till Date Cognos Developer /Administrator Responsibilities:

• Gathered the requirements from Business Analyst.
• Developed Framework Manager Models with Database Layer, User Layer and Reporting Layer to cater the various business needs.
• Modified Existing Framework Model.
• Created and modified various reports using report studio
• Created prompts, Calculations, Conditions, Filters using Report Studio.
• Created various types of reports like List and Crosstab etc.
• Used Query studio for Ad-Hoc reporting & Trained Users in using it extensively.
• Tested and validated all reports of the migration based projects.
• Performed Unit testing of the reports and the framework model.
• Expertise in writing technical specifications.
• Worked with off shore team for migration project.
• Scheduled Reports based on the request from users.
• Performed in unit testing of reports and models.
• Performed Admin task for creation of user's roles and groups in active directory.
• Created users using Active directory based on helpdesk request.
• Monitoring Cognos Server in order to avoid performance issues.
• Performed Admin task for user permissions, scheduling the reports.
• Worked as application support for Cognos.
• Handled multiple projects at time.

Environment: Cognos 8.4 ( Cognos Connection, Report Studio, Query Studio, Framework Manager, Power play and Transformer), SQL Server, IIS 6.0, Windows 2003 Server., TOAD

Confidential, NJ Dec2010-Dec2011 Cognos Report Developer Roles and Responsibilities:

• Involved in understanding existing Business Model and Customer Requirements by participating in the Design Team and user requirement gathering meetings.
• Worked on framework manager to create models by importing metadata from multiple data sources and published packages to Cognos Portal.
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Published Framework Manager Package, which feedsdata for .Iqd files which in turn was used in Powerplay Transformer to build multi-dimensional cubes.
• Migrate framework packages and reports between different environments(Development, QA and Production).
• Involved in creation of standardized testing procedures for report development.
• Built reports using multiple charts with drill-up and drill-down functionality.
• Incorporated Layout Component Reference in the new reports.
• Created Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page.
• Expertise in managing multiple projects and coordinating with off-shore team for on-time delivery of report modules.
• Maneuvered complex reporting structures with ease by designing reports with a combination of list, cross tab and charts.
• Tuned report studio reports for improved performance and less response time by taking advantage of options available within report studio.
• Implemented standards in Report design and appearance by following set of predefined rules while applying colors and fonts styles to the report structure.
• Built Complex Reports involving Prompts, calculations, Conditions & Filters.
• Highlighted agent performances using Conditional Formatting for the contest 'Best Agent of the Quarter'
• Worked on scheduling and saving the reports on Daily, Weekly & Monthly basis using Cognos Scheduler.
• Utilized the burst capability in Cognos to distribute the report to end users.
• Implemented Unit testing and Integration testing to ensure the designed reports met required business standards.
• Table of Contents and Bookmarks were used extensively for users to navigate through reports instantly.

Environment:Cognos 8.4 ( Cognos Connection, Report Studio, Query Studio, Framework Manager, Powerplay and Transformer), SQL Server, IIS 6.0, Windows 2003 Server., TOAD

Confidential, LA Dec2009 - Nov 2010 Cognos Report Developer Role and Responsibilities:

• Worked on framework manager to import metadata from multiple data sources and to create subject matter models and publish packages.
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Worked on creating list, cross-tab and chart reports using multiple queries in a single report and by using filters, calculations, conditional formatting and drill through options.
• Developed existing reports by implementing Prompts and Cascading Prompts for user to interact with reports.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Worked on summary reports and detail Reports to display information based on user requirements.
• Created drill through reports and associated with the reports having Master-Detail relationship.
• Validated report results with the source data before and after deployment to production environment.
• Worked on formulating reports scheduling strategy in Cognos Connection factored upon data refresh cycles and server contention.
• Worked on securing Cognos Connection and setup security by assigning users to the groups and roles defined in Cognos Namespace.
• Worked on creating power cubes with cube groups and applied security in viewing the cube in Cognos Connection using Analysis Studio.
• Configured Drill-Thru functionality from PowerPlay cubes into Report Studio Reports to view more detailed data.
• Monitored and optimized the performance of reports, and the server environment when required.
• Created reports in Report Studio that traverse to multi-dimensional report in Analysis Studio and Query Studio.
• Responsible for training the end-users in using Report Studio, Query Studio, Cognos Connection

Environment: Cognos 8.4 ( Cognos Connection, Report Studio, Query Studio, Framework Manager, Power play and Transformer), Oracle 9i, IIS 6.0, Windows 2003 Server., TOAD

Confidential, CA July2008 - Oct2009 Cognos Developer Role and Responsibilities:

• Gathered the requirements from Business Analyst. According to the requirements created Data Layer and Business Layer.
• Upgraded from Cognos 7 to Cognos 8.
• Created packages in framework manager and published to Cognos connection.
• Extensively involved in requirements gathering with the end client.
• Responsible in gathering User-Requirements from the End-Users and documenting end to end process.
• Worked on creation and maintenance of multiple Transformer Models.
• Fine-tuned the Cubes performance, checking the database space issue and cube growth periodically.
• Built multi-dimensional power cubes from PowerPlay Transformer Models by using multiple IQD files as a Data Source.
• Worked on creating Impromptu Query definitions by filtering and formatting the source data to feed as Data source in creating PowerPlay models and eventually power cubes.
• Monitored weekly refresh of various multi-dimensional cubes.
• Creating new User Groups and User Classes.
• Created and Scheduled Macros to refresh rebuild and publish PowerPlay Cubes.
• Involved in moving the Weekly Reports to Production.

Environment: Cognos 8.1(Cognos Connection, Framework Manager, Report Studio and Query Studio), Cognos7 (Power play 7.4 and Transformer) Oracle 8.i/9i, IIS 6.0, Windows 2003 Server, TOAD

Confidential, CA July 2006 - June 2008 Cognos Report Developer Responsibilities:

• Worked with the business team to conduct system study and analysis.
• Involved in design and development of user classes, filters, calculations, prompts and conditions in Catalog and query definition files in Impromptu Administrator.
• Connected and tested the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Reporter Operations such as Sum and Average.
• Exception Highlighting, Sorting, Ranking etc.
• Changing filters, layers and measures.
• Customized data by adding calculations, summaries and functions.
• Implemented security for Data access, Object level access and Package access.
• Developed List, crosstab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Built Power Play Reports based on these cubes and published to Report Net Server.
• Worked on Cognos Security Administration to restrict the users.
• Created User Classes and Users in Access manager and provided the user credentials.
• Created different types of reports like Forecast, Master Detail, Customer and Variance Reports.

Environment: Cognos ReportNet 1.1 ( Reports Studio, Query Studio, Cognos Connection and Framework Manager), Cognos 7.1 (Impromptu, Impromptu Administrator, Power play and Transformer), Oracle 8.i, IIS 6.0, Windows 2003 Server.

Confidential, CA Jan 2005 - June2006 Cognos Developer Responsibilities:

• Involved in gathering business requirements for new models Created catalogs and reports in Impromptu
• Involved in design and development of user classes, filters, calculations, prompts and conditions in Catalog and query definition files in Impromptu Administrator.
• Developed various kinds of prompts such as type in, pick list and cascading prompts
• Installed and configured Report Net on development server Used exceptional highlighting to avoid overlooking of critical figures.
• Performed tuning of power cubes to reduce query time by partitioning the cube Involved in scheduling; bursting and distributing reports by email Used Access Manager to administrator security for all the catalogs.
• Created and set security for news boxes and news items in Upfront Created catalogs from multiple databases with the help of Hot File (.ims) files.
• Created reports in different formats including .imr, .iwr, .iqd etc. utilizing catalogs.

Environment: Cognos 7.1 (Impromptu,Impromptu Administrator, Power Play, power Play Transformer, Cognos IWR and Access Manager) and Oracle 8i.