Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Jalalpur, GJ, India
Posted:
November 17, 2016

Contact this candidate

Resume:

Veerendra Karwekar

•Around **+ years of rich experience in design, development, unit testing and deployment of web and windows based applications, for different businesses and domains.

•Have expertise in ASP.NET, C#, WCF Web Services, T-SQL, PL/SQL, AJAX, XML, MVC4, JavaScript, AngularJS, jquery, UML, Design patterns, SQL Server Reporting Services and object-oriented analysis and design with programming.

•Have exposure to AngularJS framework, dependency injection and Entity Framework patterns.

•Have experience in Web Forms, Win Forms, .NET Web services, RESTful services, multithreaded applications, COM Interoperability and .NET remoting.

•Strong understanding of .Net Framework, CLR, JIT and SOA.

•Expertise in end to end development of software applications from Requirements Analysis, Design, Implementation, Testing and Deployment. Experience of complex product development, rich internet web applications and web services.

•Experience developing different applications for Trading systems, Wealth Management, Credit Risk, Mortgaging applications, Bill payments, Processing of checks, Tax accounting systems, ecommerce and application modernization of toolsets.

•Strong Problem Solving and Technical Skills combined with confident decision making for enabling effective solutions, leading to delivering the project in time with high customer satisfaction and stakeholder delight.

•Have worked on domains like financial, banking and modernization of toolsets.

•Have thorough hands-on experience in tools like, MS Visual Studio .NET, Win 7, Windows NT/2008 server, MS-Team Foundation Server, VSS, Concurrent Versions System, P4V, MS-Visio, Enterprise Architect and Rational Rose XDE.

•Good experience in Relational Databases, Normalization, ER Diagrams and SQL Server 2012 development. Also worked with DB2, Sybase and Oracle databases as per project needs.

•Excellent communication and interpersonal skills.

•Have good exposure to Microsoft SharePoint portals, usage and features.

•Worked for clients like McKesson, Bank of Tokyo MUFG, Bank of America - Merrill Lynch, Morgan Stanley, Lloyds Banking Group, Bradford and Bingley Group, Payment Data Systems, Unisys, Tax Accounting Department of Kern County.

•Worked into the pharmaceutical business domain.

Technical Summary

Environment

Microsoft .Net framework 4.5, ASP.NET MVC 4

Web Services- WCF, WPF, WSDL2.0, SOAP2.0, Enterprise Architect, Rational Rose, Microsoft Visio and Eclipse.

Languages

C#, PL/SQL, VB.NET, XAML, XML, XSL, Java 1.5, LINQ

Web Layer

ASP.NET, JavaScript, AJAX, MVC4, AngularJS, HTML, XHTML, JQuery, CSS

Testing & Deployment

NUnit, IIS 7.0, AFS

Database

SQL Server 2012, SSRS, SSIS, MongoDB, Sybase, DB2, Oracle 9i

Operating Systems

Windows server 2003/2008, Windows 7, Linux

Source Control and Tools

Microsoft VS 2012, TFS 2010/2012, VSS, Rational Clear Case and Clear Quest, P4.

Projects:

Client: McKesson, PA, USA Project: Controlled Substance Reporting and Digicall

Role: .Net Architect

Period: July 2015 – November 2016

Controlled Substance Reporting (CSR) is a batch processing and web based application for reporting the daily, weekly, bi monthly and monthly refills for different pharmacies and states across the US. Each state is provided with a report for all of the pharmacies that have the refills done during the period. This application helps the pharmacies to manage the different reports that are needed to report to the states.

Digicall VAX is a rewrite of the legacy application into windows based solution involving, web, windows and batch processing applications. Involved in the development of Request file, interactive load, automated load and control file creation. These are the different solutions to move the business process from legacy to windows environment.

Function & Responsibilities:

•Understanding the business requirements and transitioning them into new software requirements specifications.

•Development of the new business functionality using ASP.NET web forms for the frontend and C# for the business logic. Deploy on production and supporting post production deployment.

•Was responsible for developing the batch processes (CSR) that send the reports to the various states about the refills in the pharmacies.

•Development of the business logic using C# adhering to the current design of the application.

•PL/SQL development using stored procedures, functions and queries.

Technologies: ASP.NET MVC 4.0, C#, SQL Server 2008 R2, JIRA and kanboard tools, windows scheduler and services.

Client: Bank of Tokyo MUFG, NJ, USA Project: Portfolio Reconciliation and Risk Manager.

Role: Application Architect/.Net Developer

Period: Aug 2014 - June 2015

Portfolio Reconciliation is an application to manage the daily trading data across different systems which help the business user to analyze the markets and the customers trading information. The data warehousing applications input the trading information and a third party job scheduler called Tidal takes care of running the jobs for the daily trades. The user interface is a web application (Risk Manager developed in ASP.NET), for the users to analyze the data.

