Database Optimization for 131 Million Database

$30-250 USD

Terminado

Publicado

hace 6 meses

$30-250 USD

Pagado a la entrega

I have 131 million business emails and LinkedIn profiles database but there is no company website and no zip code. GOAL: Create a website column by simply taking the domain name from the emails addresses column. Example EMAIL ADDREES IS: AL @ [login to view URL] You would create the website URL : [login to view URL] EXCEPT when the business employee is using an email addresses: (Gmail, Yahoo, AOL, MSN, OUTLOOK, Hotmail, Live, ) Just skip those and don't add [login to view URL] to the website URL column. PART 2 of the project: The database does not have zip codes but it does have the USA City Name and the USA State. I will give you a csv file that is a database file of all USA ZIP CODES and it has the Name of the CITY and State. Just use the first zip code. Some cities will only have 1 zip code so use that one. You will search the City and State pairs and the first zip code can be used. Many cities will have more than one zip code. So if you see: CITY: Newark State New Jersey (NJ) There will be many zip codes in Newark, NJ you can use the first zip code. Note: Many zip codes in the North East have a leading zero that gets truncated when you open the csv file. So those leading zero zips need to be quoted. PART 3 There are data rows with 2 phone numbers in a field. There is a comma after the first phone number. Just delete the second phone number and use the first The project needs to be done on your server not ours as we do not have the resources to do this project I have uploaded a sample of the data fields We do not mind if the winner of the bid uses the data to get new jobs. You are welcome to it, We just need the project done as soon as possible.

ID del proyecto: 38364766

Información sobre el proyecto

26 propuestas

Proyecto remoto

Activo hace 6 meses

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@DavidLindon

All 3 parts sound straight forward. I aim to turn it around in 24 hours. I will write a custom script to manipulate the CSV file.

$50 USD en 2 días

5,0

(14 comentarios)

5,2

26 freelancers están ofertando un promedio de $619 USD por este trabajo

@AnjaliMehta

Hi There! I have understood the requirements for the task. I have 6+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tables, and excel based formulas. My expertise is broad and versatile and includes: *Microsoft Excel- Advance formulas -VBA/Macros -Dashboard -Data Analysis -Web-Scraping and Data Entry. *Adobe Acrobat-Fillable forms -Editing and Scripting. *Google Sheets-Advance formulas -Custom Scripts -Dashboard I am Proficient in Microsoft Excel, Adobe CS & CC Photoshop, Illustrator, InDesign, Adobe Acrobat and Google Sheets, and Wordpress I am waiting for a response from your side. Thanks

$150 USD en 3 días

5,0

(11 comentarios)

5,7

@Umerfarooq92912

As a seasoned professional in Data Entry and Data Processing, I am confident in my ability to tackle this project with precision and efficiency. I understand the value of your immense database of business emails and LinkedIn profiles, and the need to accurately extract relevant information such as website URLs, city, state, and zip codes. My experience equips me to swiftly handle diverse aspects of data processing- whether it's manipulating raw data to create a neat website URL by extracting domain names or identifying the first relevant zip code for each city and state pair. It is worth mentioning that I have extensive knowledge in Relational Databases, which will aid me in managing and optimizing your database with care, ensuring an accurate and efficient outcome for each step of the process. Moreover, given the scale of your project, my 24-7 availability will enable swift completion while ensuring meticulous attention to detail. In conclusion, choosing me will grant you access to a reliable individual dedicated to delivering highly accurate work within given deadlines. My skills in data processing span beyond just extraction; I'm specialized in data entry, web research, CRM management - providing an expansive skill set poised to maximize the value of your database. I'd be honored to be part of your team bringing this project to fruition. Feeling confident in my ability to execute your project meticulously!

$200 USD en 3 días

4,9

(64 comentarios)

5,7

@kundansql

Hi, I've carefully checked the attached CSV file and understand the requirements as per the project description. I can successfully complete this project using SQL Server and PowerShell. Please feel free to reach out if you've any questions or would like to move forward. Warm regards, Kundan

$150 USD en 2 días

5,0

(11 comentarios)

4,2

@hemsingh1

Python, Pandas, Numpy, data analysis skilled professional with over 5 years of experience. Can build a solution as needed and deliver on the expected lines. Thanks

$12.000 USD en 30 días

5,0

(13 comentarios)

4,0

@Jaaniiii

Got you. I Checked your sample database. I am ready to start right now.

$39 USD en 1 día

5,0

