Siddhartha Mondal

 Siddhartha Mondal Email:-Skype: Siddhartha.mondal56 To secure a dynamic position in the field of IT / Banking industry where my technical, testing and analytical skills will be utilized to the utmost level and provides enough scope to explore my knowledge to serve the organization to the best of my ability and skills. Synopsis Young, energetic and result-oriented IT professional with 6.9 Years of experience in Software Testing specializing in SOA Testing, Automation Testing and Manual Testing. I have deep understanding of technology with focus on delivering business solutions. Proficiency in Functional Testing, Regression Testing, UAT Testing, SIT Testing, Sanity Testing, Smoke Testing, STLC, SDLC including functionality & Defect Life Cycle. Recommend resolutions to complex matters of significance and coordinate the implementation of the approved course of action. Ability proven to mentor the resources according to project needs. Areas of Expertise Banking and Financial services & Retail domain Project Audit Planning, Analysis, Design & execution of both Manual and Automation Test Script Possess excellent communication, troubleshooting and problem-solving skills Reporting and Tracking of Defect Visionary Leadership DSR, WSR & MSR and Project Tracking Proactive & Industrious Technical Proficiency Operating System : Windows-XP, 7 and 8.1, AS/400 Languages : Core Java, VB Script, Groovy, SQL, XML, Unix Basic, HTML Test Management Tool : QC 10 and ALM Defect Management Tool : JIRA and Bugzilla Test Automation Tool : QTP and UFT, Selenium WebDriver, SOAPUI, TestNG, Sauce lab Databases : Oracle 11g, SQL Server and Sybase, DB2 Other Utilities and Tools : IPad, IPhone, TIBCO TOPIC & EMS, SQL Developer, Rapid SQL, POST Man, SVN Work Experience Certification Completed ISTQB Foundation Level Cognizant Certified Professional in L0 – Banking and Financial services Cognizant Certified Professional in L1 – Mortgage Banking Educational Qualifications Year Qualification School / College University / Institute Total Marks % 2008 B.Sc. (Physics) Asutosh College Calcutta University 56.5% 2004 Higher Secondary Tamluk Hamilton High School West Bengal Council of Higher Secondary Education 76.9% 2002 Secondary Tamluk Hamilton High School West Bengal Board of Secondary Education 83.2% Projects Executed Project#1: D2C Smartpush Automation Client : Macys (Retail) Duration : Sept’15 – Till Date Team Size : 2 Technology : Tibco middleware, REST Service, Main Frame Tools Used : ALM,UFT, Blue Zone, DB2, Oracle, Tibco Active Space, Topic & Queue , Tortoise SVN, JIRA Testing Type : UFT Automation, Database Validation, Tibco Topic message validation Description : Smartpush applies rules at different levels like Store level, Department Level, Vendor Level, Location Level, Product Level etc. To get a quick response from Legacy system(AS400) replica of all DB2 table has been created in Oracle Server as well and it is controlled by Golden Gate Technology. Now whenever there is any changes in Legacy System or in DB2 table then the same will be reflected immediately in corresponding Oracle table. From Oracle table data will be updated to first level and second level Tibco active spaces. Then messages will be generated at Tibco Topic subscribers and same can be consumed by different business components and General Availability Space which update the Website. Similarly any site level operation will be updated first at Oracle then it will update DB2 Table and spaces as well. Roles & Responsibilities Analysis of manual test cases and scenarios based on JIRA story and provide estimation for automation effort Set up of UFT Automation Framework in which integrate different components like Oracle, DB2, Mainframe (Blue Zone), Rest Services for Tibco Active spaces, Excel DB Developing automation scrip in UFT for each JIRA story assigned for sprint Dry run and analysis the execution report, gap analysis with Manual Test Lead and update the code accordingly After final run upload the execution report into corresponding JIRA story and change status as resolved, commit the code and test data in SVN repository and assigned the same to client for UAT Run the entire regression suit through ALM Actively participated in daily status call Project#2: CCM – Fails Management Client : Credit Suisse UK (Banking & Financial Services) Duration : Jan’15 – Aug’ 15 Team Size : 5 Technology : Sybase & Oracle Server, SOAP Service, .Net Application Tools Used : ALM,SOAPUI, Rapid SQL, Test Harness and Paystation Testing Type : SOA Testing, SIT Testing and Database Validation Description : Fail Processing model provide a framework to match internal settlement shape against external settlement advice and manage the subsequent workflow, including the management of unconfirmed settlement fail from the settlement system.The changes required within the caps settlement system & Paystation GUI in order to allow the reporting of the validate settlement status ,the necessary fields in order to resolve identified breaks & enable the management of fails are detailed from a functional perspective within this document. Roles & Responsibilities Analysis of BRD, FRD, TSD and provide estimation Preparing web service test suit using Xpath, validating the request and response in SOAPUI and same in database table and in GUI Actively participated in defect triage call Regularly interacted and followed up with the development Team to discuss the discrepancies identified Project#3: OnRam e-Brokerage service Client : Wells Fargo & Company (Banking & Financial Services) Duration : Oct’14 – Dec’14 Team Size : 2 Technology : Oracle SOA Suit, Oracle 11g Data Base Server Tools Used : SOA Admin Console, SOAPUI, SQL Developer, ALM and Wisdom Testing Type : Web Service Testing and Database validation Description : OnRam e-Brokerage service is developed to provide different mutual funds and model to its existing customer and new customer as well for investment. Set of Security Question and answer, Investment Goal and liquidity question will be given to the customer. Once customer save all the answer a risk score will be calculated and based upon this score customer can purchase the relevant fund and model recommended. Roles & Responsibilities Analysis of BRD, FRD, TSD and Preparing Test Plan Preparing web service test cases with database validation steps Executing test cases in ALM, validating the request response in SOA admin console and in database table update Defect logging, tracking and management in ALM and participated in Daily Status Call on the same Project#4: Aurora Online Auction and Seller Service Client : Copart (Retail) Duration : May’13 – Sept’14 Team Size : 4 Technology : Rest Service using JSON, Auction Server, Legacy and Mobile Apps Tools Used : SOAPUI Pro, JIRA, Rest Service Automation Framework and CRAFT Selenium Framework Testing Type : REST Service Testing and Selenium Automation Testing Description : Copart, Inc., headquartered in Dallas, Texas, is a provider of online vehicle auction and remarketing services in the United States, Canada and United Kingdom. Copart Auction System (CAS) was designed on AS400 to unify and support the growing business as well as allow Copart facilities and sellers to access information, generate reports, and increase operating efficiencies. To advance Copart Application on newly launched devices and technologies REST service is implemented to connect legacy system (CAS), Mobile apps, C2 Seller/Member Web and Aurora Web application. Rest services are published for different business modules for Seller Mobile WS project. Roles & Responsibilities Analysis of FSD and Functional Test Cases Create reusable function for each business module Preparing test data as per test suit, test cases, module, keyword, locator Develop and execute selenium automation test script in CRAFT frame work Developed Test cases for REST services (for UK 20 and for US 24) in SAFE++ REST Automation Framework Defect logging, tracking and management in JIRA Reproduce defects in I-phone and I-Pad of Aurora Mobile Apps developed for Online Auction Creating Test Summary Report Introducing and developing project specific tools for effort saving, Coordinating knowledge sharing sessions within the team Actively participated in weekly meetings about the progress of the project and monthly audit Project#5: AAAS – DPP Implementation Client : American Association for the Advancement of Science (Media & Entertainment) Duration : July’12 – Apr’13 Team Size : 5 Technology : Content Management System and J2EE Application Tools Used : Documentum, Marklogic, Artesia, Selenium Webdriver and JIRA Testing Type : Automation Testing Description : To develop an end to end solution for the client’s publishing requirements. This publication platform would be consists of models for web-based Submission Site for manuscript submission, Editorial Workflow (including art editing) and content management (using Documentum), Content Repository Management (using Marklogic and OTMM), Publication Management, People DB and roles –permission policy management, historical content management. Ingestion process Automates the ingestion of all individual historic content and assets as well as generated publications and associated metadata of the content and assets and tagging of the assets into Artesia. All textual content (Base XML, RDF files) to be archived in Marklogic and proper linkage between base XML and article and associated assets of the article are maintained by Ingestion Automation Process. Roles & Responsibilities Preparing Automation Test script and Functions in CRAFT Framework Preparing test data as per test suit, test cases, module, keyword, locator Performed Build Verification Testing, Regression Testing Defect logging, tracking and management in JIRA Actively participated in documentation reviews and defect triage meetings and execution report Project#6: Mortgage Banking Service Integration (MBSI) Client : JPMorgan & Chase (Banking & Financial Services) Duration : Apr’12 – Jun’12 Team Size : 3 Technology : SOAP Service, Oracle Server, Mainframe Tools Used : ALM, LPS Director, SOAPUI Pro, SQL Developer and Agent Desktop Testing Type : Web Service Testing Description : Mortgage Banking Service Integration (MBSI) is aimed to facilitate different applications to insert, update and read data from MSP and other data bases including third party vendors. MBSI service includes some operation which retrieves a wide variety of ARM data, including: Original Information, Convertible Controls, Interest Rate and PI Change Date and Calculation Controls, Payment Rate Calculation Controls. Also provides the capability for clients to view comments from multiple host system workstations, details for the last three monthly or quarterly bills generated for a Loan and a recap of the data for each billing statement as well. By using MBSI services user can get information of second lien holder on a loan, profile data for the borrower, co-borrower, additional borrowers, original borrower or obligors, optional product information for one or more policies, MERS information, current and pending payment change information, Military Service Relief information for a specified loan. Roles & Responsibilities Preparing test scenarios,test cases and RTM pertaining to the business requirements Preparing SOA Test Suit using various Xpath & Contain assertions for each services Submit request for services in servers and validating corresponding responses Uploading the executed test cases along with request and responses into ALM for tracking purpose Defect logging and verifying defect fixes in ALM Project#7: Making Home Affordable Program (MHA) Client : JPMorgan & Chase (Banking & Financial Services) Duration : Dec’10 – Mar’12 Team Size : 44 Technology : J2EE Application, Oracle Server, Mainframe and Lender Live Tools Used : QC 10.0, SQL developer, Agent Desktop and LPS Director Testing Type : SIT Testing and Functional Testing Description : To avoid losses due to sub-prime economic crisis in-, banks have come up with different loan modification plans for defaulted loans. These loan modifications gave an opportunity to the borrowers to repay the loan. These loan modification leads to generation of number of letters and docs which are to be sent to the borrower. MSP is a centralized repository (Database of US treasury) which has the detail about all loans. Bank can track the payment date, history of loan etc. through MSP. The loans in MSP which have defaulted are recognized and added to the Agent Desktop Application.MSP is also used for Generating and Viewing letters. Agent Desktop is the core underwriting application for various chase mortgage loan modification products. This tool determines whether a borrower qualifies for a loan modification according to HAMP or CHAMP model. It also supports various other models such as PRA, OA, FNMA, MOD24 and FNMA BAU. Agent desktop implements the rule and processes as per treasury's Mandate. Lender Live is an Imaging system, which prints the hard copy of the document. Lender Live receives the data in XML format and turns them to PDF Format and prints the hard copy and mails them to the borrower. Roles & Responsibilities Analyzing requirement document, functional specification document and Technical specification document Test Case Design, Test Data Preparation and cconditioning Loan to different newly introduced plans Uploading the test cases into QC and executing them Defect logging and verifying defect fixes Introducing and developing project specific tools for effort saving and doing POC of various efforts saving tool Mentoring the team members Coordinating knowledge sharing sessions within the team Actively participated in Client Status call Project#8: Family Dollar GM POS QA Client : Family Dollar Stores (Retail) Duration : Jul’10 – Nov’10 Team Size : 7 Technology : GM POS Tools Used : Bugzilla and GM POS Store Testing Type : System Testing & Card Testing Description : Family dollar is based out of Charlotte, North Carolina, USA. Family Dollar Stores offer true value to customers by offering a core assortment of name-brand and quality consumable merchandise supplemented by fashion and seasonal merchandise at everyday low price in a convenient, self-service shopping environment. Most merchandise is priced under $10.00.Some of the stores is running on GM POS System. Steadily GM POS count will grow on with a target of replacing all Legacy POS with GM POS in due course of time. Roles & Responsibilities Test Environment set up as Re-imaging of Stores dedicated for retail POS testing at Offshore Test Script Execution for different Card Transaction & Defect Reporting and Tracking through Bugzilla Project#9: WHG QA – CapEx Enhancement Client : Wyndham Hotel Group (Retail) Duration : Nov’09 – June’10 Team Size : 22 Technology : Oracle server, Sales Force and J2EE Application Tools Used : QC and Toad Testing Type : System Testing, SIT Testing and Web Application Testing Description : Wyndham Rewards is the international operating Loyalty Program (largest lodging in the world) of the Wyndham Hotel Group (WHG). The earned points are to be redeemed for free-night stays in hotel or resorts. Other redemptions include Car Rentals, Gift Certificates and Charitable Donations. A multi-language online system allows members to interact and redeem for rewards in exchange of their earned loyalty. Roles & Responsibilities Requirement Analysis,Test Cases Design, Execution & Defect Reporting and Tracking through Quality Center Involved in Web Application Testing, Database Validation and Knowledge Management Personal Profile Father's Name : Mr. Lakshmikanta Mondal Sex / Marital Status : Male / Single Nationality : Indian Languages Known : English, Hindi and Bengali Address for Correspondence / Permanent Address: Maruthi PG, Roopena Agrahara, Bommanahalli Bangalore, Karnataka, India Pin: 560068 Personal Objective: Looking for an exciting opportunity where my knowledge and dynamic character will contribute positively to the growth of my employer and help me to grow professionally at the same time. I do hereby declare that all the information mentioned above are true, correct and complete to the best of my knowledge and belief. Siddhartha Mondal Date: 20-Aug-16, Place: Bangalore