Prakash Tiwari

• Have created batch processing data pipelines to load data from S3 and Sftp to Data lake for different file types including CSV, TXT, JSON, Parquet, etc. • Created different python wrappers and scripts to help monitor the data loads and create the logs. • Worked on POC to increase the computation power of the existing system. Analyzed and implemented different approaches to provide fast computation in data load. • Designed and Implemented Python and SQL scripts to load data as per given business rules across the different Redshift clusters. • Have handled and stabilized operations, break fixes and data load activities.

• Member of pgRouting and FOSSASIA organization in GitHub. • Implemented functionalities for pgRouting. • Opened Issues and Solve them, Approved pull requests and Merged many pull requests in pgRouting.

• Proficient in writing and executing SQL Queries as a part of commercial datawarehouse development using tools like AWS Redshift, RDS. • Created DCR Process design for selecting the unconfirmed records from different data sources and unloading into S3 location. • Designed L1, L2 , L3 configurations for data loads into RedShift along with designed unit tests for them.

• Worked in the project pgRouting under Open Source Geospatial Foundation. • Implemented Lengauer Tarjan Dominator Tree And Bipartite graph for pgRouting. • Written 2K+ LOC in C/C++, 200+ unit tests and completed the user doc. • Founded bug on Two Graphs Common Spanning Trees of boost library, the algorithm was not giving the expected results.