Post Job Free

Resume

Sign in

Sql Server Software Developer

Location:
Jersey City, NJ, 07307
Salary:
120000
Posted:
July 30, 2015

Contact this candidate

Resume:

SUMMARY:

Software professional with *+ years of experience working on enterprise level software projects

Expert in object oriented design, algorithms and data structures

Experience in web development using ASP.Net with C# and VB.Net, HTML, XSLT, Javascript, VBScript, XML, ADO.Net and Microsoft SQL.

Extensive expertise in developing Web Forms Controls using ASP.NET, ASP.NET MVC3, jQuery UI.

Extensive experience in SQL Server Database design, Database maintenance, developing T-SQL queries, stored procedures, and triggers using SQL Server 2005/2008.

Strong Technical skills on Microsoft Technology stack: .Net framework, C#, SQL Server, RESTful WebAPI, and ASP.NET.

Good hands on and implementation experience of Object Oriented Programming

Ability to guide resources and provide estimations for the requirements.

Extensive expertise in ASP.NET DotNetNuke framework along with module development, site management

Adept in overseeing smooth implementation of projects involving multiple clients and products.

Able to work independently as well as in a team, multitask and handle project deadlines.

Articulate in interacting with different teams from diverse geographical locations and higher levels of management in the organization.

Fast learner and ability to quickly grasp and implement new technologies

EDUCATIONAL QUALIFICATION:

Masters in Computer Science, Pune University, India, Year 2005

Bachelors in Computer Science, Pune University, India, Year 2003.

TECHNICAL SKILLS:

Languages : C#, VB.Net

Operating Systems : Windows

Web Technologies : ASP.NET, MVC 3.0, 4.0 with C#, Razor Engine, AJAX, ASP.NET Web Services, HTML, XSL, XML

WCF, RESTFUL services

Scripting Languages : Javascript, JQuery, JSON

Client side framework : AngularJS

Databases and Tools : MS SQL Server(2000, 2005, 2008), Oracle – SQL Developer, MS Office

Reporting Tools : Crystal Reports

Frameworks : DotNetNuke (DNN), CSLA, Façade

Source Safes : Microsoft Visual Source Safe, Team Foundation Server

Code Review tools : FXCop, Style Cop, Resharper

CERTIFICATION:

Microsoft Certified solution Developer (Year - 2007)

PROFESSIONAL EXPERIENCES:

Client: New York City Department of Education 08/2014 – Current

Role: Dot Net Lead Developer

Project: Special Education Student Information System (SESIS)

Description: The Special Education Student Information System (SESIS) support all kind of users – teachers, students, parents, in completing special education workflow processes from referral through IEP development. SESIS is a web-based application that assists school staff and related service providers in managing the special education process for students entering kindergarten through age 21. The following processes are managed in SESIS – Referral, Evaluation, IEP.

This application is developed on .NET framework called, TieNET. This uses ASP.NET, MVC 3.0-4.0 with Razor Engine, and C #in frontend and SQL server in backend. This application supports full configuration for administrative roles, where everything can be changed or configured without touching codebase.

Currently, this application is in process of complete rewriting using latest web technologies like, HTML5, JQuery, AngularJS, ASP.NET WebAPI, ADO.NET Entity framework & SQL Server. The main purpose of rewrite is, performance issues as well as application should support all new devices like phones, tabs, laptops & desktops. With help of Responsive Web Design (RWD), we are trying to achieve this.

RESPONSIBILITIES:

Understanding business requirement for new configuration changes, possible then implementing it using framework, else need to develop new module in TieNet which will fulfill the requirement.

Majorly involved in writing technical specifications & design documents for any change in applications.

Database objects – stored procedures, complex queries tuning for better performance.

Code review of own modules, peer code review for team members using coding standard, and coding tools.

New application rewrite, worked on couple of PoCs to finalize the technologies to be used as final applications. Technologies browsed such as, AngularJS, BootStrap CSS, MVC.

Also worked on responsive web design using HTML5 & Media queries.

Client: Marsh LLC, Marsh & McLennan Companies 04/2012 – 8/2014

Role: Technical Lead Developer

Project: Marsh.com Global web site & Legacy Applications

Description: Marsh LLC is basically an insurance broker company. Marsh.com application is used across globe for providing information about its products and services, special news and events, etc.

This application is global facing web site for Marsh LLC base on DotNetNuke Framework. Using feature of DNN, This site has around 30 sub country portals on same instance. This site also uses some nice tools like Google Search appliance, which helps to provide fast search results base on contents crawled per country. Also uses Google Analytics for observing statics like, how many users visited site, from which browsers, mostly visited pages, etc. Along with this other legacy applications on MVC 3.0/4.0 with Razor Engine, RESTful API services which are mostly used internally for data provider between multiple applications.

