Customer Service Manager
Resume:
Scott Ortiz
Spring Hill, FL
***********@*****.***
SUMMARY
Talented analyst in the field of relational database development and analysis working with complex customer data records in the billions. Skilled in both data analysis and customer service. Great proficiency with data manipulation tools as well as expertise in both email and direct mail marketing campaigns and strategy. In my position I was able to both expedite and provide quality improvements in our data collection and housing process as well as quickly producing direct marketing campaigns for clients. I take pride in my ability to produce remarkable performance with high standards including optimizing trend possibilities and growth opportunities through in depth data analysis.
EXPERIENCE
Lead Database Developer / Analyst
Market Vue Partners, Durham, NC
June 2006 to June 2014
Creating, configuring and upgrading relational databases and associated tools
Successfully extracted, transformed, loaded, updated and coded client’s customer data in our large data warehouse.
Maintenance of client databases for optimal performance including troubleshooting any irregularities.
In depth knowledge and application of Alteryx 8.6 and SQL Server apps. including SSIS and SSRS.
Demonstrated ability to multi-task which encompassed:
Creating and upkeep of database in housing customer data.
Created and executed marketing campaign pulls for major marketing efforts(telephone, direct mail and email)
Optimizing data coding for better customer targeting.
Analysis and manipulation on highly in-depth data sets.
Identified, developed and evaluated marketing strategies based on knowledge of client objectives and market trends.
Proficient in scripting and using complex SQL Queries and functions including creating stored procedures, keys and join queries with relational and non-relational databases.
High standard quality documentation of processes and procedures.
Reporting using SSRS and Excel
Well versed in Microsoft Office creating spreadsheets for clients using Excel, Word and PowerPoint to create reports pertaining to customer needs.
Shipping and Receiving Manager
Linens N Things, Woodbridge, NJ
Sept 2003 thru June 2006
Supervised a team of 10 stock employees and numerous floor associates.
Responsible for stocking and opening the store.
Managed daily paperwork & reports.
Assisted in store in Loss-Prevention.
Customer service oriented environment
Shipping and Receiving Manager
Drug Fair, Iselin, NJ
April 1999 to Aug. 2003
Started as cashier/stock associate.
Promoted to the shipping and receiving manager in charge of
bi-weekly re-stock truck.
Control and security of all daily deliveries including pharmaceutical deliveries.
EDUCATION
John F Kennedy Memorial High School
Diploma 1998
SKILLS
Market Research
CRM Database Structure
Data Analysis
ETL Process
Data Entry
Microsoft Access 2013
SQL Server 2008 R2
Oracle database XE 11g
SSIS
SSRS
Alteryx 8.5
MySQL
Microsoft Excel 2013
Microsoft Word 2013
Microsoft PowerPoint 2013
Microsoft Outlook 2013
Advanced knowledge of complex SQL queries
Data Modeling
Database Design, Configuration and Maintenance
HIPAA/HITECH Awareness Training Certified
SQL Query Troubleshooting and Resolution
Fine Tuning of Databases
Reporting
Dashboards
Direct Marketing Campaigns
Quantitative Analysis
Market Segmentation
Customer Service-oriented
Quality Leadership
Excellent Written and Verbal Communicator
Fast and Reliable
Self-directed
Contact this candidate