Swati Gupta

Assistant Vice President (Senior Data Analytics Engineer) at Citi

United Kingdom

About

With 7 years of experience in data visualization, statistical analysis, and process automation, I am a dedicated and innovative Data Analyst. I possess strong analytical skills, with a proactive and problem-solving attitude, and a keen attention to detail. Additionally, I am skilled in stakeholder management and have excellent verbal communication abilities. In my previous roles, I have proven my ability to plan projects, gather technical requirements, and coordinate with business stakeholders in a Scrum (Agile) based fast-paced environment, to support business KPIs. My experience also includes developing dashboards using Tableau and Power BI, and extracting large datasets using SQL (MS SQL and MySQL databases) and Snowflake. Moreover, I am skilled in using Python and Pandas coding for automating data processing and analytics, leading to a reduction in operational costs and process improvements in a timely fashion.

Experience

  • AVP-Senior Data Analyst at Citi
    Aug 2023 - Present · 3 yrs

  • Senior Data Analyst at Upwork freelance
    Apr 2023 - Jul 2023 · 4 mos

    Use advanced Excel techniques, SQL, Python/Pandas to extract, clean and visualize data to project property income. • Using linear regression model to predict property income. • Using MySQL to fetch data and train data model. • Using Pandas to clean and merge various attributes of data set. • Updating model to improve its accuracy by tweaking its various features

  • Data Analyst at Micron Technology
    Sep 2020 - Feb 2023 · 2 yrs 6 mos

    • Contributed to the reduction of operation costs by writing Python scripts for process automation. Manipulated/wrangled data using Pandas and NumPy. • Reduced repetitive tasks of the Planning and Operations team by 40% using Tableau, RPA, and Python scripts. • Helped management make more informed decisions by providing better visibility of productivity gains of individual contributors. • Contributed to the development of dashboards using Advanced Tableau Techniques. • Wrote queries in Snowflake and SQL Server to extract data. Performed analysis using Statistics, Advanced Excel and Python/Pandas. • Participated in process automation for other teams using Tableau, Python, Advanced Excel and RPA. • Participated actively in managing projects which involved in gathering of requirements and interfacing with business units for information and feedback. • Conducted advanced Tableau LOD training, which eased peers' onboarding over it.

  • Analyst at PayU
    Feb 2015 - Nov 2018 · 3 yrs 10 mos

    • Identified fraudulent transactions and took necessary measures to protect the business from significant financial loss. • Boosted PayU product sales by 20% through careful analysis of merchant transactions and strategic proposal of effective solutions. • Conducted PayU gateway panel training for big merchants like Dominos, Myntra, etc. • Managed projects by performing requirement gathering by interacting with various merchants tied with the company using Salesforce CRM. • Used SQL/MYSQL to load data and Advanced Excel along with Power BI to gain the insights from the data using Statistical techniques. • Implemented Pandas and NumPy to generate various distributions and analyzed variance of business gained. • Collaborated with cross-functional teams for projects implementation and conducting testing techniques.

  • Product Engineer at HCL Technologies
    Jan 2013 - Feb 2015 · 2 yrs 2 mos

    • Worked for third party vendor Sprint Telecommunication company and used Citrix based environment for installation and disconnection of circuits. • Performed testing on live circuits after installation of the circuits. • Maintained all the records of the circuits to ensure successful completion with its SLA defined as per the process. • Utilized complaint data analysis to identify trends and successfully deployed solutions to address issues, leading to improved customer satisfaction. • Streamlined the onboarding process for new engineers by creating detailed documentation, resulting in a two-day reduction in overall onboarding time.