cognos developer
Resume:
Prasanth
**********@*****.***
Professional Summary
• Certified Cognos Consultant with over 7 years of experience in Designing and Development of Relational database applications, Data Warehouse, BI Applications on multiple domains like Financial, Banking, Manufacturing and Pharmaceutical industries.
• Extensive experience in BI Modeling/Report Authoring using Cognos 8 (Report Studio, Analysis Studio, Query Studio, Metric Studio, Cognos Connection, Framework Manager),Cognos ReportNet, Cognos Series 7 (Impromptu, Impromptu Web Reports, Metrics Manager), OLAP Cube development using Cognos PowerPlay and Transformer, and implementing security using Cognos Access Manager.
• Expertise in Business requirements gathering and designing Functional and Technical documentation.
• Strong experience on creating complex reports with Report Studio to customize the functionality by using Filters, Prompts, Master Detail Relational ships, Drill through definition and Conditional Formatting.
• Expertise in developing ad-hoc reports using Query Studio, creating complex analysis quickly by using Analysis Studio, analyzing metrics and other performance measures within an organization by using Metric Studio.
• Experience in designing interactive Dashboards with user friendly capabilities such as Prompts, Navigation and drill-down using Cognos Report Studio.
• Hands on experience on creating Physical Layer, Performance Layer, Presentation Layer while developing the models in Framework Manager.
• Extensive experience on Cognos Transformer for building Multidimensional Cubes.
• Experience with DMR Models, Cube data sources in Cognos Framework Manager and published to analyze Crosstab reports with Analysis Studio.
• Experience with importing metadata from various sources such as DB2, Oracle, MS SQL Server, and existing Cognos 8 Models files into Framework Manager.
• Performed interactive and batch operations and also involved in developing custom portal tabs.
• Excellent knowledge on Data Mart Architecture, Data Modeling and Dimension Modeling using Star Schema, Snow-Flake Schema and worked on both OLAP and OLTP databases.
• Extensive experience on Production Support and Troubleshoot/Test Issues with existing Reports and Cubes.
Technical Skills
BI Tools Cognos 8 BI Suite (Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Connection), Access Manager, Cognos ReportNet, Cognos Impromptu, Impromptu Web Reports
Data Modeling Cognos Framework Manager, Transformers, PowerPlay Erwin, Microsoft Visio.
Databases MS SQL Server 2008/2005/2003, Oracle 9i/8i, MS Access, DB2
Languages C, C++, SQL, PL/SQL, XML, HTML
Web Technologies IIS, Apache
Applications and Operating system MS Office Suite, MS Visio, Windows 2000/2003/XP/7, Windows NT 4.0, UNIX
Professional Experience
Sovereign Bank, Dorchester, MA Oct’09-Till date
Sr. Cognos Consultant
Sovereign bank is one of the largest banking institutions in the Northeastern U.S., is now subsidiary of Santander Group. Sovereign Bank offers a broad array of financial services including retail, business, corporate banking and insurance. The project is to use the transactional data for the development and marketing purposes. As a Sr. Cognos consultant, I have developed reports to keep track of performance of different credit cards offered by the bank.
Responsibilities
• Interacted with business users to gather business requirements and designed functional and technical documentation.
• Designed and developed the Framework Manager Models and Published into server for further use in the report authoring process.
• Built models containing namespaces, level hierarchies, query subjects, query items and members from scratch as well as from imported metadata.
• Created Stored Procedure query subject with a prompt value into the model while creating a package in Framework Manager.
• Developed Multidimensional Models (Cubes) using Cognos PowerPlay Transformer.
• Created stand-alone filters and embedded filters while creating a model by using Cognos Framework Manager.
• Designed & developed reports using Report Studio, created ad-hoc reports using Query Studio and helped business user in creating Analysis reports using Analysis Studio.
• Developed Simple List, Nested Cross tab, Chart, Drill through reports.
• Created complex reports with advanced features such as Master detailed sections, Conditional formatting, Page Set, bursting, Render & Boolean variables using Report Studio.
• Used Drill-up/down and Drill through functionalities to give a detailed and analytical report.
• Applied Cascading Prompts functionality in runtime for narrowing the final results for better understanding of the requirement.
• Created Dash Board Reports using Report Studio MDX functions and added to the portal page.
• Implemented Data level, Object level and Package level security in Framework manager to achieve highly complex security standards.
• Scheduled and distributed reports to the end users by schedule management in Cognos Connection.
• Generated SQL/MDX & analyzed Cognos SQL, Native SQL to troubleshoot the report issues.
Environment: Cognos 8.4 BI Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager, Transformer, PowerPlay, Windows XP, MS SQL Server 2008.
UPMC, Pittsburgh, PA June’08-Sep’09
Sr. Cognos Report Author
UPMC is an integrated global health enterprise and one of the leading non-profit health systems in the United States serving the health needs of more than 4 million people each year. The group of professionals in the IT department need to reserve the test sites for testing the prototypes and should be able to log the test results in a centralized location. The test results will be analyzed using the existing data in the legacy systems and reports will be generated by using the Cognos Report Studio.
Responsibilities
• Constantly interacted with the business users, attended several meetings in understanding the requirements better for development of application.
• Created standard Calculations, Filters, Data Source Query subjects, Model Query subjects in Framework Manager as per the Business Requirements, which minimize the report complexity.
• Generated OLAP Cubes in Cognos Transformer and analyzed the data using Cognos PowerPlay.
• Developed complex reports using Cognos Report Studio.
• Created Query calculations, Layout calculations, Filters and Prompts for usage in various reports.
• Generated multi object reports such as Lists, Crosstabs, Charts, Images and HTML applications using Report Studio and ad-hoc report using Query Studio.
• Extensively worked with different kind of prompts like Select and Search Prompt, Cascading Prompt, Date Prompt and Values Prompt.
• Created reports in Analysis Studio to verify the data is legitimate against the Drill through report in Report Studio.
• Created Templates, Dashboards, standard reports, and ad-hoc reports using Query Studio and Report Studio.
• Created complex reports which involved multiple Queries, Prompts, Filters reports against multiple databases.
• Created Master Detail Reports, Drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Developed Models in Framework Manager and created .iqd files to use them as source in Transformer’s while building Cubes.
• Provided solutions and implemented efficient ways to improve the performance of the reports.
• Created burst table & reports and made them available for appropriate users.
Environment: Cognos 8.2 BI Report Studio, Query Studio, Analysis Studio, Framework Manager, Transformer, PowerPlay, Windows XP, MS SQL Server 2005.
Marriott International, Bethesda, MD July’07-May’08
Cognos Consultant
Marriott International is a worldwide operator and franchisor of a broad portfolio of hotels and lodging facilities. The project Netezza designed to replace the existing MAQ’s (Marriott Automated Query) which were stored in Netezza Databases into Cognos Reports using Cognos 8 BI Suite.
Responsibilities
• Designed Metadata Models using Framework manager and published packages in to the Cognos Content Store.
• Analyzed existing Reports, created new and enhanced .cpf files for Framework Manager to accommodate future growth in reporting requirements.
• Created new Query Subjects and arranged in different folder structure for business view.
• Developed Multidimensional Models and Cubes using Cognos Transformer.
• Published packages and managed securities.
• Created Row level security for all Framework structures.
• Formulated Joins, resolved relationship & Cardinality in Framework Manager.
• Created predefined Filters in the Metadata Models.
• Generated Lists, Crosstabs, and Chart report by using Report Studio.
• Customized reports by applying Sections, converted a List report to a Crosstab report by using pivot function, and reused the objects within the same or another report to save the time.
• Developed complex reports having many Calculations, Variables, Prompts etc. in Report Studio.
• Involved in the performance tuning of SQL queries.
Environment: Cognos 8.2, Report Studio and Query Studio, Analysis Studio, Framework Manager, Netezza, Windows XP, SQL Server.
Caterpillar Inc., Peoria, IL May’06-June’07
Cognos Developer
Caterpillar is the world’s leading manufacturer of construction & mining equipment, diesel & natural gas engines and industrial gas turbines. The project NPI workflow enables the global availability of New Product Implementation management information from a variety of sources. It provides all the information necessary to track a program decision making. It provides the means for the data analysis and helps for the timely and proactive decision making.
Responsibilities
• Involved in gathering Business requirements from business analysts and users.
• Interacting with Development and Management teams, providing Technical Assistance to Developers.
• Used Framework Manager to build Metadata Model, which could be used by Report Developers to generate custom reports.
• Created, published and modified several packages in Framework Manager according to the business needs.
• Developed Standard Reports, Dashboard Reports, Charts, Drill through Reports, Master Detail Reports, Bursting Reports using Report Studio and Query Studio.
• Created Query Prompts, Calculations, Filters and Conditional Formatting.
• Scheduling and distributing reports through Schedule Management in Cognos Connection.
• Query optimization, Performance tuning of reports and model.
• Trained users on Query Studio for ad-hoc reporting.
• Involved in migration of Cognos code (Reports/Models/Frameworks) from one version to another using migtoc8 migration utility.
• Involved in implementing security authentication using LDAP and NTLM.
Environment: Cognos 8.1, Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos Connection, PowerPlay, Transformer, Access Manager, LDAP, NTLM, migtoc8, DB2, MS SQL Server, Windows XP.
Comerica Bank, Auburn Hills, MI July’05-Apr’06
BI Consultant
Comerica Incorporated is in a prime position to lead the financial services, strategically aligned into three major business segments: The Business Bank, The Retail Bank, and Wealth & Institutional Management. The project aims comparative financial reports need to be generated from Oracle and SQL server using Cognos ReportNet and Cognos PowerPlay. Fiscal year ending reports were generated and PowerPlay was used to compare the performance.
Responsibilities
• Actively involved in meetings with the user group and designed Business Requirement Documents (BRD).
• Involved in gathering Business Requirements for models directly from the users.
• Created, modified and published Framework Manager Models on ReportNet Server.
• Applied Multiple Filters, Prompts by using parameters, Calculations and Conditional formatting and created CRN Reports.
• Created various reports like List, Crosstab using Cognos ReportNet.
• Involved in deployment and maintenance of the Cubes, Packages and Reports in development, test and production environment.
• Created Models by using PowerPlay Transformer.
• Created DMR Models by using Dimensions, Hierarchies and Levels.
• Involved in scheduling and administering the Cognos ReportNet reports using Schedule management in Cognos Connections.
Environment: Cognos ReportNet 1.1 MR2 (Report Studio, Query Studio, Framework Manager, Cognos Connection), PowerPlay, Transformer, Windows XP, Oracle, SQL Server.
Matrix Laboratories Ltd, Hyderabad, India Oct’03-June’05
Report Analyst
Matrix Laboratories Ltd, a subsidiary of Mylan Inc. USA, is one of the world’s largest manufacturers and suppliers of Active Pharmaceutical Ingredients (APIs) for a wide range of therapeutic categories. As a Cognos consultant, worked with Clinical and IT team in CDMS (Clinical Data Management System). This project keeps track of the clinical trials conducted for the drugs to analyze the performance.
Responsibilities
• Created new Catalogs for reporting using Cognos Impromptu.
• Generated customized reports by using Filters, Prompts, Calculations and Functions.
• Created standard ad-hoc reports using Cognos Impromptu.
• Tested the Joins, inbuilt filters and calculations are working correctly and documented all of the work for submitting it to the users for verification.
• Distributed copies of data using Local snapshots, Remote snapshots, Thumbnails and Hot files to improve report performance.
• Created some complex reports using master-detail relationship terminology.
• Created and monitored multiple shared catalogs using Cognos Impromptu.
• Worked with system analyst to understand the flow of data, developed Framework Manager Models against Oracle Database.
Environment: Cognos Impromptu 6.1, Impromptu Web Reports 6.1, Cognos PowerPlay 6.1, Cognos Transformer 6.1, DB2, and Windows 2003.
Education & Certifications
BS in Computer Science, Kakatiya University, India
IBM Certified Cognos 8 BI Report Author
Contact this candidate