SUMMARY

• 10 Plus years of Experience in IT industry on SAP Business Objects from .
• Excellent understanding of Data modeling(Dimensional & Relational) on concepts like Star Schema,Snowflake Schema, Fact and Dimension Tables, Physical and Logical data modeling using Erwin7.2/4.0/3.5, Toad Data Modeler, Microsoft Visio.
• Hands on Integration Experience in SAP BO - BI.
• Created Universes using Information Design Tool and Universe Design Tool.
• Development experience using Oracle, SQL Server, Business Objects Web Intelligence, Desktop Intelligence, Xcelsius or Dashboard Designer, and Crystal Reports, Windows.
• Expertise in all phases of Software Development Life Cycle (SDLC) such as Developing, Testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
• Experience in installation, configuration, administration and upgrading versions of BOBJ Products (BOE, CR, DI) on Windows environments.
• Well Versed with CMS, Page Server, Cache Server, Job Server, Input/output Servers, and CR Servers within BOE.
• Involved in design, enhancement, and development of applications forOLTP, OLAP, and DSSusingdimension modellingwithTeradata and Oracle.
• Expertise in working inTeradata V2R12.x systemsand used utilities likeMultiLoad, FastLoad, FastExport, BTEQ, TPump, Teradata SQL.
• Familiarity with SAP BW architecture and experience in working with SAP BW as backend
• Experience analyzing data in source systems, documenting data requirements, process flows, data cleansing and data validation rules.
• Working knowledge of data modeling (conceptual, logical and physical) as well as database design.
• Skilled in dealing directly with customers
• SAP BOBJ experience in dash sap board/Xcelsius
• Experience in creating WebI reports, Dashboards and Crystal reports from SAP BEX Queries and HANA Views
• UpgradedBusiness Objects universes and reports from versionXI 3.1 to 4.0.
• Involved in testing the reports while migrating fromXI 3.1 to 4.0.
• Used Promotion Management tool to migrate reports and Universes in R4 Environment
• Used SAP LUMIRA to create Dashboards.
• Created Dashboards using SAP Business Objects Design Studio.
• Extensively Used CMC (Central Management Console) for user management, content management, and server management tasks and CCM (Central Configuration Manager) to manage local and remote servers.
• Experienced in developing semantic layer, retrieving data using Universes, Personal data files, stored procedures, SAP Info Cubes and Freehand SQL methods and creating complex Ad hoc Reports using the Business Objects and Web Intelligence Tools.
• Expertise in using Dashboard Managers calendars, metrics, analytics, cooperate/personal dashboards, rules and goals.
• Expertise in working and implementation of Crystal Reports.
• Worked on Crystal Reports 8.5/9/10/XI R2/2008, Crystal Enterprise 8.5/9/10
• Hands on experience in implementing row level security and universe level security within Business Objects.
• Having Knowledge on BI Flavors Live Office, Widgets, Query as Web Service, Business Explore and Voyager.
• Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing the issues.
• Experienced in production support (24*7) of BOBJ Farm.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Good knowledge on SQL Server Management Studio 2008.

TECHNICAL SKILLS

SAP Business Objects: SAP HANA 1.0 SPS 05/04/03, SAP HANA studio, SQLScript, CE functions, (SAP BO BI / BOBJ / BO)

IDT Information Design Tool: Universe Designer, Web Intelligence, Dashboards(Xcelsius), BO Design Studio, Explorer, Analysis Edition, Crystal Reports, Central Management Console(CMC), QAAWS, Live Office, Import Wizard, Report Conversion Tool, Life Cycle Manager, SAP LUMIRA.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio,TX

BI Technical Lead

Responsibilities:

• Worked collaboratively with business owners to assist in development of Business Objects reports.
• Gather customer business and technical requirements and write high-quality requirements documents.
• Developed and managed existing Universes, to enhance and implement Business requirements for reporting purpose.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Created complex webi reports on top of Bank deposits universe.
• Created webi reports to show balances, number of accounts opened, Closed accounts for checking and savings accounts.
• Designed a Corporate webi template based on the corporate standards by changing the default cell size, font size, Paper size.
• Performance Tuning of Web Intelligence Reports.
• Created Dashboards in SAP Design Studio and SAP Dashboards 4.1.
• Created Universes in Information Design tool for the reporting and Dashboards.
• Created story boards on SAP Lumira.
• Created Dashboards on Tableau.

Environment: SAP BO BI 4.1, SAP Design Studio 1.6, SAP LUMIRA, SYBASE DB, Tableau

