SANDEEP GUPTA

Contact No.: +91 - 9604969211

E-Mail: sandy.ground22@gmail.com

IT PROFESSIONALAiming for challenging assignments in QA/ Testing/ Team Management/Team Leading with a reputed organization

preferably in IT industry to deliver solutions for complex technical requirements

PROFILE SUMMARYISTQB & Sun Certified Java (1.4) Professional with 8+ years of rich experience in handling Manual & Automation Testing and

QA functions with reputed organizations: expertise entails:

Software Testing Quality Assurance Project Execution Test Automation Client Relationship Management Team ManagementTest Plan/Strategy Creation Agile/Scrum Experienced Estimations Reports/ Documentation Test Case Design & Execution Defect Tracking

Presently associated with Fiserv India, Noida as Quality Analyst. Proficiency in Software Testing involving setting up of test environment, creation of test plan, test Strategy, test scripts / cases, execution of Functional Testing, GUI Testing, Integration Testing and Regression Testing and tracking of defects using various tools. Resourceful in handling all aspects of the SDLC/STLC inclusive of conducting review & analysis, suggesting technology-based solutions, testing and fixing of defects. Expertise in utilizing tools like QC, JIRA and QTP for Defect Reporting and Test Management. Hands on Experience on Agile Testing Methodology, UNIX, SQL,IBM Rational Software Modeler (RSM), Enterprise Architecture Model (EA Model), Green Hat Tester, Toad, Data Loader, Version One, APL Tools.

Gained expertise in Banking and Finance, Investment Banking (Cards and Payments & Investment Services), Finance, Insurance, and Manufacturing Domains. Worked on Equity and Derivatives. Demonstrated excellence in understanding software design specifications, participating in design reviews, making recommendations for product improvements & executing product releases. Well versed with the concepts of end-to-end project planning and execution from scope management to activity sequencing, effort & cost estimation, risk analysis to quality management. Skilled at grasping new technical concepts quickly & utilizing the same in a productive manner. An effective communicator with strong people management, time management, problem solving, and analytical skills.

WORK EXPEREINCE Since Jul’13: Fiserv India, Noida as Quality Analyst

Presently managing a team of 8 members

Feb’12 to Jan’13: Infosys Technologies, Pune as Test Analyst

Nov’10 to Jan’12: Syntel Ltd., Pune as Test Analyst

NOV’07 to Sep’10: Larsen and Toubro InfoTech Ltd., (Software Engineer) Growth Path: Joined as Software Engineer and rose to the Quality Analyst

Key Result Areas Developing project baselines; monitoring & controlling projects with respect to cost, resource deployment, time over-

runs and quality compliance to ensure satisfactory execution of projects Scheduling & executing the Software Testing Life Cycle; conducting system study and coordinating with team members

for System Design & Integration, Application Maintenance, etc. Planning and coordinating the implementation and availability of the QA test environments, and ensuring compatibility

of QA test; carrying out analysis of the application quality and software verification technical assessment review Creating test plans, test Strategy, test scenarios, test cases and test scripts/procedures for carrying out Functional

Testing, GUI Testing, Integration Testing and Regression Testing at various stages in the SDLC

Handling Defect tracking process involving Defect reporting and verification; doing defect logging in QC, JIRA and Splice-M

Participating in Status Review meetings with the team & other stakeholders/client to monitor project progress; generating Review Report, Defect Summary Report, Progress Report, Test Matrix Report and Test Statistics Reports (you can add these also)

Verifying change requests and defects; documenting, tracking and communicating test plans, test results and unresolved problems; updating Error Log / Suggestion Log and explaining system bugs to Programmers

Building and maintaining healthy business relations with clients, ensuring high customer satisfaction matrices by achieving delivery & service quality norms

Creating and sustaining a dynamic environment that fosters development opportunities and motivates high performance amongst team members

Highlights: Served as a Business Consultant for 2 months and handled functions like RFP, POC while presenting White Paper Worked as a Coordinator in DP Group and CAR coordinator to prevent the occurrence and determine root causes of

defects Holds the distinction of being a member of an innovative boot camp workshop Took ownership of preparing the SMR report and Dashboard for project related activities Received client appreciations and monetary award in Jan’14

EDUCATION B.Tech. in Electronics & Communication from SSIET, Derabassi, PTU in 2007

Certifications: Certified as ISTQB (International Software Testing Qualification Board) Foundation Level Tester Sun Certified Java Professional 1.4 (SCJP)

TRAININGS ATTENDED Three months of intensive training on Software Fundamentals and Java Technology at L & T InfoTech Ltd. During 2007-

