Senior Programmer Analyst Resume Philadelphia - Hire IT People

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

We provide IT Staff Augmentation Services!

Senior Programmer Analyst Resume

PhiladelphiA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship