SUMMARY:

• Over 13 years of IT experience in the Data Analysis, Design, Development, Implementation and Testing of Database/Data Warehousing/Client Server applications using Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Led customer initiatives for requirement gathering and blueprinting of various business matrixes and KPI’s
• Over thirteen years of strong OLAP Business Intelligence experience using Business Objects 4.1 /XI 3.x/R 2/6.5/6.0/5.1, Desktop Intelligence, BO 4.1 Dashboard Designer /Xcelsius 2008 SP4, CMC, BO 4.1 Information Design Tool (IDT), Universe Designer, BO Developer Suite, Web Intelligence, BO MOBILE, SAP BW 7.3 Cubes, SAP Business Planning and Consolidation (BPC). BEx Query Designer, SAP - BO Data Federator 3.0 SP2, Xcelsius 2008 SP3, SAP Business Objects Explorer, Migration project from BO XI 3.1 to BO 4.1. Fully hands on experience of BO 4.1 suite of products. Implemented enterprise wide SAP BI 4.1 Mobile strategy, SAP HANA SP5, SAP HANA Modelling Studio, SAP Lumira, SAP Predictive Analysis, SAP Infinite Insight, SAP BO Design Studio 1.0, Tableau
• Eleven plus years of Data warehousing Experience in working with Data extraction, transformation and loading using Informatica Power Center and Power Mart. Expertise in Extraction, Transformation and Loading (ETL) processes using Informatica Power Center 7.1/6.1, SAP BW 7.01, 7.3.
• Throughout these years have implemented Kimball methodology driven star schema data warehousing projects
• Eleven plus years of Solid database experience in Oracle 11g/10g/9i/8i, MS SQL Server 2K/2005/2008 (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, TOAD, Rapid SQL.
• Model and develop HANA Attribute, Analytic & Calculation Views using the HANA Modelling Studio. Migrate HANA developer code content across DEV-QA-PROD HANA environments. Importing SAP BW objects (DSO, Cubes, and Analysis Authorizations) into the HANA modeling environment and leverage the same into HANA views for Business Objects consumption (Explorer for web/ iPad, Webi, Crystal, Dashboard Designer etc). Created custom hierarchies using the HANA modeling studio for business consumption
• Implemented HANA as a datamart solution for analytical reporting involving non-SAP data.
• Implement security model involving BW analysis authorization objects & non-BW related data sources, HANA user roles and Business Objects access privileges. Implement & develop solutions for SAP BO Explorer / BI applications for iPad/iPhone consumptions using the SAP BO Mobile platform.
• Developed and implemented super analytical dashboards using SAP BO Design Studio 1.0 on HANA for both desktop & the iPad leveraging BI 4.0 & SAP BO Mobile platforms.
• Performance Tuning: Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Responsibilities:

• SAP HANA/BOBJ Solutions Architect for developing and deploying enterprise wide reporting strategy.
• Lead the initiative to model and develop HANA Attribute, Analytic & Calculation Views using the HANA Modelling Studio for NCL’s Equinox reporting project.
• Understand the CASINO & Reservation systems related data model & build HANA Information Models to consume data for the KPI for business needs.
• Recommend the developers team with best practices strategy around HANA Information Model development standards.
• SAP BOBJ 4.1 Solutions Architect for developing and deploying enterprise wide SAP BO Mobile strategy using tools like Explorer, Design Studio, Lumira.

Environment: SAP BI 4.1 SP3 Suite of Products, Dashboard Designer 4.1, Oracle 9i/10g+, SAP HANA SPS7, SAP HANA Modeling Studio

Confidential, Germantown, MD

Responsibilities:

• SAP BOBJ/BW Solutions Architect for developing and deploying enterprise wide MDM enabled Datawarehouse & SAP BO Mobile strategy.
• Architected using BOBJ 4.1 “BI as Service (BIaS)” strategy around SAP and non-SAP data sources.
• Lead the platform upgraded for SAP BI from 3.1 SP2 to 4.1 SP1
• Developed Universe based Webntelligence reporting solution for Sales Force.com as data source.
• Integration of Tableau as a Dashboarding solution platform with SAP BI WebIntelligence as a reporting platform.
• Lead the requirements gathering, analysis of data preparation & implementation for the Predictive Analysis model for Customer Churn Predictive Analysis project.
• Lead the proof of concept & use case evaluation for HANA as an In-Memory solution for Confidential .
• Worked as developer for using Informatica Cloud for MDM reconciliation project for synchronizing data between existing PeopleSoft CRM system with SalesForce.com ( To be)
• Developed a sustainable BI platform to support reporting solutions involving the SAP BOBJ/BW suite of products.
• Recommend & implement best practices strategy around data governance, reporting & dashboarding solutions.

Environment: SAP BI 4.1 Suite of Products, Business Objects XI 3.1 suite of products, SAP BW 7.01/ 7.3, BEX Query Designer, Dashboard Designer 4.1, Oracle 9i/10g+, SAP HANA SP5, SAP HANA Modeling Studio, SAP BO Design Studio 1.0

Confidential

Responsibilities:

• SAP BOBJ/BW Solutions Architect for developing and deploying enterprise wide SAP BI Reporting, Dashboarding & Mobile strategy. The underlying data source for this dashboard being SAP HANA SP5 release 50 or higher
• Lead blueprinting phase for requirements gathering on KPI’s for the proposed C-Level Dashboard as below:
• 4 Business Units (LOBs)
• Manufacturing
• SHE
• HR
• Finance
• KPIs for Dashboarding
• 16 for Manufacturing
• 10 for SHE
• 24 for HR
• 13 for Finance
• Enterprise Data Model for the given Scope
• 3 information models per LOB with analytic views
• Semantic Layer Design for the given Scope
• BOBJ Dashboarding - 3 Dashboards in each LOB in Scope to cover all the above KPIs
• Data Source will be ECC or Excel

Environment: SAP BI 4.1 Suite of Products, SAP BW 7.3, BEX Query Designer, Dashboard Designer 4.1, Oracle 9i/10g+, SAP HANA SP5 release 50, SAP HANA Modeling Studio, SAP BO Design Studio 1.0

Confidential

Responsibilities:

• SAP BOBJ/BW Solutions Architect for developing and deploying enterprise wide SAP BO Mobile strategy.
• Architect the BOBJ 4.0 Explorer strategy around SAP (COPA, Procurement, and HR) and non-SAP data sources.
• Develop a sustainable BI platform to support reporting solutions involving the SAP BOBJ/BW suite of products.
• Recommend & implement best practices strategy around data governance, reporting & dashboarding solutions.

Environment: SAP BI 4.0 Suite of Products, Business Objects XI 3.1 suite of products, SAP BW 7.01/ 7.3, BEX Query Designer, Xcelsius 2008, BPC MS 7.0, MS SQL Server 2005+, Oracle 9i/10g+, SAP HANA SP5 release 50, SAP HANA Modeling Studio, SAP BO Design Studio 1.0

Confidential, Irvine, CA

Responsibilities:

• Architecting & leading proof of concept projects, thus evaluating various products that are part of an organization wide BI strategy. Evaluated products like Data Federator, BO Metadata Manager, BO Explorer and Microsoft Performance Point using sample business cases from productionizing perspective
• Development and maintenance of new reporting data marts and SAP BW-BO reporting solutions for the same.
• Research on newer technologies in the BI space to enhance the BI capabilities at Confidential .
• Developing BEx queries from the SAP BW Cubes.
• Building BO OLAP universes on the BW queries for reporting thru Web Intelligence.
• Building reporting solutions to read data directly from SAP systems using Crystal Reports then publishing the data off those crystal reports using Xcelsius Dashboards using Live Office.

Environment: BI 4.0 Suite of Products, Business Objects XI 3.1 SP 2.3, SAP BW 7.0, BEX Query Designer, Xcelsius 2008, BPC MS 7.0, MS SQL Server 2005, Oracle 9i/10g, Data Federator 3.0, BO Metadata Manager 3.0

Confidential

Responsibilities:

• Analysing data and gathering business requirements.
• Developing BEx queries from the SAP BW Cubes.
• Building BO universes on the BW queries for reporting thru Web Intelligence.
• Lead a team of 4 onsite SAP consultants at this customer site.
• Designing and developing the prototype for dashboard model.

Environment: Business Objects XI 3.1, Xcelsius 2008, BPC MS 7.0, MS SQL Server 2005, SAP BW 7.0, BEx Query Designer.

Confidential, CA

Responsibilities:

• Installation and configuration of the clustered environment for BOE 3.1.
• Configuration of Business Objects single sign on logon with SAP integration kit.
• Created Bex queries from existing BW cubes for customized reporting. The queries were designed to have BW features like hierarchies, variables.
• Successfully implemented a POC for creating BEX queries off a BW cube and building reports using a BO universe based on that BW query.
• Demonstrated creation of analytical reports from the MS Analysis Services 2005 cubes using WebIntelligence using universes.

Environment: Business Objects XI 3.1, MS SQL Server 2005, BEx Query Designer, SAP BW 7.0

Confidential

Responsibilities:

• Chief architect of the BOE security design.
• Design and development of complex universes and corresponding WebI reports.
• Migration of WebI reports/Universes from XI R2 to XI 3.0 environments.
• Design, develop and deploy 6 Xcelsius dashboards.

Environment: Business Objects XI R2, WebI XI R2, Designer, MS SQL Server 2005

Confidential

Responsibilities:

• Lead the project as the architect in designing an executive dashboard using the technologies such as MOBI V3.0, WebIntelligence XI R2/ 3.0 & MS Analysis Services Cubes using SAP BPC application.
• Configuration of the AD authentication login setup for BOE and from handheld devices.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment.
• Migration of WebI reports/Universes from XI R2 to XI 3.0 environments.

Environment: Business Objects XI R2/XI 3.1, WebI XI R2/XI 3.1, Designer, MS Analysis Services 2000/2005

Confidential

Responsibilities:

• Lead the project as the lead architect in designing the enterprise dashboard using the technologies such as Performance Manager, WebIntelligence XI R2/ 3.0 & Xcelsius 2008.
• Analysis of the existing legacy system reports and designing them using the Business Objects technology using WebIntelligence by building Universes and Dashboard Analytics as needed.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment.
• Migration of WebI reports/Universes from XI R2 to XI 3.0 environments.
• Built powerful & complex WebI report that used the functionalities like Ranking/ Query as Drill/ Aggregate Awareness.

Environment: Business Objects XI R2/XI 3.0, WebI XI R2/XI 3.0, Designer, Xcelsius 2008, Oracle 10g, PL/SQL, Windows XP Servers.

Confidential, Irvine, CA

Responsibilities:

• Contributed as a Senior Analyst in the effort to re-design a huge bulk of existing Business Objects 5.1 full client reports into XI R2 WebIntelligence reports.
• Created multiple universes in order to cater the re-design requirements. Many new features such as Break, Merging Data providers, Ranking etc that were not present in prior version of WebI were now made available in WebI XI R2.
• The newly developed WebI reports were tested against the data of the old reports for the sake of data validation which involved various test check points.
• Lead the integration testing of the newly developed reports and successfully took it to completion.
• Designed & developed an enterprise dashboard for Toshiba America Electronic Components using Performance Manager and Xcelsius 4.5.

Environment: Business Objects XI R2, WebI XI R2, Designer, Xcelsius 4.5, Oracle 9i, PL/SQL, Windows 2K

Confidential, Los Angeles, CA

Responsibilities:

• Design and development of the data model for the enterprise reporting dashboard for the Cedars Sinai Quality Council.
• Created Universes and analytical reports using WebIntelligence capable of Drill Up/Down helping the quality council executives measure the various health care related parameters for the hospital operations.
• Setup the access security for various user groups on the board to be able to see only the information that is useful to them.
• Implemented Enterprise Dashboard level user access security for various users/groups.

Environment: Business Objects XI R2, WebI XI R2, Oracle 9i, PL/SQL, Windows 2K

Confidential

Responsibilities:

• Contributed as a Senior Analyst in the effort to re-design and customize data models for Data warehouse supporting data from multiple sources on real time.
• Analyzed current reports based on underlying SQL and documented them.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment.
• Created multiple universes and resolved various design issue that came up during their design.
• The universes were frequently tested for validity and correctness of inferred SQL.
• Created reports on development data to test the functionality of universes with a group of power users.
• Scheduled reports to business users and owners using Broadcast Agent.
• Exported the Business Objects reports to WebI to be viewed by all users on the Intranet.
• Created reports using the business object functionality like queries, Slice and Dice, Drill down, functions and formulae.
• Built Powerful Queries by creating and applying complex conditions and sorts, User Objects, LOV’s, Combined Queries, Free Hand SQL and Semantically dynamic calculations using context method, organized data in the reports by using Filters, Sorting, and Ranking and highlighted data with Alerters.
• As a design improvement suggestion used ORACLE Hints to optimize performance of various ETL mappings in Informatica. This drastically reduced the ETL load time.

Environment: Business Objects XI/6.5.2, WebI 6.5.2/XI R2, Informatica PowerCenter 7.1, Designer, ZABO, Oracle 9i, PL/SQL, Windows 2K

Confidential, Schaumburg, IL

Responsibilities:

• Requirements Gathering and Business analysis
• Familiarized the business, its strategy and implementation.
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Designed and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Developed functional requirements and data specifications for the reports and corresponding data providers (Universe queries and Flat files).
• Analyzed current reports based on underlying SQL and documented them.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment.
• Measure, Dimension and Detail objects were created to meet the needs of end user requirements so that every possible query could be achieved, created various classes and objects for universe.
• Universes were frequently tested for validity and correctness of inferred SQL.
• Created reports on development data to test the functionality of universes with a group of power users.
• Scheduled reports to business users and owners using Broadcast Agent.
• Exported the Business Objects reports to WebI to be viewed by all users on the Intranet.
• Created reports using the business object functionality like queries, Slice and Dice, Drill down, functions and formulae.
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports in WebIntelligence XI R2 and Desktop Intelligence XI R2.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Built Powerful Queries by creating and applying complex conditions and sorts, User Objects, LOV’s, Combined Queries, Free Hand SQL and Semantically dynamic calculations using context method, organized data in the reports by using Filters, Sorting, and Ranking and highlighted data with Alerters.
• Used various Analytics to analyze data at a higher level of detail.
• Successfully upgraded from Business Objects 6.1 to Business Objects 6.5 and applied Hot Fix Patches.

Environment: Business Objects XI/6.5.1, Desktop Intelligence XI R2, WebI 6.5.2/XI R2, Erwin 4.0, Informatica PowerCenter 7.1, Designer, ZABO, Oracle 9i, PL/SQL, Windows 2K

Confidential

Responsibilities:

• Designed the cash flow universe by joining several dimensions like Instruments, Locs, Currencies, clients, Date-Dimensions and credit mortgages.
• Exported the universe in to the repository and maintained the domains regularly.
• Developed objects in the universe using some calculations on existing columns in database tables.
• Used drill analysis in Business Objects 6.1b which will allow the user to view data at a more detail level, than current level.
• Generated drill down reports using Business Objects at zone level, product level, borrower level.
• Created and use the variables on existing objects to customize the Business Objects reports.
• Extensively worked with alerts, filters and conditions in Business Objects.
• Created Master Detail, Cross Tab reports to view the data in analyzed way.
• Created Templates for standardizing the structure of our Corporate Documents.
• Created templates to generate different styles of reports, which are not, belong to Business Objects standard documents.
• Created calculated data items, filters and prompts in universes to maintain the consistency in the reports created by other developers.
• Involved in QA phase to test the classes, objects and Connections in Business objects.
• Converted the business rules into technical specifications for ETL process populating the Fact and Dim table of data warehouse
• Created source to target mappings, mapplets according to the business requirements using Informatica Designer.
• Created sessions, database connections and batches using Informatica server manager
• Collaborated closely with client managers, architects, DBAs and business users.
• Created Business Objects Repository while building Business Objects solution.
• Exported the universes to the Repository making resources available to the users.
• Monitored Business Objects Broadcast Agent and Web Intelligence servers. Scheduling of reports on a daily and weekly basis using Broadcast Agent Server.
• Coding, testing and deploying of Business Objects Universe & Reports.
• Creation of user and technical specification documents.

Environment: Business Objects 5.1, Web Intelligence, Designer, Supervisor, Broadcast Agent 5.1, Oracle 8i, PL/SQL, Windows 2K.

Confidential

Responsibilities:

• Coding, testing and deploying of procedures and functions on SQL Server databases.
• Creation of user and technical specification documents.

Environment: SQL Server 2000, Win NT

Confidential

Research Analyst

Responsibilities:

• Algorithm creation for the process flow.
• Detailed analysis of the user requirements and creation of code for execution of the PLC.

Environment: DOS, UNIX, C