SUMMARY:

• Over 8+ years of work experience in Business Intelligence and Data Warehousing tools i.e., BusinessObjects6.x/5.x (Supervisor, Designer, Broadcast Agent, Reporter and WebIntelligence),Business ObjectsXI R2(UniverseDesigner,DESKI, WEBIandCMC) and Business ObjectsXI3.0(Info view, Central Management Console (CMC), Universe Designer, Desktop Intelligence (DESKI) and WebIntelligence (WEBI)), Crystal Reports 8.5/9.0/10/XI, Business Explorer, ABAPand BO Data Integrator/ Data Services.
• Experience in using ETL tool BODataIntegrator, creating Objects i.e. Jobs and accessing them using DataIntegratorLocalObjectLibrary and working on them using Work Space.
• Experience in Handling and the creation of DataFlows and Workflows the core components in extracting and transforming Data in Business ObjectsDataIntegrator.
• Experience in working in all the Different phases of ETL Tool i.e. Definition, Validation and Administration.
• BODS ETL with 5+ years of hands-on experience.
• Experience in using the LocalObjectLibrary in Data Integrator for creating Jobs and applying mappings and various Transformations to the Processes/ Jobs.
• Experience in working in all the phases of Data Integrator such as Logging into the repository, defining a connection from Client to the Source, Importing the MetaDataDefinition of theSourceDatabase, Importing the TargetDatabase, and finally defining the Mapping.
• Adequate Experience in the integration of BusinessObjectsEnterprise with MicrosoftLiveOffice and also have experience in working with Business Objects Enterprise on LinuxPlatform.
• Experience in Development of Reports for Financial needs using Crystal Reports XI and BusinessObjectsXI3.0.
• Proficient in Designing, Developing and Managing the Universes using Business ObjectsDesigner.
• Proficient in creating Classes and Objects in UniverseDesigner and using all the tools and existing designs such as Alerters, Ranks, Sorting, Filters and special @Functions such as PROMPT etc.
• Proficient in developing reports using DesktopIntelligence (DeskI) starting from adding the data to QueryPanel and organizing them to create reports and Web Intelligence (WebI) for analyzing and accessing the data.
• Expertise in Scheduling and Processing of reports using Business ObjectsDesktop Intelligence (DeskI) and Web Intelligence (WebI) Rich client.
• Expert in handling and creation of Adhocqueries in generating reports using Web Intelligence (WebI).
• Expertise in handling the Migration of BusinessObjects6.x/5.x to BusinessObjectsXIR2.
• Able to create all the Users and UserGroups within the CMC which deals with the Accessgrants.
• Experience in working as an Administrator using Business ObjectsInfo view and Central Management Console (CMC) and also managed the UserAccess, ManagingObjects andSchedulingReports in BusinessObjectsXI 3.0.
• Implemented Cross-Tabreports with DrilldownCharts in CrystalReports Enterprise.
• Knowledge in creating interactive Dashboards using CrystalXcelsius4.5 and published them to various sources like Microsoft PowerPoint, Microsoft Word and also to the Business ObjectsEnterprise.
• Strong Knowledge in creating Dashboards using CrystalXcelsius 4.5 which includes adding a DataTable to a chart and also linking a Map to a chart.
• Knowledge in using Charts, Containers and Singlevaluecomponents such as Gauges and Sliders in designing a Dashboard using CrystalXcelsius.
• Hands on experience using Oracle9i/10g, Teradata V2R6.0 and SQL Server 2005 and extensive experience in writing SQLQueries, PL/SQL, Stored Procedures, Functions and Triggers.

EDUCATION:

BS in Information Technology Confidential,University

SKILLS SUMMARY:

Operating System:

Windows 98/2000/NT/ 2003 Server, XP, UNIX and Sun Solaris BI Tools: Business Objects Suite, BO Designer, BI Tools Business Object XI R3, R2 /6.x/5.x, Dashboard Manager, Performance Management, Voyager, Xcelsius, Crystal Reports 9.x/XI

Data Modeling: Erwin 3.5.2
ETL Tools: Informatica 5.x/6.x/7.x, Data stage
RDBMS: Oracle8x/9x/10g, MS SQLServer 2000/2005, DB2 UDB, My SQL
Languages: C/C++, Basic, SQL, Java, Shell Scripting
GUI Tools: VB 6.0, .NET, HTML, VB Script, JavaScript

