| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSiva Sudhakara Gotike Phone: PHONE NUMBER AVAILABLE(M)EMAIL AVAILABLESummary:Over 24 years of experience in Software Development participating in planning, analysis, design, review and programming in various projects.Over 20 years of experience in Analysis, design and development of Business Intelligence applications using Cognos Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metrics Studio & Analysis Studio & Over 6 years of experience on Tableau.Over 7 years of experience in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses using Informatica PowerCenter.Good understanding of database and data warehousing concepts (OLTP & OLAP).I have a very good understanding and experience of Claims Data.Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions and at database.Around 5years of experience in designing and developing end-to-end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence (OBIEE).Extensively worked on Transformer for Data Modeling of the corporate data for building up of Multidimensional Cubes.Providing extensive services on ETL tool Power Center 7.0/8.6/9.6.1 Versions.Good understanding of dimensional models, slowly changing dimensions.Expertise in Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in relational, dimensional and multidimensional modeling.My expertise is in the area software design and programming of Client/Server, Web applications using VB, Oracle, SQL Server, DB2, MS Access, Java Script, VBScript, ASP, HTML, DHTML, and XML.Responsible for interacting with business partners to identify information needs and business requirements for reports.Prepared complex reports in response to requests from higher management and clients.Considerable knowledge in the analysis and design of business requirements and specifications.Excellent Analytical and problem-solving skills. Team Player with the ability to communicate effectively at all levels of the development process.Skill Set:Reporting ToolsCognos11/10.2.1/8.4/8.3 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio, Event Studio, Metrics Studio), OBIEE, BI Publisher, BI Answers, Cognos SDK, Report Net 1.02/1.1, Cognos Impromptu 7.4/7.3, Cognos Power Play 7.4/7.3, Transformer 7.4/7.3, Impromptu Web Reports (IWR) 7.4/7.3, MSOLAP, LDAP, Access Manager 7.3, Power Play Enterprise Server 7.0/7.3, Crystal Reports8.0, OBIEE 11.1.1.7.0/11.1.1.9.0, WebFOCUS 8, Tableau 2019/2020/2022/2023, R,SASETL ToolsInformaticaPowerCenter9.6.1, Cognos Decision Stream 6.5/7.0,Oracle Warehouse Builder (OWB), ODIDatabasesOracle12c, SQLServer7.0/2000/2005/2008, DB2, MS-access, PostgreSQL, Sybase, NCR Teradata, Snowflake, Oracle EBS, Redshift, PostgreSQLOperating SystemsWindows 10, Windows 7 Professional, Windows NT/2000/XP Professional, UNIX, Sun Solaris, IBM AIXLanguagesC, C++, Java, SQL, PL/SQL, VB6.0, VB.NETWeb TechnologiesASP2.0, ASP.NET, ADO.NET, JSPScripting LanguagesJavaScript, VBScript, Cognos Script (macros)ToolsPL/SQL Developer, TOAD, SQL Tools, Erwin, UMLScheduling ToolsCognos Schedular, Control-MWeb ServersMicrosoft IIS 5.1, Apache Web Server, AWSSource ControlCVS, Clear Case, Visual SourceSafe, TortoiseSVN, Serena Business Manager, Serena Dimensions, GitHubERPPeople SoftEducation: Bachelor of Engineering from Karnataka University, Dharwad, INDIAProfessional Experience:Deloitte MD Jan21 to till dateAgency for Health Care Administration (AHCA)Florida Medicaid Management Information System (FMMIS)Senior Solution SpecialistMedicaid is a medical assistance program that provides access to health care for low-income families and individuals. In Florida, the Agency for Health Care Administration (Agency) is responsible for Medicaid.Roles & Responsibilities:Involved in gathering the requirements from the business users.Created System Design documents, prepared database to reports column mapping documents.Created standard Cognos templates for the standard reports and ad hoc reports.Collected the requirements from the users and analyzed the requirements and provided the insights and results to the management / users.Monitored technical challenges and resolved the issues by conducting various meetings with Team members.Developed a framework model and created various business namespaces to support different business needs.Created various Cognos packages and published them on the Cognos Server and applied security.Developed various reports and Dashboards.Developed Dashboards with drill through reports and utilized parameters, filters.Prepared unit test case documents and did the unit testing for the reports and Dashboards.Prepared the Code Review and Code Review Checklist documents for the reports and Dashboards.Handled multiple project modules and ensured delivery of projects within the timeline deadline.Interacted with Cognos Admin team and DBA Team on solving the reports & dashboards issues.Prepared code deployment document to promote code from one environment to another environment.Provided the Production support and worked on CRs, EPICs and tickets.Monitored the project tasks and ensured tasks / milestones and deadlines are meeting.Using Tableau Prep cleaning, shaping, and organization of data before it can be analyzed.Used Tableau Prep tool excels in data joining and blending, enabling users to integrate data from multiple sources seamlessly.Developed Tableau Reports and Dashboards for the DHS/DLI data sharing project.Using Tableau Dashboards various departments /offices analyze the Department of Labor and Industry data.Provided technical advice in the design / development and other phases of the projects.Provided Production Support and worked on various tickets.Environment: IBM Cognos Analytics 11.1.7, AWS Arora, AWS RedShift, SQL, PostgreSQL, SQL Workbench, Tableau Desktop 2023, Tableau Server 2023, Tableau Prep, Oracle SQL Developer, Amazon Web Services, AIX, Amazon WorkSpaces, Jira, Confluence, Azure DevOps, UNIX, Tortoise SVN, Snowflake, GitHub, GitLab, SharePoint.Analytica MD Sep18 to Nov20Centers for Medicare & Medicaid Services (CMS)Office of Acquisition & Grants Management (OAGM)Sr BI Reports Developer / Sr ArchitectOAGM is one of CMS mission critical service components - negotiating and administering hundreds of contracts, grants, and interagency agreements.Roles & Responsibilities:Gathered requirements from business users.Developed a framework model and established relationships in a way that served as a base for all possible business needs.Created various Cognos packages organized differently based on reporting needs of business purpose.Developed various OAGM workload reports and Dashboards.Developed Dashboards with drill through reports and utilized parameters, filters.Prepared unit test case documents and did the unit testing for the reports and Dashboards.Prepared the Code Review and Code Review Checklist documents for the reports and Dashboards.Converted Cognos Reports into Tableau Reports and Dashboards.Design and develop Tableau visualization solutions.Developed Tableau visualizations and dashboards using Tableau Desktop.Prepare Dashboards using calculations, parameters in Tableau.Defined best practices for Tableau reports and dashboard development.Handle multiple projects and ensure delivery of projects within deadline.Interacted with Cognos Admin team and Oracle DBA Team on solving the reports & dashboards issues.Worked as Technical Architect in Cognos upgradation projects.Prepared complex reports in response to requests from leadership and end clients.Prepared code deployment document to promote code from one environment to another environment.Provided the Production support and worked on CRs, EPICs and tickets.Worked on Production Support Tickets.Environment: IBM Cognos Analytics 11.1.2/11.1.7, Oracle 12c, SQL, PostgreSQL, TOAD, PL/SQL, PLSQL Developer, CAMS, PRISM, CALM, Oracle SQL Developer, Tableau Desktop 2020.1/2019.4, Tableau Server 2020.1/2019.4, Tableau Online 2020.1/2019.4, Amazon Web Services, AIX, Amazon WorkSpaces, Redshift, Jira, Confluence, UNIX, Tortoise SVN, Snowflake, GitHub.CNSI, Rockville MD Dec17 to Sep18CHAMPS Facility Settlement ReportsLead BI Developer/AdministratorWorked on CHAMPS Facility Settlement Reports of Accruals, Pool Payments and Hospital business areas for the State of Michigan Medicaid initiatives.Roles & Responsibilities:Gathered requirements from business analysts as well as business users.Involved in all the stages of System Development Life Cycle (SDLC) process.Developed a framework model and established relationships in a way that served a base for all possible business needs.Created various Cognos packages organized differently based on reporting needs of business purpose.Created list reports, cross tabs, charts, graphs, drill-through, master-detail reports in Report Studio.Utilized parameters, filters, and calculations along with conditionals.Used data format properties in the reports to improve the readability.Used content administration to migrate packages and reports to QA environments.Prepared unit test cases, document and did the unit testing for the reports.Prepared the Code Review and Code Review Checklist documents.Attended the Bug Triage meetings for discussing the defects with QA team.Used Quality Center tool for checking the defects and reassigning them to QA team.Provided Production support and worked on Production tickets.Environment: IBM Cognos11/10.2.2/8.4/8.3 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio), Cognos Analytics, Oracle 11.2.0, PostgreSQL, SQL, PL/SQL, PLSQL Developer, SQL Tools, SQL Developer, IBM Rational ClearQuest, UNIX, Tortoise SVN.General Dynamics Information Technology (GDIT), Columbia MD June11 to Nov17Centers for Medicare & Medicaid Services (CMS)DECC Project (CSRA)Sr Principal Programmer /Lead Developer/AdministratorWorked on Physician Quality Reporting System (PQRS), Hospital Reporting (HR) and ESRD systems.Roles & Responsibilities:Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, participated in the Design Team and user requirement gathering meetings.Gathered user Requirements and designed Source to Target data load specifications based on Business rules.Used Informatica Power Center 9.6.1 for extraction, loading and transformation (ETL) of data in the DataMart.Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.Worked on Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.Use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generatortransformations.Examined the workflow log files and assigning the ticket to the Informatica support based on the error.Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.Experience in developing Unix Shell Scripts for automation of ETL process.Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.Monitored the project tasks and ensured tasks / milestones and deadlines are meeting.Migrated Reports from Congos to OBIEE.Created (RPD) for different subject areas and created multiple reports and dashboards.Developed the reports and dashboards and maintained the OBIEE environment.Worked on OBIEE Annual Management / Monthly Management dashboards.Created list reports, cross tabs, charts, drill-through reports using OBIEE.Configured Physical Layer, Logical Layer, and Presentation Layer in repository (RPD).Managed OBIEE WebLogic and Enterprise Manager Servers.Performed the administration tasks like adding new users/ groups in OBIEE and maintained the applications.Worked on BI publisher Reports and having strong SQL skills.Developed HTML, pdf, excel format reports using BI Publisher (BIP) and analytical reports with OBIEE.Developed a framework model and established relationships in a way that served a base for all possible business needs.Provided technical advice in the design / development and other phases of the projects.Involved in review board committee on reviewing various software and various business intelligence tools and analytical tools.Created various Cognos packages organized differently based on reporting needs of business purpose.Created list reports, cross tabs, charts, graphs, drill-through, master-detail reports in Report Studio.Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts.Worked closely with business power users to create reports/dashboards using tableau desktop.Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.Created the claims related reports for the Providers and Vendors using Tableau.Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.Utilized Tableau server to publish and share the reports with the business users.Used content administration to migrate packages and reports to QA environments.Prepared unit test cases, document and did the unit testing for the reports.Prepared the Code Review and Code Review Checklist documents.Used Quality Center tool for checking the defects and reassigning them to QA team.Provided Production support and worked on Production tickets.Environment: InformaticaPowerCenter9.6.1, OBIEE11.1.1.9.0 / OBIEE 11.1.1.7.0, BI Publisher, BI Answers, IBM Cognos11/10.2.1/8.4/8.3 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio), Cognos Analytics, Tableau Desktop, Tableau Server, Oracle 10g, SQL, PL/SQL, PLSQL Developer, SQL Tools, Java, HP ALM, JDK 1.6.0, UNIX, AIX, Teradata, Oracle EBS, Tortoise SVN, Cognos Data Manager, Erwin, R, SAS, Crystal Reports, Serena Business Manager, Serena Dimensions.Iowa Foundation for Medical Care (IFMC), Elkridge MD May09 to June11Centers for Medicare & Medicaid Services (CMS)PQRI &HQR - OPPS Reporting SystemBI Technical Lead DeveloperIFMC is committed to improving the quality, service and cost of medical care and health through population health management solutions.CMS (Centers for Medicare & Medicaid Services) is a US federal agency, which administers Medicare, Medicaid, and the Children's Health Insurance Program. Worked on ETL tools and developed reports for Physician Quality Reporting Initiative (PQRI) & Hospital Outpatient Prospective Payment System (OPPS) systems.Roles & Responsibilities:Involved in Business Requirements discussions with Health Informatics, Business Analysts andQA analysts.Created Detailed Design, Technical Specifications document and Traceability Matrix document.Prepared technical design/specifications for data Extraction, Transformation and Loading.Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.Loaded the process claims to Oracle using informatica tool by creating mappings and workflowsUse of Aggregator, Filter, Router, Expression, Joiner, Union and Sequence generator transformations.Developed a framework model and established relationships in a way that served a basefor all possible business needs.Created various packages organized differently based on reporting needs of business purpose.Transposed data and created views to improve performance and flexibility.Created list reports, cross tabs, charts, drill-through, master-detail reports in Report Studio.Developed Dashboard reports and Drill Up/Drill Down reports and utilized parameters, filters.Used data format properties in the reports to improve the readability.Followed the report standards document for developing the reports.Used conditional blocks to hide and show the objects in the report based on a condition.Added conditional rendering to specify which columns are rendered when the report is run.Implemented security to the packages, folders and reports.Used content administration to migrate packages and reports between Development, QAenvironments.Prepared unit test cases, created unit test summary document and did the unit testing for theReports and workflows.Created the DPLAN (Deployment Plan) document, created the JTrac for sending the builds to QAenvironment.Prepared the Code Review and Code Review Checklist documents.Conducted/Attended the Code Review Meetings with QA analysts, Cognos Team.Attended the Bug Triage meetings for discussing the defects with QA team.Used Test Track Pro tool for checking the defects and reassigning them to QA team.Environment: IBM Cognos 8.4/8.3/8.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio), Oracle 10g, SQL, PL/SQL, PLSQL Developer, Informatica PowerCenter 8.6, SQL Tools, TOAD, Java, JDK 1.6.0,Quality Net, JTrac, Test Track Pro, UNIX, Windows XP Professional.US Steel, Granite City IL June07 to May09The new data warehouse reportsSr Cognos Author/AdminUnited States Steel Corporation is an integrated steel producer with major production operations in the United States, Canada, and central Europe. The main objective of the project was conversion of the data warehouse as well as reports from IBM Focus on mainframe to Oracle and Cognos. The intent is to develop complex reports for different departments within the organization and to involve users in the process of data mining and report development.Roles & Responsibilities:Gathered requirements from business analysts as well as business usersCreated data mapping specifications for new reports as well as existing reports that originatedfrom Mainframe FocusBuilt a robust framework model and established relationships in a way that served a base for allpossible business needs.Created query prompts, complex calculations, and conditional filters within the model.Consolidated data source view through model query subjects to reduce granularity leading toefficient SQL code generation.Transposed data and created views to improve performance and flexibility.Created various packages organized differently based on reporting needs of business users inany department.Applied security on data level, query subject level, and package level using departmental groups.Designed Report Studio templates maintaining a report information page only visible by authorsusing conditional layout. Designed Query Studio templates to maintain consistency within theOrganization.Created ad-hoc reports, cross tab reports, and charts in Query Studio.Created list reports, cross tabs, charts, drill-through, master-detail reports in Report Studio.Designed flexible prompt pages for report scheduling and on-demand execution needs containingsimple and cascaded prompts to facilitate report usability.Utilized parameters, filters, calculations along with conditionals.Implemented advanced conditional formatting to ensure proper layout considering the outputformat. Simple conditional formatting was used to increase report readability through legends.Maintained security on the Cognos portal by controlling privileges for users, groups, and roles.Implemented folder level and report level security exclusive to each department.Scheduled reports with appropriate frequency and set delivery options to email or save reportoutputs onto Cognos connection or a file system location.Created jobs and report views to increase reusability when scheduling reports.Utilized Cognos activities section to manage schedules and to re-run failed jobs.Created WebFOCUS reports from user specifications.Create Dashboard Applications and reports in the WebFOCUS Managed Reporting Environment.Used content administration to migrate packages and reports between Development, QA, andProduction environments.Used Cognos SDK to customize the application and automate various tasks.Created user groups based on Cognos roles to organize users within departments.Conducted regular interactive training for end users on Query Studio and Report Studio.Provided one-on-one walk-through sessions as requested.Prepared training materials on utilizing the data warehouse as well as process documentation including user tips and best practicesEnvironment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio), Cognos SDK, WebFOCUS, FOCUS, TOAD, DB2,Oracle 9i/10g, PL/SQL, SQL Tools and Developer, UNIX, Windows XP ProfessionalKent State University, Kent OH Nov06 to May07Sr Cognos DeveloperKent State University's eight-campus network, one of the largest regional systems in the country, serves both the development of a true living/learning approach at the Kent Campus and regional needs on seven other campuses throughout Northeast Ohio. The objective of the project was developing reports for the schooling system.Roles & Responsibilities:Involved in gathering Business requirements from end-users.Converted the Functional requirements into Technical requirements.Design and Developed Report Lay outs & created technical specifications for Reports.Build Framework Model using Framework Manager a Cognos 8 Tool.Created Folders, Namespaces, Calculations &relationships using FM.Created Package published it onto Report Net Server; it appears on the Cognos Connection.Created List Reports, Standard Reports Charts, Cross tab Reports, Drill through Reports UsingReport Studio.Created Value Prompt, Date Prompt, and Textbox Prompt to filter the data.By doing calculations & filters in model, Improve the performance of the reports.Implemented various levels of security like data security, metadata security.Used Scheduler to schedule the reports for Distribution Daily, Weekly, Monthly, and Yearly.Did the unit testing for reports and wrote the test cases.Wrote the design documentation, report documentation.Having good Knowledge on SunGard Banner and PeopleSoft HR data.Provided necessary support to the business users during UAT and after implementation.Did the business users training for how to use the reports.Involved in administration of servers using Cognos ConnectionCreation of User Classes, users and changing their profileEnvironment: Cognos 8.1(Framework Manager, Query Studio, Report Studio, Cognos Connection, Cognos Configuration, Metrics Studio), Excel, SQL, Oracle 9i, TOAD 7.0, UltiPro HR, PeopleSoft HR,Windows NT, Windows 2000 Professional, UNIXAbbott Laboratories, Waukegan, IL Jan06 to Nov06Clinical Studies Management ServicesReport Net AuthorAbbott is a global, broad-based health care company devoted to the discovery, development, manufacture and marketing of pharmaceuticals and medical products, including nutritionals, device and diagnostics. Clinical trials are currently underway evaluating the potential of HUMIRA in other autoimmune diseases, including juvenile rheumatoid arthritis (JRA), psoriasis, psoriatic arthritis, Crohn's disease and ankylosing spondylitis.Roles & Responsibilities:Involved in gathering Business requirements from end-users.Converted the Functional requirements into Technical requirements.Design and Developed Report Lay outs & created technical specifications for Reports.Build Framework Model using Framework Manager a Report Net Tool.Created Folders, Namespaces, Calculations &relationships using FM.Created Package published it onto Report Net Server,it appears on the Cognos Connection.Created List Reports, Standard Reports Charts, Cross tab Reports reports Using Report StudioCreated Value Prompt, Date Prompt, and Textbox Prompt to filter the data.By doing calculations & filters in model, Improve the performance of the reports.Implemented various levels of security like data security, metadata security.Used Scheduler to schedule the reports for Distribution Daily, Weekly, Monthly, and YearlyCreated analytical reports using Analysis StudioUsed Event Studio to send events to the business usersWrote the design documentation, report documentation.Provided necessary support to the business users during UAT and after implementation.Involved in administration of servers using Cognos connection in Report NetCreation of User Classes, users and changing their profileEnvironment: Cognos 8.1(Framework Manager, Query Studio, Report Studio, Cognos Connection, Cognos Configuration, Event Studio, Analysis Studio),Report Net 1.1, Excel, SQL, Oracle 9i, TOAD 7.0, Control-M, Windows NT, Windows 2000 Professional, UNIXHewitt Associates, Chicago, IL Aug05 to Dec05Vision Track ReportsSr Cognos& Report Net DeveloperHewitt Associates is a global human resources outsourcing and consulting firm delivering a complete range of integrated Services to help companies manage their total HR and employee costs, enhance HR services.Roles & Responsibilities:Upgraded the Catalogs, Reports from Impromptu 7.0 to Impromptu 7.3.Converted the IWR Reports, Models, and Cubes into Cognos version 7.3.Published Impromptu Web Reports(IWR) and Power Play cubes & reports onto the UpfrontUsing Cognos IWR administration as well as Power Play Enterprise ServerMaintain the Cube Security by Category level and Dimension levelWrote Unit Test Plans for Reports, IWR Reports, Models and Cubes.Involved in the Report Net design and Development.Developed List Reports, Chart, Cross tab, Drill through Reports, Master Detail ReportsUsing Report Studio.Created Complex Reports with multiple prompts, cascading prompts, conditional formatting and calculated columns.Created Value Prompts, Date &Time Prompts to filter the data.Extensively Worked on Report Net Administration ToolsUsing Scheduler Schedule, the reports Daily, Monthly, Yearly.As a Team member responsible for daily activities of other Cognos developers, and providingDaily, weekly updates to Project Manager.Environment: Cognos Report Net 1.1 (Framework Manager, Query Studio, Report Studio, Cognos Connection), Impromptu 7.3/7.0, Impromptu Web reports (IWR)7.3/7.0, Power Play 7.3/7.0, Power Play Transformer 7.3/7.0, SQL, DB2 UDB, UltiPro HR, SQL Server 2000,TOAD, PeopleSoft HR, Sun Solaris, Windows XP Professional.Cigna Health Insurance, Bloomfield, CT July04 to Aug05Report Net DeveloperCigna is a health benefits company providing health, life, accident, disability, and other employee and wellness benefits. Developed reports for their business needs..Roles & Responsibilities:Gathered Business requirements from end-users.Wrote Technical Specifications for Reports.Build model using Framework Manager a Report Net Tool.Creating Query Prompts, Calculations, Conditions & Filters.Created Package published it onto Cognos Connection Portal.Developing Standard Reports Charts, Cross tab, Drill through Reports, Bursting Reports UsingReport Studio.Created multiple page and multiple frames within a single Report for Dashboard Style Reports.By doing calculations & filters in model, Improve the performance of the reports.Implemented various levels of security like data security, metadata security.Using Scheduler Schedule, the reports Daily, Monthly, Yearly.Environment: Cognos Report Net 1.1 (Framework Manager, Query Studio, Report Studio, Cognos Connection), Excel, SQL, Oracle 9i, SQL Server 2000, TOAD 7.0, Windows NT.Avery Dennison, Concord, OH Nov03 to Jun04Worldwide SalesSr Architect/Sr. Report DeveloperAvery Dennison is a manufactured company of office supplies, Fashion brand self-adhesive products, postage stamps, labels. They have business sites all over the World, and we developed Reports, Cubes for Worldwide Sales.Roles & Responsibilities:Interacted with end-users and functional analysts to collect the business requirements.Created Catalog in Impromptu Administrator to create Reports.Created list reports and cross tab reports and drill through reportsCreated various Drill through reports from report to reportCreated User Classes and Users in Access manager.Created Cubes by using Cognos Power Play to analysis.Worked on Cognos Security Administration to restrict the Users.Created Models by using Impromptu Query Definition (IQD) in Power Play Transformer.Created dimensions, levels and hierarchies.Used Power Play Enterprise Server to publish the cubes.Published Impromptu reports to Upfront by using IWR Server.Maintain the Cube Security by Category level and Dimension level.Used Cognos Scheduler to schedule the ReportsUpdated Impromptu Catalog by adding tables and creating new joins.Good working knowledge in Unit/ |
