Data Analyst
Resume:
Michael Nelson
Atlanta, Ga
******.*************@*****.***
PROFFESIONAL SUMMARY
Experienced and dedicated Data Analyst with 5 years of experience across diverse industries. Experience in interpreting and analyzing data to drive successful business solutions, including analysis and testing of business requirements to drive deployment of applications, business processes and system solutions. Proficient knowledge in SQL, Tableau, Excel, Python, Data Quality, and Data Management.
Excellent understanding of business operations and analytics tools for effective
analyses of data.
QUALIFICATION SUMMARY
Worked on all different phases on data warehouse development lifecycle, from collecting prerequisites to support, testing, and implementation.
•Exceptional foundation in design, development, analysis, customization, implementation and testing of programming applications and products.
•Demonstrated ability using ETL instruments, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM frameworks like SQL Servers and Oracle.
•Strong pioneer with experience preparing designers and exhorting specialized gatherings on ETL best practices.
•Excellent specialized and logical abilities with clear comprehension of plan objectives of ER demonstrating for OLTP and measurement displaying for OLAP.
•Efficient in data wrangling, data modeling, data cleansing, and data mining.
•General understanding of APIs on a variety of platforms.
•Team player with fantastic correspondence and critical thinking abilities.
EDUCATION
ALBANY STATE UNIVERISTY, Albany, GA – Bachelor of Computer Science,
*Emphasis: Business, 2015
oMinor: Business Administration
TECHNICAL SKILLS SUMMARY
Programming Languages: SQL, T-SQL, Python, JAVA, VB.net, HTML, PHP, C, C++, R
ETL: SQL Server Integration Services
OLAP/Reporting/OLTP: SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Database Engine
Operating Systems: Windows Server 2008 R, Windows 7/ 8/ 10.
BI/ Analytics Tools: SQL Server Management Studio, MySQL Workbench, PostgreSQL, Excel Power Pivot, Tableau, Jupyter Notebook, Oracle 10g, Jgrasp, Google Analytics, MS Access
Business Modeling Tools: MS Office, Visio, Visual Paradigm 13.0.
Software Platforms: PeopleSoft, SharePoint, Microsoft Office.
KEY SKILLS SUMMARY
DATA ANALYIS
BUSINESS INTELLEGENCE
DATA MINING
DATA QUALITY ASSESSMENT
DATA MODELING
PRESENSTAION SKILLS
DATA VISUALIZATION
DETAIL ORIENTED
REPORT RESEARCH
BUSINESS ANALYSIS
STATISTICAL ANALYSIS
AD HOC REPORTING
WORK EXPERIENCE
Center of Disease Control (CDC Foundation)., Atlanta, GA – Data Analyst, March 2022 Current
•Worked closely with leaders across product, sales, and marketing to support and implement high-quality, data-driven decisions.
•Ensured data accuracy and consistent reporting by designing and creating optimal processes and procedures for analytics employees to follow.
•Use advanced data modeling, predictive modeling and analytical techniques to interpret key findings from company data and leverage these insights into initiatives that will support business outcomes.
•Utilized MS Access SQL to manipulate data and transform it into excel to create different pivots of the data.
•Created dashboards in Excel and Tableau to answer key business requirements.
•Used data triangulation from multiple sources to increase the validity of a study.
•Applied exhaustive knowledge of data analysis to solve real-world problems faced by the company and finding opportunities for improvement across multiple projects, teams and business units.
•Contribute to cross-functional projects using data modeling and analysis techniques to discover insights that will guide strategic decisions and uncover optimization opportunities.
•Build, develop and maintain data models, reporting systems, data automation systems, dashboards and performance metrics support that support key business decisions.
•Design and build technical processes to address business issues.
•Design and deliver reports and insights that analyze business functions and key operations and performance metrics.
•Ensure accuracy of data and deliverables of reporting employees with comprehensive policies and processes.
•Manage and optimize processes for data intake, validation, mining and engineering as well as modeling, visualization and communication deliverables.
•Examine, interpret and report results of analytical initiatives to stakeholders in leadership, technology, sales, marketing and product teams.
•Develop and implement quality controls and departmental standards to ensure quality standards, organizational expectations, and regulatory requirements.
•Teyematics, Garrison, Maryland – Data Analyst, - March 2021 – March 2022
•Handled large datasets to perform data wrangling and data cleansing for interpreting data, analyzing results using statistical techniques.
•Planned and kept up with information frameworks and data sets; this incorporates fixing coding blunders and different information related issues.
•Arranged reports for senior administration that viably convey patterns, examples, and predictions using relevant data.
•Data Analyst attaché worked across various business units in the organization to build out reporting infrastructure in Tableau from project inception.
•Utilizing tools like SQL, Excel, Tableau and Power BI to perform exploratory analysis on customer data and draw data driven conclusions to optimize business operations.
•Created, kept up with, and oversaw progressed revealing, examination, dashboards and other BI arrangements.
•Managing full application development lifecycle from requirements gathering to application delivery and continuous integration
•Creating data models for Senior Leadership Teams.
•I developed Multiple dashboards, Analytical reports, KPIs and interactive reports based on business requirements using Tableau to Support executive business needs.
•Performed and documented data analysis, data validation, and data mapping/design.
•Implemented and maintained database code in the form of stored procedures, scripts, queries, and views.
•Manipulating, cleansing, and processing data using Excel, SQL. Responsible for loading, extracting and validation of client data.
•Wrote Ad-hoc reports based on specific end user and business unit needs for various departments across the organization.
Stackit, Bladensburg, Maryland - Data Analyst/Data Engineer, January 2016 - March 2021
•Extracted data from different flat files, MS Excel, Data Warehouse and transformed the data based on user requirement using SQL Server Integration Services (SSIS) and built in ETL tools in Tableau
•Utilized Python for Exploratory Data Analysis with libraries like Pandas, NumPy, Matplotlib and Pandas Profiling Tool.
•Pulled data from API in JSON format using Python and converted into data frame for further exploratory analysis
•Developed complex SQL queries using Views, Common Table Expressions (CTE) and temporary table to serve as data sources for dashboards built in Tableau and Power BI.
•Provided thorough and clearly communicated analyses of data to business analysts and developers as the foundational part of collaborative business planning at the IT level
•Compose reports and data feed specifications for BI, ETL, and web services developers
•Translated business requirement into SQL queries to support business analysis and reporting requirement. Also, performed basic database administrative functions.
•Performs analysis to link business needs and objectives for assigned function.
•Writes queries using joins and aggregation functions to pull, and Exports data from SQL server to Excel spreadsheet; from excel spreadsheet to SQL server, to create accurate reports and communicate about it.
•Built interactive Dashboards in Tableau as part of operational and ad hoc reporting needs of various business units
•Creating data models for Senior Leadership Teams.
•Performed ETL task to transfer data into Jupyter Notebook to get a deeper dive on the data for various solutions.
•Support business initiatives through data analysis.
Contact this candidate