Data Analyst Resume CUNY, NY - Hire IT People

SUMMARY

Proficient in installation of SQL servers; Configuration, Database Design, Security, Backup, Recovery, Roles and User Permissions
Upgrade the Production, Testing and Development databases from SQL Server 2005 and 2008 Enterprise version to SQL Server 2012 Enterprise version & 2014 Standard version
Proficient in database migration from SQL servers 2000, 2005, 2008 to SQL 2016 and in creating maintenance plans for database consistency checks, indexes/statistics and performed fine tuning of database applications.

TECHNICAL SKILLS

Java
Microsoft SQL Server 2005/2008/2008R2/2012, 2014, 2016 and windows 2008R2/2012/2016
JIRA & Agile
C++
SAS
Tableau
HTML & CSS
JavaScript
phpMyAdmin
Microsoft Access
MS Excel
Python.

PROFESSIONAL EXPERIENCE

Confidential - CUNY, NY

Data Analyst

Responsibilities:

Created Clustered index, Triggers, Views & automated reports in SQL commands like Stored Procedure; Connected that to tableau for data visualization. Which drove down the total time to locate required data from large dataset.
Set up security by creating roles, login box, password, and restricted access for certain users (read-only, disabling users to edit, delete &save) by using C++ in MS Access VBA.
Extracted and analyzed data from large datasets, using SQL Commands, SAS, and Tableau to do the ETL process. Created Pipeline or Automated process- it saved time whenever new data came to the system. Cleaned up the data, to made it usable.
Architected, implemented, and delivered a fast and flexible data extraction solution in java using multi-threaded JDBC connections that was designed to quickly adapt to changing data of the IT department
Made reports of the projects, communicated, and shared plans using dashboards, JIRA or MS office tools with the team
Designed and implemented stored procedure, that helped to keep track of an updated version of a software, downloaded in lab computers (Used MS Excel and MySQL)
Performed in-memory sorting and hash join technology and linked servers by using SQL Server Management Studio, this made it easy to fetch and update data in other databases in MS Excel or Access
Summarized & sorted data, created customized table and dashboards in Excel and Tableau for data reporting by using pivot tables and vlookup; Created and then ran Macros in MS Excel, it saved time whenever the same type of task came.
Data mining on Twitter - Collected, Iterated, and cleaned tweets, using python (tweepy)

Confidential, NY

Teaching Assistant

Responsibilities:

Taught the lab portion of The Technology of Information course - Debugged JavaScript, CSS, and HTML coding errors students’ assignments; taught how to create responsive website, Software Development using Microsoft SQL Server 2008, taught relational database design and execute program by Linux command line..

We provide IT Staff Augmentation Services!

Data Analyst Resume

Cuny, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship