SUMMARY

• 8 years of experience in Business Intelligence using SAP Business Objects BI 4.1/4.0/XI R3 with Information Design Tool IDT , Universe Design Tool UDT , Launch Pad,Infoview,Web Intelligence WebI , Desktop Intelligence DeskI , Crystal Reports, Dashboard Design, Xcelsius, QaaWS, Live Office, Import Wizard, Report Conversion Tool RCT
• 6 years of experience in Analysis, Design and Development of various Data Warehousing /Data Migration projects using SAP BODS/BODI and Informatica.
• Extensively worked on BODS/BODI Designer Components-Jobs, Workflows, Data Flows, Formats, Data Store and Scripts.
• Extensively used ETL methodology for Data Extraction, transformations, loading using Data Integrator.
• Extensive knowledge in ABAP, SQL, PL/SQL T-SQL programming and trouble shooting
• Performance tuning of BOBJ reports by optimization of report queries and report template/report calculations.
• Experience in optimizing, debugging and testing SQL queries in Oracle and Teradata.
• Involved in defining the validation rules and bind those rules to against the specific columns.
• Involved in setting up the Scorecards and associate the Data Quality dimensions.
• Extensively worked on data loads from BODS to BW System.
• Extensively worked on BODS Administration Tasks like Repository Configuration, Job Server configuration, Local Repository configuration, Central Repository configuration, Job Scheduling, Monitoring.
• Installed and configuring the Business Objects Data Services 4.1, with SAP BI handling SAP DS admin activities and Server configuration
• Worked on Change Data Capture on both SOURCE and TARGET level and implemented the SCD Slowly changing Dimension Type 1, Type 2 and Type 3.
• Design, Develop and Debug complex ETL jobs using Data Integrator Scripts, Workflows, Dataflow, Data stores, Transforms and Functions.
• Extensively worked on Data Extraction from SAP ECC or Legacy Systems to SAP BW system as a Target By using SAP BODS.
• Good experience in LSMW, ABAP flows, BDC, and IDOC's integrated with Data Services.
• Created the Users and Groups for setup the user security as for business by using BO CMC.
• Experience in creation of users and assigning roles based on function area.
• Migrating Promoting also updating content between multiple Business Objects Environments.
• Involved in creating Dashboards with Dashboards4 and Xcelsius using Query Browser, Live Office and QAAWS, Webi web services as sources.
• Extensively Created SAP BW connection to interact with SAP BODS using RFC connection.
• Used ABAP Data flows to extract huge volume of data from SAP Systems.
• Based on the volume if the data we have scheduled multiple Jobs from Management Console..
• Good Experience on Hana system for data loads from legacy system to Hana System

Technical Skills

Professional Experience:

Confidential

SAP BODS Consultant

• Preparation Technical Design documents based on Functional documents.
• Involved to define the validation rules and bind those rules to against the specific columns.
• Involved to setup the scorecards and associate the Data Quality dimensions.
• Develop Information Steward Exception Reports for project.
• Scheduling reports and notifying 'End Users' when there are exceptions.
• Configured Email notification to Business users when rules refresh happened.
• Created multiple data store configurations in Data services local object library with different databases to create unified data store.
• Extensively work on Installations and configure the repositories and establish the data source connections.
• Participating in all Technical discussions, meetings and mounting the discussion points.
• Sharing his knowledge among the team.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, Table Comparison, case, Validation, Merge, lookup etc. in Data flows
• Interacted with users to know their business views while gathering the report requirements and provided several report mock-ups and outline the proposed solution by creating proof of content to finalize the requirements.
• Leading design workshops with Business users in gathering complex reporting requirements in designing BI solutions.
• 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, and Transformation and Generation of Load ready data files in LSMW format.
• 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

Environment: SAP BODS 4.1, Oracle11g, SAP ECC, SAP BW 7.3, SAP BO 4.1, Windows.

Confidential

SAP BODS Consultant

