Sql Server Software Engineer
Resume:
PINKI S NAIR
510-***-**** *********@*****.***
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