**** ** ***** ****** ********, Oregon *****
Cell 503-***-**** *******.*.****@*****.***
Chelsea M. Rose
INFORMATION SYSTEMS SPECIALIST
Results-driven MBA-level IT Professional with over 17 years technical and 26 years of communications expertise working independently as well as in teams in project-focused environments. Experience analyzing data processing problems, as well as analyzing user requirements, procedures, and problems to automate or improve existing systems and review computer system capabilities, workflow, and scheduling limitations. Able to convert project specifications and statements of problems and procedures to detailed logical flow charts for coding into computer language. Recognized skills developing, troubleshooting and maintaining computer programs to track data and store, locate, and retrieve specific documents, data, and information. Motivated self-starter.
AREAS OF PROFESSIONAL EXPERTISE
Accounting (financial, managerial, payroll)
Business & interpersonal communications
Business systems analysis
Collaboration with domestic and offshore partners
Creation/management of stored procedures
Data cleaning & processing
Data extract, transform, load (ETL)
Database administration & management
Intermediate statistics
Quality assurance testing & documentation
Research programming & data processing
Small business management
Training coordination & documentation
User interface design & implementation
TECHNICAL PROFICIENCIES
PLATFORMS: Windows 9x/2000/XP/Vista/Win8/Win10
OFFICE/PRODUCTIVITY: MS Office 2000/2003/2007/2010 [Word, Excel, PowerPoint, Access, FrontPage], UltraEdit, PFE
DATABASE: Oracle SQL, Oracle SQL Plus, PL/SQL, ANSI SQL, FoxPro
WEB DESIGN: HTML, XML, XHTML, DHTML, JScript, Macromedia Dreamweaver 4/MX
OTHER LANGUAGES: VB 6, VB.NET, C++
RESEARCH DATA COLLECTION: Confirmit, CfMC, Qualtrics, RONIN
PROCESSING, & ANALYSIS: SPSS, Quantum, IsoTab, Q
PROFESSIONAL WORK EXPERIENCE
Hansa Research/Hansa GCR (Formerly Gartner Group) Portland, OR
Data Manager Nov 2005 – Present
Manage data through the data collection and delivery, including assistance in design of surveys, sample management, front-end programming and validation, reporting and tracking during data collection, creating checks for data quality, cleaning and processing data, tabulating and reporting analytics, and creating analysis reports
Interact with vendors, both domestic and international, to ensure adherence to standards, provide process assistance, and disseminate information
Support the GCR Business Research Panel, including account administration, sampling, reporting activity, tracking and removing fake panelists, and creating web portals for data collection vendors to access Panelist records for survey sampling.
Initiate and monitor continuous improvements to standards and practices, including both new process development and business process reengineering.
Also involved with managing in-depth interviews, including creating formatted data entry templates in MS Excel, transcribing interviews, and running custom reports and graphics.
Production Programmer Dec 2003 – Jun 2005
Scripted text file logic for Windows and Web-based application programming, tested, troubleshot logic and design flaws, and coordinated solutions.
Collaborated to manage budgeted project hours, ensure data accuracy and managed projects with multiple components through the programming process.
Provided numerous reporting tools for Project Managers, including MS Access and Excel tools using complex queries; organized and tabulated data; presented final data to Project Managers and Analysts for analysis; created custom data sets as needed.
Semi-Annual HP Program Project
Oversaw semi-annual composition and redesign of custom HP program involving multiple data-collection programming components as well as an Access database for tracking and reporting contact and screening information using links to the FoxPro data files. Wrote 500 – 2000 lines of code for each component.
Created data forms and an Access switchboard to allow access to respondent data while restricting changes to authorized users, providing multiple reporting tools to clients and the project team.
Designed Access system to organize, export to Excel and deliver respondent information.
Set up logic to cross-tabulate component and data set, including matching data to previous waves, and created custom tables and crosstabs.
Core Research Representative Mar 2000 – Dec 2003
Interviewed IT professionals to collect data on IT products and services; troubleshot quality and production problems; monitored and validated research projects for quality, facilitated on-site tests for physical research.
Awarded for excellence in conducting over 400 research interviews with top-level executives in Fortune 500 companies in the US and Canada for a software deployment study.
HISTORY OF EDUCATIONAL ACCOMPLISHMENTS
Master of Business Administration: Information Systems Management With Honors
Keller Graduate School of Management - Portland, OR June 2008
* Outstanding Graduate of 2008
Bachelor of Science: Technical Management Summa Cum Laude
DeVry University - Portland, OR June 2006
Associate of Applied Science: Microcomputer Application Summa Cum Laude
Western Business College - Portland, OR October 2003