Resume

Sign in

Sql Server Data

Location:
United States
Posted:
September 27, 2019

Contact this candidate

Resume:

Jayshri C Dalvi

adagrh@r.postjobfree.com

Mechanicsburg PA 17050

919-***-****

Full Stack Senior Developer, Bank of America

PROFESSIONAL SUMMARY:

●8+ years of experience in analysis, design, development, team handling of various Web, Windows Applications development

●Excellent programming skills and strong Object Oriented programming concepts in C#, ASP.Net.

●Good experience in browser technologies such as Html, CSS, JAVASCRIPT, jQuery. Node.js etc.

●Strong experience in designing and developing applications using MVC (Model View Controller).

●Experience in working with ASP.NET 4.0, 3.5, MVC 3, 4, Window Forms, Visual Studio .Net, C#, .NET Core Framework technologies.

●Experience leading distributed team of engineers located across the globe

●Experience working in Enterprise structure setups with experience interacting with design leads, project leadership, testing teams, Config teams etc.

●Experience in securing protocols such as SAML, oAuth etc.

●Good Knowledge on designing Restful Services using REST API.

●Good Knowledge on Splunk.

●Working knowledge with ORM framework using Entity Framework to automate database activities.

●Strong experience in working with decoupled architecture using MVC framework.

●Expert in MS Excel including pivot tables and formulas

●Experience in SOAP (Simple Object Access Protocol) web services over the SOAP client and Server using HTTP protocol.

●Strong experience working with SQL SERVER for maintaining the application Data and Querying the required data.

●Hands on experience in SSIS and SSRS technologies.

●Strong experience in developing front and back end applications using ASP.Net Model View Controller, VB.Net, Object Oriented principles, Team Foundation Server and N-tier architecture.

●Used SQL Server to create Stored Procedures, Triggers, and Views.

●Experience in finalizing system requirements, creating design documents - HLD, LLD, provide knowledge transfer sessions to business teams/testing teams/development team etc.

●Good experience programming with LINQ-to-SQL in data access layer for CRUD operation.

●Working Knowledge on Data Access Technologies Entity Framework, LINQ and ADO.NET.

●Knowledge with JSON and XML in ASP.NET Web API.

●Experience in DevOps with advance knowledge on Continuous Delivery, Continuous Integration

●Strong Understanding of Containers, Micro-Services technologies etc.

●Knowledge on Single-Page Web Application from scratch, leveraging Angular.js

●Good Knowledge on SDLC, Waterfall, Agile, Scrum methodologies.

●Good documentation skills and experience of designing using UML.

●Experience with developing GUI using web technologies like HTML, CSS, jQuery, JavaScript, and XML.

●Mentored and trained developers in past on multiple technologies and projects

●Excellent communication skills, interpersonal, strong architectural skills, hardworking and a very good team player and ability to effectively communicate with all levels of the organization.

TECHNICAL SKILLS:

Languages

VB.Net, ASP.NET, SQL and PL-SQL.

Core Technologies

.NET Framework 3.0, 4.0 & 4.5, ASP.NET 2.0/3.0, C#, VB.Net, ADO.NET, MVC 3/4, Win Forms, Web Services, LINQ, WCF, Web API, .Net Core, Entity Framework, oAuth API integration, Node.js, Java

Web Technologies

ASP, HTML, HTML5, Java Script, jQuery, AJAX, CSS, CSS3, Angular, Bootstrap, TypeScript, React

Database

SQL Server 2014/2012/2008/2005, My SQL, SSIS, SSRS Reporting

Protocols

SOAP, FTP, TCP/IP, HTTP

Application/Web Servers

MS IIS 8.0/7.0/6.0, WAS 8.1

Source Control

VSS, Team Foundation Server (TFS), Git, GitHub

Development Tools

MS Visual Studio.NET 2005/2008/2010/2012/2013/2014, Eclipse.

Operating Systems

Windows 10/8/7/Vista/XP, UNIX, Linux

Requirement Management Tool

TeamSpec, MS Word, MS Excel

UML Tools

Visio

Unit Testing Tools

MSUnit, NUnit

Build Tools

MSBuild

Defect Tracking Tool

HPE’s QC

