Systems Analyst / Consultant Resume
Burlington, NJ
Summary
Creative | Adaptive | Resilient
Accomplished system analyst with a proven ability to develop and implement strategies that support business and financial objectives. Effectively works throughout the whole project lifecycle from capturing initial requirements to final system delivery. Proven experience with various environments including UNIX, Windows, Oracle and IBM MVS.
Areas of Expertise
- Corporate Financials
- Leadership
- Documentation
- Customer Interface
- SDLC
- Shell Scripting
- Vendor Software Implementation
- Requirements Gathering
- Visual Basic Application Scripting
Software Skills
PL/SQL, Oracle, UNIX, LINUX, Shell Scripting, Visual Basic Applications, SQL Server, Excel, Visio, Word Access, C, FORTRAN, COBOL, DB2, CA7, Natural and JCLProfessional Experience
Confidential - Wilmington, DE 09/2011 - 09/2012
Credit Card Services
Systems Analyst / Consultant
- Analysis, documentation and implementation of CyberArk Application Identity Management software into clients existing UNIX K-Shell and SAS scripts to retrieve logon credentials for Oracle and Teradata DB connections
- Set up new UNIX profiles/environments for migration of current production service accounts and applications to new DEV, QA, UAT and PROD regions. Modified and tested scripts/programs for portability throughout deployment. Migrated scheduling to TWS from Crontab
- Assigned team lead for introducing CyberArk into applications running on Windows server in addition to UNIX server. Created functional documentation in Word and Visio for controls project pilot applications which was posted to SharePoint.
Confidential - Philadelphia, PA 03/2008 - 06/2011
Corporate Financials
Senior Systems Analyst
- Working under tight deadlines migrated SunGard VBA pricing application to Logical Information Machine (LIM/Morningstar) price publishing platform. Coordinated with vendor and internal accounting on pricing conversion methodology. Created commodity formula script templates. Documented process flow in Word and Visio Created K shell scripts that extracted pricing data from LINUX server and FTP to downstream applications. Awarded bonus from management on project.
- Primary business analyst and developer on mainframe COBOL/Natural DB2 invoice payment system that was cost affected by eliminating manual business functions with automated processing, resolved multiple vendor\'s tax and contract pricing (LINUX application) issues to reconcile invoices automatically. Interfaced with energy companies Archer Daniels Midland, Marathon and POET to receive invoices in various electronic data formats for processing.
- Designed a Metrics time tracking and reporting application for IT management using VBA script for Excel Application was used by Corporate Financials IT group to record ad-hoc tasks requested by business. The data was presented to business partners to justify IT task load and head count.
- With no previous experience worked with SSIS transaction SQL to convert chemical\'s division group SAP pricing structure on Windows SQL Server DB to feed legacy system for stop gap solution. Final resolve was achieved with creating time series symbols using vendor software on LINUX server with shell scripts extracts.
Confidential - Horsham, PA 10/2006 - 02/2008
Systems Analyst
- Application development and production support of clients international trade and settlement system.
- Oracle PL/SQL packages, procedures functions and K-shell coding modifications implemented from business analyst specifications.
Confidential - Horsham, PA 04/2006 - 10/2006
Consultant
- Interfaced with business to design, document and code video forecasting algorithms.
- Oracle PL/SQL procedures, triggers, functions and UNIX scripting coded for back end processing modifications implemented from business analyst specifications.
Confidential - Philadelphia, PA 08/1998 - 04/2006
Corporate Financials
Senior Systems Analyst
- Designed and documented conversion methodology from legacy system to Oracle 11i including functional and technical specification documentation.
- UNIX shell scripting development
- Visual Basic 6 applications (VBFTP and SFICOPY) designed and packaged for business customer that were extremely user friendly and provided time savings.
- ASP application enhancements made in time frame requested by business customer allowing old legacy platform to be shut down saving company money
- Strong experience designing and developing customer interfaces and extracts programs using PL/SQL on Oracle 9i.
Education
Bachelor of Science Electronic Engineering Technology
Military
United States Air Force - Honorable discharge