Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

ARPIT GOEL

Noida

Summary

Strategic professional versed in distilling and analyzing large data sets. Develops and delivers presentations detailing data findings. Articulate and collaborative with expertise in algorithm design and data collection.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

Work History

Analytics Manager

Power2SME
Gurugram
10.2023 - Current
  • Managed and directed company-wide efforts towards optimizing Business Intelligence and Analytics operations within the financial industry.
  • Successfully oversaw the management of data pipelines to gather information from various sources like CRM, ERP, and NBFC financial data. Demonstrated proficiency in handling more than 200 tables/views, which included MSME Lending, collection, and Invoice Discounting.
  • Achieved effective management of over 5 data marts dedicated to diverse tasks such as sales, collection, loans, discounting and lead generation (MYSQL).
  • Optimized data load and management protocols by incorporating unit test cases, developing audit tables, and integrating JIRA for task tracking alongside GIT for version control.
  • Developed visually appealing Tableau dashboards to provide valuable data insights to top-level management and decision-makers.
  • Effectively oversaw the distribution of Tableau reports via various subscription frequencies.
  • Supervised data operations for financial KPI tracking in the NBFC and MSME lending industry covering RFQs, purchase orders/invoices (purchase and sales), along with disbursements.
  • Educated team leaders and developers on implementing efficient data strategies, project management techniques, and task coordination.

Senior Technical Lead

Birlasoft Technologies
Noida
05.2022 - 10.2023
  • Responsibility included overseeing the performance of the data engineering and database administration team, consisting of 8 members.
  • Achieved successful migration of transportation data from legacy servers to modern day servers through collaborative effort with US client, employing SQL stored procedures to drive impactful business changes.
  • Executed the design and supervision of over 50 stored procedure scripts in SQL, enabling smooth data migration.
  • Led regular sprint planning and client demonstration meetings for task updates.
  • Analyzed requirements, designed architecture, and developed technical solutions to meet customer needs.
  • Collaborated with other departments to ensure integration between different components of the system.

Technical Lead

HCL Technologies
Noida
09.2018 - 05.2022
  • Managed and implemented migration of data from ERP sql source to Active Directory while working as team lead.
  • Implemented effective data load approaches with the help of tools like Microsoft Visual Studio and SQL Management Studio.
  • Designing and implementing data pipelines through C# and SQL stored procedures
  • Managed a diverse team of 4 individuals, including data engineers and testers, to successfully develop and maintain the project.
  • In the role of a database administrator, I successfully executed regular updates and patching activities for databases.
  • Established high availability clusters for MS SQL on servers located in Bangalore and New Jersey.
  • Providing expertise in data science and analytics through workshops to enhance team members' knowledge.

Lead Analytics Engineer

Neewee Analytics
Bangalore
03.2016 - 08.2018
  • Responsible for establishing effective data management and governance practices as the inaugural team member of the company.
  • Gained experience in diverse domains and sectors by working on procurement analytics, invoice analytics,
    spend analytics, supply chain management/analytics,and IOT (Internet of Things) anayltics.
  • Engaged with Airbus (Germany) to construct a digital twin of their Hamburg plant, enabling efficient production of the A320 series while incorporating an advanced predictive analytics system.
  • Utilized tools such as AWS Cloud, Azure Cloud, Talend, and Tableau to lead and manage the startup's data ingestion, pipeline, and analytics team. Also worked extensively with Hadoop and big data systems, like HDFS, for efficient processing of large-scale datasets.
  • Engaged in numerous startup cohorts and exhibitions to present our analytics solution.
  • Successfully built and coordinated a dynamic team consisting of over 20 analysts and engineers during the startup's hiring process.
  • Maintained up-to-date knowledge on emerging technologies related to data engineering and analytics.
  • Analyzed large datasets to identify trends and patterns in data.

Senior Software Engineer

Capgemini
Bangalore
06.2013 - 03.2016
  • Managed data load projects in the health and insurance domains, overseeing development and maintenance.
  • Employed Microsoft SQL Server and SSIS as part of data migration process, efficiently transferring information from flat files to SQL tables.
  • Efficiently managed and scheduled more than 50 ETL loads for daily/monthly execution.
  • Developed comprehensive documentation including High Level Design Documents (HLD), Low Level Design Documents (LLD), Standard Operating Procedures (SOP), and Work Breakdown Structure documents (WBS).
  • Provided guidance to newly hired individuals regarding project processes, clean code wiring and script optimizations.
  • Performed unit testing on application components prior to release.
  • Optimized databases to improve query performance.

Communication Engineer

Edge Telecom
Pune
06.2012 - 06.2013
  • Provided support and maintenance on optical fiber communication network across India.
  • Worked with telecommunication technologies like SDH, DWDM for root cause analysis.
  • Created understanding documents, shift change, and task handover documents for the process.

Education

Electronics And Communication

Himachal Pradesh University
05-2012

Skills

  • 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
  • SQL Language
  • Talend DI
  • Tableau
  • Data Reporting
  • Data Insights
  • Data Analytics
  • Machine Learning
  • Linear Regression
  • Logistic Regression
  • Data Pipelines
  • Data Load Strategies
  • Business Intelligence
  • Data Stories
  • Data Security
  • Decision-Making
  • Database structures

Websites

Timeline

Analytics Manager

Power2SME
10.2023 - Current

Senior Technical Lead

Birlasoft Technologies
05.2022 - 10.2023

Technical Lead

HCL Technologies
09.2018 - 05.2022

Lead Analytics Engineer

Neewee Analytics
03.2016 - 08.2018

Senior Software Engineer

Capgemini
06.2013 - 03.2016

Communication Engineer

Edge Telecom
06.2012 - 06.2013

Electronics And Communication

Himachal Pradesh University

Similar Profiles

CREATE PROFILE
ARPIT GOEL