• Installed and configuring the Business Objects Data Services 4.1, with SAP BI, ECC handling SAP DS admin activities and Server configuration.
• Involved in writing validations rules and generate score cords, Data insights, Matapedia, Cleansing package builder by using Information Steward 4.x
• Configured different repositories Local, Central, and Profiler and job server.
• Involved in meetings with functional users, to determine the flat file, Excel layouts, data types and naming conventions of the column and table names.
• Prepared mapping documents capturing all the rules from the business.
• Created SAP BW connection to interact with SAP BODS using RFC connection.
• Created Info Object, Info Source, Info Area for SAP BW.
• Created multiple data store configurations in Data services local object library with different databases to create unified data store.
• Using Data services Created Batch and Incremental load Change data capture and wrote initialization scripts which control Workflows Data flows
• Involved in many enterprise Business Intelligence projects in entire SDLC from project initiation to implementation as technical lead.
• Participated in business requirements solicitation and analysis of BI initiatives.
• Prepared technical design specifications based on functional requirements and analysis documents.
• Modified existing Store Procedures to accommodate the report changes.
• Provided technical solutions and fine-tuned long running queries to improve query performance.
• Assisted/guided end users to efficiently use the universes in building the simple and complex reports.
• Involved in UAT and solved the issues raised by users before migrating to Production.
• Daily and Monthly reports are used to schedule using Tidal Scheduler.
• Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.
• Involved in writing scripts and also used some built-in functions like To Date, lookup, key generation and Custom Functions like checking whether the load is a initial load or a bulk load.

Environment: SAP BODS 4.1, Oracle11g, SAP ECC, SAP BW 7.3, SAP BO 4.0, Windows. Dashboards 4, Oracle 11g, Windows XP, Remedy

Confidential

SAP BODS Migration/Business Objects Developer

• Extensively worked on AIO All In One methodology, an SAP preferred methodology for migrating the data to SAP.
• Worked on Material Master, Bank master and Media Objects.
• Analysed Mapping sheet and raised Issues in the Issue log if any.
• Worked on Defects and CR's during the data loads.
• Created delta Jobs to load data from legacy source to SAP system based on the business rules provided.
• Analysed the error log for trouble shooting batch jobs.
• Interacted with Functional team to fix the load errors at ETL end.
• Supported in all the phases Dev, QA and Production of Project.
• Built customized Mobile reports for sales representatives to access their key sales and marketing data, and to meet the needs of their business role, see how well they are tracking against a predefined set of KPIs, and perform the advanced analytics they need in order to facilitate better business decisions.
• Involved in all phases of Software Development Life Cycle SDLC including requirements gathering, preparation of technical specifications, designing and developing universes/reports, unit testing and UAT.
• Interacted with the Business Users to analyze the business process and gathered the requirements.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Involved in multiple Universe designs CDC, Core, Cost and Coverage, CSI, Cue-Call Activity, Dare Specialty, Inventory, Rx, Sales as part of DARE project.
• Worked extensively on BEx query Designer and WAD to developmany complex and flexible queries.
• Configured many SAP BI queries for BOBJ reporting
• Involved in CSI Dashboard development using Live Office and QaaWS as a source feed.
• Responsible for creating Query as a Web Service objects to connect data to the dashboard model.
• Involved in Universe and Report enhancements, Performance Tuning.

Environment: SAP BODS 4.0 3.2, Oracle 10g, SAP ECC, Windows, Business Objects 4.0 BI 7x, HP Quality Center, Informatica 9, Oracle 11g, Teradata 12.

Confidential

Business Objects/ ETL Developer

• Involved in the development and implementation of the Enterprise Data Warehousing EDW process and Data Warehouse.
• Building of the BODS Jobs, Workflows, Data Flows as per the Mapping Specification.
• Worked extensively on different types of transformations like Query transformation, Merge, Case, Validations, Map-operation, History Preserving and Table Comparison transformations etc .
• Extensively used ETL to load data from flat file and also from the relation database.
• Extracted data from different sources such as Flat files, Oracle to load into Sybase IQ database.
• Ensuring proper Dependencies and Proper running of loads Incremental and Complete loads
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Designed, developed and managed Universes in Business Objects Designer for generating the marketing reports for marketing group users.
• Created universes for Financial billing system and order processing.
• Resolved loops by creating Aliases and Contexts and checked integrity of universes.
• Created hierarchies in universe to provide the users with drill down in reports.
• Involved in optimizing the universe and SQL tuning to increase the query performance.
• Implemented aggregate awareness to ensure the query is pulling the correct level of aggregation.
• Created many financial reports according to the investment deals, facility and outstanding to know the exact amount of net investment in each deals.
• Developed many standard and ad-hoc reports using features like linking documents, crosstab, sections, breaks, ranking, filters, input controls and scheduled reports in Infoview.
• Involved in preparation of Technical design documents.
• Involved in migration, UAT and solved the issues raised by users before migrating to Production.

