ETL Data Analyst Resume Burnsville, MN - Hire IT People

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

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)

TECHNICAL SKILLS:

Project Domain: Survey Research, ETL

Hardware: Dell, Gateway, Toshiba, HP

Operating Systems: MS Windows 7, Linux

Computer Languages: ASP, PHP, CSS, HTML, JavaScript, SAS, SQL, and VBScript

RDBMS: MySQL

Development Tools: SAS System, SPSS, MySQL RDBMS, SQL Server (2005 through 2008), Visual InterDev 6 using Source Safe, StatTransfer, Adobe (Photoshop, Premiere, and Acrobat), Macromedia Flash, Microsoft (Access, Excel, IIS, Outlook, Power Point, Visio)

Applications: MS Office

Methodologies: Data Mart, SQL Queries

RELEVANT EXPERIENCE

ETL Data Analyst

Confidential, Burnsville, MN

Responsibilities:

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, Texas

Responsibilities:

Managed daily operations of the Computer Aided Telephone Interviewing ( Confidential ) 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 Confidential
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

Confidential

Responsibilities:

Created of initial datasets of the collected data from the Confidential .
Tested and implemented the new, more functional and more cost-effective iCati tool
Proprietary Sawtooth Confidential to iCati (Internet Computer Aided Telephone Interview) porting and programming responsibilities.
Administered WAMP stack web, security, and database (DBA and/or DBE) of the Confidential 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

Confidential

Responsibilities:

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 Confidential (Computer Aided Telephone Interviewing) programming responsibilities
Coordinated with the Survey Research Laboratory manager in maintaining quality control standards for the Confidential telephone survey portion of projects.
Programmed Ci3 Confidential survey questionnaires

We provide IT Staff Augmentation Services!

Etl Data Analyst Resume

Burnsville, MN

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship