SUMMARY

• 9.5 Years of IT experience in Analysis, Design, Development, Testing, Implementation, Production and Maintenance in Data Warehousing, Business Intelligence and Software Applications.
• 7 years of Business Intelligence experience in Business Objects 4.1/4.0/ XI 3.0/XI R2 using different modules like CMC, Designer, WebI, DeskI, Infoview, Report Conversion Tool, Xcelsius and Import Wizard.
• Experience in Microsoft Reporting Services, Microsoft Analysis Services.
• Experience in Airline, Finance, Sales - Management, Insurance and Financial Domain.
• Experience in using various Data Providers like Universes, Stored Procedures, Free Hand SQL and Personal Data Files for retrieving Data.
• Experience in Designing/Developing Universes and Canned/Ad-hoc Reports using various Sources like Oracle, SQL Server, MS Access and Excel.
• Good hands on Experience in QlikView 10, 11, SQL Server, Oracle 10g, 11g.
• Created Simple, Complex and Ad-hoc Reports.
• Created reports using Desktop Intelligence and Web Intelligence
• Created various reports using Crystal Reports.
• Experience in Data Modeling using Erwin.
• Expertise in preparing report specifications, to support the reporting requirements.
• Design Universes for query, reporting, and analysis using BO Designer Module.
• Expertise in gathering, analyzing and documenting Business Requirements, Functional Requirements, System Test Cases and Use Cases, Performance Testing Requirements, and Data Specifications for Business Objects Universes and Reports.
• Experience in working with Operating Systems like Windows and Mac.
• Highly skilled, self-motivated, outstanding, excellent communication and interpersonal skills with result oriented dedication towards goals.
• Strong understanding of RDBMS and Data warehousing concepts. Knowledge in Data mart development, ER Modeling and Data-Flow Modeling.
• Extensively used Pl/sql and sql for report creation and testing the reports.
• Used stored procedures to create Crystal reports.
• Worked closely in UAT with Business owners in defect and problem handling.
• Involved in the training new BO XI and infoview users and webi report writers.
• Strong Experience in Software Development Life Cycle.
• Knowledge on SAP Lumira.

TECHNICAL SKILLS

Business Intelligence/ETL Tools: SAP Business Objects 4.1/4.0/XI 3.0/ XIR2, Web Intelligence XI R2, BI Launchpad, Infoview, CMC, DeskI, Crystal Reports Enterprise/2013/2008/XI R2, Xcelsius / SAP Dashboards, Congo’s, Impromptu 6.0, Power play, Power play transformer 6.0, Informatica 6.x. Microsoft Reporting Services, Microsoft Analysis Services, Microsoft Integration Services. Congo’s.

Data Modeling tool: Erwin 4.1/7.0

O/S: Windows 2008 R2/2003/2000/NT, Unix and DOS

Database: Oracle 11g/10g/9i, SQL Server 2008 R 2/2008/2005/2000, Teradata, MS Excel.

Programming: C, SQL, PL/SQL, HTML.

Dashboard Tools: Xcelsius, Corda, Qlikview, Tableau.

Web Technologies: HTML, Java Script, XML.

PROFESSIONAL EXPERIENCE

C onfidential, Iselin NJ

Sr. Business Objects Lead

Responsibilities:

• Interacted with Users and gathered Business Requirements. Mostly involved in making Changes to the existing Reports and updating the reports as per the Requirements.
• Involved in requirements study, design reviews and analysis of input/output flow.
• Reviewed User Requirements. Created detailed Functional Design Documents and Report design details documents for the reports.
• Responsible for analyzing business requirements and developing queries and reports using BO full client and info view to provide Web-enabled data analysis solutions to business clients.
• Responsible for day-to-day database and reporting problems.
• Handled production issues and tickets using Service Desk Tickets.
• Created various dashboards using Crystal Xcelsius
• Responsible for data analysis to clean up data that are not being used by any applications.
• Expert in data formatting and use of pivot table in Excel to analyze data.
• Resolved the Performance issues/Data issues within the Reports and Procedures.
• Involved in Creating store procedures in Oracle as part of performance tuning.
• Performed Administration tasks for the Project, Which Included Creating Folders, creating users/ Groups on Central Management Console and giving Appropriate Access levels.
• Created reports (Canned & Ad-hoc) based on the business requirements using Web Intelligence tools and database.
• Installation and Configuration of BO & Web Intelligence applications for different developers and users.
• Scheduled the Crystal reports & E-mail them to the necessary departments.
• Created customized existing reports using sub-reports and charts to represent information.
• Created the Crystal reports using Oracle DB tables and tested the reports by cross checking and verifying data against the reports generated from the legacy system.
• Created Webi Reports on top of Universe.
• Published the reports to the User Personal Folders in Info view.
• Created complex report using with Sub report, cross tab, custom functions, formulas and Suppressing conditions and Used advanced features like Dynamic and cascading Prompts.
• Created Graph and chart reports in Crystal Reports.
• Converted Actuate reports into Crystal Reports, Webi Reports.
• Developed Dashboards in Qlikview.

