We provide IT Staff Augmentation Services!

Senior Programmer Analyst Resume

PhiladelphiA

Summary:

Solutions-focused Information Technology professional with 20+ years of experience
Proficient in developing SQL queries, PL/SQL procedures, functions, packages and triggers
Involved in all phases of development lifecycle (SDLC)
Strong analytical, problem solving and troubleshooting skills
Ability to work independently and in large team environment
Ability to manage multiple projects at the same time

Technical Skills:

Software: SQL, PL/SQL, JAVA, JavaScript, HTML, JSP, AJAX, COBOL, JCL, IDEAL, DQRY
Databases: Oracle 9i-10g, CA-DATACOM/DB
Tools: Toad, Eclipse, Tomcat, CVS, Crystal Reports, IREPORTS, MS Office Package
OS: Windows (NT, XP, 7), OS/390

Experience:

Confidential, Philadelphia 1990-2011

Senior Programmer Analyst 2000-2011

Key projects included but not limited to: Students Transfers System, Textbook Storage System, FAFSA, Records Management System

  • Successfully owned, governed and maintained end-to-end system life cycle for FAFSA and Textbook Storage applications systems
  • Worked as a lead database developer for Records Management application system
  • Worked as a lead JAVA and database developer for Students Transfers application system
  • Designed and build new database structures
  • Created PL/SQL functions, stored procedures and packages
  • Developed and tested scripts to create, extract, convert, and load databases
  • Generated scripts to create and alter database objects, including: tables, views, primary keys, indexes, constraints, sequences, dB links, grants, synonyms and triggers
  • Worked directly with end-users to determine needs for system requirements
  • Participated in analysis, specification building, design, and development of new and re-engineered Web-based applications
  • Developed test plans, test scripts and test data.
  • Gathered test results and provided feedback to the project manager
  • Documented defects and provided quality solutions and results in collaboration with multidisciplinary staff
  • Developed a variety of activity reports using Crystal Reports and IREPORTS

Programmer Analyst 1995-2000

Key projects included but not limited to: Students Transfers System, Kindergarten Report Cards System, Pre-First Report Cards System, Elementary/Middle reports Cards System, Transportation System

  • Responsible for database design, modeling, and conversion of various application systems from DATACOM to ORACLE environment and coexist/complement mainframe
  • Load the data from Mainframe environment to Oracle database
  • Worked on performance tuning of the SQL queries to improve data conversion process
  • Performed Unit Testing, Integration Testing and Performance Testing
  • Fully documented and developed IDEAL programs to unload VSAM data to the correct format for relational DATACOM database
  • Responsible for writing mainframe requirements, analysis and design of batch and on-line database applications
  • Worked as a lead DATACOM database developer on Students Transfers System, Kindergarten Report Cards System, Pre-First Report Cards System
  • Expertly designed and developed a wide range of activity reports using Crystal Reports

Programmer 1990-1995

Key projects included but not limited to: Students Transfers System, Kindergarten Report Cards System, Pre-First Report Cards System

  • Designed and developed application programs in Cobol and IDEAL
  • Responsible for the maintenance and enhancement of new and existing systems
  • Prepared workflow charts and diagrams to present detailed explanations about the input, output, and logical operation of the various mainframe systems
  • Performed quality assurance testing on both individual and complete system basis
  • Developed a wide range of reports for various student side systems

Education:

BS in Computer Science, Economics and Mathematics

Trainings:

Oracle PL/SQL Programming Application Development and Tuning for Oracle Developing SQL Queries for Oracle Databases Relational Database Design

HTML and Cascading Stile Sheets (CSS)

Developing Java Web Applications Hands-On Crystal Reports

CA DATACOM/DB

Hire Now