Data Analysis Engineer

ALEH HARAMYKIN

Phone: +1-215-***-****

Email: ****@*******.***

Skype: aleh_olgor

LinkedIn: http://www.linkedin.com/in/aleh-haramykin-979abb43 OBJECTIVE: A full-time position in the field of Data Analysis, SQL development, Database design and development of ETL processes.

RELOCATION: Yes.

PROFESSIONAL SUMMARY:

10+ years of IT experience with expertise in data analysis, sql programming, database design and ETL development. Including extensive experience in coding, maintenance, troubleshooting and support of database applications using PL/SQL and T-SQL with expertise in extensive SQL coding of user-defined functions, stored procedures, views, table-valued functions and common table expressions. Also possess experience in design and development of processes and data analysis. TECHNICAL SKILLS:

OS: Windows NT/2000/XP/7/8/10/11, UNIX

Office Software: Microsoft Office, Outlook, Acrobat, IE Development environments: DataGrip, PyCharm, Visual Studio, Visual Code Programming languages: T-SQL, PL/SQL, Python.

RDBMS: PostgreSQL, MS SQL Server, MySQL, Redshift, Access ETL: Airflow, SSIS

Cloud: AWS, EC2, RDS, S3, Postgres, Redshift

Source control: GitLab, Bitbucket

Data Modeling Tools: ERPlus, ER Studio

Data Visualization: PowerBI, Tableau

Methodology: Agile, Scrum, Kanban

Math soft: Maple

Other skills: Excellent knowledge of Advanced Computational Methods in Science. Strong physics and math background.

EXPERIENCE:

DCV InfoSystems/Warsaw, Poland January 2024 – July 2024 Data Engineer

Maintenance and support of existing DB infrastructure.

Writing scripts for automation database maintenance tasks.

Enhancement of functionality of database routines.

Data modeling. Determination of policies for collection, storage, organization and utilization data.

Design and implementation of new ETL processes and support existing ones.

ETL processes orchestration using Airflow and Crontab tools.

Query performance analysis and tuning.

Principal33/Sanofi, R&D Department, Romania, Brasov August 2022 – November 2023 Data Engineer

Design and development data models for data storage. Data normalization.

Building data delivery pipelines from source to destination within framework of existing architecture.

Create and maintain load/clean/transform and extract routines for large datasets processing.

Work closely with customer to review requirements and planning and implementation roadmaps.

SQL coding, creating stored procedures and functions, debugging, testing, perform QA, support and maintenance.

Generation of aggregated data sets for further business analysis and decision making. DTEK, D.Trading, Trading department, Kyiv Ukraine June 2021 - April 2022 Data Engineer

Design and development data models, creation of data warehouse trading department. Create new and maintain existing SQL Stored procedures to extract, transform, and load data from multisource systems to reporting data structures. Transform complex business rules and logic into SQL code.

Creating, validating, deploying, and managing data extraction, transformation, and loading (ETL) procedures that pull data from multiple data warehouse sources and support ETL solutions

Work with Reporting Business Analysts to review requirements and priorities related to project. Provide data to Business Analysts on ad-hoc basis to support testing needs. Adhere to Data Development Lifecycle (DDLC) practices for documentation and change management procedures.

Creating dashboards using Tableau for visualization aggregated data sets. Department of Revenue, City of Philadelphia March 2017 - June 2021 ETL Developer/Data analyst

Collection of business requirements, analysis, data modeling, design, coding, development, testing and implementation of business applications with RDBMS, Data Warehouse, and client/server environment applications of financial department.

Support of existing and development new ETL processes for filling data from various sources into new data warehouse.

Writing new scripts for optimization tax collection routines (added $8-12M to city budget monthly)

Implemented data validation tool using Python scripts to reducing data-related incidents of existing ETL processes.

Building informational dashboards based on aggregated datasets using Power BI. Cotiviti LLC, Conshohocken PA January 2014 – Feb 2017 Business System Analyst/SQL Developer

Identify, analyze and design processes to improve an overall flow of information within operations. Document current applications and processes. Support the development of overall corporate systems strategy and roadmaps. Communicate with stakeholders and business management to understand and identify needs and initiate projects to meet those needs.

Analyze business processes and system functionality, identify inefficiencies and required functional enhancements. Development of processes comply business logic requirements.

SQL coding. Writing views, user-defined functions, stored procedures and reports for enhancing performance and extension functionality.

VBA coding, debugging, testing, QA and support front-end business applications. M&T Bank, Buffalo NY August 2013 – November 2013

Information systems management/SQL Developer

Design, implementation, maintenance and support of information systems. Writing of SQL code to support business applications in accordance with business logic. Creating views, user-defined functions, stored procedures, for enhancing performance and extension existing functionality of informational report system.

Diversified Controls Inc, Orchard Park NY, USA October 2010 – August 2013 Database developer

Database design, programming, management and maintenance. Writing SQL code to for business applications. Writing views, user-defined functions, stored procedures, for enhancing performance and extension database functionality. Queries optimization.

Writing, debugging and testing Objective-C code. Perform quality assurance.

Development and implementation data integration and workflow solutions using SSIS. State University of New York at Buffalo, Buffalo NY August 2006 – June 2010 Teaching assistant/Scientific Programmer

Taught PHY101-102, PHY151-152, PHY157-158 and PHY257-258 courses, labs and seminars.

Wrote C++/Maple code for scientific applications and projects in the field of experimental physics. Tested and optimized application’s performance. Adapted existing code for multiprocessor platforms.

DYNOPLEX, St.Petersburg, Russia October 2004 – August 2006 IT Engineer/QA Engineer

Managed a team of software testers, created test plans, controlled and coordinated team work with developers.

Designed and maintained database of customer issues. Wrote code of stored procedures and user defined functions (T-SQL).

Tested and evaluated new versions of software, provided QA, performed support of enterprise users. Dealt with customer concerns.

EDUCATION: State Uiversity of New York at Buffalo, USA Degree: Master of Science in Physics, May 2010

Major: Computational Physics

ST.PETERSBURG STATE UNIVERSITY, RUSSIA

Degree: Master of Science in Physics, February 2004 Major: Computational Physics

SKILLS:

Equally successful in both team and self-directed settings

Extensive experience in troubleshooting and solving complex technical problems

Adapts rapidly to new environments and result oriented

Quick learner and fast applier of new technologies in daily routine

Excellent communication, interpersonal skills and analytical mind

Adept at articulating complex technical concepts to users of varying technical understandings

Able to communicate goals and instructions in a clear and efficient manner.

Work with the business side of the company to determine the best course of action and level of effort when designing an information system/process/application/tool.

Able to listen to and interpret what the business side wants to see accomplished, discuss details in an easy-to-understand way, and then translate it all into technical.

Contact this candidate