Data Analyst

PAVEL BAUMSTEIN

Van Nuys, CA **********@*****.*** 323-***-****

SUMMARY

Experienced Business and Data Analyst/Developer with over 10 years of progressive

experience in business & statistical analysis, database administration and object-oriented

programming in diverse industries including online advertising, lending, and telemarketing.

Recognized as a hands-on, goal-oriented and solution-based business intelligence and systems

analyst. Possess a keen ability to quickly assess and understand business initiatives and

successfully develop user-friendly reports. Skilled in data integration and developing databases

for use in making critical departmental and company-wide business decisions and attaining

operational efficiencies for increased ROI. An excellent communicator and problem solver with

ability to motivate and forge strong relationships with co-workers from cross-functional teams

within fast-paced environments.

• Business & Data Analysis

• Data Warehousing

• Data Integration

• Reports Development

• Business Intelligence

• Critical Thinking

• Solutions-Driven

Software & Analytical Skills

SQL (Oracle, Microsoft, MySQL), Visual Basic, PL/SQL, Access, Excel, PowerPoint

Oracle BI Discoverer,Business Objects, SAS, Tableau, MicroStrategy

Google AdSense, Adobe Omniture, Yahoo Analytics

Professional Experience

LeCon Consulting, Los Angeles, CA March 2015 - present

Consultant (part time/temporary)

• Developed functional and technical requirement specifications.

• Reviewed, analyzed, and evaluated applications to meet enterprise business requirements.

• Designed and maintained client databases (SQL Server, Access) for reporting and analytics.

• Produced integrated dashboards for key performance indicators and other daily, weekly, and

monthly reports (Excel, Tableau).

United Online, Woodland Hills, CA April 2007 - October 2014

United Online, Inc. is a leading provider of consumer products and services over the Internet

Senior Business Analyst (Media Operations)

• Gathered and synthesized business requirements and wrote specifications for inter-

departmental projects to develop standard and ad hoc reports for advertising, marketing,

financial and CRM departments, and C-level management.

• Developed and maintained a departmental data warehouse to store and process Media

Group raw data, filter out and correct erroneous information, and display reports in requested

formats.

• Wrote from scratch and modified complex SQL queries, SQL and Visual Basic stored

procedures to meet new business requirements.

• Developed, automated, and maintained an integrated dashboard for key performance

indicators (KPI) and other reports for daily Ad Network operations (online advertising and

customer search) utilizing Excel, PowerPoint, and Tableau for visualization. The dashboard

provided Media Group with accurate timely data to manage daily operations and make

effective business decisions in constantly changing environment.

• Performed data mapping, extracted, transformed, loaded (ETL) data from multiple sources

such as data warehouse (PL/SQL, Oracle BI Discoverer, Microstrategy), and third party sites

(Google AdSense, Adobe Omniture, Yahoo Analytics).

• Identified measurable factors that impact online traffic and KPI to build descriptive and

predictive statistical models.

• Built predictive regression models for short- (quarter) and long-term (year) projection of online

traffic, KPI, and revenue.The forecast model has an outstanding accuracy predicting YTD

traffic within 1% - 3% range.

Researched impact of various factors such as new business requirements, website redesign, ad

rotation on the traffic, KPI, revenue, and the cost. Analyzed trends to separate seasonality

and fluctuations due to business changes.

• Created statistical models to measure effectiveness of business initiatives as well as to set

realistic goals and budget.

• Reconciled data from multiple sources and resolved discrepancies. My implementation of the

monthly billing Exception Report has become an important tool for correcting inaccurate

billing numbers and satisfying SOX auditing requirements.

• Ensured uninterrupted business operations by training other employees to maintain reports.

• Worked closely with internal customers helping troubleshoot and tune SQL code for optimal

performance.

• Played a pivotal role in analyzing raw data quality gaps to identify errors in ad trafficking,

delivery and revenue reporting to assist account management and technology teams in

determining the root cause of problems and fixing them in a timely manner.

Accredited Home Lenders (formerly Aames Home Loans), Los Angeles, CA March 2003 -

March 2007

A nationwide mortgage banking company

Senior Business Analyst

• Gathered business requirements, developed and maintained marketing reports for lead

management and loan origination system for the sub-prime lender. The reports covered

aggregators, direct mail, telemarketing, and other campaigns for the retail channel.

• Designed and maintained marketing data warehouse for reporting and analytics.

• Wrote stored procedures and implemented utilities (SQL, SAS, Visual Basic) to maintain

marketing database and produce reports.

• Created an algorithm and wrote program code for matching loan applications against leads to

identify true source of loan applications and funded loans, which significantly improved

accuracy of the response rate calculations and other metrics.

• Analyzed responses, produced reports and recommendations for marketing campaigns

(direct mail, lead purchasing).

• Combined data from multiple sources – marketing database, data warehouse (MS SQL

Server), lead management and loan origination systems (through Business Objects

5.1/6.5/XIR2) – to produce reports and conduct analyses.

• Produced a number of daily, weekly, and monthly reports for executives on lead activity, lead

distribution, response rate, pricing, and loan officer performance.

• Provided statistical analysis and forecasting.

• Designed, implemented, and managed loading reports from vendors into marketing database

(ETL).

• Implemented inter-application communication using ActiveX/COM technologies to produce

complex Excel pivot tables.

Education

M.S., Applied Mathematics

Moscow Aviation Institute, Moscow, Russia

Contact this candidate