Sheel Patel Email & Phone Number

Meriden, Ct, Us

New Haven, Connecticut, United States

As a Jr. Software Engineer in the Data Management team, I support the development and maintenance of Data Warehousing and Data Mart solutions that power reporting and analytics for critical areas like Finance and Human Resources at Yale. I work with Talend, SQL, and Git, contributing to various projects aimed at optimizing our data processes and improving our codebase management.Key Projects:• Talend Job Performance Analysis: Analyzed task completion times using data from the Talend Administrative Console (TAC). Cataloged average and maximum task durations to identify discrepancies between actual and timeout values, enabling performance optimizations.• Timeout Optimization: Updated Talend tasks based on calculated averages and maximum durations to establish efficient timeouts, ensuring jobs run effectively without prematurely terminating long-running tasks.• Git Repository Cleanup: Evaluated and managed the cleanup of Talend branches in Git Enterprise, ensuring consistency and eliminating obsolete branches to streamline development processes.• Data Mart and Staging Jobs (FACILITIES): Worked on Data Mart and Staging jobs using Talend Studio for the FACILITIES project. Tasks included retrieving schemas, duplicating and modifying jobs, updating Talend components, and validating data loads. Focused on accurately loading and verifying data in specific tables and coordinated SQL updates to ensure job success and data integrity. • Automated the extension of job schedules for Talend jobs using Talend Studio, SQL, and TAC. Created a job to verify pending dates, add a year of future dates, and remove dates older than one year. Developed SQL scripts for job run date retrieval and pending date calculations. Implemented a monthly TAC job with dynamic orchestration for efficient automation.

New Haven, Connecticut, United States

SQL / JobSub• Developed a JobSub for managing Math and Science surveys, including resetting surveys and clearing responses.• Utilized SQL skills to set up and manage jobs with unique identifiers and input parameters.Dynamic Forms• Created and implemented an online form for Jackson Institute GA Financial Aid, integrating API to retrieve student information and ensuring functionality through thorough testing.• Transitioned the financial aid process from paper-based to digital, with automatic email notifications for submissions.Intake Form / Qualtrics• Designed an IT support request form using Qualtrics, streamlining issue reporting with CAS-based user detail automation and integration with Jira/Email for automatic ticket creation.• Implemented features for categorizing issues, setting priorities, and automatic alerts for critical issues.YaleSites• Led the platform upgrade of YaleSites from Drupal 7 to Drupal 10, using Siteimprove to identify and fix broken links and enhance user experience.• Supported multiple departments in the upgrade process, ensuring the platform's enhanced usability and functionality.Confluence Documentation• Created comprehensive Confluence documentation for SafetyNet, ISA, and GPDEC, including end-to-end testing and test case documentation.•Analyzed code for decommissioning old SSB8 Packages and performed thorough analysis for Autosys Jobs in Dev/Test environments.Decommissioning old SSB8 Packages + Autosys Jobs• Conducted detailed code analysis and used SQL queries to check dependencies, managing the migration process in Jenkins.• Performed in-depth analysis of Autosys Jobs scripts and dependencies, ensuring a smooth decommissioning process.

Berlin, Connecticut, United States

Master Of Business - Mba It Management

Bachelor'S Degree, Computer Science

Associate'S Degree, Computer Science