Data Analyst
CurrentAs a Data Analyst and BI Developer, I specialize in leveraging advanced tools and techniques to optimize data processes and deliver insightful analytics. Data Analysis and Quality: Identifying data sets, source data, and metadata. Performing data validation, cleansing, verification, and resolving data mismatches.Informatica and SQL: Creating data profiles using Informatica Data Explorer (IDE) & Data Quality (IDQ). Automating data cleaning using SQL scripts and migrating DTS packages to SSIS.ETL and Data Migration: Utilizing SQL, SSIS, and SAS for ETL processes. Migrating data from various sources to SQL Server databases and ensuring data integrity.BI Reporting and Visualization: Designing and implementing Power BI dashboards and SSRS reports. Developing tabular and matrix reports, charts, and graphs based on customer requirements.Data Modeling and MDM: Designing STAR schemas for data marts and developing MDM data models. Creating roadmaps for MDM solutions and ensuring data consistency across systems.SQL and PL/SQL: Writing complex queries for data validation and analysis. Developing stored procedures, views, and conducting performance tuning for OLTP and OLAP environments.Customer and Business Engagement: Translating business requirements into data solutions, performing root cause analysis, and documenting requirements. Delivering high-quality data insights and reporting.Passionate about turning data into actionable insights and continuously improving data processes to support strategic decision-making.