Summary:

• Over 7 years of IT experience in Analysis, Design and Development of Client Server and Web based Business Intelligence, Reporting and Data Warehousing applications.
• Extensive experience in all the phases of Software Development Life Cycle SDLC such as Requirements Gathering, Analysis, Design, Implementation, Maintenance and also involved in the Production Support.
• Worked with End-To-End implementation with Data Warehousing team and strongunderstanding of Data warehouse concepts Star Schema, Snowflake Schema and Multi-Dimensional Models.
• Extensive experience in Business Objects BI 4.1/4.0/XIR3.1/XIR2/6.x tools like Information Design Tool/Designer, BI Launchpad/Info view, Web Intelligence, Desktop Intelligence, Dashboard Design, Explorer, Advanced analysis CMC, CCM, Import Wizard, Life Cycle Manager, Report Conversion tooland implementation of Business Applications in SAP BW 3.5/BI 7.0/7.3/7.4 and ECC, CRM, SCM, APO, SD, MM, PA, FI/CO,MFG, HR/HCM, ABAP 4/5 programming
• Trained SAP Business Objects end users in Business Objects reporting features.
• Applied Security features of Business Objects like row level, report level object level security in the universe so as to make the sensitive data secure by creating Users/Groups/Sub-groups assigning the privileges.
• Created OLAP Universes on BEx queries and BI Info Providers.
• Worked with Crystal Reports 2008/2011 for creating complicated reports including parameter based reports, graphical reports, sub-reports, formula based, well-formatted reports, analysis reports, drilling reports, data reports along with LOV.
• Expertise in Designing Universe using Derived Tables, Aggregated Tables using Aggregate Awareness, Index awareness, Contexts.
• Strong background in Oracle RDBMS, Data Warehousing, Data Modeling, and Reporting.
• Knowledge on new features of SAP Business Objects XI R2/R3/R4 and 6i including Derived tables, Central Management Console, Index awareness, Live Office, Encyclopedia, Discussions
• Created new objects in the Universe based on the report creation requirements.
• Worked on Customization which includes activating standard Business Content, extending and enhancing Info Cubes according to the requirements, Data Source Enhancements, User Exit Variables, Virtual Key Figures, Start/End Routines and Formula Builder.
• Efficient in Optimizing, Debugging and testingSQL queries and stored procedures written in Oracle and SQL Server.
• Good experience in creating Executive dashboards for management showing summary metrics for the Key performance Indicators KPI's
• Worked on SAP ABAP 4/5 Used SAP ABAP 5 in writing the Start routine , Field level routine End Routine Expert Routines Writing functional modules Debugging writing customer exits and also customized selections in DTP's and Info Packages in BI 7.0/7.3.
• Worked on Customization which includes activating standard Business Content, extending and enhancing Info Cubes according to the requirements, Data Source Enhancements, User Exit Variables, Virtual Key Figures, Start/End Routines and Formula Builder.
• Experience in Xcelsius2008to create Interactive Dashboards by using Query as a Web Service QAAWS andLive Office.
• Experience on working in a version migration environmentfrom SAP Business objects 5i to 6i, 6i to XI and 5i and XI to XIR2.
• Extensive experience in Production support, Data loads, Validation and trouble shooting of transaction data and Master data, Transport Management, Roles Security, System Checks, Performance tuning and process chains
• Excellent Communication, Strong Decision making, Organizational skills, and Customer Service oriented. Excellent analytical and problem solving skills

Technical Skills:

Professional Experience:

Confidential

Senior SAP BI / BO Consultant

Confidential is a leading provider of independent investment research in Confidential. They offer an extensive line of products and services for individual investors, financial advisors, asset managers, and retirement plan providers and sponsors.

Responsibilities:

