PREETHI CHANDRASEKRAN

• Automate manual reports which are in excel via Alteryx connecting to SAP data sources and build front-end visualization using Power BI
• Work closely with Product Health, Demand Planning teams to provide solutions in Power bi with data coming from SAP
• Create reports that are useful for VP & GM to monitor sales performance daily
• Working as key person for APME region LSC Org to implement new solutions for data analytics
• Implemented PBI & Alteryx solutions for calculating non-performing materials and BCW tracker to track more than 180 days for active materials in the system
• Portfolio Health dashboard to track whether SKU to be Kill/Cure for Fit4 Purpose
• Implemented dashboards for Demand Planning team to calculate the DFA & track GI/Total orders against Forecasts.
• Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats

• Automate manual reports which are in excel via Alteryx connecting to SAP data sources and build front-end visualization using Power BI
• Develop Ad-hoc queries in Bex query designer for business requirements
• Directly interact with VPs & GM in Shell to understand the business requirement in sales & marketing & automate the reports accordingly
• Provided various analytic solutions working with Data science teams
• Work in various data platforms and also take care of data governance, IRM compliance etc.
• Worked on end-to-end solutions using Agile methodology to provide deliverables
• · Working with Sales & Marketing team in Shell provided an excellent stakeholder management skill.
• Delivered a key project "FALCON" for APAC & China Hong-kong.

• Working in Clariant – chemical giant for several dashboards Such as Ticketing Tool - Computing Time ticket and Quality ticket from CRM table (ECC System) and joining virtual table created on top of ECC system with Customized table in Hana to calculate theBusiness KPIS
• Bonus Management Dashboard - Creating design studio dashboard which displays Bonus Payout for employees based on Quality and productivity achievements
• This dashboard is created for thetop-level management and HRs who can get information like number of employees eligible for bonus and percentage of Bonus payout segregated by Team, SSC, Process area, Sub process area etc.
• · Creating Hana graphical and SQL calculation views, Analytic, Attribute view, Input parameter, variables, Level Hierarchy.
• Created Design Studio Dashboard using multiple components like Dimension Filter, info charts, timer, crosstabs etc. Also worked on to improve performance of dashboard by implementing background processing and parallel processing

· SAP HANA Implementation and HANA Technical - development (Replicating ECC tables into HANA Studio, creating views) transport HANA objects.

· Built end to end assets (Dashboards, Data Models, and Analytics Hierarchy) for different functional areas specific to different industries.

· Understand the industry KPIs and design the views on SAP HANA.

· Experienced in Initial view of Data sources, Cascading filter, dimension filter, static & dynamic text, adding hyperlink to application, Global and Local variables and BW Hierarchies in Design Studio.

· Experience on Information Space based on Universe, HANA Cube and Excel

· Created Simple Reports using Bex Queries in SAP BO Web Intelligence.

· Data Extraction Techniques - enhancing standard Data sources and creating custom Data sources

· Data load experience from various Source Systems like R/3, Non-R/3 Systems and flat files. Hands-on experience on loading data from transactional and master data.

· Experienced in the enhancements of Multiprovider, Info Cube, Transformation logic, Bex-Query Designer, RKF, CKF, Variables

· BW Reporting – Experienced in Business Explorer Analyzer, Business Explorer Designer - Design and Development of Queries, Query, Free Characteristics, Calculated and Restricted Key Figures, Structures, Cells, Variables, Filters, Exceptions and Conditions

· Transporting Object – Experienced in migrating the BW objects from Prototyping system to Development and Quality Systems

· Managed and monitored several data loadings, captured the errors, corrected the bugs and reported the status.

· Worked on support as well as developments like Process Chain creation & fixing the Loading issues & Process chain failures.

· resolved issues in process chains like correcting PSA errors, Activation/ Roll up failures.

· Lead several QMW activities for Production, sandbox & development systems from BI space. Trained many project new joiners by giving KT on the work & project processes.