Sandeep

adei3a@r.postjobfree.com

Phone: 469-***-****

Summary:

5+ years of experience with AGILE SCRUM and Waterfall and heavy involvement in all phases of Software Development Life Cycle (SDLC) such as planning, analysis, design, implementation, testing and maintenance of Web Based, Client-Server and N-tier Architectures.

Extensive Experience with ORM technologies like Entity Framework Database Model first and performance tuning in EF.

Proficient in developing application with .NET framework (1.1/2.0/3.0/3.5/4.0/5.2)) And associated technologies such as ASP.NET, ASP.NET MVC, and C #, ADO.Net, WPF, Web Services, WCF, REST, WEB API and Oracle, SQL Server 2005/2008/2008 R2/2012.

In-depth knowledge of complex T-SQL. Power user of advanced SQL queries with multi-table joins, group functions, sub-queries, set operations and functions.

Expertise in various JavaScript frameworks like AngularJS and Angular 4 along with HTML and CSS3.

Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.

Excellent knowledge of developing application using ASP.Net MVC framework to support clean Separation of Concerns and higher testability.

Familiar with creating Custom Reusable React Components Library.

Experienced in working with Node.JS and NPM modules like http-server, Marathon, inquirer, path, mongo DB, Micro Services, Request, Elastic Search, express, luck, spark and templating engines

Real time expert in working with integration and reporting services using SSIS and SSRS.

Comprehensive software development life-cycle experience with active involvement in requirements gathering, analysis, design, programming, testing and implementation.

Self-Motivated and a Team player with excellent communication and written skills with exemplary analytical and problem-solving skills.

Passionate about building high-quality systems with software implementation best practices.

Working knowledge in configuration and version management using Visual Source Safe (VSS), Clear-Case, Subversion (SVN), GIT, SourceTree and Team Foundation Server (TFS 2012/2010/2008/2005).

Raw JSON data is used as input for this project. Postman is used for RESTful API services

Extensively worked on developing applications using Azure.

Experience on Windows Communication Foundation (WCF), WinForms, and WEB API

Extensively dealt with code review for various projects and guided developers to develop an application with perfect coding standards, by writing efficient code, developing reusable components, exception handling, etc.

Proficient in using LINQ and Entity Framework mappers to interact with other layers.

Good hands on experience and knowledge of Entity Framework Db First and POCO classes

Extensive experience in developing and consuming XML Web Services using WSDL and SOAP.

Extensively worked on HTML/HTML5, XHTML, DHTML and CSS3 to design rich web pages.

Experience in designing and implementing Single page Application with Angular 8

Experience in developing data layer using Entity Framework, ADO.NET and LINQ

Expertise in developing ecommerce of Point-of-Sale (POS) Applications.

Extensively worked on Queries, Stored Procedures, Functions, Triggers and Views in SQL Server 2012/ 2008 R2/2008/2005 to access database.

Created a responsive website using Bootstrap

Experience in Writing MongoDB Schema using Mongos.

Developed applications leveraging ADO.NET, LINQ to SQL, Entity Framework.

Technical Skills:

Microsoft Technologies: .NET Framework (4.7.1/4.2/4.0/3.5/3.0/2.0), ASP.NET, VS.NET (2019/2017/2015/2014), ADO.Net, WPF, WCF, WinForms, MVC (4.0/3.0/2.0), Azure, Xamarin.

Languages: C, C++, C# (4.0/3.0/2.0). NET, VB.NET, VB 6.0, LINQ, Entity Framework, JavaScript, AJAX, Typescript, Angular JS, Angular 2+, React Js, Python.

Database: SQL Server 2017/2014/2008/2005/2000, Oracle 10g/9i/8i, SSIS, SSRS, MS Access, MYSQL, PL/SQL, T-SQL, MongoDB, Query Optimization, Stored Procedures, Triggers, Functions.

Web Technologies: XML, XSLT, XPATH, XSL, IIS (7.0/6.0/5.0), CSS, XHTML, SOAP, WSDL, XML Web Services.

Tools: VSS, TFS (2017/2014/2010), SVN, VS 2019/2017/2015/2013/2010, GitHub, Jira.

PROFESSIONAL EXPERIENCE:

Tesla--Fremont, California Oct 2019 to April 2020

Full Stack developer

Outbound Logistics involves moving Cars from the Factory to the distributed TESLA’s service centers and from there to customer’s location. This module essentially deals with Efficient Transportation and Seamless Delivery. This system will keep track of what car is going where and what’s the demand from each of the locations where the cars are being delivered to.

Project Name: Outbound Logistics Project

Responsibilities:

Involved in daily scrum meetings to discuss various aspects of the code, related to individual modules.

Worked in Agile Methodology and used GIT/JIRA for issue tracking and configuration management.

Created and Consume the WCF Services within the network

Utilized LINQ to SQL technology extensively to interact with the SQL Server database 2017

Utilized Angular 8 as the framework to build a single page Application (SPA).

Worked on REST/ WEB API to create methods and consumed in Angular services by HTTP call.

Use Database First approach with the Entity Framework to generate models and the DB-context.

Create stored procedures, user defined functions for better result in SQL Server 2017 database

Also work on adding new features to the application as per the business Requirements when needed.

Responsible to create Typescript reusable components and services to consume REST API's using Component based architecture provided by angular 8.

Responsible to create new web services and Web API’s using ASP. NET Core 3.1 with C#

Created services Angular 8 @injectable property, as to make the service available for dependency injection.

Writing LINQ expressions for access to filter data from the database.

Configure Azure cloud service for end point deployment.

Developed Python based API (RESTful Web Service) to track sales and perform sales analysis using Flask, SQL Alchemy and PostgreSQL.

Involved designing in web pages using HTML 5, CSS3, JavaScript, Bootstrap, SASS, LESS, React.js, Redux, Flex, Mongo DB.

Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS busines

Implemented the Drag and Drop functionality using React-Draggable

Integrates the UI with Database for data retrieval and manipulation using ADO. NET data objects and ADO. NET Entity Framework.

Experience with designing and implementing automated unit tests using XUnit, NUnit, or Visual Studio Test

Technology Stack: C#/.NET, .Net Framework 4.7.1, Entity Framework 6.0+, SQL 2017, MySQL, VS 2019, VS code 2019, GIT, SourceTree, Azure, ASP.NET MVC, CSS, Angular 8, Kendo-UI, React JS, Telerik Controls, Typescript, REST API, Python, Ajax, LINQ, Restful services, ASP.Net core 3.1.

City National Bank- Los Angeles, California April 2019 to Oct 2019

Full Stack developer

When settling for a “one size fits all” experience isn’t an option, prospective clients turn to City National Bank for solutions they know they can trust. City National’s clients-first approach ensures we get to know your particular circumstances and goals. This deeper client relationship allows us to provide the custom-fit solutions you have been looking for.

Project Name: CCAR” Project

Responsibilities:

Involved in daily Scrum meetings using Agile Methodology to meet customer expectation timelines with quality deliverables.

Designing database schema and tables in SQL Server Database. Creates Data Definition Language (DDB scripts. Runs and applies DLLs scripts to create the database schema and the tables.

Working on backend logic with Stored Procedures, Triggers and Views in SQL Server 2014 Database. Integrates user data in web applications with backend database.

Developed WCF Services to implement distributed applications with a Service Oriented Architecture.

Implement tools for Executives to change the business rules any time of the year.

Responsible for setting up the security and bindings for WCF services.

Use Entity Framework in the DAL to communicate with the database using LINQ to Entities provider.

Used C# programming language to program business logic with Object Oriented Programming concepts. Created class methods and uses inheritance, polymorphism and entity data model to read the data from core system.

Did the forward and backward data mapping between the fields in mainframe and FACETS.

Used AAD Graph API to programmatically access Azure Active Directory through REST API endpoints.

Fixes bugs raised by the Quality Assurance QA) team.

