Pallavi Sethi

Experience

• 

  Wipro Limited

  Oct 2012 - Apr 2015

  Software Engineer

  Project Details: Supply Chain Management (SCM) Logistics Division Cisco Systems Inc• Analyzed Logistic data to find the on-going issues and provide long term solution by amending the existing PLSQL scripts, reducing user tickets by 20%• Successfully managed ETL process by pulling large volume of data from the lower Oracle version(11i) into staging database, performed various data transformation before loading it into Oracle R12 version• Performed Exploratory Statistical analysis to build reports/dashboard for revenue monitoring by ingesting data from Oracle Database, recommending actionable strategies for the upcoming quarter• Created Oracle Executable and Concurrent Programs for automating recurring long-term issues resolution, reduced 20% manual efforts Show less

• 

  The University of Dallas

  Jan 2021 - May 2021

  Data Analyst

  Project Details: The Office of Institutional Effectiveness (OIE)• Use Data mining techniques to perform statistical analysis on student census data, to build reports on student distribution and segmentation for federal & state compliances entities• Improved existing reporting system by incorporating advanced SAS features such as MACROs, joins, PROC SQL, proc tabulates.; transformed data to build quality reports on the student cohort• Developed a Classification data model to predict the possibility of students graduating, based on the number of credit hours taken, GPA, financial aid availability, and other demographic factors. Show less

• 

  NielsenIQ

  Jun 2021 - Mar 2022

  Statistical Operations Analyst

  • Identify deficiencies and areas for improvement, automated in-place operations procedures to find ways to improve operations, thereby reducing manual efforts• Analyze weekly report for highlighting trends in the ACV(All- commodity values) from individual store level up to larger geographical markets for Nielsen cooperating US retailers• Maintain Nielsen Store Universe, to represent the changing marketplace in the operation processes and provide actionable insights to the clients(US Retailers).• Presented data stories to the Nielsen leadership team, using KPI metrics dashboards to help them make decisions on fund allocation strategies for acquiring data from new retail businesses. Show less

• 

  Citi

  Mar 2022 - now

  • Vice President Credit Risk

    May 2023 - now

  • Assistant Vice President, Credit Risk US Branded Cards

    Mar 2022 - May 2023