Programmer/analyst Resume
0/5 (Submit Your Rating)
PROFESSIONAL SUMMARY:
- Extensive experience as a Programmer/Analyst in AS400 Technology environments
- Demonstrated expertise in a variety of computer software; provided expert user support
- Proactive problem - solver; adapts well to changing priorities and increased responsibilities
- Co-operative team member; interact effectively with colleagues, management and clients
- Professional, dependable, versatile and motivated
- Developed, maintained and provided administration of in-house software programmes
- Developed project recording and reporting system; created sales reports using SQL (Sequel)
- Designed script documents using Excel; utilized WinRunner for Syntax applications on AS400
- Tested applications on a unit and system level prior to Y2K Conversion
- Created and set-up test plans for various product tests (e.g. Operating Systems, Hardware, Third Party Software, Network, Communication)
- Created custom software in areas of order entry, physical inventory, file maintenance and A/R
- Produced History data files for Job Management Costing and Revenue data
- Set-up automated process to transfer client information and to interface to JDE accounting data
- Wrote conversion programs/procedures to translate SYS36 data to JBA file formats; developed Job Costing Reports in same layout as SYS36 using JBA data
- Developed and created Account data to be sent to IBM(IESO) via FTP for processing of files
- Developed and created process to receive reports from IBM(IESO) as a result of data files sent to IBM
- Created usage/budget reports for CDM(Conservation and Demand Management) Department.
- Created reporting for meter read analysis
- Created Disconnect/Reconnect summary reporting by residential/commercial customers
- Created Meter correction function when receiving meter information from Elster
- Created Account, Meter and Location mapping files for input to Sales Force System(pc based)
- Developed and created process to send water reads via FTP on a daily basis to U.S. SteelMaintained meter processing and maintenance programs on EMTS(Electronic Meter Tracking System).
- Modified BPCS software to in corporate a variable length product for steel pipe processing
- Provided assistance to junior staff members; supervised department in absence of supervisor
- Researched product compliancy by securing, from the vendor’s web-site, their Compliancy Statements and product test plans
- Organized vendor data (including plans) for software ; used Subject Matter Expert
- Set-up terminals, programs and bar code label printers for conversion
- Provided professional and courteous “Hotline Support”
- Modified sales reports to identify and balance promotions and allowances
- Tailored existing Credit and A/R programs; created data for Dun & Bradstreet - customized Order Entry/Pricing programs to validate customer pricing, promotions and deals
- Transportation System: adapted standard freight calculation, carrier inquiry, freight approval updates, shipment confirmation and warehouse transfers
- Evaluated and corrected problems from hot lists; rectified errors on RMA reporting
- Supported Home Video by troubleshooting and correcting problems
- Assisted in troubleshooting and fixing problems with user data in A/R, A/P and G/L
- Analyzed, modified and tested changes to freight charge program, A/R transaction inquiry by invoice/ program and editing on product allocation
- Modified editing/data on inventory allocations and LA transfer programs
- Supported PRMS (Pansophic) applications; created inventory movement reports
- Support account and meter process to and from IESO
- Modify existing programs to determine variable lengths of tubing being shipped out(includes writing additional programs to calculate the variable lengths
TECHNICAL SKILLS:
Hardware: Sys/38, AS400, PC’s
Software: RPGII, RPGIII, ILE, Query, SDA, CLP, SQL, DFU, Mapics, JDE, JBA, PRMS, Microsoft Excel, Word, Access, PowerPoint, Internet Explorer, Outlook, Windows, Netscape, BPCS