SUMMARY

• 8+years of experience in analysis, design, development and implementation of Business Intelligence (BI) projects using Cognos Products Suite.
• Developed strategic approach on requirements gathering, understanding of various organizations’ business processes, and translate the requirements into design specifications by working with various levels of business users.
• Expertisein COGNOS 8/10 (Framework Manger, COGNOS Connection, Report Studio, Query Studio and Analysis Studio), Cognosseries 7.
• Extensively worked on developing Metadata Models using Cognos Framework Manager Tools using industry best modeling standards.
• Developed standards for Cognos Framework Manager Model and Reports.
• Design and development of Cognos Power play Cubes using Cognos Power Play Transformer.
• Proficient in implementing DMR (Dimensional Modeled Relational) data using Cognos Framework Manager Model Tool.
• Extensively worked on developing complex reports using Cognos Report Studio, and developing reports from Cubes using Analysis Studio.
• Worked with business users on assisting Query Studio reports and graphs.
• Develops and implements application architecture, security plans and processes.
• Having Knowledge on Cognos TM1 products like Cognos TM1 architect, TM1 Perspectives,TM1 Tubo Integrator.
• Implemented features in Reports like Filters, Customized Prompts, Conditional Formatting, Spark line Charts and Complex Layouts like Cross tabs..
• Expertise in developing Drill - Through, Master-Detailed reports and implemented Bursting.
• Experience with Complete Lifecycle implementations of ETL Processes.
• Demonstrating knowledge in (OLAP) Data Warehouse, Data Mart Concepts and Methodologies.
• Expertise in transforming Star Schema models into building Cognos Metadata Model (database layer, dimension layer and business layer) using Cognos Framework Manager
• Worked with Oracle8i/9i/10g, SQL Server 2005/08, and Informix,DB2.
• Strong experience in SQL and PL/SQL (Procedures, Functions, Packages and Database Triggers).
• Experience in performance tuning of the reports.
• Comprehensive involvement in all phases of application lifecycle development be it analysis, development, testing, debugging, performance tuning and User Acceptance Testing (UAT) with QA team.
• Experience in software testing including software testing best practices, software test automation management; test management, test planning, execution and reporting.
• Excellent track record demonstrating strong analytical and problem solving skills.
• Excellent interpersonal skills to work with various teams within a project.

TECHNICAL SKILLS

Reporting Tools: Cognos 8/10 - Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Business Insight, Dashboards, Cognos ReportNet1.1,Cognos Impromptu, CognosTM1.

Modeling Tools: Cognos8/10 Framework Manager, PowerPlay Transformer.

ETL Tools: Cognos Data Manager, Informatica.

Markup Languages: HTML, JavaScript,Unix Shell Scripting.

Programming Languages: SQL,PL/SQL, Java, C,C++.

Operating Systems: Windows 98, NT, 2000, XP, 2003 Server, 2008 Server, Sun Solaris.

Databases: Oracle, Microsoft SQL Server,Informix,DB2.

Modeling Tools: Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

COGNOS Developer

Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Used Framework Manager to build models, packages and publish packages to Cognos Connection.
• Built models containing query subjects, query items, and namespaces from imported metadata.
• Ensuring clear query paths by resolving ambiguous relationships.
• Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, Master-detail & conditional formatting reports using Report Studio andQuery Studio.
• Created Multidimensional models in Cognos transformer using Framework Manager Packages.
• Created Dashboard reports, drill through reports, and drill up/down reports using cubes as a data source in Cognos report studio.
• Created Models based on the dimensions, levels and measures required for the analysis studio-using Transformer.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Standardized prompt pages for consistent user experience and to let users choose between different filters.
• Tested and validated the Report output against database to measure performance of reports.
• Created Unit Test Plan documents and Tested result documents.
• Used Service Manager to close the tickets that were opened by the users and other teams.
• Prepared documentation to train end users regarding the functionality of Query studio and Analysis studio.

Environment: COGNOS 10.1.1 (Report Studio, Query Studio, Analysis Studio, Business Insight), Framework Manager, Power play Transformer, MS SQL Server 2008,Windows Server 2003, 2008.

Confidential, Waukegan, IL

COGNOS Developer

Responsibilities:

• Participated in business and project functional requirements analysis, database analysis, systems architecture and design.
• Analyzed business and user needs and designed Business Intelligence solution that supports business and operations with attention to business value and strategic BI direction.
• Installed and configured Cognos 8.4.1 BI suite on windows servers. Participated in the migration to Cognos 10 project.
• Developed Framework Manager Models for different reporting projects within the organization to satisfy the needs of different departments and various project sites and publishingpackages to the Cognos Connection.
• Followed 3-Layer FM modeling approach by creatingData Layer, Development Layer and Presentation Layer.
• Created models, packages using Framework Manager and published the packages to Cognos connection.
• Created Drill through reports and Master Detail Relationshipsfor reporting in Report Studio.
• Extensively used cascading prompts, drill-through, conditional formatting, advanced grouping and sorting features to generate reports.
• Developed Dashboard Report to show various decision making key figures in multiple views.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Dispatched weekly departmental reports using report bursting to concerned department managers of all hotels about monthly Pride reports.
• Involved in QA and Post-Production support.
• Created Unit Test Plan documents and Tested result documents.
• Customized Cognos 8 Portal using Cognos System files, port lets as well as Cascading Style Sheets
• Responsible in the setup of Cognos 8 Security. Setup of User Groups, Roles, etc.
• Prepared documentation to train end users regarding the functionality of Query studio and Analysis studio.

Environment: COGNOS 8.4, 10 (Report Studio, Query Studio, Analysis Studio, Business Insight), Framework Manager, Power play Transformer, Oracle 10G, Windows XP/Server 2003, 2008.

