Thomas Lewandowski Email & Phone Number

Columbia, South Carolina Metropolitan Area

Columbia, South Carolina Area

Central Wisconsin

• Data Analyst / Developer for Data Migration project migrating legacy data from Lotus Notes and IBM iSeries to a vendor-customized Microsoft CRM system.
• Investigated existing systems to identify source system data available. Developed data mapping processes between legacy systems to vendor-required input layouts.
• Worked with business Subject Matter Experts to identify and resolve gaps in data.
• Custom ETL processing using Microsoft SQL Server 2012 and T-SQL on legacy system data for standardization and to conform to new system.

Working Remotely In Wausau, WI For Columbus, OH Management

• Oracle application DBA supporting multiple Legal Matter Management application databases.
• PL/SQL development of Stored Procedures, Functions, and View development to assist report development and custom ETL processing for internal and external interfaces.
• Shell Scripting of monitoring and alerting of scheduled processes and scripts.
• Lead designer and developer for implementing AP and GL interfaces for Legal Matter Management application databases. Project implemented early and $40,000 under budget.
• Advised business team on design and implementation of monthly reporting processes driven by GL interface to provide a standardized, repeatable, single-source for reporting to CFO.
• Collaborated with business users to provide 'sanity check' reports validating monthly reporting to reduce errors in released data and speed time to data availability.

Working Remotely In Wausau, WI For Columbus, OH Management

• Oracle application DBA supporting multiple Legal Matter Management application databases in multiple environments.
• Project Lead and Technical Lead on projects to upgrade the Legal Matter Management application databases from Oracle 9i to Oracle 10g to Oracle 11g.
• PL/SQL development of Stored Procedures, Functions, and View development to assist report development and custom ETL processing for internal and external interfaces.
• Shell Scripting of monitoring and alerting of scheduled processes and scripts.
• Provided technical advice and support during data conversions to new Legal Matter Management applications on database processing and ETL processes and procedures.
• Designed, developed and implemented standardized processes and procedures to facilitate exports and imports as efficiently as possible.

Wausau, Wisconsin Area

• Primary database engineer for a multi-billion dollar Long Term Exposure Claim application, associated interfaces and batch processing.
• Technical Lead and Project Manager for migrating application database hosting from an outside vendor to in-house hosting.
• Managed technical relationship with in-house application database hosting technical support to ensure that application and database issues were avoided if possible and resolved as quickly as possible if they occurred.
• Designed, developed and implemented a variety of internal and external interfaces.
• Technical Lead for a project to split batched accounts into individual accounts so that billing, reporting and TPA interfaces could be accomplished.
• Project Lead and Development Lead on a multi-system Finance integration project. Coordinated mainframe and mid-range changes to meet project goals.

Columbus, Ohio Area

• Oracle DBA and Technical Lead for data conversion and implementation of a custom multi-billion dollar Long Term Exposure Claim application. Multiple data sources into an Oracle 8 database.
• Project Lead and DBA for the two unique custom Claim application rewrites and implementations.
• Upgraded the Legal Timekeeping system to Oracle 8i and also consolidated from 40+ distributed production database servers to 5 local production servers.
• Oracle system and application DBA for a Legal Timekeeping system in a countrywide environment with 40+ production database servers and several test/development servers running Oracle 7.
• Redesigned and redeveloped Legal reporting by implementing a data mart. In one case reducing the elapsed time from 48 hours to 20 minutes.
• Technical liaison for client business unit and corporate technical units.

Columbus, Ohio Area