Sql Server Management

SHAHID NAEEM

Cell # 201-***-****

Email: *****@****.*** (preferable contact)

Jersey City, NJ

Work Status: US Citizen

Summary

Over 10 years Information Technology experience as subject matter expert in implementing, architecture and development

Excellent UI Skills in HTML, CSS, JavaScript, JQuery, XML & XSLT

Solid working experience of AngularJS, KnockoutJS and Twitter Bootstrap

Strong in developing applications using Microsoft .Net Framework 2.0/3.5/4.0, C#, VB.NET, Web Form, LINQ, Entity Framework, Web Services, WPF, Silverlight, WCF, SOA, Restful, ASP.Net, MVC, AJAX, IIS, Azure

Familiar with application prototyping, construction, implementation, deployment, and integration with Quality Assurance

Strong experience with SQL Server 2005/2008 in stored procedures, views, functions, triggers, performance tuning and optimization, SSRS and SSIS.

Active involvement in the complete Software Development Life Cycle.

Involved in TFS builds and version control.

Having excellent experience in test driven, domain drive and service oriented architecture(SOA)

Strong background in OOP, Object Oriented Analysis & Design and Design Patterns, IOC

Experience in Business Intelligence & Reporting Services solutions

Proven written and verbal communication skills

Highly motivated, organized, and detail oriented team player having ability to work independently and manage multiple tasks with priority.

Education

Master of Computer Information System (MCIS) from Boston University

TECHNICAL SKILLS

.NET Technologies: .Net Framework 4.5, ASP.NET, MVC 2/3/4/5, VB.NET, C#, LINQ, Web Forms, Web Services, WCF, WPF, Silverlight, AJAX

Web Technologies: HTML, XHTML, ASP, CSS, DHTML, XML, XSD and XSLT, JQuery, JSON, JavaScript, KnockoutJS, AngularJS

Tools: Visual Studio 2013, Team Foundation Server, Turquoise SVN, Perforce, Crystal Reports, SQL Management Studios, SQL Profiler, Fiddler, Firebug

3rd Party Tools: Infragistics & Telerik controls, Kendo UI

Database: SQL Server 2000/2005/2008, My SQL, Oracle, MySQL

Methodologies: Agile, Waterfall, SOA, Restful

PROFESSIONAL EXPERIENCE:

Bank of America, New York City May 2015 – Today

Senior Application Developer

Project: Registration & Insurance Licensing System-RAILS

RAILS provide support to securities registration and insurance licenses for the forms and their employees affiliated with Bank of America’s domestic broker dealers, investment advisers, NGA firms and Insurance Agencies. IT also provide support to mortgage licensing in accordance with SAFE Act requirements. Initial, amended and renewal filling for associate securities, NFA registration, insurance licenses, mortgage licenses and security related business entities. Securities continuing education monitoring and ethical training notification to registered representatives.

Responsibilities

Building wrapper services with Web API to consume legacy services for securities, features registration, insurance licenses, mortgage registration and corporate filings.

Developing responsive design interfaces to consume Web API service.

Developing rich user experience by reducing round trips to server

Unit testing with Jasmine

Weekly code reviews

Supervision of test/integration phases

Environment: ASP.Net MVC 5, Web API, WCF, Entity Framework, SQL Server 2012, Bootstrap, Kendo UI, AngularJS

KPMG US, Montvale, New Jersey Jun 2012 – May 2015

Senior .Net Developer

KPMG provides audit, tax and advisory services and industry insight to help organizations negotiate risks and perform in the dynamic and challenging environments in which they do business. Projects I have been involved in Global Desktop, Accounting Change Services, Least Management Tool, Infrastructure Management System, Team Track integration, Remedy integration & KPMG KART Aggregation & Reporting Tool.

Responsibilities

Build workflow to allow KPMG’s firm employee to schedule their machines for upgrade

Designing and implementing process changes

Evaluating changes needed to internal controls over financial reporting

Reassessing internal management reporting and business measurement metrics

