SUMMARY

• 10+ years of experience in Business Intelligence practices
• Expert in ETL implementations using SAP Business Objects Data Services 4.0/3.x
• Expert in Business Objects upgrade/migration from 5.1.8 to 6.5.1/6.5.2 and from 5.1.8/6.5.1 to Business Objects XI R2/R3
• Specialized in SAP Business Objects Enterprise XI 3.0/3.1 and XI R1/R2 implementations.
• Expert in creating Crystal Reports with SAP ERP / SAP BW system using Crystal Reports XI R1/R2/2008.
• Expert in ETL implementations using Data Integrator 6.5.x/ 11.5.x/11.7.x
• Expert in Business Objects Data Integrator upgrade from 6.5.x/ 11.5.x/11.7.x to SAP Business Objects Data Services 4.0/3.x
• Expert in creating dashboards using Dashboard Manager/ Performance Manager XI R2 and XI 3.0/3.1
• Expert in creating highly visual and Interactive dashboards using Crystal Xcelsius 2008/4.5.
• Highly skilled in designing and implementing Data Warehouses/ Data Marts for reporting and analysis
• Strong knowledge of SQL, PL/SQL, Stored procedures and query tuning.
• Strong Data Modeling experience using Erwin.
• Implemented BI Environments using Oracle, DB2 UDB, and MS SQL Server.
• Strong leadership, commitment, teamwork, planning, interpersonal relations and communication skills

• Business Objects: Business Objects XI 3.0/3.1/3.2, XI R1/R2 CMC, CMS, Desktop Intelligence, Web Intelligence, OLAP Intelligence, Performance Manager, Dashboard Manager, Crystal Reports Explorer, Crystal Reports XI R1/R2, 2008, Import Wizard, Publishing Wizard, SAP Business Objects Data Services 4.0/3.2/3.1/3.0, Data Integrator 6.5.x/ 11.5.x/11.7.x, SAP Data Quality Management 4.0,Information Platform Services, Information Steward, Metadata Integrator, Repository Manager, Server Manager, SAP-BI 7.0, ECC 6.0, SAP R/3 4.6C, ABAP/4, SQL, BEx Analyzer, BEx Query designer, BEx Web Application Designer, BEx Broadcaster, Business Objects 3.1/4.1/5i/6.5.1 Designer /Reporter/ Supervisor, WebI 2.5/2.6/6.5.1, Set Analyzer, Auditor, Application Foundation 2.x/3.x/6.5.1, Broadcast Agent Publisher 5.1.8/6.0/6.5, ZABO, Broadcast Agent, WebI/BO SDK (WICOM/WIBean) , Crystal Xcelsius 3.5/4.5, Live Office XI R2
• RDBMS & Tools: Oracle 11R1/10g/9i/8i/8.0.5/7.3.x/ 7.1.x., DB2 UDB 7.2/8.0, SQL Server 2008/2005, SQL, PL/SQL, Stored Procedure, Query Performance and Tuning,
• OS: Solaris 7.0/5.8, Win NT/2008/2003/XP, HP-UX 11.2, AIX 4.3.2, SCO 5.0.5
• Languages: Java, J2EE, C, C++
• Internet: Java, HTML, DHTML, Java script, JSP
• WebServer: IIS 4.0/5.0/6.0, Netscape/iPlanet WebServer, Apache 1.3.2
• App Server: Tomcat 5.x, WebSphere, WebLogic
• ETL Tools: SAP Data Services 4.0/3.x, Data Integrator 6.5.x/ 11.5.x/11.7.x, Informatica 8.x
• LDAP: MS Active Directory Server, Netegrity SiteMinder, Netscape Directory Server

EXPERIENCE

