Worked on Gathering requirements and develop various SQL jobs, scripts which involved extensive data analysis and understanding of data warehouse and ETL processes.• Worked with Finance, Risk, and Investment Accounting teams to create Data Governance glossary, Data Governance framework and Process flow diagrams.• Created Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.• Responsible for daily data quality checks and data profiling for accurate and better reporting and analysis.• Understanding of the quality, accuracy, and reliability of big data, as it may contain errors, inconsistencies, or noise that require data cleaning, preprocessing, and validation.• Utilized XML for data integration tasks, enabling the transfer of data between different systems and platforms in a structured format.• Extensive experience in designing, developing, and deploying interactive and visually appealing dashboards and reports using Power BI.• Extensive experience in designing, developing, and implementing ETL processes using Informatica PowerCenter.• Responsible for daily data quality checks and data profiling for accurate and better reporting and analysis.• Provided remediation support during data migration projects, identifying and resolving data issues to ensure smooth and accurate data transfers.• Understanding of the quality, accuracy, and reliability of big data, as it may contain errors, inconsistencies, or noise that require data cleaning, preprocessing, and validation.• Designed and developed complex SSRS reports using SQL Server Reporting Services, including parameterized, drill-down, and sub-reports, to meet diverse business requirements. Wrote complex SQL queries on daily basis to retrieve data and worked on Teradata, Oracle, MS Access, SQL Server etc.

Created Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.• Performed data analysis and data profiling on a day-to-day basis using complex SQL on various source systems including Oracle and Teradata.• Created data dictionary, Data mapping for ETL and application support, DFD, ERD, mapping documents, metadata, DDL and DML as required.• Documenting the Data quality scores in Collibra using integrations with Informatica Data Quality.• Developed dashboards to track and report on the progress of data remediation efforts, providing real-time visibility to management.• Integrated Collibra with business intelligence tools like Tableau, Power BI, and Qlik to enhance data transparency and reporting.• Worked on excel Pivot tables and V-Lookup tables for Data Analysis.• Used advanced Excel to work on large datasets by developing formulas, creating Pivot tables, V-lookup and H- lookup formula development, regression analysis.• Created interactive dashboard and Reports in Tableau for monitoring the operation performance on a day-to-day basis.• Extensive experience in establishing and implementing data governance frameworks to ensure data quality, consistency, and compliance.• Created Power BI Data Quality reports/dashboards for multiple lines of business.• Hands-on Experience in Power BI Power Pivot, Power integrated with Share Point and in creating dashboards in Power BI and Tableau visualization tools.• Designed logical model with all relationships for database; forward engineered it to SQL Server with Erwin, SQL Server, Visual Studios, Power BI, Tableau, and SharePoint.• Created data stories, reports and visualizations using Tableau and Power BI• Extracted data from SQL Server database tables and Oracle database tables into flat data files and Excel sheet.• Used SQL Loader and SQL Developer to load data from flat data files and excel sheet into Oracle database.