Code Quality Tool

StyleCop, FxCop

Continuous Integration Tool

Jenkins

ALM Tool

TFS, VSTS

Other Tools/technologies

SOAPUI, Postman, SAML, oAuth, WebSphere MQ, Splunk

PROFESSIONAL EXPERIENCE:

Bank of America, Mechanicsburg, PA Sep 2017 –Till Date

Domain: Investment Banking

Role: Full Stack Senior Developer

DDI – Dynamic Data Interchange

DDI evaluates, correct and queues exceptions on loan portfolio and loan origination data for improved loan svs, DDI framework RE, Svs Adapts, UIs (Rules GUI, Daily Report and DDI Central). DDI process return mail address validation.

Escrow Analysis Systems

Escrow Analysis departments applications suite consists of the Escrow operations process, reporting and FHA Modifications – Mock Escrow Analysis, DOJ Modifications – Physical Escrow Analysis and FHA Modifications – Mock Escrow Analysis

Responsibilities:

●Led the distributed team of engineers located across the globe

●Involved in finalizing system requirements, created design documents - HLD, LLD, provide knowledge transfer sessions to business teams/testing teams/development team etc.

●Interacted with design leads, project leadership, testing teams, Config teams etc.

●Designed Graphical User Interface (GUI) using ASP.NET MVC4 and the business logic in C# [MVC Controllers].

●Created UML diagram, Sequence diagram, database design, and Class diagram using Visio.

●Used various JavaScript and jQuery libraries, AJAX for form validation and other interactive features.

●Developed code in JavaScript for client side validations

●Worked on building REST based Web Services with ASP.NET Web API.

●Worked in Agile Scrum Methodology and involved in daily sprint meetings.

●Translate digital & behavior specifications into efficient front end component using HTML5, CSS3, Bootstrap, JavaScript and jQuery.

●Responsible for redesigning and implementing new features for dynamic web pages for application using HTML5, CSS3.

●Create new tables, views, indexes and user defined functions.

●Actively designed the database to fasten certain daily jobs and some stored procedure.

●Created SSIS packages for File Transfer from one location to the other using FTP task.

●Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

●Create scripts for the testing for the deployment in lower environments using PowerShell.

●Migrating data from different data sources to SQL server database using SSIS.

●Worked on SOAP based web services, WAS 8.0, SOAPUI etc

Environment: SQL Server 2014, TFS, VSTS. Visual Studio 2015, ASP.NET MVC 4, C#.NET, .Net Framework 4.5, WCF, Entity Framework, Java script, jQuery, LINQ-to-SQL, JSON, HTML, IIS, CSS, Bootstrap, SOAP, SSIS, SSRS, REST based web services, XML, TFS 2010, SQL Server 2012, Jenkins, NUnit, oAuth API integration, .Net Core, Splunk, React.js, Node.js etc.

Infosys, Tampa, Florida Mar 2017 – Sep 2017

Client: PwC (Yellow & GFS)

Domain: Audit

Role: Technology Analyst

Yellow

Yellow is Interview organization tool, which helps PwC employees and Interviewee.

It contains information of PwC Employees which are going to take interview, and their availability and depending on available time slot for interview, it schedule interview for that interviewee.

In short it connects PwC Interviewers to Outside Interviewee.

GFS

PwC Ethics and Compliance: Designed, modeled and implemented Stage, Data Warehouse and Data Mart: tables, indexes, procedures, packages Developed PL/SQL packages to load Data Warehouse and Data Mart tables to satisfy the subscriber’s needs.

Responsibilities:

●Creating the models, views and controllers using ASP.NET MVC 2, C#.NET.

●Created partial views and shared templates to reusable over the application.

●Key player in requirements gathering and analysis, data gathering and analysis and project requirements for this application which is developed using scrum methodology.

●Played a major role in coming up with the business requirements for the project, the project plan and workflow.

●Designed Graphical User Interface (GUI) using ASP.NET MVC4 and the business logic in C# [MVC Controllers].

●Created UML diagram, Sequence diagram, database design, and Class diagram using Visio.

●Used ASP.NET MVC4, HTML5 and CSS3 to design the presentation layer of the website.

