Samuel Solomon
Glenwood,IL
Overview
4
4
years of professional experience
Summary
Business Intelligence Analyst with 4+ years of experience transforming complex datasets into actionable insights. Adept at designing and implementing data models, optimizing SQL queries, and creating dynamic dashboards using Power BI and Tableau to support strategic decision-making. Excellent Communication, project management, problem solving abilities and superior work ethic to deliver high-quality results under tight deadlines.
Additionally skilled as a DevOps Engineer, with hands-on experience designing, testing, and deploying scalable plus secure CI/CD infrastructure and applications. Identifying and resolving code issues, ensuring system stability, and enhancing operational efficiency through innovative solutions.
Skills
- Data Analysis and BI Tools
- Excel
- SQL
- Data Diagram Modeling
- Data Quality Management
- Performance Optimization Tuning
- Tableau
- Power BI (Dax Formulas)
- MSBI (SSIS, SSRS)
- ETL Packages
- Data Visualization
- Custom Reports and Dashboards
- DevOps CI/CD Practices
- Linux/ Git/ GitHub
- Maven/ Jenkins/ Ansible
- AWS/AZURE/ Terraform
- Docker/Kubernetes
- Monitoring
Work History
BI Analyst
Accelerated INC
11.2022 - Current
- Wrote and optimized SQL statements to assist business intelligence practices
- Monitored and optimized SQL server performance
- Maintained complex T-SQL queries, views, CTE’s and stored procedures in database environment with little supervision and Improved SQL queries, cutting run time by 20%
- Tested software applications and systems to identify enhancement opportunities
- Compiled, maintained, and developed database systems for tracking tailored content
- Generated reports virtualization and Dashboards updated spreadsheets and presented results
- Designed and developed Database migration to extract, transform and load (ETL) applications per client specifications
- Help plan data extraction and processing tasks, aiding in eventual deployments using Jira project management tools
- Performed regular database backups to prevent information loss
- Resolved complex business issues, proposing long-term solutions to avoid repeated problems
DevOps Engineer Training
IBT Learning
11.2023 - 06.2024
- Collaborated with cross-functional teams to enhance software functionality and performance and contributed to developing scalable solutions aligned with client requirements
- Assisted in creating automation tools for deploying advanced platforms
- Optimized system configurations to improve overall performance and efficiency
- Automated system backup and recovery processes to ensure data integrity
- Implemented secure coding practices to mitigate network vulnerabilities
- Resolved build/release failures in continuous integration processes
- Prototyped and tested new data processing capabilities for integration feasibility
- Supported CI/CD pipeline development and maintenance
- Assisted in configuring and managing cloud infrastructure components
- Participated in troubleshooting and debugging system issues
- Worked on containerization technologies for application deployment
- Participated in design discussions to enhance system reliability
- Analyzed and refined system solutions based on client specifications
- Contributed to team documentation and knowledge sharing
- Integrated monitoring and alerting systems for proactive issue resolution
- Conducted performance testing and contributed to optimization strategies
- Monitored and maintained system health and uptime
- Implemented security best practices across development and deployment processes
Data Analyst Training
L.T.V Academy
07.2022 - 11.2022
- The SQL Server master's Program is an intensive, hands-on, project-oriented program where participants gain knowledge and valuable experience putting the SQL Server skill set to use in a simulated work environment
- Created numerous simple to complex queries involving joins, correlated subqueries, CTE’s and XML techniques for diverse business requirements
- Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies
- As part of a team, I analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu-Ray) rental company
- Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes, and triggers, and implemented the import and export of data using XML and SSIS
- As part of a team, we have created various reports according to the business requirements for the movie rental company
- Individually authored, installed, deployed, and managed reports using SSRS for a library database
- Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities
- Created an ETL solution that reads Product, Vendor, and Order data from .CSV files on a network shared into a SQL Server database
- The solution also validated incoming data and performed notifications when jobs were completed
- The order data thus loaded into SQL Server was used to generate reports using the new SSRS 2008 reporting functionality (including the Tablix control)
Education
Bachelor of Science - Accounting
DeVry University
Chicago, IL06-2020
Timeline
DevOps Engineer Training
IBT Learning
11.2023 - 06.2024
BI Analyst
Accelerated INC
11.2022 - Current
Data Analyst Training
L.T.V Academy
07.2022 - 11.2022
Bachelor of Science - Accounting
DeVry University