User details
PA
PA
Paul Ackerman
@paul_ackerman_61x6w5kqz
Accessibility and Accommodations Expert
Depew, NY, United States
0Follower0Following0Mutual0Post
Member since: Jan 22, 2025I am a senior software developer and database administrator with a passion for creating, integrating, and maintaining software systems with a nearly 30-year track record in the financial and educational sectors, specializing in relational databases, system optimization, and complex problem-solving. Demonstrated success in project leadership and providing effective business solutions.
Responsible for enhancing the Yield Book platform, a leading fixed income analytics solution, maintaining data integrity and accuracy, managing data ingestion from multiple sources and resolving issues for the Yield Book system. Including database migrations, development of Python and Linux scripts improving system performance and operational efficiency.
• Implemented the new Mortgage-Backed Security Index in LSEG's Yield Book offering allowing customers to see the Security Index Worldwide
• Ensured Data Integrity and resolved discrepancies from data ingestion scripts that loaded financial data into LSEG's Yield book fixed income system which provides industry wide analytics and market leading financial models to customers
• Migrated Database systems from Sybase to Postgres developing Python Scripts to Verify Data Accuracy during migration from Sybase on-premises to Postgres using AWS
• Ported Scripts to migrate from Sybase to Azure ensuring data integrity and seamless migration
• Developed and maintained Linux scripts related to treasury, corporate, and mortgage bonds
• Utilized SSIS to migrate data from on-premises Sybase to Azure
Charged with creating, evolving, and supervising the maintenance of advanced software in addition to managing the integration of external software systems for a higher education institution, resulting in enhanced system performance, increased operational efficiency, ensured data accuracy, and adherence to standards, as well as time and cost savings.
• Designed and developed the student username creation system in Java to populate Active Directory with all new students and to disable inactive student accounts
• Led implementation and integration of Blackboard and Canvas distance learning systems into existing systems and processes
• Designed and developed an ETL template that transferred data from the college's ERP to various web application databases. . Utilized SSIS to migrate data from cloud-based AWS SQL Server to on-premises SQL Server in addition to writing custom Java ETL programs
• Designed and developed a reporting template that created Microsoft Excel workbooks in native XLS and XLSX formats using Java
• Successfully migrated ERP database from on-premises MS SQL Server to Amazon AWS RDS and wrote scripts to backup and restore ERP database to an on-premises location for analysis
• Designed and developed many scripts to automate database administrative functions such as backing up and restoring databases for internal groups and outside vendors
• Designed and developed every database used in custom-built applications
Responsible for the design, development, testing, and maintenance of Visual Basic and Java-based applications. Collaborated with experienced developers to implement best coding practices, contribute to problem-solving sessions, and participate in all phases of the software development lifecycle
. Lead development team that designed, developed, and implemented the first online grade reporting system in the state of Texas for a higher education institution Eliminated manual scanning sheets saving significant instructor time and administrative overhead as well as reduced costs by eliminating the need to purchase and process bubble sheets Prevented millions in fines from the Department of Education as the existing manual process was not compliant with student attendance reporting requirements
• Designed, developed, and implemented a Visual Basic application that monitored the progress of dual credit students, which are students that can take one course to satisfy high school and college requirements
Taught various computer science courses covering topics such as computer history, database programming, and object-oriented programming. Developed and delivered engaging lectures, assignments, and assessments that enabled students to acquire and apply foundational and practical skills of computer programming. Provided feedback and guidance to students and collaborated with other faculty members to ensure the quality and consistency of the curriculum.
. Introduction to Computers - Focused on the history and evolution of computers through time . Introduction to Database - Focused on foundational relational database concepts including referential integrity, CRUD, schemas, relational model, queries, and more
• Computer Programming - Focused on the basics of object-oriented programming using C++ . Database Programming - Focused on the basics of SQL Programming in Microsoft SQL Server
• Advanced Database Programming - Focused on advanced SQL scripting concepts and applications in Oracle