Data Analyst Information Systems

SHAWN GONSALVES

Jersey City, NJ ***** ***************@*****.*** 201-***-**** LinkedIn-shawngonsalves

PROFILE

DATA ANALYST BUSINESS ANALYST DATABASE ADMINISTRATOR

1+ Years experience in Database Administration, Data Analyst with complete working knowledge of Software development life cycle. Currently seeking a Database Administrator/Data Analyst role where I can put my knowledge to work

SUMMARY OF EXPERIENCE

Margin5 Solutions Pvt. Ltd, Mumbai, India July 2015 – August 2016

Client: Sarah Jane Brain Foundation, New York, NY

Role: Database Administrator

Managed and supported 2+ MS SQL Servers with 20+ databases for all database activities

Worked on installing, configuring and patching MS SQL Server 2016 and 2012 database servers

Helped in upgrading database servers from lower version to higher version

Participated in requirement gathering and analyzing for new application development

Worked with business users and application developers for requirements and project specs

Worked on creating, planning database structures for online and web applications

Created logical and physical models of table structures and implemented the same in database

Created complete strategy for full, differential and log backups for all system and user database

Worked on securing the database by implementing windows and SQL based authentication

Implemented maintenance jobs for database consistency checks and performance

Created tables, views, stored procedures and triggers for business functionality

Analyze the requirements of stakeholders to create Business Requirement Document, Decomposition Diagram, and Process Flow/Activity Diagram.

Developed Data model diagrams and Wireframes/Prototypes on the basis of process flow.

Created Use case statements and Specifications to meet the stakeholder’s needs.

TECHNICAL SKILLS

Databases: MS SQL Server 2016/2014/2012, MySQL, Microsoft Access

Operating System Windows Server 2016/2012, Microsoft Azure, Amazon AWS

Programming Languages: R, C, C++, Java, HTML, Python

Web Designing: Java Script, HTML, CSS, HTML5, JQuery

Software & Tools: MATLAB, Microsoft Office, MS Project, PHP, Tableau, SharePoint, Visio

EDUCATION

Pace University, Seidenberg School of Computer Science and Information Systems New York, NY

Master of Science (MS) in Information Systems GPA: 3.8 May 2018

St. Francis Institute of Technology, Mumbai University Mumbai, India

Bachelor of Engineering (BE) in Computer Science May 2013

RELEVANT COURSEWORK

Database Design and Web Development Information Systems Project & Change Management Information Security and Controls Big Data and Information Systems Data Warehousing, Mining and Visualization Business Telecommunications

Information Systems Design and Development Information Architecture Business Analytics for Decision Making

ACADEMIC PROJECTS

Analyze the requirements of stakeholders to create Business Requirement Document, Decomposition Diagram, Process Flow/Activity Diagram. Develop Data model diagrams and Wireframes/Prototypes on the basis of process flow. Create Use case statements and Specifications to meet the stakeholder’s needs.

Designed and Developed application on (CRUD) for students to find good housing on the basis of their requirements. Filtered the search of the requirements to get most relevant results. Feedback module is built for the users and stored results in database.

Developed an innovative cryptographic substitution method to generate a stronger cipher using existing substitution algorithms. This method converts the sensitive information which is in the form of text into a bitmap image instead of the traditional symbols and texts.

Built a mobile based voting system which allows the users to vote using their mobile phones and announces the winner of the election at the end. The system uses an SMS Gateway software named SMSGEE to send and receive messages from the user to the computer.

TRAINING & CERTIFICATION

MS SQL Server training course by NIIT and certified for the same by NIIT

Oracle SQL training course by NIIT and certified by the same at NIIT

Training courses taken for Data Analysis, design and Analytics

ACTIVITIES

Frequently participated in SSWUG and Microsoft seminars on databases in New York

Frequently visited in Meetup groups for database and analytics

Involved in organizing various technical events during college Tech fests

Project Management Institute (PMI), member

Contact this candidate