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.
• 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.
• 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.
• 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.
• 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.

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