(14 comentarios)

3,8

@Awais0507

I have developed exceptional skills in automating processes and extracting valuable insights from extensive datasets. Your project aligns perfectly with my expertise; the task of creating a website column by extracting domain names from the email addresses can be efficiently achieved using my proficiency in Python, Pandas, and Dataframes. I assure you fast work without compromising quality. In terms of PART 2, associating city names with their respective zip codes can be done seamlessly since I'm well-versed in working with large databases like the one provided. By leveraging my ability to handle complex projects, rest assured that each city will be assigned an accurate zip code. PART 3 involving phone numbers is a relatively simpler task for me. With sound knowledge of Excel and precise attention to detail, I'll successfully remove any additional digits after the comma while retaining vital information. Lastly, it's worth mentioning that I have a dedicated server which is ideal for carrying out your project's scale effectively. Additionally, given the nature of your project, you can trust my thoroughness with data privacy and security. Let's embark on this data-driven journey together, transforming this massive database into valuable actionable insights!

$100 USD en 2 días

5,0

(5 comentarios)

2,3

@chandandubey

As an experienced software engineer with a passion for database management, I'm confident in my ability to tackle your project head-on. Throughout my 9 years in the industry, I've honed exceptional skills in PHP, AWS, and Laravel -- tools that are at the core of what can be a highly technical project like yours. I understand the complexities involved and guarantee to maximize efficiency while ensuring impeccable outputs that perfectly meet your needs. In addition to my technical prowess, I also bring strong analytical skills to the table. The task of creating the website URLs from 131 million email addresses may seem daunting but with my systematic approach and attention to detail, I see more than just random strings but a holistic picture of business identities. The same goes for handling missing zip codes and multiple phone numbers which I promise to solve accurately and efficiently. Lastly, I understand the value of time especially when managing big datasets. This is why I ensure constant and clear communication with my clients throughout project duration. Using your server for this task should not be a hiccup either as I am comfortable working on any clouds. With me, you'll get not only top-notch results but also fast and punctual delivery that won't disrupt your operations. Let's turn those raw data into Make-to-Market Business Insights!

$140 USD en 7 días

5,0

(4 comentarios)

2,5

@elhadfi

Hey there, I am a data engineer with over 5 years of experience. I will assist you in enriching your database by generating website URLs, adding ZIP codes, and cleaning phone numbers. My expertise includes: Data parsing and cleaning Database management Scripting and automation I will ensure accurate website URLs by extracting domains from email addresses while skipping common email providers. I will then match city and state pairs to ZIP codes from your provided CSV file, taking care of leading zeros. Finally, I will clean the phone number field by retaining only the first number. With my experience, I’m sure I can finish this task in a very short time, assuring the expected results. Feel free to check my profile and contact me for more details. Regards,

$140 USD en 3 días

5,0

(2 comentarios)

1,6

@Mijanur7652

Hello, With over 2 years as a data entry operator, I’ve encountered and resolved similar challenges to those presented in your project many times before. My proficiency in handling large datasets and optimizing efficiency will be key assets in completing this task effectively. Additionally, my advanced skills in Data Processing and Excel Macros give me an edge when manipulating and organizing data. I understand the importance of precision and spot-on execution in a project of this scale. Thanks to my typing speed of over 40WPM with absolute accuracy, I can guarantee quick yet error-free results. My comprehension of Microsoft software, including Excel, will facilitate the creation of website columns from email addresses efficiently, considering domain exceptions. Furthermore, my experience in working on various projects like retailers’ database management and customer profiling has given me extensive knowledge about mapping zip codes to cities and states for localized information enrichment like you require. Sifting through databases for the appropriate zip codes will not only be expedited but also done with due diligence as I double-check for any leading zero truncations often found in North East zip codes. Overall, by entrusting this project to me, you are setting it on a path to timely fruition without sacrificing quality. I am ready to commence now! Thank you

$30 USD en 5 días

5,0

(1 comentario)

1,0

@Eddiie420

<<<Dear client>>>, as a database expert, I can finish your job successfully. I have deep knowledges about SQL like MySQL, MSSQL, PostgreSQL and No-SQL link MongoDB, AWS-DynamoDB, FireStore, etc.. Before, I build many backend, database designs, and also created many large-scale queries. So I can easily many queries like Left Join, Right Join, Cross Join, Inner Join, etc.. I can optimize the queries, and also I can desing the database in high-optimization level. So I think I can be the one of the best candidate for this job. Hope to hear good news from you. Thank you

