Santhini R [pic]
***********@*****.***
Experience Summary
> Total IT experience of 9 years in the QA domain and working as a QA
manager and project lead in my current assignment with JP Morgan
Chase. I have been working since May 2006 in various capacities
including QA analyst, Test Lead, Process Improvement Lead, QA Manager
and Project manager.
> Hands on experience in all processes and knowledge areas of project
management including proposal, planning, execution, monitoring and
controlling till closure.
> Have practical knowledge and experience with implementing process
improvement for projects using my skills of Six sigma certification.
> Strong familiarity with BI tools and related software applications.
Good understanding of Data warehouse procedures.
> Proficient and have sound working knowledge in ETL, manual, functional
and automated testing techniques including tools such as QTP, Load
Runner, Informatica, Teradata, Control-M,Cognos.
> Excellent communication, analytical and interpersonal skills with
ability to coordinate effectively between multiple teams working
across geographical boundaries also.
> Expertise in developing project plan, test strategy, comprising Test
Plan, Test Scenarios, Test Scripts, Testing Methodology and Test
Reports, automation of testing of various Client/Server and Web
applications.
> Have supported and contributed significantly in the end to end process
of IST, UAT, Relational acceptance testing and business process
testing.
> Experienced in working with Developers, Modelers, Business and Testers
as a team for complex projects during full Software Development Life
Cycle (SDLC) and Software Testing Life Cycle (STLC).
> Ability to Prioritize Work, Good Analytical, Trouble shooting and
Problem solving Skills.
> Having Strong Leadership, handling multiple tasks and Time management
skills.
> Work Independently, Creative, highly motivated and hard working with
interpersonal skills.
> Ability to interact with end users, learner and team player with good
communication skills.
> Expertise in Defect management lifecycle including setting up and
utilizing tools like HP Quality Center/ALM (Application Lifecycle
Management).
Technical Knowledge
> Testing Tools : HP Quality Center, HP Quick Test
Professional, Load Runner
> Databases : SQL Server, Oracle 7.X/8/9i/10g
> ETL tools : Informatica 8X/9X, Teradata, Power Exchange
> Operating System : Unix, Windows 7/Vista/XP/2000/NT Server
> Other technologies/Tools : Mainframe, AUTOSYS, CONTROL-M
schedulers, DB2 Client, SQL assistant, ALM (Application Life
Management) tool.
Professional Certifications
> Six Sigma Green Belt Certified quality professional
> ISTQB - ISEB Certified Tester Foundation Level
> HP Certified Professional - HP Quick Test Professional 10.0 Software
> HP Certified Professional - HP Quality Center 10.0 Software
> AIS - HP Performance center v9
> HP Load Runner Software
Academic Qualification
> Bachelor of Technology in Electrical and Electronic Engineering - From
Sri Manakula Vinayagar Engineering College, Pondicherry with 90%
aggregate.
Project Experience
Project # 1: JP Morgan Chase CAF - ICDW
Period: January 2011 - Till Date
Project Role: QA ETL Manager & Project Lead
Domain: Banking and Financial Services - Retail Banking
Location: Columbus, OH/Jersey City, NJ
Project Description:
Chase Auto Finance is a part of JP Morgan Chase retail banking division.
Auto Finance ICDW initiative is to Migrate Auto Loans Origination data
[ACAPS (Prime/ Near-Prime, Manufacturing Private Label and Lease) and RCO
(Custom)] and servicing data (ALA, VLS & CALS) in the ICDW platform and in
addition migrate all the downstream feeds that is part of ADW. As part of
ICDW initiative, chase now merges to a common platform and its one stop
solution to the business.
Project Responsibilities:
> Preparation of documentation including project plan, execution plans
and reports for end to end phases of the project.
> Individually involved in designing the QA Test strategy, the test
cycles and monitoring of test execution.
> Coordinated as the single point of contact for clients and Business
relationship manager.
> Reviewing daily execution reports and project status reports with
clients and all stakeholders.
> Coordinating the daily defect status meetings/discussions between QA
and Development team to resolve any conflicts.
> Quality review and process improvement with QA teams and development
teams working out of multiple geographical locations.
> Database testing design involving analysis using complicated SQL
queries, shell scripting.
> Testing of large scale data warehouses for various stages of ETL
process using tools like Informatica and Teradata.
> Major Contribution as the coordinator for the ETL testing of different
of System of Records (SORs) to Reports and successful completion as
per the schedule.
> Took up additional responsibilities willingly in the absence of team
members in spite of heavy work load to help achieve the team goal.
> Defect Management using the Quality center to track and coordinate
with the development team for the defects identified as part of the
testing process.
Technologies Involved:
ETL testing, Mainframe, UNIX, SQL, Shell script, CONTROL-M, AUTOSYS
Tools Used:
> Informatica 9.1
> Teradata
> COGNOS
> HP Quality Center
> Power Exchange
> CONTROL-M
> PUTTY
> HP QTP
Contributions to the Project:
> Worked under tremendous pressure and in spite of tight schedules and
delivered with zero rate of rework.
> Performing multiple roles at the same time and managing every
responsibility effectively at the same time handling hands on
execution.
> Showcased my excellent interpersonal skills as a team player working
with offshore development, model, test teams and contributing efforts
above and beyond the normal working hours to ensure the team members
are in sync.
Project # 2: CITI Markets and Banking (CMB)
Period: April 2008 - January 2011
Project Role: QA Test Lead
Domain: Banking and Financial Services-Investment Banking
Location: Chennai, India/Jersey City, NJ
Project Description:
CMB Global Corporate Operations Technology (GCOT) is accountable for
managing and maintaining systems that support CMB operations globally.
GCOT has a dense application landscape comprising of over 100 applications
spanning various technologies. These applications are broadly classified
into the following Application Portfolio Groups: Trades Processing, Global
Stock Record, NAM Settlements, NAM Corporate Actions, Retail Application
Portfolio and Operate Portfolio.
Project Responsibilities:
> Worked in the capacity of test lead for a team of 10 and also played
the role of single point of contact from client and onsite managers
> Contributed significantly to ram up of the team size in offshore and
training the new joiners by voluntary knowledge transition and
guidance to bring them up to speed.
> Involvement in End to End testing lifecycle for various web
applications and managing the offshore team.
> Analyzed business requirements, system requirements, data mapping
requirement specifications, and responsible for documenting functional
requirements and supplementary requirements in Quality Center.
> Tested complex sessions based on business user requirements and
business rules to load data from source flat files and RDBMS tables to
target tables.
> Created the test environment for Staging area, loading the Staging
area with data from multiple sources.
> Worked closely with developers and report planners/analysts to insure
that an acceptance criterion is complete and accurate for desired
report capability.
> Worked with ETL group for understating mappings for dimensions and
facts. Written several complex SQL queries for validating Cognos
Reports.
> Managed and executed the test process, using Agile Methodology.
> Used Quality Center for bug tracking and reporting, also followed up
with development team to verify bug fixes, and update bug status.
> Tested several complex reports generated by Cognos including
Dashboard, Summary Reports, Master Detailed, Drill Down and Score
Cards
> Involved in preparing the Data-driven and keyword-driven frameworks in
QTP for system and UAT environments and performed data comparison and
functional comparison.
> Performed Back-End Testing of flat files in Unix environment.
> Performed extensive Back-End testing by writing and executing SQL
queries on the database-using sql assistant.
> Participated in Business process testing to determine the need for
automation.
> Provide support to the clients for User acceptance testing.
> Defect Management involving tracking and following up on the defects
raised as part of the testing process.
Technologies Involved:
ETL testing, Mainframe, UNIX, SQL, Shell script, CONTROL-M, AUTOSYS
Tools Used:
> Informatica
> Teradata
> COGNOS
> HP Quality Center
> AUTOSYS
> PUTTY
> HP Quick Test Professional
> HP Quality Center
> HP Load Runner
Contributions to the Project:
> Worked individually end to end for testing of several SOR's from SOR-
Staging-Integration-Semantic-Reports in tight schedules and delivered
with zero rate of rework and managed several applications groups.
> Proved the ability to be a quick learner by ramping up my skills level
with ETL testing using tools such as Informatica / Teradata with pro
active efforts.
> In spite of the demanding requirements of the project, contributed
value additions by studying and pro actively engaging in the
automation of test scripts. Thus saving time and increasing the
efficiency involved in the testing.
> Demonstrated proficiency in leading and mentoring individuals to
maximize levels of productivity, while forming cohesive team
environment.
> Quickly becoming skilled in new areas of knowledge like automation
testing and completing the tasks within the stipulated time.
> Completed the Six Sigma Green belt certification and proactively
engaged in implementing the quality principles within my project as a
value addition.
Project # 3: Sellermania
Period: May 2006 - March 2008
Project Role: Test Analyst & Test Lead
Domain: Retail
Location: Pondicherry, India
Project Description:
Advanced marketplace selling for demanding merchants.
Reduce time consuming tasks, increase your productivity by automating
repetitive tasks. Increase sales with smart repricing. Increase the number
of products you sell with faster listings with the following services; Web
based, Stock updates, Detailed analytics, Easy product creation,Invoices
with VAT, Smart repricing, Saved inventory, Packing slips, Picking lists,Order management,7 Day premium, Support Latest encryption, Automate tasks,
Improve customer feedback, Online help, Numerous selling strategies, Error
checking and alerts.
Project Responsibilities:
> Performed Gray Box Testing, Regression Testing, Manual Testing,
Functional Testing, Usability testing
> Performed GUI functional and sanity testing manually for each new
build of the application.
> Performed backend validation by connecting to sql server.
> Executed test cases to compare the actual result with expected results
in accordance with business, technical and functional specs of the
applications
> Responsible for thorough testing of browser and platform compatibility
issues
> Create test plan, test suits and test cases
> Ensure test data is properly identified, setup and availability of
stub before execution of a test.
> Involved in Release Activities -testing a web site during a release.
> Validated applications GUI for compliance with Usability guidelines
published by Insurance Industry Standards.
> Verify bugs fixed in new releases
> Report defects using QC.
Technologies Involved:
SQL, VB script for automation test scripts
Tools Used:
> HP Quick Test Professional
> HP Quality Center
> Microsoft SQL Server
Contributions to the Project:
> Worked individually end to end for testing in tight schedules and
delivered successfully.
> Demonstrated proficiency in leading and mentoring individuals to
maximize levels of productivity, while forming cohesive team
environment.
> Quickly becoming skilled in new areas of knowledge like automation
testing and completing the tasks within the stipulated time.