Nigsh Kidanewold
Richardson
Summary
- Accomplished data analyst with over 7 years of experience transforming raw data into actionable insights to drive strategic decision-making.
- Proficient in leveraging Power BI to develop dynamic dashboards and comprehensive reports, seamlessly integrating data from diverse sources for impactful visualization.
- Expertise in SQL Server with a strong command of writing and optimizing complex queries, managing relational databases, and performing ETL processes to ensure data integrity and high performance.
- Skilled in using tools like SSIS and Talend for efficient data transformation and loading.
- Proficient in designing and managing scalable data pipelines using technologies like Apache Spark and Azure Data Factory, ensuring seamless data flow and timely reporting through robust data warehousing solutions.
- Advanced knowledge of Python for data manipulation, predictive modeling, and process automation, with expertise in libraries such as Pandas, NumPy, and Scikit-learn to deliver efficient solutions.
- Strong background in data security practices, including encryption, role-based access control (RBAC), and compliance with organizational and industry standards to safeguard sensitive information.
- Skilled in workflow optimization and process automation using Python scripts and Power Automate, driving efficiency and reducing manual effort across operational processes.
- Experienced in creating user-focused documentation, delivering end-user training, and providing ongoing support to ensure optimal utilization of data tools and analytics solutions.
- Solid experience in project management and cross-functional team collaboration, utilizing tools like JIRA, GitHub, and Confluence for effective project tracking, version control, and team coordination.
- Proficient in advanced data visualization techniques, crafting custom visualizations in Power BI to uncover trends, correlations, and insights that inform business strategies.
- Demonstrated ability to integrate and analyze data from cloud platforms, including Azure SQL Database and Google BigQuery, enabling comprehensive cross-platform analytics and reporting.
- Adept at troubleshooting and resolving complex data issues, maintaining data integrity and accuracy across multiple systems and platforms.
- Exceptional communicator with a proven track record of presenting analytical findings to stakeholders, translating complex technical insights into actionable recommendations to support business objectives.
Overview
8
8
years of professional experience
Work History
Data Analyst \ Power BI Developer
Charles Schwab Bank
09.2024 - Current
- Designed and developed interactive Power BI dashboards and reports to provide real-time insights into key performance indicators (KPIs), supporting data-driven decision-making.
- Integrated data from various sources, including SQL Server, Oracle, Azure SQL Database, and cloud platforms, to build comprehensive business intelligence solutions.
- Optimized SQL queries and improved database performance to enhance data retrieval and ensure accurate, efficient reporting.
- Leveraged Power Query and Python for automation and data transformation, reducing manual effort and increasing reporting accuracy.
- Utilized Python libraries like Pandas, NumPy, and Scikit-learn for advanced predictive analytics and trend analysis, aiding strategic planning.
- Collaborated with stakeholders to gather business requirements and translate them into effective Power BI solutions aligned with organizational objectives.
- Implemented data governance practices such as role-based access control (RBAC) and encryption to maintain data security and compliance.
- Delivered hands-on training sessions and created comprehensive documentation to ensure smooth adoption and effective utilization of Power BI tools.
- Managed and optimized ETL processes using SSIS and Talend, ensuring seamless and accurate data flow for reporting purposes.
- Combined and processed data from diverse sources like CSV, Excel, SharePoint lists, and external databases to support flexible and thorough analytics.
- Designed scalable data pipelines using Apache Spark and Azure Data Factory, improving data processing performance and enabling real-time insights.
- Led BI projects in agile environments, coordinating with cross-functional teams using JIRA and GitHub for efficient project management and version control.
- Applied industry best practices for data security and compliance, safeguarding sensitive information and adhering to organizational standards.
- Provided actionable insights through in-depth data analysis, driving process improvements and supporting strategic business decisions.
- Environment: Utilizing Power BI, SQL Server, Python, Power Query, Apache Spark, Azure Data Factory, SSIS, Talend, and cloud services like Azure SQL Database and Google BigQuery to support data analytics, reporting, and business intelligence solutions.
Data Analyst\power BI
Kroger Co.
07.2020 - 08.2023
- Designed and developed interactive dashboards and detailed reports using Power BI, integrating data from various sources such as CSV, Excel, SharePoint lists, external databases, and cloud platforms to support business decision-making.
- Created advanced visualizations and custom reports in Power BI Desktop and Power BI Service, providing real-time insights and enabling seamless collaboration within a cloud-based data analytics environment.
- Utilized Power Query for data transformation and preparation, optimizing workflows and improving the accuracy of reporting.
- Managed and optimized complex queries in SQL Server to ensure high data accuracy and performance within a relational database environment.
- Executed ETL processes with SSIS and Talend, maintaining data integrity across relational databases and ensuring seamless data flow.
- Developed and maintained scalable data solutions using Apache Spark and Azure Data Factory, supporting efficient and accurate reporting in a cloud-based infrastructure.
- Applied Python libraries, including Pandas, NumPy, and Scikit-learn, for advanced data analysis, predictive modeling, and automation of repetitive tasks to enhance efficiency and provide deeper insights.
- Leveraged advanced Excel functions, including pivot tables, macros, and complex formulas, for data manipulation and reporting in a structured data environment.
- Implemented scalable data pipelines integrating Oracle and cloud platforms such as Azure SQL Database and Google BigQuery, ensuring robust analytics and seamless data integration.
- Automated data integration processes, ensuring timely and reliable data availability for stakeholders within a high-performance analytics environment.
- Established and enforced data security protocols, including role-based access control (RBAC) and encryption, to safeguard sensitive information and maintain compliance with organizational standards in a secure data ecosystem.
- Utilized data governance tools like Collibra and Talend Data Quality to uphold data accuracy and ensure adherence to regulatory standards.
- Automated reporting workflows using Python scripts and Power Automate, significantly reducing manual effort and improving operational efficiency in a streamlined workflow environment.
- Streamlined workflows and enhanced reporting accuracy through automation of data preparation and visualization processes within a dynamic and collaborative data environment.
- Environment: Power BI, SQL Server, Oracle, Power Query, Python (Pandas, NumPy, Scikit-learn), SSIS, Talend, Azure Data Factory, Apache Spark.
SQL Database Developer
BMO Harris Bank
05.2018 - 06.2020
- Designed and developed complex SQL queries and stored procedures to support robust data retrieval and reporting needs.
- Managed and optimized SQL Server databases, enhancing performance and ensuring high data accuracy and integrity.
- Developed and maintained data warehousing solutions using Apache Spark and Azure Data Factory, enabling efficient data flow and accurate reporting.
- Executed ETL processes using SSIS and Talend, ensuring reliable data integration and maintaining data quality across relational databases.
- Utilized advanced SQL techniques and tools to automate data extraction, transformation, and loading, streamlining data workflows and improving operational efficiency.
- Created and optimized scalable data pipelines, integrating data from diverse sources including CSV, Excel, SharePoint lists, Oracle, and cloud platforms (Azure SQL Database, Google BigQuery).
- Applied data governance practices and implemented security protocols, including role-based access control (RBAC) and encryption, to safeguard sensitive information and ensure compliance.
- Collaborated with stakeholders to gather requirements and translate them into effective SQL-based solutions that meet business needs.
- Leveraged Python (Pandas, NumPy) for advanced data analysis and automation of repetitive SQL tasks, enhancing data insights and efficiency.
- Developed comprehensive documentation and training materials for SQL processes and solutions, facilitating knowledge transfer and effective use of database systems.
- Utilized SQL Server tools and features to monitor database performance and implement optimization strategies, ensuring reliable and efficient database operations.
- Environment: SQL Server, SSIS, Talend, Apache Spark, Azure Data Factory, Python (Pandas, NumPy), Oracle, Azure SQL Database, Google BigQuery
Education
Bachelor’s -
Certified Power BI Professional - undefined
Certified SQL Server Database Administrator - undefined
Skills
- Data Analysis & Reporting: Power BI (Desktop, Service, Mobile), interactive dashboards
- Database Technologies: SQL Server, Oracle, Azure SQL Database, Google BigQuery
- Data Integration & Pipelines: Apache Spark, Azure Data Factory, live connections to CSV, Excel, SharePoint lists, external databases
- Programming & Scripting: Python, advanced Excel functions, SQL, T-SQL, DAX
- Data Security & Compliance: Implementing RBAC, encryption, GDPR, HIPAA compliance
- Automation & Workflow: Power Automate, reporting process automation, PowerShell scripting
- End-User Support: Training, documentation, support for data tools, Power BI service management
Timeline
Data Analyst \ Power BI Developer
Charles Schwab Bank
09.2024 - Current
Data Analyst\power BI
Kroger Co.
07.2020 - 08.2023
SQL Database Developer
BMO Harris Bank
05.2018 - 06.2020