SUMMARY:

• Over 8 years of Experience in BI technologies as a Business Objects Consultant with a skill set of SAP Business Objects XIR3.1/XIR3/XIR2/6.5/5.1.7, Business Object Designer, Desktop Intelligence, Web Intelligence, InfoView, Dashboard, Scorecards, Central Management Console, Xcelsius 2008/Crystal Xcelsius 4.5, Crystal Reports 2008/XI/10/9, Data Services 3.1/Data Integrator XI, Oracle 11g/10g/9i, SQL Server 2008/2005/2000, Microsoft Access 2000.
• Over 5 years of experience in SAP BO Data Integrator/Data Services.
• Good understanding on Data Integrator concepts which involves creation of complex Jobs, Work Flows, Data Flows, Writing Scripts and using different Transformations to successfully load data from multiple sources into a desired target.
• 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.
• Experience in Data Warehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading using SAP Data Integrator/SAP Data Services with Oracle, SQL Server.
• 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 InfoCube’s using SAP BW 3.1/3.0B.
• Excellent understanding of Data Warehouse architecture, Star Schema, Snowflake Schemas, Fact and Dimensions Tables.
• Knowledge in Microsoft SSRS reports.

TECHNICAL SKILLS:

SAP Business Objects Suite XIR3.1/XIR3/XIR2/6.5/5.1.7, Universe Designer, Desktop Intelligence, Web Intelligence, InfoView, CMC Central Management Console, Crystal Reports, Xcelsius, Import Wizard, Broad Cast Agent.

ETL Tools

BODI (Data Integrator XI), SAP Business Objects Data Services XI 3.1

Databases

Oracle 11g/10g/9i, Microsoft SQL Server 2008/2005/2000, IBM DB2 and Microsoft Access 2000.

Data Modeling Tools

Erwin, Toad 9.7.2/8.2/8.0

Languages

C,C++, HTML, XML, CSS

Operating System

Windows NT, Windows XP Pro/2000 Server, UNIX

SAP

SAP BW 3.1/3.0B

EDUCATION:

• Bachelors in Computer Science

PROFESSIONAL EXPERIENCE:

Confidential,November 2011 – Ongoing
Sr. BO ETL Developer

Workday SAAS systems is being rolled out continental wise globally and as a team member of Data Conversion team our aim is to get the cleaner and accurate data into Workday HCM. Payroll Integration Common Output files will be generated for each country from the Workday SAAS system. Using Business Objects Data Services Flat files are generated based on the data in Payroll Integration Common Output files and will be sent to the respective Payroll vendors in each country.

Projects & Responsibilities:
Data Conversion: The main objective is to cleanse the data from the countries before loading into Workday HCM.

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Extracted data from Excel files into SQL Server database using business objects data services.
• Designed Jobs, Workflows and Dataflows.
• Calling the Stored Procedures in the ETL job which deletes the data from SQL Server database before loading respective country data.
• Prepared a script which will check for the existence of flat file before loading data into the Database.
• Prepared T-SQL queries for the data cleansing in the SQL Server 2008.
• Worked with data quality transformations like global address cleanse and data cleanse to cleanse the data of the different regions.
• 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.
• Worked with the Excel worksheets of the different countries and setting up different conditional formatting rules based on the business logic.
• Made use of excel functions like vlookup and string functions to populate data dynamically based on the values enter by the users.

Data Integration: PICOF’s are generated based on the data in the Workday and using Data Services flat files will be generated and sent to the payroll vendors based on the requirements from payroll vendors.

• Analyzed the Business Requirements (functional & technical) with the Payroll Vendors.
• Scheduled the PICOF jobs in workday which will create the XML files.
• Extracted data from the XML files using business objects data services based on the XSD provided by the workday and generated Flat Files.
• NRDM structure of the XML files are transformed into a relational model by unnesting the XML schema.
• Used various transformations like Query, Case, and Merge transform.
• Created batch job to assign various ID’s like Network ID, Vendor ID etc. based on new business logic and exposed the job as web service and such that it could be called from Workday system.
• Used TRY CATCH blocks to capture any exceptions.
• Prepared a script which will check for the existence of the XML file.
• Experienced in Data Migration from one repository to another repository.
• Scheduled and Monitor jobs using Data Integrator Management console.
• Documented the ETL specification and migration document.

