Samantha Tseng Email & Phone Number

Smyrna, Ga, Us

Redmond, Washington, Us

San Francisco, California, Us

- Develop end-to-end data pipelines using Apache Beam, Dataflow, and BigQuery- Collaborate with Software and Product teams by creating logging specs and technical docs, reviewing new features and improvements, and sharing priorities to build the best possible solutions- Work with infra to make updates to our environment as needed for data solutions

Menlo Park, Ca, Us

Instagram Org:· Design, create, and validate extensive new pipelines by writing SQL and Python code and performing in-depth data validations during code review· Create and maintain dashboards with hundreds of monthly views for upper management and executives· Own and update critical data domain by creating roadmaps, communicating with stakeholders, and updating code based on company priorities· Update backend logging code (php/Hack) to bring new data into our pipelines· Write extensive documentation for each project, improving the usability for downstream users

West Hollywood, California, Us

• Build and maintain data pipelines for the analytics team using Hive, Spark, and Impala by working cross-functionally with infrastructure engineers and data scientists • Implemented PySpark job to pull and transform critical sales data from HDFS and stored it in Parquet files and tables, improving the runtime of downstream jobs by 2x and reducing input file size significantly • Debug and hot-fix errors in critical, time-sensitive pipelines used by the executive team • Construct Tableau dashboards to report product metrics to PMs and other stakeholders • Drive data quality best practices on analyst team and mentor junior analyst • Volunteer as Tableau on-call person granting licenses and permissions across our Tableau server

San Francisco, California, Us

• Identified, built, and monitored team KPIs to measure user conversion and team performance • Performed root cause analysis, demonstrated the health of aggregation, and derived product insights by pulling data from multiple Redshift DBs and building Metabase dashboards and visualizations • Influenced product and business direction by presenting analysis and proposals to key stakeholders • Investigated data aggregation related issues by exploring data logs and the backend codebase, creating tickets and communicating resolutions • Led weekly meeting to keep stakeholders up-to-date on data aggregation topics • Prioritized engineering tickets with the product team to resolve high-impact issues • Facilitated communications between engineering and business by bridging technical requirements and business needs • Managed relationship with our data aggregatorsFormulated strategies and solutions for data outages

Detroit, Mi, Us

• Managed company-wide data aggregation and reporting project as well as business plans for over 4,000 dealers• Accommodated shifting requirements and significant changes in external data sources by updating legacy scripts and processes• Worked closely with 2 other teams to ensure quarterly project was created, thoroughly audited, and delivered in a timely fashion• Delegated work and trained coworkers on larger projects in order to ensure breadth of knowledge on team and improve efficiency• Maintained strong relationship with my client by quickly responding to requests, answering questions, and ensuring the accuracy of our data.• Mentored and on-boarded 5 new hires on our team’s current processes• Selected as a mentor for the first intern partnership program due to reputation with coworkers and cross-team knowledge• Created estimates of effort and project mockups for client• Projected quarterly hour estimates for several projects

Detroit, Mi, Us

• Managed and drove 2 project teams composed of 5 market analysts by delegating work, communicating with clients, and auditing and delivering reports• Partnered with account executive to create a new market analysis project which resulted in higher customer satisfaction score, praise from client, and sales for 15 subsequent iterations for a new customer• Presented and shared insights from geography review to clients, both in person and remotely• Performed market analysis studies across the U.S. to determine optimal dealership network• Built and automated reports using SQL, SSRS, and SSIS decreasing potential time spent by 30-40%• Queried and manipulated data from large datasets across multiple servers and several databases• Wrote and performed various audits for data pushed to our client website• Kept documentation up-to-date

Schenectady, Ny, Us

• Researched Big Data and real-time analytics solutions• Refined presentation skills by presenting my research to the team• Compiled business specific use cases by communicating with sub-businesses to understand their needs• Evaluated the Big Data technologies and made recommendations to the team based on functionality and cost• Experimented with those technologies• Communicated with team members across the globe from New York, Georgia, California, India, and the UK

Bachelor Of Science (B.S.), Computer Science

Education record