ETL Data Analyst Resume Profile

Professional Profile

SAS ETL developer with expertise in design and development of Extract, Transform and Load processes for data integration projects to build data marts. Proficient MS Excel user with ability to use macros, and pivot tables. Experienced with UNIX Sun Solaris, HP UX, AIX . Proficient with Windows platform. Possess outstanding analytical and interpersonal skills with strong problem solving skills

TECHNICAL SKILLS

Statistical Software: SAS V8.2/V913/9.2/9.3, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/ODS, SAS/CONNECT
Microsoft Office: Word, Excel, Power Point
Windows 98/XP/Vista/7, LINUX Ubuntu

RELEVANT EXPERIENCE

ETL Data Analyst - Level II

Confidential

Work as part of a global team to develop SAS ETL software required to support a variety of business needs and often communicate with end-client on required specifications on data.
Develop database as a SAS developer in projects with large, diverse, client data source files and act as a lead developer responsible for planning and coordination of work activity for projects involving more than 2 million records.
SAS programming for auditing data, developing data, performing data validation QA and improve efficiency of SAS programs.
Manage multiple projects in a fast-paced environment meeting milestones and deliverable dates with no supervision.
Responsible for explaining and validating work results and insight applied to tools used for client analysis and documentation of SAS files and library structures.

Senior Information Technology Consultant

Confidential

Public Policy Research Institute

Managed daily operations of the Computer Aided Telephone Interviewing CATI system in the Survey Research Laboratory
Coordinated with Survey Research Laboratory on quality assurance standards, specifically including daily quality control of data collected through the CATI
Oversaw the production of data-collection status reports and the coding of verbatim data

iCati programming responsibilities

Assisted with upgrades of iCati system:
Coordinated the administration, employment, scheduling, evaluation, and termination of programming staff which consisted of approximately 5 individuals
Supervised the production of data-collection status reports and the coding of verbatim data
Trained iCati staff
Managed data:
Manipulated datasets and sample with SAS, and SPSS.
Automated data routines and operations in various ways from receiving the sample, to the start of the study, to final dataset
Coordinated with Principal Investigators customers in creation of project specific programming needs

Programmer/Analyst II

Confidential

Public Policy Research Institute

Created of initial datasets of the collected data from the CATI.
Tested and implemented the new, more functional and more cost-effective iCati tool
Proprietary Sawtooth CATI to iCati Internet Computer Aided Telephone Interview porting and programming responsibilities.
Administered WAMP stack web, security, and database DBA and/or DBE of the CATI system
ETL program, and report via SAS on the collected data of the system's MySQL RDBMS
Created CAPI Computer Aided Personal Interviewing for field interviews.
Dependent on the needs of the client, provided guidance in development of survey instrument

Programmer/Analyst I

Confidential

Public Policy Research Institute

Created computer programs of increasing complexity
Responsible for computer program testing and validation
Modified computer programs to correct problems
Wrote operations instructions and other documentation associated with programs
Learned new programming languages, techniques, and work processes
Proprietary Ci3 CATI Computer Aided Telephone Interviewing programming responsibilities
Coordinated with the Survey Research Laboratory manager in maintaining quality control standards for the CATI telephone survey portion of projects.
Programmed Ci3 CATI survey questionnaires

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship