Nicole Romer Email & Phone Number

Reno, Nevada Area

Data warehousing, analysis, and integrations for education-focused companies.Current Tools: MySQL, Oracle, MongoDB, Clojure, Git, Linux, Mac OS X

Reno, NV

• Migration of customer profile data from various custom legacy data stores for integration intonew Case 360 Oracle case management system.
• Analyze, dedupe, extract, and transform customer profile data from disparate custom sources.
• Migration of customer transaction data from custom legacy Oracle case management system andcurrent SQL Server case management/workflow system to the new Case 360 system.
• Analyze Oracle content engine document data to identify documents qualifying for migration.
• Design, build, and migrate control table from Oracle to SQLServer containing documentmetadata to manage the customer document migration.Tools: Oracle, Toad, DTS, SQL Loader, SQL Server, MS Access, Solaris, Windows

Reno, NV

• Provide staff campus-wide with job-improving data resources and training necessary to makedecisions and support students using the data.
• Design, develop, manage, maintain, and support data warehouse, operational data store, andrelated ETL and integration processes.
• Deliver and configure data access via MS Access to customers of varying technical aptitudes.
• Provide application specialists, developers, and DBA with PL/SQL, design, and data solutions.
• Design and develop data for a web-based query tool supporting campus-wide recruiting efforts.
• Conduct source system analysis for integration with custom, or third-party application data.

Reno, NV

• Design, develop, enhance, and support data warehouse data structures and processes.
• Collaborate with business unit specialists and customers to gather and proof data requirements.
• Create and present both functional and technical designs.
• Build, optimize, and troubleshoot ETL processes using Informatica, scripting, and PL/SQL.
• Assist QA department in designing test plans for complex logic.
• Package and document processes for deployment into multiple environments.

San Francisco, CA

• Design and develop server-side functionality for multi-tiered, e-commerce applications.
• Develop server-side Java database interface components for the first phase of the Orbitz project.
• Assist engineers in query design for server-side data computations or interface delivery.
• Create an object that extracts XML data from large character database fields for analysis.
• Design and implement project activities database for project management process development.
• Design and implement resource management reporting database sourced from MS Project.Tools: Oracle, MS Access, Linux, Solaris, Windows

Minneapolis, MN

• Create data warehouses and custom web-based applications.
• Build, analyze, and maintain large data models to satisfy requirements.
• Write ETL scripts for data extraction, transformation, and loading.
• Deploy and support Business Objects Business Intelligence tool.
• Develop universes for, and present data to customers using Business Objects.
• Design and code data-driven, web-based data warehouse query, integration, and management applications using Visual InterDev/VB, JavaScript, and Microsoft IIS.Tools: Teradata, FastLoad, BTEQ, ERwin, Toad, Business.

Eden Prairie, MN

• Manage and maintain Electronic Data Interchange (EDI) system.
• Design and implement automated system in C, Synergy DBL, and Unix shell languages for exchanging, processing, and acknowledging data files.
• Create, modify, and debug Synergy DBL applications, reports, and ISAM data files.Tools: UMIPS, Solaris, Windows, ISAM data files, DB2, Cognos Impromptu