Database
Below are examples of a few projects where I developed or utilized Databases:
-
Entergy - Reporting Views Data Architecture, PeopleSoft tables, SQL and Access Database
-
Orchard Supply Hardware– Reporting Views, SQL Server, and Access Database
-
Pacific Gas & Electric – SAP Tables, SQL Server, & Access Database
-
Walmart eCommerce – Access Database
-
University of California, Berkeley – PostgreSQL, SQLite, MongoDB, and AWS RDS
Latest Projects
SAMPLE 1: Entity Relationship Diagram (ERD) and SQL to create table
The ERD diagram show Human Resources schema for Pewlett-Hackard employees with the underlying relationship between various tables. The primary and foreign keys in between employee tables help link attributes between the tables. You can view SQL script that created the underlying tables.
SAMPLE 2: SQL Queries
Structured Query Language (SQL) is utilized to manage the information stored in the databases. The SQL script utilizes "SELECT INTO" statement to extract information from multiple tables into a new table with the help of an inner join. "Where" clause was to filter records, "Group By" to aggregate function(s) i.e. COUNT, and "Order By" to sort the table.
SAMPLE 3: Data Wrangling & Database Integration
Data Wrangling is the process by which the data is identified, extracted, cleaned and integrated, to yield a data set that is suitable for exploration and analysis. Although there are many techniques to Extract, Transform and Load (ETL), they often require manual work from technical and domain experts at different stages of the process. When confronted with the 4 V’s of big data (volume, velocity, variety and veracity), manual intervention can be expensive.
In Movies-ETL sample project, I downloaded movies data from Kaggle website, utilized Python to perform data wrangling and then connected Jupyter notebooks to PostgreSQL (PgAdmin) & AWS RDS databases to enable online information sharing.
Database Connections
Click on Icon to view Git Hub
Click on Icon for Python Code
LinkedIn Recommendations
“Vick brings a wealth of financial and business knowledge onto any team he is a part of. During his time as a student at UC-Berkeley Extension, he excelled at picking up programming fundamentals, and turning them into insightful analytics projects. He has a thirst for learning, and the unique talent of applying that new information quickly. Which is invaluable in a fast-paced work environment. Using his business and finance intuition, he was able to use Python and SQL to wrangle large datasets, recognize patterns, and make key business decisions. I would be delighted to have Vick as a member of any of my data teams. He's truly an asset and great teammate”
-- Ryan Norman I UC Berkeley Bootcamp Instructor |
“Vick Anand has worked on my team and I highly recommend him. He is a dedicated, talented individual and his analytical and project skills have been instrumental in enabling our team to exceed goals every year. He brings skills both in his ability to manage complex projects and the performance of financial analytics in an environment of multiple systems. He relates to the team, clients and executives with skill and is a valued team member in all aspects”
-- Linda Winter I Director Corporate Services at PG&E |