Summary
Overview
Work History
Education
Skills
Timeline
Generic

ArunPrasad Dhandapani

Malvern,PA

Summary

Goal-driven Principal Engineer adept at reviewing plans and implementing improvements. Skilled in technical research and expert in Data migration and Data warehouse. Ready for new professional challenges and willing to take on dynamic responsibilities.

Overview

15
15
years of professional experience

Work History

Lead Consultant

WIPRO LIMITED
09.2022 - Current

Data Migration / Technology migration

  • Solution has been migrated from SSIS to Talend and SQL server to SNOWFLAKE
  • Did complete study about the existing system and dependency of each data flow process and source
  • Identified outbound system setup and downstream application dependencies
  • Part of Architecture design team to bring optimized solution in to new environment
  • Defined Process and hierarchy of data processing in the Snowflake environment
  • Responsibility
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Responsible for the planning data migration strategy from SQL to Snowflake
  • Taking care of ETL development with enhancements
  • Coordinating with DB developers and making sure standards in the code
  • Closely working with business users for new requirements
  • Managing complete solution from inbound ETL to Outbound Extracts and reports


Lead Consultant

WIPRO LIMITED
02.2019 - 09.2022

Data Migration and Business transformation

  • Prepared and Implemented data migration strategy from legacy to new developed platform
  • Data profiling has been done to understand data structure and data in business terms
  • Did Analysis on source system to change data load pipeline to new environment
  • Analyzed downstream and upstream systems and impacted areas of migration
  • Designed strategy for parallel processing run without affecting business
  • Been SME for Subject areas and pre-requisite data from business
  • Tools, : SSIS, Azure SQL, Data Profiler

Principal Engineer

Shaw Academy
11.2017 - 12.2018

Data Warehouse

  • Its Product base organization main business is providing education through online (e-learning)
  • Roles and responsibilities
  • Completed design, development and deployment of a data warehouse including a normalized data store for consolidating data from multiple systems as well as dimensional data marts for loading into multidimensional databases for data analysis
  • Data Modeled using Visio for Data Warehouse, deciding on space requirements and backup criteria
  • Developed ETL packages using Talend for loading data into the Redshift environment
  • Created a suite of executive-level reporting from the Redshift warehouse using Tableau
  • Reviewed plans, documents and related materials to assess projected actions and advise on changes.
  • Applied development best practices in daily tasks for efficiency and accuracy.
  • Analyzed and interpreted customer requirements to develop ETL solutions.

Analytic Consultant

Wells Fargo
06.2016 - 09.2017

Data Warehouse

  • SPARC Reporting & Analytics It's a DWH Project which contains data about loan operations and CC
  • Roles & Responsibility
  • SPARC team is responsible for maintaining data mart and supporting various Analytical needs for CC, DA, PL&L, and ICC line of business (LOB) within Consumer lending group
  • Data model ,Designing databases, integrating different data sources, reengineering existing databases
  • Transforming business requirements to SQL procedures and setting up process to be used by other reporting team
  • Monitoring and enhancing daily data load jobs and designing data audit process, quality check etc
  • Supporting SSRS and Tableau reporting team on their various needs of data and help them to improve their report processing
  • Working knowledge of Tableau BI tool
  • Provided technical support for troubleshooting analytics and reporting issues.

Associate consultant

Accenture
05.2014 - 05.2016
  • Developed and modified programs to meet customer requirements.
  • Wrote and optimized in-application SQL statements.
  • Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
  • Interpreted data models for conversion into ETL diagrams and code.
  • Collaborated with multi-functional roles to communicate and align development efforts.
  • Completed quality reviews for designs, codes, test plans and documentation methods.

SQL Developer / SSIS Developer

Wipro Technologies
04.2012 - 04.2014
  • Data warehousing forms backbone of this project; while analysis is based on daily ETL load, handled by SAS. Credit Risk Management Solution of Banking for Ahli united bank has been implemented for different entity with respective business logic
  • Designed and implemented TSQL queries for reporting and complex solution development.
  • Analyzed existing SQL queries to identify opportunities for improvements.
  • Involved in supporting risk management solution for different entity
  • Participated in reports development as per business requirement and participating in UAT with end user to make them understand scenarios
  • Credit Risk Department for Different Countries (Bahrain, Egypt, Iraq, Kuwait, Qatar, UK) and creating reports in SAS environment and resolve issues raised by customers
  • Supporting Adhoc reporting Requests

ETL Developer

Sutherland Global
03.2009 - 02.2012
  • Wrote and optimized in-application SQL statements.
  • Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
  • Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
  • Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.

Education

Bachelor's of Engineering - Computer Engineering

Karpagam College of Engineering
INDIA
2006

Diploma - Computer Science

ArunPrasad Dhandapani
INDIA
2003

Skills

  • Talend
  • SQL Server Integration Services (SSIS)
  • Snowflake
  • MS SQL
  • Developing Databases
  • SQL Reporting
  • Data Warehousing
  • Data Extracting
  • Extraction Transformation and Loading (ETL)
  • Data Warehouse Processing
  • Database Structures Expertise
  • Transforming Data
  • Data Mapping
  • Data Quality

Timeline

Lead Consultant

WIPRO LIMITED
09.2022 - Current

Lead Consultant

WIPRO LIMITED
02.2019 - 09.2022

Principal Engineer

Shaw Academy
11.2017 - 12.2018

Analytic Consultant

Wells Fargo
06.2016 - 09.2017

Associate consultant

Accenture
05.2014 - 05.2016

SQL Developer / SSIS Developer

Wipro Technologies
04.2012 - 04.2014

ETL Developer

Sutherland Global
03.2009 - 02.2012

Bachelor's of Engineering - Computer Engineering

Karpagam College of Engineering

Diploma - Computer Science

ArunPrasad Dhandapani
ArunPrasad Dhandapani