Ankit Gupta Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

- Managed a team of 7 and achieved 100% on-time project delivery while maintaining yield of more than 90%.- Received 95% Client Satisfaction score for completed projects.- Reduced 60% calculation from the reporting side and moved to SQL side.- Optimized Tableau reports by reducing loading times by 40% there by improving customer experience.- Reduced customer's manual work by 90% there by speeding up decision making.- Interacted with multiple stakeholders to gather business requirements & developed technical specs.- Built tableau views and reports by analyzing and understanding existing reports .- Designed interactive Tableau dashboards with trends, and drill up and drill down.- Worked on custom SQL and validating the same in SQL server and develop Tableau reports.- Developed aggregates, hierarchies, charts and views for the dashboard.- Worked with actions in reporting, drill down, drill through reports.- Used SQL concepts like constraints, joins, sub-queries, Common Table Expressions, Window Functions, - Aggregate Functions, String Functions, DDL, DML, DCL, TCL and DQL commands.- Published and sharing reports with the business users on the Tableau Server.- Executed Tableau server site admin activities like permissions, extract refresh schedules, adding users, creating groups, alerts, and subscription.

Bengaluru, Karnataka, India

- Achieved 100% customer satisfaction for the delivered project.- Managed to deliver project deliverables on time with 100% accuracy.- Increased customer revenue through fees by 10% by helping make faster decisions.- Helped reduce clients' decision making time by more than 40%.- Optimized dashboard by increasing performance by 55%.- Reduced reporting side calculations by 30% by moving calculations to Oracle.- Analyzed business requirements and created functional requirements specifications to build and deploy solutions.- Managed publishing & sharing dashboards to tableau server. Created users, groups, projects, assigned users to groups in Tableau server.- Implemented binning & blending concepts in Tableau reports.- Updated some of the existing reports and dashboards.- Created filters, quick filters, table calculations, calculated measures and parameters.- Worked on dual axis visualization while working with reports.- Reported more than 45% of the bugs in reports by testing reports and validating data through Oracle Database.

Pgpm, Artificial Intelligence

Bachelor'S Degree, Mechanical Engineering

Activities and Societies: Associated as a member of mechanical department’s annual function “Yantrotsava” where various colleges took part.