Project Engineer

Neha Sandeep

PHONE NO: 704-***-****

CHARLOTTE, CAROLINA

NORTH

E M A I L I D : ****.*******@*****.***

* *********

To obtain a meaningful and challenging software development position that enables me to carry out

design and implementation through an organized approach.

1 Personal Summary

• About 8 years of professional IT experience in Development, Maintenance, Testing, Quality

Assurance and Implementation in Web based Applications using Java, J2EE and database.

• Experienced with both UI programming and Server Side programming.

• Proficiency in multiple databases like ORACLE 9i/7.3, DB2, MYSQL, MS SQL Server and

writing SQL to interact with database such as Oracle, MYSQL, Teradata.

• Proficient working and developing dataload Jobs using ETL tools such as Talend and

Informatica

• Designed, Developed, Coded, Tested and Implemented phases of Software Development

Lifecycle. Application areas included development for FINANCIAL sector (Banking, Credit risk,

Policies, 401(k),pending cases mutual funds, Variable annuities and other investments)

• Proficient with Enterprise Architecture Design and implementation in J2EE architecture, Oracle 9i

and 10G application servers, Oracle Weblogic Application Server, Design Patterns, Servlets, XML, JSP,

JNDI, JDBC, STRUTS, SPRING Framework, Hibernate.

• Knowledge of Service Oriented architecture and Web Services.

• Proficient in working with tools and utilities like MS Visual Studio 6.0, Editplus, Log4J, XMLSpy,

Apache Common API, Eclipse 3.2.2, IntelliJIDEA5.1, winCVS2.0, MS Office applications, Browsers,

TOAD, Rational Rose,Talend,Microstrategy

• Strong experience in Analysis and Design using Software Engineering / SDLC, Agile

Methodologies, UML. Preparation of Test plans to do rigorous testing. Defined and created various

Functional Documents for the systems to be developed. Involved in Client Interaction and

Requirements gathering.

• Strong interpersonal and organizational skills in addition to an ability to manage and lead projects

to succession with minimal or no supervision

• Excellent communication skills, strong architectural skills, Energetic, hardworking and a good

team worker with leadership quality

2 Education

Bachelor of Engineering, SJCE, Mysore, India (B.E)

Technical Skills

Languages Java (Core Java, Multithreading, Swing), C, C++,Visual Basic

UI Javascript,AJAX,HTML,CSS

Server Side JSP, Servlets, JDBC

Technologies

Application Servers WebLogic, Apache Jakarta Tomcat, Websphere

IDE / Tools / Parsers Websphere Studio (WSAD), EditPlus 2.0, Eclipse, Netbeans, Jbuilder, DB

Visualizer, SQLlite, Toad, Teradata SQL Assistant, Adobe Flash Builder,Talend,

Informatica

Frameworks Struts, 2.0 JUnit, JDK, Spring Framework, Axis2.0, Hibernate, Jquery,Ant,

Maven, Axis 2.0

RDBMS DB2, Oracle, MySQL, MS SQL 5.0,Teradata

Methodologies Agile,Waterfall,RAD, SCRUM

OS Linux 7.0/8.0,MS Windows XP/2000,UNIX,Solaris

CM and Versioning & Clearcase,CVS, VSS, SVN

Tracking tools

Testing Tools JUnit

Bug Tracking Tools Quality Center, Bugzilla, JIRA

3 Professional Experience

Bank of America, Charlotte, NC

April 11- Present

Application developer

Project Description –Default Validation: Default Validation is an “override” tool that allows officers to

identify “false positive” defaults.

If any default conditions matches for the customers (as defined in guideline of Bank of America, Basel II

definition of default.) will cause the customer to be identified as a default.

If one facility related to a customer (i.e. a GCI) is in default, the entire customer is considered in default.

Responsibilities:

• Responsible for n-tier architecture for new features and enhancement.

• ‘Responsible for developing reports using J2EE Technologies e.g. JS,AJAX,,Struts, Hibernate

For n-tier coding

• Heavily involved in developing dataload for the application using Talend Tool.

• Responsible for interacting with Teradata(used SQL server Assistant) as Source for the default

validation data

Used b-teq and fast load script to pull data from source.

