SUMMARY

• 10 Plus years of Experience in IT industry on SAP Business Objects from .
• Excellent understanding ofData modeling(Dimensional & Relational) on concepts likeStar Schema,SnowflakeSchema, 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 HANA 1.0 SPS 05/04/03
• SAP HANA studio
• SQLScript
• CE functions
• SAP Business Objects (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 with the Data Management team (Business Analyst) to gather, analyze, and document business requirements, functional requirements, and data specifications for Business Objects universes and reports.
• 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
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals
• 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.
• Customized some of the attributes in the style sheet (WebIDefaultStyleSheet.css) such as Font size, Color, Cell size, Padding, Background, Border etc for Cells, Tables, Section, Break etc.
• 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.
• Used Slice and Dice, Drill Down, Filters, Master Details, Cross Tab and formulas and developed Hierarchies to support drill down reports and created complex variables, multiple breaks and sorts, and cascading prompts in the reports.
• 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. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc
• 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.
• 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.
• 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.