EXPERIENCE:

Role: Sr. BODS Consultant

Responsibilities:

• Involved from the inception of the project, Gathered requirements and developed the functional specs.
• Extensively worked on creating Dimensional Data Model for New Business from Operational Data Sources.
• Used SAP Data Services (3.2,3.1) for migrating data from OLTP databases, SAP R/3 to the Data Warehouse
• Created Jobs, Workflows and Data Flows according to specifications and implemented their business logic.
• Created SAP Data services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.
• Created Real time Jobs and Nested structures Using BODS.
• Created Data Flows for dimension and fact tables and loaded the data into targets in Data Warehouse
• Designed Summary and Aggregation tables according to the functional requirement specifications and loaded data to support reporting.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs.
• Developed complex mappings utilizing built in Data Integrator functions, including reverse pivots, table comparisons, map operations, and SQL transforms,Key Generator, Case, Merge, Map Operator and lookup.
• Generation of OLAP Universe from SAP BI/BW cube / Multi-provider / ODS data model in Universe Designer on which the reports are generated.
• Configured the mappings to handle the updates to preserve the existing records using History Preserve Transformation (Slowly Changing Dimensions Type-2)
• Used parsing, correction, standardization, duplicate matching for arranging information using Data Quality Management.
• Configured ECC to SQL Server leveraging using BO connector.
• Used parsing, correction, standardization, duplicate matching for arranging information using Data Quality Management.
• ImplementedData auditinganddata validationtechniques while designing flows for better data quality using Data Insight
• Created Data Quality jobs to cleanse and match data based on internal dictionaries.
• Scheduled batch jobs for processing flat files, XML files, XSD, DTD’s as source as well as Target too.
• Used Global variables, Local Variables and Parameters between Work flow and Data flow as per business requirements.
• Designed Work flow and Data flow in such a way they can be used in multiple jobs.
• Analyze all tables and created various indexes to enhance query performance.
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes
• Defined Full client & WebI reports and published to corporate documents and viewed by info view
• Created reports using multiple data providers.
• Extensively Used Lookup_ext, Lookup_Seq and also created custom functions where repetitive code is needed.
• Created and administered Local and Central Repositories for multi user environment.

Environment:SAP Business Objects XI 3.0, SAP Data Services, Designer, Reporter, Informatica,Web Intelligence, Rich client, Info View,Oracle 11g, SAP R3, Oracle SQL developer 1.2, UNIX,

Confidential, Troy, MI Dec 10 Jun 11
Role: Business Objects Data Services Consultant

Responsibilities:

• Gathered requirements from functional users, extracting data, building universes, designing reports and dashboards as per the business requirements.
• Installed Business Objects Data Services and assisted SAP BI Admin in installing Data Quality Management Business Add-Ins (BAdIs). Also loaded into each target client the supported countries on which Data Quality for SAP can perform postal validation.
• Created Data Integrator mappings to load the SAP ERP and R/3 tables to Staging area then to SAP Business Warehouse and Rapid Marts (Sales, Purchasing, Cost Center, Accounts Payable and Accounts Receivable).
• Created Real time Jobs and Nested structures Using BODS.
• Used parsing, correction, standardization, duplicate matching for arranging information using Data Quality Management.
• Configured ECC to SQL Server leveraging using BO connector.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows
• Created Data Flows for dimension and fact tables and loaded the data into targets in Data Warehouse.
• Designed Summary and Aggregation tables according to the functional requirement specifications and loaded data to support reporting.
• Generation of OLAP Universe from SAP BI/BW cube / Multi-provider / ODS data model in Universe Designer on which the reports are generated.
• Developed Web Intelligence reports from the Universes developed on SAP BI Info Cubes or MultiProviders & BEx Queries by combining data from SAP and non-SAP data in a single report, including data from XLS, CSV, and Text files.
• Used Web Services applications based on open standards (WSDL, SOAP, and XML Schema primarily) to access SAP R/3 over an external Web.
• Created Crystal reports and live data Xcelsius dashboards from SAP BI data via OLAP kit and QaaWs.
• Designing Universes for various business needs and resolved Chasm trap, Fan traps using Contexts & Aliases.
• Customized configuration of Business Objects Web Intelligence by fine tuning and optimization for better performance.
• Created Cardinalities, Joins, Contexts and Aliases for resolving Loops, Traps and checked the Integrity of the Universe. Analyze all tables and created various indexes to enhance query performance.
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes
• Involved in user training sessions for and assisting in UAT (User Acceptance Testing).
• Developed Xcelsius dashboards for presentations, live data dashboards with alerts, Calculators, Historical data comparisons, what if analyzers for real time understanding of changes in business and embedding of dashboards into webpage.
• Created Linked, Unlinked, Parameterized and On-demand sub reports for various business needs, reports scheduled for different file based / schedule based events, distributed in email, PDF and HTML format.

