Alan Collette Email & Phone Number

Development and implementation of systems and processes using multiple technologies specializing in Oracle Primavera products including Oracle Primavera Unifier, Oracle Contract Management, Oracle BI Publisher and Oracle Project Portfolio Management. Design client driven solutions for custom reporting, data analysis and best practice use. Manage custom client database and document releases utilizing multiple software systems and SharePoint technologies. Incorporate solutions with NoTouchPM@ system and reporting integrations into OneTouch@ system.

Performed SQL server creation and maintenance on databases, tables, stored procedures, as well as perform back ups and restorations.Analyzed optimization of database functionality and performance. Gathered requirements and produced routine and custom reports utilizing simple and complex SQL queries.Troubleshot and debugged application database issues.

Led the implementation of search technology into a new electronic data discovery process.Oversaw the timely integration of new applications and software.Designed new means for processing customer data to meet unique needs of each client.Configured databases to integrate business processes with new software and turn from conceptualization to production.Maximized business process efficiency by working with software developers to optimize and debug application software.Facilitated communications with vendors to optimize software product configurations and administer daily data extraction and search procedures.Developed and documented specific operating guidelines for software products to increase accuracy of data yield.Utilized team approach to coordinate activities of analysts working on different phases of implementation.Coordinated quality assurance and performance improvement as well as documentation for these areas.Developed and administered web demonstrations of concept and keyword searching for e-discovery utilizing Autonomy Search Technology and interfaces.

Managed a team of 6 people and directed their actions to achieve client goals for timely data discovery and processing.Developed technical specifications for system enhancements to improve business processes.Maintained data in a high volume ASP document repository through modifications within proprietary application as well as data manipulation using MS Access and MS SQL Server.Trained and assisted team in data formatting and loading to ASP utilizing tools such as MS Excel, MS Access, MS SQL Server, and text editors as well as proprietary tools.

Developed graphical interfaces of insurance software systems using VisualAge for Java.Programmed web software application using VisualStudio and Visual Basic, XML, and JavaScript.Implemented Java WebSphere web solutions for property/casualty insurance systems utilizing JSP, HTML, and XML.Assisted in implementation of Java applet version of graphical interface for software systems.Technical Lead of international project that implemented software interface which included resolving functionality issues, debug code problems; implemented framework changes; evaluated, analyzed and resolved problems experienced within processes or software solution.Oversaw and trained teams of 5 to 30 developers in Object Oriented design and programming practices as well as proprietary development procedures.Developed realistic timelines and presented to management.Condensed and organized requirements as supplied by business analysts.Provided onsite support to customers to customize processes and interface designs to maximize product functionality.

Worked in a demanding, high volume international software development environment.Performed source code management including release deployments to internal development and client production environments.Responsible for the set up and maintenance of COBOL/CICS/DB2 environments in mainframe and client/server platforms. Supervised technical training of 3 engineers in source code management, environment set up, and technical troubleshooting.Developed, maintained, and implemented delivery and installation systems. Performed client installations and provided support of software system at client sites.Performed routine maintenance on PCs including software and network interface card installations.Maintained LAN servers including creating, modifying, and deleting user ids and email profiles.