Engineer Information Systems

Swapna Shenolikar

** ****** ****** ******.**********@*****.***

Malden MA 02148 978-***-****

OBJECTIVE:

Seeking challenging position in IT industry that will provide me with the opportunity to utilize and continuously improve skills of SQL development and database design.

TECHNICAL SKILLS:

Programming: SQL, PL/SQL, Python, C++, .NET, Python, Visio

Platform: UNIX, Linux, Windows

Web technology: HTML, XML

Databases: MS SQL Server, Oracle 9i/10g/11g

Tools: SSRS

PROFESSIONAL EXPERIENCE:

Reliance Info Solutions Ltd. (January 2009- December 2011)

System engineer

Responsibilities:

Creation and administration of MSSQL databases.

Created SQL queries, views and stored procedures, functions and triggers.

Build reports for Reliance retail business team and senior management as per requirements.

Analyzed existing data in database and eliminated redundancy from it for better report generation.

Reliance Info Solutions Ltd. (December 2007- December 2008)

Application Support engineer

Responsibilities:

Managing & providing IT support both remotely and on-site to all the Reliance Retail Outlet located throughout India.

Troubleshooting issues related to software, hardware and networking for smooth functioning of Reliance retail outlets and to meet critical deadlines and Service Level Agreements (SLA’s).

Resolve user (retail outlet employee) queries independently or by interacting with business team.

ACADEMIC PROJECT:

"FIFA World Cup 2014" ( September - December 2016)

Project in R which includes preparing data, preprocessing and analyzing.

Analysis includes various bar graphs, histograms, pie charts, dot plots, normal distribution, central limit theorem, simple random, systematic, stratified, cluster sampling and confidence intervals of 80% and 90% for the sample data of size 20 and 30.

"Database design for Multi-Specialty Health Center" (February – May 2016)

Design and implementation of database for electronic health record system.

Mapped the Entity Relationship Diagram to SQL database schema using Oracle SQL Developer.

Build stored procedures and views using complex queries to automate business processes

Data retrieval performance improvement by implementation of database indexes

EDUCATION:

Master of Science, Computer Information Systems (Anticipated Dec 2017)

Boston University Metropolitan College, Boston MA

Certificate in Database Management Technologies (May 2014)

Department of Continuing Education, University of Massachusetts Lowell MA

Diploma in Software engineering (June 2009)

NIIT Institute, Mumbai, India

Bachelor of Commerce, Major: Accounting (June 2006)

University of Mumbai, Mumbai, India

RELEVENT COURSEWORK:

Linux/ UNIX® Operating System

Database Administration I: Introduction to Oracle 11g

Business Data Communication and Networks

Database Administration II: Advanced Oracle 11g

Database Design and Implementation for Business

Oracle 11g SQL Development

Information Systems Analysis and Design

PL/SQL I: Introduction to Oracle 11g PL/SQL

Data Mining

Advanced Database Management

Contact this candidate