Database Developer Resume Profile
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
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, Web Services, Widows Services, Entity Framework 4.0, SQL Server 2008, Sybase ASE, TFS and Subversion.
Confidential
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
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
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
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
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.