Zalak Jayantibhai Patel: Data Analyst Intern

• Investigated various metrics to assess campaign performance such as Unique Click Rate, Click-to-Open Rate etc. for Levi Strauss & Co. and its subsidiary Dockers run frequent email marketing campaigns aimed at generating online revenue • Worked with business customers to gather requirements and deliver complete data reporting and analytical solutions • Learned why customers are asking for data and what their underlying questions and business goals are • Owned the design, development, and maintenance of ongoing metrics, dashboards, and analyses used to drive key business decisions • Recognized and adopted best practices in reporting and analysis, including data integrity, accuracy, and reliability, as well as documentation • Drive data democratization throughout the organization, enabling others to self-serve their data needs, Worked on a dataset consisting of 5 years (2016-2020) of data with around 1500 images of campaign creatives

• Developed advanced SQL queries, stored procedures and database views to generate data reports for building a financial prediction model using SQL and Python with approx. 70% accuracy for minimizing the risk of losing money while lending to students. • Performed SQL query performance tuning by creating/modifying indexes, setting transcation totals, and changing query structures, Created project plans in accordance with project management framework standards and procedures. • Used Machine Learning tools to analyze and make data-driven recommendations and decisions based on our students' journey and purchasing behavior, demand forecasting, pricing, product testing, product attributes • Created ad-hoc reports using Excel, Power BI, and Tableau per startups based on business requirements to lead functional teams in the development of standards, policy, and procedures. • Built ETL process to migrate data from multiple types of data sources (SQL Server, DB2, Oracle, Excel, Flat Files, Email Boxes, etc.) for translating business user concepts and ideas into comprehensive business requirements