CHETAN DHOKE

Client: Lowe's

Technologies: SQL, PySpark, SQL Server, MySQL, Power BI, AWS, Python, Databricks, Pandas, Azure DevOps, and GIT.

Description: The second-largest home improvement and hardware chain in the United States, Lowe's has more than 2,000 stores throughout the country. Lowe's sells a wide array of construction materials, furniture, home and garden equipment, and tools online through its e-commerce platform.

Roles and Responsibilities:

• Understand and analyze customer requirements and business logic.
• Acquiring data from primary or secondary data sources, and maintaining databases.
• Validating raw data quality and transforming the data using SQL.
• Create, design, develop, and test a data pipeline by using Databricks.
• Coordinate with various technical and functional teams to implement and monitor results.
• Data understanding and process formation from the client.
• Perform tasks like data extraction, connecting to databases, and performing SQL queries.
• Perform operations such as data processing, data extraction, data ingestion, and data validation.
• Used AWS services to perform data ingestion.
• Perform operations on CSV and Excel files, such as merging, concatenation, and data cleaning.
• Cross-functional work with different teams.
• Numerous discussions with the Operations team helped me understand the process of work done.
• Involved in client interaction to sort out requirement issues.
• Participate in daily scrum calls.
• Create the report and share it with top management.

Data Engineer

Tata Consultancy Services

Client: Aetna

Technologies: Python, EDA, NumPy, Matplotlib, Pandas

Description: Aetna is a healthcare company that offers a variety of health insurance products and services. Aetna’s product offerings include healthcare plans, dental plans, vision plans, and more. Aetna also offers a variety of health insurance products and services for individuals, families, and businesses. Aetna’s products and services are available through a variety of channels, including the Aetna website, healthcare providers, and insurance agents. Aetna is headquartered in Hartford, Connecticut.

Roles and Responsibilities:

• Search for ways to get new data sources, and assess their accuracy
• Extract data and browse enterprise databases to simplify and improve product development, marketing techniques, and business processes.
• Perform exploratory data analysis on data to pinpoint trends and find patterns.
• Involved in the design and preparation of call flows with usability services.
• Improve the functionality of existing systems by understanding the existing code.
• Identify, analyze, and interpret trends or patterns in complex data sets.