Hamsika A S
EXPERIENCE SUMMARY
Have * years of experience in Software Quality Assurance in the Banking domain in financial crimes & Economic Sanctions, Risk & Compliance and Capital Markets segments. (Have 3 years of onshore experience)
Proficient in various phases of the testing life cycle including analysis, test case preparation, Testing, Installation, Defect reporting & tracking and post release defect analysis to improve quality that involves metrics preparation and causal analysis.
Proficient in ETL Testing and currently working on testing database views that were created to track transactions from different channels of Bank of America to detect anti-money laundering activities within the bank.
Fast learner with a keen interest to be a part of the team that dynamically works towards the growth of the organization and self.
Worked on applications that deal with economic sanctions and anti-money laundering.
Worked in the Capital Markets segment where the application dealt with asset allocation and tracking of various asset holdings for the bank.
Worked for an application in the treasury and fund technology which dealt with different reports that were generated on daily, weekly and monthly basis to capture trade performance and funding reports across international locations
Trained in Capital Markets Derivatives and financial instruments.
HP Certified Professional (HP QC 9.2 and QTP 9.2)
ASDA (Accenture Solutions Deliver Academy) Certified Test Professional
NCFM - Capital Markets Level II Certified
ISTQB Foundation level Certified
EDUCATION
Bachelor of Technology in Electrical and Electronics Engineering from SASTRA University, 2005-2009
PROFESSIONAL EXPERIENCE
Offshore (Chennai, India) - Dec 2009 to Dec 2012: Worked as Software Engineer in Accenture Services Private Limited.
Onshore (Charlotte,NC ) – From April 2013 till date. Working as a Test Lead on a contract with Accenture Services Pvt Ltd
CERTIFICATIONS
NCFM - Capital Markets Level II Certified
HP Certified Tester ( HP QC 9.2 & HP QTP 9.2)
ASDA (Accenture Solutions Deliver Academy) Certified Test Professional.
SOFTWARE SKILLS
OS
Windows XP/Vista/ Win 7
Languages
C,C++, VB Script
RDBMS
PL\SQL, Oracle 10g\Teradata
Testing Tools
Mercury Quality Center, Mercury Quick Test Professional
Other Tools
Actimize Case Manager & Microstrategy
ASSIGNMENTS:
Contractor for Accenture Services Pvt Ltd(Charlotte, NC) :
Project
GRITT SQA
Client
Bank of America – Anti Money Laundering Scenario Support (ETL Testing)
Period
From April 2014 – till date
Description
Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. This project deals with testing reports that were created from the backend to consolidate transactions that came from different channels of the bank. This data report is used for tracking and reporting Anti Money Laundering activities within the bank
Position
Test Lead (Onshore)
Responsibilities
Working as a Test Lead of a 5 member team.
Involved in collaborating with clients from the requirement definition stage, analyzing testing scope and building QA strategy for testing process
Review BRD and identify technology, resources and timeline estimates
Review Mapping documents and data discovery documents to identify scope of testing
Conduct Review calls with offshore team to explain functionality and mapping document design for the pertaining release
Create SQL queries and review queries created by the offshore team for testing.
Prepare test plans and test scripts for execution
Reviewed prepared test plans and test execution documents and provide peer review comments
Track daily execution progress, collect cumulative results from team and report them on a daily basis to development, business and project management teams
Track the status of defects logged for initiatives and also follow-up with developers on getting defects fixed.
Ensure that all defects are fixed, retested and closed before the initiative SIT end date.
Post release activities to analyze the rejected defects, Calculate DAR and SIT Effectiveness to improve and maintain SIT testing Quality, Pre production and Post Production Quality review
Tools
HP QC 11.0
Teradata 13
Autosys R11
Project
GRITT TQMS
Client
Bank of America – Economic Sanctions
Period
From April 2013 – March 2014
Description
Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. This project deals with Compliance, Risk Management and Capital Markets Segments
Position
Test Analyst (Onshore)
Responsibilities
Worked as part of a 3 member team.
Worked on applications that deal with economic sanctions for US, UK and APAC regions.
Involved in collaborating with clients from the requirement definition stage, analyzing testing scope and building QA strategy for testing process
Review BRD and identify technology, resources and timeline estimates
Prepare test plans and test scripts for execution
Reviewed prepared test plans and test execution documents and provide peer review comments
Ensure that all project documents are placed in share folder and uploaded to share point
Update and send query tracker for initiatives while preparing test scripts
Conduct status calls on a daily basis during SIT Execution with Development, BA and QA teams to review test execution / defect status on a daily basis
Track the status of defects logged for initiatives and also follow-up with developers on getting defects fixed.
Ensure that all defects are fixed, retested and closed before the initiative SIT end date.
Review and circulate all testing deliverables - Test Estimates, Test Plan, Test Scripts, Daily, Weekly and Monthly status reports and SIT Sign off documents
Adhering to SLA and perform testing within the stipulated timelines
Post release activities to analyze the rejected defects, Calculate DAR and SIT Effectiveness to improve and maintain SIT testing Quality.
Create Pre-production and Post-Production quality review report for UAT and Production Phase respectively and set up calls with Project team and clients for briefing
Identify automation areas and build plan for regression suite creation to leverage automation scripts for future testing.
Tools
HP QC 11.0 & HP QTP 11.0
Accenture Services Pvt Ltd (Chennai, India)
Project
GRITT TQMS
Client
Bank of America
Period
March 2010 – December 2012
Description
Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. This project deals with Compliance, Risk Management and Capital Markets Segments
Position
QA Tester (Software Engineer - offshore)
Responsibilities
Handled a team of 4 members.
Worked on following bank applications: MDM (Matter Data Management), ERIM (Enterprise Risk and Issue Management), Common Threads, AIM (Associate Investment Management), ITF (International Treasury and Funding Technology), BAATS (Bank Of America Asset Allocation Tracking System).
Interacting with SME's & Client to leverage the Application Knowledge.
Developing domain Knowledge in Banking and technical knowledge.
Analyzing the scope of initiatives - BRD, High and Low level Design documents.
Prepared estimates for the project
Attend walkthrough calls and explain project scope and requirements to the team.
Prepare the regression bed (using QTP 11.0 ) in initiatives where this will be applicable to be used for regression testing in SIT.
Building PL/SQL queries wherever required to test database as per the BRD.
Sending Status Mails to Onshore and Offshore Leads on the status of the projects in execution on daily basis.
Provide sign off for SIT Phase. Provide UAT and Production testing support.
Database
Oracle 10g
Tools
PL/SQL Developer
Toad for Oracle 10g
HP QC 11.0
HP QTP 11.0