Use jQuery and JavaScript to implement AJAX calls and other type of client-side logic.

Developed new user interface components for different modules using Kendo UI with various controls including Grid controls, and chart controls.

Perform data transformations using SSIS (SQL Server Integration Services) via the Implemented enhancements for better performance.

Responsible for writing Unit Tests for the code developed.

Create Typescript reusable components and services to consume REST API’s using Component-based architecture provided by Angular 6

Worked in using React JS components, Forms, Events, Keys, Router, Animations and Flux concept.

Involved in designing and coding the various core components and UI Screens for the Outbound Interface in the Application using ASP. NET MVC, Angular6 and Kendo UI.

Proficient in using version control tool like Team Foundation Server (TFS)

Technology Stack: C#/.NET, Entity Frameworks, SQL 2014, VS 2017, TFS 2017, Azure, React Js, ASP.NET MVC, CSS, Angular 6, Kendo UI, Telerik Controls, Typescript, REST API, Ajax, LINQ.

NYC Department of Environmental Protection, NYC City, NY Dec 2018 to Mar 2019

Full Stack Developer

The Water Board maintains, in the interest of equity and fairness, that all customers should be billed for the services they receive in accordance with the rate schedules for water and wastewater services. In compliance with this policy, DEP will impose a Denial of Access (DOA) Administration Fee and will assess attributed consumption charges to a customer’s account when DEP is not permitted access to the customer’s water meter. DEP also intends to impose additional charges on customers who engage in theft of services TOS.

Project Name: TOS (Transportation of Service)

Responsibilities:

Involved in Requirement gathering, Design, Development and Testing of API. Involved in managing the client meetings, documenting the functional and business requirements.

Working with GitHub for Source Control allowing to host remote GIT repositories.

Developed Web API services and hosted with Asp.net MVC 4.0 application.

Building, testing and documenting applications with using C# programming language, Restful Services.

Developed REST architecture-based web services to facilitate communication between client and servers.

Developing various abstract classes, interfaces, classes to construct the business logic using C#, .Net targeting the business requirement.

Created and consumed API’s including 3rd parties and worked on the integration of the systems

Used Angular 6, JavaScript to develop templates controllers and directives.

Used JSON web token to do user authentication and secure information exchange

Worked on CSS Preprocessors like LESS and SASS and used front-end tooling workflows Node JS (NPM), Bower.

Created Typescript reusable components and services to consume REST API's using Component-based architecture provided by Angular 6.

Worked on Kendo UI Controls to support HTML5 Controls in all the browsers.

Developed data driven business logic using C# and SQL Server database

Used Entity Framework in the DAL to communicate with the database using LINQ to Entities provider

Assisted in the designing of database and also created database Triggers, Functions and Stored Procedures in SQL Server 2014 for ensuring data integrity.

Responsible for writing Unit Tests for the code developed.

Technology Stack: VS.NET 2017, ASP.NET 4.5.2, .Net Core 2.0, EF, MVC, JSON, jQuery, Angular 6, Kendo UI, WEB API, Restful Services, C#, MongoDB, NoSQL, SSIS, TFS 2017, GIT, LINQ, Azure.

Charles Schwab, Raleigh, NC Jul 2018 to Dec 2018

.Net Developer

Schwab is one of the largest banks in the United States as well as one of the largest brokerage firms in the United States. It provides services for individuals and institutions that are investing online and offers an electronic trading platform for the purchase and sale of financial securities including common stocks, preferred stocks, futures contracts, exchange-traded funds, options, mutual funds, and fixed income investments.

Responsibilities:

Involving in daily scrum meetings to discuss various aspects of the code, related to individual modules.

Use Agile Methodology (Scrum) to meet customer expectation timelines with quality deliverables.

Extensively using Application and page level tracing feature of .Net to trace and debug the code

Working with GitHub for Source Control allowing to host remote GIT repositories.

