Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Samuel Solomon

Glenwood,IL

Summary

Experienced business intelligence (BI) professional Developer with about 3 years of experience performing detailed compilation and maintenance of extensive database systems to track complete BI information. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code. Well-versed in mining data, developing databases, and generating reports. Detail-oriented and systematic with excellent follow-through and a superior work ethic. Excellent communication, project management and problem-solving abilities. Bilingual DevOps Engineer with background designing, testing, and implementing infrastructure and applications. Talented performer with less than 1 years of experience using source control tools to identify and fix bugs in code. Consistent team player with exemplary multitasking skills.

Overview

4
4
years of professional experience

Work History

BI Developer

Accelerated Logistics
2022.11 - 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
  • 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
  • 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
2023.11 - 2024.04
  • 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
2020.11 - 2022.11
  • 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 with little supervision
  • 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
2020.07 - 2020.11
  • 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)
  • The reports were set up for automatic delivery based on standard report subscriptions.

Education

Bachelor of Science : Accounting -

DeVry University
Downers Grove, IL
06.2020

Skills

  • DEVOPS
  • Linux
  • Python
  • GIT
  • Maven
  • Jenkins
  • Ansible
  • Kubernetes
  • Docker
  • AWS
  • Terraform
  • CI/CD
  • Monitoring
  • EXCEL
  • Formulas
  • Formatting
  • Tables
  • Power Pivot
  • Dax Function
  • SQL
  • Diagram
  • Coding
  • Collection
  • Validation
  • Optimization
  • Management
  • Analysis
  • MSBI
  • SSRS
  • SSIS
  • SSAS (Tabular DAX)
  • Custom Reporting
  • E.T.L Packages
  • Tabular Tables
  • Microsoft Visio
  • Data Visualization
  • Tableau
  • Power BI
  • Custom Dashboards

References

  • Rajender Chanden, Supervisor, 786-251-7777
  • Ronald Boone, Team Lead, 708-738-9200
  • Bill Green, Instructor, 334-557-9949

Timeline

DevOps Engineer Training

IBT Learning
2023.11 - 2024.04

BI Developer

Accelerated Logistics
2022.11 - Current

Data Analyst

C.W.S Dedicated
2020.11 - 2022.11

Data Analyst Training

L.T.V Academy
2020.07 - 2020.11

Bachelor of Science : Accounting -

DeVry University
Samuel Solomon