Data Analyst

Christopher Korzekwinski

718-***-**** • Queens, NY • *****************@*****.***

Senior Database Analyst/Segmentation Administrator

Multi-faceted data marketing analyst professional with a proven history of developing and implementing highly successful campaigns

Providing data analysis, extraction and implementation at all functional levels of data driven marking campaigns and audience segmentation

PROFESSIONAL EXPERIENCE

Publishers Clearing House . • Jericho, New York • 2012 – July 2020

Senior Data Base Analyst (March 2012 – July 2012)

Responsibilities and major accomplishments include:

Administrator and principle coder for the corporate segmentation engine administered and coded over 2000 complex SQL driven discrete audience segments including the largest revenue segments.

Principal Analysts providing infrastructure recommendation and UAT of deployed SQL code and procedures and processes.

Create customized mailing list for both email and offline customers.

Provide ad hoc counts for various complex audience metrics and KPI.

Responsible for quality control and testing of data feeds to data warehouse and profile database.

Work in ad hoc basis to trouble shoot any issues that may arise and provide for custom data sets.

Development of quality control procedures and automated test scripts to verify marketing segmentations for Publishers Clearing House across multiple data sources utilizing data sets consisting of billions records.

Ziff Davis Enterprise • New York, New York • 2007 to 2012

Industry leading media company in print and online, providing lead generation and advertising for B2B technology companies

Senior Database Base Analyst Programmer Database Marketing

Responsibilities and major accomplishments include:

Acted as the Senior Marketing Database analyst for Ziff Davis Enterprise whose primary responsibility was to build a large B2B corporate data base from discrete and separate corporate departments, specifically designed for optimum email, phone marketing and high level lead generation. Gathering and combing data for all departments and company brands defining schema and business flows and process. Coded and created all data sets to be hosted on our customized Web interface. Acted a chief database analyst for 5 years until the eventual

Sale and acquisition of Ziff Davis enterprise who’s chief asset was the B2B corporate database thus seeing one of industries leading B2B marketing databases form it’s inception until its sale.

1998 - JUN 2007 Sun Valley Systems Programmer Analyst

Responsible for accessing all customer servers and connecting to their networks to deploy updates to our software and develop and run DB2 Scripts to either load or fix data or troubleshoot any problems.

Interfaced directly with administrators extracting requirements and developed and deployed customized applications in MS Access using Visual Basic which linked to DB2 via the ODBC

Developed SQL scripts to Create Alter and tables and Trigger statements and scripts

Performed data conversion from customer’s previous student data administration software systems

Developed coded import and export software programs to interface with various external software packages and state data warehouses.

Coded complex applications using SQL (DB2) embedded in COBOL implemented cursor functions and dynamic SQL Techniques

Developed and deployed custom specific database applications to satisfy customized users request.

Coded and developed New York State LEAP reporting which consisted of tracking many various demographic data on students

Designed and code an immunization tracking system.

Coded and developed historical student transcript GPA and ranking programs.

Coded honor roll and eligibility specifications for all schools in the Long Island area.

Developed and coded complex reporting functions.

Performed database Backup and restore procedures as well as specific detailed data recovery.

.

TECHNICAL SKILLS, EDUCATION & ACHIEVEMENTS

Technical Skills & Training:

SQL,SQL Server, Big Data Google BigQuery, Haddoop. DB2 databases. Importing and exporting data from all format Excel,CSV,JASON,

Education:

Farmingdale State University: A.A.S Electrical Engineering Technology

Contact this candidate