Advait Gupte Email & Phone Number

Brooklyn, New York, Us

Brooklyn, New York, Us

(Python, SQL, Selenium, Java, Web Services, Shell Script, Ruby, Tableau, GIT, JIRA, Excel)* Communicate with the 3rd parties to resolve all technical issues reported at the warehouse.* Maintain and monitor the internal warehouse management system (WMS).* Analyze internal and external (clients') databases using tools like Excel, Tableau and Splunk to prepare reports and dashboards.* Determine goals based on internal stakeholders’ requests on analyzed data and metrics.* Collaborate with different operational departments to their understand goals and objective for systems and data manipulation.* Research best practices to maximize organizations' operation throughput by decision analysis and data visualization techniques.

Hoboken, Nj, Us

(Python, Selenium, SQL, JIRA, Git, R, SAS, Tableau, Excel)* Developed and maintained scalable, automated, user-friendly reports, dashboards that support data driven analysis.* Created documents to train stakeholders in industry best practices including change management, communication documents.* Collaborated with stakeholders to help navigate the applications selection, transformation, implementation, and configuration.* Optimized and fine-tuned SQL code to retrieve and analyze from database to build data visualization and reporting prototypes.* Automated manual process of populating search queries by using selenium scripts mitigating errors, improving efficiency.

New York, Ny, Us

(Python, SQL, Selenium, Web Services, Shell Script, Pearl, GIT, JIRA, Excel)* Supported Production application and database operations for Tradeweb's Institutional Fixed Income trading system* Monitored and maintained an extremely high level of availability and function for Production, Demo and UAT* Solved problems arising in all environments with attention to urgent evaluation, triage, clear and concise communication

New York , Ny , Us

(Java, Python, SQL, JavaScript, R, Selenium, JIRA, Git)* Used Groovy and Java on different algorithms with Agile Methodologies* Tested front end clients, GUIs by automating scripts developed in JavaScript* Managing deliverables for monthly Release* Managing testing activities within testing Team members* Prepared methods for process adherence in Agile Development Life Cycle/ SCRUM method* Used Java and C#.net to automate testing with Selenium Web Driver and Shell scripts* Developed and tested Web Services which used REST APIs to fetch and post data using Chrome Postman

Hoboken, Nj, Us

(R, SAS, Tableau, Excel) * Supported future budgeting for the Department of Classroom Management using SAS * Predicted the cost for work orders and inventory using forecast modeling in SAS, Python and R * Presented weekly reports using Tableau to the Board of Stevens Institute of Technology * Maintained and reviewed financial records in Excel for the Office of the Registrar * Implemented secure student data files for graduating PhD and Masters students in Excel* Managed usage of classrooms efficiently and effectively at the start of every semester* Coordinated effective registration and enrollments of students every semester

New York, Ny, Us

(Java, Python, SQL, R, Selenium, JIRA, Git)* Used Groovy and Java on different algorithms with Agile Methodologies* Tested front end clients, GUIs by automating scripts developed in JavaScript* Managing deliverables for monthly Release* Managing testing activities within testing Team members* Prepared methods for process adherence in Agile Development Life Cycle/ SCRUM method* Used Java and C#.net to automate testing with Selenium Web Driver and Shell scripts* Developed and tested Web Services which used REST APIs to fetch and post data using Chrome Postman

New York, Ny, Us

(Java, JavaScript, Selenium, JIRA, Git) * Created automation framework to emulate End Point Adapters for Trade Flow * Used Groovy and Java on different stock exchanges with Agile Methodologies * Tested front end clients, GUIs by automating scripts developed in JavaScript * Designed SpecFlow framework for automating web and business processes using Appian Software

Chicago, Illinois, Us

(Java, Selenium, jQuery, Hibernate, C#.net, Web Services, REST APIs, GIT)Client: MAXDigital, FirstLook SystemsMAXDigital and its sister company FirstLook Systems are companies based out of Austin and Chicago respectively that develops desktop and mobile solutions for automotive dealers, helping them to effectively manage their inventory, marketing, and sales process. Also they advertise about new and used cars.* Carried out manual and automation testing as a Test Lead for FirstLook project* Prepared methods for process adherence in Agile Development Life Cycle/ SCRUM method * Used Java and C#.net to automate testing with Selenium Web Driver and Shell scripts * Developed and tested Web Services which used REST APIs to fetch and post data using Chrome Postman * Managed 5 testers team and off shore client testers (QA Lead) for effective testing practices* Managing deliverables for monthly Release* Managing testing activities withing testing Team members* Thorough webservice Automation testing using Shell script on Linux* Preparing monthly RCA reports for defects, Testing Team effort utilization report* Defect Leakage report and weekly Defect Status ReportsAutomation Framework* Developed an automation framework to test the regression test suite which runs as part of the production testing* The script performs the task of 3 employees and saved between 16-20 hrs every time regression suite was run* Also maintained an existing Shell script that tested production web services.Reports Data* Developed stored procedures in SQL that provided the data for the Dashboards* Validated production reports

Client of Quinnox Consultancy Services

Buffalo, New York, Us

Client of Quinnox Consultancy Services

Bangalore, Karnataka, In

(Java, SQL, CICS, COBOL, DB2)* Developed Web Applications for Order Management Systems using Java and SQL* Created project for School Attendance and Feedback in Main Frames using languages such as CICS, COBOL and DB2 programming* Learned database interaction and executed queries on databases using joins, sub queries, pivot tables and VLOOKUP.

Master Of Science - Ms, Computer Science

Bachelor Of Engineering - Be, Information Technology

Diploma, Information Technology

Secondary School Certification