Naresh Bandaru
: + 91- 9059295480
Email ID: naresh10bi@gmail.com
A challenging position to prove my credentials and showc...
 Experience working on various databases: Oracle, MS SQL Server, Flat files, XML, DB2, MS
Access.
 Experience in Qlik Vi...
upload Patient demographic/Accounts information into the Database using the business rules provided by
the clients. Client...
 Monitoring the Scheduled Cubes in upfront, raising the PR’s based on the requests from the
Business and Updating PRs in ...
Project #3 – Wings & Co., Inc.
Environment : Cognos 8.4, Cognos Power Play Transformation7.4,
Windows Server 2008, Oracle ...
Project #5 – CIT (Commercial Investment Trust).
Environment : Cognos 8.3, Windows Server 2008, Oracle 10g,
Role : Cognos R...
Project #5 – CIT (Commercial Investment Trust).
Environment : Cognos 8.3, Windows Server 2008, Oracle 10g,
Role : Cognos R...
of 7

naresh10bi-cts

Published on: Mar 3, 2016
Source: www.slideshare.net


Transcripts - naresh10bi-cts

  • 1. Naresh Bandaru : + 91- 9059295480 Email ID: naresh10bi@gmail.com A challenging position to prove my credentials and showcase the skills I have developed so far, thus leading to the development of the organization as well as the society at large. Seeking a position in IT and BI where I can apply my experience and expertise in Infrastructure design and build including Business Intelligences. I have a high desire to apply my extensive knowledge across Cognos areas Report Studio, Event Studio, and Analysis Studio.  7 years of experience in providing services in Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools.  Experience in handling Data Warehousing and Business Intelligence (BI) Tools like Tableau, Sisense ,Cognos 10 BI& 8 Suite (8.X), Framework Manager, Impromptu, Power Play, Transformer, Impromptu Report Administrator, Impromptu Web Reports (IWR).  Expertise in Full Life Cycle Development of a Data warehousing project.  Knowledge in Installation of the Cognos 10, Cognos 8 and TM1 Server and setting Security.  Expertise in designing DMR and Relational models using star and snowflake schema.  Solid understanding of data warehousing OLTP and OLAP Concepts.  Having Good knowledge and Experience on Sisence Elasticube Manager, Elasticube Server.  Expertise in designing Widgets, Dashboards, Elasticubes  Have good experience in Developing Secured Models in Framework Manager and Publishing Secured Packages on to the Cognos Connection.  Expertise in Cognos 10 Query Studio, Report Studio, Analysis Studio and Cognos Connection.  Designing, Developing interactive Tableau Dashboard reports.  Developing reports and dashboards with multiple data sources.  Having Good knowledge in Publishing Dashboards to the server.  Experience in creating Filters, quick filters, table calculations, and Parameters.  Worked on Dual Axis concept while working with reports.  Created Filters, Groups, Sets on Tableau Reports  Generated List Reports, Cross Tab Reports, Charts and drill through reports in Cognos 10 BI.  Expertise in developing Dashboards using Cognos 10 BI Suite.  Applied conditional formatting, conditional blocks, and different kinds of prompt for different functionalities in the reports.  Expertise in using Parameter maps, Macros and setting Governors on Framework Manager.  Expertise in Upgrade/Migration from Cognos 7 to Cognos 8 versions.  Created new jobs in Cognos Connection for scheduling a group of reports.  Knowledge in deploying the reports from development server to Testing and Testing to Production environment using Content Administration.  Provided Production support by checking the integrity of the reports in the production support.  Worked in Airlines, Insurance, Banking and Pharmaceutical domains. Career Summary and SkillsCareer Summary and Skills Cognos KnowledgeCognos Knowledge ObjectiveObjective
  • 2.  Experience working on various databases: Oracle, MS SQL Server, Flat files, XML, DB2, MS Access.  Experience in Qlik View and Tableau tools  Excellent problem solving ability coupled with good communication skills to interact with end- users, customers, and team members. Operating Systems BI Tools Data Base Win NT/ 9.x/2000/XP Professional/Windows Server 2003, EXCEL 97/2000. Cognos 10.x,8.x, Cognos EP Series 7.3/7.4, Cognos Impromptu, Cognos Power play, Power Play Transformer, Tableau ,Sisence 5.8X Oracle 8i/9i/10g, Teradata MS Access2000, SQL Server 2005,2008 Nov 2011- Till date • Organization : Sutherland Global Services, Hyderabad • Total Experience : 3.8 years • Designation : Principle Software Engineer Oct 2010 – Oct2011 • Organization : Mahindra Satyam , Hyderabad • Total Experience : 1.2 years • Designation : Sr. Software Engineer Mar 2008 – Sep 2010: • Organization : Spry India, Hyderabad • Total Experience : 2.2 years • Designation : Software Engineer Professional Profile: • Client appreciation from Sutherland Global Services • Star Performer award during financial year 2012-2013 Project #1 – RCMS (Revenue Cycle Management System) Environment : Cognos 10.x, Tableau, Windows Server 2008, Sql Server 2008. Role : Cognos Report Developer Team Size : 7 Duration : 11/2011 to Till Date Description: RCMS Database contains Accounts Information (Including Payments and Adjustments), Patient Demographic information, Patient Insurance Information and Accounts Insurance Information. We have to Professional ProfileProfessional Profile AwardsAwards Professional ExperienceProfessional Experience
  • 3. upload Patient demographic/Accounts information into the Database using the business rules provided by the clients. Clients are the hospitals where we get the data and process as per the request. The processed data will be stored in the MS Access database file. And this MS Access database file data will be loaded into SQL server 2005 using SSIS. HTML, Excel & PDF Reports generated using Cognos report Studio and Dashboard we used Tableau. Responsibilities:  Familiar with Installation, configuration, patching and upgrading of Tableau tool across the environment  Involved in analyzing source systems and business requirements needed for reports development  Involved & discussed with Client to finalize Cognos reports development approach  Generated various kinds of reports (List, Cross tab, Drill Through, Master Detail,) using Report Studio and we implemented few Active reports.  Interacting with the Onsite team and Customer for providing day to day updates.  Create Dash board reports and cubes as well as cube based reports  Created Pie charts, bar charts for graphical representation of the business  Worked on scheduling the reports on Daily, Monthly& Quarterly basis using Cognos connection.  Developed Conditional Formatting, Conditional Block Using String, Boolean variables  Sorting, Ranking, Conditional Formatting, Created Cascade Prompts  Implemented data blending advanced visualizations in Tableau.  Worked on Dual Axes, Individual Axes, and Blended Axes concepts while working with reports.  Generated Dashboard with Quick Filters, Parameters and Sets.  Good knowledge on Tableau Metadata tables  Designed and developed multi-dimensional cubes.  Created FM Model and assigned relationships as per the business requirements Project # 2 - Qantas Airlines, Australia. Environment : Cognos 8.4, Cognos Power Play Transformation7.4/7.3,Windows XP, Oracle 10g, Teradata Sql Server 2005. Role : Cognos Report Developer Team Size : 12 Duration : 11/2010 to 11/2011 Description: Qantas Data Warehouse supports Business Analysis and Decision-Making by integrating data from multiple disparate systems. The business segments and primary business areas affected by this proposal include Airports, Australian Air Express, Catering, Customer Care, Engineering, Finance, Flight Operations, Freight, Frequent Flyer, Fuel Operations, In-flight Services, Load Control, Payroll, Property, Regional Airlines, Safety, Sales & Marketing, Schedule Planning, and Transport Contribution. Roles and Responsibilities:  Developing the reports based on the change requests from the Business for applications.  Testing the Report with Backend database.  Resolving the Production Issues for Various COGNOS Applications in Cognos 8 production and replying to the user on Issues.  Interacting with the Onsite team and Customer for providing day to day updates.  Validating the application data with the BI cubes.  Providing access to the users based on the requirements.
  • 4.  Monitoring the Scheduled Cubes in upfront, raising the PR’s based on the requests from the Business and Updating PRs in the ESM Ticketing Tool.  Generated various kinds of reports (List, Cross tab, Drill Through, Master Detail,) in Report Net using Report Studio.  Created Pie charts, bar charts for graphical representation of the business  Worked on scheduling the reports on Daily, Monthly& Quarterly basis using cognos connection.  Worked on Bursting reports using the available options in Report studio and cognos
  • 5. Project #3 – Wings & Co., Inc. Environment : Cognos 8.4, Cognos Power Play Transformation7.4, Windows Server 2008, Oracle 10g, Role : Cognos Report Developer Team Size : 9 Duration : 09/2009 to 10/2010 Description: Wings & Co., Inc is a global research-driven pharmaceutical company dedicated to putting patients first. Wings discover, develop, manufactures and market vaccines and medicines to address unmet medical needs. The project is designed to know the sales and distribution of the Products manufactured by the Company. Wings provide an application to report the sales in different units. The reporting application will be powered by Cognos to provide analytical reporting. The reports are used to analyze the sales and profits. Roles and Responsibilities:  Generated various kinds of reports (List, Cross tab, Drill Through, Master Detail,) in Report Net using Report Studio.  Created Pie charts, bar charts for graphical representation of the business  Worked on scheduling the reports on Daily, Monthly& Quarterly basis using cognos connection.  Worked on Bursting reports using the available options in Report studio and cognos connection  Created FM Model and assigned relationships as per the business requirements. Project #4 – Canadian Imperial Bank Ltd. Environment : Cognos 8.4, Cognos Power Play Transformation7.4, Windows Server 2005, Oracle 10g, Role : Cognos Report Developer Team Size : 5 Duration : 11/2008 to 08/2009 Description: This project is involved in the development of data warehouse for CIBL based on different kinds of functional areas such as Accounts and Loans. In CIBL loans have loan amounts for various purposes like Personal Loan, Educational Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans, etc. The company requires different level of analysis regarding loan amount, type of Loans, customers, payment schedules, interest rates, defaulters list and the penal interest calculations, etc. They needed a data warehouse so they could maintain historical data and central location for integration, Analyze Business in different locations. Responsibilities:  Extensively worked on understanding the business requirements and designing Cognos applications.  Involved in designing and creating the Model and Packages in Framework Manager  Developed Conditional Formatting, Conditional Block and Multilingual Reports Using String, Boolean and Language variables  Created List, Cross tab, Chart, Repeater Reports  Created Master-detail, Drill-through and complex reports in Report Studio.  Carried out Bursting of reports in Report Studio.
  • 6. Project #5 – CIT (Commercial Investment Trust). Environment : Cognos 8.3, Windows Server 2008, Oracle 10g, Role : Cognos Report Developer Team Size : 5 Duration : 04/2008 to 10/2008 Description: The project is for a Finance Company involved in disbursal of loan amounts for various purposes like: Personal Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans, Equipments Loan etc, company requires different level of analysis regarding loan amount, type of customers, type of payment schedules, interest rates (variable or fixed), defaulters list and the penal interest calculations, etc. The ETL part was completely done in Informatica and enterprise reporting was done with Cognos Report Studio. Roles and Responsibilities:  Built and Published the Packages to Cognos Report Net according to user requirements.  Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.  Worked on creating list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations, conditional highlighting.  Worked on creating Prompts and Cascading Prompts Pages.  Worked on securing Cognos Connection and setup Report Net security by assigning users to the groups and roles defined in Cognos Namespace. • MCA from Sri Venkateshwara University, Tirupati. • BCA from Sri Venkateswara University, Tirupati. Educational QualificationEducational Qualification
  • 7. Project #5 – CIT (Commercial Investment Trust). Environment : Cognos 8.3, Windows Server 2008, Oracle 10g, Role : Cognos Report Developer Team Size : 5 Duration : 04/2008 to 10/2008 Description: The project is for a Finance Company involved in disbursal of loan amounts for various purposes like: Personal Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans, Equipments Loan etc, company requires different level of analysis regarding loan amount, type of customers, type of payment schedules, interest rates (variable or fixed), defaulters list and the penal interest calculations, etc. The ETL part was completely done in Informatica and enterprise reporting was done with Cognos Report Studio. Roles and Responsibilities:  Built and Published the Packages to Cognos Report Net according to user requirements.  Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.  Worked on creating list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations, conditional highlighting.  Worked on creating Prompts and Cascading Prompts Pages.  Worked on securing Cognos Connection and setup Report Net security by assigning users to the groups and roles defined in Cognos Namespace. • MCA from Sri Venkateshwara University, Tirupati. • BCA from Sri Venkateswara University, Tirupati. Educational QualificationEducational Qualification

Related Documents