SUMMARY

• BI Consultant with 10 years of experience in the analysis, design, development, testing, implementation, production, and maintenance of Business Intelligence and Data Warehousing Solutions
• Experience in SAP Business Intelligence and Microsoft Business Intelligence solutions.
• Expertise in Business Objects 4.1/4.0/ XI 3.0/XI R2, SAP Lumira.
• Experience in Crystal Reports in all versions (Enterprise/ 2013/2011/2008 , XI R2).
• 2 Years of experience in Qlikview and Tableau Desktop.
• Experience in Microsoft BI Tools like (SQL Reporting Services, SQL Analysis Services & SQL Integration Services.
• Experience in Airline, Finance, Sales - Management, Insurance and Financial Domain.
• Experience in various databases like Microsoft SQL Server, Oracle 11g/10g, 9i, 8i and Teradata.
• Interacting with Business Users and understanding their requirements and creating Functional specification and Technical documents and getting the sign offs.
• Responsible of creating Unit Test, Peer review, Performance Testing documents.
• 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.
• Excellent team player, flexible and quick learner with a problem solving attitude. Ability to analyze inputs and devise strategy based on best practices and future supportability..
• Strong understanding of RDBMS and Data warehousing concepts. Knowledge in Data mart development, ER Modelling and Dimensional Modelling.
• Solid Understanding of Extraction, Transformation and loading (ETL) process.
• Customized BO User security in CMC (Central Management Console) and created robust security model for various customers based on their requirement.
• Worked closely in UAT with Business owners in defect and problem handling.
• Trained End users on BI Launchpad and Crystal Report.
• Guiding/Mentoring team members.
• Strong Experience in Software Development Life Cycle (Agile and Waterfall Models).
• Good Knowledge on SAP HANA, Microsoft Power BI.
• Good Knowledge on SQL Integration Services and SAP BO Data Services.
• Good Knowledge on Big Data Tools like Hive and Pig.
• Used Microsoft Source Safe, SVN for version control.
• Experience in handling Production Support tickets and resolving the tickets with in the SLA’s defined.
• Strong communication skills and ability to work in a team and individually.

TECHNICAL SKILLS

Business Intelligence: SAP BI (BO 4.1/4.0/XI 3.0/ XIR2). Web Intelligence / Interactive Analysis. BI Launchpad/Info view.Universes (IDT & UDT).Crystal Reports Enterprise/ 2013/2011/2008 , XIR2. Xcelsius /Dashboard Designer. Central Management Console (CMC).

Microsoft BI: SQL Reporting Services. SQL Analysis Services.

IBM COGNOS.: SAP HANA HANA Studio

ETL Tools: SQL Integration Services. SAP BO Data Services.

Data Visualization Tools: SAP Lumira.Qlikview. Tableau Desktop. Microsoft Power BI. ROAMBI.

Data Modeling tool: Erwin 4.1/7.0

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

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

Dashboard Tools: Xcelsius Corda.

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

Web Technologies: HTML, Java Script, XML.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

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.
• Responsible of creating Universe based on the requirements and also doing enhancements if required.
• 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.
• Integrating the Crystal reports and WebI into the company Portal and implemented security tokens for each user.
• 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.
• Migrating Webi reports from BO 3.1v to BO4.1v.
• Scheduled the Crystal reports & E-mail them to the necessary departments.
• Interacting with diversified teams such as ETL and Support teams to make sure everyone in line with the requirements and their roles in successful completion of the project.
• 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.
• Created Dashboards and User Stories using SAP Lumira.
• Developed SAP Lumira dashboards using HANA Analytical views.
• Designed & developed Qlikview dashboards for HR & Global Commissions business groups.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Implemented security (Document Level, Sheet Level, and Object Level) using QlikView section access
• Extensively Used Advanced Aggregations and Used Set Analysis.

Environment: Business Objects 3.1/4.1,Business Objects Data Services, Crystal Reports Enterprise/2008, 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.
• Involved in Universe enhancements based on the requirements.
• Creating Users, Groups and Access Levels for Security by using Central Management Console (CMC).
• Integrated Crystal reports into the Company website and created Security Tokens.
• 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.
• Interacting with ETL Team and getting the required things as per the requirement. Also monitoring and involving in ETL development activities whenever required.

Environment: Business Objects XI 3.1, BODS, 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 whenever required and also responsible in taking the status calls with the onsite for getting the requirement and the daily updates.
• Responsible for doing Unit testing and also responsible for sending weekly and daily status.
• Monitoring BODS workflows and making sure everything is working as expected.

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 whenever required and also responsible in taking the status call with the onsite 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 built 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: SSRS, 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 built 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 built 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