Shantanu Gupta Email & Phone Number

Delhi, India

Melbourne, Victoria, Australia

Conducted in-depth investigation and resolution of issues in the MCC Plus rebate program, optimized SSISprocesses for accurate data integration and rebate application and provided knowledge transfer to managerswhile collaborating with them to fix the bug.• Managed end-to-end setup of SSIS data replication jobs to read from BigQuery and load into MCC’s SQL Server,ensuring accurate integration of survey data into the MCC environment.• Debugged and enhanced C# code by implementing two new functionalities: a retry mechanism and detailedcommenting. Additionally, integrated custom logic to optimize overall code performance

• Designed and developed a comprehensive geological database prototype tailored to the specific needs of OreFox, ensuring seamless integration with their existing platform. Designing and implementing database schemas and data models.• Created Entity-Relationship (E-R) diagrams modeled after the acQuire database structures and customized them according to project requirements. Created Postgres Tables, Views, Procedures based on the requirements.• Developed PostgreSQL tables, views, and stored procedures to support the geological data management and processing needs of the client.• Contributed to the design and development of the backend system of the application using Python and Django.

Melbourne, Victoria, Australia

EarthSQL- Database management services for the exploration and mining industry.✔Oversaw relational databases for various Earth SQL clients, including comprehensive management of the "Xtend" database product. Provided business users with database support, restoring functionality, documenting resolutions, and participating in on-call support rotation for non-standard work hours.✔Led end-to-end processes: designed, developed, and tested diverse running processes. Identified and resolved data and software errors independently. Designed Iinnovative solutions for streamlined workflows and to ensure data confidentiality, availability, and integrity. Developed and deployed ETL/ELT solutions. Streamlined workflows through automation, utilizing stored procedures, functions, and python scripts.✔Collaborated with clients and team members, ensuring seamless communication for project success. Addressed product concerns, efficiently handled adjustments, and reported progress as needed.✔Conducted advanced SQL database analysis, documented business requirements, and produced high-standard database solutions to meet clients’ requirements. Oversaw server and database security, aligning with company policies. Implemented handling for Authentication, Authorization, and Auditing.✔Expertly migrated diverse data sources, including Excel sheets, Access databases, SQL Server databases, and On-Premises data, to Microsoft Azure self-hosted databases.

Melbourne, Victoria, Australia

✔Developed forecasting models for the Emergency Service Telecommunications Authority (ESTA). Analyzed and implemented time series models to predict call volumes and emergency vehicle dispatches. Prepared project whitepapers documenting methodologies and outcomes.

Melbourne, Victoria, Australia

Sidekicker is a flexible staffing platform that connects businesses with skilled workers for short-term or temporary assignments.✔Completed 30 jobs as a Sidekicker in various roles, including Cleaner, BOH, FOH, Kitchen hand, Data Entry, Labour, and customer service.✔Maintained a profile rating of 4.8 out of 5, demonstrating consistent delivery of high-quality work and exceptional service.

Melbourne, Victoria, Australia

align.me is a leading B2B marketing agency, helping businesses build a growth-driven B2B sales and marketing plan.✔Build Management Dashboard in Power BI. Doing ETL work and extracting data from 5 different sources.

Melbourne, Victoria, Australia

Comprara works with ASX 200 listed companies and Government organisations giving clients insights into how well they are performing against others and in the context of their own unique strategies. Provide Spend Analytics (Where are your savings opportunities?) insights that help CEO's, CFO's and CPO's to make the right choice.✔Consulted with clients to understand their needs. Worked with Public Transport Victoria (PTV), explored procurement and spend analytics.✔Developed Standard Capability Track dashboard in Tableau to efficiently track and evaluate procurement processes.✔Managed Infusion software (CRM) database and improved performance by updating application configuration. Reduced time to get information from 3 hours to 30 minutes.✔Designed & developed Python code to fetch data from Toggl (Time Tracking) rest API and ingest into SQL server.✔Fixed SQL queries and views.

Melbourne, Australia

✔Conducted research on outlier detection algorithms, work on credit card fraud detection dataset — reduced prediction error in predicting fraud by 15% with Principal Component Analysis(PCA). Commended by the professor for research and analysis.

Melbourne, Australia

✔Provides mentorship to first-year university students at Deakin University, introducing them to the university life, and helping them adjust to the new environment and lifestyle to survive and makes sure that they become familiar with the university grounds and its various student facilities.✔Arranges weekly meetings with mentees to further assist them in university life and answers any queries of mentees.

Melbourne, Australia

BP (formerly The British Petroleum Company) is a multinational oil and gas company headquartered in London, England. ✔Handle daily transactions and ensure accuracy of records for the company. 2 years of experience in retail sector.✔Handle $16000(AUD) of the transactions daily shift and ensure accuracy of records for the company. ✔Manage Point of Sale (POS) cash register, which included accepting cash, credit, or debit payment for purchases.✔Incorporate sales strategies to boosting sales by displaying prompt, courteous, knowledgeable, and professional customer service. ✔Administer and effectively execute inventory and stocking of goods and merchandise inside the store. ✔Supported new employees by explaining policies, demonstrating the use of the equipment and providing guidance.

Melbourne, Australia

✔Reviewed and analyzed service station supply chain practices, offering corporate social responsibility (CSR)-aligned solutions and constructive feedback for improvement.

Melbourne, Australia

EWG provide world class physical & digital event workforce solutions. ✔I’m a part of the EWG Academy a proven pathway for motivated graduates to gain a world of experience and training at Australia's biggest and best events across the country.✔EWG Academy has provided me with the opportunity to gain hands-on skills and experience, contribute towards successful projects and events and work alongside industry clients. The events that I have worked to date at EWG Talent include:-Deakin Open Day-White Night Re imagined 2019-Presidents Cup-Australian Open 2020

Melbourne, Australia

UberEats is a food ordering and delivering platform.✔Delivered food products to different locations throughout different Melbourne suburbs to businesses and residential homes promptly to ensure food quality.✔Picked up to-go orders from over 40 different restaurants across Melbourne CBD and ensured all orders are correct.✔ Assisted with customer service and customer service complaints, conducted phone calls, and organized orders. ✔Kept delivery service vehicle and delivery area clean and organized while adhering to principles of sanitation and safety in handling food and equipment.

Delhi Area, India

Lowell Designer Crafts are a Manufacturer & Wholesale Exporter of Fashion Accessories, Fashion Bags, Fashion Apparels, Fashion Jewellery, Corporate Gift & Promotional Items, Home Décor, and Handicrafts.✔Assisted in the development and implementation of digital marketing strategies. Increased website traffic by 40% and 30% rise in inquiries.

New Delhi Area, India

Reliance Communications Limited was an Indian mobile network provider that offered voice and 2G, 3G and 4G data services. It owns and operates the world's largest Next-Generation IP-enabled connectivity infrastructure, comprising fiber optic cable systems in India.✔Take feedback from various clients and established contacts with prospective customers.✔Helped in resolving any customer issues to ensure network connectivity support to the clients.✔Analyzed reports in MS Excel and made presentation slides as visual support for clients.✔Prioritized good customer service orientation for requirements of telecom network (Voice & Data).✔ Built with networking skills, personally a tech savvy and updated in latest trends in Broadband and Telecom.

Master'S Degree, Data Analytics, High Distinction

At Deakin, I have been involved in the following profiles: 1. Peer Support Network Mentor(Faculty of Science, Engineering and Built.

Master Of Technology - Mtech, Electrical, Electronics And Communications Engineering, 72%

A 5-year Integrated Bachelor of Technology-Master of Technology degree program with specializations in Communication Systems Covered.

Bachelor Of Technology - Btech, Electrical, Electronics And Communications Engineering, 72%

A 5-year Integrated Bachelor of Technology-Master of Technology degree program with specializations in Communication Systems ✔Study.

Education record

✔Preparing for Engineering Entrance Examination-All India Engineering Entrance Examination (AIEEE)

School Education, High School/Secondary Certificate Programs

✔Graduated in Science Stream with majors in Mathematics,Physics and Chemistry. ✔Involved in various extra-curricular and cultural.