SUMMARY:

• Successful record of for over twenty - five years’ experience in information systems and technology with extensive skills and experience in analysis, gathering and documenting requirements, process flows, use cases, user stories, business rules, design, prototyping, development, RPG programming, production support, troubleshooting, integrations, enhancements, interfaces, configuration, data conversions/migrations, unit/system/regression testing, test plans, test cases, user manuals, user, and implementation.
• Completed all projects on-time, within budget, and vast stakeholder approval.
• Skilled in RPG III/IV/ILE/Embedded SQL, CL/ILE CL, SQL, RPG Free, modules, procedures, service programs, subfiles, data queues, data areas, triggers, SQL stored procedures, interactive and batch debugging, analysis, change management tools, search tools, database tools, IFS, Rational Development/WebSphere, iSeries Navigator, design, testing, implementation, and Confidential World.
• Experienced in analytical skills with the ability to analyze problems and reveal opportunities for improvement. Skillful getting at root causes of long-standing complex problems. Adept in finding solutions and implementing them. Talented in mastering business processes, improving workflow, and reporting.
• Dedicated to teamwork and personal . Industrious. Skillful problem solver. Ability to get the job done right the first time while working in an environment with changing priorities and requirements.
• Extensive experience in Confidential World and other ERP systems in the following applications/domains: master data management, sales services, customer management, product management, inventory management and accounting, accounts receivable, credit management, general ledger, fixed assets, pricing, purchasing, order management, warehouse management, and interfaces.
• Honored with Confidential VP's Outstanding Team for innovation, productivity, timeliness, performance, business benefits, quality, customer satisfaction, and consistency of performance over time.
• Replaced Custom Confidential ERP system with a new custom Oracle Web-based system with vast stakeholder and management approval for the above-mentioned domains/applications. Reduced operating costs over $500K annually.
• Merged Confidential Music with overwhelming stakeholder and management satisfaction for the above-mentioned domains/applications.
• Streamlined workflow and reduced costs considerably.
• Integrated Confidential Pictures, Confidential PlayStation, and third party customers into the distribution segment of the Custom Confidential with overwhelming stakeholder and management approval for the above-mentioned domains/applications. Increased revenue 23% and capacity utilization 21%.
• Implemented a plug-in feature that matched customer remit documents to open A/R documents into a workspace for user review and adjustments (Cash Application) with overwhelming stakeholder and management approval. Automatically matched 90% of 66,500 monthly customer remit documents and eliminated 426 hours/$25K monthly.

SKILLS:

World: Advanced Programming Concepts and Skills, Financial Management, Supply Chain Management, Inventory Management

TECHNOLOGY:

• AS/400
• DB2/400
• Synon
• RPG IV/ILE
• CL/CLLE
• Commands
• Query/400
• EDI/Interfaces
• PL/SQL
• Stored Procedures
• SQL/400
• FTP/IFS
• RPG Embedded SQL
• Oracle Forms
• MQ & Data Queues
• Triggers
• Screen/Report Designer
• Processing Options
• Vocabulary Overrides
• UDCs
• DDM
• XCOM
• DRDA
• SNADS
• TCP/IP & ETL
• Familiar with Web Based Software, .NET, Oracle, C#, RPG Free, Java, JavaScript, XML, HTML, PHP, Qshell, MQ Series
• Business Case
• Business Requirements Documents
• Functional Requirements Documents
• Context Diagrams
• Functional Decomposition
• Process/Workflow Diagrams
• Process and Data Flow Diagrams
• Class/Entity Modeling
• User Stories/Use Cases
• Fit/Gap Analysis
• Traceability Matrix
• Business Rules Documents
• Data Dictionary
• Entity Relationship Diagrams
• Data Models
• Data Mapping
• Functional Design Documents
• Detailed Functional Design Documents (BRS)
• Software/Technical Requirement Specifications (SRS)
• Joint Application Development
• Test Plans
• Test Cases
• Regression Testing
• Test Data
• Unit Testing
• System Testing
• Integration Testing
• User Acceptance Testing
• User Documentation
• User Materials
• User
• J.D. Edwards World
• Business Objects
• MS Office
• SharePoint
• Windows
• Aldon
• Implementer
• Turnover
• MS Visio
• Visual Paradigm iPlotz iSeries Navigator
• Hawkeye
• Probe/Abstract
• WebSphere (WDSC)
• Rational Developer
• ERP Systems
• A/R
• A/P
• G/L
• P&L
• Fixed Assets
• Financial Reporting
• Financial Controls and Balancing
• Claims
• Pricing
• Credit
• Sales Services
• Product
• Customer
• Billing
• Master Tables
• Order Processing
• Familiar with EDI
• Interfaces
• Inventory Mgt. and Accounting
• Media
• E-commerce
• Banking
• Distribution
• Manufacturing

