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

• 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

• 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.• Maintain procedures integrating the student info system with the learning management system.• Collaborate with the DBA to troubleshoot and tune database performance issues.• Manage data customer expectations, requirements, and contacts.Tools: Oracle, SQL Loader, Toad, DTS, SSIS, MS Access, SQL Server, Solaris, Windows

• 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.• Contribute to upholding the integrity of the ETL process relationship architecture.• Provide availability to be final tier support for critical data extracts.• Assist analysts with Brio development, extraction, and report design.• Manage data customer relationships and assist in prioritizing tasks.Tools: Oracle, Informatica, Toad, Brio-Hyperion, Tidal Enterprise Scheduler, Solaris, SQL Server, Windows

• 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

• 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 Objects, Informix, DB2, NCR Unix, HPUX, Windows

• 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