SUMMARY

• SAP S/4 HANA /BW/BO/Tableau Solution Architect with around 10 + years of experience in SAP industry
• Seasoned Executive, Technology Consultant & BI Leader with diverse Global experience
• Experienced Leader, Architect, Trainer, Technical writer and Process Management consultant with expertise in managing Large Business Intelligence engagements
• High level proficiency and experience in Business Intelligence Life cycle management - Vision workshops, Proof of concept, analysis, Data Architecture, Data Integration and cleansing, data modeling, deployment and change management, maintenance, testing, Quality Control
• Highly Entrepreneurial, Self-motivated Thought Leader with a high level of analytic and numeric literacy in multiple verticals.
• SAP Certified HANA 1.0 Application Associate with thorough domain noledge on implementation and development of efficient data models in BW on HANA.
• Extensive experience working with Big Data modeling and architecture from multiple enterprise planning systems for executive level reporting which includes planning dashboards and FY Summary and Consolidations.
• Currently focused on High-Performance Analytics and Big Data Analysis technologies.

PROFESSIONAL EXPERIENCE

Confidential

Sr. BI Architect, Migration, Proposal Writing

Responsibilities:

• Created a data model for KPI such as Sales volume, Sales price, Net sales, component margin, STD contribution margin and std gross profit margin using HANA Calculation view and union using composite provider for multi-dimensional modeling.
• Exposed metrics to all common groups for primary driver for analysis varies me.e. Product hierarchy, management hierarchy, Customer hierarchy and Geography hierarchy.
• Worked on HANA Enterprise - Modeling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, Analytical Privileges.
• Created versatile reports with different tools like Webi,Analsis office, Lumira and design studio for end user self service reporting.

Confidential

Business analysis, Data Integration architecture

Responsibilities:

• Gatheird teh requirements from business user and transformed into functional and technical documentation
• Created teh data flow in BW on HANA from multiple source systems and consolidated BW data as a single-source of trust.
• Created teh HANA information views based on BW infoproviders and union all Calculation views with composite provider
• Created CDS Views and S/4 HANA enhancement.
• Written complex SQL based procedures, calculated column and CE functions to acquire desired data
• Created visualization dashboard on Tableau using Filter Actions, Lines, Axis, Geo coding and map functionality, which can be further drill down to particular plant for detailed analysis

Confidential - Wilton, CT

Sr. BI Architect, Migration, Proposal Writing

Responsibilities:

• Created simple to complex Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, using show me functionality.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet
• Technical oversight of teh Tableau Server infrastructure, Architecture from user setup to Deployment and performance tuning
• Responsible for Database Maintenance which involves backing up Tableau Data, restoring extracts and workbooks from Tableau Backup
• Responsible for setting up security model which involves creation and deletion of sites/users group, grantingpermissions for user / user group setup like granting user roles and assign security to teh folders created in teh tableau environment
• Involved in metadata integration from ERWIN Data Modeler with Tableau Server.
• Worked on self-service reporting integrated via HANA ledger, Spend, T&E, Payroll, Receivables, fixed assets and HR datasource to underlying COPA tables in HANA, Created Data Mart 1.

Confidential - Chalfont, PA

Sr. BI Architect, Migration, Proposal Writing

Responsibilities:

• Architecture teh BW Data flow using new functionalities in SAP BW 7.4. Combining teh SAP and Non- SAP Data in presenting teh reporting KPI’s.
• Integrated different source system data into BW System as a Governed body.
• Consolidated and streamlined financial reporting practices across landscape for faster reporting analysis.
• Involved in Technical DB migration of SAP BW to BW on HANA, and TEMPeffectivly create Unit Test Case to make sure teh DB migration does not affect teh current/existing data models with in BW.
• Functional BW Data flow migration to HANA Native flows to TEMPeffectively use of in-memory concepts with in BW.
• Created reports to users in Tableau by connecting to various data sources.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.

Confidential - Whitehouse, NJ

Sr. BI Architect, Migration, Proposal Writing

Responsibilities:

• Worked on building a comprehensive data model dat allows self-service access by Confidential business users to MMD Master and transactional data within teh four domains of SCM (Plan-Source-Make-Deliver) using various SAP tools (Business Objects - Webi and Explorer).
• Push Non-Harmonized Non-SAP source data outside SAP using Open Hubs to consume data for downstream consumption for TIBCO MDM.
• Develop BOBJ Universe to Connect to TIBCO MDM views to create reports using BOBJ WEBI.
• Publish teh BOBJ reports to User Inbox using Report Bursting and Scheduling.
• Migrating SAP BW DB to HANA DB and converting teh BW Flows to SAP HANA Optimized.

Confidential, New York, NY

Sr. BI Architect, Migration

Responsibilities:

• Worked in teh following KPI’s (Reports)
• Vendor Performance Report
• Order Fulfillment Report
• Cut Report with Reason code
• Store Wise Inventory Report
• Involved in Technical and functional upgrade to BW Powered by HANA, analyses teh availability of BW/4HANA. Help Mgmt on Best Case scenarios to Future use of BW/4HANA.
• Worked in Ship to Store, Back Order Reporting, Single Source Projects initiatives and Architect teh BI Data flows from extraction till to Reporting applications.
• Architect teh SAP HANA new modeling objects in teh existing data flows, enhance based on teh new objects available in SAP HANA.

