Synopsis

• Certified SAP Business Objects Professional with over 8 years of experience as a software developer in designing and development of Data warehouse and Reporting using Business Objects Enterprise BI 4/XI 3/XI R2 against Oracle, DB2 SQL Server.
• Experience in complete Project development LCM including: System Analysis, Design, Development, Testing, Deployment and End User Training.
• Extensive experience in installing desktop and enterprise server products of SAP Business Objects in single and distributed environment.
• Expert in creating SAP Dashboards using BO Performance Management and in working with all the modules of SAP Business Objects Enterprise BI4/XI 3.0/XI R2/6.5/5.x like CMC, CMS, SAP Dashboard, Desktop Intelligence Deski , Web Intelligence Webi , Scheduler, Publisher, Supervisor, Designer, Information Design Tool IDT , and other Applications.
• Proficient at creating SAP Business Objects universes using Designer and IDT.
• Familiar with SAP HANA conceptually and have used SAP HANA Studio.
• Experienced in creating HANA views in HANA studio and include them in Universe.
• Expert in training and supporting end-user reporting needs.
• I am a solid team player with the interest and ability to learn new technologies quickly. I have great communication and excellent analytical skills.

Technical Skills

• BI Tools: SAP Business Objects Enterprise BI 4/XI3.0/R2/6.5.1/5, SAP Business Objects Supervisor, CMC, CCM , Designer, IDT, Info view, Import Wizard, LCM, Broadcast Agent BCA , Live Office, QaaWS, Bex Query, OBIEE Administration Tool, InfoBurst, Scheduler, Publication.
• Reporting: Crystal Reports, Desktop Intelligence, Web Intelligence, OBIEE Analytics
• Dashboard: SAP Dashboard, Xcelsius, OBIEE Dashboard, Qlikview, Tableau, SAP Visual Intelligence, SAP Lumira.
• ETL: Informatica Power center 9.1, Data Integrator XIR2.
• Databases: SQL Server 2000, DB2, Oracle11g/10g/9i/8i, Teradata, SAP HANA
• Languages: PL/SQL, SQL, SQL/SQL Plus, Core Java, C, C , VBA, Pearl.
• Web Tools: HTML, XML, Microsoft Share-Point.
• Operating Systems: Windows 95/98/2000/XP/NT, UNIX.
• Tools: TOAD, SQL Developer, SQL Plus, SQL Loader.

Professional Experience

Confidential

Sr. SAP BusinessObjects SME

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline proposed solutions.
• Expertise in Resolving the Daily issues in the Daily Production Environment.
• BO Upgrade from XIR3 to BI 4.1 and also responsible for applying service pack and fix pack to BO installation and also deployed WAR files after upgrade.
• Ensured all the environments are in synchronization and checked supported environments and hardware requirements from the Products Availability Matrix PAM document for the new installation.
• Installed Microsoft .net framework prior to the installation of BOXIR3.1 for successful installation of all the BO components.
• Transferred CMC data between old and new version either through CMC/BIAR File/Import Wizard.
• Created repository and security domain with user groups and security implementation.
• Extensively worked with security issues and user maintenance in XIR3/BI4.1.
• Evaluated the possible use of aggregate tables and worked with DBA to create the aggregate tables.
• All the Scheduled report jobs were built and maintained through Info view.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implement Folder and object level restrictions.
• Used different Web services like Live Office, QAAWS to make a live connectivity between the Crystal Xcelsius Dashboards and BO Enterprise 3.1.
• Importing the groups and users from windows Active Directory into Business Objects and granting the users and groups with appropriate rights trough Central Management Console.
• Implemented end to end Single Sign-On SSO with Windows AD authentication.
• Implemented Row level security in Universe Designer by creating a security table which captures the user access privileges and then defining the required restrictions and applying these restrictions to users and groups.
• Implemented complex universe design to meet user requirements. Resolved complex universe design issues like resolving loops by defining alias and contexts.
• Created complex Webi and Crystal Reports which sourced data from multiple data providers.
• Extensively used Xcelsius for doing What-if analysis.

Environment: SAP BusinessObjects 4.1/XI3.1, SAP Data Services, QaaWS, Information Design Tool IDT , Designer, Web Intelligence, Crystal 2008, SAP Dashboard, Import Wizard, Report Conversion Tool, LCM, Red Hat Enterprise, Oracle 10g.

Confidential

Sr. Business Intelligence Developer

• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Performed migration and merging of RPD's in OBIEE.
• Designed Schema diagrams using Fact, Dimensions, physical, Alias and Logical tables.
• Worked using Catalog manager to migrate web catalog between different instances.
• Designed and Developed Financial Dashboard like GL, Payables, Receivables.
• Developed Dashboard pages like Overview, Effectiveness, Invoice Details and Payment Performance in Receivables Dashboard.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Worked extensively with Physical, Business and Presentation layer.
• Designed Schemas/Diagrams using Fact, Dimension, Physical, Logical and Alias table.
• Created different types of customized drill, aggregation to meet business requirement.
• Generated various analysis using global and local filters.
• Created numerous executive level Analysis and Dashboards to provide insight into the financial data.
• Identified the aggregation levels and created dimensions for each level of aggregate.
• Added users and configured security in web logic console of OBIEE 10g.
• Converted existing OM subject area into SAP Business Objects using IDT.
• Recreated existing OM dashboard using SAP Dashboard.
• Extensively used OPENDOC functionality to point to a detailed WEBI reports.