EXPERIENCE:

Confidential, Flushing, NY

REAL ESTATE AGENT

Responsibilities:

• While seeking an opportunity as a Senior Programmer Analyst and having a great interest in real estate I became a real estate agent.
• Completed many residential deals and refined negotiation and interpersonal skills working with buyers, sellers, agents, co-op/condo management, bankers, and lawyers.
• Continue to refresh my skills using online access to AS/400 and webinars.

Confidential, South Plainfield, NJ

PROGRAMMER ANALYST CONSULTANT

Responsibilities:

• Charged with providing consulting services for integrating customers and sales history for several acquired businesses, and the analysis, configuration, testing, and for Confidential Assets application.
• Modified many AS/400 RPG, RPGILE, RPGSQL, Subfiles, Batch, CL, SQL, Stored Procedures, and Triggers.
• Elicited, defined, and verified requirements for long-standing Fixed Assets production problems. Identified root causes, recommended solutions, configured changes, programmed corrections, tested changes, and implemented the solutions. Modified RPGSQL, RPGILE, and CL programs. Developed Excel tools that increased user productivity and reduced support.
• Debugged and resolved numerous long standing problems in Order Management and Customer Maintenance. Modified RPG Subfile, RPG SQL, RPG ILE programs, and SQL Stored Procedures and Triggers.
• Designed a web application solution for customer and sales history integrations using UML use case diagrams, workflow diagrams, class diagrams, and navigable mock-ups/wireframes.

Confidential, Jersey City, NJ

SYSTEMS ANALYST

Responsibilities:

• Analyzed and co-designed Internet Customer applications and enhancements by collaborating with Line of Business, User Experience, System Architect, Development, and QA teams. Refined requirements and solutions, including data/process flows, use cases, business rules, field definitions/validations, exception handling, and navigable mock-ups/wireframes. Ensured technical specifications and test scripts met all functional requirements.
• The team created an Automated Clearing House (ACH) Web application form, which allowed business customers to specify the frequency and amount of ACH debits and credits their vendors can make to their accounts. Streamlined twenty-five options on the paper application to four on the web page. Ensured technical specifications and test scripts met all functional requirements.

Confidential, New York, NY

SENIOR PROGRAMMER ANALYST

Responsibilities:

