SUMMARY

• Over 9+ Years of Professional experience in 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/4.2.
• 6+ years of ETL Experience with 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 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).
• 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 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.
• 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 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.
• 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 the Informatica workflows and controlling the ETL flow.
• 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.
• 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 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).
• Experience in LSMW for data loads to SAP R/3 and other concepts like IDOC, BAPI and BADI.
• Experience working with databases like Oracle, DB2, MS SQL Server 2005, Teradata, MS Access, MySQL also with 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 the inception the projects till go-live including requirements gathering, analysis, design and implementation of 2 SDLC implementations using SAP best practice migration methodologies.
• Techno/Functional knowledge 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 with 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 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.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 the team resources to the various tasks to meet the 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 the design, functional and non-functional requirements, within 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 with 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 the 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 with 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 the IDOC Jobs in DS.
• Integrated Oracle, HANA Databases through Data stores in Designer.
• Used SAP and Non SAP systems to pull the 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 the Integrity of the 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 the BO 4.0 environment to BO 4.1
• Coordinate with Informatica Corporation to solve system issues and environment tunings.
• Created Projects, Work Flow, and Data Flows and applied business logics to pull the data from source to Target.
• Coordinating with Data Stewards in providing status periodically and highlighting the data validation errors
• Designed the Reports to access the 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 without limitations being provided to the 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 the 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 with 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 the data usingData Qualitytransforms in ETL and using constraints in Database.
• Developed jobs to load the data from Flat Files (Fixed Width) into staging area and developed transformations dat apply the business rules given by the client and loaded the data into the 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 the jobs inorder to execute necessaay workflows.
• Created Substitution Parameter Configutation’s for a job’s to assign local variable’s while executing the 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 the 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 the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the 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 the upgrade to Business Objects BI 4.0
• Participated in planning sessions with ETL team to analyze and design the methodology for building the Sales Data warehouse
• Interacted with various Sales Specialists and Business users to understand the 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 the business requirements from various business teams and implemented inData Integrator jobs.
• Worked on Source to Target Mapping design.
• Designed, developed, maintained and tested the 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 the loops dat were caused coz of the 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 the animation actions for those components.
• Defined various restrictions for the Universes to restrict key information.
• Created MTD, YTD and PTD reports dat 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 the batch load process for the 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 with integrated historical sales information in the data warehouse which were useful in identifying future pricing models.
• Extensively used Calculation contexts, Variables, Breaks, Sections, Ranks and Alerts in the creation of reports.
• Excellent experience in Migrating Informatica repositories from SQL Server to Oracle 10G
• Created several dashboards using Xcelsius with Live Office and Query as a Web Service.
• Analyzed and identified ways to improve the performance of Reports and Universes.
• Developed test plans and created test scripts to perform Unit testing and System testing of the Universes and reports.
• Involved in halping the users throughout the UAT phase.
• Used Synergy and PVCS for Change and Version Control Management
• Provided Business Objects information sharing sessions and training to the 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 with business users, Financial Analysts, Project managers, and involved in analysis and creation of architecture dat can be considered 'best practice' and scalable.
• Hands on experience working within an IT/Technology organization.
• Involved in project management/implementation, QA testing, offshore coordination and production support with 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 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 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.
• 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.

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 the business stakeholders using various requirement gathering techniques such as: end-user interviews, job shadowing, questionnaires and involved in analysis and creation of architecture dat 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 dat were caused coz of the conformed dimensions.
• Involved in project management/implementation, QA testing, offshore coordination and production support with hands-on technical and functional expertise on Enterprise Reporting & Analysis
• Defined various restrictions for the Universes to restrict key information.
• Created MTD, YTD and PTD reports dat 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 with 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 with 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.
• 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 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 with AutoSys Scheduling team to Schedule Reports and ETL (Batch) Jobs.
• Involved in halping 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, 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 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

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