Environment: OBIEE 10g, BI Apps 7.9.6.3, SAP Business Objects 4.0, Information Design Tool, SAP Dashboard, Informatica 9.0.1, Oracle 11.2.0.2, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL Plus, Unix.

Confidential

Sr. SAP Business objects SME

• Worked with the team to decide on the best solution for all SAP BusinessObjects issues.
• Designed fault tolerance and fail over architect for Business objects environments.
• Installation and configuration of BOXIR2 and their modules.
• Installed and tested the BI4.0 application on sandbox.
• Involvement in Load testing of system to check performance of application.
• Configured SMTP on server to allow users to schedule report and send them to other resources.
• Expert at using Information Design Tool IDT and Universe Designer.
• Expert in converting .unv format universe to .unx using Information Design Tool IDT .
• Worked extensively in administering different SAP BusinessObjects environments.
• Extensively used IDT to create Projects, Data Foundation and Business Layer.
• Worked extensively in migrating SAP BusinessObjects environment from XIR2 to BI 4.
• Worked extensively in developing Web Intelligence, Desktop Intelligence and Crystal reports along with designing and developing SAP Dashboards.
• Created aggregate tables that were used in designing the universe schema for better performance.
• Expert in using advanced integrity check features made available in IDT.
• Created Webi Reports and generated graphs for multi-dimensional analysis using Slice Dice, Drill Up and Drill Down functionality. Also made extensive use of Aggregate Awareness.
• Identified and resolved complex Fan trap and Chasm Trap problems.
• Expert in using different modules of SAP BusinessObjects XIR2 and BI 4 like CMC, CCM, Import Wizard, and Report Conversion tools, Life Cycle Management, Upgrade Management Tool.
• Expert in defining Universe/Folder/Group level security.
• Expert in auditing business objects environment.
• Extensively implemented cascading prompts for Desktop and Web Intelligence report.
• Expert at implementing new features in SAP Business Intelligence 4.
• Extensively used Prompts and other SAP BusinessObjects Enterprise XI R2 functions.
• Extensively supported development and management personnel regarding new or improved system design, testing and implementation techniques and application efficiency/integrity.
• Provided extensive analysis and research on SAP BusinessObjects Enterprise and other Business Intelligence tools.
• Expert at training end users in carrying out day to day operations in SAP BusinessObjects.

Environment: SAP BusinessObjects 4 / XIR2, QaaWS, Information Design Tool IDT , Designer, Desktop Intelligence, Web Intelligence, Crystal XI, SAP Dashboard, Import Wizard, Report Conversion Tool, Life Cycle Management, Upgrade Management Tool, StarTeam 2005, ClearQuest, DB2, Infomix.

Confidential

Sr. SAP BusinessObjects Admin/Informatica Developer

• Involved in development of Data Extraction as part of the project effort.
• Extensively Used transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, lookup, Sequence Generator, Router, Sorter and Stored Procedures.
• Used External procedures shell scripts, stored procedure for various purposes like appending files on Post Session commands, dropping indexes.
• Responsible for designing and developing Xcelsius dashboards for both internal and external business users.
• Develop Perl Scripts to navigate files to make available for dashboards.
• Extensively used Maestro Scheduler to test jobs in Development and Test environments.
• Schedule and monitor flows using Work Flow Monitor and Maestro scheduler.
• Design and Develop complex dashboards. Created source files for the dashboard using Informatica Power Center 8.0. Implemented Dynamic XML concept for efficient and accurate result using QaaWS tool.
• Design complex SAP Crystal Enterprise 2008 reports using different data sources like free-hand SQL, Universe, Excel sheet, Stored Procedures etc.
• Successfully assisted business users in having them upgrade to higher versions of SAP BusinessObjects, Crystal Reports and Crystal Xcelsius.
• Worked extensively on creating complex Shell scripts, Perl scripts and Hyperion Scripts.
• Worked extensively in creating complex reports by implementing Open Document functionality, Multiple Data Providers, Report Bursting and Macros.
• Successfully completed migrating Crystal Reports from Crystal Report Professional v5 to SAP Crystal Enterprise XI.
• Created Complex Financial Forecasting Webi report.
• Designed Mappings and Workflows to generate XML target files for Xcelsius Dashboard using Informatica Power Point Designer and Work flow Manager.
• Extensively used Harvest to promote code changes among different work environments to maintain a consistent code among all environments.
• As part of on-call support was responsible for any production flow ABEND and was responsible for providing a solution to fix the problem.
• Involved in weekly status calls with Business and Team Members to resolve the Issues.

