Data Analyst

Nalini Bhat

Page * of *

Nalini Bhat

Ph: +91-973**-*****

Mail: ********@*****.***

Brief Overview

• Over 13 years of experience in Data Analysis, Data Visualization and Business Intelligence technologies.

• Experience as scrum master and managing projects using Agile methodology.

• Experience in Data Warehouse development, Implementation, Testing and Maintenance.

• Hands on experience in data science and machine learning algorithms.

• Hands on experience in Python & R coding.

• Domain Knowledge: - Aviation, Finance and Sales.

• Excellent oral & written communication skills, with good leadership qualities. Key Technical Skills

• Data Analytics: - Spotfire, Business Objects Enterprise 5/ XI 3.1, Informatica 7/8/9, Python and R

• Data Modeling tool: Erwin

• Database: MongoDB, Green plum, Oracle, Teradata

• Languages: Python, R, PL/SQL

• Agile tools: - Rally, Jira

Professional Certifications

• Nanodegree in Data Analyst, Dec 2015, Udacity Online University

• Informatica Administration & Architecture, Aug 2011

• Informatica Power Center Designer, Nov 2009

• Six Sigma / GB Certification, Nov 2006

Employment Summary

Organization Period Last Designation

GE India Pvt. Ltd. Mar 2014 – May-2018 IT Data Architect Thomson Reuters July 2008 – May 2013 Senior Software Engineer Tata Consultancy Services Ltd. Sep 2005 – July 2008 IT Analyst Professional Qualifications

Degree and Date Institute Major and Specialization Bachelor of Engineering

(2001 – 2005)

K.J. Somaiya College Of Engineering, Mumbai

University

Information Technology

Experience Summary

Role Project Manager / IT Data Architect, GE India Pvt Ltd. (Aviation division) Period

Projects

Mar 2014 – May-2018

Material Analytics: - Maintain a denormalized data warehouse which stores Materials related data & build visualization that helps business in viewing the performance in terms of revenue generated out of material sales & repair.

Customized Service Agreement: - Develop & maintain a warehouse of data related to CSA agreements & build reports that help business view CSA contract performance. Nalini Bhat

Page 2 of 2

Fleet Service Utility: - Develop & maintain a Datamart which facilitates billing. Deal Evaluation Tool: - Develop an end to end solution to help finance team evaluate a deal before finalizing it.

Responsibilities • Interact with business and end users to understand the problem statement & identify pain areas.

• Convert the business requirement into a format that is understood by IT team.

• Help business write good user stories & track team’s day to day activities on Agile tool :- Rally.

• Communicate with team on day to day basis to resolve issues faced during development & guide them with business domain knowledge.

• Data profiling & making decisions on best versions of valid data.

• Design transformation rules for raw data, so that it can be utilized by business.

• Review the developed product like ETL mappings, reports developed by team before presenting to business.

• Guide team in tuning performance of reports.

Tools &

Technology

Informatica, PL\SQL Developer, Erwin, Green plum database, Oracle, Teradata, Spotfire, Agile tool:- Rally. Role Team Lead, Thomson Reuters Pvt. Ltd.

Period

Projects

Mar 2011 – May 2013 (Projects: - Eikon Migration, CRM) Eikon Migration: - This is an enhancement project done for Thomson Reuters (TR). After Thomson and Reuters got merged, they are moving towards common platform (This Project is called as Eikon Migration) for all their financial and media products. Eikon migration reports are built using Business Objects XI 3.1. Integration of the migration data is done through Informatica. CRM Reporting: - This is an enhancement project done for Thomson Reuters. In this project new feature to added to the existing data warehouse

Responsibilities • Requirement gathering and analysis, Estimation, Design.

• Development of ETL Process, Business Objects Universe and reports.

• Impact Analysis of blending data from SAP with the existing reporting system

• Review team’s code prior to sprint review with business analyst.

• Reconciliation of finance data between SAP and Reporting system

• Release of the new solution into production and post release production support.

•

Tools &

Technology

Informatica 9.1.0 and Business Objects XI 3.1

Role Team / BI Lead, Developer, Tata Consultancy Services, worked for Aviation Projects. Period Sep 2005 – Jul 2008 (Multiple Projects)

Description • Analysis of existing system, ETL & report development.

• Development of Data Warehouse from scratch using Informatica

• Development of Oracle schema using ERWIN & integrating it with existing systems

• Flexible, user friendly report development using Cognos Reportnet

• Development of Complicated File structures using Informatica & UNIX scripting

• Six Sigma Process implementations to improve the performance of the entire system. Tools &

Technology

Informatica, Cognos Reportnet, Erwin, PL\SQL Developer

Contact this candidate