SUMMARY

• Over 7+ Years of solid experience in the field of IT with prominence on SAP Business Objects (BOBJ) /Business Objects Data Services (BODS), Business Intelligence (BI) including two full life cycle implementations in BI 3.5/7.0 and ETL Tool BODS 3.0/3.2/4.0.
• Proficient in all phases of Software Development Life Cycle (SDLC) including requirements gathering, Analysis, Design, Data Conversion, System Implementation, Performance Tuning, Testing and Support.
• 5+ years of Hands - on experience with data Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using BO Data Integrator and BO Data Services.
• Hands-on experience in working with Business Objects 4.0 Launch Pad, WebI, Dash Boards, Data Services, Universe Designer and Crystal Reports.
• Adept in using of Data Services Designer, Job Server Manager, Repository Management, Access Server, Data Services Management Console in Business Objects Data Services (BODS).
• Worked extensively with BEx Query Designer, BEx Analyzer, WAD (Web Application Designer) for developing reports, analysis, and Web reporting.
• Obtained relevant experience in ASAP methodology subsequent implementation phases such as Project Preparation (includes business requirement collection, business process analysis, gap analysis), Business Blueprint, Realization, Final Preparation (includes data loads, unit test, integration testing, power and end user testing), and Go Live & Support.
• ETL experience in extraction of various source data like RDBMS, flat files, XML files, Data profiling, Transformations and testing data quality using BODI.
• Experience in creating Repositories, designing Universes, Full Client/WebI reports, publishing and scheduling using Broadcast Agent for publisher and scheduler
• Skilful in BW Extractions, BW Modeling and BEX Reporting/Analyzer.
• Extensive knowledge with hands on experience in SAP BW/BI components and ETL process like creating Info Cubes, Multi Providers, Remote Cubes, Transactional/Real-time Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, ODS (DSO), Update rules, Transfer rules, Routines, Process Chains and Event management for Automation process, Transformations in BI 7.0/7.3 NW 2004s.
• Strong experience with OLAP reporting in BW/BI and implementation of BEx Analyzer.
• Hands-on experience on Queries, Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Crystal reports, Authorizations, User profile maintenance, BEx Analyzer, Info set query, RRI, Web reporting and Workbooks.
• Adept in extracting data from SAP R3/ECC, non-SAP systems, and flat files.
• Expertise in creation of Basic cube, Remote cube, Transaction cubes and DSO.
• Good understanding of Data Modeling using BW Extended Star Schema.
• Involved in managing of Info cube, which involves Info cube content, performance issues like Indices, Statistics, compression of Info cube and rolling up the data to the aggregates.
• Expertise in Business Explorer Analyzer for Reporting. Knowledge in Web Application Designer.
• Expertise in Generic Extraction of Table, Views and function Module.
• Adept in Building and enhancing BI objects dat include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.
• Hands-on experience with SAP BOE XI Central Management Console (CMC), Central Configuration Manager (CCM), Universe Designer, Web Intelligence (WebI), BO Dashboards, Crystal Reports, Xcelsius dashboards, Web Intelligence Rich Client, Desktop Intelligence (DeskI).
• Strong exposure to reporting in IBM COGNOS BI 8/10 and usage of Report Studio, Query Studio, Analysis Studio and Framework manager.
• Extensively used User conditions, Filters, Functions, Variables, Sort, Ranks, Drilling, Slice and Dice, Alerters, Sub queries, Prompts for creating efficient Business Objects reports.
• In-depth knowledge in creating reports, queries and performing analysis with IBM Cognos 8 BI.
• Hands on working experience with Windows 98/2000/XP/Vista/Windows 7/Mac, MS office.
• Experienced in working with database systems including SQL, Oracle and Access.
• Adherence to ASAP methodology in all projects and a person with strong will-do attitude.

TECHNICAL SKILLS

BW Versions: BW 3.5 & BI 7.0/7.3.

SAP Versions: 4.6C, 4.7 & SAP ERP (ECC 6.0).

SAP BW/BI: DW Workbench, DTP, Info Cube, DSO, Transformation, new PSA, and BI Accelerator.

Reporting: Business Objects Enterprise 12.0, BO XI R1/R2/R3/ 3.1, Business Objects 4.0, Info View/Launch Pad, Xcelsius2008/DashBoards4.0, Web Intelligence(WebI), Desktop Intelligence (DeskI), Crystal Reports 2008/4.0, BEx Analyzer, BEx Query Designer, QAAWS, IBMCognos BI 8/10 Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager.

