Cognos Developer
Resume:
Prashanth
Summary
About * years of IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in Financial, Banking, Manufacturing, Retail, Insurance Domain and Health care.
Depth understanding of a software development life cycle (SDLC) Requirement gathering & Analysis, System Design, Software Development,
IBM Cognos BI: Experience in IBM Cognos 10, IBM Cognos 8, Report Net 1.1, Report Studio, Query Studio, Analysis Studio, Impromptu, Transformer, Power play, IBM Cognos 8 (Framework Manager, Report studio, Query Studio, Analysis Studio and Cognos connection). Installed and configured IBM Cognos 8.2 BI (BI modeling, Report Studio, Query Studio and Analysis Studio). Cognos8.3 Report Net, Query Studio, Report Studio, Impromptu, Transformer, Power play, upfront, scheduled the Reports based on the database events using Triggers
Developed Complex Framework Manger Models & involved in Debugging FM Models
Expertise in Full life cycle system development: Requirement gathering, Administration, Designing, Development, Testing and deployment of Data Warehousing and Business Intelligence applications using COGNOS
Experience in Report Development, Modeling (Relational, DMR), Dash Board Report in Cognos 8.x and Cognos 10.1
Handling complete range of BI capabilities: reporting, analysis, score carding, dashboards and business event management and Tableau, Spotfire.
RDBMS: Database experience using Oracle 10g/9i/8.x, DB2, MS SQL Server, MS Access, Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and SQL Server, Relational database design concepts and in depth knowledge of OLAP solutions and DB2.
Data Modeling: Expertise in OLTP/OLAP/OOAD System Study, Analysis and ER modeling, Ralph Kimball’s Data Modeling developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
Provided best practices for day to day operations, performance analysis, tuning and capacity planning.
Involved in Designing Data Models Relational, Multi-Dimensional Models in order to building Data Marts and Consolidated reporting Environments.
Created requirement document and design documents for the projects.
Dash Board & Securities: Designed and developed dynamic dashboards to evaluate the Company’s performance.
Administered and Implemented Row Level Security, Object Level Security, Package Security, Folder Security and created user classes as per the requirement for both frame work packages and reports.
Architect the Cognos BI environment to support high concurrency.
Reporting: Experience in developing complex reports (List, Cross Tab, Chart, Singleton Repeater, Active Reports) using drill-through, prompts, master-detail, burst options, dynamic filtering in Cognos BI.
Developed reports using advance functionality of Analysis Studio such as drill up and drill down, rank, slicers.
Experience with Event Studio with creating alerts, executing tasks and distributing reports.
Experience in implementation of the Cognos Series 8 Business Intelligence Software and migration from Cognos Series 7 where applicable.
Experience with Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers.
Testing: Hands on experience in Unit Testing, System Testing, Functional Testing, User Acceptance testing, and Testing Documentation.
Created the Framework model which involved columnar modeling approach to ease report development and TY vs. LY analysis for Adhoc users
Analyzed and created application, dimensions, cubes using TM1 Architect and experience on transformer models for corporate data for building multidimensional cubes.
Experience in building Cognos Visualization from Scratch
Defined required Rules and chores for the cubes population.
Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
Proven experience at building, motivating and leading professional teams, managing projects and supporting client relationships.
Technical Skills:
Reporting Tools:
IBM Cognos 10.2.X, IBM Cognos10.1.1,Report Studio10.2.2, IBM Cognos Express, 8 Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Metric Manager, Framework Manager), Report Net 1.1 MR3/1.1 (Framework Manager, Report Studio, Query Studio), Cognos TM1 9.5.2, Cognos Data Integration (DI),Cognos Impromptu 7.x/6.x, SPSS,Impromptu Web Reports (IWR), PowerPlay Transformer 7.x/6.0, PowerPlay Enterprise Server,Rave
ETL Tools
Informatica, Data stage 7.5, Microsoft SSIS,SSAS,SSID 2008, Tera Data, JDE Systems
Databases
SQL server 2000/2005/2008 R2/2012, Oracle 11g/8i/9i, DB2 UDB
Presentation Tools
MS Excel/Word/PowerPoint/Access, VISIO
Programming
C, ASP SQL, PL/SQL, SQL*Plus, HTML, Java, Maximo, Kronos,VBA
Professional Experience
Client: Dell Inc., Plano, Texas Nov 2014 - Present
Role: Cognos BI Developer
Dell Inc. is a multinational computer technology company that develops, sells, repairs, and supports computers and related products and services. Business Intelligence uses technical knowledge and business acumen in Dell to deliver new commercial solutions and improve existing platforms in digital marketing, customer engagement, and database management.
Analyzed the end user requirements and gathered all those requirements.
Used Life cycle manager to compare and verify with earlier version after migration.
Worked on Cognos 10.2.2 framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 10 server and Published IQD’s which are used as Data sources in Cognos Transformer to build a cube.
Gathered requirement for Dashboard Reporting and modification of DWH as required by business dashboard and feeding them.
Expertise in deploying packages and reports to Production environment and handling production issues.
Enhanced the Framework Models and Transformer Model to suit the user requirements.
Validated the Data Loads in the Cube using Query Studio
Coded Stored procedures and PL/SQL scripts to load, update data tables.
Created SQL Queries for best Adhoc reports
Migrated reports from different environments from development to QA and then Production servers.
Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
Implemented Third Party Security with LDAP and created users and user roles.
Tested the security settings using authentication information of different classes of users.
Worked on performance tuning of the dispatchers to handle requests better and optimize the performance of the application.
Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio
Analyzed Cognos SQL Query and Native SQL Queries for better understanding of what data or parameters passed to the data base.
Responding to a change in the client\'s IT direction, promptly prepared for construction of the planning and forecasting tool, developed a global enterprise-wide application using Cognos TM1.
BI report development for Concur, launch of Revenue Planning Models, and development of an automated employee time monitoring process via VBA
Design, develop, and implement Cognos TM1 9.5.2 Applications for Financial planning and budgeting models with complex rules.
Created complex reports using Report studio with calculated columns and Formatting.
Created New Jobs using Cognos Connection and User Groups and assigned user privileges using Cognos Connection.
Testing and improving Report Performance.
Training Users on Query Studio for Ad-Hoc Reporting.
Analyzed the Functional requirement document with the Business Analyst to confirm the business logic involved in computing the KPI’s for the dashboard
Generated SQL queries and analyzed Cognos SQL, MS SQL/ VBA to troubleshoot report issues
Created a Technical document for the Dashboard, translating the business logic to technical details which included the design and specifications of the dashboard
Maintained Development and Production instances of Cognos 8.3 BI
Environment: Cognos 10.2 Suite (Cognos Connection, Framework Manger, Report Studio 10.2.2, Query Studio, Analysis Studio), Oracle 11g client, SQL server 2000/2005/2008 R2/2012,IIS 6.0,Active Directory, Windows2012, Cognos TM1, Cognos DI, Kronos, Cognos SDK,MS Excel / VBA,SSIS,SSAS,SSID
Client: SunGard, Houston, Texas Mar 2014- Oct 2014 Role: Cognos Developer
SunGard is a multinational company which provides software and services to education, financial services, and public sector organizations.
Gathering the requirements and prepare report design documents.
Planned an approach for documenting, categorizing and packaging the requirements.
Involved in Designing and creating various models and Publishing packages in Framework Manager.
Developed advanced reports using Report Studio 10.2.2.
Developed various report types ranging from simple lists, crosstab, chart, through complex dashboards, drill-through, Master-Detail and Conditional formatting reports.
Created Complex, multipage reports involving prompts, Cascading prompts, Conditional rendering and Conditional formatting.
Hands on experience in Unit Testing, System Testing, Functional Testing, User Acceptance testing, and Testing Documentation
Created custom prompted reports in Report Studio, Bursting reports to different user groups and Created Scorecards and Metrics using Metric studio, Metric Manager.
Experience in full life cycle project development; including design, coding, testing, implementation and product support.
Developed active reports using Cognos 10.1.1 in various environments.
Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making.
Created the Framework model which involved columnar modeling approach to ease report development and TY vs. LY analysis for Adhoc users
Performance tuning on power-cubes to reduce Query time and partitioned Cubes.
Tested and validated the report output against the database to measure performance of reports.
Involved in Installations of Go Office on User’s Desktop machines with the help of Desktop Services, and configuring it to Dev and Prod environments.
Developed Complex dashboard reports for various reporting requirements.
Built DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source.
Generated SQL queries and analyzed Cognos SQL, Native SQL to troubleshoot report issues
Identified various dimensions and measures required for the generation of a cube.
Implemented changes and thus improve performance for the existing cube using MDX functions. Extensively worked on Migrating reports from Cognos EP Series 7/CRN to Cognos 8.X Environment.
Performed Troubleshoot on various existing reports that had issues and fixed Remedy tickets from production system.
Implemented stored procedure query subject in Cognos Framework Manager.
Developed complex PL/SQL stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Administration.
Created reports, Complex and Cross Tab reports using Cognos Report Studio.
Deployed packages, folders and Content store from a development environment to test and then to QC and Production environments.
Uses Aggregate Join Indexes and Teradata load tools to speed cube creation and updates.
Extensively worked on Teradata modeling and ODBC configuration.
Created ETL Source to Target mapping document.
Extensively worked on Informatica Designer, Workflow Manager, Workflow Monitor Working on Source Analyzer, Warehouse designer, Mapping Designer.
Extracted data from different Sources like Oracle, DB2, Teradata and Flat Files.
Environment: Cognos 8.4/10.1 Suite (Cognos Connection, Framework Manger, Report Studio 10.2.2, Query Studio 10.2.2, Analysis Studio, SQL server 2000/2005/2008, Cognos Office Connection), Oracle, DB2, Windows 2008 Server,JDE Systems,Adhoc,Tableau, Spotfire,SSIS,SSID,SSAS
Client: Country Financial, Bloomington Sep 2013- Feb 2014
Role: Cognos BI Developer/Admin
Country Financial is the one of the largest property and casualty insurer in the United States with named Country Mutual Insurance for P&C insurances. Country Financial is a leading provider of crop insurance, personal and commercial property (P&C) and casualty insurance and long-term retirement savings products. The project was involved in developing Right, a web based system for quoting, and maintaining and issuing auto and homeowner insurance policies. Insurance billing modules like Account / Policy Billing, Third Party (Agency) Billing, List/Group Billing was used for billing system of P&C Insurance companies.
Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, Commercial).
Built DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source
BI report development for Concur, launch of Revenue Planning Models, and development of an automated employee time monitoring process via VBA
Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
Used SQL Server as the data sources.
Generated SQL queries and analyzed Cognos SQL, MS SQL / VBA to troubleshoot report issues
Deployed the reports for testing from Dev environment to QA, QA to UAT and other environments as Admin.
Developed Database and Business Views for Meta Data Models using Framework Manager by Importing Tables, Views, creating short Cuts and Aliases.
Analyzed and created application,dimensions,cubes using TM1 Architect
Created ETL (Extraction, Transformation & Loading) processes in TM1 performing business rule mappings of relational data into dimensional model.
Implemented security as Admin to various environments.
Hands on experience in Unit Testing, System Testing, Functional Testing, User Acceptance testing, and Testing Documentation
Developing Standard Reports, Charts, Drill Through Reports, Nested Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio.
Trained end users in Business Insight/Workspace & Business Insight/Workspace Advanced.
Created complex dashboards for the senior management to have a single view on the complete business.
Design and review the processing steps and create processes for new system.
Created Mock-up forms in MS word for better visualization and understanding of the software solution.
Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
Extensively worked on Informatica Designer, Workflow Manager, Workflow Monitor Working on Source Analyzer, Warehouse designer, Mapping Designer
Worked as a Cognos Modeler, developed Cognos package using Framework Manager and Transformer.
Provide inputs to the management for creation of status reports, tasks tracker and management dashboards.
Environment: Cognos Framework Manager, Cognos Connection, Report Studio 10.2.2, Query Studio 10.2.2, Power play Transformer, Cognos Data Integration (DI),Content Manger, TM1(Architect, Perspective Turbo Integrator and web),SQL Server 2000/2005,SSAS,Informatica,MS Excel/ VBA,SSIS,SSID,SSAS,DMR
Client: Sutter Health, Sacramento, CA Oct 2012- Aug 2013
Role: Cognos BI Consultant
Sutter Health is the most recognized and respected group of health insurance provider in the world. It is a trade association for the independent locally operated Sutter health Plans, Insurance focus on offering the best mix of insurance coverage and pricing, and fulfilling the promise of our products when a loss occurs to most of their consumers – auto, homeowners and small-business policies. Involved in creation and maintenance of databases, migration and created reports.
Gather, analyze and document business requirements, clarify business rules and data design requirements, functional requirements and prepare specification documents.
Assist in reviewing and analyzing existing system structures to provide solutions to enhance and improve system.
Assist in conducting in-depth review of requirement specifications collected and analyzing business process to determine the exact nature of user’s system requirements.
Designing mapping of process flow and interacting with analysts and core team members to select the proper system infrastructure.
Specifying Dimensions, Levels, Hierarchies and Key values for data flow.
Created joins, views and packages using Framework Manager to be used for report development.
Modified Metadata in the model by defining Filters and adding Calculations to better suit the requirements of the end users.
Created Ad-hoc report using Query Studio and complex report using Report Studio.
Created Mix reports, Financial and Top ten reports.
Extracting OM (Order Management) application data from an Oracle transactional system and Loading it into a SQL Server data warehouse.
Designed, developed, deployed and maintained Universes using Business Objects Designer tool.
Developed complex reports including multipage-reports, graphical reports, formulae base and well-formatted reports according to user requirements.
Created Aliases and Contexts for resolving Loops and Checked the Cardinality and Integrity of the Project / Framework Model.
Created prompts in report to restrict data fetch and ease data load.
Restricting the user access with help of Access Level privileges.
Extensively worked on Informatica Designer, Workflow Manager, Workflow Monitor Working on Source Analyzer, Warehouse designer, Mapping Designer
Creation of repositories and security domain with user groups and security implementation.
As per the Business requirement creating the reports to cater to Order, Orders History, Pending Orders at Tasks, Processes and Tasks subject areas of the application.
Provided the security access management by creating users/groups and folders.
Upgraded from Cognos 8.4.1 to 10.x.
Environment: Cognos 10.1.1, Report Studio10.2.2, Query Studio 10.2.2, Framework manager 10.2.2 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight and Business Insight Advanced), Cognos Connection, Rave, Oracle 10g, SQL Server 2005/2008 R2, DB2 9.1 on Windows Server 2003/2008, Maximo, Tableau, Click, Cognos SDK,SSIS,SSAS
Client: BBVA Compass Bank, Birmingham, AL Oct 2011- Sep 2012
Role: Cognos Developer
BBVA Compass Bancshares, Inc. is a United States-based financial holding company, subsidiary of the Spanish multinational Banco Bilbao Vizcaya Argentaria Business Intelligence solution is to identify and retain the most profitable portion of its customer base, attract new customers with similar profiles, and increase the overall effectiveness of its marketing programs and overall profitability. The project’s main objective is to create a central database for data and to provide a set of standard reports to give better analysis to the financial group. The Data warehouse project was developed for reporting and high level business needs for their financial sector, using historical and online data.
Developed and implemented Business Intelligence solutions as a part of Business Intelligence Organization.
Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
Involved in the design and implementation of the balanced scorecard and online analytical processing (OLAP) solutions
Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance.
Collaborated with business to develop high-level designs including logical models and functional specification documents.
Actively worked with the BI team and Business to transition the application into Production Environment by providing support and training through the release cycle.
Prepared training materials, developing Business models and training users in Query Studio according to their specific needs and requirements.
Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements
Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.
This included debugging and optimizing Cognos reports and used a variety of reporting packages to produce, automate, schedule, and distribute defined reports.
Managing and Administering the entire Cognos 8 for BI Team.
Involved in designing the Framework Manager Models.
Created the Framework model which involved columnar modeling approach to ease report development and TY vs. LY analysis for Adhoc users
Improving existing models by Creating Alias tables and applying other techniques for effective reporting.
Developed several Cognos reports.
Responsible do to Query Optimization and Performance Tuning of all reports.
Environment: Cognos 8.4 (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Oracle9i, MySQL, MSQL Server 200/2005/2008, windows 2003, Unix, root cause analysis, Click, Spotfire, Cognos DI,Cognos SDK,Adhoc
Client: Dialog Telekom, Bangalore July 2007- Sep 2011
Role: Cognos Developer
The purpose of the Telecom Analytics Service Offering is to provide baseline and derived analytics that will help telecom operators to meet the demands of the changing telecom landscape. These analytics will be based on the data that normally exits in various data stores in any telecom operator’s network such as customer management data (product catalog and OE), network management data (from NMS and NEs) and enterprise management data (from HRM, SCM, etc.). The purpose begins by gathering requirements from the customer about the areas of business transformation that are important to the customer and then identifying the relevant metrics.
Created the design documents for the development of Cognos Report net.
Involved in creating the model and package using Framework manager.
Created reports for various departments like HR, sales and production.
Communicated with the business users to comprehend the requirements.
Involved in the migration of catalogs from impromptu to Report Net using migration utility.
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.
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.
Created customized BI reports linking various databases, to meet the user requirements.
Developed numerous sophisticated drill-through Report Net Reports.
Created standard and Ad-hoc reports using Cognos Query Studio (Simple List, Grouped List, Crosstab, and nested Crosstab) reports and represented data graphically by charts utilizing Query Studio.
Environment: Cognos Report Net, Cognos connection 7.1, Power play Enterprise Server 7.1, Oracle 9i, Windows XP, Windows NT, and Windows 2000
Contact this candidate