Alex Emelianov

As a Database Consultant, I've worked on projects that involved a variety of tasks like analyzing and optimizing database performance, reviewing database models and code, and identifying opportunities for application optimization and refactoring. I have successfully pinpointed bottlenecks and implemented solutions that improved system performance by up to 10 times. My approach is to ensure databases run efficiently and effectively.

Led projects in sales prediction analysis to enhance forecasting accuracy. Developed interactive analytical dashboards for informed decision-making. Managed financial data processing to aid strategic financial planning. Analyzed user migration patterns for improved user experience. Implemented automation in reporting raised report delivery to 4 times. Conducted routine audits and checks to ensure data quality and integrity. BI Reporting, Oracle, Teradata, MS Excel, Qlik, Data Science, Revenue management.

• Consolidated data from multiple sources into a unified data stream, ensuring consistency and accessibility • Designed data warehouse structures and ETL tools to support dashboards and reporting • Automated the generation of user-friendly Excel extracts to enhance data visualization and decision-making efficiency • Technologies: MSSQL, Excel, Tableau

Automation of web download Visa/MasterCard invoices. Project was developed in MS Excel/VBA and delivered successfully. Next automated project helped the team to reconcile various invoices from Visa, MasterCard and calculate complex Scheme fees. Being as part of analytic team developed a system (SQL Server; Microsoft Excel) which was targeted to invoice around hundred merchants. After phenomenal success, the product produces over few thousand invoices for key enterprise customers.

• Data modelling, transformation and representation in AON’s Data warehouse • Country data analysis (SQL Server 2008, Oracle 10g, Tableau), ETL (T-SQL, PL/SQL, SPSS) • Report development (Excel, VBA) • Validation processes development and automation (VBA, Python)

SQL performance tuning. Troubleshooting of existing reports, optimisation of queries, indices. Report development and design (Business Objects XI, Crystal Reports 9/XI) Development of various modules of TopClass eLearning System (Oracle/MSSQL/ Java) Development and support e-Commerce module for TopClass (Java, JSP, DHTML, YUI) Customer's DB performance optimisation/troubleshooting/support

databases (SQL server, firebird, interbase), delphi, asp.net, c#