Project Management

Navjyot Deshmukh

Mobile: 551-***-**** Email: *********@*****.*** Location: SanAntonio TX

Professional Summary:

6+ years of experience in Manual (Web Based), Database & Mainframe Testing.

Exposure to tools like HP ALM, HP QC, eSource, IBM Rational ClearQuest.

Extensive experience in Functional testing, System testing, Integration testing, GUI Regression testing, E2E testing, and middleware testing

Execution of Test Cases, Test Summary report, Performance Reports and defect tracking and closure

Expertise in Bug Tracking and Reporting using HP QC and HP ALM

Well versed with SDLC Waterfall and Agile, Testing Life cycle and Defect Life cycle

Excellent Analyzing, Problem solving, and negotiation skills. Fast learner with good people skills and leadership ability

Ability to test the product according to customer specifications under time pressure.

Experience of analyzing and handling production issues

Capable of working in groups as well as independently. Possess excellent oral & written communication skills along with interpersonal skills.

Supported testing for Trading systems – Equity, Options, Mutual funds, Fixed Income and also worked on Mainframe testing for Insurance Domain.

Experience of handling the teams of different geographical locations (India, USA).

Areas of Expertise:

Manual Testing

Creation of Test Plan, Test Cases, Test Scripts, Defect Report, Final Test Summary Report, Requirement Traceability Matrix, Backend testing, Mainframe DB2 & COBOL Job testing.

Tools

HP ALM, QC, eSource, Rational ClearQuest, QTP (Trained), SOAP UI, TOAD, Mindmap, Hexawise.

Domains Worked

Wealth Management, Health Insurance

Operating System

Windows 7, Windows XP, UNIX

Databases

Oracle, SQL Server, DB2

Languages

C, C++, VBScript, VB, Core Java, COBOL

f

Education: BSc in Information Technology from Mumbai University, INDIA (Year 2008)

INDUSTRY EXPERIENCE:

Employer: Infosys Limited (from Sept 2008 – Till date)

Test Lead, Infosys Limited (May 2015 to till date)

CLIENT: Capital Group Companies, SanAntonio TX (Onsite Position)

Project Name: Automated Work Distributor Project(Finance Domain)

Project Abstract:

AWD (Automated Work Distributor) is business process management (BPM) solution. AWD software automates the workflow received in CG account.

Responsibilities:

Managing all QA responsibilities from E2E Test cycle with 4 members of Offshore team.

Worked on SQL, SOAP UI, Web Services testing & Unix batch job from Execution point of view.

Coordination with all stakeholders – Business, Development team.

Test Effort Estimation & tracking all QA actions as per schedule.

Used Hexawise & Mindmap for Test case design & Test case generation,

Tools/Technologies: Mindmap, Hexawise, HP ALM, SQL/ORACLE, SQLDbx, SOAP UI.

Test Lead, Infosys Limited (Feb 2015 to Apr 2015)

CLIENT: UBS Investment bank, Nashville TN (Onsite Position)

Project Name: Regulatory Reporting Framework Project (Wealth Management Domain)

Project Abstract:

RegReporting framework project is going to replace the existing excel macros calculation by implementation of new core engine or automated process. It involves following verifications:

1. Database table verification against various SunGard BRASS files (third party data)

2. OATS & FINRA Reports validation with Database tables.

Responsibilities:

QA Lead responsibilities for Test planning, Test Execution & Test Result reporting.

Use of different type of SQL Queries for retrieval of data from different tables.

Maintaining requirement traceability matrix.

Execution of negative/rainy day scenarios depending on file mockup scenarios.

Created excel comparison tool for data comparison with database extract.

Tools/Technologies: HP ALM, SQL/ORACLE, SQLDbx, SOAP UI.

Test Lead, Infosys Limited (Dec 2012 to Sept 2013. Aug 2014 to till date)

CLIENT: UBS Investment bank, Weehawken NJ & Nashville TN (Onsite Position)

