SUMMARY

• Over 7 years of IT experience in Design, Development, Implementation and Production Support for Business Applications using SAP Business Objects XI R 2/4.1/4.0/3.1 , Crystal Reports 10/XI.
• Experience in gathering business requirements in Manufacturing, Supply Chain and Financial domains by interacting with Business Users and translating them into technical specifications.
• Experience in SAP Business Objects R2/3.x/4.x suite ­ Web Intelligence, Dashboard Design Tool (SAP BO­BI 4.1/Xcelsius 2008 (Dashboard), Live Office, Information Design Tool (SAP BO­BI 4.0)/Universe Designer, BI Launch Pad (SAP BOBI 4.1)/InfoView.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drill Down, Filters, Ranking, Sections and Breaks.
• Expertise in designing, building and maintaining complex universes and resolving issues related to loops and traps by utilizing Alias and Context.
• Hands on experience creating Canned/ Ad­hoc Reports utilizing desktop intelligence and web intelligence, developing complex reports where data spans across multiple Universes and personal data files.
• Extensively worked in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated Fields, Sets, Groups, Parameters, Background Images etc.,
• Developed several complex Drill down reports, Linked reports, Sub reports and Parameterized reports with enhanced functionalities, charts, graphs, Cross Tab reports, Top N reports emphasizing critical business data.
• Knowledge of Data Warehousing and approaches like Star Schema, Snowflake modeling, Fact, Lookup and Dimension tables.
• Knowledge in ETL activities like Data Extraction, Loading, Data modeling
• Good experience in developing Crystal Reports using Crystal Reports 10/XI.
• Hands on experience migrating Business Objects from one environment to another.
• Experienced in Managing Servers, Repositories, Connections, Business Views and solving any Administration and Production issues that are escalated to the development team, to have minimal impact on delivery of new reports.
• Good Analytical Skills, Oral Communication skills and documentation skills.
• Good programming skills in SQL for developing cursors, stored procedures, functions, views and complex SQL queries.

TECHNICAL SKILLS

Reporting Tools: SAP Business Objects 4.1/4.0/XI3.1/XI3.0/XIR2, BI Launch Pad/Info View, Information Design Tool, Universe Designer, Web Intelligence, Web Intelligence Rich client, Desktop Intelligence, Crystal Reports 10/XI, Xcelsius 4.0/2008, QaaWS, CMC, Import WizardReport Conversion Tool, BEx Analyzer and BEx Query designer.

ETL Tools: BO Data Integrator(ETL), Data Services

Database: Teradata, Oracle 9i/10g, MS Access, SQL Server 2005/2008

Languages: HTML/ CSS, XML, Java, SQL, PL/SQL

Operating Systems: Microsoft Windows Server 2008/2003/XP/7, UNIX.

Other Tools: MS Office, TOAD, SQL Navigator, MS Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential, NC

SAP Business Object Consultant

Environment: SAP BO XI 4.1/3.1, Web Intelligence, Web Intelligence Rich Client, Universe Designer, Information Design Tool, Xcelsius 4.0/2008, SAP BW 7.x, BEX Suite, Teradata, Oracle, SQL Server 2008.

Responsibilities:

• Interacted with Project Manager & business users to understand the business needs, gather report specifications and modify Universe.
• Developed Business requirement documents, Technical specifications and Design documents.
• Created Custom LOV's (List of Values), Cascading LOV’s/Prompts, Hierarchies, Complex objects using various @functions and Aggregate Aware objects, derived tables, Universe Conditions etc., at Universe level.
• Web intelligence reports such as Crosstab Reports, Graphs, Complex Formulas and Variables, and Conditional Formatting, Master Detailed, Slice and Dice, Drilling methodology, prompts, Filters, Ranking, Section, Alerts and Breaks.
• Created Joins, Contexts, and Aliases for resolving loops and checked the integrity of the Universe.
• Implemented row level & object level security for different user, group requirements.
• Created complex reports by linking data from multiple data sources.
• Responsible for migrating Universe and reports from lower environment to production development to test to production.
• Involved in the regular meetings to understand the day to day work progress.
• Worked on pilots and mockups during the initial phase of the projects.
• Interfaced with DBA team to optimize report performance via database tuning.
• Work with security team to implement authorizations for BI reporting.

Confidential, GA

SAP BI Consultant

Environment: SAP BO XI 3.1, Web Intelligence, Web Intelligence Rich Client, Universe Designer, Xcelsius 2008, Qaaws, CMC, Import wizard.

Responsibilities:

• Actively involved with business users by working at the client location to gather new requirements, and made changes to fulfil the business needs
• Involved in creating the technical specs necessary for the report development, including universe.
• Implemented linking of complex universes based on different data sources.
• Created Custom LOV's (List of Values), Cascading Prompts, Hierarchies, Complex objects using various @functions and Aggregate Aware objects, derived tables, Universe Conditions at the Universe level.
• Designed and developed complex web intelligence reports using features like Multiple Data Providers, Alerts, Filters, Breaks, Merged Dimensions, Sorts and Query/Report Prompts, Cascading Prompts etc.,
• Designed dashboards using Xcelsius, QaaWS, and Live Office.
• Resolved several Universe problems (loops, fan traps and chasm traps) utilizing alias and contexts.
• Developed canned reports utilizing advanced Business Objects functionalities such as Ranks, Alerts, Filters, and Prompts.
• Resolved performance issue of reports by tuning SQL queries and stored procedures.
• Worked closely with the QA Team in testing the reports and the functionality in different environments.
• Involved in managing users, groups and folders using CMC, in exporting and scheduling of reports.

Confidential, NJ

Business Objects Consultant

Environment: SAP BO XI R2/3.x, Web Intelligence, Universe Designer, Xcelsius 2008, CMC, Import wizard, Oracle9i, SQL Server 2005.

Responsibilities:

• Worked with business users to gather new requirements to fulfil the business needs.
• Responsible for creation of the Universe Structure modeled from relational databases and create classes/objects/measures.
• Involved in creation of Desktop Intelligence and Web Intelligence Reports with different functionalities like cascading prompts, drill down, linking reports, charts and graphs, ranking, alerts etc.,
• Created interactive dashboards using Xcelsius.
• Expert in writing complex formulae at the summary level and group level to implement the business logic
• Was involved in the regular meetings to understand the day to day work progress.
• Worked on pilots and mockups to help understand the tools.
• Worked on Import wizard to migrate the reports to different instances.
• Tested the reports and the functionality in different environments.

Confidential, MN

BO Developer

Environment: Crystal Reports 10/XI, SAP BO 6.5/XI R2, Web Intelligence, Desk Intelligence, Universe Designer, Oracle 9i/10g and DB2.

Responsibilities:

• Gathered requirements from end users to create universes and reports.
• Built BO Universes utilizing designer module for end user adhoc report generation capabilities.
• Detected Joins and checked the Cardinalities.
• Resolved Universe problems such as loops and traps using alias and context.
• Developed custom hierarchies to support drill down reports.
• Created derived tables in designer to enhance capabilities and performance of universe.
• Created reports using desktop Intelligence functionalities like sections, breaks, filters, alerters, slice and dice, drill down functions and formulas etc.
• Used Business Objects free hand SQL to generate Adhoc reports.
• Created several adhoc reports on demand utilizing Web Intelligence.
• Created filters in dashboard according to the prompts using components (Filters, Combo box).
• Created Crystal Xcelsius dashboards using different chart types and tables.
• Verified and validate report functionality utilizing TOAD in the backend.