Data Support Analyst

• May 2022 - Present

Computer Programmer

• Jan 2021 - Feb 2022

◦ Worked long time to develop and support the database. ◦ Worked on the development of database and creating functionality using excel. ◦ Developed mappings of Talend/SSIS to load data to staging tables and transactional tables from multiple source systems. ◦ After extraction of the data cleaning data using Power Query, creating pivot table and graphs on the same data. ◦ Presenting these reports using power point to the manager and analyzing the data. ◦ Designed reports and custom dashboards using Tableau/Power BI visualization tool. Involved in transforming the business and functional requirements into technical details. ◦ Assisted in designing and developing complex ETL structures for the transformation of data sources into data warehouses. ◦ Experience working with the Water Fall model as well as Agile Methodology using CI/CD Pipeline. Show less

Real time analyst

• Jan 2020 - Jun 2020

1. Creating daily reports on the performance of each team. 2. Daily reporting to the manager about the leads and its potential conversion into sales plus the completed sales for the day according to the teams and individual performances. 3. Training every team for the potential sales outcomes. 4. daily cleaning, transforming the data and uploading into database. 1. Creating daily reports on the performance of each team. 2. Daily reporting to the manager about the leads and its potential conversion into sales plus the completed sales for the day according to the teams and individual performances. 3. Training every team for the potential sales outcomes. 4. daily cleaning, transforming the data and uploading into database.

Computer Programmer

• Jan 2018 - Jun 2019

◦ Worked long time to develop and support the database. ◦ Worked on the development of database and creating functionality using excel. ◦ Developed mappings of Talend/SSIS to load data to staging tables and transactional tables from multiple source systems. ◦ After extraction of the data cleaning data using Power Query, creating pivot table and graphs on the same data. ◦ Presenting these reports using power point to the manager and analyzing the data. ◦ Designed reports and custom dashboards using Tableau/Power BI visualization tool. Involved in transforming the business and functional requirements into technical details. ◦ Assisted in designing and developing complex ETL structures for the transformation of data sources into data warehouses. ◦ Experience working with the Water Fall model as well as Agile Methodology using CI/CD Pipeline. Show less

Oracle Developer

• Jul 2014 - May 2015

◦ Created various database objects including Constraints, Indexes, Triggers, Cursors, sequences, and synonyms and modified existing codes, tables, and views. ◦ Validated data to ensure the quality, validity, and accuracy of the content. ◦ Developed queries to pull out the data from the different systems as input for the collection system. ◦ Developed PL/SQL stored procedures, triggers, functions, and packages for moving the data from staging areas to data marts. ◦ Collected, cleaned, and provided analyses of structured and unstructured data used for major business initiatives. ◦ Extensively used SQL stored procedure, indexes, and partitioning options to increase the performance of the database by 30-40%. Show less

Panchayat Samitee Alibag

• Jan 2012 - Feb 2014

◦ Using the preexisting database (MySQL) and Software (Java) to collect the data from an external source. ◦ Providing software training to the end users for entering the data properly into the database. ◦ After entering the data into the tab generating an encrypted file of the data and transferring it to the system using FTP connection. ◦ Decrypt the database file and load the data into the database. ◦ Once the data is in the database validate data to ensure the quality, validity, and accuracy of the content. ◦ Collected, cleaned, and provided analyses of structured and unstructured data used for major business initiatives. ◦ After cleaning the data, creating proper blocks of data and upload data files onto NIC website. Show less