SUMMARY

• Over 9+ Years of Professional experience in 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 and ETL Tool BODS 3.0/3.2/4.0/4.2.
• 6+ years of ETL Experience wif Informatica System Architecture and Administration
• Proficient in all phases of Software Development Life Cycle (SDLC) including requirements gathering, Analysis, Design, Data Conversion, System Implementation, Performance Tuning, Testing and Support.
• Extensive experience wif 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 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).
• Expertise in extracting data from various Legacy Systems to SAP ERP, SAP HANA and from SAP ERP to DWH using SAP BODS. Involved in several Data Migration / Data Quality/ Address cleanse Projects. Expertise in data loading to SAP ECC using IDOCS, LSMW, BAPI, RFC, ABAP Data Flows. Experience in implementing Data Warehousing Slowly changing demensios SCD TYPE1, TYPE2, and TYPE3.
• Worked extensively wif 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.
• Strong experience in data migration, conversion and interface SAP projects involving SAP ECC, MDM, CRM & NON-SAP like SQL Server, DB2, and Oracle.
• 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 noledge wif 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.
• Expertise in performance tuning of SQL queries, ETL code and writing efficient and complex queries on huge volumes of data.
• Created UNIX shell scripts to run teh Informatica workflows and controlling teh ETL flow.
• Strong experience wif 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.
• Programming proficiency - application development expertise using Crystal Reports, Business Objects Enterprise, Oracle, SQL Server, SSRS, SSIS, MS Access and UNIX.
• 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 teh data to teh 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 that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.
• 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).
• Experience in LSMW for data loads to SAP R/3 and other concepts like IDOC, BAPI and BADI.
• Experience working wif databases like Oracle, DB2, MS SQL Server 2005, Teradata, MS Access, MySQL also wif Flat files, Excel and XML files.
• Delivered no.of objects on all kinds of sub-modules in HR module and other modules like MM, SD, WM, PP, PM, FI & HR etc.
• Expertise in extracting data from various Legacy Systems to SAP ERP, and from SAP ERP to DWH using SAP BODS. Involved in Few Data Migration / Data Quality Projects.
• Worked on various SAP ECC on data migration, conversion and interface projects and involved from teh inception teh projects till go-live including requirements gathering, analysis, design and implementation of 2 SDLC implementations using SAP best practice migration methodologies.
• Techno/Functional noledge on SAP SCM, OTC, P2P,FI which includes Customer Master, Vendor Master, Material Master, Credit Master, Open Sales Orders, Customer Contacts, Customer Hierarchy, Inventory, Fixed Assets, BOMs, Routings, Characteristics, GL Balances, Cost Centers, Profit Centers, Accounts Payable, Accounts Receivable, Bank Master, Open Purchase Orders, Purchase Information Records (PIRs), Open Production Orders, Open Work Orders, Functional locations, Freight Conditions, Work Centers, Bins, PM Equipment, Classifications, PM Characteristics, Work Centers, Rate Routings etc.
• Strong RDBMS concepts and Experienced in creating Stored Procedures, Views, Functions, Packages, Triggers using PL/SQL and T-SQL.
• Having experience in SAP BW implementation for SAP CPM (Commercial Project Management)
• Strong exposure to reporting in IBM COGNOS BI 8/10 and usage of Report Studio, Query Studio, Analysis Studio and Framework manager.
• SAP BW extractors for SAP ECC modules and SAP CPM module
• Worked wif BODS to extract data from Legacy Systems to BW.
• Diversified experience in implementation of Business objects in Finance, Health, Sales, Retail, Production and Insurance sectors.
• 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 noledge in creating reports, queries and performing analysis wif IBM Cognos 8 BI.
• Hands on working experience wif Windows 98/2000/XP/Vista/Windows 7/Mac, MS office.
• Experienced in working wif database systems including SQL, Oracle and Access.
• Adherence to ASAP methodology in all projects and a person wif 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.2/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, Pontiac, MI

Sr. SAP BODS Consultant

Responsibilities:

• Gathering requirements from Business Users to prepare functional specification and develop technical Specification.
• Responsible for assigning teh team resources to teh various tasks to meet teh deadlines before Go-Live.
• Performing day to day administrative activities such as user creation, folders creation, permission setup and other typical administrative tasks. Delivering ETL and related components as specified in teh design, functional and non-functional requirements, wifin established time and quality standards.
• Responsible for successful deployment of BI platform and Business Objects Enterprise to support
• SOA of organization.
• Designed and developed BODI scripts for data transformations.
• Crated IDOC's for Customer and Vendor.
• Designed Best Practices documentation for Business Objects 4.0(IDT, BI Launch Pad, Administration)
• Worked wif BODS to extract data from Legacy Systems to BW
• Developed BO Security models (Developer User, Power User, and Refresh User) to access BO Environment.
• Create Technical Specifications Document for each validation object
• Developed teh Financial Universe using Information Design tool (IDT) and Web Intelligence Reports.
• Provided Training to business Users how to execute reports and developing reports for Adhoc users.
• Creating complex Data flows wif inner R/3 dataflows and declaring parameters at different levels of Workflow.
• Experience in using SAP Business Objects Data Quality for Data Migration, Address Cleansing and Matching in large projects.
• Involved in target system (ERP) Validation after running teh IDOC Jobs in DS.
• Integrated Oracle, HANA Databases through Data stores in Designer.
• Used SAP and Non SAP systems to pull teh data using SAP Business Objects Data Services.
• Involved in migration activities from DS 3.2 to 4.0
• Developed HR Reports and Universe (IDT, UDT) and BICS top of SAP BW systems.
• Improved performance of existing SAP BW Queries and reports by creating Aggregates, Compression, Olap cache and Partition etc
• Created LSMW and IDOC structures depending on requirements for loading of data into target system.
• Administering and maintaining BO Data Services management console and repository management.
• Creating Cardinalities, Contexts, Joins and Aliases for resolving Loops
• Checking teh Integrity of teh Universes.
• Developed derived tables for complex Sql in Universe.
• Modified Universe after analyzing areas of business and user requirements.
• Developed complex reporting and formulas.
• SQL tuning of reports to increase performance.
• Upgraded teh BO 4.0 environment to BO 4.1
• Coordinate wif Informatica Corporation to solve system issues and environment tunings.
• Created Projects, Work Flow, and Data Flows and applied business logics to pull teh data from source to Target.
• Coordinating wif Data Stewards in providing status periodically and highlighting teh data validation errors
• Designed teh Reports to access teh Stored Procedures, Views and Packages.
• Installation, migration, configuration, maintenance, technical support and troubleshooting of Business Objects and Dashboard -Xcelsius implementation in a shared environment.
• Creating Tableau Dashboard- combining data from multiple data sources
• Good Experience in Java development and ETL processes.
• Highly Interactive Dashboard completely based on dynamic user input and varying amount of information to analyze wifout limitations being provided to teh user.
• Various other forms of dashboard development also performed including Data from Universe using QAAWS, Data from Webi reports using Live Office.
• Created Jobs in Data Services to load teh data from spread sheet in to Data warehouse and also made this job incremental.

Environment: Business Objects XI R2/XI 3.1/4.1, IDT, BI Launch Pad, BO Designer, Web Intelligence, Desktop Intelligence, Informatica, Dashboard, BW, HANA, Data services 4.1, Crystal Reports, Oracle 11g, Windows XP/2007.

Confidential, Wichita, KS

Senior SAP BODS Consultant

Responsibilities:

• Prepared Source and Target Mapping documents by working wif Customer, Business Analyst and Project managers.
• Created complexJobs, Work Flows, Data Flows, and Scriptsusing various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Strong experience in cleansing teh data usingData Qualitytransforms in ETL and using constraints in Database.
• Developed jobs to load teh data from Flat Files (Fixed Width) into staging area and developed transformations that apply teh business rules given by teh client and loaded teh data into teh target database.
• Involved in Data migration / Data Conversion using BODS/LSMW / BAPI / and IDOCS
• Implemented SAP BOBI 4.1 SP2 in Dev, QA and Production environments.
• Involved in migration activities from DS 3.2 to 4.1
• Migrated content from 3.1 to 4.1 using upgrade management Tool.
• Configured AJS, APS servers for better performance
• Used different transforms such asSQL, Query,Case,Table Comparison,Key Generation,Row Generation, Merge, Pivottransforms and functions likeiftanelse(),substr,lookup extetc.
• Created Datastore Configurations for a single Data store to deploy data from one environment to different environments.
• Published Batch Job’s into Webservices using Custom WSDL labels concept in management console.
• Manage ETL defects and enhancements to meet business requirements.
• Experience in Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.1 for loading data from SAP ECC system to SAP HANA
• Used Table Comparison transform to load Slowly Changing Dimensions.
• Deveolped Conditional Work flows for teh jobs inorder to execute necessaay workflows.
• Created Substitution Parameter Configutation’s for a job’s to assign local variable’s while executing teh Job.
• Created Custom Functions and Validation Functions for Date and Amount Conversions.
• Experience indebuggingexecution errors usingData Services logs(trace, statistics and error) and by examining teh target data.
• Used Business Objects Designer to create Universe, classes, sub-classes, objects, filters and hierarchies for providing drill down options for end users.
• Involved in user training sessions for and assisting in UAT (User Acceptance Testing).
• ProvidedKnowledge Transferto teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mappings.

Environment: SAP BO Data Services 4.2 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console),SAP Business Objects 4.1(Information Designer Tool, BI Launch Pad, CMC), Oracle 11g, Toad, Sql Developer, TortoiseSVN Repository, Windows 2003 Server.

Confidential, Fort Myers, FL

Senior SAP BODS Consultant

Responsibilities:

• Involved extensively in implementing a phased approach during teh upgrade to Business Objects BI 4.0
• Participated in planning sessions wif ETL team to analyze and design teh methodology for building teh Sales Data warehouse
• Interacted wif various Sales Specialists and Business users to understand teh system and gather requirements.
• Worked in multiple responsibilities includingETL architecture,ETL design,analysis and development, writing technical specifications.
• Created projects, batch jobs, Real time jobs, work flows and data flows.
• Responsible forcreating mapping and transformationspecifications based on teh business requirements from various business teams and implemented inData Integrator jobs.
• Worked on Source to Target Mapping design.
• Designed, developed, maintained and tested teh Universes.
• Designed Universes for multiple subject areas and implemented Linked universes using advanced features such as Aggregate Awareness, Contexts etc.
• Used Contexts and Aliases to resolve teh loops that were caused because of teh conformed dimensions.
• Creating a custom IDOC.
• Involved in Designing and developing BODS Jobs for De-dup, match, Address Cleansing for North America, Data Profiling, Data Cleansing activities
• 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 teh animation actions for those components.
• Defined various restrictions for teh Universes to restrict key information.
• Created MTD, YTD and PTD reports that halped in providing a sound analysis for Sales Forecasting.
• Created Stories/Dashboards using Lumira 1.28.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Dashboard 4.0.
• Integrated Oracle, HANA Databases through Data stores in Designer.
• Involved in data loads from SQL Server to SAP Hana using BODS as part of teh batch load process for teh business critical KPI's.
• Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.
• 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 historical sales information in teh data warehouse which were useful in identifying future pricing models.
• Extensively used Calculation contexts, Variables, Breaks, Sections, Ranks and Alerts in teh creation of reports.
• Excellent experience in Migrating Informatica repositories from SQL Server to Oracle 10G
• Created several dashboards using Xcelsius wif Live Office and Query as a Web Service.
• Analyzed and identified ways to improve teh performance of Reports and Universes.
• Developed test plans and created test scripts to perform Unit testing and System testing of teh Universes and reports.
• Involved in halping teh users throughout teh UAT phase.
• Used Synergy and PVCS for Change and Version Control Management
• Provided Business Objects information sharing sessions and training to teh Users.

Environment: Business Objects XI 4.0/ XI 3.1, Designer, Information Design Tool, BI LaunchPad, BI Workspace, LCM, Upgrade Manager, Business Objects Data Services XI 3.2, 4.1, Data Services Designer, Data Services Integrator, Data Services Management Console, SunOS 5.10, Oracle Application Server, SQL Server2003, Oracle11g, Teradata V2R6.1, PL/SQL, Xcelsius.