SAP Business Objects Consultant Jul 10 - Present
Client: - Confidential, Los Angeles, CA
Project: - City Data I/II
Environment:- Windows NT/2003/2008, Oracle 9i/10g/11g R1, SQL Server 2005/2008, Aqua Data Studio 6.5/9.0, IBM Red Brick Warehouse 6.6, Data Integrator 6.5.x/11.7.x, Data Quality 6.5.x/11.7.x, SAP Business Objects Data Services 4.0, SAP R/3 data store, SAP BW Source data store, SAP BW Target data Store, Metadata Integrator, Repository Manager, Server Manager, Web Administrator/Management Console, SAP Business Objects XI R2/3.1, Crystal Reports 2008, Xcelsius 2008, Web Intelligence, Desktop Intelligence, Designer, Publishing wizard, Instance Manager, Schedule Manager, Import Wizard, Query Builder.

Responsibilities:-

• Created and managed users and groups, including their Rights to folders, categories, objects and applications using CMC (Central Management Console).
• Created and Managed Folders, Objects, Subfolders, Categories and Profiles using CMC.
• Installing, Configuring and Administering the Business Objects enterprise servers. Manage servers using CCM.
• Create very advanced and most challenging reports that involve multiple data providers. Setting up scope of analysis/drill down hierarchies in the universe for drill down report analysis.
• Create universes in BO Designer (setting universe parameters, classes, objects, joins, hierarchies, etc.)
• Check Integrity/Cardinality, loops (using aliases, context), resolving chasm traps and fan traps using Aggregate Awareness, Contexts, and Aliases in designer for a universe. Documenting, distributing universes and maintaining universes.
• Scheduling WebI and Desktop intelligence documents/objects (FTP, Email (SMTP) and Format) using BI scheduler.
• Business Objects migration from XI R1/R2 to Business Objects XI R 3.0/3.1 using Import wizard. Publish desktop intelligence documents, program objects and third party documents using Publishing Wizard.
• Create and schedule publications and implement a Single pass refresh report bursting strategy. Moving universe, reports, dashboards from development to test and production using Import Wizard/BIAR file.
• Single Sign-On by mapping Windows AD accounts to Business Objects enterprise.
• Configure Business Objects enterprise to work in Firewalls, Enable the port(s) needed like 6400, 6401 etc…for Business Objects Enterprise XI R2/3.1
• Gather report migration requirements. Prepare report migration strategy.
• Implement disaster recovery in a multiple server environment. Implement CMS clusters to improve performance and scalability.
• Create, Execute, Monitor and Debug the batch job using SAP Data Services Designer.
• Install and configure Information Platform Services and SAP Business objects Data Services 4.0/3.x on Windows platform. Create and Execute Data Services batch jobs using Data Integrator and Data Quality transforms using Data Services Designer.
• Migrated job from Data Integrator 6.5.x/11.5.x/11.7.x to SAP Business objects Data Services XI 4.0/3.x.
• Scheduling, Monitoring and Executing batch jobs using Data Services Management Console Administrator.
• Create and Configure Local, Central and Profiler repository using SAP Data Services Repository Manager.
• Administering, start and stop, backup & restore and tuning repository performance. Identify and resolve data related conflicts between application projects.
• Designed and developed Data Integrator Batch jobs to extract data from various source systems. Designed and developed interdependency of ETL jobs
• Improve the quality of data by cleansing, enhancing, matching and consolidating data using Data Services Data Quality transformations
• Moving data flows from development to test and production environments.
• Create Data Services data store to connect to SAP and import metadata into the Data Services data store
• Debug execution errors using Data Services logs (trace, statistics, error) and by examining the target data.
• Expert in optimize the performance of the data flows using Push-Down operation. Parallel execute the data flows and workflows to improve the performance of the batch job.
• Interfacing with the technical staff for translating the business requirements into a functional data model.
• Develop, maintain, and document data standards, guidelines and procedures.

