. Wrote queries on PostgreSQL , SQL Server management Studios(SSMS), and Oracle SQL Developer according to business requirements . Extracted and cleaned the data from from databases in .xls and .csv file format . Created Summary Report, Pivot Tables, and Pivot Chart to summarize the performance of each departments and rep . Developed the B2C Sales Trending, EMS Rep Level, and Error Summary dashboard on Tableau for Directors and Executives

Straight Line Source | Mar 2021 - Jun 2021

Data Analyst

• Developed the Pace, Revenue Analysis, milestones, and gamification reports of Straight-Line Home Mortgage, Topdots and various businesses using Tableau and MS Excel • Extracted data from SQL Server, MySQL, Ricochet and Velocify Browsers, and Top Dot Databases to create the report in MS Excel and Tableau • Attended meeting with executive and client to gather the requirement of projects and analyzed the weekly and MTD progress • Used SSMS (SQL Server Management Studios) developed operational and investigative analysis of large data sets using SQL into meaningful analysis and reporting. • Using Seaborn, Numpy,and Pandas library python script to develop the differential and inferential statistics of sales

Springboard | Jun 2020 - Mar 2021

Data Analyst Immersive Student

400+ hours of hands-on course material, with 1:1 industry expert mentor oversight, and completion of 2 in-depth capstone projects. Mastered skills in analyzing business problems, data analysis, presenting business insights to different stakeholders, SQL, Python and data visualization. My Capstone Projects 1.ChemCorp Insights 2. Prices Factors of King County Houses

Mount Sinai Beth Israel | May 2020 - Dec 2020

IT Analyst

• Imported Hospital’s Data from PDF file and then formatted professionally as given instruction to present in MS Excel • Created the automation inventory for supplies report using VLOOKUP, HLOOKUP, SUMIFS, and IFS function for hospital Staff • Created the Remote Epic Lab for Mount Sinai Beth Israel Hospital’s staff and nurses using Zoom and Cisco WebEx • Installed, maintained, configure and deploy the zebra printers, scanners and multifunction printers • Used SOM (Service Now) and resolve the issued tickets for hospitals, and gathered feedback from end users • Troubleshot, Installed, modified, configured, upgraded and repaired computer hardware and software systems

York College of the City University of New York | Jan 2017 - May 2020

Information Technology Support Analyst

• Created tickets for the PCs, printers, and laptop using Kace Management Appliance Service System • Helped and Assisted 20+ students on network IP copiers, multifunction scanners and network printers • Installed and maintained the multifunction printers, copier and scanners • Organized and checked software, network connectivity and hardware installation of 100+ computers in library • Made IT report and pivot via MS Excel at the end of the day to update about Desktop Computer to library supervisor • Extracted the csv data file from CUNY database and then analyzed the number transfer of books, books borrowed • Created the weekly reports on MS Excel of all the expenditures in library

My Education

Take a look at my formal education

York College of the City University of New York

Springboard Data Analytics Career Track, Certification, Data AnalystSpringboard | 2020

QA ETL TESTER Certified, ETL, SQL, Informatica, Dataware HouseWhizdom Trainings | 2020

Create Your Data Portfolio for Free