Desaley Girmay

Email: adz41w@r.postjobfree.com

Phone: 571-***-****

Status: Authorized to work for any Employer

PROFESSIONAL SUMMARY

An innovative visual analytics consultant with eight 8 of experience in analysis, design, and development of data models and analytics.

I am skilled in leveraging tools such as Power BI, Tableau, and other platforms to deliver exceptional data preparation, conduct complex analyses, and create insightful dashboards.

Throughout my eight years of IT experience in various industries, I have consistently demonstrated high motivation, dedication, and versatility.

My expertise lies in collecting, transforming, and organizing data for analysis, enabling informed decision-making. I possess an excellent understanding and proficiency in platforms such as SQL, Advanced Spread sheets, Power BI, SSRS, and SSIS for effective data analysis.

In addition, I bring strong interpersonal communication, business acumen, technical prowess, and problem-solving skills, along with the ability to adapt to new roles and employ agile project management techniques.

Experience in designing, developing, and maintaining data integration workflows using Azure Data Factory.

Expertise in utilizing these Python libraries for data manipulation, analysis, and processing tasks.

I thrive in multitasking environments, working on multiple projects simultaneously, and I possess a fervent passion for learning new technologies.

WORK EXPERIENCE

Delta Airlines, Detroit MI 06/2021- Present

Power BI Developer

Responsibilities:

•Designing and developing complex Power BI reports and visualization solutions based on business requirement documents, ensuring scheduled data refresh as per business needs.

•Importing data from Amazon Redshift, Teradata, and Ana plan, and creating a data model in Power BI to generate reports.

•Experience in integrating Power BI with various APIs using C# and C++, enabling dynamic and real-time data visualization.

•Experience in integrating VBA/VB scripts and SQL queries with Power BI to create dynamic, data-driven reports and dashboards.

•Installing and configuring Enterprise Gateway and Personal Gateway in Power BI Services.

•Implementing DAX functions for efficient data visualization and various fact calculations in Power BI Desktop.

•Developed custom functions and calculations using NumPy and Pandas to derive new variables, perform mathematical operations, and create calculated fields, enhancing the analytical capabilities of Power BI reports and dashboards

•Proficient in using Power Apps to create business apps involving data connections and user interfaces.

•Proficient in HTML and web development, enabling the creation of interactive dashboards and reports in Power BI that can be embedded into web applications.

•Producing a comprehensive collection of reports, graphs, summaries, and presentations that effectively communicate results, align with business needs, and provide analytical insights.

