*

Aditi Gurav

Cell# 216-***-**** Email: adx3eu@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/aditi-gurav- 99659b102/

SUMMARY

At The University of Akron in Ohio, I am pursuing an MS in Management with a focus on Business Analytics and Information Systems.

Demonstrated R, Oracle RDBMS, Oracle Data Modeler, MongoDB, SQL, Tableau, NoSQL and C# as a part of the MS curriculum and having hands-on experience in university projects. Implemented and executed a variety of machine learning techniques (Regression, Clustering, Decision Tree, Probability Networks, AI, Machine Learning, Neural Networks, Bayesian models etc.) in project assignments.

I have successfully completed one day workshop on Power BI tool organized by Microsoft. I can use Informatica PowerCenter tool for loading data from various sources like relational and flat files into target database or flat files.

Demonstrated various transformations in Informatica such as Expression, Joiner, Lookup, Router, Update Strategy, Union, Filter, Rank and Sorter.

I’m an advanced user of Microsoft Office Suite, including Word, Excel, and PowerPoint, as well as Notepad++.

I can devote myself to the development of an organization while working as a graduate assistant at the University of Akron in Ohio.

Will be graduating by summer 2023 and am currently looking for internship/full time opportunities as BI developer, Data Engineer, Data Scientist and Data Analytics roles. In the past I have accomplished 6 months of Internship as Business intelligence developer in nStigate technologies pvt. limited.

I have demonstrated my SQL expertise to analyze and optimize existing complex SQL queries to increase performance.

I can develop, and unit test the code based on requirements. As a technology enthusiast and love to work with programming languages such as R, Python, and SQL, PL/SQL for building and analyzing data and its patterns and visualization in Tableau reporting. Experience of working on Python libraries such as Pandas, NumPy, Matplotlib with structured data sets. 2 years’ experience of working in the IT industry with strong background in data analytics and data visualization using Tableau and Oracle database management system. I have always ensured that my project deliverables are on time and of high quality. I have worked in agile projects that adapt to fast paced changes in business requirements and delivery. Have good problem-solving capabilities, a focus on teamwork and achieving team goals, a result- oriented approach, and strong communication skills.

.

TECHNICAL SKILLS

● BI Reporting tool: Tableau, PowerBI

● Databases: Oracle database management system, SQL server, MongoDB, PostgreSQL, NoSQL

● Language: SQL, Java, Python 3, R, PL/SQL

● Python libraries: Pandas, NumPy, Matplotlib

● Data modeling: Oracle data modeler. Physical modeling, logical modeling, dimensional modeling

(star schema, snow-flake schema)

● ETL: Informatica PowerCenter

● Cloud technology: Fundamentals of AWS and Azure.

● Tickets and status tracking system: Jira, Confluence, Version one, HP ALM

● Scrum agile experience and Software development life cycle. 2

PROFESSIONAL EXPERIENCE

ThinkBank Solutions, Pune, India 08/2016 – 09/2018 Project #1: Bank of Maharashtra (Investment and brokerage) Role: BI developer

Description:

Bank of Maharashtra Investments is a data warehouse project for all the investments data such as holdings, brokerages, employees to client relations, commission etc. Bank receives data from various database sources such as oracle, flat files etc. and ETL team stores it into facts and dimension tables. We process data and publish it onto Tableau dashboard based on performance metrics defined. These reports help business to know how banks’ Investments products are performing and assess them against the projections and targets.

Responsibilities:

● To work on user stories assigned to me as a part of sprint deliveries. Also work with business teams to understand the requirements.

● Create Tableau worksheets as per the business requirements and business metrics.

● Connects Tableau to Oracle database and flat files to pull data and generate reports.

● Involved in dimensional modeling, table creation, metadata management etc.

● Involved in performance tuning of SQL queries by leveraging SQL knowledge.

.

EDUCATION

2022-01 – Master of Science: Business Analytics &

Current

Information System

The University of Akron - Akron, OH

2014-07 - Master of Science: Computer Science

2016-06

S.P. College - Pune, India

2011-08 - Bachelor of Science: Computer Science

2014-06

Dayanand College - Solapur, India

Contact this candidate