We provide IT Staff Augmentation Services!

Systems Programmer Analyst Resume

New Jersey, NJ


Professional Experience

Systems Programmer Analyst, Confidential, 2006-Present
Oracle DBA, Systems Administrator and Programmer for Sungard Higher Education ERP software(Banner) suite including setup and configuration. Support Administrative users and systems through project management, analysis, design, programming, testing, implementation, system review, follow-up and closure. Provide Oracle database administration including backup and recovery, cloning, and maintenance. Web programming skills using Oracle Developer Suite 10g, TOAD, PL/SQL, Web PL/SQL, HTML, and Oracle Forms. System Administration and report development for the Cognos BI reporting tool as well as supporting the data warehouse reporting environment. Support many other 3rd party applications relating to the ERP including application server setup and support using Oracle Application Server.
Software: Oracle OAS 10g, Orcale RDBMS 10g, Developer Suite 10g, PL/SQL, Web PL/SQL, HTML, Oracle Form, JavaScript, Java, CSS, VBScript, TOAD, Cognos, Oracle Application Server(OAS), C, Cobol
Systems: Oracle 10g database, Microsoft Windows NT, Sungard Higher Education ERP (Banner)

Programmer Analyst, Confidential, 2004-2006
Data Warehouse team environment utilizing ETL processing, Informatica development, and Oracle PL/SQL. Gather business requirements from internal business users and analyze data and design, develop, test, and maintain Data Warehouse software based on business needs. Reporting environment uses Cognos and Actuate BI Tools. Full support for statistics application and reporting. Maintain, design and develop applications using ASP, JavaScript, and VBScript. Full software life cycle environment using Data Vault methodology migrating source DB2 data to Oracle.
Software: Informatica 7.1.3, ASP, JavaScript, VBScript, Oracle PL/SQL, TOAD, Microsoft Development Environment, Visual Studio, SourceSafe, Cognos, Actuate
Systems: Microsoft Windows NT, Oracle 8i, Oracle 9I, DB2

System Software Engineer, Confidential, 2003-2004
Development in Oracle PL/SQL-SQL system to electronically process health care claims. Analyze data and design, develop, test, and maintain software systems. Assist daily production in resolving processing issues. Work closely with Development Team members and Business Analysts to design new systems and system features. Work with external clients to gather requirements and provide system support. Develop test procedures and perform system testing. Document systems both internally and externally in accordance to company policy. Use HCFA and ANSI 837 Forms. HIPAA training.
Software: Oracle PL/SQL, SQL Navigator 4.2, Microsoft Visual SourceSafe 6.0, Visual Objects 2.0, WinEdit ProPack, FTP Pro, Clipper, Foxpro
Systems: Microsoft Windows NT, Oracle 8i, Oracle 9i

Database Developer/Programmer, Confidential, 1998-2002
Developed Data Warehouse ETL processes using Ascential/Ardent DataStage 5.1 for retrieving telecommunications data. Wrote shell, Perl, and PL/SQL-SQL scripts and Stored Procedures that retrieved client data from Oracle/Sybase source databases and mapped the data into a target Sybase warehouse. Analyzed data issues for mapping to existing database structures, OLAP processing, and developing and applying business rules to enhance data cohesion. Utilized UNIX flat files, ftp, sed, and awk processing. Assisted daily production in resolving processing difficulties. Developed high- and low-level design documents. Wrote HTML and ColdFusion scripts for querying and displaying data.
Software: Datastage, Oracle PL/SQL, Sybase SQL, UNIX, Perl, Infopump, HTML, ColdFusion
Systems: UNIX on HP9000 and IBM RISC6000, Microsoft Windows NT, Sybase V11.5, Oracle 8i
Resume Continues…

Senior Technical Analyst, Confidential, 1998
Provided technical applications support for the Oracle Financial Product Suite, developed with Oracle Developer 2000 using Oracle Forms and Oracle Relational Database. Built applications and database test cases to simulate customer issues using UNIX and PL/SQL. Application platforms included character mode, GUI interface, smart client, and network computing architecture. Verbally communicated with customers while logging problems and searching for solutions in the problem repository. Participated in team support and training sessions.
Software: UNIX, SQL, Oracle PL/SQL, Oracle Financial Suite
Systems: UNIX on Sun Solaris, Microsoft Windows NT, Oracle Relational Database

Software Engineer, Confidential, 1997-1998
Designed, analyzed, developed, and tested PC applications using leading-edge Microsoft technology for advanced insurance management. Programmed solutions using Visual Basic for insurance clients needing projection reports on corporate owned and executive life insurance policies. Used an N-tier architecture consisting of client, business, and data services in addition to other Microsoft tools to produce various methods of displaying complicated insurance policy data. Wrote Stored Procedures in SQL to retrieve data from an Access database.
Software: Visual Basic 5.0, Crystal Reports 6.0, Microsoft Access 97, Microsoft Transaction Server 1.0,
Visual Database Tools 1.0, Visual Sourcesafe 5.0, ODBC, SQL
Systems: IBM PCs on Microsoft SQL Server Database

Senior Programmer/Analyst, Confidential, 1991-1997
Fulfilled duties in the UniData/PICK database management system for Shepard’s Integrated Business System. Supported applications for Accounts Receivable, General Accounting, Order Entry/Fulfillment, Sales and Marketing, and Shipping and Receiving. Performed the research, analysis, design, implementation, and testing of new and existing business applications. Worked closely with users to provide an effective and efficient solution to system and business needs. Maintained data integrity within the system database and composed periodic reports. Served as project lead for a company divestiture requiring the development of a stand-alone system for another company. Developed and maintained product labels for a customer base and supported the development of data transfers between a mainframe database and network PCs.
Software: UniData V3.1 RDMS, PICK, UniBasic, UniQuery SQL, C, Raima Data Manager DBMS/SQL,
Borland Turbo Pascal
Systems: UNIX on NCR3550, IBM PCs on Banyan Vines Network

Software Engineer, Confidential, 1990-1991
Software: Ada, C, VMS DECwindows
Systems: Digital VAX 8600, DEC VAX 11/750, Macintosh IIcx
Security: Top Secret

Programmer, Confidential, 1988-1990
Software: Honeywell GMAP Assembly, FORTRAN, Jovial
Systems: Honeywell, Information Systems DPS 6000
Security: Secret


B.S. in Computer Science; Minor in Mathematics
A.A. in Computer Science

Hire Now