SUMMARY:

• 9 years’ experience in development of Business Objects Enterprise products that include UDT/IDT, Web Intelligence, Crystal Reports, Dashboards, Lumira, Design Studio, CMC, BI Launchpad, Desktop Intelligence, Import Wizard, Upgrade Management Tool, Promotion Management, and Report Conversion Tool.
• Experience in BO Administration in deploying, configuring, upgrading and maintaining through Business Objects versions 3.1/ 4.1
• SAP HANA modeling experience creating Attribute views, Analytical views and Calculation views.
• Expertise in Requirement Gathering, GAP Analysis, Development, Implementation, Production Support and Business User training.
• Good knowledge of database schemas like Star Schema, Snowflake Schema used in relational and multi - dimensional modeling.
• Experience in building dashboards with SAP Dashboards, SAP Lumira and Design studio for enabling business users with appropriate visualizations.
• Expertise in Report Bursting using Publications, schedules and profiles.
• Worked on various database platforms like Oracle 11g, SQL Server 2008/2012, DB2 and SAP HANA
• Experience in writing SQL queries, stored procedures, functions, database triggers, exception handlers, Cursors etc.
• Extensively used SAP BW Query Designer and Analyzer for creating, modifying and validating Bex queries. Customized restrictions, calculated key figures and exit variables to be consumed by BOBJ users and reports.
• Trained new users, super users and offshore team in the best practices of report development and platform maintenance to optimize resource consumption on the BI platform.
• Dynamic, result-oriented, self-trained leader with excellent communication, interpersonal and presentation skills

TECHNICAL SKILLS:

Reporting Tools: Information Design Tool, Universe Design Tool, Web Intelligence, SAP Lumira, SAP Dashboards, SAP Design Studio, Crystal Reports, BI Workspaces, Central Management Console, HANA Studio, Power BI

ETL Tools: SAP BW 7.3/7.4, Informatica Power Center 7.1.1, Data Services 4.1, SAP LT

Data Modeling: Erwin & Microsoft Visio

Databases: Oracle 11g/10g/9i, Microsoft SQL Server 2008/2012, DB2, MS Access, Hyperion, SAP HANA

PROFESSIONAL EXPERIENCE:

Confidential, Lake Forest, CA

Sr. Business Objects Developer/ Administrator

Responsibilities:

• Supported all BOBJ requests from Business users, Power users, IT super users/ offshore consultants related to new report development/ administration / production support and training of BI tools.
• Worked as an Offshore Co-ordinator managing resources in India by assigning work items, translating business requests and mentoring the resources through daily conference calls.
• Developed multiple Oakley’s wholesale reports to Luxottica’s top management for North America, Hispanic LATAM, and Asia Pacific regions.
• Developed Sales Reports using multiple data sources to be consumed by Sales Managers and Sales Reps through both SAP Business Objects Mobile as well as email distribution.
• Supported the Retail team with developing a new weekly Diagnostic report and Retail Dashboard for over 280 Oakley Stores across USA, Canada, Europe, Japan, Australia and New Zealand using Report bursting/ Publications that is based on complex golden reports.
• Created and modified Universes based on SQL Server, SAP BW Bex queries, Oracle Hyperion, MS Access, SAP HANA and Excel data sources.
• Worked on FMS on HANA implementation project creating attribute, analytic and calculation views.
• Used Data Provisioning / Import/ Export, created roles and privileges in HANA, loaded flat files on HANA that are used in BOBJ specific requirements.
• Installed a new BI 4.2 SP4 on a clustered environment and performed sizing activity for an Oakley’s parent company and Upgraded their BOXI 3.1 system to 4.2 with incremental approach using UMT.
• Installed & developed dashboards using Design Studio 1.4 using on select events, data binding, CSS formatting, & visibility components of the tool.
• Installed and Configured Lumira Server/ Desktop 1.29 and developed Lumira visualizations and stories for Manufacturing team for analyzing Open orders/ Backorders.
• Prototyped Power BI Desktop by preparing dashboards connecting to SQL Server, SAP HANA and SAP BW.
• Upgraded Business Intelligence 4.0 to 4.1 version, Installed, Configured and setup Business Intelligence Servers, setup security groups, and migrated content between environments.
• Utilized Remedy ticketing system’s SQL Server database on top of BOBJ to create automated Work order and Incident management reports to be consumed by IT leaders in various departments.
• Created and modified users & user groups, created custom access levels and assigned security restrictions to the user groups based on functional area and user profile.
• Promoted BI Workspaces to be consumed as portal to setup all related reports in a single landing page for the ease of use for business users.
• Aided in production support for myriad issues such as CORBA error, getdocumentAPI error, IFRS/OFRS issues, security issues, job failures, data validation issues etc.
• Read error logs, collected trace files and performed root cause analysis to help resolve issues.
• Utilized Promotion Management to migrate BI content between sandbox, QA and PRD regions.
• Extensive data validation using BW Bex analyzer, customize exit variables for BOBJ specific queries, modify rows and columns from free characteristics in BW Query designer.

Environment: BO 4.1, Web Intelligence, SAP Dashboards, SAP Lumira 1.29, SAP BW 7.4, Query Designer, Analyzer, SQL Server 2014, MS Access, Oracle Hyperion, Design Studio 1.4, SAP HANA

Sr. Business Objects Developer

Responsibilities:

• Facilitated the report planning by collaborating with Business areas to articulate and prioritize needs, benefits and objectives, plan the work, ensure the scope is sufficient and aligns with organizational objectives.
• Reviewed contractual Service Level Agreements and performed Gap Analysis on metrics to ensure compliance relating to assuring the accuracy of each report impacting financial credit.
• Designed and managed Universes using CRM, Policy and Claims modules as source.
• Facilitated the building of universes using Derived tables, Index Awareness, Aggregate Awareness, custom LOVs etc.
• Created Attribute, Analytical, Calculation views, calculated attributes, measures, packages, procedures and sequences using HANA studio.
• Created Webi Summarized reports for length of claims processing, Claims count, Litigation costs, Provider costs etc. on top of IDT universes on HANA.
• Enabled Webi Detailed reports with custom hierarchies for drill-up, drill-down and drill-through analysis and linked both the reports using hyperlink.
• Developed Crystal reports to capture the Loss-To-Date in paid, recovery and reserves and Loss Ratio across all LOBs using running totals, parameters, calculations, filters and alerts.
• Optimized SQL queries and designed universes that increased the query run-time significantly.
• Managed Securities, Users and User Groups at CMC level.
• Participated in Analysis, Design, Implementation and Administration of security models with role based security, row level data security in Business Objects Universes and Central Management Console (CMC).
• Scheduled and Published tailored Webi reports to targeted recipients based on business requirements using CMC and Launch pad(Report bursting).
• Created and Customized Dashboards for higher level analysis on to include Average cost per claims, claim turnaround, customer satisfaction, and claims ratio.
• Used Live Office to pull data from webi reports from Business Objects enterprise into Dashboard Designer and building Dashboards on top of Live Data.
• Used BI Services to connect to WebI reports from Dashboards using the QaaWS connector that enabled retrieving full report block and drilling down.
• Built and published KPI based performance manager metrics and SSL based mobile reports to satisfy executive reporting requirements.
• Developed project plan and test cases for Migration of Business Objects from BO XI R3.1 to BI 4.1 using upgrade management tool
• Re-evaluated hardware sizing, setup new servers and configured application server, job servers, processing servers and repositories, and performed automatic system backups in a clustered production environment.
• Created Derived tables, Developed stored procedures, Packages and Triggers using PL/SQL.
• Trained End users on BO reports.

Environment: BO BI 4.1 / XI 3.1, SAP HANA 1.0, Web Intelligence, Crystal Reports, Launch Pad / Info view, Advance analysis for Office, Designer, CMC, IDT,L CM, Dashboard Designer / Xcelsius, Live Office, BI Services, Oracle 11g.

Business Intelligence Developer

Responsibilities:

• Established methods to benchmark business information analysis and workflow processes.
• Designed Universe from Data warehouse for creating reports with inner/outer or equi joins with classes, objects, and measures using designer functions like @Aggregate Aware(), @Prompt.
• Resolved loops and chasm traps in the universe through creating aliases and multiple contexts.
• Modified universe to support reports to provide what-if, slicing and dicing, and drill capabilities.
• Modeled metadata dimensionally to satisfy Hierarchical requirements and enabled drill down and drill up in both Full client and Web Intelligence adhoc reporting.
• Generated reports that audit the financial deals relating to the trade of Energy (Electric, Natural Gas, etc.) in regulatory compliance of the North American Reliability Electric Corporation (NERC) standards.
• Created Xcelsius Dashboards using concepts like Dynamic visibility and On/Off Toggle button to displayFirst-time invoice match rate, discount captured, percent of spend under PO metrics at same positionutilizing Dashboard space more efficiently.
• Created Crystal reports using crystal reports formulas, grouping, parameters, selection criteria to handle the requests from stored procedures, views and command objects.
• Built Crystal detail reports connected to BI services pointed at WebI blocks containing BEx query details. Reports launched by and received prompts from dashboards.
• Created user conditions and filters to improve report generation & readability of the reports and displayed the summary of data by creating Charts.
• Scheduled and Published reports based on Events.
• Moved Webi reports in pdf format to distinct file locations and FTP locations.
• Provided documentation on building Dashboards using BI Services, QAAWS & Live Office.
• Collaborated with technical teams and End users in resolving critical BO issues and delivering solutions in timely manner.
• Created repositories, users, and user groups and prioritized security levels for users and user groups. Implemented ROW Level security in the Universe to protect client information from other client Agents.
• Created views and stored procedures using SQL Server 2008 and used performance optimization techniques while writing code.
• Documented BO work including CMC security, Webi guidelines, Crystal reports, Xcelsius and Universe
• Developed test plans and executed test cases to ensure all the Webi and Dashboard reports were working in good shape with regressive testing.

Environment: BI 4.0, SAP HANA, Web Intelligence, Dashboards, Info view, Live Office, Teradata 12, QAAWS, Oracle 11g, SQL Server 2008

Analyst

Responsibilities:

• Involved in Relational modeling with data analysis and normalization including construction of logical & physical data models, forward & reverse engineering and Data Warehouse/Data Mart dimensional data modeling with using Star Schema..
• Designed the ETL processes using Informatica to load data from DB2 UDB, SQL Server, Flat Files and Excel files to staging database and from staging to the target ERP Data Warehouse.
• Performed data cleansing and data manipulations using various Informatica Transformations.
• Setting up batches/sessions to schedule the loads at required frequency using Informatica Server manager (Workflow manager/ Workflow monitor)
• Created various transformations using Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Sequence Generator etc
• Installed and Configured Business objects products - Xcelsius, QAAWS, Client tools and SAP Integration kit on Servers & client machines.
• Set up security models, user groups and security access levels in CMC as per Requirement and maintained CMC administration.
• Developed a complex universe universes on relational databases and finally merged multiple universes into a single universe according to the user requirement.
• Created reports using multiple data provider's @functions and inner query concepts to generate thin client reports.
• Designed universes on top of SAP BW - Bex Queries using SAP Authentications.
• Modeled metadata dimensionally to satisfy Hierarchical requirements and enabled drill down and drill up in both Full client and Web Intelligence adhoc reporting.
• Created reports in Crystal Reports using running totals, sub totals, and embedded linked and unlinked sub-reports to separate and organize information.
• Scheduled reports on daily based events using SMTP for email notification and unmanaged disk for storing large sized reports.
• Used complex Calculations, Variables, Break points, and Sorted inputs, Drill downs as well as Slice and Dice and Alerts for creating Business Objects reports.
• Created different Categories in the repository and published full client reports to their respective categories.
• Migrated universes and reports to PROD and DEV environments from BO 6x to BOXIR2 version to their respective folders using Repository Migration Wizard.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with reporting system and also to successfully implement business logic.
• Documented BO work including CMC security, Webi guidelines, Crystal reports, Xcelsius and Universe
• Developed test plans and executed test cases to ensure all the Webi and Dashboard reports were working in good shape with regressive testing.

Environment: Informatica 7.1, Erwin, Business Objects XI R2, BOXI 3.1 Designer, Supervisor, CMC, Web I, BCA Scheduler, Crystal Reports 9.0, SQL Server 2005, Oracle 9i, SAP BW 7.0, ECC6.0, Seibel ERP, PL/SQL, Win NT