EXPERTISE SUMMARY:

• Over 16 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, PL - SQL, T-SQL.
• Over 16 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, Web Intelligence, BO MOBILE, SAP BW 7.3 Cubes. BEx Query Designer, Xcelsius 2008 SP3, SAP Business Objects Explorer, Version migrations expert 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 10.1, R-Programming, R-Studio
• Over 8 years’ experience in SAP HANA Modeling & Data Provisioning, Over 2 years’ experience in SAP HANA Administration. Real time data replication from SAP & non-SAP systems ( Oracle, IBM DB2) into HANA on-premises and cloud. Expert in skills involving Modeling and development of SAP HANA Attribute, Analytic & Calculation Views using the HANA Modeling Studio. Migrate HANA developer code content across DEV-QA-PROD HANA environments. Importing SAP BW objects (DSO, Cubes, 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.

PROFESSIONAL EXPERIENCE:

Confidential, Silver Spring, MD

Reporting & Data Analytics Consultant

Responsibilities:

• Working for the Confidential CSTAR project initiative for Medical Devices review & approval lifecycle.
• Data analysis for the CEntry & CTS application systems flowing into the Confidential reporting data warehouse.
• Developing Business Objects universes for various reporting use cases.
• Developing Tableau dashboards & user stories for self-service analytics for business.
• Training business users in Tableau & Business Objects Webintelligence tools coexisting environments.
• Developing complex SQL queries for data analysis on sources & data warehouse systems.
• Developing adhoc Webi reports for meeting various business on demand reporting requests.
• Evaluating the opportunities for modernizing the CSTAR data warehousing reporting platform including SAP HANA & newer state of the art technologies including Predictive Analytics using R-Programming.
• End user training for self-service BI capabilities enablement for business.

Environment: SAP BI 4.1 SP5 Suite of Products, S AP HANA SP10, SAP HANA Modeling Studio, Tableau 10 Desktop, T-SQL, ORACLE, R-Programming, R-Studio

Confidential, Baltimore, MD

BOBJ Solutions & HANA Consultant

Responsibilities:

• SAP BOBJ & HANA consultant for developing and deploying HANA Views on SAP & non-SAP data sets out of multiple subject areas.
• Modelling of HANA Views based on ECC tables pertaining to SD functional module side for Allocations Preview use case.
• ETL design strategy & data modeling for population of the Data Warehouse in star schema fashion following Kimball methodology for HANA native modelling scenario.
• Design & develop best practices for implementing HANA Information models to fulfill the business requirements as well as optimized performance for fast highly available response.
• Develop dashboards using Tableau, number of Webi reports including Universes for same for various functional reporting needs across Confidential Logistics ( Warehouse Management), Retail space.
• User requirements gathering involving interactive with executive leadership including other business stake holders.
• End user training for self-service BI capabilities enablement for business.
• Enable the client to move to a BIG Data platform and integrating it using HIVE with existing SAP BI 4.1 analytics platform, R-programming for Predictive Analytics.

Environment: SAP BI 4.1 SP5 Suite of Products, S AP HANA SPS9 Rev 97, SAP HANA Modeling Studio, Tableau 9 Desktop, T-SQL, HIVE, R-Programming, R-Studio

Confidential, Sparks, MD

BOBJ Solutions & Data Analytics Consultant

Responsibilities:

• SAP BOBJ consultant for developing and deploying BO Universes for multiple of subject areas.
• ETL design strategy & data modeling for population of the Data Warehouse in star schema fashion following Kimball methodology.
• Design & develop best practices for implementing HANA Information models to fulfill the business requirements as well as optimized performance for fast highly available response.
• Develop dashboard using Design Studio 1.4
• User requirements gathering involving interactive with executive leadership including other business stake holders.
• End user training for self-service BI capabilities enablement for business.
• Enable the client to move to a BIG Data platform and integrating it using HIVE with existing SAP BI 4.1 analytics platform.

Environment: SAP BI 4.1 SP5 Suite of Products, Sybase IQ 16, SAP HANA SPS7, SAP HANA Modeling Studio, Tableau 9 Desktop, T-SQL, Cassandra DB, HIVE, DataStax Enterprise Edition

Confidential, Miami, FL

Data Analytics Strategy Lead

Responsibilities:

• SAP HANA/BOBJ Solutions Architect for developing and deploying enterprise wide reporting strategy.
• ETL Design strategy & data modeling for population of the Data Warehouse in star schema fashion following Kimball methodology.
• Lead the initiative to model and develop Datamarts involving 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.
• Lead the data modelling scenarios for the Loyalty Management Program/ Reward Programs for the cruise liner & its Casino partners.
• Designed & implemented best practices for loyalty program rewards tracking related reporting systems.
• 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, SAP Design Studio 1.4, SAP Lumira, Tableau 8.1
• Lead the implementation for Hadoop with SAP BI platform using the HIVE connector.

Environment: SAP BI 4.1 SP3 Suite of Products, Dashboard Designer 4.1, Oracle 9i/10g+, SAP HANA SPS7, SAP HANA Modeling Studio, Tableau 8.1 Desktop, Hadoop HIVE integaration with BO, T-SQL

Confidential

Data Analytics Strategy Lead

Responsibilities:

• SAP BOBJ Data Warehouse Architect for developing and deploying enterprise wide MDM enabled Datawarehouse & SAP BO Mobile strategy.
• ETL Design strategy & data modeling for population of the Data Warehouse in star schema fashion following Kimball methodology.
• 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 8.1 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, Tableau 8.1 Client-Server Architecture, Hadoop HIVE integaration with BO, T-SQL, MS SQL Server

Confidential

Data Analytics Architect

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 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, T-SQL, MS SQL Server

Confidential

SAP BI Architect

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, 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

Sr BI Strategist / Architect

Responsibilities:

• 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, PL-SQL, T-SQL

Confidential, CHARLOTTE, NC

Sr SAP BI Consultant

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

Sr SAP BI Consultant

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

Sr BI Developer

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

Sr BI Developer /Onsite Co-ordination Lead

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

Sr BI Developer /Onsite Co-ordination Lead

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

Environment: Business Objects 6.1b, Business Objects Designer, Business Objects Supervisor, Web Intelligence, BroadcastAgent, Oracle 9i, ERWIN, UNIX and Windows 2K.

Confidential

Sr BI Developer /Onsite Co-ordination Lead

Responsibilities:

• 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.

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

Confidential, New York

BI Developer

Responsibilities:

• 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.