SUMMARY

• 8 years of total IT industry experience as Cognos Professional in analysis, design, testing, development and implementation of client/server applications
• Good experience in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 7/ 8/10 and Cognos Report Net
• Good understanding with Cognos architecture.
• Sound skills in Cognos 10 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio, Transformer)
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio
• Having experience on dashboard reports building using report studio.
• Developed database schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in DMR model designing using Framework manager.
• Very good experience in Report building using Report Studio and Analysis Studio
• Work Experience in Transformer model design and Power play cube building
• Experience in Installation and configuring the Cognos 10/8 and CRN environment and implementing third security tools Tivoli directory Server and Sun One with Single Sign on
• Familiar with Cognos EP software where you can develop budgets and forecasts
• Experience in OLTP/OLAP system study, analysis, E - R modeling and developing database schemas like star schema and snowflake schema.
• Basic knowledge of BIA (Business Insight Advanced).
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
• Having knowledge on ETL tools like Informatica, Data Stage.
• Good experience in Oracle SQL and PL/SQL
• Worked with senior academic and administrative officers in support of financial management.
• Having experience with TM1 for analytical and reporting applications.
• Experience in interacting with end users to gather requirements for reporting.
• Developed Cognos Planning solution enables a flexible and transparent process of forecast, while integrating with the in-place IBM Power Play solution.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.

TECHNICAL SKILLS

Reporting Tools: Cognos 10.2/10.1/8.2/8.3/8.4/8.1 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio) Cognos EP Series 7.3, Business Objects 5.1, Cognos Impromptu 7.3, Power Play 7.3, IWR, Visual Studio.

ETL: Informatica, Data Manager, Datastage, Erwin

Databases: Oracle 8i/9i/10g, SQL Server 2000/5.0, DB2, Teradata, IBM Neteeza

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX, and Linux

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

Languages: C, C++, C#, SQL, T-SQL, PL/SQL, Shell Scripting, asp.net

PROFESSIONAL EXPERIENCE

Senior Cognos Developer

Confidential, RI

Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• In depth interaction with Client Architects, Project Manager, Subject Matter Experts, and Developers for solution implementation
• Responsible for the architectural design and detailed design of reporting and obtaining sign off from the business.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Design and Developed the Framework Manager models using stored procedures, Relational tables and published in to server.
• Created cubes in Transformer using Framework Manager packages and report studio reports as a source.
• Upgraded reports from Cognos 8.4 to 10 Version.
• Designed adhoc reports using tableau with various data sources.
• Created tableau dashboards with various combinations of charts, reports using filters, parameters.
• Worked extensively on tableau to produce complex reports to support Cognos reporting.
• Managed tableau admin activities, installations and support.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models
• Used Informatica 8.x (Source Analyzer and Warehouse Designer) to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Developed various Mappings and Workflows in Informatica as required by the Design specifications.
• Customizing Cognos Connection Portal based on user specifications.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements.
• Developing the Dashboard reports using Cognos Report Studio and Metric Studio.
• Worked with Stored Procedure Query Subjects in FM and Reports.
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Developed Dash Board reports in Report Studio using MDX Functions.
• Created Oracle PL/SQL Stored Procedures, Functions, and Cursors for use by Framework Manager Packages and Report Studio reports.
• Worked with Analysis Studio to develop multi-dimensional reporting
• Java Script for complex validation, navigation, communication and format customization.
• Performance tuning the by analyzing and comparing the turnaround times between SQL, tableau and Cognos.
• Trained users on tableau to create adhoc reports using excel files, flat files.
• Also trained users using analysis studio.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.

Environment: Cognos 10/ 8.4 (Framework Manager, Cognos Connection, Report Studio, Analysis Studio), Tableau, Oracle 11g, Toad, Qlik view, Micro Strategy

Senior Cognos Developer

