IT Analyst/Software Qau
Resume:
V I N ITA P I L LA I
E-mail: ******.*****@*****.***, *******@*****.***
P rofile Summary
IT Analyst with over 2 years of work experience in Software Testing and Database
M anagement.
Education
Yea
Qualification Subject School/University Score
r
Bachelor of Comp Science &
2012 BMSCE,Bangalore 8.72 /10
E ngineering E ngg.
H igher Secondary/ 200 Engineering Indian H igh School, 85%
CBSE 8 D rawing D ubai
Secondary / CBSE 200 General Indian H igh School, 88%
6 D ubai
Technical Strengths and Competencies
Project Management Business Intelligence Reporting
Resource Allocation Training, KTP & Documentation
Test Strategies & Coverages Sage Accpac ERP
QA & QC Standards & Branding C,C++,Java
Defect / Bug Tracking(HP QC /QTP) Web Development(HTML &CSS)
Database Management(SQL Sever) Project audit
Employment Experience
M iddle East Development L LC, Dubai [ Feb 2014-P resent]
I T Analyst - M anaged client information with the help of BI tool and performed front end
U I/functional testing.
P roject Experience
1 Page
C ustomer I nformatics
Team : IT (ERP Team)
Suite : Sage 300 ERP (Accpac), Oracle DB
The database was managed to refer and retrieve customer-related details and credit status.
Data cubes were maintained for the company’s sales history, pricing so as to take business
decisions for future projects and identify high net worth customers.
Areas of Expertise
Customer I nformation Management and Report Generation
• Used the Customer Enqui ry Form to t rack down the customer related details- amount
overdue, payables, receivables, bills, credit limit.
• Used the Customer L ist Tool, a Business In telligence reporting tool which enables the
application of wide selection of criteria(Optional fields) to produce reports to suit
d ifferent needs (inactive accounts).
• Managed the company database -Creating database queries and checking backend
components.
Software Testing
• Performed U I and functional testing on the company’s official website.
• Extensively involved in defects t racking and reporting to the internal IT (Development)
team.
• Coordinated with the ERP team to integrate the client data and deliverables using
Sage AccPac ERP (Accounting Software) before handover to the CRM team.
• Responsible for collaborating with other teams on integration projects to ensure
adequate testing is carried out without data and environment conflicts.
Tata Consultancy Services Ltd, Kochi [Sep 2012-Nov 2013]
Assistant System Engineer - Worked for the American Express as a Software Test
E ngineer. Performed Application testing and Data Migration testing.
P roject Experience
Online Book Pu rchasing System
Team : Training team
Environment : Tomcat Server
Tool : Eclipse
The application was developed for buying, selling and reviewing books online using Java
p latform and SQL.
P rofile_ POA [ Dec 2012-Nov 2013]
Client : A merican Express (AMEX)
Team : Global Travel Technologies (GTT)
Environment : Oracle database
Tool : HP Quality Centre
2 Page
P rofile_ POA mainly revolves around MyProfile, an application developed by the American
E xpress for maintaining t ravel profiles of employees belonging to different organizations as
A MEX serves as a Travel Agent for these Employees. MyProfile serves as a U I backend for
several t raveler portals. MyProfile fetches the t raveller profile data (itenary and non- i tenary)
f rom these portals and makes a reservation/booking in the G.D.S using the same.
Magellan_PSD M igration [Aug 2013 -Nov2013]
Environment : SQL server, Oracle Database
Tool : HP Quality Centre, Soap U I, Oracle SQL Developer
Magellan_PSD Migration was developed with the main aim of migrating the t raveler
i nformation from GDS (Globally Distributed Systems) –Sabre to GBT_MyProfile to hold
l arger amount of data. The non i tenary t raveler information that comes in from the GDS
(XML files with t raveler information) is pushed in to an intermediate staging database called
PSD via xml file upload and further pushed to GBT_MyProfile
Areas of Expertise
Analysis and Strategy
• Worked with business analysis function to ensure requirements were appropriately
i dentified and included in the requirements.
• Obtained a high level understanding of the project requirements and developed pretest
conditions.
• Exported Test Requirements and Test Cases from HP QC to Excel as required.
• Maintained Requirement Traceabili ty Mat rix and performed in Gap Analysis.
Resource Allocation, Test Data Creation and Test Execution
• Developed the test plan and performed resource allocation during smoke and regression
testing.
• Organized test data for a given change or set of changes for a system.
• Actively involved in preparing and executing test cases -GUI Tests, Regression Tests,
F unctionality testing, Data Migration Testing and Adhoc Testing.
• Executed automated test scripts using QTP.
Defects T racking, Data Validation and I n tegrity
• Documented softwa re defects using bug t racking system and reported defects
i nvolving program functionality, output, online screen and content to software
developers
• Worked with Senior QA Lead, Business Analyst, Project manager and Developers by
p roviding a walk-through of defects and discuss next steps to resolve high priority
defects.
• Extensively used SQL statements to query the Oracle Database for Data Validation and
Data In tegrity.
• Performed XML file validation (SOAP U I Pro) and upload to Oracle database.
3 Page
R eports and Documentation
• Distributed and analyzed 'Daily Status Reports' to the project team and worked closely
w ith application developers and QA Team to minimize the defects based on severity
level.
• Moderated/ Co-ordinated the 'Daily Defect Status' conference calls and live meetings.
• Participated in UAT, t raining and maintenance of applications.
• Worked on various SIT and UAT reports at the end of project sign off.
• Performed audit for several projects using automated audit tool.
Knowledge T ransfer P rogram
• Mentored onsite team members, assigned tasks, monitored progress and showed
w illingness to spend the extra time required to complete overall goal set by
business/project.
• Training and hands on experience in Sabre (GDS).
External T raining
Emi rates, Dnata, Dubai [ Jul 2011-Aug 2011]
I nternship under the Resource and Planning Department- I t acts as an in-house consultant to
other Dnata Ai rport Operations departments on the planning and allocation of their
resources.
Key Skills: Documentation on resource allocation using D ata M ining technique (Cluster
A nalysis) that enabled the management to allocate the staff for various operations based on
t heir previous t rack records.
U.O.W.D, Dubai [ Ma r 2014-May 2014]
Graduate foundation course on Business Administration - Knowledge t ransfer on the basic
concepts of Business subjects- Accounts, Finance, Operations Management and Marketing.
Achievements
• Received several Appreciation mails from the clients, portfolio manager and director for
efficient work
• Pivotal in maintaining the project deadline and quality with deliverables to execute my
p roject.
• Was chosen as the group leader during t raining period at TCS (Tata Consultancy
services), Ahmadabad for leading fellow associates on final project.
Personal Details
D.O.B : 21/04/1990
Nationality : Indian
Residency (Dubai) : Father’s sponsorship
Language Proficiency : E nglish, H indi, French, Malayalam, Arabic, Tamil
4 Page
Contact this candidate