PROFESSIONAL SUMMARY

• Six+ years of experience in IT industry, includes SAP BW as Technical and ABAP/4 Programming. Six+ years of Technical hands - on expertise as a Business Objects Consultant, worked on various modules of Business objects like Designer, Deski, Web Intelligence, CRYSTAL reports.
• Undergone 3 complete life cycles implementations of SAP BW/BI and one SAP R/3 full Implementation which dealt with Blue Print, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up-loads), Scheduling, Monitoring, BEx Analyzer, Query Designer, Web Applications Designer, Testing, Go Live & Production support, End user documentation and 1 full life cycle implementation in Business Objects XI 3.1 (BOBJ).
• Upgrade experience in SAP BW from 3.5 to BI 7.0 and in depth knowledge of migrating both backend and frontend from BW3.5 to BI7.x and maintaining transformations and DTP’s.
• Expertise in defining and implementing the BW-BPS data model.
• Extensively worked on the new features of BI 7(NW 2004S) like Data transformations, Data Transfer Process, Remodeling of the Info Cubes, Data Store Objects and the New Data Source, multi-providers, Info sets, Transfer Rules, Update Rules, PSA, Open Hub Service, Data Mart, BW Transports, Aggregates, and Performance Tuning.
• Experienced in creating, organizing, publishing and scheduling reports using Central Management Console.
• Migration of Business Objects 6.5 to Business Objects XI R2 Enterprise. Migration of the content (User, Groups, Universes and Reports etc) using Import Wizard and BIAR files applying Business Objects best practices. Conversion Desktop Reports to WEBI reports using Conversion tool.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, grouping, sub reports etc.
• Experience in Developing Crystal Reports, Crystal Xcelsius Reports (Query as Web Connect).
• Experience in building Dashboards and insightful analytics using EPM and Crystal Xcelsius.
• Good Experience on visually explore and analyzing the business data using Business Objects Explorer.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and parametrized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Strong knowledge of Business Objects SDK with JAVA and JSF knowledge.
• Knowledge in creating a JSF managed bean to handle request data, wire the managed bean to the application's web pages, and convert the web pages into Facelets template files.
• Knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Modeling - experience in design, maintenance of Info Cubes, Multi-Providers, Remote Cubes, ODS objects with consistent star schema and efficient multi-dimensional data modeling techniques.
• Experience in Analysis Process Designs (APD), Real Time Data Acquisition.
• Worked extensively on Designer, Web Intelligence (webi), Desktop Intelligence (Deski), CRYSTAL reports and Central Management Console (CMC).
• Experience in providing training & support to users by answering and documenting business/application questions, helping in creation of adhoc reports.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into designing database, documenting and rolling out the deliverables.
• Experience in trouble-shooting reporting problems effectively and be able to discern reporting defects versus reporting set-ups.
• Experience in following the Change management requests, presenting the data in a simple, meaningful format by creating Charts, Power-point Presentations from Data.
• Proven ability and experience in creating complex financial business reports using Webi, Deski/Full Client, and CRYSTAL Reports.
• Ability to find solutions for Performance problems and to write complex sql queries to verify data and create views.
• Worked closely with project managers, other build teams and Operate on implementation of Business Objects components.
• Knowledge about report Migration from one version to another.
• Excellent Leadership, Analytical, Communication skills and the ability to develop creative solutions for challenging client needs.
• Very good as a team person and efficient at working without much assistance.

TECHNICAL SKILLS/TOOLS

ERP Packages: ECC 6.0, ECC 5.0, 4.7, 4.6C

SAP Modules: MM, SD, CS, CO-PA, FI-GL, CRM, SCM, HR, FI-CO, SEM

Data Warehouse: SAP BO, SAP BW (3.0B, 3.5B, SAP Netweaver 2004s/BI7.0)

Reporting Tools: BEx Reporting (BI 7.0/BW 3.5), BO XI 3.1, 3.0, 4.0, Xcelsius, CRYSTAL Reports.

Languages: C,C++, ABAP/4, SQL

Web: HTML, XML, Dreamweaver

Tools: OLAP Tools: Business Objects XIR3.1/XIR2/6.X/5.X, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, CRYSTAL Reports XI, Xcelsius 2008, Broadcast Agent, CMC, Performance Management, QAAWS, EQM 4.0.

RDBMS: Oracle8i/9i/10g, SQL Server 2005/2008 R2/2012 & MS Access 2010

Operating system: Windows XP/7, Sun Solaris, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Business Objects Developer/Analyst

Responsibilities:

• Involved in all phases of Software Development Life Cycle such as Development, Testing, Migration, Administration and Production.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and helping outline the proposed solution.
• Administering Business Objects Enterprise XIR2 using Central Management Console and Seting up multiple Business Objects environments for different users.
• Implement Support Processes for BO Application Support.
• Creating Groups and defining security on Folders, Objects, Universes and Business Objects Enterprise applications like Webi, deski, InfoView, CMC and Designer.
• Advise best practice approach for development and support activities.
• Creation and maintenance of users and assigning them to respective groups based on their profiles and security and explicitly granting permissions if necessary.
• Creating folders, categories and setting permissions accordingly.
• Worked as a developer in designing the Universes and generating critical IB reports like Derivatives Reports, Country Risk Reports, Lender Work Station, Operational reports, Risk Grade Changes, TCP-FM reports, ORS reports, etc.
• Team lead to an offshore team as a part of a couple of reporting projects. Provided direction, training and mentoring to the offshore team in understanding the data and report creation.
• Provided support to users by answering and documenting business/application questions, helping in creation of adhoc reports and resolving customers’ issues related to business workflow/logic. Support to Users included direct one-on-one training and also remote assistance.
• Maintained and worked on the version control system (Enterprise Quality Manager EQM) to migrate various Universes and Reports across different environments.
• Implemented Standard Naming convention across Universes and Reports.
• Worked on different user entitlements to protect sensitive information from being exposed to general users.
• Involved in the migration of universes and reports from 6.x to XIr2.
• Learned various concepts like Risk Grades, Stand Alone, Obligor, Default and Facility Grades, Exposures, etc.
• Design and Hierarchy Building for Data Analysis, Aggregate Navigation, and apply conditions to the Objects in the universe. Creation of pre-defined conditions, Case Statements, Cascading Prompts.
• Created a large number of Full Client and Web Intelligence reports. Functionalities such as Slice and Dice, Drill mode and Ranking, complex IF statements, Where Clauses were used for Multidimensional Formatting.
• Reports were created using multiple data-providers. Reports involved Current Date-Prior Date, Weekly, Monthly, Quarterly comparison of Exposures, grade changes, etc.
• As a part of report development used powerful business objects functionalities like linking, Subqueries, Ranking, Alerters, Charts, Filters, Contexts, and Merge Dimensions etc.
• Involved in trouble shooting and performance tuning of the existing and new reports.
• Found work-around and solutions for various problems posed during the design phase.
• Implemented various solutions for Performance tuning of reports.
• Imported CRYSTAL Reports from previous version to Current version XI R2.
• Developed Standard CRYSTAL Reports with LOV’s using Business View Manager.

Environment: Business Objects XIr2, CRYSTAL Report XIr2, SQL, Oracle 9i/10g, DB2, TOAD, MS Office XP, EQM 4.0, Lotus Notes 6.5.4

Confidential, NJ

sap bi/bo consultant

Responsibilities:

• Created Info Objects, Info Sources, Info Cubes and developed transfer structure, update rules and transfer rules as per business requirement and extracted data from external sources.
• Extract, Transformation and load data from ECC into BW using Enhancement, LO Cockpit, Custom and Standard.
• Develop query using BEX analyzer and web designer.
• Performed Architect tasks such as communicating the technical benefits of all Business Objects and OLAP technology.
• Worked with the team to keep track of the Business Objects design environment and incorporate BI where applicable.
• Installed Business Objects XIR2 version, Migrated Business Objects universes, reports from 6.5 to XIR2 version, enabled Audit functionality in BO.
• Migrated Business Objects XI R2 content in to Business Objects XI R3 environment using the Import Wizard.
• Administered DB2 subsystems in Prod, Qual, Test and Development regions
• Participated in design review meetings, involved in logical design and in converting logical model into a physical database model
• Analyzed index requirements and designed appropriate indexes.
• Performed SQL tuning and bind plan/package creation for enhancements and developments.
• Prepared test environments and performed data refresh.
• Designed, debugged and implemented stored procedures and triggers.
• Produced and analyzed DB2 performance reports.
• Install and Configure Development and Production Environments.
• Created the User Groups and Users, Set up the privileges to them according to their requirement.
• Creating users and groups assigning the access levels.
• Creating folders and Categories.
• Monitoring the Servers and maintaining the servers.
• Monitoring the day to day activities in the servers.
• Migrating the Universe/Reports from Development/QA to Production.
• Managed scheduled and notification options for documents to the desired users.
• Worked on Migration of Business Objects 6.5 to Business Objects XI R2 Enterprise. Migration of the content (User, Groups, Universes and Reports etc) using Import Wizard and BIAR files applying Business Objects best practices.
• Conversion Desktop Reports to WEBI reports using Conversion tool.
• Created the Row level securities for restricting the accessability of data based on user access levels.
• Designed Business Objects Universes. Used Contexts and Alias to resolve the Loops.
• Extensively Created Derived Tables in the Universe.
• Developed reports using various functions, operators, Calculation Contexts, report filters and variables.
• Restricted the data using the Prompts and filters.
• Interacted with the Business analyst and the Manager in gather the business requirements to design and develop reports.
• Involved in Installation, Configuration and Deployment of Business Objects Suite.
• Involved in designing and building of Universes, Classes and Objects by resolving complex loops by defining contexts and aliases.
• Created canned and Ad-hoc reports using WebI/Deski Reports.
• Modifying existing WEBI reports and supporting the UAT process.
• Expertise in creating reports using the Business Objects functionalities like Prompts Slice and Dice, Open document (Linking Reports), Drill Filters and Aleter.
• Fine-tune the existing universes to enhance their performance.
• Converted existing CRYSTAL reports to Business Objects and Web enabled them.
• Worked on the Database Performance & Tuning and supported the Production System.

