Data Analyst

Aisha Rumman

202-***-**** *****.**********@*****.*** US Citizen

Objective

An experienced and self-driven data analyst looking for employment to further build her skills. Looking for a challenging role to work on a variety of different Business Intelligence technologies. Possessing extensive knowledge of SQL, TSQL, Power BI, Tableau, Basic Python, SSIS. Highly resourceful, professional, dedicated, hard worker looking to improve a company's performance through skills gained in data analysis and creative problem solving.

PROFESSIONAL SUMMARY

·Over 3+ years of experience in analyzing data to drive successful business solutions.

·Excellent understanding of business operations and analytic tools for effective analysis of data.

·Performed Data validation, Normalization & Data-Cleansing on multiple data sources to have the highest quality information.

·Experienced with report analysis and development using business intelligence tools such as Tableau and Power BI.

·Proficient in design and development of various dashboards, reports on Power BI Visualizations such as bar-charts, scatter plots, pie-charts, maps, funnel charts, line charts, donuts & bubbles, etc.

·Experienced in building complex Tableau dashboards with advanced functions to provide insightful analysis, identify growth opportunities, and maximize profits.

·Capable of writing SQL queries and optimizing the queries in Oracle SQL Developer, and SSMS.

·Excellent knowledge in Data Analysis with large data sets of Structured and Unstructured data.

·Proficient in blending data using multiple data sources (primary and secondary).

·Hands-on experience on pulling data by using SQL Server and SSIS from the database automatically.

·Excellent understanding of Visualization Techniques by creating summary and detailed reports using Drill Down, Drill Through & Hierarchies techniques.

·Developed a deep understanding of data trends; identified outliers, exceptions, and data inconsistencies.

·Experienced in using Pandas for data cleaning, manipulation, and analysis.

·Strong in technical skills, analytical thinking, problem solving, communication skills, and time management. Very Motivated, Disciplined, ambitious, detail oriented, goal driven and fast learner.

PROFESSIONAL EXPERIENCE

Alliance Tek Solutions, Virginia Data Analyst June 2021- Present

Responsibilities

·Worked with Stakeholders and End Users to gather requirements to build Risk Modules.

·Excellent understanding of business requirements and raw data for effective data analysis.

·Performed data profiling on data warehouses and other business systems to assess data quality. Strong in organizing large datasets of profiled data and validating it.

·Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, and structure and to maintain data efficiently.

·Created data flow diagrams, data mapping from Source to stage, and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.

·Present Dashboards and ad hoc analyses in Power BI to key stakeholders to increase adoption and understanding of key performance indicators (KPIs) and business drivers.

·Contributed to building business dashboards to conduct trend analysis on metrics relating to driving revenue and investments.

·Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

·Excellent communication abilities and compelling presentation skills.

·Contributed to developing Machine learning modules for risk prediction.

·Drafted quarterly and yearly reports on company financial metrics to assess successes and account for deficiencies.

·Experienced in creating, and configuring workflows designed in SQL Server Integration Services (SSIS)

·Highly skilled in leveraging Excel to drive data-driven insights for the business.

·Proficient in statistics, mathematics, and analytics. Excellent understanding of business operations and analytics tools for effective analyses of data.

AmWINS, Georgia Data Analyst June 2019- June 2021

Responsibilities

·Extracted data from multiple source systems using Oracle SQL Developer.

·Created various SQL Scripts for verification of the required functionality.

·Coordinated the development activities with the development team and QA team.

·Worked with the business users and product managers to accurately capture all stakeholder requests and translate them into system specifications.

·Evaluated administrative data for accuracy and consistency.

·Compiled, edited, and analyzed survey data from primary data collection.

·Drafted written analysis and created graphical and tabular representations of quantitative findings.

·Developed Tableau data sources, including the development of scripts and Tableau Prep flows.

·Evaluated business processes, anticipated requirements, uncovered areas for improvement, and developed and implemented solutions.

·Designed, developed, and implemented business intelligence Tableau Dashboards and reports to facilitate data review and analysis.

·Developed interactive data visualization tools to make data readily available to stakeholders using Tableau.

·Helped the company with reviewing and improving existing systems and collaborating with teams to integrate new systems.

A-1 Mortgage Group Loan Processor March 2004- Oct 2007

Responsibilities

·Analyzed and verified the applications to determine the borrower’s creditworthiness for loans.

·Specialized in Commercial and mortgage loans.

·Coordinated and Organized documentation received from the third parties, brokers, Teammates, borrowers, etc. necessary to process all files from the beginning to closing.

·Served as the primary point of contact with brokers borrowers and third parties to order, receive and assembled files for each transaction.

·Entered and verified accurate information and status for each file, which was maintained during the underwriting process through closing within the database.

·Ordered Title Binders, Appraisal and Hazard Insurance for the borrowers.

·Interfaced with the associated Analyst, underwriter and loan closer as needed to address issues, which raised during the process and confirming to a tight timeline.

·Worked with associated legal, underwriting, and closing personnel to ensure accurate documentation, booking, funding of the transactions.

·Coordinated with loan servicing with handoff of file and point of contacts.

TECHNICAL SKILLS

Data Analytics

Data Cleaning, Manipulation, Visualization and Normalization

Math & Stats

Variance, Correlation, Measures of Central Tendency (Mean, Mode, Median)

Reporting Tools

Power Bi & Tableau

Languages

SQL, T-SQL, & Basic Python

IDE

SQL Developer, SQL Server Management Studio, Google Collab

Python

Pandas, NumPy, Matplotlib, Scikit Learn & Plotly

Databases

SQL Server, Oracle

ETL

SQL Server Integrated Services (SSIS)

Operating System

Windows

EDUCATION & PROFESSIONAL CERTIFICATION

NOVA Community College- Associate of Science & Business Administration- 2005

Syntax Technologies - Data Analytics Boot Camp- 2018

Considering getting more Education to become a Data Engineer.

Contact this candidate