Environment: Business Objects Data Services 3.2, Business Objects XI 3.1, Informatica, Business Objects Data Quality Management 12.0 /11.7, SAP BI 7.0/BW 3.5, SAP R/3 FICO and SD, SAP BI/BO integration kit, Oracle 11g, SQL Server 2008.

Confidential,Stamford, CT Oct 09­ Nov 10

Role: Sr.BO Data Integrator Consultant

Responsibilities:

• Used Data Integrator 11.5 for migrating data from SAP R/3 and ERP to the Data Warehouse.
• Created Jobs, Workflows and Data Flows according to specifications and implemented their business logic.
• Created SAP Data Integratormappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup functions etc. in Data flows
• Configured database Data Stores and File Formats to allow DataServices to connect to the source or target database and files.
• Develop processes using ETL tools (Data Integrator), PL/SQL and SQL to support business reporting requirements.
• Design and develop ETL processes, data flows, and Data Marts based on business requirement specifications
• Created Data Flows for dimension and fact tables and loaded the data into targets in Data Warehouse.
• Used ABAP interface, RFC/BAPI interface, IDoc interface to move data in and out of SAP ERP and R/3. Created custom ABAP codes and used them as Transformations to extract certain Cluster tables.
• Designed Summary and Aggregation tables according to the functional requirement specifications and loaded data to support reporting.
• Migrated ETL Jobs by exporting and importing ATL files.
• Used Data Integrator to call external Web Services from within its jobs using a built-in web services adapter.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs.
• Worked closely with the data population developers, multiple business units and data solution engineer to identify key information that will enhance Business Decision Making.
• Structured the flat file database to support decision-making and statistical analysis by denormalizing for the faster data retrieval.
• Developed WebI reports for various business needs.
• Defined categories of documents for different level of groups.
• Defined Complex Security set up for end users.
• Designed Universes for various business needs and resolved Chasm trap, Fan traps using contexts & Aliases.
• Created custom LOV’s and Hierarchies for easy user selection drill down purposes.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Defined Aliases and Contexts to resolve loops in the universes.
• Worked on functionalities like Breaks, Filters, Sorts, Query prompt and Drill filters.

Environment:Business Objects XIR2, Data Integrator 11.5, SAP BI 7.0/BW 3.5, SAP R/3 FICO,Data Quality Management 12.0 /11.7, Informatica, Oracle 11g, SQL Server 2005, PL/SQL, T-SQL, Windows 2003/UNIX.

Confidential,Louisville KY Aug 08 Sep 09
Role: BO Data IntegratorDeveloper

Responsibilities:

• Gathering requirements from users, extracting data and designing reports as per the business requirements.
• Installation and configuration of Business Objects XI server and Desktop products on Windows and UNIX machines.
• Involved in Normalization
• Database design, creation of user Databases, Installation of MS SQL Clients.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Rebuilding the indexes at regular intervals for better performance
• Used Data Integrator 3.0/11.5 for migrating data from SAP R/3 and ERP to the Data Warehouse
• Created Jobs, Workflows and Data Flows according to specifications and implemented their business logic.
• Created SAP Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows
• Created Data Flows for dimension and fact tables and loaded the data into targets in Data Warehouse.
• Designed Summary and Aggregation tables according to the functional requirement specifications and loaded data to support reporting.
• Used Data Integrator to call external Web Services from within its jobs using a built-in web services adapter.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs.
• Built SAP Business objects universes on top of SAP BW queries and optimized the performance of the Universes.
• Developed WebI reports for various business needs (Medical Records, Drug records, Financial Records).
• Defined categories of documents for different level of groups.
• Defined Complex Security set up for end users.
• Designing Universes for various business needs and resolved Chasm trap, Fan traps using contexts & Aliases.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Created dashboards for financial presentations with alerts and what- if analysis using Xcelsius.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Defined Aliases and Contexts to resolve loops in the universes.
• Created Operational Dashboards, Tactical Dashboards and Strategic (Scorecards) Dashboards for various requirements using Dashboard Manager.
• Worked on functionalities like Breaks, Filters, Sorts, Query prompt and Drill filters.
• Created users and groups in the CMC Central Management Console and grated permissions based on their usage levels.
• Worked closely with the data population developers, multiple business units and data solution engineer to identify key information that will enhance Business Decision Making.
• Structured the flat file database to support decision-making and statistical analysis by denormalizing for the faster data retrieval.

