Manager Data
Resume:
Devaraj Erirajanna
*******.***@*****.***
Sr. Cognos Business Intelligence Developer
PROFESSIONAL SUMMARY:
●Over 7+ years of professional experience on Cognos Business Intelligence as a Cognos Developer and Developer-Analyst with key activities in all the stages of the project SDLC such as support, analysis, designing, testing, debugging and documenting Cognos BI/TM1 solutions across multiple industries.
●Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR), &OLAP Cubes) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension) using Data Modeling tools such as Cognos Transformer, Cube Designer and Framework Manager.
●Installed, configured and worked on Cognos BI suite, including Business Insight & Advanced, Report Studio, Analysis Studio, Workspace Advanced, Cube Designer and Framework Manager.
●Experience in understanding existing business processes, gathering business systems requirements analysis and design thereby converting into detailed reports for strategic decision making.
●There are a lot of business intelligence tools out there, and in full disclosure, I have only used Business Objects, Cognos, and Tableau.
●Extensive experience working with Cognos 10.x/8.x Business Intelligence Reporting Suite (Framework Manager, Analysis Studio, Report Studio, Event Studio, Query Studio and Transformer, Dynamic Cubes, Workspace, Workspace Advanced, Power Play Studio, Cognos mobile) Applications.
●Designed and implemented enterprise wide Reporting strategies utilizing Business Intelligence (BI), Data warehouse, Data Analysis, Data Modeling, Data Mining techniques.
●Tableau has a wide variety of native database connections that make it very easy for your users to quickly and effectively get moving.
●Unlike some of the other BI tools, Tableau is not a complete technology stack, it is most useful for visualization and analytics.
●Implemented the Enterprise level Cognos security and Server Administration using Cognos 10.x/8.x and administration of security using Access Manager, LDAP and Custom Authentication Provider.
●Developed simple and complex reports including list, crosstabs and charts with drill-thru capabilities, Master Detail relationship, Bookmarks, Prompts, Macros, and Dashboards etc.
●Experience in Database coding using ETL tools, data mining techniques, installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008, MY SQL and Oracle 10 series databases
●Extensive experience using various data sources such as Oracle, DB2, SQL Server and Access.
●Excellent knowledge on SDLC/Data Warehousing implementations using Star schema and Snowflake schema and developing reporting solutions from OLTP.
●Experienced in Migration of other reports into Cognos and version up-gradation in Cognos.
●Has worked on several requests from business towards building Report Studio reports, Query Optimization and Performance Tuning of reports.
●Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules.
●Solid designing and development experience in developing various kind of reports like Cascading parameters, pick lists, Drill down, Drill through, Sub Reports and Charts.
●Responsible for Interacting with users and department directors to identify information needs and business requirements.
●Experience with the Enterprise level Cognos administration and Framework Development support, which includes the installation, configuration, administration and maintenance of a business-critical Cognos product set in a 24x7 production environment.
●Strong Business intelligence design skills including Entity Relationship Diagrams, Data Modeling, Process Modeling, Systems Design, User-Interface Design, System/Application Architecture and Reports Development
● Strong understanding of dimensional modeling of Star Schemas, Snowflake Schemas methodologies, dimensional data structures and complex hierarchies.
●Proficient in analyzing and translating business requirements to technical requirements and architecture.
●Proficient in maintaining Data Level, Object Level and Package Level Security.
●Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
●Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.
●Excellent team player with problem-solving and troubleshooting capabilities and ability to adjust to people, circumstances, with a Drive for results through self-motivation.
TECHNICAL SKILLS
BI/OLAP Tools
Cognos 8.x BI(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event studio, Metric Studio and Cognos Connection), Report Net 1.1 Cognos Data Manager, Cognos EP Series 7, Impromptu Administrator, IWR, Power play reports, Upfront, Power Play Transformer, Access Manager LDAP, Cognos Architect, Business Objects, Upfront, Oracle Discoverer, Crystal Reports8.5.
DWH Tools
Informatica7.x Power Mart/ Power Center, SQL Server DTS, Erwin4.0/3.5.2
Databases
Oracle 10g/9i/8i, SQL Server 2005/2000, DB2, Teradata, TOAD, MS Access, Clear Quest, IIS 7.0, Apache Web Server
ETL Tools /
Software
Informatica, Data Stage, Data Manager, Decision Stream, Oracle Warehouse Builder, MS Office 2000 (Word Excel, PowerPoint, Access), Visio
GUI
Developer/2000, Forms 6i, Reports6i, Oracle Application server 9iAS.
Languages
SQL, PL/SQL, XML, HTML
Server Applications
Cognos Enterprise Server, Sun ONE Directory Server, IIS, Netscape Directory Server, NES, NAS, IBM Web Sphere, Web Logic, Apache
OS
Windows 95/98/2000/NT/XP, UNIX, Linux, Sun Solaris and MS DOS
PROFESSIONAL EXPERIENCE
Client: IBM, Armonk, New York. July-2015 to Present
Role: Sr. Cognos BI Developer
Description:
International Business Machines corporation provides information technology(IT) products and services worldwide. The company’s Global Technology services segment provides IT infrastructure services, such as IT outsourcing, integrated technology, cloud, and technology support services. IBM Cognos BI allows business managers to analyses sales and service data from across its various business divisions generating weekly, monthly and quarterly reports and dashboards
Responsibilities:
●Worked with Business Users to get the user requirement for creating multi-dimensional cubes and canned reports.
●Understood business logic underlying the requirements, based on the report mockups.
●Implemented report prototypes layouts before the actual report implementation.
●Conducted constant review meetings with Business End Users to ensure the reports are meeting the requirements.
●Worked extensively with the ETL Team for creating the MV’s and creating Views for the report requirements.
●Did performance tuning on Dynamic cubes to reduce query time by capturing the Queries from the XQE-Logs
●By using MDX Functions developed Dashboard reports in Report Studio. Involved in design phase, gathered requirements from users and documented, designed, developed report specifications including report documentation for creating reports using Report Studio.
●Developed Complex reports using Report Studio which includes various report types ranging from simple lists, crosstabs and chart through complex dashboards, drill-through, master-detail and conditional formatting.
●Involved in the Unit Testing of the reports and preparing the Test cases.
●Raised tickets and interact with different teams for migration of code (Teradata views, packages and reports) to different environments
●Created multipage reports involving prompts, cascading prompts, conditional rendering and conditional highlighting.
●Designed Dynamic Cubes – in memory tool using Cube Designer tool and deployed in the Cognos 10 environment to increase the performance which is using large data sets.
●Created POC for Active Reports (using data tabs, data decks etc.) and Dynamic Cubes in Cognos 10.2.2
●Updated Active Reports using Scheduled jobs and used these for the Mobile reporting both for IOS and Android Tablets and Phones.
●Defined a separate portal tab for hosting the Active reports, Dashboards and WSA Reports that are useful for Mobile users both offline and online.
●Analyzed existing solution containing cubes reports, materialized views and worked with the functional team to create technical documents.
●Installed, configured and administered various Cognos components such as the Cognos BI server, Framework Manager and Cube Designer.
●Worked with the user for resolving the issues on QC, to log and close the defects that are raised.
●Supported the reports in Production environment and transferred knowledge on maintaining/modifying reports in the future to the support team.
Environment: Cognos 10.2.2 (Transformer, Cube Designer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration), CAFÉ, Oracle 11g, Windows 2003/7, Microsoft Excel.
Client: Yamaha Motor company Limited, Kennesaw, GA April - 2014 to June - 2015
Role: Sr. Cognos Developer.
Description:
Yamaha Motor company Limited is a Japanese manufacture of motorcycles, marine product such as boats and outboard motors and motorized products. Cognos Business Intelligence tools, Cognos power play andCognos Impromptu. It allows Yamaha business managers to analyses sales data from across its various business divisions generating weekly, monthly and quarterly reports into dealer and territory performance by transaction value, volume margin and product. As a result, business managers and directors at Yamahawill now be able to quickly assess performance right across the company.
Responsibilities:
Conducted user interviews and documented their queries, business and reporting needs
Developed different types of reports according to the user requirements.
Developed list reports, Cross tab, charts, drill-through reports, and master-detail reports, Dashboard reports.
Developed Templates, standard Reports, Bursting Reports and Multilingual Reports using Report Studio and Query studio. Provided training on Query Studio to create Ad-hoc Reports.
Involved in extensive use of conditional formatting while developing reports in Report Studio.
Improved the performance of reports using normalized models, Views, indexing.
Implemented security for Data access, Object level access and Package access.
Created Hot Files to be used as Lookup tables to prepare reports and reduce querying time.
Formed joins and database definitions according to the requirements. Scheduled Reports and Jobs to run periodically.
Involved in UAT with Users (Reports Demo) and working on Modifications provided by the users and taking Sign Off from Testing.
Testing the report and the validity of the data it retrieves from the database.
Customized data by adding calculations, filters, prompts and governor settings.
Created Notifications and Alerts for the Reports that are critical in budget calculations using Event Studio
Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio for their several projects Life and Annuity Paid and Pending Productions
Involved in writing SQL and PL/SQL procedures
Developed Prompt Pages and Cascaded input Prompts to display only the selected entries in the report
Created reports with dynamic prompts and auto submit without using HTML or java scripts
Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Report Net 1.1, Cognos Connection, TOAD, Windows 2003/XP, Oracle 10g, Clear Quest, Excel 2003
Client: Pitney Bowes Inc, Shelton, CT Feb - 2013 to March - 2014
Role: Sr. Cognos Consultant/Trainer
Description:
Pitney Bowes Inc. is a global e-commerce solution provider shipping and mailing products providing customer information management solutions. The main aim of the project is to implement Data ware house for execute the reports and analyze the business so that which is useful for decision making for improving the business and customer services.
Responsibilities:
Modeled and reported against a dimensional database which is in the form of a Star schema.
Analyzed functionality and business requirements and transformed the Functional Design Document into Technical Design Document.
Involved in design and development of security architecture to meet business needs.
Ensured ambiguous relationships are resolved and implemented Model enhancement techniques to improve Model performance.
Created Model query subjects, Data source query subjects, standalone and embedded filters to implement complex business logic.
Implemented internal Cognos security both at Column level and Row level using Security tables to secure sensitive data with Security Filter, Macros, session parameters and parameter maps.
Developed Hierarchies and Measures to support ad-hoc reporting and multidimensional reporting.
Published Packages to Cognos connection and implemented Package level security.
Using Transformer cubes as data source imported those into Framework Manager, created Models and packages for Analysis Studio.
Created highly complex reports using OLAP Cubes as data source for Multidimensional analysis.
Automated the monthly cube refresh process using Command line options and scheduled it using Windows Scheduler.
Developed report templates for Standard and Ad-hoc reporting to make the reports look consistent.
Developed List, Cross-Tab and Chart reports for different Views of data.
Implemented various reporting techniques like Drill up, Drill down and Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail and secured Reports and Folders for specific user groups.
Deployed Packages and Reports to Test environment using Content Administration.
Scheduled and distributed reports via Schedule Management in Cognos Connection Bursting reports to different user groups.
Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Transformer, Oracle 10g, Informatica8.1.
Client: Care First-Maryland, MD November - 2011to January - 2013
Role: Cognos Administrator
Description:
CareFirst BlueCross BlueShield is a not-for-profit, a non-stock health service company which, through its affiliates and subsidiaries, offers a comprehensive portfolio of products and administrative services to individuals and groups in Maryland, the District of Columbia and portions of Northern Virginia.
Responsibilities:
Install and configure Development, Test, Stage, Training and Production environments with IBM Cognos 10.2 BI /CognosTM1 10.1.
Design and Implement Integration of Cognos BI and TM1 Portals
Design and implement Cognos content Backup and restore
Cognos 10.2 BI/TM1 10.1 Distribution environment Setup
Provide design and implementation architectural solutions for data warehouse and data marts database design, ETL/data loading strategy, and business intelligence reporting data, taking into account system requirements, security, system extensibility and interoperability, costs, operations and support considerations, and BI best practices.
Develop and maintain BI architecture principles, best practices, patterns, guidelines, standards, methods, techniques, and models.
Logical and physical data design modeling and implementation to meet business objectives and the needs of BI architecture other program deliverables.
Provide an end to end solution and work with integration partner during design and implementation of the data warehouse, BI tool integration, and associated sub systems.
Developed Complex ETL code through Data manager to design BI related Cubes for data analysis at corporate level.
Formulated ETL processes to Extract Data from Operations DB to the Reporting DWH, Designed and developed Cognos EP models and Cubes.
Worked on MDX functions over Report Studio on Multi-dimensional sources
Work with MDM Data Governance Lead to implement processes to maintain integrity and quality of the data residing in the data warehouse and data marts.
Design and implement production processing architecture, including performance monitoring, scheduling, and notification in the event of failures.
Once deployed, responsible for day to day support of the data warehouse and marts, ETL integration, and BI application.
Manage Cognos BI licenses for project life cycle and reviewed the report design and documentation.
Environment: Cognos 10.2 and 10.2.2 BI versions, Report Studio10.2.2, Query Studio 10.2.2, Framework manager 10.2.2, Dynamic Cubes, IBM Cognos Business Insight, IBM Cognos Configuration, IBM Cognos Lifecycle Manager, Cognos 10.2 tool suite, Cognos TM1 9.5.2 and SQL, PL/SQL, Windows 2008, 2012.
Client: Transystems, Kansas, MO August- 2010 to October - 2011
Role: Cognos Consultant
Description:
Transystem is a bulk commodities transportation company operating in the Midwest and Western United States. Founded in 1942 by John S Rice, Transystems continues to be a family-owned company managed through the core values of quality work, integrity and professionalism. The main aim of the project is to implement Data ware house for execute the reports and analyze the business so that which is useful for decision making for improving the business and customer services.
Responsibilities:
Involved in Installation & Configuration of Cognos 8.4 tools in distributed environments on Windows.
Developed the Framework Manager models (DMR Models) and Published into server.
Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases. Used filters for efficient data retrieval.
Design & development of the reports using Cognos 8 Report Studio, Analysis Studio reports.
Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
Modifying the existing reports based upon the change request by the user. Involved in resolving Performance issues with various reports.
Creation of Multi-dimensional Dash Board Reports using Report studio and adding it to the portal page using Cognos URL.
Understanding the existing security structure of the company and implemented organizational security for Cognos environment (Folders, Models and Reports etc). Implemented SSO between the company internal portal and Cognos.
Involved in deployment to UAT and Production.
Scheduled and Distributed Reports through Schedule Management in Cognos Connection
Carried out bursting of reports in Report Studio
Troubleshoot Cognos Server Environment for the better performance.
Managing the dispatchers and services in distributed Environment.
Environment: Cognos 8.4.1 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio and Event Studio), SQL server 2005, and Windows 2003 Server
Client: AVIVA Insurance, Haryana, India, June -2008 to July - 2010
Role: Business Analyst
Description:
Aviva India is a joint venture between Dabur Invest Corp (DIC) and Aviva International holdings Limited. India’s leading life insurers with a quality business model, focused on sustainable growth. The main aim of the project is to implement Dataware house for execute the reports and analyze the business so that which is useful for decision making for improving the business and customer services
Responsibilities:
Involved in Requirement gathering from Business Users.
Analyzing the source data from different databases.
Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
Installed and Configured Cognos 8 BI Suite in multi-server environment on Windows and UNIX environments.
Created Complex Reports using Cognos 8 BI Report Studio and Ad-hoc web based reports using Cognos 8 BI Query Studio.
Developed various Complex report types ranging from simple Lists, Cross-tabs through complex dashboards, drill-through, Master-detail & conditional.
Formatting reports for both HR and end-users.
Created Complex Dash Boards and published into connection portal.
Created Member based security, Custom/ Dimension views, Apex custom views and cloak.
Created Scheduled Jobs by (Triggers) and scheduling multiple reports a job.
Tested and validated the report output against the database to measure performance of reports.
Deployed Reports, Packages and Folders from DEV to UAT and from UAT to PROD Environments.
Environment: Cognos 8.4/8.3 BI (Report Studio, Query Studio, Analysis Studio, BI Modeling, Framework Manager, Cognos Connection), Power Play Transformer
Education: Bachelor of Technology from National Institute of Technology, Jalandhar, India
Contact this candidate