Environment: SAP BusinessObjects XI R2/XI 3.1, SAP Dashboard Xcelsius , Crystal Reports 5, Crystal Reports 2008, Desktop Intelligence, Web Intelligence, Live Office, QaaWS, Informatica 8.5, Maestro, Oracle 9i, TOAD.

Confidential

Sr. SAP BusinessObjects SME

• Responsible for installation and configuration of SAP BusinessObjects Enterprise XI R2 Software on client machines and created User groups and users of PROD, STAGE and DEV environments.
• Implemented LDAP configuration of SAP BusinessObjects Enterprise to get Single-Sign On for the Business Users.
• Responsible for performing migrating between PROD, STAGE and DEV environments.
• Analyzed the architectural features of SAP BusinessObjects Enterprise XI 3.0 and proposed the implementation of it.
• Defined the security setup in SAP BusinessObjects Enterprise XI 3.0 for the CDW team.
• Maintained the overall system to be SOX Compliance- the government standard for Pharmaceutical Industry.
• Created Performance reports with SAP BusinessObjects Enterprise XI R2 Auditor and CMS database.
• Experienced in designing SAP BusinessObjects Architecture for large user base.
• Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checked the integrity.
• Created universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
• Developed Complex Web Intelligence reports with data across 7 tabs Territory, Region, and District, state, department and store tabs for the daily, MTD, QTD, YTD sales.
• Created complex reports involving Multiple Data Providers, Slice and Dice, Ranking, Alerter, Breaks, Cross Tab and Prompts.
• Replicated the scheduling system that users had in Business Objects 6.5 into SAP BusinessObjects Enterprise XI R2 using Scheduler and Publication.
• Designed VBA Macro to implement a specific user requirement in Scheduling.
• Scheduled reports to PDF, XLS and DESKI format to users Inbox or users E-mail id or Unmanaged Disk locations.
• Scheduled reports on Daily, Weekly, Monthly and Nth week of a month basis.
• Migrated reports from Business Objects 6.5 to SAP BusinessObjects XIR2 and tested it before moving them to SAP BusinessObjects Enterprise XI R2 Production environment.
• Created SAP Crystal Reports XI Workshop System Identifying users, system resources, system structure, Crystal Enterprise Server installation and support .
• Developed interactive Dashboards using SAP Crystal Xcelsius for custom requirements from Contract Information Group.
• Created Bursts in InfoBurst to schedule reports as per user requirements.
• Created audit report to trace all the reports that have instances that got scheduled successfully, that got failed and have a recurrence instances.

Environment: SAP BusinessObjects 6.5/XIR2/XI 3.0, Designer, Desktop Intelligence, Web Intelligence, Crystal XI, Xcelsius, Live Office, QaaWS, ZABO, Oracle 9i, TOAD, InfoBurst.

Confidential

Business Objects Admin/Developer

• Analyze the reporting requirements with the business users and come up with the technical specifications for the BO Reports.
• Conduct 'Quality Assurance' and 'Performance Tuning' of the reports in BOEXIR2 environment.
• Responsible for installation and configuration of BOE XIR2 Software on client machines and created User groups and users of DEV, UAT, PROD environments
• Migrated universes and reports to DEV, UAT and PROD environments from BOXIR2 version to their respective folders using Repository Migration Wizard.
• Implemented WINDOWS AD and KERBEROS configuration of Business Objects to get Single-Sign-On for the Business Users.
• Performed the installation of Business Objects XIR2 SP3 with Dev, UAT and Production environments.
• Experienced in implementing the authentication with Windows NT, Windows AD, Enterprise and LDAP groups.
• Involved in Central Management console CMC to setup rights for users, User groups/Folders based on each Business Application and supporting documentation for ongoing user's maintenance.
• Creating, maintaining and modifying the business critical reports using the Desktop Intelligence and Web Intelligence.
• Created reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab, Master Detail, Breaks and Sections.
• Educated the business users by making sure that they get familiarized with the reports.
• Moving the report objects DESKI, WEBI from Dev Stage to Prod Environments.
• Solved many Universe problems Loops, Fan and Chasm Traps
• Documented my entire effort. Documented the Report specification, Technical specification, Unit test cases and Project planning.
• Experience in creating Customized Xcelsius, Voyager, Live Office complex reports using Business Objects Enterprise.
• Created reports by extensively using functions and sub-query concepts
• Extensively used Calculations, Sorting, Drilldown, Drill thru, Slice and Dice, Formatting, Breaks, Filters, Changing Displays and Prompts for creating Business Objects Reports.
• Created parameterized Crystal Reports using Charts, Sub-reports and Running Totals.
• Experience in creating customized and complex reports using Business Objects XI R2 and Crystal Reports XI.
• Worked on Microsoft Share-Point for generating issues and publishing documents for Business users.
• Worked on the custom installation of SAP integration kit with Business Objects
• Detected Cardinalities and Loops. Resolved the Loops, checked the integrity of the Universes and created List of values, finally exported to Repository.

Environment: BusinessObjects XI R2, Designer, Desktop Intelligence, Web Intelligence, Crystal XI, Repository Migration Wizard, Xcelsius, DB2, Oracle, Teradata.