Thomas Lewandowski

Thomas Lewandowski Email and Phone Number

Senior Database Analyst with a Focus on Database and Application Development @ BlueCross BlueShield of South Carolina
columbia, south carolina, united states
Thomas Lewandowski's Location
Columbia, South Carolina, United States, United States
Thomas Lewandowski's Contact Details

Thomas Lewandowski personal email

n/a

Thomas Lewandowski phone numbers

About Thomas Lewandowski

Development Focused Senior Database Analyst/Database Administrator with experience supporting multiple databases on Unix, Linux, AIX and Windows. Primarily SQL Server and Oracle with MongoDB, Netezza and DB2 LUW as well.Extensive experience supporting application development teams. Demonstrated analytical, troubleshooting, technical, communication and problem-solving skills.Technical / Project Lead for database conversions, database and application upgrades, data migrations, design, development and implementation of databases interfaces and reporting development and support.Technology SnapshotExperience on a wide variety of projects, platforms and environments with:SQL Server, Oracle, Database Performance Tuning, SQL and SQL Tuning, Database Backup & Recovery, Capacity Planning, Database Conversions, Upgrades and Migrations, SQL Server Utilities, Oracle Utilities, Windows, Unix, Linux, Solaris and AIX Operating Systems, Unix/Linux/AIX Shell Scripting

Thomas Lewandowski's Current Company Details
BlueCross BlueShield of South Carolina

Bluecross Blueshield Of South Carolina

View
Senior Database Analyst with a Focus on Database and Application Development
columbia, south carolina, united states
Employees:
4226
Thomas Lewandowski Work Experience Details
  • Bluecross Blueshield Of South Carolina
    Senior Database Analyst
    Bluecross Blueshield Of South Carolina Aug 2024 - Present
    Columbia, South Carolina Metropolitan Area
  • Bluecross Blueshield Of South Carolina
    Database Analyst Ii
    Bluecross Blueshield Of South Carolina Aug 2015 - Aug 2024
    Columbia, South Carolina Area
  • Teksystems
    Consultant
    Teksystems Sep 2013 - Mar 2014
    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.
  • Nationwide Insurance
    Consultant, Infrastructure Engineering & Consultant, Data Engineering/Administration
    Nationwide Insurance Mar 2010 - Jun 2012
    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.• Developed and maintained the data models, database design and ETL import design for a custom Legal Electronic Discovery application using data from a legacy Claims Systems.
  • Nationwide Insurance
    Consultant, Business Consulting/Analysis
    Nationwide Insurance Apr 2008 - Mar 2010
    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.• Worked closely with corporate technical staff and vendor staff to resolve application issues.• Designed, developed and implemented nightly reporting table refreshes to facilitate faster report execution.• Trained business users on using Unix and simple shell scripting to enable them to run existing interfaces.• Assisted business reporting users in report development against the new Legal Matter Management applications.
  • Nationwide Insurance
    Specialist, Data Engineering/Administration & Applications Database Specialist
    Nationwide Insurance Mar 2002 - Apr 2008
    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.• Analyzed and tuned application and data warehouse performance issues. Coordinated with IT staff on implementation of recommendations.• Mentor current and new technical and business staff.
  • Paros Business Partners
    Consultant
    Paros Business Partners Nov 1997 - Feb 2002
    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.• Co-chair for the Paros Education Committee.• Completed several relational database designs/redesigns.• Interacted with a wide variety of people at different levels to gather and validate requirements and get feedback on their systems and projects.• Worked with a diverse group of developers, business people and vendors in several different locations and on a variety of software and hardware platforms.
  • Nationwide Insurance
    Various Programming And Analysis Positions
    Nationwide Insurance Nov 1985 - Oct 1997
    Columbus, Ohio Area

Thomas Lewandowski Skills

Oracle Etl Pl/sql Microsoft Sql Server Unix Database Design Databases Relational Databases Db2 Toad Data Modeling Solaris Sdlc Data Warehousing Oracle Enterprise Manager Relational Data Modeling Linux Data Migration Business Analysis Software Development Life Cycle Oracle 9i Oracle 10g Oracle 11g Oracle Sql Integration

Thomas Lewandowski Education Details

Frequently Asked Questions about Thomas Lewandowski

What company does Thomas Lewandowski work for?

Thomas Lewandowski works for Bluecross Blueshield Of South Carolina

What is Thomas Lewandowski's role at the current company?

Thomas Lewandowski's current role is Senior Database Analyst with a Focus on Database and Application Development.

What is Thomas Lewandowski's email address?

Thomas Lewandowski's email address is th****@****ssc.com

What is Thomas Lewandowski's direct phone number?

Thomas Lewandowski's direct phone number is (570)-752*****

What schools did Thomas Lewandowski attend?

Thomas Lewandowski attended Devry University-Ohio.

What skills is Thomas Lewandowski known for?

Thomas Lewandowski has skills like Oracle, Etl, Pl/sql, Microsoft Sql Server, Unix, Database Design, Databases, Relational Databases, Db2, Toad, Data Modeling, Solaris.

Who are Thomas Lewandowski's colleagues?

Thomas Lewandowski's colleagues are Jacquelyn Groff, Marissa Ivey, Liane Navey, Ty-Niqua Trotman, Glennie Stoudermire, Stephanie Shilling, Amy Burba.

Not the Thomas Lewandowski you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.