Nitin J.
Sr Data Engineer - Lead at SEVENROOMS- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Hindi Native or bilingual proficiency
Topline Score
Bio
Vaishnavi E
I have known Nitin for more than a year now, in this timeframe I saw him not only as a hard worker but also a very good contributor to the team, he demonstrates not only mastery at the core skills but also goes beyond to take new initiatives, which could be critical to the project/organization. He has the mix of both productivity and ambition set, thereby setting a good example to the team and that is why everyone loves working with Nitin. I highly recommend Nitin for his Capabilities, Abilities and Strong passion for technologies.
Jose Castillo
Nitin is an incredibly sharp, passionate, and dedicated teammate. I had the pleasure of working with him as a student and research assistant for more than one year at Florida International University. He is very focused and has the fortitude to overcome obstacles on any initiative set out. His desire to constantly improve awarded him for designing the optimal predictive model to get the highest profit on a campaign. I hope to get the chance to work with him again.
Gerald Inberg, PMP, CSM
Nitin Jain worked on the Informed Traveler Program and Applications (ITPA) project as a research assistant since the spring of 2015. During his time with me, Nitin worked on the ITPA core, developing features using Java and Python and in the front end work on the Smart Phone and Operations Center working in HTML5, CSS, and JavaScript. We do our development work as an agile scrum team and he works very well with the team in this mode, jumping in where he can help, contributing his ideas, and promoting team values. He is always willing to take on new challenges and has now jumped in to work on an embedded device on transit vehicles gathering data for ITPA. In summary, Nitin is friendly, enthusiastic, and provides good quality code. He would be an asset to any team.
Vaishnavi E
I have known Nitin for more than a year now, in this timeframe I saw him not only as a hard worker but also a very good contributor to the team, he demonstrates not only mastery at the core skills but also goes beyond to take new initiatives, which could be critical to the project/organization. He has the mix of both productivity and ambition set, thereby setting a good example to the team and that is why everyone loves working with Nitin. I highly recommend Nitin for his Capabilities, Abilities and Strong passion for technologies.
Jose Castillo
Nitin is an incredibly sharp, passionate, and dedicated teammate. I had the pleasure of working with him as a student and research assistant for more than one year at Florida International University. He is very focused and has the fortitude to overcome obstacles on any initiative set out. His desire to constantly improve awarded him for designing the optimal predictive model to get the highest profit on a campaign. I hope to get the chance to work with him again.
Gerald Inberg, PMP, CSM
Nitin Jain worked on the Informed Traveler Program and Applications (ITPA) project as a research assistant since the spring of 2015. During his time with me, Nitin worked on the ITPA core, developing features using Java and Python and in the front end work on the Smart Phone and Operations Center working in HTML5, CSS, and JavaScript. We do our development work as an agile scrum team and he works very well with the team in this mode, jumping in where he can help, contributing his ideas, and promoting team values. He is always willing to take on new challenges and has now jumped in to work on an embedded device on transit vehicles gathering data for ITPA. In summary, Nitin is friendly, enthusiastic, and provides good quality code. He would be an asset to any team.
Vaishnavi E
I have known Nitin for more than a year now, in this timeframe I saw him not only as a hard worker but also a very good contributor to the team, he demonstrates not only mastery at the core skills but also goes beyond to take new initiatives, which could be critical to the project/organization. He has the mix of both productivity and ambition set, thereby setting a good example to the team and that is why everyone loves working with Nitin. I highly recommend Nitin for his Capabilities, Abilities and Strong passion for technologies.
Jose Castillo
Nitin is an incredibly sharp, passionate, and dedicated teammate. I had the pleasure of working with him as a student and research assistant for more than one year at Florida International University. He is very focused and has the fortitude to overcome obstacles on any initiative set out. His desire to constantly improve awarded him for designing the optimal predictive model to get the highest profit on a campaign. I hope to get the chance to work with him again.
Gerald Inberg, PMP, CSM
Nitin Jain worked on the Informed Traveler Program and Applications (ITPA) project as a research assistant since the spring of 2015. During his time with me, Nitin worked on the ITPA core, developing features using Java and Python and in the front end work on the Smart Phone and Operations Center working in HTML5, CSS, and JavaScript. We do our development work as an agile scrum team and he works very well with the team in this mode, jumping in where he can help, contributing his ideas, and promoting team values. He is always willing to take on new challenges and has now jumped in to work on an embedded device on transit vehicles gathering data for ITPA. In summary, Nitin is friendly, enthusiastic, and provides good quality code. He would be an asset to any team.
Vaishnavi E
I have known Nitin for more than a year now, in this timeframe I saw him not only as a hard worker but also a very good contributor to the team, he demonstrates not only mastery at the core skills but also goes beyond to take new initiatives, which could be critical to the project/organization. He has the mix of both productivity and ambition set, thereby setting a good example to the team and that is why everyone loves working with Nitin. I highly recommend Nitin for his Capabilities, Abilities and Strong passion for technologies.
Jose Castillo
Nitin is an incredibly sharp, passionate, and dedicated teammate. I had the pleasure of working with him as a student and research assistant for more than one year at Florida International University. He is very focused and has the fortitude to overcome obstacles on any initiative set out. His desire to constantly improve awarded him for designing the optimal predictive model to get the highest profit on a campaign. I hope to get the chance to work with him again.
Gerald Inberg, PMP, CSM
Nitin Jain worked on the Informed Traveler Program and Applications (ITPA) project as a research assistant since the spring of 2015. During his time with me, Nitin worked on the ITPA core, developing features using Java and Python and in the front end work on the Smart Phone and Operations Center working in HTML5, CSS, and JavaScript. We do our development work as an agile scrum team and he works very well with the team in this mode, jumping in where he can help, contributing his ideas, and promoting team values. He is always willing to take on new challenges and has now jumped in to work on an embedded device on transit vehicles gathering data for ITPA. In summary, Nitin is friendly, enthusiastic, and provides good quality code. He would be an asset to any team.
Credentials
-
Data Visualization and Communication with Tableau
Coursera Course CertificatesJul, 2016- Sep, 2024 -
Python Data Structures
Coursera Course CertificatesJul, 2016- Sep, 2024 -
Gaming- Basics of Gaming Industry
Infosys -
Overview of ES Technologies
Infosys
Experience
-
SEVENROOMS
-
United States
-
Hospitality
-
200 - 300 Employee
-
Sr Data Engineer - Lead
-
Aug 2022 - Present
-
-
-
AppFolio, Inc.
-
United States
-
Software Development
-
700 & Above Employee
-
Sr Data engineer - Tech lead
-
Sep 2021 - Sep 2022
- Up to Real-time processing of data for our prod data and business services using streaming services(k8s, kafka, debezium). - Transformed our legacy and current system into a IaaC using terraform and configuration management using Ansible and Helm chart. - Implemented batch processing pipeline for product and business services using apache airflow with datadog, slack integration. - Data lake formation, architected the data lake, and onboarding different business units onto the data… Show more - Up to Real-time processing of data for our prod data and business services using streaming services(k8s, kafka, debezium). - Transformed our legacy and current system into a IaaC using terraform and configuration management using Ansible and Helm chart. - Implemented batch processing pipeline for product and business services using apache airflow with datadog, slack integration. - Data lake formation, architected the data lake, and onboarding different business units onto the data lake. - Snowflake usage cost was reduced by about 50%. Optimized queries, implemented best practices on the snowflake. - Security: Implemented and enforced RBAC: Role-based access control on the snowflake. - Data sharing, created an infrastructure to share, monitor data with companies' customers.
-
-
Senior Data Engineer
-
Jan 2020 - Sep 2022
- Data lake formation, architected the data lake, and onboarding different business units onto the data lake. - ELT for 16K databases on a regular and real-time basis onto snowflake using Ruby, Python, Airflow, and shell script. - Snowflake usage cost reduced by about 50%. Optimized queries, implemented best practices on the snowflake. - Security: Implemented and enforced RBAC: Role-based access control on the snowflake. - Helped create cloud resources for Data science users… Show more - Data lake formation, architected the data lake, and onboarding different business units onto the data lake. - ELT for 16K databases on a regular and real-time basis onto snowflake using Ruby, Python, Airflow, and shell script. - Snowflake usage cost reduced by about 50%. Optimized queries, implemented best practices on the snowflake. - Security: Implemented and enforced RBAC: Role-based access control on the snowflake. - Helped create cloud resources for Data science users using EC2, Data bricks, and colab. - Data sharing, created an infrastructure to share, monitor data with companies' customers.
-
-
-
MINDBODY, Inc.
-
United States
-
Hospitals and Health Care
-
Data Warehouse Engineer II
-
Nov 2017 - Jan 2020
• AWS: Worked on writing Lambda function, creating VPC's Cloud formation template, DynamoDB, RDS, IAM, Data pipeline and Redshift clusters. • Architect/Design ETL to merge 100,000 Databases into Central Database in AWS RedShift cluster by using Py, SSIS and Shell Scripting. • QA : Python to write complex ETL script and analytical function to perform QA and Testing AWS RedShift Database. • API Integration from different data sources( SalesForce, Internal MB API, Stripe)… Show more • AWS: Worked on writing Lambda function, creating VPC's Cloud formation template, DynamoDB, RDS, IAM, Data pipeline and Redshift clusters. • Architect/Design ETL to merge 100,000 Databases into Central Database in AWS RedShift cluster by using Py, SSIS and Shell Scripting. • QA : Python to write complex ETL script and analytical function to perform QA and Testing AWS RedShift Database. • API Integration from different data sources( SalesForce, Internal MB API, Stripe) with millions of data loaded daily. • Data Analysis: write complex Advanced SQL queries to perform Data analytics and hand over to end user. • Data Modeling: Dimensional modeling and 3NF on Databases for better performances of central databases and Reporting(Tableau) Show less • AWS: Worked on writing Lambda function, creating VPC's Cloud formation template, DynamoDB, RDS, IAM, Data pipeline and Redshift clusters. • Architect/Design ETL to merge 100,000 Databases into Central Database in AWS RedShift cluster by using Py, SSIS and Shell Scripting. • QA : Python to write complex ETL script and analytical function to perform QA and Testing AWS RedShift Database. • API Integration from different data sources( SalesForce, Internal MB API, Stripe)… Show more • AWS: Worked on writing Lambda function, creating VPC's Cloud formation template, DynamoDB, RDS, IAM, Data pipeline and Redshift clusters. • Architect/Design ETL to merge 100,000 Databases into Central Database in AWS RedShift cluster by using Py, SSIS and Shell Scripting. • QA : Python to write complex ETL script and analytical function to perform QA and Testing AWS RedShift Database. • API Integration from different data sources( SalesForce, Internal MB API, Stripe) with millions of data loaded daily. • Data Analysis: write complex Advanced SQL queries to perform Data analytics and hand over to end user. • Data Modeling: Dimensional modeling and 3NF on Databases for better performances of central databases and Reporting(Tableau) Show less
-
-
-
Infosys
-
India
-
IT System Custom Software Development
-
1 - 100 Employee
-
Technology Analyst
-
Aug 2016 - Nov 2017
•ETL (Oracle): Automated 80% of ETL code from scratch using PL/SQL. Design and Transforming Data from Legacy system into the Landing-Staging-Target. (Data Marts, Oracle PL/SQL) • Requirement Gathering and reporting for LOB on daily basis. - (BRD, Data Lineage, conceptual, Logical, physical model and creating interactive ad-hoc Tableau report) • Data modeling: Designing Conceptual, Logical and Physical Model on Mortgage Foreclosure domain (Power Designer). • Data Lineage (Legacy),… Show more •ETL (Oracle): Automated 80% of ETL code from scratch using PL/SQL. Design and Transforming Data from Legacy system into the Landing-Staging-Target. (Data Marts, Oracle PL/SQL) • Requirement Gathering and reporting for LOB on daily basis. - (BRD, Data Lineage, conceptual, Logical, physical model and creating interactive ad-hoc Tableau report) • Data modeling: Designing Conceptual, Logical and Physical Model on Mortgage Foreclosure domain (Power Designer). • Data Lineage (Legacy), Gap analysis (Landing-Staging-Target) and Source target mapping (Transformation Logic). • ETL using DataStage from Different Data sources(SQL Server, Flat Files, Oracle, WebAPI) to Oracle 11g and 12c Show less •ETL (Oracle): Automated 80% of ETL code from scratch using PL/SQL. Design and Transforming Data from Legacy system into the Landing-Staging-Target. (Data Marts, Oracle PL/SQL) • Requirement Gathering and reporting for LOB on daily basis. - (BRD, Data Lineage, conceptual, Logical, physical model and creating interactive ad-hoc Tableau report) • Data modeling: Designing Conceptual, Logical and Physical Model on Mortgage Foreclosure domain (Power Designer). • Data Lineage (Legacy),… Show more •ETL (Oracle): Automated 80% of ETL code from scratch using PL/SQL. Design and Transforming Data from Legacy system into the Landing-Staging-Target. (Data Marts, Oracle PL/SQL) • Requirement Gathering and reporting for LOB on daily basis. - (BRD, Data Lineage, conceptual, Logical, physical model and creating interactive ad-hoc Tableau report) • Data modeling: Designing Conceptual, Logical and Physical Model on Mortgage Foreclosure domain (Power Designer). • Data Lineage (Legacy), Gap analysis (Landing-Staging-Target) and Source target mapping (Transformation Logic). • ETL using DataStage from Different Data sources(SQL Server, Flat Files, Oracle, WebAPI) to Oracle 11g and 12c Show less
-
-
-
Florida International University
-
United States
-
Higher Education
-
700 & Above Employee
-
Research Analyst
-
Apr 2015 - Apr 2016
• Contributed and analyzed all the business requirements for this project and managed a funding for $11m approx. as a team. • Bus arrival and Parking space optimization - Created dashboard for Notification, ETA & Parking garage occupancy to monitor real-time status, Implemented predictive algorithm for real-time Bus arrival & Parking space (Python) and Reduced API response time for bus location service by 85% via state memory caching SQL query optimization. • Designed & built… Show more • Contributed and analyzed all the business requirements for this project and managed a funding for $11m approx. as a team. • Bus arrival and Parking space optimization - Created dashboard for Notification, ETA & Parking garage occupancy to monitor real-time status, Implemented predictive algorithm for real-time Bus arrival & Parking space (Python) and Reduced API response time for bus location service by 85% via state memory caching SQL query optimization. • Designed & built Database (RDBMS in MySQL), Backend Services (Python, SQL), RESTful API(Spring) • Developed mobile app for notification services in real time (JQuery, HTML5, CSS, JS) Show less • Contributed and analyzed all the business requirements for this project and managed a funding for $11m approx. as a team. • Bus arrival and Parking space optimization - Created dashboard for Notification, ETA & Parking garage occupancy to monitor real-time status, Implemented predictive algorithm for real-time Bus arrival & Parking space (Python) and Reduced API response time for bus location service by 85% via state memory caching SQL query optimization. • Designed & built… Show more • Contributed and analyzed all the business requirements for this project and managed a funding for $11m approx. as a team. • Bus arrival and Parking space optimization - Created dashboard for Notification, ETA & Parking garage occupancy to monitor real-time status, Implemented predictive algorithm for real-time Bus arrival & Parking space (Python) and Reduced API response time for bus location service by 85% via state memory caching SQL query optimization. • Designed & built Database (RDBMS in MySQL), Backend Services (Python, SQL), RESTful API(Spring) • Developed mobile app for notification services in real time (JQuery, HTML5, CSS, JS) Show less
-
-
-
-
System Engineer ( Business Data Analyst)
-
Jun 2011 - Dec 2014
• Worked on requirements gathering, integration and migration projects for Oracle 11i to R12 for AR, AP and GL modules. • Developed Reports in PO, Financials and Inventory (Delivery Slip Report, PO Report, Custom PO delivery slip report). • RICE / Oracle Alerts / Register custom applications / Created concurrent programs / Define responsibilities / users. • Data warehouse implementation for Wealth Management Company SSIS, SSMS, SSAS, SSRS and Tableau. • Develop code and unit test… Show more • Worked on requirements gathering, integration and migration projects for Oracle 11i to R12 for AR, AP and GL modules. • Developed Reports in PO, Financials and Inventory (Delivery Slip Report, PO Report, Custom PO delivery slip report). • RICE / Oracle Alerts / Register custom applications / Created concurrent programs / Define responsibilities / users. • Data warehouse implementation for Wealth Management Company SSIS, SSMS, SSAS, SSRS and Tableau. • Develop code and unit test scripts for implementing new business modules or enhancing existing modules in the application. • Help on Code Deployment, Testing, Quality assurance,Code Review and Defects fixed Show less • Worked on requirements gathering, integration and migration projects for Oracle 11i to R12 for AR, AP and GL modules. • Developed Reports in PO, Financials and Inventory (Delivery Slip Report, PO Report, Custom PO delivery slip report). • RICE / Oracle Alerts / Register custom applications / Created concurrent programs / Define responsibilities / users. • Data warehouse implementation for Wealth Management Company SSIS, SSMS, SSAS, SSRS and Tableau. • Develop code and unit test… Show more • Worked on requirements gathering, integration and migration projects for Oracle 11i to R12 for AR, AP and GL modules. • Developed Reports in PO, Financials and Inventory (Delivery Slip Report, PO Report, Custom PO delivery slip report). • RICE / Oracle Alerts / Register custom applications / Created concurrent programs / Define responsibilities / users. • Data warehouse implementation for Wealth Management Company SSIS, SSMS, SSAS, SSRS and Tableau. • Develop code and unit test scripts for implementing new business modules or enhancing existing modules in the application. • Help on Code Deployment, Testing, Quality assurance,Code Review and Defects fixed Show less
-
-
Education
-
2021 - 2021
Udacity
Data streaming -
2017 - 2018
Udacity
Nano degree, Data Modeling/Warehousing and Database Administration -
2015 - 2016
Florida International University
Master's Degree, Management Information Systems and Services -
2007 - 2011
Narsee Monjee Institute of Management Studies
Bachelor's Degree, Computer Science
