RIYANSHI GUPTA

Consumer Analytics - Agile Management

• Refactored and Tested Service Operations CPL scripts from Apache Hive to Google's Big Query.
• Used different GC service like buckets, data proc and cloud composer to automate the pipeline via Jenkins.

Informatics VBC Attribution

• Worked in production team - deployed pipelines, tested them and pushed into production.
• Used Apache Hive for big data pipelines.
• Created pyspark scripts for pipeline building, leveraged secured CRT to deploy shell scripts.

• Performing ETL process on different ERP systems to provide insights into trends and prospects for the client
• Using Big Query to build SQL code, test , debugg it to match with client's numbers and then pushing it into our application.

• Conduct full lifecycle of analytics projects, including creating data marts, pulling, manipulating, and exporting data from project requirements documentation to design and execution by using SQL and Python.
• Evaluate key performance indicators, provide ongoing reports, discover new insights for competitive advantage and recommend business plan updates.

• End-to-end key metrics tracking will be a key part of my role, including a focus on SLAs and KPIs for the accounts you're working on using spreadsheets (google sheet, excel) and intermediate in SQL.
• Analyze numbers, trends, and data to take appropriate actions based on your findings.