Jennifer Reed Email and Phone Number

Responsible for all aspects of a full legacy database migration utilizing MS SQL Server 2016, Toad, MS Excel, Azure DevOps.Work with business users and technical staff to design, document, implement, and test migration and synchronization.Data mapping and transformation.Legacy data analysis, validation, and cleansing.Legacy data purge/archive.Database synchronization during transitional period from legacy system.Review all database object adds and changes.Work with developers to tune SQL statements and stored procedures.Implement programmatic SQL standards validations.

-Design and implementation of a data warehouse environment for all of the operational data. This included data loads from many different sources and environments.-Work with business to document requirements, produce test plans, and author help guides. Including, but not limited to, grain definitions, field level cube guides, application usage.-Tabular model and Multidimensional cube design and implementation using SSAS.-ETL design and implementation using SSIS. -Data warehouse database design (relational and dimensional) and implementation. Tools include Toad and MS SQL Server through 2012. Utilized Kimball methodology.-Design and Implementation of SAP BO universes.-Support reporting environment. Tools include T-SQL, SSRS, Power BI, CRS Analyzer, SAP BO-Provide technical analysis, development, on-call support, and maintenance of applications used to manage railroad systems. Tools include Visual Studio 2008-2017, MS SQL 2008 R2-2016, MS TFS, QuickBase, OnBase, Jira, Git-Analyze business requirements and recommend solutions.-Spec and code modifications to existing application code in Visual Studio, SQL Server 2008, SQL Server 2016, and MS Access.-Develop test cases and write test plans.-Compile, prepare, and deploy software releases.-Monitored daily/nightly ETL jobs.

- Provide technical analysis, development, on-call support, and maintenance of applications used to manage a railroad systems. Tools include Visual Studio 2008 and 2010, MS SQL 2008 R2, MS TFS, QuickBase, OnBase. - Work with client and users to analyze the business requirements and recommend solutions.- Spec and code modifications to existing application code in Visual Studio.- Develop test cases and write test plans.- Compile, prepare, and deploy software releases.

Contractor at RailAmerica- Provide technical analysis, development, on-call support, and maintenance of data warehouse applications. Tools included SQL 2000 and 2008, MS VB6, MS Visual Studio 2005 and 2008. SAP BW.- Work with client and users to analyze the business requirements and recommend solutions.- Integrate MS SQL data warehouse with SAP BW.- Provide data analysis and reporting from the data warehouse.- Spec and code modifications to existing application code in Visual Studio.- Develop test cases and write test plans.- Compile, prepare, and deploy software releases.

Contractor at RailAmerica- Provide technical analysis, development, on-call support, and maintenance of applications used to manage a railroad transportation management and EDI system. Tools included PowerBuilder 6.5 and 10, SQL 2000 and 2008, MS VB6, MS Visual Studio 2005 and 2008, proprietary issue tracking system, Crystal Reports 7.0, Sterling's Gentran:Server for Windows 5.1.- Work with client and users to analyze the business requirements and recommend solutions.- Spec and code modifications to existing application code in PowerBuilder.- Develop test cases and write test plans.- Compile, prepare, and deploy software releases.- Manage updates of industry reference data files.- Manage updates of industry EDI standards data mapping.- Setup MS Team Foundation Server for source control and project reporting.- Initiated and created a team-based Wiki in Sharepoint 2007 for centralized publication of standards and guides that was adopted by the support group. - Setup MS Sharepoint 2005 site for collaboration amongst the support group.- Wrote comprehensive SOP (Standard Operating Procedures) manual for the support group. - Wrote comprehensive TOP (Transitional Operating Procedures) manual for use by the support groups in both the US and Sri Lanka, while transitioning duties to the offshore team.- Designed metrics reporting and work processes to monitor the transitional progression and support the managements decision making process.

Contractor at the General Service Administration (GSA)- Project manager, lead architect, and developer on various internal and remote contract management applications using Java, Struts, PowerBuilder 10.0, and COBOL.- Work with client and users to analyze the business requirements and recommend solutions.- Grew team from 9 to 14.- Team lead of 13 that provides development, support, and maintenance of applications in Java, PowerBuilder 9.0, and COBOL.- Work with QA team to develop test case procedures and create test case data using DMSII and PowerBuilder 9.0.- Prepare and deploy all web-based application releases.- Review all code in Java and PowerBuilder.- Develop and implement processes and procedures in keeping with CMM, 3D-VE, and the SDLC.- Transition teams skill sets from PowerBuilder to Java.- Implemented use of PowerDesigner, Rational RequisitePro and Rational Software Architect to produce use-cases, SRS (Software Requirement Specification), Screen and data specs, SAD (Software Architecture Document), and class stubs generation.- Initiated and led committees to produce standards, procedures, and best practice documentation for publication on a Wiki based web site for multiple environments including Java, PowerBuilder, and COBOL.

- Provide business/technical analysis, development, support, and maintenance of applications used to manage class action lawsuit mailings.- Develop test case procedures and create test case data using SQL 2000 and PowerBuilder 7.0.

- Projects include three internal applications for management of projects and contractors including two enterprise applications used company wide by over 600 users and one application used by a single department with over 50 users.- Design and develop web pages for reporting and data gathering utilizing ASP and SQL 2000.- Provide business/technical analysis, development, and support using PowerBuilder 6.5 and SQL 2000.- Redesign application workflow, objects and code for improved navigation and consistency in PowerBuilder.- Design complex report window objects for contractor/project analysis in PowerBuilder with Cornerstone framework.- Code modifications to existing application code in PowerBuilder.- Develop test case procedures, create unit test case data, and perform regression testing.- Compile, prepare, and implement all software releases.- Review all code and train replacement programmer in PowerBuilder.

- Design, develop, and support multiple insurance e-business applications using ASP, IIS, SQL 7.0 and PowerBuilder 7.0.- Manage teams and coordinate a multi-company software integration utilizing XML, MSMQ, ASP, and SQL.- Design and develop an interface from Lotus Domino to Sybase SQL Server 11.5 database.

- Lead architect and manager of teams up to 40 employees in U.S. and India for multiple development projects in PowerBuilder 5.0, 6.5 with Sybase SQL server.- Projects include: human resource package, leasing package, and insurance agency management systems.- Work with business experts, user groups and clients to design applications business flow.- Create and implement standards and protocols for development and customer service departments.- Design a corporate class layer inherited from the PowerBuilder PFC framework.- Setup, train and manage departments to provide; - Installation and support of application and database - Custom software design and development - Conversion software and processing of conversions - Enhancement releases to the application - Quality assurance testing of all software products - Software support for a 200+ client base.- Design and maintenance of all insurance data download interface software via IVANS (ACORD AL3).- Design all modules for rewrite of software from a character-based application to a GUI application. This included writing conversion applications for legacy data to the newly designed database in Sybase SQL Server and performing all the conversions.- Design SQL database for multiple applications including an insurance application with over 900 tables.

- Design, develop, install, and support client-server application in PowerBuilder 5.0 with MS SQL server 6.5.

- Develop, maintain, and test integrated accounting/film industry distribution and production software.- Implement software upgrades.- Develop interfaces for various software products to move data into native accounting system.- Design, code, and test custom program modifications on-site for a major client.- Design, code, and test conversion of accounting modules from Wang's BASIC2C to Foxpro.- Provide software support and training. (Phone/on-site)