SUMMARY:

• Having 10+ years of SAP Business Objects4.x and 3.x (Universe Design Tool, IDT, Web Intelligence, Crystal Reports 2013, SAP Dashboards), good experience on ETL tools like SSIS and Informatica.
• Expertise in Designing and maintenance of Universes (UDT and IDT)from different data sources like Oracle, MS SQL Server and IBMInformix Databases.
• Extensively developed complex Web Intelligence Reports using Drill down, Drill up, Section, Alerts, Breaks, Ranks, Custom Sort, Charts and Variables.
• Created Webi Reports from SAP NetWeaver BW directly via BICS in BO 4.1.
• Extensively worked wif Xcelsius/SAP Dashboards from SAP and NON SAP data sources.
• Good Experience in writingSQL Queries, creating Views, Stored Procedures and Schedule Jobs.
• Worked wif Crystal Reports for creating complicated reports including sub - reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports.
• Experience and involved in Migration of Business Objects from BOBJ 3.1 toSAP BI4.1.
• Migrated Desktop Intelligence reports to Webi reportsusing Report conversion tool directly in BI 4.1.
• Experience in setting up environments for teh project dat involves creatingUsers and groups, applying security at teh folder and report level in CMC.
• Created Row level and Object LevelSecurity and Implemented customized security at user level wifDerivedTables in teh Universe.
• Experience in ETL tools like Microsoft SSIS and Informatica to load and manage data into Data warehouse.
• Hands-on experience tuning SQL using execution plan analysis
• Excellent noledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts.
• Expertise in Universe designing, developing and generating complex, Ad-hoc, dashboard Reports, List of values along wif User Acceptance Test and data accuracy test.
• Experienced in interacting wif business users to analyze teh business process and requirements and transforming requirements into screens, designing database, documenting and rolling out teh deliverable.
• Handled complex projects using end to end SDLC and prepared Functional documentation, HLD & LLD, STS (Software Testing Specification), Test Plan Design and Review.
• Good Knowledge on SAP Lumira, SAP BODS, SAP Explorerand Tableau.
• Good Knowledge in SAP HANA data modeling (Attribute View, Analytic View and Calculation View).
• Created Dashboard using SAP Design Studio, used java script for dynamic Charts and interactivity between teh components, Dashboard formatting done wif CSS Code.
• Knowledge on SAP BW/BI workbench for defining Info objects, Info Cubes, Multiproviders, DSO objects and infoSets.
• Worked wif BEXQueryDesigner using calculated key figures, restricted key figures, free characteristics, formulas, filters, structures, Conditions, Exceptions and Variables.
• Expert in writing Microsoft Excel Macros using VB Scripts and recording methodologies.

TECHNICAL SKILLS:

OLAP Tools: Business Objects 4.1/ 3.x/XIR2 Designer, SAP BW/BI, SAP Dashboards (Xcelsius), WebI, Promotion Management and Crystal Reports

DBMS: Oracle8i/9i/10g, SQL Server 2008 and IBM INFORMIX

SAP: SAP BO, SAP Design Studio, SAP Explorer

ETL Tools: SQL Server Integration Services (SSIS) and Informatica 9.1

Languages: VB, SQL and PL/SQL

Operating Systems: Windows, WIN NT and Unix

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Senior SAP BI Developer

Responsibilities:

• Interacted wif business users in understanding teh reporting requirements and functional specifications
• Independently manged complex projects through implementations, coordinated wif project leads, development teams and testing teams
• Providing status updates and participating in calls wif teh client
• Managed user, user groups and controlled user access using Central Management Console. Involved in installation 4.0 and upgraded 4.1 sp4.
• Designed and developed small data marts basing on report requirements.
• Involved in requirements gathering, data modeling, planning/scheduling data extraction from source systems
• Created various WebI reports on UDT using input controls and drop down filters and provided interactivity to teh reports.
• Created and maintained complex Webi reports on BEx queries wif BICS connection.
• Created OLAP Universes on cubes using Universe Designer and Information Design Tool
• Created Dashboards using SAP Business Objects Dashboards wif Query as a Web Service (QaaWS)
• Connected to teh BW (Bex Query) back end and Universe to design teh Design studio application
• Worked extensively on BEX Analyzer in building Queries for BO reporting and user reporting
• Extensively developed Bex queries using Variables, formulas, Hierarchies, Calculated and Restricted Key Figures, also used conditions, Exceptions & Structures.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View
• Developed complex Calculation views using SQL scripts
• Involved in Information Design Tool - Creation of Data Foundation, Universe for HANA reportinG
• Extensively worked on creating BICS and RDMS multiproviders connections in IDT (Information Design Tool)
• Extensively used Toad and Microsoft Server Management Studio to verify if teh data pulled by teh report is correct compared to teh database data and also to verify if teh joins used in designing teh universe are correct.
• Connected to Trizetto FACETS application database to pull teh claims into WEBI reports.

Environment: s: SAP BI BO 4.1 SP5, WebI Reports, SAP Dashboards, Crystal Reports 2013, SQL Server 2008, Oracle 10g and Microsoft Visual Studio - SSIS.

Confidential, Phoenix, AZ

Sr. SAP BO Developer

Responsibilities:

• Developed various sales and marketing reports using Web Intelligence and Crystal reports.
• DevelopedUniverse as per teh client requirements by identifying teh required tables from Data mart using base queries and report mock-ups.
• Created classes, Objects (Dimension, Measures and Details), conditions and @Promptsin Universe.
• Created contexts and Aliases to resolve teh loops problems in universe and used derivedtables to access teh tables from other databases.
• Involved in design reports wif Cascadingprompt.
• Developed Stored Procedures for Crystal Reportsand created sub reports according to business/financial requirements.
• Developed various Sub-Reports in a main report to get Summarized and Detail Data and Cross tab reports in Crystal for different business needs.
• Exported newly developed and existing Crystal Reports to Business Object reports (BO Repository).
• Having daily discussions, walkthroughs, and weekly meetings/conferences wif onsite managers, clients regarding projects (reports) requirements.
• Involved in project planning sessions wif project managers, business analysts, ETL specialists and team members to analyze business requirements.
• Understanding teh user Requirements and prepared Low Level Technical Specification documents for all WebI reports.
• Development of Xcelsius components Grids, Pie charts, Bar Charts and developed teh animation actions for those components.
• Created QaaWS connectivity to WebI for refreshing Xcelsius wif current data.

Environment: s: SAP BOBJ 3.1, WebI reports, Crystal Reports, Xcelsius 2008, SQL Server 2008 and Oracle.

Confidential - (San Jose, CA)

Sr. SAP BO Consultant

Responsibilities:

• Worked on analyzing business requirements and created technical specifications.
• Designed and developed universe in IDT over Business Objects 4.1 Environment.
• Created WEBI reports and SAP Dashboards using Universe (IDT and UDT).
• Developed critical reports using options like drill down, Slice and Dice, master/detail reports in WEBI.
• Generated Variables, Breaks or groups and formulas in Report level.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objectsby using @aggregate aware function to create teh summarized reports.
• Created Classes, Objects, Measures, Conditions, and Prompts in Universe.
• Create reports using Business Objects functionalities like combined Queries and Merged Dimensions.
• Published Webi Reports generated by teh user in BI Launchpad for reusability.
• Created users, user groups and maintained user access rights by using CMC.
• Experience and involved in Migration of Business Objects from BOBJ 3.1 to SAP BI 4.1.
• Migrated Desktop Intelligence reports to Webi reports using report conversion tool directly in BI 4.1.
• Designed, developed and provided in creating Ad-hoc reports, modifying universes, scheduling options in BO4.1to End Users/Power users.
• Created WEBI reports using Bex queries from SAP NetWeaver BW directly via BICS in BO 4.1.
• Created SAP Dashboards using Bex Queries.
• Development of Crystal Reports using Pie charts, Bar Charts, cross tabs and sub reports to achieve teh client requirement.
• Developed various Sub-Reportsin a main report to get Summarized and Detail Data and Cross tab reports in Crystal for different business needs.
• Loaded data into Financial reporting DW from different data sources like Baan ERP (Oracle 10g), Sql server flat files using SSIS.
• Created packages using Mappings, Parameters, and Variables.
• Developed complex mapping to load data from teh Oracle and SQL into DW.
• Synced data from production environment to other environments very frequently.
• Created and managed Master data using concept of Master Data Management and practices.
• Worked wif Stored procedures and user defined functions to perform teh required data movement/transformations.
• Debug and tune SSIS and other ETL processes to ensure accurate and efficient movement of data.
• Designed and developed Data Warehouse, loaded data using SSIS from different data sources (Oracle and SQL Server).
• Worked wif teh end users and Database developers to identify teh critical data needs for reporting.
• Identified teh aggregate reports dat analyze yearly and quarterly sales figures and worked wif teh DBA to create teh relevant aggregate tables.
• Extensively used Toad and Microsoft Server Management Studio to verify if teh data pulled by teh report is correct compared to teh database data and also to verify if teh joins used in designing teh universe are correct.

