Designed and built Planning Interface (MPI) in lead role (four team members) for a Fortune 50 company.
- Designed MPI to act as interface among several systems, including budgeting and category planning tool, store allocation system, and various legacy and Java applications.
- Designed and implemented timing-critical batch processes using Oracle 9i, batch scripts (ksh), SQL-Plus scripts and PL/SQL packages.
- Built screen mockups for prototypes and testing purposes.
- Provided project time and resource estimates using MS Project.
- Presented to and educated management regarding multiple paths in terms of complexity, technologies and resources required, and time requirements.
- Scheduled, coordinated and distributed work load efficiently among all team members according to strengths and abilities; successfully led team through rapidly changing, multi-phase project.
- Assumed sole responsibility for database design and rebuild to more efficiently meet business needs.
Rewrote PL/SQL functions and stored procedures to align with new functional
requirements and new database design; designed and built nightly batch architecture
to insure process reentry capabilities.
- Modularized code and incorporated logging, error-handling and transactional requirements.
- Authored comprehensive system use cases, system flow diagrams and architectural documents.
- Developed process to lock users out of the application in the event of critical batch process failures.
Worked closely with Configuration Management to insure streamlined build and code
- Managed complex, hierarchical permissions structures in compliance with SOX requirements.
Worked closely with QA group to insure smooth transitions among environments.
- Provided volume and load estimates; performed risk management analyses.
- Interfaced extensively with Enterprise DBAs; provided ER diagrams using Erwin, forward and reverse engineered multiple schemas on development server, and submitted change scripts for production.
- Built VB6 screens to allow for detailed control of merchandise planning from several hierarchical layers.
The MPI system was designed, along with the other upstream and downstream systems, to
allow the merchandise planners fine-grained control over inventory at the warehouse, ad
region, and store levels.
Scratched the previous database design which proved to be unworkable, and redesigned it from the ground up to efficiently allow overlapping of ad region and warehouse/DC without complex SQL manipulations.
Worked through critical issues with various meetings with senior business and technical management. The MPI system sat nearly central among an Essbase feed, and downstream AS400, mainframe, Java and Unix processes/feeds.