Amit Sachdeva Email & Phone Number

New York, NY, US

New York, NY, US

New York, NY, US

• Created client dashboards in Tableau, saving FTE payroll hours
• Established best practices for campaign data capture for reporting, optimization and predictive analysis
• Managed junior staff, delegating responsibilities and providing support
• Revamped reporting processes for improved efficiency, shortening turnaround time and decreasing costs
• Drafted company documentation on industry topics such as a cookie-less web, and the impact on the business
• Leveraged Python, Tableau, SQL for streamlining processes

New York, New York, US

• Built automated client dashboards in Tableau, resulting in $50K incremental for one client
• Designed, executed custom queries against datasets to derive actionable recommendations and insights to sales, account management, and supplier teams from Hive and Vertica
• Defined company standard for A/B testing, wrote documentation and provided internal training
• Managed junior staff analysts on workflow and provided feedback and best practices
• Presented analytical findings directly to clients including high level marketing executives

Playa Vista, CA, US

• Served as primary analytics resource to buyer team, including sales leads, account managers, and executive leadership on demand-side initiatives and investigations:
• Provided daily and weekly updates on shifts in spend among strategic partners to key stakeholders, business owners
• Identified wastes in ad serving costs and elevated findings to executives for action
• Provided weekly updates to account managers on how their accounts were pacing based on forecasts and actuals spend figures, using Snowflake and a shared document
• Developed collateral materials for company-wide buyer presentations on performance with top partners, publishers, and advertisers
• Collaborated across teams to monitor inventory quality control, impacts to the company’s bottom line

New York, NY, US

• Was the primary and often sole analytics resource for organization, mostly assisting the sales team in using data to inform client campaigns and marketing initiatives
• Utilized large search and campaign data sets to gain audience insights to inform media, search and creative strategies for advertising clients
• Presented customer behavioral findings to clients, along with actionable recommendations
• Worked on development of periodical client reports and analytic findings with engineering, product development teams
• Developed analytics POV for the company
• Created marketing materials from distilling terabytes of proprietary search data using Hive, Impala, Python

New York, NY, US

• Provided insights on campaign performance, site-side activity, creative and media optimization recommendations, landing page optimizations at the HTML level, and multivariate dynamic creative analysis on a range of.
• Created campaign success measurement proposals for in-market optimizations and post-campaign analysis
• Estimated required delivery for test plans in order to achieve actionable results
• Designed, specified requirements for database schema for automated reporting process, saving 800~1,200 man hours/year
• Delivered, presented key findings of numerous media and content initiatives, making recommendations to achieve goals
• Quantified opportunity for increased tourism through a poaching strategy targeting qualified prospects, accounting for competitor reaction

Boston, Massachusetts, US

• Designed test plans to measure differences in responses for direct mailings to loyalty rewards program and presented plan to client
• Designed, wrote code to extract loyalty membership renewal behavior and presented findings to client
• Constructed client presentations in PowerPoint using charts manipulated in Excel and SAS
• Designed and presented marketing test plans to clients
• Used data from DoubleClick/DART, Google Analytics, Omniture, and other vendors for the use of campaign reporting and analysis.
• Aided in campaign pitch for new business by mapping out strategy for specific channels of media campaign (i.e., social, search, etc) and forecasted sales based upon media plan

• Using SQL, SAS, Excel and PowerPoint, analyzed membership data and trends for clientpresentations and in the support of sales and new client acquisition
• Addressed ad-hoc inquiries from clients on specific marketing opportunities
• Performed statistical analysis of web site traffic to address internal and external requests
• Survey design and survey-results analysis
• Secondary market research in the health care and pharmaceuticals sector to aide and add insight to client deliverables.

Boston, Massachusetts, US

Created a database of all online higher education programs that offered degrees (i.e., associates, bachelor's, master's, doctorate), by institution and program area.

Boston, MA, US

• Analyzed and forecast market trends in the mobile communications industry, communicating these findings to internal and external stakeholders
• Collaborated with team members to address ad hoc requests from clients on specific inquiries
• Extracted and manipulated survey response data sets, performing tests of statistical significance and communicating these findings to clients and the news media
• Worked on development of a Sigmoidal-curve modeling tool that forecast market penetration of various mobile telecommunications technologies and devices

Boston, Massachusetts, US

• Supported efforts to develop a company intranet, including aggregating cross-functional information,collaborating on design, and maintaining up-to-date information
• Data review and analysis of internal survey results for training needs and requirements.
• Apex language programming for developing triggers in Salesforce CRM application.

Washington, DC, US

• Resolved network, hardware and software problems
• Supported and assisted users with new applications and training on new tools
• Designed and ran queries on optical character recognized subpoenaed documents upon attorneys' request

Master Of Arts, Economics

Bachelor Of Science - Bs, Economics

Diploma