Programmer Analyst Resume Profile
4.00/5 (Submit Your Rating)
HIGHLIGHTS OF EXPERIENCE
- Hardware: PC, Sun Workstation
- Environments: UNIX, MS Windows 98, MS Windows NT, MS Windows 2000
- MS Windows XP, MS Windows Vista
- Programming Languages: Visual Basic, SQL, C , HTML5, XML, JAVA, Visual Foxpro
- Software: Oracle Application Express, SQL Server, Oracle 10, Oracle 11G, TOAD, SQL Developer, MS Access, Sharepoint 2010, MS Excel, MS Powerpoint, MS Word, MS Outlook, Adobe Acrobat, Flash MX, Visual Basic 6.0
EMPLOYMENT SUMMARY
Confidential
- Made additions to the ICEPIC program using Oracle Application Express with an Oracle database. This program is used by Department of Homeland Security agents to gather information on immigration-related criminal activity. Created numerous screens and updated the back-end.
- Performed installations of Oracle 11G and routine maintenance of log files.
- Set up various databases in Oracle, adding indexes to improve speed and performance. Maintained backups of the DLL files containing scripts for these databases.
- Created Extract, Transform and Load ETL processes. Performed data analysis on several databases. Once analysis was completed, used Data Transformation Services DTS packages to pull data from external databases to staging databases. The DTS packages were written in SQL Server Enterprise Manager, where the data was loaded into text files and transferred to the staging area using SQL Loader.
- Made additions to the CITF program using Oracle Application Express with an Oracle database. Created new screens, updated existing screens and modified tables and stored procedures used in the back-end. This program is used by the Central Intelligence Task Force to process information on terrorist activity gathered by field agents.
- Assisted in creation of a Sharepoint Site containing pages for several departments in the office Training, Technical Sharing, etc. , with sections for adding new documents, Point of Contact data and other information.
Confidential
- Maintained and updated the Chart Management System medical software, which tracks patient appointments, medical records and physician schedules for various medical centers. Programming was done in Visual Foxpro.
- Created the Patient Kiosk program, which allows patients to use a touch screen interface to sign-in using a Patient ID when visiting a medical center.
- Created and maintained various tables in MySQL.
Confidential
- Maintained application to track parts and supplies used on Dahlgren base.
- Participated in development of a web-based document tracking library and tracking system using VBScript and Java.
- Updated various tables in SQL Server.
- Confidential
- Programmed the Information Requirements Database IRD using MS Access and Visual Basic 6. The Database serves as a repository for FORCEnet related requirements and associated Programs of Record, allowing requirements analysts to research and run assessments on current and future FORCEnet requirements.
- Programmed the SATCOM library database, which was used to maintain a library of SATCOM documentation deliverables. The database had a GUI interface, allowing the user to navigate through intuitive forms to update SATCOM file information.
- Performed reviews on FORCEnet related documents, making revisions where necessary.
Confidential
- Programmed numerous Web Based Training WBT courses in Flash MX and HTML. The courses were run on the internet and used by clients to train new employees.
- Performed thorough testing of the WBT courses. Test plans were developed for each course, and a comprehensive test results report detailing problem areas was submitted to the WBT course developer.
Confidential
- Programmed Access applications that tracked garment orders received from clients. Each application was tailored to the client's garment needs size, color, etc. and used a GUI interface to enter orders and generate invoice reports.
- Programmed an Access application to track the use of company vehicles, generating monthly gas and maintenance costs. These reports were filed for tax purposes.
- Developed training manuals for Microsoft Word and Microsoft Excel classes taught at headquarters.
- Created and updated forms used in daily operations e.g., Purchase Order Requests, Travel Vouchers, New Hire Information
- Wrote numerous reference manuals. These manuals included The New Users Guide given to new employees and containing instructions on working within the Windows and Unix environments and The Backup Procedures Guide detailing the process for running backups at headquarters and in the field .
- Developed and maintained user manuals for various programs developed by the company.
- E-mailed memos to the field notifying them of new software releases and updates.
Confidential
- Programmed Access applications to process monthly inventory tapes received from clients. Each application used a GUI interface to import the tape data into the database and generate reports showing any discrepancies between the company and client data.
- Programmed an Access application that tracked calls made by the company's student loan collectors. Collectors entered the date and time of the call, as well as notes on what transpired during the call. At month's end, call data for the month was transferred to tape with the click of a button, for shipment to the Department of Education.
- Maintained databases for several clients, and generated financial reports from these databases on demand.
- Wrote test plans for several programs. Executed the tests and submitted test reports to the programmers, detailing problem areas encountered and recommending program changes where appropriate.
Confidential
- Wrote code patches for the SG R program, written in C and running on a Unix network. The development focused on the resolution of Software Trouble Reports STRs . Software Design Document modifications were made based on changes to the code.
- Edited several Program Design Documents PDDs , including the Decoy Module PDD and Built-In Test Module PDD.
- Developed Verification Validation V V test procedures for the AN/SLQ-32 V system. Executed the tests and wrote detailed test reports upon completion.