I pursued my bachelor of engineering degree in Information Technology, and after that, in 2017 I started working as a software engineer in Tata Consultancy Services. Over the period of 3 years, I worked for 2 clients, Virgin Media and Equifax for their data migration projects. I would like to continue working and contributing in the same domain.
So in 2020, I decided to pursue a master's degree in Information Systems and currently, I am in my 2nd Semester. As I have a strong inclination towards Data Science and that’s why I opted for courses like
Data Science and Machine Learning tools
Advance Data Science architecture
Data warehousing and business intelligence
Data management and database design
As a part of Advance Data Science and Machine Learning I have completed 3 projects till now which are movie recommendation system, FIFA-2019: performance analysis, and restaurant revenue prediction where I used multiple machine learning libraries like pandas , matplotlib , seaborn, scikit learn, H2O.
And as a part of Data warehousing and business intelligence Currently I am working on multiple databases using data integration tools likes Alteryx, talent, and BI tools like tableu and powerBI
Experience
Tata Consultancy Services
Sep 2017 – Aug 2020
Mumbai
Software Engineer - Data
• Performed a detailed analysis for the migration of CDC data to Cloud through bluebird
• Designed efficient ETL pipelines in Talend to integrate the data and performed mapping to transform extracted data into target tables
• Designed normalized tables, implemented indexes, and successfully reduced the SQL query processing time by 70%
• Implemented Stored Procedures, Functions, Triggers, and SQL joins to load and manipulate data from on-premise to cloud
• Improved the performance tuning up to 60% by creating and modifying indexes, partitions, and changing query structure
• Fetched weekly production data, imported in Pandas data frame, and performed various imputations to analyze it
• Created self-explanatory reports and dashboards using Tableau and presented data migration reports to higher management
• Collaborated with the onsite client and successfully analyzed the total number of scripts to change due to application upgrade by writing an efficient shell script which increased the time optimization to 70%
• Identified the data source(Main Frame) flow and equivalent data in the target dataset (Netezza)
• Used procedures and functions while performing data conversion into Netezza to achieve equivalent data format
