Python Data
Resume:
************@*****.***
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