Trupti P. Profile

EXPLORAR

0,0

(0 comentarios)

Ahora estás siguiendo a

Error al seguir a usuario.

Este usuario no permite que los usuarios lo sigan.

Ya estás siguiendo a este usuario.

Tu plan de membresía solo permite 0 seguimientos. Mejora tu membresía aquí.

Dejaste de seguir correctamente a

Error al dejar de seguir al usuario.

Has recomendado exitosamente a

Error al recomendar al usuario.

Algo salió mal. Por favor, actualiza la página e intenta de nuevo.

Email verificado correctamente.

$15 USD / hora

pune,

india

$15 USD / hora

Aquí son las 8:01 p. m.

Se unió el febrero 16, 2016

0 recomendaciones

Trupti P.

@trumayurp

0,0

(0 comentarios)

0,0

$15 USD / hora

pune,

india

$15 USD / hora

N/A

Trabajos finalizados

N/A

Dentro del presupuesto

N/A

A tiempo

N/A

Tasa de recontratación

Project Coordinator

I am very much interested to work with this requirement as i have 8+ yrs of experience in Excel VBA and scrapping projects(Open the websites and scrap the data as per clients requirements and format that data and provide to clients) and provide good quality work. I have created so many scraping projects from various websites. Recently i have created the macros for the creating folder,copying and pasting the files from one location to another, open the excel files and copy paste the data with perfect header with formatting with providing the status of the work. ex. while pasting the data DATE should be in fix format. etc. I am also using selenium, iMacros, regex etc. tools for data scraping. I am working as a Service Data Analyst in Cummins Inc. in VBA Excel Macros, Excel formulas like Vlookup, Hlookup, Pivot Tables,Grouping, What if analysis, Data Validation, Naming, Sorting, Filtering etc.I have extract data for "[login to view URL]","[login to view URL]", "Linkedin - Profiles","Facebook" etc.

Ver todo Data Processing Executives en India

Contacta Trupti P. sobre tu trabajo

Inicia sesión para comentar cualquier detalle por chat.

Portafolio

In Zocdoc Website, I scrap the Link, Department, and other contact details. And I achieved my goal to provide the client with satisfaction with the job.

Data Extraction

Create the automated file from manual entry.

Copy Paste data and Create folder with excel macros

Open the websites and scrap the data as per clients requirements and format that data and provide to clients

Web Scraping

I have created this tool which will check the data whether it is as per the standard list or not. If it is not then It will write the error message in specific columns as per the row data. It will also match the data with the database data and provides its output. Macro will connect with the Oracle database and display the data in an excel file and then check the data.

Audit File prepared with Macro

I have created the dashboard for Service data of Yearly, Monthly and Weekly by using formulas. Based on the formula values, the charts are also created which will help us to understand more.

Service Data Dashboard

Data Extraction

Copy Paste data and Create folder with excel macros

Web Scraping

Audit File prepared with Macro

Service Data Dashboard

Comentarios

Cambios guardados

¡No hay comentarios para ver aquí!

Experiencia

Automotive Company

sept 2016 - Presente

I am working as a data analyst, managing databases, creating macros in VBA excel as needed. - Check data quality and update/upload the data as per requirement in the Service database i.e. CCIMS (Customer care information management system). - Develop automation tools using excel VBA macros - Check data for warranty claims and upload that data into the database for worldwide CTT- OEMs. - Manage Remedy Tickets to solve the issues.

E-Procurement Technologies ltd.

jul 2015 - jun 2016 (11 meses, 1 día)

- Data Analysis, Mining - Crawl data using visual web ripper software - Check data in SQL Server, Mapping data and made effectives changes in data through queries. - Create SP as per requirement. - Check day to day crawled data quality and enhance the queries.

X-Byte Technologies

abr 2015 - jun 2016 (1 año, 2 meses)

- Data Mining - Extracting data from site using Macro and IOpus as per Client requirement - Prepare Reports - Help the team with Technical documentation - Effective Customer Interaction and co-ordination of development activities - Developing reports using Crystal Reports. - Run Macros using Selenium code in VBA and Excel VBA Code to fetch data from site and scrap that data according to client requirement.