Function & Responsibilities:

•Analyze and understand the business requirements.

•Development of the UI screens using ASP.NET and business logic using C# classes.

•Maintaining the daily trading data using MQ and job scheduler.

•Unit testing the new features, deployment on servers for UAT and production.

•Verifying the functionality works from the GUI using unit testing scripts.

•Fixing defects for system integration testing, UAT and on production environments.

•Development using Infragistics web controls for web forms.

Technologies: ASP.NET 4.0, C#, .Net framework 4.5, SQL Server 2012, XML, TFS 2012, MSMQ, Infragistics web controls with web forms.

Client: Bank of America, NJ, USA Project: Merrill Edge Data mart.

Role: .Net Lead/SQL Consultant

Period: Jan 2014- to June 2014

Merrill Edge Data mart is a suite of applications to manage the portfolio of accounts for customers with different wealth management solutions. The applications are targeted for the business users to manage the campaigns developed for customers based on different criteria like the assets, HH Accounts, age of accounts etc. Also, the applications help the business users to manage the Relationship Managers book, the clients associated with each RM and RM details. Edgeport is a web application to host these suites of applications for different business users. The applications can be accessed using an internal authentication and authorization system called siteminder. Campaign administration and book assignment were new tools for business user to manage the different campaigns for customers and RM's book respectively.

Function & Responsibilities:

•Was involved in the Analysis, design, development and managing change requirements for the application.

•Development of the UI screens using ASP.NET and business logic using C# classes to meet the requirement specifications.

•Creating and verifying table schema, development of stored procedures and views in SQL Server 2012.

•Unit testing the new features, deploying on the server with the release management team and fixing issues and bugs for system integration testing, UAT and post production defects.

•Developed WCF web services hosted on IIS server and consumed by different clients with in the group.

•Coordinating with the offshore development team with requirements, development activities and any technical issues with the team members.

•Development of WCF Web services which was used for the database transactions in the application as well as for new clients to consume.

Technologies: ASP.NET 4.0,WCF Web Services, web forms, C#, .Net framework 4.0, SQL Server 2012, XML, TFS 2010.

Client: Morgan Stanley, NYC, USA Project: Credit Risk Vision

Role: .Net Consultant

Period: Feb 2013 - to Nov 2013

Credit Risk is a financial services application for managing the daily credit risk involved in the firm. The system interacts with various other applications like the Firm Risk, Operations Risk and the Market Risk which together manage the risk involved in the entire firm. Credit Risk Console is the User Interface for managing the credit risk. The application is developed using FLUX (a home grown UI framework) and windows forms. It provides a GUI interface for seeing various party loans, hedges and other types of exposures. The rich .net WinForms interface is used by Business Users to manage the various features involved in the credit risk space. Architecture wise the UI talks to the service layer built in Java/Spring technology which interacts with the database.

Function & Responsibilities:

•Understanding the functional requirements.

•Analysis of the requirements and impact on the current system.

•Development of the new features for the requirements for managing the credit risk system.

•Creating and verifying table schema, stored procedures and triggers in DB2 using DB Artisan.

•Development of the User interface using windows forms and flux interface.

•Unit testing the new features, deploying on the server system and fixing defects post production and UAT.

•Verifying the functionality works from the GUI using unit testing scripts.

•Worked on the performance optimization of the system.

Technologies: Windows forms, C#, .Net framework 4.0, DB2 using DBArtisan 2.0, perforce 4.0, Infragistics 12.1, ChartFx 7.0 and AFS file system management with Linux.

Client: Lloyds Banking Group, UK Project: Unisys Financial Services System

Role: .Net Lead

Period: June 2011 - Jan 2013

Unisys Financial Services System (UFSS) is a portfolio of applications that support all aspects of mortgage management from initial sales enquiry, through application processing, mortgage administration, redemptions, arrears management. The product was enhanced for other clients including Bradford and Bingley Group and WestBrom Building Society.

Function & Responsibilities:

•Developed product features in C#, also involved in design, development and unit testing.

•Involved in requirements understanding and analysis from clients.

•Was involved with the front end UI development, using ASP.NET, JQuery and JavaScript.

•Provided solutions to any customer related issues and interfaced with Business and Technical Architects to iron out requirements and scope of product features and enhancements.

•Was involved with the architecture of the software application which involved making necessary changes as per the new requirements.

•Deployment of the software web application in IIS 7.0 on Windows Server 2008.

•Mentoring of team members with technical queries, code review and fixing complex issues.

•Used Stylecop and Code Analyzer tool for code optimization.

