Kunal Kumar

Data Eng, Mgmt & Governance Sr Analyst

Accenture

02.2022 - Current

Developed and enhanced the Service Operations Data System for a leading US based Insurance Domain Client
Created the complex SSIS packages and SQL scripts, ensuring proper control and data flow tasks depending on the Business requirements
Developed a comprehensive system for extracting data from various sources, including text files, CSV files, Excel, SQL Server, Oracle DB, Snowflake, and IBM DB2
Transformed the data through ETL processes and loaded it into the Business Data Warehouse for use by reporting teams and business analysts
Executed troubleshooting and improvements for recurring job failure issues
Participated in the migration of SQL server from 2016 to 2019 from the data ingestion team doing the checks and testing for the smooth execution of SSIS packages and jobs
Worked in a Source system migration to enhance the whole ETL process and performed the data validation, code change, data analysis in case of mismatch
Streamlined long-running jobs and processes, achieving approximately 140 hours of monthly savings
Implemented automation initiatives to streamline manual tasks such as file checks, notifying users of new data availability, deleting backup/test tables, and sending reminders for naming convention violations, resulting in a savings of 90 hours per month for the client
Did individual contribution in projects from initial Business requirement gathering through to deployment including building the ETL, performing unit testing and discussion with Business regarding UAT
Drives Client meetings in absence of Lead and hosts weekly automation meetings
Worked in the migration and development of ADF pipelines to do basic transformations
Excellent in analytical, communication, interpersonal, technical writing and teamwork

Similar Profiles