Mahmut SARITAS

ac4god@r.postjobfree.com San Jose, CA 650-***-**** LinkedIn

Computer/Technology Skills

Proficient in: MS .NET (C#/VB.NET), T -SQL, HTML Familiar with: Hive, Java, R, Python, and PHP Relational Databases: MS SQL, MySQL 5.0+, and Oracle Project Management: MS Office Project, JIRA Data Warehouse Systems: MS Analysis Services 2008 Unit-Testing: TSQLT and J-Unit Reporting Systems: MS RS, Crystal Report ETL Systems: MS DTS, MS SSIS 2008 Professional Experience

AgilOne Inc.

Data Analyst / Manager of Marketing Operation, California, US 5/2013 – 8/2017

■ Expertise on building direct mail and advertising campaign automation with 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 help 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 with 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 AgilOne 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 knowledge and capable of performing assigned duties

Page 2

AgilOne Inc.

BI Developer, California, US 11/2009 – 5/2013

■ 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

AgilOne Inc.

Software Developer, Istanbul, Turkey 10/2006 – 11/2009

■ Built .NET web/desktop applications, SQL Server Common Language Run-time (SQL CLR) procedures to support data pipeline operations such as address cleansing/verification, data de- duplication, data merging, and reporting

Ericsson Mobility Word

Sr. Software Developer, Istanbul, Turkey 12/2003 - 10/2006

■ 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)

Senkron Computer System

Software Developer, Istanbul, Turkey 04/2002 - 12/2003

■ Designed and developed Pocket PC / PDA applications for purchasing department and ERP modules

■ Test and verification of software components on Pocket PC / PDA Porcan Holding

Software Developer, Istanbul, Turkey 08/1998 - 04/2002

■ Responsible for developing order management and procurement applications on Personal Digital Assistant (PDA) using OVAL (on PSION) for retail organizations Education

Anadolu University, Turkey / Bachelor's degree, Economics 2004-2008 Sakarya University, Turkey / Associate's degree, Computer Programming 1996-1998