Data Analyst Supply Chain

Nishit Ajmera

Harrison, NJ 267-***-**** ******.*****.******@*****.***

Summary

Data Analyst with 5 years of experience leveraging SQL, Tableau, and Python to solve problems and deliver insights-driven solutions. Proven ability to drive process improvements across diverse industries, including supply chain, e-commerce, and finance. Skilled in turning data into actionable insights that enhance operations and support business goals. SKILLS

• Programming Languages: SQL, Python, R Programming

• Databases: Microsoft SQL Server, Snowflake, Redshift, Teradata, Synapse Analytics, PostgreSQL, MS Access, Cassandra

• BI/Analytics Tools: Tableau, Power BI, MicroStrategy, Visual Studio (SSIS, SSAS, SSRS), Alteryx, Informatica, Talend, Excel

• Other tools: GitHub, Bitbucket, JIRA, Confluence, Collibra, Alation, Figma, Visio, Trello EXPERIENCE

Barclays Bank Plc, Whippany, NJ March 2022 – Present Business Insights Analyst

• Designed complex SQL queries to identify $12 billion in overdue loan fees, developed logic to classify lending facilities into accruing, non-performing, or repossessed categories, streamlining debt recovery efforts for the loan operations team.

• Engineered ETL pipelines to detect transaction breaks based on age, invoice type, counterparty name, and amount, in the loan operations process, helping stakeholders meet their SLA of clearing 90% of cash breaks received each month.

• Partnered with data engineers to migrate loan operations data from Teradata to Snowflake, created data marts to automate exception reporting through Tableau, replacing Excel reports and improving reporting efficiency by 75%.

• Automated regulatory reports preparation using Python scripts, reducing reliance on manual reports, lowering error rates in submissions to the Federal Reserve Federal Reserve, mitigating regulatory risk to Barclays.

• Developed secondary loan trading dashboards in Tableau using custom SQL queries in Snowflake, encompassing reports like new positions, unconfirmed trade exceptions, pre-funding details, position balance and broker trade summaries.

• Created dashboards focused on Key Risk Indicators (KRIs) for wholesale lending operations, tracking metrics like non- performing loans (NPL) ratio, exposure distribution, loan trade settlement times and delayed reconciliations. Vivint Smart Home, Provo, UT January 2021 – March 2022 Business Analyst

• Developed ETL process to integrate data from disparate sources (Salesforce, Workday, Qualtrics) to create data marts for automating reporting for sales operations, reducing new subscriber acquisition cost by 81%.

• Collaborated with the sales operations team to deliver user journey-based insights that directly contributed to a 50% increase in customer retention.

• Analyzed correlation between different metrics to isolate relevant product KPIs and built scorecards using Tableau.

• Utilized statistical models to create dashboards and provide recommendations on optimizing schedule for 2500 field employees, reducing drive times by 40% and increasing work orders fulfilled by 15%.

• Prepared comprehensive reports using SQL and Tableau to analyze product defect data and provided recommendations to capture $300,000 yearly in missed chargeback opportunities.

• Built aging inventory dashboards in Tableau using backend SQL queries, identifying 75,000 sq. ft. of potential space savings through collaboration with the supply chain operations team. Volvo Group, Jacksonville, FL August 2019 – December 2019 Service Market Logistics (Data Analyst) Co-op

• Consolidated and automated multiple supply chain performance reports in Power BI, by integrating Excel sheets into Teradata using Python, TPT and SQL scripts for ETL, reducing order backlog and stock-outs by 25%. EDUCATION

Northeastern University, Boston, MA Master of Science in Engineering Management May 2020 University of Mumbai, India Bachelor of Engineering in Electronics Engineering November 2017

Contact this candidate