ETL Tools: BI 7.0/7.3, Business Objects Data Services (BODS)4.0/3.2/3.1 (Designer, Repository Manager, Job Server Manager, Metadata integrator, Management Console), BO Data Integrator XIR 2/11.7/11.5.

Databases: Oracle, Teradata, Microsoft SQL Server, Access.

Applications: VMware, Microsoft Office - Word, Excel, PowerPoint, Outlook, Project.

Languages: ABAP, C, C++.

Web Technologies: HTML, DHTML.

Operating System: MS-DOS, WINDOWS 95/98/XP/Vista, WINDOWS 2003/2008 Server.

PROFESSIONAL EXPERIENCE

Confidential, Tallahassee, FL

Business Objects/BODS Consultant

Responsibilities:

• Requirement gathering by working with business users, Financial Analysts, Project managers, and involved in analysis and creation of architecture dat can be considered 'best practice' and scalable.
• Involved in the design, development and testing of Business Objects Data Integrator mappings.
• Prepared ETL functional and technical specifications.
• Developed complex mappings in Data Integrator to load the data from various sources into the Data Mart, using different transformations like Query, Table Comparison, Merge, Pivot, Reverse Pivot, Lookup, Key Generation, History Preserving, Date Generation, Map Operation and Validation etc.
• Extracting data from legacy systems into SAP data stores.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.
• Created Data Flows for dimension and fact tables and loaded the data into targets in DW.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs indifferent ways like indexing the source tables and using Data transfer transformation.
• Participated in Business Objects 4.0 up gradation Project.
• Involved in building and designing Universes and resolved Loops and Traps using Contexts and Aliases.
• Created Aggregate awareness functions on multiple summary tables to improve the query performance.
• Updated Universes as per the changes of the Database table structure and notified the users about changes made to the Universe.
• Involved in Migrating Business Objects system from version XI R2 to Business Objects XI 3.1.
• Set up Universe level conditions to restrict data based on report requirements.
• Created reports using Business Objects functionality’s like slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Used Import Wizard to migrate reports from one environment to another environment.
• Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
• Configured Local, Central and profile repositories and repositories are associated to the Job server.
• Access server is configured for Real time jobs. Scheduling jobs to run daily.
• Created Users in Data services management console and assigned roles based on the requirement.
• Supported Production environment and fixing the issues raised by the jobs while running in production.
• Designed the universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Created different types of reports like Master/Detail, Cross Tab and Chart.
• Developed various full client and thin client reports using Business Objects and Web Intelligence.
• Wide usage of Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
• Worked extensively on Designer, Web Intelligence (WebI), Desktop Intelligence (DeskI), Crystal reports, Central Management Console (CMC) and Developments of Crystal Xcelsius components Grids, Pie charts, Bar Charts and developed the animation actions for those components.
• Created QWS connectivity to WebI for refreshing Xcelsius with current data.
• Worked extensively with Data services Designer, Job Server Manager, Data Services Metadata integrator, Repository Manager, Data services management console in Business Objects Data Services (BODS).

Environment: SAP BO Data Services 4.0, Business Objects Data Services XI 3.1, SAP Business Objects Data Integrator XI 3.1, Business Objects XI3.1/4.0 (Designer, Business Objects DeskI, CMC,), Web Intelligence XI 3.1, (WebI), Info View, Dashboards 4.0/Xcelsius 2008, Oracle11g/10g, SQL, TOAD, MS Access, Excel, Windows NT/2000.

Confidential, Seattle, WA

Business Objects Consultant/BODS Consultant

Responsibilities:

