Database Optimization for E-commerce Website

Nikhil S

Data Analyst
Data Engineer
I am here to create ETL pipelines for your data so that insightful and meaningful conclusions can be drawn through powerful PowerBI dashboards in which diagrammatic arrangements of data appears in a clear and concise way.I can make your business decisions easy to make by showing proper alignments of key performance indicators KPI's on the dashboards so that reaching to a conclusion by making proper decisions by visualizing the data.I can make your database queries run fatser by 10x .I can increase the overall performance of a database by applying techniques such as performance optimizations ,writing ETLs,creating automated scripts to move data in a proper format applying necessary transformations,cleaning the imporper data to a proper format and much more.Performance optimizations writing optimized queries ,applying proper indexes to the tables ,thus running the ETLs 10x faster.I have created date range for the US's daylight savings dates for the 21 century .I have found out bugs in the sql queries and what all optimizations required for the database tables so as to make buisness process faster and efficient.Certifications done are as follows:SQLSQL AdvancedSnowflake-The Complete MasterclassOracle SQL Performance Tuning MasterclassBuilding Tools with PythonData Ingestion with PythonElasticsearch Essential TrainingLearning Amazon Web Services (AWS) for DevelopersSQL BasicSQL-IntermediateUsing Python for AutomationLearning Excel 2019Advanced SQL for Query Tuning and Performance OptimizationLearning Data AnalyticsIntroduction to ProgrammingPython for Data Science and AIPython for Data Science and AITools for Data ScienceTools for Data ScienceWhat is Data ScienceOracle Certified Java ProgrammerHow Computers workI take client requirements and deliverables on a very serious note . Whatever knowledge and skills are required to complete the tasks and projects are considered very efficient and effective by me and I try my best to deliver the best quality of work from my side.So,I am here to put in time and effort .I provide services for the subjects in :datawarehouse creationwriting ETLS with proper transformations and error free data.automating the daily tasks.creating PowerBI dashboards so that buisnesses can infer proper conclusions from the charts and diagrammatically showing them in a concise way.✅ Performance Tuning.✅ Automation Expert (using python)✅ Power BI.✅ Expertise in SQL and PL/SQL programming.✅ Data Warehouse .✅ Data extractions via SQL queries.✅ Expertise in development of procedure, functions, packages, triggers ,cursors , views etc.✅ Developing code based on DB specifications.✅ Creating database functions and stored procedures for API endpoints.🛠🔧 🆂🆀🅻 ✔️🔧🔨 🅿🅻🆂🆀🅻✔️⚙️🛠 🅿🅴🆁🅵🅾🆁🅼🅰🅽🅲🅴 🆃🆄🅽🅸🅽🅶✔️🔨⚙️ 🅿🅾🆆🅴🆁 🅱🅸✔️
Partner With Nikhil
View Services

More Projects by Nikhil