16+ years of experience in IT industry, working with fortune 500 company & clients.
Expertise in Data Management, Functional, Regression, Database testing and data sanity testing
Expertise in complete Software Development Life Cycle and various testing life cycle roles including Analysis, Test Planning, Test Execution, Defect tracking and Reviews.
Implemented and adhered to processes leading to enhanced quality of deliverables
Bachelor of Engineering in Computers from Goa University, completed in 2007.
Database
Microsoft SQL Server
Methodologies
SDLC, STLC, Agile, Scrum
Language
SQL
Operating Systems
Windows, Unix
Defect Tracking Tool
Team Foundation Server , Test Manager, HP ALM,JIRA
ETL Tool
AutoSys
Data Tool
EBX MDM Tool
Project
Citi Corp
Team Size
7
Role
Team Lead
Environment: Oracle, AutoSysJan 2018 – Till Date Description:
ORM RDMT is a reference Data management tool of Citi. It has different map categories which are different business requirements. Details of specific requirements are categorized as one map and its specifications under that map. Changes incorporated should be pushed to downstream so as to synchronize downstream systems. User should be able to discard changes done to maps.
Responsibilities:
Data Management and creating data for the downstream systems to analyze.
Execute the AutoSys jobs and monitor the jobs and data validation in target systems.
Play an active part in the requirement and work with the stakeholders in order to understand the requirements and suggest the challenges in implementation.
Guiding the team members with the tasks and work with them closely.
Testing Map categories by doing various type of changes to Map categories i.e. Edit, Add, Delete.
Check whether data created is in sync with downstream and verify whether data is matching with Database.
Work closely with the BA in understanding the requirement so as to be able to prepare
Project
CLSA Capital Markets
Team Size
20
Role
Team Lead
Environment: Oracle,Cobra,Viper,Python,SynJune 2017 – Nov 2017 Description: Equities trading - Single Stocks, PT, DMA/DSA - Cash Equities & Derivatives
; market connectivity, Order Management Systems , Execution MGT systems.
Downstream Settlement systems (SYN) allocation, Blocks per netting rules, Client confirmations.
SDLC, Test Strategy/Plan, Agile Development Methodology, Bug Tracking & RCA.
Responsibilities:
Ensures that all aspects of testing are completed.
Log and review issues and defects identified by testers.
Project
Allianz_Fraud Analytics
Team Size
5
Role
Team Lead
Environment: Oracle, HP ALM, SASJan 2016 – June 2017
Description: Globi Data Ware house is a project which provides standard and reusable Business Intelligence globally. This also offers end to end products as integrated service by providing shared services using SAS tools and solutions. It involves extracting data from heterogeneous source systems (.zip to .csv files), transform it as per business requirements and finally loading data into DWH/DM. In here, the extraction of data from the Data Warehouse is done by extracting all valid records for a selected period of time from a selected OE table by table. Once the extraction is done, the data will land into a temporary Staging Data Mart.Finally data from DWH/DM is used to generate reports for the business analysis and applications like SAS Fraud Framework For Insurance.
Responsibilities:
Being Lead, oversee all activities for all assigned applications by requirement analysis.
Ensures that all aspects of testing are completed.
Log and review issues and defects identified by testers.
Allocate and manage team member’s task.
Project
Morgan Stanley CorpTech
Finance_Libra
Team Size
6
Role
Team Lead
Environment: DB2, Unix, HP ALM, InformaticaApril 2015 – December 2015
Description: Libra is the books and records for the Institutional Securities business of Morgan Stanley. It processes more than 6-8 million journals on a typical day
Responsibilities:
Being Lead, oversee all activities for all assigned applications by requirement analysis.
Analyzing user stories, decide on acceptance criteria’s, and providing/escalating on testing approvals.
Design test process including required test activities and deliverables.
Ensures that all aspects of testing are completed.
Log and review issues and defects identified by testers.
Create Test Completion Report and provide sign off.
Allocate and manage team member’s task.
Project
CybageMIS_ReportBuilder
Team Size
20
Role
S/W Tester
Environment: SQL Server 2008, IE8, SharePoint, Test Manager
Description: The project is associated to automate processes/activities in Cybage. It deals with real time needs of various departments. The basic objective are
Implementing new as well as Integration / Updating / Replacement of existing applications running under different departments.
Bridging the functional gap within the department and cross department.
Centralization of Master information.
Responsibilities:
Being Lead, oversee all activities for all assigned applications by requirement analysis.
Analyzing user stories, decide on acceptance criteria’s, and providing/escalating on testing approvals.
Works with project team to define and create overall strategy and ensure the completion.
Communicate the test strategy to the Project Manager and Development Team.
Design test process including required test activities and deliverables.
Estimates test effort and define test schedule and milestones.
Conduct walk-through, review, modify and approve test cases.
Ensures that all aspects of testing are completed.
Log and review issues and defects identified by testers.
Create Test Completion Report and provide sign off.
Allocate and manage team member’s task.
Project
Digital River Inc, USA/Global Tech
Team Size
8
Role
S/W Tester
Environment: SQL Server 2005, SharePoint, Test Manager
Description: Digital River is a U.S. e-commerce outsourcing company. The company’s platform offers site development and hosting, order management, fraud management, export controls, tax management, physical and digital product fulfillment, multi-lingual customer service, reporting and strategic marketing services.
Responsibilities:
Write test cases for functional, database integration & regression testing of the application.
Create test data based on the test cases and execute it using sample test data.
Exhaustive integration and regression testing for all the modules of the application
Beta testing of the product and monitor it on production after the release.
Documentation of test analysis for future reference.
Prioritizing and tracking Issues, Defects for closure and maintaining records for the same.
Active participation in daily defect meeting and report on testing progress.
Mentored a team on two major tasks of project.
Project
BMC Recovery Manager for Databases
Team Size
6
Role
Graduate Trainee
Environment: Windows, SQL Server, Oracle
Description: BMC Recovery Manager simplifies and automates database backup and recovery tasks across the enterprise. It allows you to plan, automate, monitor, and document your backup and recovery processes to ensure data integrity.
Responsibilities:
Solving issues related to BMC Recovery Manager which deals with Sybase and Oracle.
Perform backup and recovery tasks through menu, command line or script.
To check the connectivity of our product with its client through OBSI namely TSM & Netbackup in case of third party storage manager.
Helping customer in backing up and recovering the database.
Date of Birth: 23rd July, 1986
Marital Status: Married
Languages Known: English, Hindi, Marathi, Konkani
Passport No.: S-
Visa Status: H1B Ready
Email:-Phone: -