●Used Angular JS as the development framework to build a single-page application.

●Worked on building REST based Web Services with ASP.NET Web API.

●Worked in Agile Scrum Methodology and involved in daily sprint meetings using VSTS.

●Working on validating the model from both Client side and server side in ASP.NET MVC.

●Create new tables, views, indexes and user defined functions.

●Actively designed the database to fasten certain daily jobs and some stored procedure.

●Created SSIS packages for File Transfer from one location to the other using FTP task.

●Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

●Migrating data from different data sources to SQL server database using SSIS.

Environment: SQL Server 2014, Oracle 11G, TFS, VSTS. Visual Studio 2015, ASP.NET MVC 4, C#.NET, .Net Framework 4.5, WCF, Entity Framework, Java script/JQuery, LINQ-to-SQL, JSON, HTML, IIS, CSS, Bootstrap, SOAP, SSIS, SSRS, Rest based web services, XML, TFS 2010, SQL Server 2012, Jenkins, NUnit, VB.Net etc.

HPE, El Paso, Texas Dec 2016 – Mar 2017

Client: State of Nevada (MMIS)

Domain: Health Insurance

Role: Sr. Developer

MMIS is Medicaid Management Information System.

MMIS is used by Medicaid for claim processing, information retrieval and reporting purposes.

MMIS provides operational and system support for implementation of healthcare services for state.

This project contains different functional areas like Recipient, Provider, Claim, Managed care, Reference, Benefit Administration, Drug rebate, Financial, Third Party liability and Prior Authorization.

This application is developed in ASP.NET MVC, C#, JQuery, JavaScript, WCF and Entity framework with SQL Server as Database.

Responsibilities:

●Graphical User Interface (GUI) was designed using ASP.NET MVC4 and the business logic was coded in C# [MVC Controllers].

●Used various JavaScript and JQuery libraries, AJAX for form validation and other interactive features.

●Created UML diagram, Sequence diagram, database design, and Class diagram using Visio.

●Working on using JavaScript for client side validations

●Worked on building REST based Web Services with ASP.NET Web API.

●Working on writing stored procedures and functions in SQL Server.

●Working on Http methods for implementing a REST based Web Services.

●Used ASP.NET MVC4, HTML5 and CSS3 to design the presentation layer of the website.

●Involved in writing SQL Queries, Triggers, Views and Stored Procedures.

●Working on writing SQL Joins queries for combining data from tables in SQL Server

●Working on OOPS concepts like Polymorphism, Inheritance, Abstraction, etc. in C#.

●Developed stored procedures, Views and automated SQL, T-SQL scripts for database maintenance, deployment and installation.

●Created SQL queries to perform insert, update or delete operation on SQL Server database

●Worked on TFS Source control for managing the source code.

●Worked in Scrum Methodology and involved in daily sprint meetings using TFS.

Environment: Kentico 12.0, MMIS (Medicaid Management Information System), Visual Studio 2012, ASP.NET MVC 4, C#.NET, .Net Framework 4.5, WCF, Entity Framework, Java script/JQuery, LINQ-to-SQL, JSON, Ajax, HTML, IIS, CSS, Razor View Engine, SOAP, Rest based web services, XML, TFS 2010, SQL Server 2012, Jenkins, Visio, MSBuild, NUnit, HPE’s QC

Mars Medisciences Pvt Ltd, India Mar 2014 – Nov 2016

Client: Imax Hospital (ePulse Web Management System)

Domain: Healthcare and Hospital Management

Role: Sr. .Net Developer

ePULSE is an end to end solution for Hospital management. This is a web application having online access to patient for taking appointment online.

ePULSE has multiple modules such as Registration, OPD, IPD, HR, Inventory, Lab etc.

ePULSE web Management System is a web based application which is comprehensive enterprise-wide software, which covers all aspects of hospital management and day-to-day operations of a hospital. Accessibility of all information is role based.

Responsibilities:

●Created requirement document using MS Word and participated in Requirement Analysis, Requirement Finalization.

●Graphical User Interface (GUI) was designed using ASP.NET MVC4 and the business logic was coded in C# [MVC Controllers].

●Converted windows application to web application.

