Jaskirat Singh Saini

Jaskirat Singh Saini

Data Analyst
United Kingdom
English, Hindi

About Me

5+ years of Data / BI experience with a diverse background in Retail, E-commerce, and Finance. Skilled in creating reporting structures and transforming data into actionable insights. Proficient in Excel, SQL, Python, an…

Experience

Data Analyst

Freixenet Copestick, Northampton, UK
Apr 2021 - Present · 5 years 3 months

Led the Data division of the E-commerce (D to C) business Slurp.
Conducted a customer lifetime value analysis, enabling targeted marketing strategies.
Achieved a 4% increase in 2nd shop-rate post reallocated budgeting.
Conducted Basket Analysis to pinpoint Loss-leader, Loss-lagger, and Hero products, enabling the Marketing team to change promotional strategies and resulting in a revenue increase of £100K.
Performed competitor analysis, revealing subscription model potential.
Facilitated setup of wine subscription, yielding £70K revenue in 6 months.
Utilised Python code to automate data cleaning and transformation processes, eliminating manual intervention.
Saved 1 hour per day.
Increased targeted marketing effectiveness by 35% by developing customer segmentation models using Azure Databricks and Power BI.
Created interactive Power BI dashboards, enhancing data accessibility.
Built a comprehensive Data Dictionary and reporting infrastructure from the group up improving business efficiency by 50%.

Senior Data Analyst

Freixenet Copestick
Apr 2021 - Present · 5 years 3 months

As a Sr Business Data Analyst for Freixenet Copestick's (FXC) E-commerce business Slurp -
Conducted a customer lifetime value analysis, enabling targeted marketing strategies. Achieved a 4% increase in 2nd shop-rate post reallocated budgeting.

Conducted Basket Analysis to pinpoint Loss-leader, Loss-lagger, and Hero products, enabling the Marketing team to change promotional strategies and resulting in a revenue increase of £100K.

Performed competitor analysis, revealing subscription model potential. Facilitated setup of wine subscription, yielding £70K revenue in 6 months.

Utilised Python code to automate data cleaning and transformation processes, eliminating manual intervention. Saved 1 hour per day.

Increased targeted marketing effectiveness by 35% by developing customer segmentation models using Azure Databricks and Power BI.

Created interactive Power BI dashboards, enhancing data accessibility.

Built a comprehensive Data Dictionary and reporting infrastructure from the group up, Improving business efficiency by 50%.

Business Intelligence Analyst

Pairview, London, UK
Apr 2020 - Mar 2021 · 11 months

Conducted detailed customer analysis and built a Power BI dashboard, identifying targeting opportunities that led to a 10% increase in market penetration for key products and segments.
Automated ETL tasks using the Panoply cloud data platform, saving 15+ hours of manual work per week.
Implemented stored procedures and views to streamline data retrieval and improve query runtime by 30%.
Utilised SQL queries to extract, manipulate, and summarise data from databases; handled random samples and aggregated data for 20+ analytical reports.
Managed an average of 10 ad hoc requests per week without missing a deadline.

Compliance & Audit Consultant

Momenta (Deloitte), Crawley, UK
Sep 2018 - Jan 2020 · 1 year 4 months

Developed Excel dashboard resulting in a 50% increase in trend visibility.
Conducted trend analysis across streams, identifying Fail patterns and reasons leading to a 25% improvement in departmental quality.
Data extrapolation, consolidation, and cleaning using advanced Excel functions saving 7+ hours of manual work per week.

Business Analyst

Contractor
Nov 2012 - Jun 2018 · 5 years 7 months

Worked with some of the biggest names in the UK banking sector including Barclays, Lloyds, Santander, Clydesdale and Yorkshire Bank across different sites as a Business analyst.
Designed a process checklist to review before submitting cases.
Trained and supported the external auditors on internal policies improving the quality to hit 95% SLA target.
Created and maintained project documentation, including business requirement documents, process flows, and user manuals.
Preparing high-level reports highlighting quality concerns and recommending appropriate action plans intended to reduce the number of outcome errors.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Python Structured Query Language (SQL) Key Stakeholders Presentations Data Analysis Skills Power BI Process Optimization Techniques Tableau Databases MySQL SQL Server PostgreSQL Microsoft Power BI Pandas NumPy Microsoft Excel Microsoft Azure Databricks Azure Data Lake Data Warehouse GitHub Google Analytics Market Basket Analysis Customer Lifetime Value (CLTV) Interactive Dashboard and Visualisation Customer Segmentation Market and Competitor Analysis Data Cleaning Process Automation
Report this Profile?