SUJOY DIPTA PATHAK, Solution Architect

SUJOY DIPTA PATHAK

Solution Architect

Ericsson

Location
India - Kolkata
Education
High school or equivalent,
Experience
9 years, 7 Months

Share My Profile

Block User


Work Experience

Total years of experience :9 years, 7 Months

Solution Architect at Ericsson
  • United Arab Emirates
  • June 2017 to October 2017

· Deploying machine learning model from on-premise Kubernetes cluster to Google cloud Kubernetes engine.
· Designed and developed a fully automated data pipeline to migrate an on-premise data lake to Google cloud platform.
· Building an up to date feature store for AI/ML framework for multiple business support system products.
Building anomaly detection rule-based framework in Python3 for in-house fraud detection System.
· Designed data audit framework for the reconciliation of data between ECM (Ericsson Cloud Manager), EOC (Ericsson Order Care) and a third-party system called Assure Now.
· The whole framework is based on spark ETL and Scala and pyspark are used as primary language.
· Optimized existing scripts on data audit framework and migrated them to Apache spark.
· Created technical design document (LLD and HLD) of the solution based on the joint application development session with customer.
· Responsible for designing data flow pipeline with Unix shell scripting and Cloudera Impala to store custom insight data with proper analytics KPI transformation to internal ETL layer impala tables.
· Implementing impala optimization technique to create the data set for efficient and quick displaying in visualization layer; in this case Tableau.
· Developing custom insight script through impala for loading the data in ETL layer tables for downstream system consumption.
· Designed data flow pipeline with Apache Nifi and loading data to Cassandra and postgres tables.
· Designed and developed pyspark scripts for network performance management anomaly detection.
· Designed missing data flow and fraud analytics KPIs framework for operator suggested KPIs.

Associate at Cognizant Technology Solution
  • United Arab Emirates
  • July 2016 to June 2017

· Responsible for developing Informatica workflow based on customer requirements.
· Creation of data marts based on the customer adopted data model.
· Creation of patient hierarchical data model through Erwin.
· Developing UNIX shell script for various post data integration activities and database maintenance activities.
· Validating PL/SQL procedures and functions which are plugged in as a component in Informatica workflow.
· Communicating with internal and external clients to determine business requirements and expectation.
· Creating data quality framework using “Informatica Data Quality” (IDQ) tool.
· Creation of technical design document.

Engineer at Ericsson
  • United Arab Emirates
  • September 2011 to June 2016

· Responsible for developing Informatica workflow based on customer requirements.
· Actively engaged in POC using Tableau 8.3.2 to show enhanced billing capabilities of Ericsson billing system (BSCS) to the client.
· Responsible for billing system integration with Ericsson order care and product catalog.
· Responsible for creation of data model for customer centric billing solution.
· Responsible for writing for PL/SQL procedure and function to implement revenue assurance and leakage mechanism.
· Communicating with internal and external clients to determine business requirements and expectation.
· Created High level design document (HLD) and Low level design document (LLD) for the solution provided.
· Involved in joint application development (JAD) with client and other stakeholders to reach the consensus on proper capturing of business requirement.
· Responsible for the analysis of data from various telecom nodes with the help of SQL and PL/SQL procedures and functions to identify customer’s behavior pattern.
· Involved in validating a data output from Informatica and identify the gap between customer expectation and actual output.
· Involved in telecom operational consulting to identify the performance bottleneck of WeDo RAID (a telecom revenue assurance COTS product)
· Preparing the gap analysis and test case document.
· Involved in showcasing operator wise traffic analysis report using Tableau.
Prepared data quality audit report using Tableau reporting tool

Education

High school or equivalent,
  • at West Bengal University of Technology
  • December 2014

courses: Enhanced Telecom Operations Map (eTOM)), TM Forum

High school or equivalent,
  • at Ericsson Expert Analytics
  • August 2014

High school or equivalent,
  • at West Bengal University of Technology
  • December 2012

courses: ITIL Foundation, Excelos

Master's degree,
  • at West Bengal University of Technology
  • July 2007

courses: In this bachelor degree course, the following subjects are included: 1. Operating System 2. Database Management System 3. Programming Languages (C, C++, Java) 4. Digital Electronics 5. Artificial Intelligence Courses Microsoft BI Service, NIIT Technologies

Master's degree, Computer Science
  • at West Bengal University Of Technology
  • July 2007

I have got 8.8 as GPA

Bachelor's degree,
  • at West Bengal University of Technology
  • July 2004

In this

Bachelor's degree,
  • at West Bengal University of Technology
  • July 2004

In this

Specialties & Skills

Tableau
Informatica
APPLICATION DEVELOPMENT
CUSTOMER RELATIONS
INFORMATICA
ORACLE PL/SQL
QUALITY
WORKFLOW ANALYSIS
BILLING
BILLING SYSTEMS
CATALOGS
CONSULTING

Languages

English
Expert
Hindi
Expert
Spanish
Expert

Hobbies

  • Recitation, Playing music by Guitar, Enacting a play