SUMMARY

• 8+ years of Experience in BI technologies as a Business Objects Consultant with a skill set of SAP BOXIR3.1/XIR3/XIR2/6.5/5.1.7, BO Designer, DeskI, WebI, InfoView, Dashboard, Scorecards, CMC, Xcelsius 2008/Crystal Xcelsius 4.5, Crystal Reports 2008/XI/10/9, DataServices 4.1/4.0/3.1/Data Integrator XI, Information Steward 4.0, Oracle 11g/10g/9i, Teradata 6.0, SQL Server 2008/2005/2000 , Microsoft Access 2000
• Over 5 years of experience in SAP BO DataServices
• Good understanding on Data Integrator concepts which involves creation of complex Jobs, Workflows, Data Flows, Writing Scripts and using different Transformations to successfully load data from multiple sources into a desired target
• Proficiency in DataWarehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture
• Extensively used DataServices Management Console to schedule and execute jobs, manage repositories and perform metadata reporting
• Experience in DataWarehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading using SAP Data Integrator/SAP Data Services with Oracle, SQL Server
• Experienced in ETL Methodologies using Business Objects Data Integrator Services XI 3.1 with IDocs, Data Quality, Data Profiling & RapidMarts and worked on Metadata Integration (BOMM - Business Objects Metadata Manager)
• Experience in gathering business requirements and building Universes, Reports and Dashboards
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness, applied row level and object level securities on different groups and users using Business Objects Designer
• Created ad hoc, canned reports and tested the reports in full-client and Webi environment for migration purposes, scheduled and published the reports using Broadcast Agent
• Hands on experience in Migration from 6.5 to BO XIR2 and BO XIR3
• Expertise experience in using CMC to Maintain Objects, Universes, Connections, Resources, Users, User Groups, User Restrictions and Categories in BO XI R3
• Worked with Crystal Reports 2008/XI/10/9 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports and data reports
• Experienced in creating InfoCubes using SAP BW 3.1/3.0B
• Excellent understanding of DataWarehouse architecture, Star Schema, Snowflake Schemas, Fact and Dimensions Tables
• Knowledge on Microsoft SSRS reports and Hyperion EssBase

TECHNICAL SKILLS

BI: SAP BO XIR3.1/XIR3/XIR2/6.5/5.1.7, Universe Designer, DeskI, WebI, InfoView, CMC, Crystal Reports, Xcelsius, Import Wizard, Broadcast Agent

ETL: BODI (Data Integrator XI), SAP Business Objects DataServices XI 4.1/4.0/3.1

Databases: Oracle 11g/10g/9i, SQL Server 2008/2005/2000 , Teradata 6.0, IBM DB2, MS Access 2000

Modeling: Erwin, Toad 9.7.2/8.2/8.0

Languages: C,C++, HTML, XML, CSS

OS: Windows NT, Windows XP Pro/2000 Server, UNIX

ERP: SAP ECC 6.0 (MM, SD, SCM, FICO, HR), SAP BW 7/4.5/3.1/3.0 B, Oracle Applications, Workday HCM

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAP BO Data Services Consultant

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Managed Repositories using administrator console as per developer/user requirements.
• Created mappings using Designer and designed workflows using Workflows to buildDW as per business rules.
• Most of the transforms used were like the Source Lookup, Case, Merge, and Sequence Generator.
• Prepared data Extract from legacy system and populating SQL Database on which datastore for BO has been created.
• Worked extensively on Data Profiling to assess the Data Quality and formulate the DataCleansing strategy.
• Designed templates to transform Legacy Master and Transactional data compatible to target
• SAP ERP system
• Developing and modifying changes in data flows according to the business logic.
• Creating Variables, substitution Parameters
• Creating Workflows, Data flows using Designer.
• Used SAP AIO templates for generating IDOCS and applied SAP best practices inDevelopment.
• Coding & Debugging, Sorting out their time-to-time technical problems.
• Analyze the types of business tools and transforms to be applied.
• Tuned performance for large data files by increasing block size, cache size and targetbased commit interval.
• Implemented performance tuning logic on sources, workflows, data flow’s and targetsin order to provide maximum efficiency and performance.
• Involved in writing the Unit Test Cases.
• Involved in migrating the jobs from Dev QA and to Production.
• Dealt with Unit Testing of all the mappings end to end and also with UAT.
• Provided Knowledge Transfer to the end users and created extensive documentationon the design, development, implementation, daily loads and process flow of themappings.

