Summary

Overview

Work History

Education

Skills

Certification

Timeline

Personal Information

Akash Kumar Sahoo

Sunnyvale,CA

Summary

Results-driven IT professional with over 14.8 years of experience in Cloud Computing, Data Warehousing, Data Analytics, and Business Intelligence. Currently serving as an on-site collaborator, effectively coordinating with offshore teams while contributing to development activities. Proven expertise in designing and optimizing data pipelines and architectures using Snowflake, along with strong capabilities in Big Data technologies such as Hadoop, Hive, and Spark, as well as GCP products like BigQuery and Dataflow. Skilled in analyzing business requirements, enhancing processes, and delivering comprehensive solutions through proactive communication and collaboration with clients and stakeholders.

Overview

years of professional experience

Certification

Work History

Technology Lead

Wipro

05.2024 - Current

Developed and managed Apple sales reporting, utilizing data analytics to track performance metrics and trends. Created detailed reports and dashboards to provide insights for decision making, facilitating strategic planning and driving sales growth. Collaborated with cross functional teams to enhance reporting processes and ensure data accuracy.
Team: GBI Rocket / Horizon
Project: Sales Reporting Dashboard
Peak Team Size: 7
Responsibility: Processed data in Snowflake using stored procedures, exporting to Single Store DB for a sales UI dashboard. Addressed user issues, gathered requirements for business enhancements, and actively contributed to development efforts.
Technologies: Snowflake, Dbt, Single Store, PL/SQL, Python

Lead Consultant

Infosys

04.2022 - 05.2024

Customers who are using GCP for running their applications are provided with different support offerings to troubleshoot in case they face any issue by contacting support team through Google Cloud Support Center (GCSC). This service is chargeable to customers by Google. So, for this customer do not directly contact Google technical support engineers (TSEs) instead they contact Google technical support team representative (TSRs) first for resolving their cases. GCSC is an app engine which allows customers to create/edit cases. It uses Salesforce API to interact with our case management system.
Team: Google Cloud Support
Project: Google Sunrise Project
Peak Team Size: 25
Responsibility: Prepare case notes based on Internal research on the case, File FMR (first meaningful response), have GVC with customer for better clarification on the issue, discuss with SMEs regarding RCA and solutions, file consults to TSEs for getting better clarifications whenever required, File bug/PIT if required
Technologies: Big Query, Dataflow, Dataproc, Pub/Sub, Composer, Bigtable, GCS

Lead Consultant

Infosys

09.2021 - 03.2022

Apple have partnered with various Carriers to increase iPhone sales. Scope of this project is to fetch the details of Apple Music new subscription or renewal of an existing subscription via these Carriers on daily basis. This information is then used to generate invoice detail report for each Carrier.
Team: GBI PX4
Project: iTunes Finance – Carrier Invoice Reporting
Peak Team Size: 3
Responsibility: Requirement Analysis, Coding, Developing and Testing, Data setup in Test Environment, Implementation in Production
Technologies: Hadoop, Hive, Oozie, Python, Unix, SQL

Technical Manager

Quest Global

01.2020 - 09.2021

Apple Music is a music-streaming service, developed by Apple Inc. Users select music to stream to their device on-demand, or they can listen to existing, curated playlists. The service also includes the Internet radio station Beats 1, that broadcasts live to over 100 countries 24 hours a day. The aim of this project is to capture events done by the user on their Apple Music app and report number of valid plays done by the user. These reports are then further used for royalty payment calculation.
Team: GBI PX4
Project: iTunes Finance – Apple Music Reporting
Peak Team Size: 3
Responsibility: Requirement Analysis, Coding, Developing and Testing, Data setup in Test Environment, Implementation in Production
Technologies: Hadoop, Hive, Oozie, Unix Shell Scripting, SQL

Technical Manager

Quest Global

12.2018 - 12.2019

IDAA is a Centralized Tool to run the DQM (Data Quality Management) for multiple applications. DQMs can be split on multiple categories based on the data validation being done. DQM reporting is enabled at Dataset level and Application Level based on different rules viz. Data checks, Reconciliation, Variance. Data Checks are used to validate the correctness of data. Recon checks are used to validate the data across multiple systems. Variance checks are used for calculating the variance for different measures. These checks validate the consistency of data over period of time. The DQM status in iDAA UI is displayed at the Application and Dataset level. For each DQM, iDAA displays the Pass or Fail Status for the rule with the corresponding numbers and the %age Completion. For the failed rules, iDAA has an alerting mechanism which allows the application teams to troubleshoot and take a corrective action on a failed rule. Alerting mechanism in iDAA for Failed rules are done by emails and tickets raised by iDAA framework based on the input provided by the application teams
Team: GBI PIANO
Project: iTunes Piano – iDAA Centralized Tool
Peak Team Size: 5
Responsibility: Requirement Analysis, Coding, Developing and Testing, Data setup in Test Environment, Implementation in Production
Technologies: Hadoop, Spark, Scala, Python

