Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Nishika Abeytunge

Beaverton

Summary

Results-driven Lead Data Analyst/BI Analyst with over 10 years of experience in retail industry. Proven expertise in processing and analyzing large datasets, deriving business insights, and driving KPIs. Strong background in statistics and programming, utilizing tools such as SQL, Python, PowerBI, and Tableau. Adept at collaborating with crossfunctional teams to inform strategic decisions.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Senior Data Analytics Manager

Nike
09.2022 - Current
  • Explore and identify the best upstream cloud-based data sources in NDF: Nike Data Foundation (Snowflake, Databricks, Hive) using Python, SQL and API calls to replace the existing BOBJ reporting tool
  • Azure Analysis Service (AAS), OLAP tabular model development, deployment, and version control
  • Test and validate the data sources, coordinate with data owners to get insight on upstream data sources, refresh criteria and dependability
  • Work closely with data engineers in defining the ETL processes to extract, transform and load data into the reporting model, ensuring data consistency and integrity
  • Collaborate with key business stakeholders to gather and analyze the business requirements, work engineers in enablement of data needs for reporting
  • Lead the data governance of the new model in the development and documenting source to target maps (STM)
  • Design and create data visualizations for KPI reports using PowerBI, Cognos
  • Conducting UAT, office hours and Hyper Care sessions to assist tool access, report creation and data validity

Senior Data Analyst

Adidas Inc
08.2021 - 07.2022
  • Delivered high-quality analytics within an agile framework
  • Designed, developed, and automated a daily KPI dashboard for the retail division and distributed it to over 150 users including leadership
  • Built a dashboard for store-level inbound delivery tracking to deploy in NA retail stores
  • Wrote queries to pull data from source systems using SQL, analyze data using SQL and Python, create interactive dashboards in Tableau and Power BI and process automation through Alteryx
  • Collaborated with stakeholders to identify their reporting needs, changes and provide viable solutions
  • Identified upstream opportunities for improvements between systems, datasets, and processes and spearhead optimization efforts
  • Lead efforts to streamline and sustain existing reports and analytics products
  • Shared best practices and knowledge transfer within an analytics community of practice
  • Leading daily standups, sprint planning, and sprint retro meetings in agile environment

Senior Business Analyst

Oakley Inc
09.2020 - 08.2021
  • Led cross-functional collaboration efforts to align all support teams towards achieving operational KPIs
  • Designed and implemented KPI monitoring model for procurement, which improved the material availability by 12%
  • Designed and created reports in Business Intelligence, Tableau and PowerQuery
  • Improved the production capacity utilization by 2% through designing a reporting system
  • Analyzed, and presented KPI's related to demand, supply, unitization of capacity, quality of plan and recommendations to leadership on a weekly basis
  • Managed data integrity between SAP ERP system and other internal systems

Senior Production Planner

Calvin Klein (PVH Corp)
10.2011 - 09.2020
  • Managed the production planning process for $10 million units monthly
  • Designed and implemented a tool to deploy the demand into production orders for 'Speed to Market' models using Oracle Database, SQL queries and Informatica for data integration- saved $250k annually
  • Developed and implemented a KPI analysis template, automated the fulfillment rates reporting and maintained the Tableau KPI dashboard
  • Designed and created reports using Micro Strategy, SAP BI, Tableau, and advanced MS Excel functions for monthly reviews
  • Maintained data integrity between JDA, BI and ACS systems to minimize variances and potential errors in capacity projections

Education

Master of Information and Data Science -

University of California

Master of Business Administration - undefined

University of Moratuwa

Bachelor of Science - Engineering (First Class Honors)

University of Moratuwa

Skills

  • Snowflake
  • DBeaver
  • SSMS
  • Python
  • R
  • PySpark
  • SQL
  • Tableau
  • PowerBI
  • Cognos
  • SAP BI
  • BOBJ
  • MicroStrategy
  • Alteryx
  • Business Object
  • Git
  • Github
  • Anaconda
  • VS Code
  • Redshift
  • Jira
  • SharePoint
  • Confluence
  • SAP
  • S4/HANA
  • Advanced Microsoft Excel
  • Word
  • PowerAutomate
  • AWS
  • Google Cloud
  • Databricks
  • Postman
  • DAX Studio
  • PowerBI Dataset
  • Tabular Editor
  • Statistic Modeling
  • Deep Learning
  • NLP
  • Retail
  • Supply Chain
  • Manufacturing

Certification

  • Data Science and Visualization Boot Camp, University of California, San Diego, 07/01/21
  • PGP in Artificial Intelligence and Machine Learning, University of Texas, 01/01/21
  • Certificate in SQL for Data Science, UC Davis, 08/01/21
  • Python for Data Science certificate, IBM, 12/01/20
  • PCEP- Certified Entry-Level Python Programmer Certification, 06/01/20
  • Advanced Diploma in Management Accounting, (CIMA- UK), 01/01/10

Timeline

Senior Data Analytics Manager

Nike
09.2022 - Current

Senior Data Analyst

Adidas Inc
08.2021 - 07.2022

Senior Business Analyst

Oakley Inc
09.2020 - 08.2021

Senior Production Planner

Calvin Klein (PVH Corp)
10.2011 - 09.2020

Master of Business Administration - undefined

University of Moratuwa

Bachelor of Science - Engineering (First Class Honors)

University of Moratuwa

Master of Information and Data Science -

University of California

Similar Profiles

CREATE PROFILE
Nishika Abeytunge