• Gathered and documented business and functional requirements, developed current and future workflow/process models, performed gap analysis, developed data models, defined functional requirements, designed prototypes, produced technical specifications, and developed, modified, and debugged countless AS/400 Confidential World RPG, RPGSQL, RPGILE, CL, SQL, Batch, and Interactive programs.
• Created Business Objects reports, created Oracle web pages, created and tracked test plans, created test cases, executed test cases for unit, system, and integration testing, conducted user acceptance testing, trained users, authored user manuals, and implemented solutions for the above-mentioned domains/applications.
• Employed industry best practices. Delivered integrations, enhancements, and corporate initiatives to meet the changing needs of the business and organization.
• After numerous layoffs resulting in a reduction from 37 to 6 in my department, I was one of the six remaining for the last four years.
• As a member of the project team, successfully replaced the Custom Confidential World ERP system with a new custom Oracle Web-based system with vast stakeholder approval for the above-mentioned applications/domains. Reduced operating costs over $500K annually. Produced functional and technical requirements of numerous AS/400 RPG, RPGSQL, RPGILE, and CL programs. Wrote data conversion programs. Created SQLs to verify conversions. Built Oracle Business Objects and Oracle Web Pages. Wrote test cases, user manuals, and trained users. Produced the implementation plan, procedures, and steps.
• As a member of the project team, effectively merged Confidential Music (Custom Confidential World) and BMG (SAP) with overwhelming stakeholder satisfaction for the above-mentioned applications/domains. Streamlined workflow and reduced costs considerably. Produced functional and technical requirements. Created and modified AS/400 RPG, RPGSQL, RPGILE, CL, interface, batch, subfile, and data conversion programs. Produced test cases. Created SQLs to verify conversions. Implemented the new processes.
• Successfully integrated Confidential Pictures, Confidential PlayStation, and third-party customers into the distribution segment of the Custom Confidential World ERP system with vast stakeholder approval for the above-mentioned applications/domains. Increased revenue 23% and capacity utilization 21%. Researched and designed the best approach to integrate the new businesses. Produced functional and technical requirements. Analyzed and modified AS/400 RPG, RPGSQL, RPGILE, and interface programs. Made enhancements, modified system configurations, produced test cases, tested, and implemented the new businesses.
• Implemented a plug-in feature that matched customer remit documents to open A/R documents into a workspace for user review and adjustments (Cash Application) with huge stakeholder approval.
• Automatically matched 90% of 66,500 monthly customer remit documents and eliminated 426 hours/$25K monthly.
• Analyzed and designed new application. Produced functional and technical requirements.
• Developed and modified AS/400 RPG programs, created test cases, performed testing, managed user acceptance testing, wrote user manuals, trained users, and installed the application.
• Implemented improvements between manufacturing and inventory management modules and across Billing, A/R, G/L, and P&L modules. Identified and resolved deficiencies and discrepancies, and instituted enhanced control and balancing procedures. Saved $96K annually by increasing service levels 22%, reducing MTTR 17%, and increasing MTBF 20%. Received large stakeholder approval. Modified AS/400 RPG, RPGSQL, and RPGILE programs. Modified system settings. Created test cases. Updated user procedures. Performed user acceptance testing and implemented the improvements.
• Successfully conceived, designed, developed (Java), and implemented a plug-in utility that converted existing reports into spreadsheets, HTMLs, and PDFs and another utility that e-mailed these reports and process alerts automatically. Streamlined workflow and enabled the business community to slice and dice data easily and make better timely decisions. Received enormous stakeholder approval. Modified AS/400 RPG, RPGSQL, and RPGILE programs. Modified system settings. Created Java programs. Created test cases. Updated user procedures. Performed user acceptance testing and implemented the features.
• Integrated a subsidiary into the Custom Confidential World System, encompassing sales services, A/R, G/L, financial controls and balancing, restructured chart of accounts and reporting consolidation, and data mapping/migration/conversion. Reduced costs, streamlined processes, and eliminated redundancy. Performed analysis and design. Created data conversion programs and data verification SQLs. Received large stakeholder and management approval which prompted management to hire me.

Confidential, North Bergen, NJ

PROGRAMMER ANALYST CONSULTANT

Responsibilities:

• Charged with providing consulting services for supporting and enhancing the AS/400 RPG client-server Wholesale Sales Management, Retail Sales Feedback, Account Maintenance, and Retail Inventory Management modules.
• Diagnosed and resolved operating, PC/LAN configuration, and application issues on the AS/400 (RPG, Synon, CL, SQL, DB2) and on the LAN (Visual Basic) while interfacing with users and systems counterparts.
• Resolved long-term intermittent costly problems between invoicing and accounts receivable. (AS/400 RPG)
• Streamlined support by tracking and categorizing issues and by standardizing resolution procedures.

Confidential, White Plains, NY

