Pratik Bhandari

Jersey City, NJ

C#/.Net Developer

PROFILE:

Highly motivated IT Professional with Eight years experienced in software development. I am self-starting, goal-oriented, flexible and enthusiastic software professional with experience in developing multi-tiered Microsoft .NET based applications. I am having expertise and experience in:

? Multi-tier distributed applications development.

? Component design principles utilizing design patterns ? Singleton, Fa?ade, Factory and Observer.

? Component development & deployment using COM+

? . NET Framework, C#, AngularJS, ASP.NET, MVC, WinForms, WPF, XML Web Services, WCF, Entity Framework and Remoting

? Web applications development using Active Server Pages (ASP.Net), MVC, JQuery, JavaScript, Angular JS and SPA.

? Relational database management and Microsoft Data Access Application Blocks.

PROFESSIONAL SUMMARY:

? 8+ years of extensive experience in designing and developing web applications, web services, client/server applications by using ASP.NET, MVC, C#, OOPS, jQuery, AJAX, SQL Server & Entity Framework .

? Extensive experience in C#, ASP.Net, SILVERLIGHT, .Net Framework 4.5/4.0/3.5/3.0/2.0, WCF, LINQ, Ajax, Win Forms, Web Forms, ADO.Net, SQL Server, Web Services, Crystal Reports, JavaScript, JQuery, Telerik Control.

? Strong experience in developing internet, intranet, N-tier and distributed client-server applications using C#.Net, ASP.Net, ADO.Net, AJAX, VB.Net, SQL Server 2000/2005/2008. Recent intensive project experience in Silverlight, Windows Communication Foundation (WCF), LINQ.

? Expertise in building rich AJAX enabled UI based Web applications in.Net and developing multi-tier client-server Web applications. Good Knowledge on Web Services (SOAP, WSDL, UDDI), XML, XSLT.

? Experience creating Web Forms, User Controls, Custom Controls and Web services etc.

? Experiences with Database Design, Normalization and strong abilities in Data Modelling, Database Design, Views, Stored Procedures, joins, Triggers and Functions using SQL Server & Oracle 11/10/9i.

? Experience on ADO.Net components such as Datasets, Data Adapter, Data Reader and Data View & Data Table to access & update database

? Strong knowledge in System Architecture, Design Patterns including Service Oriented Architecture (SOA), Model View Controller (MVC), MVVM etc.

? Expertise in configuring & administrating version control systems like Team Foundation Server (TFS).

? Expert in debugging an application using the debugging tools provided by the Visual Studio.Net IDE.

? Experience in web programming with good understanding of concepts View Model, Master Pages, validation controls, design patterns and several other ASP.NET features.

? Experience with Test-Driven Development (TDD) like N-Unit testing frameworks and MS unit Tests.

? Experience with Source Code Control Systems like MS Visual Source Safe, TFS (Team Foundation Server), GIT, SVN and Perforce.

? Experience in supporting multiple applications at the same time and provide L3 support within SLA time.

? Experience in production support for various applications implemented in different technologies.

? Experience using Visual Studio development environment, for windows and web based applications having used them for professional and academic projects.

? Proficient in writing Unit Test Cases for Business logic, Web services and WCF.

? Excellent interpersonal and communication skills as an active team player.

TECHNICAL SKILLS:

Design Patterns: Singleton, Fa?ade, Factory, Observer and Command patterns. MVC and SOA architecture. Agile / Scrum Methodology.

Language: C Sharp (C#)

Internet /Web MVC 5/4, WebForms/Razor, Dot Net Framework 4.5/4.0/3.5/3.0/2.0/1.1/1.0, ASP.Net 4.0/3.5/2.0/1.1/1.0, ASP 3.0/2.0, AngularJS, Angular 2, Knockout JS, JQuery, SPA, HTML 5, TypeScript, JavaScript, Ajax, Bootstrap, VBScript, Visual Studio.Net 2015/2013/2012/ 2010, Visual Studio 6.0, SVN and Visual Source Safe

Middle ?Tier Objects WCF, SOAP Web Services, Entity Framework, .Net Remoting, COM+, COM, Scripting Object and Remote Scripting

Technique: Multi-Threading, Reflection, Sockets, MS Application Blocks 5.0, 2.0, MS Dot Net Provider for Oracle / SQL Server, ODP.NET (Oracle), ADO.Net, OLE-DB, ODBC.

XML XML, XSLT, XSL and Xpath

DataBase: MS SQL Server 2012/ 2008/2005/2000/7.0, Oracle 11,10G/9i/8i/7.3, Sybase 12.5, DB2, T-Sql, PL/SQL, Dynamic PL/SQL, Toad, Navigator, Erwin and SSIS Package

OS/Server: Windows Dot Net Server 2012,2008/2003, Web Server (IIS 7.0/6.0/5.0), Windows 2012/2008/2000 Server, Windows 7 /2000 /XP Pro and Unix Sun Solaris

Package: MS Reporting Services (SSRS), Crystal Reports, SSIS, HighCharts, JIRA, Autosys, MS Silverlight 2.0, Rational Rose, UML, XML Spy, FXCops, MS Office 2016/2013/2010/2007, MS Project, VBA, Discoverer (Oracle), VSS, PVCS, SourceGear, Infragistics, Telerik, Kendo, Dev Express, NUnit, MOQ

PROFESSIONAL EXPERIENCES:

HSBC, NYC, NY Jun 2016 ? March 2017

Role: C# / Full Stack Developer

Project: Treasury Credit Systems (TCS): TCS enables COBAM credit services and Treasury Credit to perform credit risk management functions, such as reviewing, approving, tracking, and monitoring credit for counterparties HSBC engages in business with limits and treats.

Responsibilities:

? Participated in requirements gathering and compiled them into design document.

? Created use case and class diagrams in MS Visio using UML notations.

? Used ASP.NET Master Pages, jQuery, utilizing Server Controls, User Controls, Data Grid Controls, Form Validation controls, Custom controls and CSS.

? Developed middle layer using C#.Net and ASP.NET.

? Used ADO.NET for data retrieving, querying, storage and manipulation interface screens developed using MVC.

? Applied lot of basic validations in MVC using Data Annotations.

? Developed the presentation layer by using Ajax controls and web server controls.

? Used JQuery extensively across the application like making Ajax calls, cascading menus, calendar controls, tool tips, sliding menus, Ajax loading tabs, expand collapse panels etc.

? Implemented bootstrap to make application accessible in other devices.

? Used forms based Authentication and role based Authorization for security.

? Worked on TFS for version control, Code Review and for automatic builds and continuous Integration.

? Created Joins, Views, functions, stored procedures and triggers as part of the database programming.

? Implemented WCF, ASMX Web services to share data to downstream.

? Maintenance/Enhancement of Project and handling/fixing bug on daily basis reported by Help Desk

Environment: .Net Framework 4.5, Visual Studio 2012, VB.NET, ASP.NET 4.5, C#, HTML, CSS, JavaScript, Web Services WCF and REST, XML, Oracle 12c, TFS, MVC 4, Web API, Entity Framework, Angular JS, Boot Strap

LIUIS, Brooklyn, NY Jan 2016 ? Jun 2016

Role: Web Application Developer

DESCRIPTION: LIUIS is a Digital knowledge management platform built to support content representation, subscription, enrolment, education and tracking activity progress across multiple digital platforms. The system offers a clean and efficient layout that allows users to have enrichment opportunities. This application has been show cased in several institutional forums and achieved recognition for its contribution towards digital knowledge growth.

Responsibilities:

? Used ASP.NET MVC template and C# for building the application.

? Subscribers can enroll in multiple courses. Many-to-Many Relationships.

? Created a registration page and implemented server side and client side validation.

? Used complex data model for relationship among the entities using Entity Framework.

? Searched Tab for searching subscribers and Content providers to select the search criteria from the list.

? Provided authentication and authorization for different user like Content providers, Subscribers, Enrollment Services, Administrators. Providing different level of privileges among the different users.

? Sorting of the data ascending and descending manner like Dates, Profile Names etc.

? Used Code-First Migration, entity classes are created manually to start from scratch.

? Using Inheritance with the Entity Framework.

? Implemented OAuth using Google and Facebook authorization.

? Defined the relationship among the object and specifying the properties for each of them.

? Used Bootstrap for making graphical user interface for customer friendly approach.

? Designed Controller and action from scratch.

? Binding multiple models or object to create single view page for fast access.

Environment: Visual Studio 2012, Entity Framework, HTML, Bootstrap, C#, CSS, MS SQL SERVER 2012, OAuth Google and Facebook.

MIR Labs, Brooklyn, NY Sept 2015 ? Jan 2016

Role: Web Application Developer

DESCRIPTION: Media Information Retrieval System is an intelligent media search application which performs content tagging, identification, classification and querying across multiple media formats. Content represented in textual, image, audio and video formats are systematically analysed and subjected against MAPS (parameter based) analytical model to perform information retrieval and classification.

Responsibilities:

? Developed web applications using ASP.NET MVC and C#.

? Involved in Code-First Migration Approach for creating Database using Entity Framework.

? Used Migration for updating the schema of database.

? Strong client side experience using JQuery, HTML, CSS and Bootstrap.

? Knowledge of Data Annotations for Server-side Validation, HTML helper method to display the errors.

? Used Authorize attribute for restricting the access of unauthorized user.

? Used Twitter.Typeahead for listing multiple movies.

? Used Bootstrap and Boot Box for the UI.

? Used JQuery Data tables for Pagination, Searching and Sorting of the data.

? Used Partial View Layout for separating the main navigation page.

? Facebook Social Login for the registration of a new user using OAuth.

? Using Custom Validation if user is above 18 years of age and must select the one of the membership type rather than free membership.

? Used Eager loading for loading the relative data. For Instance, when we load the customer object, it will also load their membership type.

Environment: Visual Studio 2012, Entity Framework, HTML, Bootstrap, C#, CSS, MS SQL SERVER 2012, OAuth Google and Facebook.

OATI (Open Access Technology International, Inc.), Mohali, Punjab, India Jul 2012 ? Aug 2015

Headquarter: Minneapolis, MN

Role: C#/.Net Developer

DESCRIPTION: OATI is the leading provider of innovative software solutions. The OATI webTrans ecosystem of solutions fully integrates the functions for both Transmission Providers (TPs) and Balancing Authorities (BAs) by providing the tools for performing complex calculations, data management and reporting functions that automatically gather data from OATI and third-party systems, fulfil compliance reporting requirements, reduce redundant data entry, and automate critical business functions. I was working on a web-based power grid transmission management system and was in charge of designing the transmission logical process via C# and SQL Server 2008. The technologies mostly used in this project were C#, SQL Server, Team Foundation Server, Asp.net.

Responsibilities:

? Enhancing and upgrading currently existing web based applications designed to meet the requirements of electrical control areas and transmission operators.

? Migration of the legacy application to use internally developed (proprietary) framework.

? Customized the energy transaction managing web application.

? Developed C# program, using ADO.net and socket programming that read data from database, did calculations, converted to specific file format and exported to ftp sites.

? Designed and developed numerous web based user interfaces for system that support everything from real-time delivery of data for electric generating plant control to energy transactions.

? Utilized ADO.NET in DAL for database access.

? Participated in production site issue handling and making high level changes to support continuous functionality. Provided support for production releases and post implantation validation.

? Utilized Cookies to store the application state to improve application performance.

? Worked on web forms and data binding controls like Grid View, Data List and Data Set in order to map page fields to the database fields.

? Created View Models to encapsulate all models and classes used on the different views for more stable, organized and clean code to reuse in Views.

? Used Entity Framework models as a bridge to map with SQL Server to support data manipulation.

? Used MVC Action Filters for user authentications and for caching data to improve performance.

? Used NUnit to detect and solve issues related to application by creating various automated test cases

? Developed interfaces to fetch data (CSV and XML) from different ftp sites and feed to the system, which are further processed by the other system.

? Developed stored procedures, views, functions and ad-hoc queries in T-SQL used by the application.

? Developed interfaces to read data files from ftp parse them and import them to db.

? Setting up and configuring webTrans applications for new projects (development, staging and production environment).

? Worked as group lead for OATI India teams for development of software modules.

? Worked as senior developer whose responsibilities are to apply patches/upgrades or trouble shoot problems in production server.

? Investigated performance problems with SQL Servers databases, and implemented corrective measure to solve these problems by fine tuning queries and/or server side scripts.

? Restored the production database from full, differential and hourly dump to development in order to investigate, reproduce and solve production issues.

? Created replication databases on DMZ, and subscribed to main production database to allow application from outside the firewall to access it.

? Moving data from one server (DEV) to another (Production), flat file (CSV or excel) to database table by using bulk copy program (BCP).

Environment: Net Framework 4.5/4.0, ASP.Net, C#, WCF, ADO.Net, AJAX, JavaScript, T-SQL, XML, HTML, LINQ, JQuery, Internet Information Services (IIS) 6.0, SQL Server 2008, Visual Studio.Net 2010 IDE and Team Foundation Server (TFS)

Polaris Software Lab, Chennai, India Aug 2009 ? May 2012

Client: Russell Reynolds Associates, NYC, NY

Role: C# / Web Application developer

Project: Beacon : Beacon is a windows application delivers competitive advantage to the firm and their clients, guiding them through the search and assessment process by facilitating global collaboration and enabling to find better quality candidates quickly. Technologies used are Dot Net Framework 3.5, C#, WinForms, nHibernate, SQL Server 2008 and Dev Components control.

Responsibilities:

? Worked with Project Managers and BA team in understanding and defining the requirement.

? Beacon used MVVM architecture (View ? ViewModel ? Model - Database).

? Used Visual Studio 2008 to modify and create new windows.

? Designed GUI using ASP.NET, HTML, CSS, and Bootstrap.

? Application Logic was implemented using Microsoft .NET Framework powers with CLR and Object oriented Programming Concepts like Encapsulation, Polymorphism and Inheritance.

? Generating Weekly reports using Crystal Reports to track the hours worked by employee.

? Worked with C# codes and XAML to modify and developed new functionalities.

? Used generics for optimization and LINQ to query object collection.

? Applied Bootstrap popup window to display details of the account information

? Implemented Ajax Form to support partial refresh of the page.

? Used LINQ to SQL queries to perform CRUD operations on data in SQL server inside repository layer

? Wrote C# code using Lambda Expression, Auto-Implemented Properties and other features of C# 3.0.

? Modify nHibernate mappings to work with business entity.

? Worked with WCF Data Contract used to serialize and de- serialize objects.

? Resolved Security issues like Cross site scripting and SQL injection in existing application

? Modify and wrote new SQL Server 2008 stored procedure.

? Implemented jQuery slider to implement range filters inside finding service page.

? Used SQL Server Profiler to monitor executed SQL statements.

? Used TFS version control system for data maintenance

? Wrote technical documents with screen shots to explain new enhancements.

Environment: SQL Server 2005/2008, SSIS, SSRS, Visual Studio 2008, C#, CSS, JavaScript, Bootstrap, HTML, MS-Excel, ADO.NET, Entity Framework, .NET, AGILE.

Polaris Software Lab, Chennai, India Jun 2007 - Jul 2009

Client: Merrill Lynch, NJ

Role: C# Developer

Project: MLTrac and GFDM WCF Services: MLTrac, Merrill Lynch Tables and Rules Assessing Commissions, and GFDM, Global Financial Data Model, WCF services are used to retrieve real time data from DB2 and modify CDCP field mapping to extract current holding information for Redemption and Exchange order entry from MLTRAC and LPS for converted fund products. Technologies used are .Net Framework 3.5, C# and DB2 using DB2Connect.

Responsibilities:

? Defined the design pattern, object -orientation and re-usability strategy for the application.

? Used User Control for re-use. Used collection for populating grids and list boxes.

? Integrated UI with Java server side web services.

? Created and modified business tier functionalities using Inheritance and Polymorphism.

? Used Multi-Threading to process multiple tasks.

? Optimized database by evaluating tables and creating indexes and db relationship

? Designed, created and tested Reports using MS Reporting Services. Scheduled reports to send daily e-mails with excel attachment-using database driven data.

? Performed Unit testing and Integration testing and supported System and UAT testing team.

? Wrote technical documents and created database model diagrams.

? Designed and developed .Net WCF services using .Net Framework 3.5, C# and VS 2008

? Created DB layer and Business layer API to encapsulate business logic using OOP.

? Coordinated with various DB2 teams to develop new stored procedures.

? Worked with IF, Integrated Framework, to design and develop services using IF.

? Created WixGen script to create MSI and used TFS for new build.

? Used Java Script for Client Side Validations.

? Assisted team (including off shore) to consume services.

? Prepared Product Profile and Installation guide.

Environment: SQL Server 2005/2008 Enterprise Edition, SSMS, JQuery, ADO.NET, HTML, CSS, MS PowerPoint, Visual Studio 2005/08.

EDUCATIONS:

Master in Computer Science - LONG ISLAND UNIVERSITY, Brooklyn, NY

MBA Finance - Sikkim Manipal University, INDIA

Contact this candidate