Confidential, Oakbrook, IL

COGNOS Developer

Responsibilities:

• Created Reports using Report Studio and created adhoc queries using Query Studio.
• Created List, crosstab and drill through reports for departments like Reservations, Analytics and members/subscribers in Report Studio.
• Used Framework Manager in modeling the metadata to provide a business view for report authors and query users.
• Created models, packages using Framework Manager and published the packages to Cognos connection.
• Added business rules, such as filters and calculations that define the information that users can retrieve.
• Defined the relationships between the fact and dimension tables.
• Created Query Subjects to optimize and customize the data and organized the metadata into Business View using folders, namespaces and shortcuts.
• Implemented object and data level security by creating various filters and Prompt Pages.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Good in creating Query Prompts, Calculations, Conditions, Filters, Bursting Reportsusing Report Studio.Used HTML item to create reports.
• Created Active Reports for Hyatt Reservation system in retrieving the region specific data.Scheduled reports in Cognos Connection (Web Portal), Organized the folders for user convenience
• Created Private and Public Folders and Custom Views in Cognos Connection.
• Worked with ETL team in developing Cognos Data MnagerJobs, creating datamarts,building and refreshing processes for numerous projects by extracting data from different sources and loading into data warehouse(ETL).Testing and improving Report Performance upon report completion for validation of Calculations & data.
• Prepared documentation to train end users regarding the functionality of Query studio and Analysis studio.

Environment: COGNOS 8.4, 10.1 (Report Studio, Query Studio, Analysis Studio, Business Insight), Framework Manager V10.2, Power play Transformer,Cognos Data Manager,DB2,Informix, Windows XP/Server 2003, 2008.

Confidential, Milwaukee WI

COGNOS Developer

Responsibilities:

• Analyzed Business System requirements and prepared the documentation for the Project Plan and the Scope of the Project.
• Upgraded Cognos BI environment from 8.2 to 8.3 to 8.4.
• Developed the Metadata layer by importing the required objects, organized the metadata as per the requirement in Folders and Namespaces in Framework Manager.
• Created DMR (Dimensionally Metadata modeling using Relational Database) Models (Drill up, drill down Levels like PowerPlay) in Cognos 8.3 Framework Manager for Analysis Studio.
• Implemented the Security at data and object level in Framework Manager. Worked on both relational as well as dimensional datasources.
• ProvidedCOGNOS access in COGNOS connection by assigning roles and maintaining security for auditing purposes.
• Developed Several Reports usingReport Studio, Query Studio and AnalysisStudio. Created alerts in EventStudio.
• Created complex reports in Report Studio such as list reports, crosstab reports.
• Created various reports using COGNOS functionalities like Sub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail.
• Created my folders options for users using external application and displayed report output data in external applications using SDK.
• Created reports in ReportStudio using Prompts, Filters, Calculations, Summaries, Functions and Conditionalformatting.
• Applied performance tuning by extensively working in query explorer, implementing static choices and working with Datawarehousing team in building indexes / SQLhints.
• Scheduled the reports in COGNOS Connection and distributed them via mail.
• Deployed Packages and reports from Developmentto QA and Production Environments.
• Responsible for creating test plan documents and documented the test results.
• Documentedself developed reports and Framework Manager (FM) Models as well as supported them.
• Co-facilitated client workshops and training, typically small to medium group of clients.

Environment: COGNOS 8.3- 8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio COGNOS Connection, COGNOS Configuration),Oracle 10g, TOAD, Windows 2003/XP.

Confidential, CA

COGNOS Developer

Responsibilities:

• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Analyzed the specifications provided by the clients and developing specification documents for reports as per client requirements.
• Involved in designing models using Framework Manager.
• Modeled metadata from SQL Server data source for use in Report studio and QueryStudio using Framework Manager.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Design & development of the reports using CognosReport Studio, Analysis Studio reports.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts.
• Reports include, detail level and summary reports.
• Performance tuning by analyzing and comparing between SQL and Cognos.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Coordinating with Development Team tasks& Deliverables and working on high priority issues
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members
• Testing reports for Quality Assurance before delivering to the end users

Environment: Cognos8.2, Framework Manager, Report Studio, Query Studio, Analysis Studio), SQL server 2005, TOAD.

Confidential

COGNOS Developer

Responsibilities:

• Conducted User Workshops and documented their queries, business analysis and data warehousing needs.
• Migrated metadata from Impromptu using the migration utility and mapped it to the corresponding metadata of ReportNet.
• Worked jointly with the data management team members to understand data domains, values, cardinalities and other dimensions of data needed to support BI solutions.
• Created, Published and Managed packages.
• Planned and Created professional reports in Report Studio and ad hoc reports in Query Studio
• Scheduled andDistributed Reports through Schedule Management in COGNOS Connection
• Responsible for creating users, groups and roles to manage security
• Documenting and understanding the existing system designs and then building the PowerPlay Cubes.
• Executed scripts to refresh the cubes on a daily and weekly basis.
• Worked on performance tuning and optimization techniques such as load balancing, table weighing and partitioning.
• Scheduled reports to run on a monthly, weekly and daily basis using ReportNet.
• Administration of the Portal, Users, Groups, Security, etc and Knowledge of UNIX commands to be able to navigate directories, invoke shell scripts, move and copy files
• Utilized UNIX commands to support Basic functionality with files and to support the COGNOS configuration and environment
• Responsible for all COGNOS software upgrades and patch installation.
• Integrated ReportNet with third-party security providers like LDAP.
• Trained the end users to build and customize their ad-hoc reports.

Environment: ReportNet 1.1(Framework Manager, Report Studio, Query Studio,MS SQL Server 2005, Windows 2000, UNIX.