Confidential, Billerica, MA

Lead Business Analyst /SAP BODS 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 project management/implementation, QA testing, offshore coordination and production support wif hands-on technical and functional expertise on Enterprise Data Warehouse (EDW) and Enterprise Reporting & Analysis.
• Extensively used ETL to load data from Flat Files, XML, and Oracle to Oracle 8i.
• Involved in Business Process Management (BPM) activities like Process Design, Process Monitoring and Process Execution.
• Created UI Documents as supporting documents for teh 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 teh data from various sources into teh 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 teh data into targets in DW.
• Tuned Data Integrator Mappings and Transformations for teh better performance of jobs indifferent ways like indexing teh 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 teh query performance.
• Updated Universes as per teh changes of teh Database table structure and notified teh users about changes made to teh 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 teh Job server.
• Created Users in Data services management console and assigned roles based on teh requirement.
• Supported Production environment and fixing teh issues raised by teh jobs while running in production.
• Designed teh universes by creating teh Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve teh loops, subdividing into contexts and creating teh 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 teh reports in accordance wif teh 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 teh 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, T-SQL, TOAD, MS Access, Excel, Windows NT/2000.

Confidential, Tallahassee, FL

Lead BI/BODS Consultant

Responsibilities:

• Elicited requirements from teh 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 teh single/multiple source Universes.
• Created Universes and developed teh 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 teh loops that were caused because of teh conformed dimensions.
• Involved in project management/implementation, QA testing, offshore coordination and production support wif hands-on technical and functional expertise on Enterprise Reporting & Analysis
• Defined various restrictions for teh Universes to restrict key information.
• Created MTD, YTD and PTD reports that halped 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 teh data warehouse which were useful in identifying Child and Adult Investigations.
• Extensively used Calculation contexts, Variables, Breaks, Sections, Ranks and Alerts in teh creation of reports.
• Created Sub Reports, Cross Tab, Graphs, Charts, Ranking, Alerts for Children Scorecard Reports.
• Analyzed and identified ways to improve teh 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 teh Universes and reports.
• Involved in implementing ECC to Success Factors migration for Benefits, Payroll, employee Data, Foundation Data.
• Created Projects, Work Flow, and Data Flows and applied business logics to pull teh data from source to Target.
• Developed complex mappings in Data Integrator to load teh 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 teh 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 halping teh users throughout teh UAT phase.
• Used ClearQuest and ClearCase for Change and Version Control Management.
• Provided Business Objects information sharing sessions and training to teh 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, IBM Data Stage,AutoSys, IBM Clear Case, Clear Quest, Windows 2003 Server, IBM-DB2.

Confidential, Seattle, WA

SAP BODS Consultant

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.
• 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 teh data.
• Created Projects, Work Flow, and Data Flows and applied business logics to pull teh 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 teh data using SAP Business Objects Data Services.
• Tuned Data Integrator Mappings and Transformations for teh better performance of jobs indifferent ways like indexing teh source tables and using Data transfer transformation.
• Worked extensively wif 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 teh animation actions for those components.
• Tuned Data Integrator Mappings and Transformations for teh better performance of jobs indifferent ways like indexing teh source tables and using Data transfer transformation.
• Architected teh 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 teh issues raised by teh 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

BODS Developer

Responsibilities:

• Gathering teh business requirements, functional requirements and data specification from teh 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 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.
• Creating complex Data flows wif inner R/3 dataflows and declaring parameters at different levels of Workflow.
• Created Info Packages and Info Package Groups and scheduled them in order to load Master Data and Transactional Data from SAP R/3 as well as Flat File Source Systems in BW.
• Creation of different datastores to get SAP P40 and SIEBEL PRD tables.
• Responsible for teh Estimation and completion of CR Projects and also involved in Documentation of teh Projects.
• Completing teh requested tasks and projects on time as per user provided end Date wif frequent interactions wif source level users to end users involved in teh 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, UNIX, SQL Loader, SIEBEL, SAP ABAP, SAP BW, Microsoft Visio 2000, Windows NT/2000.

Confidential, Malvern, PA

BI 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 teh 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 teh application performance.
• Created stored functions to manipulate table values before fetching it to teh 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.