SUMMARY

• Certified Business Intelligence Consultant with knowledge in all phases of Software Development Life Cycle (SDLC) - Requirement Gathering, Design, development, administration, security management and production support on various platforms like UNIX, Windows NT/2000/XP/9
• Worked extensively in developing and implementing report solutions on SAP Business Objects 4.x/3.1/XIR2/6.5, Crystal Reports 2011/2008/XI, Information Design Tool 4.x/Universe Designer, Web Intelligence Rich Client, SAP Dashboards 4.x/Xcelsius, Explorer
• Expert in handling BW front-end tools like Query Designer, BEx Analyzer.
• Worked with SAP BI Modeling components like Info Cubes, DSOs,Info Sets,Multi Providers.
• Experience in Dimensional data modeling techniques, Star and Snowflake schemas.
• Experience in writing stored procedures, functions and cursors using PL/SQL programming.
• Experience in creating dashboards using SAP Dashboards 4.x/XCelsius.
• Working with data extraction, transformation and loading using SAP BusinessObjects Data Services 4.0 and Informatica Power Center 8.1.
• Experienced in gathering requirements from the end users, writing specifications and developing reports as per the needs of the client and documenting different stages of report development.
• Excellent communication, analytical and leadership skills.

TECHNICAL SKILLS

Reporting Tools: SAP Business Objects BI 4.1/4.0/XI 3.1/R2/6.5.1(CMC,Upgrade Management Tool, Desktop Intelligence, Designer, Web intelligence),BEx Query Designer, BEx Analyzer, Cognos8.0,SAP Design Studio, SAP BO Dashboards 4.x /XCelsius,Explorer,QAAWS,Live Office, Crystal Reports 2011/2008/ XI, Actuate 7.1/8.1,SSRS

RDBMS: Oracle 10g/9i, Teradata V2R4, SAP HANA 1.0, MS SQL Server 2012/2008/2005 , DB2 UDB v9.0

Languages: SQL, PL/SQL, T- SQL, UNIX Shell Scripting

ETL Tool: SAP BusinessObjects Data Services 4.0, Informatica Power Center 8.1

Operating Systems: Windows 7 / Windows 2003/NT/XP, UNIX

Other Tools: MS SharePoint, MS Visio, Visual Studio 2005, SAP R/3, SAP BW 7.3/7.0/3.5, Maximo 7.1.6, Erwin, TOAD, Rapid SQL

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SAP Business Objects/BW Lead

Environment: SAP Business Objects BI 4.1 SP5 /XI 3.1 SP4, SAP BW 7.x, Information Design Tool, BI Launch Pad, WebIntelligence, SAP Dashboards 4.1, SAP BusinessObjects Explorer 4.1,Analysis for Office and OLAP, Central Management Console (CMC), Promotion Management Tool, Upgrade Management Tool, Infoview,SQL Server 2012,T-SQL,Oracle 10g.

Responsibilities:

• Leading a team as part of SAP Business Objects 4.1 implementation and providing support in an offshore support model.
• Migrate content and users from SAP Business Objects 3.1 SP4 to SAP Business Objects 4.1 SP5 using Upgrade Management tool.
• Gathering, analyzing and documenting requirements from key stakeholders.
• Involved in providing estimates forimplementing BI solutions based on thescopeof the requirements.
• Create and maintain reports in WEBI 4.1 primarily using BEx queries as data source using BICS connectivity and relational data sources.
• Design and suggest best practices in universe development using Information Design Tool.
• Develop Information Spaces in SAP BusinessObjects Explorer 4.1.
• Build queries with variables,calculated/restricted Key Figures,conditions,exceptions etc.in BEx Analyzer
• Enhance performance of BEx queries by setting up aggregates, indexes and utilizing rollup, compression techniques.
• Involved in designing BW components like Infocubes, multiproviders, DSO etc.
• Create dashboards in SAP BusinessObjects Dashboards 4.1 usingQuery as Web Services andQuery Browser.
• Scheduling and publishing reports by creating publications, creating users and group, monitoring serversthrough Central Management Console.
• Performed installation of SAP BOBI 4.1 SP5 on development and POC servers and build the installation document accordingly.
• Knowledgeable in SAP BOBI 4.1 Single-Sign On setup against SAP BW (through STS) and Windows AD.
• Suggest best practices in design and performance enhancement of report and troubleshoot issues on needed basis.
• Developed training documentation and provided training sessions to end users.
• Delivered a POC on SAP BI 4.x Integration Option for Microsoft SharePoint .

Confidential, Tampa, FL

Sr. Business Objects Consultant/Analyst

Environment: SAP Business Objects BI 4.1/4.0/ XI 3.1, SAP BW 7.x, Information Design Tool, Desktop Intelligence, WebIntelligence,SAP Dashboards 4.0,SAP HANA, SAP Design Studio 1.2,Central Management Console (CMC),Upgrade Management Tool, Crystal Reports 2011/2008, XCelsius, Infoview, Maximo 7.1,SAP R/3, Actuate 7.1/8.1 SP2,SSRS 2008 R2, SAP BusinessObjects Data Services 4.0,SQL Server 2012/2008, Oracle 10g.

Responsibilities:

