About

Shilpa Verma is a highly skilled Senior Data Engineer (Data Delivery Specialist) at McKinsey & Company. With a Master's degree in Computer and Information Systems- Big data management and analysis from Georgia State University, Shilpa is an expert in data engineering, SQL, big data, Python, EVM, Jenkins, test, QA, data scientist, Hadoop, ETL, web, software engineer, and Ruby. She has over 7.95 years of relevant experience in the industry. Shilpa is passionate about helping companies take well-informed and well-analyzed steps to keep growing in a positive manner. She has worked for Ess Analysis as a Data Engineer (Analytics), where she regulated automation using JinjaSQL templates and improved the flexibility and performance of the data acquisition process of the ETL process of the EVM platform by 40%. She also scraped data from hospitality websites using Mozenda agents to give business insight into the various reasons why customers tend to book their trips through OTAs rather than the individual websites. This generated rich data for analysis, thus increasing productivity by 30%. Shilpa led the team in migrating data acquisition code from db2 to pyspark using S3 as the primary database and EC2 instance to run Hadoop clusters, which aided in QA as well as helped speed up the process by 50%. Shilpa has also worked for Atgwork as a Software Developer, where she worked on installing and integrating Ruby on Rails, Jenkins, and GitHub with each other and then developing a secure system that authenticates in OAM(Oracle Access Management). She worked on Oracle Ellucian Banner, which is the world's leading higher education enterprise resource planning (ERP) system. Her tasks included extending web pages and updating web forms, creating key blocks to populate forms with data from tables in the database, working over forms using Oracle form builder, and coding using Java based on MVC architecture. Shilpa is proficient in GitHub to maintain access control and consistency of code with master-staging branch architecture. She primarily worked on data collection and wrangling for the data science team on the CRM Lifecycle project. This includes automated running of Jenkins jobs that run db2 queries, downloading the final dataset, and checking the integrity of data using SAS, thus improving the quality of training as well as test datasets. Overall, Shilpa is a highly skilled and dedicated Senior Data Engineer (Data Delivery Specialist) who is passionate about helping companies grow in a positive