Nickolas Smith Email & Phone Number

Mandeville, Louisiana, United States

Sedgwick acquired YORK. Presently transitioning from MSSQL to Oracle and helping with the migration from Legacy YORK systems into Sedgwick. Developing ETL processes to feed Tableau and other in-house applications.

Mandeville, LA

Promoted from lead engineer to manager of the Business Intelligence team. Still active SQL Developer and now managing a team of 6 SQL developers. York purchased by Sedgwick, transitioned to Lead Business Intelligence Engineer in March.

Mandeville, LA

Moved into Lead BI role after successful completion of large billing project effectively removing manual intervention in client billing by developing a data model to replace 40k line functions. One direct report to start putting together a plan for a new EDW initiative.

Columbus, OH

Database DevelopmentETL DevelopmentProcess DevelopmentThe things I love! Relocated to to be closer with the BI team which is located in Mandeville, LA.

Dublin, Ohio

• Modernized multiple departments by developing databases and intuitive web interfaces to replace their reliance on tracking information in Excel documents.
• Led the charge for developing a new data warehousing solution for customer and associate data. Developed new ETL packages and custom applications to load data from numerous sources and database types.
• Transformed existing ETL processes to be more reliable and responsive. Improved logging and error safeguards for faster notification if there was a problem.
• Overhauled legacy database to normalize tables, streamline stored procedures and eliminate or greatly reduce long running queries.

Dublin, Ohio

• Revolutionized Human Resources by developing new C#.NET Web Based HR System, custom tailoring it to our needs and replacing legacy FoxPro application.
• Utilized DBA and Programming experience to completely migrate company from MySQL to MSSQL.
• Strengthened client relationships by developing the companies first external secure.NET web portal for clients to retrieve reporting, recordings and other valuable information. This was also an additional revenue.
• Instrumental on developing the databases and processes that led to detailed analysis regarding call center trends, attrition, sales and customer service KPIs.

• Worked daily with VB 6, ASP, SQL and generally all area’s of IT.
• Designed, developed and deployed new applications with a SQL Server backend.
• Installed, maintained and developed databases in SQL Server 2000.
• Worked with Tables, Views, Stored Procedures and basic Triggers in SQL Server 2000.
• Made and implemented multitude of recommendations and suggestions setting a direction for the IT department not only from a programming and database view but also selected, setup and deployed all servers and networking.
• Trained and assisted new and existing employees for the IT department.

• Promoted to second level help desk support along with a raise in two months.
• Used my customer service skills and abilities with Windows and Networking to assist Bellsouth Internet Service customers with their connections.

• While still in High School I helped update and migrate their code from Microsoft Access to SQL Server with a web based front-end.
• Worked daily with ASP, SQL and VB while developing applications for in-house employees and external clients.

Computer Science, Programming

Activities and Societies: Classes in several programming languages.

Computer Science, Networking, Programming

Activities and Societies: Post SecondaryTook classes in Programming and Advanced Programming while still attending High School.