Gaurav k gupta sr.test consultant

Please download to get full document.

View again

of 6
30 views
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.

Download

Document Related
Document Description
1. Gaurav Kumar Gupta Om.gaurav@gmail.com Mobile: +9-9911357398 Sr. Test Consultant PROFESSIONAL SUMMARY  10+ years of IT experience in Manual and Automation Software…
Document Share
Document Transcript
  • 1. Gaurav Kumar Gupta Om.gaurav@gmail.com Mobile: +9-9911357398 Sr. Test Consultant PROFESSIONAL SUMMARY  10+ years of IT experience in Manual and Automation Software Testing and Quality Assurance in BFSI Domain (Core Banking - Finance - Swift Payments - Investment), currently working in SAXO Bank – IT INDIA  Experienced in Test Lead & Sr. Test Consultant Roles for MSCRM, Trading Applications (FO, BO) and DWH (Data Ware House) and BI (Business Intelligence), ETL Projects.  Certifications: ISTQB, CUES (Credit Union Executives Society), PCIDSS.  Good Exposure to implement automation testing with QTP, Selenium, SOAPUI.  Experienced in driving the UAT at overseas client location Saxo Bank A/S, Copenhagen, Denmark.  Proven experience in Test Management, Test Sprint planning, Resource Planning, negotiations with the client for SLAs, project progress monitoring and delivery as per defined norms.  Possess strong communication, leadership and relationship management skills. Excellent team player with good interpersonal and problem-solving skills.  Domains expertise- BFSI (Capital market / Investment banking).  Proficient in Requirements Gathering & analysis, Use-case development, Testing & supporting UAT teams.  Excellent implementation knowledge in SDLC, Testing Levels, Bug Life Cycle & Testing Life Cycle.  Extensive experience in Black Box Testing of Client/Server & complex n-tier Web Applications with complex Architected with multiple databases, Web servers, App Servers in clustered environment.  Expertise in Integration testing of complex Banking systems (SOA, Web service, Batch programs, Message bus, BizTalk, Swift Gateway, API automation using visual studio, web service automation using SOAP UI)  Highly skilled in Functional Testing, Integration Testing, System testing, User Interface Testing, Regression Testing as well as defect and test environment management, planning walkthroughs and reviews.  Thorough understanding of (manual / automated) Testing Procedures, Test Estimation, Test Planning, Risk Identification, QA activities and CMMI processes.  Strong in Analyzing Business specs, Test Scripts and Test Case execution. Experienced in Defect management & Reporting using various bug-tracking tools.  Expertise in conducting Internal Audits to ensure the Development/Support activities compliance with organization’s Quality Management System (QMS) 1
  • 2. NOTEWORTHY MILESTONES  Focused in performing weekly and monthly client reporting and prepared various metrics to ensure that projects were progressing as planned and were within the approved time and budget.  Have experience in handling testing projects right from the requirements phase till completion.  Involved in developing Best Practices with experience and effectively implemented them with the Team  Won client rewards and appreciations in all my projects for handling the testing activities efficiently.  Active member of Training, Interview and Cultural event teams in the Organization. W o r k E x p e r i e n c e • SAXO Bank – IT INDIA Gurgaon, as Sr. Test Consultant - Since May 2 2011 to till date. • TCS - TATA Consultancy Services Delhi, as IT Analyst - since Nov 10 2010 to April 25 2011. • Fiserv Global Services (Fortune 500 Company) Noida, as Senior Test Engineer- since Jan 15 2007 to Nov 2010 (Awarded VIP – 3 times and Shining Star ) • Cosmic Softech Pvt. Ltd, New Delhi as Software Testing Engineer - since October 04 2004 to Jan 05 2007. T e c h n i c a l s k i l l s Operating system : MS-DOS, W indows 98, 2000 Prof, XP, W in 2000 Server Languages : C, C++, C#.NET, HTML, VB Script, JAVA-SCRIPT Databases : MS SQL Server 2014 (SSMS, SSIS, SSAS, SSRS) Automation Testing Tool : Quick Test Professional (QTP 10), SoapUI Test Management Tool : HP Quality Center 10, MS Test Manager, TFS Enterprise computing : M.S. OFFICE Configuration Management : VSS, TFS W eb Technologies : VSTS 2012, ASP, ASP.Net (I.I.S.), W eb Services Third Party Tools : INFRAGISTICS, CRYSTAL REPORT, MS VISIO, MIND MAP, Smart inspect, P r o f e s s i o n a l q u a l i f i c a t i o n • Master Degree in Computer Application ( M.C.A. ) From Punjab Technical University with First Division • Bachelor Degree in Computer Application ( B.C.A. ) From Makhanlal Chaturvedi University Bhopal with First Division in 2004 P r o j e c t s 1. Company: SAXO Bank – IT INDIA Oct 14 – Till date Projects SAXO DWH (Data Ware House) and BI (Business Intelligence) Client: SAXO Bank, Copenhagen DK T e c h n o lo gi e s us ed : M S B I - M S S Q L S e rv e r , S S I S , S S A S , S S R S , M D S , Po w e r P ivo t , Po w e r Vi e w , Actim i z e for A ML , Su mm a r y : Saxo Ware House & Business Intelligence is developed to keep bank critical data preserve and analysis is performed on same to provide intelligence to business using Different tools like SSRS, CUBE, Power Pivot, Power View, 2
  • 3. Actimize (for AML and market data abuse). R e s p o n s i b i li ti e s : Working as Sr . L e a d Co n su l t a n t for Planned Sprint Features. It include F u n ct i on a l , int e g r a t i o n a nd e nd to en d T e s t , Es ti m a t i o n , Pl a n n i n g an d ex e c u t i o n for E T L , R e p o rt i n g , C U B E , D a t a So u rcin g a n d D a t a An a l yt ic s t as k Company: SAXO Bank – IT INDIA May 11 – Oct 14 Projects Saxo Group Engine, Cash Commander Physical Delivery of payments using Swift Saxo Privat Bank Integration Client: SAXO Bank, Copenhagen DK T e c h n o lo gi e s us ed : C#.net, MS SQL, TFS, SharePoint, M S Test Manager, BizTalk (message Queue / Message Buss), MindMap Smart Inspect, S O A P U I , WCF test tool, Selenium Web Driver. Su mm a r y : System used by Front Office & Back Office Operations of SAXO Bank (Leading Danish Investment Bank provide Forex Trading ) to create/manage clients & accounts which in turn creates them on various other Front Office and Back Office systems(like MSCRM, Cash Funding application, SWIFT Gateway, Web, Window and mobile trading systems) integrated with BizTalk Server R e s p o n s i b i li ti e s : Team Leading, Client handling, Business requirement gathering form Business Owner/architects, System and Integration Test Planning and Test design for testing of Enterprise Message Buss Model, for Saxo group Engine Program which include Front Office, Back Office projects (MS CRM, Saxo Trader, Cash Commander, UCR, and DWH). Implementation for automation for API test and web Test. 2. Company: TATA Consultancy Services Nov 10 – April 11 Client: Royal Bank of Scotland T e c h n o lo gi e s us ed : Visual Studio .Net, SQL Server 2000, HP Quality Center and QTP 9.2 for Testing R e s p o n s i b i li ti e s : Team Leading, Client handling, Project Test Estimation & Planning, Reviewing Activity, Team Query/Issue Resolution, Project Risk Analysis, Status Reporting Customization of the Keyword driven framework - Driver, Controller and Utility Scripts as per the Application. Use descriptive programming for script writing. Writing Test Cases, Test scripts and functions wherever necessary for various modules Peer Review of the scripts and Test Cases Stored the scripts and function into VSS for maintaining the version control. Used excel file for reporting the results with timestamp. 3. CUBE (Credit Union Banking Environment) Jan 07 – Nov 10 Company: Fiserv Global Services Client: Integrasys Cube, Lake Mary, FL, US T e c h n o lo gi e s us ed : Visual Studio .Net, ASP.Net, VB.Net, SQL Server 2000, XML, CRYSTAL REPORT, INFRAGISTICS controls, HP Quality Center and QTP 9.2 for Testing R e s p o n s i b i li ti e s : Understanding Business and Functional Requirement Test Estimation using estimation techniques Creation of Integration Test Plan (FIT, SIT) and Scenarios Attending WPR Sessions and preparation of WPR and MOM Documents Designing and Documentation Test cases in Quality Center Functional testing, System testing, Security and license testing, Integration Testing, Regression testing, Load testing, Database Testing, Acceptance testing Report the test execution status by including the key data points Product Knowledge Transfer to new team members. The CUBE (Credit Union Banking Environment) product includes all components required for Bank’s basic operations, including Teller and member service processing, loan, mortgage, collections, collateral, Task Navigator, Assignment Tracking, Collections profile and Legal, HSA (Health savings Account), Card services, Vision Plus application integration, GLWisdom, Credit Card, IAT ACH (Automatic Clearing Houses) Processing-, Cross Sell, PCI DSS (Payment Card Industry Data Security Standard) Licensing Module, MSR Purge, Asset Income & Employment Risk, SSC Transaction activities (Shared Service Center) and other member account activities. 3
  • 4. Below are some further enhancement projects done under CUBE Product Cross Sell and Sales Tracking Project Overview: This project is designed as an enhancement for CUBE (Credit Union Banking Environment) which has an old version designed in Probe and newer one transformed in .Net. The objective of this enhancement is to create an updated .NET interface for Cross Sell and Sales Tracking Alert, Opportunities and History. o Enhanced, redesigned components featuring easier navigation. o Ability to view opportunities, take action and add notes all from a single screen for the Opportunities and History screen. o Comparison of Trade lines and CUBE opportunities now automatically calculates the savings and provides a view of multiple trade lines at once. o Employee Assignment and Incentive capability. o Eliminates the need for CUBE Classic client to be running. o Ability to toggle between the Alert and History views of the dialog. GL Wisdom Project Overview: The intent of this project is to provide migration of the CUBE General Ledger application to the W isdom General Ledger application. This project will eliminate the core CUBE General Ledger application. However, the core CUBE General Ledger application will be retained for a period of time in order to provide users time to make the transition to the W isdom General Ledger application. In addition, the system will still maintain the functionality required to support clients that subscribe to a third party general ledger application other than W isdom. The GL (General Ledger) uses a flexible Chart of Accounts, from 3 to 12 digits. Posting to the GL is through batch entry which can contain an unlimited number of entries and provides online validation of a balanced posting prior to submission. An unlimited number of Financial Statements can be created and generated using user-defined reporting criteria. Cost center reporting is supported and provides allocation of income and/or expenses based on a dollar amount, a percentage or user-defined ratios. The allocation process can spread the balance of a single GL account across many branches or cost centers as desired without the need for specific GL accounts for each center. Collection Legal Project Overview: The Collection Legal project creates a user interface to support the retention of legal information related to a membership record. In CUBE Classic, the legal information consists of attorney, bankruptcy, foreclosure, and expense information. The ability to print documents and support defined user fields with each record is also available. Users will have the ability to add, view, and update each type of record from the Member Home or Collections tabs. IAT ENTRY CLASS FOR ACH Project Overview : Effective September 18, 2009, an amendment to the NACHA Operating Rules will become effective that will require CUBE to handle all international payment transactions transmitted via the ACH Network as International ACH Transactions using a new Standard Entry Class Code of IAT. The IAT standard entry class code will replace the CBR (Corporate Cross Border) and (PBR) (Personal Cross Border) standard entry class codes. There will no longer be a distinction between business and personal ACH for international ACH IAT is the largest single change in ACH in many years and requires credit unions to perform OFAC checking on individual ACH item in order to meet OFAC requirements. In support of IAT ACH items, almost every aspect of ACH processing will change to some extent. 4
  • 5. 4. STAR (Sales Tracking Analysis and reporting) 5. Sales Force Automation (SFA) Company: Cosmic Softech Pvt. Ltd. Client: Bikaner Foods. Ltd., & SAR Silicon Private limited Team Size : 4 T e c h n o lo gi e s us ed : Visual Studio .Net, ASP.Net, C#, SQL Server 2000, PL/SQL, JavaScript, Crystal Report 9 The project was designed to track the Companies sales at secondary (Distributor) and tertiary (Dealer) levels, to maintain a record of companies Promotional and Marketing Activities, to keep track of daily field work accomplished by the employees, assigning targets to Sales Persons and tracking their corresponding achievements, to manage targets for distributors and employees and also to produce various general and comparison reports. The project is based on seven modules i.e. Admin module, Sales process (secondary & tertiary sales), Sales force, Tour plan, Sales forecasting, Marketing & promotion budget approval, MIS Reports, on the base of role & rights these modules are Available for the users. R e s p o n s i b i li ti e s : Functional Testing, System Testing, Regression Testing, GUI Testing, Bug Reporting 6. NSIC Enterprise Management System Company: Cosmic Softech Pvt. Ltd. Client: National small Industries Corporation Ltd (NSIC) National small Industries Corporation Ltd (NSIC), an ISO 9001:2000 certified company, since its establishment in 1955, has been working to fulfill its mission of promoting, aiding and fostering the growth of small scale industries and industry-related small scale services/business enterprises in the country. This Project is a whole enterprise management System, which will work on 38 branch and Head office. The main motive of developing this application to provide a system which will be able to give synchronised data of different offices and make fast communication between different offices and Head office. Each office will have its own local database and there will be a centralized database system. The system will be responsible to synchronized data at head office on defined scheduled interval. Modules of this application are:HR, SysAdmin , Payroll, Loan, Finance R e s p o n s i b i li ti e s : • Developing a W eb Service to Consolidate data from all the branches to the head office and Sending Master data from Head Office to all branches and a utility to perform • Developing widows based application to perform scheduled transfer of data to and from HO using web service 18 members are involved in the development of this project on W idows 2000 using ASP.Net, C#.Net, JavaScript, SQL Server 2000, Microsoft W ord and Excel. P e r s o n a l I n f o r m a t i o n Date of birth : 9 august 1985 Father's Name : Shri. S.K. Gupta Languages Known : English, Hindi. Nationality : Indian Sex : Male Personal strength : I learn the things very quickly, and my strong functional & Technical skills 5
  • 6. 4. STAR (Sales Tracking Analysis and reporting) 5. Sales Force Automation (SFA) Company: Cosmic Softech Pvt. Ltd. Client: Bikaner Foods. Ltd., & SAR Silicon Private limited Team Size : 4 T e c h n o lo gi e s us ed : Visual Studio .Net, ASP.Net, C#, SQL Server 2000, PL/SQL, JavaScript, Crystal Report 9 The project was designed to track the Companies sales at secondary (Distributor) and tertiary (Dealer) levels, to maintain a record of companies Promotional and Marketing Activities, to keep track of daily field work accomplished by the employees, assigning targets to Sales Persons and tracking their corresponding achievements, to manage targets for distributors and employees and also to produce various general and comparison reports. The project is based on seven modules i.e. Admin module, Sales process (secondary & tertiary sales), Sales force, Tour plan, Sales forecasting, Marketing & promotion budget approval, MIS Reports, on the base of role & rights these modules are Available for the users. R e s p o n s i b i li ti e s : Functional Testing, System Testing, Regression Testing, GUI Testing, Bug Reporting 6. NSIC Enterprise Management System Company: Cosmic Softech Pvt. Ltd. Client: National small Industries Corporation Ltd (NSIC) National small Industries Corporation Ltd (NSIC), an ISO 9001:2000 certified company, since its establishment in 1955, has been working to fulfill its mission of promoting, aiding and fostering the growth of small scale industries and industry-related small scale services/business enterprises in the country. This Project is a whole enterprise management System, which will work on 38 branch and Head office. The main motive of developing this application to provide a system which will be able to give synchronised data of different offices and make fast communication between different offices and Head office. Each office will have its own local database and there will be a centralized database system. The system will be responsible to synchronized data at head office on defined scheduled interval. Modules of this application are:HR, SysAdmin , Payroll, Loan, Finance R e s p o n s i b i li ti e s : • Developing a W eb Service to Consolidate data from all the branches to the head office and Sending Master data from Head Office to all branches and a utility to perform • Developing widows based application to perform scheduled transfer of data to and from HO using web service 18 members are involved in the development of this project on W idows 2000 using ASP.Net, C#.Net, JavaScript, SQL Server 2000, Microsoft W ord and Excel. P e r s o n a l I n f o r m a t i o n Date of birth : 9 august 1985 Father's Name : Shri. S.K. Gupta Languages Known : English, Hindi. Nationality : Indian Sex : Male Personal strength : I learn the things very quickly, and my strong functional & Technical skills 5
  • Search Related
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks
    SAVE OUR EARTH

    We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

    More details...

    Sign Now!

    We are very appreciated for your Prompt Action!

    x