SUMMARY:

• 14+ years of professional experience in development and implementation of Business Applications using SAP Business Objects BI 4.2 / 4.1 / 4.0 / BO XI 3.1, SAP BW 7.4 / 7.3 / BI 7.0 / BW 3.5, SAP HANA, MS SQL Server, Cloudera Hadoop / Hive SQL, Google Big Query / GCP, Tableau, Power BI, SAP ECC & R/3, SRM, SCM / APO, SD, MM, PPM, HCM, FI/CO, GL, AP, AR etc.
• Experience in handling projects from different sectors - Retail, Automotive, Insurance, Computer Software, Medical Appliances & Equipment, Energy & Utilities and Computer Networking across multiple business functions - Sales & Marketing, Finance, CRM, HR, and Confidential -Commerce etc.
• Experience in Full Life Cycle Implementation of the project i. Confidential ., requirements gathering, analysis, design, development, documentation, testing, deploying and supporting applications.
• Good understanding of various Data Models such as Dimensional Data Modeling, Extended Star Schema Modeling, Snow Flake Modeling, Physical and Logical Data Modeling.
• Thorough understanding of EDW architecture / SAP BW’s architecture (ETL and Reporting)
• Involved in full life cycle Implementation of projects in BI / Data Warehousing which includes Data-Modeling, Data Extraction, Data Loading, and Data Staging & Monitoring.
• Good knowledge and experience on SAP HANA and was part of BW 7.4/7.3 on HANA implementation.
• Good understanding of Columnar Data Storage & In-Memory computing architecture of SAP HANA.
• Knowledge of HANA Modeling and experience integrating various BI tools such as Tableau, Power BI, SAP BO / BI with HANA data sources such as Analytic Views, Calculation Views, Attribute Views & Free-hand SQL queries
• Excellent knowledge and very good work experience in designing reports / dashboards using SAP BI tools such as Web Intelligence, Analysis for Office, Analysis for OLAP, SAP Lumira, Design Studio, Crystal Reports, Xcelsius / Dashboards, CMC, CCM, Information Design Tool (IDT) and Universe Design Tool (UDT), Universe Designer, BI Launchpad, Infoview, QaaWS and Business Objects Administration
• Experience in migrating older versions of Business Objects Universes and reports to newer versions.
• Expertise on using front-end Business Warehouse components such as BEx Query Designer to build BEx Queries (using Calculated Key Figures, Restricted Key Figures, Filters, Variables, Structures, Hierarchies, Conditions, and Exceptions etc.), BEx Analyzer, and Web application designer (WAD)
• Extensively used advanced reporting functionalities such as Master-Detailed, Drill Down, Drill Through, Hyperlinks, Document Linking, Element Linking, Cascading Filters, Ranking, Sections, Breaks, Tabs, and Graphs.
• Worked on Tableau Server Administration, Tableau Security, Tableau Data Extracts, Tableau Development using Tableau Desktop and delivered high-performance Dashboards with KPI's
• Worked on Microsoft Power BI Desktop, Power BI Service, and Power BI Mobile and designed reports and dashboards using MS Excel, MS Access, Oracle DW, SAP BW, SAP HANA & other External Data Sources.
• Proficient with various RDBMS technologies including MS SQL Server, Oracle and MS Access
• Extensive database architecture and design skills to deliver high-performance solutions in large corporate environments.
• Involved in review meetings with Project Managers, Developers, and Business Associates during Project Planning, Coordination and implementing various QA methodologies.
• Very good experience working and dealing with Onsite-Offshore model.
• Extensively involved in End User , Classroom as well as Developer .
• Created Technical Specifications, Manuals etc. Developed User Guide document for business objects.
• Excellent communication, presentation, management and interpersonal skills.

TECHNICAL SKILLS:

Data Warehouse App's: SAP BW 7.4 / 7.3, SAP BI 7.0, SAP BW 3.5, Oracle DW

ERP Packages: ECC 6.0, SAP R / 3, Oracle EBS

Reporting / Design Tools: Tableau, MS Power BI, SAP BO BI 4.2/4.1/4.0, BO XI 3.X, Web Intelligence, SAP Lumira, Design Studio, Analysis for Office, Analysis for OLAP, Crystal Reports, Xcelsius/Dashboards, BEx Query Designer, BEx Analyzer, Web Application Designer, BI Launchpad, CMC, CCM, IDT, UDT, Infoview, Desktop Intelligence, Live Office, QaaWS