Confidential, Findlay, OH

SAP Business Objects Lead

Responsibilities:

• Worked collaboratively with business owners to assist in development of Business Objects reports.
• Gather customer business and technical requirements and write high-quality requirements documents.
• Created multi source universe on top of Microsoft APS Platform and Hana Views.
• Created Sub Reports, Standard, Mailing Labels, Cross Tab ReportsandGraph Reportsby usingChart expertof Crystal Reports
• Good at usingsharedandglobal variablesacross crystal reports
• Created Complex Crystal ReportsAd Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports
• Installation of Business Objects 4.1 in clustered environment.
• Expert in creating variousPL/SQL stored procedures, views, functionsand temporary tables for data input to the Crystal Reports
• Deployed reports on the web usingCrystal publishing wizardand scheduled reports usinge-PortfolioandCrystal management console
• Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the Software Development Life cycle.
• Performance Tuning of Web Intelligence Reports.
• Created Dashboards on top of SAP Design Studio.
• Used Custom CSS on Design Studio to enhance the components.

Environment: SAP BO BI 4.1, SAP HANA 1.0, Crystal reports 2011, SAP Data Services 4.2, Microsoft APS, SAP Design Studio, SAP LUMIRA, Microsoft SQL Server Management Studio 2008

Confidential, Herndon, VA

Sr. Business Objects Developer

Responsibilities:

• Worked collaboratively with business owners to assist in development of Business Objects reports.
• Gather customer business and technical requirements and write high-quality requirements documents.
• Developed and managed existing Universes, to enhance and implement Business requirements for reporting purpose.
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Installed Patches, Support Packs and Fix packs after the installation of the base versions according to the client needs.
• Customization of the BI 4.0 web applications like CMC and BI Java Launch pad with the company logos.
• Designed a Corporate webi template based on the corporate standards by changing the default cell size, font size, Paper size.
• Converted Deski reports to Webi reports using Report Conversion tool.
• Migration of Universe, reports to BOXI R3 to BO XI R4.1 Environment.
• Created reports in Web Intelligence tool.
• Maintained & managed different versions of the same document using Life Cycle Manager.
• Created Universes on top of Teradata tables.
• Create various complex reports using Crystal Reports 2011
• Enhance/modify existing reports by creating new Parameters, Formulas etc,
• Interact directly with the business users in gathering requirements
• Optimize various SQL queries to make the reports run faster
• Create and edit alerts on Reports, as per User request
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
• Provide on call support after reports are deployed to production
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Use prompts, alerts, drill down analysis as per the end user requirements
• Create nested, conditional subgroups and formatting features in reports
• Create Sub reports called from the main report to implement the business logic
• Create various database objects like Tables, Views and Stored Procedures by using Toad
• Responsible for defects raised during testing of the reports
• Performance Tuning of Web Intelligence Reports.

Environment: SAP BO BI 4.1, Microsoft SQL Server Management Studio 2008, Teradata

Confidential, East Hanover, NJ

SAP BO/BI HANA Consultant

Responsibilities:

• Worked extensively on Universe Designer, Web Intelligence, Desktop Intelligence, Info view in SAP Business Objects
• Experience in training Business Objects end users
• Constantly worked with Business users to provide them with the data in form of complex reports and excel sheets for analysis
• Worked on cross-tab and master detail reports. Also represented the same as line charts/ bar charts / pie charts of the same
• Performed tuning on existing reports for better performance.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, coloursetc
• Designed & developed various Ad hoc reports for different teams inBusiness (Teradata and Oracle)
• Extensively used Designer to design various universes for different business groups.
• Involved in design, enhancement, and development of applications forOLTP, OLAP, and DSSusingdimension modellingwithTeradata and Oracle.
• Detected cardinalities, loops, and checked the Integrity of Universes
• Configuration of BOE with LDAP Security (LDAP).
• Created Universe using SAP Info cube from Operational data sources.
• Created, maintained users and user groups to use within multiple Global projects for both application and data level security.
• Management of content and data migration through Dev, QA and Prod environments.
• Management of all CMC content.
• Implemented SAP HANA data modelling using Attribute View, Analytic View and Calculation View.
• SAP HANA Data Provisioning and using SAP LT Replication Server(SLT)
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0
• Created Webi reports based on SAP BEx Queries and HANA Views.
• Refreshed the structure of the Universe to get the updated fields from the database.
• Checked for performance information and made additional changes to the reports for performance enhancements.
• Extensively used WEBI, reporter and explorer for querying, reporting and analysis tasks.
• Worked on combine queries using Union, Union All, Minus and Intersect
• Used WebI functions for creating formulas, variables and complex query filters.
• Involved in enhancing the performance of the slow running reports.Data loads from R/3 and from a legacy system (flat files).

