Badges
Certifications
Work Experience
Data Analyst
Infodia Technologies• December 2018 - September 2020
Part of Azure framework projects: ● Leadership Skills and Stakeholder management: Spearheaded the business requirement gathering processes with stakeholders, defining success metrics, requirement analysis with the relevant team and addressed key client issues with 95% customer satisfaction. ● Utilised Databricks to extract, transform, and load (ETL) data from various sources into a centralised database for analysis. ● Developed automated data pipelines for faster cleaning and transformation into a digestible format using Python, leading to a 24% decrease in processing time. ● Optimised Data pipeline using Delta Lake and partitioning. ● Persuaded clients to opt for Power BI for visualisations, resulting in a 5% reduction in budget. ● Analytical skills and Creative skills: Worked collaboratively with cross-functional teams to identify patterns in customer segmentation, sales trends and identified top-selling products using Power BI and advanced excel functionalities,e.g. Pivot, lookup etc., leading to 11% increase in sales. ● Pioneered, published and maintained comprehensive and highly interactive data-driven Power BI reports and dashboards with key KPIs. ● Communication skills and Presentation skills: Communicated business insights and recommendations to technical and non-technical stakeholders using clear and concise PowerPoint presentations with data visualisation, to facilitate informed decision-making and improve customer engagement.
SQL Developer
MassBrain Systems Pvt Ltd• September 2015 - November 2018
Part of multiple On-Premise projects for Oracle Technologies and MS SQL Server: ● SQL Proficiency: Developed stored procedures and complex SQL queries for large datasets for optimal extract, transform and load i.e. ETL from multiple sources using SSIS, created data models, (ER modelling), resulting in MI improvement of 32% in organisational performance. ● Experienced in triggers, views, joins and subqueries and optimising SQL queries. ● Delivered custom PL/SQL codes for data conversion, data manipulation, data cleaning and data validation, and documented errors and standards, with improved data accuracy by 10%. ● Experienced in Kimball's data modelling for databases. ● Mentored 10 new joiners as Junior SQL Developers. ● Project Management skills: Delivered solutions 2 days ahead of the deadline by prioritising agile project tasks for the team and delivering daily, weekly and monthly reports to the client, as a team lead. ● Utilised JIRA for Sprint planning and to assign team with user stories from product backlog, and redesign using feedback. ● Team work: Collaborated with a cross-functional data analyst team to manipulate, clean and transform e-commerce data to analyse data trends, patterns and risks using SQL (joins and subqueries) and Python. ● Documented anomalies, errors and risks and flagged them for investigation and future references. ● Maintained Tableau dashboards and produced business insights to solve complex business challenges and facilitate data-driven decision-making, using Tableau, which led to an increase of 10% in revenue. ● Managed and prioritised workload to meet changing demands, target deadlines and SLAs. ● Demonstrated good problem solving and attention to detail skills.
Education
University of Texas at Austin, Austin
CLOUD COMPUTING, MS• November 2021 - October 2022
University of Sheffield
Data Science, MS• October 2020 - October 2021
Guru Gobind Singh Indraprastha University
Information Technology, B.Tech• September 2011 - August 2015
Skills
kumarpreetilata2 has not updated skills details yet.