Udit Agrawal Email & Phone Number

Dallas, Tx, Us

Melbourne, Florida, Us

Melbourne, Florida, Us

•Loaded query log JSONs from AWS S3 to Snowflake using Snowpipe, and flattened semi-structured data using SnowSQL.•Developed Python auto-enable tokenization script to enhance efficiency, reducing data processing time by up to 40%.•Implemented Python-based stored procedure to manage Snowflake object tags compliant with ALTR’s data masking standards.•Leveraged Snowflake's SECRETS store for enhanced API key and secret management, bolstering data protection in integration.•Utilized AWS Glue for daily crawler runs, thereby automating the extraction of schema and structured information from S3 bucket into AWS Athena reducing manual creation of tables and helps in dynamic updates.•Collaborated with data scientists, product managers and data governance team to fulfill the need for a flattened data structure, subsequently transforming the data for anomaly analysis.•Led Apache Airflow PoC for ETL, extracting real-time weather data from OpenWeather API and loading it into S3 via EC2.•Enhanced model accuracy by 82%, reducing MAPE, through in-depth dataset analysis and deploying an ARIMA model for forecasting targeted database column usage.•Utilized advanced techniques for extracting, cleaning, and analyzing diverse structured and unstructured data sources.•Spearheaded a tableau analytical storyline for query audit logs, tracking columns and database usage by user roles, revealing insights on the most active users across four U.S. time zones within 24 hours.•Crafted an insightful AWS Quicksight dashboard dedicated to monitoring the usability of ALTR's product among customers.

Richardson, Texas, Us

● Excellent customer service.● Providing excellent facility management.● Providing training to the new employees and making them aware of the UREC responsibilities.

Charlotte, Us

• Provided exceptional food service.• Ensuring a positive dining experience.• Skilled in maintaining cleanliness and resolving customer inquiries.• Strong teamwork and communication skills.

Mumbai, Maharashtra, In

• Led a $74.50 Million irrigation project, oversaw day-to-day operations, and managed a cross-functional team of 40, thereby achieving a profit margin of $6.75 Million• Developed a time series forecasting machine learning (SARIMAX) model with an average MAPE of 13.4% to predict the project’s monthly sales value• Designed and developed the dashboards in Tableau to track the daily progress which helps management to take important project decisions• Performed data extraction and manipulation for any subsequent statistical analysis and modeling from the database using SQL query to get insightful reports in PowerBI.

Mumbai, Maharashtra, In

• Recommended and presented the forecasted budget of $12 Million (FY 2019-2020) to the senior leadership team, achieving 90% utilization of the budgeted figures.• Analyzed the operational and progress data, performed applied decision optimization techniques on a look ahead plan, thus optimizing the cost reduction by 5%.• Created a cost analysis using previously approved Accepted Cost Estimates for the entire plan.

Mumbai, Maharashtra, In

- Preparation of daily progress report and further updating it to the client.- Delivering cost optimization solutions to the management.

Washington, Dc, Us

Being part of the American Society of Civil Engineers, India section brings enormous opportunities. International Civil Engineering Symposium (ICES’16), an initiative by ASCE-VIT in collaboration with the American Society of Civil Engineers India section and the School of Civil and Chemical Engineering of VIT University is the ultimate destination for civil engineers for the past 2 years with a participation of over 1000 students, professionals, researchers and faculties.

Mumbai, Maharashtra, In

The Piramal Agastya Business Park is a commercial project comprising 3 buildings, buildings A, building B and building C located at LBS Road Kamani, Kurla Mumbai. This project is located near the Mumbai International Airport.The Estimated Project Budget was 50.64 Million USD.

Master Of Science - Ms, Information Technology And Management

Bachelor’S Degree, Civil Engineering

Higher Secondary, Pcm