Resume

Sign in

Sql Server Software Engineer

Location:
Tracy, California, United States
Posted:
July 11, 2019

Contact this candidate

Resume:

PINKI S NAIR

510-***-**** ac9sx0@r.postjobfree.com

EXECUTIVE PROFILE

Maintaining and improving the integrity of production and quality systems through the machines, equipment, processes, and employees that add business value to an organization and coordinate the technical and business team based on the business needs/requirement.

SKILL HIGHLIGHTS

Leadership/Communication Skills

Web Development

Self-Motivated

Client-oriented

Data Analysis

Training and Development

Exceptional Interpersonal Skills

Innovative

Problem Resolution Ability

Banking experience (worked in Wells Fargo-Fraud Management Application Development)

PROFESSIONAL SUMMARY

10 plus years of experience in software development. Extensive experience in Web based applications, Development and Implementation of various Client/Server and Internet/Intranet applications and 5 years of work experience in creating and designing SSIS packages and Reports.

2 years of Lead experience in recruitment/training/coordination between the technology and business team to maximize productivity.

As a lead developer I planned the work/user stories for the team in each sprint, also provided technical solution for production issues and restructure/rewrite some modules using latest technologies such as Angular JS and bootstrap.

Good Domain Knowledge in the field of Banking, Insurance, Financial

Experience in team coordination and product enhancement based on the business needs.

Initiating project, Managing technical process and team along with my development skills.

Skilled in the use of SSIS, SSAS and SSRS.

Involved in Backup and Restoring the Databases.

Experience in design and development of cutting - edge Enterprise Applications using ASP.Net, C#, Web Services, SOAP, WCF, SQL Server, VB 6.0, jQuery, Java script, CSS, HTML, DHTML, ADO.Net, Entity Framework, Bootstrap.

Aware of the Modern software development models and theories, such as the object-oriented programming (OOP) model and event driven programming.

Excellent Communication Skills in both technical and business terms. Can motivate and help others for a highly productive development environment.

Experience in combining technical and analytic skills in the design and development of high-end Internet applications.

Excellent analytical, problem-solving and documentation skills and involved in the entire SDLC life cycle design and implementation.

Strong development skills in n-tier Applications using Microsoft Technologies and good competence in handling Software projects.

Created Web Services to fetch data from an application database to another application database, thus process the business logic.

Creates the entire application using MVC architecture for an insurance client for the online quoting web portal.

Got agile methodology training when working for the client Capital Insurance Group, Monterey.

EDUCATION

Master’s in computer applications (MCA), Madurai Kamaraj University

Bachelor of Science (BSc), Calicut University

TECHNICAL SKILLS

Programming

C#.Net 2.0/3.5/4.0, ADO.Net Entity Framework, VB 6.0, C++

Web Development

ASP.Net, HTML, jQuery, JavaScript, CSS, LINQ, Generics, Angular JS 1.0, Dependency Injection, Bootstrap, WCF and Web Services, SOAP, RESTful WCF, Json/XML

Databases

SQL Server 2012/2014, MS Access

Dev tools and services

Visual Studio, Visual Studio Team Services (VSTS), SVN, Team Foundation Services, GitHub,

Testing Skills

Unit Testing, Integration testing

Domain Knowledge

Finance, Health Care

Methodology

Agile Methodology

Waterfall Methodology

PROFESSIONAL EXPERIENCE

5/2018 to till date

Client: Albertsons Companies, Pleasanton CA

Senior Programmer Analyst

Ecommerce: VPOS/ECHO/OSPG:

Maintenance and Enhancement on VPOS (Virtual Point of Sale) Application. Creating Web API services for cloud Environment for connecting to cloud based online shop site and to Azure Database

Responsibilities:

Designing and Developing Web application using Restful Web API

Services.

Utilized SQL Server 2012 as a back-end database server and creating

stored procedures.

Involve in the discussions with management and business team to list

out the requirements.

Adding new feature or functionalities to existing Applications.

