PULLARAO (RAO) MITTAPALLI
abnyiu@r.postjobfree.com
Summary:
. 13+ years of Overall IT experience with 10+ years of extensive experience
in Testing, Business Analysis, Coding, and Implementation of Mainframe,
Siebel, Client\Server and Web based applications.
. Involved in implementing, defining, designing, testing, supporting and
developing web/SOA based and client server environments.
. Good experience in software System testing, Integration testing, White
Box Testing, UAT, PST, GUI Testing, Regression, Smoke Testing, System
Acceptance testing, Interface Testing, Adhoc Testing, DB Testing,
Functional Testing and Manual Testing.
. Proficient in SOAP Web Service Testing & Automating Web Services using HP
Service Test Tool.
. Involved in Project Management - Worked on Integrating and Data modeling
core business processes CRM Siebel applications, E Commerce, and Web
Applications & DWH Applications.
. Worked extensively on XMLs, XSDs, WSDLs,UDDIS,JAVA/JBOSS,Java Messaging
Services, TCP/IP Protocol, Tibco interface testing, and Web services
Testing on Service Oriented Architecture(SOA) tool and SOAP (Simple
Access Object Protocol)Tool
. Experience in various domains like Smart Grid Retail Energy, Banking,
Financial, E-Commerce, B2C&B2B Portal, Telecommunication, Country Store
Outlets and Pharma.
. Strong knowledge in SDLC Concepts, STLC Concepts, QA Methodology and
Project Management Concepts.
. Worked on very tight deadlines and followed Agile/Scrum methodologies to
sucess the projects for various clients.
. Extensively worked on Smart Grid IT implementation for Utility and Energy
client.
. Strong expertise to lead the project with the high expectations.
. Good Exposure on Point of Sale concepts and billing domain expertize.
. Worked as Onsite & Offshore coordination for various clients.
. Worked as a Test Lead for Various offshore companies.
. Good Exposure Windows, UNIX, Linux environments and also able to execute
the Shell & Perl on command line interface.
. Good exposure creating the test data before executing the test on various
application domains.
. Good expertize in back end validation using Oracle SQL & Teradata using
various client tools.(TOAD,SQL Developer, SQL Assistant for Java and
Windows)
. Good expertize to create test reports for various projects using HP
Quality Center ALM 11 Version.
PROFESSIONAL EXPERIENCE:
Oklahoma Gas and Electric (OG&E), Oklahoma City, OK
Aug'11 - Till Date
Sr.QA Analyst
Smart Grid IT at Oklahoma Gas and Electric (OG&E) program involves system-
wide deployment of a fully integrated advanced metering system,
distribution of in-home devices to almost 6,000 customers, and installation
of advanced distribution automation systems. Smart Grid IT allows smart
meter customers to view their electricity consumption data at any time
through a personalized Web site (study participants are testing other
visual displays), and also allow OG&E to manage, measure, and verify
targeted demand reductions during peak periods. New systems capture meter
information for billing and implement new customer pricing programs and
service offerings. The project deploys a more dynamic distribution
management system, automated switching, and integrated voltage and reactive
power control (IVVC) that reduces line losses, reduces operational costs,
and improves service reliability.
Responsibilities:
* Design, development and execution of test plans, test cases, and test
strategies.
* Single handedly completed various projects for the smart Grid IT
Implementation.
* Good expertize working on multiple projects at a time with tight
schedules.
* Fast learner and Team player on any new technologies and also eager to
work on any applications.
* Good expertize using Quality Centre for various projects, Create Test
Plans, execute Test Cases, Requirement traceability matrix, generated
various test reports.
* Expertize to work in fast paced Agile development model.
* Experience in functional, integration, performance, data quality and
regression testing.
* Identify project risks and recommend actions to minimize risk
* Experience with large horizontally scalable distributed component
architectures including distributed databases and large Web/SOA
application architectures
* Good expertize in Java Messaging Service ((Hermes JMS, GEMS), XMLs,WSDLs, XSD Schemas, JBOSS and Web Services(SOAP UI Tool and HP Service
Test) and Java based applications.
* Mentor and train 1-2 other engineers, lead larger projects, prioritize
test activities and find creative solutions to blocking issues and
problems
* Good Expertize in Tibco products like Tibco Designer, BW, EMS, CLE
(Exceptions, Log, Configuration) & Enterprise Service Bus components.
* Good Expertize in automating the web service test cases using SOAP UI
Tool 4.5 Version and HP Service Test 11.2 Version.
* Good Experience in File Load process, batch load process and load the
test data.
* Read the Meter and Register Interval data from Silver Spring Network UIQ
system
* Good experience on Searching the events, devices, Reports, Networks,
Schedules and exports
* Experience working on windows NT and Unix/Linux systems
* Tested Daylight Saving Time (DST) for Fall & Spring Meter Interval Data.
* Tested Topic Messages and Queue Messages using Hermes JMS Tool & Gems
Tool.
* Tested and extracted meter interval data(15 minute Interval) Meter
Interval status from MDMS to Info Factory(Teradata Extract) by running
the ETL Job Scheduler from the web interface
* Documented and track defects in JIRA & QC, as well as produce detailed
reports using defect tracking tools
* Expertize in troubleshooting and identify the issues while doing the test
execution.
* Good Expertize in backend validation using SQL Developer, Toad and
Teradata db.
Environment: Soap UI Tool 4.5 & 3.5, HP Service Test 11.20(Automation
Tool), Silver Spring Networks(SSN)UIQ AAM4.4.7.2, Tibco Designer 5.7.1.2,
Tibco EMS 6.1, WSDL, XMLS, XSDs, Schemas, Hermes JMS Tool V1.14, BMC Remedy
7.6, HTTP Protocol, SMTP Protocol,,HP ALM Quality Center 11, Sprinter 11,
Linux, TIP version to 2.2.0.1 FP7, Omnibus version to 7.3.1 FP4, Cute Ftp,
Jira 4.5 Defect Tracking Tool, MDMS EI Server 8.9.21, GEMS 3.3, AIX OS,
Oracle SQL Developer 2.1.0, Teradata 13.20 & Microsoft SharePoint
KeyBank, Cleveland, OH
April'11 - July'11
Test Lead
Extreme Makeover - KNB Sales Tool project encompasses planning, designing,
developing, testing and implementing an easy to use, brand new CRM Sales
Tool for Key Corporate Bank. The benefiting user community includes the
Sales Professionals, Managers, the Support Staff and Data Administrators
from a variety of Lines of Businesses and Product Groups.
Responsibilities:
* Analyzed business Requirement's, Technical Design and Release Notes
Walkthroughs with business groups.
* Created Test Strategy, Test Plans, Test Cases and Test scenarios in
Quality Center, and mapped the test cases to Requirements.
* Experience in leading the team from onsite and Offshore Role model.
* Assigning the day to day work priorities to offshore team
* Defects were tracked and prioritized using HP Quality Center Tool.
* Tested this application using different Line of Business users
* 800 users were involved in this application
* Involved in UAT Test, Regression Test, Functional and System Integration,
Data Integration, batch testing in Test & UAT environments.
* Reviewed and Modified Existing scripts and also developed new scripts for
the new functionality.
* Proactively solve problems and suggest process improvements
* Mentor junior engineers to build their skills and contribution levels
* Good Expertize in Corporate Banking Domain Applications including
analytics dashboards, reports, profitability matrix, revenue by product
etc.
* Write test status reports and escalate issues as appropriate
* Reviewed the test case which was written by offshore team.
* Expertise in Test Data preparation for this project.
* Querying the results using Oracle Pl/SQL.
* Validation of Test Plans injecting SQL queries using database Oracle10g
and TOAD.
. Involved in testing the Organizations, Positions, Responsibilities,
Products, Company Hierarchy, Dashboards, Reports, Aggregate rules, Admin
users & Support users etc.
Environment: Siebel 8, OBIEE Reports, CRISP, CIX Integration, Oracle SQL
Developer 2.1.0, Oracle 11g, DAD, BoB Transfer Tool, CUCU Tool, Cognos
Reports, AS/400, UNIX, Web services, Windows XP, HP Quality Center 10, WIN
SCP 4.2.5, IBM DB2.
My Macy's Rewards, Atlanta, GA
Jan'10 - Jan'11
Role: Sr.QA Analyst
Macy's Loyalty program was introduced to grow Macy's store sales and
improve customer loyalty through a tender neutral rewards program. The
loyalty program would initially reward customers based on their number of
visits. The offers would entice customers to visit and purchase from our
stores more frequently in order to earn rewards. The project has been
declared one of the biggest successes in the recent history of the company.
This project also set a precedent to all the other retailers by embracing
cutting edge technology like Complex Event processing (TIBCO BE).
Roles & Responsibilities:
. Involved in Requirement Analysis based on the BRD, RDD,TDD and also
participated in Business and Technical Review meetings
. Co-ordinated with Business teams and Development teams during Test
Planning Phase to prepare the various test documents including Test Plan,
Test Strategy and Test Cases.
. Involved in executing the test cases and test scenarios for Smoke
Testing, Functional and System Testing
. Involved in validating the Web Services related to Customer, Account and
Transaction Management using the SOAP UI 3.5
. Involved in executing and validating SPOS (Smart Point of Sales)
transactions like Purchase, Returns, Post void, Presales and Shipments.
. Involved in Customer Enrollments and Customer Lookups and Customer Info
and Account Maintenance using SPOS, MCOM and ICM
. Involved in loading and validating the WSDLS in SOAP UI and preparing the
Request XMLs
. Involved in validating the Request and Response XML in SOAP UI Editor
. Involved in validating the Business Processes developed in TIBCO Business
Events and TIBCO Business Works
. Involved in validating the Logs and Exceptions in TIBCO CLE (Common
Logging & Exception)
. Involved in triggering the JMS messages manually using TIBCO Designer 5.6
. Involved in data extractions, file extractions and file transfers in UNIX
environment using WINSCP
. Involved in validating the Daily and Weekly Batch jobs like Presales to
Rewards Conversions, Award Purge, Transaction Purge and Reward Markdowns.
. Involved in writing SQL statements in Oracle ODS and DB2 for data
validation
. Extensively used Bug Tracker to raise defects, generate reports etc.
. Conducted daily meetings with Project and Development teams to discuss
testing and to prioritize defects and issues
. Involved in preparing Test Execution Status reports and graphs using
Excel
Environment: SOAP UI 3.5, TIBCO Active Matrix Business Works (BW) 5.7.2,
TIBCO Business Events 3.0.1, TIBCO Designer 5.6.0, TIBCO Enterprise Message
Service 5.1.2, TIBCO Hawk 4.8.1, TIBCO Rendezvous 8.1.2, TIBCO Runtime
Agent 5.6.1, TIBCO CLE 2007, XML, Oracle SQL Developer 2.1.0, Oracle 11g,, AS/400, UNIX, Web services, Windows XP, Bug tracker 3.0, WIN SCP 4.2.5,
IBM DB2.
Cox Communications, Atlanta
March'09 - Dec'09
Ecommerce Tester
Cox Content Store Application that will give Cox wireless customers a
richer experience while downloading content/application for their wireless
devices through the Cox.com website. Cox will be partnering with various
Content Vendors for making available content along with other media assets.
The Content Store Application will allow the user to browse, preview and
purchase content/application. The purchase transaction will be sent to
QUALCOMM's Brew Zone. Brew Zone will send the purchase request for
authorization to BMC which validates user details against Cox Oracle BRM
through Active Mediation.
Responsibilities:
* Analyzed business Requirement's, Functional Design, Technical Design and
Release Notes Walkthroughs with business groups.
* Lead projects and provide technical supervision to other QUALITY
ENGINEERING staff
* Good Experience in Agile methodology.
* Created Test Plans, Test Cases and Test scenarios in Quality Center,
Mapped the test cases to Requirements.
* Experience in Automate the creation, execution and analysis of
functional, regression, sanity and performance tests for Siebel and
Ecommerce applications.
* Generate and download reports, approve, publish, edit, reject content and
maintaining other administrator profiles.
* Download content from the Cox Web Content Store like ringtones &
Graphics, games, applications, what's hot and news sports & Weather etc.
* From the requirement and system requirement document to come up with a
detailed Test Plan
* Verified data content after ran the batch jobs for Daily, Monthly, Weekly
and Monthly.
* From the requirement and system requirement document to come up with a
detailed Test Plan
* Executed Test Cases manually to check GUI and Functional features of the
application.
* Defects were tracked and prioritized using Quality Center Tool.
* Tested this application using different logins like Guest/Anonymous
Customer, Existing/Authenticated Customers etc.
* Tested Request XML Data and Response XML data which was sitting in the
Logs.
* Verified the XML content when the batch jobs ran in UNIX environments.
* Involved in UAT Test, Regression Test, Performance Test and System Test
and supported to Production environments.
* Reviewed and Modified Existing scripts and also developed new scripts for
the new functionality.
* Involved in Integration testing using XML validations which the data is
coming from external application using middleware components.
* Good Experience on POS system using BRM.
* Account data has been loaded using UNIX batch jobs.
* Querying the results using Oracle Pl/SQL.
* Validation of Test Plans injecting SQL queries using database Oracle10g
and TOAD.
. Involved in Creation of Organizations, Positions, Responsibilities,
Products, Product Classes, Product Attributes, Sites, and Franchise
Groups etc.
Environment: Windows XP, Java, CRM, MCS, IDM, SMSC, Qualcomm, WCM,
Brewzone, Quality Center 9.2, Web Services, HTML, Tibco interfaces, XML,
Oracle 10g, ICOMS Billing, Order Express, CNS, Ingrain, Unix, Visual
Studio, QTP 10, Cute FTP
Alltel, Atlanta
Jan'06 - Feb'09
Senior QA Tester
Alltel is the largest regional mobile phone company in America, and the
fifth largest mobile phone company overall. With a market cap of $24.79
billion and around 13 million customers, the company focuses on small to
medium-sized cities, and also has low-cost roaming agreements with the
major national carriers.
Responsibilities:
* Full Lifecycle Upgrade conversion from Siebel e-Communication 7.5.3 to
Siebel7.8. Work included planning, analysis, design, development,
implementation, testing and support of the conversion process in a
UNIX/NT environment.
* Analyzed business Requirement's, Functional Design, Technical Design and
Release Notes Walkthroughs.
* Created Test Plan, Test Cases and Test scenarios in Quality Center,
Mapped the test cases to Requirements.
* Experience in Automate the creation, execution and analysis of
functional, regression and performance tests for services and SOA
applications.
* Validated the data in MQ Series Logs.
* Involved in Web services testing using SOAP applications.
* Set up the test environment with the libraries and configuration files
required for SOAP Web services or custom security algorithms.
* Good Exposure on WSDL Concepts
* Experience in testing B2B&B2C portal applications in single sign on
authentications.
* Executed Test Cases manually to check GUI and Functional features of the
application.
* Defects were tracked and prioritized using Remedy Tool.
* Involved in UAT Test, Regression Test, Performance Test and System Test
and supported to Production environments.
* Performed all development migrations to other upper environments using
version control PVCS Dimensions.
* Reviewed and Modified Existing scripts and also developed new scripts for
the new functionality.
* Ran the shell and Perl jobs in UNIX machines and loaded Customer
information in to Siebel and mainframe applications.
* Involved Payments using the Point of Sale (POS) system methodology.
Environment: Windows 2000, Java, Web sphere, Vitria, Unity, Siebel 7.8.2.5,
Siebel e-Communication, VII Billing,B2B & B2C Portal applications, Cellware
Billing, XML, SOAP Web Services, HTML, Oracle 10g, Oracle9I,Unix, Shell
scripts, Perl scripts, Dimensions, Remedy, Visual Studio, QTP, Cute FTP,
Quality Center and PL/SQL Developer.
Fujitsu, New Jersey
Oct'04 -
Dec'05
Sr. QA Analyst
Fujitsu has internal applications running across different platforms and
technologies supporting the business users. Fujitsu is particularly
regarded as a solutions provider to the different Products, finance and
telecommunications industries as well as government agencies. It also
offers a variety of unique and innovative software products.
Responsibilities:
. Involved in gathering Business Requirements and developed specific test
scenarios to test client.
. Tested & verified Service, Forecasting, Quotes and Order Management
Module.
. Logged bugs in Test Director that are found during the process of testing
and running defect reports for status meetings.
. Executed test cases manually to check GUI and Functional features of the
application.
. Involved in project meetings and discussions for setting targets and
goals to be achieved in the QA process.
. Involved in Black Box Testing (Functionality, GUI Testing, System
Integration Testing (SIT), Compatibility Testing, Accessibility Testing)
for Manage Actions, Monitor Database and Action Monitor Modules.
. Analyzed the business requirement document and the system requirement
document to come up with a detailed Test Plan.
. Defects were tracked and prioritized using Test Director and analyzed the
variation between expected and actual results.
. Analyzed defects status using Test Director and interacted with
developers to fix defects/bugs of the application.
. Involved in running PL/SQL and SQL queries to validate Data.
. Experience in handling large business teams & conducting requirement
gathering the sessions.
. Rich Experience in Siebel Test Plan Creation, test scenario & Test Case
Creation.
. Executed test scripts using Mercury Quality Center.
. Experience on Siebel Test Execution Management using Defect Management
Tool.
Environment: Windows 2000, Java, J2ee, Oracle9i.Unix, Quality Center, QTP,
Win Runner, CVS and Test Director
Gateway, USA
Oct'03 - Oct'04
QA Lead
Gateway has country store outlets in all over USA. Gateway manufactures
computer related products. This Project represents a committed order
amount request that will be handled by Siebel. By using this framework any
application can generate the appropriate message to request a Siebel
committed order amount. The Siebel adapter is independent of the
requesting application, and does not need to be modified if a new
application requires Siebel committed order amount.
Responsibilities:
. Study of Master Test Plan, Knowledge Acquisition and Capturing Test
Requirements.
. Analysis of all Technical Transformation Rules, Business Translation
Rules for both functional and business requirements from the Mapping
Specifications and Functional Design specifications.
. Worked with the team lead to coordinate the test case turnover process
proceeding each cycle and selectively executed the test cases to verify
that they are kept current.
. Primarily involved in testing activities like Functional Verification,
Regression, and User Acceptance testing for new builds.
. Create and configure the load test plan using Mercury.
. Verifying data on message text and rvspy tool for JD Edwards.
. Worked on Configuration Management tools like PVCS repository tool.
. Prepared test data for positive and negative test scenarios for
functional testing as documented in the test plan.
. Worked on Configuration Management tools like PVCS repository tool.
. Testing Siebel eSales, Call Center, Service, and Sales Order data on
Siebel thin client in different environments such as UAT and Pre-
Production environments
. Preparing test cases and analyzing the results of the test cases.
Environment: Windows XP, Siebel Tools 7.5.2, Siebel Client, Oracle9i, Java,
HTML, PVCS, Tibco, rvspy, Morpheus Tool, Message Test, UAT, PST (Gateway)
Environments.
IBM, Paris
Dec'02- Sept'03
QA Tester
IBM Siebel was selected to perform customer relationship management
activities within IBM Corporation. The MDS (Migration, Deployment &
Support) operations scope focused on testing and support of legacy data
migration and data interfaces to Siebel.
Responsibilities:
. EIM Data Mapping for Accounts, Contacts, Positions, List of Values and
Products.
. Data extractions from legacy or source systems are developed and tested.
. Testing the Siebel application.
. Logging the defects through CMVC and Tracking those defects by TTT (Test
Tracking Tool) till closure. Also followed up with development team to
verify defect fixes and update defect status.
. Provided support in moving the project to the Production Environment.
. Reviewed Server/system logs and reports to identify application
processing errors and possible improvements.
. Analyzing, developing and testing the data for the EMEA and Asia Pacific
Project.
. Analyzing packages and running test reports.
. Troubleshooting log files.
Environment: Siebel 7.5, Siebel 6.3, EIM, Siebel Tools, Siebel Client, Thin
Client, LCIA, PCIA, Java, C, C++, Aix, Lotus Notes, Korn shell scripts,
DB2 and Unix.
GE, UK
Oct'01- Nov'02
Software Developer
GEPS has implemented the Siebel Field Service to profitably manage all
aspects of their field service operations. Using Siebel Field Service they
are managing field service activities, preventative maintenance, break/fix
service events, service inventory, warranties, quotes and orders, shipping
and receiving etc., it automatically assigns the most appropriate field
service engineer to a service request based on product expertise,
availability, geography, or other criteria.
Responsibilities:
. Involved in the Customization of Siebel to meet the customer requirement
and performed business analysis for enterprise CRM Application.
. Defined Organizational hierarchy and created Responsibilities and
Positions for different SR's.
. Configured Components to support Workflow Manager, assigning data with
Assignment Manager, defining assignment rules and running the assignment
manager
. Involved in configuring user interface objects applets, views, screens
etc.,
. Involved in developing actuate reports.
. Involved in writing workflow policies for sending e-mail.
. Worked on workflow manager and written work flow policies, conditions
etc.
. Developed single grouping and multi grouping reports.
. Monitoring the Siebel application for its stability and track Siebel
services and server components to ensure that application up and running
during the business hours.
Environment: Siebel Version 6, Siebel Tools, Siebel Client, Workflow,
Oracle, Actuate Reports, Microsoft Excel
Image Infosys, Hyderabad, India
Aug'99 - Sep'01
Senior Software Engineer
This project was developed for banking transactions in Enterprise Java Bean
gives consistency to the Database. User must logon by entering the valid
username and password. This can be used to open a new account whenever
necessarily. There are the options to choose the account Type like single
account or joint account etc. User can also deposit the amount by just
clicking the deposit button, whenever the customer wants to deposit their
amount. In another Module, the user can withdraw the amount and they can
close the account.
Responsibilities:
. Designed the Customer Views, Standard Views, and Login Information for
the Users. Whenever the Customer come to bank to make fixed deposit, So
that just the user can enter the details of the customer, name of the
Customer, Account number and amount to be deposit and the duration etc.
Environment: Java, EJB, XML, Servlets, JDBC and Oracle 8, Microsoft Excel
Win 98
Ananth Technologies, Hyderabad, India
Aug'98 - Jul'99
Software Engineer
This Tool is mainly developed to keep track of the Project Status of
various Projects, Quality Management records, Software Configuration
Management Records. It can generate different QC forms (Quality Control)
and Change Management Forms. This tool can be used to see the Old Project
Status reports, QC forms and change management of various projects. Change
Management includes Change request details, Change Approval and Change
Implementation details.
Responsibilities:
. Designing, Coding, creation of Forms and Reports, Modifying the QC forms
and change management of various projects and Check the status of
Project Reports.
Environment: Java1.3, HTML, JDBC, JavaScript, Oracle and Windows NT.
EDUCATION:
. M.B.A (International Business) from CSM Institute of Graduate Studies,
India (1997-1999)