Environment: s: SAP BI BO 4.1 SP5, WebI Reports, SAP Dashboards, Crystal Reports 2013, SQL Server 2008, Oracle 10g and Microsoft Visual Studio - SSIS.

Confidential, Denver, CO

SAP BOBJ Developer

Responsibilities:

• Worked on creating SAP BW OLAP universes over BEX queries in Business Objects 3.1 Environment.
• Worked wif teh end users and Database developers to identify teh critical data needs for reporting.
• Created different types of WebiReports Chart, Master/Detail, and Cross Tab etc..
• Extensively created and used Alerts, Rankings, Sorts, and drill-down (using custom hierarchies) in Webi Reports
• Created Hyperlinks for Webi Reports
• Created users, user groups and maintained user accessrights by using CMC.
• Developed Crystalreports wif SAP BW Infoproviders.
• Generated variables, groups and formulas in Business Objects.
• Created various dashboards using Xcelsius 2008.
• Worked on User/System report documentation, user and testing developed reports for final deployment.
• Created a backup of WEBI Reports and Universes in BIAR format using Import Wizard.
• Documenting teh Unit TestCases& Run sheets

Environment: s: SAP BOBJ 3.1, SAP BW,WEBI, Crystal Reports, Oracle and Xcelsius 2008

Confidential

Business Objects Associate

Responsibilities:

• Used Multiple Data providers, Complex query Filters and Combined queries in Report Development WEBI.
• CreatedHierarchies and List of Valuesin Universe to implement Drill Up, Drill Down in Webi Reports and controlled teh Drill down at report level by using Scope of analysis.
• Created Objects, Complexjoins, Cardinalities, @Prompts and @aggregate awareFunctions in theUniverse.
• Involved in Sending, Publishing and Scheduling Corporate Documents and Managed Users, Groups and Categories using CMC
• Used Calculated Formulas, Sorting, Rank, DrillDown, CrossTab, Master detail Format in Webireports
• Created DerivedTables, Contexts and Aliases to resolve chasm and fan traps in Universes.
• Created User Conditions and Filters to improve report generation & readability of report and displayed teh summary of data by creating Charts.
• Developed various Sub-Reports in a main report to get Summarized and Detail Data and Cross tab reports in Crystal for different business needs.
• Worked wif Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports.
• Prepared test cases, performed Unit testing, documented teh test results, involved in Code reviews

Environment: s: SAP BOBJ 3.x, WebI Reports and SQL Server 2005.

Confidential

SAP BOBJ Developer

Responsibilities:

• Created aggregate awareness, LOV, Custom Hierarchies, Time Hierarchies and used @Functionsin Universe.
• Resolved Chasm&Fan trapsby using aliases, Contexts and shortcut joins
• Created Daily, Weekly, Quarterly reports for teh management team and field operation managers using WEBI.
• Created Universe Custom Connection Parameters and Designed Cascading list of values and Reusable Lists of Values and Designed Reusing Interactive Objects wif @Variable & @Where.
• Created user Conditions and Filters to improve teh report generation. Also used Alerts to improve teh readability of teh report.
• Applied Breaks, Sections and Custom Sorting in teh Webi reports.
• Added Aggregate awareness to Measure Objects and created SQL & Projection aggregates in teh Universe.
• Developed multiple cross tab reports, master detail, charts and tabular reports in webintelligence.
• Raising and Handling tickets for issues related to teh project.

Environment: s:BusinessObjects XIR2, Universe Designer & WebI and Oracle.