• Involved in Business meeting with the Business users for requirements gathering, business analysis and making technical specifications for the reports.
• Worked with Functional Managers / BA's / End Users to gather reporting requirements to implement business logic for successfully implementation of reporting system to satisfy the needs of Business Units.
• Designed Mockup of the reports and presented to users.
• Created APS Dashboard, APS Process Monitor reports.
• Created joins and implemented Aggregate awareness in the APS Operational View and APS Reporting View universe.
• Created and involved in Most of the views and MT tables which we have used in the universe and reports.
• Involved in performance tuning and optimization on business objects universes by creating aggregate tables.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Extensively worked on creating contexts for the Universe based upon the Business Flow.
• Developed Hierarchies to support drill down reports.
• Created Cascading prompts in the universe as per the user requirements.
• Customized LOV's List of Values as per the user requirement.
• Performed Integrity testing of Universes Universe Structure checking, Objects Parsing, Join Parsing, Conditions Parsing, Cardinalities checking, Loop checking and Contexts checking after any modifications to them in terms of structures, classes and objects.
• Exported the universes to the Repository to make resources available to the users.
• Updated and maintained existing universes based on changing user requirements and changes in data source.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Created hyperlink WEBI reports using opendoc function and created some drill down and drill up reports.
• Detected loops in the universe and resolved the loops by creating Aliases and Contexts and checked the Integrity of the Universes.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Generated various numbers of reports on a daily, weekly and monthly basis using Business Objects Report module.
• Worked with testing team in validating various reports.
• Managed all phases of the application testing process, including specifying testing requirements, planning tests, executing tests, and tracking defects through Mercury Quality Center application.
• Migrated the reports from DEV to SIT and DEV to UAT using Import Wizard.
• Formatting the Reports based on the Users requirements using the functionalities in Business objects like Drill Down, Alerts, User response, Functions.
• Scheduling the reports through CMC and WEBI level by refreshing and sending to the in box/corporate documents.
• Involved in training end users located all over globe in basic and advanced adhoc reporting.

Environment: SAP Business Objects XIR3, Desktop Intelligence, Web Intelligence, Designer, Import Wizard, Report Conversion tool, Central Management Console, Oracle, Abintio,Peoplesoft

Confidential

Senior SAP BI / BO Consultant

Confidential Information Technology Services provides centralized IT services to the State and its governmental entities with the awareness that their citizens are reliant on those services. At ITS, they set statewide technology policy for all state government agencies and monitor all large technology expenditures in the state, seeking efficiencies, lower costs and innovative solutions.

Responsibilities:

• Involved in Full life cycle of Business Intelligence Application right from requirements gathering till the deployment of the reporting system on to the production.
• Involved in BFC, dimension Concepts, Collecting Data, Monitoring the Consolidation Process, Initializing Consolidation, Consolidating, Creating Manual Adjustments, Analyzing Data ,Initializing a New Data Collection, Configuring the Structure Creating Data Entry Schedules.
• Worked extensively on implementation and extracting from CRM to BW and reporting on them.
• Worked extensively on OLAP and OLTP tools.
• In BFC Involved in Collect, consolidate and publish account statement data and configure the application for your consolidation needs.
• Designed and created custom Multiproviders, InfoCubes, DSO, InfoSets, enhance extractors, transformation, DTP and Info package.
• Extend the Business Content Data sources using Enhancements and populate the appended fields using User Exits. Create custom Info Source/Data Source, DSO, and Info Cubes for Data extraction, transformation and loading from SAP R/3,FICO system to SAP BW.
• Extracted Data from Existing BI Info Providers and ECC Custom Data Sources using Generic extraction and also using Flat files.
• Involve in BO universe design and on integration of SAP BW and SAP BO using SAP integration Kit.
• Extensive experience in writing the documentation for Technical Specifications and functional requirements.
• Review and validate data loaded into the data warehouse for accuracy and at the same time, interacts with user community to produce reporting requirements.
• Implement various Performance Tuning techniques to increase the performance of Queries by Creating Aggregates, Partitioning and Compression of info cubes.
• Responsible for Identifying Business Requirements from end-users. Perform GAP analysis against Business Content. Modeling various objects like Info Object, Info Source, Info Cubes and DSO Object.
• Migrated Business Objects XIR3 content users/user groups, Universes, reports into Business Objects BI 4.0 environment using the Upgrade Management Tool.
• Used Analysis Process Designer Data from different data sources in the BI system and gathered data from different data sources combined, transformed, and staged for analysis in several individual steps and resaved in data targets in the BI system
• In BFC, Configuring the Category Scenario, Configuring Ledgers for Manual Adjustments, Creating Data Analysis Reports, Initializing New Data Collection, Configuring Security
• Worked on BODI/BODS transformations like Query, Hierarchy Flattering, Query, Map, Pivot, Reverse Pivot, Table Comparison, Temp Tables.
• Worked on US Address Global Address cleaning, Match transformations to clean the data by suing Quality transformations in BODI/BODS.