●Worked in all phases of Software development life cycle (SDLC) such as Requirement Gathering/Understanding/finalization, doing POCs, Design, Development, code reviews, Deployment/Integration as well as Production support.

●Used various JavaScript and JQuery libraries, AJAX for form validation and other interactive features.

●Worked on building REST based Web Services with ASP.NET Web API.

●Worked on writing stored procedures and user defined functions (UDF) in SQL Server.

●Worked on Http methods for implementing a REST based Web Services.

●Working on writing REST based Web services by applying REST architectural concept to web services.

●Used ASP.NET MVC4, HTML5 and CSS3 to design the presentation layer of the website.

●Developed components to fetch the data from the back end using AJAX and JQUERY.

●Involved in writing SQL Queries, Triggers, Views and Stored Procedures.

●Developed WCF Data services and consumed by MVC application.

●Working on Bootstrap, Authentication filter, Filter overrides, Attribute routing using ASP.NET MVC framework.

●Working on writing SQL Joins queries for combining data from tables in SQL Server

●Working on OOPS concepts like Polymorphism, Inheritance, Abstraction, etc. in C#.

●Working on validating the model from both Client side and server side in ASP.NET MVC.

●Created SQL queries to perform insert, update or delete operation on SQL Server database

●Worked on TFS Source control for managing the source code.

●Worked in Scrum Methodology and involved in daily sprint meetings.

Environment: Visual Studio 2012, ASP.NET MVC 4, C#.NET, .Net Framework 4.5, WCF, Entity Framework, Java script/JQuery, LINQ-to-SQL, Angular JS, JSON, Ajax, HTML, IIS, CSS, Bootstrap, Razor View Engine, SOAP, Rest based web services, XML, TFS 2010, SQL Server 2012, JIRA, Visio, NUnit, MSBuild and Jenkins.

Mars Medisciences Pvt Ltd, India Jul 2011 – Feb 2014

Client: Metlife Insurance

Domain: Insurance

Role: Sr. Developer

Core Elixir is an end to end solution for insurance domain. It is an insurance product comprises of different modules like New Business, Product, Underwriting, CMS, Finance and policy servicing which are developed on top of basic framework using SOA architecture.

Core Elixir Insurance Services program offers competitive pricing, outstanding customer service and benefits designed specifically for the customer. MetLife Insurance will allow assignment of payments to claims based on claim numbers policy account insured to do a final review of pending allocation.

Responsibilities:

●Creating the models, views and controllers using ASP.NET MVC 2, VB.NET.

●Created partial views and shared templates to reusable over the application.

●Key player in requirements gathering and analysis, data gathering and analysis and project requirements for this application which is developed using scrum methodology.

●Consumed the WCF services using JQuery Ajax calls to enable effective communication

●Extensively used Visual Studio 2012 development tool for building Web Application.

●Extensively used CSS and Java Script to create visually appealing User Interfaces.

●Developed the procedural code using ASP.NET, VB.NET, HTML, Ajax and JavaScript using Visual Studio.

●Extensively used JavaScript for client side validations in the views.

●Extensively worked on most of the data and validation controls in Visual Studio and also creating a variety of Dynamic Controls in the application supported by dynamic style sheets since there were quite some pages which were database driven.

●Members/employees where they can assist monitor and support their individual children.

●Developed and implemented custom Tracking and Error Logging mechanisms.

●Assisted in developing Tables, Triggers, Views, stored procedures and updating the SQL Server database and Optimized SQL Server Stored Procedures using join indexes.

●Assisted in the design and development of reports in SQL Server using SQL Server Reporting Services (SSRS).

●Designed, processed and displayed reports in the website using the Report Viewer web server control.

●Performed and resolved cross-browser issues, Unit Testing and Documentation along with N-unit testing.

Environment: .Net 3.5, ASP.Net MVC 2, C#.NET, ADO.Net, AJAX, JSON, HTML, JavaScript, CSS, MS Visual Studio 2012, Waterfall, SQL Server 2012, Crystal Reports, SQL Server Integrating Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, PL/SQL,Web Services.

EDUCATION QUALIFICATION:

●Bachelor of Computer Science from TPCP’s, India.

●Diploma in Information Technology from GPS, India



Contact this candidate