Senior Data Analyst
Location : Chennai, India
Experience : 5.6 Year
Rate: $21 / Hourly
Availability : 2 Week
Work From : Any
Category : Information Technology & Services
MALATHI VENKATESAN
Summary
Experienced and dedicated Business & Data Analyst with 5+ years (5 years and 6 months)of experience identifying efficiencies and problem areas within data streams, while communicating needs for projects. Currently looking for a challenging role to apply the analytical skills which are earned from experience and form successful business organizations.
Skills
MySQL , PostgreSQL , BigQuery.
Data Proc, Azure Databricks, Data lake, PySpark.
Python (Pandas, Numpy, Matplotlib, Seaborn).
Excel/Google Sheets.
Looker (Including LookML,Liquid parameters...etc), Data Studio, Tableau, Power Bi, Klipfolio.
ADLS and Databricks Integration
A/B Testing.
Cohort Analysis .
Customer Retention/Revenue Rate Analysis.
Dashboard Reporting & Analysis.
Professional Experience
Foray Software /Senior Analyst Apr’2023 - Present
Built out the data and reporting infrastructure from ground up using Looker – LookML and BigQuery to provide real-time insights into the product, supplier addons and business KPIs.
Built the data pipelines using LookML, GCP - bigquery and DataPlex scheduler. Implementing data driven solutions through Looker visualizations for Wayfair science analytics project.
Senior Analyst/ Razorpay July’2022- Mar’2023
Worked directly with the operation execution and finance team as the first data hire to formulate and report on KPIs across all the registered merchants using Azure Databricks (SparkSQL) , pyspark and google sheets.
Developed and implemented ETL processes to extract, transform, and load data from ADLS into a databricks.
Developed ADLS Databricks Integration using JDBC and Mount Points.
Developed root cause report to address the problems with the fraud merchants to help the ED/CB CID Officers .
Developed the condition in firewall security applications using the fraud data history to avoid and identify the fraudulent payments and irregular payments. Created the Realtime reports in databricks and Looker
Senior Analyst/ Latentview Analytics July’2021- July’2022
Clients handled: Zulily, Walmart
Developed the Centralized Data tables in GCP layer using BigQuery.
Built the data pipelines using LookML, GCP - bigquery and DataPlex scheduler. Used the centralized tables to create the cohort analysis report using python to explore the customer
behaviour, customer retention and revenue rate. Worked on price elasticity model using python to identify the demands of each product in Zulily to fix the price for the products based on elastic levels. Visualized all the identified insights in Looker data model for better analysis. Business Analyst/ GFM Retail PVT LTD (Tender Cuts) May’2020- July’2021
Developed a python notebook to maintain the Sales/Purchase and COGS Reports for Daily, Weekly, Monthly and Yearly. Python and SQL server integration using advanced python libraries. Maintained real-time sales/inventory dashboards using Power BI
Experimenting with premium and regular customers for certain offers using A/B testing.
Data Analyst/ Data Analytics-Visionary RCM June’2018- April’2020
Transformed the organization into an organization towards data-driven mechanism with the help of data analytics tools. Understanding the data for Business improvement, Pre-Processing data for further analysis, using appropriate Quantitative measurable methods.
Developed a python notebook to combined the data from multiple projects (in sql server). Processed and cleaned unstructured data from the different projects using python libraries.
Visualize the production, quality, shrinkage, incentive reports for each employees/projects using Power BI for the better understanding of performance.
Education
Course Insititution Year of Passing Remarks
Bachelor of Engineering in the
Stream of Electronics and
Communication
University College of
Engineering Tindivanam
2018
7.99 CGPA
Higher Secondary
R C Girls Higher Secondary
School
2014 91%
SSLC
R C Girls Higher Secondary
School
2012 90%