PROFESSIONAL SUMMARY:

• Over 5 years of experience in Business Intelligence Solution Architecture / Development SAP Business Objects 3.x/4.x with different modules such as Information Design Tool (IDT), Webi BI Launchpad, Desktop Intelligence/Deski, Central Management Console, Lumira, Strong experience in Data Warehousing (dimensional model, 3NF and Star Schema), SQL and strong analytical skills, SAP HANA, SAP SLT/ECC, SAP Data Services (BODS)
• Experience in SDLC Documentations; for instance, Functional Requirement Document, Technical Specification, Unit Test scripts, System Integration Scripts, User Acceptance Scripts, User Manuals and Knowledge Transition checklist.
• Created information views Attribute views, Analytics views and Calculation views in SAP HANA Studio.
• Knowledge of Data provisioning to integrate and replicate data from SAP SLT using SAP ECC, non - SAP BODS/ ELT based replication system.
• 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 - Navigation Path).
• Developed complex universes by defining hierarchies - navigation paths, derived tables, aggregate aware and context.
• Created custom hierarchies (navigation paths) to support drill down reports.
• Detected Joins and checked the cardinalities. Resolved table-joining problems like Chasm trap and Fan trap using context and Alias.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, @Functions, Cross Tab, Master Detail and Formulas etc.
• Experience working with Dashboards to create executive dashboards, integrating Webi reports with Dashboards using OpenDoc API
• Created dashboards with functionality and features such as What-if analysis, Alerts, Drill Down, Filtered Rows and Dynamic visibility.
• 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.

TECHNICAL SKILLS:

ETL Tools: SAP BODS, Informatica

Databases: MS Access, Oracle 11g/10g/9i, SQL Server 2008, SAP HANA 1.x, 2.0

Operating System: Windows 95/98/2000/XP/7, UNIX, SUSE Linux

Application Tools: MS Word, MS Excel, MS PowerPoint, Adobe, Outlook, HP Center, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Business Objects Developer/ HANA Modeler

Responsibilities:

• Worked with the business analyst to understand and document the functional requirements
• Performed modeling exercise to address the functional specifications
• Developed complex universes using Star Schema, Snowflake Schema and 3NF data model.
• Developed reports using the advance Webi functions like, merge query, context measures, ranking, custom complex formula
• Created universes (IDT) on multiple sources and used the Federation Layer for data integration
• Leveraged aggregate aware in the ad-hoc universes to dynamically select appropriate aggregate layer (fact table) based on the dimensions selected by the business users.
• Created Derived tables to leverage custom SQL and to implement YTD, QTD calculation
• Created multiple dashboard with functionality and features such as What-if analysis, Alerts, Drill Down, Filtered Rows and Dynamic visibility.
• Scheduled Business object Reports to users using BI Launch pad.
• Scheduled reports using BILaunchPad and used the report bursting using Publisher.
• Created analytical, calculation and attribute views using SAP HANA Studio
• 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 (via SLT) and non-SAP (via BODS) data using HANA Studio
• Involved in meetings with functional users, to determine the flat file, Excel layouts, data types and naming conventions of the column and table names.
• Prepared mapping documents capturing all the rules from the business.
• Created SAP BW connection to interact with SAP BODS using RFC connection.
• Created Info Object, Info Source, Info Area for SAP BW.
• Created multiple data store configurations in Data services local object library with different databases to create unified data store.
• Using Data services Created Batch and Incremental load Change data capture and wrote initialization scripts which control Workflows Data flows
• Involved in many enterprise Business Intelligence projects in entire SDLC from project initiation to implementation as technical lead.
• Prepared technical design specifications based on functional requirements and analysis documents.
• Modified existing Store Procedures to accommodate the report changes.
• Provided technical solutions and fine-tuned long running queries to improve query performance.
• Assisted/guided end users to efficiently use the universes in building the simple and complex reports.
• Developed the Calculation views using graphical and SQL Script mode with SAP HANA 2.0
• Created universe (using IDT) on HANA views to expose the data in BO 4.1 Webi
• Optimized the SAP HANA view for Adhoc reporting using Webi
• Created dashboards with dynamic data from SAP HANA calculation view using universe (IDT)
• Created driver based dashboards with functionality and features such as What-if analysis, sliders, Drill through, Filtered Rows and Dynamic Visibility.
• Implemented security structure and user groups in CMC
• 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, SAP BI 7.3, SAP BODS 4.1, SAP ECC, Dashboards 4.0, SAP BI 7.3, SQL Server 2008, SAP HANA 2.0

Confidential, Milwaukee, WI

Business Objects Developer/ HANA Modeler

Responsibilities:

• Worked at Miller-Coors as SAP HANA and BO developer
• Worked with the business analyst to understand and document the functional requirements
• 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 through ECC 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
• 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.
• Leveraged aggregate aware in the ad-hoc universes to dynamically 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, Webi Reports, Dashboards 4.0, SAP BI 7.3, SQL Server 2008, SAP HANA 1.0 / 1.6

Confidential, IL

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 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
• Analyzed existing stored procedures to create simple queries to create reports.
• Involved in performance tuning and optimization on Business objects reports.
• Created universe to access non SAP Data.
• Designed and Documented Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Provided 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, Teradata 13.11