Ekansh Gupta Email & Phone Number

Dallas, Texas, United States

Designed and deployed enterprise Power BI solutions with advanced data modeling and custom visuals, boosting reportingefficiency and user engagement by 35%.• Designed and implemented SQL-based ETL processes with custom scripts and automation, streamlining data pipelines andenhancing data quality.• Gathering intelligence on business requirements by interviewing stakeholders and analyzing workflows and procedures.• Led SSRS and Power BI Report Builder development, integrating data from multiple sources and optimizing performance forfaster report generation and enhanced data analysis.• Optimized complex SQL Queries and Stored Procedures, enhancing performance by 25% and supporting robust data analysis.• Utilized advanced Excel functions such as pivot tables, VLOOKUP, and INDEX-MATCH for data analysis and visualization, drivingmore informed business decisions.

Austin, Texas, United States

Planned and developed an automated process using Salesforce and MicroStrategy which help analyst to keep track of selleractivities on the eBay website unlocking auto-decisioning, saving 3 hours per case/15,000 hours per year.• Collaborated with cross-functional teams to define product requirements, project plans, and launch schedules using Confluence,and Monday.com.• Designed Alteryx workflow to automate comparing reports containing 20,000+ rows within ~5 seconds.

Houston, Texas, United States

• Extracting data from PostgreSQL and Oracle to perform analysis and prediction for inventory, and sales for the upcoming quarter• Creating views using complex SQL queries against real-time data, result in reducing analysis time by 40% for stakeholders• Designed and constructed an ETL pipeline for third party data providers using Airflow DAG to store insightful data• Designed and automated the process for updating the latest drug price for every quarter using Airflow DAG

Dallas, Texas, United States

• Responsible for maintaining the status reports of the deliverables provided by the President.• In charge of communicating with different school administrations and student representatives in order to organize events, providing a platform for students to interact with global leaders, and persuading peers to volunteer and contribute.

Dallas, Texas, United States

• Managed cross-groups to organize cultural events, helping 1000+ students with airport pickups and accommodations.• Operationalized and streamlined team communication, developed the newsletter to report team deliverables.

Dallas, Texas, United States

Faridabad, Haryana, India

• Developed software leveraging Cisco, Salesforce, and the Jack Henry API using JAVA, SQL resulting in a 95% improvement in customer satisfaction for 50+ contact centers• Presented roadmap, Project Plan and developed technical solutions to business challenges which turns 50+ clients into a potential customers; recognized with Rising Star of the Year• Introduced and implemented the Agile Methodology acted as a Scrum Master, and saved 200 hours of rework.• Automated the process of displaying customer information from different databases like UCCX and UCCE, Cisco API, Credit Union (Jack Henry, Fiserv, Epic), and Salesforce using Java, Rest API, and SQL • Collaborated with cross-functional teams to negotiate and communicate about a product from process requirements, project plan, and schedules to launch, increasing process adherence by 22% by implementing process checklists.

Faridabad, Haryana, India

New Delhi Area, India

Delhi

Master'S Degree, Information Technology And Management

Bachelor Of Technology - Btech, Computer Science

Activities and Societies: Playing Badminton, Drama, CricketPursued B.Tech from Computer Science and Engineering

Associate’S Degree,Science, 71%

High School, Science, 9.4 Cgpa