RESPONSIBILITIES:

Developing new DNN modules base on .Net platform using C# making use of recent

Performing code review on of DNN module base on pre-defined coding standards

Executing performance test for any module which will be used on site

Coordination with network team to manage new and existing domains for sites which will be live from site

Coordination with hosting provider (PowerDNN) for any type of issues

Code & SQL Server database objects tuning whenever required for application

Writing scripts for exporting data from Marsh.com database to other applications, like new users, cleaning up terminated users.

Part of audits

Developing and maintaining legacy applications for data transfers, request handling customer tracking using ASP.NET MVC 3.0, REST Web APIs, Microsoft tools like MS Access, MS Excel base on requirements

Developing Microsoft Word documents of business users which works as standard templates, Customizing outlook features per business requirements like meeting place, additional information can be placed while sending emails with the help of MS VSTO C# 2010

Environment: C# on .Net, Microsoft SQL Server 2008, MVC 3.0/4.0, REST API services, Infragistic

External Tool Integration: Google Search Appliance, Google Analytics

Client: Oliver Wyman, Marsh & McLennan Companies Oct 2010 – Mar/2012

Role: Senior Software Developer

Project: Work-Life Balance System, Employee Benefits

Description: Oliver Wyman is an insurance broker company and works under Marsh & McLennan companies.

It is developing in-house software for its consultants for presentations, data manipulations, data storage, products demos and for CRM.

RESPONSIBILITIES:

Provide programming and technical expertise for Oliver Wyman data products as a member of Engagement Services team in the Enterprises Products and Services division.

Perform software development and support for clients by programming their custom finance applications Microsoft API using VBA, C#.Net and VB.Net