• Responsible for creating view, tables in SQL Server database.

• Participated In Agile methodologies and troubleshooting of the application using JIRA tickets.

• Interacted with Business users and presented demo for the iteration releases.

• Responsible for deploying the application using Bladelogic tool

• Responsible for creating JIL file and scheduling job via autosys.

• Responsible for writing shell script to automate the deployment process for Talend jobs on batch

server

Environment: Agile,Java 1.6,Javascript,Ajax,JSP,Struts,Hibernate 3.0, Talend Data Quality

4.9.1, Eclipse,,SQL Server Toad,Autosys Scheduler, Teradata SQL Server Assistant,

Weblogic10.2, Filezilla, putty(Unix),JIRA

Project Description-QRT-Projects helps bank to estimate the loss occurred in each quarter.QRT has

various applications which act as internal business tool that enables BOA to understand how economic

cycles impact different segment of its customer. It follows GCSBB Model governance policies.

Responsibilities:

• Work closely with Project Managers, Technical Product Managers, clients, subject-matter experts,

and data modelers to obtain requirements, objectives, and business rules for projects.

• Responsible for enhancing the application portal which analyze risk associated to Bank using

Java,JSF,Flex,J2EE and Oracle

• Responsible for developing the new services layers for various lines of business using Spring

MVC

• Responsible for developing code in Hibernate to establish DAO relationship

• Responsible to implement new request in Oracle PL/SQL code.

• Responsible for developing complete data load process for various RISK portals in ETL tool

Talend

• Responsible to monitor jobs in Datasynapse by checking logs in engine

• Responsible to interact with end customer for their queries regarding the application.

• Resolved issues/bugs related to the application system using JADE (JIRA).

• Responsible for interacting and tuning database using SQL queries in Oracle Toad.

• Responsible for creating data base objects such as tables, stored procedures, triggers etc and

normalized tables to store the optimum data.

• Responsible for supporting and debugging multiple applications for risk analysis using Java

Flex,J2EE and Oracle

• Migrating ETL code and UNIX scripts from one environment to another (UAT, Pre-production, and

Production)

• Responsible for writing shell script to automate the deployment process for Talend jobs on batch

server

• Responsible for writing JIL file and executing jobs via autosys

• Actively co-ordination for release and migration.

• Developed and performed the quality assurance activities and unit testing.

• Responsible to document the new enhancement as well other utilities.

Environment: Java 1.5, Spring 3.0,Hibernate 3.0,Ibatis 2, Talend Integration

Suite(TISEE),Datasynapse Autosys Scheduler,Netbeans 6.9.1,Flash Builder 4,Oracle 10.3,toad

Eclipse, Weblogic10.2, Filezilla, PL/SQL, putty(Unix),MATLAB,JADE,

Wells Fargo, Charlotte, NC

Signature LLC

Oct10- March11

Technical Analyst

Project Description- Wells Fargo Retirement Services (WRS) – The Project deals with developing,

managing and supporting the 401(K) applications for various customers. It involves creating and adding

401(k)profile for new customers for Wells Fargo as well as clients eg Lowes, Rolex etc. project assist

existing clients with reports .

Responsibilities:

• Designing and developing new features using core Java,JSP,JSTL, Struts, Servlets,

JavaScript,CSS,XML

• Responsible for writing frontend for internal tools to keep a track of customer’s demographic

information.

• Responsible for writing Stored Procedures and SQL queries using SQL Toad.

• Writing Business Requirement documents for new feature request.

• Other responsibilities include Collaborating with customer management, Business

representatives, and other IT areas as appropriate throughout the development of code, UAT

testing, and installation processes.

• Managing the UNIX jobs including analysis and debugging of the UNIX shell scripts

• Responsible for running report on daily/weekly/monthly based on business requirement and FTP

it to sponsor through filezilla.

• Managing the autosys job failures and taking corrective action.

• Collaborating with DBAs for performance tuning of the critical stored procedures.

• Impact-analysis, fixing and testing of the customer reported issues with the back-end.

• Designing, implementing, and testing of stored procedures for the new functionalities needed by

the applications.

• Creating Autosys jils on UNIX platform to integrate the stored-procedure invocation.

