Description
Professional Summary: * Over 10 years of extensive IT experience in Business Analysis, Business Intelligence, Data Warehousing, Data Mining, Data Analysis, Design, Development, Implementation, OLAP and Testing of BI, Database & Data Warehousing applications and Tableau. * Extensive experience inSoftware Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms. * Extensively worked on SAP Lumira1.0 Lumira 2.0 Discovery, Design Studio 1.6 Designer2.0. * Good Hands on experience in creating both Graphical and scripted Hana Views as per the requirements and development best practices. * Worked on SAP Vora integrating with Hadoop for the interactive Analytics. * Extensive Tableau Experience in Enterprise Environment including technical support, troubleshooting, report design and monitoring of system usage. * Deep experience with the design and development of Tableau visualization solutions. * In-depth knowledgeon SAP BW SAP BO 3.X and 4.X, HANA and BW on HANA Tableau Desktop and Tableau Server. * Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau. * End to end experience in designing and deploying data visualizations using Tableau. * Deployed the reports and Scheduled Reports for the use of end users and customers. * Successfully upgraded Tableau platforms in clustered environment and performed content upgrades. * Extensive experience working as a Business Intelligence Consultant with specialization in SAP HANA Crystal reports and SAP BW. * Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphsand Breaks. * Expertise in creation of Universe on various data bases through UDT and IDT. * Experience in creating ad-hoc reports using Business Objects Web Intelligence tools. * Expertise in working with all modules of SAP. * Excellent understanding of Data modelling (Dimensional & Relational) on concepts like Star-schema, Snow-flake schema using fact and dimension tables and relational databases (Oracle), SAP HANA, MS Access and client/server applications. * Worked with SAP BW ETL process to Extract, Transform and Load the data into stage area and data warehouse. * Worked extensively with the major functionality of SAP BO ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports. * Professional in writing complex Formulas, Sub Reports, Summary Reports. * Involved in Trouble Shooting, Performance tuning of reports and resolving issues within SAP BW /BOBJ. * In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment. * Strong working knowledge in software development methodologies like ASAP, Agile, Waterfall across the span of various projects. * Worked extensively with creating reports as per user requirements using BW reporting BO and Tableau. * Excellent data-analysis skills and ability to translate specifications into a working Universe and Report. * Experienced in tuning long running SQL queries for better performance. * Gathered and analyze the requirement to replicate the ECC content to HANA using data provisioning . * Created blueprint for Technical/Functional specifications and standard modeling documents for HANA. * Strong experience in carrying Functional, integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products * Established the best modeling and recommended strategies and architecture for SAP HANA. * Worked on trigger based data replication for SAP ECC using SAP Landscape transformation (SLT). * Build SAP FI, SD data to build information model for user consumption (Attribute view, Analytical view and Calculation view). * Created multiple models in HANA such as model consisting of replicated SAP tables VBAK, VBAP, VBUP and VBUK. * Created HANA information models (Attribute views, Analytical views, Calculation views, and Column/Row based tables) in HANA design studio for efficient data integration. * Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development. * Involved in SAP HANA Security including User Management, Roles, and Privileges. * Developed Real-Time Information models to support SLT replicated tables for SAP ECC. * Created SQL script based Calculation views using CE functions. * Built Schemas, analytic privileges and granted permissions for BI users. * Worked on Power BI Power Pivot to develop data analysis prototypes. * Proficient in creating Power BI Dashboards and Visualizations. * Worked extensively on creating Relationships, Measures, Calculated Columns, and Tooltips in the Power BI. * Experience in publishing Power BI Desktop reports created in Report view to the Power BI service. * Efficient in using Power View and Power Map to visualize reports. * Developed over 30 different interactive Dashboards using various visualizations in Power BI Desktop. * Primarily worked on producing Monthly and Daily reports in Power BI. * Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business. * Involved in the Unit testing, Quality Assurance testing and User Approval testing of Power BI reports and modifying the code accordingly to match user's business requirements. * Worked on modelling the data in Power BI involving creating measures, calculating columns, etc. * Created and managed relationships between tables in Power BI in order to calculate accurate results. * Transformed and combined the data using Query Editor in the Power BI. * Created Power BI Visualizations and Dashboards as per the requirements. * Published Power BI Desktop reports created in Report view to the Power BI service. * Worked on Power View and Power Map to visualize reports. * Help build dashboards within Power BI and MS Excel. * Excel PowerPivot, Power BI, PerformancePoint. * Identified expensive statements using HANA monitoring traces for performance optimization. * Transported objects by creating delivery units HANA monitoring traces for performance optimization. * Worked on SAP Hana security and analytical privileges for user access to different reports. * BuiltInformatica mappings to load Customers data from SAP BW application tables for various business units into HANA tables. * Performed full and delta loads based on MD5 checksum and scheduled workflows. * Monitored, Debugged and followed ETL best practices for efficient data loading. * Imported Flat files using SAP HANA import wizard. * Performed trigger based data replication using SLT technique for SAP ECC SD, FI. * Monitored triggers, data loads for SLT schema. Environment: SAP HANA BW 3.X to BI 7.5, HANA 1.0 SP11, HANA VORA Business Objects, IS-U, Lumira 1.0 Lumira Discovery 2.0, Design Studio 1.6 Lumira Designer 2.0Tableau WEBI, Power BI, Customer Service (CRM), Invoicing, FICA, Device Management, Work Management, Hadoop YARN and HDFS.
Accomplishments
Highlights:
Companies I like:
Ortho clinical Diagnostics
Keywords
