Experienced data professional with experience in data analysis skills. Seeking Data Analysis or SQL BI Developer role, where new technology in data processing is applied, and career development is encouraged.
Overview
8
8
years of professional experience
Work History
Data Analyst
DataCheff LLC
Dallas, TX
08.2021 - Current
Generated 50+ data reports and dashboards delivering valuable insight to stakeholders and executives using SSRS and Power BI
Created over 1000 database objects including tables, joins, views, and triggers, to structure, optimize, and secure data for my business entity
Configured SSIS package pipeline for data movement from the Source to the Staging environment
Designed and maintained complex stored procedures, optimizing system performance by 30%
Deployed and automated several ETL processes, migrating data from several sources to database destinations with zero data loss
Collaborated with stakeholders, executives, and several departments to deliberate on business requirements and deliver on tasks
SQL Developer
BCTwenty Solutions
Dallas, TX
03.2019 - 07.2021
Worked in the SQL business intelligence department, using data to create insights and drive stakeholders' informed business decisions increasing revenue
Created and debugged database entities applying constraints and data models for maintaining referential integrity in the data warehouse and enhancing database structure
Generated staging databases, performing ETL (extract, transform, and load) on several data sources into staging databases and operational data stores (ODS)
Employed, maintained, and troubleshot several database techniques like CTEs, functions, and subqueries, to dynamize SQL queries improving client users' performance by 15%
Developed and automated several incremental and full loads into the Data warehouse
Provisioned Data models establishing Facts and Dimension relationships on Star schemas, Snowflake, etc
Increasing database efficiency
Streamlined query performance by implementing advanced optimization techniques and best practices, reducing processing time to 60%
Possessed expert knowledge of Database management tools while enhancing and keeping up to date on new and emerging technologies
Supply Chain Analyst
Valeo
Remote
07.2017 - 07.2020
Identified product, service, and process-related cost-saving measures utilizing the organization's databases, benchmarking studies, and technology assessments
Coordinated the supply chain process through various projects
Generated data and reports for customers and project team members
Performed recommended backup procedures for electronic files to ensure projects or programs were properly maintained
Co-ordinated customer orders checked inventory availability, and processed orders
Conducted full inventory count and management every week to ensure inventory integrity
Processed inbound and out paperwork through SAP and provided customers with detailed documents on shipped products
Education
Bachelor of Science - Logistics & Supply Chain Management
Ball State University
01.2019
Solution BI Analytics Bootcamp - Data Analysis
01.2020
Skills
ETL
Data Analysis
Data Visualization
Data Migration
Data Modeling
Database Management
Database Optimization
Power BI
Tableau
Visual Studio
SQL Server
SSMS
SSIS
SSRS
T-SQL
Excel
Google Sheets
XML
CSV
Repository
Microsoft Suite
Google Suite
Communication
Collaboration
Leadership
Problem Solving
Research
References
Available upon request.
Timeline
Data Analyst
DataCheff LLC
08.2021 - Current
SQL Developer
BCTwenty Solutions
03.2019 - 07.2021
Supply Chain Analyst
Valeo
07.2017 - 07.2020
Bachelor of Science - Logistics & Supply Chain Management