Kumar Lakkapragada
*** ***** ***** ****, **: **0-
Cedar Park, TX-78613
*****.************@******.***
SUMMARY OF EXPERIENCE:
12+ years of Industry experience, Quality Engineering, System Design
and Analysis on Client/Server based Applications.
SPECIFIC EXPERTISE:
.GUI, Stress, System, Regression, Integration, installation and
Functional Testing.
.Table manipulations using SQL.
.System Analysis and Design.
.Documentation and User Acceptance.
.Automation using Win Runner, Load runner, QA/Partner, QTP.
.Repository Migration and Configuration using Siebel Tools.
.Integration of Siebel with External Databases.
TECHNICAL SKILLS:
Tools: Win Runner, Load Runner, Test Director /QA Partner, QTP.
Languages: C, C++, VB script, Power script.
Databases: Db2390, Oracle 8.0/9.2/10g, Sybase 10.2/11, db2
6.1/8.1,SQL server.
Servers: BEA Tuxedo 6.3/6.4, MSMQ 1.0/2.0, Web logic, web sphere,
.NET
GUI:P B 6.5, VB 5.0/6.0, Forms 4.5, Reports 3.0, crystal reports
CRM: Clarify e Front Office9.Siebel 2000, Siebel 7.0/7.5.3
/7.7/7.8/8.0,Nexus2.0/3.0
OS: Zos 1.6/1.7,Sun/Solaris 8/9.2 HPUX 11i, AIX 4.33/5L,
Win2000/2003/XP
Red hat/Suse Linux.
PROJECT PROFILE:
Oracle USA, Inc (Mar'06- Till
Date)
Product: Fusion CRM V1- Lift & Shift & Customer Data Management
Description: For Fusion CRM M1, an Oracle database with selected
Siebel tables has to be created. Schema consists of Siebel 8.0 (HOR
and Loyalty from SIA).Lift & Shift dev have identified views that
will be converted to Fusion. Conversion tool will create
corresponding UI for these views and convert all the underlying
Business components to Fusion artifacts.
Responsibility: Work with management to ensure all needed resources are
available to complete tasks as per schedule. Enhanced discussion with team
members to listen to them, motivate them, to understand their goals, help
them to enhance their professional skills set .Ensured that team has all
the needed resources to complete the designated tasks with in the time
frame. Conducted 1 on 1 with individual team members to review their
objectives and training needs
Environment: jdeveloper, Oracle10g. Linux
Product: Data Migration - Siebel 8.0 - Fusion V1
Description: Data Migration is provided to Siebel CRM V8.0
customers who should explore migrating to Fusion V1
Responsibility: Identified the scope of the project and collected
Heuristics to estimate effort and resources needed for the Project by
running a pilot test cycle. Created QA Project Plan for executives to
secure approvals for resources needed for the project. Created and
implemented Test Execution Stategy for Data migration project against
mulitple source /target combinations. Worked with development and Product
Marketing to define defect logging templates.
Environment: jdeveloper, ODF, BIP, ODI, Oracle10g. Linux
Product: Siebel Universal Customer Master 8.0 and 8.1
Description: The Siebel Universal Customer Master is a Siebel
platform configured to store a clean and unified profile for
enterprise customers, partners, and prospects. Traditional customer
data such as Accounts, Contacts, Households, Partner, and Agent data
is included as well as customer relationship Information, address
information, and asset information. The Siebel Universal Customer
Master Interacts within enterprise architecture by integrating with
key back-office systems to act as the Master record for the customer-
specific subset of an organization's data.
Environment: AIX 5.2/5.3,Solaris,HPUX,WIN 2003/XP, db2390,
oracle9i/10g,
Mssql 2000, Haley Rules Engine, First Logic, Tibco, and Siebel Data
Quality.
Responsibility: As a Principle Quality assurance Engineer have
demonstrated ability to design and program test plans and scripts
that effectively test a product, Have in depth understanding of the
Siebel architecture and a broad range of product features, aptitude
for managing small projects. Sound judgment in areas of project
prioritization problem solving. Effective verbal and written
communication with peers, team members and management. Excellent
organizational and time management skills. Ability to deliver high
quality results.
. As a team lead am responsible for building the offshore team and
provided support.
. Managed onshore /offshore resources to deliver a high quality
product.
. Involved in Project planning and the test execution strategy.
. Reviewed design/functional specs to develop test plans based on
MRD and engineering specifications.
. Coordinated with marketing, engineering, and QA to ensure product
coverage.
Siebel systems, Inc (Nov'00-
Mar'06)
Product: Siebel Component Assembly 2.0 /3.0.
Description: Siebel Component Assembly delivers the essential
building blocks to help organizations build custom CRM applications
more quickly, easily, and efficiently. This product is built on an
open Service Oriented Architecture (SOA) that runs natively on both
.NET and J2EE application server platforms. Enables customers to
simplify and speed the design, development, and deployment of custom
CRM applications, enhance organizational decision-making, and
increase end-user productivity. The ability to define application
behavior in a metadata-driven, declarative development environment
vs. writing hundreds of lines of code .A complete set of prebuilt
CRM components for rapid development .End user productivity
integration components for Microsoft Office, Microsoft Outlook and
Micro Share Point .Multiple UI framework support for portal servers,
Web sites, and Microsoft Smart Client .Infrastructure support for
application concepts such as data federation and access control
Environment: J2EE, Web sphere, Web logic, .Net, Win2003/xp, db2390,
oracle10g, mssql
Responsibility: As a Lead QA Design engineer have demonstrated
ability to design and program test plans and scripts that
effectively test a product, Have in depth understanding of the
Siebel architecture and a broad range of product features, aptitude
for managing small projects. Sound judgment in areas of project
prioritization problem solving. Effective verbal and written
communication with peers, team members and management. Excellent
organizational and time management skills. Ability to deliver high
quality results.
. As a team lead am responsible for building the offshore team and
provided support.
. Managed onshore /offshore resources to deliver a high quality
product.
. Involved in Project planning and the test execution strategy.
. Reviewed design/functional specs to develop test plans based on
MRD and engineering specifications.
. Coordinated with marketing, engineering, and QA to ensure product
coverage.
Products: Siebel Tools, Siebel Server, Siebel Anywhere, Siebel-
Siebel (Siebel 7.0, 7.5, 7.7and SAP/Oracle Connector.
Responsibility: As a Senior QA Design Engineer in the sever Core
Components group handled multiple concurrent Projects (Repository
configuration, Repository Migration, Server Administration, Virtual
Business Components, Siebel Anywhere, Siebel MSMQ adapter and
External Business components and Siebel Analytics).
. Reviewed design/functional specs to develop test plans based on
MRD and engineering specifications.
. Coordinated with marketing, engineering, and QA to ensure product
coverage.
. Documented all defects into bug database using Siebel ebiz.
. Define requirements, and reviewed defects to improve the product
Quality.
. Worked on Integration of Analytics data into Siebel Application
using EBC connector.
. Trained and Coordinated Offshore Operations.
Expertise: NT, Win2000/XP, Sun/Solaris8/9.2,HPUX11i,AIX5.1/5.2,
db28.1/7.2 Oracle9.2,Sql Server 6.5/7.0/2000, MSMQ 1.0/2.0,db2390,
XML, Web sphere, iplanet 6.0,HP Apache 2.0, HTTP Server (IHS) 2.0.
Clarify, Inc (Nov'99-
Nov'00)
Products: Clear Enterprise e.link (Saturn, Saturn2i, Jaguar and
Cougar releases)
Responsibility: As a Quality Assurance Engineer in the sever
processes group.
. Created test environment for Clear Enterprise eLink Application.
. Responsible for writing Test Plans, Test Cases.
. Performed functional, internationalization/localization, System
and Regression testing.
. Involved in reporting software defects using Clarify Clear
Quality.
Expertise: NT, Sun/Solaris 2.6, HP/UX, RS-6000, db2 6.1, Sybase
10.2/11,Oracle 8.0,Sql Server 6.5/7.0, BEA TUXEDO 6.3/6.4, MSMQ
1.0/2.0, Clarify eFrontOffice9, Clarify Rule manager eFrontOffice9.
CENSUS BUREAU (Mar'99 -
Nov'99)
Accuracy Coverage Evaluation (ACE): This system handles the
sampling of Census 2000. This project is divided into three
operations like PAPI (manual operation), CAPI (Laptop operation),
and CATI (Telephone operation). Each of the operation is sub
divided into activities like define Manager Functions, Sample
control, Assignments, Check In/ Check out, Print/View reports and
etc.
Responsibility:
. Writing test plans, test cases
. Investigated defects and interact with developers to resolve the
technical issues.
. Load and stress test for multi-user environment using Load
Runner.
. Extensive use of third party controls like VBX's (like thunder
spreadsheet, thunder aware date time, thunder ware currency) for
integrity with the application.
Expertise: Win Runner, Load Runner, SUN S/2.0 Server, Win95/NT, PB
6.5 & Oracle7.2
BPL TELECOM (Jan'98-to sep'98)
Coreman Financials (CFN) - It consists of five modules - General
Ledger, Accounts Payable, accounts receivables, analysis and
voucher entry. This system handles the day-to-day transactions
like cash payments and receipts, bank payments and receipts,
creation of debit note and credit note, travel sanctions, creation
and retirement of bank documents and preparation of check request,
etc.
Responsibility: Analysis, design and development of accounts
payable module. Involved in the testing voucher entry module.
Configuration, regression, system and integration testing using
SQA-Team test. Verifying data sourcing and data integrity using
SQL. Responsibilities also included server testing. (i.e. crashing
the server while data is being downloaded).
Expertise: Win Runner, Load Runner SUN S/20 Server, Win 95, VB 5.0
& Oracle 7.2.
US. Pizza (Feb'96 to
Nov'97)
Integrated Software Solution System - This system consists of two
major modules- sales/ billing and inventory operations.
Sales/billing Module deals with acceptance of orders from
customers, preparation of kitchen order ticket (KOT), cancellation
of KOT, preparation of bill, payments and tips. Inventory module
deals with purchase, purchase returns, and issue of materials and
issue returns. It generates various MIS reports for analysis.
Responsibility: Analysis, design, development and implementation of
sales/billing module. Involved in testing and implementation of
inventory module. Involved in various testing processes like user
interface, performance, stress, load, installation, configuration
and regression testing. Utilized Tree view and picture list box
controls to display the activities.
Expertise: Windows 95, win runner, Visual Basic 5.0 & MS Access.
ICICI, Inc (April'95
toFeb'96)
Investors Information System (IIS) - This system is a data bank for
the investment department, which captures information of retail
investors and agents during public issue. It allots marks and
prioritizes the investors in three categories - high, medium and
low.
Responsibility: involved in the development of the system. Provided
query by example (QBE) feature in all screens/reports incorporated
field level help on the click of right mouse button Instead of drop
downs to all screens.
Expertise: Windows 95, Visual Basic 4.0 & MS Access.
EDUCATION
Master of Science in Computer Science.
Bachelor of Science in Computer Science.