Sql Server .Net

FAIZ S

802-***-**** / *******.*****@*****.***

SUMMARY

.Net Project Lead/developer with over ten (10) years of experience in software design and development with more than five years as a team lead

Proficient in Microsoft Technologies (.NET framework, Visual Studio, C#.NET, VB.Net and the SQL server etc.)

Experience with project development in Waterfall and Agile models

Experienced in managing teams of up to ten

Experienced in developing client/server, Web-based applications and Windows application using .NET Frameworks

Hands on knowledge of distributing application development using .Net Web services and WCF

Strong background in ASP.NET, MVC framework, ADO.NET, LINQ and entity frameworks.

Experience in JavaScript, JQuery, HTML, CSS, Bootstrap and AJAX

Worked on configuration management tools such as VSS, SVN and TFS

Proficient with SQL Server and Oracle

Excellent communication, integration, negotiation and leadership skills

Experienced in coordinating onsite-offshore sites

Good working knowledge of T-SQL and SQL Server Reporting Services (SSRS)

Experience in Test Driven Development (TDD) and Unit testing using NUnit

Coding experience with solid principles, ReSharper, Autofac and Appistry

Worked with build tools, for example, Jenkins

Working experience with tools like Rational Team Concert, UDeploy, Service Now, Tidal Job Scheduler

EDUCATION

B.Tech, National Institute of Technology, Rourkela, India

SKILLS

Operating Systems

Windows

Databases

SQL Server, Oracle

Tools & Skills

Oracle SQL Developer, TOAD, VSS, TFS, SVN, Visual Studio, .Net framework, Open text Process360, ReSharper, Jenkins, Autofac, Appistry, Log4Net, Infragistics, Jira, Rational Team Concert, UDeploy, Service Now, Tidal Job Scheduler

Software Skills

VB.NET, C#.Net, VB 6.0, ASP.Net, ADO.Net, WCF services, .NET Web Services, MVC framework, JavaScript, JQuery, LINQ, SSRS, SOLID principles, Entity Framework, WebAPI, AJAX, HTML, CSS, Bootstrap, Oracle PL/SQL, T-SQL

Domain Knowledge

Insurance, Reinsurance & Publishing

Project Development

Waterfall, Agile (SCRUM)

EXPERIENCE

Apr ’16 – current .Net Project Lead, CDPHP, Albany, NY

CDPHP manages patient information and maintains different applications to store, and process patient data. There are already existing applications which are in maintenance mode: we developed new applications and batch jobs were assigned to accommodate new business requirements.

Responsible for end to end project execution

Held requirement gathering sessions with client

Provided project estimation and planning

Documented project progress and team activity on a daily basis including offshore activities

Responsible for coding, Unit and Integration testing and reviewing the application modules

Created web applications and batch jobs with C#, ASP.Net, MVC, .Net Web Service, WCF, JQuery, Bootstrap, HTML, CSS etc

Wrote UNIT test cases using Visual Studio unit testing

Wrote Oracle stored procedures and packages for complex business functionality

Wrote stored procedures and functions in SQL Server

Used NInject DI to inject the dependent objects into the constructor of the class, which will help in mocking the objects for unit testing purposes

Resolved issues with automated builds configured in Jenkins for application deployment in non-production environment

Used tools like Rational Team concert for creating tasks and maintaining project status

Employed Service Now for creating Requests for deployments and releases

Used UDeploy to deploy application in different environments

Analyzed and fixed any bugs raised in QA/UAT/PROD

Managed a team of 6 people working offshore

Environment: C#.Net, ASP.Net, Microsoft Enterprise library, LINQ, MVC framework 4, .Net framework,4.5, JavaScript, JQuery, SVN, Visual Studio 2013, NInject, Log4Net, AJAX, HTML, Bootstrap, SQL Server 2008, Oracle, Windows 7 and Windows server 2008

Aug ‘15 – Apr ‘16 .Net Project Lead, State Street, Kansas City, MO

This is a real time back office Web application that is used by multiple user groups for all pre trade processing of hedge funds by the buy side firms. The application requires continuous maintenance. It deals with order capture, trade processing, pricing, fund maintenance and reporting of the hedge funds booked. The development was done in agile environment with scrum

Managed a team of eight people including onsite and offshore

Took ownership of the project delivery for each iteration done on agile methodology

Gathered requirement sessions with the client

Estimated story and planning

Kept track of the project progress and team activity on a daily basis including offshore.

Coded, tested and reviewed the application modules

Worked on implementing new components in the existing application using MVC patterns, Entity Framework and JQuery

Worked on refactoring the existing code blocks to make it simpler for future enhancements

Worked on enhancing the performance of the application by optimizing the logics and reduced DB calls etc.

Worked on implementing WebAPI services for integrating it with other companion applications

Worked on the user stories by creating unit test cases and then implemented the same.

Implemented logging for the WebAPI service requests using log4net

Used Autofac DI to inject the dependent objects into the constructor of the class, which will help in mocking the objects for unit testing purposes

Resolved the issues encountered during the daily regression test runs

Worked on resolving the issues with automated builds configured in Jenkins for application deployment in the non-production environment

Analyzed the business requirements by constantly interfacing with the BA team

Participated in the user story estimation and grooming sessions before iteration

Participated in three way communications (BA, DEV and QA) before working on the user stories

Participated in the Iteration Retrospective meetings post completion of the iteration

Environment: C#.Net, ASP.Net, MVC framework 4, LINQ, SOLID principles, .Net framework 4.0, JavaScript, JQuery, Entity Framework, Autofac, Appistry, Web API, Log4Net, AJAX, HTML, CSS, SVN, Visual Studio 2013, Jenkins, ReSharper, SQL Server 2008, Windows 7 and Windows server 2008

Jan ’14 – Jul ’15 .Net Lead, XL Re, Stamford, CT

This application was used for evaluating and managing the risks for catastrophes all over the world. The services also returned analysis results for a location which was required for accessing the risks for reinsurance. This is a three tier architecture and Windows based application that was developed in C#.Net that was used for catastrophic data modelling. The back end is SQL Server 2008. There were services written in WCF for communicating with third party vendor data. The Microsoft enterprise library was used for logging, caching and exception handling. There is also another Web application written in MVC (with C#) as front end with the WCF service as a middle tier and SQL Server 2008 as back end. This application was used to interact with the third party vendor systems to fetch catastrophic risk analysis data. The development was done in agile model.

Gathered requirements, impact analysis and estimations

Met with the clients to discuss the project plans, tasks, issues and growth

Coordinated and managed up to six employees at offshore for project tasks

Designed, coded, code reviews, unit testing, integration testing and regression testing etc.

Developed applications with the WinForms in C#.Net.

Used LINQ for connecting to the database

Created WCF services for connecting to the third party DLLs.

Developed Web application in MVC for testing the WCF service

Wrote DB scripts in the SQL server 2008

Deployed and tested the applications on the development environments

Environment: C#.Net, WCF Services, Microsoft Enterprise library, LINQ, MVC framework 4, .Net framework,4.5, JavaScript, JQuery, TFS, Visual Studio 2013, SQL Server 2008, Windows 7 and Windows server 2008

Apr ’11 – Dec ‘13 Technology Lead, ING Americas, West Chester, PA

This application is based on imaging and work flow model used to handle scanned images for the fixed and variable annuity application. Here scanned images are imported and processed through the .Net web application and DLLs. The work flow of these images can be found out by Open Text Process360 maps. The scanned images are processed as per these maps and finally archived in to a central location. The data was also stored in the Oracle database. There are also other .Net tools/applications developed for retrieving the data and images from the database and central image locations. There are major and minor enhancements done to this application.

Gathered requirements and analysis at the client locations

Discussed the project tasks, issues and growth with the clients

Coordinated with the offshore teams for project tasks

Coded and tested (unit testing, integration testing and system testing)

Wrote .Net DLLs with VB.Net

Created .Net Web service for the database operations

Created a new Web application with C#.Net for fetching annuity images

Developed/enhancing the Stored Procedures, Views, Functions and DB scripts in Oracle using the Oracle SQL developer

Deployed and tested the application on the development environment

Coordinated with the QA teams on behalf of the development team

Environment: VB.NET, C#.Net, Oracle PL/SQL, ASP.Net, ADO.Net, .Net Web Services, .Net Framework 3.0, Oracle SQL Developer, VSS, Open Text Process360, Visual Studio 2010/2012, Oracle, Windows XP, Windows Server 2003/2008

June ‘09 – Mar ’11 Technology Analyst, Axis Capital, Bhubaneswar, India

CWS is a claim handling system. It is a .Net application delivered via Citrix Metaframe designed to streamline the handling of claims processing. CWS was implemented to create an environment where the claims would be handled more efficiently and met the client’s organization's goals to reduce claim redundancy thus, improving claims outcome and customer service. This is a Windows application developed in VB.Net at front end and Microsoft SQL Server at back end. Microsoft reporting services (SSRS) were used for reporting purposes.

Gathered requirements and analysis

Designed, coded and tested (unit testing, integration testing and system testing)

Developed the application with VB.Net

Developed/enhanced the Stored Procedures, Views, Functions and DB scripts in the SQL server 2005

Developed/enhancing the CWS reports using the SQL server reporting services

Interfaced with the clients to discuss requirements and provided the details of the changes made

Environment setup in DEV and INT

Deployed and tested the applications on the development and Integration (INT) environment

Environment: C#.NET, ADO.Net, ASP.Net, .Net Web services, .Net framework 2.0/3.5, T-SQL, VSS, Visual Studio 2003/2005/2008, SQL Server 2005, Windows XP, Windows Server 2000

May ’06 – May ’09 Software Developer, Underwriter Laboratories, Bangalore, India

Service Desk is a Web-based tool used to manage users across all of the databases. The tool was used to create new users, grant access rights to the users, revoke rights from the users and delete users. It is also used to delete the terminated users from all of the databases. The tool also allowed synchronizing the passwords over all of the databases. Only the administrator had the right to perform the above functionalities. The general users were able to view the roles of the users in the various applications.

The tool was used to manage users of Lotus Notes and Active Directory. The tool allowed the user to register a new user in Lotus Notes and Active Directory, deleted the user from Lotus Notes and Active Directory and edited the details in the Active Directory user. The tool was also used to configure Lotus Notes mail servers, active directory home folders, Lotus Notes registration configuration settings and location details. The application was developed from scratch.

Gathered requirements

Developed Web forms and Web services in .Net

Developed the Stored Procedures in SQL server 2005

Interfaced with the clients to discuss the requirements and provided the demo of the application

Environment setup in DEV, UAT and Prod

Deployed and tested the application on the development and production server

Environment: C#.NET, ADO.Net, ASP.Net, .Net Web services, .Net framework 2.0/3.5,VSS, Visual Studio 2003/2005/2008, SQL Server 2005, Windows XP and Windows server 2000

Contact this candidate