Environment::SAP BI 7.3, ECC 6.0, Bex 3.x, 7.x,FI,CO,CRM, SAP ABAP 5,Business Object BI 4.0/XIR3.1, Business Objects Data Services XI 4.0, Xcelsius 4.5/2008,Design studio 4.0, Crystal Reports 2008,Designer, Web Intelligence, Info View, CMC,SDK, Oracle 11g, SQL, PL/SQL, SQL Server 2008, TOAD, Erwin 6.1, Windows 2007

Confidential

Senior SAP BI / BO Consultant

Confidential is an international, integrated energy company. It has six segments. Its E P segment explores for, produces, transports and markets crude oil, natural gas, natural gas liquids and bitumen on a worldwide basis. The Midstream segment gathers, processes and markets natural gas produced by ConocoPhillips and others, and fractionates and markets natural gas liquids, predominantly in the United States and Trinidad. Its R M segment purchases, refines,markets and transports crude oil and petroleum products. It is also one of the Fortune 500companies.

Responsibilities:

• DevelopedCrystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports.
• Created parameterized Crystal Reports and customize existing reports for presentations using Cross-Tab reports sub-reports, Running Totals, used Crystal syntax to create formulas for the reports.
• Involved in Designing Xcelsius Graphs using QAAWS.
• Involved in designing EXEC DASH Board universe for all the reporting Needs
• Used Input controls, report elements, drillfilter, Timedimto accomplish complex requirements.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Performed various techniques for performance both in BO and BW.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Defined and Created Hierarchies as per the business rule for the reports to be viewed at selected reporting level. Checked the Integrity of the Universes and exported the Universes to Repository for making available to users.
• Involved in BI implementation include BI configuration, requirement gathering, configuration, extraction setup, functional and technical design, data modeling, extractor setup and developing BI objects
• Enhanced InfoCubes with remodeling concept to make changes, without having to reload data
• Designed Complex Queries, Transfer Rules, Update Rules, Extracted Hierarchies and Created Aggregates
• Implemented Start and End routines within Transformations
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0
• Performed migration of emulated data source with Export and without Export.
• Created Data Transfer Process DTP to transfer data within BI from PSA Persistence staging area
• Worked on the extraction of data's from LO cockpit-SAP R/3 , FICO and MM to BW.
• Worked extensively on OLAP and OLTP tools.
• Implemented new concepts and technologies that are available in the Data Warehousing Workbench for process design and data modeling.
• In BFC, Configuring the Category Scenario, Configuring Ledgers for Manual Adjustments, Creating Data Analysis Reports, Initializing New Data Collection, Configuring Security
• Involved in BFC, Dimension Concepts, Collecting Data, Monitoring the Consolidation Process, Initializing Consolidation, Consolidating, Creating Manual Adjustments, Analyzing Data,Initializing a New Data Collection, Configuring the Structure Creating Data Entry Schedules.
• In BFC Involved in Collect, consolidate and publish account statement data and configure the application for your consolidation needs.
• Involved in upgrading the environment from BW 7.0 to 7.3
• Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Created Reports using Crystal reports formulas, Grouping, Parameters to handle the end user requests from Tables, Stored Procedures, Views and Command Objects.
• Involved in displaying data from legacy systems andrelational databases and also in creating, modifying reports using tables, views, functions and stored procedures.
• Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.

Environment: SAP BI 7.3/7.0, ECC 6.0, FI,CO, CRM,SD, MM, Asset Accounting, Logistics, Inventory and COPA,SAP ISU,SAP ABAP 4/5,Business Object BI 4.0/XIR3.1/XIR2,Xcelsius 4.5/2008, Crystal Reports 2008,Designer, Desktop Intelligence,Web Intelligence, Info View, CMC, Oracle 11g, SQL, PL/SQL, SQL Server 2008, TOAD, Erwin 6.1, Windows 2003 and UNIX

Confidential

Senior SAP BI / BO Consultant

Confidential scalable business solutions for employers of all sizes. ADP services provide the widest range of HR, Payroll, Tax Support, and Benefits Administration from one single source. ADP offers superior customer service and new integrated technologies to easily manage the business behind your business

