Tom Ostberg Email & Phone Number

Windham, Nh, Us

Dover, Nh

Modeler for MondoDb persistent store improving performance from sql db and for dynamic claims processing. Created the model into a mongoDb database with multiple collections, using mongoDb Schema Validation and generating indexes. Created the MongoDb collections in EC2 mongo community edition instances as well as Atlas development, test and production instances Working as the Data Analyst at the Agile Train Level across 7 teams across 3 departments to bring multiple lines into one new architectural bundled model for UI Capture and a Model for Consumers like rating, reporting, data lake and downstream users. Also produce mysql schema DDL and database tuning performance improvements.

North Reading, Ma

Wrote java classes for relaying messages of status, alerting and errors via Lambda interface to Tote Palletizer Kinesis analytics application. Completed a Transshipment history data capture via kinesis to Redshift, with aggregations in kinesis applications, EC2 and in Redshift. Produced a DynamoDb data capture for SSP to help determine tote error issues, the DynamoDb data was streamed via lambda to kinesis and into redshift for analysis and tableau reporting.Working as the lead MySql Db developer of the Advanced Programs team for warehouse stow and pick automation. Developed small persistence and aggregation warehouse for long term analysis and dynamic error analysis. I was the team resource for database internals concentrations in performance analysis, new feature data persistence, operation and support tool query optimizations, application managed data. Also develop schema patch control and release mechanism as well as aid with production performance issues.

Danvers, Ma

Transferred data warehouse to the Amazon Cloud Red-shift platform. Did deep dive into how the query was compiled down into node separations and sort order structures specialized.Lead all aspects of software development as Database Architect and Systems Analyst including requirements analysis, effort estimation, technical investigation, design and implementation. Provided verification that components and processes are scalable, reliable, and maintainable through disciplined development and structured unit testing. Lead the development, review and enhancement of best practices for applications development. Organize with other disciplines (QA, Security, Product Management, and Sales & Marketing) to ensure implemented applications meet both business requirements and technical requirements.Responsible for developing realtime call buisness logic systems with 3 years of realtime call and transer data. Engineering team lead to plan, designing, implement and rollout an architecture for the organization’s data warehouse. It was 3 terabytes of data across multiple star structures from which it supported enterprise cubes for the Portal, Billing, Analytics and reconciliation extracts. Used .Net to generate several CLR’s for use when building DWH items like alerting web service connection, GMT conversion, universal ticks to & from UTC, Took 5 disparate call control database repository systems and converted it to a standard single company design, which grew to cover all of the company’s clients. Based on this initial system, redesigned it to one master system with satellite smaller servers for real-time near to call host access during an online call. Designed / created centralized enterprise configuration schema that kept central configuration for all Eliza tools and what was previously operation spread sheets. Team Lead for a large development group that generated reports and monitoring tools that the Network Operations Center began to use 24x7 in a dedicated center.

Participate in all aspects of software development including requirements analysis, effort estimation, technical investigation, design and implementation, unit testing, and bug fixing (SDLC). Program, test and implement components and applications following established system development standards and guidelines. Provide verification that components and processes are scalable, reliable, and maintainable through disciplined development and structured unit testing. Research and recommend software tools available to increase development productivity and efficiency. Lead the development, review and enhancement of best practices for applications development. Organize with other disciplines (QA, Security, Engineering, and Compliance) to ensure implemented applications meet both business requirements and technical requirements.

Manager of the Teambase content management database group. Designed a database classification system for storing IPTC and other category attributes based on the nested set method of displaying hierarchical data in a relations SQL database. Built in archival knowledge so that online, near line and offline file asset metadata can be stored within the database and allowing archive specific storage retrieval mechanisms are programmed into the server. Added a keyword system that can be hierarchical and full text searchable using the Microsoft full text index mechanism. Developed dynamic navigators that worked off of the metadata that is stored with the assets. The navigator will change as the metadata changes so that users can organize assets by changing the metadata. Managed the development and production builds using Perl scripts and CVS as the basis. Developed a customer issue and bug tracking in-house system with web and Access front ends.

Developed a Microsoft SQL server database for a new relational newspaper publishing system on an NT server. Became a part of the Microsoft Developer Network in order to keep up with new developments and support issues with the SQL server. Migrated database from SQL 6.5 to latest release of SQL 7.0, then upgraded to SQL 2000. Wrote special auto view generator procedures for use with personalized attribute and info browsing of the article queues. Continuing support throught adding features like permissions & roles, session tracking, maintenance scavengers, statistics & reports, as well as consulting on future directions.

Wrote converter programs to change a C++ application into a Java bean based relational database application. The conversion process was to transfer the C++ structures into database tables, then transform them into a new database relational model. I was also directly responsible for creating the model and the transformation SQL to move the data from the flat structure into the new relational model. The conversion program converts the ANSI SQL files and database DDL into either Oracle, MSSQL or Cloudscape (a pure java database implementation). The java application reads the database schema and outputs an XML & annotated XML templates. These then are used to generate a database access layer of classes as the interface to the database of choice.

Created an administrator's design center for a Java based online live help system. This design center was used to create account information, users and add detailed operational information that will enable the Hey application to function correctly. This was accomplished by generating XML messages to maintain a MSSQL database on an NT web server, and present the data for modification through web pages automated with Java Script functions for user presentation and validation. These pages are created by Java Servlets for object maintenance and for collecting and filling out HTML templates.

Wrote Java Servlets that read data from an oracle database with RMI functionality and created a dynamic HTML page for instructor and student personal home pages as a part of an online book subscription system. Used Java scripting for the site specific hot buttons and servlet starting features. Wrote Java Applets for database access and subscription list creation.

Working at Liberty Mutual as the Sybase Database analyst currently involved in design and analysis of a next generation billing system which consists of multiple Sybase databases, C++ backend billing processes and remote ware house data connections for retrieving accurate data. Developed stored procedures for integrity checking and correction of a workers compensation billing database. Wrote stored procedures for calculating large deductible invoices across four databases of 2.5 gigabytes. Also developed a UNIX based batch process manager ( C & Scripts) for controlling execution and error handling of scheduled tasks. Write integrated error reporting and source code control system based on RCS, PERL, and CSH scripts in Unix.

Certification

mongoDb Atlas Security, Aggregation Framework, Data Modeling, Mongo Performance, Cluster Administration etc

Master'S Degree Program, Inprocess, Computer Science, Completed 3/4

Bachelor Of Applied Science

Education record

Bachelor Of Science (Bs), Biology/Biological Sciences, General

Storytelling, Storytelling Alliance

Activities and Societies: Mass-mouth Inc., New Hampshire Storytelling Alliance, Fugitive Productions, True Tales Live, Story Slam.netNPR.