SUMMARY:

• A dedicated professional with over twenty years experience in the information technology field.
• A results oriented individual who functions effectively as an individual contributor or as a member of a project team.
• Understands the importance of project schedules and extends the effort required to meet project deadlines.
• Enjoys problem solving and is a very quick learner with excellent communication skills and positive work attitude.

KEY SKILLS & KNOWLEDGE:

• iSeries (AS/400)
• S/38
• Windows
• OS/2
• Crystal Reports
• 10 & 11
• Informatica PowerCenter 7.2
• Informatica PowerExchange 5.2
• Microsoft Analysis Services
• Silvon Data Tracker
• 3.0 erWIN
• MS Sequel Server
• T - SQL
• ORACLE 9.0
• PL-SQL
• Client\Server
• FTP vb 6.0 vb.net vbSCript
• RPG III, IV / ILE
• CL / ILE
• FTP
• SQL
• DB2
• Hawkeye
• FastFax
• Broderick ezMerge
• Confidential
• PC/Miler
• MS Office Suite
• MS Windows
• XP / Vista
• Confidential XA 2.0
• Financials (GL, AR, AP)
• PDM / ePDM
• Inventory
• MRP
• Purchasing / Procurement
• Cross App
• Payroll
• Production Mgt and Control

PROFESSIONAL HIGHLIGHTS:

Confidential

ETL Architect

Responsibilities:

• Provided leadership and direction to support business objectives through cost effective use of technology and appropriate business practices.
• Coordinated activities with management in direction setting for applications including setting priorities, coordinating, and reporting
• Created over 300 PowerCenter mappings and sessions which are used to populate star schema fact and dimension tables, used for custom reporting and custom web applications
• Responsible for scheduling, migration and implementation of all Informatica related tasks
• Supported more than 20 Confidential categories and more than 200 users.
• Technical lead and developer for SAP conversion project which involved creating customer templates from Confidential ’s data warehouse and legacy transactional systems. Project included creating many new MS SQL Server tables, stored procedures and many Informatica components (maps, sessions and workflows). The project had a very aggressive timeline and was completed on time and under budget with no other resources.
• Developed process which uploads gross margin calculated from data exclusive to company’s in - house data warehouse to Confidential . This saved the company from having to resource or rewrite Crystal Reports and Confidential custom queries. This project included new iSeries programs, tables, new MS SQL Server tables, stored procedures and new Informatica PowerCenter mappings and sessions. Completed project in less than one month (160 man hours and $6,500). Original estimate to rewrite or resource all reporting was 3 people 6 months (approximately 2,900 man hours and $120,000).
• Used MS SQL Server, Informatica PowerCenter & PowerExchange, erWIN, Data Tracker, DB2 for i, RPG ILE, CL ILE, FTP, T-SQL and Broderick FileXfer3X/400
• Developed custom application to help manage data warehouse, saving the company significant software costs. Other Informatica tools were no longer required.
• Used PowerCenter, vb.net, MS SQL Server, Crystal Reports
• Developed process to upload data from 3rd party costing software, proprietary database (Impact:ECS) to in-house data warehouse utilized by custom-built Customer Business Planning (CBP) tool. Saved significant time and resources from a previously manual Excel process.
• Used PowerCenter, vb Script, MS SQL Server
• Member of Order Management and Logistics application (OML) team. Developed and maintained iSeries applications used by over 19 plants in the US. Interfaced 3RD party software tools FastFax, Broderick and ezMerge with in-house applications in an effort to go “paperless”. Interfaced in-house Transportation Management code with PC Miler to validate all North American address.

Confidential

Systems Analyst

Responsibilities:

• Created never ending job process to handle all Confidential transactions created by custom programs.
• Transactions include: Receipt to Inspection (RI) and Receipt to Purchase Order (RP) generated from our purchasing receipts application; Planned Issue (IP), Miscellaneous Issue (IS), Unplanned Issue (IU) and Receipt to Manufacturing Order (RM) generated from our custom manufacturing execution application; Physical Inventory (PH) and Inventory Transfer (TW) generated from our Radio Frequency (RF) applications.
• These applications replaced manual system where transactions took as long as 5 days to process to under five seconds.
• Used DB2, RPG IV, RPG ILE, CL, CL ILE and embedded SQL
• Using ZPL programming language for Confidential printers generated Stock Location (with barcode) labels, Material Receipt (with barcode) labels, Custom Customer Shipping labels and more.
• These replaced hand written labels and stenciling done by plant personnel. As customer specific labeling became a requirement Confidential replaced custom code to produce customer specific shipping labels. Each customer’s requirements were saved as a template and labels produced via an API called from HLL programs.
• Led the implementation, testing, and release to production of Confidential 2 to Confidential DB and Confidential DB to Confidential XA upgrades.
• Provided full project management and technical support in all aspects of the design, installation, integration and production functionality on these projects
• Led the implementation, testing, and release to production of numerous operating system and hardware upgrades. Provided full project management and technical support in all aspects of the design, installation, integration and production functionality on these projects

Confidential

Senior Programmer Analyst

Responsibilities:

• Interfaced transactions developed by custom shop floor data collection programs to Confidential automatic data collection system.
• Created interface between in-house Order Entry system and MRP module.
• Using Confidential software for Confidential printers designed and implemented Stock Location (with barcode) labels, custom Customer Shipping labels and others. These replaced hand written labels written by plant personnel. These labels were interfaced with Confidential software and plant personnel could request label via Confidential bar-code scanners located throughout the plant.
• Led the implementation, testing, and release to production of Confidential 2 to Confidential DB and Confidential DB to Confidential XA upgrades. Provided full project management and technical support in all aspects of the design, installation, integration and production functionality on these projects
• Led the implementation, testing, and release to production of numerous operating system and hardware upgrades.
• Provided full project management and technical support in all aspects of the design, installation, integration and production functionality on these projects