Sql Server Web Services

SUMMARY OF EXPERIENCE

*+ years of experience in analysis, design, development and implementation of web based, Client/Server and n-tier distributed applications using software development methodologies / frameworks like SDLC, OOAD, RUP, and AGILE

Expertise in various JAVA/J2EE technologies such as JSP Servlets Struts 2.0, Hibernate 3.2,Spring, JDBC, JNDI, and Web Services

Experience in development of Web Forms, Windows Forms, WPF and other data-driven applications using ASP.NET, and C# .NET using Visual Studio 2005/2008/2013 and SQL Server 2005/2008.

Experience in Oracle, Microsoft SQL Server 2000, Microsoft Office Access 2003, SQL, PL/SQL, MySQL, ODBC, TOAD, SQL Developer, Triggers, and Stored procedures.

Extensive experience in web application development, testing and deployment using IBM WSAD 7.x, RAD 7.0, Eclipse 3.x.

Extensively worked with Unified Modeling Tools (UML) in designing Use Cases, Activity flow diagram, Class diagrams, Sequence and Object Diagrams using Rational Rose, MS-Visio

Experience in using design patterns like Singleton, MVC, Factory in the development of Multi-tier Enterprise Applications.

Expertise in designing ASP.NET based Graphical User Interfaces with CSS, JavaScript, J-Query, AJAX, DHTML, and HTML.

Proficient in various Web based technologies like HTML, XML, JavaScript and AJAX.

Experience in implementing Service Oriented Architectures (SOA) using XML based Web Services (SOAP/ WSDL) using AXIS.

Experience in writing XML DTD and Schema, validating XML documents and parsing XML documents using parsers like SAX, DOM, JAXB.

Expertise in unit testing using JUNIT. Experience in error logging and debugging using Log4J.

Strong experience in creating/reviewing of data models that are created in RDBMS like Oracle, DB2 databases.

Experience in working with Reporting tool SSRS for various reports used to be loaded to a web application.

Exposure to other application server WebLogic Server 10.3, JBOSS 6.1, and web server Apache Tomcat 7.0

Strong experience in using various tools like SQL IDEs TOAD, Oracle SQL Developer and XML validations using Altova XML Spy.

Experience working with versioning tools like CVS and Clear Case.

Experience in writing MS-Unit test cases to test the Libraries/Components written in C#.

Worked on Software configuration tool SonarQube.

Possess good verbal and communication skills and highly motivated with the ability to work independently or as an integral part of a team, and committed to highest level of professional and personal excellence.

Experienced in build tools such as ANT and Maven.

TECHNICAL SKILLS

J2EE Technologies:

Servlets, JSP, MVC, JDBC 2.0/3.0, JNDI, RMI, JMS

Microsoft Technologies:

ASP. Net 3.5, MVC Framework, Native Language Support(NLS) in MFC, Windows Link Library(WLL), Web Services

Frameworks:

Jakarta Struts Framework 2.0, Hibernate 3.0/3.1/3.2, EJB, J2EE Design Patterns, spring 2.5/3.0, JUnit, LOG4J, Java Mail API

Languages:

Java, C, SQL, PL/SQL, MSSQL, C#, VB.NET, Visual C++ Framework, .Net Framework 4.0/3.5/3.0/2.0

XML Technologies:

XML, XSL, XSLT, SAX, DOM, JAXB, SOAP, WSDL

Web Technologies:

JavaScript, CSS, HTML, DHTML, AJAX, JQuery

Databases:

Oracle 10g/11g, SQL Server, DB2, MS Access

IDE Tools:

RAD 6.0/7.0,WSAD 5.1.2, Eclipse 3.x, NetBeans 5.0/5.5, Visual Studio.NET 2013/2010/2008/2005/2003, MS Project, MS Office

Tools:

Rational Rose, MS Visio, TOAD, Altova XML Spy, Oracle SQL Developer, ANT, UML, SonarQube

Version Control Tools:

CVS, Clear Case, MS Visual Source Safe(VSS), SVN, Team Foundation Server, Star Team

Web/Application Servers:

Bea WebLogic 10.3, JBOSS 6.1, Apache Tomcat 7.0

Operating System

Windows 98/2000/XP/Vista, Server 2003

EDUCATION

Bachelor of Engineering (Computer Science & Engineering)

PROFESSIONAL EXPERIENCE

Shiro Technologies Inc., Dallas TX

Project: Credit Acquisition System

Duration: Sept 2013 - Present

Role: Java/J2EE Developer

Credit Acquisition System is an automated multi application system used by Bank of America which can be used on different platforms, enabling prompt and accurate processing of loan and credit card applications to clients throughout the USA. This project consists of the modules such as Cards, Loan Processing, Credit Risk Management, Finance and Regulatory.

Roles and Responsibilities

Involved in the analysis, design, and development and testing phases of Software Development Lifecycle (SDLC).

Designed Use Case Diagrams, Class Diagrams, Sequence Diagrams and Object Diagrams using IBM Rational Rose XDE to model the detail design of the application.

Used Spring 2.5 Framework to support the Hibernate tool.

Deployed the applications on Web logic 9.0 Application Server.

Wrote JAXB XML parsers for XML Schema Validation and used SOAP for sending and getting data from different applications.

Extensively used Hibernate 3.0 in data access layer to access and update information in the database.

Used XSLT to transform my XML data structure into HTML pages.

Used XML Web Services using SOAP to transfer information to the Credit Monitoring Systems.

Used CVS for version control across common source code used by developers.

Developed JUnit test cases for all the developed modules.

Used Maven for building the application.

Monitored the error logs using Log4J and fixing the problems.

Active Team member in a 10 member global agile development team.

Used ASP.Net, JQuery, C#, MVC3 for UI design and development.

Effectively used OOP concepts, C # 3.5/4.0 Frameworks, Generics, Collections and Interfaces.

Responsible for dynamic integration of REST services on client side.

Implemented AJAX Controls by sending data in common formats like XML.

Responsible for owner for Data Quality and Refdata management modules.

Involved in database work to create tables, functions and stored procedures using SQL Server 2008R2.

Used CSS, Ajax Control Toolkit, and JQuery2.0 for effective UI richness.

Configuring and deploying application on IIS and other release management activities.

Responsible for Unit testing with 95% code coverage.

Created test plans and performed NUnit on the application.

Worked on Software configuration tool SonarQube.

Environment: J2EE 1.7, JSP 2.0, JMS 1.1, XML, SOAP, WSDL, JAXB, Log4j, JUnit, .Net Framework 4.0/3.5, C#.Net, ASP.Net, MVC 3.0, REST, AJAX, WCF, Java Script, JQuery 2.0, Agile, Partial type scripting, Dev express controls, HTML5, XML, IIS, NUnit, Oracle 10g, SQL Server 2008R2, TFS 2010, SVN, Site minder, SonarQube, WebLogic 9.0, Web Services, Hibernate 3.0, Spring 2.5, Maven, JavaScript, HTML, CVS, Oracle 10g, PL/SQL, CVS, Windows XP.

Amdocs Inc

Project: Engineering Systems

Duration: Jun 2012–July 2013

Role: Java/J2EE Developer

The Vendor Response Form (VRF) is used as a communication tool between Telecom Transport Engineer and Cluster Vendor to provide a firm price quote on a transport job. It is a role-based application. Every user of this application has a role assigned. All the tasks and privileges are set according to the role of the user. User can have one of the following roles

Super Admin,

User Admin,

Transport Engineer,

Cluster Vendor.

Roles and Responsibilities

Implemented the system using Agile Development methodology.

Used spring framework with Hibernate in My Eclipse IDE and Oracle 11g as back-end.

Communicated with AT&T preferred vendors applications using Web Services with the help of SOAP and WSDL.

Implemented the project by using Spring Web MVC framework.

Was involved in the implementation of User Interfaces.

Configured the project in Linux environment.

Was involved in writing complex SQL queries. Tested project using JUnit unit testing framework.

Developed ADT RE(Reverse Engineering) tool

Developed an application prototype for an early-stage startup (health-care related venture)

