Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Siddharth Jain

Lead Data Analyst
Pune

Summary

Personable business professional with over 7 years of experience in Data Migration and Data Analytics in Telecom and Supply-chain domain. Excellent reputation for resolving problems and improving customer satisfaction.


Overview

7
7
years of professional experience
4
4
years of post-secondary education

Work History

Lead Data Analyst

DecisionTree Analytics
Gurugram
11.2020 - Current
  • Part of the Business Intelligence team primarily working in the Supply Chain domain
  • Building, maintaining and Scheduling Talend jobs to source dimensional and transactional data for multiple entities from platforms like SQL Server, Flat files, Database backups, APIs and load them into a Postgres based Data Warehouse on a daily basis.
  • Building SQL views on the EDW Dimensions and Fact tables that feed the Tableau which helps in Leveraging text, charts and graphs to communicate findings in an understandable format.
  • Created and automated data visualizations to present insights and tell compelling stories.

Business Analyst

Amdocs DVCI
Gurugram
01.2019 - 10.2020
  • Facilitated data conversion for new Clients in case of Product switch from 3rd party to Amdocs or for existing clients who preferred upgrading the existing Amdocs product. Primarily worked on ABP (Amdocs Billing Product) and CRM.
  • Ensured functionality, capability and system integrity testing prior to launch.

Senior System Analyst

Amdocs DVCI
Gurugram
07.2017 - 12.2018
  • Exposure on SQL tuning, designing complex SQL code and analytical SQL queries
  • End-To-End defect ownership from creating Hot-fixes to fixing bugs in the code to writing negative database SQL checks in advance in order to ensure data quality.

System Analyst

Amdocs DVCI
Gurugram
07.2015 - 07.2017
  • Handled Telecom Data Migration Projects. Mapped data between source systems and Target warehouses.
  • Worked on SQL, Informatica 9.5/10.2, SQL tuning and optimization, developing migration code for extraction, transformation and load of data in the Enterprise data warehouse.

Education

B.Tech - Electronics & Communication Engineering

Motilal Nehru National Institute of Technology
Allahabad, India
07.2011 - 05.2015

Skills

Oracle SQL, PostgreSQL

undefined

Projects

Brady-IFS, United States: Nov 2020 to present

Creating Dashboards for Brady, IFS and its acquisitions to ease data visualization.

Role-Inventory Analysis, Pricing Opportunity, Daily Sales/CoGS/Margin- YOY/MOM


Globe, Philippines: Dec 2018 to Oct 2020

Migration of Globe’s customers’ corporate and consumer database with multiple LOBs to Amdocs 'Enabler' - ABP, OMS and CRM modules.

Role-Client Discussions, Designing Mapping documents, Cross-team Discussions


Comcast Modesto, United States: Nov 2017 to Nov 2018

Migration of 1M Customer Database from Comcast's 3rd party Billing/CRM product to Amdocs 'Enabler' - ABP, OMS and CRM modules.

Role-Process Automation, end-to-end defects ownership, ST/UAT/Production Support.


TrueCorp, Thailand: July 2015 to Nov 2017

Migration of 3M customer database from True's multiple products (Mobile, Broadband and TV) to one unified Amdocs Billing system.

Role-Wrote SQL codes and built ETL pipelines in Informatica, provided offshore and onshore support.

Timeline

Lead Data Analyst

DecisionTree Analytics
11.2020 - Current

Business Analyst

Amdocs DVCI
01.2019 - 10.2020

Senior System Analyst

Amdocs DVCI
07.2017 - 12.2018

System Analyst

Amdocs DVCI
07.2015 - 07.2017

B.Tech - Electronics & Communication Engineering

Motilal Nehru National Institute of Technology
07.2011 - 05.2015

Similar Profiles

CREATE PROFILE
Siddharth JainLead Data Analyst