Deep Mehra Email & Phone Number

Lake Oswego, Oregon, United States

Durham, Nc, Us

San Francisco, Ca, Us

I transitioned to the Data Engineering team to build Data Warehouse for Techsoup’s financial systems. Major tools: Snowflake, Python, Informatica Cloud, SQL Server• Took full ownership of the data warehouse, streamlining processes and implementing best practices in data governance to support product and commercial teams with user-friendly, actionable insights.• Utilized Snowpipe to automate ingestion of more than a million rows from S3, reducing stage load time by more than ~40%• Develops data cleaning and validation tasks in Python before loading the data into Snowflake.• Ensures data integrated from Data Lake is mapped adheres to the data policies, standards and Quality using Informatica Cloud.• Develops Stored Procedures in SQL to facilitate automated reporting queries from fact and dimensions.• Manages users and assigns roles on Snowflake to different teams based on their department.

San Francisco, Ca, Us

Collaborated with product teams on consumer insights, managed data repositories, & generated successmetric reports for monetization & product initiatives using SQL, Python, A/B Testing, & Power BI..Major tools used: Power BI, SQL, Python, SSIS, SSRS• Designed measurement system to track performance bottlenecks in Power BI and give insights on user’s engagement for online courses of over 50000 users.• Wrangled data in Pandas DataFrame to allow easy EDA and visualizations in Seaborn.• Elevated user engagement for 50000+ online course participants by ~10% in 3 months through targeted A/B Testing and presented the outcomes via Power BI to the stakeholders.• Managed Zendesk for internal users and translated business requirements into reports using Power BI, SQL, and SSRS.

Richardson, Texas, Us

While pursuing my Master’s full-time, I served as a Data Analyst where I focused on automating and streamlining processes for the Student HelpDesk. Utilizing Power BI, Excel, and SQL, I delivered significant enhancements in operational efficiency and data management. • Drove efficiency: Implemented automation and visualization dashboards in Power BI to optimize workflow processes. • Reduced overhead: Automated the quarterly review process for helpdesk staff, decreasing organizational overhead by 30%. • Enhanced reporting: Managed the design and daily delivery of metrics reports using advanced Excel functionalities, improving data accessibility and decision-making support.

Richardson, Texas, Us

Copenhagen, Capital Region, Dk

Saxo Bank is a major Danish investment bank specializing in online trading and investment. As a data analyst/data engineer, I made it my mission to deliver key data, insights and metrics to our Products business leaders so they could make informed business decisions.Major Responsibilities: Data Engineering:• Developed and monitored databases to facilitate efficient financial performance for 100+ traders• Built systems and scalable pipelines by leveraging big data technologies like Hadoop.• Led a team of 6 Agile developers and increased revenue by 6% by launching the bank’s business analytics services.• Served as a liaison between the stake holders and the developers for transition of business suited knowledge.Data Warehouse:• Used RDBMS and SQL to build and maintain an efficient and heterogeneous data warehouse 20+ TB in size.• Performed root cause analysis on failures in the data model/queries in SQL• Ensured project delivery within timelines and met critical business needs• Designed and deployed SSAS cubes using Kimball methodologies (Star and Snowflake schema)• Create stored procedures to handle daily data warehouse processes.• Implemented Error Handling in SSIS packages.

Pune, Maharashtra, In

• Created complex analytics dashboards, pulling data from 5 data sources to analyze the correlation and seasonality in customer usage patterns.• Performed ad hoc analyses for executive leadership team including pricing analysis and modeling, and historical performance• Utilized Power BI to perform data collection, data transformation and data loading on multiple sources of data• Designed and built data processing pipelines using tools & framework in the Hadoop ecosystem

Pune, Maharashtra, In

Birlasoft is CMMI Level 5 company that provides digital and information technology consulting, services, solutions and products for organizations across industries, worldwide.Fresh out of college, this was my first introduction to the IT world. I am very thankful to have joined a team of very competent BI developers. Here, I was able to leverage my passion for working with data, and ensuring it is presented in the best form for business suited measures. The best part was I gained a newfound skillset in ETL, SQL, Data visualization and understanding how businesses work in the consulting domain. Major Responsibilities:• Implemented a scalable ETL solution to compute the pricing and sales of each product category across the portfolio.• Improved the database response time by 20% through SQL query optimization.• Imparted training on Kimball architecture to new employees.• Designed end to end Data warehouse for clients implementing data modeling techniques like Star and Snowflake schemas.

Masters In Business Analytics, Business Analytics

Bachelor Of Technology - Btech, Electrical, Electronics And Communications Engineering