About Me
Know Me More
I'm Nitin Jain, a Data Engineer
As a seasoned data engineer, I bring a wealth of expertise and accomplishments to the table. My proficiency lies in crafting and executing intricate data pipelines, ensuring seamless data flow across diverse sources and destinations. With a keen eye for detail and a penchant for problem-solving.
I meticulously design data models and manage databases, optimizing performance and scalability. My fluency in Big Data technologies like Hadoop, Spark, and Kafka empowers me to tackle large-scale data challenges with finesse.
- Name:Nitin Jain
- Email:nitinj025@gmail.com
- Years of experience:12
- From:New York
12+
Years Experiance
250+
Happy Clients
650+
Projects Done
38
Get Awards
Services
What I Do?
Data Engineering
With a strong foundation in data modeling, ETL processes, and scalable infrastructure deployment, I consistently deliver robust solutions that drive data-driven decision-making.
SQL
Proficient in SQL, I adeptly design and optimize database queries, ensuring efficient data retrieval and manipulation to support informed decision-making processes.
Python
With a comprehensive grasp of Python, I skillfully develop scalable solutions, leveraging its versatility and rich ecosystem to tackle diverse challenges in data engineering and beyond.
AI/ML
With a proven track record of implementing AI/ML solutions in impactful projects, I leverage advanced algorithms and data-driven insights to tackle complex problems, driving innovation and delivering value.
Terraform
Proficient in Terraform, I've successfully orchestrated infrastructure at scale in challenging projects, demonstrating expertise in automating deployment and managing cloud resources efficiently to solve critical problems.
Shell
Mastering shell scripting, I've spearheaded critical projects, adeptly automating tasks and solving complex problems with efficiency and precision in diverse computing environments.
Data modeling
Proficient in Data Modeling, I excel in designing robust data architectures that power insightful analytics and drive informed decision-making across diverse projects.
Cloud engineer
Adept in cloud engineering, I leverage advanced technologies to architect scalable and resilient cloud infrastructures, enabling seamless deployment and optimal performance across diverse projects.
Summary
Resume
My Experience
August 2022 - Present
Data Engineer - Lead
SevenRooms
- Architected and constructed the Data infrastructure on GCP, facilitating seamless data management and analytics.
- Formulated and implemented rigorous Data security and Governance policies to uphold compliance and data integrity.
- Established comprehensive monitoring mechanisms, reducing operational costs by $50K per month while enhancing user activity tracking and auditing.
- Spearheaded proactive data quality checks, employing Monte Carlo simulations to fortify data reliability and preempt potential issues.
- Deployed CI/CD pipelines via GitHub
January 2020 - September 2022
Data Engineer Manager
AppFolio, Inc.
- Spearheaded the transition to real-time data processing for our production data and business services by leveraging cutting-edge streaming services such as Kubernetes (K8s), Kafka, and Debezium.
- Led the transformation of our legacy and current systems into Infrastructure as Code (IaaC) using Terraform, ensuring seamless scalability and reproducibility.
- Orchestrated the implementation of batch processing pipelines for product and business services utilizing Apache Airflow, integrating monitoring capabilities with Datadog and Slack for enhanced visibility and communication.
November 2017 - January 2020
Data Warehouse Engineer II
MINDBODY, Inc
- 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.
- 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.
August 2016 - November 2017
Technology Analyst
Infosys
- 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).
April 2015 - April 2016
Research Analyst
Florida International University
- 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
- Designed & built Database (RDBMS in MySQL), Backend Services (Python, SQL), RESTful API(Spring)
June 2011 - December 2014
System Engineer ( Business Data Analyst)
Infosys
- 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)
- Data warehouse implementation for Wealth Management Company SSIS, SSMS, SSAS and Tableau.
- Help on Code Deployment, Testing, Quality assurance,Code Review and Defects fixed
My Education
August 2007 - April 2011
Bachelors in Computer Science
Narsee Monjee Institue of management Studies University
Completed my Bachelor's in Computer Science with distinction, showcasing dedication, expertise, and a passion for excellence in every endeavor.
January 2015 - March 2016
Masters in Information Systems
Florida International University
Successfully completed my Masters in Information Systems with exemplary achievement, demonstrating a commitment to excellence and a deep understanding of cutting-edge technologies and methodologies.
My Skills
Data Engineering 90%
SQL 80%
Python 80%
Cloud Engineering 85%
Google Cloud Platform 80%
Data Modeling/Manupilation 95%
Azure 85%
Shell Scripting 80%
AWS 95%
Apache Airflow 75%
Portfolio
Photography
Testimonial
Client Speak
Jose Castillo Developer, Florida internatinal University
“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 Manager, ITPA
“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.”
Contact
Get in Touch
Contact Info
+1 (585) 733-6042
nitinj025@gmail.com