SUMMARY

• Over 8 Years of Professional Experience in the field of IT wif 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.
• Proficient in all phases of Software Development Life Cycle (SDLC) including Requirements gathering, Analysis, Design, Data Conversion, System Implementation, Performance Tuning, Testing and Support.
• Hands - on experience wifData Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using BO Data Integrator and BO Data Services.
• Extensive experience in working wif 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).
• 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.
• Experience in creating Repositories, designing Universes, Full Client/WebIReports, publishing and scheduling using Broadcast Agent for publisher and scheduler.
• Extensive knowledge wif hands on experience in SAP BW/BI components and ETL processeslike creating InfoCubes, Multi Providers, Remote Cubes, Transactional/Real-time Cubes, Data Marts, Info Source, Info Package, Data Source, InfoObjects, ODS (DSO), Update rules, Transfer rules, Routines, Process Chains and Event management for Automation Process, Transformations in BI 7.0/7.3.
• Strong experience wif OLAP Reporting in BW/BI and implementation of BeX Analyzer.
• 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 InfoCube and rolling up the data to the aggregates.
• Hands-on experience wif 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.
• Experienced in working wif database systems including SQL, Oracle and Access.

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, Billerica, MA

Senior Business Analyst /SAP Business Objects/BOBJ Developer

Responsibilities:

• Requirement gathering by working wif business users, Financial Analysts, Project managers, and involved in analysis and creation of architecture that can be considered 'best practice' and scalable.
• Hands on experience working wifin an IT/Technology organization.
• Involved in Business Process Management (BPM) activities like Process Design, Process Monitoring and Process Execution.
• Created UI Documents as supporting documents for the Business Requirements Documents.
• Developed Excel formulas for testing and verification of insurance premiums, forward/backward traceability of functional requirements.
• 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 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 wif 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.
• 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 wif 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 wif current data.

Environment: 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, JIRA, Oracle11g/10g, SQL, TOAD, MS Access, Excel, Windows NT/2000.

Confidential, Tallahassee, FL

Senior SAP Business Objects/BOBJ Consultant

Responsibilities:

• Elicited requirements from the business stakeholders using various requirement gathering techniques such as: end-user interviews, job shadowing, questionnaires and involved in analysis and creation of architecture that can be considered ‘best practice’ and scalable for implementation of project deliverables.
• Designed, developed, maintained and tested the single/multiple source Universes.
• Created Universes and developed the WebI reports and dashboards using IDT (Information design tool).
• Created WebI Reports connectivity through BEx Queries for Hierarchical Data.
• Used Contexts and Aliases to resolve the loops that were caused because of the conformed dimensions.
• Defined various restrictions for the Universes to restrict key information.
• Created MTD, YTD and PTD reports that helped in providing a sound analysis for Investigations.
• Used OpenDocument functionality extensively to create hyperlink sub-reports, to allow for mixing of summary and detail data.
• Created Complex Drill down reports wif integrated summary information in the data warehouse which were useful in identifying Child and Adult Investigations.
• Extensively used Calculation contexts, Variables, Breaks, Sections, Ranks and Alerts in the creation of reports.
• Created Sub Reports, Cross Tab, Graphs, Charts, Ranking, Alerts for Children Scorecard Reports.
• Analyzed and identified ways to improve the performance of Reports and Universes.
• Developed Adding/Changing Logos and Customizing InfoView Web Page.
• Helpdesk Troubleshoot: User Access, report Subscription, BOE Password problem issues, Resolving High priority tickets.
• Administrative Tasks of BOE in Dev/UAT/Pilot/Production such as creating users, giving access, managing services, scheduling reports.
• Scheduled CBC (Community Based Care) user Reports to FTP Server.
• Created (.biar Files) migrated Users, Groups, Universes, Reports from One Region to another region using Import Wizard/Upgrade Management Tool.
• Worked directly wif Agency Health Care Administration (AHCA) for Data Exchange.
• Developed Health Care Reports for children like Child Welfare Pre-Paid Mental Health Program (CWPMHP) Enrollment, Psychotropic Medications Claims Validation Match and Child in Care Provider Billing.
• Developed test plans and created test scripts to perform Unit testing and System testing of the Universes and reports.
• Created Projects, Work Flow, and Data Flows and applied business logics to pull the data from source to Target.
• Developed complex mappings in Data Integrator to load the data from various sources like Tables, Flat Files, and Excel Sheets into Data Mart using different Transformations like SQL, Query, Merge, and Table Comparison.
• Moved the projects from DEV to ST, ST to UAT and UAT to Production.
• 24/7 Production/On Call Support for BOE Reports, Servers and BODS Jobs.
• Worked Closely wif AutoSys Scheduling team to Schedule Reports and ETL (Batch) Jobs.
• Involved in helping the users throughout the UAT phase.
• Used ClearQuest and ClearCase for Change and Version Control Management.
• Provided Business Objects information sharing sessions and training to the Users.

Environment: Business Objects XI 3.1/4.0, Designer/Information Design, BI Launchpad/Info View, WebI Rich Client, DeskI, CMC, CCM, Import Wizard, Crystal Reports 2008/2011,Dashboard Design/Xcelsius, BEx Queries,Business Objects Data Services XI 3.2, Data Services Designer, Data Services Integrator, Data Services Management Console, AutoSys, IBM Clear Case, Clear Quest, Windows 2003 Server, IBM-DB2.

Confidential, Seattle, WA

Business Objects Consultant

Responsibilities:

• Involved in Requirement gathering by working wif business users, Business Analysts, and involved in Design and implementation of project deliverables.
• 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.
• 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.
• Involved 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 wif 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.
• Created complex Data flows wif inner R/3 dataflows and declaring parameters at different levels of Workflow.
• Created different data stores 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 wif frequent interactions wif 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 wif Business Components in Informatica.
• Working wif 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 wif 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 9i/8i, SQL Server 2000, SQL*Plus, Toad, MS Excel, ASP, HTML/DHTML, VBScript, IIS Server, Web component server, Windows 2000, UNIX.