Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Abhi Rampal

Sr Associate Wealth Management Analytics
Austin,TX

Summary

As a Business Intelligence professional with 6 years of experience, I am passionate about leveraging data to drive business growth and innovation. With expertise in data analysis, visualization, and reporting, I am dedicated to delivering insightful solutions that enable businesses to make data-driven decisions. My goal is to continue advancing my skills and knowledge in Business Intelligence, while contributing to the success of an organization that values data-driven decision-making

Overview

6
6
years of professional experience
6
6
years of post-secondary education

Work History

Sr. Associate

JP Morgan Chase &Co
Austin, TX
12.2022 - Current
  • Leading a team of analysts; responsible for designing, building, and maintaining ETL pipelines to automate manual processes and support the data driven decision making for wealth management business teams
  • Designed & developed Advisor metrics and performance dashboard to provide the top management insight into key business metrics and measure performance of individual advisors.

Business Intelligence Engineer -Supply Chain

Schlumberger Technology Corp
Houston, TX
03.2020 - 11.2022
  • Developed Schlumberger’s internal inflation monitoring system, querying Supply chain procurement data from 5 different business systems and created Global Inflation dashboard to track internal inflation as part of Planning & Supply chain KPO
  • Led Preferred Logistics Partner (PLP) program digitalization project, utilized Bonus Malus concepts to ensure Schlumberger remain in line with the market rates, resulted in reduction of spot bidding and live benchmarking against market rates
  • Created "Category Control Room", a business Intelligence platform for Global Sourcing teams to access a suite of business Intelligence Power BI dashboards, for reporting and decision making
  • Performed Index- based cost modelling for products & Services, by collecting/analyzing third-party price indices data and provide insights for strategic procurement actions to capture savings and mitigate cost increases
  • Created a Python based bot for clustered part description to optimize catalogs utilization
  • Automated various periodic reports for business analysis, developed, scheduled & tested Alteryx workflows
  • Work closely with Planning & Supply Chain teams and provide ad hoc analytical support

Inventory Project (ZIP) Analyst

Schlumberger Technology Corp
Houston, TX
02.2018 - 02.2020
  • Analyzed current inventory models and its corresponding annual spend value within Schlumberger’s (SLB) Chemical division to promote consignment-based inventory models with SLB suppliers, hence improving the cashflow by reducing financial inventory costs and lead time
  • Used Business Intelligence Reporting Tool (Microsoft Power BI) to create various analytical dashboards to measure the ZIP performance and depict critical Geo Market KPIs
  • Created a prescriptive opportunity dashboard to identify potential ZIP opportunities that can optimize the overall impact of ZIP on increasing Cash-Flow, decreasing inventory level and Lead Time
  • Calculated and monitored Days Stock on Hand (DSOH) for items in scope to measure the effectiveness of inventory models in reducing the total inventory cost

Supply Chain

Schlumberger Technology Corp
Houston, TX
05.2017 - 02.2018
  • Coordinated procure to pay function, work in conjunction with accounts payable and accounts receivable department in handling GRIR cleanup issues, inventory reconciliation of proppant at bulk plants and to bill the client in timely manner
  • Automated the Goods Receive (GR) process, by creating a validation tool in excel using VBA and created standardized templates in Innowera to link it with SAP for transactions

Education

Master of Science - Supply Chain Management

The University of Texas At Dallas
01.2015 - 12.2016

Bachelor of Science - Mechanical Engineering

Punjab Technical University
08.2007 - 05.2011

Skills

Microsoft Power BI, Tableau, Alteryx, MS Excel, JIRAPython, DAX, M querySnowflake, MS SQL Server, Teradata

Project Management

Accomplishments

  • Certifications:
  • Alteryx Designer Core Certification, CPIM-Basics of SCM (APICS), Certified in Transportation and Logistics (CTL), Lean Six Sigma

Timeline

Sr. Associate

JP Morgan Chase &Co
12.2022 - Current

Business Intelligence Engineer -Supply Chain

Schlumberger Technology Corp
03.2020 - 11.2022

Inventory Project (ZIP) Analyst

Schlumberger Technology Corp
02.2018 - 02.2020

Supply Chain

Schlumberger Technology Corp
05.2017 - 02.2018

Master of Science - Supply Chain Management

The University of Texas At Dallas
01.2015 - 12.2016

Bachelor of Science - Mechanical Engineering

Punjab Technical University
08.2007 - 05.2011
Abhi RampalSr Associate Wealth Management Analytics