Pradeep Sharma

Data Analyst

ICSI

Noida (******)

Mob-790-***-****/843-***-****

E-mail: ad4aw8@r.postjobfree.com

Professional Summary:

Work extensively in Data handling, providing high quality result-oriented services, analyzing business problems and report Development and Maintenance in EXCEL, SQL SERVER and POWER BI. Created workbooks by importing data, and defining relationships between Excel and SQL. Experience in working with complex SQL queries like Joins and Sub-queries to generate reports. Skills:

POWER BI DATA VISUALIZATION MS SQL SERVER

REPORT GENERATION DASHBOARD CREATION MS OFFICE

LMS ADMIN LARGE DB HANDLING REQUIREMENT GATHERING

Achievements and certification

Successfully completed Certification program for “Data Visualization with Power BI” from Great Learning. Professional Experience

Company Name: - ICSI 03 September, 2021 to currently working Position Title: Consultant

Description:

Data Extraction and Transformation.

Write SQL queries to extract data from various sources. Develop dashboards to monitor key performance indicators. Worked with Excel Pivot tables.

Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like SQL and MS-Excel. Interacting with the Stakeholders and understanding the process related requirement and creating Dashboards and Automations for Data Analysis.

Involved in extensive Data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.

Roles & Responsibility:

Taking care of Daily, Weekly and Monthly reports.

Creating almost 50+ MS-excel data extraction utilities with the help of SQL server 2012. Making process related Automations like Report Automations to reduce time and efforts. Wrote SQL Queries like different joins to extract data from different tables for accurate data. Clean, maintain and update database for accuracy of all reports. Maintain the Data as per requirement and data processing. Coordinating with other departments for the data to analyze. Involved in website database design to manage users. Wrote SQL Queries, Stored Procedure, Triggers, Views and Indexing using DML, DDL commands and user defined functions to implement business logic.

Maintained positive communication and working relationship with all business levels. Reviewed, analyzed and implemented necessary changes in appropriate areas to enhance and improve existing system Company Name: - CORE INTEGRA 25 September, 2019 to 02 September 2021 Position Title: Functional consultant Product : ICSI E-learning Browser : Google chrome, Mozilla Firefox Role : DME Description:

It is an E Learning domain based project in which E learning courses are provided to student of different courses. It provides a unique E- learning experience of courses for students in form of E-book, Audio book and Video. Roles & Responsibility:

Having knowledge of platform and its capabilities. Assist with activities of system design, implementation, and administration Utilizes software applications for the analysis and processing of different project reports. Understanding requirement so that we can provide best possible solution. Configuring and test QB with different modalities. Facilitated creation, revision and maintenance of training material content Company Name: - Sybex. 3 July, 2018 to 24 September, 2019 Position Title: -IT Analyst

Product : ICSI E-learning

Browser : Google chrome, Mozilla Firefox

Role : IT Analyst

Description:

This software provides online facility for student to take the Pre-examination Test. It is an E Learning domain based project in which E learning courses are provided to student of different courses. Academics.

B.Tech (I.T) from UPTU

Class 12th from S. D. Inter College U.P Board

Class 10th from S. D. Inter College U.P Board