Sonam Karia
San Francisco, CA 747-***-**** ***********@*****.*** LinkedIn: linkedin.com/in/sonamkaria, Profile GitHub: github.com/sonamkaria
Summary
Junior Data Analyst authorized to work for any employer in the U.S. enthusiastic about creating and delivering solutions to fulfill challenging business, customer, and technology requirements. Strengths include leveraging the power of data to build dashboards and data visualizations, solid analytical, creative and communication skills, in addition to business development and finance proficiencies. The ability to draw actionable insights from large data sets using Python, Excel, SQL, and Tableau, while working in a deadline driven environment.
Core Competencies
Data Analyst, Data Science, Data Visualization, Business Intelligence Analysis, KPI Analytics, CTR, CPC, CPM, ROI, Cost per Acquisition, Data Strategy, SQL, Python, Tableau, Excel, Analytics, R, Relational Database, A/B Testing, Database Organization, MySQL, NoSQL, SQLite, Sales, Marketing, Finance
Professional Experience
Compare My Rates Inc., Toronto, Canada March 2019-April 2020
Junior Analyst
Substantially improved decision-making capabilities for senior business leaders at Canada's largest rate and price comparison website in 2020 for the best mortgage rates, compare credit cards, internet plans, cell phone plans, Bank accounts, Investments, TV, and Phone Plans.
Built automated Excel, Google Sheets and Tableau dashboards utilized for optimizations and high-level trend analysis.
Participated in monthly client reporting with updates and implemented analysis for campaign performance.
Managed A/B testing analyzed and recommended changes which helped improve the overall conversion rate by 25%.
Contributed to designs of chart and table visualizations for sales presentations.
Improved overall website lead conversion rates by 25% by analyzing Google Analytics.
Obtained actionable insights for decision makers using SQL and advanced Excel techniques.
Consumer Debtor Protection of Canada, Toronto, Canada October 2017-March 2019
Account Executive, Consultant
Managed the largest tier 1 revenue generation clients and supported financial data for 150 + accounts for this consumer counseling company.
Led and enhanced relationships with existing and new insolvency firms which produced additional revenue streams estimated at $400K annually.
Promoted to Consultant and exceeded sales targets, achieved an 80% conversion rate, and met KPI goals.
Built scalable reporting templates used by account managers and cross functional teams.
Created financial budgets for clients and helped them stabilize and achieve their financial goals.
Analyzed aggregate sales data across the company to improve future processes and efficiencies for the book of business.
Dollar Financial Group, Toronto, Canada
Operations Manager June 2016-March 2017
Customer Service Representative Coach April 2016-May 2016
Customer Service Representative October 2015-March 2016
Promoted to perform historical sales trend analysis and implement new strategies that improved branch sales by 30% for this financial services company.
Performed market research to identify budget and local demographics and create a sales strategy.
Led weekly team meetings to review upcoming initiatives, created action plans, and analyzed previous quarterly reports.
Education, Certifications
Humber College, Toronto, Canada 2016
Post Graduate Diploma, Global Business Management
Mumbai University, India
Bachelor of Commerce, Accounts and Finance 2013
General Assembly, Los Angeles 2019
Data Science Immersive Bootcamp
Ryerson University, Toronto, Canada 2019
Data Analysis using R 2019
Computer Science, Python 2019
Data Organization for Data Analytics 2019
Google Analytics Academy
Google Analytics 2020
Udemy 2020
Microsoft Excel 2020
Tableau Training for Data Science 2020
The Complete SQL Bootcamp 2020
LinkedIn 2020
SQL Essential Training 2020
Learning SQL Programming 2020
SQL: Data Reporting and Analysis 2020