SYSTEMS SPECIALIST

Responsibilities:

• Worked with client management, users, and development counterparts in gathering and documenting business and functional requirements/designs.
• Developed data models, created functional designs, produced technical specifications, created test cases, developed, modified, and debugged countless RPG, RPGSQL, RPGILE, batch and subfile programs, performed testing, and conducted user acceptance testing. Employed industry best practices.
• Shared business and technical knowledge with the new project manager and systems analyst located at the new Northfield office for the migration of 12 AS/400 plants using RPG to the corporate SAP system. Increased productivity $240K annually. Successfully gathered and documented functional requirements and instituted new operating and support business practices. Streamlined change management and functional processes. Standardized multiple customized features and functions. Received special commendation for my superior performance and high quality results.
• Implemented new purchasing, capital tracking, and lot tracking components of Supply Chain at 12 plants while supporting three related applications at the same plants. Project involved interfaces across plant AS/400s, Mainframe, and LAN. Included customer-focused optional features and user-friendly pop-up windows. Performed analysis and design. Created and modified AS/400 RPG, CL, and Synon programs. Modified system settings. Created test cases. Updated user procedures. Performed user acceptance testing and implemented the new applications. Received overwhelming stakeholder and management approval.
• Implemented Corporate Contract Distribution system linking the corporate contract system (LAN-Paradox) with the plant purchasing system (AS/400s) using Client/Server Architecture. Implemented at 12 plants. Improved average timeliness of contracts from 9 to 1 day, standardized and streamlined business practices, improved accuracy, and reduced redundant data entry 95% and late payment fees 23%. Cut $192K of administrative and late payment costs annually. Performed analysis and design. Created and modified AS/400 RPG, CL, and Synon programs. Created test cases. Updated user procedures. Performed user acceptance testing and implemented the new application. Received overwhelming stakeholder approval. Also received IT and business management commendations because it was the first IT project that worked 100% correctly when it went live.
• Implemented new interface between the Corporate Capital Projects Tracking system (M&D CP Millennium-mainframe) and the plant purchasing system (AS/400) that superseded the plant capital tracking systems at 14 plants. Cut plant and corporate administrative costs by $75K annually by simplifying processes, reducing rework, and eliminating duplicate data entry. Improved accuracy and timeliness of capital information, yielding better cash flow management. Created and modified AS/400 RPG, CL, and Synon programs. Created test cases. Updated user procedures. Performed user acceptance testing and implemented the new application. Received vast stakeholder and management approval.
• Implemented Procurement Data Warehouse system which summaries and up loads plant contracts, purchase orders, and inventory balances to corporate office for purchasing synergy, tracking, and reporting. Implemented at 12 plants. Created and modified AS/400 RPG, CL, and Synon programs. Created test cases. Updated user procedures. Performed user acceptance testing and implemented the new application. Received overwhelming stakeholder and management approval.
• Revamped Purchasing and Receiving system at 12 plants to process service contracts from requisitioning through invoicing, replacing manual procedures. Created and modified AS/400 RPG, CL, and Synon programs. Created test cases. Updated user procedures. Performed user acceptance testing and implemented the new application. Received overwhelming stakeholder and management approval.
• Co-designed, developed, tested, and implemented two releases and multiple upgrades of the Purchasing and Receiving system at 12 plants, which included value-added interfaces to inbound transportation, financial, and inventory (PRISM) systems, and redesigned functions and features that streamlined plant operations. Significantly reduced support efforts, including MTBF and MTTR. Created and modified AS/400 RPG, CL, and Synon programs. Created test cases. Updated user procedures. Performed user acceptance testing and implemented the new application. Received overwhelming stakeholder and management approval.
• Coordinated system and integration tests for the above-mentioned releases. Created test plans, test cases, procedures, and policies, using ANSI/IEEE guidelines, to verify the integration of purchasing, receiving, inventory, inbound transportation, and financial systems. Adopted as the department's template.
• Designed the format for user and technical manuals, and trained users and developers.