Rajesh Purushan

 RAJESH PURUSHAN - Bhandup West (Mumbai), Maharashtra - 400078 - PROFILE SUMMARY An experienced Test Consultant with eighteen+ years of testing experience across a wide range of sectors particularly Banking, Finance , Insurance, Manufacturing , Healthcare , Utilities, Broadcasting , Telecom and worked with major clients like HMRC, Nationwide, BT, BSKYB, Lloyds Pharmacy, John Lewis, Harvey Nichols, Centrica, UBS, Credit Suisse , Citigroup, Tata AIG , Novartis and Agilent. Proven experience as a Senior Test Engineer/Test Lead/Test Manager across the entire testing spectrum including Functional Testing (Manual and Automated), System Integration Testing(SIT),Exploratory Testing, E2E Testing, User Acceptance Testing(UAT), Load & Performance Testing (NFT) , Failover Testing (NFT) and Operational Acceptance Testing (OAT). Experience working on Cyber Security-related projects within a large-scale environment/organization and advanced understanding of Cyber Security Experience in Load Runner based performance testing for Volume, Load, Spike and Stress Testing Experience using HP ALM , Microsoft MTM, Zephyr , JIRA , TFS, Test Rail for test management and bug tracking. Experience on multiple platforms such as Client/Server, Multi-tier, Web/E-commerce, Acqueon LCM, CMS (Wordpress, Wiki, Magento) , BI/ Data warehousing, Teradata, Pentaho, Cognos, ERP( Oracle ESB, Oracle HRMS, Kronos, Procurement) , Unix, Databases (Oracle, DB2,Mysql, SQL). Experienced in managing projects in Agile, AWS, Scrum/Kanban, SOA, TDD/BDD, TFS, JS, XML, XSD, JSON, Web services, REST/ SOAP UI, Spec flow Iterative/ Incremental , V Model and Waterfall development/testing models. Demonstrable experience of contributing to improving Test methodologies, processes & technology, practical experience of agile methodologies, tools and test automation Advanced understanding of the principles of software testing and strong problem solving, presentation & communication skills Co-ordinated and managed distributed test teams globally based offshore and onshore resources. Self motivated individual with good organizational and communication skills. DOMAIN / COMPUTER SKILLS DOMAIN : FX, Spots, Interest Rate Swaps, FX Options, Rates, Credit, Securitized products, Commodities,Front Office Equities, OTC Derivatives, Credit Risk , P&L, Cash Equities, Wealth Management, Retail and Business Banking, Fund Accounting ,Corporate Actions, Insurance (Life and Pensions, Claims), IRS ( Interest Rate Swaps) , Wealth Management , Asset and Fund Management, GLOSS, Cash products DATABASE : Oracle 10g, MS Access, MySQl, SQL Server 2005/2008, SQL DB, TOAD TEST AUTOMATION: Java,Javascript XML, XSD, .Net, SAP(CRM),HP QTP 11.0, HP Load Runner 11.0. TOOLS : Algorithmic/Portfolio trading systems and FIX protocol, Equity DMA/ STP, Markitwire, Smartstream CMS , JIRA, Confluence, Unix, VSS, Clear case , Zephyr , Cognos 8,Informatica, Pentaho Integration, ETL,Teradata, Data Manager ,BI, Cloudera Manager, Hive, Hue, Impala ,Hadoop/HDFS, Sharepoint , Git Lab,TFS, Gherkin, Specflow, Cucumber ,Github, Scala, Spark, SOAP UI, Oracle ESB, Oracle HRMS ,Kronos, Visual Studio, API, OSS,Corporate Actions, Reinsurance, Dynamics AX 2012, SWIFT, Interest Rate Swaps, Swap Clear, Acqueon List & Campaign Manager,AWS(Amazon Web Services), RDS, Redshift, S3, Data migration, Data Modelling EDUCATIONAL QUALIFICATIONS University Degree in Science – Mumbai University – Year 2001 PROJECT EXPERIENCE HM Revenue & Customs (HMRC) Test Lead Jan‘19 to Nov’19 Technology: Business Object Data Services (BODS), Pentaho Integration (PDI) 11.0, Linux, Oracle, HDFS, Jira, AWS(Amazon Web Services), RDS, Redshift, S3, Data Migration, Data Modelling Key Responsibilities: Analyzing functional and non-functional requirements , doing business analysis for EU Exit Border contingency project , defining entry and exit criteria. Taking lead role in Project Planning, Create Test Plan for each projects, forward to PM and BA team for approvals Creation of Test plan and Sprint Test Report for the test reporting for each sprint Experience in testing ETL’s within the Enterprise Data Hub and data modelling Knowledge of HDFS and Advanced version control using Git (branching/merging models, submodules, tagging, bitbucket and gitlab interface features) for data migration Test Reporting and Stake holder management Support End to End testing for data migration and manage test data requirements HM Revenue & Customs (HMRC) Test Lead May‘18 to Nov ‘18 Technology: Pentaho Integration (PDI) 11.0, Linux, Oracle, Mysql, Hive, Hue, HDFS, Cloudera Manager, Impala, Gitlab, Jira Key Responsibilities: Creation of functional test scenarios, test data for each story and maintaining the test data on GitLab Manage test/ requirements documenation in Confluence and defect management on JIRA Creation of Test plan and Sprint Test Report for the test reporting for each sprint Creating XML files and reading XSD schemas and validating xml files against them. Usage of advanced text editors like Notepad++, sublime and vim Reading and writing command line interfaces (bash) Writing SQL queries and usage of generic SQL clients (DBeaver) Knowledge of HIVE/IMPALA and the Hue interface to Cloudera Hadoop Running kettle/spoon from the command line on both linux and Windows using Pentaho Data Integration Experience in testing ETL’s within the Enterprise Data Hub Knowledge of HDFS and Advanced version control using Git (branching/merging models, submodules, tagging, bitbucket and gitlab interface features) Support End to End testing and manage test data requirements Nationwide Building Society (NBS) Test Lead Jan ‘17 to Feb '18 Company : British Telecom (BT) Technology: eGain v15 , Cisco UCCE, Cisco Outbound Dialler, CUCM, Contact Centres, Acqueon List & Campaign Manager,Data Modelling Key Responsibilities: Hands on experience performing functional testing turning requirements and designs into test scripts for respective test phases, practical experience of agile methodologies and tools Taking lead role in Project Planning, Create Detailed Test Plan for each projects, forward to PM and BA team for approval Creating and assigning Testing activities for EGain Product V15, Cisco Outbound Dialler, Nationwide Omni channel testing - email, Web and Social and Knowledge Testing , Cisco UCCE, CUCM, Flow Testing of an On Premise Solution for eContacts Performing ST/ SIT/ UAT /NFT/ OAT testing for eContacts Solutions and data modelling Have experience in testing & building phishing campaigns in Acqueon Campaign Manager In-depth knowledge of documentation, risk based testing and methodologies and great attention to detail Performing System Integration Testing, End to End Testing & Non Functional Testing after each and every code release Proven ability to interpret complex business systems and have experience developing & presenting blueprints to build a test capability Execution of Test Scripts and raise bugs / issues in ALM Taking customer User Stories and Use Cases and defining Test Scenarios and Test Scripts Good Stakeholder Management, Project Management knowledge. Manage daily stand-up defect status calls with client & development team.  Updating status and highlighting issues/ risks in daily status Meetings Saudi Government Test Consultant Oct ‘15 to Jul ‘16 Company : British Telecom (BT) Technology: Kibana, Hue,Hive, Scala,Spark Gateway,GitHub, Elasticsearch,Hadoop/HDFS, Cloudera Manager, Cisco ACS, Cisco UCS, Cisco ISE, Firewalls, Switches, CA Server, Red Hat Satellite, Microsoft AD 2012, LDAP, Mcafee SIEM, Mcafee Web Gateway, Darktrace, Mcafee ePO, Fireeye, Check MK, Test Rail, Jira, Confluence,.Net , SQL, ETL Key Responsibilities: Hands on experience performing functional testing for each of the work packages forward to PM and BA team for approvals Creating and assigning Testing Tasks for Test Team for Cyber Security infrastructure testing for KSA client Preparing test case for testing & executing it with the help of Test Rail Performing FAT/ SAT/ UAT and Exploratory testing for Cyber Security apps and Network security solutions testing In-depth knowledge of documentation, risk based testing and methodologies and great attention to detail Performing Factory Acceptance Testing, System Integration Testing, End to End Testing & Non Functional Testing after each and every code release Experience working on Cyber Security-related projects within a large-scale environment/organization and advanced understanding of Cyber Security Execution of Test Scripts and raise bugs / issues in JIRA with Business Owners Understand the parameters of ticket management systems, vulnerability scanning, analytics , heuristic analysis(Hadoop), data ingest modules, web gateways , SIEM, HDFS, Fireye, Cisco Infrastructure such as Cisco ACS, Cisco ISE, Network access devices (SW, FW), Active Directory , LDAP, CA server and manage testing activities Manage daily stand-up defect status calls with client & development team.  Updating status and highlighting issues/ risks in daily status Meetings Celesio (Lloyds Pharmacy) Test Consultant July ‘15 to Sep ‘15 Technology: GK EPOS,Worldpay, SAP(CRM), HP ALM , SQL Key Responsibilities: Performed testing using GK EPOS( Point of Sale), Order management testing Preparing test case for testing & executing it with the help of HP ALM In-depth knowledge of exploratory testing techniques and methodologies and great attention to detail Performing Acceptance Testing, Sanity Testing, Functional and End to End Testing after each and every code release Update Regression Test Pack after each and every code release , critical analysis and definition of acceptance criteria and execute exploratory tests Understand the parameters of acceptance criteria and creation of user Journeys for Point of Sale (EPOS), payment and backoffice systems Updating status and highlighting issues/ risks in daily Project Meetings Harvey Nichols Test Consultant May ‘15 to June ‘15 Technology: Enactor, Magento Platform, Merett ERP, HP ALM , EPOS, SQL Key Responsibilities: Perform functional testing for Loyalty app ecommerce solution in Magento Platform , EPOS ( Point of Sale) and mobile testing using iOS ( iphone 5/6) and Android (Samsung galaxy s5). Design and Review test case for Loyalty app against business requirements and test execution In-depth knowledge of exploratory testing techniques and methodologies and great attention to detail Performing Exploratory Testing, System Integration Testing for each of the releases Execution of Test Scripts and raise bugs / issues in HP ALM Understand the parameters of acceptance criteria and creation of user Journeys for Loyalty Systems, Point of Sale (EPOS) and ecommerce transactions Updating status and highlighting issues/ risks in daily team meetings John Lewis Test Lead/Manager Dec ‘14 to April’15 Company : Cognizant Technology Solutions Technology: Oracle HRMS, Oracle 10G , ESB, SOA ,HP ALM, Sharepoint 2013,AX dynamics 2012, Kronos, SOAP UI Key Responsibilities: Analyzing functional and non-functional requirements , doing business analysis as BA for time attendance system/ HR portal , develop and maintain test scripts, creation of user journeys and defining entry and exit criteria. Leading a team of 3 Test Analyst Taking lead role in Project Planning, Create Test Plan for each projects, forward to PM and BA team for approvals Creating and assigning Testing Tasks for Test Team and testing AX dynamics 2012, Kronos, Oracle ESB Preparing test case for testing using SOAP UI & executing it with the help of HP ALM and data modelling Performing SIT, E2E testing for newly implemented time & attendance system - Kronos and test integration of these systems with existing systems and test Sharepoint applications. In-depth knowledge of exploratory testing techniques and methodologies and great attention to detail Performing Exploratory Testing, Sanity Testing, System Integration Testing, End to End Testing for every release Execution of Test Scripts and raise defects in HP ALM Updating status and highlighting issues and impediments in weekly Project Meetings Arrange weekly team meetings with whole team and update them with current project standings and forthcoming projects British Sky Broadcasting (BSkyB) Test Consultant Oct ‘13 to Nov ’14 Company : Cognizant Technology Solutions Technology: .Net, SQl Server, Toad, TFS, BDD, Visual Studio, Gherkin, Microsoft Test Manager, Spec flow , HP ALM, SOAP UI As a Senior Agile Test Analyst responsible for the System Integration Testing (SIT) and End to End (E2E) testing of Content Management System / Electronic Sell Through, Dynamic Playlist , VoD OTT, VoD EST and various SKY applications , producing estimates and planning and delivery of test preparation and execution, working with 3rd party suppliers etc Key Responsibilities: Analyzing functional and non-functional requirements , doing business analysis as BA for various sky applications to develop and maintain test scripts and defining entry and exit criteria. Creation of Technical specifications, user stories/journey , BRDs , Test Plans and Test Cases SIT and E2E testing which includes cross browsers (IE/Crome/FireFox/Safari) testing using SOAP UI the above mentioned websites , API Testing and other interfacing applications Executing test scripts using MTM in Visual studio and logging defects in HP ALM, database testing using SQL. Experience in writing Gherkin scenarios Utilizing BDD tools such as Specflow  Details planning, monitoring and tracking of the works for 5 Test Analysts.  Planned and exploratory testing of business-as-usual defect fixes and retesting.  Daily scrum, Sprint Planning, Defect Management, liaising with other stake holders including 3rd party vendor Preparation of daily testing progress report including RAG status. CENTRICA Plc (British Gas) Test Manager Jul ‘12 to Sep ’13 Company : Cognizant Technology Solutions Public Company; 10,001+ employees; CNA; Utilities industry Technology: Java, JSP, Unix, Oracle, Mainframe, Sharepoint 2013, Cognos 8, ETL, Tera Data, Data Manager, BI, Data modelling As Test Manager working on agile and End to End testing, defining/implementing Test Strategy and approach, producing estimates, and planning and delivery of test preparation and execution, working with 3rd party suppliers and Off shore teams. Key Responsibilities: Day-to-day management of multiple project test teams. Project-managing the testing service to guarantee success, working with a team of 5+ test analysts, across multiple scrum teams, within an agile development environment, implementing and integrating multiple development pieces across smart metering systems. Liaising with Project Managers, Analysts, Developers, Business and Users, playing an active role in delivering the business benefits of change. Experience producing Test Strategies and Test Plans at the programme level/project level, and experience of working in a team and a project environment with a flexible and adaptable working style with multiple project managers. Proficient in testing Share point, BI and ETL using Cognos in Teradata platform Expertise in testing interactive dashboards ,scorecards, ad-hoc analysis, and OLAP analysis in BI and data modelling Test the job schedule for ETL interfaces from Source to Dimension/Fact ,aggregate tables and manipulation of BI cubes Producing test entry and exit criteria plans, defect management and defect progress reports for release plans. Solid working knowledge of Agile methodologies and associated test practices and  ability to define test techniques and coverage for testing of requirement Organize status meetings and send status report Derive data from HP ALM and produce test status reports for various stakeholders Close working with Environments Delivery teams to identify test environment and support requirements, and to efficiently manage the allocated environments. UBS Test Consultant Jan ‘12 to Jun’12 Company : Cognizant Technology Solutions Testing Fix messages for Euronext, BATS, CHIX, LON, TRQ, Nordics, Emerging mkts Technology: Java, Unix, SQL Server, HP ALM , FIX Messaging , Fund Management and corporate actions. Key Responsibilities: Key responsibilities include Requirements Study, Gap Analysis and SOA testing for fund management and corporate actions Analyzing new requirements for CRS and identifying the functional scope, preparing the Test Case Design document with full coverage of new functionality and getting it reviewed by UBS team for FIX messaging Execution of test scripts including regression testing , capturing requirements for Asset and Fund Management Raise defects in the HP ALM with the details after the RCA and reporting the status of the regression runs to the stakeholders, updating the status to the Test Manager. Created new SQL Traces to query the database using joins, Querying and updating data using SQL Accurate and concise documentation skills, used for creating detailed test case design/plan, test reports and other documents required within the test process. Direct regular liaison with the UBS test team to resolve, triage bugs and provide technical support on the issues. CREDIT SUISSE Test Lead/Manager May ‘08 to Dec ‘11 Company : Cognizant Technology Solutions Credit Suisse Plus is a single dealer platform for Fixed Income in FX, Spots, Swaps, FX Options, IRS, Swap Clear, Rates, Credit, Securitized products, Commodities and Emerging Markets and corporate actions Technology: Java, Silverlight, Unix, Oracle 10g , HP ALM Prepares detailed specifications, requirements, scope documents and logic flowcharts for the development and implementation of complex application programs and modifications Perform test planning, test design and test execution on for corporate actions and securities / commodities. Analyzing the requirements, User stories/ journey of the new business model, preparing Test Approach Prepared the high level, detailed test cases and reviewed the test cases of team members. Work independently and with a team as well as interface across teams and liaison to applicable team members to ensure cross team collaboration Validating XML files, querying the database and checking the server logs for any errors. Perform system-wide root cause analyses and drive improvements Reporting defects using HP Quality Centre 11.0 and retesting of the defects on being fixed, running the regression test suite for any regressed functionality. TATA AIG Test Manager Jun ’07 to Apr ’08 AIG Life insurance solutions for new business, claims, underwriting, pensions , micro insurance Technology : Windows XP,IBM AS400, Oracle, ASP, HP Load Runner v9.0 Defining the scope of testing within the context of each release / delivery Good working knowledge of Agile Testing and experience of leading or implementing test automation and/or performance testing for Life, Pensions and claims applications Demonstrated experience in project sizing and effort estimation process Effectively communicate with all stakeholders to include technical, business and all levels of management Document and manage Test plans and Test Strategies Demonstrated proficient use of HP ALM as it pertains to report generation, metrics management, requirements management and test planning/execution Effectively communicate any project risk(s) to the respective stakeholders and work with team to identify mitigation plan. Work independently and with a team as well as interface across teams and liaison to applicable team members to ensure cross team collaboration CITIGROUP INC Sr Software Specialist Jun ’06 to May ’07 CITI DIRECT for Securities is a one stop web solution which takes care of entire global transactions within Global Citi clients for trading, securities, asset and fund management and corporate actions . Technology : Windows XP, Cognos, BI , Oracle 10g, HP ALM, HP Load Runner v9.0 Requirements Study , Gap Analysis ,writing test plans and experience in SOA testing for fund management and corporate actions Responsible for design , review of Test Scenarios and Test Cases Proficient in testing BI and ETL using Cognos and BI development tools Strong knowledge and working experience of BI, and ETL solutions in a QA context with ability to drive end to end with data integration to application tiers Keen to take the lead in investigating issues using application documentation, subject matter documentation and internet sources; document findings informatively for the benefit of the team Defect Management using HP ALM and defect resolution NOVARTIS AG Software Engineer Apr ’05 to May ’06 Dragon is the web based application with a single point of reference providing worldwide regulatory status and parameters for all global and local Novartis Pharma products. It supports the cross-functional business processes by sharing regulatory values and status on Pharma products which is Centralized Global validated application (21 CFR Part 11) Technology : Windows XP, Cognos,BI, Oracle9i, Load Runner v 8.0, Site scope & HP ALM Coordinate functional activities and requirements with cross-functional teams for specific product releases. Analyzes product test requirements and assists Test Manager with development of Test Plan Maintaining the Test Defect Log for all the defects found during the testing for bug tracking. Responsible for DWH and enterprise report testing using Cognos and BI. Detailed and practical knowledge of Data Warehousing concepts and best practices Using Site scope tool to monitor configurations , redundancy & failover testing Creation of automation scripts , creation of test runs in Load Runner for performance& Fail-over Testing checking for performance bottlenecks. DELOITTE CONSULTING Analyst Jul ’03 to Mar ’05 Agilent is a globally diversified technology organization that provides enabling solutions to technology market within Communication, Electronics, Life Sciences and Chemical Analysis Segments, Product lines include Semiconductor products, test and measurement equipments, and chemical analysis instruments. Services include R & D via Manufacturing, Product installation and Maintenance. Manual Testing of the Agilent Website. Preparing Test Data using tools Enput (Publishing Tool) , Broadvision DCC Technology : Windows 2000, Oracle 11i App , Oracle 9i , HP Load Runner 7.6, HP Site Scope Creation of test cases , test data in flat files for batch jobs Maintaining the Test Defect Log for all the defects found during the Testing for bug tracking. Defect Management using HP ALM Tool, prioritizing defects Writing Change Requests for the defect found in the system and tracking them. Installation & Configuration of HP Load Runner Controller . Documenting the vuser scripts for oracle reports Reporting all issues related to testing to the On Site Project Lead. Performing test runs for volume , stress , failover & resilience testing Using Sitescope to monitor configuration , check for redundancy & Interpretation of test results