Pranav Arora Email and Phone Number

• Streamlined Financial operations by accurately gathering/analyzing business requirements and engineering a comprehensive Data Warehouse solution within a team of developers and data scientists.• Developed an ETL Pipeline using Python and PostgreSQL, integrating an efficient data transfer algorithm to improve query performance for reporting by over 50%.• Designed the Warehouse's Entity Relationship Diagram (ERD) by leveraging Kimball's Star Schema Dimensional Data Modelling techniques.

• Generated $23,000 in sales from high value contracts, closing deals with 40 cold leads in one month, by implementing specialized sales techniques such as sales cycling, objection handling, and various closing styles.• Surpassed weekly sales targets by canvassing over 60 hours per week and working during weekends.

• Led a data migration project reporting to the CFO, and transitioned over 500,000 lines of personal client data to a new portfolio management application for Family Office advisors, enhancing data accessibility• Consolidated and validated diverse data sets, reducing error margins to less than 2% by developing robust Python and VBA scripts to automate data extraction from multiple sources, including PDFs and spreadsheets

Supervised my team and delegated tasks related to R&D for producing our podcast andaffiliated merchandise