Project Name: G2 Fixed Income Trading Project (Wealth Management Domain)

Project Abstract:

BondWorks is a console for the financial advisors and clients to place their orders for fixed income securities hosted by internal and external sites.

QA verification involves full trading life cycle's end to end testing of the following components:

1. Trade initiation and delivery.(front office function)

2. Risk management and order routing.(middle office function)

3. Affirmation and confirmation. (Back office function)

4. Clearing and Settlement.(back office function)

Responsibilities:

Requirements gathering from Business, preparing test plan and test strategy document.

Responsible for creating tickets and link it with the requirement to trace the progress of each phase (from development to release in production)

Creation of the test cases on the basis of the requirement, setting up test data, QA/UAT environment for testing.

Test Execution involves verification of webservices, GUI validation, Mainframe and database validation.

Experience working with Capital market products (fixed income, MBS, OTC derivatives, FX etc).

Defect tracking & verification for the vendor applications (BondDesk & TradeWeb Retail)

Responsible to provide UAT support and getting UAT signoff from Business users

Responsible to carry out the production checks when the code is released in production

Co-ordination with the Development team, Business team and QA teams in India.

Execution of the automation scripts in QTP for regression created by automation team.

Tools/Technologies: HP ALM, eSource, ADT Jetpac, QTP.

Test Lead, Infosys Limited (June 2014 to Till date)

CLIENT: UBS Investment bank, Weehawken NJ & Nashville TN (Onsite Position)

Project Name: Cost Basis Project (Wealth Management Domain)

Project Abstract:

Cost Basis is an IRS regulatory compliance project which involves reporting of all transactions on tax lot level to IRS. It involves calculation of total cost when shares are bought and that forms the basis for future tax calculations depending upon gain or loss.

Responsibilities:

Onshore QA coordinator. Led medium (6 people) sized team. Responsible for management of all Quality Assurance functions include planning, strategy, testing execution and tools.

Worked with the Project Manager, Development Team and Business Team to establish time tables and agree on a Quality Assurance plan.

Coordinates performance testing and ensures that performance standards are communicated and documented.

Facilitates weekly Quality Assurance meetings with IT and Business team and maintains agenda

Worked on Console application which is used for Trading of Equities, Options, MFs & Fixed Income also Gainskeeper application which is repository for Tax lot representation of various securities.

Tools/Technologies: HP ALM, VBScript language, Mainframe DB2, UNIX.

Test Lead, Infosys Limited (Nov 2013–June 2014)

CLIENT: UBS Investment bank, Weehawken New Jersey (Onsite Position)

Project Name: Asset Held Away – Rage (Wealth Management Domain)

Project Abstract:

Asset Held Away project allows UBS to aggregate custodial accounts, assets, transactions, cash flows and position data for IC clients whose assets are held away at other custodians.

Responsibilities:

Managed and Led medium(5 people) sized teams spread across onshore and offshore

Understanding business requirements and define the scope of testing work.

Worked on all phases of STLC in this project

Testing artifacts preparation such as Requirement Traceability Matrix (RTM), High level test plan, flow charts, High level scenarios, Test cases.

Found more than 300 defects during version1 of this project which causes business to extend timelines of this project and eventually total tally of defects becomes 600+

End to end verification of Client enrollment system with Performance and billing data validation. QA has successfully verified all requirement changes during this project.

Used Toad to retrieve data from database as per different criteria’s.

Created VBScript tool for comparison of Extract files which has generated 80% effort saving

Tools/Technologies: HP ALM, VBScript language, Toad, UNIX.

Test Analyst, Infosys Limited (June 2012 – Oct 2013)

CLIENT: UBS Investment bank, Weehawken New Jersey

Project Name: Equity and Options Fee Pricing Project (Wealth Management Domain)

Project Abstract:

This project is about introduction of new Equity and Option commission schedules based on a defined range of principal money, percentage and set dollar amount so that UBS WMA will be aligned with competitor.

