adezvc@r.postjobfree.com

+91-987*******

LinkedIn: Shaurya Ratna

SHAURYA RATNA

Objective

To be a part of a growing organization and aid in accomplishment of organizational objectives by utilizing my knowledge.

Technical Skills

Database : T-SQL, Oracle SQL/ PL-SQL

Tools : Anaconda, SQL Server Management Studio(SSMS), Informatica PowerCenter & SSRS

Programming : Python, PL/SQL

Analytics : Tableau & Excel

CRM Systems : Oracle Siebel, Salesforce Cloud CRM Personal Competencies (Soft Skills)

Quick learner as well as adaptable.

Good Analysis, problem solving and communication skills.

Highly inquisitive and punctual nature.

Can work on multiple tasks, can prioritize the tasks and help the team to meet the deadlines.

Attentive listener, Very proficient in English.

Educational Background

Education

School/College

Board/ University

Percentage/CGPA

Obtained

B.Tech CSE Galgotias University Galgotias University 8.66

Intermediate

Tagore International

School

CBSE

84.8%

High School

Tagore International

School

CBSE

87.8%

Certifications

Cisco Certified Network Associate (CCNA) CSCO12423808.

International English Language Testing System (IELTS) in 2018. Work Experience

JOB

Name of the company: EXL SERVICES/ INDUCTIS (July 2019 - Present)

Designation: Consultant / Assistant Manager

Description: Working with an Insurance Domain (Annuities) Client to create Databases, DataMarts and different Stored Procedures and performing Analysis on the same using a bit of Python/Tableau/Excel. Direct Client interaction for Data manipulations /validations coming from different sources on both Historical as well as Transactional Data. Loaded Raw data, cleaned, transformed it and sent to Tableau for creation of more charts and doing analysis. Have performed Outlier Treatment using IQR by removing skewness in data in Python. Created automated reports in SSRS using Stored Procedure functionality of SQL. Have also created few SSIS packages to execute stored procedures in SQL. Proficient in Data Warehousing concepts. Creating and maintaining technical design documents, issues and log documents and Daily Status tracker.

Name of the company: INFOSYS LIMITED (August 2015 – July 2019)

Designation: Technology Analyst

Description: Worked on Informatica PowerCenter and developing SQL queries. Using Informatica PowerCenter for designing, developing, maintaining, and monitoring ETL processes for a leading auto finance client. Worked on data extraction, Transformation and loading data from heterogeneous data sources. Involved in Performance tuning at source, target, mappings, sessions, and system levels. Extensively used SQL Developer to write/run the queries. Have worked on Salesforce Cloud for a data team for Bulk Loading/Migrations writing Pl/Sql stored procedures, triggers and using DBAmp and SSMS for loading data. Basic knowledge of SSIS is also there. Also got trained on Python and worked on a project briefly for the same. Have prepared HLD documents and got trained on Oracle Siebel CRM as well.

Professional Competencies

Got the Value Champion Award in Analytics Annual Meet in EXL Services.

Got an award in Zero Distance initiate by Infosys Ltd and a certificate of appreciation for automating some batch related jobs in a team.

Coordinated at the Career Planning Development Division Cell in the college.

Worked as a Race Marshal in the 2012 Formula 1 Airtel Indian Grand Prix.

Attended the “National Conference on “Contemporary Developments in Mathematical Sciences and Computing”.

Hobbies and Interest

Reading novels, Watching movies, Cooking, Volunteering and Swimming.

Contact this candidate