Power Bi Data Analysis
Resume:
Tad Mez
********@*****.***
SUMMARY
●Skilled in creating interactive dashboards and visualizations using Power BI and Tableau.
●Experienced with SQL for querying, manipulating, and managing databases.
●Proficient in Python and R for statistical analysis, visualization, and machine learning.
●Conduct exploratory data analysis and derive meaningful insights using Python and R.
●Utilize Jupyter Notebook for collaborative data analysis and documentation.
●Identify trends and patterns within datasets through statistical analysis and visualization.
●Cleanse and preprocess data to ensure integrity and accuracy.
●Conduct hypothesis testing and regression analysis for actionable insights.
●Experienced in time series analysis and forecasting for predicting future trends.
●Communicate findings and insights effectively through visualizations and presentations.
●Deliver actionable recommendations based on data analysis to drive business decisions.
●Understand data governance principles for maintaining quality and security.
●Collaborate with cross-functional teams to gather requirements and deliver solutions.
●Leverage external libraries and packages in Python and R for efficient analysis workflows.
Skills
●RDBMS/Databases: MSSQL, Oracle, Postgres, MongoDB, TOAD 7.5, SQL Developer, MS Access.
●BI Tools: Power BI Desktop, Power BI Service, Tableau, SSAS, Crystal Reports, MS Excel, SSRS
●SQL Server Tools: SQL Server Management Studio, BIDS, SQL Server Profiler, FTP, TOAD.
●Methodologies: Agile, Waterfall, Data Modeling Logical/Physical/Dimensional, MS Project.
●Cloud Services: Microsoft Azure, AWS, Snowflake, Oracle Enterprise Manager Cloud.
Education and Certification:
●MSc Degree in Software Engineering
Ally Bank - Midvale, UT Mar 2021 – present
Sr. Data Analyst /Power BI Developer
Roles and Responsibilities
●Develop interactive dashboards and reports using Power BI and Tableau to facilitate data-driven decision-making.
●Write SQL queries to extract and manipulate data from databases for analysis purposes.
●Utilize Python and R programming languages in Jupyter Notebook for advanced statistical analysis and predictive modeling.
●Designing Power BI dashboards and managing the power BI gateways with a focus on usability, performance, flexibility, testability, and standardization.
●Design and develop Power BI reports and Dashboards (Operational, Strategic & Analytical) including data set ingestion and transformation, Data Modeling, and Data Analysis Expressions (DAX) using the appropriate report templates depicting the status of key performance indicators (KPIs) and other important business metrics for an organization to make data-driven decisions
●Utilizing Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
●Perform exploratory data analysis (EDA) to uncover insights and trends within datasets.
●Collaborate with stakeholders to gather and understand data requirements for analysis.
●Cleanse and preprocess data to ensure accuracy and reliability in analysis.
●Implement machine learning algorithms and techniques to derive actionable insights from data.
●Conduct regression analysis and hypothesis testing to validate findings and make informed recommendations.
●Create and maintain data pipelines to automate data extraction, transformation, and loading processes.
●Develop and present data-driven reports and visualizations to communicate findings effectively.
●Provide training and support to colleagues on data analysis tools and techniques.
●Participate in data governance initiatives to ensure compliance with regulations and standards.
Environment Power BI Desktop, Power BI Service Pro, Business Objects, SharePoint, QlikView,SQL, MSSQL, MS Access, Microsoft Excel
Dillard's, Inc. - Little Rock, Arkansas Sep 2018 – Feb 2021
Data Analyst
Responsibilities:
●Perform data analytics utilizing Python and pandas, extracting insights from diverse datasets to guide data-driven decision-making.
●Develop visually engaging and interactive data visualizations and dashboards in Tableau, empowering stakeholders to explore data intuitively.
●Create comprehensive reports that clearly communicate analytical findings and key performance indicators (KPIs).
●Process and cleanse data to ensure accuracy, completeness, and consistency, facilitating reliable analysis.
●Utilize advanced SQL queries to retrieve and manipulate data from various sources, ensuring data readiness for analysis.
●Integrate AWS Redshift with Tableau for seamless data connectivity, enabling real-time data exploration.
●Generate impactful reports using Tableau, presenting crucial metrics and insights to support business decision-making.
●Collaborate cross-functionally to grasp business requirements and deliver data analytic solutions.
●Implement best practices in data visualization to produce compelling and easy-to-understand visual representations of complex data.
Environment: Power BI Desktop, Power BI Service, Project Online, SSAS, DAX, Tableau, Microsoft Azure, Python, SharePoint, Visual Studio, Scrum/Agile, XML, SQL Profiler, TFS, MS Office
Signature Bank - New York, NY Feb 2016 – Aug 2018
SQL/SSIS Developer
Responsibilities:
●Foster collaboration with diverse teams to gather and assess data requirements, offering effective data solutions.
●Design documents and requirements to comprehend the operational aspects of both source and target systems.
●Formulate well-optimized SQL queries that align with specified data retrieval needs.
●Create and refine T-SQL stored procedures, functions, triggers, and views.
●Address SQL Server performance issues by enhancing query efficiency, optimizing indexing, and configuring database settings.
●Construct intricate SQL queries tailored to extract data from a variety of sources, such as flat files, Excel spreadsheets, and Oracle databases.
●Develop and oversee SSIS packages to facilitate seamless data integration and transformation.
●Design, validate, and deploy SSRS reports utilizing SQL Server Reporting Services (SSRS).
●Customize database schemas and objects, including tables, indexes, and views, to meet evolving business requirements.
●Implement comprehensive database security measures, encompassing roles and permissions for distinct user groups.
●Maintain comprehensive documentation encompassing database designs and procedural guidelines.
●Deliver technical support and resolve issues concerning SQL Server, SSIS, and SSRS for end-users.
Environment: Microsoft SQL Server 2012/2014, visual studio, Power BI, SAP -Hybris, MuleSoft. .Net, GIT, Jira, and Tableau.
Contact this candidate