Database Administration Resume Profile
Experience: Confidential
Manager, Real Estate Services,Pennsylvania State Employees Credit Union, Harrisburg, PA. Responsible for overall supervision of Real Estate Servicing and Real Estate Closing unit. Responsible for numerous Real Estate Departmental projects and functions including real estate regulatory compliance, advanced report creation and automation, FICS Mortgage Servicer administration and testing, FNMA profile and technology manager administration, RealEC administration and other projects and tasks as assigned. Compliance duties include analysis and implementation of new RESPA and Regulation Z rules and forms including revised Good Faith Estimate, revised HUD1 and HUD1A, updated Truth in Lending documents, updated Fact Act documents, updated Adverse Action Notice and others. Analyzed, coordinated and updated SAFE Act quarterly call reporting for real estate area. Analyzed, tested and coordinated document updates related to SAFE Act. Advanced report development and automation included numerous pipeline management reports, updated delinquency distribution reports related to risk management, out of state loan reporting and analysis and a variety of quality control reports for both real estate servicing and real estate processing.
Confidential
Manager, Real Estate Servicing Unit
Responsible for overall management and maintenance of approximate 15,000 loan 600,000,000 real estate loan portfolio including oversight of Adjustable Rate Mortgage maintenance, Escrow Analysis and maintenance, flood and homeowner insurance tracking and maintenance, payoff and satisfaction functions, FICS mortgage servicer software administration and testing. Managed Home Equity Line of Credit Promotion, Homeowner Loan informational tool project, Automatic Loan issuing conversion project, numerous letter automation projects, quality control report design and automation. Supervised 9 full time employees.
Confidential
Manager, Database Administration
Responsible for analysis, development and implementation of all database projects at the Credit Union. Designed and implemented numerous databases for support of various web based and traditional client / server applications. Developed internal web based applications to view database information stored in Microsoft SQLSERVER. Interviewed, hired and developed employees. Scheduled external training as needed. Analyzed hardware / software needs and made recommendations for upgrade as necessary. Extensive use of T transact -SQL, DTS package development, SQL profiler. Supervised two full time employees.
Confidential
Programmer Analyst / Database Administrator, Pennsylvania State Employees Credit Union, Harrisburg, PA. Responsible for analysis, design and implementation of numerous client / server applications at Credit Union. Developed and implemented application to extract information from Mortgage Processing System and create loans on Mainframe system. Assisted with development of a message based connection object used to communicate with mainframe server. Re-designed and implemented a new consumer loan application system. Extensive use of Object Oriented design and programming methods. Extensive use of Visual Basic 6, COM, some HTML, some XML, some JAVA.
Confidential
Software Support Manager
confidential
Primarily responsible for supporting the Credit Services department from an ITS perspective. Created numerous system reports, working with the Internal Audit department to enhance security within various Credit Services systems, integrating laser generated forms into the Mainframe loan system, implementing a bi-weekly mortgage payment option for our membership and working with the Real Estate unit in selecting a new Mortgage origination and servicing system. Supervised 1 full time employee.
Confidential
Manager, Real Estate Servicing Unit
Responsible for management and maintenance of approximate 5,000 loan 225,000,000 real estate loan portfolio. Escrow management, assisted in design of various automated rate adjustment/escrow analysis programs, escrow tracking system, loan maintenance. Knowledge of RESPA and Fannie Mae servicing guideline / regulations. Supervised 13 full time employees.
Confidential
Manager, Credit Services Telephone Unit
Responsible for initial setup, training and implementation of a call center handling more than 1000 loan related telephone calls per week. Extensive use of Microsoft software packages, including Word, Excel and Access. Extensive use of AT T Call Management System on Definity G3I telecommunications system including standard report interpretations and custom report design and implementation. Supervised 7 full time employees.