Summary:

• Over 8 Years of experience in in SAP Business Objects and Business Intelligence with strong emphasis in Data Warehousing and Business Objects with experience in full life cycle implementations, Migrations, Upgrades and Production support.
• Expertise in all modules of Business Objects suite XIR2,XI3.0,BO 4.0 with experience using Crystal reports ,Xcelsius, Dashboard, WEBI, Info view, Import Wizard, Designer, Central Management Console.
• More than two Years of Experience as SAP Business Objects Data Services Consultant.
• Well versed in installing, using and extracting data from Oracle and MYSQL Databases
• Fluent in SQL Coding using different software tools such as MYSQL Editor, TOAD and Ms SQL Server Management Studio 2008
• Strong understanding of OLAP Data warehouse concepts, Dimensional Data Model, Star Schema, Snowflake Schema.
• Involved in BODI/BODS Business Object Data Services Projects like End to End implementation, Data migration and Upgradation.
• Developing Workflows, Data flows based on the specifications using various stages in BODI/BODS.
• Experience in configuring SAP ECC, SAP BW systems with Data Services system.
• Work closely with project management, analysts, data modelers and the existing Data Warehouse Design and developers to understand project requirements and contribute to the project solution
• Provide technical expertise on Design, Performance Tuning, Data modeling, Data Warehousing, and Data integration for applications.
• Partner with Business Intelligence and Business operational teams to implement new requirements
• Expert with Data Services -Extract, transformation, coding logic, loading
• Install, analyze, design, test, implement, and support complex production SAP Business Objects Enterprise systems and all associate tools and content
• Experience in Techno Functional analysis with hands on experience in understanding and evaluating business on SAP Modules Sales and Distribution, Material Management, After Market and implementation experience of SAP HANA Model and Reporting
• Design, develop, and test ETL Extract, Transform and Loading processes as per business requirements following the development standards and best practices.
• Design, implement and deploy SAP business intelligence solutions applications and technologies which are used to gather, provide access to, and analyze data and information about company operations for end-to-end data warehousing and analytics including SAP BW, HANA and Business Objects.
• Good Knowledge on SAP Modules of Sales and Distribution of an organization including Sales Documents, Material Management, Delivery Documents etc.
• Experience in creating and managing jobs on Informatica power center 8.0.
• Team player with demonstrated collaborative working relationship.
• Possesses excellent communication and interpersonal skills.
• Adoptive to learn new technological skills.

Professional Skill Pack:

Professional Project Profile:

Confidential

Role: Sr. Business Objects Consultant

Responsibilities

• Worked on creating Attribute Views, Analytic Views Calculation Views in HANA Studio
• Connected to IMCE from Reporting tools through Universe and direct interfaces to generate the reports
• Created designed Universe for reporting from Information models
• Worked collaboratively with project managers, SAP Offshore Consultants and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.
• Involved in full life cycle of Business Objects Implementation.
• Make configuration changes, requested as per change in business process
• Interacted with key business users to understand the business scenarios.
• Designed Developed and deployed and maintained universes used Business Objects designer Information Tool Designer
• Interacted with the users, analyzed the required changes for improvement in existing reports and developed the reports to satisfy their requirements
• Experience in creating Dashboards for the top level management to review the auditing and financial management using Xcelsius.
• Developed Score cards, Bubble charts, filters and alters in Dashboards Using Xcelsius connecting to OLAP databases, Universes Etc.
• Used Crystal reports 2008 advance features like dynamic and cascading Prompts ,worked with sub reports and tuned them for optimum performance
• Created interactive Dashboards and Business presentations by importing data from sheets, query's using Xcelsius.
• Conducted training sessions on BO to BO users across different regions EMEA, APAC to make users understand the usability and functionality of BO reports
• Conducted meetings with management and user community to understand the business requirement and convert business requirements into technical specification.
• Trained the user community in making use of universe to create and publish reports.
• Designed dashboard reports and scorecard formats with process analytics predictive analytics.
• Prepared user documentation for hand on training for end user community.

Environment:

SAP Business Objects 4.0/XIR3.1,Info view, Crystal Reports 2008/Enterprise, Xcelsius, Windows XP, Web Intelligence, Oracle, Hana DB, Hana Studio

Confidential

Role: BOBJ/BODS Consultant

Responsibilities:

