Ashray A.

About Ashray A.

Experienced data analyst with a demonstrated history of working in the retail data…

Experience

1. Consultant (Analytics)

   Fractal

   Oct 2018 — Present

   At Fractal, I\'ve worn many hats ranging from data analyst to data engineer to data visualizer, as detailed below: a) Asia Business Database (ABD), Client: A top five American CPG company worldwide, dominant in Hair Care, Air Care, etc. With a team of three, we managed/maintained an international sales database (value, volume, some distribution metrics too), which had a monthly refresh SLA. I worked on a tech stack of SQL Server Management Studio and Windows VM hosted on Azure Cloud. This is where I gained crucial skills in data stewarding (QA and validation), communicating intractable technical concepts to business users or third-party data providers (Nielsen, IRI), tightening data upstream / downstream co-ordination, mentoring new recruits and documenting data load processes to serve as knowledge transfer materials. b) Baby Care Share Power BI Report, Client: Same as previous. I worked on producing a data pipeline using R and creating a Power BI dashboard of diapers sales performance in the Indian market. I created about five pages of visuals, with a standard set of slicers and basic visuals. One of the advantages of this, was constantly being in touch with the power user through development. This led to a successful dashboard deployment and it was also used as a template for other related visualization projects inside the client vertical. c) Ecom Sales Reporting, Client: A renowned American CPG company selling snack, meal and beverages for over 100 years. Presently I\'m working with a team of three to build pipelines, conduct weekly and monthly data batch refreshes and troubleshoot any data anomalies. I speak to international clients regularly to explain and discuss data issues or alignments. I optimize data tasks wherever possible. I\'ve had the opportunity to work with industry leading tools like Snowflake for SQL-based processing, Azure Data Factory for disparate source connection, PuTTY for Linux-server navigation and Azure DevOps for source control.