•Used TFS for source code management, work item tracking, creating msi builds, branching of a release and releasing the msi to the testing team for system testing.

•Worked on defects raised by the system testing team.

•Developed the auto dropdown feature using the JQuery, json and JavaScript.

•Setting up the environment with all the configurations for the system testing team.

•Wrote unit test cases and performed unit testing.

•Migrated software components from .Net 3.5 to .Net 4.0 as per client requirements.

Technologies: Microsoft .Net framework 4.0, ASP.NET MVC 4.0, C#, Visual Studio 2010, XML, LINQ, JQuery, JSON, JavaScript, Team Foundation Server, Internet Information Server, Windows 2008, Web services, XML, XSLT.

Client: Eurojust, Netherlands Project: Case Management System

Role: .Net Lead

Period: Apr 2010 - May 2011

CMS is the IT tool used by the College of Eurojust for the management of the cases they are dealing with. It is intended to support the management and coordination of investigations and prosecutions, for which Eurojust is providing assistance, in particular by the cross-referencing of information, facilitate access to information on ongoing investigations and prosecutions, facilitate the monitoring of lawfulness and compliance with the provisions of this decision concerning the processing of personal data. CMS is a smart client application, where in, the application user, downloads the application to the client system from a server using the click once technology.

Function & Responsibilities:

•Involved in re-engineering of use cases, requirements management with use cases, design of the features

•Developed Win forms GUI for CMS application.

•Development of rich User interface with WPF for the windows applications.

•Development of stored procedures for data access from SQL Server 2008 database.

•Using TFS for source control, work item tracking, creating msi and releasing to the test team for system testing of the features developed.

•Used Microsoft Enterprise Library for exception handling.

•Worked on fixing of the defects raised by the system test team.

Technologies: Microsoft .Net framework 3.5, Win Forms, WPF, SQL Profiler for performance optimization, Visual Studio 2008, SQL 2008 and ASP.Net Web services, NUnit, TFS.

Client: Unisys and Microsoft SATC, USA Project: 3D Blueprinting Toolset

Role: .Net Developer

Period: Jan 2007 - March 2010

3D Blueprinting is a Unisys methodology that helps a project complete on time and cut costs. It is based on RUP and encourages iterative development. There are 4 layers which span across the different phases of the project. Each layer has a set of documents called artifacts that when completed increases the visibility in the project.

Function & Responsibilities:

•Lead the requirements analysis, design and development of Knowledge Modeler tool.

•Analyzing and understanding requirements for the Knowledge Modeler tool and development of Use Cases.

•Translating the use cases into an UML model with class diagrams.

•Coding of these classes designed using C# and used xml, xmi files for importing and storing information.

•TFS 3D Blueprinting integration for adding link into the TFS repository for a 3D Blueprinting methodology which helps visualize the impact in the 3D Blueprinting Impact Analysis feature.

•Development of Process Guidance and Process Template for a 3D blueprinting for .Net Software

•Modified the Java web services to accommodate changes in the backend.

•Was involved in the business process modeling implementation using metastorm provision.

Technologies: Microsoft .Net framework 3.5, ASP.Net, C#, Web Services, SOA, Sql Server 2008, XML, Java 1.5, UML, Unix, Tomcat, Metastorm.

Client: Kern County, CA, USA Project: Kern County Tax Accounting System

Role: .Net Developer

Period: July 2006 - Dec 2006

Kern county tax accounting system enables the office of the tax accounting to maintain the property tax details of the owner property of Kern County. The system authenticates the user using the LDAP server. The taxing system is such that the tax can be paid in installments and in several tenders as the system specifies. Exceptions are created based on the payment and stored into the system. The exceptions are resolved by making the correct payment for the bill.

Function & Responsibilities:

•Involved into the development of Web based front end using ASP.NET 2.0.

•Developed the stored procedures for data access from the front end. Used .Net tiers architecture for the creation of the data access layer.

•Developed the business layer in C#

•Development of SQL Server Reporting Services for custom report generation.

•Reporting the performance and issues for Microsoft Team foundation server, for which this project was a POC.

•Client interaction for requirements understanding, review of design, code and database schema.

•Was awarded the outstanding performer for delivering the Kern County Tax Accounting application to the client (Kern County, USA) on time with a very high customer satisfaction.

Technologies: Microsoft .Net framework 1.1/2.0, ASP.Net, Visual Studio 2003, SQL 2005, .Net tiers, SSRS.

Client: Office of Motor Vehicle, LA, USA Project: Next Gen Motor Vehicle System

Role: .Net Developer

Period: Mar 2006 - June 2006

