Systems Analyst Resume

PROFESSIONAL SUMMARY

15 years of experience in all phases of Oracle database development and design.
Experience in designing database table structures, views, complex stored procedures, relational database design, SQL and PL/SQL tuning, triggers, SQL Loader, and Export/Import of data.
Extensive knowledge of multiple table queries for customized complex reports.
Highly skilled in analyzing information, converting data and ETL (Extract, transform and load data).
Ability to handle simultaneous projects and providing clients with extensive support, training, and troubleshooting during their implementation and project life cycle.
Develop scripts to load test data in oracle.
Oracle Data Guard synchronization of the primary and standby database.
Experienced in working in a global team environment.

TECHNICAL SUMMARY:
Language: PL/SQL, SQL
Database: Oracle 7, Oracle 8, Oracle 9, Oracle 10
Software: Oracle Forms, Oracle Reports

WORK EXPERIENCE:

Confidential, Union, N.J. May 2001 - November 2010
Systems Analyst

Created and enhanced application using Oracle forms and reports
Created and maintained stored database triggers, functions and procedures using PL/SQL
Collaborated on development, testing, and implementation of new modules added to software
Upgraded and developed reports from clients' specifications
Identified and fixed deployment problems of new application modules
Provided client support and training
Implemented finished programs from test environment to a live environment at client sites
Deployed table and data changes using SQL at the client live environment
Developed lifecycles and time tables for assigned projects

Confidential, Union Beach, N.J. July 1998- May 2001
Programmer Analyst

Led and directed a team of three programmers
Developed, tested, and implemented a more cost-effective purchase order printing process
Created stored database triggers, functions, procedures
Created public and private synonyms for tables, views, and functions
Worked in a global team environment and supported manufacturing systems operating in Mexico and United States
Designed and developed advanced reports in SQL and Oracle
Contributed to start-up planning and development for several manufacturing sites
Developed and supported the back-end of company e-commerce site on an Oracle Database

Confidential, Mahwah, N.J.November 1995 - July 1998
Programmer Analyst

Client/Server application development
Created and enhanced Client/Server application using Oracle forms
Created and maintain PL/SQL procedures, functions, and stored database triggers
Contributed to database development and design
Created and altered Oracle tablespace and Users
Created public and private synonyms for tables, views, functions and procedures
Provided client support answering questions about the application and assisting with Oracle and application setup

EDUCATION:
Bachelor of Science in Computer Science
Oracle Education New York City, N.Y.
Oracle 7 Database Administration July 1997
Oracle Reports 2.5 July 1998
Business Objects New York City, N.Y.
Business Objects 4.0 Manager Course October 1996

REFERENCES: Available Upon Request

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship