TECHNICAL SKILLS

Software Skills .NET Framework 3.0/3.5/4.0 ASP.Net MVC ASP.Net VB.Net

C LINQ WCF WPF Web Services Infragistics Telerik tools Visual Basic 6.0 Servlets JSP JDBC Multi-Threading JMS XML XSLT DOM Ant Maven Log4J

Scripting JavaScript AJAX jQuery JSON Knockout.js HTML T-SQL

PL/SQL

Operating Systems Windows Server 2000/2003/2008 Windows XP/7/8

Databases SQL Server 7/2000/2005/2008 Oracle 9i Sybase

Tools Visual Studio 2003/2005/2008/2010 Netbeans 6.0

Visio SSRS SSIS Crystal Reports.

Application Servers IIS JBoss WebLogic Server WebSphere

Configuration Tools TFS Subversion VSS PVCS

ORM Tools Entity Framework

S/W Methodology Agile

PROFESSIONAL EXPERIENCE

Confidential

Description

This ASP.Net MVC based application is used within RBS to track client activity as they relate to Dodd-Frank EMIR Remediation Canadian Trade Reporting and other client maintenance functions. Pre-Trade tool is used across RBS by the front office to check RAG Red/Amber/Green status before executing any trades. This application tracks Execution Agreements ISDA Protocols Aug 2012 and March 2013 and adherence letters from compliance perspective.

Roles and Responsibilities

• As a senior .Net and database Developer involved in the complete software development lifecycle from requirements gathering analysis design development testing and end user training.
• Built the application framework and major sub-systems from scratch.
• Successfully delivered weekly builds for several months keeping pace with regulatory/compliance requirements/changes.
• Significantly improved the performance of widely used Pre-Trade tool.
• Developed solutions to automate importing of large amounts of data from external systems using SQL Server bcp.
• Created several extension methods for use across the applications within the team.
• Designed the database schema created Tables Stored Procedures Triggers and Views in SQL Server.
• Developed a Web Service component to query and download ISDA Cross Border and Margin Requirements data from Markit.
• Developed a Windows Service to validate and process spreadsheets uploaded by users.
• Developed components that interface with a middleware to provide real-time remediation data to other downstream systems within RBS.

Environment

Windows XP/7/2003/2008 IIS 7.0 jQuery AJAX XML ASP.Net MVC 3.0 C WCF WPF Web Services Widows Services Entity Framework 4.0 SQL Server 2008 SSRS Sybase ASE TFS and Subversion.

Confidential

Description

This web application was developed to enable electronic filing of Land Records deeds mortgages etc. . Prior to the launch of PREP property records were filed across the Westchester County manually.

The entire workflow has been automated in PREP right from customers creating and paying for their documents to examination of those documents by the County Clerk s office till it reaches the stage where the documents are published and made available to the public.

Roles and Responsibilities

• As a senior .Net and database developer involved in the design and development of major business components using ASP.Net AJAX jQuery and JSON.
• Created fillable PDF forms for RP-5217 and TP-584/584.1/IT-2663 paper forms using Acrobat Professional and enabled them for efiling using Acrobat Javascript.
• Developed a component using Onbase Web Services to retrieve/add/modify/delete document information/images from Onbase.
• Designed and developed Data Export/Import modules. Export module will extract data from PREP s database and sends the information to DoTF and ORPS. Import module will take in data from external entities using PRIA standard XML documents.
• Developed Reports module using SSRS and Crystal Reports 11.
• Created a Web Service in ASP.Net to access OnBase documents.
• Developed SQLs and Stored Procedures in T-SQL.
• Fine-tuned SQLs in SQL Server using database tools like Index Tuning Wizard.

Environment

Windows XP/2008 IIS 7.0 Onbase 8.0 Infragistics 11 Crystal Reports 11 AJAX XML XSL XPath ASP.Net VB.Net C SQL Server 2005 and VSS.