Environment: Visual Studio.Net 4.5 (ASP.NET MVC5, C#)

SQL SERVER 2012, Git Hub, Web API

ECHO: eCommerce Customer Helpdesk and Operations, this is an internal application developed for Customer Support.

Worked on the enhancement of this application, both on UI as well as back end

Environment: Eclipse, Java, jdk 1.8, Angular JS, Spring, JavaScript

Ecommerce: Shop Site Application

Shop site is a website application for placing orders for delivery /store pick up. This application communicates with other internal application like Enterprise Order Management, Virtual point of sale through service call. Customer can select the store, delivery time/slot, pick up time and add delivery notes, if needed.

Environment: Visual Studio.Net 4.0, ASP.Net MVC, SQL SERVER 2014, GitHub, jQuery, Java Script, Restful Web API, JSON

12/2016 to 04/18

Client: Wells Fargo, San Francisco, CA: Banking & Finance

Lead Web Developer/Database Analyst (Full Stack)

1)ACS (Automatic Candidate Selection)

ACS is an engine created to select the customers/candidates for each waves/events of a project. Project team decides which customer goes to each wave. Based on the project team decision criteria develops and then the engine select the customers based on the criteria. Waves are categorized as Criteria, Mixed and Batch.

Responsibilities

Co ordinating the technical team process based on the business requirement.

Understanding the benefits of the product and analyses and design based on the business needs.

Coordinate with the technical team to start the process

Keep track of the progress, troubleshooting the roadblocks in the development

Environment: Visual Studio.Net 4.0, ASP.Net MVC, SQL SERVER 2012, TFS, jQuery, Java Script, Entity Framework, LINQ

2)Dual Custody

Dual Custody is one of the most effective fraud deterrents in a layered security approach. Dual Custody UI helps Customer Service officers to record customer /client responses related to conversion of Single custody features/products to Dual Custody.

Responsibilities

Co ordinating the technical team process based on the business requirement.

Understanding the benefits of the product and analyses and design based on the business needs.

Development of the entire application, front end as well as Database designing and structuring for the application.

Keep track of the progress, troubleshooting the roadblocks in the development

Client-side validation using JavaScript and Regular Expression

Environment: Visual Studio.Net 4.5, ASP.Net, ADO.Net, SQL SERVER 2014, TFS, jQuery, Java Script, Entity Framework

Database Tech Refresh:

I also participating in coordinating tech refresh job such as remodifying SSIS packages in more easy and simple way, upgrade the server /SSIS packages to higher versions.

10/2015 to 11/2016

Client: Alameda County: ITD Oakland, CA

Lead Senior Software Developer

1)WDT (Workload Distribution Tool)

The Workload Distribution Tool (WDT) will function as a case action notification and tracking system, providing for the automated assignment of case actions (tasks) to notify a user (Clerical, Worker or Supervisor) that specific actions are required.

Responsibilities

Designing and Developing Asp.net 4.5 and C# and SQL Server 2012.

Create UI and code behind functionalities in C# and client side validation using JavaScript.

Used Asp.net, jQuery and CSS to design UI pages

Leveraged SQL Server Reporting Services 2012 (SSRS) to generate reports based on different search criteria.

Wrote complex stored procedures in SQL Server 2012 for automatic case action assignment to workers.

Involved in configuring IIS.

Utilized SQL Server 2012 as a back-end, used T-SQL to create.

Developed the application using MS.NET Framework 4.0 mainly Web Forms.

Utilized various technologies such as ADO.NET, CSS, HTML5, jQuery and Web controls, Ajax toolkit controls.

Used Java script for client side validation to improve the performance by reducing the post back to the server.

Responsible for Deployment of the project.

Created scheduled task creating Visual Studio Console Application as well as SQL script.

Created Linked server to connect with Oracle DB from SQL to retrieve data from Oracle to SQL.

Environment: Visual Studio.Net 4.0 (ASP.NET, C#, ADO.NET), WCF, Web Services, SQL SERVER 2012, SSRS, TFS, AJAX, T-SQL, CSS, XML, JSON, jQuery, Java Script, Linked Server

03/2014 to 09/2015

Client: Wells Fargo, San Leandro, CA: Banking & Finance

Lead Senior Web Developer

1) WFRD Dashboard Monitor

Dashboard Monitoring System provides all the application status, database status of web-based applications and also provides all server database status and related jobs status of each database.

Responsibilities

Designing and Developing Asp.net 4.0 and C# with the back end as SQL Server 2008.

To create responsive UI using bootstrap.

Used jQuery 1.11 and CSS to design UI pages

Leveraged SQL Server Reporting Services 2008 (SSRS) to generate complex reports.

Used Team Foundation Server as a version control tool.

Wrote complex stored procedures in SQL Server 2008 using T-SQL.

Involved in configuring IIS.

Implemented Form Authentication to authenticate the users.

Utilized SQL Server 2008 as a back-end database server, used T-SQL to create stored procedures, created database tables and constraints, and performed all the database related tasks from the Visual Studio Development environment.

Developed the application using Microsoft .NET Framework 4.0 mainly Web Forms.

Utilized various technologies such as ADO.NET, CSS, HTML5, JQuery, Bootstrap, LINQ and utilized various web controls.

Used User controls and Navigation features of ASP.NET 4.0.

Utilized various validation controls, used regular expressions performed custom validations and created various validation groups.

Used Java script for client side validation to improve the performance by reducing the post back to the server.

Responsible for Deployment of the project.

2) GLVariance

GLVar is a report generating web based internal application. Business users can generate different type of reports of selected year or month.

3) WALM (Wholesale Assessment of Liability and Maintenance)

WALM is mainly using for the employee reward program. This is an internal web based application.

Responsibilities:

Maintenance and Enhancement of GLVar and WALM applications in Asp.net 3.5 and C# with the back end as SQL Server 2008.

To fix IE11 compatibility issues

Used Team Foundation Server as a version control tool.

Involved in configuring IIS.

Utilized various technologies such as ADO.NET Entity Framework, CSS, HTML and utilized various web controls to make the applications compatible to IE11

Used User controls and Navigation features of ASP.NET 3.5.

Responsible for Deployment of the project.