Environment:Business Objects 4.0, SAP BODS 3.2 Oracle 10g, Oracle Designer, HP Service Center, HP Quality Center, Windows XP.

Confidential

Business Objects Developer

• Business Analysis and Requirements gathering from various business user community, coordinating with end users communities understand their requirement
• Gathered Reporting Requirements and arrived at the best Reporting Model using Business Objects teams.
• Involved in the installation of Xir2 and created different profiles for as per their responsibilities and maintained them.
• Involved in analysis and design of logical and physical data model with STAR schema for Score and Category P L Data mart.
• Designed, developed, modified and maintained Business Objects universe using Designer XI R2 for ad hoc and canned reports.
• Created joins, indicating cardinalities, checked integrity of the universe and resolved
• Resolved issues like loops by creating aliases and contexts as required to remove the cyclic dependencies
• Scheduled pre-canned reports through Broad Cast Agent Server for distribution and printing.
• Created variables, formulae and objects at report level.
• Generated reports using prompts, filters and conditions and testing these reports with all possible data for consistency.
• Tested reports before posting them to the repository query optimization performance .
• Provided training to end users to use various functionalities of Business Objects thick and customized thin client.
• Coordinated with all team members and report the issues to the manger as necessary.
• Used Microsoft Live Office to present the reports to the business users.

Environment:Business Objects 6.5.1/XIR2 Designer, Desktop Intelligence, Web Intelligence,CMC, Import Wizard , Crystal Report XIR2, Oracle 10g, , HP Quality Center, Windows XP.

Confidential

BW/BO Developer

• Created the Cost Center accounting info cube for all costs and quantities for marginal costing on cost centers that were transferred from the connected source systems. Costs and quantities that
• are distributed via cost splitting to activity types are also included
• Used the SAP delivered queries to analyze your live data in SAP BW for testing and demonstration purposes
• Extensively used ABAP Routines in Transfer Rules and Update rules to load and update data into Data Targets
• Created Formula Conversion Routines using Transformation Library to create formulas for Concatenation, Date Change and String Manipulation
• Used the Aggregate awareness for the optimization and performance tuning of universes.
• Linked the universes to share the common components between the universes.
• Implemented hierarchies to support drilling in reports.
• Involved in migration from Business Objects from 6.5 to XIR2 and establishing BO environment.
• Created various analytical reports like Market share vs Volume and Payer Information reports
• Implemented Security Features of BO like row level, object level and report level to make the data secure.
• Worked on Business Objects Administration like CMC, CMS maintenance and security issues.

Environment: Business Objects XIR2/6.5 Designer, Web Intelligence, Desktop Intelligence , Oracle 9i, Oracle Designer, Windows

Confidential

BW/BO Developer

• Used ABAP for Data Source enhancements 0HR PY 1, 0HR PY 2 , and extensively used ABAP Routines in Transfer Rules and Update rules to load and update data into Data Targets.
• Involved in creating Custom Multi cubes and SAP Configuration changes for the Human resources application area.
• Involved in extensive interaction with the users and management to identify Business requirements, and analyze reports in the CO-PA, FERC, HR application areas.
• Used the SAP delivered queries to analyze your live data in SAP BW for testing and demonstration purposes
• Developed universe by creating classes with Dimension, Detail Measure objects.
• Involved in resolving loops and traps by using Aliases and Contexts.
• Involved in creation of Filters, prompts and setup hierarchies for multidimensional analysis.
• Created complex Web Intelligence reports including Drill down, graphical reports, formula base and well-formatted/customized reports according to user requirements.
• Created charts to display summary data Product vs Time dimension.
• Prepared high level Test plan, and detailed test case scenarios for Unit testing.
• Scheduled the reports on recurring basis using Infoview.
• Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP Cubes.

Environment:Business Objects XIR2/6.x Designer, Web Intelligence, Desktop Intelligence , Oracle 9i