Senior Data Engineer Senior Data Analyst

Versatile IT/ Business Professional with a proven track record in 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.

Advance Technical Skills:

Data Modeling: Data Vault 2.0 and Vault Speed.

Business Intelligence: Cognos, MicroStrategy, Crystal Reports .

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

Snowflake Optimization.

ETL: Informatica, Snap Logic.

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

Process Mapping and Improvement, System Design and Systems Improvement.

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

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

Areas of Expertise:

System Development Life Cycle (SDLC) Management Business Requirements Functional Requirements Data Ingestion Data Modeling System Improvement Reporting Problem Solving Analytical Skillset Team Player Agile Jira

Experience:

Liberty Mutual Insurance, Boston, MA January 2020-December 2023

Senior Data Engineer Senior Data Analyst

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

Lead Data Modeling Data Vault Initiatives:

Collaborated with stakeholders across business, technical, and data science units to establish business requirements.

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

Designed and implemented intricate Data Models for Raw Vault and Business Vault .(Vault Speed, Snowflake, Control M,CI/CD, Bamboo, GIT, Views, JavaScript ETL stored procedures, Agile, SQL).

Improved time to market delivery from 3 months to 3 weeks by creating re-usable data pipeline from Raw to Model Layer to Standard Layer.

Achieved Snowflake optimization, reducing processing time for Model to Standard Layers from 5 hours to 40 minutes. (Snowflake, SQL, Stored procedures, clustering).

Provided mentorship to team members on Data Vault Modeling, Vault Speed, and Snowflake optimization techniques.

Performed data ingestion by collecting and integrating data from various sources, and loaded it into both Snowflake and Teradata Warehouses. (Kafka, Snowpipe, Hydrofoil, Informatica, Snap Logic,SQL, AWS S3, AWS Glue, Athena, Unify, CI/CD, GIT, Eclipse, Postgres database).

Created Dashboard for Data Visualization (Power BI).

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

Generated technical documentation encompassing technical requirements, runbooks, and a wiki.

Performed Production support.

Travelers Insurance, Hartford, CT October 2006- December 2019

Associate Software Developer November 2018- December 2019

Worked on Data Exploration (data conformance) initiatives in the Data Lake for various Rating applications, handling both unstructured and structured data. (BIG Data/Hadoop, SQL, HIVE, Oracle, Teradata, XML).

Conducted thorough data profiling, identifying data patterns from Rating Applications.

Created complex Business Rules and Functional Requirements for data conformance.

Associate Software Developer March 2016- November 2018

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

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

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

Created application to reduce TAT (Turn Around Time) from 3 days to 2 hours (Validation BOM Releases).

Additional Travelers Experience :

Associate Software Developer (Personal Lines ) September 2014 - March 2016

Developed and implemented Business Workflows Rules ILOG (Eclipse, XML).

Information Delivery Consultant (Legal Department ) October 2006 -June 2014

Worked on Litigation System Implementation, Report Development and ad-hoc support (Cognos, Data Conversion, UAT testing,intranet websites, SME on data and Reporting. )

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 : One of the first adopters for 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