Burt Melvin Email & Phone Number

Greater San Diego Area

Database administrator (DBA) supporting 42 Oracle and 23 HANA databases for the SAP Basis team.• Oracle Database: Installed, integrated, tested, maintained, and supported Oracle 8.x to 11g (11.2.0.4) for large and small databases running SAP systems. Reviewed and tuned Oracle parameters to improve performance as per SAP standards. Performed daily database health checks.• SQL Performance Analysis: Proactively reviewed Shared Cursor Cache to find poorly performing SQL and found additional… Show more Database administrator (DBA) supporting 42 Oracle and 23 HANA databases for the SAP Basis team.• Oracle Database: Installed, integrated, tested, maintained, and supported Oracle 8.x to 11g (11.2.0.4) for large and small databases running SAP systems. Reviewed and tuned Oracle parameters to improve performance as per SAP standards. Performed daily database health checks.• SQL Performance Analysis: Proactively reviewed Shared Cursor Cache to find poorly performing SQL and found additional poorly performing SQL via OEM12c. Implemented solutions that improved SQL performance. Regularly performed index rebuilds and table reorgs to reclaim space and improve performance.• Health Checks Automation: Streamlined time devoted to health checks by automating health checks of all databases using HP Unified Functional Testing (UFT) tool. Automation resulted in seven-fold reduction in time (3.5 hrs. to .5 hr.) dedicated daily to health checks. Database issues and collected statistics were stored in Microsoft (MS) Excel spreadsheet for easy review by DBAs, as well as health check history for auditors.• OEM 12c: Installed and configured OEM12c to monitor Oracle databases and generate email early warning alerts to correct issues before they became problems for users.• Capacity Planning: Experience in capacity planning and space management. Performed resource estimation and calculation based on statistics and projections.• HANA Database: Refreshed test systems from production. Performed health checks.• Backup/Recovery and Refreshes: Performed database refreshes and restores using Veritas NetBackup Show less

Greater San Diego Area

• Installed and certified SAP Business Warehouse (BW). One of the first SAP clients to install SAP BW version 1.0.• Tested and certified loading data into BW Info Cubes and documented the process for other team members.

Greater San Diego Area

Greater San Diego Area

• MicroStrategy DSS: Installed, configured, tested, and certified DSS Architect, DSS Server, DSS Web and DSS Agent to analyze and report on customer electric consumption for marketing group.• MicroStrategy Standardization: Established and documented standards for testing, QA, and production. Documented naming standards and client access privileges.

Greater San Diego Area

• Information Technology (IT) department representative to Customer Operations and Customer Service client groups.--- Took lead role in resolving client issues and concerns related to IT.--- Facilitated bimonthly PC Partner meeting.--- Promoted new software and hardware to advance IT product standardization and upgrades via oral presentations.• Desktop 97: Planned, collected data, and coordinated Desktop97 installs for 427 clients. Data Warehousing: Assumed the lead role in… Show more • Information Technology (IT) department representative to Customer Operations and Customer Service client groups.--- Took lead role in resolving client issues and concerns related to IT.--- Facilitated bimonthly PC Partner meeting.--- Promoted new software and hardware to advance IT product standardization and upgrades via oral presentations.• Desktop 97: Planned, collected data, and coordinated Desktop97 installs for 427 clients. Data Warehousing: Assumed the lead role in implementing data warehouse datamarts. Show less

Greater San Diego Area

• MS Windows Development: Developed Windows Client/Server applications using Gupta’s SQLWindows development tool.• Database Administration: Performed DBA duties including installing, tuning, upgrading, and table maintenance for Gupta’s SQLBase database.• Standardization: Created application development and testing standards for SQLWindows application development

Greater San Diego Area

• Management: Managed a group of five Information Specialists. Duties included interviewing, hiring, and employee performance reviews.• Strategic Directions: Defined the strategic and tactical plans for group.

Greater San Diego Area

• IT department representative to Capital Markets Group, which included Trading Desk, Wire Transfer, Secondary Marketing, and Financial Planning.--- Took lead role in resolving client issues and concerns related to IT.--- Promoted new software and hardware to advance IT product standardization and upgrades via oral presentations.

Greater San Diego Area

• Created New Group: One of four Information Specialists who pioneered an Executive Information Services group to implement PCs, local area networks, and tools to access mainframe database.

Greater San Diego Area

• Management: Managed a group of four programmers. Supported the mainframe Customer Information System.• Duties included interviewing, hiring, and employee performance reviews.

Greater San Diego Area

Greater San Diego Area

Greater San Diego Area

Greater San Diego Area

• Profitable Innovation: Developed innovative software to convert data into a Customer Information System that condensed the conversion process to 24 hours from the norm of two weeks. HomeFed packaged and sold the conversion programs to other financial institutions yielding over $250,000 in profit.• Application Development: Developed many mainframe applications using COBOL. Supported ATM card system, accounts statement processing, and various programming projects.

Bachelor Of Science - Bs, Business Administration, Management And Operations

Business Administration, Management And Operations