PHANI C VARRE
Senior Java Developer
Profile Summary:
• Overall 5 years of IT experience in System Analysis, Design of Systems software solutions,
Development, Support, Maintenance, Testing and Quality Control while performing a wide
variety of roles as Team lead, Team Member, Quality coordinator, Developer and Tester.
• Extensive experience with CRM primarily in the Integration side. Dealt with huge
transaction volumes while interfacing the front end application written in Java, JSP, Struts
with Tomcat web server.
• Sun Certified Java Professional (SCJP) & Sun Certified Web Component Developer
(SCWCD).
• Delivered four Projects/Change requests 2 weeks before the dead line, working on all of
them at the same time which involved over 1000 man hours of effort to be completed in
two months.
• Supported and enabled in the successful migration of changes to the production servers
which involved considerable amount of volume testing (including writing test scripts) and
administration activities.
• Zero defects were found during the UAT(User Acceptance Testing).
• Recieved four E-awards from Hewlett Packard for leadership, team building.
• Delivered zero defect code for three large projects which involved changes to both the
front end (Java, Struts) and the back-end (Oracle) to load the data into Siebel.
• Has over four years of experience in creating test scripts / test cases for the Java, J2EE,
Oracle environment using Mercury Test Director. Worked closely with the business
analysts, solution architects in creating/validating test data. Also wrote numerous SQL
scripts to perform integration testing during a migration project for CRM.
• Proactively suggested enhancements to the DIF framework and implemented them after
brain storming sessions with the Solution Architect.
• Extensive experience in using Relational DBMS. Well versed with writing complex SQL
statements.
• Strong domain knowledge in Sales & Marketing and Logistics . Collaborated with the
business analysts to write technical requirements for over 25 projects and small service
change requests.
• Lead a team with varied technological skills and got the best out of each individual which
increased the overall productivity of the team by 10 hours per week and was well
appreciated by the clients. Managed 6 people in the project.
• Created user guides as a reference tool for use by WWCRM team.
• Has been a regular trainer in Siebel 8.0 boot camps for three years, providing class
room training to HP associates new to Siebel and received several recognition awards from
the management for the same.
Technical Skills:
Operating Windows 2000 / NT / XP / Vista
Systems
Programmi Java, PL/SQL, C, C++, VB, Hibernate, JDBC.
ng
Languages
Databases/ Oracle 9i/10g, MS Access, Client/Server
technologie
s
Application Apache Tomcat, BEA Weblogic
Servers
Web JSP, Servlets, JavaScript, Struts 1.2/2.0, HTML, XML
Technologi
es
Domain Sales and Marketing, Logistics
Expertise
Other Siebel 8.0, Mercury Test Director, Microsoft Visual Source
Software Safe, Microsoft Visio, Microsoft Office, Eclipse IDE
Academic Record:
Bachelor of Technology in Computer Science & Engineering, JNTU, Hyderabad, India.
Professional Experience:
Project Title: HP World Wide CRM – Data Integration Framework
Role: Application Developer
Client Name: Hewlett Packard
Duration: March 2007 – August 2009
Description: Data Integration Framework (DIF) integrates the data from the external system
with the Siebel database. It provides a set of tools that simplifies the creation, support and
maintenance of the batch interfaces. DIF also provides a monitoring web application to keep track
of the data loading processes in to Siebel. DIF provides standard services and features which can
be used by data integrators for their respective projects. At the Real-Time/Near-Real-Time Level,
DIF provides a full methodology to standardize the log messages which are published as a report
in the DIF monitoring website to be easily accessible across the platform.
While working with the team,
• Successfully implemented four major releases of HP World Wide CRM (WWCRM) working
both individually and as a part of the larger team. All the four releases were delivered
ahead of the schedule with zero defects.
• Designed the high level and detailed design for ten new services added to the DIF, which
require exceptional analytical skills and also a thorough understanding of the current
system.
• Wrote over thirty thousand lines of Java, JSP, Struts code to implement the service,
process the business logic, load the data into Siebel, publish the progress of these
services, results on the monitoring web page.
• Developed the DIF monitoring Web Application using Struts 1.2 MVC Framework.
• Developed User Interface using JSP based on Struts and Custom tag library facility using
form beans and action classes.
• Developed ANT scripts to build the different modules for the Project, such as building the
binary files and scripts for deploying to the server. Minimized over 30% of the manual build
process time by utilizing ANT for automation.
• Provided technical assistance to the Infrastructure team in successfully maneuvering the
challenges faced during installation and execution of services offered by DIF.
• Wrote several SQL scripts in the process.
• Developed enhancements for an existing Struts application. Worked with management and
business analysts to assure requirements and ad-hoc requests were fully coded.
• Prepared LOEs for over 20 new projects and change requests and also coordinated with the
onsite team, Solution Architect to ensure timely and quality deliverables.
• Worked closely with the Infrastructure team during the build process in deployment and
configuration of the new version of DIF in Tomcat Webserver in different regions. Resolved
the environmental issues in a timely manner and performed IT checkout to ensure
sucessful deployment on all the region servers.
• Created the technical design documents and test scripts adhering to HP quality control
standards.
• Coded the complex work modules for the new services added adhering to the Java coding
standards.
• Mentored over ten new team members by involving them in hands-on training sessions.
• Prepared Unit test plans and unit testing the Java Classes using JUnit test cases.
• Learnt the functionality of DIF and the Interfaces (both Batch and Real-Time interfaces)
with in 2 weeks and from then on, I have taken care of all the changes that were
necessitated every release.
• Took care of the configuration management and release management activities in the
team, including creation of build notes and collaborating with the Infrastructure team to
deploy the new release to all the 3 regions (Americas, Asia Pacific, Europe regions).
• Developed efficient test cases and test scripts using Mercury Quality center which were
used by the Testing team in SIT (System Integration Testing) phase and also in UAT phase.
• Acted as Single Point Of Contact (SPOC) for DIF in all the releases. Saved the company
1000s of man hours by effectively resolving the production issues on more than 10
occasions. This was done by quickly recognizing the problem and pointing to the correct
support team to be engaged.
• Helped the external system team (CID: Customer Identification team) in performing their
testing and investigating the problem and fixing them.
• Used IQMS tool for tracking the effort and for code review, Design Document review and
Test Script review.
Environment: Java, JSP, Struts 1.2, Siebel 8.0, JDBC, PL/SQL, Oracle 10g, XML, HTML,
Hibernate, and JavaScript, Mercury Quality Center, Microsoft Visual Source Safe, MS Office,
Apache Tomcat, Apache Ant.
Project Title: Americas Instance Consolidation & Support Simplification (AICSS)
Role: Application Developer
Client Name: Hewlett Packard
Duration: April 2006 – March 2007
Description: Consolidation of the Latin American and AMER region data into a single streamlined
Siebel database as part of Americas Instance Consolidation project. Support Simplification project
automated the manual tasks performed by the support team members in order to reduce the
costs.
While working in the team,
• Acted as Single Point Of Contact for DIF in the Americas region.
• Discussed with the Americas region clients, Solution Architects to make necessary changes
during the consolidation of the 2 regions.
• Supported SIT and UAT during the Co-located testing performed by over 40 business
analysts.
• Interacted with the external system team inorder to retrieve the data in the format
specific to Americas region.
• Gave hands-on training to the Americas region clients on How to Install and use DIF,
writing services effectively.
• Performed regression testing before deploying the release to Americas production.
• Collaborated with Support Team, buisiness users and Solution Architects to design the
changes to be done to DIF as part of Support Simplication project.
• Several new services were added in order to automate the process that support team
performs. Wrote thousands of lines Java code to achieve this.
• Documented Configuration Management and DBA processes to transfer knowledge among
team members.
Environment: Java, JSP, Struts 1.2, Siebel 8.0, PL/SQL, Oracle 10g, XML, HTML, Hibernate,
and JavaScript, Mercury Quality Center, Microsoft Visual Source Safe, MS Office, Apache Tomcat.
Project Title: Commercial Air Line Haul Management System
Role: Application Developer
Client Name: DHL
Duration: August 2004 – March 2006
Description: Commercial Air Line haul Management System (CALMS) supports business
processes associated with the management of Commercial Air Line haul. CALMS supports,
Management of bookings, schedules, allotments, tariffs and other flight information.
Preparation of IATA standard neutral MAWB(Master Air Way Bill).
Recording, reconciliation and approval of carrier invoices.
Analysis, reporting and general visibility of line haul expenditure.
While working in the team,
• Analyzed the specifications provided by the clients.
• Prepared the high level design document and also the pseudo code in most cases.
• Coded some of the complex programs in the entire project using Java, JSP and Struts.
• Wrote over 5000 lines of Java code while developing the “Inbound Handling Charges”
module which was used by the business model, design model and product definition
components.
• Used Function Point analysis to arrive at the estimates for all the releases and coordinated
with several teams to ensure that the timelines were strictly followed.
• Provided support for the application and effectively helped the end users by getting them
back up and running with in 4 hours on 90% of the occasions.
• Performed peer review of the coding and unit test plans prepared in the team.
• Actively conducted the code review meetings to ensure the quality of code being delivered.
Also conducted change management audits to ensure compliance.
• Documented the limitations, dependencies and the lessons learned for the project, which
was well appreciated by the client as it helped teams working on the subsequent releases.
• Reviewed the quality metrics documents on a weekly basis to ensure the deliverables are
qualitative.
• Reviewed the test scripts/results prepared by the test team to ensure all the objectives of
the requirements are being covered.
• Used mercury quality center to unit test including review of the test results in some cases.
• Was the point of contact for all the quality procedures related to the project.
Environment: Java, JSP, Informix, PL/SQL, Mercury Quality Center, Microsoft Visual Source
Safe, BEA Weblogic.