Responsibilities:

• Changed the Info view page layout by adding new features like the company details instead of the Business Objects logo by using the customization methods.
• Migrating Universes and reports to one environment to other environment and involved into installation configuration
• Created user defined prompts and complex conditions at Universe level for better performance.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Generated Full client Reports from Different Data Providers in Business Objects using Oracle Database.
• Created Compound Analytics, Charts and Goals on the Dashboard Manager.
• Created Universes for Customized Metrics and Goals to Create Metric Analytics and Goal Analytics.
• Scheduled Metrics and Analytics to refresh for a scheduled time.
• Created Analytics on top of Metrics for the Performance Manager.
• Opened tickets in the Tracker for Reporting purpose to track all the Report statuses purpose.
• Created Derived Tables in the Universe using views and stored procedures to meet the Desktop Intelligence Reporting Requirements.
• PM repository development and Metrics development.
• Created Cascading Prompts on the Reports.
• Implemented Filters, conditions in the Universe to the run the Reports quickly.
• Created single sign-on for many reports using the URL functionality to access them directly for upscale users.
• Created Analytic Dashboards for upscale users on the Financial Actual Budget and Target Budget.
• Created Metrics, Metrics lists and used different analytics.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Wrote Complex SQL Queries for Data validation purpose.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Views, Stored Procedures and validated data for the Performance.
• Created reports with maintaining and developing MS Access databases
• Created hundreds of reports in thin client and full client using all the functionalities
• Used the Export option for the Reports to schedule them in Broadcast Agent Server and sent the scheduled reports via Email, Text and Excel formats.
• Used the Broadcast Agent Server to Schedule and Monitor the Reports.Prepared Documentation to understand how the reports will work and how to use the functionality with step by step.
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.

Environment:Business Objects Xi 3.1 SP4, 4.0 Crystal Reports 2008, XCelsius 2008, Teradata 13.0, MS SQL Server 2008.

Confidential

Senior SAP BI / BO Consultant

Confidential is a diversified financial services holding company with primary business units in banking operations through Bank Atlantic, and investment and financial a service through Ryan Beck Co. Ryan Beck is one of the leading specialty investment banking financial services firms in the United States. This project involves the Design, development and maintenance of Business Objects universes and Reports to enable various portfolio analysts to analyze the markets and execute trades and to buy/sell stocks, bonds, loans and credit derivatives.

Responsibilities:

• Led the team and involved in gathering, analyzing, and documenting technical requirements from the functional requirements.
• Interacted with business users to know their business views in developing and modifying Dashboards, Reports, Universes and User Security.
• Developed Crystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports.
• Integrated BO XI 3.1 with Portal 7.0 and BI 7.0 successfully and created IView's to show BO Webi and XCelsius reports in portal.
• Interacted with Business Analyst and end users to gather initial business requirements and developed reporting prototypes for user presentations.
• Involved in installation of Business Objects Enterprise XI R 3.1 on development box.
• Experience in User Administration of BO XI environment for setting up user accounts and groups using Central Management Console CMC .
• Build Webi reports with different functionalities like Dynamic cascading prompts, drill down, linking reports, charts and graphs, ranking and set Alerters to enable exception highlighting in the reports for business conditions alerts.
• Managed the user, groups, repositories and the documents through the BOXI 3.1 Central Management Console CMC .
• Extensively worked on CMC in maintaining objects, Universes, Connections, Resources, Users, User

Groups,and Categories in BO XI 3.1.

• Development of BO Universes for Cases Budget Analysis and AFS.
• Involved in Performance tuning of reports using derived tables and index awareness.
• Developed Performance Management Dashboards to set goals, measure and monitorKPI's for balance scorecard initiative.
• Responsible for developing thick/thin client canned reports using Desktop Intelligence and Web Intelligence Infoview .
• Scheduled and distributed the reports to the end users using Broadcast agent BCA .
• Worked on SQL and Scripts Basic Crystal for solving the problems in Crystal Reports.
• Utilized Business Intelligence capabilities of Business Objects using Business Objects SDK to support event handling in reports. Built the feature of Nested Prompts in reports using BO SDK.
• Used BCA Publisher and BCA Scheduler to send the documents to the repository.
• Worked with Macros and SDK to improve the performance of universe as well as reporting.
• Created Dashboards and Scorecards using XCelsius 2008.
• Maintained Modified Universes using BO Designer and exported to the CMS Repository.

