Steven Morgan Email & Phone Number

Providence, RI, US

• Led E2E/UAT testing as part of the OpenBank national expansion - Horizon transformation for Back Office and Contact Center.
• Managed work streams for our onshore cross functional team.
• Responsible for the delivery of accurate on-time testing coverage.
• Automated reconciliation of work and generation of test strategy utilizing artificial intelligence.
• As part of digital readiness to understand the migratable customer base, we leveraged the data analytics team to assist in KDE identification to build Branch Teller-ATM metrics.
• Leveraged JIRA for product design to build test scripts.

Boston, Massachusetts, United States

• Communicated weekly with stakeholders on delivery timeline, design, and defect management.
• Architected and oversaw Customer Data Quality control models spanning across 500 key data elements and over 10,000 data quality rules.
• Hosted discussions with Data Owners and Data Stewards to capture the business and technical requirements.
• Prototyped rules-based code in SAS/SQL/R/Python/DB2/Access.
• Maintained JIRA with appropriate code and metadata.
• Hosted sprint meetings with off-shore to facilitate Informatica IDQ ETL development.

Boston, Massachusetts, United States

• Led a small cross-functional team dedicated to reverse engineering the analytics behind the mail-in marketing campaign
• Impact: Savings of $1.2M Annually
• Architected and developed SAS/SQL code to generate Customer Data reports.
• Reverse-engineered code by analyzing the data fields, reformatting fixed-width compact-field binary files from Mainframe, transforming the data in SAS, and exporting the final datasets as csv files.
• Implemented automation through the Control-M team to execute the code and generate the data feeds monthly.
• Spearheaded Change Management requests and facilitated discussions for CIO and CISO sign-off.

Boston, Massachusetts, United States

• Performed Azure Migration assessment of customer databases.
• Infrastructure recommendations (Movement to Azure PaaS) and assessment of the SSIS compatibility with Azure (lift and shift, data management gateway, express route, custom components, refactoring, design changes).
• Comparison of Azure SQL Managed Instance and Azure Data Warehouse assessing the benefits, security, cost, compatibility, data types, and cross database joins.
• Security assessment and recommendations for on-premises and Azure databases (compliance and risk).
• Designed a database architecture utilizing Azure SQL Managed Instance and refactored SCD (slowly changing dimension) SSIS components.

Boston, Massachusetts, United States

• Client was looking to upgrade from on-premises to cloud services.
• Their datasets come from disparate sources, their data mart was exorbitantly slow, and they had increasing tech-debt.
• Our team analyzed the current state of their database architecture (SSIS/SSAS based).
• One of our recommendations for a quick win was to repartition their SSAS cube for a more performant Data Mart.
• A more in-depth analysis of their applications, databases, SSAS cube and Data Mart architecture was performed in terms of optimal performance, scalability, and ease of use/maintenance.
• Issues presented themselves relating to data movement and security, transformation logic, and data load jobs.

Smithfield, Rhode Island, United States

• Co-led a cross-functional team for our global transformation to LIMS 2.0.
• We migrated 900k+ combined environmental and physical property data elements.
• Delivered core components ahead of target date and exceeded our team in Ireland's expectations.
• Trained on GMP and instrumentation in Biochemistry, Analytical Chemistry, and In-Take Laboratories.

• INBRE Funded. Chemistry and Biochemistry departments collaborated on designing a system with a polarizing beam splitter and dual-channel detection of single-molecule fluorescence to determine fluorescent anisotropy.
• Fluorescence anisotropy measurements contain a large amount of raw information about intrinsic properties of molecules, and their environments.
• The data collected was used to analyze the size and form of each molecule, the stiffness of their internal structure, and the viscosity of its environment.
• Our effort was focused on protein-protein interactions and receptor-ligand binding.

• INBRE/NSF Funded Project. Published our work 'Drug Design as a Video Game' where we showed how our team designed, produced, and tested Tamoxifen derivates.
• Small sample production was performed in-house.
• Tested on bio-assays with the 3ERT protein complex in our sister lab at URI.
• In Silico design performed using the Molinspiration software suite.
• Taking large sets of molecules, utilizing their short-form SMILES format and preparing the molecule dataset for protein docking by converting to 3D format.
• Utilizing the cell microprocessor on the PS3, our team used Genesys' electrionic High Throughput Software (eHiTs) to collect physical property data (e.g., Binding Affinity) on 1M+ conformations of tamoxifen derivates.