.Net Developer Sql Server

Praveen Kumar

Senior Full Stack .NET Developer

Profile Summary:

Over 14+years of experience in Client/Server and Web Applications using Microsoft Technologies and .NET framework.

Worked on Financial Accounting Management System, Publishing domain, Health Care domain and currently working on Home Loan Origination System.

Expertise in Web-Development technologies like HTML, VB6.0, ASP, ASP.NET, C#, JAVA, J2EE, XML, XSLT, XSD, MVC, VBScript, JQuery, LINQ, JavaScript libraries & NodeJS, AngularJS.

Strong experience in creating/backup/restoring Database and writing SQL's, Stored Procedures, Triggers, Functions and Views on SQL Server 2005-2010 and PLSQL oracle.

Extensive experience on SOA-Service Oriented Architecture by creating services for data transfer/receive.

Strong experience with Microsoft Visual Source Safe (VSS), Tortoise SVN, TFS server and GitHub.

Strong experience in implementing various design pattern like as Singleton Design Pattern, Observer Design Pattern, Factory Design Pattern. Abstract Factory Design pattern, Facade Design Pattern and Dependency Injection.

Worked on Loan Sphere/Empower System tool of Black Knight Financial Service for home loan origination.

Extensive experience in configuration of fees, products and pricing for home loan origination.

Strong in the complete Software Development Life Cycle (SDLC) including requirements definition, design, programming/testing and implementation of major systems using waterfall.

Extensive experience of Nstein’s Technologies likes as Digital Assets Management System for maintaining assets and Text Mining Engine for creating metadata’s using linguistic analysis.

Extensive experience of Ixia soft Text ML server for central repository of Book and Magazine in XML format.

Integrated the Wave Corp Media Bank with our application using Chatter API to download metadata’s and images files.

Integrated the WordPress CMS using XML-RPC to send data to word press for web publishing and receive updated articles for synchronizations.

Created various data export techniques like as export articles in XML format, Word document & excel format, Kindle, Nook and e-Pub format.

Strong experience of Lucene to generates metadata’s and keyword to search articles fast.

Extensive experience in WCF, WPF, MVVM, Window Workflow and MVC design pattern.

Integrated LDAP with our application for authentication.

Integrated Microsoft Ajax Minify with Microsoft VSS to minify the Java Script and CSS files at web site building time.

Extensive experience with creating batch job and task scheduler in .Net framework.

Excellent skills in developing code for the database applications to interact with the databases, using ADO.NET, ADO and object-relational mapping using Entity Framework.

Strong experience in Troubleshooting, Diagnostic and researching production issue and fixing.

Extensive experience in handling Internet Information Server (IIS) and tomcat.

Strong experience in writing unit test cases using mock library and automation testing using UFT and spec flow.

Research-oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills

Technical Skill Expertise:

Programming Languages

C#, VB, ASP, SQL, PL/SQL, VB, Java, J2EE

Web/XML Technologies

HTML, DHTML, CSS, JavaScript, AJAX, ASP, JSP, DOM, XML, XSLT, XPATH, DTD, XSD, NodeJS and AngularJS 1.0 & 2.0

Frameworks

Microsoft .Net Framework, Entity Framework, Spring Framework

Tools & Utilities

Visual Studio.Net, Visual Interdev 6.0, Eclipse, Edit plus, SOAPUI Pro, Alfresco Server, Ixia Soft Textml Server, Lucene, Nstein DAM & TME, Crystal Report, Loan Sphere tool for Home Loan Origination, Unified Functional Testing, Spec Flow

Application/Web Servers

IIS Server, Tomcat & Web Logic server

RDBMS

MS SQL Server 2000, Oracle 9.x, MS Access

Source Control

Microsoft VSS, TFS, Tortoise SVN, Git HUB, IBM Clear Case

Design Patterns

MVC, Singleton, Factory, Abstract Factory, Facade and dependency injection

Operating Systems

Windows 9x/2000/XP

Virtualization

Amazon Web Services (AWS)

Professional Work Experience:

Client: Capital One, Plano, TX Sep '13 – Till Date

Role: Lead Developer

Project: Home Loan Origination System

Capital One Financial Corp. is a U.S.-based bank holding company specializing in credit cards, home loans, auto loans, banking and savings products. As a part of Home Loans origination process, scope of my services includes platform development, enhancement, maintenance, and production support.

Responsibilities:

Strong experience in development, and testing phases of software development life cycle.

Developed dynamic web application using ASP.Net MVC framework and angular JS.

Worked on building pricing and fees engine using C# and Microsoft Web API.

Involved in Implementation of .Net Workflow Foundation using WPF for creating workflow and rules to perform required activities in each work queue.

Strong experience in writing Store procedures, Functions, Views, Triggers using SQL 2010.

Good knowledge of home loan origination process from start application to final closing of loan and knowledge products, fees and rates.

Involved in implementation of various batch job processing using window services and PowerShell.

Involved in Implementation of orchestration engine to automate various activities like appraisal order, sending loan estimate and closing disclosure to buyer(s).