$140 USD en 2 días

0,0

(0 comentarios)

0,0

@ayesha0124

Hello, I believe i can help u with getting this job done as i have the great knowledge of Excel Macros, Relational Databases, Data Mining, Database Development and Data Processing. I have working experience of several years on this platform. So please initiate the chat to discuss with me in detail. Regards, Ayesha

$250 USD en 9 días

0,0

(0 comentarios)

0,0

@imandaneshi1

Hello, I can help you process your database by extracting domain names from email addresses to create website URLs, skipping non-business email domains. I'll match city and state pairs with a ZIP code database to fill in missing ZIP codes, ensuring leading zeros are preserved. Additionally, I'll clean up phone numbers by removing any secondary numbers after a comma. I will perform all processing on my server to ensure minimal disruption. I'm confident in delivering this project accurately and promptly. Best regards, Iman D.

$200 USD en 3 días

0,0

(0 comentarios)

0,0

@novakpetrovic

Hello, Need only 1 day. You will get good result in 1 day. After reviewing your job post, I understand what you want to achieve. Great! It's the best match for my skills and experience. I have enough experience of data processing and analytics using python. As a seasoned Python developer, I have over 5 years of expertise in developing quality software and leading backend development projects. I look forward to the opportunity to contribute to the success of your project and assure you of my commitment to delivering exceptional results. I hope to discuss your work. Thanks for your time.

$200 USD en 1 día

0,0

(0 comentarios)

0,0

@benjaminf7

Hi, how are you? Thank you for the opportunity to bid on your database enhancement project. I have extensive experience in data processing and web development and am confident in my ability to deliver the desired results efficiently and accurately. My timeline Days 1~2: Initial setup, data loading, and processing email addresses. Day 2: Zip code addition and validation. Day 3: Phone number cleaning and final data validation. Day 4: Quality assurance, documentation, and delivery. I look forward to the opportunity to work with you on this project. Please feel free to reach out with any questions or further details. Thank you for considering my bid. Best regrads, Benjamin.

$50 USD en 5 días

0,0

(0 comentarios)

0,0

@TechSolutionsBen

I'm very interested in your database processing project and I'm confident that my skills and experience will meet your needs perfectly. Here's how I can help: Domain Name Extraction: I will create a column with website URLs by extracting the domain name from business e-mail addresses, automatically excluding personal e-mail addresses (Gmail, Yahoo, etc.). Adding Zip Codes: I'll use your CSV file containing zip codes to match the correct cities and states to the first available zip codes, ensuring that the northeast zip codes are properly formatted. Phone Number Separation: I will process fields containing two phone numbers to separate them correctly, ensuring a clear and accurate presentation of the data. My methodical approach and attention to detail will ensure the accuracy and completeness of your database. What's more, I'll be working on my own server, avoiding any impact on your internal resources, and I'm committed to delivering the project in the shortest possible timeframe. I am available immediately to start this project and look forward to working with you to achieve your goals. Thank you for considering my application. With kind regards,

$170 USD en 7 días

0,0

(0 comentarios)

0,0

@Fammii1999

Greetings! I have thoroughly reviewed the job description and the attached CSV file. I grasp the project requirements completely and would like to propose my services as an experienced data management expert. With a keen eye for detail, I guarantee accurate data adjustments. Additionally, I am prepared to provide sample work for 1000 entries to facilitate your hiring decision. I commit to completing the project promptly and will provide updates after every 25,000 entries for your review. I eagerly await your response to discuss this opportunity further. Thank you!

$250 USD en 12 días

0,0

(0 comentarios)

0,0

@wrathleo20

I can write the websites as you mention according to the email, but I can verify them by searching for them on Google if you like, It won't take less than 18 hours to do the job. I only need the file you mentioned about the zip codes. wait for your message

$140 USD en 1 día

0,0

(0 comentarios)

0,0

@macf0107

Hi! Nice to meet you! I can help you with your project. Please see my profile and ping me a quick message. Regards!

$550 USD en 14 días

0,0

(0 comentarios)

0,0

@husseins5

Why not .. mining data , shaping , cleaning is one of my lovly jobs .. Let us begin u will have all what y wont

$140 USD en 7 días

0,0

(0 comentarios)

0,0

@rishabhrajora152

I have been working on excel and data for recon of derivatives product on excel which provides me exposure as well experience to complete this project with high efficiency and on time

$240 USD en 7 días