Charles Wallin

** ***** **** ( East Northport, New York 11731

631-***-**** ( 631-***-**** ( ( abohfl@r.postjobfree.com

Profession: Data Analyst - Customer Information Systems

Profile: Comprehensive experience and education (MBA) in Business

Information systems. Relational database design, analysis, and reporting.

Strong expertise in customer relationship management (CRM). Highly

effective skills in analyzing, organizing, and communicating. Experienced

in SQL ACCESS and EXCEL.

Experience: Data Analyst - Customer Reporting / Retail Feedback Group

10/08 - 11/12

> Design, develop, and maintain Business Intelligence system for 12

supermarket chains (512 stores).

> Developed custom reports and dashboards for clients using customer

satisfaction survey and employee feedback data utilizing SQL,

ACCESS, EXCEL Pivot tables and vlookups..

> Load (ETL) raw survey data into RDBMS to discover trends, patterns,

and anomalies.

> Create monthly trend analysis reports and present findings to

clients.

> Train users on system functionality and set up any customized

reporting.

> Monitor and review store response rate reports for clients.

> Perform data analysis to eliminate fraudulent surveys.

> Act as an liaison between business users and IT staff

Business Analyst Customer Marketing Foto Fabric Impressions Corp.

(`06/04-07/08)

> Created customer acquisition and retention data models. System

resulted in 30% increase in customer loyalty

> Performed return on customer (ROC) analysis to rank most profitable

customers and products utilizing EXCEL and ACCESS.

> Created customer models based on recency, frequency and lifetime

value (LTV).

> Implemented permission based email system increasing customer

retention in certain segments.

> Created PowerPoint presentations to educate distributors in marketing

Foto Fabric's product line.

> Redesigned company web site using Microsoft FrontPage, Adobe

Photoshop, and Illustrator.

> Contributed to several articles for Promotional Products trade

publications.

> Initiated ecommerce project with search engine optimization and

keyword research.

Independent IT Consultant / KC Data Corp. (`98-`04)

> Design, code, debug, report programs for various large mainframe

corporate applications utilizing

Cobol, CICS, DB2, SQL server.

> Created user and system test plans with QA department wrote ETL

programs. Created test scripts and documentation.

Clients included Chase Auto Finance, Arrow Electronics, and First

Data Merchant services.

Senior Systems Analyst / Barnes & Noble (`93-`98)

> Responsible for support, maintenance and development of all

Merchandising legacy Systems.

> Successfully redesigned Authorized Vendor Return system to provide

more functionality to business users. Applications utilized CICS,

VSAM, COBOL, EZTREIVE, IMS, Paradox and EXCEL.

> Designed and coded extract programs (ETL) for OLAP project.

> Successfully designed and implemented store wide special order

system using RDBMS.

Project Manager (POS) / Alexander's Dept. Stores (`90-`93)

> Responsible for all Point of Sale Systems (POS) for department

store chain (12 stores).

> Supervised staff of 12 programmers, business analysts, and

consultants.

Education: MBA Degree in Information Resource Management

Graduated 1989, New York Institute of Technology

BA Degree in Psychology

Graduated State University of New York at Buffalo

Certificate in Programming / Grumman Data Systems Institute

Relevant Keywords: MS Word, Excel, PowerPoint and MSProject, Access,

MBA, Project Manager, SQL,Business Intelligence (BI), Data

Modeling, CICS, IDMS, DB2, IMS,ETL

Contact this candidate