Sr. SAP Data Services Consultant Sep 09 - Jul 10
Client: - Confidential, San Diego, CA
Project: - Merchandise Data Warehouse (MDW)
Environment:- Windows NT/2000/XP, Oracle 9i/10g, Business Objects XI R2 SP1/SP2, WebI XI R2 SP1/SP2, (Desktop Intelligence, Designer, Publishing wizard, Instance Manager, Schedule Manager, Query Builder), Central Management Console, Data Services XI 3.0/3.1, SAP R/3 data store, Data Quality, Server Manager, Repository Manager, Metadata Integrator, Web Administrator/Management Console

Responsibilities:-

• Install and configure SAP Business objects Data Services XI3.0/3.1 on Windows platform. Create and Execute Data Services batch jobs and Data Services real time jobs using Data Integrator and Data Quality transforms using Data Services Designer.
• Create, Execute, Monitor and Debug the batch job using Data Services Designer.
• Create Workflows using object library and tool palette to execute data flows. Define database Data Stores and File Formats to allow Data Services to connect to the source or target database and files.
• Scheduling, Monitoring and Executing batch jobs using Data Services Management Console Administrator.
• Create and Configure Local, Central and Profiler repository using Data Services Repository Manager.
• Install and Configure of Metadata Integrator for impact and lineage analysis on Business Objects Enterprise objects such as Universes and Crystal Reports.
• Manage batch job, real-time services, Web services, adapter instances, server groups, local, central and profiler repositories using Data Services Management Console.
• Improve the quality of data by cleansing, enhancing, matching and consolidating data using Data Services Data Quality transformations.
• Create and Configure profiler repository using Data Services Repository Manager. Profile the database data and File for Column analysis and Relationship analysis using Data Services Data Profiler.
• Debug execution errors using Data Services logs (trace, statistics, error) and by examining the target data.
• Optimize the performance of the data flows using Push-Down operation. Parallel execute the data flows and workflows to improve the performance of the batch job.
• Reads data from SAP applications using regular data flows and ABAP data flows.
• Moving ABAP data flows from development to test and production.
• Reads data from SAP applications tables, hierarchies, extractors, and functions using ABAP data flows.
• Create Data Services data store to connect to SAP and import metadata into the Data Services data store
• Used Auto-generated ABAP program or RFC functions that read data from the SAP tables of the InfoCube, DataStore object or InfoObject.
• Create very advanced and most challenging reports that involve multiple data providers. Setting up scope of analysis/drill down hierarchies in the universe for drill down report analysis.
• Create universes in BO Designer (setting universe parameters, classes, objects, joins, hierarchies, etc.)
• Check Integrity/Cardinality, loops (using aliases, context), resolving chasm traps and fan traps using Aggregate Awareness, Contexts, and Aliases in designer for a universe. Documenting, distributing universes and maintaining universes.
• Scheduling WebI and Desktop intelligence documents/objects (FTP, Email (SMTP) and Format).
• Project lifecycle development, methodology documentation and quality control.
• Interfacing with the technical staff for translating the business requirements into a functional data model.
• Develop, maintain, and document data standards, guidelines and procedures.

Sr. Business Objects Consultant May 09 - Sep 09
Client: - Confidential, Irvine, CA
Project: - MLM Datawarehouse
Environment:- Windows 2003/XP, Oracle 10g, Business Objects XI 3.1,WebI XI 3.1 (Rich Client, Desktop Intelligence, Designer, Publishing wizard, Instance Manager, Schedule Manager, Query Builder), Central Management Console, Data Services XI 3.0/3.1/3.2, Data Quality, SAP R/3 data store, Server Manager, Repository Manager, Metadata Integrator, Web Administrator/Management Console
Responsibilities:-

• Create very advanced and most challenging reports that involve multiple data providers. Setting up scope of analysis/drill down hierarchies in the universe for drill down report analysis.
• Create universes in BO Designer (setting universe parameters, classes, objects, joins, hierarchies, etc.)
• Check Integrity/Cardinality, loops (using aliases, context), resolving chasm traps and fan traps using Aggregate Awareness, Contexts, and Aliases in designer for a universe. Documenting, distributing universes and maintaining universes.
• Created and managed users and groups, including their Rights to folders, categories, objects and applications using CMC (Central Management Console).
• Created and Managed Folders, Objects, Subfolders, Categories and Profiles using CMC.
• Performance tuning of CMS servers and recommendations to tweak server settings and monitor server usage statistics. Design system architecture.
• Single Sign-On by mapping Windows NT/LDAP accounts to Business Objects enterprise.
• Gather report migration requirements. Prepare report migration strategy.
• Business Objects migration from XI R1/R2 to Business Objects XI R 3.0/3.1 using Import wizard. Publish desktop intelligence documents, program objects and third party documents using Publishing Wizard.
• Scheduling WebI and Desktop intelligence documents/objects (FTP, Email (SMTP) and Format).
• Create and schedule publications and implement a Single pass refresh report bursting strategy. Moving universe, reports, dashboards from development to production using Import Wizard and PMDT. Responsible for repository migration between environments.
• Create Workflows using object library and tool palette to execute data flows. Define database Data Stores and File Formats to allow Data Services to connect to the source or target database and files.
• Scheduling, Monitoring and Executing batch jobs using Data Services Management Console Administrator.
• Create and Configure Local, Central and Profiler repository using Data Services Repository Manager.
• Analyze the impact of changing a source table, column, element, or field on existing Business Objects Documents and Reports.
• Improve the quality of data by cleansing, enhancing, matching and consolidating data using Data Services Data Quality transformations.
• Debug execution errors using Data Services logs (trace, statistics, error) and by examining the target data.
• Expert in optimize the performance of the data flows using Push-Down operation. Parallel execute the data flows and workflows to improve the performance of the batch job.
• Project lifecycle development, methodology documentation and quality control.
• Interfacing with the technical staff for translating the business requirements into a functional data model.
• Develop, maintain, and document data standards, guidelines and procedures.

