Scott Mallory Email & Phone Number

Connecticut, United States

Connecticut, United States

Indianapolis, Indiana, Us

As a Remote W2 contractor, developed a file parser app to create an Error Tracking System to enhance the visibility of data aggregators for automated dispense reports. Created ETL processes to parse PDFs and generate data tables to be used for datafeeds. Review, optimize and create SQL reports to support pharmacology sales reporting. Worked with the Analytical Team members on improving SQL performance. • Utilized Amazon Redshift, Postgres, Python, BOTO3

Managing the fiduciary assets as Durable Power of Attorney for an elderly parent. Coordinated assisted living resources and continuing health care oversight. This is ongoing, responsibilities are only a few hours a month.

Newton, Ma, Us

Analyzed, documented, and offered improvements to the AWS Aurora (PostgreSQL 12) Cluster(s) for the Identity product. Initiated a Data Governance Framework. Implemented an AWS IAM authentication method removing U/P database access for the development team. Designed a “Least Privileged SQL Role” data access model. Created a migration plan to go from AWS RedShift Provisioned to AWS RedShift Serverless. Developed a multi-region Aurora Postgres diagnostic, reporting and editing application in Python (Boto3), capable of connecting to 45 clusters, each with ~3.5k databases. Mentored co-workers in advance SQL querying techniques. • Utilized Amazon RDS/Aurora, RedShift, S3, Lucid Charts, Python, Dataframes

Maintained and improved the AWS Aurora (PostgreSQL 13) Cluster for an Electronic Medical Records (EMR) web application (SaaS). Created deployment scripts to support CI/CD utilizing Docker containers to keep on pace with the DevOps team. Introduced Liquibase CE as migration tool for database changes/release. Created changeset management tool written in Python 3 to support Liquibase changesets in a CI/CD pipeline. Developed a SQL API to help manage PGP encryption via AWS Lambda to support HIPAA (Safe Harbor Method). Designed and implemented data migration script (Python/AWS S3) to move data from Snowflake to Postgres.• Utilized Amazon RDS/Aurora, S3, Lambda, Liquibase CE, Python 3, Docker, Snowflake

Waltham, Ma, Us

Designed, developed and maintained a Tenant Database Management System for AWS Aurora (PostgreSQL 10). Including unit testing (pytest) and deployment via Jenkins (CI/CD) leveraging docker containers (docker-compose).Designed EVA, 3rd, 4th normal form data models, and created/tested migration scripts for prototype database concepts. Created a text-based SQL DDL/DML extractor for client archival needs (in lieu of Oracle DATAPUMP). Maintain and extended diagnostics scripts and packages (ORACLE PL/SQL) for metrics gathering. Created and maintained user documentation to support SQL querying, diagnostics, and performance. Participated in larger discussions with leadership on long-term software design strategies and operational improvements to the current data store.• Lead the migration from Oracle to Postgres • Refactored legacy platform JAVA methods into scalable SQL functions and stored procedures as needed• Lead team of 3 Sr. SQL Developers • Maintain Oracle Package documentation and host trainings as needed• Utilized Amazon RDS/Aurora, Oracle SQL*PLUS, 11g XE, 12c SE, Postgres, Lucid Charts, Docker, Kubernetes, Jenkins

Branford, Ct, Us

Focus is on database SQL development and query speed optimization.

Branford, Ct, Us

Refactor and analyze SQL scripts for performance. Create diagnostics scripts and packages (Oracle) for metrics gathering. Create and maintain user documentation to support SQL querying, diagnostics and performance.* Rewrote the PFS installation documentation. * Created a standalone web application installer and supporting documentation. * Create custom SQL views, stored procedures and functions for clients as development needs* Tuned database schemas as needed by analyzing indexes and performance metrics* Utilized Oracle 11g, 12c. Install4j6.

East Hartford, Ct, Us

Assist the CEO with short and long-term strategic business goals, managed a multi-skilled team of developers and designers. Drafted design specifications for client engagements and drafted contracts.• Work with clients to address their business needs and offer cost effective and timely solutions • Write project proposals, timelines and design specifications• Create and maintain internal business documentation for streamlining hiring and onboarding processes• Oversaw the implementation of ConnectWise • Stepped in as a developer to as needed• Managed 5 contract employees