Sean Palac

Data Engineer

Locust Point Capital•  January 2024 - August 2024•  Remote

Automated Investor Relations reporting using Docker and Python scripting to generate Financial Quarterly reports, saving up to 80 man hours per quarter Created new KPI pipelines in DBT and Snowflake to deliver brand new investor requested data on an ad hoc basis, giving insights to prospective clientele and removing the need for 8 hours of manual calculation per investor Implemented Validation and Profiling to preexisting KPI streams to provide data security in DBT Integrated data from multiple sources, such as DBT, Fivetran, and SFTP, into a Snowflake data warehouse Used Tableau to automate the generation of Investor Reports on a quarterly basis to provide useful information on both past Net Cash Flows as well as KPI Projections to inform future investor decision making

Python/SQL Developer II

PWC•  December 2021 - January 2024•  Remote

Design a multitude of asynchronous function apps to integrate with Azure Service Bus and front end web application requests Remove a major client bottleneck of manual data correction by creating and streamlining data ingest functionality to analyse and present data inconsistencies to the user, allowing for user feedback to drive backend functionality Resolve bugs and re-factor calculations that resulted in data calculation timeouts. Increased efficiency such that timing of KPI calculations and generation of client requested workpapers was reduced by nearly 90% Develop ETL pipelines for clients to manage their data processing to become compatible with cloud storage in Azure Head development of validation and profiling scripts to automate reporting on data that was received from clients, ensuring proper data standards were met during ingest and transformation processing Created a proof of concept for automated validations for implementation with future Azure Data Factory projects, reducing the time needed for client agnostic work Demonstrated the functionality of our data processing platforms to client representatives in weekly “Show and Tell” sessions

Java Developer

Common Securitization Solutions•  April 2019 - December 2021•  Remote

Lead our data correction team through the use of intricate PL/SQL queries and procedures as well as overall understanding of our platform to correct incidents issued by our clients or internally; this effort often leads to collaboration with 5 other modules, requiring me to become competent in the processes across the whole of our platform Implemented fixes across two interconnected, yet independent, teams in order to optimize code performance and data reliability Utilized git bash and bitbucket, along with the Jira tools suite, to work in a collaborative environment with other developers Utilized core competencies in SQL and Java to triage production data and code errors in order to delivery a quality data product to our clients Provided real-time constant communication with our client facing business team as to what data issues we were experiencing and provided steps to resolve these issues