| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatesaranya.thoppe.neelakantan@gmail.comSARANYA THOPPE NEELAKANTAN Contact: Us No: PHONE NUMBER AVAILABLEExperience SummaryI have 12+ years of experience in Testing (Azure Dev ops Testing, ETL, Bigdata Hive, Manual & Report Testing). I have acquired complete knowledge of the Software Testing Life Cycle and involved in different phases - Analyzing Phase, Test Planning, Test Design, Test Execution, and Defect Management. I have a good Knowledge of SQL queries, Basic Unix commands, BO Reporting, E2E testing process, and Test Management Tools like HP Quality Center.Technical SkillsTestingETL ToolsTest Management ToolAzure Dev ops Testing, ETL Testing, Manual &Report TestingAzure ADF, Informatica 9.1Agile Kanban Board, ALM - Quality CenterDatabasesTools / TechnologyMS SQL, Teradata 14.0.0.1, Oracle 11gSQL Assistant, Oracle SQL Dev, TOAD 10.6, Basic UNIX commands, SQL queries, SOAP UIEducational SkillsBachelor of Engineering in Information TechnologyArulmigu Kalasalingam college of Engineering2009Project ExperienceProject #1 @ IBMTitle EAP-Platform & LandlordClient Amerisource BergenTools &Technologies Azure DevOps-ADF, SERVICE BUS, Logic APP, Storage Explorer, MS SQL ServerPeriod Aug 2020 to July 2023Project Description: SAP Source System ( All information about Orders, Suppliers, transactions, Billings are available in SAP)--- EAP(intermediate service) takes only high level info --- Dump in SQL DW BI Reports -- ABC User do forecast, Invoices, Stock details, order.Control Framework
Reads the files from Azure data lake and loads into Azure Data warehouse (Raw Schema).It is custom code i.e PolyBase is a tool built in with SQL Server 2016 and Azure SQL Data Warehouse that allows us to query data from outside files stored in Azure Blob Storage or Azure Data Lake Store. Once we define a file type within SQL Server Management Studio (SSMS), we can simply insert data from the file into a structured external table.Creates workflow (register dataset into Datawarehouse) using the metadata fileRoles and ResponsibilitiesAnalyzing the business requirements exist on stories and coming up with major deliverables like Business Scenarios, test cases.Extensively interacting with developers and BAs tounderstand the business requirements and Azure design document specifications.Analyzing project functionalities and writing test casesWriting complex SQL queries to validate the data from Input to Output.Running the ADF jobs to load the data into DW.Responsible for running test cases and logging defects.Responsible for running ADF Pipelines, Service Bus, Logic App and doing Ingestion testing and validating the stored procParticipating in daily scrum calls.Project #2 @ IBMTitle IFRS 9 & CECLClient T & D BankTools &Technologies SQL Server, HP ALMPeriod Feb 2019 to July 2020Project DescriptionIFRS 9 is an International Financial Reporting Standard (IFRS) promulgated by the International Accounting Standards Board (IASB). An impairment staging solution is required for bridging data delivery between TD and KPMG gCLAS (proposed IFRS 9 impairment solution). IFRS 9 Staging will use an ETL process for all intake data from TD sources. IFRS 9 staging will cleanse, perform existing businesstransformation rules and prepare the data for loading into KPMG gCLAS. KPMG gCLAS will calculate expected credit losses, manage stage migration and provide quantitative disclosures / reporting and provide projected cash flow measures under IFRS 9.Roles and ResponsibilitiesAnalyzing the business requirements and coming up with major deliverables likeBusiness Scenarios, test casesExtensively interacted with developers, business, management teams tounderstand the business requirements and ETL design document specifications.Analyzing project functionalities and writing test casesWriting complex SQL queries to validate the data flow from Input to Output.Running the jobs to load the data using SQL Server 2012.Responsible for running test cases and logging defectsResponsible for Functional Testing, Integration Testing, System Testing andQualification Testing.Participated in regular project status meetings and QA status meetingsPrepared daily status reports with details of executed, passed, and failed test casesand defect status.Project #3 @ IBMTitle DWBI-Testing ( Panorama)Client MetlifeTools &Technologies Bigdata Hive, Oracle, HP ALMPeriod Dec 2016 to Jan 2019Project DescriptionWorking in Migration Program, where 18 Admin System are Migrated to CSC Admin System.Going forward Policy information, Party Information, Transaction Information we will be receiving from DXC (CSC) wmA.Roles and ResponsibilitiesPlaying Technical Lead Role, Involved in Client Design walkthrough call.Driving defect Triage call.Involved in writing Complex queries & Testing Complex scenarios.Presenting the Status with Client along with Burn down chart.Executing the Test Cases and Logging defects in QC and Maintaining Defect ReportingRetesting the defects once it is fixed without delay.Involved in Test Data Management.Project #4 @ IBMTitle Rise Manual Adjustment ToolClient T & D BankTools &Technologies SQL Server, HP ALMPeriod May 2016 to Oct 2016Project DescriptionRISE Adjustments Tool as part of RISE Program, which will create a standardized process along with sufficient review and audit practices built-in to facilitate a more robust and transparent adjustment process across the enterprise. RISE Manual Adjustment Tool will be built as one of the two components of CRAF (Central RISE Administration Facility) along with Central DQ (DQ Aggregation across all GDSs).Roles and ResponsibilitiesCreating Test Cases covering all Functions in GUI tool.Validating all Functionalities at GUI by creating adjustments and validating the same adjustments at the Backend databaseExecuting the Test Cases and Logging defects in QC and Maintaining Defect Reporting for every Code Drop.Involved in Requirement walkthrough with Onsite.Retesting the defects once it is fixed without delay.Delivering the Complete Status of the Project to Onsite Lead on daily basis as DSRProject #5 @ Cognizant Technology SolutionsTitle Debt Issuance Profile ReportClient Standard and Poors Rating ServicesTools &Technologies TOAD 10.6, HP ALM 11.52, MSTR/BO ReportsPeriod Nov 2015 to May 2016Project DescriptionDebt Issuance information should be monitored for each Issuer. As a result, RRDW will extract debt issuance information from CORE, and provide a mechanism for Org Analysts and Analytical Managers to review their covered Issuers debt issuance informationRoles and ResponsibilitiesBased on the Functional Scenarios, creating the Test Cases.Functional Testing, Validating the Functions of Source to Target of the Systems and Executing the Test Cases and checking the values and Logging defects in QC and Maintaining Defect Reporting for every sprint.Involved in Requirement walkthrough and client call in understanding requirements.Retesting the defects once it is fixed and communicating to client if its required.Maintaining the Test cases whenever changes in Functional Specification.Delivering the Complete Status of the Project to Manager and Client on Weekly and daily basis as DSR and WSR.Project #6 @ Cognizant Technology SolutionsTitle European Ratings PlatformClient Standard and Poors Rating ServicesTools &Technologies TOAD 10.6, HP ALM 11.52, SOAP UIPeriod Aug 2015 to Oct 2015Project DescriptionEuropean Parliament and Council adopted the Regulation on credit rating agencies. As per the Regulation, a new requirement for ESMA is to establish a European Rating Platform (ERP) to publish individual credit rating information in connections with credit ratings and ratings outlooks, issued by CRAs (Credit Rating Agency).For this purpose, CRAs will submit rating information, including the credit rating and rating outlook of the rated instrument, information on the type of credit rating, the type of rating action, and date and hour of publication in the form of XML files.a.Ratings Fileb.Qualitative DataRoles and ResponsibilitiesBased on the BRD, creating the Test Cases.Running Web Services in SOAP UI and validating the responsesExecuting the Test Cases and checking the data and Logging defects in QC and Maintaining Defect Reporting for every sprint.Reviewing the Test cases and Defects before raising the defects.Retesting the defects once it is fixed and communicating to client if its required.Preparing Daily Status report and Monthly status reportProject #7 @ Cognizant Technology SolutionsTitle Enterprise Data Warehousing (EDW)Client STC (Saudi Telecom)Tools & Technologies Informatica, UNIX, Teradata 14.0.0.1 Database, Quality CenterPeriod Sep 2013 to June 2015Project DescriptionThe Saudi Telecommunication Group provides integrated mobile, fixed and broadband communications services to over 160 million customers globally. Headquartered in Riyadh, Saudi Arabia, Saudi Telecom Company (STC) is the largest telecommunications company by market capitalization, total revenue and number of employees in the Arab region.This project deals with the upgrading of the existing EDW solution of STC to empower the organization with business intelligence capabilities to harvest knowledge from disparate data sources to enable the business to make strategic decisions in a timely manner. Data model is upgraded from cLDM7 to cLDM12 and the ETL is upgraded to Ab Initio from Data stage.Roles and ResponsibilitiesUnderstanding the business requirements and designing the test scenarios, test cases, SQL queries, executing the psets and plans in Ab Initio, testing the data at target.Identifying the critical defects and tracking them to closure in Quality Center (QC).Delivering the test exit report.Preparing the daily, weekly and monthly status reports.Leading the daily status call.Preparation of Knowledge Management related documents.Conducting frequent KT sessions for cross stream training.Project #8 @ Tata Consultancy ServicesTitle Enterprise Data WarehousingClient COMCAST USTools &Technologies Informatica 9.1, UNIX, Teradata 13 Database, Quality CenterPeriod February 2011 to Sep 2013Project DescriptionThe objective of the project is build National Data warehouse for the company comprising from different source systems like Oracle, Flat file etc. COMCAST-NDW is an enterprise data-warehouse implementation. It is based on several subject area in the view of a major Telecommunication business. This is associated with Telecom as well as cable and internet. For capturing Business data there are many legacy system have been used like Amdocs-Billing system, Kalido, Golden Gate etc. For DSS Informatica is being used for ETL and OBI has been used for BI reporting. Data Base is based on Teradata.Roles and ResponsibilitiesReviewing the business requirement document, Traceability matrix and design documents.Preparing the Test Approach document.Performing the requirement testing.Writing the test specifications.Creating the Test cases, executing the work flows and defect fixing before code moves to Production.Delivering the test exit report.User Acceptance testing support.Preparing the daily, weekly and monthly status reports.Interacting with the Business Analysts and System Analysts during the projects walk through.Leading the daily test status call and communicating with all the stakeholders (Developers, Delivery Leads, and BA).Preparation of Knowledge Management related documents.Conducting frequent KT sessions for cross stream training.Mentor the new joiners to understand the Insurance business process & applications.Project #9 @ Tata Consultancy ServicesTitle Parts Planning System Business Intelligence (BI)Client Motorola Inc., USTools &Technologies QC, Oracle 10g Toad, QC, TeradataPeriod August 2010 January 2011Project DescriptionParts planning application designed to provide Motorola mobile devices business community with Intuitive access to business operations. It is intended to provide a global data system that supports business reporting needs at the global and regional level by providing timely & targeted view of data from all regions.Roles and ResponsibilitiesInteracting with Requirement Analysis team/Development team and understanding the Business Requirements and Functionality of the systemTest Planning, Test Case writing, Test Execution and Report generation.Prepare and Execute SQL queries using Transformation Rules document.Validating Transformation rules, Count Mismatch, data mismatch from Source file to Staging, Staging to Temp, Temp to Base.Daily interaction with various stake holders and providing Daily/Weekly Status Update.Managing a Test team of 4 membersProject # 10 @ Tata Consultancy ServicesTitle ILP Initial Learning programClient Organized by TCS itselfOperating System Windows 7Period February 2010 to June 2010Project DescriptionDuring ILP, I was given training in basic software concepts, testing concepts, C, C++ Java and J2ee.Roles and ResponsibilitiesTo build excellent programming skillsTo understand and implement the concepts of OOPTo develop good leadership qualities.To build good communication skillsTo build skills in Technical WritingTo develop good team skills.To understand the basic concepts of Test Scripts.To understand the basic concepts of Operating Systems. |
