EXPERIENCE SUMMARY:

*+ Years of experience in Software Testing and Quality Assurance including Database Testing, Data warehousing –DWH-ETL testing, and REST Web service testing.

Strong Experience with Amdocs CRM, Telecom OSS/BSS, Mediation, Data analytics [DWH+BI]

System/Domain.

Analyze ETL Requirements and Mapping sheet with BA.

Involved in CSV & Json Dataset Automation using Python script.

Knowledge of Hadoop ecosystem - Map Reduce, Pig, Hive, HBase and Sqoop.

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

Map Source and target data in term of Duplicate, Count, Nullable, String length, data types, constraint, length.

Involved in the analysis of source systems, gathering business requirements and identification of business rules.

Prepared and run SQL queries to verify Dimensional and Fact tables, verifying the data in target database by ETL process, Transformation logic is applied before loading the data.

Data flow validation from the staging area to the intermediate tables, Surrogate key check.

Knowledge of all Data warehousing /DWH concepts, good understanding of OLAP, OLTP, Star schema, snowflake schema.

Understand and analyze SRS to ensure it meets the Customer requirement, Responsible for Test Case Writing, Execution, Bug Tracking and Reporting.

Actively involved in Review of test Case, Performed Functional, Integration and Retesting, Regression, Sanity, and Database testing.

Enough exposure to all stages of SDLC, Mapped the business requirements with test case by preparing Traceability matrix. Strong knowledge over whole Software Test Life Cycle (STLC).

Work closely with other testers and developers with bug fixes and Defect Analysis Using defect management tool such as HP ALM &JIRA

Used Postman tool as protocol for REST- Web service testing.

Worked on Software quality assurance Process AGILE methodology, V Model.

Wrote SQL queries to access the data from the database tables.

Strong Knowledge about UNIX Commands to validate server data.

A result-oriented team player and skillful in coordinating with development team and problem solving abilities.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000 /XP, UNIX,

Languages: Python, SQL.

Testing Tools: REST, PuTTy

Cloud : Azure

Bug Reporting: HPALM, JIRA.

Databases: Oracle 9i/10g/11g, SQL Server 2005/2008

ETL /BI Tools: SSIS Package, Metric Insights BI.

Database Tools: SQL Developer

Web service tools/Technology: REST, JSON, POSTMAN

Working Zone – Organization:

Currently working as ETL/ BI Test Engineer- Telus International

