frank setian

United States

@csetian

Seeking new opportunity

Badges

Problem Solving
Java
Sql

Certifications

csetian has not earned any certificates yet.

Work Experience

  • Software Engineer

    New York Shipping Exchange•  June 2022 - January 2024•  New York, NY

    • Collaborated across three teams (Carrier Experience, Shipper Experience, Data Integration) to drive project success and enhance overall system performance. • Developed RESTful APIs for Port of Load/Discharge filters, enhancing user experience and processing time.• Integrated a PostgreSQL database with microservices architecture, enabling cross-environment functionality and improving data consistency. • Automated data synchronization between Amplitude and Vitally using Python and AWS Lambda, resulting in improved user data insights. • Engineered Contracts 2.0 to replace an outdated microservice, significantly improving system scalability and performance. Utilized Java, PostgreSQL, Spring, Hibernate, JUnit, Mockito, Docker, and Kafka. • Integrated Slack into the application, enabling analysts to efficiently upload contract files and receive automated responses, reducing manual processing time. • Developed new RESTful API endpoints, entities, and permissions, ensuring robust security and functionality. • Wrote comprehensive unit and integration tests to guarantee code quality and system stability. • Implemented versioning for Contracts 2.0, ensuring backward compatibility with legacy contract versions and facilitating a seamless migration for existing users.

  • Software Engineer

    Adroit Trading Technologies•  March 2021 - April 2022•  Stamford, CT

    • Hired project team members requiring review of over 800 resumes, selecting interview candidates, contributed to hiring decisions for the project team. • Developed a C# parser for Bloomberg RUNZ/AXE files, standardizing trade pricing data across multiple formats for further processing. • Identified and resolved critical bugs in the order and execution management system, enhancing reliability and user satisfaction. • Designed and implemented a C# simulation program for 3rd-party energy trading platforms, facilitating off-hours testing of system interfaces.

  • Software Developer

    Battea Class Action Services•  May 2018 - September 2020•  Stamford, CT

    • Engineered a Java-based framework to automate the processing, loading, and normalization of client files in multiple formats, significantly reducing manual effort and ensuring consistent data handling across systems • Investigated and resolved performance issues in a legacy C# application that integrated QuickBooks with an Oracle database, streamlining claims tracking and improving payout accuracy. • Collaborated with data analysts to identify and resolve inefficiencies in the data request process, optimizing SQL-based cron jobs and Python scripts, resulting in improved data accuracy and faster reporting cycles. • Enhanced and maintained a Java-based web scraping solution that collected court case data from pacer.gov and RSS feeds, storing results in a JSON format for further analysis. • Created an efficient Node.js script to parse PDF court documents and extract key data, automating document review and enhancing data accessibility

  • Senior Software Developer, Software Developer

    Finacity Corporation•  October 2015 - May 2018•  Stamford, CT

    • Developed a robust reporting platform in Java (Spring, Hibernate) that processes accounts receivable data and generates detailed client collateral valuation reports, supporting daily, weekly, and monthly financial analysis. • Integrated and validated client data into MySQL/SQL databases, creating automated error reports to ensure compliance with receivables criteria and improve data integrity. • Diagnosed and resolved data discrepancies in receivables reports, providing critical support for financial analysts, auditors, and clients through accurate and timely reporting. ● Designed and implemented a modular reporting framework, significantly improving code reuse, reducing maintenance costs, and streamlining client-specific customizations. • Optimized and maintained database archiving processes, enhancing data retrieval efficiency and compliance with storage policies. • Automated the creation of Salesforce Accounts and Contacts from spreadsheets, eliminating manual data entry and reducing processing time by 50%.

  • Software Developer (Internship)

    Connolly, LLC•  February 2014 - September 2014•  Wilton, CT

    February— March, June — September

Education

  • Dartmouth College

    Computer Science, BS•  September 2011 - June 2015

    Discrete Mathematics in Computer Science, Software Design and Implementation, Computer Architecture, Algorithms, Security and Privacy, Object-Oriented Programming, Smartphone Programming

Skills

GIT
RabbitMQ
Petapoco
Oracle
SQL
MySQL
PostgreSQL
Spring
Hibernate
Python
C
Java
C#
Data Structure