Programming Languages: ABAP / 4, Java / J2EE, C

IDE's: SAP HANA Studio, Eclipse, My Eclipse

Database Technologies: Google Big Query, SAP HANA, Oracle, MS-SQL Server, MySQL, MS Access

Server Technologies: Apache Tomcat, IIS, BEA Web logic

Scripting Languages: JavaScript, HTML, CSS

Microsoft Office Suite: MS Word, MS Excel, MS PowerPoint

Operating System: Windows 9 / XP / VISTA / 7, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Milpitas, CA

Enterprise BI Solutions Architect

Responsibilities:

• Worked on multiple BI initiatives supporting different programs such as Customer Analytics, Amazon Returns, Project & Portfolio Management and other ad-hoc tracks
• Played the role of a techno-functional analytics person bringing onto the table vast BI / Analytics expertise combined with extensive domain knowledge within the Retail industry.
• Designed “Customer Analytics” Landing Page, which acts as a one stop shop across the enterprise generating valuable Customer Insights using Tableau, Google Big Query / GCP & Teradata etc.
• Played a key role in developing “Amazon Returns” dashboard at Confidential ’s by working very closely with the business stakeholders and Product Management teams. The insights generated using this dashboard were tracked by executive team on a day to day basis to assess the ROI of this new initiative at Confidential ’s.
• Developed multiple dashboards / data visualizations such as Customer at a Glance, Digital Customer at a Glance, Digital Customer Behavior, Digital Purchase Frequency, Customer Journey, Amazon Returns, KCC KPI Analysis, Campaign - Data Analysis, Data Quality & Data Flow dashboard etc.
• Delivered important KPI’s / Customer Metrics such as Customer Counts, Transaction Counts, Sales, AOV (Average Order Value), ATV (Average Transaction Value), AUR (Average Unit Revenue), RPC (Revenue per Customer), UPT (Units Per Transaction), Avg. Digital Spend per Customer, Avg. Store Spend per Customer, Visitors, Visits, Visits with Product View, Visits with Cart Add, Checkout, Orders & Conversion etc.
• Generated various insights based on Customer Type (In-Store / Online / Omni), Customer Segment, Loyalty Segment, Merchandize Type and Marketing Channel etc.
• As part of Amazon Returns initiative, valuable insights such as Top & Bottom Stores Analysis, Peak Return Analysis, Amazon Location Analytics, Amazon Returns Trend Analysis (Daily / Weekly / Monthly / Quarterly / Yearly) and Amazon Return Details were delivered highlighting the following KPI’s: Total Returns Count, Avg. Daily Returns per Store, Overall Coupon Redemption Rate, Same Day Coupon Redemption Rate, Confidential ’s Charge Penetration, Returns Traffic Penetration, Total Redemption Value, SUPC Usage Rate etc.
• Generated various reports and dashboards for Digital PMO based on JIRA data wherein you can track the status of JIRA Stories & Defects at Portfolio / Program / Project / Sprint / Release / JIRA Type / JIRA Status & JIRA Priority etc.
• Designed custom visualizations such as Funnel Charts, Donut Charts, Timeline Charts and other Data Visualizations / reports adhering to the best practices right from Database level to Dashboard level.
• Improved the performance of “Customer Dashboards” by 100 times by using Aggregated queries on top of Aggregated Tables and leveraging Tableau extracts scheduled to refresh periodically ( instead of directly going against base tables which are at a very low granularity i. Confidential ., “Customer Id” grain )
• Conducted interactive sessions for various business users & functional teams across the enterprise to spread the usage of Tableau Data Visualizations in answering their day to day reporting questions based on real time / near real time data.

Environment: Tableau 2019.2 / Tableau 2018.3, Google Big Query / Google Cloud Platform, MySQL Server, Teradata, Oracle, Atlassian JIRA etc.

Confidential, San Jose, CA

Enterprise BI Solutions Architect

Responsibilities:

• Worked on implementing BI / Reporting solutions as per new Revenue Accounting & Reporting standards (ASC 606) for Finance and other enterprise business units across Adobe.
• Designed and developed GAAP & Non-GAAP reports / dashboards related to Revenue Recognition using BI tools such as Tableau & MS Power BI. Source system being SAP ECC / RAR with analytics on top of SAP HANA data sources. (Calculation Views / Custom SQL queries)
• Developed operational reports such as RAR Actual Revenue, RAR Deferred Revenue & Forecast, RAR Unbilled Receivable, RAR Unbilled Backlog, RAR Revenue Forecast, RAR Invoice Correction, RAR Bookings, RAR Billings and SSP Determination etc.
• Built reports & dashboards for business as well as executives to monitor the comparison of key metrics between ASC 605 vs. ASC 606 Revenue Recognition Standards. These dashboards provide live insights about RAR migration activity (as it happens in source system) and highlight any variances between old (ASC 605) & new (ASC 606) Revenue Recognition KPI’s, thus enabling RAR team to take immediate action to mitigate the risks associated with RAR migration
• Worked on modifying / enhancing Revenue Operations / QBR dashboards (built using Power BI) to include the new Revenue Recognition information without impacting existing data.
• Worked as part of Enterprise Product Analytics group to design various dashboards that provide valuable insights related to Named User Delegations / Provisions across different Market Segments and Geographies for various Cloud Types. (Built using Power BI with data coming out of Cloudera Hadoop and used HIVE SQL / Power BI Modelling to work with multiple data sources)
• Designed and developed several Power BI dashboards & reports using standard & custom visuals and shared them with business users via Power BI Apps
• Good understanding of Power BI architecture (from both Administration and development perspective)
• Used Geo Maps and ArcGIS based mapping visuals in Power BI to build location based intelligent dashboards
• Built several Power BI Apps for different business functions and enabled access to business users
• Developed enterprise level dashboards and presented them as stories / narratives to top management
• Worked on performance tuning of operational reports / dashboards by adhering to the standard and best practices of BI / Data visualization
• Worked closely with business users / super users to help clarify their issues related to BI / Reporting (Tableau & Power BI). Tried to adopt a “Show & Tell” mechanism to answer their “How To” related questions and made them understand the nuances of reporting / business intelligence.

Environment: MS Power BI, Tableau 2018.2 / Tableau 10.1, SAP HANA SPS 12, SAP ECC / RAR, Cloudera Hadoop / Hive SQL, MS SQL Server, MS SharePoint, Atlassian JIRA etc.

Confidential, Cypress, CA

Enterprise BI Solutions Architect

Responsibilities:

• Implementing BI / Reporting solutions across various Yamaha Group of companies such as Confidential, Yamaha Golf Car Company, Precision Propellers Industries Inc. and Yamaha Motor Finance Corporation etc.
• Designing Analytics solutions for different Product Lines such as Motorsports, Watercraft, Marine, Low-Speed Vehicles, Parts & Accessories etc. spanning across multiple modules such as SAP Transportation Management (SAP TM), SAP Vistex, Siebel CRM, SCM, SAP Financials, Sales & Distribution etc.
• Worked on designing dashboards using Power BI (Wholesale, Retail, Actual vs. Budget etc.)
• Mobile enabled dashboards and shared them with executives, managers and business users
• Worked on implementing Power BI Security at an enterprise level by creating corresponding groups for Super User & End User etc.
• Configured Power BI enterprise gateways and used it to schedule refreshes for SAP HANA and SQL Server data sources
• Implemented Row Level Security in Power BI reports and enabled region-based access to Sales Managers
• Worked on designing operational reports using Web Intelligence and SAP Analysis for Microsoft Office to support daily reporting needs for multiple business units
• Worked on BO Administration and Production Support activities and resolved various reporting issues for users as well as other team members
• Conducted sessions for business users on Self-Service Reporting and educated them in using BI tools to simplify their day to day activities

Environment: MS Power BI, SAP BO 4.2 SP2, SAP BW 7.4 SP15, SAP HANA SPS 12, SAP ECC, SAP Vistex, SAP TM, Siebel CRM, BEx Query Designer, Oracle DWH etc.

Confidential, Livermore, CA

Enterprise BI Solutions Architect

Responsibilities:

• Was part of Global Sales & Marketing Team working on Market Analytics Project to build Enterprise ready Dashboards for their Annual Sales Meeting
• Was on-board to examine painfully slow performing Dashboards and to fix/redesign them highlighting the existing design/architecture flaws and work on the improvements based on standard / best practices for designing Tableau Dashboards
• Worked on building high visibility Marketing & Sales Dashboards for use by a wide variety of audiences such as Top-Level Executives, Product Sales Managers, District Sales Managers, Regional Sales Managers and Business Analysts / Business Users
• Worked on the entire lifecycle of designing the dashboards, right from requirements gathering, prototyping, identifying various data sources / required dashboard elements, designing the backend queries, developing the dashboard using Tableau Desktop, testing and publishing the dashboard to Tableau Server
• Worked with multiple Data Sources / multiple Data Connections and used Tableau Data Joins / Data Blending for Data Preparation and subsequently built Dashboards and Stories on top of it
• Worked on building Regional Sales Manager Performance Dashboards and Product Sales Manager Performance Dashboards for both Topcon & Sokkia brands, Dealer Performance Dashboards for both RSM & PSM, Geo-positioning Overview Dashboard etc.
• Worked extensively with Tableau Data Extracts based on BW Data Sources for performance optimization of Dashboards
• Configured the entire security model on Tableau Server based on standard practices and created various User Groups for Executives, District Managers, Product Managers, Regional Managers & Business Users and applied appropriate security levels ( View, Interact, Edit & Custom ) as per the requirement
• Implemented Security at the Project / Workbook Level adhering to the standard security guidelines (Default Project Level Security User Defined Project Level Security Workbook Level Security)
• Worked extensively with Scheduling functionality on Tableau Server and defined New Schedules for Tableau Data Extracts, Automated Extract Refreshes by defining New Tasks and associated them with respective Schedules
• Worked on Tableau Server Administration and monitored various activities (Processes, Server Activities, Scheduled Data Extracts, Load Times, Resource Utilization etc.) and fine-tuned parameter settings for optimum performance following best practices
• Trained the business users on the features and functionality of Tableau with an emphasis on basic standards for designing enterprise dashboards

Environment: Tableau 10.1 / Tableau 9.3 (Desktop & Server), Salesforce CRM, SAP BW 7.3, SAP ECC, BEx Query Designer, BEx Analyzer, MS SQL Server, MS Access, External Data sources etc.

Confidential, San Francisco, CA

BI Solutions Architect (SAP BOBJ / HANA / Tableau)

Responsibilities:

• Part of Global Confidential -Commerce Reporting, Global Supply Chain Reporting & Enterprise BI Upgrade projects and played a Key Role in transitioning GSI NetAcumen Reports to SAP BO / BI Reports with SAP BW on HANA as the major Source System
• Reporting Landscape includes a wide variety of Systems such as SAP Hybris, SAP AFS, SAP SCM / APO, Raymark, Omniture, PivotLink, Avalara, GSI NetAcumen etc.
• Participated in the business meetings and did the requirements analysis to re-build the legacy reports using SAP BI suite of reporting tools such as Analysis for Office, Web-I, SAP Lumira, Design Studio etc.
• Designed Levi’s Reporting Templates and Prototypes for Confidential -Commerce Reporting (Springboard) Project
• Worked on the design, development, and implementation of various Confidential -Commerce Reports such as Order Detail Lookup, Promotion Order Details, Promotion Analysis (Demand Level & Order Level), Tender Type Analysis, Product & SKU Details, Tax Summary, Return Detail Lookup, Return Reason Analysis etc.
• Worked on designing various Supply Chain Reports such as Ship Risk Weekly / Monthly, Supply Planning Weekly / Monthly, DC operations Summary / Detail, Global Excess & Obsolete Summary / Detail etc. Also developed Exception reports for business such as WFC Actuals Above / Below Target, Negative Stock out, Negative Ending Inventory & Ship Risk Exception reports.
• Worked on building / prototyping various Dashboards using Design Studio and SAP Lumira such as Levi’s / Dockers Weekly / Monthly / Yearly Demand KPI Analysis Dashboards, Levi’s / Dockers Weekly / Monthly / Yearly Traffic KPI Analysis Dashboards, Levi’s / Dockers Marketing Trend Analysis Dashboards, Levi’s / Dockers Funnel KPI, Levi’s / Dockers Merchandizing Product Performance Dashboards, Levi’s / Dockers Financial Executive Summary Dashboards etc.
• Worked on Global Confidential -Commerce Location Analytics Dashboard Prototype using the GEO Maps feature of Design Studio 1.6 to drill down from Country / State / County / City level using Custom GeoJSON files to display shapes/bubbles/markers on Map along with KPI’s
• Involved in implementing SAP BO 4.1 SP6 and worked on Sizing the APS Server (Splitting the Adaptive Processing Server) in Dev / QA / Prod environments based on the best practices for managing SAP BI System
• Responsible for creating and managing users/connections/reports etc. in SAP BO across all the 3 environments
• Installed the required SAP HANA Clients (HDBODBC) to enable direct reporting on top of SAP HANA using Analysis for Microsoft Excel 1.X version. Subsequently changed the connection mechanism to HTTP connection when reporting against Analysis for Office 2.X client tool
• Worked on enabling direct reporting on top of SAP HANA Views (generated from the BW System) by executing the RS2HANA CHECK transaction to replicate BW Authorizations / Roles in SAP HANA
• Used SAP HANA Calculation Views and SAP HANA Analytical Views as Source for Reporting in various BI tools such as SAP Lumira, Design Studio and Analysis for Office
• Installed and configured various BI tools such as Analysis for Office, SAP Lumira, Design Studio etc. for Business Users
• Worked Closely with the Desktop Engineering Team to package various BI Applications and prepared the required guidelines/documents regarding the system pre-requisites, installation procedure, and post-installation configuration/checks
• Prepared End-User Guidelines / documents for Confidential -Commerce / Global Supply Chain Reporting
• Conducted a series of sessions for End Users on Analysis for Office / BI Launchpad and ensured that the business is self-sufficient in using these tools to get answers to their questions

