Data Migration Warehouse

Malvern, PA ***** +1-484******* ******.**********@*****.***

.

ARUNPRASAD DHANDAPANI

PROFESSIONAL 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.

SKILLS

Talend Integration

SQL Server Integration Services (SSIS)

Snowflake

MS SQL

Developing Databases

SQL Reporting

Data Warehousing

Data Migration

Transformation and Loading (ETL)

ELT

Database Structures Expertise

Data Mapping

Data Quality

Data Profiling

Data cleansing

WORK HISTORY

LEAD CONSULTANT 09/2022 to Current

WIPRO LIMITED

Data Migration / Technology migration

Existing Integration solution has been migrated from SSIS to Talend

Migrating Datawarehouse from MS 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

Roles and 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 02/2019 to 09/2022

WIPRO LIMITED

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 11/2017 to 12/2018

Shaw Academy, Bangalore

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 06/2016 to 09/2017

Wells Fargo

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 05/2014 to 05/2016

Accenture

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 04/2012 to 04/2014

Wipro Technologies

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 03/2009 to 02/2012

Sutherland Global

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

Karpagam College of Engineering, INDIA

Bachelor of Engineering, Computer Engineering.

District of Technical Education (MPNMJP) INDIA

Diploma in Computer Science.

Contact this candidate