Environment:Business Objects Xi 3.1/3.0 Java SDK, Crystal Reports, XCelsius 2008, Web Intelligence,.NET, QAAWS Oracle 10G, MS SQL Server 2005,Windows 2003,Solaris Server.

Confidential

Senior SAP BI / BO Consultant

Confidential is a research-based, global Pharmaceutical Company responsible for the discovery and development of today's most innovative medicines. Wyeth has a long history of pioneering developments in pharmaceuticals and biotechnology. The Project includes creating the reports to monitor the sales of the various products as per the region and by pulling the historic data from the EDW Enterprise Data Warehouse .

Responsibilities

• Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Extensively used BEx analyzer, created queries with variables, filters, exceptions, conditions, calculated key figures, restricted key figures.
• Created RRI so that the user can jump from one report to the other.
• Developed several queries and the workbooks using BEx Analyzer according to end users requirement for SD billing document, deliveries, planned sales/ actual sales .
• Involved in activating the Master Data sources and loaded the master data in SD and MM areas.
• Created and maintained the info cubes in SD for Billing, Deliveries and Sales Orders Overview.
• Worked on Info Objects, Data Sources, ODS and Info Cubes to facilitate corporate reporting.
• Worked on the extraction of data's from LO cockpit-SAP R/3 to BW.
• Extensively worked in extractions, LO-Cockpit extraction 2LIS 02 ITM, 2LIS 13 VDHDR and others using V3 update.
• Responsible for building and maintaining the Info Cubes / Info Providers, in Purchasing for Purchasing Data 0PUR C01 , Vendor evaluation 0PUR C02 from the standard Business content.Created transfer rules, update rules and the start routines wherever required.
• Maintained and created aggregates to improve the performance.
• Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Created predefined condition, prompts and customized LOV's in the process of building the Universes.
• Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
• Extensively created reports in WEBI and DESKI module and implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.
• Created reports on web using Info View Portal and published the reports on the World Wide Web to different users.
• Created several Classes, Objects, Conditions, and Measure objects
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Resolved loops, defined contexts and aliases to resolve loops and also tested them to ensure that correct results are retrieved.
• Resolving join path Problems like 'Chasm Trap' and 'Fan Trap' and loops by creating Context and Aliases.
• Exported the Universes to the Repository to make resources available to the users. Created reports from the Universes as the main Data Providers
• Created reports using Universe, Free-Hand SQL, and Stored Procedures Data providers.
• Improved the performance and reduced the coding with the use of functions aggregate aware, select, prompt, where . Created complex reports using different data sources.
• Developed and supported Business Objects reporting system for various Business units.
• Tested the created reports and modified the relevant objects in the Universe.
• Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence

Environment: BW 3.5, ECC 5.0, ABAP/4, SRM, SD Business Objects XIR2,Xelcius 4.5/2008, Web Intelligence,Desk I, SDK, Oracle 10g, PL/SQL, SQL Server 2005, Toad,Erwin, Windows 2007 Server/ XP/Professional and Unix shell programming

Confidential

Business Objects Developer

Confidential along with its subsidiaries, is primarily engaged in providing a range of information technology, business process outsourcing BPO and infrastructure services. The Company delivers solutions across verticals, including aerospace and defense, automotive, energy and utilities, financial services, government, life sciences, healthcare, media and entertainment, retail and consumer, telecom, travel, transportation and logistics. The Company'sinfrastructure management services involve the sale of networking equipment and software,installations and provision of access and maintenance services.

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirements Specification document.
• Creation of database objects like tables,views,procedures,packages using Oracle tools like PL/SQL,SQL Plus,SQL Loader and Handled Exceptions
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Created PL/SQL stored procedures by using bulk bind for inserting, updating data in process tables.
• Created Dynamic generalized procedures for truncating current and old partition data.
• Designed the front end interface for the users using Forms 6i.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Developed number of reports using Reports 6i.
• Performed Unit Testing.

Environment: Business Objects 5i, Web Intelligence, Broadcast Agent, Oracle 8i, DB2 Version 7.0, PL/SQL, UNIX, Windows NT and TOAD.