Data Engineer Analyst

ALIAKSEI CHARNIAUSKI

Data Engineer Database Developer Data Analyst Report Analyst

@ ********.***********@*****.*** https://www.linkedin.com/in/aliaksei-charniauski-4a1889358 Simsbury, CT

SUMMARY

I possess over 25 years of professional experience in the Data Engineer, Database Developer, Data Analyst and Report Analyst project roles:

Strong knowledge and experience with various RDBMS systems (Oracle, Teradata, MS SQL Server), versatile experience in design, data modeling, development and optimization of ETL/ELT solutions (Informatica and Informatica Cloud), DWH/BI deliverables, and performance tuning

Experience with engineering technologies, frameworks and languages such as Python, Spark, Angular, PL/SQL, T-SQL

Passionate and steady increasing the experience with the Cloud platforms (AWS services for processing Big Data) and Gen AI/ML

Deep understanding of business processes in the Healthcare (with Legal and Compliance areas), Transportation and Logistics and Banking business domains

Deep understanding of Software Development Lifecycle (Agile, SCRUM, Kanban, Waterfall, RUP models)

Strong analytical and problem-solving skills aimed at improvement efficiency of the solutions implemented. Proven ability to effectively organize and prioritize workloads in a constantly changing environment. Quick leaner and enabler of new technologies.

SKILLS

Engineering Practices

Data & Analytics: DWH & DB Concepts, Data Discovery, Data Solution Architecture, ETL/ELT Solutions, Data Preparation, Data Management, Data Analytics Engineering, Dimensional Modeling, Data Profiling, Data Transformation Concepts, Data Analytics and Visualization

Database Development: Architecture, Transactions, Data Objects, Tools & Utilities, Coding, Performance tuning

Advanced Technology: Data Modeling, Solution definition, Software Engineering Processes, APIs and Integration, CI/CD

Technologies

Databases: Oracle, MS SQL Server, Teradata, PostgreSQL, MySQL

Computer Languages: SQL, Oracle PL/SQL, T-SQL, Python

Frameworks: Angular, Flask, Apache Spark, Pandas

Platforms: Amazon Web Services (AWS), Docker

ELT/ELT: Informatica, Informatica Cloud

Data: Databases, Oracle RDBMS, Oracle Streams, Informatica PowerCenter, AWR Reports in Oracle Database, Informatica Cloud Data Integration, Oracle Partitioning, Oracle Advanced Queuing, Oracle Database Platform, Oracle In-Memory, XML Path Language, XML Query Language, Databricks, MySQL, SQL Management Studio, Data Warehousing, Amazon RDS, Microsoft SQL Server, Microsoft SQL Server 2014, Teradata Database, Sybase SQL Anywhere, Oracle Enterprise Manager, SQL Databases, Toad for MySQL, Data Integration (ETL/ELT) Platforms, ASC X12, PySpark, Microsoft SQL Server 2012

IDEs: Visual Studio, PL/SQL Developer, Toad for Oracle, Jupyter Notebook

Web/Application Servers: Apache HTTP Server

Solutions: Microsoft Excel, MS Project, Oracle VirtualBox, Jira, Microsoft Visio, Team Foundation Version Control, Oracle SQL Developer, Oracle SQL*Plus, GitHub, Apache Hive, TortoiseSVN, Sybase Power Designer / Quest Designer, Microsoft Word, Microsoft Outlook, MS PowerPoint, PuTTY, SourceTree, Version Control Systems

Operating Systems: Microsoft Windows, Linux, Unix

Industry Specific Technologies: EDI X12

Standards: JSON, REST API, Git, Regular Expressions

Industries

Healthcare: Healthcare Provider

Insurance: Health Insurance

Financial Services: Legal & Compliance reporting

Transportation and Logistics

Banking

Leadership & Soft Skills

Communication: Business Correspondence

Teamwork and Collaboration: Teamwork and Collaboration

Growth Mindset: Data Analysis, Root Cause Analysis

EXPERIENCE

2018-2025 EPAM Systems, Software Engineering Team Lead

Client: Cigna Corporation. Bloomfield, CT

Project Roles: Senior Data Engineer, Key Developer

Completed several automation projects for Compliance and Legal reporting which were built on top of Cigna Enterprise Data Lake (Teradata, Hadoop, Hive):

Project #3:

The project focused on development solution (BEAM application) for automation of the Compliance and Legal reporting. The solution is built on top of Enterprise Data Lake and is positioned like a self-service across wide range of customer’s departments.

Responsibilities:

Responsible for business domain analysis, requirements gathering, design, development, testing, deployment and production support of BEAM application, which is consists of up to 100 predefined regulatory reports and provided a big variety of the Custom reporting (as a Self-service) by searching filter criteria across Utilization Management Regulatory Reporting for Medical and Behavioral areas, requested by US regulators. Regulatory reports produced by BEAM application have extremely heavy and complex transformation logic and reports were generated in the layouts (with multi tab support) exactly specified by US regulators

Acted as primary contact for scope of works, target dates of deliverables, followed up with customer to verify satisfaction, reported to customer representatives

Provided estimations and planning the works, supervised and supported team members in the offshore

Acted as full stack developer across all technologies on the project as on the Backend side (Teradata, Postgre, Python, Flask, Pandas, Alembic) so and on the Frontend side (Angular, REST API) as well

Contributed into report migration and SQL conversion from Teradata to Databricks transition

Tools and Technologies: Angular, Python, Flask, Pandas, Alembic, Teradata, Databricks, PostGre, Docker, Jenkins

Project #2:

The project implies development and implementation of enterprise-wide Big Data solution for automation and data processing of the Regulatory reporting. The solution is built on top of Enterprise Data Lake using Teradata and Cloudera Hadoop eco-system.