Sr. Data Integrator Consultant Apr 08 - Apr 09
Client: - Confidential, San Diego, CA
Project: - Auto Data Mart
Environment:- Windows NT/2000/XP, Business Objects XI R2 SP1/SP2, XI 3.0/3.1 WebI XI R2 SP1/SP2, XI 3.0/3.1 ((Desktop Intelligence, Designer, Publishing wizard, Instance Manager, Schedule Manager, Query Builder), Central Management Console, Crystal Reports XI R2, Data Integrator 6.5.x/XI R1/R2, Data Services XI 3.0/3.1, Data Quality, SAP R/3 data store, Server Manager, Repository Manager, Metadata Integrator, Web Administrator/Management Console, SQL Server 2000/2005
Responsibilities:-

• Understand complex technical specification documents to Create, Test and Execute Data Integrator jobs using Data Integrator Designer to transfer data from source to target
• Create Workflows using object library and tool palette to execute data flows. Define database Data Stores and File Formats to allow data integrator to connect to the source or target database and files.
• Scheduling, Monitoring and Executing batch jobs using Data Integrator Administrator.
• Create and Configure Local, Central and Profiler repository using Data Integrator Repository Manager.
• Managing User roles, add/remove repositories, Publishing batch jobs and real time services via web services using Data Integrator Administrator.
• Designed and developed Data Integrator Batch jobs and Real time jobs to extract data from various source systems. Designed and developed interdependency of ETL jobs
• Performed simple and complex transformations in Data Flows.
• Administering, start and stop, backup & restore and tuning repository performance. Identify and resolve data related conflicts between application projects.
• Create and administer the Central repository and Local repository in a multi user environment.
• Install and configure Data Integrator on Windows platform. Optimized the batch job execution performance at Source, Transformation and Target level using Data Integrator Designer.
• BODI XI 11.5.x to BODI XI 11.7.x migration.
• Configure Job Server, Access Server to Local/Central repository using Data Integrator Server Manager.
• Implemented Recovery Mechanism for unsuccessful batch jobs execution. Capture the exceptional errors using Try/Catch mechanism.
• Expert in implementing Change Data Capture (CDC) after an initial load complete and nightly Full refresh
• Debug execution errors using Data Integrator logs (trace, statistics, error) and by examining the target data.
• Expert in optimize the performance of the data flows using Push-Down operation. Parallel execute the data flows and workflows to improve the performance of the batch job.
• Expert in upgrading repositories from Data Integrator 11.5.x/11.7.x to Business objects Data Services XI 3.0/3.1
• Install and configure SAP Business objects Data Services XI3.0/3.1 on Windows platform. Create and Execute Data Services batch jobs and Data Services real time jobs using Data Integrator and Data Quality transforms using Data Services Designer.
• Create, Execute, Monitor and Debug the batch job using Data Services Designer.
• Scheduling, Monitoring and Executing batch jobs using Data Services Management Console Administrator.
• Create and Configure Local, Central and Profiler repository using Data Services Repository Manager.
• Install and Configure of Metadata Integrator for impact and lineage analysis on Business Objects Enterprise objects such as Universes and Crystal Reports.
• Manage batch job, real-time services, Web services, adapter instances, server groups, local, central and profiler repositories using Data Services Management Console.
• Improve the quality of data by cleansing, enhancing, matching and consolidating data using Data Services Data Quality transformations.
• Improve the quality of source data by cleansing, enhancing, matching and consolidating data using Address cleanse, Data cleanse.
• Created and managed users and groups, including their Rights to folders, categories, objects and applications using CMC (Central Management Console).
• Created and Managed Folders, Objects, Subfolders, Categories and Profiles using CMC.
• Create very advanced and most challenging reports that involve multiple data providers. Setting up scope of analysis/drill down hierarchies in the universe for drill down report analysis.
• Create universes in BO Designer (setting universe parameters, classes, objects, joins, hierarchies, etc.)
• Check Integrity/Cardinality, loops (using aliases, context), resolving chasm traps and fan traps using Aggregate Awareness, Contexts, and Aliases in designer for a universe. Documenting, distributing universes and maintaining universes.
• Scheduling WebI and Desktop intelligence documents/objects (FTP, Email (SMTP) and Format).
• Create and schedule publications and implement a Single pass refresh report bursting strategy. Moving universe, reports, dashboards from development to production using Import Wizard and PMDT. Responsible for repository migration between environments.
• Project lifecycle development, methodology documentation and quality control.
• Interfacing with the technical staff for translating the business requirements into a functional data model.
• Develop, maintain, and document data standards, guidelines and procedures.
• Conducting interviews with the business users for business requirements analysis and supporting documentation.

Business Objects Consultant Oct 07 - Apr 08
Client: - Confidential, Minneapolis, MN
Project: - Executive Dashboard Management
Environment:- Windows NT/2000/XP, Oracle 10g, Business Objects XI R2 SP2 Fix Pack 2.6/2.7 WebI XI R2 SP2 (Desktop Intelligence, Designer, Publishing wizard, Instance Manager, Schedule Manager, Query Builder), Central Management Console, Import Wizard, Performance Manager, Dashboard Manager, Strategy Builder, Informatica PowerCenter 8.x, Crystal Xcelsius 4.5, Live office XI R2
Responsibilities:-

• Provided high level consulting services to the existing Business Intelligence staff on the implementation of a Performance Management/Dashboard Manager solution that best meets their goals and objectives.
• Analyzed and documented their current requirement and provided a recommendation on how to proceed and use the performance manager to meet their requirement.
• Install and configure Performance Management. Create EPM repository. Push/update universes to the EPM repository.
• Create and Manage corporate and executive dashboards and analytics (IMT, Speedometer, Barometer, Pareto Chart, Alert, etc). Setting up Rules and Alert key business users.
• Moving dashboards and EPM objects from development to production using Import Wizard and PMDT. Identified KPI (Key Performance Indicators) for defining and creating metrics for Business Users. Responsible for scheduling metrics, analytics using Scheduler.
• Created real time alerts based on KPI and metrics.
• Setting up goals and implement goals management using Performance Manager. Analyzed metric requirements. Populated metric data stores from source systems.
• Created Dashboards for user groups based on the requirements using Dashboard Builder.
• Define, Manage and Monitor corporate information strategies using Strategy Builder.
• Create universes in BO Designer (setting universe parameters, classes, objects, joins, hierarchies, etc.)
• Check Integrity/Cardinality, loops (using aliases, context), resolving chasm traps and fan traps using Aggregate Awareness, Contexts, and Aliases in designer for a universe. Documenting, distributing universes and maintaining universes.
• Used Informatica PowerCenter for Designing/Creating of Mappings/Sessions to populate the Data Warehouse.
• Created various Transformations like Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy.
• Involved in the development of mappings and also tuned for better performance.
• Developed mapping to load the data in slowly changing dimension.
• Work extensively for monitoring session for conformity of Data in Data Warehouse
• Replaced lookups in mappings with join conditions.
• Broke up complicated slow mapping into multiple mapping
• Designed and created mappings/sessions/workflows to move data from source to reporting data warehouse.
• Implemented upgrade plan including testing of all production mappings, sessions, workflows.
• Modified mappings, sessions, workflows as needed to get them to work as designed in upgraded environment.
• Designed highly & interactive dashboard with "what-if "analysis.
• Created an Xcelsius dashboard based on the spreadsheet.
• Connected to universe queries and build web services with QAAWS.
• Created interactive visualization with live refreshable data from Business Objects enterprise using Live Office Connector in Xcelsius.
• Project lifecycle development, methodology documentation and quality control.
• Interfacing with the technical staff for translating the business requirements into a functional data model.
• Develop, maintain, and document data standards, guidelines and procedures.
• Conducting interviews with the business users for business requirements analysis and supporting documentation.

Sr. Business Objects Consultant Apr 07 - Sep 07
Client: - Confidential, St.Louis, MO
Project: - Sales Stock (Macy's Midwest Sales & Stock)
Environment:- Windows NT/2000/2003/XP,SQl Server 2000,Business Objects XI R1/R2 SP1, SP2 Fix Pack 2.1/2.2/2.3, WebI XI R1/R2 SP2 (Desktop Intelligence, Designer, XI Scheduler) Central Configuration Manager, Central Management Console, Import Wizard, Performance Manager, Dashboard Manager, Crystal Reports XI R2, VBA Macros.
Responsibilities:-

• Installing, Configuring and Administering the Business Objects enterprise servers. Manage servers using CCM.
• Created and managed users and groups, including their Rights to folders, categories, objects and applications using CMC (Central Management Console).
• Created and Managed Folders, Objects, Subfolders, Categories and Profiles using CMC.
• Developed Load Runner monitoring scripts to monitor CMS servers. Performed stress testing on the CMS servers by increasing the number of users and measure the stress using LoadRunner scripts.
• Performance tuning of CMS servers and recommendations to tweak server settings and monitor server usage statistics. Recommended Load balancing strategies to distribute the load between CMS cluster servers
• Design system architecture. Design a system management plan. Deploy Business Objects enterprise. Design and implement a system auditing plan. Sizing Business Objects enterprise deployment
• Single Sign-On by mapping Windows AD accounts to Business Objects enterprise.
• Gather report migration requirements. Prepare report migration strategy.
• Implement disaster recovery in a multiple server environment. Implement CMS clusters to improve performance and scalability.
• Business Objects migration from XI R2 to Business Objects XI R2 using Import wizard. Publish desktop intelligence documents, program objects and third party documents using Publishing Wizard. Scheduling WebI and Desktop intelligence documents/objects (FTP, Email (SMTP) and Format).
• Moving universe, reports, dashboards from development to production using Import Wizard and PMDT. Responsible for repository migration between environments.
• Creating and maintaining repository and users with Administrator, Creating Universes with BO Designer, and creating reports with Business Objects Reporter (Desktop Intelligence).
• Create very advanced and most challenging reports that involve multiple data providers. Setting up scope of analysis/drill down hierarchies in the universe for drill down report analysis.
• Create universes in BO Designer (setting universe parameters, classes, objects, joins, hierarchies, etc.)
• Check Integrity/Cardinality, loops (using aliases, context), resolving chasm traps and fan traps using Aggregate Awareness, Contexts, and Aliases in designer for a universe. Documenting, distributing universes and maintaining universes. Publishing and broadcasting/scheduling business intelligence documents/reports to large number of end users via business objects repository using Central Management Console. Setting up profiles in Central Management Console under profiles to users and groups to apply filters during single pass report bursting.
• Expert in Advanced reporting, crosstabs and Trending graphs. Monitor user activities, system activities using Administrative console.
• Project lifecycle development, methodology documentation and quality control.
• Interfacing with the technical staff for translating the business requirements into a functional data model.
• Develop, maintain, and document data standards, guidelines and procedures.
• Conducting interviews with the business users for business requirements analysis and supporting documentation.
• Provided high level consulting services to the existing Business Intelligence staff on the implementation of a Business Objects solution that best meets their goals and objectives. Analyzed and documented their current infrastructure and provided a recommendation on how to proceed.

Sr. Business Objects Consultant Jun 04 - Apr 07
Client: - Confidential, NJ
Project: - eTalent (Global Hiring Management System)
Environment:- Windows NT/2000/XP,Oracle 9i/10g,Business Objects 5i/6.5.x/XI R1/R2 WebI 2.7/6.5.x/XI R1/R2 (Reporter, Designer, Supervisor, Broadcast Agent, BCA Publisher, Auditor), Crystal Reports 10, XI R1/R2, Application Foundation 6.5.1, Central Management Console, Import Wizard, Performance Manager, Dashboard Manager, VBA Macros, Erwin, Data Integrator 6.5.0.4/ XI R2
Responsibilities:-

• Created and managed users and groups, including their Rights to folders, categories, objects and applications using CMC (Central Management Console). Created and Managed Folders, Objects, Subfolders, Categories and Profiles using CMC. Installing, Configuring and Administering the Business Objects enterprise servers. Manage servers using CCM.
• Upgrade from Crystal reports 8.5/9/10 to Crystal Reports XI R2. Migrating reports containing charts to Crystal Reports XI R2.
• Design system architecture. Design a system management plan. Deploy Business Objects enterprise. Design and implement a system auditing plan. Sizing Business Objects enterprise deployment.
• Single Sign-On by mapping Windows NT/LDAP accounts to Business Objects enterprise.
• Gather report migration requirements. Prepare report migration strategy.
• Implement disaster recovery in a multiple server environment. Implement CMS clusters to improve performance and scalability.
• Business Objects migration from 5.1.8/6.5.1 to Business Objects XI R2 using Import wizard. Publish desktop intelligence documents, program objects and third party documents using Publishing Wizard. Scheduling WebI and Desktop intelligence documents/objects (FTP, Email (SMTP) and Format). Create and schedule publications and implement a Single pass refresh report bursting strategy. Moving universe, reports, dashboards from development to production using Import Wizard and PMDT.
• Creating and maintaining repository and users with Supervisor, Creating Universes with BO Designer, and creating reports with Business Objects Reporter. Create very advanced and most challenging reports that involve multiple data providers. Setting up scope of analysis/drill down hierarchies in the universe for drill down report analysis. View/Refresh full client business objects corporate document with ZABO.
• Create custom built reports (JSP) using com.bo.WIBEAN WebI SDK API
• Create universes in BO Designer (setting universe parameters, classes, objects, joins, hierarchies, etc.)
• Check Integrity/Cardinality, loops (using aliases, context), resolving chasm traps and fan traps using Aggregate Awareness, Contexts, and Aliases in designer for a universe. Documenting, distributing universes and maintaining universes. Publishing and broadcasting/scheduling business intelligence documents/reports to large number of end users via business objects repository using Broadcast Agent server. Setting up profiles in Recipient Manager to users and groups to apply filters during report bursting. Expert in Advanced reporting, crosstabs and Trending graphs. Monitor user activities, system activities using BO Auditor. Report and Universe migration from 5.1.8 to 6.5.1/6.5.2. Install and Configure Business Objects Enterprise Server 6.0/6.1a/6.5.x. Business Objects Broadcast agent server / Broadcast Agent Publisher installation on Windows NT server and configuration.
• Creating repository and setting up the universe, document, security domain and various universe connections
• Create Broadcast Agent for specific groups and Monitor Broadcast Agent.
• Understand complex technical specification documents to Create, Test and Execute Data Integrator jobs using Data Integrator Designer to transfer data from source to target
• Create and administer the metadata Data Integrator repository in a multi user environment.
• Scheduling, Monitoring and Executing batch jobs. Configuring, starting and stopping real time services. Configuring Data Integrator Job Server, Data Integrator Access Server and repository usage. Configuring and Managing adapters. Managing Users. Publishing batch jobs and real time services via web services using Data Integrator Administrator. Performed simple and complex transformations in Data Flows.
• Create Workflows using object library and tool palette to execute data flows. Define database Data Stores and File Formats to allow data integrator to connect to the source or target database and files.
• Administering, start and stop, backup & restore and tuning repository performance. Install and configure Data Integrator on Windows and UNIX platforms. Designed and developed Data Integrator Batch jobs and Real time jobs to extract data from various source systems. Designed and developed interdependency of ETL jobs
• Expert in implementing Change Data Capture (CDC) after an initial load complete and nightly Full refresh
• Debug execution errors using Data Integrator logs (trace, statistics, error) and by examining the target data.
• Project lifecycle development, methodology documentation and quality control.
• Interfacing with the technical staff for translating the business requirements into a functional data model.
• Develop, maintain, and document data standards, guidelines and procedures.
• Conducting interviews with the business users for business requirements analysis and supporting documentation.
• Provided high level consulting services to the existing Business Intelligence staff on the implementation of a Business Objects solution that best meets their goals and objectives. Analyzed and documented their current infrastructure and provided a recommendation on how to proceed.

Reports Developer Jan 01 - May 04
Confidential, Bangalore, India

Environment: - Oracle8i, Oracle Developer6i (Forms), PL/SQL, SQL*Plus, Win 2K Server, BusinessObjects 5.1.4
Responsibilities:-

• Identifying the key metrics for reporting
• Coding of forms & reports using Developer/2000
• Creating Universes and maintaining Universes
• Resolving loops in Universes
• Breaking the universes into well defined small universes to minimize complexity and query optimization.
• Exporting the Universes onto the Repository on the server.
• Creating user profiles and apply security restrictions on the user profile.
• Distributing the Universe to the User Groups.
• Creating Specific categories to group the reports.
• Creating the Repository database for report access.
• Administering the server in terms of optimizing the performance of the server.
• Monitor the User\'s logged in and take specific actions.
• Creating reports by pulling data from universe.
• Linking of the universes at the designer level to get the consolidated data.
• Creating complex reports pulling and combining multiple data sources.
• Creating Drillable reports which help in Analysis.
• Scheduling the reports for refresh in Broadcast Agent.
• Involved in the development of PL/SQL stored procedures

EDUCATION

• Master of Computer Applications.