Building, testing and documenting applications with using C# programming language, Restful Services.

Develop, configure, deploy, program and implement software applications, servers, packages and components customized to meet specific needs and requirements

Updating activities and progress on assigned tasks.

Developed Web API services and hosted with Asp.net MVC 4.0 application

Implemented business logic/rules using WCF services and integrated with the UI components.

Developed REST architecture-based web services to facilitate communication between client and servers.

Built and maintained T-SQL scripts, indexes, and complex queries for data analysis and extraction

We have consumed and exposed Web Services using REST.

Involved in design & implement of the Brokerage internal system web app including several modules using MVC, Node.js, MongoDB, and Visual Studio Code.

Developing various abstract classes, interfaces, classes to construct the business logic using C#, .Net targeting the business requirement.

Worked with complex SQL queries, SQL joins and stored procedures for data retrieval and update.

Have developed WCF and RESTful Services by using C# and Web API

Used React JS for templating for faster compilation and developing reusable components.

Developing application using object-oriented design

Highly used Angular6 router to build single page application for navigates through the different status and multiple modals.

Accustomed in developing Client/Server (WinForms) and Web based (Web Forms, ASP.Net) application development.

Being involved in Unit testing, XUnit, Functionality testing, Integration testing and User Acceptance Testing (UAT) and involve in bug fixing.

Developed GUI using WPF Controls, Windows controls in .NET 4.0/4.5, VS.NET2012, C# and XAML

Build new API’s for banking transactions with Node.js and MongoDB

Technology Stack: VS.NET 2017, ASP.NET 4.5.2, EF, MVC, JSON, Responsive Design, jQuery, WEB API, WPF, WinForms, Azure, Restful Services, C#, MongoDB, React JS, NoSQL, TFS 2013, GIT, T-SQL, LINQ4.X, Splunk, XPath

CVS Health, Greensboro, NC Feb 2017 to April 2018

Full Stack Developer (.Net and Angular)

CVS Health is a one-of-a-kind health care company that helps patients get the care they need through the channel that works best for them. Each day, we help millions of people on their path to better health. This is our company’s purpose, and it’s the inspiration behind everything we do

Responsibilities:

Worked in Agile scrum methodology and delivered accepted functionality in each sprint

Involved in the requirement analysis and change requests

Participated in UI design using Angular 4, JavaScript and improved layout with HTML5, Bootstrap and CSS3

Involved in designing the pages with C#.NET, MVC5 and in Visual Studio .NET 2015.

Provided database connectivity using Entity Framework 6.0, LINQ designed Store Procedures and Views at backend

Worked on the web services and middle tier implemented in WEB API

Created and consumed API’s including 3rd parties and worked on the integration of the systems

Used Angular 4, JavaScript to develop templates controllers and directives.

Used JSON web token to do user authentication and secure information exchange

Responsible for debugging the code and bug fixing using C#

Optimized stored procedures which improved performance by ~25% in legacy WinForms applications

Extensively used WPF Telerik Controls for fast-paced development

Developed data driven business logic using C# and SQL Server database 2014

Work with parameters. Create T-SQL scripts for add/update/delete records from database by client request

Worked on WCF services using HTTP and SOAP protocol

Used a microservice architecture, with Spring Boot-based services interacting through the REST end points.

Used TFS 2015 for version control, user stories, tasks, bug tracking, build configuration.

Experience in Test-driven development using MS unit testing and N-Unit, xUnit.

Tracked and solved tickets for defects on bug reporting tool (ALM)

Mentored new team members to get in-line with work

Gave Client demos and interacted with Client’s Product Owner.

Technology Stack: VS.NET 2015, ASP.NET 4.7, EF 6.0, WPF, MVC, JSON, jQuery, Angular 2, Kendo UI, Typescript, WEB API, C#, ADO.NET, TFS 2013, GIT, SQL Server 2014, LINQ, T-SQL, SSIS/SSRS.

Bank of America, Plano, Texas Aug 2016 to Feb 2017

.NET Developer

