About

Sonia Thekknedath is a highly skilled Data Analytics Specialist with over 9 years of relevant experience in the field. Currently working as a Senior Data Engineer at McKinsey & Company, she has a strong background in Data Engineering, ETL, Data Warehouse, and SQL. Sonia has previously worked at JP Morgan as an Application Developer, where she developed ETL jobs that supported customization of transactional data for over 250 commercial clients. She led all phases of development projects and allocated tasks, planned production deployments, and coordinated with business and cross-functional teams. She also created system usage reports and automated alerts that improved the client experience while using Cognos. Sonia identified time-consuming tasks and designed shell scripts that reduced the time by 80%. Additionally, she automated several manual activities such as Import/Export of jobs, reducing the production deployment time by 50%. She liaised with clients, gathered requirements, identified problems, and provided solutions to complex and critical problems. Prior to JP Morgan, Sonia worked at TCS as a System Engineer, where she developed 200+ ETL processes and provided production support for the enterprise data warehouse of a global manufacturing organization. She spearheaded a ‘Data Quality’ project that validated data across the various layers of the data warehouse. She trained a team of 10 new recruits in developing ETL processes, reducing the onboarding time by 30%. Sonia introduced a new tool ‘InfoSphere Fastrack’ to the team that aided in documenting data mapping across various layers of the data warehouse, decreasing UAT defect rate by 65%. She optimized complex SQL queries, implemented ‘Change Data Capture’ and converted Type 2 to Type 1 dimensions that reduced the daily data load time by 40%. Sonia created and customized reports and dashboards using Report Studio, Analysis Studio, and Framework Manager (Cognos). Sonia holds a Master of Science (M.S.) in Management Information Systems, General from Carnegie Mellon University and a Bachelor of Engineering (Telecommunication) from CMR Institute of Technology. She is proficient in Data Engineering, ETL, Data Warehouse, SQL, and has a proven track record of delivering high-quality solutions.