Data Analyst Civil Engineering

Martha Birru

Seattle, WA *****

PROFILE

●A highly motivated BI Developer with around 5 years of experience in interpreting and analyzing different domains of data for driving business solutions.

●Extensive experience in SQL Server, Power BI, Business Objects, and Tableau.

●Authorized to work in the US for any employer.

PROFESSIONAL SUMMARY

●Around 5 years of experience in analyzing, designing, and developing client/server, Business Intelligence (BI) database applications, Requirement Elicitation, ETL, Data visualization, Analytics, Data Integration and related database Platforms in the Banking sector, Parking and oil and gas industry.

●Experienced in developing Statistical models to perform predictive data analysis.

●Extensive experience using data cleansing techniques, Excel pivot tables, formulas, and charts.

●Excellent skills in analytical analysis and proven ability to read and interpret different points of data.

●Experience in analyzing, designing, and developing client/server, Business Intelligence (BI) database applications, Requirement Elicitation, ETL, Data visualization, Analytics, Data Integration and related database Platforms in the Parking and oil and gas industry.

●Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.

●Proficient with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.

●Experienced in ETL, data analysis with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping and Data Modeling.

●Experience in OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration.

●Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), AGILE Methodologies.

TECHNICAL SKILLS

●Programming and Scripting: SQL, R, T-SQL, PostgreSQL, HTML, PHP, JavaScript

●Database Tools: Microsoft SQL Server 2008/2012 and MS Access.

●Data and Analytic Tools: Power BI, Tableau.

●Others: Git, Pivot tables, VLOOKUP, SharePoint, ServiceNow

EDUCATION

●Bachelor of Science, Civil Engineering, Gondar University 2016

COURSE CERTIFICATES

●Querying Data with Transact -SQL EDX Microsoft verified Certification

●Data Analysis and technical decision-making process - University of Washington, Seattle

PROFESSIONAL EXPERIENCE

Role: Power BI Developer

Nov 2020-Current

Client: AP Professional for Nike, Seattle, WA

Responsibilities:

●Motivated and results-driven BI developed with a proven track record in Business Intelligence (BI), Data Warehouse (DWH) and Data Analytics related consulting projects. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.

●Have excellent skills in Data Warehouse, Relational and Multi-Dimensional database, Data Migration, System & Data Integration, Reporting Analysis and Software Development and Data Management.

●Experienced in developing, implementing, documenting, monitoring and maintain the data warehouse extracts, transformations and ETL process.

●Extensive professional experience in design, development, and support of mission-critical Business Intelligence (BI) applications.

●Delivered BI reporting solutions in Power BI and Reporting Services (SSRS)

●Experience with all phases of software development life cycle (SDLC) and Agile methodologies.

Role: BI Developer

April 2020 – Nov 2020

Client: FIS Global, Seattle, WA

Responsibilities:

●Performs research and analysis to support business operations.

●Plans and designs business processes and makes recommendations and changes in order to improve and support business systems and activities and/or to deliver greater effectiveness and efficiency.

●Design, develop, test, and maintain Tableau functional reports based on user requirements

●Utilizes systems and data to resolve business issues in the most effective and productive manner.

●Analyzes and documents business processes and metrics and identifies improvement opportunities.

●Manage SNOW(ServiceNow) from CSM report migration.

●Completed in-depth analyses for business-optimization projects, reporting tools, back-office programs.

Data Analyst

Oct 2018 – April 2020

Client: Reef Parking, Seattle, WA

Responsibilities:

●Converted parking data into actionable insights by predicting and modeling future outcomes.

●Created interactive dashboards in Power BI to assist end-user decision making.

●Involved in the design and development of user interfaces and customization of Reports using Power BI and designed cubes for data visualization, forecasting reports using historical data.

●Generated various presentable reports and documentation using report designer.

●Analyze data model, write business algorithms using stored procedures and queries, and perform proof of concepts for new data architecture.

●Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detailed analysis and design.

●Preparing Dashboards using calculations, parameters in Power BI.

●Evaluated data profiling, quality, cleansing, integration, and extraction tool.

●Performed data analysis on the target tables to make sure the data as per the business expectations.

●Environment: SQL, Power BI, SSIS, SSRS, SharePoint, Advanced Excel

Data Analyst

June 2017 – Sep 2018

Client: Bazean Corp, Seattle, WA

Responsibilities:

●Analyzed data from multiple sources, developing reports, providing valuable insights.

●Facilitating data driven making in the oil and gas industry.

●Extracted data using OLTP and OLAP connections.

●Created dashboards for analyzing POS data using Tableau 7.0.

●Monitored workflow process to enter, create, or change the data.

●Conducted or performed data modeling exercises in support of subject areas and/or specific client needs for data, reports, or analyses, with a concern towards reuse of existing data elements, alignment with existing data assets and target enterprise data architecture.

●Created pivot tables interactive dashboards for measuring the impact of data mapping changes.

●Modified spreadsheets to achieve analytical goals.

●Developed conceptual, logical, and physical Enterprise Data Model based on industry standards.

●Involved in preparing logical data models and conducted controlled brain-storming sessions with project focus groups.

●Generated reports using Microsoft Excel Pivot tables.

●Worked with SQL, Stored Procedures, Triggers, Advanced T-SQL queries

●Rationalized the relationships expressed in the logical data model to the schema of the physical data store (that is, database tables and columns).

●Developed complex SQL queries, and performed execution validation for remediation and Analysis.

●Worked with cross-functional teams to build out data queries that highlight potential issues and changes to check erroneous data.

●Environment: Power BI, SQL Server 2012, SQL, MSOffice (Word, Excel, and PowerPoint), MS Project, MS Access, CSV files, Erwin

Dec 2015 – May 2017 (Moved from Ethiopia to US)

Role: Engineering Data Analyst

Aug 2012 – Nov 2015

Client: NIB Engineering, Addis Ababa, Ethiopia

Responsibilities:

●Gathered business requirements through interviews, surveys, prototyping and observing from civil engineers and site managers

●

●Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.

●Identified entities and attributes and developed conceptual, logical, and physical models using Erwin.

●Used reverse engineering to create Graphical Representation (E-R diagram) and to connect to existing databases.

●Developed data mapping documents between Legacy, Production, and User Interface Systems.

●Used SAP (Structural Analysis Program) for load analysis.

●Creating or modifying the T-SQL queries as per the business requirements.

●Designed and Developed SQL database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data.

●Environment: SQL, Advanced Excel, AutoCAD, SAP

Contact this candidate