Trupti P. Profile

EXPLORE

0.0

(0 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$15 USD / hour

pune,

india

$15 USD / hour

It's currently 12:26 AM here

Joined February 16, 2016

0 Recommendations

Trupti P.

@trumayurp

0.0

(0 reviews)

0.0

$15 USD / hour

pune,

india

$15 USD / hour

N/A

Jobs Completed

N/A

On Budget

N/A

On Time

N/A

Repeat Hire Rate

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.

See all Data Processing Executives in India

Contact Trupti P. about your job

Portfolio

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

Reviews

Changes saved

No reviews to see here!

Experience

Automotive Company

Sep 2016 - Present

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 months, 1 day)

- 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

Apr 2015 - Jun 2016 (1 year, 2 months)

- 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.