Environment: SAP BO BI 4.1 SP6, BW 7.4 SP10 on HANA 1.95, SAP HANA Studio, SAP Hybris, SAP AFS, SAP SCM / APO, WEB-I, SAP Lumira 1.29, Analysis for Office 2.1, Design Studio 1.6, BO Administration / CMC, IDT, UDT, Tableau 9.1, GSI NetAcumen, Raymark, Omniture, PivotLink etc.

Confidential, Santa Clara, CA

BI / DW Solutions Architect (SAP BOBJ / Tableau)

Responsibilities:

• Worked closely with the business in transition of Tableau / Oracle reports to SAP BO reports
• Part of the Flexera Project and involved in reporting on Flexera, InstallBase and Contracts business processes
• Designed InstallBase, Flexera and Contracts Universes with Oracle EBS (RDBMS) as source using IDT 4.1
• Migrated the old universes (.UNV) to new universes (.UNX)
• Analyzed the existing SQL queries / Procedures in Oracle and built BO Universes with appropriate Joins and used Aliases and Contexts in IDT to overcome various Loops and Traps (Chasm, Fan)
• Created reports using WEB-I, Dashboards (Xcelsius) and Lumira
• Designed the Confidential Corporate Reporting Standards document

Environment: SAP BO BI 4.1 SP4, IDT, UDT, WEB-I, Crystal, Lumira 1.18, Tableau 9.0 etc.

Confidential, San Ramon, CA

SAP BOBJ / BI Consultant

Responsibilities:

• Worked closely with the business and participated in the requirements analysis for various reports
• Designed various reports based out of SAP PPM (SAP Portfolio and Project Management)
• Worked on designing the high visibility "IT Governance" WEB-I report which gives an overview of various projects in the organization based on the department, sub-divisions within a department and other information such as Business Owner, IT Owner, Project Owner, Allocated Budget, Timelines, Progress, Funding Unit etc.
• Worked with relational and OLAP universes and designed the WEB-I reports based on multiple sources
• Used Crystal reports and Lumira to develop certain reports
• Worked on "Work Order" report which tracks the status of various projects
• Modified the existing SAP SEM reports based on the back-end changes as part of a new release
• Worked on fixing the missing Measures / other information in the existing reports and modified various variables in the report accordingly to reflect new changes

Environment: SAP BW 7.01, SAP BO BI 4.0 SP6, IDT, UDT, WEB-I, Crystal, Lumira 1.18, PPM, SEM etc.

Confidential, Johnston, RI

Sr. SAP BOBJ / BI / BW Consultant

