Project Sql Server
Resume:
Pranab Kumar Kotagiri Phone: 732-***-****
Email: ***********@*****.***
Professional Summary
Over 9+ years of experience in development and design of various applications using Java/J2EE
technologies.
Key participant in all phases of software development life cycle with Analysis, Design, Development,
Integration, Implementation, Maintenance, Debugging, Reports, Testing, Production support of
Software Applications in client server environment and Web based applications.
Experience in core Java -Multithreading, collections, socket programming, J2SE, RMI and
JDBC.
Expertise in working with various Distributed technologies in J2EE area that includes Struts
(MVC), Servlets, JSP, EJB, JMS, JDBC, Hibernate.
Experience in Configuring and deploying applications on BEA WebLogic 9.x/8.x/7.x and Tomcat
5.5.23 application servers.
Extensive knowledge working with various IDE Tools, Eclipse 3.2/3.1/2.1.1 and JBuilder.
Extensive use of various J2EE Design Patterns such as Business Delegate, Singleton, Session
Facade, DTO and DAO in designing of large applications.
Knowledge of UML, X ML (SAX, D OM ), XSL, XSLT, SOAP.
Developed multi-tiered object-oriented system architectures utilizing Use cases, UML diagrams,
Rational Rose, RUP process.
RDBMS concepts and extensively worked with Oracle 9i/8i, PL/SQL, SQLServer 7.0, MS SQL
Server 2000.
Familiar with coding stored procedures, Triggers and Functions using PL/SQL.
Experience in System maintenance, analysis and performance in Windows, UNIX and Linux
environment
Certifications
TM
Sun Certified Java Programmer Java2.0 with 86%
Qualifications
Master of Computer Application, Kakatiya University, Andhra Pradesh, India.
B. Sc (Elec), Osmania University, Andhra Pradesh, India.
Technical Skills
Languages Editors & IDE
C, C++,Java 2, XML, HTML Cute HTML, Edit Plus, Textpad,
Front Page, E clipse and JBuildrer
WebTech. WEB & App
JSP, Servlets, EJB, JNDI, IIS, JRUN, iPlanet, WebLogic,
Servers
JDBC, JavaBeans, RMI, Apache
Struts
Operating Procurement &
Windows NT/XP, DOS, Ariba Buyer, Ariba e-Sourcing,
System EAI Tools
Win95/ 98/, UNIX, SOLARIS. Ariba Analysis, Ariba Cat Man,
TIBCO
Internet Version
Javascript, VBScript, JSP, Visual Source Safe, Clear Case
Control
Servlets.
RDBMS Design Tools
Oracle 8i/9i, SQL Server 7.0 Rational Rose, MS Project, MS
Visio 2000
Career Profile
Projects Handled:
Duration: Apr 2007 to till date
1. Poject : Business Management System
Cleint : E&Y
Team Size: 4
Role: Tech Consultant
Responsibilities:
Involved in Loan application Module functionality.
Involved in analysis, specification, design, and implementation and testing phases of Software
Development Life Cycle (SDLC ) and used Rational Unified Process (RUP ) to develop the project.
U sed U ML with Rational Rose to design the Object Model [Use Cases, Activity Diagrams,
Sequence Diagrams, Class Diagrams and Component Diagrams]
Used Struts framework to implement MVC design pattern.
Consumed Web Service using W SDL and SOAP to get the credit history from the service provider.
D eveloped user in terface using JSP, JSP Tag libraries to simplify the complexities of the
application.
Adapted various design patterns like MVC, Business and Session Façade.
Extensively used Hibernate in data access layer to access and update information in the database.
Utilized PL/SQL for querying the Database and Written stored procedures and triggers
Environment:
JSP 2.0, Struts 1.1,Hibernate 3.0, XML, XSL, XSLT, JMS 1.1, CVS, JUnit 3.8.1, Oracle, Shell Scripts,
UNIX, RUP, Rational rose (UML design tool).
Duration: May 2006 to Feb 2007
2. Project: Loan Application Module
Client: Pfizer
Team Size: 6
Role: Tech Consultant.
Responsibilities:
Worked in the Analysis, Design, development, testing and production phases.
Involved in the development of modules as per the functional specification documents and closely
interacted with the business team in understanding the business requirement.
Worked on the Struts framework based on the MVC architecture
Worked on the technologies like J SP, Servlets, JDBC, Java Beans, EJB, Ja vaScripts, XML, CSS
for developing various modules such as Customer Care and Knowledge Management.
Involved in developing business components using s tateless session EJBs and creating Data
Access Object’s (DAO)to interact with the databases using JDBC
Involved in designing the data model and writing the SQL scripts in Oracle 10g
Used Log4j for logging in the application
Involved in the peer review of the code as per the coding standards
Involved in the Knowledge transfer of the business functionalitites to the peers
Involved in performming Unit Testing by writing Unit Test Plan and Unit Test Result using J Unit.
Written necessary mapping files between the portal application and CRM APIs so that portal initiated
operations can invoke the correspnding SimpleRM APIs to fetch and pull data into the SimpleRM
database.
Wriiten the CRM APIs related operation such as create portal user, create/view support request,
contact writer, incident writter, worknote writter, sending email, show statistics, etc.,
Worked for the production support phase and fixed the reported defects.
Environment:
J2EE, Java 1.2/1.3, Rational Rose Professional J Edition, RUP, IBM-Web Sphere 4.0/5.0, Visual Age
for Java 4.0, PVCS version control, XML, Java Servlets, JSP, JNDI, DB2 7.1, Oracle8i, VB 6,
Struts1.1, HTML, JavaScript, Log4J, J Unit
Duration: Nov 2005 to Jan 2006
3. Project: Automated Enrollment System (AES)
Client: MetLife
Team Size: 4
Role: Tech Consultant.
Responsibilities:
Designed the application architecture of the System based on MVC (Model View Controller), Struts
Framework and J2EE specifications.
Used Design Patterns such as session facade and Factory.
Responsible for designing, coding and developed the application in J2EE using MVC architecture.
Developed the presentation layer using JSP and Servlets.
Developed S ession Facade objects using S tateless session beans (EJB 2.0) for having single
point of control for a business service.
Incorporated Login authentication by using JSP and verifying it with database security tables.
Oracle Database design and built PL/SQL script for database translation.
Extensive involvement in database design, development and coding of D DL & DML statements,
functions. Extensively involved in determining the data needed to address business user’s analytical
requirements and design data mart to support these analysis.
Environment:
Weblogic server 8.1, J2EE, EJB, Struts, Servlets, JDBC, JSP, XML, HTML, Design Patterns, Java
Script, ANT, JUnit, JMS, Rational Rose, Unix, Web Logic, Windows NT, Oracle.
Duration: Nov 2004 to Oct 2005
4. Project: Buyer Migration
Client: BEAR STERNS
Team Size: 6
Scope:
Migration of Buyer 7.0.6 to 8.2 on Dev, QA and Production Environment, implementation of Ariba
Category Procurement
Role: T ech Consultant.
Responsibilities:
Gather the requirements from the end client
Doing the gap analysis
Preparation of Sand Box on windows and Solaris environment
Running IVT, Harness
Fixing issues related AML, AWL, AFR
Fixing issues related to Java Code
M a nually migrating TIBCO sheets
Migrating database to UTF8 format
Integration with Ariba Sourcing and Category Management
Environment:
Java, AML (Ariba Markup Language), TIBCO, WebLogic 8.2
Windows NT 4.0, SQL Server 7.0, IIS Web Server, Ariba Buyer 8.2.
S un Solaris 8, UDB DB2 7.0.8.0, Apache Server, PeopleSoft 7.5
5. Project: CEP Implementation
Client: BEAR STERNS
Scope:
Detaching the CEP Balance field from the user object and create new object and apply restrictions while
creating PR.
Role: Tech Consultant.
Responsibilities:
Modifying existing AML files and java files to remove the CEP Balance Field
Create new AML file for the CEP object
Create new MB sheet to pull the CEP Balance amount from PS
Create new File Channel integration event to pull the CEP Restricted commodity codes
Custom condition to check the CEP restricted rules
Custom trigger to update the CEP Balance amount
Custom condition to control the visibility of the CEP Related fields
Environment:
Java, AML (Ariba Markup Language), TIBCO, WebLogic 8.2
Windows NT 4.0, SQL Server 7.0, IIS Web Server, Ariba Buyer 8.2.
Sun Solaris 8, UDB DB2 7.0.8.0, Apache Server, PeopleSoft 7.5
6. Project: Profile ID Implementation
Client: BEAR STERNS
Scope:
To identify whether the item is an asset or non-asset item based on the cost center, division and push the
value.
Role: Tech Consultant.
Responsibilities:
Create new profile id field in the AML
Create new MB sheet to pull the Profile ids from PS
Modify the MB sheet to push the Profile id value to PS with other item details
Custom trigger to update the profile id filed with the appropriate value
Custom condition to control the visibility of the accounting fields based on profile id.
Environment:
Java, AML (Ariba Markup Language), TIBCO, WebLogic 8.2
Windows NT 4.0, SQL Server 7.0, IIS Web Server, Ariba Buyer 8.2.
Sun Solaris 8, UDB DB2 7.0.8.0, Apache Server, PeopleSoft 7.5
7. Project: Ariba ACW Customization
Client: BEAR STERNS
Team Size: 6
Scope:
Implementation of Category Management solution along with Ariba Contract Workbench
Role: Tech Consultant.
Responsibilities:
Gather the requirements from the end client
Doing the gap analysis
Building QA, Master Dev
Customizing ACM (creating new project types)
Added few custom fields and validations
Added few new filed to CR
Loading existing contracts into Buyer
Testing
Environment:
Java, AML (Ariba Markup Language), WebLogic 8.2
Windows NT 4.0, SQL Server 7.0, Ariba Buyer 8.2. And Category Management 2.0
Sun Solaris 8, UDB DB2 8.x, Apache Server
8. P roject: Ariba Sourcing and Ariba Category Management
Client: BEAR STERNS
Team Size: 6
Scope:
Implementation of Ariba Sourcing and Category Management solution along with Ariba Contract
Workbench
Role: Tech Consultant.
Responsibilities:
Gather the requirements from the end client
Doing the gap analysis
Preparation of Sand Box on windows and Solaris environment
Building QA, Master Dev
Customizing ACM (creating new project types)
CDS Filters, Identifying roles and permission
Preparing the Master Data (Commodity codes, suppliers, unit of measures and etc)
Environment:
Java, AML (Ariba Markup Language), WebLogic 8.2
Windows NT 4.0, SQL Server 7.0, Ariba Sourcing 4.2. And Category Management 2.0
Sun Solaris 8, UDB DB2 8.x, Apache Server,
9. Project: Buyer Production Support
Client: BEAR STERNS
Team Size: 2
Scope:
Maintenance and support of Production Box
Developed Code for ACSN Bypass
Developed a B-Form
Developed Approval Rules
Developed E-Form
Role: Tech Consultant.
Responsibilities:
Running Integration Events and Scheduled Tasks
Bug fixing
Managing Purchase Orders and Invoices
Environment:
Java, AML (Ariba Markup Language), TIBCO
Windows XP, SQL Server 7.0, IIS Web Server, Ariba Buyer 7.1a.
Sun Solaris 8, UDB DB2 7.0, Apache Server
PeopleSoft 7.5
Duration: Aug 2003 to Oct 2004
10. Project: Approval Rules
Client: San Miguel Philippines
Scope:
Designing and developing approval rules based on commodity code, pricing conditions, division, partition
and group with dynamic approvers.
Role: Tech Consultant.
Responsibilities:
Designing approval rules for each division.
Developing group specific rules
Developing partition specific rules
Developing global rules
Implementing dynamic approval nodes.
Environment:
Java, JavaScript AML (Ariba Markup Language), TIBCO, WebLogic 7.2
Windows NT 4.0, Oracle 8.1.7, IIS Web Server, Ariba Buyer 8.1.
SAP R/3 4.6C, 4.5B, 4.6B, 4.0B, 3.1I.
11. Project: ACM
Client: San Miguel Philippines
Team Size: 10
Scope:
Implementation of ACM along with ACW and customization of contacts compliance module in Ariba
buyer.
Role: Tech Consultant.
Responsibilities:
Installing ACM in Dev and QA
Customized Contracts module in buyer added few fields and did validation
Loading existing contracts in to Ariba buyer
Testing
Environment:
Java, JavaScript AML (Ariba Markup Language), TIBCO, WebLogic 7.2
Windows NT 4.0, Oracle 8.1.7, IIS Web Server, Ariba Buyer 8.1, ACM 1.0
SAP R/3 4.6C, 4.5B, 4.6B, 4.0B, 3.1I
12. Project: Pricing Conditions
Client: San Miguel Philippines
Team Size: 10
Scope:
Implementing custom taxing and pricing conditions where user should be able to select different pricing
conditions that has to be applied for the item.
Role: Tech Consultant.
Responsibilities:
Creating new object to hold the pricing condition information.
Integration event to pull the available pricing conditions and respective rates
Custom trigger to set the values based on pricing condition, value of the item and shipping location
Custom validation class to validate the amount and the pricing condition based on the item and
division
Environment:
Java, JavaScript AML (Ariba Markup Language), TIBCO, WebLogic 7.2
Windows NT 4.0, Oracle 8.1.7, IIS Web Server, Ariba Buyer 8.1.
SAP R/3 4.6C, 4.5B, 4.6B, 4.0B, 3.1I
13. Project: STEP-UP
Client: San Miguel Philippines
Team Size: 10
Scope:
San Miguel Philippines, is interested to use the Ariba Buyer 8.1, Ariba Sourcing 4.1, Ariba Analysis 2.5.1,
Ariba Category Management 1.0 for automating there procurement process. The scope of the project
includes
Integration of 10 SAP Divisions (Sister concerns of San Miguel Inc.), which are in different versions of
SAP right from SAP 3.0 to SAP 4.6C.
Integration of 1 Oracle Finance for 1 Division
Integration of all ASM Products
Integration of Buyer with ASN
Customization of PR/PO format, Customization of Approval flow according to the organization
business rules and Report customization.
Pulling the data from the SAP and Oracle Finance.
Building the Catalog.
Importing Contracts
Invoice Reconciliation in Dispute management
Designing the new Reports in Analysis
Role: Tech Consultant.
Responsibilities:
Gather the requirements from the end client
Doing the gap analysis
Setting up and configuring the Ariba Buyer System, which involved, user addition, configured to
server for e-mail notifications, importing catalogs through e-mails.
Managing catalogs using CIF and cXML formats initially carried out ad-hoc imports and imported
catalogs through e-mails.
Developed custom Java code for filtering supplier data to specific partitions.
Designed and implemented Approval Rules using JavaScript.
Customized few integration events, TIBCO Message Broker work sheets.
User Interfaces were customized using Ariba MetaXML.
Environment:
Java, JavaScript AML (Ariba Markup Language), TIBCO, WebLogic 7.2
Windows NT 4.0, Oracle 8.1.7, IIS Web Server, Ariba Buyer 8.1.
SAP R/3 4.6C, 4.5B, 4.6B, 4.0B, 3.1I.
Duration: Dec 2002 to Aug 2003
14. Project: eTSR
Client: Merrill Lynch
Team Size: 4
Scope:
Merrill Lynch US is interested to use the Ariba Buyer for approving the day – to – day services, like
moving the pc from one place to another, enhancing the RAM in a pc and etc. The Scope of this project
includes creation of Bform, submitting the PO to an external system using ASN, pulling the data from
CSV to Buyer database, writing an approval rule and finally a hyper link to connect to the external
application to know the status.
Role: Tech Lead.
Responsibilities:
Setting up and configuring the Ariba Buyer System, which involved, user addition, configured to
SMTP server for e-mail notifications, importing catalogs through e-mails.
Managing catalogs using CIF and cXML formats initially carried out ad-hoc imports and imported
catalogs through e-mails.
Developed custom Java code for filtering supplier data to specific partitions.
Designed and implemented Approval Rules using JavaScript.
Implemented new integration events using metaXML and TIBCO Message Broker.
User Interfaces were customized using Ariba MetaXML.
Environment:
Java, JavaScript AML (Ariba Markup Language), TIBCO, WebLogic 7.0
Windows NT 4.0, Oracle 8.1.7, IIS Web Server, Ariba Buyer 8.1.
15. Project: Consumer Marketing Information System
Client: UNILEVER
Team Size: 4
Scope:
Unilever has computerized most of its departments, now they wanted to use Ariba’s approval process for
analyzing the usage of the existing projects and the requirement of new Projects. The management would
decide whether a project should be extended or a new project should be started, based on the market
research done by the requester. The scope of the project includes creation of an eForm, converting
eForm to PR, and submitting the same.
Design the solution as an eForm and develop, test and deployment
Configure SAP partition of Ariba Buyer for CMI eForm.
Automatic conversion of eform request to Purchase Order
Approval Rules
PO and Receipt Push to ERP
Receipt value updating to Eform
Role: Tech Lead.
Responsibilities:
Development, validation and testing of E-Form
Integration
Receipt value updating
Approval Rules
Environment:
Java, JavaScript, AML (Ariba Markup Language), TIBCO, WebLogic.7.0
Windows 2000, Oracle 8.1.7, iPlanet Web Server, Ariba Buyer 8.0.
SAP R/3 4.6C
Duration: Jan 2001 to Dec 2003
16. Project: Rollout of Ariba
Client: Korean oil major
Team Size: 4
Scope:
This project is a rollout of CSV based Ariba implementation for Korea oil major.
Customization of PR/PO format
Customization of Approval flow according to the organization business rules
Report customization.
Responsibilities:
Setting up and configuring the Ariba Buyer System.
Developed custom Java code for validation and Customization of User Interface using AML.
CSV based integration using TIBCO.
Environment:
Java, JavaScript, AML (Ariba Markup Language), TIBCO.
Windows 2000, SQL Server 7.0, iPlanet Web Server, Ariba Buyer 7.1(a).
17. Project: Integration of Ariba Buyer with SAP using ACTA & BC - Proof Of Concept.
Team Size: 4
Scope:
The scope of the project includes pulling ERP related information like Cost Center, account etc., into
Ariba Buyer from SAP using the TIBCO and pushing PO and receipts back to (SAP 4.6C) using the ACTA
& BC.
Responsibilities:
Creating new TIBCO message broker worksheets and modifying the existing ones.
Pushing PO to SAP using the ACTA & BC.
Pulling the PO number from SAP using ACTA & BC
Environment:
Java, JavaScript, AML (Ariba Markup Language), TIBCO.
Windows 2000, SQL Server 7.0, iPlanet Web Server, Ariba Buyer 7.1(a).
18. Project: Integration of Ariba Buyer with Oracle Financials - Proof Of Concept
Team Size: 4
Scope:
The scope of the project includes pulling ERP related information like Cost Center, Account etc., into
Ariba Buyer from Oracle Financials and pushing PO and receipts back to Oracle Financials.
Responsibilities:
Configuring Ariba Buyer for integration like creating variants and partitions, updating integration event
entries etc
Creating new TIBCO message broker worksheets and modifying the existing ones.
Fixing the errors that arise during the integration
Environment:
Java, JavaScript, AML (Ariba Markup Language), TIBCO.
Windows 2000, SQL Server 7.0, IIS Web Server, Ariba Buyer 7.1(a).
Oracle Financials 11i
19. Project: TRW-ASG Original Equipment & Maintenance Repair & Overhauling Forecasting
System.
Team Size: 12
Scope:
TRW’s Aeronautical Divisions, manufacturers Line Replaceable Units (LRU) needs to predict its future
business for the future 20 years. The forecasting takes into consideration, the two main sources of
business to TRW, which are Original Equipment (OE) and Manufacturing, Repair and Overhauling
(MRO). Apart from functional complexities the major requirement for the client is at the performance level
where millions of records need to be handled in a reasonable time and provide many functional reports,
which form their basis for quantities to be manufactured. In this project a novel attempt is made to bring
this kind of a forecasting engine to the web, which should be the first of its kind. This Project has two
major modules one which caters to the requirement of OE and other, which takes care of MRO. This
project is developed using JSP Technology for the Front end and Java as the language for developing the
Object Model, which forms the backbone of this forecasting Engine. For MRO where the data is very
huge, the traditional programming consumes time, for attaining high performance we have used a new
concept called Object Model in Memory. The concept of Partitioning in oracle is used extensively to
improve the performance of database operations
Role: Module Leader.
Responsibilities:
System Analysis
Database Design
Design of Object Model
Development
Implementation
Environment:
Java, JSP, Java Script, Oracle 8.1.7
Windows NT/2000, Jrun 3.0.
20. Project: TRW -ASG Customer Relationship Management (CRM).
Team Size: 4
Scope:
TRW’s Aeronautical Division has a huge customer base; the forecasting process takes inputs from this
customer database in order to generate the forecasting results. The unit was also interested to allow
shared access the database by key customer interface functions, they wanted to integrate the forecasting
application with rest of the applications and enable the worldwide accessibility through network and the
internet (AeroVantix portal) with a simple, familiar interface
CRM is a tool that:
1. Aids better management of the customer interface
2. Has a common shared system for key customer interface information
3. Manages opportunity capture in line with business processes
4. Improves market knowledge through shared competitor/ partner information
5. Is an information source but is not a driver of actions
The key elements of CRM are:
Companies
Contacts
Meetings
Opportunities
Events
Voice of the Customer
Role: Tech Lead.
Responsibilities:
System Analysis
Database Design
Design of Object Model
Development
Environment:
Java, JSP, Java Script, Oracle 8.1.7
Windows NT/2000, Jrun 3.0.
Contact this candidate