Akash Mishra Email & Phone Number

Noida, Up, In

Hyderabad, Telangana, India

Data Integration:-Combine data from 10 different tables into a single, unified master table.-Ensure data consistency and accuracy during the integration process.SQL Query Optimization:-Utilize views and common table expressions (CTEs) to simplify complex SQL queries and improve performance.-Break down complex queries into smaller, more manageable parts for better readability and maintainability.Colab Script Development:-Create a Python script in Google Colaboratory to automate the process of reading data from multiple spreadsheets.-Implement efficient data extraction and transformation techniques to prepare the data for integration.Data Consolidation:-Merge the data from multiple spreadsheets into a single, unified spreadsheet.-Ensure data consistency and alignment between different sources.Data Validation and Cleaning:-Implement data validation checks to identify and correct errors or inconsistencies in the data.-Clean and preprocess the data to improve its quality and suitability for analysis.

Hyderabad, Telangana, India

Develop Python Script:-Create a Python script to handle data ingestion tasks, including:-Data extraction from various sources (e.g., csv files)Data transformation and cleaning:-Data loading into a target system like big queryCloud Function Deployment:-Deploy the Python script as a cloud function on a suitable platform (e.g., AWS Lambda, Google Cloud Functions, Azure Functions).-Configure the cloud function's triggers (e.g., time-based, event-driven) to automate the ingestion process.Data Ingestion Automation:-Automate the data ingestion pipeline by scheduling the cloud function to execute at regular intervals or in response to specific events.-Implement error handling and logging mechanisms to monitor the pipeline's health and troubleshoot issues.Version Control with Git:-Initialize a Git repository to track changes to the Python script and configuration files.-Commit code changes regularly with descriptive commit messages.-Use Git branches for feature development and bug fixes to maintain a clean and organized codebase.Configuration Management:-Store configuration settings (e.g., data source credentials, target system details) in external configuration files or environment variables.-Use Git to manage configuration files and track changes.Testing and Debugging:-Implement logging statements to track the execution flow and identify potential issues.-Use debugging tools to step through the code and inspect variables.Deployment and Monitoring:-Deploy the cloud function to the target environment and configure it to run automatically.-Monitor the cloud function's performance, logs, and error rates to ensure optimal operation.-Implement alerts and notifications for critical issues or failures.

Pune, Maharashtra, India

Google Analytics data insights and keyword optimization, Ad copy writing, bidding and cost per lead optimisation

Master Of Technology - Mtech, 9.65

B.Tech, 79.44%

Senior Secondary, Pcm, 87.6%

Activities and Societies: Debating and public speaking

Secondary, 9.6