Following Agile ceremonies like as pre-grooming, grooming, estimation, planning, stand up, development, retrospective and show case work at end of each sprint.

Involved in implementation of various interfaces to integrate 3rd party services like as Equifax, Fannie Mie and Wolters Kluwer.

Extensively used of XML, XSLT and XPath to send and receive request from 3rd party interfaces.

Integrated google API like chart and google map using angular JS.

Worked on alfresco java application to integrate with .Net Application to upload documents and search documents using Lucene metadata’s.

Extensively used of SVN and Git-Hub for source control and versioning.

Strong experience in writing Unit tested using Type Mock and UFT & spec flow for writing automation test cases.

Environment: ASP.Net, C#, MVC, WCF, WPF, WF, MVVM Visual Stuidio.NET 2010, Java, Alfresco, SQL Server 2008, XML, XSLT, JQuery, Angular JS, BKFS Empower System, Spec Flow, UFT, SVN, AWS and Git Hub.

Client: US Bank, Irving, TX May '13 – Sep '13

Role: Senior .Net Developer

Project: Tracking ATM System

Independent Sales Organization (ISO). An ISO is a non-FI/bank company that owns or manages its own ATM portfolio and who usually offers a wide-range of services such as ATM equipment purchase, cash replenishment, and first-line maintenance to merchants who wish to have ATMs at their locations. With the help of this product customer monitors the terminal for in service, availability and performance. This product also displays the number of tickets that represent ATMs that need attention due to paper shortages, hardware problems, low on cash, etc. (still available for processing). In project has batch process which receives the raw data from base24 and creates the reports.

Responsibilities:

Strong experience in development, and testing phases of software development life cycle.

Involved in creating web site to manage ATM portfolio using ASP.net and JQuery.

Involved in Implementation of Middleware framework using entity framework.

Extensively used of window service to run batch jobs.

Involved in writing Store procedures, Functions, Views, Triggers using SQL 2005.

Strong experience in using telerik controls like grid and document processing.

Extensively used XSLT and XPATH for reports generation from XML files.

Implemented Log4net for logging mechanism

Involved in Unit testing using type mock

Environment: ASP.NET, C#, WCF, WPF, Visual Studio, SQL SERVER 2005, XML, XSLT, JQuery, Telerik Controls, HTML, CSS, Log4j and Clear Case IBM as source safe.

Client: BCBS, Chicago, IL Oct '12 – May '13

Senior .Net Developer

Project: Vantage Management System

Blue Cross Blue Shield (BCBS) companies have provided healthcare coverage to members in United States. BCBS provide the high quality of health insurance to individual, student and families. This project was developed to display the plans offered by BCBS using Obama care enrollment. I worked on web service to expose health plan offered by BCBS based on eligibility.

Responsibilities:

Involved in designing design dependency injection framework using .Net C#.

Involved in Implementation of middle layer using WCF to run business rules and show eligible plans.

Involved in writing Store procedures, Functions, Views, Triggers using SQL 2005.

Involved in Agile ceremonies like as pre-grooming, grooming, estimation, planning, stand up, development, retrospective and show case work at end of each sprint

Extensively used XSLT and XPATH to share data as par standard.

Involved in Unit testing using Moq.

Involved in writing business layer to validate request and data.

Environment: ASP.NET, C#, WCF, Visual Stuidio.NET 2010, SQL SERVER 2005, XML, XSLT, MOQ, Windsor Container and Dependency Injection pattern

Client: Reader’s Digest Association, White Plains, NY Dec '08 – Sep '12

Role: Senior .Net Developer

Project: Content e-library

Content e-Library is effectively used to manage and reuse the content which in itself, gets aggregated and syndicated in a centralized repository used by the application. The Content e-Library application makes use of Nstein’s Digital Asset Management (DAM) tool to import, store, aggregate, export and archive digital content in an effective and centralized manner. Content e-Library also makes use of Nstein’s Text Mining Engine (TME) which creates links between content assets and surrounds them with rich and relevant information, making it quick and easy for readers to find similar articles or learn more about related topics, people and places.

Responsibilities:

Involved in analysis & requirement gathering, feasibility study and preparation of technical documents.

Developed Application in C# (2.0), Database as SQL server 2005, Ixia Soft Text ML Server 4.1 for central XML repository.

Responsible for generating metadata’s and keywords by applying linguistic analysis tool (TME) and created indexes in Text ML server for searching article fast and efficiently manner.

Responsible for creating various export rules to export articles in different format like as XML, Kindle, Nook, ePub and word document format.

Responsible for Integrating various third party tool like Wave Corp. Media Bank, Word Press web application and Other Internal Content Management System using web services.

Designed & Developed UI & client side scripting/data validation using JS script and Jquery.

Log4net is used to exception and transaction logging.

Tortoise SVN is used for source control and version maintain.

Used CSS/HTML/DHTML for reach look & feel of User Interface

Developed Store procedure, Function, Views, Triggers using SQL 2005.

