Badges
Certifications
rajatpatil112 has not earned any certificates yet.
Work Experience
Software Engineer
Harman Connected Services (A Samsung Company)• January 2019 - December 2019
• Worked on Several internal projects in UK HRS team as a Software Engineer with Boots-CS team and MNS-CS team and got an opportunity to work on the large data sets. • Technologies worked on Hadoop, Hive, Oracle, SQL, PowerShell, Kubernetes, AWS Glue, AWS EMR, AWS S3. • Tools Used: JIRA, Git, Devops, VS Code, Control-M. • Developed complex dynamic stored procedures in SQL to load the data from staging phase to keying phase. • Developed stored procedures to scope the geographical datasets according to the requirement of end user. • Used Shell script to automate the fact data load by creating the config file and using this config file as the source to the shell scripts. • Experience in managing the scrum process with the coordination of the team in Agile Methodology • Using pivot tables and VLOOKUP, created visually impactful insights and dashboards in Excel and Tableau for data reporting. • Participated in data migration activities from SQL Server Databases to Azure SQL Database using Azure Database migration service. • Requirement gathering from the internal and external clients for business planning and to make sure data integrity, consistency and prompt data availability as well as answering all questions related to data architecture. • Worked as a DBA to ensure data is secure and organized so analysts can easily locate information.
SQL Developer
Harman Connected Services ( A Samsung Company )• August 2016 - January 2019
• Project development, implementation, post-implementation support as an Associate Software Engineer for IRI Germany clients and handled end to end data load of Rewe, Rewe-Dortmund, Globus retail clients. • Technologies worked on SSIS, SSMS, SSAS, SSRS, Tableau, Python, PowerShell, Hive, Oracle, Agile, DevOps • Tools Used: Microsoft SQL Server 2012, Microsoft Visual Studio, Tableau Desktop. • Analysing the business requirement and functional requirements for development as per the client. • Identifying the key issues of query performance and creation of Root Cause Analysis reports. • ETL process and mapping the attributes from two different data warehouse. • Implemented and validated the Custom Attribute Builder framework code for Marks and Spencer client. Organising the knowledge transfer programmes with the Boots client services team to discuss the functionality of the system after deploying to the production server. • End-to-end workflows development and interfacing with clients and transitioning knowledge of business strategy. • Cooperated with other project mates to create the application's system analysis based on client specifications.
Education
National College of Ireland
Data Science, MS• January 2020 - February 2021
• Modules: Datamining and Machine Learning, Deep Learning, Database Analytics and Programming, Business Intelligence, Domain Application of Predictive Analytics, Statistics, Mathematics, Modeling Simulation and Optimization. • Project 1: (Team project -4 members). Developed an automatic story generation technique based on Artificial Intelligence using deep learning models Bi-LSTM and GPT2. Users suggest a sentence and model will suggest future sentences by prediction using different approaches like Beam search, grid search. Result obtained: 71%. • Project 2: Developed Stock Price Prediction technique using machine learning and deep learning models. The logos of the companies were passed as the input to the system. The text present in the logos were detected using OpenCV’s OCR technique and mapped the logo names with the company names in the PostgreSQL database. ARIMA, ARIMAX and LSTM models were used to analyze data retrieved. The evaluation metrics used were RMSE and MAE.
Visvesvaraya Technological University
Computer Science & Engineering, BE• June 2012 - July 2016
• Academic Project: Developed a computer science project on Automatic attendance system using a face recognition system with an intent to prototype a human face detection algorithm which is popularly being explored in enormous application fields such as video surveillance systems. We had made use of Microsoft Visual Studio IDE and C++ programming language. Open CV external library was used for acquiring, processing, analyzing, and understanding images of high dimensional data.
Links
Skills
rajatpatil112 has not updated skills details yet.