Accessing general business issues such as contractual terms, pricing practices and debt covenant compliance

Worked in production environment and hit the ground running

Provide multi-client functionality to web project

Provide support and implemented new functionally to KPMG Leasing Tool

Involved in technical specification based on functional specifications

Created web services with MVC 4 Web API

Utilize Web API functionality with JQuery and C# code

Implemented Task Parallel Library to utilize multi-core and Asynchronous functionality of MVC 4

Created and implemented tables, stored produces and functions in SQL Server 2008 R2

Implemented Gang-of-Four design patterns and IOC containers

Design and developed leasing framework based on WWF

Analysis and design of complex reports using SQL Reporting Services

Make the web project compatible with different browser like IE 7, 8,9,Firefox and Chrome.

Extensible experience in troubleshooting JQuery, JavaScript and CSS

Environment: ASP.Net MVC 5, WCF & Restful services, Entity Framework, SQL Server 2012, SSIS, SSRS, JQuery, Kendo UI, Bootstrap, Kendo UI, AngularJS, Knockout

Polo Ralph Lauren, Madison Ave, NYC Aug 2011 – Apr 2012

Senior .Net Developer

What began almost four decades ago with a collection of ties has grown into an entire world redefining American style. Polo has always stood for providing quality products and creating worlds that invite people to take part in our dream. We were the innovators of lifestyle advertisements that tell a story and the first to create stores that encourage customers to participate in that lifestyle. Back when we started, it seemed there were no boundaries for Polo. That's even truer today.

Responsibilities

Created technical specification based on functional specifications.

Involved in all phases of Software Development Life Cycle including requirements gathering, design, development, testing, implementation and post production support

Experienced in creating user friendly web user interface, user controls and custom controls.

Implemented design patterns especially Inversion of controls, Ninject, Castle Windsor & Structure Map

Created Restful services and utilized with JQuery & JSONP

Provide support and implemented new functionally to existing RL websites

Environment: ASP.Net, MVC 2/3, WCF & Restful services, Entity Framework, SQL Server 2008, JQuery, CSS,

Mr. Youth LLC, NYC Oct 2010 – July 2011

Project: Social Confeiti

Sr. Net Developer

The Social Confieti is a social media marketing product providing statistics of social media campaign from Facebook, Twitter and Youtube. It creates comprehensive social business strategy and monitors the best way the people talk about your product or service. It helps customer quickly research, manage, monitor and report on social media marketing campaigns.

Responsibilities

Build framework for facebook and twitter APIs in C#

Used json and jquery in MVC project

Resolve/diagnose data issues relating API

Implemented design patterns in C#, ASP.NET & MVC

Optimized pages for search engine standards

Created and implemented WCF service interfaces

Prepared and executed unit test plans for every module

Environment: ASP.Net MVC 2, Silverlight, WCF, Entity Framework, Visual Studio 2010, SQL Server 2008, JQuery, NUnit

Capture Inspiration Jan 2008 – Feb 2010

Programmer Analyst

Project: HIS ( Hospital Information System )

HIS provides Medical Services, Supporting Services, specialized treatments, Medical Insurance. HIS provides in-patient and out-patient management, hospital procedures management and patient care, Insurance and claim management, Medical treatment record, Patient History, Financial Management, payroll, Scheduling Management etc.

Responsibilities

Created technical specification based on functional specifications.

Involved in all phases of Software Development Life Cycle including requirements gathering, design, development, testing, implementation and post production support.

Branded the entire portal using master pages, css and html

Develop custom site/list definition, web parts and event handlers to MOSS 2007

Created custom forms using InfoPath and published them in SharePoint form library.

Developed and consumed xml web services.

Worked on out of the box workflow features of SharePoint Server 2007

Designed and Developed of new feature enhancements.

Environment: MOSS 2007, InfoPath, SQL Server 2005, Visual Studio

Project: Report Distribution System