Integrated LDAP with our application for password authentication.

Unit tested application using Business/Functional Test Cases.

Closely work with QA team & release team.

Involve in Production support /Bug fixing & Release.

Environment: Nstein’s Digital Assets Management and Text Mining Engine, ASP.NET, C#, WCF, JQuery & JavaScript libraries, Ajax, Visual Stuidio.NET 2010, HTML, DHTML, CSS, SQL SERVER 2005, XML, XSLT, JSON, Mustache.js

Client: Edexcel, UK Sep '07 – Dec '08

Role: Senior .Net Developer

Project: Trident Online System

Edexcel is UK’s largest provider of work experience for learners aged between 14 to 16 years old. It helps schools to find work experience placements for its learners. I worked Employer Management and Employer Visit Management System. These modules cover functions like employer creation and amend, schedule the employer visit, create visit, employer accept and schedule appointment time.

Responsibilities

Involved in analysis & requirement gathering, feasibility study and preparation of technical documents

Developed Web Services for communication between businesses Layer & Data Base.

Developed n- tier architecture based data access components and business logic components using C#.NET.

Created/Modified Stored Procedures, Functions, Triggers and Views in SQL and effectively used within the application.

Created Test Case & Unit Testing.

Environment: ASP.NET, C#, ADO.NET, JavaScript libraries, HTML, DHTML, CSS, SQL SERVER 2005, XML, XSLT

Government of Rajasthan Jul '06 – Aug '07

Senior .Net Developer

Project: Integrated MIS System

This project was developed for government organization to computerized manual activities like as Personnel Information System, Financial Accounting and Payroll, Project management and Inventory Control System, Monitoring system, Operation and Maintenance and Management Information system.

Responsibilities

Involved in understanding their manual work, requirement gathering, analysis, prepares mock-up and prototype.

Developed Web Services for communication between businesses Layer & Data Base.

Developed n- tier architecture based data access components and business logic components using C#.NET.

Created/Modified Stored Procedures, Functions, Triggers and Views in SQL and effectively used within the application.

Created Test Case & Unit Testing.

Environment: ASP.NET, C#, ADO.NET, JavaScript & JavaScript libraries(JQuery), Visual Stuidio.NET 2.0, HTML, SQL SERVER 2000, XML, XSLT.

Delhi University Oct '05 – Jun '06

Senior .Net Developer

Project: SCCE Automation system

This project was designed and developed for university to computerize various activities like as Admissions, Examination, Cash and Enrollment, Printing of Course material, D& C Section, Dairy degree and PCP section, mailing section, general function like as Financial Accounting, Personnel Information System, Inventory Control System, Payroll and Library Management System.

Responsibilities

Analyze, design, develop, test and implement using Net, ASP.Net, and ADO. Net, HTML and Java Script.

Involved in Data base design from identifying entities, setting up relationship, done normalization to improve application performance.

Used Microsoft Enterprise Library Application Blocks for Accessing Data Base.

Environment: ASP.NET 2.0, ADO.NET, MS Visual Studio, XML, XSLT, Crystal Reports, JavaScript & JavaScript libraries, .Net Remoting, SQL Server 2005.

BHEL Apr '03 – Sep '05

Developer

Project: Financial Accounting Management System

The product was being developed in Java Struts, BEA Web Logic Server and Oracle 10g as database server. This application covers following functions like as Voucher Entry, Voucher Validation and Approval of Voucher, Cash Disbursement, Medical Claim Entry and Approval of Medical Claim, cheque printing and preparing of Ledger Book, Account Book and Trail Balance Statement.

Responsibilities

Responsible for creating various JSP pages to enter voucher and entry forms.

Worked on writing business logic to reconciliation of voucher entries.

Responsible for pull out data from old system and create a data file of each table.

Created various rules and validate them before ingestion to new system.

Create xml mapping between old system fields and new system fields.

Responsible for writing complex Oracle query and extensively used stored procedures, Views, User defined Functions in optimized way using indexes and profiler.

VSS is used for source control and version maintain.

Environment: Java Struts, JSP, BEA Web Logic Server and Oracle 10g, XML, XSLT, Crystal Reports, JavaScript libraries.

Moser Baer Sep '02 – Mar '03

Developer

Project: Customer Complaint Management System

The Moser Baer was largest CD manufacturer company and they need a system to log complaints raised by customer. The help desk team can track complaint and forward them to concern department for resolution. Once they have internal resolution then then can send email to customer for satisfaction.

Responsibilities

Analyze, design, develop, test and implement using ASP and VB script, HTML and Java Script.

Involved in Data base design from identifying entities, setting up relationship, done normalization to improve application performance.

Involved in developing the Business Layer, where all the Business Objects are written in developing the whole Application.

Completely involved in maintenance, module testing, unit testing and documentation.

Environment: ASP, VB Script, JavaScript & JavaScript libraries, SQL Server 2000

Educational Qualification:

Bachelor of Technology in Computer Engineering, Maharashi Dayanand University, India- 2002

Contact this candidate