Ajit Chaudhary
AWS Data Engineer at InfoTrack AU- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Abhishek Man Singh
I have worked with Ajit for more than 6 years where I have seen him grow from a data analyst to data manager. He has worked for the most complex clients for the company which put him as a very valued member of the team and he was also an integral part of the team. He does even better when he is under pressure. He has the ability of good decision making and has good communication skills. I am sure he will do well where ever he goes.
LinkedIn User
Ajit and I worked being in same team where he worked as Data Manager. He has good proficiency in data analytics (healthcare) and SQL. He has been familiar to various analytic tools like MS SQL, MySQL, AWS RedShift for detailed data analysis. He always have good work ethics and is friendly in nature. I wish him all the success for his future endeavors.
Abhishek Man Singh
I have worked with Ajit for more than 6 years where I have seen him grow from a data analyst to data manager. He has worked for the most complex clients for the company which put him as a very valued member of the team and he was also an integral part of the team. He does even better when he is under pressure. He has the ability of good decision making and has good communication skills. I am sure he will do well where ever he goes.
LinkedIn User
Ajit and I worked being in same team where he worked as Data Manager. He has good proficiency in data analytics (healthcare) and SQL. He has been familiar to various analytic tools like MS SQL, MySQL, AWS RedShift for detailed data analysis. He always have good work ethics and is friendly in nature. I wish him all the success for his future endeavors.
Abhishek Man Singh
I have worked with Ajit for more than 6 years where I have seen him grow from a data analyst to data manager. He has worked for the most complex clients for the company which put him as a very valued member of the team and he was also an integral part of the team. He does even better when he is under pressure. He has the ability of good decision making and has good communication skills. I am sure he will do well where ever he goes.
LinkedIn User
Ajit and I worked being in same team where he worked as Data Manager. He has good proficiency in data analytics (healthcare) and SQL. He has been familiar to various analytic tools like MS SQL, MySQL, AWS RedShift for detailed data analysis. He always have good work ethics and is friendly in nature. I wish him all the success for his future endeavors.
Abhishek Man Singh
I have worked with Ajit for more than 6 years where I have seen him grow from a data analyst to data manager. He has worked for the most complex clients for the company which put him as a very valued member of the team and he was also an integral part of the team. He does even better when he is under pressure. He has the ability of good decision making and has good communication skills. I am sure he will do well where ever he goes.
LinkedIn User
Ajit and I worked being in same team where he worked as Data Manager. He has good proficiency in data analytics (healthcare) and SQL. He has been familiar to various analytic tools like MS SQL, MySQL, AWS RedShift for detailed data analysis. He always have good work ethics and is friendly in nature. I wish him all the success for his future endeavors.
Credentials
-
Introduction to Data Science in Python
CourseraJan, 2021- Nov, 2024 -
Statistical Inference
CourseraDec, 2020- Nov, 2024 -
Deploy Machine Learning Model into AWS Cloud Servers
CourseraNov, 2020- Nov, 2024 -
Excel 2016: Advanced Formulas and Functions
LinkedInApr, 2020- Nov, 2024 -
Excel 2016: Pivot Tables in Depth
LinkedInApr, 2020- Nov, 2024 -
Creating Interactive Tableau Dashboards
LinkedInMar, 2020- Nov, 2024 -
Excel: Power Pivot for Beginners
LinkedInMar, 2020- Nov, 2024 -
Learning Python
LinkedInMar, 2020- Nov, 2024 -
Tableau 10: Mastering Calculations
LinkedInMar, 2020- Nov, 2024 -
Databricks Certified Data Engineer Associate
DatabricksJan, 2023- Nov, 2024 -
SQL
TestDomeFeb, 2020- Nov, 2024
Experience
-
InfoTrack AU
-
Australia
-
IT Services and IT Consulting
-
200 - 300 Employee
-
AWS Data Engineer
-
Nov 2021 - Present
• Build an ETL Data ingestion of both batch and real time processing using Apache Spark from SQL Server and Mongo DB to Databricks warehouse using AWS migration service, AWS glue and S3 from scratch. • Building an actionable dashboard, KPI metrics, Customer insights using SQL Server, DAX, and Power BI. • Property data transformation from raw to staging from Mongo DB in Databricks and building insights in Power BI. • Data ingestion from several APIs in Databricks and performing transformation from raw to staging and building dashboards and insights in Power BI. • Data modelling using tools like Erwin and MS Visio. • Writing complex procedure, views, and Business logic in SQL Server. • Real time data alerts for anomalies or product usages. Achievements: - • Build and released end to end first Power BI reporting for the company. • Build data warehouse from scratch in Databricks. • Databricks Associate Data Engineer certified. Show less
-
-
-
Upwork
-
United States
-
Software Development
-
700 & Above Employee
-
Data Analyst
-
Feb 2020 - Nov 2021
Profile:- https://www.upwork.com/freelancers/~01d3069df43d26d4c8 Website:- https://akchaudhary57.github.io/akchaudhary/ - Casual Database Administrator at Macquarie University Profile:- https://www.upwork.com/freelancers/~01d3069df43d26d4c8 Website:- https://akchaudhary57.github.io/akchaudhary/ - Casual Database Administrator at Macquarie University
-
-
-
Deerwalk Inc.
-
United States
-
Software Development
-
100 - 200 Employee
-
Data Manager
-
Oct 2016 - Feb 2020
• Business and data requirement review that requires initial data analysis to research and interpret whether the data meets application and operational requirements. • Communicate with a client regarding data issues and provide a solution to the team• Design, analyze, visualize and provide the technical solutions to the team in the platform like SQL, Erwin and MS Visio.• Conducting and coordinating complex cross-functional analysis of heath care data.• Devise and implement efficient procedures for data handling and analysis with attention to all technical aspects through data modeling tool like Erwin and MS Visio.• Knowledge of Git hub that involve tracking and managing workflow.• Communicate with the Account manager about data changes or requirements.• Take complete responsibility for the issues and ensure that there is a smooth delivery of the project. Show less
-
-
Senior Data Engineer
-
Feb 2015 - Sep 2016
Currently working as a team lead in Deerwalk. Major task includes:-• Worked on data modelling, design, and development of Data Warehouse in AWS Redshift, Erwin, MS Visio.• Database performance tuning, troubleshooting, and optimization in MSSQL.• Creating dashboard using PowerBI.• ETL, data Mapping and scrubbing on US health care data from raw to stage format in SQL server, AWS Redshift, AWS glue.• Scripting / Programming in database like MSSQL and Mysql platform.• Experience setting up and monitoring / alarming for production Database environments.• Data Mapping and Scrubbing: - Working on US health care data analysis, major task would be to turn data into standard format. Scrubbing is the data cleaning process. We first work on the layout and study it in detail. Then we import the data into relational database and work further on cleaning it.• Understanding and analyzing the data while working on implementing the business logic of various projects.• Provide database support to include triggers, queries and custom reports in collaboration with other systems engineers and software developers.• Working on data modeling, design and development of Data Warehouse• Good knowledge of automating data process.• Configuring and managing data replication including clustering, conducting daily backup, importing/exporting data to our systems, reporting, monitoring, troubleshooting and directly interacting with client.• Providing training and guidance to junior developers. Show less
-
-
Data Engineer
-
Aug 2012 - Jan 2015
Major work includes:- • Structure ETL process in extract, transform and load information from and in various database platforms like SQL Server, AWS glue.• Develop import scripts in SQL for implementations client or when changes occur in data layout.• Developing, automating, and maintaining procedures and reports • Analysis, design, and build of new and enhanced components on the SQL Platform with includes cursor, stored procedure, and functions.• Prepare scrub script in SQL as per the finalized DSD.• Prepare a automated scrub scripts that imports data files as per the frequency of processing (Daily, Weekly, Monthly and Quarterly).• Ensure that the provided data matches with standard industrial layout.• Monitor for errors and accuracy. Analyze and fix errors.• Escalate issues to the Team Lead / Managers whenever required. Show less
-
-
Education
-
2020 - 2021
Macquarie University
Master's degree, Master of data Science -
2008 - 2012
Kathmandu University
Bachelor of Engineering (BE), Computer Engineering
Community
