Software Developer Database Administrator

Paul G. Ackerman **********@*****.*** • 361-***-****

Software Developer Database Administrator linkedin.com/in/pgackerman • Buffalo, NY I 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. SKILLS

Java • Microsoft SQL Server • Azure • Sybase • Postgres • Python • Linux scripts • JavaScript • Visual Basic • C

• C++ • XML • JSON • Apache Maven • Apache Tomcat • Project Leadership • Database Architecture • Process Optimization • Change • VS Code Management • Requirements Definition • Project Management • UX Design • Problem Solving • Continuous Improvement • Training Development • Architecture Engineering CAREER HIGHLIGHTS

London Stock Exchange Group (LSEG) Buffalo, NY

Database Developer May 2022 – July 2024

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 Del Mar College Corpus Christi, TX

Software Developer and Database Administrator October 2006 – April 2022 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.

• 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 Paul G. Ackerman • Software Developer Database Administrator **********@*****.*** • 361-***-**** • Page 2

Del Mar College Corpus Christi, TX

Software Developer July 2001 – October 2006

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 o 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

o 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

Del Mar College Corpus Christi, TX

Adjunct Instructor January 2001 – May 2006

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

EDUCATION

Rochester Institute of Technology Rochester, NY

Master of Science – Software Development and Management May 1993 Buffalo State College Buffalo, NY

Bachelor of Science – Information Systems Management May 1991

Contact this candidate