Shalendra

Shalendra

Data Analyst
India

About Me

Looking for an opportunity to work as Data Analyst with an established organization, leveraging my experience in data mining, query optimization, and report generation.

Experience

Data Analyst

Xapotech Service Pvt. Ltd
Feb 2022 - Present · 4 years 4 months

Design the Database, Ensuring its Stability, Reliability, and Performance
 Design, Create, and Implement a BD system based on the base on users'
Demands. (Web Application Development)
 Develop BD schemas, Tables, and Databases.
 Ensure data Quality and Maintain Database Integrity.
 Fix issues related to Database performance and provided the corrective
measures.
 Create complex function Script, stored Procedure, and Trigger to Support
Application Development.
 Take Regular Database Backup. SSMS, SSIS, ETL
 I will additionally be fulfilling ad-hoc data requests within tight deadlines and
am preferably comfortable working with financial and marketing data.
 I will be responsible for the analysis of large datasets in a complex data
environment.
 Visualize the Report or the dataset using bar and chart and other tools of the
Power BI Visualization and create the Dashboard too.
 Standardization Data Format, parsing and splitting Data, Validating data,
Handling Outlier, performing Transaction in the database to maintain the ACID
Properties
 Azure SQL Database for managing Cloud Database Services

Data Analyst

Xapotech Servies Pvt.Ltd.(FF, G-21, Sector-03, Noida-201301, (U.P.))
Feb 2022 - Present · 4 years 4 months

Design the database, ensuring its stability, reliability, and performance.
Design, create, and implement a BD system based on users' demands.
Develop BD schemas, tables, and databases.
Ensure data quality and maintain database integrity.
Fix issues related to database performance and provide corrective measures.
Create complex function script, stored procedure, and trigger to support application development.
Take regular database backup.
Fulfill ad-hoc data requests within tight deadlines.
Work with financial and marketing data.
Analyze large datasets in a complex data environment.
Visualize reports or datasets using bar charts and other Power BI visualization tools.
Create dashboards.
Standardize data format.
Parse and split data.
Validate data.
Handle outliers.
Perform transactions in the database to maintain ACID properties.
Use Azure SQL Database for managing cloud database services.

MIS Executive

LAKSHMI MACHINE TOOL (Ghaziabad, Uttar Pradesh)
Apr 2018 - Jul 2021 · 3 years 3 months

Data entry on Excel regarding the distribution of batch products with drawing sheet.
Maintain the Excel sheet hourly.
Record finish time of the product by the machine.
Maintain daily and monthly progress reports.
Prepare estimation of building material from raw material.
Visualize the data to check real-time growth.
Make MIS quality reports of one-to-one product in batch production.
Create dashboards of the dataset during product manufacturing.
Analyze factors to minimize error.
Generate reports through dashboard, chart, graph, and pivot table.
Send reports to higher authority on a weekly basis and as per needs.

Skills

Microsoft Access Statistical Analysis System (SAS) R Programming Language (R) Tableau Database Design Database Stability Database Reliability Database Performance SQL Stored Procedures Triggers Database Backup SSMS SSIS ETL Power BI Data Visualization Data Standardization Data Parsing Data Splitting Data Validation Outlier Handling ACID Properties Azure SQL Database Excel Python VS Code Jupyter Machine Learning Artificial Intelligence Data Transformation Data Modelling DAX Dashboards Insights Lookups VLOOKUP Goal Seek Scenario Manager Data Table Conditional Formatting Pivot Tables Pivot Charts Macros Power Pivot Statistics Exception Handling File Handling SQL Database Connection Pandas NumPy Matplotlib Seaborn Joins
Report this Profile?