Post Job Free

Resume

Sign in

Sql Server Manager

Location:
Jersey City, NJ
Posted:
June 01, 2015

Contact this candidate

Resume:

MONIS KAMIL Cell: 551-***-****

** ****** ******, *** *, Jersey City, New Jersey, 07307 Email: acpzr1@r.postjobfree.com

OBJECTIVE: Enthusiastic and driven experienced professional seeking a full-time job position.

EDUCATION: Stevens Institute of Technology, Hoboken, New Jersey December 2014

Master of Science in Computer Science

GPA 3.6

Mumbai University December 2012

Bachelor of Engineering in Computer Science, Mumbai, India

GPA 3.6

TECHNOLOGY SUMMARY:

DBMS : MS SQL Server, SSIS 2012/2008, SSRS, Oracle 9i, MYSQL, MS-Access.

Programming Languages : SQL, Transact SQL (T-SQL), C, C++, Java, R, VB.Net.

Web Technologies : Java Script, HTML, XML, Servlets, PHP, CSS.

Software : SQL Server Enterprise Manager, Visual Studio, Python, SAS, Anaconda

Business Tools : Word, Excel, PowerPoint, Access, Visio, Outlook

Operating Systems : Windows (98/2000/NT/XP/Vista, 7, 8), Linux.

WORK EXPERIENCE:

Systems Engineering and Research Centre (SERC), HELIX Project Feb 2014 –

Dec 2014

Research Intern, Stevens Institute of Technology

• Performed text extraction and analysis on INCOSE data using Python and R-software by cleaning 18GB

of data (unstructured data approx.18000 records) and assisted in analyzing the data by performing extraction,

clustering, summarizing, network analysis and question answering to effectiveness of system engineers.

• Designed a dynamic website and mobile site using WordPress, PHP.( www.se-swe.org)

• Conceptualized and Designed a Content Management System (CMS) using MS Access, PHP to store the

records in a database for future extraction.

• Research paper: “The Education Background of INCOSE Systems Engineering Professional Certification

Program Applicants” selected and published in INCOSE International Symposium 2015.

Top Serve International Pvt. Ltd., Mumbai Aug 2012 – Feb 2013

SQL Server / BI Developer

• Performed all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server

Integration

Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2012 environment.

• Created daily, weekly and monthly SSRS dashboard reports for sales and profit analysis. Updated the SSRS

reports with different location and period hierarchy.

• Designed and built the dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Ms. NELCO LTD. (a TATA Enterprise), Mumbai

Industrial Drives Intern Dec 2008 - May 2009

• Designed and collaborated various drawing layouts of projects using AutoCAD.

• Assisted in ISO 9001:2000 certification; documented and organized all records and files.

Auxiliary converter Intern June 2005 - Nov 2005

• Installed and configured programs on Integrated Circuits used in the Auxiliary Converters.

• Performed troubleshooting: identified problems, gave technical advice, prepared service reports and

followed up on scheduling and successfully completed projects within budget and ahead of schedule.

ACADEMIC PROJECTS: Fall

2014

• Classifier to predict whether a Resturant review is positive or negative based on TEXT from

Tripadvisor.com

o Implemented CRISP-DM modelling methodology to address the large volume of data.

o Created python scripts in Anaconda to extract data from the website and Pre-processed the data using stop words

elimination, POS tagging and Stemming and built a classifier to obtain the highest accuracy of prediction.

• SSIS/SSRS Report Project

o Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server

2008/2012

o In-depth knowledge of Transact-SQL (DDL, DML), Indexes, Views, Stored Procedures and User

defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate

efficient data manipulation and data consistency. Also, experience in Reporting services using SSRS.



Contact this candidate