2008 Two weeks training on QC & QTP at LnT Infotech in 2008 One week training on SharePoint 2007 which included overview of SharePoint 2007 and the use of its tools such

SharePoint Designer and InfoPath Forms 2008 One week training on tools like VSS Server and IBM Rational Software Modeler (RSM) 2009

IT SKILLSOperating Systems: Windows 2000, Windows XP, Windows 7Databases: MS SQL Server 2000, MS SQL Server 2005, MS AccessSource Control Tools : Microsoft Visual Source Safe (VSS)Design Tools: IBM Rational Software Modeler (RSM), Enterprise Architecture Model (EA Model)Code Analysis and Testing Tools: Microsoft FXCOP, QC, SPLICE-M, QTP

PERSONAL DETAILSDate of Birth : 10th January 1986Current Address : flat:702, building: Urvashi 2, society: Amarpali royal, indirapuram, ghaziabad, 201010Permanent Address : # 2933, Sector 15, Panchkula (Haryana)Languages Known : English, Hindi and PunjabiLinkedIn Profile : Sandy.groun22@gmail.com , sandyz_ground@yahoo.com Location Preference : Anywhere in North India

Please refer to Annexure for Project Details & Extracurricular Activities:

ANNEXURE

PROJECTS EXECUTED

With Fiserv India

System: CPQ (Configure Price Quote) SalesforcePeriod: November 2015 – Till DateClient: Fiserv ISRole: Lead Quality AnalystTeam Size: 8Hardware Platform: Pentium PCsSoftware Platform: Windows 7, Virtual MachinesScope: It is Rate Quote Bind application. Its main purpose is to provide various options for 4 wheeler Insurance to its clients based on the type of vehicles. It is a Role/Profile based application. It’s basic model comes from Salesforce which is highly customizable Cloud Computing technique. We can modify our application in various number of ways with the help of Sales Force Framework.Responsibilities: Involved in:

o Understanding requirements from the client’s end users (Agile Process)o Coordinating Daily and Weekly Status Calls, Defect Triage Callso Preparing Test Plan, Test Strategy, High Level Test Scenarios, Test Caseso Performed FIR (Final Inspection Review)o Providing Estimationso Mentoring new Team Memberso Conducted Process related Trainings o Executing Test Cases and Logging Defectso Attending CAR meetings and creating reports on weekly/monthly basiso Creating SMR Reportso Creating HCMo Facing QPI Auditso Heading DPG

System: One ViewPeriod: July 2013 – October 2015Client: Fiserv ISRole: Lead Quality AnalystTeam Size: 8Hardware Platform: Pentium PCsSoftware Platform: Windows 7, Virtual MachinesScope: It is a Portfolio Management Tool for Investment Banking customers. In One View the portions of Portfolio are managed by different Investment Sub Managers. A Master Manager allocates funds to Sub Managers and handles the Administration. The purpose of this application is to create a UI for the old application which was written way back in APL (A Programming Language). Trade life cycle is monitored closely in this. The previous application did not had a UI so users had to Log In to APL and enter commands which yielded results but the results were very time consuming to understand interpret, so the need of a UI application arise. We compare the functionalities from the UI with the APL application. There

are number of functions used for Trading in Equities and Derivatives which have been transformed into UI module but still there are many more functions to be transformed. UNIX and SQL are extensively used.Responsibilities: Involved in:

o Understanding requirements from the client’s end users (Agile Process)o Coordinating Daily and Weekly Status Calls, Defect Triage Callso Preparing Test Plan, Test Strategy, High Level Test Scenarios, Test Caseso Performed FIR (Final Inspection Report)o Providing Estimationso Mentoring new Team Memberso Conducted Process related Trainings o Executing Test Cases and Logging Defectso Carrying out Testing (Functional, Regression)

With Infosys Technologies

System: GPU MigrationPeriod: February 2012 to January 2013Client: BarclaysRole: Lead Test AnalystTeam Size: 7Hardware Platform: Pentium PCsSoftware Platform: Windows XP, Virtual MachinesScope: The purpose of this application was to migrate all the payments to a new Payments Processing Engine i.e. GPP (Global Pay Plus). Earlier all the initiated payments were routed to a different Payments Processing Engine i.e. AFTS (Automatic Funds Transfer Services). A middleware system BEM is placed between the payments initiated and the destination i.e. the Payments processing Engine, which governs all the rules and according to the rules hit in BEM the payments are routed accordingly to the correct Payments Processing Engines. SQL is extensively used.Responsibilities: Accountable for:

