Resume of Systems Analyst

Title
Systems Analyst

Primary Skills
PHP, MySQL, Data Warehouse, QA, Javascript, BRIO

Location
US-NY-Hopewell Junction

Posted
Jul-23-08

OBJECTIVE:
To obtain a Telecommuting position in Information Technology that will provide the opportunity to utilize my experience and knowledge to facilitate and optimize productivity.

EXPERIENCE:
Freelance Web Developer Hopewell Junction, NY
Mar 2007 to Present
-Create and or modify web based business applications for various clients utilizing PHP, MySQL, Javascript, HTML, XHTML and other languages as based upon the customers' specifications.

Ajilon Danbury, CT
Consultant - IBM Assignment Mar 1999 to October 2004
April 2002 to October2004
-Develop a suite of web based applications utilized to analyze and project Divisional spend and savings with responsibilities including:
-Collect user requirements and develop architectural plans based upon system capabilities and data content.
-Create DB2 tables and coordinate data loads.
-Utilizing BRIO software, design and develop reports including user lookup, analysis and export features.
-Generate automatic extract, load, and run programs for data updates and refreshes.
-Publish data reports via HTML.
-Interface with external Card Manufacturers to:
-Coordinate data feed transmissions.
-Collect and program data integration code.
-Produce and publish data reports used for contract compliance and industry trend analysis.
-Document technical scripts and procedures.
-Provide training classes and assist users in software installation and analysis techniques.

January 2002 to March 2002
- Develop Brio and DB2 queries to replace current data warehouse reports.
- Document procedures, data problems and requirements for new data warehouse implementation.
- Analyze DB2 tables for data content and consistency.
- Validate spend data for accuracy and executive reports.
- Compose access and usability instructions for DB2 Connect and BRIO setup; provide end user support.

March 1999 to December 2001
- Handle security administration for one DB2 and one SAP application.
- Administer all changes and design enhancements to area Lotus Notes databases.
- Analyze and compose BRIO queries used for replacement of MVS for corporate data warehouse.
- Support test endeavors for fixes and enhancements for an SAP application and front end WEB MVS based application. Track issues and bug resolution.
- Procure various measurement reports for executive evaluation and action.
- Compose SQL queries for data warehousing tests, data extracts and executive information requests.
- Create DB2 table element data directory via Lotus Notes including search and drill down capabilities.
- Design Lotus Notes database used to track and provide reports for eApplication deployment.
- Implement a Lotus Approach application to extract data from db2 and Lotus Notes and run comparison reports.
- Provide support and training for user community of 800 people.
- Document procedures, FAQ's and common problem scenarios for on line Knowledge Base Support tool.

Transamerica Leasing, Inc. Purchase, NY
System Consultant Jan., 1998 to Feb 1999
- Define user requirements and expectations for a Windows based tracking system for 850,000 units of equipment.
- Generate user acceptance test scripts; document findings and issue status reports.
- Complete functionality, user acceptance, and string testing.
- Manage system issue and bug database. Ensure items are properly resolved.
- Develop enhancement requirements; prioritize present and future system modifications.
- Schedule deployment and user training activities.
- Compose, design and develop on-line help function as well as desktop user manual.
- Assist users during system rollout; filter information and follow up on required data.

Transamerica Leasing, Inc. Purchase, NY
Administrator, Trailer Billing & Accounting Feb., 1992 to Oct., 1995
Hire, manage, develop, and motivate a team of ten responsible for:
- Tracking the disposition and revenue for an intermodal fleet of 45,000 pieces of equipment, generating approximately $70 million annually.
- The evaluation of projected revenue against payments; prevention of non-collectable items, budget preparation and analysis.
- Definition, analysis, and resolution of issues involving direct contact with internal and external customers.
- Documentation and evaluation of departmental procedures in an ever changing environment.
Accomplishments:
- Consolidated Equipment Accounting and Per Diem Control functions into the department workflow providing a cross functional team.
- Implemented an electronic data interchange product, resulting in increased accuracy of revenue liability, cost reduction of $250k annually, and headcount reduction.
- Conducted company wide training for QMF and System Archival Retrieval applications.

Transamerica Leasing, Inc. Purchase, NY
Supervisor, Billing Nov., 1985 to Feb., 1992
Provide supervision, training and motivation for a staff of eight primarily responsible for:
Invoicing functions for all customers encompassing short and long term leases, warranty rebills, equipment sales, and maintenance and repairs.
Accomplishments:
Responsible for the creation of requirements and management of testing for a new legacy system replacing manual billing and tracking functions.

EDUCATION:
Pace University Pleasantville, NY
Accounting Major
Certificate in Basic Accounting
Total credits: 40

Software Expertise:
SQL PHP
Java Script BRIO
MySQL HTML
Lotus Approach MS Excel
ISPF MS Word
DB2 MS Access
MS Windows 95/98/2000/Millenium/NT/XP MS Power Point
Lotus 1-2-3

REFERENCES FURNISHED UPON REQUEST

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-NY-Hopewell Junction »
View all resumes in US-NY »

View other Systems Analyst resumes, Programmer / Developer resumes