Jr. Systems Analyst Resume Profile
3.00/5 (Submit Your Rating)
Richmond, VA
Experience
- Technical Director
- Project Management / team lead
- Systems analysis and design
- Software engineering / testing
- Structured programming and analysis
- System and program documentation
- Customer liaison and support
Professional Experience
Confidential
Jr. Systems Analyst
- While participating in the Confidential Project for the Confidential:
- Assisted in the extraction, transformation and loading of an ORACLE Data Warehouse / Data Mart.
- Developed several ORACLE scripts to verify data / key mapping in over 1100 tables in six Database instances.
- Providing ongoing ORACLE table maintenance by manipulating data, while ensuring data integrity.
- Providing ongoing customer support through writing, installation, maintenance, and modification of moderately complex operational programs and procedures, including stored procedures and triggers.
- Perform other duties as assigned by a Senior Database Administrator or Program Manager, or as the situation dictates.
Confidential
Web Developer
- Designed, developed, programmed and implemented several web-based applications for local businesses.
- Designed, developed, programmed and implemented a web-based application for a local church.
- Assisted in the development of several web-based applications, including a local restaurant.
Confidential
Student
- Designed, created, populated and implemented an Access database. Created and executed database reporting procedures.
- Designed and wrote Visual Basic programs to access an Access database, allowing Add/Delete/Update and reporting functions with Crystal Reports .
- Designed and wrote VB.Net programs to access an ADO.Net database, allowing Add/Delete/Update and reporting functions.
- Designed, wrote and executed several C and C programs.
- Designed, created and published interactive web pages using Dreamweaver, Flash, HTML.
- Designed, wrote and executed several Java programs.
- Designed, wrote and executed several ORACLE SQL and PL/SQL procedures to perform Add/Delete/Update and reporting functions.
- Designed, wrote and executed several Add/Delete/Update and reporting functions using Oracle Developer.
Confidential
Consultant Software Engineer IV
- Acted a member of a team responsible for the online Combat Service Support Training Simulation System for the U.S. ARMY Logistics Exercise and Simulation Directorate.
- Provided direct support through development, maintenance, enhancements and manual Quality Assurance of the Personnel Sub-System. Maintain multiple version control of CSSTSS load modules across 20 CICS regions on 2 LPARS.
- Prepare and present presentations to upper management GS and Army Officers proposing system enhancements for increased efficiencies and detailing project status.
- Resolved production problems and monitored on-site on-line Exercise Control Center for all systems during War Simulation exercises on a 24/7 shift and as required basis. Monitor systems during War Simulation exercises using Landmark's TMON product for CICS regions and TCPIP connectivity.
- Attend coordination meetings with Corp. Battle Simulations group for linkage considerations to all the US branch service simulation models for joint exercises.
- Maintain Personnel Sub-System documentation manuals for Applications, EXD, SIMD, Translator, Systems, Special Models, and Communications groups
Confidential.
Co-Owner
- Provided Desktop computer support for customers, including MS Windows and MS Office training.
- Provided trouble shooting and problem resolution.
- Installation of hardware and software products according to customer needs.
Confidential
Consultant
- Acted as a member of a team responsible for Y2K Systems remediation, manual Quality Assurance testing and implementation of over 1200 programs for a major brokerage firm.
- As a member of a Systems and Programming team for a major financial institution, I was responsible for:
- Systems used for the routing and settlement of all financial data, and direct support through maintenance, enhancement and testing of the Routing Settlement Data Entry System.
- Conducting full System weekly and monthly Quality Assurance tests using test files I built from existing production files prior to complete production turnover of approved results.
- Providing one week per month 24/7 on-call support of the Routing Settlement Data Entry System insuring proper balancing of all related accounts, and production problem resolution.
- Attending meetings with upper management to coordinate and plan system updates and changes.
- Establishing workflows for the processing of data for mergers and acquisitions.
Confidential.
Consultant
- Performed analysis, programming, documentation, testing, maintenance and user interface / training of a Legacy accounting system for the Va. Dept. of Transportation.
Confidential.
Consultant
- Acted as a participating partner, providing electronic forms consultation and custom form design.
- Provided application design, and programming services for customers.
- Software included MS Windows 3.1 / 95, Delrina FormFlow, Winfax Pro, Jetform, and Borland Visual dBASE.
Confidential.
Consultant
- Acted as a member of a team responsible for the conversion of a Medicaid Management Information System for First Health Services Corporation.
- Software was TSO/ISPF, JCL, CICS, COBOL II, and VSAM data files.
Confidential.
Consultant
- Provided conversion of COBOL and CICS programs of a Dunn and Bradstreet Human Resource Payroll package for the University of Virginia.
- Provided conversion of COBOL, VSAM and CICS programs to COBOL, CICS and IMS for the Va. Department of Social Services.
- Implemented Easytrieve and Easytrieve Plus/IMS ad-hoc reporting services.
- Implemented LIBRARIAN.
- Trained 12 members of systems personnel in the use of Confidential and Easytrieve and Easytrieve Plus/IMS.
- Trained 25 users in the use of Personal Computers, Windows, and WordPerfect.
Experience Summary
- Database: Oracle 10g, ORACLE Forms, Reports, SQL Server, DB2, IMS, Datacom/DB, Microsoft Access, Borland dBase
- Web Development: HTML, Dreamweaver, Flash, Adobe Photoshop, Fireworks, Freehand, MS Frontpage
- Programming: SQL, PL/SQL, Visual Basic 6, VB.Net, COBOL II, CICS, C , Java, HTML, XML
- Tools/Utilities: Toad for Oracle 8.6, Erwin, TortoiseCVS, MVS JCL, TSO/ISPF, LIBRARIAN, FDR, Assist/GT, NDM, TMON, SYNCSORT, IMS, CA7, VSAM, APS, NDM, CHANGEMAN, INFOPAC, SAS ETL
- Project Mgmt: MS Project, Scrum Works
- Business Apps: Outlook, MS Office Suite, Easytrieve, Easytrieve Plus/IMS
- Operating System: Windows 98, 2000, XP, DOS, Unix, IBM, Unisys
- Miscellaneous: Formflow, Jetforms, Winfax Pro