• Cognos Certified Professional with over 8+ years of total IT industry experience analysis, design, testing, development and implementation of client/server applications • Expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 6 / 7/ 8 and Cognos ReportNet • 5 years experience and expertise in Cognos suite (ReportNet 1.1, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, and Analysis Tools such as Cognos Transformer & Power Play 7.x/6.x Access Manager) • 3+ Years experience and expertise in Cognos 8 BI Suite (8.2/8.3/8.4) • Expertise in Cognos 8 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio ,Metric Studio,Event Studio and Query Studio) • Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio • Expertise in Relational and Dimensional ( DMR )Modeling • Expertise in Report building using Report Studio and Analysis Studio • Expertise in creating Dash board reports and using Java Script in Report studio • Experience in Transformer model design and Power play cube building • Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment. • Experience in databases such as Oracle 8i/9i/10g,SQL SERVER 2000/2005 , Nateeza,DB2 and Teradata. • Experience in writing SQL,T-Sql,PL/SQL Packages, Stored procedures, Functions, Triggers, Cursors as per the business needs. • Worked with Access Manager and Server Installation & Maintenance. • Installed and Configured Cognos 8 in single server Environment. • Experience in interacting with end users to gather requirements for reporting. • Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.
Report Analysis Forecasting Feb'09 to Till Date Deutsche Bank, NY
Deutsche Bank is a leading global investment bank with a strong and profitable private clients franchise. Its businesses are mutually reinforcing. A leader in Germany and Europe, the bank is powerful and growing in North America, Asia and key emerging markets. Currently working with Cognos 8 BI on the Corporate and Investment Bank group. CIB is subdivided into two Corporate Divisions: Corporate Banking & Securities and Global Transaction Banking. Corporate Banking & Securities covers Deutsche Bank's origination, sales and trading of capital market products, corporate advisory and corporate financing businesses, asset finance and leasing, and commercial real estate. Global Transaction Banking covers Deutsche Bank's trade finance, cash management and trust & securities services businesses and serves both financial institutions and corporate clients.
Environment:Cognos8.4/8.3,CognosEPseries7.3(Impromptuadministration,Transformer,Powerplay Windows/web and upfront),Cognos Access Manager,MS Excell,Access,Oracle 10g,SQLServer 2000,Informatica 8.x
Responsibilities • Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements • Installed & configured the Cognos 8.4 BI Environment, Administering the Servers, Troubleshooting, and Performance Tuning. • 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 IQD's, packages and reportstudio reports as a source • Migrated reports from Cognos EP Series 7 to Cognos 8 Environment. • Upgraded reports from 8.3 to 8.4 . • 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, 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 turn around times between SQL and Cognos. • Resolved issues resulting from User Acceptance Testing (UAT). • Performed Data validations, Unit testing and preparation of Unit test cases.
Sales Goal Reporting Mar'08 to Jan'09 Marriott International Inc, Bathesda,MD
Marriott International, Inc. is a leading lodging company. Its heritage can be traced to a root beer stand opened in Washington, D.C., in 1927 by J. Willard and Alice S. Marriott. Today, Marriott International has more than 3000 lodging properties located in the United States and 67 other countries and territories. The aim of this project is to develop consolidated reports to their business by using CognosBI as a reporting tool.
Environment: Cognos 8.2 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio,Powerplay Transformer),Nateeza, Oracle 10g, Cognos Access Manger, Windows 2003 Server. Responsibilities: • Involved in Requirement gathering from Business Users. • Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements. • Design and Developed the Framework Manager models and Published into server. • Created DMR package in Framework Manager for use by Analysis Studio Users. • Created packages in Framework Manager to publish cubes to Analysis Studio • Created cubes in Transformer using Framework Manager IQD's, packages and reportstudio reports as a source. • Design & development of the reports using Cognos 8 Report Studio, Analysis Studio reports • Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports • Performance tuning by analyzing and comparing the turn around times between SQL and Cognos. • Worked with Analysis Studio to develop multi dimensional reporting • Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP -- ROLAP) • Extensively worked with Stored Procedure Query Subjects in Framework Manager and Reports. • Involved in writing different stored procedures, triggers in PL/SQL as per functionality. • Experience in Migrating reports from Cognos EP Series 7 to Cognos 8 Environment. • Involved into move to Deployment to UAT and Production. • Interacting with the End users on a regular basis for resolving issues pertaining to the reports • Co-facilitate client workshops and training, typically small to medium group of clients. • coordinating with Development Team tasks& Deliverables and working on high priority issues • Testing reports using review checklists for Quality Assurance before delivering to the end users.
Assurant Health, Milwaukee, WI June'07 to Feb'08
Assurant, a Fortune 500 company and a member of the S&P 500. Assurant has more than $25 billion in assets and $8 billion in annual revenue.Assurant Health is a leader in the individual medical health insurance market.Assurant Health is a premier provider of specialized insurance products and related services in North America and selected international markets. The main aim of the project is to find various Premiums, Claim paid to the policyholder, Commission paid to the agents and premium received from the policyholder. We can track the premium by channels, Marketing type and location.. Scope of the project was to conduct user requirement analysis, design detail level and summary reports in Cognos 8 BI Suite , CRN 1.1 MR2 and Cognos EP Series 7 based on knowledge management components, data warehouse and operational data stores.
Environment: Cognos 8.2 BI Suite, Cognos FrameworkManager8.2, Cognos Impromptu 7.3, Cognos Power Play 7.3, Cognos Transformer 7.3,SQL Server 2005, Teradata, Windows 2003 Server
• Analyzed Business requirements from the analysts. • Involved in Desiging models using Framework Manager and deployed packages to the Report Net Servers • Implemented Framework manager security for Data access, Object level access and Package access. • Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager . • Modeled metadata from SQL Server 2005 data source for use in Report studio and Query Studio using Framework Manager in ReportNet • Creating the Teradata views as per the business and reporting requirement. • Importing the Teradata Views to the model and creating the relation between the views. • Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model. • Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities. • Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database. • Created custom templates and custom toolboxes for the use of reporting. • Customized Cognos Connection with appropriate reports and security measures • Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables. • Designed Power Play reports to provide summarized results by measures and dimensions. • Created custom prompted reports in Report Studio, Bursting reports to different user groups. • Moved projects from development to QA and then Production servers • Built Power Play Reports based on the cubes and published to Report Net Server. • Involved in the Testing of the reports and updating the Bug Tracking Tool • Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports • Transferred technical knowledge specific to Cognos tools and the existing data model to other team members
Galderma is unique in pharmaceutical industry, as it has chosen to focus in Dermatology. Galderma will contribute to the treatment of dermatological diseases and conditions by developing and marketing products to meet the needs of dermatologist and the patients. The Galderma learning management system provides a single system for administering, reporting and recording the training status of all employees. This project involves in developing suitable models, packages, OLAP Cubes and complex reports using Cognos BI products.The models will utilize actuarial practice and methodology for historical data analysis as well as forecasting
RESPONSIBILITIES: • Worked on Cognos8.1 framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server. • Creating relationships between query subjects to better represent the logical structure of the business and the user requirements. • Implemented Security with LDAP and Group level security in Cognos Connection Portal. • Creation of procedures, views, tables and functions according to business requirements in Oracle. • Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities. • Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio. • Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio. • Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs. • Extensively worked in Scheduling and Deploying (Staging to Production) Reports. • Worked on complex reports using Tabular Objects, Static Prompt conditions. • Involved in designing and building the Poweplay cubes using Transformer. • Built Power Play Reports based on these cubes and published to ReportNet Server. • Administering the business users in the portal based on the requirements.
Caterpillar Inc, Peoria, IL April'06 - Nov'06
A Fortune 100 company, Caterpillar is the world's leading manufacturer of construction and mining equipment, diesel and natural gas engines and industrial gas turbines. Project is for strategic reporting and Budgeting/forecasting which enables markets to carry out the necessary decision support work with minimum effort using Cognos Tools. Helps markets manage and improve the performance of their finished goods logistics.
Environment: Cognos ReportNet1.1 MR2 (Framework Manager, Query Studio, Report Studio) Power Play Enterprise Server 7.3, Transformer 7.3, Oracle 9i,DB2, Windows 2000
• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses needs (Folders, Filters, and Macros) • Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models. • Developed Complex Report Studio Reports using Bursting, Tabular Objects. • Created Drill- through reports and Customized Reports with Prompts (List. Cross tab). • Prepared User documentation to train users and functionality of each report. • Production Support which involves solving user problems. • Securing Cognos Connection and setup ReportNet security by assigning users to the groups and roles defined in Cognos Namespace. • Creating IQD files from Reportnet and designed Power play models in Transformer. • Involved in building the Cubes and optimizing the cube creation. • Publishing cubes and created Power play Reports for the web users. • Played as a good mentor to the newly joining team by giving knowledge transition in both technical and functional areas. • Developed Stored Procedures and Database Triggers in PL/SQL. • Designed extensive sample business Reports to cater the needs, which can meet their future demands on behavioral, trend analysis. • Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports. • Responsible for overseeing the Quality procedures and Software configuration management related to the project • Production Support, which involves solving user problems.
General Electric, Houston, TX Sep '05 -- Mar'06
The GE Business structures are divided into various divisions like GE Aero Energy Products, GE Air Quality Systems & Services, GE Aero derivative and Package Services, GE Distributed Power, GE Energy Products - Europe.GEPS-EDW is built on integrated legacy system. Data is received from many GE-based business data sources. This will allow GEPS Management to continue to analyze the organized data, which would enable both tactical and strategic decision-making.
Environment: Oracle 9i, Cognos Impromptu Admin/User, Power play Transformer, Power play for Web/Windows, PPES, Cognos Reportnet 1.1, PL/SQL, Windows 2000
RESPONSIBILITIES: • Created Framework Manger Models and created and published packages into the portal. • Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio. • Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications. • Created standard and Ad hoc reports using Cognos Impromptu Designed catalogs and defined User Classes, Security and Privileges. • Created Lists, Groups and Cross-tab reports with Drill-through functionality. • Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using Power Play and Transformer. • Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play reports. • Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models. • Created Impromptu Web Reports and published them on the web server and later on upfront. • Created News boxes in Upfront and customized the environment. Set Security for News Item and New boxes in Upfront. Set Privileges for user classes by defining News Index Admin
General Motors, MI Nov'03 -- Aug'05
GM is the world's largest car manufacturer based on annual sales and second largest based on quarterly sales. GM manufactures its cars and trucks in 33 countries. This project is designated to analyze automotive products are on sale which will help managers to know the effort put up by the down level officials.
Environment: Cognos ReportNet 1.0, Internet Information Services (IIS) 5.1, MS SQL Server2000,Oracle 8i, Windows 2000, Impromptu 6x/7x Transformer 6x/7x and Power play windows and Web, Informatica Powermart.
• Gathered & analyzed the end-user business requirements. • Giving estimation of efforts required • Imported metadata from multiple data sources to build a HR model and publishing packages in Framework Manager to the ReportNet server. • Worked with relationships (cardinality) between query subjects to better represent the logical structure of the business and the user requirements. • Created list reports, cross-tab reports and chart- reports using multiple queries in a single report. • Created various Report Studio reports using calculations, filters, prompts and conditional formatting, drill through. • Created PowerPlay cubes using Transformer (PowerPlay). • Data retrieval, Multidimensional analysis, PowerPlay structure • Created Multi-Dimensional reports using PowerPlay. • Created Cognos Impromptu Reports: • Developed Impromptu Web Reports (IWR) and published them into Upfront. • Created Impromptu Reports and published them to the PPES server. • Validated report results with the source data and authorized the reports to production environment. • Scheduled Reports and Jobs to run periodically. • Worked on securing Cognos Connection and setup ReportNet security by assigning users to the groups and roles defined in Cognos Namespace. • Created several drill through to several reports for providing better functionality. • Provided technical assistance, training and mentoring to Users and Business Partners.
Lanco Group, India May '01 -- Oct'03
Resource Management System is a web application for Lanco Group.This project is used to automate the Lanco Companies day-to-day activities and transactions. It is an Intranet based enterprise application, which automates the process of resource management and provides better services like stock management, and accounting. It links their activities like office maintenance and inventory control and provides access to all of their branches.
Environment: Oracle 7.3/8.1, PL/SQL, Cognos Transformer 6.x, Impromptu 6.x, Power Play 6.x, Cognos Upfront, Microsoft Access .
RESPONSIBILITIES: • Created catalogs with the help of Impromptu utilizing relational databases. • Developed impromptu reports with various functionalities (Drill -- through, Cascading prompts) . • Created templates utilizing Impromptu. • Created ad hoc reports utilizing Cognos Query. • Created user prompts, conditions and filters to improve report generation. • Created hierarchies to provide drill-down options for end-users. • Created Power Play cubes using Power Play Transformer to permit multi-dimensional cross sectioning and drill down analysis. • Enabled users to access the distributed HTML reports through local network folders, intranet and via e-mail. • Analysis of Design Documents. • Testing the Reports.