Selected Projects Janine Gropp is currently employed by Massachusetts General Hospital in Boston as Manager, Reporting & Applications Development/Database Administrator/Application Developer for the MGPO PBO Information Systems Department. University of California, San Francisco Real Estate Services Property Management Database Application Designed, developed and implemented multi-user Access application for managing properties owned and leased by the University, including property compliance, property taxes, agreements of various types, accounts receivable, and project management. Features include reports by interactive filter; a Mail Generator for selecting property managers, landlords and tenants by various criteria and sending email notices; and a Send Email Notifications interface to control email reminders sent by the database application to the Real Estate Services Department's project managers when critical dates are approaching, such as lease expiration, rent increase, and agreement option dates. Required data migration from non-relational Access 97 database, SQL, and automation with Microsoft Word and Outlook. Image Displayed: Main Menu Scios Inc. (Johnson & Johnson) Adhere Clinical Registry and Contract Management Application Designed, developed and implemented multi-user Access application for managing clinical registries including hospital site contracts and site profiles, product sales, and sales representative and internal employee site responsibility and call log. Features include a Data Exchange interface to retrieve data from the company's Oracle database and update related data in the Access database and workgroup security for 14 users. Prepared training materials and provided customized user training session at implementation. Image Displayed: Application Opening Menu and Main Menu Business for Social Responsibility Media Monitoring Application Designed and developed Access application for monitoring media coverage of a proposed corporate project, and tracking media coverage for multiple projects in the future. Features include form and report graphs of media spin and Report Distribution dialog for selecting contacts to receive reports and distributing selected reports via email attachment. Required SQL and automation with Microsoft Outlook. Image Displayed: Main Menu and Report Distribution Dialog Business for Social Responsibility Stakeholder Mapping Application Furthered development of a user created Access application for tracking project stakeholder organizations and contacts. Added data tables, revised table structure, established relationships/ referential integrity, and created forms and reports. In response to client's need for a visual representation of the relationships between stakeholder organizations and contacts, implemented the AddFlow V4.2 ActiveX component from Lassalle Technologies to generate relationship diagrams from the data. The nodes representing organizations and contacts are placed in one of four quadrants and color coded based on data criteria. Users can edit and save the automatically generated diagrams, and have the option to create a new diagram by adding nodes and links manually. Image Displayed: Relationship Diagram Form with AddFlow V4.2 ActiveX Component LeapFrog SchoolHouse LeapTrack Software Application Development Projects Designed and implemented database structure for state education standards used in the LeapTrack software application and created custom database applications for correlating product data to state education standards and managing product content. Participated in weekly LeapTrack software design meeting and provided written reports at the direction of the Engineering Director. Met project deadlines and technical standards required by the LeapTrack application product launch and release schedule. Image Displayed: Content Database Correlation Form for correlating LeapFrog proprietary learning standards to educational diagnostics and activity books LeapFrog Product to State Standard Correlation Application and Update Tool Designed and developed State Correlation Editor Access application as a solution for LeapFrog education specialists' need to correlate the company's education products to state standards and provide data ready to be incorporated in the LeapTrack application database. As the project required state data to be maintained in separate databases, developed an application Update Tool to automate the process of updating multiple database applications (49 state correlation editors) with new components and data. The Correlation Editor became the primary tool used by LeapFrog's correlation group for correlating products to state educational standards and analyzing product performance. Images Displayed: Correlation Editor Main Menu and Update Tool for updating multiple database applications LeapFrog SchoolHouse Testing Tool and Database Preparation for LeapTrack Software Application Release 1.6 Prepared state databases for incorporation into LeapTrack software release 1.6. Designed and built Testing Tool for running a series of data tests on multiple state databases as part of the QA process. Created database build schedule in Microsoft Project for tracking progress and input from the product development team. LeapFrog SchoolHouse Data Conversion/Importing/Exporting Extensive data migration of state standard data for 49 states. Developed process to extract specific data from Oracle generated csv files provided by MediaSeek, Inc. and import the data into the normalized database structure for state databases. Provided training and support to staff for importing and formatting state standard data using queries and functions.   Kenney and Associates Sales and Marketing Application Designed, developed and implemented multi-user Access application for sales and marketing. Features include Promotion Generator for sending email promotions to selected contacts. Required data migration from Excel and ACT, SQL, and automation with Microsoft Outlook. Image Displayed: Promotion Generator for selecting contacts and sending mailings