SUMMARY

• Over 8 years of total IT work experience as BI Developer using Data Warehousing and Business Intelligence Suite - SAP Business Objects BOBJ 4.1/4.0/ XI 3.0/ 3.1, SAP HANA 1.0 SP9, SAP Business Object and BODS (Data Services 3.1/4.0, SAP Lumira, Live Office, Crystal Reports.
• Proficient in SAP Business Objects Enterprise Tools including CMC, CMS, Information Design Tool ( IDT ), Universe Designer, Webi, BI Launchpad, Dashboard Designer / Xcelcius, Crystal Reports, SAP Lumira, Live Office.
• Planned, Installed, Configured, administered Business Objects 4.1/3.1 on Windows and UNIX platforms.
• Administered and maintained the Business Objects environment, Users and Users Content.
• Created, administered and maintained user/groups security profiles in accordance to the standards, security restrictions and business requirements.
• Identified opportunities for improving efficiency/reliability of the BI platform and associated processes.
• Executed a large scale BO 4.1 migration project -involved in all aspects of the migration including user and object migration, dependencies, maintenance, technical support, security and troubleshooting processes.
• Designed the Enterprises Level Security for the Secured Business Objects environment including defining the Servers, Server Groups, Servers/Services assignment to different groups.
• Managed the User, Objects, Servers and Security using the CMC and CMS.
• Defined the Standards for BO Environment including the standards for Designer, Webi, Deski and CMC.
• Acts as a liaison with the vendor for upgrades and issues related to migrations, support and enhancements.
• Migrated the BO XI 3.1 Environment to BO XI4.0 SP 5.
• Excellent experience in Designing Universes, Star Schemas and Snowflakes to support Adhoc and Complex Canned Reports..
• Acted as a Consultant or Onsite Business Objects Subject Matter Expertise (S.M.E) for different Onsite and Offshore Projects.
• Experience working with ETL Tools - SAP BW, BO Data Services, SLT.
• Experience in Data Migration, Data Transformation and Data loading to Target Databases.
• Experience working with Oracle, SQL Server, MySQL, Teradata, SQL Plus, TOAD, SAP HANA.
• Contributed in all phases of SDLC including working with Administration Team, Infrastructure Teams, Business Analysts, Business Users and Technical Developers to ensure clear understanding of Business Needs.
• Skilled in requirement gathering, gap analysis, design, develop, test business process and implement business applications using databases, client server and ETL/BI development tools.

TECHNICAL SKILLS

SAP BO Tools: Business Objects XI 4.1/4.0/XI 3.1/XI R2/6.5, Crystal Reports XIR2, CMC, CMS, Information Design Tool, Universe Designer, Desktop Intelligence, Web Intelligence, BI Launch Pad /Info view, Dashboard Designer / Xcelcius, BOBJ 4.0 Design Studio., Upgrade Mangement Tool, Promotion Management / LCM, Report Conversion Tool, Widgets, Webi - Rich Client.

ETL Tools: MSBI, SAP BW, Business Objects Data Service 4.0, Pentaho

Databases: SAP HANA 1.0, Oracle 11i/10g, SQL Server 2008, MySQL, MS Access, Teradata.

Other Tools: SQL*PLUS, SQL*LOADER, PL/SQL, TOAD 7/8/9.0, SQL Navigator, Teradata sql assistant, Erwin 4.1/7.1, Microsoft Visio 2003/2007, C, C++, Shell Scripting, Java, HTML, DHTML, XML JavaScript, MS Project 2003, MS VISUAL BASIC, ASP MS Power Point, MS Excel.

Languages: C, C++, Visual Basic, Shell Scripting, SQL, PL/SQL

Operating Systems: Unix - Sun Solaris, Windows 2003 Server, Windows 7/8

Web / App Servers: Apache 1.3.x, Tomcat 5.x/4.1.27, Web Sphere 5.0/5.1.

Package: SAP Business Objects Business Intelligence 3.x SAP Business Objects Business Intelligence 4.0/4.1

Reporting Tool: Business Objects Web Intelligence, SAP Lumira, SAP Predictive Analysis, Universe Designer, BI Launch Pad, Crystal Reports, Dashboards, Live office, MS Excel and BEX.

Modeling Tool: SAP HANA Studio 1.0, SAP BW 7.3/7.4

Process: SDLC, QA

Bug Tracking Tool: HP Quality Center (9.0), Jira, QTP

Editing Tool: MS Office 2011, Notepad++

General Tool: Putty, FileZilla, Rapid SQL, SQL Server 2008 Management Studio

Operating System: Windows 2003 Server, Windows 2008 Server R2, Windows 7, Linux and Solaris 10

PROFESSIONAL EXPERIENCE

Confidential, Irvine CA

SAP BO Developer/Admin

Responsibilities:

• Worked in Business, Functional, Technical Requirements Gathering, Designing, Documenting, Developing, Testing and Deploying the Universe, Database Developments, Reports and Dashboards.
• Strong Experience in Technical and Business Requirements Documentation.
• Designed and Maintained Universes for Standard / Ad-hoc Reporting Requirements.
• Developed Universe’s and Reports with more emphasis on Enterprise User Distribution and Best Practices both on Database and BOBJ Platform in order to minimize the Performance issues
• Worked extensively on Optimizing Report / Query Performance using BOBJ based Improvements (Index Awareness, Aggregate Awareness) and Database based Optimization (Index, Partition, Statistics, Hints)
• Analyzed the requirements, worked on gap analysis and identified existing business content as well as areas for enhancements.
• Developed SAP Universe, Created Classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Developed web intelligence reports for the SAP exported universe related to pay-down curves of home loans mortgage.
• Created the reports by using BO functionalities like filters, sections & breaks, combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and formula.
• Written Complex SQL queries and PL/SQL procedures and cursors to retrieve the required information.
• Extensively worked on ETL, created Informatica workflows and sessions to write the data into the Staging tables.
• Created various simple and complex reports mainly using business objects universes as the data Providers.
• Used QaaWS (Query as a Web Service) and Live Office to feed data into Xcelsius 2008.
• Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius.
• Installed Business Objects, Webi Intelligence, set up business objects repositories, created users, user groups and provided them access to the Universe and Documents.
• Crystal Reports 10/XI reporting environment and to Design the Universes to meet their reporting requirements. Writing SQL queries, PL/SQL Procedures Installation and Configuration Crystal Enterprise.
• Created the Universes using Business Objects Designer from different databases like Oracle and MS SQL Server.
• Deployed Reports on the web by using Crystal Enterprise XI and Crystal Server Pages. Used Publishing wizards and Web Wizard for publishing Reports
• Generated WEBI reports using Business objects Web Intelligence to pop in Java server pages.
• Created reports using Xcelsius 2008 for the business executives. This is used to monitor business through Key Performance Indicators (KPI).
• Followed Best Practices for Database and Business Objects Platform in order to minimize the Performance issues at later stage
• Worked extensively in Optimizing Report/ SQL Query Optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Worked on SAP Business Objects 4.2 Migration Plan.
• Worked with the ETL Team to create new database objects that needs to be added to the Databases and monitor data refresh on a daily basis.
• Worked across teams to fix the outstanding Data Quality Issues and remediate the reports to meet timelines.

Confidential, Phoenix, AZ

SAP BO S.M.E /ADMIN / Developer

Responsibilities:

• Involved in project for Data Analytics team from start to its inception, responsible for implementing BOBJ 4.1 on SAP HANA 1.0.
• Create Visualization reports using SAP BOBJ 4.1 tools like Webi, Dashboards, Crystal Reports and SAP Lumira to help identify the KPI’s and analyze the customer’s performance.
• Created and maintained Universes using IDT on HANA,
• Performed scheduling of Webi reports and do report development, administrated Central Management Console, users, System configuration and maintenance.
• Created highly formatted Web intelligence reports and maintain, enhance performance of the existing reports.
• Created webi and SAP Lumira reports by consuming HANA Calculation views via universe and generated the Documentation form HANA into PDF format.
• Scheduled various reports using prompts, filters and conditions and testing these reports with all possible data for consistency.
• Enhanced the existing Business Objects Universes to support changing Business Requirements and Performance.
• Created a test plan to test the universe, validated queries on universe to retrieve correct results, moved universes to UAT, Training and Production environments.
• Resolved loops, defined contexts and aliases to resolve loops and also tested them to ensure that correct results are retrieved.
• Developed various complex canned reports using Business Objects Universes as the main Data Provider.
• Created user prompts, conditions and filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
• Developed reports with business objects functionalities like slice and dice, drill down capabilities.
• Involved in Information Design Tool - Created Relation connection and OLAP connections, creation of data foundation, Business Layer for Hana reporting.
• Installed, configured BOBJ tools, SAP BODS and SAP HANA studio on client system.
• Responsible for configuration and migrating data from non-SAP data sources into SAP HANA using SAP BODS.
• Responsible for installation and configuration of SAP HANA Client tools. Adding HANA system to studio and creating schemas for migrated tables.
• Performed HANA Modeling by creating Attribute views, Analytical views and Calculation views for multi-dimensional data analysis.
• Created calculated columns, Input Parameters and added filters to aggregate the data in HANA.
• Involve in presentations, demos and POC activities as required for SAP HANA, BOBJ.

Environment: BO BI platform 4.1 / 4.0, SAP HANA 1.0 SP9, Life Cycle Manager, IDT, BI Launchpad, WEBI, Xcelcius2008/Dashboard Design, Business Objects Data Services (Designer, Management Console), DS (Data Quality/Data Integrator), ORACLE10g/11g, SAP BW 7.3/7,4, MSBI

Confidential - Raleigh,NC

SAP BO Developer

Responsibilities:

• Monitored BO scheduled jobs after major implementations and ensured post implementation support.
• Worked on full lifecycle of BOXI/BI platform implementation including migration of reports and data migration from ORACLE 10g to ORACLE 11g.
• Performed manual comparison of reports designed earlier in Web Application Designer and simulated the similar look and feel into the reports of SAP BO 4.0.
• Converted BO XI R3.1 Universes to BI platform 4.0 Universes using Information Design tool.
• Worked on Universe Design from scratch and was part of the Design Development and Implementation of 2 major Universes and their comparative report generation.
• Made drop down structure using quick filters on the filter bar area thereby offering the users an alternative interactive option to prompt.
• Made sure that there are more report filters than query filters in a multi-query report to make the performance improved by running the reports on the resultant data.
• Involved in the UAT and coordinated between offshore and onshore developers to support 24 X 7 for the end users.
• Involved into meetings with the data modelers and data architects as part of requirement analysis and requirement freezing.
• Monitored BO scheduled jobs after major implementations and ensured post implementation support.

Environment: BO BI platform 4.0 / Business Objects XI 3.1(SP3/SP2), SAP Integration Kit (FP 2.1), Life Cycle Manager, Universe Designer, Info view/BI Launchpad, WEBI, Xcelcius2008/Dashboard Design, Business Objects Data Services (Designer, Management Console), DS (Data Quality/Data Integrator), ORACLE10g/11g, SAP BW 7.0

Confidential, CA

SAP BO Developer

Responsibilities:

• Worked with Confidential Analyst Team and Business Intelligence Team in preparing the Functional/Technical design specification.
• Prepared Mock-Up reports for Operations Analyst Team for sign off.
• Worked with Senior Business Objects Administrator in installation and configuration of Business Objects XI 3.1/SP3 and in creation of users, groups, folders and custom access levels as per the required security and work flow approach of Confidential .
• Created universes Stock Order Accounting/Order History/Group Activity History and modified the universe Transfer Acceptance Rate.
• Modified the standard report template of Confidential ’s cover page and included prompts and parameters, report objects.
• Developed canned reports and hyperlinked the summary reports to the detailed reports which shows the detailed Supply Chain stats.
• Assisted Business Intelligence Team in preparing deployment procedures for business objects reports.
• Worked with MS-SharePoint to manage different versions of Reports and Universes.
• Created interactive dashboards using Live office and Xcelcius. Used the single values, data sliders, Pie and Combination charts in the dashboards.
• Created Crystal reports on Bex Queries and made connections to SAP BW for extraction of data.
• Involved in optimization of queries to extract data process faster and Unit Testing the reports as per the Confidential Standards.
• Write planned and ad-hoc reports for Customer Retention project using OBIEE.
• Trained Operations Analyst Team of 8 members in Business Objects XI 3.x and also trained OBIEE developers on the new features of BO XI 3.1.

Environment: Business Objects XI 3.1/3.0, Designer, WEBI, Web Intelligence Rich Client, MS-Share point, DB2, DB2 Connect, IBM-Datastage8.0.1, Windows 2003 Server, OBIEE.

Confidential

SAP BO Developer

Responsibilities:

• SAP BO developer for material handling unit customer and dealer reporting project, including SAP BW/SAP BO 3.x system implementation.
• Gathered functional requirements from the Business Users and Analysts and translated them to technical requirements and SRD (Specification Requirement Documentation) to create Universes.
• Worked with the Power Users, Data modelling team, ETL team and Higher Management to define the requirements. Review the requirements and convert them into design specifications.
• Designed the Universe by defining necessary Joins, Cardinalities and applying Contexts/Aliases to maintain the overall integrity of the Universes by resolving loops and traps.
• Contributed significantly to WEBI report using custom LOV, navigation path (hierarchy in 3.1), and all latest features of SAP BO 3.x.
• Assisted with XCelciusdashboard for SAP BO 3.x for client’s customer and dealer reporting requirements, created directly on Bex queries and universe.
• Implemented reporting solution to jump from SAP BO 3.x web I reports to SAP R/3 invoice.
• Implemented report publication/scheduling (Reports Cache) functionality to reduce initial performance impact for dealer and customer reporting and WEBI reports.
• Contributed to various WEBI reports using calculation contexts, applying almost every available formatting feature, ranking, sorting, breaks, prompts, sub-queries, and data tracking.
• Involved in creating complex formulas/variables, projecting charts, cross tab reports, drill down reports.

Environment: Business Objects XI 3.1/3.0, Designer, WEBI, Web Intelligence Rich Client, MS-SharePoint, DB2, DB2 Connect, Windows 2003 Server, OBIEE.