Environment: Business Objects Data Services 4.2, SAP ECC 6.0, Oracle 10g, MS SQL Server 2008, PL/SQL, T-SQL, HPQC/ALM 11.0.

Confidential, Knoxville, TN

Sr. SAP BO Data Services Consultant/Admin

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Extracted Vendor and Customer master data from SAP R/3.
• Implemented the rules against the data by using inbuilt Data Services transformations.
• External Web Service has been invoked using the Data Services to validate the vendor VAT numbers in SAP.
• Newly created Data Flows for each rule have been added to the existing ETL job.
• Documented the ETL specification and migration document.
• Created connections in CMC for the information Steward
• Performed column profiling and Address profiling using the Information Steward on SAP Master Data like vendor and customer for the business to understand the quality of source data.
• Evaluated SAP HANA product on an In-Memory appliance can boost the Business Reporting needs by doing a POC. Extracted SAP CO-PA data from SAP ECC into SAP HANA as part of the evaluation.

Environment: SAP BO Data Services XI 14.1.0.0/14.0.0.0 , Information Steward 4.0, SAP ECC R/3 (MM, SCM), SAP BW 7, SQL Server 2008, MS Office Suite and Windows Server 2008/2003

Confidential, Miami, FL

Sr. SAP BO Data Services Developer/Admin

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Coded the SQL queries of the Master and Encounter tables of the EPSI.
• Designed the ETL jobs based on the coded queries using SAP Business Objects Data Services.
• Used various transformations like Query, Case, and Merge transform.
• Worked on a script which perform both First load and Delta load
• Unit testing of the ETL code as per the business test cases to validate the code.
• Worked with Data Services management Console to schedule jobs, monitor log files and managing access rights to users.
• Documented the ETL specification and migration document.
• Analyzed the existing ETL project EDW
• Worked with business users on getting additional information from source systems to the Oracle EDW based on their reporting requirements.
• Used various transformations like Query, Case, and Merge transform.
• Worked on updating mapping document of the fields from the Source to the target.
• Automated the manual process using scripts in Data Services.
• Scheduling the EDW ETL jobs in the management console.
• Monitoring and Documenting the Load Stats of the EDW ETL jobs daily.
• Analyzed the existing ETL code for the EPSI Daily feeds.
• Worked with business users on the new enhancements for the EPSI daily feeds
• Designed the ETL code using the Data Services designer
• Used various transformations like Map Operation, Table Comparison, Row-Generation, Query and SQL transformation.
• Monitoring and Documenting the Load Stats of the EPSI Daily Feeds jobs daily.

Environment: SAP BO DataServices XI 14.0.0.0, Information Steward 4.0, Oracle 11g, Sybase ASE 15.x, Microsoft SQL Server 2005, DB2 UDB 9.x Toad for Data Analysts, MS Office Suite and Windows Server 2008/2003.

Confidential, Detroit MI

Business Objects Data Services Developer

Responsibilities:

• Gathered and documented all functional requirements and converted all functional requirements into technical specifications documents.
• Installed Business Objects Data Services 4.0.
• Involved in the Business Objects Data Services migration from 3.2 to 4.0.
• Upgraded all client machines with BODS 4.0.
• Involved setup and configured Business Objects data services central repository.
• Installed the data cleansing package after the installation of the BODS on server as well as on BODS client machine.
• Extracted data from different source systems like Oracle, SQL server, flat files and loaded into the Data warehouse & Data Marts.
• Implemented the Type2 slowly changed dimensions (SCD) by using history preserving transformation.
• Loaded the data into Customer Master IDOC (DEBMAS06).
• By referencing AIO CUSTOMER MASTER JOB, created the job to load into customer master segments.
• Used the query transform and English North American data cleansing, USA noncertified address cleansing, Match transform(to cleanse the Firm data) and Associate transform to generate Customer Master Basic data.
• Used the case, validation, merge transforms and lookup function to validate the CUSTOMER MASTER basic data (to find whether that record already exist in SAP or not).
• Using the ABAP dataflow, extracted the data from R3 table and generated the lookup tables.
• Implemented the Data Enrichment step as per the AIO schema.
• Extracted and loaded the data from SAP BW source.
• Extensively used the validation transformation in order to perform any validation rules before we load data into the warehouse.
• Scheduled and monitored jobs using Business Objects Management Console.

