Nalini Bhat, Developer in Bengaluru, Karnataka, India
Nalini is available for hire
Hire Nalini

Nalini Bhat

Verified Expert  in Engineering

Database Developer

Location
Bengaluru, Karnataka, India
Toptal Member Since
June 18, 2020

Nalini is a seasoned BI professional with 13 years of experience successfully working in the information technology and services industry. She specializes in designing and implementing databases and data warehouses, data visualizations, and data analytics. A few facts about Nalini: she knows how to make the most out of the Informatica PowerCenter tool, how to work productively on projects using the waterfall model and agile methodology, and she's a Udacity certified data scientist.

Availability

Part-time

Preferred Environment

R, Python, Erwin, Spotfire, TIBCO, SQL, Oracle, PL/SQL, Informatica PowerCenter

The most amazing...

...project I've designed and developed is a data warehouse for the sales team in an aviation global organization that helped boost sales by almost 30%.

Work Experience

Project Manager | IT Data Architect

2014 - 2018
General Electric
  • Maintained a data warehouse that stored materials related to data & build visualizations that helped the business to view the performance in terms of revenue generated out of material sales and repairs.
  • Developed and maintained a warehouse of data related to customized service agreements (CSA) and wrote reports that helped the business absorb CSA contract performance.
  • Developed an end-to-end solution to help the finance team evaluate a deal before finalizing it.
Technologies: Spotfire, Teradata, Oracle, Greenplum, Erwin, PL/SQL Developer, Informatica

Team Lead

2008 - 2013
Thomson Reuters Pvt. Ltd
  • Helped the Thomson and Reuters merge, as they were moving towards a common platform for all their financial and media products by integrating the migration data through Informatica.
  • Worked on an enhancement project done for Thomson Reuters by adding new features to an existing data warehouse.
  • Interacted with the business analyst, understood the requirements, and prepared a technical specification document for the team to develop and release in phases (sprints).
Technologies: SAP BusinessObjects (BO), Informatica

Team and BI Lead | Developer

2005 - 2008
Tata Consultancy Services
  • Built a data warehouse to track personal computer vulnerability and wrote reports on it.
  • Developed complicated file structures using Informatica and Unix scripting.
  • Implemented Six Sigma process to improve the performance of the entire system.
Technologies: PL/SQL Developer, Erwin, Cognos ReportNet, Informatica

Material Analytics

Material Analytics is an end-to-end solution to help the sales team boost their revenue by increasing the number. of sales and repair orders. I worked as the data warehouse designer and my team had developed and implemented it using Oracle, ETL tool—Informatica PowerCenter. We also built comprehensive dashboards Tibco Spotfire to enable the sales team to identify opportunities and compare various trends in sales across various shops. After the implementation of this project, sales revenue were increased by 30% which made it a huge success.

Fleet Service Utility

I developed and maintained a data mart that facilitates billing based on engine cycles. The project was aimed to automate the process of collecting engine data from customers and billing them on a monthly basis. The challenge here was to maintain a master database for engines because customer data had engine names that did not confirm to standard naming conventions. A master database was built in order to resolve this.

Customized Service Agreement (CSA)

I developed and maintained a warehouse of data related to CSA agreements and built reports that help businesses view CSA contract performance. Several key metrics like revenue, cost, profit margin, service turn-around time, the amount of time spent at various stages of service, and so on were captured. Then appropriate dashboards were built to showcase the data to the business. This helped boost CSA sales by 20% every year.

Deal Evaluation Tool

I developed an end-to-end solution to help the finance team evaluate a deal before finalizing it. This project involved developing microservices for every task in the evaluation process. I also worked as a data architect for this tool.

Tools

Informatica PowerCenter, Tableau, Erwin, Spotfire, Cognos ReportNet

Paradigms

Database Design, Agile, Business Intelligence (BI)

Storage

Oracle PL/SQL, Microsoft SQL Server, PL/SQL, PL/SQL Developer, Greenplum, Teradata

Other

Data Warehouse Design, TIBCO Spotfire, TIBCO, Informatica, SAP BusinessObjects (BO)

Languages

Python 3, R, SQL, Python

Platforms

Oracle

2001 - 2005

Bachelor of Engineering Degree in Information Technology

KJ Somaiya Institute of Technology - Mumbai, India

AUGUST 2011 - PRESENT

Informatica Administration and Architecture

Informatica

NOVEMBER 2009 - PRESENT

Informatica PowerCenter Designer

Informatica

DECEMBER 2005 - PRESENT

Nanodegree in Data Analysis

Udacity

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring