Vinil. K.

About Vinil. K.

10+ Years of experience in ETL DW BI developer with a solid understanding of Data development, Data Warehousing, Data Integration, ETL/ELT methodologies and expertise in Requirements Analysis, Architecture, Design, Development, Testing, End to End Implementation, Framework, User Training, and production support aspects with a strong background in Insurance and Financial domains.Experience in Analysis, designing, development and Testing various data warehousing projects and BI applications.Expertise in the areas of Business Analysis Data Modeling, Data Cleansing, Data Quality, Data Conversions and ETL Development using methodologies including Waterfall and Agile.Experience in BI and ETL tools like Informatica BDM, Informatica PowerCenter, SQL Server Integration Services.Proven ability in making systems better through re-architecture, framework, code cleanup, performance tune, redesign, application tuning, and debugging strategies.Worked in the capacity of Technical Architect and provided guidance on Reusability, Restart-ability, Change Data Capture, automating the process of parameterization across different environments, design audit control process to track the run time statistics and maintain run history of various jobs and perform Performance Tuning of sub-optimal jobs.Extensive reporting in SQL Server Reporting Services, Crystal Reports and Power BI reports/DashboardsExperience of end to end ETL design, framework, development, requirements gathering, Data Mapping, Transformation and Loading in a complex, high-volume environment.Profound expertise of implementation of Enterprise Data Warehouse (EDW)/Operational Data Store (ODS) modeling concepts including OLTP/OLAP, Dimension/Fact tables, Top-down/Bottom-up models, Star/Snowflake schemas.

Experience

1. Senior Etl Power Bi Developer

   Tractor Supply Company

   Jan 2021 — Present · Brentwood, TN, US

   Project: Tractor Supply Co. is a well-known retail company based in the United States, with a significant presence in Tennessee. As a Senior ETL (Extract, Transform, and Load) Developer at Tractor Supply Co, My primary responsibilities likely include designing, developing, and maintaining ETL processes and workflows. These processes are crucial for efficiently extracting data from various sources, transforming it into a usable format, and loading it into data warehouses and databases. Involved in the development of an ETL engine which self-services all analytical needs around populations at different grains that include Policy, claims, Member (Party/ies), Agent, Places, and Groups. Underlying model was designed in Snowflake schema model with facts for each grain and the facts are surrounded by existing conformed objects in the data warehouse. Involved in the migration of current and entire DB2 legacy application systems to in house architecture Enterprise Data Warehouse. Automated data pipelines, to pull data from all TSC application sources, prep it via ETL process, and immediately begin analyzing it. End to End Data warehousing. Extensively worked on Facts and Slowly Changing Dimension (SCD) tables. My expertise in BI reporting helped my client to advance in reporting for many business questions and KPI’s.(Retention rate of the agents who writes policies for Illinois mutual) Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance. And creating End to End streamlined, efficient workflows that allow my client to enhance new user experience Resolved on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.