Confidential, Forth Worth, TX

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Involved in Designing models with Relational Data using Framework Manager and published packages to the Cognos Reporting Servers.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed efficient Stored Procedures to support SSIS Packages and Business Intelligence Reporting.
• Improved the performance of long running views and stored procedures.
• Developed List, cross tab, drill through, master-detail, chart and complex reports, which involved Multiple Prompts in Report Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Developed Pharma Dash board reports to display all the information related to environment using Summary reports.
• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Extracted data from databases using ETL tools like data manager and data stage.
• Created optional filters/prompts in report studio using Java Script and HTML.
• Worked on Analysis Studio to develop multi dimensional reporting.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Environment: Cognos 10.2.1 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio), JavaScript and HTML, SQL Server 2008, Windows 2008, SQL, PL/SQL.

Cognos Developer

Confidential, PA

Responsibilities:

• Designed meta model in Framework Manager by creating database layer and business layer, defining appropriate relationship between query subjects in Framework Manager and then deployed packages into Cognos connection portal.
• Developed List, Crosstab, Drill through, Master-detail, Tabular, Chart and Dashboard reports which involved multiple prompts like Cascading, Date and Value.
• Executed Unit test, Dry run and formal execution test cases for each report.
• Developed reports that allow user to select a particular report to execute using render variable
• Setup Data Level, Package Level and Folder Level Security in Framework manager.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Developed Active reports to the end users.
• Created Filters, Prompts, Calculations both at package level and report level.
• Conditional Variable to display different colors and for text according to format
• Unit testing of each report and working with testing team to get user sign off.
• Deployment of Packages & Reports between Development and Production Environment using Cognos Administrative Tools.
• Created Unions and Joins for combining different tables in Query Subjects.
• Created jobs to schedule reports using schedule management in cogon’s connection.
• Experience in writing HTML/Java script in cogon’s report studio reports.
• Attending weekly status Calls and updating the status of the project to the Client. Presenting project’s Monthly Deck to Client Service Manager.

Environment: Cognos 10.2/10.1 BI (Report Studio), Oracle 11i, Microsoft Access DB, Windows XP Professional. Integration Services (SSIS) 2008, SQL Server Reporting Services (SSRS) 2008, MS SQL SERVER 2008

Cognos Developer

Confidential, Portland, OR

Responsibilities:

• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Extensive interaction with Business Users and gather information and requirements.
• Migrated Reportnet Models and reports to Cognos 8.2.1 environment.
• Managing User IDs and User groups like providing privileges to the users and User Groups in Access Manager.
• Designed and Developed projects, packages, Reports using Framework Manager, Query Studio and Report Studio.
• Modifying relationship between different databases tables and building models using Framework Manager.
• Implemented Data Security, Object Security, Package Security and created user classes as per the requirements.
• Analyzing the existing reports and preparing checklists starting from generating new reports in Report Studio, creating all the query items that match the expressions with the previous reports.
• Created Dynamic Dashboards to evaluate the business performance based on various KPIs.
• Developed Templates, Master Detail Reports, Chart Reports and Multilingual Reports using Report Studio and Query Studio.
• Design, Develop and test new queries with end users.

Environment: Cognos 8 Suite (v8.3), Windows XP., Informatica v9.1, Oracle 10g, Windows 2003 Server, Unix Shell scripting, SQLServer2005, Shell scripting, UNIX, Tomcat/Apache, Cognos SDK.

Cognos Reports Developer

Confidential

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: Cognos ReportNet (Report Studio, Query Studio), ReportNet SDK, SQL, Oracle 9i, Solaris 9, IBM DB2, Informatica, Windows 2000/NT

Cognos Developer

Confidential

Responsibilities:

• Developed Cognos Framework models to support advanced reporting
• Authored various types of reports in Report Studio using relational data sources.
• Created Transformer cube for Sales analysis
• Created MDX reports using Cognos cube as source
• Created adhoc reports using query studio.
• Analyses different cubes using analysis studio.
• Implemented report bursting to distribute reports effectively.
• Developed Active reports
• Support and maintenance of existing Cognos reports, cubes, report schedules
• Set up users and set report and folder level security
• Worked on performance tuning of the existing models and reports
• Trained users on creating Cognos Report Studio and Analysis Studio reports
• Active Report user interfaces required for connecting a Radio Button Group to a Data Deck.

Environment: Cognos 8.4, MS SQL Server