REN E PAWLISH
Littleton, CO 80123
******@*****.***
SUMMARY
As a client-focused data analyst, I implement the key concepts of data
typing, cleansing and data analysis using SAP Business Objects ETL
(Extract, Transform, Load) software and SQL. I develop and maintain
circulation databases for newspaper retention, marketing and circulation
analysis for a broad variety of customers.
TECHNICAL SKILLS
. SAP Business Objects ETL, FirstLogic ETL, and Sagent ETL/data
cleansing software
. Experienced in SQL Server and Access database
. Visual Basic, COBOL programming
PROFESSIONAL HISTORY
IMPLEMENTATION SPECIALIST/DATA ANALYST 2000 to
present
smartFOCUS ASTECH, (Denver, CO)
. Manage SAP conversions, data cleansing, database design/development,
and data manipulation.
. Design SAP applications and build proprietary databases for fifteen
newspapers, including the Atlanta Journal-Constitution, the Miami
Herald, the Toronto Star, and USA Today.
. Assess and define business system user requirements, design and
develop proprietary databases used for analysis and reporting.
. Design, build, and troubleshoot databases. Provide high levels of
technical support for database software and hardware.
. Identify project objectives from clients, plan and track the project,
assess risk management, resource management, and delegation using
project management skills.
. Utilizing SQL Server to import, query, manipulate, and export data.
. Lead analyst converting FirstLogic ETL address cleansing jobs to SAP,
utilizing various file formats. Designing, developing, coding,
testing and maintaining data procedures.
. Project manager for the Atlanta Journal-Constitution database,
converting 30 flat format files to SQL data loads.
. Managed implementation for the Toronto Star database. Created SAP
applications for Canadian data.
REN E PAWLISH
JUNIOR PROGRAMMER
2000
HotelConnect, (Westminster, CO)
. Designed and implemented databases for hotel phone software using
FoxPro.
. Created and modified reports using Crystal Reports.
JUNIOR PROGRAMMER 1998 to 1999
The TriZetto Group, (Denver, CO)
. Analyzed date inconsistencies for Y2K project. Designed and
implemented solutions for Y2K compliance on medical management
software. Performed unit tests of these designs and on modifications.
. Converted medical management software system from VAX/VMS to DEC
ALPHA.
COMPUTER OPERATOR 1997 to 1998
Red Rocks Federal Credit Union, (Highlands Ranch, CO)
. Performed end-of-day procedures, submitting nightly reports and job
streams, preparing and distributing reports, and performing daily wire
transfers on Fedline system.
. Performed network administration on a RISC 6000, setting up and
modifying end-user accounts, maintaining printers and training users
in terminal usage.
. Performed Novell Network system administration, including solving
Netware connectivity problems, installing hardware and software and
training users on PC's.
OTHER EXPERIENCE
OUTPATIENT COUNSELOR/GROUP FACILITATOR
Centennial Mental Health Center
1997
Lost and Found, Inc. 1993 to 1997
EDUCATION
Red Rocks Community College
Associate classes in Computer Science (Visual Basic, Microsoft Access,
HTML)
Denver CBS
MA in Counseling
University of Colorado
BA in History