Environment: SAP Business Objects Data Services XI 12.2.3.2, SQL Server 2005/2008, Workday SAAS system (ERP), Microsoft Office Suite and Windows Server 2008/2003.

Confidential, October 2010 – November 2011
Sr. BO/ETL Tech Lead

“Customer Profitability” ETL project has provided the insight into the Gross Sales, Costs, Sales Units and discounts data where customer relationship will be assessed in a greater detail. “Integrating Canada into planning System” ETL project has helped the business in forecasting sales and operation for the region Canada. Apart from that worked on crystal reports, SSRS reports and Oracle Applications.

Projects & Responsibilities:
ETL Project 1: The main objective of the “Customer Profitability” project is to analyze the customer relationship based on gross revenue and costs associated with servicing the client. Reports will be generated based on the data to analyze the financial data in multiple views.

• 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.
• 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.

ETL Project 2: The main objective of the “Integrating Canada into Planning System” project is to integrate Canada into the planning systems using SAP BO Data Services for the sales and operations planning in Zemeter.

• 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.
• Documented ETL specification and migration document.

ETL Project 3: The main objective of this project is to get the “OrdersonHold” Historical information into the Rapid Marts.

• 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.

Reports:

• Worked with the operations department for gathering the business requirements.
• Coded SQL query in toad which will fetch all the cancelled load plans with “PC” as status.
• Coded SQL query in toad which will fetch the entire pending inventory with “PW” as status.
• Implemented the SQL query in Crystal Reports and designed the “Pending Warehouse Cancellation report”.
• Implemented the SQL query in Crystal Reports and designed the “Pending Inventory Check report”.
• Worked on Central management Console and InfoView in deploying and scheduling the designed Pending Warehouse Cancellation Report and pending Inventory Check Report.
• Documented and trained users on how to schedule and run an On-Demand Pending Warehouse Cancellation Report and pending Inventory Check Report using InfoView.
• Generated DoorSlot and StoreVisits SSRS reports for the US sales department using Microsoft Visual Studio 2008.
• Generated StoreVisits summary SSRS reports for the Canada sales department using Microsoft Visual Studio 2008.
• Deployed US DoorSlot, StoreVisits and Canada StoreVisits summary SSRS reports using Reporting Services Configuration Manager on the web.

Oracle Applications project:

• Worked on the Order Management Sysadmin module in Oracle Applications.
• Worked on a PL/SQL package which calls the procedures and cursors to generate an Email Alert when a concurrent program in Oracle Application fails.
• Worked on a PL/SQL package which calls the procedures, functions and cursors to generate an XML file for the 3rd party carriers.

Environment: SAP Business Objects XI 3.1, SAP Business Objects Data Services XI 3.1, Crystal Reports 10, Oracle9i/10g/11i, SQL Server 2005, Oracle Applications (ERP), Microsoft SQL Server Reporting Services, Microsoft Visual Studio 2008, Microsoft Visual Source Safe, and Windows Server 2008/2003.

Confidential,CA June 2009 – September 2010
SAP BODI Developer

SVB Financial Group provides diversified financial services to emerging, growth and established technology companies and the life science, venture capital and premium wine markets. As a Business Objects Data Integrator developer I was responsible for extracting data from different heterogeneous data sources into a target database.

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.
• Extensively 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 various transformations like Map Operation, Table Comparison, Row-Generation, Query and SQL transformation.
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data.
• Developed ETL code using SAP Business Objects Data Integrator/Data Services.
• Migrated Jobs, Workflows, Data Flows from test repository to production repository.
• Backed up entire target repository and databases before data migration
• Documented the ETL process using auto documentation in Data Services Management Console.
• Extensively used Data Services Management Console to Schedule jobs, monitor log file and managing access rights to users.
• Experienced in Installing and Configuring Data Services.
• Creating Universes, Classes, Objects, Measure Objects, Prompts, Conditions and Joins.
• Resolving the loops, fan traps, chasm traps using contexts and aliases, checking the Cardinalities and Integrity of the Universes.
• Worked on 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.
• Written SQL and PL SQL statements and created cut views from the Oracle tables along with stored procedures and functions.

Environment: SAPBusiness Objects XI 3.1, SAP Business Objects Data Services, Crystal Reports 2008, CMC, InfoView Oracle11g/10g, SQL Server 2005/2008, Web Intelligence XI 3.1, Windows Server 2003.

Confidential,MO May 2007 – May 2009
BODI Developer

Americo Financial Life and Annuity Insurance Company have been doing business for over 100 years. Americo Life, Inc., our holding company, is currently one of the largest, independent, privately held insurance companies in the United States. The project is mainly about extracting data from different heterogeneous sources into a target database for Finance department to study more about customers by doing analytical reporting on the information.
Responsibilities:

• Actively involved in gathering business requirements, functional requirements and data specification.
• Involved in 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 data marts.
• Extensively used Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, and Validation Transforms in data integrator in order to load data from source t o Target Systems.
• Used TRY CATCH blocks to specify alternative work flows if errors occur during job execution.
• Involved in Creation of jobs that specify data mappings and transformations by using Data Integrator Designer.
• Developed ETL code using SAP Business Objects Data Integrator/Data Services.
• 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 change data capture (CDC) tables as source tables for incremental.
• Design and developed SAP Data Integrator scripts for data transformation.
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data.
• Experienced in Data Migration from one repository to another repository.
• Scheduled and Monitor jobs using Data Integrator Management console.
• 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.
• Worked with CMC (Central Management Console) to set-up the security credentials (User Profiles) for the user community and configured the connections and the services.
• Migrated Reports, Universes, User root folder rights from 6.5 to XI R3.0 and other environments using Import Wizard and BIAR files.
• Interacted with Business community to gather and analyze the Business Requirements in developing and modifying Universes and building the reports.
• Resolved Chasm traps, Fan Traps & Loop problems by using contexts and aliases to reduce the complexity of the universes.
• Improved the 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 the Universes.
• Created custom List of Values (LOVs) for better understanding of prompts by the end users.
• Applied User and Group Restrictions in selected objects in universe level based on User and Group types.
• 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: SAPBusiness Objects XIR3, Universe Designer, Web Intelligence, Data integrator/Data Services, Xcelsius 2008/Crystal Xcelsius 4.5, Crystal Reports 2008/XI Oracle 10g, MS SQL Server 2008, Windows NT.

Confidential,AZ October 2006 – April 2007
BODI Developer

This project is about converting the legacy Data warehouse DataMart ETL written in SQL/ PL/SQL code into Data Integrator Jobs.

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,CT February 2006 – October 2006
BODI/BOBJ Developer

The goal of the project is to build a data warehouse for Sales Department by extracting data from different sources into the respective dimensions in the target data warehouse.
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 Data Warehouse.
• Extracted data from SAP modules 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 Data Warehouse 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.
• Effectively worked on Try and Catch mechanism to handle errors and scripts objects, variables and parameters at data flow and work flow level.
• Used various Platform and Data Integration Transformations for data manipulation.
• Migrated jobs from test repository to production repository to schedule those jobs.
• Implemented performance tuning concepts to the whole Business Objects Data Integrator 6.5 ETL process.
• Scheduled and Monitor jobs using Data Integrator Management console.
• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in the 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 of the company.
• Created Joins, Contexts, and Aliases for resolving Loops and removing cyclic dependencies and checked the Integrity of the Universes.
• Weekly Production moves made to the universe. Created Dimension, Detail, as well as complex Measure objects, adding tables, revalidating joins.
• Created Master-Detail reports using Drill down/up functionality for the Decision Support System regarding to the company’s Sales Revenue, Insurance and Loan Analysis.
• Applied Filters, Breaks and Calculations to the required reports and also sorts for flexible data representation.
• Using SQL tools like TOAD to run PL/SQL queries and validate the data in Full Client reports.
• Migrated universe and the canned reports Testing (QC) environment to the Production Environment.
• Analysis, design and implementation of reports in Business Objects 6.5 for the deployment of strategies in the Business Analysis.
• Monitoring Business Objects Broadcast Agent and Web Intelligence servers. Scheduling of reports on a daily/weekly/monthly basis using Broadcast Agent Server.
• 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 in.
• 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, Web Intelligence, Data Integrator XIR2/6.5, Crystal Xcelsius 4.5, Crystal Reports XI/10, Broad Cast Agent, Oracle 9i, SQL Server 2000, PL/SQL, Windows XP Pro/2003 Server, Erwin Data Modeler, TOAD 8.2