Over 7 years of experience as a Data Analyst/ Senior ETL Developer, with progressive responsibilities in data analysis with focus on Financial Reporting, Data Profiling, Data Cleansing and Business Intelligence. * Accomplished Senior IT professional with a background in ETL Design and Development, handling Financial Data and Commercial Banking, and full life-cycle development. * Worked extensively with ETL tools Ab Initio GDE 2.1.5/3.1.2, IBM Optim, Optim Z, Hydrograph, IBM Datastage 8.5/9.1 for Data Integration and Data Migration projects from on-prem to AWS. * Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary. * Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate * Data sources - RDBMS, Parquet, ASCII, unstructured, JSON, CSV. * Hands on experience on complete Software Development Life Cycle SDLC for the projects using methodologies like Agile, Waterfall and hybrid methods. * Chaired and conducted JAD sessions with business and technical teams. * Extensive experience on interaction with system users in gathering business requirements and involved in developing projects. * Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy. * Strong working experience in Relational Databases - Snowflake, Salesforce, Teradata, MS SQL server and Oracle. * Experience in integrating AWS DataLake repository with Redash to query data sources, perform data analysis and build dashboards. * Vast experience of working in the area of data management including data analysis, gap analysis and data mapping. * Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes using Datawise data quality tool. * 2 years of Experience in building dashboards and reporting solutions using SAP Business Objects and Cognos Business Insight. * Coordinated and prioritized outstanding defects and system requests based on business requirements. * Acted as a liaison between the development team and the management team to resolve any conflicts in terms of requirements. * Capable of managing project while leading cross-functional teams to meet and exceed overall IT initiatives. * Excellent technical, time management, communication, interpersonal and presentation skills. Page | 1 NAVEENA DAVAY ARUNKUMAR