Environment: Business Objects 4.1/4.0, Crystal reports 2008; Crystal Reports Enterprise, Info View, Oracle and Sql Developer, Qlikview.

Confidential, Minneapolis, MN

Sr. Business Objects Consultant

Responsibilities:

• Having experience on handling various customers, Understand their requirements and involving in full product life cycle of the project.
• Interacting with the team and getting the work done from them.
• Worked on Converting Actuate Reports to True Analytics (Business Objects Crystal Reports).
• Involved in Development, Production Support, Migrations and BO Server Administration (CMC).
• Generating Sub Reports, Hyperlinks and Graph Reports by using chart expert of Crystal Reports and developed 100+ reports.
• Creating Users, Groups and Access Levels for Security by using Central Management Console (CMC).
• Creating Publications and publish all the reports developed from Crystal Reports to the end user.
• Extensively used Toad to verify if the data pulled by the report is correct and compared to the database data and also to verify if the joins used in query are correct.
• Worked on creating groups, formulas, filters and ranking in Business Objects Webi Reports.
• Developed Crystal Reports by using Stored Procedures etc.
• Created a backup of Crystal Reports in BIAR format by using Import Wizard.
• Interacted with Users and gathered requirements for the Reports.
• Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
• Crystal Reports design, development and Resolve the database connectivity issues.
• Designed, developed and maintained various Complex reports like Sub Reports, Detail Reports and Parameterized Reports, Cross tab.
• Monitored report executions and identified performance issues, worked with DWH SMEs / DBAs to identify root causes for potential database-related issues.
• Based on Requirement, Created complex crystal report using the data from SQL Server and Oracle server database.
• Tested the developed reports and created a report-promotion model for moving the reports in to the production environment.
• Responsible for improving report-processing performance.
• Responsible for Writing Stored Procedures in PL/SQL for better performance.
• Scheduled Reports from Crystal Enterprise enabled Email notification on failure reports.
• Converted all actuate reports into crystal reports.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Passed default values through xml for the parameters used in the report to eliminate the burden of entering parameter values.
• Responsible for preparing requirements, dependency scenarios documents for the reports.

Environment: Business Objects BOXIR3.0, Crystal reports 2008, Info View, Oracle and Toad.

Confidential

Sr. Business Objects Consultant

Responsibilities:

• Providing solution to the team on creating Mobile Apps on various phones such as iPhone, Samsung etc
• Developed SAP BW queries using BEx Query Designer for the reporting requirements in Operations Support, Human Resources, Accounting and Finance, Procurement and Inbound Logistics charters.
• Worked on creating SAP BW OLAP universes over BEx queries in Business Objects 3.1 Environment.
• Replicated/Migrated reports created in crystal reports to Business Objects.
• Created various dashboards using Crystal Xcelsius.
• Worked with the end users and Database developers to identify the critical data needs for reporting.
• Migrating Webi & Crystal Reports from Lower to higher versions and also universes from DEV to UAT & PROD env.
• Creating reports in Business Objects and Crystal reports
• Creating dashboards in Xcelsius and Corda.
• Interacting with the Onsite team for any clarifications when ever required and also responsible in taking the status calls with the on site for getting the requirement and the daily updates.
• Responsible for doing Unit testing and also responsible for sending weekly and daily status.

Environment: Business Objects XIR3.0, Business Objects Info View (Web I), Crystal Reports XI, BODI/DS, Crystal Xcelsius.

Confidential

Business Objects Consultant

Responsibilities:

