Business Data Analyst Resume NJ - Hire IT People

SUMMARY

Analytical, result driven, recent Master Degree graduate in Applied Statistics. Proficient in R/S - plus and Visual Basic programming; possesses working knowledge of SQL/Sybase/Access databases, well-versed in data visualization software, such as Tableau. Five years of data analyst experience with variety of data sets.
Offers broad knowledge of application and automation of statistical methods in R environment; continuously advances his knowledge of R and its applications. Able to work independently and in a team environment; strives to learn and apply new skills to fit current and future projects.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Business Data Analyst

Confidential, NJ

Responsibilities:

Developed VBA tools/add-ins for data analysis in Excel. Created custom Excel add-ins to automate data analysis, data cleaning, and data manipulation. Optimized algorithms to reduce run-time for existing VBA tools in application to large datasets.
Developed user defined functions in R, for data transformation in Tableau software, to generate quartiles, expected values, variance, standard deviation, among other metrics based on criteria determined by user.
Applied Linear/Logistic/Lasso/Random Forest regression methods to predict contractor quality, and assess variable/factor contribution to contractor performance. Created user defined functions in R for variable/model selection.
Data mining with SQL and R for ad hoc requests/reports.

Commercial Data Analyst

Confidential, Newark, NJ

Responsibilities:

Designed a vendor database on Sybase and MS Access servers; developed new VBA Marco/Excel based Core Mail pricing tool, which connects to, and runs queries/stored procedures to gather vendor rates from databases via ActiveX controls
Developed vendor analysis tools for commercial department to identify and generate most competitive vendor postage rates across all international destinations, formats, and weight breaks to create vendor routing matrices for various product lines.
Re-designed pricing tools from formula-based to VBA/Macro-based; expanded tool capabilities with new features such as custom routing, variable pricing options, quote comparisons, vendor specific exceptions and discounts, and enhanced data validation.
Automated weekly vendor performance reports (previously requiring 4+ hours of spreadsheet data manipulation).
Performed various ad hoc analyses, created reports using data from SQL and Access databases, such as, rate change scenarios, mailing volume and transit time analysis.

Service Quality Analyst

Confidential, Newark, NJ

Responsibilities:

Conducted transit tests to measure international mail delivery times for current vendors to major international destinations.
Ran queries to gather tracking data from multiple vendor sources/tables in Sybase; prepared weekly and monthly vendor performance reports based on this tracking data.
Updated and maintained annual vendor increase model, analyzed and prepared annual rate increase data, stored in Access database for pricing department

Data Analyst

Confidential, Southfield, MI

Responsibilities:

Collected, extracted, and organized data to determine trends and patterns
Performed fare analysis for airline carriers to determine airlines/destinations to include for marketing broadcasts
Evaluated and established air fare data loading priorities for the internationally based data team