Objective
To work as a LEAD in a competitive organization that seeks an ambitious and career conscious
person, where acquired skills and education will be utilized towards continued growth and
advancement.
Skills
Languages: Java (J2SE/J2EE), C++, HTML, ASP.NET, Visual Basic, Perl, PHP , Unix Shell
Scripting.
GUI Tools: Toad, XML, Maven 2.x, Hudson, SVN, CVS, Sql Developer.
Databases: Oracle, MS SQL Server, mySQL.
Operating Systems: Linux, UNIX, Hadoop, Windows XP/2000, Mac OS X.
Automated Test Tools: QTP, Win Runner, Load Runner, Quality Center, Test Director.
Professional Experience
Confidential,
FL June’07 – Till date
QE
Worked on multiple Products/Projects. Some are listed below with detailed description and my
responsibilities.
Custom Data Handler (CDH)
This application [Java] consumes data from DAGG and creates client specific data files. It
processes an average of 100GB data per hour. The application is responsible for creating
compressed and encrypted data files for the client and deliver them using the configured delivery
mechanism. This application runs multiple services responsible for archiving and eventually
deleting the processed data. This application improved the data processing by over 200% and
was made a lot more scalable than its previous version.
Currency Expander
Currency Expander was developed as an API [Java] and a core application consuming the API to
convert native USD metric values to client specific currency data. This product consumes
financial reporting data from DAGG and expands it into native currencies by referencing data
from mySQL DB.
Multiple Loaders
There are multiple versions loaders for individual pipelines depending upon the data flavor. All
the loaders would take the data available on filer and load into the Oracle db. Data in some
loaders is loaded by referring to the mySQL DB for Timezone.
Grid Interface (Scheduler and Builder)
This application schedules a Data set to load into Journal Tracking DB, which will be picked by
Builder application. Builder connects to GRID via CFI and fetches the data and writes it to filer
location, which in turn will be used by multiple apps.
Automation Support
Lead our team to meet the deadlines for automation integration by using in-house automation
suite. Wrote and developed test cases in XML using JAVA built methods for various products,
implemented the automation suite and integrated it with internal QA reporting portal and
Hudson.
Over all Responsibilities:
- Wrote test cases for multiple products.
- Created Test Plans for all my projects.
- Co-documented the automation engine along with Developers.
- Always been the POC of our Team for any cross team E2E efforts.
- Involved coordination across geographically diverse teams for integration and e2e testing
efforts.
- Create and execute SQL statements for backend database validation.
- Perform manual and automated execution of Test Scripts in a UNIX environment.
- Expertise in eclipse for automation test cases creation.
- Lead our TEAM in our pipeline’s automation effort.
- Always been the person to train the cross teams as I had the intensive knowledge of most of
the applications in our Group (17 apps to be precise)
- Involved in all the GRID Migration efforts for all the pipelines.
- Created suites for all the products and integrated with Hudson.
- Used Hadoop extensively to move/access data on/from GRID.
- Developed scripts in Pearl and Shell for our team.
- Able to effectively manage my time to ensure project milestones were hit and deliver quality
results.
- Worked closely with SE in setting up the Staging environment.
Technologies used: Test Manager, AX247, Bugzilla, UNIX, XML, Oracle, SQL Server, mySQL,
Maven, Hadoop, SQL Developer, TOAD, Shell, Perl
Confidential,
FL Jan’07 – June’07
QA Engineer
Rightmedia was a Media network company where the bids were taken dynamically and the Ad is
served as per the budget allotted.
I worked on Applications such as DaLo (Data Loader) , MCP, Shifter, Journal Tracking etc.
Responsibilities:
- Analyzed system requirements and wrote test cases for testing the application
- Developed SQL Scripts for Back-end testing to ensure the data updated is as per the
transaction and business rule.
- Involved in QC setup in Florida office.
- Prepared test plan and test strategies for end to end testing.
- Analyzed user requirements and documented them using QC.
- Used Test plan and Test lab modules in QC.
- Linked all the requirements to the test cases in QC.
- Performed Functionality and Regression Testing on new builds of the software.
- Organized reviews and walkthroughs.
- Used UNIX commands extensively for testing.
- Organized meetings with developers and BA’s for test scenario reviews and requirement
corrections.
-
Technologies used: QTP, Quality Center, Load runner, XML, Unix, SQL Server and mySQL.
Confidential,
L Jan’06 – Dec’06
QA Test Engineer
Worked as software testing consultant on project “ICES System” that maintains transactions and
updating related to order processing and also the software records, sale orders received from the
customers. It also records the deliveries made against the orders.
Responsibilities:
- Analyzed system requirements and wrote test cases for testing the application
- Worked closely with BA’s, Developers and DB architects in identifying the outstanding
issues.
- Involved in testing of data using SQL queries.
- Analyzed requirements and documented then in QC.
- Used QC for tracking requirements and communicating them to the team during the test
process.
- Proactively worked on new applications.
- Extensively used SQL queries to perform Data Integration/Validation testing.
- Used to do both White box and Black testing.
- I was involved in cross team e2e testing.
- Performed functionality and regression testing on new builds.
- Contributed to the product documentation.
- Developed test cases and scripts in Load Runner for stress and Performance Testing of the
application by creating Virtual users.
Technologies used: Win Runner, Quality Center, Load Runner, Windows NT, Unix, Visual
Basic, SQL Server and Oracle.
Confidential,
Manchester Mar’05 – Dec’05
QA Consultant
Conversion Validations (LINE of Credit, Installment LOANS)
Conversion Validations is the Mainframes application for multiple banks such as charter one,
Citizens bank etc. Online validations were done with this application. It generates EZTrieve
Reports for conversion validations of Line of Credit, Installment Loans.
Responsibilities:
- Developed Test Plan and Test cases.
- Conducted UAT testing cycles.
- Created Trouble reports (Modification Request) for Software defects in Test Director.
- Worked in AS/400 environment and used commands like WRKSPLF, WRKOUTQ,
WRKACTJOB and WRKUSRJOB.
- Used DBU (Database Utility) command to check database.
Technologies used: TestDirector7.0.1, IBM Mainframe, AS/400, OS/400, DB2, EJB, XML.
Confidential,
Liverpool Oct’03 – Feb’05
QA Consultant
Druid system was a high performance financial product for the organizations, which deal with
equities, foreign exchange and fixed deposits. The application is a high transactional e-commerce
based B2B application. This application includes a robust n-tier architectural system. All the
systems operate independently in a distributed environment on both internet and intranet. This ntier
architecture supports a centralized data sharing between these subsystems using XML for
data buffering and transfer.
Responsibilities:
- Applied testing methodologies like White Box, Black Box, Unit, Integration, System, UAT.
- Made recommendations for manual and automation testing for various functionalities.
- Used Oracle to query the data to ensure data integrity.
- Identified and Automated regression test cases.
- Involved in writing complex SQL statements – Sub selects, grouping and indexes.
- Used to conduct team meetings and take the bullet points and communicate effectively back
to the higher management.
Technologies used: Win Runner, Test Director, Windows98/NT, Oracle8i, SQL Server, Java,
JSP, VB Script and HTML.
Confidential,
Kent Dec’02 – Oct’03
QA Consultant
This was a Customer database application. This system is used to maintain the database of the
National Customer’s for BT. The main feature of this system is to maintain the personal
information related to the customers of BT. And also updates the information about the plan
type, billing, price type etc.
Responsibilities:
- Used Win Runner to automate the scripts for all the modules in the project.
- Involved in Backend, GUI and Functional testing.
- Partially involved in writing backend code using PL/SQL
- Closely worked with developers and SE’s to nail down the technical issues.
- Created and executed synchronization statements, GUI checkpoints, text verification, bitmap
checkpoints and Database checkpoints.