Business Intelligence Sql Server

YEVGENIY

LEDVIN

Sherman Oaks, CA *****

310-***-****

**************@*****.***

https://www.linkedin.com/in/yevge

niy-ledvin-88761a7/

PROFESSIONAL SUMMARY

Dynamic IT Business Intelligence Director with a proven track record at Lionsgate, specializing in data warehousing and systems integration. Expert in Microsoft SQL Server and Snowflake, I have successfully designed disaster recovery solutions and mentored junior engineers, enhancing team performance and data integrity. My unparallel analytical skills drive my success in delivering impactful solutions. SKILLS

• Microsoft APS(PDW) • Microsoft SQL server • Snowflake

• SSIS • Matillion • AWS S3

• SAP BPC 10.1 Microsoft. • Systems integration • .Net EXPERIENCE

Director IT Business Intelligence

Lionsgate Santa Monica, California

October 2007 - Current

• Designed and implemented DR solutions for multiple applications.

• Managed ETL/ELT processing and MPP data warehousing in Microsoft PDW and Snowflake.

• Designed and managed SAP BPC (Microsoft platform) solution.

• Led integration projects between BPC, Snowflake, SQL server and third-party data.

• Responsible for Tableau, SQL server, SAP BPC, Snowflake security and administration.

• Provided guidance and mentorship to junior data engineers and SQL developers. SQL Database Administrator/ SQL Developers

Lionsgate Santa Monica, California

September 2003 - September 2007

• Developed and implemented database maintenance plans to ensure data integrity and optimal performance.

• Migrated legacy databases to newer platforms, minimizing downtime and ensuring smooth transition process.

• Managed user access permissions within database environment, adhering to company policies regarding data security.

• Monitored database performance metrics, identifying potential bottlenecks and tuning system accordingly.

• Delivered expert-level design and development of relational databases.

• Implemented backup and recovery strategies, ensuring data availability in case of system failures or disasters.

• Created wide range of database queries, functions and actions using SQL.

• Developed complex SQL queries to extract, analyze, and manipulate data from multiple databases.

• Trained junior developers in SQL best practices, improving overall team productivity Access Programmer

Artisan Entertainment Santa Monica, California

June 1999 - September 2003

• Utilized Visual Basic for Applications VBA scripting and Access forms to create Title Master application with SQL server as database.

• Created custom forms, reports, and queries to meet specific client requirements.

• Conducted thorough testing of developed solutions, identifying and resolving bugs before deployment. EDUCATION

Master of Science (M.S.) - Mechanical Engineering

Moscow State Automobile and Road Technical Institute (State Technical University) (MADI), Russia Mechanical Engineering

Odessa National Polytechnic University, Ukraine

LANGUAGE

Russian

Native

Ukrainian

Conversational

AWARDS

I have received several Lionsgate Achievement Awards in recognition of my contributions to the successful execution of key company projects.

Contact this candidate