Bhavin Rathod Email & Phone Number

Pune, Maharashtra, India

Pune, Maharashtra, India

Mumbai, Maharashtra, India

- Developing ETLs in Talend to meet wide range of data gathering requirements.- Gather and transform data from different sources like web, databases, excel files or any other source and present it in a particular way or format as required by end users.- Worked on complex and big projects on ETL development, creating data quality tools and connectors for one source to another, monitoring and maintaining them.- Developing reports and dashboards on Power BI having multiple data sources and also maintain them.- Also have strong knowledge working on SQL queries, APIs and Java.- Having global exposure working with teams and stakeholders around the global, understanding requirements and interacting with them on day-to-day basis.

Mumbai, Maharashtra, India

Involved in report design using Spago BI tool. Developing reports as per requirement using BIRT (Reporting Tool) in Spago BI, using various BIRT functions and tools to present the report as required. Developing complex SQL queries along with functions and procedures to retrieve data from database to display in the report and deploying it to the live servers. Creating data sources, data sets, roles, users and parameters on Spago server for the users to use and view the reports. Spago BI also includes development of dashboards, cockpits, KPI, etc.Integrating different databases into one in order to obtain consolidated database for ease for report making and designing using Talend intergration software. Directly inserting data into tables in database from different database or other files. Also using as a ETL tool and data migration.Using Tableau data visualization software to represent data in a graphical format in form of bar charts, maps, etc. and also preparing dashboards to display the same. This helps high level managers to get a snapshot of the company in terms of overall profits, sales, margins, production cost, etc.Preparing reports and dashboards and provide proper analysis of the data as required using tools like spreadsheets and BI tools. This involves proper planning of where and how to get data from database using SQL / PLSQL, data cleansing and then representing it as required, i.e., in graphical format like graph, charts or tabular form.Developing reports in Excel and Google Sheets, Familiar with Excel formulas, VLOOKUP, Pivot Table.

Mumbai, Maharashtra, India

Providing support for ERP application (OpenERP), mainly through back end using Postgresql database. Connecting to live servers, taking backups of databases, restoring the backups along with updating and deletion of records. Familiar with Linux commands as all the work is done in Linux OS using terminal. This ERP application includes various accounting modules required for making and keeping track of day to day transaction of invoices, receipts, payment details, contracts and customer details, stock management etc.Also, familiar with writing shell script and scheduling the same in crontab in Linux. Replication of databases using PostgreSQL replication and maintaining the same on different server.Analysis and monitoring of databases to keep in check the consistency and reliability of data, so as serve the purpose of providing accurate and timely reports as required by top managers.Developed SQL functions to fetch data from different servers and database for the purpose of representing a consolidated report. This also includes SQL functions to store this data from different servers and database, into a single database on a server for faster retrieval of data which is updated/refreshed every day to get up to-date information whenever required.