Siddharth Agarwal

Experience

• 

  Insta Digital

  Jan 2015 - Feb 2016

  Business Analyst Intern

  Project: Kiah Diamonds• Created engaging social media strategies and execution plans that became a catalyst to customer growth by 30%.• Assisted the company’s business development in landing clients by developing proposals within the digital marketing segment.• Handled day-to-day Search Engine Marketing (SEM) activities including campaign planning, implementation, budget management, performance review and optimization and managed social media accounts for international clients.• Coordinated with Marketing and Sales teams to analyze efficacy and Return on Investment (ROI) of all brand management events.• Spearheaded Kiah Diamonds lead campaign which accelerated the sales to their Amazon and Flipkart landing pages by 35%. Show less

• 

  Violet Info Systems Pvt Ltd.

  Mar 2017 - Aug 2017

  Business Analyst

  Project: Customized Web and Mobile Application• Successfully handled and managed SDLC of customized web and mobile application.• Gathered client requirements, designed wireframe, provided solutions and translated the requirements to the development team.• Developed business architecture using industrial requirements such as scope, processes, alternatives, and risks.• Conducted 4+ levels of testing including alpha, beta, functional, user acceptance (UAT), integration and performance.• Analyzed, cleaned and integrated user database consisting up to 8000 users and performed data wrangling using Oracle SQL Developer, Tableau advanced Excel, including VLOOKUP, HLOOKUP functions and Pivot tables.• Created and organized Business Requirement Document (BRD), FRD, System Requirement Specification (SRS), System Requirement Document (SRD), Proposals, Scope, Process and Workflows, UML and ER diagrams using Microsoft Visio.• Systematized Learning, Training and Knowledge Management System (LMS/TMS/KMS) which consisted up to 10,000 users. Show less

• 

  USF CONNECT

  Nov 2017 - May 2018

  Market Research and Data Collection Assistant

  • Handle, maintain and develop Customer Relationship Management (CRM) system, database and dashboards for USF CONNECT.• Develop and create statistics and analysis of weekly, monthly and quarterly financial and metrics reports and dashboards.• Analyze analytics and reports on Facebook, Qualtrics, Survey Monkey to gain insights, demographics and recommend future trends. • Conduct market research and develop and analyze survey, including incubator client and event satisfaction survey.• Assist prospective incubator clients with event planning and execution. Show less

• 

  Carnival Corporation

  May 2018 - Dec 2018

  •Reviewed and analyzed the data warehouse, monitored portals, developed reporting mechanism and created analytical reports as per the requirements. •Wrote complex queries to extract data using Oracle SQL Developer and performed analytics on extracted data. •Reviewed, analyzed and performed visual analytics on Shipboard Marine Operational Excellence Program survey and Deck and Engine 4FUNDX rollouts.•Develop analytical dashboard and metrics using advanced Tableau, Power BI and Microsoft Excel. Show less

  • Performance Analytics Analyst

    Sept 2018 - Dec 2018

  • Project Analyst

    May 2018 - Aug 2018
• 

  JPMorgan Chase & Co.

  Jan 2019 - now

  • Data Engineer

    Jan 2020 - now

  • Compliance Reporting and Analytics Sr. Associate

    Jan 2019 - Dec 2019