Sql Server Information Technology

Location:

Posted:

January 16, 2017

Looking for a position in Information Technology to utilize skills in performance management, communication and problem analysis.

Certification:

Preparing for Microsoft certifications in MTA (Technology Associate) and MCSA (Solutions Associate) (January 2014 – May 2016)

Database Administration Fundamental – 98-364

Querying Microsoft SQL Server 2012&2014 – 70-461

Administering Microsoft SQL server 2012&2014 – 70-462

Technical Skills:

Database Systems: MS SQL Server 2008/12/14, Oracle, MySQL, SSRS, NoSQL

Operating Systems: MS Windows Server and Desktop, Mac OS X, Linux (CentOS)

Languages: SQL, C#, ASP.Net, JavaScript, Python, Java, Tableau

Internet Technologies: HTML, JSP, XML, SOAP / REST

Tools: MS Visual Studio, MS Office, Lotus Notes, Jira, MS Project, OLAP, ad-hoc query

Professional Experience:

Regal Info Service, Toronto, Canada

SQL Developer/ Analyst

Dec 2011 – Dec 2013

Involved in all phases of Software Development Life Cycle (SDLC) form requirements gathering phase to maintenance phase.

Create automation test script on Java for different test cases scenario on administration portal.

Analyze workflow, test in different browser as well as different OS and report a detailed bug reports on JIRA defect tracking tool.

Involved in projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Perform quality assurance and testing of SQL server environment.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Responsible for the designing advance SQL queries, procedure, cursor, triggers, batch files.

Experienced with SQL Plus and TOAD, PL/SQL Developer, Oracle SQL Developer as an interface to database – to analyze, view and alter data.

Using SQL to query Databases Performing various validations and mapping activities.

Validated and tested reports; then published the reports to the report server.

Performed and conducted complex custom analytics as needed by clients.

Designed and developed specific databases for collection, tracking and reporting of data.

Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.

Education Qualification:

Post Graduation in Business Management (IT)

Lambton College, Toronto, Canada - August 2013

Bachelor of Science with Finance & IT

Sardar Patel University, Gujarat, India - March 2011

Reference: Available upon request.