• Worked in Data Analysis, Data Profiling, Data Integration, Migration, Data governance and Metadata Management, Master Data Management and Configuration Management with multiple LOB’s.• Performed Data Profiling, Data Cleansing, Data Quality by importing Data from multiple sources using Alteryx.• Designed and developed Extract, Transform, Load (ETL) workflows using Azure Data Factory, ensuring seamless data integration across diverse sources.• Utilized Azure Logic Apps for orchestrating data workflows and automating data movement processes.• Proficient in ingesting data into MongoDB databases from various sources using tools like mongoimport, mongorestore, or custom ETL (Extract, Transform, Load) pipelines, and migrating data between different database systems.• Utilized Azure Databricks for advanced analytics and machine learning, enabling data-driven insights and predictive modeling. • Managed all data collection, extraction, transformation and load (ETL) activities using Microsoft SSIS, Talend and informatica including data profiling, data cleansing, data conversion and quality control.• Worked on data analysis and ETL solution design by utilizing tools such as Advanced Query Tool, Teradata SQL Assistant, Oracle SQL Developer, SSMS, SSIS, AMM, Infosphere Data Architect etc.

• Identified opportunities and flaws in Supply Chain Logistics by meeting and building relationships with various business stakeholders to increase revenue, decrease cost by converting the same into Analytics project.• Established a hybrid data driven scrum agile framework in the team for prioritization of tasks while achieving best results.• Engage effectively with cross-functional teams to test hypotheses and validate recommendations.• Created and maintained several workspaces, gateways, and permissions as a single point of contact, to access reports which ensured compliance to data security and governance.• Scaled analytics methods, tools, Executive Summary, and Score Cards which better defined key business metrics, P&Ls, improved end user experience, and tracked KPIs for growth.• Built consumable and ad hoc reports using, SQL, Power BI, and Excel to identify business insights, trends which assisted leadership in Strategic Planning, Decision Making and Audits• Designed ETL pipelines in SQL, Power BI using Power Query and DAX to construct dashboard for ‘home time’ trend analysis that resulted in better planning and organizing especially during holiday season by 45%• Quantification of Data Quality and its availability through EDA and statistical modelling to optimize Data Governance processes and created KPIs that brought down data integrity issues by 25%• Financial modelling for new support equipment and performed analysis to check its profitability that saved 265,000 $ per month.

• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.• Created data dictionary, Data mapping for ETL and application support, DFD, ERD, mapping documents, metadata, DDL and DML as required.• Create and maintain product backlog items, bugs, features, etc. in JIRA and TFS / Azure DevOps for story tracking and documentation.• Worked on Snowflake cloud database and used tools like Alteryx and Tableau to present study, analyze and present data• Prepared user stories documentation in JIRA for Agile projects, documented requirements for the development and data migration epic to convert customer data to oracle instance with upgrades.• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the Multi-dimensional data warehouse.• Lead the go-live implementation plan from the business side for digital banking initiatives and partner with other management leads in IT to align organizational readiness plans with delivery plans.• Documenting the Data quality scores in Collibra using integrations with Informatica Data Quality.• Performed data analysis and data profiling using complex SQL on various source systems including Oracle and Teradata.• Experienced in using Granger causality tests to assess causality and property in time series data.• Skilled in creating comprehensive documentation for data models, including data dictionaries, naming conventions, and data model metadata.• Prepared business glossary and metadata with Confidential for all deposit related CDE's.

• Worked on projects involving Data Analysis, Data Management, SQL, problem-solving, and multi-tasking between multiple projects.• Wrote complex SQL queries on daily basis to retrieve data and worked on Teradata, Oracle, MS Access, SQL Server etc.• Involved in documenting the Data quality scores in Collibra using integrations with Informatica Data Quality.• Performed data analysis and data profiling on a day-to-day basis using complex SQL on various source systems including Oracle and Teradata.• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.• Wrote the business requirements in Jira Agile Epics and user stories format and uploaded and assigned the user stories in Jira for both Agile (sprints) methodology.• Proficient in using data modeling tools like ERwin, ER/Studio, IBM Data Architect, or Lucidchart to design data models.• Ensured data quality and consistency within data marts through validation and cleansing processes.• Provided training and support to end-users, enabling them to leverage Looker for their analytical needs.• Experienced in web development using Python, including web frameworks like Django and Flask to build web applications and APIs.• Experience in integrating SSRS reports with other Microsoft technologies like Power BI, SharePoint, or third-party applications.• Experience in integrating Snowflake with other tools, databases, or ETL processes, ensuring seamless data transfer and synchronization.• Experience in using SAS BI tools for creating dashboards, data visualization, and generating insights through reports and analytics.• Worked closely with business stakeholders to gather requirements and translate them into data mart design specifications.• Utilized Looker’s API and SDK for advanced integrations and custom functionality.