PROFESSIONAL SUMMARY:

• 7 years of experience in Information Technology with strong emphasis in business intelligence, database modeling, data analysis and business users support.
• Involved in several full project life cycles i.e. requirements gathering, design, development, test, cut-over and support as SAP Business Objects developer and one full project life cycle as SAP HANA Modeler.
• Hands on development experience with SAP Business Objects 3.x/4.0/4.1 Universes, Webi reports, BO Explorer, Lumira, Crystal, Xcelsius dashboard builder, Lumira, CMC user administration, OLAP Analyis and SAP BW and Business Objects integration via BICS and OLAP universe
• Hands on modeling experience with SAP HANA Modeling using HANA Studio 1.0 SP6 - created Attribute View, Analytic View, Calculation View, Variables, Input Parameter and Decision trees. Created schema and row store / column store tables.
• Comprehensive understanding of SAP HANA data provisioning using SLT Replication for SAP as source system, SAP Data Services for non-SAP data source and DXC
• Worked as a Universe designer developing and modifying universes using UDT/IDT and advance experience in SQL and Data Warehousing concepts Enterprise Data Warehousing, Data Marts and Hierarchies
• Experience working with Xcelsius 2008/ Dashboards 4.0 to create executive dashboards, integrating webi reports with Dashboards using OpenDoc API.
• Developed complex universes by defining hierarchies - navigation paths, cascading prompts, derived tables, aggregate aware and context.
• Detected Joins and checked the cardinalities. Resolved table joining problems like Chasm trap and Fan trap using context and Alias.
• Created custom hierarchies navigation paths to support drill down reports.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Functions, Cross Tab, Master Detail and Formulae etc.
• Hands on experience in query performance optimization and working with the data modelers to define the requirements for different aggregate layer for optimal query performance for executive dashboards, canned reports and ad-hoc analysis
• Created analytical, operational, relational, What-if Model Dashboards in Xcelsius using QAAWS, Live office, dashboard queries to enable executive's view of the business performance.
• Used TOAD to run the SQL against the database to conduct data analysis, data validation and query performance.
• Customized the dashboards and KPIs for better manageability of overall performance.
• Provided production support for the existing Business Objects contents and followed defect management process for defect resolution and change management process for any enhancements.
• Created training document and conducted in-person and virtaul business users training sessions.

TECHNICAL SKILL SET:

PROFESSIONAL EXPERIENCE:

Confidential

Title: Business Objects Developer

• Work with the Arcadia Health Care Solution to understand the functional requirements document for Yakima Valley Farm Workers Clinic Business Objects implementation efforts
• Drafted a proposal using buttom-up estimation to migrate approx. 100 Cognos and SRSS reports over to the SAP Business Objects, including custom Data Warehouse development
• Created capacity planning and provided detailed reporting activities for the project plan
• Work on SAP Business Objects Webi reports, Universes and Dashboards

Confidential

Title: Business Objects Developer/ HANA Modler

Responsibilities:

• Worked with the business analyst to understand and document the functional requirements
• Worked at Ralph Lauren as SAP HANA and BO developer
• Performed modeling exercise to address the functional specifications
• Created several calculation view and analytical view to support the functional requirements
• Worked with the SAP Basis team to setup the SLT replication for SAP source and SAP Data Services team to load the non-SAP data in SAP HANA
• Design the solution to integrate the SAP and non-SAP data using HANA Studio
• Developed the calculation views using graphical and SQL Script mode. Developed analytical views to integrate different tables.
• Worked on the Life Cycle Management to transport delivery unit
• Created universe using IDT on HANA views to expose the data in BO 4.0/4.1 Webi
• Optimized the SAP HANA view for Adhoc reporting using Webi and BO Explorer
• Created dashboards with dynamic data from SAP HANA
• Created dashboards with functionality and features such as What-if analysis, Alerts, Drill Down, Filtered Rows and Dynamic visibility.
• Laveraged aggregate aware in the ad-hoc universes to dymanically select appropriate aggregate layer fact table based on the dimensions selected by the business users.
• Implemented functionalities like Drill filters, Breaks, Sections, Hyperlink, variable, prompt etc...
• Created, maintained, and updated several universes using Universe Design tool and Information Design Tool.
• Scheduled Business object Reports to users using BI Launch pad.
• Created Webi reports Publications in CMC based on User Profile to enable report bursting.
• Involved in performance tuning and optimization on Business objects reports and Universes.

Environment: Business Objects 4.0/4.1 BI Launch Pad, Interactive analysis , Webi Reports, Dashboards 4.0, SAP BI 7.3, SQL Server 2008 , Bex Query designer , Advanced olap analysis for Web.

Confidential

Title: Business Objects Developer

Responsibilities:

• Worked on Business objects reports, Webi reports, Universes, dashboards
• Worked on Transparency Project.
• Interacted with business users and business analysts for understanding requirements to build universes/ reports for users.
• Created SAP BEx queries in SAP BW and integrate them with Webi using BICS.
• Created WEBI reports , Advanced OLAP analysis for Web reports
• Involved in Project planning , maintaining different phases of the projects
• Extensively worked on end-user requirements, business data requirements, analysis and study and efficient in testing SQL queries and stored procedures.
• Developed Canned, Standard Interactive Analysis reports, Webi reports.
• Created and modified dashboards with dynamic data
• Created, maintained, and updated several universes using Universe Design tool.
• Analyzed existing stored procedures to create simple queries to create crystal reports.
• Involved in performance tuning and optimization on Business objects reports.
• Created universe to access non SAP Data.
• Scheduled Business object Reports to users using BI Launch pad
• Designed and Documented Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Provided training to end users about basic functionalities of using reports, such as 'opening reports, using prompts, saving reports in different formats, scheduling reports, etc...'

Environment: Business Objects 3.x/4.0, Webi reports, Xcelsius 2008, SAP BI 7.3, SQL Server 2008 , SAP BI , Bex query designer.

Confidential

Role: SAP BW/ SAP Business Objects Developer

Responsibilities:

• Involved in full implementation of SAP BW and BOBJ Supply chain management and Financial Management reporting
• Involved in gathering business requirements, functional requirements data specifications.
• Involved in SAP BW implementation
• Involved in Bex query development
• Designed and developed complex Crystal reports involving Sub-reports, Cascading prompts, Running Totals, Cross tabs and Charts with extensive formulas..
• Using several functionalities of crystal reports such as Record Sort Expert, Group Expert to sort and group the record data.
• Designed complex Web Intelligence and Desktop Intelligence Reports.
• Designed Universes for Ad-hoc reporting.
• Created and tested classes and objects to organize the universe.
• Created different reports containing charts showing revenue and operating income by different divisions.
• Implemented security features of Business Objects like row level, object level and report level to make the data secure.
• Created Objects using different Business Objects functionalities like prompt, aggregate aware in the process of designing the universes.
• Linked the universes to share the common objects between them.
• Created Alerts in various reports according to user requirements.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end user.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Worked closely with the end users to develop the transformation logic to be used in Reports.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and predefined conditions to use in Business Objects.
• Extensively used multiple data providers for building reports.

Environment: SAP BW 2004s , Bex query designer ,Crystal Reports XI R2, Business Objects XI R3.1, Xcelsius 4.5, Info View, SQL Server 2005, Windows XP.