SUMMARY

• Certified SAP Business Objects Professional with Over eight years of professional experience as a software developer in designing and development of Data warehouse, Reporting, SAP Business Objects 4.2/4.1/3.1/XI R2/Crystal Reports XI, Xelsius, Design Studio 1.6/1.4, Lumira Oracle, SAP BW and SQL Server.
• 8 years of experience in Analysis, Design and Development of various Data Warehousing projects using SAP Business ObjectsData Services 4.2/4.1/4.0/XI3.2/3.1, Data Integrator XIR2/11.7/11.5, Business Objects XI 3.1/XIR 2/6.5/6.0/5.1.
• Strong understanding of OLAP Data warehouse concepts, Dimensional Data Model, Star Schema, Snowflake Schema.
• Strong SDLC knowledge including entire life cycle of analysis, design, build, test and deployment.
• Solid team player with the interest and ability to learn new technologies quickly. Ability to learn new technologies and challenging concepts quickly and implement them.
• Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator.
• Worked on data Migration from Legacy system to SAP System using SAP Best practices.
• Strong experience in the integration of BODS with SAP modules and Non - SAP data sources.
• Strong experience in using BODS as an external system for ETL between ECC and BI.
• Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms(Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Strong experience in cleansing the data using Data Quality transforms.
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Data modeling (Dimensional & Relational) concepts including Star-schema modeling, Snowflakes modeling, fact and dimension tables.
• Installed and Configured Business Objects Enterprise Suite, Business Objects Data Services/Data Integrator/Data Quality & Data Insight with proper IQ and OQ documentation.

TECHNICAL SKILLS

ETL Tools: SAP BO Data Services 4.0/XI3.2/3.1/3.0 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2/11.7/11.5, SQL 2008 R2 SSIS.

Business Intelligence: SAP BusinessObjects 4.2/4.1/4.0/XI R3.1/XI R2 BusinessObjects XI 6.5/6.1/6.0/5.1 (Supervisor, Designer, Info view, SAP BusinessObjects Enterprise Reporting, Web-Intelligence 6.0/2.7/2.6/2.5, Broadcast Agent, Designer, Supervisor, Auditor, Performance Management & Dashboard Manager, Report Writer), IDT, UDT, Analysis For Office 2.2 sp2, Design Studio 1.6/1.5/1.4, Lumira, SAP Crystal Reports 10/XI, Crystal Enterprise, Central Management Console, Tableau 8, 9, 10, Tableau Desktop, Tableau Server, TOAD 8.5, SQL Navigator, Info-burst, Bex query.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.0, Visio.

Databases: SAP, Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2000, SQL Server 2005, Teradata, MS Access, Rapid Mart.

Programming: SQL, PL/SQL, SQL Plus, VB, C, C++.

Environment: MS-Windows 9x, Windows NT 4, MS-Windows 2000/XP.

PROFESSIONAL EXPERIENCE

Confidential, Wayne, NJ

Sr. SAP Business Objects SME

Responsibilities:

• Gathered the requirement, completed the proof of concept, Designed and Developed ETL Jobs, Build universe and Webi reports using SAP Data Services and SAP BusinessObjects
• Was responsible for interacting with business users and convert the business requirements into technical specification
• Was responsible for maintaining Development, Test, Stage and Production environments.
• Designed and Developed ETL jobs using SAP Data Services(BODS) 3.2 and 4.2 to load data from transactional systems to a data warehousing environment
• Worked extensively in upgrading jobs from Data Integrator 3.2 to Data Services 4.2
• Worked extensively towards creating Real time jobs using SAP Data Services.
• Worked extensively towards creating a batch jobs to load data from transaction system to star schema.
• Extensively used history preservation transform, case transform, key generator, map operation and merge transform
• Used different transforms such as Query, Case, Table Comparison, Key Generation Merge,Date Generation, Pivot transforms and functions like if then else(), substr lookup, lookup ext etc.
• Used various Transforms like Map Operation, Table Comparisons, Row-Generation Query History Generation, Key Generation, Pivot, Reverse Pivot and functions like lookup, index search for transforming data.
• Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism
• Search Replace, Lookup ext and Custom Functions like Sending Email whenever an exception is raised
• Replication of data from source system to SAP HANA database is done using SAP LT Replication and BODS.
• SAP LT uses trigger based approach.
• Performance of the Design Studio dashboard has been improved by using css scripts.
• Load only those components when the dashboard in which tab we are in to improve the performance.
• Created a mock up dashboard using Tableau desktop and Design studio.
• Dynamic Visibility and drill through functionality has been done in Design Studio Dashboard.
• On click of a text box a panel dynamic visibility opens up decline on click of close using css script.
• Drill through from cross tab to cross tab has been achieved.

Environment: SAP Business Objects 4.2 / XI 3.1, Information Design Tool, Universe Designer, SAP Dashboard, Design Studio, Web Intelligence, Crystal Reports, SAP Data Services 4.2 / 3.2, SAP HANA Oracle 11.2.0.2, SQL, PL/SQL, TOAD, Unix.

Confidential, Northbrook, Illinois

SAP Business Objects Developer

Responsibilities:

• Created Webi reports on SAP BO 4.1 sp5 patch 6 with back end as Bex.
• Complex Webi reports build for HR and FI module.
• Hyper linking with the prompts from the summary report to the detail report.
• On demand Show Hide logic as per user request has been build.
• Lead SAP BusinessObjects team both offshore and on shore.
• Part of Migrating BW on HANA. This help in improving the performance drastically.
• Involved in usingJob Serverin creation of real time jobs. And also involved in Performance tuning, transformation, and target levels.
• Strong experience in cleansing the data usingData Qualitytransforms.
• Proficiency in data warehousing techniques likeSlowly Changing Dimension, surrogate key assignment andChange Data Capture.
• Involved in Creation of jobs that specifydata mappings and transformationsby usingData Integrator Designer (BODI)
• Used Data Integrator to load data from different sources (SQL, Text files) to the target database
• Performed Unit, System and Regression testing of theBusiness Objects Data IntegratorETL jobs
• CreatedJobs, Workflows, Transformations and Data Flowsaccording to requirement to integrate source data in to Target data ware house
• Analyzed various Data Warehouse Models likeslowly changing models, Conceptual Models, Logical Models. Also Designed and developedData Integrator scripts for data transformation
• Extracted data source for cube from SAP transactional system and flat files.
• Worked with tables involving Hierarchies and resolved them using Hierarchy flattening whenever required.
• Used and monitoredInfo View, CMCand also assigned Roles, and setUser Groups and rules and according principlesandalso monitored securityand otherCMC controlled functions.
• Developed Drill Downs report using Graphs inCrystal Reports 2008.
• Build reports on Normalization and De-Normalized data.
• Worked with Type1, Type2 and Type3 dimensions.

Environment: SAP BusinessObjects 4.1 sp5 patch 6, Design Studio 1.4, Crystal Reports 2008, SAP BW on HANA, Bex Query, SAP BusinessObjects Data Services.

Confidential

SAP Business Object SME

Responsibilities:

• Resolving all the Application level issues for SAP BusinessObjects in AMS.
• Promotion of Reports from Development to Production.
• Done test case for webi and Dashboard on each server after HANA Migration.
• Created Dashboard and webi reports and maintained them.
• Multi Tab dashboards have been build and performance of the Dashboard has been take care by loading only those objects in the tab we are in.
• Trained User on SAP Lumira, SAP BOD310.
• Involved in Requirements gathering for making a Standardization SAP BusinessObjects SOP.
• Helped users to improve Performance of the reports.
• Had a much appreciation for my AMS activity from Client side.
• Xcelsius Dashboards are build using a BICS connections.
• Scheduled ETL jobs using BOE scheduler.
• Involved in writing DI scripts and also used some built-in functions like Search Replace, Lookup ext and Custom Functions like Sending Email whenever an exception is raised.
• Made modifications to existing universes by adding new tables in the data warehouse, creating new objects and exported the universes to repository.
• Responsible for designing, building, testing, and deploying Dashboards, Universes and Reports using Web Intelligence through Business Objects.
• Extensively used central repository for version controlling.
• Successfully implemented complex type 2 transformation.
• Transformed data from source system to data warehouse using data services.
• Worked with DBA in reviewing the explain plan and recommended use of appropriate partitions and indexes.
• Involved in complete migration from Dev to Prod.

Environment: SAP BusinessObjects 4.1 sp2, Design Studio 1.3, SAP BW on HANA, Bex Query, Data Services.

Confidential

Responsibilities:

• Created webi, Design studio Dashboards and Analysis for Office reports on SAP BO 4.2 sp2 back end as Bex.
• Complex Webi reports build for HR and FI module.
• 7 consecutive days of vacation, is a complex webi report where the manager gets the list of employees under him who has taken leave for a period selected in input control.
• Publishing of reports was structure such that manager receives an email notification of the employee under his umbrella.
• Involved in creating the Repository, creating Users, User Groups and assigned privileges to the users using Supervisor.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Converted webi reports with oracle as source to Bex queries.
• Designed and developed universe for report generation.
• Resolved the loops, cardinalities, contexts and checked the Integrity of the Universes.
• Exported the universe to the Repository to make resources available to the users.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• FSI check for all the FRS and one the score reaches 80% we start the development.
• Using Design studio build dashboard for the user.
• Performance of the Design Studio dashboard has been improved by using css scripts.
• Analysis for Office is the key for all the end user to do analysis based on bex query and save it as work books locally or on server.
• Used HANA as source to create webi report with IDT as semantic layer.

Environment: SAP BusinessObjects 4.0 sp2 patch 6, SAP BW on HANA, Bex Query, Data Services, Oracle sql/Plsql.

Confidential

SAP Business Object Analyst & Developer

Responsibilities:

• Involved in interacting with Business users, gathering and analyzing requirements, logical and physical design of the reporting Requirements.
• Extensively created reports on HR database.
• Created a Dashboard for HR Turnover Report using Live Office.
• Designed cascading prompts in the universe to filter the list of account names based on the business units.
• Defined Customized Hierarchies at Universe level as for the user requirement.
• Created Derived Tables in the universes as for the requirements given.
• Created WEBI Reports and generated graphs for multi-dimensional analysis using Drill Up and Drill Down functionality.
• Build Webi reports and hyperlink it to another report using Open Doc functionality.
• Build Reports on Cost Center and Billing PNL Rapid Mart extensively as per the user requirement with various level of hierarchy.
• Created reports for GM, CAPEX, OPEX, AP, AR, HR and Balance Sheet.
• Created the SAP BusinessObjects Dashboards 4.0 (Xcelsius) with Drill Down optionto one level. used Alerts while creating the Dashboards (Xcelsius).
• Created interactive reports in SAP BusinessObjects Dashboards 4.0 (Xcelsius) and exported dashboards in different formats.
• Created a hyperlink from Webi to an ECC Transaction.
• Dashboards and Webi reports build were tested before give to user for SAP source testing has been done with MDX and for non-SAP sources using Toad.
• Extensively worked with Excel Functions while Pivoting the Data (VLOOKUP, HLOOKUP) to SAP BusinessObjects Dashboards 4.0 (Xcelsius) Designer.
• Created Classes and Objects within the universes based on the user requirements.
• Delivered reports in phases and demo to Business users for feedback. Extensively used BEx Analyzer to build queries and worksheets to access data from BW data targets.
• Created reports with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts Using different functionalities like Breaks, Filter, Sorts, and Ranking to generate reports.

Environment: SAP BusinessObjects Enterprise XI R3.1, SAP Crystal Reports XI R2, SAP BusinessObjects Dashboards 4.0 (Xcelsius) 2008, Web Intelligence (Webi), BEX Analyzer, Data Integrator, SAP, Oracle, SQL Server 2005, QAAS, Live Office, Rapid Mart, Toad.