Environment: Java 1.5, J2EE, Servlets,,JSTL, Struts, Servlets, JavaScript,CSS,XML

JSP, Eclipse, Websphere 6.1, IBM WSAD (5.0/4.0.3), XML, XSL,Filezilla,Sybase 15.0.4, JDBC, ODBC,

PL/SQL, UNIX.

Market Tools, San Francisco, California

Aug 09- Nov 09

Software Developer

Project- True Sample

Project Description- True Sample is a patent-pending software solution that allows respondents to

take survey for company-specific researches. It is used by over 100 Companies.

In accordance to ensure the quality of research by using True Sample to eliminate fake, duplicate and

unengaged respondents and improve survey design.

It helps the Company to conclude in better and confident way after analyzing the survey data.

I worked on a module with the development team in which enables Market Tools to generate Company

profile based on their access permission which internally helps them to keep track of Administration User,

Accounts-owner user, Internal Users etc. Based on the authentication of User, they can view reports,

accounts, metadata, upload files etc.

.

Responsibilities:

• Responsible for information gathering with the business users and documentation.

• Responsible for UI design and coding and developed middle tier using J2EE technologies

• Designed the presentation layer layout and Developed code for front end using JSP, CSS, HTML,

XML and Struts.

• Responsible for writing codes in JavaScript for client-side validation.

• Responsible for developing the new services, action classes for various lines of business using

Spring and Spring DAO.

• Effectively utilized J2EE patterns such as Singleton, Session facade and Business delegate in

this framework

• Involved in Unit Testing and System Testing of the application.

• Worked as module lead for testing.

• Deployed EAR and WAR files using ANT to automate our build process.

• Developed complex SQL queries for data manipulation and querying data from MSSQL server.

• Generated log files for application logging and debugging using Log4J

• Prepared technical design documentation and Unit test plan

• Resolved issues/bugs related to the application system using BugZilla

Environment: Java, JDK1.4, JSP, HTML, CSS MSSQL server, Log4j, Weblogic 8.1,

AJAX,JQuery,Struts1.2, Spring 2.0, Windows XP, ANT 1.6.5, WinCvs2.0, Eclipse, Bugzilla 2.2

CAE Online, Menlo Park, California

Sept 08 – Aug 09

Senior System Developer/Analyst

Project: Marina

Project Description:

CAE Online is a marketplace for online trading of buying and selling semiconductor equipment and

commodities.

Marina is a web-based J2EE and PHP application that was developed in-house in CAE Online and used

to list the commodities and equipment. It is CAE Online's primary bidding system for the online trading of

semiconductors. It also helps to store and map the relationship between the buyer and the vendor for the

historical trend analysis as well as future strategic alliances and deals.

Based on the items listed, the customers are allowed to bid for one or more items, out of which the

application allows to find the best potential deal.

Responsibilities

• Successfully developed and implemented the Marina applications. Involved in the requirement

gathering from the Business

• Successfully wrote Business Specification Document and Technical Specification Document.

• Developed the pages for the web based Marina Application using PHP, Java Script and Ajax

using JQuery.

• Developed the test plan, unit test cases in Test Director and set up the test environment.

• Responsible for API testing using automation tools.

• Successfully prepared and reviewed the entire suite of project documents.

• Responsible for creating customized Subpanels for various module using PHP, Struts 1.2 and

Hibernate.

• Responsible for creating invoices and Purchase order using eZPDF for the application.

• Responsible for developing and testing database complex queries to achieve back end

interaction.

• Responsible for accomplishing Release of various module successfully

• Responsible for creating validating the error messages on the client side using JavaScript.

• Resolved issues/bugs using JIRA. Coordinated with SQA for testing the application, in a phased

manner and provided UAT support. Developed reports for traders to deal with their trading needs.

Environment: Java, JDK1.5, AJAX JUnit 4.0, MySql5.0, DB Visualizer 6.0, Struts 1.2,JBoss 4.2, Log4j,

Ant 1.7.1, Eclipse 3.3.2, Hibernate 3.2., SugarCRM 5.1.0b, PHP 5.0, Zend framework, Linux,VB

Sansa Technology, Fremont, California

Client: GTSS Inc.

Nov 07 – Sep 08

System Analyst/Software Developer

Project: Rover System

Project Description:

Rover is a state of the art customer relationship management solution and case management system that

helps agents and home office case managers to manage their contacts information and their Policy and

Investment data. Rover provides rich CRM functionality focused specifically on the needs of life, annuity,

and long-term care insurance professionals. In addition, the system allows integration of data feeds from

various new business and policy administration systems. The system is a Server application environment,

which uses J2EE, based server in a distributed environment. The server side architecture provides for

extensibility, flexibility, scalability, redundancy, clustering and performance. The applications and modules

are being written on top of an extensive Framework, which provides standardization and easier

development.

Responsibilities:

• Worked as a Systems Analyst and Component Developer in Data Import Modules.

• Responsible for Interacting with various Project Partners, Subject Matter Experts(SMEs) and

technical Members of Data Import modules.

• Responsible for evaluation of Data Models of various modules to generate Requirements

documentation.

• Lead the QA efforts in the project which included a Collector, Oracle data warehouse with

multiple databases and a web application to present reports.

• Responsible for developing different test plan, test cases.

• Responsible for setting up the test environment and participated in end to end testing of the

project.

• Responsible for developing SQL scripts for automation of report validation.

• Experience in using JSPs for flow of transactions using State chart model concepts.

• Experience in using Data Access Objects for data retrieval and updating using JDBC.

• Experience in using mailing for generating Intimation mails as transactions take place. Worked on

EJB and JMS.

• Responsible in designing and developing User Interface using JavaScript/ DHTML/ CSS/ XML

Environment: EJB 3.0, Servlets, JSP, XML, XSL, XSLT, DHTML, JavaScript, JDBC, Axis 2.0, Java Mail,

JMS, Web Sphere 6.0, WSAD, CVS, Oracle, CSS,UNIX

Tata consultancy Services

System Analyst

Feb 07-Nov 07

Project: GECF Private Level Credit Card

Project Description:

GECF Private Level Credit Card is a project of GE Consumer Finance indulged in business services for

its private label credit card partners (PLCC). There are primarily two workflows in this project. One is for

Administration of the web portal and the other is for Users i.e. Global Partners of GE. Admin change the

entitlements of users and approve, reject, activate or deactivate the membership of user (partner) from

various services. The partner flow actually provides sign up, enrollment to various services and business

information like new products, their related documents and links, messages and alerts (outages) etc and

other online services (integrated and non-integrated) for business partners based on their entitlements.

Every user (partner) has to login through the page and the homepage of the web provide the personalized

business information and links to the enrolled online services.

Responsibilities:

• Responsible for Designing and preparing activity diagrams, sequence diagrams and class

diagrams from various use-cases.

• Responsible for designing UI for the client using struts-tiles framework

• Responsible for developing, coding for the presentation layer using Apache Struts Framework,

AJAX, JSP, XML, CSS,HTML, XSLT and JavaScript.

• Responsible for developing, coding for the business layer using Java, XML DOM parsing, Struts

1.2.

• Involved in coding for Integration Layer using JDBC-DAO layer.

• Responsible for leading the QA efforts in the project and communicating with Development and

Program Management. Attended PMT meetings.

• Responsible for Unit Testing, string testing and integration testing using JUnit and Mercury Quality

center.

• Co-ordinate with the QA lead for development of test plan, test cases, responsible for defects

allocation..

• Responsible for performance testing using Loadrunner due to its high volume.

Environment: Java/J2EE, JSP, Servlets, EJB, XML, HTML, Apache Struts Framework, Spring

Framework, JDBC,QTP, SOA, DB2, Axis, CVS, Eclipse, WebLogic 9.1, Mercury Quality Center,

Windows XP.

Tata Consultancy Services

Client: GE Consumer Finance, UK

Aug 06 - Feb 07

Software Engineer

Project: HOF recognition points

Project Description:

HOF is a leading retail store in UK. HOF has a membership card program which accumulates points of its

member and gives them promos and offers accordingly.

Earlier the application system was in Mainframes environment and Visual Basic . Migrated the whole

system into JAVA environment as per client's new policies.(new business rules)

