Sahastranshu Tiwary
Deoghar
Summary
A professional who has worked on Data for more than 5 years developing, analyzing and administrating data. Have experience in building databases & data models for software. Skilled in designing and executing comprehensive testing plans which increased the success rate substantially. Equipped with skills to enhance the performance of database with latest concepts and technologies while keeping cost effective approach. Working towards targets to increase value of the organization.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Business Analyst
Larsen and Toubro Infotech
04.2021 - 07.2022
- Created and optimized data model using JSON to store and manage data.
- Developed and maintained data warehouses to support business operations
- Developed customized reports, summarizing and presenting data in visually appealing format using matplotlib, plotly and pyplot.
- Wrote and performance tuned SQL scripts for 5 software for clients to fetch desired data.
- Performed analysis on memory utilization and saved 30% of data.
- Migrated data from older version to newer version.
- Maintained security and set standards of data using ACID Principles.
- Used ETL concepts to fetch, migrate and load data.
Business Analyst
Wipro
03.2019 - 03.2020
- .Performed gap analysis to identify areas of improvement.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Developed and implemented testing plans to increase success rate by 90%.
- Deployed predictive analytics models to forecast future trends.
- Implemented business intelligence, pipelining and ETL solutions to increase operational efficiency
- Created dashboards to present data across teams.
Database Administrator
TCS [Contract - ASAP Technologies]
05.2018 - 12.2018
- Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures
- Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability
- Analyzed memory utilization to reduce memory usage by 20%.
- Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations
- Performed regular backups and used IBM DB2 Utilities to conduct administration tasks
- Created and implemented 2 disaster recovery plans to ensure business continuity in event of hardware failures or natural disasters
- Optimized database performance by monitoring health and implementing tuning recommendations.
Database Administrator
IBM India Pvt Ltd
07.2015 - 02.2018
- Worked for 3 clients from 3 different industries.
- Created Db2 objects based on client's requirement
- Developed customized reports, summarizing and presenting data using concepts of data visualization
- Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability
- Optimized database performance by monitoring health and implementing tuning recommendations
- Performed yearly audits for client to ensure maintenance
- Tested programs and databases to identify issues and make necessary modifications
- Created and performed 6 disaster recovery plan to ensure business continuity in event of hardware failures or natural disasters
- Maintained regular backups and consistency points.
Education
Master of Science - Msc Data Science
University of Nottingham
Nottingham, UK_ 12.2024
Bachelor of Science - Msc Data Science
S.R.M. Institute of Science And Technology
Chennai, India_05.2015
Skills
- SQL, RDBMS, MySQL, JSON, NoSQL, Python
- Agile Methodology, SDLC
- Business Analytics, Communication Skills
- Data Visualization, Gathering & Modelling
- Trade Life Cycle
- ETL
- Requirements Gathering
- Machine Learning, Linear Regression
- Database Administration & Development
- Report Preparation & Presentation & Auditing
- Health Checks and Monitoring
Certification
- Databases and SQL for Data Science with Python
- Python for Data Science, AI & Development
- Data Science Methodology
- Tools for Data Science
- What is Data Science?
- The Data Scientist’s Toolbox
Projects
- Mastering SQL Joins.
- Plots Creation using Matplotlib Python.
- Fake News Detection with Machine Learning.
- Simple Nearest Neighbors Regression and Classification.
Timeline
Business Analyst
Larsen and Toubro Infotech
04.2021 - 07.2022
Business Analyst
Wipro
03.2019 - 03.2020
Database Administrator
TCS [Contract - ASAP Technologies]
05.2018 - 12.2018
Database Administrator
IBM India Pvt Ltd
07.2015 - 02.2018
Master of Science - Msc Data Science
University of Nottingham
Bachelor of Science - Msc Data Science
S.R.M. Institute of Science And Technology
- Databases and SQL for Data Science with Python
- Python for Data Science, AI & Development
- Data Science Methodology
- Tools for Data Science
- What is Data Science?
- The Data Scientist’s Toolbox
Similar Profiles
Prakhar MittalPrakhar Mittal
Senior Data Engineer at Larsen and Toubro Infotech (LTIMindtree)Senior Data Engineer at Larsen and Toubro Infotech (LTIMindtree)
Mit ShethMit Sheth
Implementation Consultant /Software Engineer at Larsen and Toubro InfotechImplementation Consultant /Software Engineer at Larsen and Toubro Infotech
Shiksha KapoorShiksha Kapoor
System Engineer at Larsen and Toubro Infotech (LTI)System Engineer at Larsen and Toubro Infotech (LTI)