Environment: SAP Business Objects XIR4, SAP BW, Teradata, Tomcat

Confidential

Sr SAP BO Consultant

Responsibilities:

• Created Business Objects groups, users and assigned privileges to their accounts.
• Used all types of methods in reporting technology to represent data on report like (filters, alerter, breaks, sorts, ranking, master/detail and Drill).
• Generating Reports from different data providers using Business Objects.
• Used Promotion Management to migrate reports from Dev to QA and Production Environments.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Writingteradatasql queriesto join or any modifications in the table
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Built Universes using SAP BEX Queries.
• Installed and Configured Business Objects on Both Client and Server Installations.
• Involved in CMS configuration, CCM Maintenance, CMC security set-up
• Converting business requirements in to technical requirements with BO technical team.
• Info Areas, Info Objects, Info Cubes, and DSO’s, and created required Transformations and DTP to load data into Data Targets.

Environment: Business Objects XIR3, XIR4, SAP BW, Teradata, Tomcat.

Confidential, Lexington, MA

Business Objects Consultant

Responsibilities:

• Participated in the complete development lifecycle: analysis, design, build and test reports
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
• Created several complex Web Intelligence and Desktop Intelligence reports to help management to track and monitor contract, commodity and price compliance.
• Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report.
• Extensively used Calculations, Variables, User Objects in the creation of reports.
• Created User Prompts, Conditions and Filters to improve the quality of report generation.
• Scheduled Reports using scheduler Infoview as well as CMC.
• Key metrics ‘procure to pay cycle times’, ‘diversity spend’, ‘cash discounts captured and missed’ spanning across different subject areas has been re-created using Xcelsius.
• Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.
• Providing support for the users on application usage and conducting training walk through of salient features of the application.

Environment: BO XIR3.1, Oracle 10g, Tomcat and Windows 2003 Server,Teradata.

BO Consultant

Responsibilities:

• Installation, Configuration and Test/Validation of Business Objects Enterprise (BOE) Server Products in a clustered environment.
• Integration of BO with SAP BI.
• Configuration of BOE with LDAP Security (LDAP).
• Created Universe using SAP Info cube from Operational data sources.
• Created, maintained users and user groups to use within multiple Global projects for both application and data level security.
• Management of content and data migration through Dev, QA and Prod environments.
• Management of all CMC content.
• Migrated the BO Environment from XI R2 to XI R3.1 using Import Wizard/Migration tool.
• Worked in collaboration with PM, Business Analyst, Data Analyst, Solution Architect, BI Developer, DBA to deploy the reporting solutions.
• Involved in the designing and building of the Universes, Classes and objects for the client requirements.
• Modeling to Design Custom Info Providers based on Reporting Requirements.

Environment: BO XIR2, XIR3.1, Tomcat, MS Office Suite and Windows 2003 Server. BI 7.0, Oracle.

Software Engineer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Created reports containing all the information regarding the publishers, distributors and retailers using crystal reports xiR2.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Created different reports containing charts showing revenue and operating income by different divisions, market share of newspaper by circulation.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Provided the security access management by creating users/groups and folders.
• Implemented the ETL process and business logic by using PL/SQL.
• Developed universe user documentation guide for the end users reference.
• Provided training for end users for generating their own report including complicated report.

Environment: Business Objects 6.5.1/ XI r2, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, CMS, Oracle 9i, Teradata, SQL, PL/SQL, Windows XP

BO Administrator

Responsibilities:

• Demonstrated several demos to business owner and user community to have a strong understanding about Business Objects application that we developed and product features.
• Analyzing business requirements converted business requirements in business/technical requirement documents.
• Developing a scope of the application and following up the business requirements time to time.
• Installing and configure Business Objects XI R2 on both Windows.
• Installed and Configured Business Objects on Both Client and Server Installations.
• Involved in CMS configuration, CCM Maintenance, CMC security set-up
• Converting business requirements in to technical requirements with BO technical team.
• Worked in the Team closely with Functional Architect, DBA and Analysts to get a clear understanding on the Application.
• Implemented Filters, conditions in the Universe to the run the Reports quickly.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Views, Stored Procedures and validated data for the Performance.
• Installed and Configured Business Objects on Both Client and Server installations.

Environment: BO XIR2, SQL Server 2005, Tomcat, MS Office Suite and Windows 2003 Server.