Jayanta Paul
About Jayanta Paul
Jayanta Paul is a Sr. Oracle Developer, Application DBA, and Data Engineer at Ally, with extensive experience in database management, data engineering, and data visualization.
Current Position at Ally
Jayanta Paul is currently employed at Ally as a Sr. Oracle Developer, Application DBA, and Data Engineer. He began this role in 2018, where he utilizes his extensive experience in database management and development to support the company's data infrastructure. His responsibilities include developing data migration processes, implementing data masking solutions, and monitoring database performance to ensure optimal system efficiency.
Previous Work Experience
Prior to his current position, Jayanta Paul accrued significant experience working at various high-profile companies. He served as a Senior Oracle Developer at Thomson Reuters from 2016 to 2018 in Denver, Colorado. Before that, he held a similar role at Wells Fargo in Fremont, California for seven months in 2016. Notably, Jayanta worked at Google from 2014 to 2016 in Mountain View, California, and at Oracle India from 2012 to 2014. He started his career at IBM, where he was a Senior System Engineer for seven years from 2005 to 2012.
Educational Background
Jayanta Paul holds a Master of Computer Applications (MCA) degree from IIEST, Shibpur, where he majored in Computer Science. He also earned a Bachelor of Science (BS) in Mathematics from the University of Calcutta. Additionally, he completed his high school education at Salt Lake School. His academic background laid a strong foundation for his career in technology and database management.
Technical Skills and Expertise
Jayanta Paul is proficient in developing data migration processes using PL/SQL. He has expertise in handling and processing JSON data within Oracle tables and has developed REST API calls to streamline data operations. Jayanta has implemented data masking solutions using Delphix and automated database jobs with Control-M, enhancing the operational efficiency of the organizations he has worked for. He is also skilled in data visualization using Power BI and has performed data lineage analysis using IBM Infosphere.
Database Engineering Projects
Throughout his career, Jayanta Paul has undertaken several significant projects. He has engineered data ingestion pipelines from an in-house Financial Data Warehouse to AWS S3 and Snowflake. Using tools like Qlik Replicate and Snowflake Tasks & Streams, he has optimized data processing. Additionally, he has monitored database performance using Oracle AWR, OEM, and RESOURCE_MANAGER, contributing to the stability and efficiency of database systems.