• Serve as product expert/data model manager for a customizable ETL/Data Warehousing/BI solution capable of supporting all sized financial services clients from credit unions to large corporate banking ventures• Gather and translate business requirements into functional design specifications• Manage reusable, standardized relational financial data model and associated metadata repository• Analyze source data and identify relationships to properly integrate data and facilitate ease of use and access• Define and build integration and transformation logic from multiple source systems to data warehouse entities• Import and define source file layouts and fields within an ETL tool• Validate and test data integration logic• Recommend data warehouse enhancements as required to support integrations

Manage relational databases containing site data for multiple Naval installations which are part of the Navy CLEAN InitiativePerform statistical analysis and various risk-related calculations using analytical data from laboratories for multiple environmental matricesWork with geographic information systems (GIS) department to produce graphical and spatial representations of analytical data for inclusion in site remediation reports required by the Navy and Environmental Protection Agency (EPA)Generate a variety of custom reports from standard data printouts to complex statistical tables using multiple reporting tools including MS Report Builder, MS Access, MS Excel, MS SQL Server and MS FoxPro

Functioned as the network administrator, desk side IT support, and phone system managerManaged fleet vehicle and cell phone needs for entire company (new hire phones, Blackberry support, air card support) Developed procedures for new email system rollout and disaster recovery plan

Handled various streams of environmental data uploaded, managed, and stored on a web based data management system for multiple project sitesPerformed QA/QC checks of laboratory/field electronic deliverables to confirm completeness and data/file type requirementsGenerated ad-hoc and routine data dumps for reporting of final data to project team membersDeveloped an Access based tool to receive laboratory electronic deliverables to be re-configured and formatted for submittal to state agencies

Functioned as a Level 1 application support specialist for over 30 applications for J&J's Biopharmaceutical Information Management department Developed new reports and executed change requests to existing reports in Cognos ReportNet/Impromptu/PowerPlay as well as management of the report server and data warehouseFound significant cost savings for the department by streamlining in-place processes and developing new process flows and documentation for upcoming projects

Database work on client's defined benefits database (approx. 125,000 participants, 500+ tables in Oracle 8i) using SQL queries through PL/SQL Developer or SQL*PLUS and Access for data analysis Performed data integrity checksDeveloped test cases and handled regression analysis