Environment: Visual Studio.Net 4.0 (ASP.NET, C#, ADO.NET), WCF, SQL SERVER 2008, TFS, T-SQL, CSS, JSON, Angular JS 1.0, jQuery, Java Script, Bootstrap

10/2013 to 03/2014

Client: Capital Insurance Group, Monterey, CA

Programmer Analyst

Online Quoting System:

CIGLive Online Quoting system is generating online quote for the client, based on the information they are entering to get the quote from the system. Quote will be sent to the client by email. Quote holds the information about the coverage and generates the premium and discounts for the client.

Responsibilities:

Designing and Developing Web application using Visual Studio.Net, Asp.net MVC3, C#, JavaScript, jQuery, JSON, HTML and CSS.

Responsible for Configuring and developing Windows Communication

Foundation (WCF) which exchange data between the Client and the services.

System exposes all the data/content through a WCF service hosted in IIS.

Involved in all the phases of the SDLC life cycle of the project.

Utilized SQL Server 2008 R2 as a back-end database server and created

stored procedures, creating database tables and constraints and performing the entire database related tasks.

Created complex Stored Procedures and Triggers by Optimizing Queries for a better performance and eliminate all direct SQL calls.

Leveraged Masters Pages, AJAX across the application.

Involve in the discussions with management and business team to list out the requirements.

Environment: Visual Studio.Net 4.5 (ASP.NET MVC3, C#, ADO.NET), WCF, LINQ, SQL SERVER 2008, TFS, AJAX, T-SQL, CSS, XML, JSON, jQuery, Java Script.

10/2011 to 09/2013

Client: Dollar Thrifty Automotive Group, Tulsa, OK

.Net Developer

Violation Processing System:

Violation Processing System handles tickets, tolls & violation details of the vehicle rented out by Dollar Thrifty which is sent by the municipality to Dollar Thrifty corporate office located in Tulsa, OK.

Responsibilities:

Developed application using ASP.NET, C#, WCF, ADO.NET, CSS, HTML, jQuery and JavaScript.

Wrote complex stored procedures, triggers, User defined functions in SQL Server 2008 using T-SQL.

Developed Windows Communication Foundation (WCF) which is consumed by external applications.

Actively involved in the creation of n – tier applications.

Involved in Unit Testing.

Developed application using Microsoft .NET Framework 4.0 mainly Web Forms.

Leveraged SQL Server 2008 as a back-end database, T-SQL to create stored procedures, database tables and constraints.

Utilized JavaScript, Validation controls for validation.

Used jQuery as code behind for complex pages to improve the performance and to make WCF service calls.

Involved in configuring IIS.

Responsible for deployment of the project.

Used Team Foundation Server (TFS) for check in, check out, shelve, un-shelve etc.

Environment: .Net 4.0 (ASP.NET, C#, ADO.NET, WCF), SQL SERVER 2008, TFS, CSS, HTML, jQuery, Java Script.

05/2010 to 09/2011

Senior Software Engineer Sarvata Technologies, Bangalore, India

Professional Portal

This is an intranet application for Professionals like Doctors, Lawyers and Chartered Accountants. This portal provides data search, communication between the professionals from the same field, discussion forums etc.

Responsibilities:

Development of the professional portal application in Asp.net 2.0 and C# with the back end as SQL Server 2005.

Used Visual Source Safe as a version control tool.

Wrote complex stored procedures in SQL Server 2005 using T-SQL.

Utilized SQL Server 2005 as a back-end database server, used T-SQL to create stored procedures, created database tables and constraints, and performed all the database related tasks

Developed the Application using Microsoft .NET Framework 2.0 mainly Web Forms.

Utilized various technologies such as ADO.NET, CSS and utilized various web controls.

Environment:

Net2.0 (ASP.NET, C#, ADO.NET), WCF, SQL SERVER 2005, HTML, CSS, VSS, Java Script.

03/2009 to 05/2010

Senior Software Engineer: Sarvata Technologies, Bangalore, India

Chart Mover

The system will provide to store scanned patient information in to the database, which will eliminate the paper based coding and then transfer the patient logs and demography data to the US data center.

Responsibilities:

Designed the n-tier architecture.

Utilized SQL Server 2005 as a back-end database server, used T-SQL to create stored procedures, created database tables and constraints, and performed all the database related tasks from the Visual Studio Development environment.

Utilized various validation controls, used regular expressions performed custom validations and created various validation groups.

Involved in unit testing.

Environment: .Net 2.0 (ASP.NET, C#, ADO.NET), Win forms & SQL SERVER 2005, Java Script

07/2008 to 03/2009

Senior Software Engineer: Sarvata Technologies, Bangalore, India

Commercial Services

The commercial services system receives an order from the client via connection system, a web application. The objective is to automate the manual process of inserting the data into CS database by the CS staff. The data sent in the PDF format shall be converted to an XML file and will be stored in database automatically.

Responsibilities:

Consumed Web services.

Utilized various validation controls, used regular expressions performed custom validations.

Involved in configuring IIS.

Intensively worked with T-Sql queries in Sql Server 2005.

Developed stored procedures using SQL Server 2005.

Involved in unit testing.

Environment: ASP.net, C# 2.0, XML, SQL SERVER 2005.

01/2008 to 07/2008

Software Developer: Sarvata Technologies, Bangalore, India

Sales Information and Analysis

The project is to develop an information and analysis software to track and analyze the complete sales process.

Responsibilities:

Complete requirement analysis and as is system study of the company’s Sales process.

Prototype presentation and Design freezing.

Software development.

Involved in configuring IIS.

Unit Testing.

Environment: .Net 2.0(ASP.NET, C#), ADO.NET & SQL SERVER 2005

08/2007 to 12/2007

Programmer : Sarvata Technologies, Bangalore, India

Online Social Welfare System

This project was to develop a website for a non-profit charitable organization, which would help them raise funds through web and extend their services.

Responsibilities:

Development of application using Asp.net, C#,ADO.Net

Involved extensively in all the activities of the Software Development Life Cycle (SDLC).

Utilized SQL Server 2005 as a back-end database server, used T-SQL to create stored procedures, created database tables and constraints, and performed all the database related tasks from the Visual Studio Development environment

Presented Prototype model & Demonstration of the project.

Tested the Web Site - Functionality, Browser compatibility, Navigation, Security and GUI.

Environment: .Net 2.0 (ASP.NET, C#), ADO.NET, SQL SERVER 2005



Contact this candidate