SHIVAM MITTAL

Location

Seattle, WA
Jaipur, India
Education
    University of Washington-Seattle Campus
    June 2023 - June 2024
    degree
    Master's
    major
    Management Information Systems
    National Institute of Technology
Work Experience
    Google
    Data Analyst Student Consultant
    Seattle, WA, US
    March 2024 - present
    company
    Google
    title
    Data Analyst Student Consultant
    overview
    - Analyzed digital marketing data in Google Analytics to develop predictive models for building targeted ad campaigns using Python and SQL, increasing student admissions by 15% and donor funding by 10 - Collaborated with cross-functional teams to gather requirements and develop Tableau dashboards (DAX) for tracking KPIs (PPC, CTR), streamlining decision-making for non-technical stakeholders by 32% and increasing website traffic by 20
    GitHub
    January 2024 - February 2024
    University of Washington
    Financial Analyst
    Seattle, WA, US
    September 2023 - December 2023
    Garg Trading Company
    Business Analyst
    July 2020 - January 2023
Skills
A/B TestingAdvertising CampaignsAgile MethodologyAmazon Elastic Compute CloudAmazon RedshiftAmazon S3Amazon Web ServicesAutomationBilling ProcessesBudgeting SkillsBusiness AnalysisBusiness IntelligenceBusiness Process ImprovementCloud ComputingCustomer ExperienceCustomer Relationship ManagementCustomer RetentionDashboardsData AnalysisDatabasesData LakesData MiningData QualityData ReportingData VisualizationData WarehousingDecision Making SkillsDigital MarketingElectronicsExtract Transform Load (ETL)Financial Data AnalysisForecasting SkillsGithubGoogle AdSenseGoogle AnalyticsHuman Resources Information System (HRIS)Information SystemsIssue Tracking SystemsKey Performance IndicatorsKnowledge of Electrical EngineeringKnowledge of FinanceKnowledge of StatisticsLooker AnalyticsMachine LearningMacrosMarketing Performance Measurement and ManagementMarket SegmentationMatplotlibMicrosoft AzureMicrosoft ExcelMicrosoft SQL ServerMySQLNumPyPandasPivot TablesPower BIPredictive ModellingProfit MarginsPython (Programming Language)Relational DatabasesRequirements AnalysisRetail CommerceSalesSales PromotionSales TrendsSearch Engine MarketingSnowflakeSocial MediaSQL DatabasesStakeholder ManagementStatistical Hypothesis TestingStrategies of PricingStreamlineSuccess Driven PersonTableau (Software)Team ManagementTeam WorkingTime SeriesTradingVba Programming LanguageWeb TrafficsWorkday