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.
• Extensive experience on integration, migration, dimensional models, data marts and cubes to achieve optimum reporting capabilities for the management.
• Hands on experience in COGNOS 10.x/8.x Suite (Framework Manger, COGNOS Connection, Report Studio, Query Studio, Transformer, Business Insight, Advanced Business Insight, Analysis Studio and Event 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.x.
• 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 on Cognos 8.x/10.x.
• Excellent problem solving ability coupled with good communication skills to interact with end-users, customers, and team members.

TECHNICAL SKILLS

Reporting Tools: Cognos 8.x/10.x (Report Studio, Query Studio, Analysis Studio and Event Studio) Cognos 10.x (Business Insight and Advanced Business Insight) Cognos Report Net 1.1 (Framework Manager, Report Studio and Query Studio) Cognos EP Series 7.x (Power play Transformer, Power play Windows/Web, Impromptu, Upfront)

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

Cognos Developer /Administrator

Responsibilities:

• Worked with Business users to gather Business strategy and created a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed and managed Dimensionally Modeled Relational model (DMR) using Framework Manager.
• Defined the keys, Joins, cardinalities and global filters in Framework Manager.
• Used package level security and folder level security.
• Developed Burst reports, Drill through, Master Detail, List, Chart, cross tab and complex reports (which involves Joins, Unions, Prompts, Report Library, Table of Content, Report Layout, template, Dashboards etc) in Report Studio based on the business requirements involved Multiple Prompts in Report Studio
• Developed Query studio Packages for Ad-Hoc reporting.
• Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger
• Created Technical Specification documents for QA team to understand more about reports which was helpful for their testing.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports mainly through Analysis Studio, Query Studio, and Business Insight.
• Coordinated with offshore team for Migrations.
• Scheduled the reports in Cognos connection and distributed them via mail.
• Used Event Studio to trigger the jobs.
• Developed Structural and Transactional IQD’s from Framework Manager and used it for Transformer.
• Use the advance functionality of Analysis Studio such as drill up and drill down, rank, slicers etc.
• Created Transformer Cube in UNIX environment by running script.
• Provided security in Transformer Cube by using Custom Views .
• Interacted with QA team for Unit Testing, System Testing and Performance Testing.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

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

Confidential, NJ

Cognos Developer

Responsibilities:

• Interacted with business analyst and end user to gather business requirements.
• Involved in designing functional documentation.
• Created Technical design document for Report studio reports based on Functional specifications.
• Performing Report Rationalization during requirement gathering.
• Worked in Framework Manager to develop (business logic by creating prompts, folders, calculated columns, joins and naming convention) and deployed packages to the Cognos Connection.
• Used Dimensional modeling (DMR) and Relational modeling techniques technique to develop FM models.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed detailed and summary reports using Cognos Report Studio.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in Report Studio.
• Created Dashboards (Combination of list reports, cross-tab reports, chart reports and Drill through) using underlying multiple query structure by using filters, calculations, complex expressions, conditional formatting.
• Involved in setting up Hierarchies, performing Drill Up and Drill Down reports and Slice & Dice operations and creating Cross Tab Reports.
• Developed reports using different Joins, Unions, complex display logics using different variables and customized the reports by applying filters, calculations, conditions, prompts (text box, tree, value, date) and Cascading Prompts in Report Studio.
• Created Ad-hoc Reports using Query Studio.
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports.
• Created various IQD in Framework Manager and from this IQD’s as source, integrated to Power Play Transformer to create various models and build cubes.
• Design and creation of Multi-Dimensional Cubes using Transformer, so that all key performance indicators can be analyzed.
• Publishing the Cubes to Cognos Connection to be used for multidimensional analysis.
• Developing Analysis Studio views of analysis from dimensional modeled packages and made the reports using them in Analysis studio.
• Assisted QA Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas.
• Preparation of Cognos Training Presentation for end users

Environment: Cognos 10.1 (Query Studio, Report Studio, Framework Manager, Analysis Studio) Power play Transformer, SQL Server 2005, Windows Server.

Confidential, MA

Cognos Report Developer

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 feeds data 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, Power play and Transformer), SQL Server, IIS 6.0, Windows 2003 Server., TOAD

Confidential, LA

Cognos Report Developer

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

Cognos Developer

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

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 Report Net 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

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.