Technical Manager

Quest Global

12.2017 - 11.2018

Existing Sales & Trend reports are processed in Hadoop environment and reports are generated using Hive. As part of this project all the reports will be generated using Spark. This will help in reducing total processing time and met the business SLA.
Team: GBI PIANO
Project: iTunes Piano – S&T Spark Migration
Peak Team Size: 5
Responsibility: Requirement Analysis, Coding, Developing and Testing, Data setup in Test Environment, Implementation in Production
Technologies: Hadoop, Spark, Scala

Technical Manager

Quest Global

07.2013 - 11.2017

Sales and Trends provides the following reports: Summary Sales Report - Aggregated sales and download data for your apps and In-App Purchases. Subscription Report - Total number of Active Subscriptions, Free Trials, and Marketing Opt-Ins for your auto-renewable subscriptions. Subscription Event Report - Aggregated data about subscriber activity, including upgrades, renewals, and free trial conversions. Subscriber Report - Transaction-level data about subscriber activity using randomly generated Subscriber IDs. Magazines & Newspapers Detailed Report - Transaction-level data for Magazines & Newspapers apps using randomly generated Customer IDs. Opt-In Report - Contact information for customers who opt in to share their contact information with you. These reports were processed in Hadoop environment and provided to Sales & Trend dashboard which can be accessed using iTunes Connect.
Team: GBI PIANO
Project: iTunes Piano - Sales & Trend Reporting And TD to Hadoop Migration
Peak Team Size: 2
Responsibility: Requirement Analysis, Coding, Developing and Testing, Data setup in Test Environment, Implementation in Production
Technologies: Hadoop, Hive, Unix Shell Scripting, Oracle

Technical Manager

Quest Global

07.2012 - 06.2013

A generic framework developed using JSF, which can be customized various report requests on a scheduled basis. According to the requirement of application team, the reports can be upload to file system or SFTP to other server or send the file to the user through mail. User can able to download the uploaded report file from the UI.
Team: GBI PIANO
Project: URF (Universal Reporting Framework)
Peak Team Size: 2
Responsibility: Requirement Analysis, Coding, Developing and Testing, Data setup in Test Environment, Implementation in Production
Technologies: Java, JSF, Oracle

Technical Manager

Quest Global

04.2012 - 06.2012

A solution developed in the web service (JSON) architecture to generate reports by processing millions of records using multi-threading. This also uses the file server to upload the reports. Reviewed and analyzed the requirements and proposed solutions. Designed the complete control and data flow along with the exception handling and also involved in the development of some of the major functionalities.
Team: GBI PIANO
Project: Ad-hoc Reporting
Peak Team Size: 2
Responsibility: Requirement Analysis, Coding, Developing and Testing, Data setup in Test Environment, Implementation in Production
Technologies: Java, Webservice, Oracle, Unix

Technical Manager

Quest Global

10.2011 - 03.2012

A SOAP based web service to serve one of the native web applications. This is a dynamic service being hit by millions of users daily through a reporting application. Reviewed and analyzed the existing legacy code base to design the complete web service with improved quality and performance by incorporating all possible OOPs features. Designed the complete control and data flow along with the exception handling.
Project: DASHBOARD
Peak Team Size: 3
Responsibility: Business Requirement Analysis, Preparing Test cases, DB coding, DEV, UAT and Prod setup, Primary Implementer
Technologies: Java, Webservice, Oracle, Unix

Technical Manager

Quest Global

04.2011 - 09.2011

A JSON based web service to serve one of the native mobile applications. A web service developed for a mobile application to be used by a huge number of users. Involved in design and development of the complete web service which constitutes 10 APIs.
Project: COHO and Sockeye
Peak Team Size: 3
Responsibility: Business Requirement Analysis, Preparing Test cases, DB coding, UAT setup
Technologies: Java, Webservice, Oracle, Unix

Education

B.Tech - Information Technology

Institute Of Technical Education And Research

01.2010

12th - undefined

JNV, Kendrapara

Kendrapara

01.2004

10th - undefined

JNV, Kendrapara

Kendrapara

01.2002

Skills

Domain: Apple Sales, Apple iTunes, Apple Music and Google Cloud Platform
Technology: Database/Datawarehouse: Snowflake, Big Query, Hive, Oracle, Teradata
Big Data Technologies: Hadoop, Spark

Language skills: Scala, Java, Spark SQL, HQL, PL/SQL, Unix Shell Script, Python
GCP Products: Big Query, Pub/Sub, Dataproc, Dataflow, GCS
Tools: Eclipse, SQL Developer, SQL Workbench, IntelliJ IDEA

12th - undefined

JNV, Kendrapara

10th - undefined

JNV, Kendrapara

B.Tech - Information Technology

Institute Of Technical Education And Research

Personal Information

Gender: Male
Marital Status: Married
Visa Details (If any): H1B Visa