Finance departments have been provided the ability to manage their report distribution securely and efficiently. All current and past employees have been provided one location for viewing of Finance reports. It has been provides the ability for all business units to deliver secured electronic reports to the staff. Web based, internally developed and managed using technology standards for ease of ongoing support and enhancements.

Responsibilities:

Assisted in the deployment of the application to the production environment.

Control the Application Security using the Windows Active Directory Service.

Designed the User Controls, Involved in Bug Fixing and Provided Hot Fix.

Using the Visual Studio Tools for Office to break the Files into multiple Files and Convert the Excel\Word Files into PDF Format.

Parse the Excel/Word/PDF Files From Excel-to-Excel, Excel-to-PDF, Word-to-Word, Word-to-PDF, PDF-to-PDF,

Environment: Visual Studio 2008, C#, Web Form, Web Services, WCF, SQL Server 2005, Windows 2003 server, R.A.D controls, XML, VSTO

Media Office June 2007- Dec 2007

Programmer Analyst

Media Office is personal office for ruler of Dubai. It contains daily news, his poetry, biography and other information in Arabic and English. The website is implemented in Vignette’s integrated web content management system.

Responsibilities

Day to day administration of the vignette application

Install, configure and manage IIS Web servers and Apache Tomcat

Trained the end user for website backend how to use

Developed web pages in ASP.NET using C#

Responsible for daily news publication activity

Provide production support/problem resolution

Environment: Visual Studio 2005, C#, JSP, ADO.Net, SQL Server 2005, Vignette Web Content Management, Windows Server 2003 Enterprise

Orbplanet Mar 2004 – Apr 2007

Project: Visitors’ Guide (www.visitorsguide.is)

Senior Web Developer

Visitor’s Guide is most popular tourist guides to Iceland. It contains information about booking accommodation, dining, shopping, culture, tours & activities. It also contains articles, photo-galleries and maps. The system is developed as content management system. CMS gives template to create and maintain a fully functional website. It also meets standard compliant to all web standards and search engine friendly.

Responsibilities

Design & Develop Business, UI Layer and Data Access Layer.

Developed the web pages in ASP.NET using C #

Developed the Custom Handlers for Specific Validation Issues in ASP.NET

Created classes for DML operations in VB.NET and C #.

Used JavaScript along with ASP.NET validation controls for client side validations

Search Engine Optimization’s responsibilities

Environment: Visual Studio 2005, C#, ADO.Net, Web Forms, SQL Server 2005, Windows Server 2003

Project: School Management System

This system creates and maintains student and staff records, classes, sections activities and library management, fee and expenditure and open forum among staff members and students to communicate. It also contains class room activities, assignment and results.

Responsibilities:

Created & Writing the code using Web Forms

Designing the Database using SQL Server.

Written Stored Procedures to improve system performance in SQL Server.

Used joins (inner join and outer join) in SQL queries to get data from multiple tables using SQL.

Developed Business rule and Work Flow.

Used Sheridan Controls(Third party Control) for data entry

Implement the project over intranet

Environment: Visual Studio 2003, Sheridan Control, SQL Server 2000, Visual Source Safe, Windows 2000

Fine Knitting Pvt. Ltd Oct 2000 – Feb 2004

Software Engineer

Project: Visual MIS System

Finance department has been provides fully web-based financial accounting system up-to four level of chart of accounts as well as inventory control module including quotations, sales, purchases and stock maintenance. System has features to create and maintain chart of a/c and journal vouchers. It automatically generates reports such as payable a/c, receivable a/c, trial balance, balance sheet and income statement.

Responsibilities

Responsible for system study, gathering user requirements

Involved in database design and created database objects; tables, views, triggers & stored procedures

Individually responsible to work out the User Interface (UI) and designed Forms for the data Entry, update and for data retrieval.

Designed and developed reports in Seagate Crystal Report

Implement chat of a/c set up

Environment: Visual Studio 2000, Visual Basic 6.0, Crystal Reporting, SQL Server, Sheridan Control/Components One (Third party Tools), Windows NT

Contact this candidate