Designed and developed components for Amdocs Data Type (ADT) backend engine for value- objects which is successfully deployed and used by all developers across Amdocs product line

Developed JSPs, Servlets with HTML, DHTML, CSS using spring framework for different modules for the interaction of user interfaces.

Was involved in the design and development of Presentation Tier using JSP, HTML, DHTML, XHTML CSS and JavaScript and Ajax.

Configured and deployed the project in Tomcat application server.

Prepared shell scripts.

Used Maven for building the application. Used CVS for code management.

Environment J2EE/Java technologies, XML, SOAP, Web Services, Eclipse, LAMP environment, XML, SOAP, SQL stored procedure

Key Projects: ADT engine, ADT Reverse Engineering tool, Application Prototype Apache, Lucene, Tomcat, Linux, MySQL

ICICI Bank, Bombay, India

Duration: Jan 2011 – Feb 2012

Role: Java Developer

Description: Banking Applications include two major components for a complete automation: Banking Processes and Online Banking Application. Banking Processes computerizes all business processes. It allows the employees of bank to carry out daily transactions (managing deposits and withdrawals, handling checks and drafts, etc.) as well as to generate reports for different purposes. Online Banking Application gives customers an online access to their accounts and other services as well as administration. It includes managing accounts online, generating reports and statements, transferring money between checking and savings accounts, etc. The Banking Application is developed using JFC/Swing and the Online Banking. Application is developed using Servlets/JSPs hosted on Tomcat. Both applications use MS SQL Server 2000 as a database for all operations.

Responsibilities:

•Worked closely with business analysis team to understand the existing Banking Application developed.

•Designed a new Banking Application (prepared Uses Cases, Sequence Diagrams, Class Diagrams,etc.)

•Designed a database to be used by the Banking Applications (prepared ER Diagrams)

•Developed modules for managing checking and savings accounts, transactions as well as users of the system using JFC/Swing, Collections API

•Used JDBC to interact with the database

•Developed Test Cases and performed Unit Testing

•Designed HTML, DHTML, CSS, JavaScript components of the user interface

•Used JDBC in various Servlets to interact with the database

•Configured Tomcat

•Created a database to be used by the Online Banking Application

•Provided production support

Environment: Windows NT 4.0/98, Java 1.3 (JFC/Swing, Collections, JDBC), MS SQL Server 2000,JUnit, HTML, DHTML, CSS, JavaScript, J2EE 1.3 (Servlet, JSP, JDBC), Ant, Tomcat 3.x, Windows 2000

Global Bank, Hyderabad, India

Duration: May 2009 – Nov 2010

Role: Application Programmer

Project Description: PayPack is an application which involves calculation of Pay packages for Employees going out on Assignments to any part of the world. This Application has various modules including Core UI, Core Components, Pay Staging, Cost Projection, Imports-Exports and Allowances.

Responsibilities:

Involved in the analysis, design and development phases of the Software Development Life Cycle (SDLC).

Used Rational Rose to generated Use case diagrams, Class diagrams and Sequence diagrams that modeled the design details of the application.

Developed UI screens using JSP, Struts tags and HTML.

Used Jakarta Struts Framework, based on the Model View Controller 2 architecture, for rapid application development and ease of maintenance.

Used Validation framework for client-side validation and Internationalization to support multiple languages.

Implemented several design patterns such as Business Delegate, MVC, Singleton and Factory to resolve the most common design issues.

Encryption and Decryption using symmetric keys.

Password encryption and Decryption and making it more sure.

Implemented SQL queries and Stored procedures for Oracle9i database.

Used XML parser APIs like DOM for marshaling and unmarshalling of data

Used MyEclipse for writing JSPs, Struts, EJBs, and other java code snippets.

Used JUnit framework for Unit testing of application and Clear Case for version control.

Built application using ANT and used Log4J to generate log files for the application.

Environment: Java, J2EE, JSP 2.0, Struts 1.1, Apache Tomcat, EJB, Servlet, JNDI, JMS, Oracle 9i, HTML, XML Web Services, MyEclipse, SOAP, JUnit, ANT, Rational Rose, LOG4J, Clear Case.

Contact this candidate