Shreshtha Shrivastava

Experience

• 

  Cognizant

  Feb 2022 - Jul 2023

  SQL- Used PostgreSQL• Created databases and tables according to Client requirement• Inserted data into tables• Import data from text files using delimiter• Retrieve records without duplicate• Worked with where clause, logical operators, update, delete for performing tasks• Used selection commands for filtering and ordering• Used alias for giving different names to columns/ tables in results• Worked with aggregate commands• Used group by statement with having clause for performing tasks• Worked on Joins for combing rows from two or more tables-Inner join, Left join, Right join, Full join• Learned how to write subqueries, indexes• Worked with String functions for finding results• Used mathematical functions, date and time functions for performing tasks.• Worked with pattern matching, window functions for finding resultsExcel- Worked with data validation, conditional formatting, basic formatting and sorting data, dealing with null valuesand duplicate values, trimming whitespaces, text functions, date time functions, functions(sum, sumif, sumifs,count, countif, countifs etc.), vlookup, hlookup, data modelling, power query editor for transforming data,multiple charts based on data, pivot tablesPower BI- Created Power BI dashboardsPython- Worked with NumPy, Pandas, Matplotlib librariesHTML & CSS - Created tables, forms, unordered lists & order lists, added hyperlinks, changed and created styling on HTML Elements Show less •SQLLearned about SQL Commands-DDL, DML, DCL, TCL, DQL Learned how to apply Where clause, Operators(AND, OR, NOT), Order By, Insert Into, Update, Delete, Min and Max, Like, Wildcards, In, Between, Aliases, Joins-Inner join, Left join, Right join, Full join, Unions, Intersection, Group by, Having, Comments, Learned how to create-Database, Drop Database, Create table, Alter table, Constraints, Data types.•C++Comments, Variables, User Input, Data Types, Operators, Conditions, Switch, If-Else, While Loop, For Loop, Break/Continue, OOPs Concept, Classes and Object, Access Specifiers•PythonSyntax, Comments, Variables, Data Types, Numbers, Strings, List, tuples, Set, Dictionaries, If-Else, While Loops, For loops, User Input, OOPs Concept.•Presentations & Writing Email Learned how to present presentations, write appropriate emails with proper structure. Show less

  • Software Engineer Trainee

    Jul 2022 - Jul 2023

  • Internship

    Feb 2022 - Jul 2022