• Participate in Data Mapping workshops and follow-up meetings with the client business, DML 's, DMC 's and TFC 's.
• Developing Workflows, Data flows based on the specifications using various stages in BODI/BODS
• Expertise in fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.
• Worked extensively with Sales Distribution team to design data migration from SAP to warehouse.
• Installed configured BODS XI 4.0 SP1 in Development Production Server.
• Configured the Data services to connect to the SAP R/3, BI and CRM.
• Used Open Hub Services to push data out of SAP BI using BODS.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Used Data Integrator and Platform Transforms extensively.
• Worked on Change Data Capture on both Source and Target level for SCD Slowly changing Dimension Type 1, Type 2 and Type 3.
• Interacted with both Legacy and Functional teams to design the mapping to load data .Moved the projects from DEV to ST, ST to UAT and UAT to Production.
• Scheduled the jobs, managed users and repositories in Management Console.
• Drill down the Analytics to the detail level data.
• Participated in detailed report design and created design specifications documents at report level.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation
• Ability to interpret, configure and implement data mapping / transformation business rules into Data Services
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool
• Generated Pl/SQL procedure to load data into warehouse on a weekly basis.
• Created several complex Web Intelligence and Xcelsius Dashboards reports to help management to track and monitor contract, commodity and price compliance.

Environment:

SAP Business Objects Data Services, Info view, Crystal Reports 2008/Enterprise, Xcelsius, Windows XP, Web Intelligence, Oracle, SAP 7.3

Confidential

Role: Business Objects Developer

Responsibilities:

• Involved in creating Mapping ,Workflows and Session in Information
• Data Migration from SQL server to NeoView Database.
• Responsible for Analysis of the existing system and mapped to new derived EDW Database Model.
• Created Universe for Customer Analysis Reports
• Involved in analyzing different source system for Banking domain
• Responsible for testing the existing system data migrated to New EDW
• Managed a Team of 5 for Migration Process
• Developed Complex Reports using WEBI against OLAP Universes
• Developed Complex Reports using Crystal Reports against SAP and non-SAP databases.
• Developed Complex Interactive Dashboards using Xcelsius.
• Developed Complex Reports such as Sub Reports, Drill Down, Drill Up, Shared Variables and Multiple Data Sources using Crystal Reports.
• Developed Interactive Dash Boards with Line, Bar, Combination Charts, Selectors for What-If Analysis.
• Prepared Functional specifications.
• Migrated Universes and reports from SIT/UAT to production Using Import wizard
• Deployed Business Objects Universes and Reports in a secure Environment from one server to other server using Import Wizard and BIAR
• Created alerters ,filters and inserted Breaks and Sections in designing reports.
• Generated Reports from Different Data Providers in Business Objects
• Created complex reports by using multiple data providers ,merge functions, variables, sections, breaks, Filters fie Webi/ Webi Rich client and Deski
• Developed Deski Webi /WEbi Rich client reports by using advanced functionalities like optional prompts, data tracking, custom SQL at report level and calculation contexts.
• Experience in scheduling reports in different formats to different destinations.
• Built the Universes as per the requirements by identifying the required tables.

Environment: SAP Business Objects XIR3.1/XiR2,Info view, Windows XP, Web Intelligence, Neoview, Informatica 8.6 ,Unix.

Confidential

Role: Business Objects Developer

Responsibilities:

• Involved in creating Views for easy data access from different source system.
• Responsible for Central Management Server Administration.
• Responsible for ownership of creating universe for Key Performance indicators Reports
• Created Users and responsible for assigning roles and rights to different user
• Responsible for Designing and developing Dashboards and Web Intelligence reports
• Generating reports on key performance indicators and metrics of the product lines.
• Performed testing on different functionalities of the application.
• Involved in design of the application.
• Created functional specification documents based and requirements.
• Work closely with project management, analysts, data modelers and the existing Data Warehouse Design and developers to understand project requirements and contribute to the project solution
• Troubleshoot and resolve application / system issues, Conduct peer reviews to ensure standards.
• Implement object/data level security within Business Objects.

Environment: SAP Business Objects XiR2, Info view, Windows XP, Web Intelligence, MS SQL Server 2005,Informatica

Confidential

Role: Data Analyst

Responsibilities:

• Involved in creating Views for easy data access from different source system.
• Responsible for Central Management Server Administration.
• Responsible for ownership of creating universe for Key Performance indicators Reports
• Created Users and responsible for assigning roles and rights to different user
• Responsible for Designing and developing Dashboards and Web Intelligence reports
• Generating reports on key performance indicators and metrics of the product lines.
• Involved in creating stored procedures in java using JDBC
• Troubleshoot issues in timely manner.
• Creating or updating technical documentation from functional documentation