| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Ashland, MA PHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLE SUMMARY:Senior Data Analyst Senior Data Engineer Business Professional 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 requirements and Functional requirements. Data Profiling, Data Analysis, Mapping,(SQL/PL-SQL), SQL, JavaScript, Stored Procedures, MS Excel. Data Modeling: Data Vault 2.0 and Vault Speed. Business Intelligence: Cognos, MicroStrategy, Crystal Reports, Power BI. Process Analysis, Mapping, and Process Improvements. Data Warehouse/Databases: Snowflake, Teradata, Oracle, SQL Server, AWS, Athena, PostgreSQL ETL(Extract, Transform, Load): Informatica, Snap Logic. PROFESSIONAL EXPERIENCE:LIBERTY MUTUAL INSURANCE Boston, MASenior Data Engineer (Senior Data Analyst) 2020-2023 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, JSON, B2B, SLIM, Snap Logic, Informatica, Apache Kafka).Led Data Modeling Data Vault Initiatives: Collaborated with stakeholders across business, technical, and data science units to establish business/functional requirements. Conducted thorough data analysis, identified patterns, mapped business processes, and created comprehensive system requirements and documentation. Innovation: Designed and implemented Data Models into Snowflake using Data Vault and Vault Speed. Created a Power BI Dashboard for analytical needs. (Snowflake). Mentored team members in advanced Data Vault Modeling, Vault Speed, and Snowflake optimization techniques.TRAVELERS INSURANCE Hartford, CTAssociate Software Developer (Senior System Analyst) 2006-2019 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, XML, XSLT, Legacy). Translated Business requirements into 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 and UAT testing. Coordinated Releases.Legal System Development and Support: (Cognos Reports, SQL, process automation, SME on application, data reporting, system design) Provided countrywide data/reporting support to a population of over 1,300 users within 35 states.(Identified Business /System requirements, created Cognos Reports, ad-hocs, and data extracts. Identified gaps in business processes through process/data analysis. Automated operational process that decreased turnaround time from multiple days to a few hours( KPI metrics). Worked on the design/development/implementation of a new litigation management application as a Data/Reporting SME. (Data Conversion & Reporting streams). Developed a dynamic intranet website (ASP, HTML, DHTL, CSS). EDUCATION: BS/MS in Physics and Engineering from Moscow Engineering and Physics Institute. CERTIFICATIONS AND 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." |
