PROFFESSIONAL SUMMARY

• Highly skilled Business IntelligenceDeveloper having around 8 years of Data Warehousing/BI Reporting experience in SAP Business Objects BI4.1/XI3.1/XI R2 and Xcelsius Dashboard possessing superior analytical skills, the ability to meet deadlines and sharing technical expertise
• Involved in all the phases of SDLC i.e., Analysis, Design, Development, Implementation, Testing and support for various data warehousing projects in SAP Business Objects.
• Experienced in working with Sales and Retail, Financial and Insurance Domains.
• Expert in SAP BO BI tools such as Information Design Tool (IDT), Universe Designer Tool (UDT), Business View Manager, BI Launch Pad, SAP Business objects Explorer, Universe Designer, Web Intelligence Reports, Desktop Intelligence Reports, Xcelsius Dashboard, CMC, Infoview, WebI Rich Client, Import Wizard and Report Conversion Tool.
• Extensively worked on Universe Connections, Building the Universe Schema, resolving the join path Problems (Loops and Traps), Contexts, Derived Tables, Creating the hierarchies, LOVs/Cascading LOVs, building complex objects/conditions with the help of @functions.
• Experienced in setting up the various Security Restrictions (Connection Level, Row Level, Object Level, Table Access Level Restrictions) at the Universe Level.
• Highly experienced in designing complex reports in Web Intelligence with Multiple data providers, Sub Queries, Hyper Linking, Alerts, Drill Functionality, Sections, Breaks, Filters, Ranking, Sections, Breaks, Graphs and Extended Calculations etc.
• Expertise in creating complex Dashboards usingXcelsius2008and Exported them to repository to make it available for users through info view.
• Extensively worked on Query As A Web Service (QAAWS) while getting the query data from Business Objects Enterprise toXcelsius2008
• Knowledge on Administration activities like creating and managing repositories, users, user groups, File based Events, Schedule based events, connections, folder security and security privileges.
• Expertise in SQL/PLSQL skills in creating the views, materialized views, stored Procedures, custom functions, Partitions, Triggers, Indexes and granting/revoking the privileges to the users.
• Expertise in SQL Tuning using Explain Plan Technique and Hints.
• Assisted in implementation of Enterprise Data Warehouse and Data Marts, dimensional tables (Star Schema) with identification of measures and hierarchies.
• Good Understanding on Dimensional modeling concepts like Star Schema, Snowflake Schema, Fact Tables, Dimension Tables and Slowly Changing Dimensions(SCDs).

TECHNICAL SKILL SET

Expertise Domains: Sales & Retail, Banking & Finance, Insurance and Healthcare

BI Reporting Tools: SAP BO BI 4.1 (IDT, UDT, BI Launch Pad, Business View Manager, WebI Rich Client, Life Cycle Manager, Upgrade Management Tool), BO XI R2/R3(Designer, Infoview, DeskI, Import wizard, Publishing wizard, Qaaws, Report Conversion Tools, WebI Rich Client, CMC, CCM)

Dashboard Tools: Xcelsius 2008, Tableau (knowledge).

ETL Tools: Informatica8.6/9.1 (Knowledge), FIORANO (knowledge)

Database: Oracle 9i/10g/11g, SAP HANA 1.80.3 SQL Server 2005/2008, Teradata

Database Tools: Toad, Oracle SQL Developer, PLSQL Developer

Data Modeling Tools: Erwin Data Modeler, Oracle SQL Developer Data Modeler and Toad Data Modeler

Operating Systems: Windows NT/Servers, Unix/Linux Servers

Shell Scripting: Unix

PROFESSIONAL EXPERIENCE

Confidential San Jose, CA

Business Objects Developer.

Responsibilities:

• For Universe Order Visibility (UOV) Project we’re using SAP HANA as Database source to create Universe and all the Web Intelligence Reports are created using the Universe(Supply Chain).
• Developed several reports for Customer Orders which are not fulfilled as per the promise date, On Time Shipment, Supply Chain Operations audits Carrier provided shipment information to ensure that the milestone that triggers revenue recognition is received timely and accurately and Carton Tracking Report is to improve visibility levels of tracking the carton location in the Supply Chain.
• Most of the report complexity have moved to Calculation Views to improve the performance of the reports, debugged several CV's to according to the report logic.
• Build several reports which have more than 80 columns in the report, implemented input controls to the reports, to filter the report data as per the users requests.
• Worked on giving access privileges to the new users in CMC .
• Supported the project and resolved many report defects which were logged on Rally, retested, fixed and closed them.
• Worked on documenting the report development, additional functionality requested by the user to reports as part of Agile Methodology.
• Involved in several meetings with Product Owner, Project Manager and the team on several new developments to the existing reports and the defects.
• Worked with the ETL Team on the data Load to SAP HANA Stage environment and the in turn the Procedure were run to Load the HANA Prod .

Environment: SAP HANA 1.80.3, Information Design Tool 4.1 (IDT), UDT, Rally, BI Launch Pad, CMC.

Confidential, Irving, TX.

Business Objects Developer.

Responsibilities:

• Participated in project planning sessions with project managers, Business Users to analyze business requirements and proposed the outline solution.
• Created the several universes in Information Design Tool (IDT) for the EDW data model and resolved the join path problems like loops, Chasm Traps and Fan Traps.
• Implemented various Security restrictions at Business Objects like row level, object level and report level to make the data secure.
• Set up Aggregate Awareness to enhance the performance of SQL in the reports.
• Expertise in using all the functionalities like Sort, Group, Hyperlink, Alert, Parameters, Formulas and Conditional Formatting.
• Used several report optimization techniques such as creating indexes, dynamic partitioning, optimizing SQL with proper outer joins, eliminating existing 1 to 1 table joins.
• Experienced in creating the Universes based on the Stored Procedure
• Deployed the reports to CMC to run the reports in Info View, schedule and download the reports in different formats (PDF, Excel)
• Developed and maintained Graphical Dashboards in Xcelsius 2008 to integrate in Zales Portal
• Extensively worked on Query As A Web Service (WSDL's) while getting the query data from Business Objects Enterprise to Xcelsius
• Created Xcelsius Dashboards for Overall Sales Volume (sales per product, Group, customer segment), Billing and Collections (AR) Metrics (days sales outstanding, average collection period).
• Coordinated with ETL Team on FIORANO Process to create many store reports and scheduled them to different user groups.
• Created Rollback plan, UAT Signoff, Impact Analysis and plan documents for production migration.
• Documented the CMC Security model in DEV, QA and PROD
• Experienced in Prod Support to the existing COR system and created many new complex reports for the EDW data model

Environment: SAP Business Objects BI 4.1, Oracle 11G, SQL Server 2014, SQL, PL/SQL, SQL Developer, FIORANO, TOAD and JIRA

Business Objects Developer.

• Responsible for all phases of the project life cycle starting from business requirement gathering, analysis, design, implementation and testing
• Interacted with Business Users for gathering requirements, preparing the Mapping Documents & Report Documentation.
• Created several Business Objects Universes in IDT and Universe Designer based on the Database Views and Derived Tables.
• Created several custom database functions for Complex Logic implementation and make use of these in the Object definition to reduce the complexity at Universe Level.
• Created linked universes and developed Complex reports with multiple data providers, Master/Detail charts, cross tab charts and calculation contexts to create Sales and Store reports for Daily, Weekly, MTD and YTD Schedules.
• Responsible for Conversion of DeskI Reports into WebI Reports using Report Conversion Tool
• Created highly formatted reports in Crystal Reports featuring parameters, cross - tabs, graphs, sub reports, conditional formatting, complex formulas to implement complex business rules.
• Improved the performance (up to 400%) of many reports by re-writing the Select Expert criteria, using SQL commands and re-formatting
• Worked with Dynamic Cascading prompts to get the most recent and specific data for the parameters selected in Crystal Reports
• Customized existing Crystal Reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting, Visual Basic syntax to create formulas for the reports.
• Worked with Select Expert, Section Expert, Group Expert, Template Expert and Record Sort Expert
• Responsible for Unit Testing at Development Phase and prepared Test Case Scenarios to perform UAT.
• Created several Views, Functions and Procedures and Responsible for Database Code Migrations

Confidential, OH.

Sr. Business Objects Developer

Responsibilities:

• Created Standard reports, Cross-tab, Sub reports, drill down reports, on demand sub reports using Web Intelligence and Crystal Reports.
• Created new Universes and Enhanced the existing Universes with several Views and Derived Tables
• Extensively worked on the Join path Problems, Alias, Contexts, Hierarchies
• Played a major role in development of the complex reports using Derived queries &materialized views.
• Created Hierarchies, Custom LOVs and predefined conditions using Business Objects.
• Implemented the Universe Linking concepts by adding new Universe to the existing Universe
• Responsible for setting various levels of Security Restrictions at Universe Level.
• Created the different types of reports like Master/Detail, Cross Tab and Chart Reports as per the user’s requirements.
• Used Calculations, Variables, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Converted DeskI Reports into WebI Reports using Report Conversion Tool.
• Created several Complex Formatting Reports in Crystal Reports
• Created several Stored Procedure oriented Reports, sub Reports, Chart based Reports in Crystal Reports
• Well versed in using Crystal Reports functionalities for Chart Expert, Section Expert, Group Expert, Group Sort Expert, Record Sort Expert, Highlight Expert and Template Expert.

Environment: Business Objects XI R3.1, Crystal Reports 2008,Oracle 11g, SQL, PL/SQL, TOAD.

Confidential, NY

Business Objects Developer.

Responsibilities:

• Designed, developed and managed several Universes in the Designer for report generation.
• Defined Aliases and Contexts to resolve the join problem in the Universe.
• Created the different types of reports like Master/Detail, Cross Tab and Chart Reports as per the user’s requirements.
• Monitored and solved the issues encountered in Universes and reports
• Created the reports using Business Objects functionality's like Sub Queries, Slice and Dice, Drill Mode, Cross Tab, and Master Detail.
• Created the different types of reports like Master/Detail, Cross Tab and Chart Reports as per the user’s requirements.
• Developed differentXcelsiusscreens with multiple components at different levels of hierarchy-Sub-function/Region/Site.
• Developed the database Objects such as Views, indexes and custom Functions to enhance the report performance.

Confidential, TN.

Business Objects Developer.

Responsibilities:

• Designed, developed and managed Universes in the Designer for report generation.
• Defined Aliases and Contexts to resolve the join path problem in the Universe.
• Created User conditions, Filters to improve report generation& readability of report and displayed the summary of data by creating Charts.
• Used Calculations, Variables, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Optimized the report performance by filtering the reports as needed.
• Customized reports by adding new features such as report alerts, cross-tabs, running total, sub-reports and drill-down fields.
• Created several WebI Reports & DeskI Reports using Universe and Free Hand SQL
• Implemented several mappings in Informatica Power Center involving sources as flat files, relational tables to load the data to relational target tables using real time extract methods.
• Created several mappings with various Transformations Source Qualifier, Expressions, Sequence Generator, Sorter, Router and Aggregator
• Created several workflows and Sessions on mappings load the data from Production to Test Environments for UAT test loads.
• Monitored Remedy system to track Help Desk tickets and resolved any problem tickets.
• Updated daily tasks and controlled the workflow through SharePoint.

Environment: Business Objects XI R2, Informatica 7.1, Oracle 10g, SQL, PL/SQL, SQL Developer.

Confidential, CA.

Business Objects Developer.

Responsibilities:

• Created the reports by using Extended Calculation Contexts.
• Monitored and solved the issues encountered in Universes and reports and tested before moving to production.
• Created several DeskI and WebI reports using Business Objects functionality's like Queries, Slice and Dice, Drill Mode, Cross Tab, and Master Detail.
• Created User conditions, Filters to improve report generation& readability of report and displayed the summary of data by creating Charts.
• Used Calculations, Variables, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created several Universe conditions to automate report prompt generation.
• Optimized the report performance by filtering the reports as needed.
• Monitored Remedy system to track Help Desk tickets and resolved any problem tickets.

Environment: Business Objects XI R2, SQL Server 2005 and HP Quality Center.