Data Analyst / Manager of Marketing Operation Resume California, US - Hire IT People

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

We provide IT Staff Augmentation Services!

Data Analyst / Manager Of Marketing Operation Resume

California, US

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship