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