Programmer/Analyst/Database Administrator Resume Example
Love this resume?Build Your Own Now
PROGRAMMER/ANALYST/DATABASE ADMINISTRATOR
Summary
A creative, resourceful and flexible professional offering a broad range of IT experience with proven abilities in PC, mid-range, and mainframe systems design and implementation; legacy system conversions; Database development/management; strategic planning; installations and support. Principal strengths include analytical, technical, team building and problem solving. Offering excellent communication, interpersonal, and research and planning abilities.
Highlights
| DB2 * SQL * COBOL 2 * MS SQL Server * JCL * SAS * Chrystal Reports * MS Office Suite * MVS * ISPF/TSO * Electronic Data Interchange (EDI) * IBM Utilities * UNIX * Shell * C * Informix * Connect:Direct * FTP * Visual Basic * Oracle * ChangeMan * Syncsort |
Experience
Programmer/Analyst/Database Administrator
January 2008 to January 2009The College Of William & Mary － Williamsburg , VA
January 2008 to January 2009The College Of William & Mary － Williamsburg , VA
- Analyzed, created, and installed 3 new Microsoft SQL Server 2000 databases to replace 6 existing databases for the AT&T Treasury Operations group reducing database management cost by 50%.
- Drafted new reports using Crystal Reports for a returned mail application.
- Collected and composed requirements for new client/server web application working directly with programmers from India, tracking progress with internal tracking system.
- Production support, maintenance, and new development of COBOL II / DB2 mainframe application.
- DATABASE MANAGEMENT: Performed maintenance for 27 Microsoft SQL Server databases used by all 6 of the AT&T Treasury Operations applications.
- Result: Databases that were stable, efficient, and reliable 100% of the time during non-maintenance periods.
Programmer/Analyst/Database Administrator
January 1997 to January 2008The College Of William & Mary － Williamsburg , VA
January 1997 to January 2008The College Of William & Mary － Williamsburg , VA
- Created 100% of the new tables, columns, indexes, and table loads for 5 IBM DB2 databases used for development, testing, and production.
- Continuously provided subject matter expertise to 65 banks, billers, and other financial institutions using Connect:Direct to ensure an uninterrupted flow of transactions to/from Remittance Resolution System.
- Planned, coded, tested, and debugged 35 COBOL II / DB2 application programs to redirect lost payments while maintaining legacy PL/1 application.
- Designed and implemented a large IBM DB2 database consisting of 60+ tables using normalization methodologies and techniques resulting in a stable, efficient database requiring minimum enhancements.
- SOFTWARE DEVELOPMENT: Created, designed and implemented a solution for corrupted data in the largest consumer billers by writing 3 COBOL II programs to correct data and report to upper management daily for 6 months.
- Result: Customers' accounts 100% accurate saving AT&T over $8M, obtained one of the highest honors - "The Circle of Excellence Award".
- Daniel Hoyle Page 2 PROCESS DESIGN / AUTOMATION: Developed a weekly archive process to reduce the amount of production data stored in 31 DB2 tables.
- Result: Data was moved successfully saving time and cost reducing production data storage by 85%, and increasing data retrieval time by 60%.
- DATABASE DEVELOPMENT: Planned, created, and installed 100% of the new tables, columns, indexes, and table loads for 5 IBM DB2 databases used for development, testing, and production.
- Result: All tables, columns, and indexes created or updated in a timely manner for the applications supported by the databases.
- TROUBLE SHOOTING: Investigated several long running batch jobs to determine the root cause by creating and testing new indexes for 7 key DB2 tables.
- Result: The job run time was reduced from 5 hours to 3 minutes.
Programmer/Analyst
January 1996 to January 1997Lucent Technologies － City , STATE
January 1996 to January 1997Lucent Technologies － City , STATE
- Successfully cloned and implemented all EDI processes from AT&T Financial Services Organization for Lucent Technologies giving Lucent Technologies a state-of-the-art EDI system, allowing Lucent Technologies to conduct Electronic transactions on the first day of business.
- COST REDUCTION / AVOIDANCE: Utilized existing resources, and developed a process to receive 100's of electronic files using Connect:Direct from 3 different trading partners, then sent electronic files back to the trading partners.
- Result: $50K savings in cost avoidance, plus over 480 man hours in development time.
Programmer/Analyst
January 1984 to January 1996AT&T, Inc － City , STATE
January 1984 to January 1996AT&T, Inc － City , STATE
- Streamlined the production EDI processes for AT&T Financial Systems Organization saving AT&T over $100K annually.
- Designed and Developed entire host interface for the AT&T Transfer System to interact with Conversant Script Builder establishing the largest Conversant system ever for AT&T HR systems.
- Implemented 10 and 12 hour shifts in the AT&T Hourly Manufacturing Payroll System.
- Contributed in the development of the AT&T Customer Network Design Tool replacing the manual method of system engineers increasing the efficiency of the work flow, and operations by 500%.
- PROGRAMMING / CODING: Participated in an EDI Pilot Program with the IRS by designing, developing, and coding the processes required to file quarterly payroll taxes electronically.
- Result: All major corporations use a variation of this trial to report payroll taxes electronically to the IRS.
Education
Bachelor of Science : Computer ScienceDeVry Institute of Technology － City, StateComputer Science
Interests
Database Administrator, Programmer, Analyst, DB2 DBA, MS SQLServer, ETL, SQL, Cobol, SAS, MVS, Excel, Powerpoint, Word, Access, RPG, EDI, JCL, File Transfer, FTP, Connect:Direct, Coding, Software Development, Cost Reduction, team building, Crystal Reports.
Additional Information
- Awards Circle of Excellence Award for exceptional Software Development Star of Excellence Award for outstanding Cost Reduction / Avoidance Star of Excellence Award for outstanding Process Design / Automation Award for Patriotic Service from U.S. Department of Treasury Keywords: Database Administrator, Programmer, Analyst, DB2 DBA, MS SQLServer, ETL, SQL, Cobol, SAS, MVS, Excel, Powerpoint, Word, Access, RPG, EDI, JCL, File Transfer, FTP, Connect:Direct, Coding, Software Development, Cost Reduction, team building, Crystal Reports.
Skills
art, AUTOMATION, C, client/server, COBOL II, COBOL 2, COST REDUCTION, Crystal Reports, Databases, database, DATABASE DEVELOPMENT, database management, designing, Electronic Data Interchange, EDI, Financial, FTP, HR, IBM, DB2, MVS, Informix, ISPF, JCL, mainframe, mail, MS Office Suite, 2000, Network Design, Oracle, Payroll, PL/1, PROCESS DESIGN, processes, CODING, PROGRAMMING, progress, SAS, Shell, Script, SOFTWARE DEVELOPMENT, MS SQL Server, Microsoft SQL Server, SQL, Syncsort, tables, taxes, Treasury, TROUBLE SHOOTING, TSO, UNIX, IBM Utilities, Visual Basic, work flow
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Completeness
- Formatting
- Word choice
- Length
- Measurable results
- Clear contact info
- Typos
Resume Overview
School Attended
- DeVry Institute of Technology
Job Titles Held:
- Programmer/Analyst/Database Administrator
- Programmer/Analyst
Degrees
- Bachelor of Science : Computer Science
Similar Resumes
