Preeti Jain Email & Phone Number

Palo Alto, California, United States

• Skilled in managing batch and real-time pipelines using Java, Spark, Druid, and Flink, handling daily ingestion of 25 billion events and managing around 8 petabytes of data.
• Collaborated with product management, GTM, and front-end engineering teams to simplify and rebuild the Raw Data Export API, using modular code and Spark on EMR. This effort resulted in a 50% reduction in operational.
• Developed and maintained an Apache Airflow platform of 200+ DAGs. Increased observability by integrating Telegraf for real-time monitoring and alerting, and custom spark operator to capture logs from EKS, which helped.
• Developed a platform that allowed customers to use Airflow to schedule Spark jobs on Kubernetes. This platform had features like logging, reporting, metrics, alerting, debugging, retries, etc, built in so that.
• Strengthened the BI team's capabilities by introducing a data cataloging and discovery solution. Led the evaluation of technologies through independent POCs and successfully implemented OpenMetadata.
• Developed a customer-facing data product with both synchronous and asynchronous APIs for aggregated data export, leveraging Java, spark SQL, and Druid. Oversaw product management by identifying requirements, engaging.

Mountain View, CA

• Worked on and maintained the primary big data pipeline including debugging and troubleshooting issues such as optimizing EMR, MapReduce performance tuning, optimizing Hive queries, schema evaluation, etc. (1.5 to 2 PB.
• Provided end-to-end support and guidance to hundreds of internal customers (data scientists, data analysts, engineers, product managers, quality engineers) to migrate from on-prem systems to the EMR platform we created.
• Designed and developed a framework for launching transient EMR clusters which lowered total cost of ownership and maximized flexibility for applications.
• Updated the Intuit EMR framework to ensure data is encrypted in transit and at rest by eliminating insecure TLS versions throughout the application stack and updating AMI to use encrypted EBS volumes.
• Developed a Hive UDF in Java for standardized encryption and decryption in the Intuit data lake.

Mountain View, CA

• Designed comprehensive regression and integration test plan for an ETL pipeline comprised of multiple data sources, Java, Python, Sqoop, Hadoop, and Hive.
• Implemented and automated tests using pytest, and helped further automate execution of these tests using Jenkins, Vagrant, and Tox.
• Identify bugs using white and black box testing methodologies and thoroughly document in JIRA.
• Verify data quality in production systems post deploy using python scripts.

San Francisco

• Maximized revenue for two hotels using sensitivity/pickup analysis to monitor market trends and demand and adjusting prices accordingly.
• Modernizing analytics for the hotel by creating a SQLite analytics database that combines data from multiple sources to allow easier retrieval and web based reports.
• Directly managed two Reservations Agents responsible for managing incoming reservations.
• Ongoing study on impact of AirBnB on hotel industry using Amazon Mechanical Turk and a MySQL database for collection and storage of data.
• Managed data gathering, formulation, and standardization for a Year-over-Year and Day-of-Week analysis of Group Occupancy rates to forecast better rates in 2016.

San Francisco

• Conducted qualitative analysis of financial data to forecast revenue, identifying future trends, and assess risk associated with capital expenditures and investment.
• Handled 50,000 lines of data and formulated new tracking and management reporting system to improve availability and accuracy of financial data, triggering 15% increase in accuracy.
• Developed detailed and accurate spreadsheet to identify trends, track the budget and develop forecasts for the sales team, reducing the time to manage such reports by 20%
• Consolidated, reconciled and analyzed monthly reports and budgets.
• Prepared Monthly Revenue, Budgeting, and Forecasting reports as well as cash flow analysis.
• Daily reservations tracking, checking for duplicates and tracking deposits.

Paris, France

• Data entry on Oracle 11i and project spreadsheets.
• Executing variance analysis to accurately balance project accounts.
• Coding invoices to accurate tax and general ledger accounts using Oracle ERP 11i.
• Preparing and reviewing all the weekly reports (Invoicing status Report, Labor Costs Report andPast Due Report) with extensive use of Excel.
• Payroll responsibilities: Review payroll reports and Timesheets for corrections before Payroll transactions. Ensuring all Labor Corrections are done accurately and in a timely manner (Using Oracle ERP)