Bank of America is a multinational banking & financial services corporation. It’s the second largest bank holding company in the United States by assets. My work here was as a .NET developer to work on the Small Business PIN On-Demand (POD) and MC Travel Rewards Product project.

Responsibilities:

Followed Agile Environment, involved in daily meetings.

Involved in the requirement analysis and change requests

Implemented logic in Stored Procedures, Functions, Triggers in SQL Server 2014 Database and also involved in performance tuning of SQL queries

Worked with OOPs and OOD patterns like Dependency Injection, Singleton, and IOC.

Performed data transformations using SSIS (SQL Server Integration Services) via the Implemented enhancements for better performance.

Worked on developing packages by using SSIS and developed various reports and sub-reports by using SSRS.

Used LINQ and Lambda Expressions to query the .NET objects and data interaction.

Integrated Outlook contacts and calendar into the application using Outlook COM library (WinForms).

Followed test driven development (TDD) and used Unit Testing while developing applications

Worked with ADO.NET Entity Framework 5.0, LINQ to integrate the database with the applications

Worked on MVC to build the web portal of the new system.

Worked with JSON, jQuery on the front end and Web API in the business layer.

Built a web service for the application using SOAP webservice methodology.

Involved in developing the requirement with C#, ASP.NET, WCF and Web services in .Net Technologies, unit testing, and system testing and release management.

Extensive knowledge of CRM industry standards and best practices

Responsible for debugging the code and bug fixing using C# 4.5

Developed data driven business logic using C# and SQL Server database 2014

Worked on the data processing modules and the logic for processing PDF files to database.

Used TFS 2013 for version control, user stories, tasks, bug tracking, build configuration.

Participated in code reviews using the TFS inbuilt features like Shelving.

Technology Stack: VS.NET 2015, ASP.NET 4.6, EF, WinForms, MVC, JSON, jQuery, WEB API, C#, ADO.NET, TFS 2013, SQL Server 2014, UML, LINQ, T-SQL, SSIS/SSRS.

CISTSOMAG, Hyderabad, India Mar 2012 to Mar 2014

.NET Developer

CISTSOMAG deals with the design, analysis, construction, servicing, and maintenance of physical structures like roads, bridges, railways, canals, dams, buildings, and etc. In general, deals with the overall interface of human-created fixed projects with the greater world. Generally, Civil engineers work closely with surveyors and specialized engineers to design grading, drainage, pavement, water supply, sewer service, dams, electric and communications supply. Basically, it’s referred to as Site Engineer.

Responsibilities:

Developed Software solutions to accommodate the business needs of the project.

Involved in the development Calculation Module used for various calculation purposes using C++. Used PL/SQL queries and procedures to resolve the production issues.

Unit testing of the developed components.

Involved in the design and development of various client and server applications/utilities which are used by polling system for different types of polls and users to get various reports and polling status using C++

Developed ASP.NET pages using Visual Studio 2003 and win forms using Visual Studio.

Coded in Data Access Layer, and Business Logic Layer using C#.NET and SQL Server in backend.

Designed and developed the application using Visual Studio 2010 and ASP.NET

Involved in developing ASP.NET Security, State Management, Caching and Encryption.

Developed data driven business logic using C# and SQL Server database.

Maintained ASP.NET Web services using VB.NET and C#

Implemented the business logic/rules using XML based web services in C# and integrated the ASP.NET web services with the solutions.

CAD software - Proficient in AutoCAD and intermediate in Solid Works.

Technology Stack: VS.NET 2015, ASP.NET 4.5, EF, WinForms, MVC, JSON, jQuery, WEB API, C#, ADO.NET, TFS 2013, SQL Server 2014, UML, LINQ, T-SQL, SSIS/SSRS.

Educational Details:

Bachelors in Osmania University- Hyderabad-India-2010

Masters in IT: 2016- Wilmington University-Delaware

C# and Asp.net MVC certifications in 2017

Professional references will be provided upon request

Contact this candidate