Jennifer Forehand Email & Phone Number

Transform raw, unstructured data into well structured, normalized data models for end user consumption in Business Intelligence reporting toolsBuild models and rules to validate the quality and integrity of user submitted dataHelp define ongoing data and reporting requirements, documented in a consistent and clear manner.Assist with activities required to launch new data related projects such as data mapping, data modeling and establishing data dictionaries.

Assessed the current state of the company data warehousing solution to suggest and implement enhancements to future proof and improve the platform

Use TSQL, C#, VB.NET to create SSIS packages converting data from legacy client systems to ID Networks proprietary databases. Design and develop databases as part of conversation process. Document conversion patterns and processes. Assist in troubleshooting SQL Server performance problems.

Erie, Pa

Solely responsible for creating and supporting internal web applications. Applications built using ASP.net, AJAX, VB.Net and Microsoft SQL Server 2008. Developed and maintained SQL Server 2008 Integration Services packages to import data into SQL Server to support web applications and other 3rd party systems. Data sources included Oracle based student information system, FoxBase based financial system and flat files.Developed and maintained SQL Server 2008 Report Server reports.Performed administrator duties (install and update database, report and IIS servers; DB backups, maintenance plans, performance monitoring, user management).Provided support and training for the district's public web site hosted on Edline, internal web applications and SQL Server Reports.

Erie, Pa

[Continued relationship with Resource Interactive in a Database Developer capacity.]Developed and maintained SQL Server 2000 DTS packages used for importing data, exporting data, reporting, monitoring and maintenance.Migrated SQL Server 2000 DTS packages to SQL Server 2005 Integration Services packages.Wrote Transact-SQL scripts for data manipulation and data retrieval using the SQL Server 2005 Management Studio.Developed and maintain SQL Server 2000 Report Server reports using SQL Server 2005 Business Intelligence Development Studio.Performed administrator duties of SQL Server 2000 server (backups, integrity checks, index defragmenting, user management, etc) on Windows Server 2003.

Columbus, Oh

Architected a multi-lingual content management system. (Microsoft SQL Server 2000, IIS v4.0, PHP v4.3, HTML, JavaScript, Visual Source Safe, Windows Server 2003)Architected multi-lingual ecommerce systems. (Microsoft SQL Server 7.0, IIS v4.0, ASP, HTML, JavaScript, Visual Source Safe, Windows NT v4.0)Architected and developed other product driven web sites.Served as part of technology leadership, helping to determine direction of technology team. Responsibilities included staffing, associate development, setting goals.

Columbus, Oh

Participated in developing a web-based order provisioning system for a telecommunications company by contributing to business and system requirements and application design. (SunOS v5.6, Netscape Enterprise Server v3.0, Oracle v8.0 and Java Servlets)Participated in developing a web-based time management application. (Microsoft Windows NT v4.0, IIS v4.0, SQL Server v6.5, Visual Studio, ASP, DHTML, VBScript and JavaScript) Developed an Intranet site for a telecommunications company. (SunOS v5.6, Netscape Enterprise Server v3.0, Oracle v7.3, Server-side JavaScript, DHTML and Homesite)

Ms Cis, Database Management And Business Intelligence

Bs, Mis

Integrative Nutrition Health Coach

Intelligence Studies

Completed course: Intelligence Theories and Applications.