Data Engineering Intern Resume San Ramon, CA - Hire IT People

PROFESSIONAL EXPERIENCE

Data Engineering Intern

Confidential, San Ramon, CA

Responsibilities:

Designed and implemented highly scalable data warehouse as a central repository on GCP for business intelligence and analytical solutions.
Built new ETL packages using Python and Talend Big Data Integration tool. New packages included detailed workflow of data imports from NetSuite ERP system.
Managed Google Big Query instance on Compute Engine, using Google Data Prep, Google storage as a staging platform. Deployed the application on Google Cloud Function.
Optimized SQL queries and wrote custom views to create rich interactive Tableau reports, assisting in implementation of dynamic pricing strategy across multiple clients.
Analyzed and interpreted internal/external data to identify the KPIs for targeted marketing and make recommendations on product assortment, shelf placement and competitive trends.
Created dynamic dashboard for senior stakeholders, assisting them in data driven decisions that reduced overall operating cost by 23%.

Data Engineering Intern

Confidential, Palo Alto, CA

Responsibilities:

Created data models, solution designs and managed data architecture documentation for cloud - based menu recommendation system.
Engineered data warehouse solution on AWS Redshift wif S3 as the data lake, thus automating the complete process of menu creation on front end.
Orchestrated ETL pipeline to structure, transform and cleanse website data and data from PostgreSQL, using Python and SparkSQL.
Leveraged cloud technologies such as AWS Lambda for triggering and EC2 to deploy the application.
Experienced wif installation ofAWSCLI to control variousAWSservices through SHELL/BASH scripting.
Worked in an agile test-driven-development environment using tools like Git, Zube, Docker and Circle CI to achieve continuous integration, continuous deployment.

Technology Consultant

Confidential

Responsibilities:

Spearheaded multiple rounds of commercial room pilot wif stakeholders in a B2B environment to capture requirement and demo design functionality prior to network and data migration.
Having experienced in Agile Methodologies, Scrum stories and sprints experience in aPythonbased environment, along wif data analytics, data wrangling and Excel data extracts.
Developed SQL scripts to fetch network compliance data and created a weekly audit report for senior leadership.
Performed quantitative analysis and provided recommendations on customer complaint date for MIS domainusing MS SQL and Tableau which improved customer satisfaction index by 6%.

Data Analyst

Confidential

Responsibilities:

Analyzed data sheets, design layouts, specifications, and general business process design.
Used SQL join statement and stored procedures extensively to fetchdatafrom MS SQL database.

Confidential

Advanced Business Intelligence

Responsibilities:

Predictive analytics technique used to assess customer’s brand loyalty after analyzing their behavioral and demographic data. Leveraged tools like Base SAS, Qlikview to perform survival analysis and suggest customer retention methods.

TECHNICAL SKILLS

Certifications: Google Analytics, BASE SAS Data Mining and BI, Six Sigma Green Belt

Technical Tools: Talend, Tableau, Qlikview, Docker, Bugsnag, LogDNA, MS Visio, MS Excel

Languages: SQL, Python, Spark, R, Base SAS, Version Control Git, Shell Scripting

Cloud: AWS, GCP (Compute Engine, Data Prep, Cloud SQL, Big Query)

Database: MS SQL Server, PostgreSQL, Oracle

Analytical Skills: Linear & Logistic Regression, Statistical Analysis, A/B Testing, Hypothesis Testing, Correlation Analysis

Project Management: Zube, MS Project, Agile/SCRUM, Requirement Gathering & Analysis, SDLC