Environment:Business Objects 3.0/XIR2, Data Integrator 3.0/11.5, SAP BI 7.0/BW 3.5, SAP R/3 FICO,Data Quality Management 12.0 /11.7, Informatica, Crystal Reports XI R2, Oracle 10g, SQL Server 2005, PL/SQL, T-SQL, Windows 2003/UNIX.

Confidential, Denver, CO Jun 07 Jul 08
Role: Data Integrator Developer

Responsibilities:

• Performed the Server management and User management and performed ongoing monitoring of the environment, responds to incidents.
• Business Objects Enterprise environment setup, server installations, implementation, upgrades, Configured Report Servers, testing.
• Document all design and development efforts in accordance with Software Development Life Cycle standards.
• Performance monitored Production WI servers, and improved Performance by using various deployment techniques.
• Analyzed the reporting requirements with the business users and come up with the technical specifications.
• Monitoring closely with the end users and decision makers to develop the transformation logic to be used in reports.
• We have extracted the data from various data sources by using DATA INTEGRATOR.
• Developed and tested (DQ) Data quality processes for address standardization and geo coding.
• Generatedexport Data Quality Reports and export all of the specified job reports at once upon execution.
• Perform data quality analysis, standardization and validation, and develop data quality metrics
• Analyzed the reporting requirements with the business users and come up with the technical specifications.
• Constructed simple to complex reports which involved the usage of sub queries in conjunction with @ functions and functions that would generate complex calculations, as well as format the report.
• Implement Data Level Security, based on the Divisions.
• Performed both Unit and System integration testing of the Data marts.
• Involved in performance tuning of Business Objects Report which are running significantly slower.
• Created financial reports like Actual, Planning and Forecast using full client.
• Creating, maintaining and modifying the business critical reports using Web Intelligence.
• Develop reports based on the subject area, using Universes as the main Data providers.
• Documenting the entire effort. The documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents, and System testing documents.

Environment:Business Objects XIR2, Crystal reports, WebI, Informatica, Performance Management, Oracle9i, sql server 2005, Windows 2000, Data Integrator XI.

Confidential,India Jan 03 May07
Role: ETLDeveloper

Responsibilities:

• Interacted with Business Users to know their Business needs to effectively develop and modify Universes and Reports.
• Installed and Configured Data Integrator and Job Server.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Used various transformations like lookup, Case, Merge, Date_Generation, Query, SQL, Table Comparison on data extracted according to the business rules and technical specifications
• Tuned Data Integrator Mappings and Transformations for better performance
• Scheduled Jobs with Data Integrator
• Documented all the mappings and the transformations involved in ETL process.
• Migrating Jobs from one environment to another environment and loading the data to populate the database tables.
• Designed and developed Universes and reports according to the user requirements.
• Used Designer to create Universes and resolve loops utilizing contexts and Alias Tables.
• Developed Complex Reports that involved multiple data providers, Master/Detail charts, cross tab, bar charts, pie charts, complex variables and calculation contexts.
• Created Prompts, Conditions and Filtersto improve the report generation. Also used Alerts to improve the readability of the report.
• Extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks and Alerts in the creation of reports.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Documented all the changes made to the Universes and Reports for future references.

Environment: Business Objects 6.5, Data Integrator 6.5, Crystal Reports, PL/SQL, Oracle 9i, Windows 2003 Server, Web Intelligence 6.5, Apache Tomcat.