(https://www.telusinternational.com), Noida since June 2019 to till date.

PROJECTS:

Project Sequence 1

Project Name : O-RAN Integrator

Vertical : Telecom OSS –Provisioning & Activation [Inventory Management]

Client : Telenor, Sweden

Technology & Tool : Data warehousing /ETL, SSIS Package, Database testing, UNIX

Detail Project Overview and Workflow:

Telecom network operations are becoming increasingly complex, owing to increasingly diverse and demanding use cases, increased frequency band choices, virtualization, network slicing, as well as the ongoing disaggregation and distribution of the radio access network (RAN) functions, such as through Open RAN.

The Open Radio Access Network (Open RAN or simply ORAN) has opened the gates of opportunity for the telecom company RAN industry. It has given a fillip to the market competition and gifted operators with both freedom and flexibility in vendors' selection and deployment strategies. The purpose of ORAN is to define and build RAN solutions based on general-purpose vendor-neutral hardware, open interfaces, and software. This offers an integrated approach that allows businesses to use the best technology for them at the lowest possible cost.

The Wireless Router 5G enables you to create a robust cellular connection in an industrial production environment. The router is prepared to be used with private industrial 5G networks in Europe supporting band 78 (other bands on request). Main functions:

Future-proof and ready for new use cases such as 5G network slicing, SD-WAN, 4K/8K cameras and AR/VR

High-speed 5G NR and 4G LTE-Advanced Pro Cat 20 dual connectivity cellular radio

Enterprise-grade Wi-Fi 6 and dual 2.5 Gigabit Ethernet

Extended operating temperature range for wider use-cases

Standards-based Power over Ethernet simplifies installation

Multiple mounting options and accessories

Serial port for remote, out-of-band management

Securely deploy, monitor and control devices with Telenor exchange

Full-featured enterprise and industrial cellular routing platform

Project Sequence 2

Project Name : MVNO & MVNE billing and charging solution

Vertical : Telecom BSS, Amdocs CRM

Client : GCI Communication Corporation, USA

Technology &Tool : Data warehousing /ETL, SSIS Package

Detail Project Overview and Workflow:

GCI’ MVNO & MVNE billing and charging solution, allows an MVNO to implement its own plans and promotions. As the MVNO grows, it can offer branded services to other newly launched MVNOs by expanding its billing platform, thus transforming itself into a full-fledged MVNE.

Carrier-grade, out-of-the-box, convergent charging and real-time billing services for prepaid and postpaid

Rapid time-to-market for new products and services

Simple and seamless integration with network elements and VAS

Multi-language, multi-currency support on a single billing platform

Project Sequence 3

Project Name : Circuit Billing and Ordering

Vertical /System : Telecom BSS, Amdocs CRM.

Client : GCI Communication Corporation, USA

Technology &Tool : Data warehousing /ETL, EDI File Processing, SSIS Package, Database testing, UNIX, Job Run

Detail Project Overview and Workflow:

GCI Communication Corporation rating engine rates usage events for any telecom and digital services: ISP, broadband, VOIP, TV, OTT, subscription-based services, telephone, IoT, and more.

Real time prepaid and postpaid charging and provisioning schemes: AT & T keeps subscriber account balance up-to-date and transmits connection and disconnection messages to the Provisioning module immediately.

Fully customizable templates of tax and pro forma invoices and credit notes. Automated invoices printing and sending.

Multiple Bill Cycles can be run concurrently.

Bill Cycles establish the statement date, payment due date, billing interval (monthly/quarterly), billing start date, and the prorate method used to determine partials,Bill Cycles can have any number of related Bill Groups associated with them,Bill Groups define a ‘collection of accounts’ – billed at the same interval, in the same bill cycle, with the same invoice format,

Trial Balance Report verifies that each Bill Cycle balanced properly.

PERSONAL DETAILS:

Father Name : Rajendra Ghaytidak

Mothers Name: Sangita Ghaytidak

DOB : 07/04/1994

Address : Room no 305, Jadhav hights, Oppo.UCO Bank Kesnand,Pune

412207 Maharashtra

Declaration:

I hereby declare that the above-mentioned information is correct to the best of my knowledge

Date:

Location:

Regards,

Suryakant Rajendra Ghaytidak

Suryakant Rajendra Ghaytidak

ETL Test Engineer – Telus International

(https://www.telusinternational.com)

Objective

To employ myself in a progressive organization that provides scope to update my practical knowledge and skills in accordance with the latest trends and be part of the team that dynamically works towards growth of the organization.

Looking for a software test engineer Job where I can utilize my SQL skills to validate Cloud ETL/ Data warehousing –DWH/ETL components/System/ Python Automation. To achieve a challenging position in Software Testing in a result-oriented company, where acquired skills and education will be utilized towards continuous growth and advancement.

Education

University: Rahuri

Branch: B.Sc (Agriculture)

Hobbies

Cycling Reading Gardening

CONTACT

Phone: 869-***-****

Email: advhll@r.postjobfree.com

Experience

Core Technologies:

ETL Testing, Database Testing, BI Testing, Big Data, Unix, REST Web service Testing, Agile, Manual Testing, Dataset Automation with Python Script.

Vertical/System Involvement Area:

Telecom BSS/OSS, Amdocs CRM, Data Migration

Client:

Telenor, Sweden

GCI Communication Corporation, USA

Domain/System/ module Worked/Working with:

Amdocs CRM *Telecom BSS/OSS * Telecom OSS –Inventory Management (Provisioning & Activation) * Rating Charging * Mediation *

Core Area Involvement:

Agility Database Testing File Processing ETL Testing web service testing Role based access security system Data volume Testing (Shortest path Detection –Performance Testing System Integration – Functional Testing

Process worked with: Agile V model

ETL Tools used: SSIS Package Defect Management tool: HPALM, JIRA Process: Agile + Waterfall Model BI Tools used: Metric Insights BI

Technical Qualification Headlines:

Manual Testing * *EDI File Process * Business Intelligence- * Sisense BI *DWH/ETL-Data warehousing* SSIS Package *Database Testing * Web service Testing * UNIX * SQL * HPALM * JIRA * Waterfall model * Agile * RESTful Web service *Data Volume Performance test * Security Test *

Contact this candidate