Responsibilities:

Worked as Offshore lead for 4 team members.

Involved in Requirement understanding phase with Business stakeholders.

Created Test plan and Test cases

Verified Commission admin tool which is created for Equity and Option products based on different conditions.

Created Excel macro tool to automate various commission rules. This tool is used by entire team which resulted in 40% effort savings.

Raised more than 100 high severity defects.

Coordination with various application stakeholders proactively on various issues, test results and testing status.

Work allocation, Effort estimation, Defect tracking, UAT testing and Integration testing efforts.

Tools/Technologies: HP Quality Center, VBscript, Oracle, UNIX.

Test Engineer, Infosys Limited (Jan 2010 – May 2012)

CLIENT: UBS Investment bank, Weehawken New Jersey

Project Name: Retail Trading QA project (Wealth Management Domain)

Project Abstract:

Worked on below projects in Retail Trading QA project:

COE (Consolidated Order Entry) Project consists of applications that enable financial advisors and Clients place order for Equities, Options, Mutual Funds and Fixed Income products.

Equity Investor Order entry project

Unit investment trust (UIT) project is an exchange-traded mutual fund offering a fixed (unmanaged) portfolio of securities having a definite life.

Responsibilities:

Analyzed Software Design Specification (SDS) and Functional Requirements Specifications (FRS) with business, Development team.

Prepared Test plan, Test strategy, Test Cases from business Requirements

Verified frontend order entry system for various trade products – Equities, Options and Mutual Fund in QA envt. Worked on CTPS (UNIX based application) application to execute trades.

Mainframe backend system is used for Position and balance verification.

Created macros for search and login functionality in Mainframe. 60% effort saving is achieved.

Performed database testing to verify different investment products parameter values.

Worked on Agile testing methodology for EQI project.

Used Quality Center for defect reporting. Attended Defect Status Meeting and prioritize the defects.

Collected and reported testing metrics for all aspects of testing.

Interacted and worked with the business/developers for implementing Change Requests.

Offshore coordinator for EQI and COE Equity application.

Tools/Technologies: HP Quality Center, Oracle, UNIX.

Test Engineer, Infosys Limited (Dec 2008 – Dec 2009)

CLIENT: Aetna Healthcare Insurance

Project Name: Government Programs (Healthcare Insurance Domain)

Project Abstract:

GP Project involves mainframe applications for member enrollment in various plans of Aetna. MID is frontend application whereas APPS is DB2 application.

This has Mainframe Database as backend system (DB2).

Responsibilities:

Verification of New Enrollment process of Government program Members.

Involved in Job setup activity, Data preparation, Online and batch (Job process)

Written test cases to verify the functionality of frontend application MID

Various test execution activities in Mainframe project - GPS

Database testing in SQL Server and DB2 for APPS project

Interaction with Client on status, deliveries and sign off

Coordinating team of 4 members including status reporting and issue resolutions.

Coordination with various application stake holders proactively on various efforts and testing status.

Tools/Technologies: HP Quality Center, Clear Quest, COBOL, CICS, DB2, JCL, SQL.

Other Achievements:

Worked as knowledge Management prime Anchor at UBS Account level. UBS WMA account has won second best project award in Infosys for March’13-Oct’13 period.

Won Insta award – Quarterly Best QA at Account level for Apr’13 in Infosys.

DP Anchor for Aetna GP project during May’09 – Dec’09.

Training and Certifications:

Basics of Business and Professional Practices conducted by Global Business Finishing School - Time Management, planning and prioritization, business etiquettes, customer orientation (1 month Training period)

Manual and Automation Testing - QSIT Certified with an ‘A+’ Grade (2 months Training period)

‘Software Testing Foundation Program’ conducted by Infosys.

Oracle Fundamentals – Infosys internal certification.

Attempted CFA LEVEL 1 exam in Dec 2014.

"REFERENCES: Available upon request"

Contact this candidate