We provide IT Staff Augmentation Services!

Sql Developer Resume

2.00/5 (Submit Your Rating)

Professional Summary:

  • Seven years of experience in Information Technology, building enterprise Java based applications using various components of J2EE on Windows and UNIX Platforms.
  • Worked closely with business stakeholders and project managers at every stage of software development life cycle (SDLC - Analysis, Design, Development, Testing, Deployment and Support) for the delivery of software systems.
  • Extensive experience in Design Patterns, UML, OOAD, Multi-tiered Systems and Software Development Methodologies.
  • Expertise in designing and developing enterprise applications using technologies like Core Java, JDBC, Servlets, JSP, JavaMail, JSTL, EJB, Struts, Spring, Hibernate, JSF, WebSphereMQ, JMS, XMLBeans, ApacheAxis, AJAX, XML, XSL, XSLT, JavaScript, CSS and HTML.
  • Involved in writing client side validations using JavaScript, Validation.xml and Validator-rules.xml in Struts.
  • Experience in writing SQL statements and PL/SQL (triggers and procedures).
  • Expertise in SOA and Web Services.
  • Good knowledge in writing build scripts using ANT and unit testing using JUnit.
  • Experience in configuring servers like Tomcat 6, JBoss 5, WebSphere 6.1, WebSphere Portal Server6, WebSphere Content Management and WebSphere Commerce Server.
  • Experience in developing applications using IDEs like Eclipse, IntelliJ and RAD6, 7, 7.5.
  • Strong experience in databases like Oracle10g, DB2 v9, SQL Server 2000
  • Developed logging standard and mechanism based on Log4J.

Technical Background:
Operating Systems : Windows NT/2000/XP.
Languages Known : Java, C and ASP.
J2EE : Servlets, JSP, JDBC, JMS, JSTL and EJB.
Frameworks : log4j, ANT, JUnit, Struts, XMLBeans, ApacheAxis, Hibernate and spring.
Databases : Oracle 10g, DB2 v8.2, SQL Server2000 and MySQL5.
Web Servers : Tomcat, IBM HTTP Server and Portal Server.
Application Servers : Weblogic, WebSphere and JBoss.
IDE : Rational Application Developer (RAD) 7, Eclipse 3.3, IntelliJ
Web Tools : JSF, AJAX, JS, XML, XSL, CSS, JavaScript, HTML.
Methodologies : Agile and Waterfall.
Configuration : Clearcase7.1, MS-VSS and CVS

Educational Background:

  • Master of Computer Applications

Detailed Experience:
Confidential,Project: Retail Web Ordering (RWO) Jan 09 – Till date
Cardinal Health has begun an enterprise Web Ordering Program to support the Retail National Chains. This program consists of several projects including Retail Web Ordering (Web Ordering 2.0), Hawaii Distribution, Controlled Ordering Substance Ordering (CSOS/Capacity), and Master Data Management (MDM). The Web Ordering 2.0 project is to provide a solution that contains basic self-service order functions for retail national chains.
Cardinal has recently developed an enterprise eCommerce Strategy to define enterprise opportunities to improve the customer experience and enable competitive advantage through integrated process, information and technology. In order to achieve these opportunities, the technology strategic direction is to invest in the implementation of the IBM WebSphere Portal and Commerce platforms integrated into the Cardinal technical and application infrastructure.
The future state will deliver an improved customer experience through standardization, simplification and introduction of new functional capabilities. The Web Ordering 2.0 project will start to position Cardinal as an eCommerce leader and significantly improve its ability to increase performance and provide greater transparency to its customers in the Web channel.
Team Size: 15
Role: Consultant – Java programmer.
Accomplishments:

  • Developed Use Cases and Class, Sequence diagrams.
  • Written SQL and PL/SQL procedures.
  • Responsible for Portal UI development, Web Content Management – for creating contents.
  • Worked on WebSphere Portal Server, Websphere Content Management server, WebSphere Commerce Server.
  • Used JSP, JSF and AJAX to provide rich UI experience to the end user.
  • Written XSL and CSS style sheets to transform XML data to HTML.
  • Did Integration Test, System Test before deploying the system in the production.
  • Supporting the application
  • Involved in Portal, J2EE services enhancements

Environment: Java1.6, J2EE (JSP, JSF, JSTL, EJB, JMS, ), Web Services, AJAX, WebSphere Portal Server6, WebSphere Commerce Server, WebSphere Content Management Server, RAD7, JUnit, ANT, CSS, JavaScript, HTML and DB2. WindowsXP.

Confidential,Denver, CO
Project: Mutual Fund Security Master (MFSM) Sep 08 – Dec 08
Mutual Fund security master updates will reduce regulatory and trading risks caused by inaccurate parameters and will allow Schwab to support a larger population of Mutual Funds in the marketplace. This project will prototype systematic updates to the security master, piloting Bluesky and Cumulative Discount Grid, as well as provide enhanced data view and query capabilities
Team Size: 5
Role: Sr. Software Engineer.
Accomplishments:
I provided effective support by providing quick resolutions for all the production issues assigned to me. I have resolved a high priority issue which was pending from years by finding out the root cause. I have proactively involved for release (Build) work and deployed the client, server code by following the Schwab build process. I have prepared Build Process document and posted in internal site. I have proactively involved with client code as well for some of the production issues. I have interacted with business users effectively for some of the issues did UAT. For one fix and got signoff by providing the test process document, Output Report.

  • Participated in project discussions and helped in defining the requirements.
  • Adopted agile methods for development and delivery of the solution.
  • Written stored procedures.
  • Responsible for development, Support activities.
  • Used Spring MVC, JSTL, JSF and AJAX for rich UI experience to the end user.
  • Developed JSPs as part of the UI layer and JavaBeans as data carriers.
  • Written database functions and triggers.
  • Developed Class, Sequence and Use Cases diagrams for the AMC Module.
  • Conducted technical document/code reviews of the deliverables to ensure quality of outputs. Ensured that the product meets expected performance benchmarks by suggesting better way of code writing and using appropriate tools.
  • Bug fixing, conducted Unit, Integration and stress test.
  • Written deployment scripts to deploy application at client site.

