Duncan Wachi

About Duncan Wachi

Industry Experience: 7+ years as a Data Analyst across Telecommunication, Insurance, and Banking domains. • Data Warehousing Expertise: Proficient in business requirement gathering, development, enhancement, testing, production support, and data profiling. • Documentation Mastery: Extensive experience in crafting Business Requirements Documents (BRD), Functional Specification Documents (FSD), Technical Requirement Documents, and testing documentation. • Enterprise Data Management: Skilled in data lineage, ETL data mapping, transformations, metadata, and data flow/process flow diagrams. • Data Analysis Proficiency: Adept at data validation, cleansing, profiling, and mining. • SQL & Cloud Expertise: Advanced SQL skills for querying databases, with hands-on experience using Snowflake, Alteryx, Tableau, and Snowpipe for data analysis and visualization. • Data Modeling Tools: Expertise in Erwin and PowerDesigner for logical, conceptual, and physical modeling. • Data Quality Tools: Proficient in IBM Information Analyzer, Collibra, and Microsoft Visio for data lineage and governance. • Data Architecture Knowledge: Strong understanding of Star Schema, Snowflake schema, FACT & Dimensions tables, and 3rd Normal Form (3NF) design. • Technical Skills: Hands-on with SAS 9.2, Informatica PowerCenter 10.0, Mainframe systems, and IDQ (Informatica Data Quality). • Control & Scheduling: Familiar with Control-M for supporting operating systems and database processes. • Visualization & BI Tools: Proficient in Tableau, Alteryx, and Cognos8 for business intelligence and reporting. • ETL Tools: Experience with Microsoft SSIS, Talend, and Informatica. • Cloud Platforms: Worked with Azure Data Lake, Azure Data Factory, Azure Synapse, and Databricks.

Experience

1. Data Analyst

   Verizon

   Jun 2023 — Present · Dallas, TX, US

   Developed comprehensive data management strategies for metadata, data lineage, and defect tracking.• Conducted in-depth data analysis, profiling, metadata management, and data governance.• Designed data quality solutions with a focus on implementation, monitoring, and reporting.• Built real-time analytics platforms using Spark SQL and Spark Streaming.• Authored complex SQL queries for data transformation and integration in Ab Initio Express IT.• Managed data dictionaries and mappings using Collibra for data governance.• Migrated on-prem databases to Azure Data Lake with Azure Data Factory.• Streamlined workflows with Salesforce to enhance client engagement and team efficiency.• Created Alteryx workflows and Tableau dashboards for advanced data visualization.• Defined data quality dimensions (completeness, accuracy, consistency, uniqueness) and implemented data lineage solutions.

Education

• Moi University

  Bachelors

  2006 — 2010