Alexey Simonenko Email & Phone Number

Seattle, Wa, Us

Seattle, Wa, Us

New York, Ny, Us

• Designed and built solution based on business requirements.• Designed new data flows, worked with vendors on exporting data from external systems and processing it through ETL into a Hadoop Data Lake.• Designed and supported data inflows/outflows for Machine Learning models.• Performance tuning of existing data flows based on Python workflow.• Designed ad-hoc reports for spotting anomalies and outliers, extracted and cleansed data from multiple sources.• Developed Python scripts to automate everyday team tasks.

Moscow, Russia, Ru

• Full cycle Data Warehouse development - gathered requirements, created specifications, designed and developed ETL (SSIS, C#/.NET, scripting) and a data model.• Designed and developed Data Warehouse components for regulatory banking reporting (MS SQL Server).• Acted as a technical lead for a team of developers and analysts working from multiple sites.• Gathered user requirements, created project technical documentation, designed and developed Data Marts for ad-hoc analysis.• Developed Business Intelligence solutions (Stress testing scenarios, What-If analysis, etc…) for Treasury and Finance users with SAP Business Objects and MS Reporting Services.• Improved data storage format for more cost effective usage of storage arrays and predictable growth.• Developed and supported daily batch process for DWH master loading. Used ActiveBatch software to connect multiple servers / data sources and schedule the process in order to meet required timeframes.• Analyzed Data Warehouse performance on regular basis taking care of fine tuning of complex queries. Identified and resolved bottlenecks in BI / DWH engine stack.

New York, New York, Us

• Maintained Data Warehouse (1TB+, running on MS SQL Server) – ETL, architecture, internal structure, synchronizations, data flows, etc.• Developed end-user analytical reports.• Initiated and managed projects of DWH optimization and development.• Configured database information security.• Change management and control.• Maintained documentation library (modules descriptions, data dictionary, etc).• Performed database optimizations, did performance tuning and consistency checks.

• Analyzed user requests and designed GUI database applications. • Developed applications with scripting tools and MS SQL Server databases. • Developed DTS packages to transfer data from Excel and Oracle to MS SQL Server• Used MS SQL Server tools to monitor and tune the performance of T-SQL scripts and applications.• Integrated business software. Implemented enterprise information bus. • Maintained the Microsoft SQL Server database and performed backups.