Responsibilities:

• Played a vital role in the new SAP Finance implementation project in Insurance domain
• Worked closely with the business and designed and architected various reporting requirements
• Worked on designing Operational Profit & Loss Dashboards using Design Studio
• Used Design Studio Scripting, CSS, and HTML to develop various Dashboards
• Mobile enabled Summarized Dashboards used by C-Level executives
• Implemented drill through functionality from one dashboard to another and used global script variables to pass the parameters from parent dashboard to child dashboard
• Worked extensively with WEB-I Cross Tabs and used Dynamic Hyperlinks, Variables, Document Linking etc., to implement drill through functionality from OP&L Summary Reports to Multiple Detail Reports
• Architected, Designed and Implemented OP&L Quarterly Summary Report as well as OP&L Monthly Summary Report with dynamic drill through functionality for a GL Account & Profit Center Combination
• Designed multiple levels of drill through reports from a Summary Report to various Account Level, Policy Level, Claim Level and Expense Level reports for both Quarterly Summary and Monthly Summary reports
• Designed WEB-I Template as per the industry standard and adhering to client specifications
• Worked extensively with BEx Hierarchies, BEx Structures, BEx Variables, Calculated Key Figures, Restricted Key Figures etc. and leveraged the same into front end WEB-I reports
• Used Query Filters, Report Filters, Input Controls, Block Filters and Filter Bars etc., while designing WEB-I Reports.
• Identified tool issues when trying to filter based on BEx hierarchies & BEx Structures in WEB-I and worked closely with SAP and suggested the basis team to upgrade to 4.1 SP3 to resolve these issues. Suggested various workarounds to overcome the tool issues.
• Worked on technical specifications document for all the reports and documented various test cases so that the QA team can validate the scenarios
• Demonstrated the end to end functionality of the Quarterly Summary & Monthly Summary reports with detailed drill through functionality (From Summary -> Account -> Policy / Claim / Expense -> Source Category -> Source) based on a business scenario
• Trained the business users on using various SAP BO tools and addressed their issues/questions

Environment: SAP BW 7.4, SAP BO BI 4.1, IDT, WEB-I 4.1, Design Studio 1.2, SAP FI/CO, SAP ECC 6 with EHP 6 etc.

Confidential, Sunnyvale, CA

Sr. SAP BOBJ / BI Consultant

Responsibilities:

• Worked on the day to day production support requests from the users.
• Handled multiple new and existing requests from the users and worked closely with the business to do the gap analysis
• Proposed possible solutions to the users based on the existing issues and enhancement requests and subsequently worked on implementing the solution
• Showcase the reports to the business after meeting the enhancement requests and resolving the issues and get an approval / sign-off for the report to GO LIVE into Production
• Worked extensively on Universe Design & Development and enhanced the existing Universe's by adding new objects based on the reporting requirement.
• Developed Universe using Information Design Tool (IDT) in BO BI 4.1.
• Created Joins, Parsed the objects, Resolved Loops in the Universe by using Aliases (Alias names for Tables where several fields have the SAME Master Data Text Table) and Contexts and checked the Integrity and Cardinality of the Universe.
• Worked with both Relational Universe's and OLAP Universe's and designed several WEB-I reports on top of these Universe's.
• Worked on designing WEB-I reports based on Multiple data sources (SAP & Non-SAP Data)
• Designed several WEB-I reports such as MDR Report, STAPLER Report, Deactivated Systems Report, Notification Aging Report, IBASE Systems & Components Report etc.
• Developed complex WEB-I reports using MULTIPLE Universes as a data source.
• Successfully designed various WEB-I documents with multiple report tabs and each of these report tabs used to have several columns (sometimes 50 columns in a single report tab).
• Extensively worked with Merged Dimensions and Detail Objects in WEB-I to show the data coming from multiple universes in a single Table / Block within a report.
• Used Conditional Formatting in WEB-I reports so that the business can easily distinguish data in the report based on various COLOR CODES and highlighting.
• Used Promotion Management in CMC to move the reports from Dev to QA / Production.

Environment: SAP BW 7.4, SAP BO BI 4.1, IDT, Universe Designer, WEB-I 4.1, SAP FI/CO, SAP CRM, SAP ECC 6 with EHP 6 etc.