ArunPrasad Dhandapani

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

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

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.

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.

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

• 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

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