Bipin Kumar's Linkedin Analytics

3 Years of Experience | Snap-on Business Solutions India Pvt. Ltd. • Transition from old to the new architecture • Creating complex views and queries • Creating complex SQL queries by combining Joins, SubQueries, CTE, and Inline Views. • Worked on various PL/pgSQL components such as procedures, functions, and triggers. • Improving the performance of old queries while migrating to new architecture queries. • Enhanced database query performance through strategic Tuning, Partitioning, Indexing, and Optimization of code that used to process 10- 100 Millions of records, resulting in improved query response times ranging from 20%-95%. Technical Skills: RDBMS, SQL, PL/SQL, PostgreSQL, Oracle, pgAdmin, DBevier, ODI, Python, Power BI, JSON, XML, Microsoft Office, Shell Scripting, PuTTy, winSCP, Jupyter notebook, JIRA, Agile Methodology. Python library for data analysis: Numpy, Pandas, Matplotlib, Seaborn. Operating System: Windows and Linux