• Involved planning, Requirement gathering and Testing Phases of Migration Process.
• Responsible for understanding the existing Actuate reports and replicating the same in Crystal Reports XI R2
• Interacting with the FT team for any clarifications when ever required and also responsible in taking the status call with the on site for getting the requirement and the daily updates.
• Responsible for doing Unit testing and also sending status email at the end of the day.
• Involved in performance tuning of Business Objects reports by tuning the SQL.
• Worked with Complex Queries as per the user requirements.
• Involved in designing and development of Security Model which was manually created in Central Management Console.
• Extensively tested the migrated and converted reports by validating the data and fixed the issues relating to them.
• Involved in Migration of Repositories from Development, Test and Production environment using import wizard.
• Created a backup of WEBI Reports and Universes in BIAR format using Import Wizard.
• Created training manuals for users and trained about the usage of Infoview in the BOXIR2 environment.

Environment: Business Objects BOXIR2 / R3.0, Business Objects Web I, Crystal reports, Info View Oracle 9i.

Confidential

Team Developer

Responsibilities:

• Involved in full project life cycle implementation (requirement gathering to production phase).
• Prepared the following - business/technical writing of requirements, design templates, development standards document and detailed design documents.
• Involved in extensive testing of universes and reports during version migration of business objects.
• Involved in performance tuning of Business Objects reports by tuning the SQL.
• Involved in the installation of Business Objects repository, creation of user Ids, implementation of security features and management of the repository.
• Extensively created Business Objects reports like matrix reports, tables, charts and pie charts.
• Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Responsible for writing SQL Queries and developing the reports.
• Responsible in taking the status call with the on site for getting the requirement and the daily updates.
• Responsible for doing Unit testing and also sending status email at the end of the day.
• Extensively used breaks for white spaces and sections for better navigation. And created template documents with header, footer and company logo.
• Created user groups and managed access privileges using Business Objects Supervisor.
• Responsible for managing the Business Objects repository.

Environment: Business Objects 6i, BOXIR2, Business Objects Web I, Crystal reports, Info View, Oracle 9i.

Confidential

Reporting Consultant

Responsibilities:

• Involved in providing the complete reporting solution and during the course of action have build cubes using Analysis services.
• Involved in planning, Requirement gathering, design, development, Testing and maintenance of Microsoft reporting environment.
• Creating stored procedures and developing reports on top of that.
• Deploying the reports into Share Point server for customized features.
• Doing unit testing of the reports, functionality checking and also the front end designing.
• Involved in SQL tuning for better performance while generating Ad-Hoc reports.
• Exposure and good understanding with the Supply chain management process.

Environment: SSRA, SQL Server DB, Windows XP

Confidential

Reporting Consultant

Responsibilities:

• Designing the Analysis Cube, developing reports and also doing Unit Testing for the reports. Used MDX querying as part of developing reports.
• Responsible for final UI related sanity check before delivering. Involved in providing the complete reporting solution and during the course of action have build cubes using Analysis services.
• Involved in planning, Requirement gathering, design, development, Testing and maintenance of Microsoft reporting environment.
• Creating stored procedures and developing reports on top of that.
• Deploying the reports into Share Point server for customized features.
• Doing unit testing of the reports, functionality checking and also the front end designing.
• Involved in SQL tuning for better performance while generating Ad-Hoc reports.
• Exposure and good understanding with the Supply chain management process.

Environment: SSAS, SSRS, SSIS, SQL Server DB, Windows XP

Confidential

Reporting Consultant

Responsibilities:

• Involved in providing the complete reporting solution and during the course of action have build cubes using Analysis services.
• Involved in planning, Requirement gathering, design, development, Testing and maintenance of Microsoft reporting environment.
• Involved in creating various reports such as List, Crossed Tab, Drill Through, and Chart Reports.
• End user interaction for requirements and status call.
• Involved in doing the Unit Testing and Peer Review for the reports developed.

Environment: SSAS, SSRS, SSIS, SQL Server DB, Windows XP

Confidential

Reporting Consultant

Responsibilities:

• Integrating and setting up the databases in SQL Server from excel through SSIS.
• Involved in creation of cubes in SSAS and creating of the reports from in the SSRS based on the cubes developed.
• Involved in creating various reports such as tabular, matrix, sub-reports. Interacting with the Client for the requirement gathering