NGMV is an enterprise application which enables State of Louisiana, Office of Motor Vehicle (OMV) to service and support the citizens of Louisiana. NGMV provides OMV with the ability to significantly reduce processing times and interact efficiently with business partners. NGMV also provides OMV Field Office users direct access to information and support tools that will assist in further improving the across-the-counter quality of service.

Function & Responsibilities:

•Designed and Developed business components in C# for Convictions, Suspension and SR22

•Developed the implementation of the UI in ASP.NET.

•Involved in fixing of defects from QA testing.

•Developing class Diagram, Sequence Diagram and Activity diagram using UML as modeling language and Rational Rose / Enterprise Architect as modeling tool.

Technologies: Microsoft .Net framework 2.0, ASP.Net, VB.NET, Visual Studio 2005, SQL Server 2005.

Client: Payment Data Systems Inc., USA Project: www.billx.com

Role: .Net Developer

Period: Mar 2005 - Feb 2006

It is a web based e commerce application which contains two major components Billx.com (http://www.billx.com) and Sponsor-Care Application. Billx.com interface communicates with the Kubra interface to accept electronic Bill payments, including scheduled, recurring, account transfer and P2P payments. Sponsor Care application provides different services related to customer care. Sponsor Care provides different services related to Sponsor and subscriber care.

A Sponsor care person can view all the details of the subscriber and help to answer the subscriber queries and insert cases (issues) faced by the subscriber.

Function & Responsibilities:

•Designed and Developed business components and data access layer in C#

•Developed the implementation of the web based front end using ASP.NET

•Developed stored procedure using SQL Server 2000.

•Was involved in feature enhancement, bug fixing and post production defect fixes.

•Was involved in the development of reports for customer’s monthly statement using SQL Server Reporting services. These were emailed to customers.

Technologies: Microsoft .Net framework 2.0, ASP.Net, Web services, Visual Studio 2003, SQL 2000, and SSRS.

Client: Royal Automobile Club, UK Project: RAC Migration Tool

Role: .Net Developer

Period: Dec 2004 - Feb 2005

It is a Migration Tool to convert the data in HTML files to XML so that XML’s can be used in different applications. RAC has a road side browser, which consists of static HTML pages. To address dynamic changes and to have the data in the standard XML format, RAC‘s tool migrated the HTML data into XML data. These XML data were placed in structured database.

Function & Responsibilities:

•Designed and Developed business components in C#

•Developed the implementation of the UI in ASP.NET

•Fixing of defects from the QA testing and UAT.

Technologies: Microsoft .Net framework 1.1, ASP.Net, Visual Studio 2003, XML.

Client: CareerNet Consulting Inc Project: Resume Manager

Role: .Net Consultant

Period: Aug 2003 - Nov 2004

Resume Manager is for HR consultants to facilitate the entire processing of the resumes. The resumes were saved into the company data source using the candidate details. This would streamline the process of searching and later hiring a candidate for a company very smoothly.

Function & Responsibilities:

•Designed and developed front end.

•Developed the implementation of the UI Win forms.

Technologies: Microsoft Visual Basic 6 and SQL Server 2000.

Client: Caribou Inc, USA Project: Music Manager

Role: Programmer

Period: Jan 2002 – July 2003

The Web Application 'Music-Manager' monitors, manages and gives access information of music in the entire music store. The management system provides for creation of users Web Administrators. Various Albums, tracks present in the store can be accessed, modified, created and deleted. The system also maintains the list of tracks that can be played at the music store. Also a DB of the precompiled packages available is also maintained.

Function & Responsibilities:

•Designed and developed front end using ASP.NET.

•Developed the business layer classes using C#.

Technologies: ASP.NET, C#, SQL Server 2000.

Professional Training and Seminars

•Attended the Microsoft Tech Ed 2009 seminar conducted by Microsoft at Hyderabad, India, from May 13th to May 15th 2009.

•Completed the Effective Team Leadership training conducted by Unisys at Bangalore between 18th May to 20th May 2009.

•Completed the Effective Team Leadership training conducted by Unisys at Bangalore.

•Attended the Microsoft Tech Forge 2008 seminar conducted by Microsoft at Bangalore on Dec 10th 2007.

•Underwent the training on Mastering Requirements Management with Use Cases from Nov 10 to Nov 12 2008, organized by Unisys University in Bangalore.

•Week long training on Provision version 6.0 tool and Unisys 3D Blueprinting Business Architecture from Oct 15 – Oct 19 2007, Bangalore.

•Underwent the training of "Web Application Development" Course (Programming basics, C, C++, Java, OOP’s, Web based development and database fundamentals) from IBM ACE, Bangalore.

•Underwent the training on XML, Xpath, SQL Server 2000 and UML at Tarang Software Technologies Pvt. Ltd., Bangalore.

Education

Bachelor of Engineering, from Karnataka University, India.



Contact this candidate