ETL Developer

ANKITA GHADI

**** **** ******** **, *******, IL *0607 312-***-**** ******.*********@*****.***

SUMMARY

2+ years of industry experience of working with ETL tools, Hadoop Environment, shell scripting in Agile Methodology

Expertise in working with structured and unstructured databases – querying data, analyzing data, query optimization

Proficient knowledge in statistical analysis and with developing supervised and unsupervised learning models

Ability to work on challenging tasks and to automate the manual processes to make them more efficient to use

EDUCATION

Master of Science: Management in Information Systems University of Illinois at Chicago May 2018 GPA - 3.81/4.0

Bachelor of Engineering: Electronics & Telecommunication University of Mumbai May 2014 GPA - 3.25/4.0

SKILLS

Informatica Power center

Hadoop(HIVE, Spark)

Data Mining

Firebase

Drupal

Ab-Initio

R

Tableau

React Native

MS SharePoint 2013

SQL

Python

Java

Angular JS

Git

TERADATA/ORACLE

Microsoft Excel

Python

HTML5/CSS3

WORK EXPERIENCE

Graduate Assistant University of Illinois at Chicago, Illinois Sep 2017- Present

Maintained ‘Business Connect’ website in Drupal CMS, used by business school to introduce programs and faculty to students

Worked on Microsoft SharePoint projects to automate different tasks saving manual efforts for business managers and faculty

Created surveys in Qualtrics and made reports on responses received for different business requirements

Designed and developed database schemas to store business school student and faculty data

Created and managed Hadoop cluster environment using Ambari for students to work on their Capstone projects

Technology Analyst Barclays Technology Center India, Pune, India Sep 2014 - Dec 2016

Delivered more than 10 INFORMATICA projects with data sources like TERADATA, ORACLE, XMLs and Flat files

Supported development, testing and deployment of code in LIVE environment for multiple projects in Agile Methodology

Created JAVA hashing algorithm to secure money transactions for PINGIT application – used by around 2 Million customers

Worked with support team to fine-tune ETL jobs handling 2M customer data reducing time by 10-15% execution time

Built Ab-Initio models to execute Change Data Capture updates for Personal and Corporate banking customers

Was a part of migration process from TERADATA to HADOOP(Hive) for five major data sources

Built test case data automation process in JAVA to minimize unit testing efforts for developers by 3-4 hours per development

PROJECTS

Federal Employee Job Satisfaction Survey Principal Component Analysis, Logistic Regression in R

Examined how education level and tenure with Federal services impacts employees’ job satisfaction level by hypothesis testing

Built a regression model in R to learn various job satisfaction factors for 300,000 US Federal Employees in year 2014

Mortgage Loan Data Analysis MANOVA testing, Discriminant Analysis, Clustering

Carried out MANOVA testing and Linear Discriminant Analysis determining effect of demographic factors on loan applicants

Performed Clustering to get properties of target audience and then strategize for the new mortgage loan policies

US Airlines Data Visualization Tableau Visualization

Prepared data of 4500000 Delta flights operated in year 2016 collected from Bureau of Transportation Statistics website

Developed data visualization models in Tableau of overall Delta performance in year 2016 with other US airlines

Predicting Earning Manipulation by Indian Firms Decision trees, Random Forest in R

Studied Beneish model and decided the Manipulator score to identify potential earning manipulators for MCA technologies

Performed Decision trees and Random Forest modelling after balancing data by SMOTE and oversampling methods

Jitney Rider (Client: HBCU Ventures) IONIC, HTML5, CSS3, Angular JS4, Firebase, Stripe, Zapier

Collaborated with client and performed market research for ride sharing application complimenting public transit which will be launched in St. Louis and Detroit

Developed primary features to deliver MVP in IONIC framework with Firebase and Stripe/ Zapier as backend

New-to-world (Client: Mettlesports.com) React Native, Firebase

Analyzed the business requirement and consulted the technology stack for the mobile application

Provided the Sprint (Agile Methodology) plan for the application development

Designed and developed the initial two sprints in React Native with Firebase’s database and authentication modules

ACCOMPLISHMENTS

Won second prize in Student Expo competition at University of Illinois at Chicago for ‘Jitney Rider’

Received recognition as 'Employee of the month' from Barclays Western Europe team

Contact this candidate