Consultant (contract) Resume
San Diego, CA
SUMMARY:
- Experienced, tech - savvy professional with seven years of data and financial analysis experience Process improvement specialist with a keen eye for detail, thrives under pressure and ambiguity Delivers results—helped capture 300% of target revenue for Confidential &T while reducing staff turnover
TECHNICAL SKILLS:
SKILLS: MS Office, *advanced Excel, VBA, PowerPoint, Access, Outlook, Word, SharePoint, Business Intelligence tools, Adobe Analytics (Omniture SiteCatalyst), ThoughtSpot, Looker, Tableau, ERP, Python, Survey Monkey, JIRA, Confluence, Slack, data analysis, financial analysis, modeling, budgeting, forecasting, accounting, excellent customer service skills, technical writing, natural teaching ability to explain complex ideas to non-technical audience. Excel power user PowerQuery, PowerPivot, dashboards, slicers, macros, VBA, VLOOKUPs, pivot tables, conditional formatting, data validation, nested and other advanced/custom formulas for data extraction, manipulation:
PROFESSIONAL EXPERIENCE:
Confidential, San Diego, CA
Consultant (contract)
Responsibilities:
- Updated VBA code/macros for accounting department, allowing month - end closing and server upgrade to be performed.
- Worked with senior accountant to coordinated deliverables met project deadlines
Confidential, San Bruno, CA
Data Analyst (contract)
Responsibilities:
- Analyzed website traffic, sales, KPIs to gain insights into e - commerce business
- Used tools such as Adobe Analytics, SQL, ThoughtSpot, Excel, Tableau, Looker
- Measured traffic, click-through rates, GMV, IMU, created conversion funnel reports
- Analytical support for online ad campaigns, SEO/SEM, affiliate marketing
- Pulled data using SQL to create reports for financial planners, team meetings
- Created dashboards, models for fiscal year plan, forecasts and actuals
Confidential, Oakland, CA
Financial Analyst, Cardiology (contract)
Responsibilities:
- Analyzed medical equipment spend to facilitate management of clinical resources
- Transformed disparate data and ambiguous instructions into insightful reports
- Using financial models, turned raw data in insightful visualizations for cost/benefitRFP analysis for the procurement of clinical resources, pulled raw data using SQL.
- Prepared surveys using Survey Monkey, translated results into heatmaps
- Coordinated with suppliers to ensure timely submission of RFPs.
Confidential, San Francisco, CA
Data Analyst (contract)
Responsibilities:
- Cleaned survey data for Fortune Magazine's Best Companies To Work For list
Confidential, Austin, TX
Data Analyst (contract)
Responsibilities:
- Audited T1 accounts to track contract commitment levels, resolved billing issues
- Pulled data using SQL/Excel/Access, produced weekly, monthly, ad hoc reports
- Created validations to ensured data integrity, trained new team members
- Key player in project growth and success - -helped capture 295% of target revenue
- Optimized work processes by formalizing operating procedures into charts, created technical manuals, retained 100% of new hires trained.
Confidential, Austin, TX
Financial Analyst
Responsibilities:
- Performed financial analysis of real estate operations, financial modeling f monthly, quarterly, and year - end NOI projections compliant with GAAP.
- Prepared quarterly earnings and annual budget packages, forecastsad-hoc analyses and other financial reports under tight deadlines.
- Performed revenue/expense variance analysis on conference calls
Confidential, Austin, TX
Data Analyst (contract)
Responsibilities:
- Tracked contract commitment levels, validated potential uplift revenueidentified billing issues, created production reports, trained new hires.
- Consolidated auditing protocols into charts, influenced their adoption, increasing efficiency and productivity throughout department.
- Provided vital feedback during upgrade to Access - based production platform
Confidential, Austin, TX
Self-employed
Responsibilities:
- Operated home remodeling business - -advertising, sales, customer service
Confidential, Wall, NJ
Wireless Billing Analyst (temp)
Responsibilities:
- Configured POS tables, confirmed accuracy of product updates
- Reviewed wireless billing invoices to verify accuracy of charges
- Significantly improved organization, speed and efficiency of invoice verification procedures using macros and data validation.