Professional Summary

• Over 7.5 years of experience as a test analyst and automation engineer with strong technical and analytical skills.
• Lead a team of three and demonstrated success in managing test activities for critical million dollar financial projects.
• Extensively worked in client facing role collated project requirements and change requests.
• Vast domain knowledge in Health Insurance, Securities Trading, Investment Management, Retirement Distributions and Financial Analytical Tools.
• Extensively trained on oracle applications - Oracle ERP, Oracle Advanced Benefits OAB , Oracle HRMS, Oracle PLM e-business suite, Oracle Warehouse Management System.
• Highly experienced in analyzing business and technical specifications and developing manual/automated test scenarios that ensure maximum coverage.
• Engineered robust automated test scripts for web applications, web services, .NET windows forms, Oracle forms and Mainframe screens in QTP using descriptive programming in VB.
• Leveraged past engineering experiences t propose and prove innovative Test automation Engineering strategies
• Experienced in designing data driven automation framework and delivering reusable modular test scripts.
• Strong Understanding of SDLC concepts.
• Skilled at performing Functional, System Integration, User Acceptance, Regression and Exploratory testing for Web applications.
• Proficient in creating complex SQL queries and working with RDBMS.
• Experienced in manual testing of desktop and Client-Server based application.
• Worked on load testing using .
• Expertise in using MS excels Macros, Formulas and Functions.
• Key member of quality team and helped promote QA standards and best practices.
• Recognized for being a successful team worker, fast learner, problem solver and sol achiever.

Technical Skills

• Operating Systems: Windows 2000/XP, UNIX
• Programming Languages: VB, SQL, PL/SQL, PERL
• Automated Test Tools: QTP/UFT, Load runner, Excel Macros
• Testing Tools: QC, SOAP UI, Confluence, JIRA, Clear Quest, MS excel Macros Formulas, Test Advantage, Lotus Notes
• MS Visio, SharePoint
• Databases: Oracle, Mainframe DB2, MS Access, MS SQL Server
• Database client: TOAD, SQL Navigator, RUMBA
• Technologies: JAVA, XML, HTML5
• QA Methodologies: SDLC, Agile

Experience

Confidential

Senior Analyst Developer Quality Assurance

• Goldman Sachs owned Archon Group Archon is a real estate investment services and asset management firm with focus on building value through acquisition, development, management, financing and disposition of real estate investments, including mortgage loans secured by real estate.
• Business Analytical Models project was part of an initiative that aimed at bringing all data- real estate, loan, financing, valuation, disposition int one single repository, OMNI. This central repository helped Excel Based analytical models t work as online models that helped asset managers t get real time access t data and avoid manual collation of data from various data sources.
• Set up a QA team for end t end testing of 22 Financial Analytical Models used in Asset Management
• Engaged with key stakeholders and product owners t assess current state, define target state and ensure smooth integration of QA int the SDLC
• Lead a team of three and coordinated with offshore team t meet QA deadlines.
• Formulated test strategy after a thorough analysis of models and interdependent systems.
• Defined test plan for onshore-offshore model
• Owned 13 of the 22 Models and responsible for estimations, test deliverables and documentation.
• Gathered, documented and maintained project requirements and related business documents in Confluence.
• Created comprehensive test scenarios that facilitated in detection of 28 of issues in the early stages of model development.
• Created Requirements Traceability Matrix by mapping test cases t user requirements
• Recognized as the Subject Matter Expertise for Asia Investment Rollup models t the Portfoli Management Team
• Validated and debugged views, triggers, stored procedures t ensure conformance t business rules.
• Involved in building complex SQL queries for data mining and troubleshooting defects
• Recommended and developed custom VB Macr solutions for Portfoli team t increase efficiency of business processes.
• Performed functional testing of SOAP based web services using SOAPUI t kick start test cycle before the GUI could be implemented.
• Conducted training sessions and presentation on QA workings t the globally distributed teams
• Actively participated in sessions with technical business analysts t analyze change requests, discuss impact areas and review test scenarios
• Prepared and presented status updates. Documented and reported system defects including defect summary, steps t recreate, system configuration, environment setup, expected, and actual result .
• Performed root cause analysis after a major release t incorporate learnings int future test cycles
• Tracked bugs in JIRA and worked in collaboration with developers t resolve issues
• Provided task dependencies , priorities and time estimates for project releases
• Mentored new team members on processes and application functionality
• Maintained a high degree of functional expertise on target systems.
• Strategized excel based test framework and developed an automated solution for web services using QTP 10 that validated XML response against DB. This facilitated validation of more than 100,000 records of cash flow data for accuracy and consistency
• Created, executed and maintained the automated suite
• Responsible for analysis and reporting of web services automation test results every monthly release cycle
• Real estate management project involves new feature based testing of real estate management portal java based web application , RMS that manages the life cycle of an asset from acquisition t disposition
• Worked in agile development project for Lease Abstract module and represented QA in SCRUM meetings.
• Created detailed test cases from user stories
• Involved in Functional testing, test planning and estimations for each user story
• Managed all test artifacts in QC and executed tests from QC

Confidential

Senior Analyst Developer

