Rachel Young
Software Engineer - SQL Developer, Business and Data Analyst
************@*******.***
www.linkedin.com/in/rachel-young Barnstable, MA
Skillful and highly analytical SQL developer and analyst with 25+ years’ experience in systems analysis, database management, data conversions, and application development as well as roll out and support. Capable of increasing reliability and introducing system efficiencies through in-depth analysis. Ability to determine potential deficiencies and co-ordinate corrective actions to improve application performance. Proven success developing full-stack, creating user interface, and developing solutions to meet all reporting needs as well as implement complex batch processing. Demonstrated expertise in coordinating multiple tasks from initiation to completion in deadline-driven environments. Expert communicator; capable of liaising across multiple levels, while focusing on long-term relationship building. Ability to transfer business needs into technical specifications.
Technical Proficiencies, Knowledge
MS SQL Server (2000-2019), T-SQL, SSMS, SSRS, Powerbuilder (ver5-2021), Oracle, PL/SQL, Informix, MySQL,Visual Studio, some C#, Python, Power BI, Java Script, XML, COBOL, Mainframe, MS Office, Access, Excel, Teams, OLE, Git, AWS, Jira, Rally.
Career Experience
National Student ClearingHouse, New Jersey (contract) Remote Independent Contract Jan 2023 – current
Systems Engineer
Responsible for designing, analysis, coding, implementing and managing application development and support of enrollment /
degree verification application in Powerbuilder with Informix/ESQL/SQL Server backend processing.
Arch Reinsurance Ltd - Hamilton, Bermuda (contract) Remote Independent Contract Oct 2021 – Nov 2022
Systems Engineer
Responsible for designing, analysis, coding, implementing and managing application development and support of the policy administration and accounting systems across the global reinsurance segment. One year contract. Provide direct Production support to users at all levels of corporate structure including data analysis.
Design, develop, maintain and enhance multiple Powerbuilder applications and back-end (SQL Server/Oracle) calculation modules. This included all phases of development of back-end procedures, functions, tables, triggers, reports and extracts. Created TEST/QA Plans. Designed and implemented EDI Processing. Execute technical knowledge transfer and training to newer staff members.
Woods Hole Oceanographic Institute (contract) Remote Independent Contract January 2020 – current
Systems Engineer
Design, develop, maintain and enhance multiple Powerbuilder applications and back-end (Informix/PL SQL) calculation modules. Upgrade application to PB 2021. This included all phases of development of back-end procedures, functions, tables, triggers, reports and extracts. Created TEST/QA Plans. Execute technical knowledge transfer and training to newer staff members.
Alexander Associates – Marstons Mills, MA 1988-2021
Senior Software Engineer
Contribute to seamless functioning by developing robust systems to meet diverse needs across multiple industries. Play integral role in execution of cost-effective, secure, and user-friendly solutions for long-term scalability as well as durability, by assessing user concerns and business requirements. Locate and resolve complex processing issues by leveraging debugging and problem-solving skills at all levels of software development lifecycle. Enable organizations to gain competitive advantage by implementing robust next-gen solutions, systems, and applications, while ensuring maximum customer satisfaction. First and foremost, one cannot develop software successfully without being a business analyst and understand its operation and needs.
Identified and determined wide range of business needs by designing sophisticated user interfaces.
Served pivotal role in generation of complex, parameter-driven batch calculation modules while maintaining exceptional performance standards.
Fulfilled customer expectations in deadline-driven environment by collaborating with team members to develop systems while monitoring schedules.
Oversaw end-to-end reporting needs of all customers by retrieving and manipulating data while providing effective formatting and presentation. Tools included Powerbuilder, Sql Server, Oracle,OLE Automation, Informix extracts, some Power BI
Directed client-server applications by creating full-stack development to improve digital agency via utilization of multiple databases, including MS SQL Server, Oracle, and Informix.
Built and sustained effective relationships with key business partners across multiple organizations, ranging from scientific institutions to Fortune 500 companies.
Utilized Powerbuilder (ver5-2021), for over 25 years producing fully integrated robust applications with menus, windows, data entry screens and reports in relatively short period. Linking SQL Server, Oracle and Informix on backend using scripts, functions, store procedures and triggers. Currently enhancing a Marine Biology application within Powerbuilder. From 2005 to present, designed/implemented Insurance Systems (UW, PA, Cash, Accounting, Claims, Cessions, IBNR, EDI) producing sophisticated windows, screens, procedures, functions, excel extracts, reports. Migrated to PB 2021 for GitHub. Design Unit and QA Test Plans.
Education
BS in Computer Math and Statistics – 1984 Graduate
Keene State College – Keene, NH
MA Real Estate License - 2015