• Requirement gathering by working with business users, Financial Analysts, Project managers, and involved in Analysis and creation of architecture dat can be considered 'best practice' and scalable.
• Converted existing Excel Reports and MS Access to Business Objects Reports.
• Defined and created classes, objects, conditions, users and measure objects to capture complex formulae.
• Created variables, formulae, grouping objects, and inserting prompts at report level.
• Designed and developed BODI scripts for data transformations.
• Created, validated and executed jobs to transfer data from various sources to target.
• Hands on experience in creating Query Transform, Map Operations, Table Comparison, Merge, Case, SQL And Validation of Transforms in order to load data from source to Target Systems
• Created Projects and maintain them using Management Console.
• Created various transforms and cases to clean the data.
• Created Projects, Work Flow, and Data Flows and applied business logics to pull the data from source to Target.
• Maintain different Databases in data sources of SAP Business Objects Data Services.
• Used SAP and Non SAP systems to pull the data using SAP Business Objects Data Services.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs indifferent ways like indexing the source tables and using Data transfer transformation.
• Worked extensively with Designer, Job Server, Data Services Engine, Repository, Access Server and Administrator in Business Objects Data Services (BODS).
• Utilized/managed various components of Business Objects Enterprise (BOE) XI 3.1 - Web Intelligence Rich Client, Central Configuration Manager (CCM) - Central Management Server (CMS), and BW Publisher for Crystal Reports reporting from Business Explorer (BEx).
• Worked extensively on Designer, Web Intelligence (WebI), Desktop Intelligence (DeskI), Crystal reports, Central Management Console (CMC) and Developments of Crystal Xcelsius components Grids, Pie charts, Bar Charts and developed the animation actions for those components.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs indifferent ways like indexing the source tables and using Data transfer transformation.
• Architected the Web Deployment strategy for Business Objects Web Reports using Web Intelligence, ZABO, automated document Scheduling and Publishing using Broadcast Agent.
• Doing production support and fixing the issues raised by the jobs while running in production.

Environment: Business Object Xi 3.0/3.1/3.2 Info View, Xcelsius 2008, Crystal Reports 2008, Business Objects Data Integrator (BODI), Business Objects Data Services XI 3.1 Oracle, SQL Server.

Confidential, Mclean, VA

Business Objects/ DI Developer

Responsibilities:

• Gathering the business requirements, functional requirements and data specification from the end users.
• Involving in CR’s (Change Request) Issues and resolving them in an estimated time period.
• Extracting Data from different sources like SIEBEL, SAP ABAP, ELVIS, ACCESS, EXCEL and flat files and loading them into requested target flat files, excel sheets, Oracle Tables in Data Integrator.
• 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, nvl, to char and Custom Functions like Send Email.
• Creating complex Data flows with inner R/3 dataflows and declaring parameters at different levels of Workflow.
• Creation of different datastores to get SAP P40 and SIEBEL PRD tables.
• Responsible for the Estimation and completion of CR Projects and also involved in Documentation of the Projects.
• Completing the requested tasks and projects on time as per user provided end Date with frequent interactions with source level users to end users involved in the Project.
• Involved in writing Stored Procedures and calling them at Pre Load command in Data Integrator Designer.
• Involved in scheduling and running Batch jobs on time at Data Integrator Administrator.
• Involved in working with Business Components in Informatica.
• Working with transformation like Expression, Update Strategy in Informatica.
• Involved in creation of sessions and running different tasks in workflow monitor in Informatica.
• Involved in designing Logical model with Entity Relationships in Microsoft Visio tool.

Environment: Business Objects XI (Data Integrator XI R2), Informatica 7.1/8.0,Cognos 7.1, Oracle 9i, SQL Server, DB2, PL/SQL, SQL Loader, SIEBEL, SAP ABAP, SAP BW, Microsoft Visio 2000, Windows NT/2000.

Confidential, Malvern, PA

Database Developer/ Report Developer

Responsibilities:

• Used Crystal Reports for designing of reports and multi grouping of data at report level as per client requirement.
• Displayed pie charts, bar graphs more understandable for top-level management using Analyzer in the reports.
• Deployed reports in Crystal Enterprise and setup of Scheduling, Publishing is done.
• Set up of Users, Groups, User Ids, Single sign-on, Report viewing privileges for Users are done in Crystal Enterprise.
• Extensively involved in using of formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Displayed reports for users on web browser by e-launch pad, e-portfolio using Crystal Enterprise.
• Extensively involved in SQL coding creating complex queries, Views, Stored procedures, Functions to give better results at Crystal Reports.
• Creation of packages, procedures, functions and triggers to boost the application performance.
• Created stored functions to manipulate table values before fetching it to the reports using queries.

Environment: Crystal reports 9, Crystal Enterprise 9, Oracle 8i/9i, SQL Server 2000, SQL*Plus, Toad, MS Excel, ASP, HTML/DHTML, VBScript, IIS Server, Web component server, Windows 2000, UNIX.