Environment: Business Objects XI 3.1/ R2, Web Intelligence, Info view, Designer, Data Integrator, CRYSTAL Reports XI, CMC, Oracle 9i, PL/SQL, Teradata, Windows XP and UNIX.

Confidential, NJ

SAp BI, business objects developer

Responsibilities:

• Involved in all phases of Software Development Life Cycle such as Development, Testing, Migration, and Production.
• Involved in the migration of universes and reports from XIr2 to XIr3.1.
• Creating Groups and defining security on Folders, Objects, Universes and Business Objects Enterprise applications like Webi, deski, InfoView, CMC and Designer.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and helping outline the proposed solutions.
• Worked as Business Analyst in providing information to end users with their day to day data requirements and designing BRDs (Business Requirement Documents).
• Optimization and Formatting of the Existing Universes for easy understanding for the Users. Implemented Standard Naming convention across Universes and Reports.
• Helped users in solving adhoc query issues, building adhoc reports, setting up report schedules in Infoview.
• Design and Hierarchy Building for Data Analysis, Aggregate Navigation, and apply conditions to the Objects in the universe.
• As a part of Universe development, created Classes, different kinds of Objects, cardinalities, Strategies, resolving loops using Aliases and Contexts.
• Created views on oracle and derived tables in the universes to meet the BO report design requirements.
• Analyzed and explored the existing the MS Access Reports to understand the data and data availability.
• Created CRYSTAL Reports using CRYSTAL Designer XI R2 and 2008.
• Used CRYSTAL functionalities like Sub Reports, Variables, Different Charts and Cross Tabs.
• Published CRYSTAL Reports from Dev to UAT and UAT to Productions environments.
• Worked on new functionalities in XIr3 like - Data-tracking, Optional Prompts, Smart Measures, Personal Data-providers in WebI, etc
• Dealt with large volumes of data coming from the database to migrate across the latest versions of the Business Object system.
• Modified and corrected many existing reports/universes as per the change requests from users.

Environment: Business Objects XIr3.1/XIr2, CRYSTAL Reports XI, SQL, Oracle, MS Office XP/2007, MS Outlook 2007, GroupWise.

publix, florida

sap bi/bo consultant

Responsibilities:

• Involved in requirement gathering from Business users, Responsible for understanding end user requirement and convert into functional requirement and involved in Designing reports using SAP BI 4.0 and XI 3.1
• Analyzed business reporting requirements that could be satisfied with SAP business content and installed the necessary objects.
• Identified data sources based on end-user reporting requirements, and created Info Cubes, extracted data from SAP BI info cubes, DSO’s, Info Sets and Multi Providers
• Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts.
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users and business users.
• Responsible for delivery of Business Objects Reports environment on time.
• Created Master/Detail, Cross Tab and Chart templates using the Business Objects and Web Intelligence tools.
• Created Single or multi line chart for showing tendency over a period of time particularly used in revenue history using Dashboard Designer and Xcelsius on top BW sources and Universes.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart and Bubble chart using Xcelsius.
• Created Revenue Dashboard, Sales figure Dashboard using Xcelsius 2008.
• Involved in Security Design and Implementation, performance tuning of reports, unit testing and documenting the processes.
• Performed Admin tasks like monitoring DB Services, monitoring BO server running with optimal performance, monitored licenses, monitoring of user activities/ sessions etc.
• Created a stable environment for Business Objects XI 3.1 by scaling the number of processing servers based on the user base and access frequency.
• Organized data in the report Inserting Filters, Sorting, Groups, Prompts, Ranking and Highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Created Aliases and Contexts for resolving Loops in the Universes to improve performance.
• Designed Universes based on SAP BW info Cubes
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
• Extensively used BEx analyzer, created queries with variables, filters, calculated key figures, restricted key figures, exceptions, conditions etc.
• Designed extraction / transformation routines using Data Integrator to extract data from various source systems.
• Extensively used ETL tool Data Services to extract, transform, and load the data from databases and applications into a data warehouse used for analytic and on-demand queries.
• Designed work flows and data flows involving Map Operation, History Preserving, Date generation, key generation, Merge, Table comparison, Row Generation and SQL transforms.
• Created reports using SAP data source using the SAP best practices.
• Created hierarchy and conditions in the universes for reporting needs to drill down reports on hierarchies.
• Assigned security levels to the users in the universe according to the requirement.
• Implemented the SAP-BI environment for Business Objects including universe, BI infrastructure configuration, and security.
• Uploaded Master and Transactional data from flat files and SAP BI.
• Responsible for writing Stored Procedures, Functions, Triggers using T-SQL for data retrieval from SQL Server database and also performance tuning.
• Writing functional specs and design specs
• Worked with other team members in US through net meeting and teleconferencing.
• Performed the knowledge transfer and mentoring to other team members.

Environment: SAP Business Objects, Web Intelligence, Info view, Designer, Desktop Intelligence, Data Integrator, Dashboard Design, SAP BI Integration, BEx Analyzer, Windows Server 2003, SSAS and SQL Server 2005.