Senior Programmer/analyst Resume
Hands-on techno-functional, results-oriented business analyst/project manager with 13+ years of IT experience in program management, project management, client relationship management, IT management (all aspects), custom software development, database administration/programming, Crystal Reports, SSRS and COTS implementations. Well-seasoned with experience directing multiple projects utilizing Agile, Scrum, Iterative, MSF and Waterfall software development/project management methodologies. Knowledgeable in all phases of SDLC performing business process analysis to achieve significant productivity gain and quality improvements on all projects. Experience with multiple ERP, CRM, WMS and web technology project implementations as well as hands-on experience programming, network administration/design, Windows/Unix server build and administration and database administration/programming.
Work Experience:
Confidential, 3/08 - 10/09
Manager Information Systems
Brought in to manage corporate IT systems redesign including network infrastructure, server and workstation hardware, programming of web applications and corporate database applications. Implemented ITIL framework and formal project management methodologies.
- Corporate data system redesign including ERP, CRM, Web systems.
- Project management: Calculate ROI, Prepare SOW, set milestones, etc.
- Vendor selection including, RFP, RFQ, vendor selection, metrics.
- Contract management/negotiations.
- Budget management, departmental and vendor payments when milestones were reached.
- Requirements gathering. Conducted JAD sessions with SMEs, vendors, users and key stakeholders as well as project champions.
- Hybrid MSF Agile Scrum methodology used.
- Implementation of Kronos timekeeper system with corresponding integration to ERP system within SQL databases.
- Implementation of ITIL.
- Implement MS Sharepoint for dissemination of project documents.
- Network infrastructure redesign/implementation.
- Oversee direction of IT department, including but not limited to, network technologies implemented, server infrastructure technologies and implementation, design, recommendations for new technologies, web presence, licensing requirements, SOX compliance, business process analysis and redesign, departmental budget, HR management. Manage/train/support IT staff.
- Report programming from Crystal Reports/Business Objects and SSRS out of various database systems.
- Database administration.
- Windows and Unix systems administration.
- Programming in SQL, VB.NET.
- Technologies used in this position - SQL server, Cisco, Windows, IIS, Visual Studio .NET, MS Office including Excel and Access, Kronos, Abra, Crystal Reports, T-SQL, Visio, Project, Exchange, Active Directory, DNS, Cisco IOS, Dreamweaver/Flash, ITIL.
Confidential
Senior Programmer/Analyst Contract to Hire Position 11/05 - 3/08
Brought in to Lead the implementation of an Oracle-based warehouse management/ERP/Manufacturing and Supply chain systems including EDI functionality, WMS functionality, Shipping and Receiving functionality, Inventory Control functionality, RFID functionality, Business Objects Enterprise reporting and carton labeling systems and programming. Lead the implementation of SQL server-based parcel shipping system (ConnectShip) in their Fontana, California, Neosho, MO and Milford, CT distribution centers to interface with SAP, Oracle and AS400 (JD Edwards).
- Gather end user requirements, conduct JAD sessions with SMEs, key stakeholders, end users and project champion, document this information for submission to vendors for bidding process and use during the course of the project.
- Gather hardware and software requirements from software vendors.
- Gather pricing information from software vendor.
- Initiate RFP process, obtain bids from vendors for selection process and lead selection process.
- Monitor and manage payments to vendors.
- Conduct User Acceptance Testing.
- Specify interface requirements and build between JDE, SAP and Oracle.
- Specify and program printing and reporting requirements out of systems via SSRS and Crystal Reports Enterprise.
- Create training materials and perform training sessions of end users.
- Specify, design and install and configure web server for distribution of Oracle printing and reports and SQL server reports to all users in the organization which require report functions without need for Client software.
- Interface with outside vendors during the course of the implementation through go-live for issue identification/resolution as well as managing budget and vendor payment at milestones.
- Specify and develop/oversee modifications to both Oracle and Connectship applications, databases and interfaces, test and obtain approval from department managers.
- Managed development team, specification phase, testing, hardware, software, infrastructure, training, end-user/management signoff and post go-live support.
- Implemented web interface for customers to enter orders into the system, other than via EDI to enhance customer ordering experience and enable smaller non EDI customers to enter their own orders without calling customer service thereby reducing operating expenses.
- Design EDI carrier specific RFID/non-RFID labels using Loftware labeling system.
- Perform data analysis to identify root cause for issues and make appropriate adjustments/recommendations as required.
- Server Build and Administration (Unix/Windows).
- Database Administration in Oracle and SQL server.
- Report Programming in Crystal Enterprise.
- Design, set-up and maintainance of all Unix and Windows based servers, wireless access points (802.11g) as well as print servers and printers for reporting and RFID and non-RFID label as well as report generation in distribution center.
- Post go-live program owner of Connectship (SQL server) performing DBA duties, reporting, end user support and VB.NET, PL/SQL and T/SQL programming .
- Monitoring EDI transaction logs and maintain compliance with vendors for Fontana location, review of vendor guides to maintain compliance with trading partners, reporting, data analysis and identification of root cause and performing corrective measures when vendor requirements changed or issues identified for all departments.
- Agile/Scrum methodologies used on these projects.
- Technologies used in this position: Oracle 9i, SQL server 2000/2005, SSIS, SSRS, SSAS, VB Scripting, VB.NET, Windows 2000/2003, Unix, Crystal Reports/Business Objects 8-11 (350+ reports programmed and implemented web intelligence/Enterprise), PL/SQL, T-SQL, Loftware, Oracle 11 ASCP WMS, Catalyst, Sato, Printronix, Oracle Forms, Oracle Reports, JD Edwards (AS400), EDI, ERP, ASCP, SOX, GMP. Build and maintain all servers and perform maintenance as needed using W2K, W2003 and HP-UX. ITIL, RCA, Business Intelligence, Data Analysis, Cisco networking equipment.
Confidential
Project Manager Contract Position 2/05 - 11/05
Brought in to complete conversion of corporate data processing system (parent and five subsidiary companies including Minka Lavery, Minka Aire, Metropolitan Lighting, George Kovacs and Ambiance Lighting) from Cobol to Oracle 9i and 10g databases running on Sun Solaris 9. Prior to bringing me on as the project manager, the project had been in progress for 5 years and was only approximately 20 percent complete. Completed project within 9 months with successful conversion to Oracle and Logistic Labeling System (web labeling).
- Selection via RFP and management of 3 outside service providers (C3, AOC USA and Allen Group).
- Managed 7 internal programmers.
- Gathered end-user requirements via one-on-one meetings with SMEs and JAD sessions.
- Manage all project meetings.
- Specification/design, hardware and software requirements.
- Manage User Acceptance Testing process.
- Manage change management process.
- Served as lead programmer role delegating work to programmers and overseeing programming and testing.
- Managed implementation and go-live of custom programmed e-commerce, EDI transaction processing, CRM, ERP, WMS, manufacturing, accounts payable, accounts receivable, general ledger, purchasing department, logistic warehouse inventory control system, customer service system, sales department functionality including commission system, sales analysis reports and order processing system. Managed keeping the project on time and on budget.
- Managed Project for Web interface carton labeling system for suppliers/vendors in China (Logistic Labeling System) thus saving the corporation several hundred thousands of dollars per year in labeling costs.
- Managed web ordering system programming.
- Managed requirements gathering and programming Business Intelligence reporting systems for Sales, Purchasing, Finance, Senior Management, Accounting, Manufacturing, Quality Control, Sales and Warehousing.
- Responsible for maintaining communication between team managers, end-users, programmers and outside service providers.
- Programmed using PL/SQL, TCL, Oracle Forms and Reports.
- Responsible for testing programs with end-users/department managers, performing data analysis to identify root cause, identifying necessary modifications/bug fixes and assigning duties to programmers, interacting with outside service providers and specifying interface requirements and testing for proper functionality, keeping project moving, on-time and on budget.
- Converted projects from Waterfall to Agile methodology.
- Technologies used in this position: Java, SQL, PL/SQL, Oracle 9i, Oracle WMS, Oracle Forms and Reports, Crystal Reports, TCL, RMAN, OEM, Business Analysis, Visio, Project Management, Process Improvement, EDI, SOX, GMP, Business Intelligence, Data Analysis, Agile methodology.
Confidential
Lead Systems Analyst/Project Manager 2/03 - 2/05
Managed large and small corporate IT redesign projects for a consulting company.
- Design, install, document and maintain Windows, Novell and Linux networks, Exchange systems, web presence, SQL server and Oracle server database systems.
- Gather end-user requirements via one-on-one interviews with SMEs, key stakeholders and project champions.
- Specify, design, program, test and implement custom database applications including, CRM, ERP and web applications for clients.
- Iterative/Waterfall PM methodologies used in this position.
- Respond to RFPs from potential customers, prepare bids and go over requirements with customers.
- Duties included specification of hardware, software, network infrastructure, bid preparation, keeping projects on time and on budget, interfacing with clients, obtaining payments when milestones are met.
- Data analysis/creation of statistical reports to make recommendations for customer's sales, accounting, finance, purchasing and management roles.
- Provide end-user training and support for clients.
- Notable Projects included : CheckMaster Agency - Corporate Information System redesign JazzTrax - Web playlist implementation, corporate IT management contracted, Stein-Whittington - Development and implementation of Block Trade program with Charles Schwab, Desert Veterinary Specialists - Implementation of new EMR, IT infractucture and Radiology systems, Valley Health Systems - Epic ADT implementation.
- Programming languages used in this position: Java, HTML, Flash, Dreamweaver, Oracle Forms and Reports, Oracle 9i, SQL server 2000-2005, SSIS, SSAS, SSRS, SOX, Business Intelligence, Data Analysis, PL/SQL, T-SQL, Crystal Reports/Business Objects 8-10 implementation including web intelligence/desktop intelligence, RMAN, OEM, Visio, Epic ADT/Prelude master file, category list, workflow and report build.
Confidential
Manager of Information Systems 5/97 - 02/03
Originally hired as intern, was promoted to Manager after completion of 6 month internship position.
- Training and management of seven employees including annual performance reviews. Responsible for the hiring, training and continuing education, professional growth and performance evaluation/review of employees in the IS Department.
- Responsible for overseeing direction of IT department including research on latest technologies then recommendation to Senior Management for approval.
- Project management for all corporate IT projects including budget, scope, requirements gathering, specifications, testing, training and maintenance and payments to vendors.
- Responsible for contract definition/negotiations/payments with all vendors.
- Responsible for approval and purchase of new hardware, software and IT equipment, telecom equipment and office equipment.
- Prepared all departmental reports and budget.
- Interacted between the controller and the Vice President of STI on manners concerning the IS Department.
- Responsible for installation, maintenance and programming of all corporate intranet and extranet, databases, network infrastructure, helpdesk, corporate time-keeping system, telecom, office equipment and software.
- Agile/Scrum methodologies used in this position.
- Technologies used in this position: Visual Basic, Oracle 9i, RMAN, OEM, SQL server 2000, Oracle Forms and Reports, SQL, PL/SQL, HTML, Javascript, VBscript, Visio, Project, Kronos, Cisco.
Education:
Bachelor's Degree in Computer Science, GPA of 3.9
Associate's Degree in Respiratory Therapy.
Technical Knowledge:
Network Administration:
Novell Netware 4.x-6.0, Win 95, 98, XP, NT, 2000, 2003 Active Directory, DNS, DHCP, VPN, Samba, Exchange 5.5 & 2000, Veritas Backup Enterprise, Linux, UNIX system administration, Apache, IIS, Cisco Routers, Cisco Catalyst Switch, Cisco IOS - VLSM, IGRP, EIGRP, RIP, OSPF, BGP, access lists, frame relay, ISDN, ATM, PPP, VLAN (VTP), trunking, etc; SNMP - HP OpenView, LAN Auditor; Sniffer, What'sUp Gold, PC Anywhere, ZENworks, VNC, Dameware, Remote Desktop, Mac OS9-OSX , PC configuration/repair.
Application Software:
MS Office Suite 97/2000/2003 (Access, Word, PowerPoint, Outlook Express, Excel, Publisher, FrontPage, Visio, Project), MS Sharepoint, Quick Books, Norton Antivirus Corporate, McAfee, TrendMicro, WordPerfect 5.1-9.0, Photoshop, Flash, Dreamweaver, Sage Asset Management, Oracle ASCP, McKesson, Kronos, Epic ADT/Prelude certified, Mckesson CentraMax, Paragon reporting, Pathways Materials and Financials reporting, Business Objects/Crystal Reports Enterprise 8-XI.
Programming Skills:
Java, JavaScript, PERL, HTML, Visual Basic. NET, VB Script, VBA, C/C++, PL/SQL, SQL Plus, Oracle Developer, Oracle Forms and Oracle Reports, TCL, JDeveloper, Oracle Discoverer, Crystal Reports 8-XI, Business Objects, SAS, statistical reporting, CRM, ERP, EDI, SDLC, UNIX Shell Programming (bash/ksh, Cshell).
Database Skills:
Oracle 9i-10g database administration, Data Analysis, Oracle Enterprise Manager (OEM), Oracle Security, RMAN, Oracle 11 ASCP, Microsoft Access 2000-2003, SQL server 2000-2005 database administration all aspects including SSIS, SSAS, SSRS, T-SQL.