• Private wealth management group of Goldman Sachs enables investment analysts with information t guide the investors about their wealth, Risks, Assets, Liabilities and many other parameters useful for managing their assets.
• The project involves functional testing of portfoli front end, Investment analytical tool- CI Presentation builder used by sales representatives t market portfoli services t high net worth clients.
• Lead functional testing of CI investment analytics tool Proposed and implemented test strategy and contributed t test plan
• Engineered data driven automation framework t regression test CIO
• Set up automation environment and built automated test suite for CI using QTP
• Designed and implemented XML compare and PDF compare automated scripts for Presentation builder module t ensure consistency of data in QA environment and PROD The XML file generated in XML compare is converted t PDF for PDF compare
• Analyzed business and technical specifications t come up with requirements traceability matrix
• Conducted Gap Analysis t ensure all Business Requirements were covered by test cases
• Participated in requirement walkthroughs and design review meetings
• Performed Load test on Presentation builder module t generate the load on the server by creating Vuser Scripts t simulate heavy load using LoadRunner.
• Performed back end testing by running SQL queries
• Attended Change Control Meeting for approval of change requests and raised testing concerns.

Confidential

QA Test Engineer

• Streetscape is an online web-based brokerage solution that integrates trading and service functionality with customer information, risk management tools, and a single point of access t real-time market data, news, and third-party research. The project involved regression testing and new functionality/module testing of Streetscape.
• Lead testing efforts on the implementation of new feature: Trailing Stop Orders in Equities and Options trading platform.
• Developed and executed comprehensive test suite t perform user acceptance testing on the new feature
• Identified possible impact areas and performed regression test
• Managed Test requirements, test cases, execution status and defects in QC
• Identified automation scenarios and scripted tests in VB using QTP
• Developed, maintained and optimized a fully automated regression suite using QTP 10 t test business critical modules -Brokerage Accounts, Portfolio, Securities Trading and Order Book on Brokerage Solutions platform, a Java based web application. This resulted in significant cost savings by reducing regression test effort from 40hrs t 8hrs per monthly build.
• Created user manual for running the automated scripts
• Developed an automated test suite for workflow management system, XTRAC .NET application . It reduced the time taken for on-boarding of new clients int the system from 3 days t 2 hrs. per client
• Gathered customer requirements, performed feasibility study on the application under test and investigated the tool Test Advantage by Infragistics in integration with QTP 10
• Wrote Proof of concept POC and presented gap analysis findings on QTP t clients
• Worked closely with the sales and technical team of Infragistics t purchase the tool and understand its working
• Designed data driven automation framework with data stored in external excel sheet and scripted automated tests
• Documented a training manual for running the scripts and gave a demonstration t clients
• Collaborated with multiple development teams and technical analysts across departments t carry out UAT on
• Securities lending project-Borrow fully paid. Responsibilities included test co-ordination, requirement analysis, test
• case preparation and walkthrough, test execution, defect logging and resolution
• Coordinated with third party vendors t carry out end t end testing of Fixed Income Trading Tool, Bond Trader Pro.
• Involved in Project Estimation and metrics collation for the team
• Actively involved in QA forums t discuss testing experiences, available tools and techniques and share best practices
• Conducted trainings on developing automated scripts using QTP
• Gave project presentations t business analysts and UAT managers

Confidential

Associate Test Engineer

• Retirement Distributions project is aimed at enabling Advisors Correspondents using Streetscape.com, NF's web based brokerage technology platform, t perform paperless online entry of retirement distributions through Integrated Cash Platform ICP .
• Analyzed customer requirements, documented use cases, prepared test scenarios and performed executions on all the three phases of Retirement Distributions project.
• Worked collaboratively with development teams t drive resolution of bugs
• Involved in system design review phase of the project
• Health and Other benefits system HOBS is Fidelity customized HR solutions suite which is built on an Oracle Advanced Benefits OAB platform. HOBS maintains employee data and utilizes it t provide the corresponding benefits t employees called participants by sharing it across multiple modules such as Eligibility, Enrollments, Rates and premiums, Literature sent t participants, employers and als Carriers .
• The project involved ongoing testing of all HOBS modules oracle forms for the fixes provided in-house for either customized code or Oracle provided Technical patches for core Oracle code on a monthly release cycle.
• Performed requirement analysis and feasibility studies on the oracle release patches
• Worked on functional testing on technical patches, regression testing on all HOBS modules and ensured conformance t HIPAA guidelines.
• Identified regression test scenarios and worked on building automated test scripts for the same using winrunner
• Validated employee benefit reports using PERL scripts
• Involved in peer review of test plan and test strategy
• Acquired vast domain knowledge in Health insurance towards attaining subject matter expertise
• Evaluated logs in UNIX boxes for debugging issues
• Built complex SQL queries t mine data for test data set up
• Maintained , documented issues, test cases , test execution status in Lotus Notes
• Outbound Redesign and Virtualization project was aimed at redesigning and virtualizing the outbound operations of Fidelity's Enterprise Processing Services as part of business continuity program. The outbound applications involve Correspondence Manager CM , Oracle ERP suite e modules, Oracle Warehouse Management System WMS and SMA integrated together.
• Effectively engaged with Functional architects, implementation teams globally t understand business requirements and working flow of Oracle ERP suite
• Created and documented test cases for functional and end t end testing of Oracle forms in integration with WMS, Oracle PLM e-business module and SMA
• Extensively trained on Oracle e business suite for manufacturing and supply chain management module
• Tested mobile interface of java based Oracle warehouse management system using a telnet client
• Tested upload of flat files t SMA using FTP protocol
• Executed tests under tight deadlines
• Reported daily defect report and execution status Involved in daily triage meetings