I have talent for designing strategies for databases and establishing standards for database operations, programming, and query processes. I have expertise in creating and optimizing data models for warehouse infrastructure and workflow. I am known for consolidating new data sources and providing quality transformation and load. I am skilled in enhancing and driving existing database development operations and processes. Also, I am adept at conducting ETL performance tuning, troubleshooting, support, and capacity estimation. Furthermore, I have a proven track record designing, testing, tuning, and maintaining UI’s functionality to achieve business requirements.I excel at translating complex technical information into rationalized business terms and recommending innovative business solutions to build consensus with key project stakeholders, including executive leadership and high-value clients. I am a versatile and dependable professional with inspiring leadership ability, excellent communication skills, and the capacity to mentor, train, and develop database team for career progression, performance improvement, and recognition purposes.CAREER HIGHLIGHTS: * Slashed time of ETL execution up to 30% by improving query performance.* Cut database size 30% through design and implementation of a trigger that transferred all tables created during ETL into certain schema into another file group to remove this group at the end of ETL.* Reduced manual work time 90% through design and implementation of functionality that deleted any databases’ table records with foreign key constraint recursively.* Automated the mapping process between client’s and competitor’s unit types using amenities’ mapping of client’s unit types and weights of features which increased quality data and reduced manual work time 80%.* Designed, tested, and debugged new and existing ETL.* Subject Matter Expert in logical data modeling and relational database design.* Worked with 100+ large, medium, and small Ukrainian companies in development, configuration, and maintenance of financial and accounting software utilizing ERP system 1C: Enterprise, SQL Server.* Developed Management by objectives solution that was software built to provide flexible Employee Management through goals, assessments, and rewards.
Listed skills include Microsoft Sql Server, Sql, T Sql, Msbi, and 15 others.
