Sailesh Kumar JS

Industry: Insurance

• Developed SQL queries to perform Extract, Transform, and Load (ETL) operations, efficiently processing large volumes of data on a daily basis.
• Utilized GitLab to effectively store and manage SQL queries and database schema files, ensuring organized version control, and easy accessibility.
• Orchestrated ELT operations using VS Code and GitLab, managing data transformation, push/pull activities, and executing CI/CD pipelines to ensure the integration and deployment of changes, culminating in efficient merge request management.
• Administered AWS data storage through Unity Catalog, conducted code transformations and validations using notebooks, using SQL, and leveraged clusters for efficient data monitoring.
• Engineered multiple DAGs to streamline job management and data-loading processes. Managed job monitoring with meticulous scheduling, leveraging DAGs to efficiently load market data daily, using both truncate-and-load and incremental table methodologies.
• Conducted data analysis to promptly identify and resolve issues, or when establishing new tables/datasets, ensuring seamless and precise data operations.
• Employed Power BI to create and develop interactive dashboards and data visualizations, providing actionable insights to improve business decision-making and data-driven strategies. Utilized data transformation, Power Query, relationship management, and online streaming features within the Power BI Workspace.
• Created reports from the ground up using the report builder, utilizing SQL Server Reporting Services (SSRS) to design, deploy, and manage comprehensive, interactive reporting solutions, enhancing data-driven decision-making.
• Applied SQL Server Management Studio (SSMS) to conduct advanced data checks and perform crucial operations, maintaining data accuracy and integrity.
• Performed unit and regression testing on data analysis and development tasks, ensuring the accuracy and reliability of data solutions.
• Leveraged JIRA for efficient issue tracking and management, ensuring the timely delivery of tasks and features.
• Proactively engage in client calls to gather project requirements, provide updates, and manage expectations using AGILE methodologies and SCRUM practices. Participate in User Acceptance Testing (UAT) to validate deliverables, gather feedback, and ensure solutions align with the client.