About

Mansi Pandya is a Data Engineer at McKinsey & Company, with a Master of Science in Information Systems and a Bachelor's degree in Computer Science. With a passion for innovation and experimentation, Mansi has developed a range of technical skills, including expertise in databases such as MySQL, MS SQL Server/T-SQL, Oracle 11g, and PostgreSQL. She is also experienced in Python programming for data munging, scraping, and feature engineering, as well as in implementing various Machine Learning techniques for data tuning. Mansi has created data pipelines using tools like Alteryx, Talend, and SSIS, and has built interactive dashboards and visuals with Power BI and Tableau to convey data insights. She has also developed multiple projects during her undergraduate period, including Java application, Web application, Android application, and various database projects. As an energized team player with a strong ability to multitask and work under pressure, Mansi differentiates herself by approaching challenges through smart work ethics and a strong problem-solving mindset. She is highly interested in working in an environment where she can challenge herself and build on her skillset. Mansi's technical skills include databases, programming languages such as Python, R, Java, SQL, HTML, and CSS, BI/ETL tools like Talend, SQL Server Integration Services (SSIS), and Alteryx, data visualization tools such as Tableau, Power BI, and Microsoft Excel, and Machine Learning techniques such as Regression, Classification, Decision Trees, Random Forest, KNN, and K-means clustering. She also has experience with Big Data/Cloud technologies like MongoDB, Hadoop, MapReduce, Spark, Hive, Pig, and AWS (RDS, DynamoDB, S3, EC2). Prior to joining McKinsey, Mansi worked as a Software Quality Assurance Analyst at Casa Systems, Inc., where she maintained the data mart for structured and unstructured data, wrote and executed SQL queries to perform back-end testing, and automated functional and system level testing in Python using Selenium WebDriver. She also worked as a Data Analyst at Dev Information Technology Limited, where she designed an Android application's database schema using SQLite, analyzed various records coming from multiple networks, and developed SQL queries to store desired network parameters in the Firebase database. Mansi holds a Master's degree in Information Systems from Northeastern University and a Bachelor of Technology in Computer Engineering from Nirma University.