Angel Garcia

Brooklyn, NY ***** 917-***-****

www.linkedin.com/in/1Garcia adhus8@r.postjobfree.com

Associate Product Manager

Incite Action Based on Data-Driven Insights

Analytical self-starter proficient in identifying and implementing solutions to extremely difficult and time-consuming problems. Talented relationship builder skilled in acting as liaison between multiple cross-functional departments and clients in a fast-paced environment. Reputation as fast learner adept at seeing “the big picture” and creating solutions that improve operational efficiency and empowers users.

− UX Designer − Data Analysis

− Product Development − Logical thinker

− Problem Solving − Interdepartmental Collaboration Technical Skills

Software knowledge: HTML, CSS, Figma, Lucid Chart, JSON, SQL (SSMS) 2016, API (restful), Looker, Datawatch Monarch, Jira Agile /Scrum

Professional Experience

AppNexus, New York, NY 2019 - 2020

Sr Analyst - Product Support II

Coordinated with product and engineering in identifying, reporting, and resolving customer’s technical issues. provided post-implementation and product support to AppNexus customers in North America and South America.

• Provided troubleshooting assistance with cross-functional issues from impression counts, underdelivering, data segments across multiple publishers using APIs, MySQL, and the AppNexus UI; defining product goals.

• Consolidated outdated runbooks for those not familiar with advertising and new product releases by utilizing gifs and short videos while also mentoring interns. NAMELY, New York, NY 2016 - 2018

Lead Technical Analyst, Operations

Bridged gap between business and engineering in building / finding applications to improve product, business and operations. Created scalable models for whole operation and other departments to use. Influenced management and led team on projects based on business demand. Collaborated with business leaders to understand issues and possible solutions.

• Responsible for the development of user stories and grooming of our internal tools, while running a two week sprint, results : scaling of 3 internal products. Recognized in a 2017 HRIS conference as the leader in electronic data interchange (EDI) reports to our partners in the health insurance industry.

• Developed stored procedures, triggers, and data import interfaces using SQL Server 2016, reducing operational redundancies and eliminating engineering resources occurring during open enrollment and in web applications.

• Imported historical client data from salary to medical rates using Datawatch Monarch, creating scalable templates across clients for business use and eliminating need for data wrangling during import process.

• Generated and exported ad-hoc reports using SQL then transitioned to Looker reports, formulating dashboards and visualizations in Looker and eliminating use of SQL ad-hoc reporting, while opening ad-hoc reporting to business side.

• Documented and trained departments on codebase, internal tools, Datawatch Monarch, Looker, and Excel, empowering business to address clients’ needs.

Angel Garcia adhus8@r.postjobfree.com Page Two

DIGITAL MEDIA RESEARCH, New York, NY 2015 - 2016

Data Analyst

Analyzed and cleansed data to identify trends / discrepancies to measure budget spent and ROI based on countries, brands, publications, and competitors. Extracted data to supply monthly, quarterly, and yearly reports utilizing Excel macros and creating visual aids in PowerPoint.

• Tracked launch of new products on print media, measuring key performance indicators and obtaining market insights.

• Spearheaded onsite training for public relation departments of high-end fashion world, supporting management in understanding needs of new clients and creating road map for social media tracking. MDSL, New York, NY 2014 - 2015

Data Analyst

Aggregated, retrieved, and modified data using SQL and Excel that pertained to HR codes, employees, price components, usage, and GL codes. Performed extensive data cleansing from SQL databases and provided weekly spending and forecasting reports to higher management.

• Audited and disputed any invoice variance greater than 5%, safeguarding against unnecessary charges and securing compliance with corporate policies and client contracts.

• Investigated billing discrepancies using VLOOKUP, filters, pivot tables, and macros. Ensured accurate allocation of charges and credits were applied to telecom invoices, generating creation of audit team to review all telecom portfolios for discrepancies.

• Managed inventory by analyzing and modifying over $10M in telecomm portfolio through utilization and manipulation of data in Excel.

NETWORK SHOWROOM INC., New York, NY 2014

Pubic Relation Intern - Marketing

Coordinated and communicated with magazine editors and stylists on samples requested for upcoming press opportunities and red-carpet events such as movie premieres, Met Gala, and Cannes Film Festival. Facilitated store training sessions at Bergdorf Goodman, client luncheons with magazine editors, and press days.

• Oversaw logistics of over 100 samples using Fashion GPS software, FedEx, USPS, and express courier, ensuring that samples were always returned and avoiding missed press opportunities for client.

• Increased productivity 25% by organizing expenses of 3 account managers according to clients using Excel on monthly basis.

GIORGIO ARMANI, New York, NY 2012

Accounts Payable Intern - Accounting

Processed over 500 invoices and personal travel expenses for North American region of Armani using Oracle. Prepared check runs on biweekly basis, shipped over 200 checks, and transitioned to ACH while verifying and updating vendor information.

• Reduced late fees 3% through handling processing, distribution, and accuracy verification of up to $100K in invoices per week.

• Implemented next-generation technologies (ACH) and processed automations, increasing productivity.

• Restructured and kept vendor list on Excel (VLOOKUP), including outstanding amounts, due dates, etc., enhancing information productivity.

Education

Bachelor of Business Administration (BBA), Finance, Minor: Marketing & Graphic Communication, Baruch College / CUNY, Zicklin School of Business, New York, NY

• Honors: Cirio Foundation Scholarship

Contact this candidate