Data Analyst Marketing

Page*

Selin Holder

Data Analyst at Restoration Hardware

***********@*****.***

Summary

Creating Value Driven Analyses with DATA, Flexible on multi-dimensional platforms, Produces Reporting by utilizing various BI - business intelligence tools - Passionate about Data Integrity. Data Analysis #Reporting #Customer Relationship Management CRM Application - Server side - #SQL, (MS SQL Server 2008 - 2012 - SSRS - SSIS) MS ACCESS #Salesforce # Qlikview # SharePoint # Oracle ERP # SCRUM# CiviCRM, Aprimo, Tessitura, Wordfly, Sybase, Infomaker #MS Office 2011, MS Project# Business Objects# Quickbooks#GoogleAnalytics# WebAnalytics

#Data mining, Data Trending, Database Management # Data Validation # Data Loading- Stored Procedures

(ETL)#Favorite SQL statements : CASE : Index : Partition By Experience

IT Application Support Analyst _Contractor at Marin General Hospital July 2015 - Present

-Administered and managed master data for Provisioning for all hospital departments.

-Provided Tier 1 - 2 support to clinical staff requests for Paragon Clinical Applications and Systems.

-Managed workflow and tickets for IT Security group.

-Acted as Primary liason between IT and other departments for system questions/Issues and fixes. Data Analyst_Contractor at Restoration Hardware

November 2015 - May 2016 (7 months)

- Audited and analyzed weekly vendor data for identifying open and past due order statuses.

- Provided forecasting on Production Lead Times and inventory levels

- Completed demand analyses based on vendors.

Project Data Analyst _ Contractor at HDA Associates 2012 - 2015 (3 years)

- Transformed data findings into actionable sustainable reporting.

- Supported systems, applications and acted as a liason for the projects between outside vendors and internal business units.

- Produced Contract Estimates at Completion Charts (EAC).

- Managed work plans for meeting with development time schedules.

- Prepared documentation, analyzed information to form logical and consistent conclusions, and to communicate the logical process to customers and co-workers. Page2

- Maintained updates with company's database and ERP systems. Data Analyst at Marin Clean Energy

2011 - 2012 (1 year)

-Performed data monitoring and reporting for resources under contract for tracking customer enrollments and status, processing web-based customer requests, identifying any data irregularities (de-dup, scrub)

-Developed and Participated SCRUM process during database development.

-Led CRM systems data integration including data mapping process between procedures with Qlikview

- Produced metrics and dashboards for senior executives, commercial partners, board members and regulatory bodies.

Data Analyst at Autodesk

2010 - 2011 (1 year)

-Performed data analyses and dashboard reporting by using 3rd party BI analytics tools : CustSat, Qlikview, SalesForce,MS Excel, SQL Server, SharePoint.

-Supported Global Channel Management data-centric projects with customer/market segmentation and Net Promoter Score optimization for Survey data.

SQL DBA - Senior Database Analyst - at San Francisco Opera 2008 - 2010 (2 years)

-Created all aspects of Custom Reporting by writing and running SQL scripts on MS SQL Server 2005-2008.

-Used CRM tools (TESSITURA, Infomaker) MS SQL server SSRS tool and Excel as report writing tools for all departments, including Marketing, Box Office, Development, Finance and Information Systems.

-Administered CRM analytics -Tessitura and Wordfly, Omniture for Sales, Marketing Campaigns.

-Implemented best practices for analyzing and storing raw data for the survey and E-Mail Marketing, Partner Hierarchy, Pricing group and Open Distribution.

Database Analyst at Kaiser Permanente

2007 - 2008 (1 year)

- Produced Forecasting reports regards to Staffing and Budgeting needs for three call centers - call volume - patient ratio versus staffing - throughout Northern California.

- Utilized data for reporting from various resources about membership analytics.

- Streamed data trending for hospital operations.

SQL DBA - Database Systems - Business Analyst at The Prieston Group 2005 - 2007 (2 years)

- Provided analysis and ad-hoc reporting on insured loan, fraud, claims, sales and loss mitigation data.

- Wrote SQL Scripts for business processing and business requirements to ensure the data flows Page3

met with the business needs.

- Developed and distributed monthly risk management reports.

- Participated in the design of company data directory and current documentation of database schema and stored procedures.

- Established and managed data integrity requirements (normalization). University Lecturer at Yeditepe University

2003 - 2004 (1 year)

Designed a curriculum for 1st and 2nd year students about :

-Database Management

-Social and Political Impacts on Digital Divide,

-Ethics in Information Systems,

-ERP system as a backbone for OLAP and Data warehousing in Supply Chain Management. Fully assisted with Internship and higher education replacement help for 4th year students. Financial Business Analyst at AXA

2000 - 2003 (3 years)

-Coordinated policy operations and risk management guidelines.

-Provided Swot Analysis and compatibility report for Insurance eligibility.

-Ensured that guidelines are being attended within policy and company standards. Servicing Portfolio Analyst at TRI Capital Corporation 1997 - 1998 (1 year)

-Managed servicing portfolio of 60 to 90 by providing quality service to investors and borrowers.

-Performed all the administrative duties associated with the daily management of closed mortgage loans such as account reconciliation, collection of mortgage payments, paying of property taxes and hazard insurance premiums.

-Prepared monthly & annually escrow forecasts for taxes and insurance premiums on MS Excel along with other related financial statements and maintained database for clients on MS Access. Skills & Expertise

Data Analysis

Financial Reporting

Analytics

CRM

CiviCRM

Business Intelligence

Data Warehousing

Agile Methodologies

SQL

Microsoft SQL Server

Page4

SSRS

Databases

Relational Databases

SharePoint

QlikView

Salesforce.com

Business Analysis

Customer Insight

E-commerce

Project Management

Risk Management

Marketing Strategy

Product Management

Direct Mail

Cloud Computing

IT Strategy

Consulting

Finance

Crystal Reports

Vendor Management

Management

Microsoft Office 2011

MS Access database

Microsoft Office

Access

Analysis

Education

San Francisco State University

Graduate, Management of Information Systems (Client / Server Technologies), 1998 - 2000 University of California, Berkeley

Graduate, Finance, 1996 - 1997

Marmara Üniversitesi

Master of Business Administration (MBA), 1991 - 1993 Marmara Üniversitesi

Bachelor of Applied Science (BASc), Linguistics, 1987 - 1991 Certifications

MS SQL SERVER 2008 Official Training

Microsoft 2008

Volunteer Experience

Volunteer at Senior Long-Term Care Facilities

Page5

January 2015 - Present

Languages

English (Native or bilingual proficiency)

Turkish (Native or bilingual proficiency)

Page6

Selin Holder

Data Analyst at Restoration Hardware

***********@*****.***

1 person has recommended Selin

"I have worked in a project with Selin for close to a year. I have seen her not only excel at core elements of the her job including data analysis but also learn other tasks that extend beyond the scope of her role such as direct email marketing and payroll. Selin goes above and beyond in demonstrating not only mastery for her core role, but also the ability to take on new projects that are both difficult and critical to the company's growth. In fact, her taking on internal company communication aligned with a sharp increase in employee happiness. She is hard working, profoundly detail oriented and team player. "

Michael Bayrakeri, Ph.D., Founding Partner: Product Management and Marketing, Accuvizyon Inc. - Product Marketing Start-Up, managed Selin at Kaiser Permanente Contact Selin on LinkedIn

Contact this candidate