Sr. Engineer (Data and Business Analyst)

Vishruti Patel

Dublin, CA ● 310-***-**** ● ****.*****@*****.*** ● LinkedIn ● Github ● H1B

ABOUT ME

Sr. Engineer with 5+ years of experience in Data Engineering, Analytics and Project Management, specializing in building scalable ETL pipelines, optimizing data workflows, and delivering actionable insights. Proficient in SQL, Python, PySpark, and cloud data platforms like Snowflake and BigQuery, with expertise in data modeling, business intelligence, and KPI tracking to drive strategic decision-making. Skilled in Agile, Scrum, risk mitigation and process optimization, ensuring the efficient execution of data initiatives. Passionate about leveraging AI-driven analytics and automation to enhance data quality, reporting, and operational efficiency while aligning data strategies with business goals.

CORE COMPETENCY

Technical and Data Engineering Expertise

ETL pipeline development, SQL & Python(PySpark), Data Modeling, Data Warehousing, Stream Processing(Apache Kafka), Feature Store Collection, MLOps, Cloud Computing, Data Governance, and Technical Documentation. Analytical and Business Intelligence

Data-driven decision making, business analytics, KPI monitoring, trend analysis, predictive analytics, data visualization, dashboard reporting and performance metrics.

Project Management

End-to-end lifecycle management, strategic planning, budget management, risk assessment, change management, resource allocation, vendor management, and Agile/Scrum methodologies.

Stakeholder & Team Leadership

Cross-functional collaboration, executive communication, stakeholder engagement, team mentoring, and conflict resolution. TECHNICAL SKILLS

Programming Languages Python, SQL, Shell Script

Databases & Data Warehousing PostgreSQL, MySQL, Redis, Cassandra, DuckDB, Snowflake, Cloud Data Lakes, Big Query ETL & Big Data Technologies Apache Spark, Apache Kafka, Airflow, ETL, Data Pipeline Development(Batch/Stream) Data Visualization & BI Tableau, Looker, Microsoft Excel, PowerPoint, Jupyter Notebook Project Management Tools JIRA, Confluence, ClickUp, Agile, Scrum, Kanban, Sprint Planning & Review, Risk & Issue Management, Resource & Budget Tracking

Cloud & DevOps

AWS S3, GCP GCS, Datadog, Harness, CircleCI, Docker, Kubernetes Web & API Technologies REST, GraphQL, HTML, CSS, JavaScript Other Tools: VSCode, PyCharm, DataGrip, Git, LucidChart PROFESSIONAL EXPERIENCE

Sr. Engineer @Agero Inc, San Francisco, CA Aug 2019 - Present

● End-to-End Project Leadership: Directed full lifecycle program management by defining scope, planning sprints, managing risk, and coordinating cross-functional teams to ensure timely project delivery.

● Strategic Data-Driven Decisions: Developed and optimized Tableau dashboards to track KPIs (customer demographics, operational metrics, resource allocation), resulting in a 15% improvement in overall efficiency.

● ETL & Data Pipeline Management: Designed and maintained robust SQL and Python-based ETL pipelines, ensuring high data quality and enabling predictive analytics and trend analysis for data science teams.

● Stakeholder & Executive Engagement: Collaborated with business stakeholders and senior leadership to translate complex technical data into strategic initiatives and actionable insights, fostering data-driven decision making.

● Process Improvement & Risk Mitigation: Implemented anomaly detection and automated reporting processes to reduce data defects by 70% while proactively managing project risks and change requests.

● Team Leadership & Mentorship: Led agile transformations, conducted sprint planning and reviews, and mentored team members through pair programming and technical documentation best practices. Student Assistant Analyst @Pollak Library, Fullerton, CA. Sept 2018 – May 2019

● Automated Data Extraction & Analysis: Spearheaded the design and development of Python-based web crawlers (using BeautifulSoup and Selenium) to automate data extraction, enhancing data collection efficiency.

● Cross-Functional Collaboration: Partnered with library and academic stakeholders to define project requirements, ensuring that data cleaning, storage, and reporting aligned with strategic institutional objectives.

● Process Optimization: Streamlined data preprocessing and database organization to facilitate immediate access to analytical insights and reporting.

Data Analyst Intern @Lucky Bucks LLC, Atlanta, GA. May 2018 - June 2018

● Data Validation & Cleansing: Improved data accuracy through rigorous validation and cleansing processes, laying the groundwork for high-quality data analysis.

● Interactive Reporting: Engineered SQL queries and developed interactive dashboards to monitor KPIs, support business intelligence, and drive organizational growth.

● Effective Communication: Presented analytical findings and strategic recommendations to stakeholders, enabling data-driven decision making and process optimization.

PROJECTS

User Engagement Analysis (Data Visualization, KPI Tracking, A/B Testing, Agile Project Management) Developed dashboard to visualize user engagement trends, revealing a 15% increase in engagement for multi-content recommendations. Analyzed a large dataset using SQL and Python to optimize content strategies and improve CTR by 12%. Financial Data Analysis (SQL, Tableau, Financial Analytics, Data-Driven Decision Making, Process Improvement) Designed an interactive dashboard using SQL and Tableau to analyze ecommerce quarterly revenue dataset, showcasing business analytics on 10% unnecessary expenditure and strategies for optimizing revenue tracking by defining new KPIs. SentimentAnalysis-AmazonReviews (Python, Pandas, Tableau, Data Governance, Predictive Analytics) Performed old school sentiment analysis on approximately 1 billion Amazon Kindle product reviews dataset using scikit-learn. EDUCATION

California State University, Fullerton, CA Master of Science, Computer Engineering May 2019 Gujarat Technical University, Gujarat, India Bachelor of Engineering, Computer Engineering May 2016 LEADERSHIP EXPERIENCES

Agile Transformation & Scrum Leadership

Led agile adoption and sprint planning initiatives, increasing feature delivery by 20% per release and fostering a culture of continuous improvement.

Diversity & Inclusion Champion:

Co-led Agero’s D&I initiative to promote cultural awareness and improve team cohesion.

Contact this candidate