o Understanding requirements from the client’s end userso Coordinating Daily and Weekly Status Callso Preparing Test Plan, Test Strategy, Test Data, High Level Test Scenarios, Test Cases, o Executing Test Cases and Logging Defectso Carrying out Testing (Functional, Regression)

With Syntel Ltd.

System: SEPA ImplementationPeriod: Nov 2010 to January 2012Client: American ExpressRole: Test AnalystTeam Size: 25Hardware Platform: Pentium PCsSoftware Platform: Windows XP, Virtual MachinesScope: SEPA stands for Single Euro Payments Area, the purpose of this application was to provide a mechanism to process cross border EUR payments as domestic payments. The validation of all the Reports generated after a specific amount of time is being done according to the client specifications.Responsibilities: Accountable for:

o Understanding requirements from the client’s end userso Attending Daily and Weekly Status Callso Preparing Test Caseso Executing Test Cases and Logging Defectso Conducting Testing (Regression)

System: SalesforcePeriod: Nov 2010 to January 2012Client: American ExpressRole: Test AnalystTeam Size: 25Hardware Platform: Pentium PCsSoftware Platform: Windows XP, Virtual MachinesScope: The purpose of this application is to Record and Store the details of a Customer who enrolled for a policy. The Customers are contacted via Salesforce Customer Care Centre and the interested Customer’s details are stored in the system. The status of the Policy is monitored constantly at every level.Responsibilities:Accountable for:Understanding requirements from the client’s end usersMonitoring End To End Testing ScheduleAttending Daily and Weekly Status CallsPreparing Test CasesExecuting Test Cases and Logging DefectsConducting Testing (Functional)

With Larsen and Toubro InfoTech Ltd.

System: IMX (Inland Marine Express)Period: October 2009 to September 2010Client: TravelersRole: TesterTeam Size: 5Hardware Platform: Pentium PCsSoftware Platform: Windows XP, Virtual MachinesScope: The purpose of this application was related to Insurance domain. Travellers is a Leading Insurance provider in Business as well as Personal domain in US. A system is designed which is used by their Agents and Administrators to provide Insurance to the people for the Goods that they commute from LAND. They also provide an option to INSURE the goods being commuted through SEA.Responsibilities: Involved in:

o Understanding requirements from the client’s end userso Preparing Test Caseso Executing Test Cases and Logging Defectso Conducting Testing (Functional, Automation and Regression)

System: IT Ordering Process (ITOP)Period: January 2009 to September 2009Client: Scania Info Mate (Leading Truck Manufacturers In Sweden)Role: TesterTeam Size: 13Hardware Platform: Pentium PCsSoftware Platform: Windows XP, Virtual MachinesScope: The purpose of the application was to provide Scania with such a System that Scania can fulfill the Hardware requirements of their employees, by ordering the different types of Packages for their employees. This system will be used by Scania internally. It gives them various options to choose between different varieties of Packages available. The UI is very User Friendly and can be easily understood and various Packages can be easily searched and ordered.Responsibilities: Accountable for:

o Understanding requirements from the client’s end userso Preparing Test Plan and Test Cases

o Designing of the applicationo Preparing Test Caseso Executing Test Cases and Logging Defectso Conducting Testing (Functional and Regression)

System: Tracer Graphics EditorPeriod: June 2008 to December 2008Client: Leading Air Conditioning Systems and Services Company from USA.Role: TesterTeam Size: 15Hardware Platform: Pentium PCsSoftware Platform: Windows XPScope: The purpose of the application was to provide editor functionality to the trained users to generate the web pages (.xhtml pages &. aspx) containing the information about the layout of the components spread over the floor. The web pages thus generated will be fed as input to the existing Tracer SC server and Tracer ES server application. The editor being developed is similar to the Visual Studio IDE where basic editing functionalities such as drag-drop, move, resize, alignment, layering, cut, copy, paste and delete of components are provided. Undo and Redo of actions performed is provided to the user using the command design pattern. The components being created by drag drop would be varying from user controls and transparent shapes such as rectangle, circle and free shapes. The application also supports the opening of already generated web pages and set the layout of the components on the fly. Apart from the editing functionalities, complex controls such as toolbox and editor pad with scrolling facility are developed for the rich look and usability of the application.Responsibilities: Involved in:

o Understanding requirements from the client’s end userso Designing of the applicationo Preparing Test Caseso Executing Test Cases and Logging Defectso Conducting Testing (Functional, UI, AdHoc and Regression)

EXTRACURRICULAR ACTIVITIES Merit of representing College and School in Shot Put, Javelin Throw, Table Tennis and Basketball Attained Black Belt in Martial Arts Successfully organized Technical and Cultural events during IT & College