Offer technical expertise for Oliver Wyman data products like Data license where client can get Oliver Wyman data via FTP or using web services. Help clients with code (Java/C#) and configuration of web services using utilities like SOAPUI that use the SOAP protocol.

Continue to learn new products and cutting edge solutions for data distribution management. Provide Proof of Concept to finance firms as to how the Platform solution will streamline their data distribution workflow and cut down on their costs. Also, do Solution evaluation and help architect the best solution for the client based on their custom needs, budget and infrastructure available.

Provide programming expertise with ASP.NET MVC, Silverlight softwares, integrating third party controls like Telerik, Infragistics,and help clients develop multi-tier applications using RESTful services

Lead client visits to assist with pre-sales technical discussions, offer onsite advisement, solution comparison and expertise for clients during the development phase and also help troubleshoot production issues. Use Microsoft Office tools like PowerPoint and Excel for all client presentations.

Responsible for developing in-house as well as client facing tools using C#, JQuery and Microsoft SQL to leverage technologies and aid in providing a more efficient environment internally as well as externally for the clients.

Liaise with different teams internally at Oliver Wyman and work with them to manage client expectations, escalate and expedite resolution of client issues, convey client concerns and requirements to business and provide a seamless customer experience for the clients.

Environment: .NET (Framework 2/3.5/4), MVC, Silverlight, C#, VB.net, Web Services, SOAP, VBA, FTP, Telerik, Visual Studio, MS Office

Client: Mercer LLC, Marsh & McLennan Companies Sep 2008 – Oct 2010

Role: Senior Software Developer

Project: Executive Talent Management

Description: Current system is ETM re-write application in DotNetNuke (DNN) framework from classic ASP application. This is an evaluation system of executive corporate. Through this system, corporate can maintain performance of employee, overall ratings, KRAs etc. with proper security.

Re-write application is mostly contains multi portal application using single codebase. It has facility of multi-lingual application as well.

RESPONSIBILITIES:

Analyze the functional and technical needs of the client, and accordingly design, enhance and architect. Mostly involved in requirement gathering, design decisions, project planning, implementing core modules

As a module lead, responsibility of release & implementation of code for internal QA and to client.

Write client-side scripting code using JavaScript and VBScript and server-side code using C# and VB.Net on the ASP.Net framework.

Use AJAX to provide fast and efficient dynamic updates on the webpage

Major responsibility of doing peer review, gatekeeper review, and code cleaning of application using standard tools like FXCop, StyleCop & ReSharper.

As individual, I was responsible for developing one of the core modules of application .i.e. process engine, which decides flow of entire application. I have designed entire database & code of this module as per the client requirements.

Manage the back-end connection to Microsoft SQL as the data source using ADO.Net and write SQL queries, stored procedures and triggers to manage data. Also create clustered and non-clustered index to aid faster retrieval of data.

Oversee the installation of customizations unique to the client environment, and respond to questions, comments and criticisms so that the concerns raised by the client were adequately addressed.

Also I have provided guidelines to team, how to improve performance of application at code level and while writing stored procedures.

Environment: ASP.Net, C#, DotNetNuke(DNN), JavaScript, VB Script, AJAX, ADO.Net, Microsoft SQL Server 2005, IIS, StyleCop, FXCop, ReSharper

Client: Mercer LLC, Marsh & McLennan Companies June 2007 – Sep 2008

Role: Senior Software Developer

Project: e-International Positioning System (eIPE)

RESPONSIBILITIES:

Description: The current system is an International Position Evaluation system, by which companies can use Mercer’s standard position and calculate position class, using that companies come to know what would responsibilities assigned to particular person in the system, reporting structure for him/her.

Analyze the functional and technical needs of the client, and accordingly design, enhance and architect the company’s Customer Relationship Management (CRM) software that best catered to the client needs.

Write client-side scripting code using JavaScript and VBScript and server-side code using C# and VB.Net on the ASP.Net CSLA framework.

Use XSLT as the styling language to transform XML data returned from the server to HTML

Use AJAX to provide fast and efficient dynamic updates on the webpage

Manage the back-end connection to Microsoft SQL as the data source using ADO.Net and write SQL queries, stored procedures, and triggers to manage data. Also create clustered and non-clustered index to aid faster retrieval of data.

Handling Tasks like, code review, performance issues, tuning code and database objects

Environment: ASP.Net, C#, AJAX, Crystal Reports, SQL server 2005

Client: Thomas Cook June 2006 –June 2007

Role: Senior Software Developer

Project: Corporate FE (ASP.NET/ C#-SQL- Server)

Description: Corporate FE is the result of consolidating existing London corporate clients, Serviced from Thomas Cook stores across London, into a single location Based at Great Russell Street.

This is a web based Application. Modules, which have been included here such as

To maintain invoices detail (Buy/sell) for the customers and generate invoice details reports in a much presentable way.

To maintain corporate customer details into the system

To load the spot rates for different currencies on a daily basis into the system to send emails from the system with invoice details or rates for different currencies.

Printing Reports.

Project: WIPS (Worldwide Income payment System)

This is a worldwide Income and Payment System (WIPS) for Thomas Cook, which each resort sends it weekly data for UK office for showing weekly Income and Expenses of particular resort.

The Current System is developed for Centralized data processing for resorts of Thomas Cook which are distributed all over the world in 60 Gateways and each gateway having multiple resorts. We are developing this system using C# windows forms for client application and web services for transferring data between these client applications to centralized database server.

RESPONSIBILIES:

Involved in requirement gathering, defining project scope, preparing design level documentations.

Designed system in C# windows form and ASP.NET Web Services

Database communication using ADO.NET objects along with SQL server objects like Tables, Views & Stored Procedures

Use case preparation and execution in testing phase

Handling releases

Environment: ASP.NET, C#, Windows Forms, Crystal reports, SQL Server 2000

Client: UTS Feb 2006 - June 2006

Role: Software Engineer

Project: ERP System (Winforms/ C#-SQL- Server)

Description: Developing and maintaining ERP system based on requirements using C#, Winforms & SQL Server 2000

Developing & integrating reports using reporting tools like Crystal reports

RESPONSIBILITIES:

Involved in Initial requirement discussions with the business during the design phase.

Involved in developing functional design document and Technical design document.

Involved in implementation of User Interface, Business logics, and Data Access Components in WinForms- C#

Involved in database design and development in SQL Server 2000.

Involved in Bug Fixing and enhancements.

Used TFS to coordinate with team member’s development.

Environment: C#, Windows Forms, Crystal reports, SQL Server 2000

Client: The Analyst Group Pvt Ltd. Oct 2004- Dec 2005

Role: Software Engineer

Project: Assent and liability management system

Description: The system is concerning with generating reports which are imports for RBI from every bank’s head offices every year. This system works as per the standard RBI’s rules for each bank to show their annual/semi-annual/quarterly working with proper time buckets. My role in this system to write stored procedures for functioning data internally into database and writing stored triggers.

RESPONSIBILIES:

Involved in requirement gathering, defining project scope, preparing design level documentations.

Designed system in C# windows form

Database communication using ADO.NET objects along with SQL server objects like Tables, Views & Stored Procedures

Use case preparation and execution in testing phase

Handling releases

Environment: ASP.NET, C#, Windows Forms, Crystal reports, SQL Server 2000



Contact this candidate