Confidential, Whitehouse, NJ

Sr. BI Architect, Migration, Proposal Writing

Responsibilities:

• Responsible for interacting with teh various IT and business teams to collect reporting requirements to design and develop close and consolidation project.
• Worked sessions with MDM team to provide BW Master Data requirements to halp develop Confidential Common Information Model (CIM) which is a central hub for Consolidating, Managing, Governing business definitions and Content.
• Meetings with Treasury team to understand teh requirements for generating teh Foreign Exposure outbound feed file to FIREAPPS from BW to support Balance sheet hedging program.
• Developed and documented multiple customized function modules in SAP BI using ABAP for improved flexibility in harmonizing Master data and tracking financial CIM accounts which are made standard across SAP BI.
• Developed multiple designs to house data from different SAP and Non-SAP Systems(Vistex). Non-SAP data includes General Ledger Data from JD Edwards, Journals Data from Hyperion Financial Management, Sales Base and Adjustments data from Global and Local Repository Systems.
• Developed Real-time InfoCubes, Real time BEx Planning queries and created Dashboards using SAP Supply Chain Performance Management (SCPM) to support SCPM Dashboards project.
• Worked on SAP APO SNP/ DP Cubes, export datasource and create a spotfire Dashboard
• Developed BEx reports like Transit Close and Consolidation Report, GL Analysis Report, Foreign Exposure Report, Foreign Exchange validations Report.

Confidential - Hermitage, TN

Sr. BI Architect, Migration, Proposal Writing

Responsibilities:

• Created a Data model in LSA methodology to provide conceptual solution for Concurrent Employment.
• Created custom extractors and customization in BAdi and worked on various HR infotypes.
• Created custom hierarchy on employee.
• Enhance standard extractor 0HR PA 0 (Employees) and 0HR PA 1 (Personnel Actions).
• Developed Bex Queries for reports like Head Count According to Capacity Utilization Level, Number of Personnel Action, Percentage Breakdown of Headcount FTE.
• Worked on extraction of data SLT, DXC and BODS and deploying RDS solutions in IMCE HANA and ariba

Confidential

Business requirement analysis

Responsibilities:

• Participated in gathering teh requirements and architectural design and scope of teh project.
• Designed teh dataflow diagrams and defined teh reporting flavor depending on client’s Requirements after Business Blue Print.
• Created a Data model to consolidate Employee compensation data from AASIS (ECC) and other non participating agencies (Flat file) on FTP Server and reporting on transparency website.
• Consolidated data like Employee data, position text and salary data for teh Boards/ Commissions.
• Created security model to mask teh secure data on transparency website.
• Participated in gathering teh requirements and architectural design and scope of teh project.
• Designed teh dataflow diagrams and defined teh reporting flavor depending on client’s
• Requirements after Business Blue Print.

Confidential - Tampa, FL

Report development, Upgrading, testing

Responsibilities:

• Involved in teh Pre Upgrade Activities and Upgrade strategy.
• Running of Reports for activation of all teh Objects.
• Running RSRV for teh Consistency Check for Master and Transactional Data.
• Running teh Report RSUPGRCHECK Report for Checking teh Consistency Check.

Confidential

Sr. BI Architect, Migration, Proposal Writing

Responsibilities:

• Analyzed business requirements and developed functional, technical and test specification
• Designed SAP BW data model to meet business requirements
• Created export datasources to migrate data from one SAP BW to another SAP BW
• Fostered customer relationship by ensuring dat all deadlines are getting met and TEMPeffectively managed communication amongst stakeholders
• Worked on APO such as SNP/DP, MAPE, and Time Horizon. Reporting on 3 months lag
• Configured and activated Business content according to teh requirement based on teh Application areas. Extracted data from data source 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM to extract an opening stock balance, material movements and valuated revaluations in Financial Accounting.
• Activated business content for R/3 and BI for reports for SRM - SUS requirement, designed teh model for SRM SUS and extracted teh data from teh Custom Defined data sources from SUS.
• Developed reports for PO order history, PO order status and fro Invoices and Confirmations

Confidential - Wickliffe, OH

Sr. BI Architect, Migration, Proposal Writing

Responsibilities:

• Worked on FI GL and COPA integration for product groups and profitability segments.
• Created CO PA - GL line items reports and published them in portal.
• Costing-based Profitable Analysis and reporting to evaluate market segments, classified as combination of key dimensions; customers, strategic business unit, products etc.
• Implemented SAP Business Process Consolidation (BPC) to streamline planning, budgeting, forecasting and consolidation
• Implemented Business Intelligence Inventory Management (0IC C03 Cube) to optimize inventory and analyze warehouse stocks across various key parameters.
• Involved in defining flexible queries using Filters, Variables, Exceptions, Conditions, Restricted Key figures and Calculated Key figures in BEx Analyzer to facilitate data analysis in Customer and vendor master details reports.
• Worked extensively on WebI and Crystal reports.
• Scheduling teh documents and distributing them using CMC and monitoring them.
• Put teh limits on teh report instances by folder level / report level.