Aravind Kellampalli Email & Phone Number

Interacting with Client to gather business requirements. • Created Drill- through reports, Master detail reports.• Design, development and bug fixing of reports as per the requirement needs.• Creating Do nut reports, Pie charts and Guage charts.• Formatting the reports as per the user requirements using conditional formatting.• Doing unit testing and Report Validation based on the report requirement specification.• Actively involved in all phases of SDLC of the project.• Scheduling the reports based on specified date and time according to end user requirement.• Prepared documents like User Manuals, training documents. • Checked the reports for data accuracy.

Interacting with Client to gather business requirements. • Created Drill- through reports, Master detail reports.• Design, development and bug fixing of reports as per the requirement needs.• Creating Do nut reports, Pie charts and Guage charts.• Formatting the reports as per the user requirements using conditional formatting.• Doing unit testing and Report Validation based on the report requirement specification.• Actively involved in all phases of SDLC of the project.• Scheduling the reports based on specified date and time according to end user requirement.• Prepared documents like User Manuals, training documents. • Checked the reports for data accuracy.

Interacting with Client to gather business requirements. • Created Drill- through reports, Master detail reports.• Design, development and bug fixing of reports as per the requirement needs.• Creating Do nut reports, Pie charts and Guage charts.• Formatting the reports as per the user requirements using conditional formatting.• Doing unit testing and Report Validation based on the report requirement specification.• Actively involved in all phases of SDLC of the project.• Scheduling the reports based on specified date and time according to end user requirement.• Prepared documents like User Manuals, training documents. • Checked the reports for data accuracy.

Environment : Sql Server, Cognos 8.4 Report Studio, Query Studio, Analysis Studio, SSIS (ETL) Database : SQL Server 2008; Since 1997, The Endurance International Groups has been a leading provider of shared web site hosting and other online services to individuals and small-to medium sized business. Project Involved creating data mart for sales, marketing, Finance for sales, marketing, and Finance reporting. Designed high level ETL and star schema so as the whole system architecture supported the business requirement. Solution involved conversion of reporting based on Perl Script reports to Cognos 8BI. Creating a sales, marketing and finance report in Cognos 8BI according to the business requirement. As a leading provider of hosting services and online solutions, Endurance International serves close to 1.8 million customers through 25 distinct hosting brands. The diversity of our brands enables us to target a broad range of customers, allows us to provide a customized experience for each customer. Roles & Responsibilities: Interacting with Client to gather business requirements. Created Drill- through reports, Master detail reports. Design, development and bug fixing of reports as per the requirement needs. Creating Do nut reports, Pie charts and Guage charts. Formatting the reports as per the user requirements using conditional formatting. Doing unit testing and Report Validation based on the report requirement specification. Actively involved in all phases of SDLC of the project. Scheduling the reports based on specified date and time according to end user requirement. Prepared documents like User Manuals, training documents. Checked the reports for data accuracy. Involving in SSIS and writing SQL Queries. Software Used : Cognos 8.4, Sql server 2008, SSIS

Interacting with Client to gather business requirements. • Created Drill- through reports, Master detail reports.• Design, development and bug fixing of reports as per the requirement needs.• Creating Do nut reports, Pie charts and Guage charts.• Formatting the reports as per the user requirements using conditional formatting.• Doing unit testing and Report Validation based on the report requirement specification.• Actively involved in all phases of SDLC of the project.• Scheduling the reports based on specified date and time according to end user requirement.• Prepared documents like User Manuals, training documents. • Checked the reports for data accuracy.

Environment : Sql Server, Cognos 8.4 Report Studio, Query Studio, SIS (ETL) Database : SQL Server 2005; ITIL advocates that IT services must be aligned to the needs of the business and underpin the core business processes. It provides guidance to organizations on how to use IT as a tool to facilitate business change, transformation and growth. The ITIL best practices are currently detailed within five core publications which provide a systematic and professional approach to the management of IT services, enabling organizations to deliver appropriate services and continually ensure they are meeting business goals and delivering benefits. The five core guides map the entire ITIL Service Life cycle, beginning with the identification of customer needs and drivers of IT requirements, through to the design and implementation of the service into operation and finally, on to the monitoring and improvement phase of the service. Roles & Responsibilities: Create Database and Done ETL work for creating Meta data. Involved in writing SQL Queries and SSIS. Involved in analysis and development of Meta data. Involved in analysis and development of reports. Formatted the reports as per the user's requirements, which allows the users to analyze the data. Designing Drill through reports in Analysis studio and Report Studio as per requirement. Design different charts to the reports. Created reports with various types of filters and prompts. Actively involved in all phases of SDLC of the project. Checked the reports for data accuracy. Performed unit testing on the designed reports. Software Used: Cognos 8.4, Sql server 2005, SSIS

Interacting with Client to gather business requirements. • Created Drill- through reports, Master detail reports.• Design, development and bug fixing of reports as per the requirement needs.• Creating Do nut reports, Pie charts and Guage charts.• Formatting the reports as per the user requirements using conditional formatting.• Doing unit testing and Report Validation based on the report requirement specification.• Actively involved in all phases of SDLC of the project.• Scheduling the reports based on specified date and time according to end user requirement.• Prepared documents like User Manuals, training documents. • Checked the reports for data accuracy.

Environment : Sql Server, Cognos 8.3 Report Studio, Analysis Studio, Query Studio, SSIS Database : SQL Server 2005 Description; Business intelligence (BI) practice covers decision support systems, query and reporting, online analytical processing, statistical analysis, forecasting, and data mining - solutions that help transform vast quantities of information into timely, fact-based and actionable knowledge that positively impact on business strategies, tactics and operations. Roles & Responsibilities: Installed and configured Cognos in the Development and production serversCollecting requirements for report development & preparing the Gap analysis documents Creating & publishing the packages according to the business requirements Creating list reports, cross tab reports, Charts, Master Detail reports & Drill through reports by using Report studio Creating filters, variables and applying conditional style, text for highlighting the specific dataFormatting the reports using layout component reference and Classes.Creating reports by using Query calculations and Layout calculations. Developing Prompt pages and Conditional Variables Creating CM, LM, LYCM, YTD, LYTD & WTD based reportsCreating value prompts, Date & time prompts, cascading prompts and Tree prompts Involved in deployment of the reports Involved in performance tuning of the Reports Involved in the Testing of the reports and preparing the Test cases.Software Used: Cognos 8.3, Sql server 2005, SSIS

2009, Mca, A

M.C.A, 78