Lee Pratt Email & Phone Number

SAP Business Planning and Consolidation

US Administration and Finance IT • Led technical team in solution design of complex business requirement; developed and executed complicated stored procedure code.• Designed, developed and maintained framework for files from multiple internal and external sources being imported into SQL database; transformed data as required, and loaded to make available for application use. • Implemented re-design of business Web site in PHP to use template-based approach, and render pages for each of the hundreds of clients based on presence of data files stored in specific folders. Facilitated changes to all sites via simple update to template file, and replaced application with individual hard-coded HTML pages. Significantly facilitated use and maintenance.• Supported dozens of business applications, and trained / supervised several off-shore personnel. • Maintained and developed content for corporate Web sites.

Corporate and Financial Information Systems• Managed project to migrate all SQL Server databases to SQL 2000 environment. Selected for Y2K team to oversee testing, manage results, develop contingency plans and guide department.• Represented department in company-wide effort to achieve CMM Level 2. Assisted in development of peer review procedures for all IT. Identified defects earlier, allowing quicker and cleaner delivery of end products.• Fulfilled simultaneous roles as business analyst, developer and project manager on several business applications.• Heavy SQL stored procedure and report development. Designed and executed SQL data migration for large financial application.

Corporate Systems, Human Resources • Served as main developer on team creating one of department's first client/server applications, a call management application for human resources. Learned and applied MS SQL Server and Visual Basic, participated in business analysis and developed close working relationship with human resources personnel.