Scott Mitchell

Email: resume@the-mitchells.org

Summary

Over 12 years of technical expertise in designing, implementing, integrating, and supporting IT solutions. My experience extends into the enterprise environments of retail, insurance, manufacturing, and health care.

6 years of experience designing and developing Java based web applications. Comfortable with modeling both relational and object oriented domain models. Experienced with Struts, object relational mapping, and web services.

10 years of technical experience with the Oracle Applications (versions 8.3 - 11.5.9). Roles and responsibilities have included systems requirements definition, system design, integration and customization design and development, data conversion, implementations, and upgrades. Strong understanding of financials and distribution applications.

Skills

Languages: Java (J2SE, J2EE), SQL, PL/SQL, XML, Unix shell, HTML, CSS, JavaScript, ASP, Web Services
Development Tools: Struts, Hibernate, Spring, WebWork, OSCache, Ant, JUnit, IntelliJ, Eclipse, SQL*Plus, SQL Navigator, Oracle Reports, Oracle Workflow, Informatica, Cognos ReportNet, JReport, webMethods B2B
Modeling Tools: PowerDesigner, Poseidon
Application Servers: Tomcat 4/5, JRun, OC4J/Orion, JBoss
Database Software: Oracle (versions 6-9i), Sybase ASE, MySQL, SAP DB
Operating Systems: Linux, HP-UX, AIX, Solaris, Windows 9X/2000/XP
Soft Skills: Application Architecture/Design, Application/Database Development, Mentoring, Project Planning, Requirements Gathering, Use Case/Specification Creation, Relational Modeling, OO Modeling, Application/SQL Tuning

Experience

Senior Application Architect - Servidyne Inc. - Apr. 2005 - Present

One of 2 architects working on a java/web-based work order management system with a Blackberry mobile client application aimed at customers in the office and hospitality space. Application offered to customers in ASP mode with customers served from one of two application clusters. Projects/accomplishments include:

  • Development of preventative maintenance functionality opening the doors to the hospitality market.
  • Design and development of guest services functionality including high speed data entry screens (utilizing AJAX) to enable the application to be sold into hotel call centers handling hundreds to thousands of calls per day.
  • Design and implementation of cluster enabled caching system to significantly increase the scalability of the system by reducing calls to the database by over 50%.
  • Responsible for review of frameworks to add to the application to reduce development effort and improve quality.
  • Initiated port of the application from JRun to Tomcat which resulted in significant increase in the load capacity of each application server.
  • Participated in scalability/load testing project. Helped design test scenarios, review test results, and tune application.
  • Implemented a continuous integration environment utilizing CruiseControl
  • Designed and implemented build process to automate propogation of database schema changes to all application sandboxes to keep database in sync with the code base.
  • Designed and implemented a CRUD framework to reduce development effort to implement data maintenance pages.

Applications Architect - RMC USA, Inc. - Nov. 2002 - Apr. 2005

Responsible for design of internet/intranet web based systems, customizations and interfaces with Oracle Applications databases, and data warehouse model and ETL for 6 companies. Development team consists of 6 other developers and a mix of consultants brought in on an as needed basis. Accomplishments include:

Projects:

  • Re-implemented systems for Mid-Atlantic region which merged 3 subsidiaries into one company. Responsible for the architecture and design of the customization and interfaces between the Oracle Applications, the CommandSeries dispatch system, and the data warehouse.
  • Created the myrmc.com web site to allow customers to review transaction information and pay open invoices. Rule based design used to allow the system to integrate with different systems depending on which subsidiary the customer is associated with. The system also allows for local branding by allowing each subsidiary to have it's own look and feel. Responsibilities included design of the underlying data model (created in PowerDesigner) and the design and development of the Java domain model, Struts actions, and Hibernate mappings.
  • Creation of a mobile interface to the myrmc website to allow customers to check on order details and delivery status.
  • Designed and was one of the developers for a web based time entry system used to track plant employee’s labor hours. . Utilizes the existing data warehouse to provide both driver and location master information. Responsibilities included design of the underlying data model (created in PowerDesigner) and the design and development of the Java domain model, Struts actions, and Hibernate mappings. Also designed the integration of this application into the data warehouse.
  • Designed and was one of the developers for our Customer Concern Tracking System used by the technical services department to track quality claims made by customers. Responsibilities included design of the underlying data model (created in PowerDesigner) and the design and development of custom DAOs, and Struts actions.
  • Participated in the creation of multi-company, conformed, dimensional data marts for delivery and invoicing information as the foundation of an enterprise data warehouse. Responsible for the data model (created in PowerDesigner), sourcing, and ETL design (all ETL built using Informatica).

Operational improvements:

  • Implemented source control system for use by the development team and integrated this system into the change control process used by operations.
  • Implemented coding standards and customization guidelines for the Oracle Applications environments.
  • Designed and developed a web application framework based on Struts and Hibernate. Framework used to develop 5 intranet applications and 1 internet website.
  • Implemented continuous integration process and unit tests to help improve quality of the Java based applications.

Solutions Development Manager - Tactics/Stonebridge Technologies/SegueSolutions - May 1996 - Nov. 2002

Responsibilities included development of intellectual capital around Oracle Applications customization and EAI/B2Bi solutions in addition to project work for clients. This includes methodologies, best practices, and re-usable components. Accomplishments/experience includes:

  • Technical Lead for 4 implementations of the Oracle Applications. Responsible for designing and developing interfaces, customizations, and conversions typically using PL/SQL, Oracle Forms, Oracle Reports, SQL*Loader, and Unix shell scripts. Also provided support to functional team for issues with the core applications performing root cause analysis, SQL tracing/tuning, and patch application.
  • Technical Lead for 8 upgrades of the Oracle Applications. Responsible for analysis on existing customizations to identify areas that needed to be modified do to functionality/data model changes. Also responsible for the planning and execution of the actual cutover process.
  • Improved the quality of the customizations/integrations delivered in Oracle Applications implementations through improved definition of customization guidelines and development of reusable components.
  • Created processes and procedures that formed the basis for the Tactical Migration product for Oracle Applications upgrades.
  • Implementation of webMethods B2B solution. Responsible for the architecture and detailed design of the system used to integrate with trading partners using EDI over the Internet. Designed modular, rules based system to allow for easy implementation of new trading partners and new document formats.
  • Involved in development of a J2EE/Struts based work order management system. Responsibilities on this engagement included:
    • Design of the integration between the Visual Basic based handheld application and the J2EE based server application for the upload and download of scheduling and work order information. Solution utilized XML based Web Services to pass large, user defined data types between the two platforms.
    • Development and testing of the Java based, server-side web services
    • Development and testing of several pages in the core application using Struts tag libraries, session beans, and entity beans.

Analyst - Southern Company Services - June 1992 - May 1996

Supported the Oracle Financials (8.3, 9.4.2, GL, AP, AR, FA, PO, OE, INV) software packages used by non-regulated utility companies. Duties included implementing the software for new companies, troubleshooting production problems, designing custom extensions, and upgrading applications. Along with these job duties, provided system administration for 2 HP 9000 machines running HP/UX, and was the primary DBA for three production Oracle databases.

Education

BBA Computer Information Systems - Georgia State University

Publications

Co-authored and presented paper entitled "The Automation of Custom Interfaces Between Oracle and Legacy Systems" - Oracle Applications Users Group Proceedings Spring 2000

References

References available upon request.


EditThisPage BackLinks PageInfo last changed on 02/02/07 12:36:14