Summary
Overview
Work History
Education
Skills
References
Timeline
OfficeManager

Samuel Solomon

Glenwood,USA

Summary

Results-driven 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. Recognized for exceptional problem-solving, attention to detail, and delivering high-quality results under tight deadlines. Excellent Communication, project management, problem solving abilities and superior work ethic.

Additionally skilled as a DevOps Engineer, with hands-on experience designing, testing, and deploying scalable plus secure CI/CD infrastructure and applications. Adept at identifying and resolving code issues, ensuring system stability, and enhancing operational efficiency through innovative solutions.

Overview

4
4
years of professional experience

Work History

Devops Engineer Intern

PolicyCon
07.2024 - Current
  • Proved successful working within tight deadlines and a fast-paced environment
  • By Estimating work hours and tracking progress using Scrum methodology
  • Corrected, modified and upgraded software to improve performance
  • Tested and deployed scalable and highly available software products
  • Coordinated deployments of new software, feature updates and fixes
  • Monitored automated build and continuous software integration process to drive build/release failure resolution
  • Designed and developed forward-thinking systems that meet user needs and improve productivity

BI Analyst/Developer

Accelerated
11.2022 - 11.2024
  • 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
  • Helped 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 repeat problems

DevOps Engineer Training

IBT Learning
11.2023 - 04.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

C.W.S Dedicated
11.2020 - 11.2022
  • Wrote and optimized SQL statements to assist business intelligence practices
  • Monitored and optimized SQL server performance
  • Maintained complex T-SQL queries, views, and stored procedures in database environment
  • Tested SQL applications and systems to identify enhancement opportunities
  • Validated warehouse data structure and accuracy
  • Produced Dashboards and reports using Tool's Services functions like SSRS, Tableau
  • Analyzed data to identify root causes of problems and recommend corrective actions
  • Analyzed transactions to build logical business intelligence model for real-time reporting needs

Data Analyst Training

L.T.V Academy
07.2020 - 11.2020
  • 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 self 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, 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, 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, IL
06.2020

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, SSAS-Tabular)
  • ETL Packages
  • Data Visualization
  • Custom Reports and Dashboards
  • DevOps CI/CD Practices
  • Linux/ Git/ GitHub
  • Maven/ Jenkins/ Ansible
  • AWS/AZURE/ Terraform
  • Docker/Kubernetes
  • Microservices
  • Monitoring

References

Available upon request.

Timeline

Devops Engineer Intern

PolicyCon
07.2024 - Current

DevOps Engineer Training

IBT Learning
11.2023 - 04.2024

BI Analyst/Developer

Accelerated
11.2022 - 11.2024

Data Analyst

C.W.S Dedicated
11.2020 - 11.2022

Data Analyst Training

L.T.V Academy
07.2020 - 11.2020

Bachelor of Science - Accounting

DeVry University

Similar Profiles

CREATE PROFILE
Samuel Solomon