• Work with Business Managers and end users in analyzing requirements, lead Business Intelligence weekly review meetings and participate in technical design reviews to work towards an integrated solution.
• Design and Development of universes in Information Design Tool 4.0/UDT for cross-functional reporting.
• Designed and developed Universes on HANA views and reports as a POC for the client.
• Built information models (Attribute views, Analytic views, Calculation views etc.) in HANA Studio.
• Create reports in Web Intelligence 4.0 using BEx queries as the data source by setting up BICS connectivity.
• Actively participated in migration of universes and reports from BO XI 3.1 to SAP Business Objects BI 4.0.
• Worked with SAP BI Modeling components like Info Cubes, DSOs, Info Sets and Multi Providers.
• Designed queries in BEx Query Designer/SAP Design Studio and created work books using BEx Analyzer using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures
• Set up custom hierarchies and cascading prompts in the Universe to build drill down reports using scope of analysis in WEBI 4.0.
• Creating and maintaining aggregates, Indexes and utilizing Rollup, compression techniques to enhance performance of BEx queries.
• Performance tuning and optimization of Business objects Universes utilizing Index Awareness, Aggregate Awareness etc.
• Work closely with DBA/Data Modelers in tuning queries and stored procedures to enhance the performance of reports through explain plans and in the design of logical and physical data models.
• Handle Business Objects administrative tasks like scheduling and publishing reports, creating users and groups, defining roles and setting privilegesusing Central Management Console (CMC).
• Work with Dashboards 4.0/XCelsius to create scorecards using Query as Web Services and Live Office.
• Suggest best practices in report development and train end users in creating reports using Web Intelligence, Explorer, Analysis for Office and OLAP.
• Converted and enhanced reports from Cognos, SSRS to Web Intelligence and Crystal Reports.
• ExtractingDatafrom different sources like flat files, excel, SQL tables etc., and loading them into requested target flat files, excel sheets, SQL tables inDataIntegrator.
• Worked with various transformations like Query, Key Generation, Pivot, Map operation, Table Comparison, Hierarchy Flattening etc

Confidential, Madison, WI

Business Intelligence Specialist

Environment: Business Objects XIR2 (Designer, DeskI, WebIntelligence), SAP BW 3.5, Crystal Reports XI, XCelsius 2008 Business View Manager, CMC (Central Management Console), Infoview, Informatica Power Center 8.1, SAP R/3, Oracle 9i, SQL, TOAD.

Responsibilities:

• Designed and implemented end-to-end Business intelligence Reporting / Analytical Solutions.
• Actively participated in gathering and analyzing requirements from the Business Users for the reporting system.
• Built new universes and improved the performance of existing ones by utilizing @functions like aggregate awareness and index awareness.
• Designed reports in Desktop Intelligence and Web Intelligence based on multiple data providers leveraging functionalities like opendoc syntax, grouping/sectioning, cascading parameters
• Created parameterized reports using Crystal Reports using dynamic grouping, command objects, on demand sub reports for multi-dimensional analysis.
• Worked on Infocubes to build and publish BEx queries on the web for reporting requirements.
• Created complex SQL & stored procedures using reference cursor for reports using PL/SQL.
• Worked with Database Administrators and improved report performance drastically by fine-tuning SQL statements, building indexes, materialized views, hints
• Developed interactive models through gauges, dials and sliders in Crystal Xcelsius and embedded them inside Crystal Reports. Worked on Informatica Power Center 8.1 tools - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager.
• Created and modified mappings, mapplets and transformations using Designer and developed Informatica sessions as per Business requirements.
• Monitored Workflows and Sessions using Workflow Monitor and was involved in scheduling the Workflows using Autosys..
• Designed test cases based on the requirements, performed extensive unit testing and submitted reports to the Business Analysts for further assessment.
• Developed end user training documentation including reporting best practices and provided ongoing assistance and support.

Confidential, Chicago, IL

Business Intelligence Lead

Environment: Crystal Reports XI, Business View Manager, CMC (Central Management Console), Infoview, UDB DB2 v9.0, SQL Server2005, SQL, PL/SQL.

Responsibilities:

• Managed and lead a team responsible for delivering BI Reporting solutions to the business community.
• Provided estimates forimplementing BI solutions based on thescopeof the requirements and technical specification documents.
• Analyzed business requirements and built logical data models that describe all the data and relationships between the data.
• Created and modified reports using Crystal Reports XI and DB2/SQL Server as databases.
• Tested developed reports, published them on the web using Central Management Console (CMC).
• Created data connections, data foundations, business elements as part of building business views using Business View Manager.
• Migrated Crystal reports from DB2 to SQL Server.

Confidential, Franklin, WI

Sr. Business Intelligence Consultant/Analyst

Environment: Business Objects XIR2 (Reporter, Designer, CMC, Infoview), Performance Management, Dashboard XIR2, DB2 UDB v9.1, SQL Server 2005, Rapid SQL 7.3,SQL, PL/SQL, Actuate 7. 0, UNIX.

Responsibilities:

• Involved in requirements gathering from the business users for the reporting system.
• Created predefined conditions, prompts and custom hierarchies in the process of updating the universes as per the business requirements.
• Created attributes, filters and complex measure objects in the Universe
• Resolved issues like loops by creating aliases and contexts as required to remove the cyclic dependencies.
• Administered business users by grouping them and assigning privileges accordingly in CMC.
• Replicated existing Actuate reports in Business Objects Desktop Intelligence.
• Created dashboards using different analytics like Interactive Metric Trend, Speedometer, Rule Analytics, and Goal Analytics.