Ananya Mishra

• Contribute to migration of data warehouse from AWS Redshift to Snowflake (SQL, Terraform, BuildKite)
• Create, deploy, monitor, and debug ETL pipelines using Prefect workflow automation and Fivetran to bring in data from 3rd party sources and other internal teams (Python, SQL)
• Develop new models and improve upon existing business objects in conjunction with analyst team using dbt ELT analytics layer (SQL, jinja)
• Decommission visualization layer on Metabase and move analytics content to Looker (Python, SQL)

• IoT/Wearable Biometrics Manufacturer (6 months)
  Main projects included rearchitecture of partner data sharing platform on AWS Lambda and upgrades to data sharing REST API on AWS API Gateway, as well as client technical advisement on API usage best practices.
  
• Remote Job Recruitment Platform (6 months)
  Primary responsibilities included maintenance of analytics platform on dbt Cloud and migration of Salesforce integration to Hightouch reverse ETL platform for improved consistency. In addition deployed several auxiliary microservices in support of data platform using Docker/Terraform.
  
• Major Online Music Retailer (6 months)
  Assisted in development and migration of ETL pipelines on legacy Pentaho platform to modern Google Cloud BigQuery tasks

• Collaborated with Data Engineering team on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability (Python, Airflow)
• Addressed ad hoc analytics requests and facilitated data acquisitions to support internal projects, special projects and investigations.
• Contributed to internal activities for overall process improvements, efficiencies and innovation.
• Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines including HIPAA and SOX.
• Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.

• Built cohesive data platform based on Amazon Redshift to integrate analytics across the organization including operations, sales, merchandising, and marketing data
• Implemented & evangelized Apache Airflow for superior management of ETL tasks and centralization of data transport across the engineering organization
• Created analytical models based on user behavior data to fuel growth and increase customer retention

• Responsible for device analytics platform and infrastructure
• Implemented realtime log processing and data visualization architecture utilizing Google Protobuf, Python, AWS Lambda/Redshift/Kinesis, LogEntries, and open source tools such as Apache Airflow and Airbnb's Superset
• Built platform to monitor manufacturing test processes and prevent anomalies in end-user experience
• Created dashboards used company-wide and by C-suite to monitor device performance in the field
• Empowered firmware team to iterate quickly using realtime statistics on device performance characteristics
• Contributed to open source projects such as Apache Airflow.

• Responsible for conducting proofs-of-concept and demos for enterprise and technology customers
• Led technical discussions with customer development teams as product expert on MemSQL
• Integrated product into customer environments by architecting schemas and optimizing SQL for distributed architectures
• Built realtime data pipelines by leveraging open-source tools such as Apache Kafka and Spark
• Prototyped future product features by writing Python and bash scripts to automate database operations
• Demoed business intelligence capabilities of MemSQL by integrating Tableau, Looker, MicroStrategy, etc.
• Project managed product fixes and enhancement requests, escalating to Engineering when required.

• Dean's List
• Recipient of Cornell Alumni Association of Greater Houston scholarship

Underwent a 12-week immersive program (graduated early at the 6-week mark) covering the following topics:

• Exploratory Data Analysis and Software Engineering Best Practices
• Statistical Inference, Bayesian Methods, A/B Testing, Multi-Armed Bandit
• Regression, Regularization, Gradient Descent
• Supervised Machine Learning: Classification, Validation, Ensemble Methods
• Clustering, Topic Modeling (NMF, LDA), NLP
• Network Analysis, Matrix Factorization, and Time Series
• Hadoop, Hive, and MapReduce
• Data Visualization with D3.js, Data Products, and Fraud Detection Case Study