Responsibilities:

Responsible for migration Legal and Compliance reports from legacy system into Legal and Compliance Reports (LCF) application. Legal and Compliance Reports are contained data for All-Payer Claims Databases (APCD - https://www.apcdcouncil.org) of the many participated States such as Colorado, Maryland, Oregon, Utah and others (up to 20 States). The content and format of collected data with set of mandatory APCD reports are legislated by participated States by their own laws and are included the Eligibility, Medical and Pharmacy Claims, Dental, Providers and other Healthcare and Insurance data

Acted as primary contact for scope of works, target dates of deliverables, followed up with customer to verify satisfaction, reported to customer representatives

Provided estimations and planning the works, supervised and supported team members in the offshore

Performed business domain analysis

Analysis requirements and data of legacy compliance reporting

Design and implementation reports migration to LCF application (Teradata, Hive)

Developed ETL pipelines to upload source data into report supporting schemas (Informatica)

Testing and analysis legacy and migrated reports with data quality validations (Python, Spark)

Tools and Technologies: Teradata, Hive, Python, Spark, Informatica

Project #1:

Development work in Pharma IT department on integration and data exchange points between Cigna and Express Scripts

Responsibilities:

Responsible for the implementation and testing of the various functionalities for Datawarehouse databases (Oracle 12c) at Pharma department

Gathering and clarifying requirements

Estimation and planning works

Design and implementation

Providing unit tests and integration tests

Performance tuning

Delivery management

Tools and Technologies: Oracle 12c, Toad for Oracle, Oracle SQL Developer, Informatica 10.1, CAWA Workstation

2018-2018 EPAM Systems, Software Engineering Team Lead

Client: Novartis Business Services (NBS). Cambridge, MA

Project Roles: Senior Data Engineer, Build Engineer

Accomplished the Data Masking project for obfuscating of the Customer sensitive data for usage on Testing and Development environments.

Responsibilities:

Participated in all phases Data Masking processes for Novartis applications - from Onboarding to Final UAT sign-off

Contributed into architecture on-premises and Cloud Data Masking architecture and approaches

Inventory and assessment of current Novartis environments and applications

Technical support of all aspects Informatica TDM; Informatica Cloud TDM

Implementation and validation of Masking Data for applications

Tools and Technologies:

Informatica 10.2.0; Informatica Test Data Management 10.2.0

Informatica Cloud Test Data Management

Informatica Data Validation Option 10.2.0

Salesforce Workbench; PL\SQL Developer; Toad for Oracle

Relational and non-relational databases

Cloud databases

2016-2017 EPAM Systems, Software Engineering Team Lead

Client: Penske Truck Leasing Co Reading, PA

Project Roles: Senior Database Developer, Key Developer

Responsible for architecture, implementation and testing KPI reporting aimed to build the reports on Datawarehouse databases (Oracle 12c/Oracle 11g) with further integration in Fleet Insight product. This project is going to replace existing legacy Customer system and to be in sync and integration with Qlik BI system.

Responsibilities:

gathering and clarifying requirements

providing architecture solutions

estimation and planning works

design and implementation

providing unit tests and integration tests

performance tuning

delivery management

Tools and Technologies:

•Oracle DB/DWH, JSON, Sybase Power Designer, Oracle SQL Developer, Toad for Oracle, PL\SQL Developer, AQT, SAP BO, SAP Data Services, Oracle 12c, Oracle 11g, DB2

2008-2015 EPAM Systems, Lead Database Developer

Client: One Call Medical. Parsippany, NJ

Project Roles: Development Team Lead, Lead Database Developer

Oversaw offshore Database Development Center for Diagnostics (DX) Services in the One Call Care Management.

Delivered a variety of front-end and back-end products which were fully covering Customer's business in the Worker’s Compensation industry: In-house Claims processing products, EDI (X12), Web applications, integration with other systems.

Developed 30+ project functionalities based on Oracle 12c and Oracle 11 (PL/SQL, ETL) regarding all gathering requirements, architecture, design, development and release steps.

Responsibilities:

Coordinated DB Development Team, created, distributed and controlled tasks and assignments

Planned (with WBS creation) and estimated new project initiatives

Architectural design and development of core application for performing day-to-day business processes and web-oriented applications

Closely hands on: databases architecture design; conceptual, logical and physical stages of data modelling; full stack of database development

Contributed to establishment of new projects on the account

Performed integration with external payment system

Investigated production issues

Mentored and trained of the newcomers and juniors on the project

Main projects: Phoenix (core application for performing day-to-day business processes), Interactive Voice Response Framework, Enterprise Web Framework, Network Portal, Customer Center Web Application, Data Web Tools, Enterprise Delivery Framework, Template and Delivery Engine, Business Rule Engine

Tools and Technologies:

Oracle 12c/11.2.0.3, SQL, PL/SQL, Oracle Advanced Queue, XML, JSON, EDI (X12)

Toad for Oracle; PL/SQL Developer, Sybase Power Designer; MS Visual Studio 2010; MS BizTalk Server 2009; Microsoft Team Foundation Server

EDUCATION

Bachelor’s degree in Radio Engineering

Polotsk State University

1992 - 1997

CERTIFICATIONS

AWS Certified Cloud Practitioner

PASSIONS

Innovations

Passionate about learning and enabling new technologies, which evolved and improved the business processes on the projects.

Intensively growing expertise across AWS services: EMR, Glue, SageMaker, Gen AI and ML.

Data management

Enjoy mastering data to produce unique and comprehensive deliverables to Customers

STRENGTHS

Problem-solving mindset

Consistency keeping the focus on identification and resolving data issues

Quick learner and enabler

Able quickly learn new technologies and processes, adapt them on the projects and produce deliverables in short terms

Contact this candidate