Close sidebar

Mitalee Bakare

Iit Mis Graduate, Data Warehouse Professional Having 7 Years Of Experience In Sql Development, Etl Designing, Data Modeling, Data Analytics, Reporting
  • Bangalore, Karnataka, India
  • Tableau, Business Intelligence, Data Warehousing
Profile Snapshot
Mitalee is based out of Bangalore & has studied MIS-Management Information System, MIT-Master of Information Technology from Year 2014-2016 in ISU-Illinois State University, Illinois State University.
Mitalee Bakare is Skilled in Tableau, Business Intelligence, Data Warehousing and other talents.
About
Experienced in providing end-to-end management over medium to large scale ETL and BI development. I have in-depth skills in Extract Transform and Transform(ETL), Data and Analytics, Microsoft Excel, Tableau and R. Throughout my career, I have demonstrated a strong ability to understand business needs, translate into technical solutions and deliver above expectations, enabled by excellent people, analytical, presentation, and communication skills.Highlights: Informatica,AWS,Tableau,Unix and Agile
Work Experience
Data Analyst
North Carolina Farm Bureau
Full Time Jul-2016 To Jul-2019 (3 years )
Responsibilities
  • My responsibilities included ETL system design, development, deployment and data analysis. The tools, technologies, and languages used in projects were iWay integration tools, complex SQL, IBM databases, Unix scripting, SAP BI and Tableau.

Software Engineer
John Deere
Full Time Jul-2011 To Dec-2014 (3 years 5 months)
Responsibilities
  • My responsibilities included ETL system design, development, deployment and data analysis. The tools, technologies, and languages used in projects were the Informatica PowerCenter, complex SQL, IBM databases, Unix scripting, and Tableau.

» 2 Projects


Amazon AWS based Cloud hosted web application for Image processing
Software Engineer at John Deere
Aug-2015 to Dec-2015
Amazon AWS based Cloud hosted web application for Image Processing: Developed thumbnail generator for images application (HTML, CSS and PHP) hosted in Amazon cloud using AWS – EC2, S3, RDS, SNS, Cloud Watch, ASG on the load balanced EC2 instances with original and processed images (sketches) stored in S3 bucket; email and phone notifications sent to the user after successful processing and enabled graceful degradation... more on Github link

Machine Knowledge Node Rearchitecture
Software Engineer at John Deere
Jan-2013 to Mar-2014
Functionality – This project re-engineered the process to store JDLink data (Modular Telematics Gateway sending machine health information). This data comprised of machine measurements, alerts, and events collected on a 24/7 basis. This process is a high-volume, “big data” batch cycle that can pass up to 200 million records a night. A new database node strategy was devised to allow machine data to be spread across multiple, smaller database instances. Single code multiple runs data model was enabled to migrate current Z/OS JDLink Data Warehouse and Mart to Netezza. Fully automated process with near to real time data leading to time reduction from 12-24 hours to four times daily execution. Redesign facilitated more than 50% performance improvement in the application. Highlights – Push Down Optimization, Netezza Bulk Writer, Netezza Geospatial Store, MSRMT_BASE - 60 billion records, Resource throttle, Dynamic creation of parameter file, one click report, Clone tables, Concurrent work
Education
Master of Information Technology
Illinois State UniversityIllinois State University
2014-2016 | Score 95%

Bachelor of Engineering
Cummins College of Engineering for Women PuneSavitribai Phule Pune University
2007-2011 | Score 65%
Extra-Curricular Interests
  • Dancing
  • Photography
  • Reading Books