Summary
Overview
Work History
Education
Skills
Certification
Interests
Timeline
Generic

ARPIT GOEL

Noida,UP

Summary

Detail - oriented Analytic Manager with over 12 years of experience. Expert in developing and implementing data management strategies to enhance organizational performance. with an ability of leveraging advanced analytics to drive strategic decision-making and foster business growth. Proven ability to lead cross-functional teams and manage complex projects to deliver high-impact results.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Analytics Manager

10.2023 - Current
  • Heading Business Intelligence and Analytics domain of organization
  • Managing data pipelines to ingest data from multiple source - CRM, ERP, NBFC financial data including MSME Lending, collection and Invoice Discounting for more than 200 tables and views
  • Managing over 4 data marts for sales, collection, loans and invoice discounting
  • Enhancing data load and data management practices of organization like implementation of Unit test case ,creation of audit tables, JIRA and GIT
  • Creating new Tableau dashboards for Business Heads, CFO and CEO

Project Lead

Birlasoft
05.2022 - 10.2023
  • Leading and managing data and ETL team of 8 developers
  • Creating data load methodology using SQL, stored procedures and views
  • Migrating legacy data regarding citations, violations, repayment into new MS SQL systems with creation of over 40 sql scripts and stored procedures
  • Leading sprint planning and client demonstration meetings.

Technical Lead

HCL
09.2018 - 05.2022
  • Leading Team for migrating data from MS SQL database to Active Directory
  • Designing data load strategy using MS Visual Studio and MS SQL
  • Creating High Availability cluster of MS SQL for fail safe model
  • Management of multiple MS SQL databases, regular updates and patching.

Lead Engineer

03.2016 - 08.2018
  • First employee of the startup and worked on various tools and technologies in domains
  • Like procurement and spend analytics, supply change management, IOT analytics
  • Lead and manage the data ingestion part/team for client Airbus using technologies AWS, postgresql, Linux, predictive analytics, Talend, Tableau, HDFS, Hadoop and Spark
  • Actively participated in requirement gathering and other meeting with the client in Hamburg, Germany
  • Participated in various business meets/exhibitions like CeBIT to showcase and demonstrate multiple platforms of the organization
  • Hired and built horizontal and vertical teams for the startup in domains of data, machine learning, java and visualization
  • Created and deployed multiple cloud instances - AWS EC2 and AWS RDS for both test and production environment.

Senior Engineer

Capgemini
06.2013 - 03.2016
  • Worked in both development and maintenance environment in domains of healthcare and insurance
  • Use of ETL tools like SSIS, Pentaho-kettle and Informatica to create new data load strategies with business transformations
  • Migration of existing sql servers to PDW (Parallel Warehousing)
  • Scheduling of over 50 ETL jobs into daily, weekly and monthly buckets with implementation of SOPs for same
  • Documentation of data pipelines like LLD, HLD, and WBS.

Communication Engineer

Edge Telecom
06.2012 - 05.2013
  • Provided support on optical fiber communication network across India
  • Worked with technologies like SDH, DWDM and debugging the network failure

Education

B. Tech - Electronics

Himachal Pradesh University
Shimla
05.2012

Skills

  • Data analysis
  • SQL programming
  • Data visualization
  • ETL
  • ELT
  • Data warehousing
  • Data modeling
  • Data mart design
  • Data profiling
  • Statistical analysis
  • Data mining
  • Project management
  • AWS
  • Cloud Computing
  • Big Data
  • Agile Framework
  • Scrum
  • Sprint Planning
  • Predictive Analytics
  • Database Management
  • Python Programming

Certification

Big Data Foundation Level 1 by IBM Big Data Foundation

Level 2 by IBM Hadoop Foundation

Level 1 by IBM IBM Block chain Essentials Spark

Level 1 by IBM Introduction to Career Skills in Data Analytics (LinkedIn Learning)

6 month certification in Strategic Management from IIM Kashipur (In-Progress)

Interests

Networking with like-minded professionals to share knowledge and best practices

Attending conferences and workshops on data analytics and business intelligence

Enjoy bike touring to explore new places.

Timeline

Analytics Manager

10.2023 - Current

Project Lead

Birlasoft
05.2022 - 10.2023

Technical Lead

HCL
09.2018 - 05.2022

Lead Engineer

03.2016 - 08.2018

Senior Engineer

Capgemini
06.2013 - 03.2016

Communication Engineer

Edge Telecom
06.2012 - 05.2013

B. Tech - Electronics

Himachal Pradesh University

Similar Profiles

CREATE PROFILE
ARPIT GOEL