Summary:

• Result Oriented IT professional with over Seven 7 years of progressive expertise in analyzing the requirements, Application design, development, testing and a comprehensive background in Database development, Business Intelligence, OLAP and Data Warehousing.
• More than 7 of Business Intelligence experience using Business Objects Xir4.1,4.0/XIr3.1/Xir2/6.5/Xir, CMC, BO Designer, BO Reporter, Broadcast Agent, InfoView, Web Intelligence and Xcelsius.
• Job roles include gathering business requirements, establishing functional specifications, translating them to design specifications.
• Strong Data warehousing experience with SAP Business Objects, Web Intelligence, CMS Central Management Server , CMC Central Management Console , Import Wizard, Publisher, Broadcast Agent.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT dimensions tables, physical logical data modeling.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experienced in design and development of Complex Universes.
• Published Reports in Crystal Enterprise via. Crystal Publishing Wizard and Crystal Management Console. Experience in Scheduling the Reports using Crystal Enterprise.
• Expertise in gathering the business requirements and creating Universes in the Designer
• Experienced in Analyzing through MS Office by creating Cross Tab Navigation, Sorting and Filtering.
• Experience with creating hierarchies, predefined conditions, customized Lists of Values, Derived Tables and in using functions.
• Experienced in creating canned, ad-hoc and complex reports using SAP Business Objects.
• Experienced in the implementation and Migration of SAP Business Objects applications across different versions using Import Wizard.
• Extensively worked on CMS by creating users, Groups. Involved in Clustering with Xi 3.1 servers, Deciding cluster Scalability.
• Prepared Technical specifications for the development of Universes and Report.

EXPERIENCE SUMMARY:

Confidential

Job Title: Sr. BI/BO Developer/Consultant

Responsibilities:

• Involved in Complete life cycle of SAP Business Objects.
• Modified existing universes and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
• Appended and enhanced the Universe Meta layer in order to meet reporting requirements.
• Designing and customizing data models for Datawarehouse supporting data from multiple sources on real time.
• Extracted data from different flat files MS Excel,MS Access and transformated the data based on user requirements using Informatica Power Center and loaded into target, by scheduling the sessions.
• Worked closely with quality assurance and report implementation team members to successfully run unit tests, SIT tests and UAT testing.
• Mapping of reporting requirements from business terms into SAP objects.
• Created OLAP Universes using BO 4.0 4.1 Information designer tool/ Universe designer on top data extracted from database tables created/modified classes, objects, dimensions, measures and details.
• Created RDBMS universes using Universe designer.
• Created and edit queries and reports in BOBI BI Launch Pad for multidimensional analysis and trained users on drill-down, cross-tab, triggers, master detail, slicing and dicing, ad-hoc reports by Web Intelligence Webi , scheduling and publishing to BO Inbox, email, FTP, .. in multiple formats html, PDF,..
• Created Crystal Reports based on queries and universes.
• Provided training to BOBI BI end-users, Super users, team members.
• Worked on technical documentations.

Environment: SAP Business Objects 4.0,4.1, Crystal reports 2011 ,Informatica, Oracle 11g, Access, MS SQL Server.

Confidential

Job Title: Business Objects developer/Consultant

Responsibilities:

• Involved in Complete life cycle of SAP Business Objects.
• Requirements Gathering and Business Analysis.
• Responsible for Data Analysis and Requirements Collection.
• Research Sources and identify necessary Business Components for Analysis.
• Understand the business needs and implement the same into a functional database design.
• Used Use cases for documenting the functional specifications.
• Involved in Design, Analysis,Implementation,Testing and support of ETL processes for Stage,ODS, Mart Documentation.
• Extensively worked on Xcelsius 2008 for developing Dashboards for end users.
• Worked with end users to get Xcelsius dashboard requirements.
• Helped end customers to create Xcelsius Dashboards.
• Designed and implemented a data warehouse system Insight to capture the Sales and Marketing information like Calls, Samples, and Details. This system was used to Measure Sales force effectiveness and to plan sales and marketing strategies.
• Involved in creating Dimensions, Cubes and Fact tables.
• Gather, analyze and document business requirements, clarify business rules and data design requirements, functional requirements and data specifications for Business Objects universes and reports.
• Study the existing report application, to finalize the data elements required for reporting.
• Install and configure various components of BO XI 3.1 on Windows 2003 Server.
• Create users/groups and define privileges and access rights using Central Management Console.
• Design and develop universe in the designer, connection to the database, classes and objects, joins and predefined conditions.
• Created Aliases and Contexts for resolving Loops in the Universes to improve performance.
• Work with various types of joins such as inner-joins, outer-joins, equi-joins, theta-joins, defined cardinalities and resolved issues like loops and traps by creating aliases and contexts.
• Set object level and row level restrictions, to restrict sensitive client information to concerned departments only.
• Extensively used filters, conditions, list of values LOV , calculations, etc.
• Use functions like prompt for user defined queries , where for creating conditional filters , select to create duplicate objects in the process of building the universes.
• Perform Analysis with MS Office in latest SAP BO XI 4.0 through Voyager in creating Conditional Formating,Navigation etc.
• Create custom hierarchies while designing universe and making it available to end users through Web Intelligence.
• Leverage the Business Objects Universe Semantic Layer to make measures aggregate awareness. These changes substantially improved query performance.
• Create corporate dashboards to monitor the key metrics using Performance Management tools.
• Responsible for scheduling metrics, sets, analytics using Scheduler Interface.
• Responsible for creating real time alerts based on KPIs.
• Created various analytics such as Interactive Metric Trends, Gauges, metric list to display in dashboards.
• Used Analytics linking extensively between Analytics, webi reports by using prompts extensively.
• Worked and created analytics using Dimensioned metrics and secured them for Enterprise users.
• Use the drill down/up, slice and dice features to analyze data, set variables, alerts and group values in the reports.
• Generate various SAP Business Objects reports such as measure reports, change reports, highlight reports using drill down, slice and dice, cross tab, master detail etc.

Environment: SAP Business Objects Xir3.1,4.0,Web Intelligence, InfoView, DeskI, BO Designer, Crystal Xcelsius, Crystal reports, CMC, CCM,MS SQL,Oracle 11g/10g/9i, Windows 2003 server.

Confidential

Job Title: SAP Business Objects developer/Admin/Consultant

Responsibilities:

• Fulfilled the business objects development needs for various departments. And also performed the day to day admin tasks.
• Modified existing universes and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
• Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
• Handled various tickets for business objects issues for the end users.
• Involved in Design, Analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Performed Admin tasks like monitoring DB Services, monitoring BO server running with optimal performance, monitored licenses, monitoring of user activities/ sessions etc.
• Some daily admin tasks included verification of all BO user logins and security checks, testing the availability of all universe connections, Monitoring day to day scheduled jobs on Broadcast Agent BCA .
• Modified the default session timeout, for the infoview as the users complained about being session timeouts frequently.
• Handled BOBJ Administration tasks, to create new users and groups, handle password resets and assign security. Was involved in upgrading the service pack.
• Created a stable environment for Business Objects XI 3.1 by scaling the number of processing servers based on the user base and access frequency.
• Modified existing crystal reports and created new reports with cross tabs and sub reports based on the client requirements using Crystal Reports 2008.
• Designed complex reports based on discussions with user groups and created various objects using built-in functions like prompt, select, where, and aggregate ,complex report level filters and contexts and complex SQL queries and joins involving case statements, some analytic functions like partition by etc. Thus Considering best business Practices using Web intelligence Rich Client
• Scheduled Webi reports based on the requirement.
• Moved the developed webi, crystal reports and universes between development, QA and production environments using import wizard.
• Was involved in training the end users over the newly developed crystal and webi reports.

Environment: SAP Business Objects XI 3.1,3.2,4.0,Xcelsius 2008, Crystal Reports 2008, Web Intelligence,Oracle 11g, SQL Server 2008/2005.

Confidential

Job Title: SAP Business Objects developer/Consultant

Responsibilities:

• Analyzing system functionality requirements, documents and scope of the work.
• Work included Developing, Testing and enhancing existing Business Objects Universes work required modifying, testing and promoting to the Repository.
• Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements, Also solved any issues/errors encountered
• Responsibilities required acting as the Key Person for maintaining Universe's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data analysis etc.
• Have resolved Loops, Fan Traps and Chasm traps using context and alias and also have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
• Extracted Data from various sources like Data Files, Different customized tools like SQL and Oracle.
• Extensively worked on Views, Stored Procedures, Triggers and SQL queries and for loading the data staging to enhance and maintain the existing functionality.
• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerter and Formulae etc using Web intelligence.
• Scheduling daily, weekly and monthly reports using BO XI Scheduler using Events, creating Calendars. Upgraded BO XI R2 to BO XI R 3.0 Enterprise Environment. Used Java SDK's.
• Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Used Polestar for better interaction with predefined data sets to generate quick visualized reports
• Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts etc in Creating Reports, formatted old reports, generated charts, bars etc as per user requirements using Crystal Reports 2008, Xcelsius 2008 and integration as well.
• Designed interactive Dashboards such as Popup, Tabs etc and many creatively styled Xcelsius Reports.
• Manipulating data through various presentation styles using Crystal Reports 2008 such as charts cross tabs, slice and dice, user response, alerts, prompts, nested loops and filters.

Environment: SAP Business Objects XI 3.1,3.2,Xcelsius 2008, Crystal Reports 2008, Web Intelligence,Oracle 11g,SQL server.

Confidential

Job Title: SAP Business Objects Developer/Consultant

Responsibilities:

• Work included Universe Designing, Requirement Gathering, Setting up Joins, Cardinalities, and Solving Traps using Contexts and Aliases and Updating Universes based on additional Requirements etc Using Designer.
• Built new universes as per user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using aggregate aware function to create the summarized reports.
• Created reports containing all the information regarding the publishers, distributors and retailers using BOXIR2 and Crystal Reports XIR2.
• Worked on implementing the LOVs, hierarchies, pre-defined conditions, resolving database connections, adding new objects to the Universes.
• Created Business Objects reports using Formulas, Grouping, Parameters and Static/Dynamic Cascading Prompts to handle customers' requests from Tables, Stored Procedures, and Views.
• Responsible for creating the reports on demand, ad hoc reports, summary reports, sub reports, dynamic grouping, cross-tab, graphical, etc for business users using, Deski, Webi and Xcelsius 2008.
• Extracted Data from various sources like Data Files,Different customized tools like SQL and Oracle.
• Extensively worked on Views,Stored Procedures,Triggers and SQL queries and for loading the data staging to enhance and maintain the existing functionality
• Implemented security features of Business Objects like row level, object level and report level.
• Created complex reports using user-defined functions like variables, prompt, condition objects and aggregate awareness functions for SQL enhancement.
• Added, modified and positioned analytics and Webi reports in personal, corporate dashboards and in compound analytics.
• Created dashboards using Xcelsius and Live Office.
• Worked with Crystal Xcelsius for creating simple dashboards and simple crystal reports and convert those into user interfaces like Excel files, PowerPoint representations for better understanding.

Environment: SAP Business Objects XI 3.1,3.2,Xcelsius 2008, Crystal Reports 2008, Web Intelligence,Oracle 11g,SQL server.

Confidential

Job Title: BO/Crystal Reports Developer

Responsibilities:

• Implement the Use cases for new reports.
• Assist in planning, designing, and implementing of Reports.
• Implemented Crystal reports for standard reporting, Ad-hoc query and business users.
• Enhance the existing reports as per client requirements and business team.
• Advanced reports of varying complexity including slice and dice, drill down, cross tab, multiple table/section, and master detail type reports.
• Involved in requirements gathering and performed ETL Process.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates.
• Integrated various sources in to the Staging area in Data warehouse to Integrate and Cleansing data.
• Provide support to QA testing team to clarify changes and resolve testing issues or bugs.
• Follow-up with Client on various proposed initiatives.
• Implement the Database components Stored procedures .
• Alter the existing stored procedures as per Design team.
• Involved in the module testing, functional testing and integration testing.
• Meeting with programmers, test engineers and product management team to gain an understanding of the business requirements.
• Tested the reports thoroughly created by other developers, as per the report specifications.
• Written documentation for the newly created reports.
• Developed pie charts, bar graphs more understandable for top-level management using Analyzer in the reports.
• Estimate the timeframe to design the reports.
• Exported reports to document agent server to schedule and monitor reports. Created complex reports using multiple universes.
• Provided training for End Users and Super Users

Environment: SAP Business Objects Xir2/6.x,3.1,Crystal Reports 8.5/10, Crystal Enterprise 10, Oracle 10g/9i, PL/SQL, SQL Loader, SQL PLUS and Toad.