Snr. Programmer/analyst Resume
NY
SUMMARY:
- IT Professional with over 15 yrs. of demonstrated success and proven ability to manage and lead business and technical teams in the development, implementing and integration of strategic and tactical business applications to achieve flawless process execution, cost reduction, maximize productivity and increasing bottom line results in diverse application areas.
- AS/400, IBM i Application System Development Supply Chain Solutions
- WMS & ERP Systems Integration and Support EDI Implementation Strategies
- Supply Chain Solutions Software Reverse Engineering
- Material Handling Systems SQL
- Business Analysis methodologies Database Modeling/Design
- Structured Methodologies Business Systems Analysis & Design
- Software Development Life Cycles Project Management
- Change Management systems Database Modeling/Design
- Data Warehousing Manhattan Associates(PKMS)
- Microsoft Office (MS Project/Excel/Access/Visio)
PROFESSIONAL HIGHLIGHTS:
Confidential, NY
Snr. Programmer/Analyst
Responsibilities:
- IBM i Application Development for conversion from legacy system AWARD Retail and WMS Systems to Confidential Retalix ERP Systems(Power Enterprise, Power Warehouse) Applications
- Business Analysis using SWOT Techniques/Functional and Technical Specifications to analyze, document to perform Gap analysis for application modifications and retrofits
- Self - managed projects and tasks assigned and reported to management and development team on progress using Dashboards.
- System and application documentation
Skill set used: IBM I AS400/iSeries Application Development Tools,, RPGILE SQL,CL Subfiles, SDA fixed format and freeform RPGILE, Embedded SQL Stored Procedures, Service Programs
Confidential, NY
Snr. Programmer/Analyst S2K Enterprise Management Software
Responsibilities:
- AS/400 (iSeries) Application Development/Enhance programs for conversions and Retrofits for various clients upgrading to current release of S2K(6.0). Modified clients customized applications into current ERP release, gap analysis, testing of modified applications
- Applied Software Development Life Cycle(SDLC)waterfall model and prototyping to analyze modifications requirements on various components of ERP system based on Business and Functional requirements
- Developed Interfaces for system integration and data conversions
- Rectified, maintained, documented and supported changes/enhancements to existing code.
- Self-managed projects and tasks assigned and reported to management and development team on progress using Dashboards.
Skill set used: AS400/iSeries Application Development Tools, RPGLE,RPGILE SQL fixed format and freeform RPGLE, Embedded SQL, Interactive SQL, CL Programming, Procedures, Service Programs
Confidential, NY
Senior Programmer/Analyst
Responsibilities:
- AS/400 (iSeries) Application Development/Enhancements on Supplier address databases for all Distribution centers to conform with Confidential and/or List 1 chemical registration and regulatory requirements
- Expanded Supplier location Address Databases by introducing 13 new fields. Identified and modified all dependency programs introducing warehouse number as part of the database primary keys for license checks information
- Modified all dependency programs to populate warehouse number. Created new database and maintenance programs to store and validate states that requires State controlled substance licenses based on a matrix capturing various drug class codes, In state RX, Confidential and state controlled Substance.
- Developed supplier Licenses maintenance program for a 5 tier license number and expiration dates
- Modified receiving process to validate receipts into DC based on matrix/flags for 5 tier license expiration dates. Modified various user interactive screens
- To access licensing Information based on valid supplier location for selected warehouse
- Created reports to capture licenses that have expired or set to expire in the next 3 months with Emailing capabilities
Skill sets used: AS400/iSeries Application Development Tools, RPGILE (fixed format and freeform), Embedded SQL, Interactive SQL, CL Programming, Subfiles, Procedures, Prototypes, Business System Analysis, Hawkeye, Turnover, SDLC as a development methodology, Prototyping
Confidential, Cranbury, NJ
Senior Programmer/Analyst
Responsibilities:
- AS/400 (iSeries) Application Development for ( Confidential ) Supply Chain
- Modification of Legacy system. Business System Analysis and design, development of applications to support system integration (SQL Server Database), created new code to meet specific business needs.
- Installed/ Configured /Deployed change management system(Turnover) to meet Business needs
- Installed /Configured/Deployed Hawkeye to assist in system integration for HBC to assist acquisition and merger projects
Skill sets used: RPGILE, (fixed format and freeform) CL Programming, Subfiles, Procedures/ Prototypes, Embedded SQL, Binding directories, ILE Modules, SQL, Business Analysis Using Scrum/ Agile combination
Confidential
Senior Programmer Consultant
Responsibilities:
- AS/400 (iSeries) Application Development for ( Confidential -channel) Supply Chain Group
- Modified customized code to meet specific business needs. Production and configuration support for PKMS (Manhattan Associates) Applications WM Package
Skill sets used: RPGILE, (fixed format and freeform) CL Programming, Subfiles, Procedures/ Prototypes, Embedded SQL, Binding directories, Modules.
Confidential
Senior Programmer Consultant
Responsibilities:
- AS/400 (iSeries) application development/support for Multi-Channel Order Processing, Inventory Management, Quality Control and CRM Systems
Skill sets used: RPGILE, (fixed format and freeform) CL Programming, Subfiles, and Stored Procedures. Procedures/Prototypes, Triggers, Embedded SQL, Binding directories, Modules.
Confidential
Senior Programmer/Analyst
Responsibilities:
- AS/400 (iSeries) application development/support for online securities transaction processing system
- Application Systems support for Bloomberg Interfaces, Security processing systems, clearance and settlement systems
- Systems analysis and application development/ support of conversion programs and interfaces for On-boarding Global clients
- Review and analysis of Technical documents and specifications for application development
- Resource Planning application development
Skill sets used: RPGILE, (fixed format and freeform) CL Programming, Subfiles, Stored procedures, Triggers, Embedded SQL, Binding directories, Modules
Confidential
Application Developer (WMS/ERP)/Sr. Business Analyst/Project Manager Consultant
Responsibilities:
- Application Development for Infrastructure, strategic and tactical projects to support and Improve supply chain on AS/400 (ISeries)
- Interface Designs WMS implementation and integration with ERP systems ( Confidential MMS Allocations, Replenishment, Inventory control, PO Management)
- Lead Architect in developing and modifying core business modules to align with business needs to facilitate evolving business practices and requirements.
- Business system analysis for strategic Planning to identify business needs, Business model analysis, Process Design (Workflows) Systems Analysis to interpret business rules and requirements for technical systems, risk and return analysis
- Business plans, KPI’S, Project plans for WMS Integration efforts
- Functional requirements using Data models and technical specification
Skill sets used: Structured systems analysis and Design Methodology (SSADM) for Logical and Physical data modeling, High level context and dataflow diagrams, Entity Relationship Modeling using Visio, Database modeling and design, Use cases, Data dictionaries, software Development Methodology (Waterfall Model), IBM Rational Methodology for Development work on AS/400. RPGILE (fixed format and Free) CL Programming. Embedded SQL, MS Project Management.
Confidential
Application Developer/Business Analyst Consultant
Environment: AS/400, RPG ILE CL Programming (Retail and Distribution)
Responsibilities:
- Developed interfaces for WMS (Knighted/Intelligrated) and Manhattan WMS slotting optimization software to help eliminate pre-allocation issues due to physical constraints of the building, resulting in a 5% turn around improvement, increased in stock of 1.5% and reduction of pre-allocation by 50% by providing more forward pick locations for products and cross docking functionality.
- Developed EDI application interfaces to support Distribution, Transportation and 3PL Applications
- ERP ( Confidential MMS) application interfaces to WMS Confidential MMS Application development (Replenishment, Allocation, Inventory control PO Management)
- Improved operation efficiencies and/or reducing cost through technology projects
- Application development custom modifications within ERP ( Confidential ) and WMS systems to support changing business requirement.
Skill sets used: Business Analysis methodologies for gathering and defining As-Is and To-be business models, Data flow diagrams. Prototypes, Business and Technical requirement analysis, Visio, Use Cases, ROI methods for Risk and Value added assessments
Confidential, NJ
Application Developer Consultant
Responsibilities:
- Responsible for all application development, rollout/deployment and daily support for all WMS (High Jump) and Distribution center related tasks and activities
- Set Standards and accountability for exercising full system development life cycles for applications development on WMS related tasks based on Six Sigma standards and SOX requirements
- Interactions with all levels of Management on corporate Information systems Strategies and Reporting
- WMS (High Jump) and ERP (Island Pacific) Integration
- Technical support in deployment of WMS(High Jump) for West Coast Facility
- Managed Integration of WMS with FedEx as a supply chain logistics Provider
- Managed Integration of WMS with Third Party Logistics Providers to enhance and provide full visibility of Outbound supply chain initiatives
Skill Set Used: WMS(High Jump), Sequel server Transact SQL, Agile Development Methodology, Material Handling System(Pyramid), IBM Rational for Development work on AS/400. RPGILE (fixed format and Free), CL Programming. Embedded SQL
