Data Analyst Senior

Marina Skornyakova

860-***-**** *********@*****.***

www.linkedin.com/in/marinaskornyakova Ashland, MA

Summary:

Senior Data Analyst/ Senior Data Engineer with a proven track record guiding projects through the entire system development life cycle. Proficient in bridging communication gaps between diverse stakeholders, from business partners to IT technical staff. Possesses comprehensive expertise spanning Business and Functional Requirements, Data Ingestion, Data Modeling, and Reporting, ensuring a holistic and seamless approach to project execution.

Advanced Skills:

Business and Functional requirements.

Data Profiling, Data Analysis, Mapping (SQL/PL-SQL), SQL, JavaScript, Stored Procedures.

Data Modeling: Data Vault 2.0 and Vault Speed.

Business Intelligence: Cognos, MicroStrategy, Crystal Reports, Power BI

Data Warehouse/Databases: Snowflake, Teradata, Oracle, SQL Server.

Snowflake Optimization.

ETL: Informatica, Snap Logic.

AWS Cloud: AWS Glue, AWS S3, Athena, Postgres.

Process Mapping and Improvement, System Design, and Systems Improvement.

DevOps: CI/CD, GIT, Eclipse, Bamboo, CTRL-M, Apache Kafka, CloudForge.

Experience:

PNC Bank, remote Aug 2024-current

Consultant Data Analyst

Perform Data Analysis, profiling, ETL, and System Impact Analysis

Liberty Mutual Insurance, Boston, MA Jan 2020-Dec 2023

Senior Data Engineer (Senior Data Analyst)

Designed, developed, tested, and delivered ETL solutions for the Digital Marketing portfolio in alignment with business requirements.

Developed and maintained robust, reusable data pipelines from multiple sources ETL (Extract, Transformation, Load) into Snowflake and Teradata Warehouses. (SQL, AWS, csv, Kafka).

Lead Data Modeling Data Vault Initiatives:

Developed and supported integration services.

Liaised with stakeholders to establish and document implementation requirements, developing use cases and functional specifications.

Conducted thorough data analysis, identified patterns, mapped business processes, and created comprehensive business and system requirements and documentation.

Documented and analyzed derivations, and workflows, required for project solutions. (Inbound /Outbound Vendors).

Innovation: Designed and implemented logical and physical Data Models into Snowflake using Data Vault and Vault Speed.

Created a Power BI Dashboard for analytical needs. (Snowflake, SQL).

Mentored team members in advanced Data Vault Modeling, Vault Speed, and Snowflake optimization techniques.

Developed manual and automated tests covering various scopes, including Unit, System, Integration, and Regression testing.

Travelers Insurance, Hartford, CT Oct 2006-Dec 2019

Associate Software Developer (Senior System Analyst)

Worked on various projects within multiple departments.

Data Exploration (data conformance) initiatives for the Data Lake:

Conducted thorough data profiling, identifying data patterns in various Rating Applications. (BIG Data/Hadoop, SQL, HIVE, Oracle, Teradata, XML).

Created complex Business Rules and Functional Requirements to ensure data conformance.

ETL (Extract, Transform, Load) : (Datawarehouse, Data Mart, Teradata, SQL, Abinitio, XML, XSLT, Legacy).

Gathered comprehensive system requirements, and created Source-to-Target Mapping, and data dictionaries for new Sources.

Performed impact analysis to the Datawarehouse, Data Marts, and downstream systems.

Process Optimization: Developed an application to slash Turn Around Time (TAT) from 3 days to 2 hours for an existing Operational Process. (Validation BOM Releases).

Business Rules Development: ( ILOG Eclipse, XML).

Performed “gap analysis” between current and future state, and developed Insurance Business Workflows Rules.

Defect Fixes: Identified Root Cause, and performed Impact Analysis.

Coordinated Department production Releases.

Legal System: (Reports, Data Conversion, design of new application)

Provided countrywide data/reporting support to over 1,300 users across 35 states through the design, development, and delivery of comprehensive reports and data extracts (SQL, Cognos, ad-hoc reports).

Collaborated with Business Users, and identified Business and Functional requirements.

Designed and Implemented Reports and ad hoc extracts.

Designed and implemented a dynamic intranet website (ASP, DHTL, HTML, VBScript).

Created Business and Functional Rules for Data Conversion between multiple systems.

Contributed to the design and implementation of a new Legal System, serving as the Reporting and Data Subject Matter Expert (SME).

Supported testing activities and post-production transitions, including test plan development and test scripts.

Automated operational process that decreased turnaround time from multiple days to a few hours (KPI metrics).

Designed and implemented self-service analytics (Cognos Reporting Studio).

Provided technical training for business users ranging from basic Excel to advanced programming on multiple applications.

Education :

BS/MS in Physics and Engineering from Moscow Engineering and Physics Institute.

Certifications & Awards:

Presented Data Model at the department's "Architecture Center of Excellence".

(Liberty Mutual Insurance: One of the first adopters of Data Vault 2.0 methodology).

Received Department Award for Litigation System Implementation (Travelers).

Certified Data Modeler Practitioner in Data Vault 2.0 (Data Alliance 2021).

Oracle Certified Developer in "Introduction to SQL and PL/SQL" and "Developing PL/SQL program Units."

Contact this candidate