Sean Jeffries Email & Phone Number

Continued to work as the Agile Product Owner for the Database Compliance stack for our enterprise-class database inventory system. Worked with Enterprise Governance and Oversight teams to provide evidence that security policies were fully and completed tested against all supported database platforms. Worked with DBAs to develop and implement testing methodologies for each policy in our automated tool.Acted as Lead Product Owner for our group, guiding other Product Owners to help them become more proficient in the role. Helped our team get stronger at writing effective user stories, manage road maps and story boards, and more efficiently bridge the communication gap between stakeholders and the development team.While in this role, our team was understaffed, which required me to also act as the sole developer for the Database Discovery and Compliance software clients, designing, writing, and implementing the code for our automated programs. While it was challenging to be in both the Product Owner and Developer role at one time, it also helped me to become better at writing effective user stories and efficiently manage our Jira backlog.Obtained my Scrum Alliance Certified Product Owner certification in March, 2022.

Charlotte, North Carolina, United States

Agile Product Owner for the Database Compliance stack for an enterprise-class database inventory system. With strong technical knowledge of a variety of DBMS platforms, engaged with governance and DBA teams to craft security and non-security policies for every database system in the enterprise. Helped devise automated testing methodologies for each policy.Worked with scrum team and scrum master to regularly modify Database Compliance and Discovery code to meet policy revisions and to onboard new DBMS platforms into the inventory system. Responded to requests from internal support team to help troubleshoot and resolve questions brought by the DBA teams concerning Compliance results. Worked closely with governance teams to respond to audit requests and reporting needs.

Charlotte, North Carolina, United States

Maintained and improved Jython code utilized by the Mercury Application Mapping system to collect database inventory and compliance information.Worked as a team lead for a group that architected and directed the creation of an enterprise-class intranet web application to manage inventory and compliance of over 170,000 databases across all major DBMS platforms in the enterprise. Technologies used are Linux, Apache, Oracle 12c Exadata, Object Oriented PHP 7.2, MVC framework, SQL, Perl, XML, JSON, ExtJS JavaScript library, SOAP / RESTful Web Services, and AJAX.Sole developer for the Database Discovery software used to detect instance and database inventory for Oracle, SQL Server, Informix, DB2 LUW, Aster, Couchbase, Hbase, MongoDB, MySQL, PostgreSQL, Progress, Sybase and Teradata. This modular software also retrieved patch information, password change information for system accounts, database encryption, database size, and database backup details for each DBMS platform, and was the key source for populating the inventory system. Sole developer for the Database Compliance software used to test DBMS software for adherence to internal security and non-security policies, providing results back to the enterprise inventory application for all of the database products listed above. Interfaced with DBAs to help explain and troubleshoot policy violations on various DBMS platforms. Worked with Database Competency Center governance teams to respond to audit requests and to collect requirements for changes to Discovery and Compliance clients. Wrote complex SQL to provide reporting for regulatory requests submitted through the governance teams.

Charlotte, North Carolina, United States

Continued to work as a DBA for the Branch Automation and Branch Entry applications after the First Union acquisition of Wachovia. Slowly transitioned to an internal DBA development team that focused on writing tools for use by the DBAs. Wrote a database inventory system in C# to track and maintain information about all databases in the bank. Wrote a dynamic DBA reporting system in C# with data stored in DB2 on Z/OS to allow DBAs to quickly define various reports. DBAs were able to feed data into the reporting system directly from DB2 to provide a variety of reports on a rapid basis.Developed ISPF panels and REXX programs to continue to automate daily tasks for DBAs.Rewrote the previous mainframe-based DBA workflow system into a more robust C# web-based application that provided full tracking of DBA engagement requests from start to finish.

Charlotte, North Carolina, United States

Primary DBA for Branch Automation and Branch entry applications. Designed and created application tables and databases and helped troubleshoot and performance tune complex queries. Pioneered transitions to emerging DB2 technologies including parallelism and data sharing groups, transitioning to DRDA from DB2 Private Protocol, partition independence, and migration from BMC utilities back to IBM native tools. Wrote REXX and ISPF tools and utilities for the DBA team to help automate routine tasks, including generating IMS PSBs for new application programs, executing DB2 bind adds as needed by application teams, generating utility jobs for image copies, reorgs, and database recoveries. Wrote automated workflow system for application developers to engage DBAs for work. Participated in disaster recovery tests, architecting recovery strategies for high volume mainframe applications. Created standards for weekly full image copies with daily incrementals and added automation so that new jobs would not need to be created every time a table was added to a database.Worked closely with the DB2 and IMS System Support team to develop and maintain common subroutines used by applications to facilitate message switching between IMS regions and to determine the target DB2 subsystem for distributed queries. Performance tuned system support applications to save over one million dollars in mainframe chargeback costs annually. Wrote assembler "shield" program for the powerful DSNTEP2 utility to prevent applications from using it to work around DBA standards while still allowing DBAs to utilize it in their JCL jobs.As DBAs started working from distributed locations, wrote a persistent chat instant messaging system that was used by over 200 DBAs before technologies such as Skype emerged. The low-impact VB6 program leveraged UDP and message encryption for secure communications over TCP/IP networks, allowing DBAs to stay in touch with each other throughout the day.

Charlotte, North Carolina, United States

Sole developer for the Branch Automation application, writing and maintaining IMS and CICS screens used by branch tellers to query deposit account information. Back end data was stored in DB2 and IMS databases on OS/370, utilizing both SQL and DL/I to access data. Wrote software in APS and COBOL, with back-end jobs managed via JCL running through CA/7.Participated in conversion efforts from legacy banking systems to the First Union Emerald deposit system for Florida, South Carolina, and Georgia. Onboarded other states into Emerald as First Union acquisitions pushed into the Northeastern region of the United States. Wrote and maintained Automated Voice Response Unit applications on both Infobot and Periphonics units that accessed IMS screens to provide information to customers. Rewrote previously existing IMS screens used by Infobot to improve performance on the mainframe to eliminate large dollar chargeback amounts.

Bachelor'S Degree, English Language And Literature, General

Associate'S Degree, General Studies