Rishabh Gupta Email & Phone Number

Dallas, Tx, Us

Commerce, Texas, United States

Prepared Business Analytics Suite using Alteryx to generate meaningful insights for the business to take robust and diligent actions. Further, automated the scheduling using Gallery assisting the operations team streamlined their analytics tasks improving working efficiency by 50%.Enhanced Data Analytics reports per business requirements using Advanced SQL on Alteryx improving quick decision making.Improvised Tableau dashboard developing a storyline to report additional business… Show more Prepared Business Analytics Suite using Alteryx to generate meaningful insights for the business to take robust and diligent actions. Further, automated the scheduling using Gallery assisting the operations team streamlined their analytics tasks improving working efficiency by 50%.Enhanced Data Analytics reports per business requirements using Advanced SQL on Alteryx improving quick decision making.Improvised Tableau dashboard developing a storyline to report additional business KPI’s based upon impacted record count, distinct vendors to act ahead of user complaints improving trust and credibility by users.Engaged in client calls to understand the product requirement, design the project plan architecture and work iteratively following agile principles to ensure expected deliverables for each iteration. Show less

Commerce, Texas, United States

Commerce, Texas, United States

Analyze the Stock Inventory Database and prepare reports for demand/supply orders using SQL,Python and TableauDevelop Customer Feedback visuals and charts for the management to evaluate the favorable, amelioration scope and customer suggestionsConduct regular calls with the management for strategizing the suggestions in order to achieve and maintain high standards Keeping Track of the Account logs and submitting the reports by the EOD.

Cost Optimization Analysis of multiple AWS cloud accounts, using SQL, Tableau and Advanced Excel, saving up to $2000 per monthAutomation of the financial reports to generate meaningful insights for analyzing market movement trends for a variety of categories thus improving efficiency by 30% using SQL and PythonCustomer Behavior Analysis for Textile Industry using TableauSales and Profit Forecasting for the Pharmaceutical Industry using Regression, Exponential Smoothing… Show more Cost Optimization Analysis of multiple AWS cloud accounts, using SQL, Tableau and Advanced Excel, saving up to $2000 per monthAutomation of the financial reports to generate meaningful insights for analyzing market movement trends for a variety of categories thus improving efficiency by 30% using SQL and PythonCustomer Behavior Analysis for Textile Industry using TableauSales and Profit Forecasting for the Pharmaceutical Industry using Regression, Exponential Smoothing and Moving Average methodsManage and automate Account Risk reports for various clients, using Python and Oracle, in order to track essential risk metrics such as duplicate payments, account delinquency, account defaultsDesign project plan architecture and lead, mentor the team with responsibility to have clear vision for each individual alongside track/present the performance metrics to higher managementWork with the Data team to extract data for different applications for example error patterns and constructed multiple Dashboards/Reports for the same using SplunkCollaborated with different stakeholders to understand the Business requirements, strategize the work, following the "Agile Methodology" to ensure expected deliverables for each scrum call Show less

Gurgaon, India

Setup of Virtual Private Cloud for the new accounts within cloud and formalising basic subnets, gateways and CIDR settings.Creating various CI/CD pipelines through Jenkins and running applications via Docker containers on EC2 instances.Setup of Organisations Structure for multiple AWS accounts with an organisation. Setup of Controller and Master node architecture on AWS EC2 machines for multiple clients and controlling the infra service orchestration (based upon… Show more Setup of Virtual Private Cloud for the new accounts within cloud and formalising basic subnets, gateways and CIDR settings.Creating various CI/CD pipelines through Jenkins and running applications via Docker containers on EC2 instances.Setup of Organisations Structure for multiple AWS accounts with an organisation. Setup of Controller and Master node architecture on AWS EC2 machines for multiple clients and controlling the infra service orchestration (based upon requirement) through configuration files using ANSIBLE .Installation of Cloudwatch Unified Agent for capturing different sets of data on multiple nodes for analyzing the activities on cloudwatch.Formulating AWS GLUE crawlers to analyse the data on AWS ATHENA and generate custom reports through SQL queries.Setup of Cloud Infra using Terraform.Setup of Reports for analyzing the long processing bonds/securities using SQL Database Queries.Used SPL(Splunk Processing Language) to create alerts for catching real time errors using Splunk. Constructed multiple Dashboards/Reports for illustrating the domain specific error logs.Reduced query execution time by 30% by Writing well-designed, efficient code using best code practices.Setup of Alerting Framework for the escalation policy using PagerDuty thus automating the escalation protocol by triggering alerts though email/phone.Worked with Statistical and Analytical Team to generate and analyze financial statistical reports to take timely business actions thus improving the turn-around time to 50%.Analyzed, Assigned and built scalable solution for Cores Allocation according to priority using IBM Symphony Grid thus reducing runtime cost to 40%, also resulted in High Availability.Conducted RCA during multiple production issues for gradual processing/expected allocation on grid.Administered the migration of existing scripts from Solaris to Linux machine by converting theSQL file's to generic stored procedures. Show less

Gurgaon, India

Functional Flow of the PIMCO Night Cycle Process, Analysis and Hands-On with the Risk Assessment jobs and processes.Jobs Information Language(JIL) file structure and its scheduling process over the Autosys with appropriate runnable conditions.Traversed with various tools and utilities used in Production Operations - CodeSearch, PUMA,Symphony, Splunk etc.

Master Of Science - Ms, Business Analytics

Bachelor Of Engineering, Computer Programming

Master Of Science - Ms, Business Analytics