Summary

• Over 8 years of experience in IT industry covering Development, Analysis, Design, Testing and System Maintenance of Business Intelligence based applications.
• Excellent Experience working on Business Objects 4.0, Releases XI R2/3.1/4.0 SP2, SP4 and SP5 CMC, CCM, CMS, LCM, Promotion Management, Information Designer tool, Business Intelligence Consumer Services BICS , Universe Design Unv and Unx , Web Intelligence 4.0, Business Intelligence Web Services BIWS , Report Conversion Tool, Crystal Reports 2001, Dashboard Design using Xcelsius, Live Office, Query As a Web Service QaaWS , SAP Business Objects Explorer, Good understanding of BEX.
• Expertise in Business Explorer Suite - BEx Query Designer, BEx Analyzer and BEx Web Analyzer.
• Strong work experience in Dimensional Modeling, and designing Star and Snowflake Schemas, Fact and Dimension tables.
• Experience in using Information design tool IDT to create universes using multiple Data Sources.
• Experience in Designing/Developing Universes/Data-Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports.
• Excellent skills to develop reports using Web Intelligence Rich Client 4.0.
• Expertise in creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries.
• Knowledge on Dashboard Designer Components like Charts, Selectors Filters, label Based menus , Tab Sets, Canvas Containers.
• Proficient in Business Objects Reporting using Crystal Reports, WEBI Rich Client 4.0, Live Office and Xcelsius for both SAP and Non SAP sources.
• Strong knowledge In creating connections using Data Connection manager like Query Bowser, Live Office, Query As A Web Service QAAWS , Flash Variables, SAP BI connectors, UD connecters, DB connectors.
• Strong experience as Business Objects Administrator including installation, configuration of BO tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.
• Experience in CMC Administration activities like creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server.
• Worked on migration of the Business Objects from lower versions to XI R2, 3.0, 3.1, 4.0.
• Worked on Business Objects with Databases like SQL Server 2000/2005, Oracle, Sybase, flat files, Teradata and DB2.
• Experience with Promotion Manager using CTS in migrating universes, reports and Dashboards from Dev to Test, UAT and Production environments.
• Creation of BEx queries on BI 7.0, 3.5 Reporting .
• Knowledge on SAP HANA 1.0.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with Latest technologies.
• Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills.
• Wide experience in interacting with end-users to gather and document the reporting requirements and giving training to the end users.

Technical Skills:

Professional Experience:

Confidential

Role: Senior SAP Business Objects Developer

• Involved in requirement gathering and understanding the end-user needs and business processes in creating optimized Business Objects reports.
• Used multiple semantic layers like OLAP Universes, Non-OLAP Relational Universes, BICS Connections, IDT and reporting tools like Web-Intelligence, Crystal, and Xcelsius/Dashboard Designer to build client required reports from SAP and Non-SAP Sources on top of SAP BW and Relational database SQL .
• Extensively worked in developing SAP BW BEx Queries as a source to Business Objects reports.
• Migrated the reports across the landscapes using new lifecycle Manager and import wizards.
• Extensively used CMC, Web Intelligence Server performance tuning, Load Balancing, BOBJ Server Sizing Maintenance.
• Implemented object level security universe to incorporate security for sensitive information for non-SAP and as a part of SAP team, involved in SAP BOBJ Security implementation.
• Created complex variables, breaks, sorts, filter and conditions for various WEBI reports.
• Expert in developing Ad-hoc reports using Web Intelligence and guiding the client in right direction in choosing the right tool.
• Created complex reports involving master/detail and cross-tab and Combined queries and sub-queries
• Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of campaigns.
• Extensively used scheduler for report scheduling and deployment.
• Generated various report templates for standardizing the reports throughout the organization.
• Involved in end user training and documenting the procedures.

Environment - Business Objects XI3.1, 4.0, Web Intelligence, Dashboard Designer/Xcelsius 2008, Crystal 2008, SQL Server 2008, Information Design Tool/Universe Design Tool, SAP BO Integration Kit, SAP BW 7.0, SAP Modules PUR, SD, FICO, APO, MM

Confidential

Role: Senior SAP Business Objects Developer

• Fulfilled the business objects development needs for various departments and also performed the day to day developer tasks.
• Developed complex Web Intelligence 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 in developing new reports and enhancing existing reports.
• Modified existing crystal reports and created new reports with cross tabs and sub reports based on the client requirements using
• Designed complex reports and Dashboards 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 etc.
• Always considering best business Practices using Business Objects on SAP and non SAP sources for Web intelligence Rich Client, Crystal and Dashboards.
• Go exposed to SAP BW BEx Queries as data sources to Web Intelligence and involved in SAP BW and BOBJ integration Kit.
• Moved the developed Web Intelligence, 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 Web Intelligence reports.

Environment - Business Objects XI R2, 3.x, Web Intelligence, Desktop Intelligence, Xcelsius 2008, Crystal 2008, Oracle 10g, Universe Design Tool, SAP BO Integration Kit, SAP BW 7.0, SAP Modules Purchasing, Sales and Distribution.

Confidential

Business Objects Developer

Responsibilities:

• Developed complex reports merging queries, using aggregate aware function for calculating monthly and 3 day intervals, drill down, Slice and Dice, master/detail for analysis.
• Deployed reports on the web using Crystal publishing wizard and scheduled reports using e-Portfolio and Crystal management console
• Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI
• Created reports using Crystal Reports.
• Optimized the Universe and Database table for improving report performance.
• Build the new universe as per the requirement by identifying the required tables from semantic layer and by defining the universe connections
• Experience troubleshooting and solving business user ad-hoc report development problems.

Environment - Business Objects XI R2, 3.1, Oracle 10g, SQL Server 2000 2005 Windows 2003, SAP 4.7, Oracle 9i, Windows XP.

Confidential

Sr. Crystal Report Developer

Responsibilities:

• Interacted directly with the business users in gathering requirements
• Optimize various SQL queries to make the reports run faster
• Enhance/modify existing reports by creating new Parameters, Formulas etc,
• Responsible for creating the Complex Crystal Reports On demand, Adhoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-down, Dynamic grouping, Cross-Tab, graphical, aging reports .
• Developed Standard Reports for the Sales Marketing Department involving prompt pages, Conditional variables, calculations and filters
• Developed Standard Templates, Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports
• Designed and Developed existing Impromptu reports in Crystal Reports XI

Environment: Crystal Reports 8.5/9, Oracle 10g, MS- Excel, Crystal Info View XI R2 and Windows XP

Confidential

Role: Business Objects Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirements Specification document.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL,SQL Plus, SQL Loader and Handled Exceptions.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Created PL/SQL stored procedures by using bulk bind for inserting, updating data in process tables.
• Created Dynamic generalized procedures for truncating current and old partition data.
• Designed the front end interface for the users using Forms 6i.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Developed numbers of reports using Reports 6i.
• Performed Unit Testing.

Environment: Business Objects 5i, Web Intelligence, Broadcast Agent, Oracle 8i, DB2 Version 7.0, PL/SQL, UNIX, Windows NT and TOAD.