Karan Bahal

Business Development Executive

Dallas, Texas, United States4 yrs 9 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Expert in transforming data into actionable insights.
  • Proven track record in SQL query optimization.
  • Strong background in data visualization and analysis.
Stackforce AI infers this person is a Data Analyst with expertise in Fintech and data-driven decision making.

Contact

Skills

Core Skills

Data AnalysisSql

Other Skills

Adobe AnalyticsAlgorithmsAmazon Web ServicesAnalyticsArduinoBig Data AnalyticsBusiness IntelligenceCC++Cloud ComputingConsultingCustomer ServiceData AnalyticsData MiningData Science

About

Senior Data Analyst at PennyMac Loan Services, Ex Pricing Analyst Intern at Santander Consumer USA; Graduate with a MS degree in Information Technology and Management (MIS) from The University of Texas at Dallas. Philosophy: Transforming data into asset and decision science that help organizations resolve business challenges (reduce costs, improve customer experience etc.) and identify future opportunities (increase revenue, new products, etc). Technical Skills Programming: SQL (MS SQL, MySQL), Python (numpy, panda, scikit-learn, matplotlib), R (ggplot2, caret, leaps, mass) Tools/Technologies: Tableau, PowerBI, Qlik, MS Excel (pivots, lookups, VBA), MS Office Suite, MS Visio, MS Project Big Data Ecosystem: Hadoop, Spark, Hive, Impala, Flume, Pig Certifications: Google Analytics, Graduate Certificate in Business Intelligence and Data Mining Publications: 'Design of a five phase CMOS OTA oscillator' in IJERT journal, Volume 7, Issue 08, in August 2018

Experience

Pennymac

3 roles

Senior Analyst, Business

Oct 2024Present · 1 yr 5 mos · Dallas, Texas, United States

Analyst III, Business

Promoted

Apr 2023Oct 2024 · 1 yr 6 mos · Dallas, Texas, United States

Analyst II, Portfolio Strategy

Jun 2021Apr 2023 · 1 yr 10 mos · Dallas, Texas, United States

Santander consumer usa

Pricing and Analyst Intern

Jul 2020Aug 2020 · 1 mo · Dallas, Texas, United States

  • Supported the creation of complex queries using MS SQL Server and queried different databases
  • Modified existing SQL queries and optimized the code to improve the efficiency by 30%, also built new code to assist with ad hoc requests from the business
  • Analyzed data using MS Excel Pivot tables (slicing/dicing) according to business needs and created data visualizations
  • Automated and improved the existing processes used by SVP and VP to enable good business decision making
  • Analyzed changes in portfolio trends, tradeoff between pricing and volume and the factors on how it impacts overall profits
  • Assisted in planning the pricing, credit mix and return objectives by market for future originations
MS SQL ServerSQLMS ExcelData VisualizationData Analysis

Defence research and development organisation (drdo)

Intern

Jun 2017Aug 2017 · 2 mos · New Delhi Area, India

Education

University of the Cumberlands

Doctor of Philosophy - PhD — Information Technology

Jan 2024Jan 2027

The University of Texas at Dallas

Master of Science - MS — Information Technology and Management

Jan 2019Jan 2021

Guru Gobind Singh Indraprastha University

Bachelor of Technology - BTech

Jan 2014Jan 2018

Delhi Public School, Mathura Road

Physics

Jan 2000Jan 2014

Stackforce found 100+ more professionals with Data Analysis & Sql

Explore similar profiles based on matching skills and experience