We provide IT Staff Augmentation Services!

Data Analyst / Manager Of Marketing Operation Resume

California, US

TECHNICAL SKILLS

  • Hive, Java, R, Python, and PHP Project Management
  • MS Office Project, JIRA Unit - Testing:
  • TSQLT and J-Unit ETL Systems, MS DTS, MS SSIS 2008
  • MS .NET (C#/VB.NET), T -SQL, HTML
  • MS SQL, MySQL 5.0+, and Oracle
  • MS Analysis Services 2008
  • MS RS, Crystal Report

PROFESSIONAL EXPERIENCE

Confidential, California, US

Data Analyst / Manager of Marketing Operation

Responsibilities:

  • Expertise on building direct mail and advertising campaign automation wif focus on direct mail plans for small to medium size businesses. Responsible for all phases of campaign management and execution
  • Helped clients to understand/target their customers better (data analysis) and halp them for the next moves (predictive analysis) by using their transaction, email and web behaviors
  • Helped clients measure and improve campaign effectiveness by using machine learning and marketing analytics to identify likely-to-buy and likely-to-lapse customers
  • Helped clients to boost their campaign marketing ROI wif address cleansing/verification tools such as Zip4, Melissa Data, Accuzip, First Logic, or Google API
  • Created models such as distances to store, primary store and utilized models in geo-targeted campaigns and marketing reports
  • Provided on-going and ad-hoc reporting for Renewal Rate, Match back Reporting, Employee KPIs, and Customer Demographics
  • Performed A/B test analysis and measure campaign performance by different customer segments
  • Created visually impactful dashboards in Excel, R and Python for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
  • Fine-tuned and improved query performance using profiling tools and SQL.
  • Owned the design, development and maintenance of ongoing metrics, reports, analyses, dashboards, etc., to drive key business decisions and communicate key concepts to readers.
  • Built marketing analysis by using Confidential tools and built custom solutions
  • Performed ad-hoc data analysis to obtain actionable insights on loyalty programs and audience targeting, and to answer business questions
  • Perform code reviews, analyze execution plans and tune inefficient code for large size data
  • Lead team of five (5) consists of engineers and analysts in different geographic locations, mentored and guided team members ensuring all were trained in product noledge and capable of performing assigned duties

Confidential, California, US

BI Developer

Responsibilities:

  • Design and implement custom Extract Transform Load (ETL) tasks for automating data pipelines and migrations using Microsoft SQL Server Integration Services (SSIS) 2005/2008
  • Designed the new version of the data replication engine using .NET and Microsoft SSIS custom integration tasks that consolidates data from different data sources into single data warehouse. Increased the processing speed up to four (4) times for bigger clients. This led us to increase data refresh cycles from daily to hourly schedules
  • Designed and developed data warehouse and OLAP cubes using Microsoft Analysis services for online retailers

Confidential

Software Developer

Responsibilities:

  • Designed and developed ASP.NET / MS SQL application for GSM operators to provide the monitoring of Value Added Services (VAS) provisioned to the subscribers
  • Improved the usability, performance and quality of existing web applications by introducing newer version of .NET components
  • Created Extract Transform Load (ETL) applications using Microsoft Data Transformation Services (DTS)

Confidential

Software Developer

Responsibilities:

  • Designed and developed Pocket PC / PDA applications for purchasing department and ERP modules
  • Test and verification of software components on Pocket PC / PDA
  • Responsible for developing order management and procurement applications on Personal Digital Assistant (PDA) using OVAL (on PSION) for retail organizations

Hire Now