Michael Rosenstein Email & Phone Number

Northeast Harbor, Maine, United States

- Design, develop, and test scalable internet applications using Typescript (Angular), Java (Spring Boot, RESTEasy/EJB) microservices, and PostgreSQL databases.- Introduced Scrum and other process improvements. Perform ScrumMaster duties.- Introduced modern frameworks and technologies.- Collaborate with clients and developers to identify requirements and implementation details.- Automated versioned database migration and release processes.- Refactored Java API applications to follow best practices in architecture and coding, increasing maintainability and easing migration to updated technologies.- Refactored project databases to follow data modeling best practices, enforce data integrity, and meet performance requirements.

Portland, Me (Remote)

- Designed, developed, and tested complex, scalable internet applications using Angular, Typescript, state management, Java/Spring Boot microservices, and Activiti business-process management in an Agile development process.- Collaborated with clients, designers, and project managers to identify requirements and implementation details following best practices.- Participate in peer code reviews and provide mentoring.- Provide UX input.- Estimate new project work.

Bar Harbor/Portland, Me

- Created and extended Angular components and BreezeJS/OData services for a cloud-based animal laboratory information management system in an Agile development process.- Converted application from AngularJS to Angular, refactoring it to be more maintainable and expansible. After conversion, development velocity increased and product defects decreased.- Redesigned substantial portions of the user interface to be cleaner and more intuitive. Set UI standards.- Created onboarding wizard to lower cost of customer acquisition.- Created .NET/C# models, controllers, and business-logic helpers, and SQL Server database objects.- Participate in peer code reviews.- Wrote unit tests.

Bar Harbor, Maine

- Implemented the full software stack for two online scientific databases—RegenDbase (regendbase.org) and the Comparative Toxicogenomics Database (ctdbase.org)—using Java (Spring Boot, Spring Security, JDBC, JEE), PostgreSQL, Oracle, Rserve, JavaScript/jQuery, JSP, and FreeMarker. These applications support complex biological data queries and visualizations in fast, intuitive web interfaces.- Created a Java/Spring application to extract, transform, and integrate data from 16 external resources. The application included generic modules for loading any structured vocabulary, and could refresh data with no downtime.- Gathered requirements from scientific staff.- Designed and maintained data models and database objects.- Tuned SQL queries to meet performance goals.- Analyzed large-scale gene expression data using R. Implemented pipeline for creating miRNA binding-site predictions.- Created a public REST API.- Contributed to publications, grant applications, and budgets.- Completed complex database migration (Oracle to PostgreSQL), achieving substantial cost savings and performance improvements.- Led development and management of the institution's public websites. Maintained highly customized WordPress instances with multiple interrelated custom post types.- Led adoption of Confluence as the institution's intranet platform, thereby modernizing many processes and yielding cost savings.

Bar Harbor, Maine

- Worked with business and scientific staff to analyze requirements and design and document data models for complex scientific and administrative systems.- Inventoried institutional data resources to identify integration opportunities. Negotiated with data owners and implemented a mart to federate common data.- Led the institution's Data Resources group, procuring and managing subcontracted services, creating budgets, and managing a database administration team.- Set data modeling standards. Evaluated new technologies.

New York Ny

- Data-architecture subject matter expert responsible for working with clients of this McCann Erickson affiliate to translate promotional strategies into databases for high-performance web applications.- Supervised and approved all database programming. Created project estimates and budgets.- Analyzed, designed, and documented data models. Created optimized tables, triggers, stored procedures, and queries for Oracle and SQL Server. Performed Oracle and SQL Server database administration.- Implemented strategies for distributing data among heterogeneous systems.

- Technology manager responsible for leading the live-chat product's data architecture and for helping define product direction.- Led a team of database administrators and programmers to execute all phases of database development.- Designed and maintained a complex, flexible data model able to address both short- and long-term needs. Created and optimized SQL Server and Oracle tables, stored procedures, and triggers.- Migrated data from SQL Server to Oracle, and from an obsolete data model, writing 300 stored procedures in three weeks.- Created a fault-tolerant database infrastructure, and defined global data distribution strategies.- Designed a data mart to facilitate reporting.- Set coding and data modeling standards.

New York, Ny

- Responsible to senior management for all technical aspects of the Sony Music internet presence, including business-to-business applications, email lists, streaming media, and consumer websites for Sony Music, Columbia Records, Epic Records, and 500 recording artists.- Led and performed requirements analysis, system design, data modeling, coding (C, Java, Perl, SQL), and testing and optimization of high-traffic, database-driven websites in a heterogeneous data environment using Oracle and Netscape Application Server. Performed database and system administration.- Managed a team of programmers and system administrators. Coordinated efforts with external contractors and internal divisions.- Created daily traffic reports for hundreds of websites.- Set development and infrastructure standards.

New York, Ny

- Worked with clients and internal teams to analyze and model project requirements and to design and implement Sybase (Solaris) data stores for interactive web content.- Leveraged understanding of content from both creative and technical perspectives to perform data modeling; to develop and tune stored procedures, triggers, and other database objects; to contribute to the creative process; and to create documentation for both technical and non-technical audiences.- Designed and implemented the data layer for the online catalog of Bantam Doubleday Dell using data extracted, cleaned, and augmented from legacy systems.- Analyzed requirements and managed projects.

New York, Ny

- Worked with clients at this mid-sized law firm to analyze complex legal issues, and to implement solutions to those issues.- Provided broad aspects of corporate and securities legal representation, including negotiating and drafting agreements relating to secured financings, stock and asset acquisitions, mergers, shareholder arrangements, employment/consulting arrangements, and trademark licensing; preparing filings under federal securities laws; formulating employee codes of conduct; and performing legal research and drafting memoranda of law.

Bachelor Of Arts (B.A.) With High Distinction, Political And Social Thought

Activities and Societies: Honors Thesis: "Dostoevsky and Zamyatin: The Soviet Utopia Gone Wrong"; Echols Scholar; Intermediate Honors.

Certificate, Relational Database And Structured Design

Activities and Societies: Guest Lecturer - Database Technology and the Internet (1996), Teaching Assistant - Sybase Server Technology.

Doctor Of Law (Jd), Law

Activities and Societies: Associate Editor (Notes and Comments) - New York University Law Review