Overview

Experienced technical and senior systems analyst knowledgeable in all phases of the systems development life cycle SDLC . Background includes inventory management in order fulfillment industries and retail point of sale. Retail software experience includes designing and creating a complete interface system between Oracle RMS RETEK and E3 Inventory Management Systems. Excellent analytical, problem resolution and functional/technical documentation skills. Ability to effectively communicate with upper management and the user community, successfully translating business needs into technical specifications and design.

Skills Summary

Experience

Confidential

Position: Senior Systems Analyst

• Created detailed functional design documents
• Designed and coded functional solutions in the following languages:Linux Shell scripts KORN Shell, Oracle SQL, Oracle PL/SQL and Pro C , IBM Mainframe DB2, COBOL and JCL .
• Created detailed test plan documents including implementation of recommended improvements to ensure a more complete regression test.
• Led code walkthrough meetings with team to solicit feedback and ensure expected results
• Supported implementation of quarterly releases, including troubleshooting, status updates and on-call support
• Initiated weekly training forum to share knowledge base and cross-train team members

Confidential

Position: Consultant PL SQL

• Responsible for the daily EDI support which included the BOOMI EDI software package. Worked directly with the accounting team for daily support resolutions and the occasional enhancement.
• Project lead in charge of developing new EDI replacement software.
• Gathered the accounting team requirements which were used to design both the JAVA GUI front end and PL /SQL batch processing back end . Design also included Oracle tables and data flow.
• Lead a third party vendor in developing the JAVA GUI.
• Solely responsible for developing the PL/SQL back end programs.
• Among other improvements, the new design included a huge difference from the BOOMI processing model. Flat files were replaced with PL/SQL modules that used a database link between Oracle and MS SQL. This design feature provided a HUGE advantage whenever a vendor restart price errors for example was required no manual deletion of flat files was required and no manual reset of MS SQL staging tables .

Confidential

Position: Senior Business Analyst

• Worked closely with clients and AHM technical team located in VA to monitor client project requests and problem support log.
• Gathered business requirements from the client to create functional documentation for design and development.
• Monitoring the support log included creating business functional and technical documentation and reported updates in weekly client meetings.

Confidential

Position: Senior Systems Analyst Consultant

• Tools: Oracle 10g, UNIX scripting, PL/SQL, Pro C, TOAD, SQL
• Designed, developed and installed key reports identifying inventory shipments received for which there was no sales activity, identifying approximately 1M of excess inventory. Design required centralizing eight 8 different database / business divisions into a single location for users to access data and generate reports. Development tools included: Oracle 10g, PL/SQL and UNIX scripting.
• Led a team of Oracle Forms and PL/SQL developers in installation of a series of new store reports designed to show inventory and purchase order discrepancies including inventory sold but never received between the host and warehouse management systems. Duties included converting user requirements into a functional design, creating supporting table design and program specifications. In addition, developed UNIX batch scripts and coordinated testing effort with the Quality Assurance team.

Confidential

Position: Senior Systems Analyst - Consultant

• Tools: Oracle RMS 8.0, Oracle 10g, UNIX Scripting, Oracle Reports 9i, Pro C, PL/SQL, TOAD, SQL
• Worked with Inventory Control management to research and correct 4M Stock Ledger f imbalance by creating a resolution process that included several new Oracle balance tables, Pro C programs and validation scripts.
• Wrote UNIX script to manage space usage on several mount points. Notification prevented space-related nightly batch problems.
• Converted Inventory Control User business requests into functional requirement documents. In addition, created technical design documents for each request and provided development time estimates to I.S. management.
• Designed, developed and installed several batch programs including reports to list duplicate inventory cartons, negative inventory and an inventory movement/balance report.
• Provided daily support to Inventory Control team. Support tasks included problem research, ad-hoc reports, and file extraction.

Confidential

Position: Senior Systems Analyst

• Tools: Oracle RETEK 6.0, Oracle 9i, UNIX Scripting, JDA E3 Advanced Warehouse Replenishment AWR 2004.2, JDA E3 Advanced Store Replenishment 2004.2, JDA Network Optimization OPT , Pro C, PL/SQL, SQL
• Led a team consisting of AS 400 Developers and replenishment users to install JDA Network Optimization OPT enhancement. This installation linked JDA E3 Advanced Store Replenishment ASR with JDA E3 Advanced Warehouse Replenishment AWR .
• As lead functional and technical consultant, developed batch interface that fed Oracle RETEK data to JDA E3 AWR and JDA ASR systems. Implementation saved the company 104 M by reducing inventory overstock by 58 .
• Created a database archive system that reduced the number of active records by more than 50 providing users with faster online response time while maintaining research accuracy.
• Designed a complete vendor return system RTV into Oracle RETEK that will automatically process 80,000 vendor returns a year providing 65 million dollars in traceable returns for credit.
• Provided daily business support and final peer review approval for support team members.
• Participated in large team effort to reclassify all SKU class and subclass attributes within the Oracle RETEK system.
• Acted as lead technical consultant to develop a process to convert inventory, transfers and purchase orders from a closed warehouse to the new warehouse. Created tables, PL/SQL and Pro C programs to ensure integrity of data.
• Modified Oracle forms, Pro C, UNIX scripts to allow RTV users to reserve vendor return numbers.
• Provided daily Oracle RETEK stock ledger support including EXCEL files, comma delimited files and Oracle Reports.
• Designed detailed functional, technical documents and test plans that enabled Oracle Report developers to create a series of complex reports that balanced monthly Oracle RETEK totals to Data Warehouse inventory totals.
• Created a Tax department reporting system consisting of Oracle Forms, Oracle reports, Pro C extract programs and UNIX scripts. Reports were used to successfully balance with Michaels Data Warehouse system.

Confidential

Position: Systems Consultant

• Tools: Catalyst 4.0, Lawson 7.0.6, Microfocus COBOL, UNIX Scripting, PERL, LOTUS Notes, Oracle 8, SQL
• Participated in the creation and installation of data interface programs used to send and receive files between warehouse inventory management system CATALYST 4.0 and host system Lawson 7.0.6 .
• Designed, installed and trained users on a new and complex customer pricing structure that based on management defined criteria would allow our sales team to actively pursue new customers while rewarding loyal active customers.
• Converted the paper driven daily sales reports to LOTUS NOTES. This conversion provided upper level management faster access to reports, eliminating manual report distribution.
• Provided IT support for Price Waterhouse audit. Reports were crucial to ensure SEC compliance.

Confidential

• TOOLS: IBM Mainframe MVS/ESA, CICS, COBOL, DB2, JCL, TSO
• Installed warehouse shipping system TAN DATA . The shipping system captured all relevant shipping information including shipping costs, printed bar code labels, and UPS Bill of Ladings.
• Provided IT support for Aviall accounting team and Price Waterhouse auditors to calculate excess and obsolete inventory.
• Inventory Lead responsible for creating a complete online CICS physical inventory system. System included inventory count entry, count reports, inventory variance reports and final postings.
• Provided IT support for business team that developed a new mail order catalog business Aviall's Airplane Things . Selected business software, created reports and all data interface between new company and host in-house system developed in CICS .
• Team member active in the conversion of the in house developed online system SUPRA database to CICS/DB2.