RAVI TEJA PEDDARAPU

ISTQB- CTFL

PROFILE

A versatile, analytical and hard-working,

with a practical “get the things done”

approach, who always perseveres to

achieve the best results. Passionate

towards the ETL-Data warehouse testing,

Telecommunications, Data analysis and

Business analysis.

CONTACT

France - +337********

203, 92700, Colombes

adkywe@r.postjobfree.com

30.07.1994

Indian

Visa: APS (Job Search)

www.linkedin.com/in/ravi84

TOP ROLES

Software Engineer

System Test Enginee

QA Engineer

LANGUAGES

Telugu

English

Hindi

French A1

HOBBIES

Travel, Cooking and Swimming.

SKILLS SUMMARY

Programming Languages Python

Automotive Tools Selenium, UFT

IDE(s) Eclipse, PyCharm, Visual Studio

Database T-SQL, Oracle, DB2, Teradata Sql

Project Management Agile,Waterfall

Triage/Bug tracking Tool HP-ALM, Microsoft Test Manager, JIRA Operating Systems Windows, Linux/Unix

Packages Ms-Office

Others Hardware, Power Supply, Filed network

engineering

LATEST EXPERIENCE

TEST ENGINEER

09/2015 – 06/2018 India Infosys Ltd, Hyderabad

Project

Role ETL-BI Test Analyst & Developer.

Project Name WestPac Banking Corporation

Duration September 2015– June 2018

Skill Set Used Informatica, Informatica BDM, Data warehouse, ETL & BI, Unix, Control-M Scheduler, Tableau, Cognos,Python, Selenium, Teradata SQL,SQL, Linux, JIRA, HP-ALM, Waterfall & Agile-SCRUM,

Overview

Westpac is one of the leading bank in Australia with an history of 200+ years, had acquired few banks(Bank of Melbourne, St.George Bank of South Australia,Banker’s Trust Financial Institution and RAMS) in Australia. Westpac maintains centralized Datawarehouse for the data retrieved from the different source systems in heterogeneous forms. Initially it has chosen Teradata 14.0 as the database and upgraded to the version 16.0 later point of time.

As a solution to handle huge data, implemented the hadoop with Hortonworks Distributed Platform (HDP). At source end, HDFS and SQOOP are used to extract the data and PIG to load into intermediate stage tables. As a target, data loaded to HIVE tables. Datastax Cassandra is chosen as NoSQL databases to integrate with HIVE and then data is allowed for reporting.

Responsibilities:

Responsible for developing, support and maintenance for the ETL(Extract, Transform and Load) processes using Informatica PowerCenter(9.x)Worked on mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.

Worked with several facets of the Informatica PowerCenter tool Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.

Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.

Strong practical experience in writing complex SQL queries, BTEQ scripts(Teradata Sql assistant), stored procedures.

Develop a test plan/design, execute test cases and defect management for ETL & BI(Tableau, Cognos) systems and to perform data validations after migration.

Develop test scripts using selenium for web applications and creating bulids in Jenkins for CI and CD.

Preparing the dail test status summery report and sharing with stakehoulders and project presentation to clients before the relase. SUMMARY

3.6 years of experience as a Test

Engineer and Intern Digital

Marketing analyst

Good Hands of experience in the

following fields:

ETL-Data warehouse, Software

Testing.

Regression Testing

Automation/manual Testing

Data Driven Testing

CI/CD Pipelines

Requirement Gathering and

Grooming Test case

SDLC & STLC

Bug Life cycle

Agile/Waterfall Model

Expertise in understanding

requirement and Development of

Functional Test plan.,

Good hands of experience in

Software testing, Sql complex

queries and AWS .

Knowledge on CI/CD

pipelines(Jenkins)

Comfortable with AWS services

(EC2, S3, EBS,RDS,Redshift(basic))

Have Knowledge in python, java

Scripting, Agile Methodology etc.

Manual, Functional and

Automation Testing.

API, DB, DWH and ETL Testing &

UAT, SIT, E2E Testing.

Data analysis and analytics.

Project and Team Management.

Core marketing and Digital

Marketing.

Business analysis and

Requirement analysis.

Ability to learn quickly, good

communication skills, self-

motivated and work

independently.

Executive Digital Marketing Internship.

The Key Corner Constructions Pvt ltd.

06/2019 - 10/2019,

• Social media marketing and management.

• Use of HubSpot CRM and WordPress CMS, Web Development

• Google Ads campaign and use of Google analytics,

• Email marketing (Developed Excel Macro for mass mailing).

• Planning digital marketing campaigns including web, SEO / SEM, Technical and Filed Engineer telecom.

SIONT. Paris, France.

11/2020 - Present,

• Server Hardware Troubleshooting Network Hardware. Copper and Optical Fibre Cabling, Switches, Routers.

• Primary point of contact for both internal customers (for example: Network Engineers, Systems Engineers, Software Developers, Database Engineers, Technical Operations) and external customers

(Hardware Vendors, Contractors, Service Providers among others).

• Technical trouble-shooter for all Systems and Network hardware problems.

• Racks and stacks customer equipment, building up an entire rack from scratch.

• Installs customer equipment and cabinets.

• Installs/Tests/Modifies cross connects per SOPs and ensures proper cable management of coax, fibre, twisted pair copper and intra- building cross connects.

• Installs and tests advanced cross connects circuits (switched, multiplexed, etc.)

• Data Centre Operations: Inventory Management. fibre testing and cabling.,

EDUCATION

MSc International Marketing and Business Development Skema Business School 09/2018 - 12/2019, Paris,France

• Core concepts of Marketing.

• Practices of Business development exercises.

• Presentation of new business ideas.

• Sales and International Business Development.

• Business and Data analysis.

Bachelor of Technology in Electrical and Electronics Engineering SRM University, Chennai, India; 2011 – 2015.

• Core concepts of electronics and telecomunications.

• DC machines and Electrical circuits

• Computer networks and the Internet.

• Basic elements of a telecommunication system.

• Wired communication and Wireless communication.

CERTIFICATIONS

• ISTQB- Certified Tester Foundation level; ISTQB; Sep2020

• Selenium WebDriver with Java -Basics to

Advanced Frameworks; Udemy; Sep 2020

• AWS Cloud Practitioner Essentials; AWS digital

training; Aug 2020

• Scrum Development with JIRA and Agile JIRA;

PLURALSIGHT; APR 2020

Contact this candidate