Sales Analyst Resume San Francisco, CA - Hire IT People

SUMMARY:

Relevant Coursework: SQL, HTML, JavaScript, Financial Accounting, Salesforce, SAP, Cognos
Certified: Microsoft Certiport Excel and Access 2013, SQL, Google Analytics, Google AdWords, QuickBooks
Computer: Microsoft Word, Excel (pivot tables, vlookups, financial models), PowerPoint, Access, CapIQ, Basic HTML and JavaScript, SQL, Google Analytics, Cognos, Silvon
Other: Google Analytics, Google AdWords, QuickBooks for Accounting, Salesforce.com, SAP
Interests: East Bay teams, NBA, NCAA basketball, AAU basketball, badminton, yoga, tutoring

WORK EXPERIENCE:

Confidential, San Francisco, CA

Sales Analyst

Responsibilities:

Streamlined and recreated weekly sales reports for leading food distributor by using SQL queries for AMs tobetter reflect commissions, gross margins, and sales growth; redesigned shortline to better track sales errors
Led efforts to automate reporting and consolidated large data sets using Cognos extensively andanalyzed results for consumer packaged goods companies; worked wif PMs to reduce process by 50%
Drove delivery of project deliverables and managed work plans to track overall milestones and progress

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

Managed process to standardize reporting of large data sets wif SQL queries and worked wif engineersand project managers to reduce process by 30%
Prepared forecasting and budget analysis to track labor and material costs and assisted in classifyingdifferent assets; identified opportunities for various process improvements wif Salesforce.com
Interfaced consistently wif executives and cross functional teams and recommended implementations

Confidential, Los Angeles, CA

Financial Analyst

Responsibilities:

Worked as part of five - person team and analyzed and aggregated large data wif SQL and Access queries,developed value estimates by creating operating models for valuation of $150 million company
Performed NLV analysis to develop fair market valuations and assisted in identifying and classifyingdifferent assets; identified opportunities for various process improvements

Confidential, San Francisco, CA

Analyst

Responsibilities:

Analyzed CPC and ad impression data wif Google Analytics and evaluated results; increased RPMs by 60%
Collaborated frequently wif the development teams to ensure business requirements were reflected infunctional design and user interface; communicated expectations to team members and stakeholders
Oversaw the creation and review of all requirements documentation (business requirements, matrices,and master tables) for leading CPG and technology companies

Confidential, New York, NY

Merchant Banking / Investment Banking Analyst

Responsibilities:

Conducted an asset by asset review to evaluate capital structure considerations of real estate portfolio
Assessed capital requirements necessary to maintain compliance wif loan to value guidelines and located

Confidential

Financial Analyst

Responsibilities:

Worked as part of four-person team responsible for assessing total revenue potential and risk of multiple companies based on key metrics; gathered data from Access and SQL databases
Researched optimizations for ad unit and placement method for MySpace; identified new user interfaces leading to higher click through rates, CPC, RPM, and total monetization results by over 130%
Received competitive $5,000 scholarship for performance during internship