Shweta Shrivastava's Email Addresses & Phone Numbers

Software Engineer @ Google Greater New York City AreaSoftware Engineer @ Bloomberg LP Team Data Snapshot - Software InfrastructureData and Analytics Platform @Bloomberg From June 2017 to April 2019 (1 year 11 months) Greater New York City AreaTechnology Analyst @ Goldman Sachs Securities Division Data Services Team As part of the core Database team at the firm,...

Software Engineer @ Google Greater New York City AreaSoftware Engineer @ Bloomberg LP Team Data Snapshot - Software InfrastructureData and Analytics Platform @Bloomberg From June 2017 to April 2019 (1 year 11 months) Greater New York City AreaTechnology Analyst @ Goldman Sachs Securities Division Data Services Team As part of the core Database team at the firm, my work revolved around designing systems which help capture, cleanse, enrich and transform critical data that impact everyday business of the firm. The goal was to look at the latest trends and technologies in the world of Big Data to design better and faster systems. My most recent project at Goldman was modelling Bloomberg data using Apache Spark to help revamp the existing Hadoop systems and infrastructure to Spark to leverage data enriching through Scala and DataFrames. Some components of my work were as follows - • Big Data - Worked on building a Hadoop infrastructure for consolidating the firm’s trading data into a single source. Performed complex modelling and enriching of data from disparate sources using technologies such as Apache Pig and Hive, enabling downstream users to perform efficient data mining.• Visualization - Built a Dashboard UI using Python-Django framework and AngularJS that enhanced the efficiency of the team by presenting a simple UI to complicated and redundant backend tasks. Product went on to become critical in the team technology stack and found its usage in cross-platform teams and wider Business Units. From June 2014 to May 2016 (2 years) Bengaluru Area, IndiaSummer Intern @ Goldman Sachs Performance Comparison and Analysis of DB2 and Sybase IQ Databases with respect to the firm's reporting query patterns.DB2 is a row-based database whereas SybaseIQ is a a column-based database. The project required a very fundamental understanding of the storage and retrieval patterns of databases and making an analysis as to which would perform better for which kind of queries. Key phases of the project as follows -1. Migration of the relevant tables from DB2 to Sybase IQ.2. Recreating indexes after identifying the best ones based on the understanding of the workings of a columnar database.3. Exporting the data of past 10 years from the DB2 tables and reloading them to the new IQ tables. This exporting and loading was done using both traditional export and load commands of DB2 and IQ respectively as well as using the ETL tool Informatica. A detailed comparison of statistics was made for the time taken in each case.4. Performing write operations on both the databases to check which sort of operations(UPDATE, DELETE, INSERT) work how well. The analysis was done after studying the row and columnar database theory in detail to jot down the expected results. Then, the statistics, each collected by taking the average of a minimum of three runs per query, were collected to verify the theoretical results.5. Some of the firms highly critical and useful reporting queries were picked up and run against both the DBs to collect the read statistics. 6. Detailed analysis and verification via results was done for every single SQL clause being used within the reporting queries. For exampele - a "JOIN" works better in which case, a filter or "WHERE" performs better in which case, where are Range searches more effective, which produces faster results for a "SELECT *" operation, etc. From June 2013 to July 2013 (2 months) Bengaluru Area, IndiaResearch Intern @ Indian Academy of Sciences Fellowship - University of Hyderabad Enhancing Seam Carving Approaches for Image Resizing and Applications to Image Segmentation From May 2012 to July 2012 (3 months) Hyderabad Area, India