Srinivasa Rao Andhavarapu
*** ***** ******** ****** #**,
Ossining, New York 10562
Contact phone Nos: 914-***-****(H)
914-***-****(O)
314-***-****(M)
Email Id: **************@*****.***
Professional Summary
. TWELVE years of experience in the requirements gathering, analysis,
design, development, implementation and support of applications
primarily using Pega BPM Tools, Java, Servlets, JSP, JDBC, EJBs, J2EE,
HTML, Java Script, XML, Oracle 7.x/8i, C, Pro*C, Stored Procedures,
C++, Shell Scripts, SQRs under Windows NT and UNIX.
. Experience in implementing J2EE technologies (JSP, Servlets, JDBC and
EJBs) to develop Enterprise software applications.
. Experience in implementing Struts architecture and JSP tag libraries
to use for the web applications.
. Experience in PL/SQL for writing queries, stored procedures, triggers
and packages.
. Worked extensively with BEA Tuxedo Applications as a middle layer.
Written may Tuxedo Services in C and C++ for Edward Jones.
. Involved in Performance tuning, Upgrades, Disaster recovery, Tool
Conversion and Production support.
. Expertise with Requirement, Analysis, Design of the system and
developing use cases by gathering information from various sources and
expertise in developing in data models and class diagrams using UML.
. Worked on DOM and SAX parsers for parsing XML documents.
. Worked extensively in PeopleSoft Structured Query Report Writer
language.
. In-depth understanding of Software Development Life Cycle, Rational
Unified Process, and QA methodologies.
. Expertise in business modeling, use case development, software
testing, and in setting and achieving software development milestones.
. Extensive experience in the UML, Rational Rose, Rational RequisitePro,
MS Project, ERwin, MS Visio, Lotus Notes, Mercury and Rational testing
tools.
. In-depth knowledge in testing applications for functionality,
industrial strength, environment, and usability with emphasis on end-
to-end System Testing and User Acceptance Testing.
. Specialized in Requirements Traceability Matrix (RTM), test plan
and test procedural development and review, tool validation and
setup, project customization and administration, defect
management, configuration management and version control, and
business documentation.
. Strong team builder with excellent lead, analytical and
communication skills with capability to handle new technologies
and situations.
. Expertise in preparing time and cost estimations for new projects.
Awards and Appreciations
. Received two SPOT awards from Mastercard IT Management for the
successful completion
and Implementation for Franchise Licensing projects.
. Received appreciation from Edward Jones for the successful
imeplementation of Quicken
and Microsoft Money Download project.
. Received a Valuable Contribution award from LTITL for the AccountLink
project developed at Edward Jones, St.Louis, USA.
. Received a Recognition Certification for the AccountLink project from
the client Edward Jones.
. Received a Team Award from LTITL for good work done in all Licensing
Proejcts developed at the client Edward Jones.
. Received good appreciation letter from Hitachi Ltd., Japan client for
the implementation of JP1/NETM/DM for Internet for the implementation
of the project at on site.
Educational Qualifications
. Bachelor of Engineering in Electronics from University of Pune, India.
. Diploma in Advanced Computing from C-DAC Pune, India.
Project Experience
MasterCard Purchase, NY (May 2007 - Till Now)
Licensing Workflow Processes
Licensing Workflow Systems are written in Pega systems BPM software with
Business Rules Engine to broadly improve business effectiveness.
Role: Lead Developer
Responsibilities :
. Developed various pega processes of Licensing entities like Additional
Bin, Bin Transfer, Bin Delete, Bin Program Code Change, Change of
Sponsor, Additional Sponsor, Terminiation of Sponsorship, Add ICA, ICA
Transfer and ICA Delete.
. Written many database transactional packages to communicate with Pega
and perform the transactions with external databases.
. Written test cases, test plans and scenarios for the project using
the QC for some of the pega processes developed.
. Extensively used JIRA for requirements gathering, estimations, agile
approach to software development, issue tracking and project tracking
for software developmnt.
. Analysing the exisitng MPI systems for various entities like Member,
License, ICA, Bin, LGP, Affiliates and converting these to pega
processes.
. Requirements Collection and Client liaison for the new enhancements,
estimation, documentation. Coordinting and helping the business to
prepare the requirements using pega
. Involved in Analysis and Design, Reviewing, implementation and post
production support.
. Responsible for code reviews with the team.
. Testing the application in QA and Model environments.
. Coordinating the application with USERS for User Acceptance Testing.
. Served as an implemenation coordinator between STL admin teams and Biz
teams in NY.
Environment: PRPC 5.3, PRPC 5.5, JIRA, IBM Web Sphere 6.0/6.1, Oracle,
PL/SQL, UML, MS Visio, TOAD, CVS, PVCS, SQL, HTML, XML, Windows 2000, Test
Director/Quality Center 9.0.
LCN
Licensing Non Member application adds non member organizations data that
originates from various internal departments that are requesting ICA
numbers for billing and relationship purposes.
Role: Lead Developer
Responsibilities :
. Written many packages, procedures, functions that are required for the
project.
. Written many actions classes, services layer functions and manager
layer functions using struts framework.
. Involved in designing the proxy setup and updating the database
through proxy sessions.
. Written test cases, test plans and scenarios for the project using
the QC.
. Database design for various entities like Members, ICA, RTNs,
Processors, Relationships, Contacts, Comments, Auditing events.
. Analysising the exisitng MPI systems to incorporate the both Licensing
and Non Licensing applications.
. Written many JSPs, Custom tags for JSP pages, Enterprise Java Beans
for the application.
. Requirements Collection and Client liaison for the new enhancements,
estimation, documentation.
. Involved in Analysis and Design, Reviewing, implementation and post
production support.
. Responsible for code reviews with the team.
. Testing the application in QA and Model environments.
. Coordinating the application with USERS for User Acceptance Testing.
. Served as an implemenation coordinator between STL admin teams and Biz
teams in NY.
Environment: Java, Java Servlets, JSPs, Java Script, JDK 1.4, JUnit,
Spring 2.0, IBM Web Sphere 6.0/6.1, IBM Rational Applicaton Developer 7.0,
Oracle, PL/SQL, Struts Framework 1.3 with MVC architecture, UML, MS Visio,
TOAD, CVS, PVCS, SQL, HTML, XML, Windows 2000, Test Director/Quality Center
9.0.
BUNGE GLOBAL MARKETS, NY (March 2006 - May 2007)
OPRS
Bunge is an integrated agribusiness, fertilizer, and food products trading
company having worldwide operations in trading, trade structured finance &
planning, and support systems such as logistics, market data management,
and global position systems. BGM IT provides solutions to organization's
business and information needs. Involved in Commodity contracting as well
as analyzing, developing and supporting trade position systems.
Role: Business Analyst, Lead Developer & Onsite Offshore Coordinator
Responsibilities :
. Co-ordinate onsite and offshore team of 4 developers.
. Written many JSPs, Custom tags for JSP pages, Enterprise Java Beans
for the application.
. Requirements Collection and Client liaison for the new enhancements,
estimation, documentation and maintenance works.
. Written many test plans and scenarios.
. Involved in Analysis and Design, Reviewing, implementation and post
production support.
. Responsible for code reviews with the oniste team.
. Testing the application in QA and Model environments.
. Coordinating the application with USERS for User Acceptance Testing.
. Served as an implemenation coordinator between offshore team and
onsite admin teams.
Environment: Java, Java Servlets, JSPs, Java Script, JDBC, EJB 2.0, IBM
Web Sphere, Oracle, PL/SQL, Struts Framework with MVC architecture, UML,
RUP, MS Visio, Borland Together, ARIS, Oracle, TOAD, SQL, HTML, XML,
WebFocus, SiteMinder, Windows 2000, Test Director/Quality Center 9.0.
Edward Jones, MO, USA (January 2000 - February 2006)
AccountLink
AccountLink is customer's source for information about their Edward Jones
householded accounts and financial news. With Edward Jones AccountLink,
customers have the ability to view their householded accounts online,
current holdings, account acitivty, amount invested and gain/loss
information, create watch lists for stocks and mutual funds, pay bills
online, access historical statements, headline news, daily market
commnetary and etc.,
Role: Developer, Lead Developer
Responsibilities:
. Involved in devloping Striped design of presentation layer, middle
layer using BEA Tuxedo and database layers for the application.
. Developed health check mechanism for WSDs for monitoring the
individual stripes including web servers, tuxedo servers, database
servers and mainframe.
. Developed TRUSTNOTHING and GATEKEEPER checking for validations.
. Involved in running the AccountLink application from two data centers
with load sharing between them.
. Introduced the clean and clear way of logging as per the application
needs for Tuxedo Services, Servlets and Stored Procedures which will
make debugging easier.
. Created many tuxedo services for the application which includes daemon
processes, inter domain communication between various domains.
. Developed many Java Servlets for various releases of the application.
. Served as implementation coordinator for major releases of the
AccountLink application.
. Performed the role of package coordinator for some releases to move
the development code to QA lab and production environment.
. Supported the production system till February 2006.
. Involved in developing MASTER/SLAVE configuration of databases for the
application.
. Developed various mailers for the users using post script files and C
batch programs.
. Analysed the components and estimating the AccountLink International
using J2EE technologies with Struts MVC architecture.
. Involved in migrating the source code to CVS.
Environment: Java,Java Servlets, JSPs, C/C++, BEA Tuxedo, BEA Jolt
Interface, Sun Solaris Unix, HTML, Java Script, Pro*C, PL/SQL, Shell
Script, Visual Slick Edit, Visual Thought, iPlanet Web Server, jrun
application server, Mercury TestDirector 8.0, BEA Web Logic, JSPs, Struts
Framework with MVC architecture, CVS, TOAD, Ant build tool,.
Investment and Tax Download
The Tax Download project phase will provide Edward Jones customers enrolled
in AccountLink with the ability to download various 1099 forms data like
INT, DIV, B, OID, MISC and Retirement tax information to Intuit's Turbo Tax
preparation software for the financial year. The Investment download
project phase will provide Edward Jones customers enrolled in AccountLink
with the ability to download their Account Balances, Positions and Activity
into their Intuit's Quicken and Microsoft Money client Personal Financial
software.
Role: Lead Developer
Responsibilities:
. Design, coding, testing and implementation of the system.
. Understands the OFX server and their architecture with Edward Jones
Backend systems to get the data.
. Mapping the XML fields of OFX with the data at the back end. Data.
. Administration of the Innovision Financial Server for the project.
. Full functional testing of the system.
. Prepared the test plans to conver all the scenarios that are required
for the certification with Intuit and Microsoft vendors.
. Coordinated the testing with the Intuit and Microsoft vendors.
. Written many tuxedo services in C, Pro*C, BEA Tuxedo for the project.
Environment: Innovision Financial Server - 3.3.1, JDK 1.4.2_08, C, Pro*C,
BEA Tuxedo 8.1, XML, Oracle 8i, Ant build tool, PL/SQL, Unix Sun Solaris
2.8, Mercury TestDirector 8.0, Turbo Tax client software, Intuit's Quicken
& Microsoft Money software, UML.
NASD Interface with Licensing Workflow
To electronically process between Edward Jones and the NASD for Enrollments
data, U4 amendments, Partial U5's, Post exam data, Post approval data, Post
accounting data, Post pending data, Post deficiencies data, U4 -
additional state registrations and a full U5.
Role: Lead Developer
Responsibilities:
. Involved in design, coding, testing and implementation of the system.
. Designed the overall system that has various components like Java, C,
Pro*c, Shell Scripts, XML.
. Created various XML parsers using DOM and SAX parsers for parsing XML
documents.
. Developed overall flow of the system by scheduling the jobs using
AUTOSYS.
. Written many shell scripts that controls the overall flow of the
system.
. Involved in analysing the components and estimating the project.
Environment: JSPs, Java, C/C++, XML, Tuxedo, Oracle, Shell Scripts,
PL/SQL, pro*C batch jobs and Autosys for Scheduling the jobs, Visual Slick
Edit, UML, PeopleSoft Database, Mercury TestDirector 8.0, Ant build tool,
NSCC Interface with Licensing Workflow
Create a clearing-house interface through the National Securities Clearing
Corporation (NSCC) system to transfer Licenses and Appointments information
between Edward Jones and its insurance vendors. The system will automate
the communication with insurance vendors pertaining to the License
requests, appointment requests, renewals, terminations, name changes,
address changes, identification changes, QO changes, confirmations and
periodic reconciliation.
Role: Lead Developer
Responsibilities:
. Involved in design, coding, testing and implementation of the system.
. Created many Structured Query Report writers for the application
. Written many stored procedures for the application.
. Involved in designing the overall system that has many database
servers.
. Implementing the project with MET LIFE insurance vendor.
. Coordinated in transferring the knowledge to the support team to
implement with other vendors.
. Developed overall flow of the system by scheduling the jobs using
AUTOSYS.
. Involved in analyzing the components and estimating the project for
middle layer using various components.
Environment: JSPs for the front-end screens, Oracle, Shell Scripts, PL/SQL,
SQR (PeopleSoft Structured Query Report Writer) and AutoSys for Scheduling
the jobs, Visual Slick Edit, UML, PeopleSoft Database, Mercury TestDirector
8.0, Ant build tool,.
Licensing Workflow System
The Licensing Workflow project's purpose is to create an infrastructure
that will allow for the automation of work tasks associated with Licensing
and Insurance processes. Templates, Checklists, Activities list and Manual
Request system make up the Licensing Workflow application.
Responsibilities:
. Involved in design, coding, testing and implementation of the system.
. Involved in developing middle layer that uses BEA Tuxedo for accessing
Oracle database.
. Written many tuxedo services in C, Pro*C, BEA Tuxedo for the project.
. Involved in understanding the overall application that will be used in
building the applications like NASD Interface for licenses and NSCC
Interface for Insurance systems.
. Written many stored procedures for the application.
. Involved in analyzing the components and estimating the project for
middle layer using BEA Tuxedo.
Environment: Java, C/C++, Unix, Tuxedo, Java Script, Pro*C, Oracle, Shell
Scripts, PL/SQL, Visual Slick Edit, Visual Thought, PeopleSoft Database,
Mercury TestDirector 8.0, Ant build tool,.
LARSEN & TOUBRO INFOTECH, India (Feb 1998 - Dec 1999)
JP1/CM2 Java for Hitachi Ltd., Japan
The project was the JP1/Cm2, which was a family of program products for
network and systems management. It provided the functions such as
configuration, performance, and fault management for networks and systems.
The existing system was a straightforward single executable. This was
converted to client server architecture by moving the GUI part to the web.
The new design includes a client, which is the GUI portion of the existing
system and a server developed in C to respond to the requests sent by the
GUI. The server acts as middle-ware between the client and base product's
daemon. The server handles multiple simultaneous requests from clients. A
protocol was defined so the client and server could communicate
effectively. The GUI was developed as JAVA APPLETS. For every applet, a
CGI SCRIPT was developed which was executed when a sub-product was executed
through an option in base product. The CGI was written in HTML, which
included the sub-product applet.
Role: Team Member
Responsibilities:
. Involved in the design of the GUI screens.
. Coding and testing of the GUI screens.
. Performed the role of Hitachi QA groups for this project and ensured
that the project is delivered with zero defects.
. Acted as a member of the support group during the implementation
process.
Environment: C, Java, Java Applets, JDK, CGI, HTML, Windows NT 4.0
JP1/AM for Oracle Applications, Hitachi Ltd., Japan
JP1/Application Manager for R/3 is a program product required when
operating SAP R/3 system background jobs from a system other than the SAP
R/3 Client system or when running them with a JP1 Series program product.
Hitachi now requires the same system to be run for Oracle Applications (ERP
from Oracle). Oracle Applications system concurrent requests can be
controlled from a system other than Oracle Applications. It can do the
operations like Submit, Cancellation, Status and Acquiring Resource
information of Oracle Applications Concurrent Requests. We have developed
this command set as command line arguments. And the Submit command is
developed as GUI also.
Responsibilities:
. Team Member & IQA of a team of 13
. Setting up the required network.
. Developed the Pro*C part of the application using Dynamic SQL method
3.
. Prepared the unit test cases
Environment: Oracle Server 7.3.3 for NT Serer 4.0, C, VC++ 5.0 for NT,
PL/SQL, Pro *C/C++ V 2.2.4 for Win NT, HP9000, JP1 - AOM, AJS, SES for Win
NT, HP9000, Win NT Server 4.0.
JP1/NETM/DM Web Console for Hitachi Ltd., Japan
The Integrated Network Management System was a software resource management
system intended for large-scale enterprise networks and consisted of server
and client programs. The JP1/NETM/DM Web console features enabled
reference to resource information, which NETM/DM Manager controls, via web
browser. The scope of work was to change the base JDK1.0 to JDK1.1. The
work involved APPLET screen design changes and addition of new features.
The event handling was converted to event-delegation model of JDK 1.1. The
GUI enhancement, code changes and compilation were done using VISUAL CAF .
A part of CGI SCRIPTS were converted to JAVA SERVLETS. Worked as Project
Leader and managed a team of 9 members. In addition, communicated with
Hitachi regarding project management, status reporting and technical
issues.
Responsibilities:
. Involved in design of classes and detailed functional specifications.
. Developed GUI for message channel agent using JDK 1.1.6.
. Involved in module, product and system level testing.
. Responsible for setting up the system.
Environment: Java, Java Servlets, Java Applets, JDK, VISUAL CAF , WINDOWS
NT 4.0, SQLServer 6.5
JP1/NETM/DM for Internet for Hitachi Ltd, Japan
This project was the development of the GUI for the modules of Internet
Client, Web Administrator and Packager Internet for the project JP1/NETM/DM
for the Internet. This product facilitated file distribution and
collection in Internet and extranet. It supported distribution of JAVA
applications and user certification. This project involved all phases of
the development life cycle. Web administrator was JAVA APPLET, Packager
Internet was a JAVA application and Internet client was a C++ application
developed in VC++ 5.0 with MFC. Onsite implementation included the
integration of the GUI with the backend developed at Hitachi. On completion
of the project led the team during onsite implementation in Japan.
Responsibilities:
. Involved in design and development of Packager Internet Application.
. Involved in detailed functional specification of Packager Internet
Application.
. Prepared test case documents for module level testing and product
level testing.
. Involved in Module Level and Product Level testing.
Environment: Java, Java Applets, JDK, Borland's JBuilder, Visual C++ 5.0,
MFC, Windows NT 4.0, Oracle 7.3.