Mahi Manchala
PROFESSIONAL SUMMARY
. Over ** years of experience in Testing and Quality Assurance of Web-
Based, Client-Server, Multi-Tier and ERP applications and over 7 years of
managing experience handling multi-application project releases,
resources, schedules and deliverables.
. Experience with QA/QC Methodologies including Black Box, White-Box, Gray-
Box testing and QA Strategies to ensure the Quality Control.
. Expertise in writing skills and setting up standardized procedures for
BRD, SRS, FRD and Data dictionary documents
. Knowledge of Software Development Life Cycle (SDLC) methodologies
including Waterfall model, V-Model and Rational Unified Process (RUP),
Agile processes.
. Master in change management skills in the technical, strategic and
structural areas as required by the business for successful deliverables
. Expertise in resource management cross training resources within limited
budgets.
. Expertise in working in an agile environment gathering requirements and
achieving solutions through collaboration between self-organizing and
cross-functional teams
. Extensive experience in Manual Testing and expertise in creating
automation environment using Win Runner, Quick Test Professional (QTP),
Load runner, Quality Center, Rational Functional and Performance tester.
. Extensive knowledge in various Financial Business Processes like Interest
Rate Fluctuations, Equities, Stocks, Exchange Rates and VaR (Value at
Risk).
. Experience in Developing and Executing Test Plans and Test Cases from
Requirements and Design Documents.
. Expertise in data validation testing using ETL tools like Informatica.
. Proficiency in back-end database testing and verification of data
integrity using SQL, PL/SQL.
. Experience in execution of AUTOSYS jobs using UNIX Shell Scripts.
. Good working knowledge of JavaScript, VBScript, HTML, DHTML, EJB, JSP,
JCL, SDSF etc.
. Strong experience in performing Smoke, Unit, GUI, Functionality, System,
Integration, Performance, UAT, End-to-End and Regression tests.
. Expertise in testing ERP data ware house products like SAP, Cloud systems
including Workday.
. Experience in creating Requirements Traceability Matrices.
. Expertise in predictive analytic techniques.
. Proficiency in Development of Templates, Standards, Bug Reporting, Error
Documentation and Training Materials.
. Proficient in Managing Delivery Schedules as per Business/Functional
Requirements.
. Excellent team player with good Written and Oral Communication and
Interpersonal skills. Experienced in providing Knowledge Transfer to team
Members and End Users.
PROFESSIONAL EXPERIENCE
Citi Private Bank
TCoE QA and Environment Release Implementation Manager
Jan'14-
Present
Citi Private Bank, a subsidiary of multinational banking
conglomerate Citigroup, markets private banking services for wealthier
clients, including entrepreneurs and senior corporate executives. It has 60
offices in 23 countries. To qualify for a Citi Private Bank account, one
must have a net worth of at least US$25 million. Its private
banking services are divided between high net worth clients and Law Firm
groups, which focus on servicing the needs of high net worth
individuals and law firms and their lawyers. Formerly part of Global Wealth
Management, Citi Private Bank is now part of Citi's Institutional Clients
Group. Therefore, Citi Private Bank clients are treated as institutional
investors rather than consumer banking clients. Acted as the ISTQA and
Environment Release Manager for all the applications in the Private banking
division.
. Accomplished quality assurance human resource objectives by recruiting,
selecting, orienting, assigning, scheduling, employees, communicating job
expectations, planning, monitoring, appraising, and reviewing job
contributions, planning and reviewing compensation actions, enforcing
policies and procedures. Headed a team of 120 resources including onsite
and offshore with 40 applications under the Private banking division
globally (US( AMRS), AP and EM) with monthly releases.
. Achieved quality assurance operational objectives by contributing
information and analysis to strategic plans and reviews, preparing and
completing action plans; implementing production, productivity, quality,
and customer-service standards, identifying and resolving problems,
completing audits, determining system improvements, implementing change.
. Met quality assurance financial objectives by estimating requirements,
preparing an annual budget, scheduling expenditures, analyzing variances,
initiating corrective actions.
. Developed quality assurance plans by conducting hazard analyses;
identifying critical control points and preventive measures, establishing
critical limits, monitoring procedures, corrective actions, and
verification procedures, monitoring inventories.
. Validated quality processes by establishing product specifications and
quality attributes; measuring production; documenting evidence,
determining operational and performance qualification, writing and
updating quality assurance procedures.
. Maintained and improved product quality by completing product, company,
system, compliance, and surveillance audits, investigating customer
complaints, collaborating with other members of management.
. Acted as an environment release management specialist coordinating with
the EM team for test environment support and maintenance, Check
environment preparation for testing, Deployment of code in the server and
packages in the database and maintaining the test DB server and
troubleshooting. Also coordinated Interface set up with other systems and
applications ensuring services are running between them and subsequent
UAT release of packages after IST sign off.
. Used HP Application Lifecycle Management for requirements
management, test planning, functional, regression, performance
testing and defect management. Prepared quality documentation using
ALM Qulaity Center to create reports like daily dashboards and monthly
dashboards by collecting, analyzing and summarizing information and
trends including failed processes, stability studies, recalls,
corrective actions, and re-validations.
. Enhanced department and organization reputation by accepting ownership
for accomplishing new and different requests, exploring opportunities to
add value to job accomplishments.
Environment: Quick Test Professional-10.0 for functional regression
automation, Eggplant for Mobile automation,Load runner for performance
testing, ALM QC 10.0, Oracle, Microsoft Visio and project, Windows XP and
UNIX.
AIG
Dec' 2011 to Dec'13
QA Manager -HRIT
American International Group, Inc. (AIG) is a leading international
insurance organization-serving customers in more than 130 countries. AIG
companies serve commercial, institutional and individual customers through
one of the most extensive worldwide property casualty networks. In
addition, AIG companies are leading providers of life insurance and
retirement Services in the United States. Managed the HRIT QA group for a
Workday implementation of the HR system from PeopleSoft globally while
maintaining the legacy HR system in US and Canada.
. Tested the entire HCM System covering the employee life cycle from
hire to retire including various phases of Recruitment, Hiring,
Onboarding, Position Management (Promotion, Demotion, Lateral move),
Expatriation, Termination, Retirement and Separation
. Overcame major challenge in Workday Testing is understanding complex
requirements related to Business Process with their integrations with
Upstream / Downstream third party applications and converting them to
End-to-End Test Scenarios for 100% Test Coverage
. Provided System configuration inputs in accordance with Solution
Design & Configuration Workbook
. Provided Expertise in integrating the solution with third party
systems
. Tested the Employee master data -head count reports, interfaces,
conversions, Enhancements, Forms and Workflow.
. Ensured successful quality and timely delivery of close to 300 plus
change requests per month including the BAU (Core HR, Base benefits,
Payroll, Self services, Re-lo, Manager Hierarchy, Org Management,
compensation, RPR) and the HRIM releases for roll outs of HR across 57
countries including different payroll vendors
. Involved in tools patch and tax updates to keep the PS version update.
. Provided Budget and resource estimates on a quarterly basis based on
projects executed on hand
. Handled a team of 60 team members onsite and offshore, ensuring
resource and skills management are up-to date and as required
. Conducted cross training sessions within the team to keep the
knowledge update.
. Review daily status reports and resource updates and send in weekly
reports to the higher management
. Track and meet on testing activities, including testing results, test
case coverage, defects discovered and their status, performance
baselines, etc.
. Document, implement, monitor, and enforce all processes and procedures
for testing is established as per the standards defined by the
organization. Ensure content and structure of all Testing documents /
artifacts is documented and maintained and is audited for Fed
readiness.
. Automated applications for regression testing and reduce timelines for
QA efficiency
Environment: Quick Test Professional 10.0, People soft Version 9.0, Oracle
Tools Patch -8.53, HPQC 10.0, Oracle, Mercury Quality Center, Microsoft
Visio and project, Windows XP and UNIX
Merrill Lynch/Bank of America
May 2009 to Nov' 2011
QA Manager -Credit Risk management/GCPI /GMRT/GCB
The goal of credit risk management is to maximize bank's risk-adjusted rate
of return by maintaining credit risk exposure within acceptable parameters.
Managed the QA releases for the credit risk applications with different
legal entities inherent in the entire portfolio as well as the risk in
individual credits or transactions. The effective management of credit risk
is a critical component of a comprehensive approach to risk management and
essential to the long-term success.
. QA Team Manager, resource manager, Onsite/Offshore coordinator
handling multi- applications with different technology, knowledge base
and end user functionality. Working closely with the business analysts
and development teams for requirements and release updates.
. Managed the QA releases and activities in the bank's investment
banking area under the Merrill Lynch subsidiary. Involved in creating
standardized QA procedures for Leveraged Finance, Syndicated Loans and
Mortgage backed securities applications.
. Involved in approving change management requests for release items to
be tested and approve after functional execution.
. Acted as the single point of contact between Project management,
Development and QA team for iterations, testing and deployment
activities.
. Worked in a highly agile environment adapting scrum methodology for
managing projects with changing requirements and business needs and
adjusted timelines and resources to handle the needs with great
success.
. Involved in onboarding resources within managed budget.
. Analyzed requirements and needed resources for schedule and delivery
of projects and communicate it to the project manager accordingly.
. Involved in automating applications to reduce manual errors and reduce
time in QA executions providing more effectiveness.
. Used Predictive analytics statistic patterns to identify risks and
opportunities.
. Involved in review for estimations, test conditions and test
plan/script documents throughout the QA cycle of planning and
execution.
. Involved in creating custom scripts for different applications which
or UI based, .Net and Java involving custom spring frameworks.
. Handle the task of developing test procedures to provide support to
mobile browsers and devices like android, blackberry and iOS devices.
. Responsible for generating standard solutions to solve issues in
mobile technologies and applications.
. Perform responsibilities of testing devices as well as provide
contribution in developing regulatory compliance.
. Large amount of ETL data validation testing was done with the merger
of BOA and Merrillynch as applications with similar functionalities
and user base were combined
. Arrange the Hardware, software, train resources as per the changing
needs of the projects
. Review daily status reports and resource updates and send in weekly
reports to the higher management
. Track and meet on testing activities, including testing results, test
case coverage, defects discovered and their status, performance
baselines, etc.
. Ensure content and structure of all Testing documents / artifacts is
documented and maintained. Assign task to all Testing Team members and
ensure that all of them have sufficient work in the project.
Document, implement, monitor, and enforce all processes and procedures
for testing is established as per the standards defined by the
organization.
. Frequent status-check meetings with the Team. Target for timely
delivery of different milestones.
Environment: Quick Test Professional 9.0, Rational functional and
performance tester, Load runner 10.0, SQL Advantage/SQL Squirrel, Mercury
Quality Center 10.0, Informatica, Microsoft Visio and project, Windows XP
and UNIX
UBS Investment Bank, Jersey City, NJ
February 2008 to May 2009
QA Manager for SBL Applications, Stock Brokerage Loan
Functioned as the Onsite / Offshore coordinator and Team lead in the Sales
& Trading division, compromising Equities (brokering, dealing, Market
making and engaging in proprietary trading in equities, equity-related
products, equity derivatives, and structured products) and Fixed Income,
Currencies, and Commodities (FICC).(Mortgage backed securities, leveraged
loans, investment grade and high yield debt). Also worked in the Mobile
banking division of the bank
. Developed custom scripts for inter-application application testing
between equity trading and fixed income applications
. Prepare the Software Test Plan.
. Check / Review the Test Cases document - System, Integration and User
Acceptance prepared by test engineers.
. Analyze requirements during the requirements analysis phase of
projects.
. Keep track of the new requirements from the Project.
. Forecast / Estimate the Project future requirements.
. Keep track of change control requests coming into testing for QA
executions.
. Arrange the Hardware and software requirement for the Test Setup.
. Send the Status Report (Daily, Weekly etc.) to the Client.
. Track and report upon testing activities, including testing results,
test case coverage, required resources, defects discovered and their
status, performance baselines, etc.
. Identify Training requirements and forward it to the Project Manager
(Technical and Soft skills).
. Escalate the issues about project requirements (Software, Hardware,
Resources) to Project Manager.
. Ensure content and structure of all Testing documents / artifacts is
documented and maintained. Assign task to all Testing Team members and
ensure that all of them have sufficient work in the project.
Document, implement, monitor, and enforce all processes and procedures
for testing is established as per standards defined by the
organization.
. Frequent status-check meetings with the Team.
. Act as the single point of contact between Development and Testers for
iterations, testing and deployment activities.
. Organize / Conduct internal review trainings on various products.
. Prepare the Agenda for the meeting, for example: Weekly Team meeting
etc. Attend the regular client call and discuss the weekly status with
the client
. Motivate team members.
Environment: Quick Test Professional 9.0, SQL Query Analyzer, Mercury
Quality Center 9.0, VB, Sybase, UNIX, MS Access, Windows XP/2000 and IE
6.0
Merrill Lynch, Jersey City, NJ
June 2006 to January 2008
Application team lead, Market Risk Technology
. Designing Test Plan, Test Cases, and the QA Process Document,
Capturing Test Results, and capturing and resolving Test Anomalies
using Mercury Quality Center.
. Executed and Maintained Scripts written using Rational Robot and QTP.
. Prepared test cases in accordance with the Merrill Lynch Standards of
Documentation.
. Performed Functional and Regression Testing for new changes in
application processes and verify the existing procedures.
. Extensive Database Testing done using Rapid SQL.
. Build of all applications tagged on the developer's code was done
using UNIX.
. Involved in running extensive AUTOSYS jobs using UNIX Shell Scripts
. Worked with Product Owners and Development Team on application
enhancements and new features needed.
. Used JIRA as a Defect Reporting Tool.
. Involved in communication with offshore team (MLITS) members in order
to provide the clear clarification of requirements and ongoing
application changes.
. Provided Post Deployment Application Verification as Sign Off Process
. Actively involved in weekly status, product delivery and bug review
meetings.
Environment: Quick Test Professional 9.0, Rational Robot, Rapid SQL,
Mercury Quality Center 9.0, Java, Sybase, UNIX, Asp.Net 2.0, COBOL, MS
Access, Windows XP/2000 and IE 6.0
Fidelity Investments, Boston, MA
September 2005 to May 2006
SQA and UI Lead, FBCT and Financial Search
. Defining the Testing Procedures for Systems Management group for FBCT
as part of the Capital Markets testing team.
. Designing Test Plan, Test Cases, and the QA Process document that
include Test Cases/Scripts, Capturing Test Results, and resolving Test
Anomalies in an agile environment.
. Mercury Quality center was used for Test case creation and execution.
. Prepared test cases and executed them for the Order Management,
Trading, and Compliance systems.
. Performed Regression testing for new developments and enhancement on
the systems
. Created Integration test strategy followed by preparing test cases and
execution for systems including home grown middleware systems, back
end mainframe books and records systems, as well as vendor trading
systems
. Responsible for identifying, assessing and recording near-term
business needs, recommending business priorities, and advising
businesses on options, risks, and costs versus benefits.
. Test all layers of the web application on UI with Macromedia flash
front end with coding done on Flex.
. Automate the entire test suite using Quick Test Professional.
Customize the scripts in both tree view and expert view using
VBScript.
. Comparison of Databases with clear case.
. Tested the backend Inquira engine with built-in .Net tool for results
relevancy
. Tested on the backend for both the upgraded and enhancement versions.
. Defect reporting was done using Resolve Clear Quest.
. Performed Risk Analysis of Automation; Build Management, Hardware,
Test Execution, and Resource Conflicts
. Analyze performance requirements and create load test plan. Create
virtual user scripts and Load Runner Scenarios to execute load and
performance tests.
. Worked with Business system analysts and development team on system-
investigated requirements.
. Conducting Regression tests for already reported Bugs to test whether
fix was applied or not and to test and check that no baseline
functionality was degraded during this.
. Provided production support during the install of the application and
sign off as a lead.
. Provided testing resources where necessary to meet projects schedule
requirements.
Environment: Quick Test Professional 9.0 Beta, Quality Center 8.2, DB2,
COBOL, .Net, Macromedia flash player 8.0, MS Access, Windows 2000, IE 6.0
and Windows XP
Pfizer, Inc., Morris Plains, NJ
April 2004 to August 2005
SQA Tester, FFO Laptop Upgrade
. Designing Test Plan, Test Cases, and the QA Process document.
. Defining the Testing Procedures that includes Test Cases/Scripts,
Capturing Test Results, and resolving Test Anomalies.
. Creating Win Runner scripts for Client/Server and Web applications in
order to test the MSI packages and Install Shield Packages.
. Creating automated scripts to validate that the Core Image/Add-On's
that are been created according to standards.
. Analyze performance requirements and create load test plan. Create
virtual user scripts and Load Runner Scenarios to execute load and
performance tests.
. Worked with Business system analysts and development team on system-
investigated requirements.
Environment: Win Runner 7.6, Test Director 8.0, Java Scripts, DB2, COBOL,
JCL, PL/SQL, Macromedia flash player, MS Access, Windows 2000, IE 6.0,
Windows XP, SQL Analyzer and UNIX
October 2001 to April 2004
United Health Care, Montgomeryville, PA SQA Tester, Flexible Spending
Account Information
MED Cost Recovery System, Columbus, OH SQA Tester
Allstate Insurance Co., IL QA Engineer, Multi Access Integration
EDUCATION
Master of Science in Electronic Engineering, New Jersey Institute of
Technology, Newark, NJ
Bachelor of Engineering, Osmania University, Hyderabad, AP, India