Environment: Java1.5, J2EE (JSP, JSTL and JavaMail), AJAX, Spring MVC, JSF, WebSphere Application Server, RAD7, JUnit, ANT, CSS, JavaScript, HTML, and Oracle10g. WindowsXP.

Confidential,Australia
Project: Customer Care and Billing (CC&B) Nov 07 - Aug 08
CC&B implements the following features. Meter Tests, Meter Connection and Grouping - Validation and Create Objects, Concession Validation, Meter Reading Unplanned - Special Meter Reading and Property Visits, Meter Reading Planned - Meter Reading and Customer Audit Read, External Systems Invoices, Rebates, List Maintenance, Payments from Coles Myer and Bill Express, Payments from Australia Post, Payment Deductions from Centrelink, Payments from Maxi Kiosk and IVR, Payments from Mercantile Agents and DHS, Direct Debit to Securepay & ANZ, Payments from Scan Bill Stubs, Daily Postings to Apollo, Letters, Bad Debt Write Off Processing, File Verification, CARMS Interface
Team Size: 5
Role: Sr. Software Engineer.
Accomplishments:

  • Understanding the CC&B architecture.
  • Used agile methods for the solution development and delivery.
  • Written the Database Queries.
  • Used JSP, AJAX for rich UI experience to the end user.
  • Developed uses cases.
  • Written ANT scripts

Environment: Java 1.5, J2EE (JSP, WebServices, Mbeans, EJB, WebSphereMQ & JMS), WebSphere App Server, RAD6, Log4j, JUnit, ANT, CMVC, DB2, Oracle10g, RAD6 and SOATest tool. Developed on WindowsXP, tested on AIX, RadHat and Suse.

Client: Applied Energy Group, East Brunswick, NJ
Project: Information Management System (IMS) Jul 07 - Nov 07
Information Management System is an application which has different modules to serve various AEG operations. The modules are 1.User Management. 2. Budgets. 3. Invoicing. 4. QA/QC. 5. Document Management. 6. Integration Layer. 7. Reports. 1. User Management - is for Adding, Editing, Deleting users. 2. Budgets - is for Creating Annual Budgets, Updating Annual Budgets, View Manage Budgets, and Update Manage Budgets. 3. Invoicing - is for viewing, Approving, Rejecting Program Expenses, and Rebate Expenses. 4. QA/QC - is having facility to set the status of the verified data (Expenses, Rebates). 5. Document Management - is for Uploading, Downloading the Documents. 6. Integration Layer - is having facility to upload data in the form of comma separated files, to authorize the uploaded data. 7. Reports - is to allow the user to generate reports, provide the user with the capability to save the currently viewable report in excel format.
Team Size: 5
Role: Sr. Software Engineer.
Accomplishments:

  • Understanding and implementing AEG requirements.
  • Designed Class, Sequence and Use case diagrams for representing the static flow of data.
  • Done the JAAS setup for authenticating the users in JBoss.
  • Used JSP, Struts, JBoss application server.
  • Developed uses cases.
  • Written ANT build scripts.
  • Involved in Functional, Integration testing.

Environment: Java 1.4, J2EE, JBoss App Server, Eclipse, JUnit, Log4j, ANT, DB2 v81, Oracle 10g. Developed on Windows XP.

Confidential,IL
Project: Content Based Router/ HeadWater (POC) Mar 07 - Jun 07
HeadWater is a platform for establishing data interoperability across healthcare domains and organizations. It simplifies the cost and complexity of data interoperability by: Using a standardized, yet flexible representation of data between providers (the canonical form) so that achieving integration requires only mapping from source to canonical, and NOT source to every single end point Provides an “appliance-like” implementation at each organization handling issues of firewall, routing, security, reliable message delivery and manageability additionally reducing the costs involved to connect systems and organizations. It is extensible beyond getting data “from point A to B” It provides the capability to attach services to the data flow in order to implement value-processing, such as patient registration across multiple systems, drug interaction testing, duplicate procedure checking, logging pay-for-performance metrics, claim coding verification and resolution, etc.
Team Size: 5
Role: Team Lead
Accomplishments:

  • Understanding SDD, CDD and usecases to create testcases.
  • Involved in Time estimation and Recourse estimation.
  • Communicate team status, Task accomplishment and direction.
  • Participated in different testing phases like, Functional Testing, System Testing
  • System Integration Test.
  • Application Test.
  • Accessibility Test.

Environment: WebSphere Application Server (WAS v5.1.1.8), WSAD v512, DB2 v81, Oracle8i, Apache Axis2 , ANT.
Operating systems: WindowsXP

We'd love your feedback!