•Experience in needed language or technology (e.g. - C#, C++, HTML).

•Experience in creating, managing, and delivering Paginated Reports in Power BI.

•Experience in designing, developing, and maintaining data integration workflows using Azure Data Factory.

•Providing guidance and direction to other team members, particularly junior members, on a day-to-day basis.

•Experience you have with Azure Data Factory, Azure Data Factory pipelines, and Azure Data Factory integration with Power BI.

•Utilizing data mining techniques and data visualization tools such as Power BI and SSRS to design reports for stakeholders, enabling informed business decisions.

•Assisting in the development, roll-out, and maintenance of dashboards and SSRS reports that contribute to process improvement.

•Integrated NumPy and Pandas with Power BI to create visually appealing and interactive data visualizations, enabling effective data storytelling and decision-making.

•Designing, deploying, and supporting business intelligence and data warehouse solutions to assist organizational programs in achieving their goals.

•Experience in extracting and transforming data from various sources using SQL queries and Crystal Reports for use in Power BI.

•Experience in data modeling, as this is a key part of creating effective Paginated Reports and ability to create and manage relationships between different data sources.

•Experience in integrating Crystal Reports into web and Windows applications.

•Skilled in integrating Power Apps with other Microsoft services like Power Automate and Power BI.

•Analysing key performance indicators, conducting integration tests, utilizing skills in Jira, and focusing on innovation, documentation, decision making, data modelling, Data Lake, and dashboard maintenance.

•Demonstrating critical thinking and strong communication skills, with expertise in Bit bucket, AWS Redshift, AWS, and architecture.

•Collaborating with IT and business stakeholders to understand business requirements and deliver effective solutions.

•Analysing passenger information to predict volumes.

•Sourcing data from various types of relational databases, flat files, and Excel files.

•Developing SSIS packages with various tasks such as FTP, file system, for each loop, execute package, data flow task; execute SQL task, custom script task, and data mining task.

Centauri Health Solutions, Nashville, TN 03/2018- 05/2021

Power BI Developer/Data Visualization

Responsibilities:

•Designing Microsoft Power BI dashboards and managing Power BI gateways with a strong focus on usability, performance, flexibility, testability, and standardization.

•Developing data analysis prototypes using Power BI and Power Pivot, and utilizing Power View and Power Map to visualize reports in web clients and mobile apps.

•Utilizing Power BI (Power Pivot/View) to design scorecards and dashboards that display information required by different departments and upper-level management.

•Implementing various DAX functions for efficient data visualization and fact calculations in Power BI.

•Performing data analysis based on business requirements by developing SQL queries or utilizing data profiling applications, and creating data profiling reports for data discovery.

•Applying common transformations such as aggregate, data conversion, conditional split, and lookup, merge, and sorter transformations.

•Expertise in using SQL queries and VBA scripts to extract and transform data from various sources into a format suitable for Power BI.

•Collaborating with Data Architects, DBAs, and Business Intelligence teams to design and support end-to-end data solutions across multiple platforms.

•Designing and developing graphical and visualization solutions using Quick Sight and Power BI, ensuring scheduled data refresh as per business needs.

•Proficiency in working with Azure services, such as Azure Data Lake Storage, Azure SQL Database, Azure Analysis Services, and Azure Machine Learning.

•Demonstrating skills in metadata management.

•Installing and configuring Enterprise Gateway and Personal Gateway in Power BI Services.

•Publishing Power BI reports in Power BI Server and scheduling dataset refresh for live data.

•Creating interactive dashboards, email reports, and built-in analytics to provide business users with insights and actionable information.

•Developing Business Intelligence/Analytical Dashboards and reports in Power BI, incorporating global filters, calculated columns, complex DAX calculations, and transformations using Query Editor and Power Query Formula Language (M).

•Building Power BI dashboards, detailed and summary level reports with KPIs, advanced analysis capabilities, calculations, parameters, maps, scatter plots, trend lines, statistics, and log axes.

•Working on Power BI dashboards, visualizations, report publishing, scheduling, refreshing, and automation.

•Publishing live interactive data visualization dashboard reports and workbooks from Power BI Desktop to Power BI servers.

•Experience in creating complex formulas and developing custom functions in Crystal Reports.

•Conducting training sessions for Power BI users and creating support documents for end users.

•Collaborating closely with business users, vendors, and delivery teams to understand business requirements and design effective analytics and reporting solutions.

•Resolving performance issues and optimizing process distribution for different projects.

MetLife, Newark, NJ 11/2014 – 02/2018

BI and SQL Developer

Responsibilities:

•Engaging in query optimization to enhance the performance of reports.

•Developing reports for business end-users using Report Builder and updating statistics.

•Creating charts and pivot tables in Excel for data analysis and visualization.

•Establishing ETL design practices to optimize and improve the performance of packages and parameterized SSIS.

•Updating functional specifications and technical design documents to align with project requirements.

•Developing reports with complex formulas and database querying using SSRS, generating various ad-hoc reports.

•Analyzing existing ETL jobs to identify gaps and areas for improvement.

•Creating complex stored procedures, SSIS packages, triggers, cursors, tables, views, and SQL joins and statements for application development.

•Designing OLAP systems using ERWIN to visualize data structures and support analysis.

•Extracting data from heterogeneous sources and transferring it to OLAP using SQL Server Integration Services (SSIS).

•Creating low-level designs and ETL design documentation based on project requirements.

•Designing and developing SSIS packages to export and import data from CSV files, text files, and Excel spread sheets.

•Creating matrix and tabular reports with drill-down, drill-through, and drop-down menu options using SSRS.

•Developing ad-hoc reports, summary reports, sub-reports, and drill-down reports using SSRS and Visual Studio.

•Identifying and troubleshooting database problems, resolving issues, and tuning indexes for optimal performance.

•Collaborating with technical architecture teams to align development efforts with overall system architecture.

•Creating alerts to notify users of successful or unsuccessful completion of scheduled jobs.

•Writing complex SQL queries, stored procedures, triggers, functions, indexes, tables, views, and T-SQL code for application development.

•Gathering business requirements from users and translating them into technical specifications and design documents.

•Participating in requirements gathering and analysis meetings, describing the analysis and approach to stakeholders.

•Power BI development and administration, including designing and developing Power BI dashboards and reports.

•Creating and managing SQL Server jobs using SQL Server Integration Services (SSIS) packages for automated execution based on specific schedules.

•Utilizing SSIS extensively for data movement from text files to SQL Server databases.

•Creating complex ETL packages with SSIS to extract data from staging tables and load it into partitioned tables incrementally.

•Proficiency in using SSIS Control Flow items (For Loop, Execute Package/SQL tasks, Script task, Send Mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy Lookup, Fuzzy Grouping, Pivot).

•Collaborating with cross-functional teams and leveraging various programming languages such as SQL, R, JavaScript, and Python.

•Applying technical architecture principles, utilizing metadata skills, and working with scalable solutions.

•Creating logging mechanisms at the package and task level in SSIS to track the number of records processed.

•Collaborating with Airport Customer Service teams to build key performance indicators (KPIs) and reports for measuring and incentivizing business partners at different stations.

Education:

•BA in Economics from Addis Ababa University, Addis Ababa, Ethiopia (1999-2003)

•MA in Economics from Indira Gandhi Open national University, India (2012-2014)

Certifications:

•Earned the Certified Manager designation from the Institute of Certified Managers, JMU, USA in April 2021.

•Achieved a Certificate of Professional Project Management from Google Project Management through Coursera in 2022.

•Completed the Google Professional Certificate on Data Analytics via Coursera in 2022.

Contact this candidate