Responsibilities:

• Developed design of the application and successfully implemented in Java Environment.

• Responsible for writing Technical aspects and low level designing(LLD)

• Responsible for writing codes and testing for Presentation Layer as well as Business Logic.

• Responsible for testing the data migration between databases and aggregation of data from fact

to aggregate tables.

• Responsible for developing messaging system in middleware using JMS

• Responsible for Performance and Scalability testing on this application using Load Runner.

• Responsible for coordinating with QA Team Members.

• Responsible for arranging and taking session for the new joiners

Environment: Java, JSP, Struts, XML, JMS,CSS, HTML, VSS, Eclipse, Oracle, Websphere, Linux.

New York Life, Mumbai

Mar 05 - June 06

Java Developer/Programmer Analyst

Project: Field Technology Contact system Viewer

Project Description:

FTCS Viewer is web-based Customer Relationship Management (CRM) solution for agents and advisors,

to distributor agencies and brokerages, to the home office of New York Life. This system helps streamline

operations, improve customer relationships, and increase top-line revenue. System contains contact,

calendar and opportunity management, marketing, and customer service features, it also offer targeted

industry functionality, including support for multi-carrier insurance products, Investment and annuity

tracking, Commission and compliance tracking, New business/pending case processing, Financial data

feeds and Crystal Reports generation.

Responsibilities:

• Responsible for Managing Systems Analyst for requirement analysis for the FTCS system using

OOAD (object-oriented application development) with the UML (Unified Modeling Language).

• Responsible for designing and developing a highly flexible and extensible framework which

provides standardization and easier development.

• Developed Middle Tier of the application using EJB and configured messaging system using

JMS.

• Provided extensive pre-delivery support using Test Director, Bug Fixing, Code Reviews, etc. UI

generation was using XML and XSL also used XSLT on server side on browser specific requirement.

• Worked as a Systems Analyst and Component Developer in Policy and Pending Case

Management Module.

• Responsible for interacting with Business partners, Project Managers, Tech Leads and Team

Members of different teams like Policy, PCM, New Business, Underwriter, Carrier modules.

• Responsible for evaluating of Data Models of various modules to generate Requirements

documentation.

• Extensively used the different J2EE Design Patterns namely- Command Handler, Service

Locator, DAO, Value Object, Business Service, Session Façade, Client Delegate, Singleton, etc.

• Responsible for testing various modules.

Environment: Java, J2EE, Servlets, Javascript, JSP, JSP Tag Libraries, WebLogic 8.1, EJB 3.0,

JDBC, JNDI, Hibernate, Struts, XML, Oracle, CVS

Worldschool Pvt. Ltd.

May 04 - Mar 05 (Academic project)

Software Engineer/Testing Engineer

Project: World school’s online education system

Project Description:

Worldschool provides Internet based education to the students according to their curriculum. The site

provides the student a personal learning center, learning materials specific to his year and subject, as well

as the ability to connect to a qualified teacher online, whenever he needs help with homework or revision.

The collaboration suite gives the functionality of connecting the student to the tutor on demand.

Worldschool’s online education system is built upon Java/J2EE technologies and uses the following

components: JSP, Oracle8i, Tomcat, HTML, JavaScript, JUnit3.1, Visual Source Safe for Version Control,

Windows NT, Sun Solaris.

Responsibilities:

• Responsible for the Analyzing and designing the architecture of the learning system with OOAD

and UML approach, using Rational Rose.

• Responsible for designing and developing framework for the learning system using J2EE

technologies.

• Responsible for coding the User Interface in JSP with struts and HTML/DHTML/JavaScript.

• Responsible for measuring the performance bottlenecks and memory leaks with JProbe

performance analyzer.

• Responsible for automating different unit testing for all the modules with JUnit3.1.

Environment: Java, J2EE, Servlets, JSP, JSP Tag Libraries, Apache Tomcat, JDBC, JavaScript,

HTML, XML, Oracle, CVS

Environment: Core Java (JDK 1.2, Visual Cafe1.2), Java AWT, Win 95/98, Oracle 7.3, HTML and VSS

for Version Control, Linux.

--References Available On Request

Contact this candidate