Confidential

Description

This web services based application enables electronic filing of court documents between New York state and Westchester County.

Roles and Responsibilities

• As a .NET lead developer developed a WCF web service consumer application which uses x509 certificates for message signing over SSL.
• Developed case file module which will use the WCF component to file and retrieve cases.
• Involved in the design of the reporting module.

Environment

Windows XP/2008 IIS 7.0 Infragistics 10 AJAX XML Web Services SOAP ASP.Net C SQL Server 2005 VSS.

Confidential

Description

This application was developed for the County to enable filing of UCC Uniform Commercial Code documents electronically. UCC documents are web enabled PDF forms in the application. PDF forms are dynamically created using iText. Filed applications are reviewed using the Review application.

Roles and Responsibilities

• As a Web and Database developer involved in the design and development of the core UCC application filer application Review and Admin applications using JSF Java iText and Acrobat JavaScript.
• Integrated credit card processing using Authorize.net payment API.
• Involved in the database design of the Review and Admin applications.
• Developed several dynamic Reports for the finance department using Crystal Reports.
• Developed a component using Onbase Web Services to retrieve/add/modify/delete document images from Onbase.
• Developed SQLs and Stored Procedures in T-SQL.
• Installed and configured the applications in the QA environment including the setup of WebSphere Tomcat and SQL Server.

Environment

Windows XP/2000 Netbeans 6.1 Onbase 6.2 JSF Tomcat 6.0 iText Adobe JavaScript JNDI XML SQL Server 2000 Subversion Crystal Reports 11 WebSphere 6.0.

Confidential

SUPPLY OPTIMIZER

Description

Supply Optimizer is a self-contained analytical tool that is used to analyze the spend information of a company in a variety of ways. It enables a company to analyze spend by Business Unit Supply Markets UNSPSC and Supply Base a.k.a. Suppliers . It helps customers verify whether their suppliers are financially stable and whether they are diverse enough to help them meet their supplier diversity objectives etc.

Roles and Responsibilities

• As a senior Web and Database developer involved in design and development of major business components like Transaction Details Reports and Data Import using T-SQL EJBs JSPs and Servlets.
• Re-designed the Data Import module to use Threads and bulk import tools like bcp and sqlldr to enhance the performance of the data import process.
• Developed SQLs and Stored Procedures in both T-SQL and PL/SQL.
• Successfully lead a team of developers in porting the application from JBoss 3.2 to WebLogic 8.1 and WebSphere 5.0.
• As a Build Manager responsible for the preparation and deployment of builds in QA/UAT environments.
• Conducted in-house product trainings.

Environment

Windows 2000 Sun Solaris z/OS Ajax Netbeans 5.0 JSP Servlet Struts 1.2 JNDI JMS XML EJB Rational Rose SQL Server 2000 Oracle 9i DB2 JMS XML VSS PVCS JTest ANT Crystal Reports 6.0 JBoss 3.2 WebLogic 8.1 WebSphere 5.0.

Confidential

Description

Supply Intelligence is one of D B s widely used online applications. It enables its customers to find qualify and validate suppliers. It can search over 100 million global businesses based on 4 different Taxonomy classifications UNSPSC SIC NAICS and eClass Countries and various other parameters. It can also show Diversity Classification and D B Risk scores of suppliers and generate Supplier Information Report SIR and Supplier Qualifier Report SQR .

Roles and Responsibilities

• Reviewed the design documents as a lead. Trained my team on usage of Netbeans PVCS and Ant.
• Developed business components using Servlets and JSPs.
• Developed web applications to make calls to web services consumption
• Developed SQLs for complex data fetching and manipulation.
• Installed and configured SQL Server 2000 in QA environment.

Environment

Windows 2000 Sun Solaris Netbeans 5.0 Java JSP Servlets Struts XML SOAP JBoss 3.2 SQL Server 2000 VSS PVCS JTest ANT PuTTY.