Rasheed Shahzad
***-** ******** *** ***# *R Jamaica NY, 11432
Cell: 347-***-****, Email: *******.*******@**********.****.***
Education:
Baruch College/ CUNY New York, NY
Major: Computer Information System
Certification:
Advance windows 7 certification June 2014 CUNY- NY
ComTIA A+ (part 1) August 27, 2014
Skills: Microsoft Office Suite, QuickBooks, TaxPro, C++, HTML, CSS, IBM Rational Software Architecture, UML, SQL, Adobe Photoshop, Adobe After Effects, Pinnacle 17, Magix 16(video Editing), Mobile devices trouble shooting, Windows (all version), Mac
Work Experience:
NYC Department of Education (Division of Instructional and Information Technology) New York, NY
Data Analyst Sep 2015 – Present
Data extraction, manipulating, uploading, management and quality assurance using Excel, SQL, Visio and Tableau
Analyze data on portal, data server, online Data Dictionary and manipulate it according to the requirements
Manage large datasets and create reports using Excel, SQL and Access
Communicate and document technical work, including coding methodology
Translate broad guidelines into actionable data requirements and business rules
Web application testing, quality assurance and creating report
Working on ticketing system (Magic) to enter tickets then extract through SQL and transform it report
CUNY School of Professional Studies New York, NY
College Assistant/Help Desk Specialist April 2016- June 2016
Provide technical assistance to students, faculty, and staff regarding all types of computer, internet, printer/copier issues
Handled an average of 30 calls, 25 emails per day and prioritized and escalated issues as required
Resolve Students/teachers/administration computer, internet and general issue through remotely, in person, telephone, chat and email
Assist in diagnosing, troubleshooting CUNY Blackboard, E-mail accounts and college registration
Utilize online ticketing software for daily tasks include creating, closing, updating tickets and reporting major issues
Research foundation CUNY (NYC Department of Education) New York, NY
IT Specialist (LaGuardia High School) Sep 2014 – June 2015
Assist in setting up computer, projector, audio/video system for meetings, conferences and events
Performed hardware, software installations/upgrades, imaging, repairs, maintenance and replacing project parts
Assist in buying technology for school teachers, staff and administration for educational purposes
Contact vendors for supplies like ink/tonner, paper and for printer/copier repairs
Contact department of education for replacing old computer and other related equipment from school
Maintain school equipment (desktop, laptop, monitor, projector, printer/copier, smartboard) inventory list
Install, upgrade and maintain small network with in the school building using routers and switches
Opening, closing, updating of tickets on online system and taking actions on ticket
Demonstration and training regarding use of computer, smartboards and different software to staff and teachers
Baruch College New York, NY
Computer Lab Assistant June 2011 – May 2014
Diagnose and maintenance of computer hardware, software and all in one printers
Network installation and maintenance of the network in the computer lab
Helping students to work in Microsoft suit, adobe suite to complete their assignments
Opening/closing of computer lab
Reporting computer labs issues to the supervisors
S.A Associates (provides tax and accounting consultancy / services) New York, NY
Tax preparer and bookkeeper June 2013 – June 2014
Extracurricular Activities:
Secretary, Pakistani Student Association, Baruch College 2012 – 2013
Undergraduate Student Government of Baruch College July 13 – June 14
Executive Board (Communication Board member)
Photographer at Baruch College 2011 -- 2015
Member of Baruch Accounting Society Dec 2012 – 2015