Environment: Business objects data services 4.0/3.2 ((Desktop Intelligence, Web Intelligence, Central Management Server, Central Management Console), Oracle 11g, Microsoft SQL server 2008, Flat files, Windows 2008 Server, Tomcat 5.5.

Confidential, Lexington, KY

Sr. BO/ETL Tech Lead

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Analyzed on how the current SSIS package works.
• Mapped all the tables from Oracle 11i to Oracle Rapid marts.
• Coded SQL queries for accounts like Gross Sales, Returns, Freight Costs, Cost of goods sold, Cost of returns, Sales Units, Sales Return Units, Other Discounts, Floor Model Discounts, Sales Allowances, AR trade Discounts, Exchange, Free Product Rebates, Rebates, Freight Costs, and Freight Charges.
• Implemented the Queries designed in Toad for all the accounts in Business Objects Data Services.
• Worked on a Rapid Mart dependency script as well as the script which performs First Load and Delta Load.
• Worked on a script which runs the Batch file at the End of the ETL jobs to load data from SQL Server Database into Hyperion Essbase cubes.
• Unit testing of the ETL code as per the business test cases to validate the code.
• Worked with Data Services management Console to schedule jobs, monitor log files and managing access rights to users.
• Documented the ETL specification and migration document.
• Analyzed the Business Requirements (functional & technical) with the Business users.
• Analyzed the existing Planning ETL jobs in the BO Data Services.
• Coded SQL queries on extracting Purchase orders with status as open, Demand history and inventory history.
• Implemented the queries in the SAP BO Data Services that will fetch data from Accpac ERP system.
• Unit testing of the ETL code as per the business test cases to validate the code.
• Documented ETL specification and migration document.
• Analyzed the Business Requirements (functional & technical) with the Business users.
• Added new ETL code to the existing Rapid marts ETL code to fetch the “OrdersonHold” Historical information from Oracle Applications.
• Calculated how long an order has been on hold.
• Documented ETL specification and migration document.
• Analyzed both business and functional requirements with the users.
• Worked with data quality transformations like Global address cleanse, data cleanse and match transforms to cleanse the customer data while migrating to the new Microsoft dynamics CRM.
• Unit testing of the ETL code as per the business test cases to validate the code.
• Worked with Data Services management Console to schedule jobs, monitor log files and managing access rights to users.
• Documented the ETL specification and migration document.

Environment: SAP BOXI 3.1, SAP BO DataServices XI 3.1, Crystal Reports 10, Oracle9i/10g/11i, SQL Server 2005, Oracle Applications (CRM), Hyperion Essbase, SQL Server Reporting Services, VisualStudio 2008, Visual SourceSafe, and Windows Server 2008/2003

Confidential, Santa Clara, CA

SAP BODI Developer

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users
• Extracted data from both RDBMS and Non-RDBMS sources into a target RDBMS
• Designed Jobs, Complex Workflows and Dataflow
• Created Scripts like starting script and ending script for each job and declaring the variables local and Global Variables
• Defined separate data store for each database to allow Data Integrator to connect to the source or target database
• Created, validated and executed jobs to transfer data from source to target
• Used lookup, lookup ext functions in SAP Data Integrator to load data from source to Target using a transform Table
• Performed both source and target based Capture Data Change to move changed data from source to target
• Used transformations like Map Operation, Table Comparison, Row-Generation, Query and SQL transformation
• Installed Address Dictionaries on the Data Services Job server and also Cleansing Package
• Worked with data quality transformations like global address cleanse, data cleanse and match transforms to cleanse the data of the different regions
• Used DataServices Management Console to Schedule jobs, monitor log file and managing access rights to users
• Experienced in Installing and Configuring DataServices
• Creating Universes, Classes, Objects, Measure Objects, Prompts, Conditions and Joins
• Resolving loops, fan traps, chasm traps using contexts and aliases, checking the Cardinalities and Integrity of the Universes
• Creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views to increase the performance of the universe
• Applied graphical representation to Web Intelligence reports such as Bar Charts and Pie Charts as per end user requirements
• Created various stacked bar Charts, percentage bar charts and pie charts for analyzing data in graphical format in Crystal Reports environment
• Deployed reports on web by using components of Business Objects Enterprise and worked with Business View Manager, Central Management Console and InfoView
• Wrote SQL and PL/SQL statements and created cut views from the Oracle tables along with stored procedures and functions

Environment: SAP BO XI 3.1, SAP BODS, Crystal Reports 2008, CMC, InfoView Oracle11g/10g, SQL Server 2005/2008, Web Intelligence XI 3.1, UNIX, Windows Server 2003

Confidential, Kansas City, MO

BODI Developer

Responsibilities:

• Gathering business requirements, functional requirements and data specification
• Detail design and development of mappings using Business Objects Data Integrator
• Extracted data from multiple heterogeneous sources like RDBMS, Excel Files, Flat Files and XML into a target RDBMS using Data Integrator and also extracted data from SAP ECC, SAP BW and stage them to DataMarts
• Used Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, and Validation Transforms in data integrator in order to load data from source to Target Systems
• Configured SAP to send IDocs to DI, and loaded Customer master data from SAP. Configured Web admin for IDocs
• Worked with sending IDocs to SAP to create new customer master data
• Developed ETL code using SAP Business Objects Data Integrator/DataServices
• Involved in creation of recoverable workflows during source and target server crashes
• Worked on performance Tuning of long running jobs used techniques like pushing down operations to database level, using cache memory, Degree of Parallelism, collect statistics to monitor jobs
• Developed mappings to support incremental loading. Used CDC tables as source tables for incremental.
• Installed and Configured Data Integrator
• Involved in creation of local repository and associating job server to it
• Migrated BO from 6.5 to XI R3.0
• Resolved Chasm traps, Fan Traps & Loop problems by using contexts and aliases to reduce the complexity of the universes
• Improved performance and reduced the coding with the use of @functions like @Prompt (for user defined queries), @Where (for creating conditional filters), and @Select to create duplicate objects in the process of building Universes
• Designed and Developed WEBI reports, created charts and graphs for quick analysis
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with the Alerter
• Preparation of Critical, Master Detail, Sub Reports, Cross Tab and Summary reports using Crystal Reports, features includes functions, running totals, parameters and conditional formats
• Created Dashboards using Xcelsius 2008/Crystal Xcelsius 4.5 for senior management for business decision making
• Created new users in XIR3 using Central Management Console and set restrictions, assign privileges based on their profiles

Environment: SAP ECC R/3 (FICO)SAP BOXIR3, Universe Designer, WebI, Data Integrator/DataServices, Xcelsius 2008/Crystal Xcelsius 4.5, Crystal Reports 2008/XI Oracle 10g, MS SQL Server 2008, Teradata 6.0, UNIX, Windows NT

Confidential, Tempe, AZ

BODI Developer

Responsibilities:

• Installed and configured Business Objects Data Integrator (BODI) in a multi-tier environment
• Designed and developed several Data Integrator(BODI) ETL batch and real time jobs for various clients with sources and target systems such as Oracle, SQL Server, SAP, XML and flat files
• Designed and developed several Data Integrator (BODI) ETL batch jobs
• Designed & developed error catching procedures in BODI jobs
• Developed ETL code using Business Objects Data Integrator
• Automating all error handling, error escalation, and email notification procedures
• Logical database design, physical database design, data modeling with Erwin/Model mart
• Developed several PL/SQL procedures
• Developed and Tested dashboards using Crystal Xcelsius 4.5
• Created complex Master Detail reports in Webi (Web intelligence) and Deski based on existing universes
• Trouble-shooting failed Business Objects reports by analyzing the SQL generated by the report
• Involved in developing customized dashboards, scorecards, and applications using Business
• Objects Application foundation to meet the organization's unique business needs using Xcelsius dashboard designer
• Designed Crystal documents using the advanced functionalities like drill down reports, sub reports and charts (side by side and stacked)
• Used QAAWS, Live Office Connector to build the Xcelsius Dashboards

Environment: Business Objects XIR1/6.5, Data Integrator XI, Crystal Xcelsius 4.5, Crystal Reports XI, Windows 2000, Oracle 10g/9i, IBM DB2, MS Access, TOAD 8.0

Confidential, Stamford, CT

BODI/BOBJ Developer

Responsibilities:

• Gathered requirements from both Functional and Technical teams to start the project.
• Designed the ETL processes using BO Data Integrator to load data from Oracle, SQL Server, Flat Files, (Fixed Width) and Excel files to staging database and from staging to the target Oracle DataWarehouse
• Extracted data from SAP ECC and staged them into a target database
• Developed ETL code using Business Objects Data integrator
• Created Scripts like starting script and ending script for each job and declaring the variables local and Global Variables
• Analyzed various DataWarehouse Models like Slowly Changing models, Conceptual Models, Logical Models.
• Worked on making full load jobs in to incremental loads using Map Operation, Table Comparison, and Auto Correct Load
• Configured SAP to send IDocs to DI, and loaded Material master data from SAP. Configured Web admin for IDocs
• Worked with sending Idocs to SAP to create new Material master data
• Worked on Try and Catch mechanism to handle errors and scripts objects, variables and parameters at data flow and work flow level
• Migrated jobs from test repository to production repository to schedule those jobs
• Implemented performance tuning concepts to BODI 6.5 ETL process
• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly
• Creation of Universes, Classes, Objects and Hierarchies for Multidimensional Analysis of the database using Business Objects 6.5 for the Accounting, Insurance, Technical, Finance and Sales departments
• Created Joins, Contexts, and Aliases for resolving Loops and removing cyclic dependencies and checked the Integrity of the Universes
• Business Objects Administration - like adding/deleting users, set up passwords and rights for users and group’s maintenance of BO Repository by scan and repair
• Migrated universe and reports from version 6.5 to XI R2
• Generated dashboards for finance and sales department using Crystal Xcelsius 4.5 for various regions they are located within
• Developed Crystal Reports based on InfoCube’s in SAP BW and included user defined formulas in those reports

Environment: BO XIR2/6.5, Universe Designer, WebI, Data Integrator XIR2/6.5, Crystal Xcelsius 4.5, Crystal Reports XI/10, Broadcast Agent, Oracle 9i, SQL Server 2000, PL/SQL, Windows XP Pro/2003 Server, Erwin Data Modeler, and TOAD 8.2

Confidential

BOBJ Developer

Responsibilities:

• Responsible for the System Study & Business Requirements Analysis & Documentation.
• Interaction with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Created Connections to Oracle Database, Microsoft Access Database by in turn creating the User and System DSN.
• Exported / Imported Universes and Documents to / from the Repository.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Resolved loops using contexts and aliases to remove the cyclic dependencies.
• Used Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer and Info View) to perform various tasks specific to each component.
• Configured Info View as the portal for Business Objects Web Intelligence.
• Created reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc.
• Used supervisor module establishing access privileges to documents and universes.
• Scheduled Web intelligence documents using Broad Cast Agent Server.
• Provided end user and production support after deploying the application into the production environment.
• Applied breaks on reports to get appropriate results after converting documents, Analyzed and explored the reports using Slice and Dice and Drill Down.
• Created complex reports using Crystal Reports.
• Developed dashboards using crystal Xcelsius 4.5 for senior management.
• Worked on SAP BW 3.0B to create InfoCube for sales department.
• Developed reports using Free-hand SQL and PL/SQL procedures

Environment: Business Objects 5.1.7 (Designer, Supervisor, WebI 2.7, Broadcast Agent, Publisher, Crystal Reports 10/9, UNIX, Webi SDK, BO SDK, ZABO), ASP, Erwin 4.0, Windows 2000, Oracle 10g/9i, SQL, PL/SQL SAP BW 3.0B