Geetanjali Dutta Email & Phone Number

Westlake Village, California, United States

Westlake Village, California, United States

Westlake Village, California, United States

Westlake Village, California, United States

Boston, Massachusetts, United States

INFO7290 Data Warehousing and Business Intelligence• Conducted one-on-one interaction sessions with students to review and grade assignments for a class of 35 students• Answered students’ questions and provided guidance on course-related topics viz., ETL, data modeling, data profiling, and data visualization• Bridged communication gap between Professor and the students

Greater Boston Area

INFO 6150 Web Designing and User Experience Engineering• Conducted one-on-one interaction sessions with students to review and grade assignments for a class of 76 students• Supervised lab sessions, delivered lab demos, and provided guidance in solving assignments and projects on course-related topics such as Javascript, JQuery, HTML, CSS, Node JS, Angular JS• Created and graded weekly, midterm, and final quizzes for the course

Greater Boston Area

• Implemented and supported enterprise-wide financial reporting and BI platform that is used to provide reporting solutions for both company internal use as well as for external client consumption using QlikView and QlikSense• Developed data pipelines by integrating data coming from different sources viz. SQL database, RESTful APIs, flat files, etc. • Fully automated laborious data handling in MS Excel by building Qlik apps, saving the work of up to 5 business days in case of quarter-end and annual reports• Furnished technical documentation, including Process Flow Diagrams, on functioning and usage of developed dashboards in QlikSense mobile/desktop app

Mumbai Area, India

Data Warehousing, ETL and BI Reporting• Gathered and combined large-scale data, coming from different sources (e.g. flat files, excel) representing confidential departmental as well as client data of the organization, using data warehousing concepts into a single database in MySQL• Wrote functions and stored procedures to retrieve specific information, reciprocating the business requirements, and represent them in the form of interactive dashboards using Tableau and Yellowfin that helped:i. Replacing about 80% of manual tasks of extracting reports using time-consuming ETL packages and tedious data manipulation in MS Excel ii. Members of Executive Committee of the organization to make important business decisions on the go • Developed and deployed ETL packages utilizing SSIS to load data from client server to local server to automate the process of loading data manually multiple flat files, excel sheets• Monitored and troubleshoot issues during running ETLs to generate various client reports with 99% accuracy

Airoli, Navi Mumbai

Data Warehousing, ETL and BI Reporting• Designed interfaces in SQL for migration of health insurance data from a mainframe based system to .Net based system• Created traditional paginated reports in SSRS for client consumption• Held responsibility for generating reconciliation reports after completion of every data migration cycle, depicting data from old system, new system, and the difference between them to provide business acumen• Aced Entry Level Training program in .Net with a 3rd rank nationally

Lower Parel, Mumbai

Software Testing Intern, Researched about the QA and software testing model of the company, making Powerpoint presentations for new recruits so that they could get introduced to the software testing techniques of the company, maintaining Excel Spreadsheets to check the integrity of client data.

Master Of Science - Ms, Management Information Systems, General, 3.84

Java, Python, Data Science, Database Management, Web Designing, Finance and Accounting, Business Analysis, Planning and Managing Projects.

Bachelor Of Engineering (B.E.), Electronics And Telecommunication, Distinction

First topper in Academics, Joint Technical Secretary of Student Body during 2012-13, General Secretary of Student Body during 2013-14.

High School, Distinction