Post Job Free

Resume

Sign in

Data Analyst Sql Server

Location:
Allentown, PA
Posted:
December 14, 2023

Contact this candidate

Resume:

Samuel Encarnacion

646-***-**** ad1zal@r.postjobfree.com Allentown, PA linkedin.com/in/samuel-encarnacion Date available to begin work: Immediately

Summary statement

Expert with a strong background in Cybersecurity. A genuine passion for Technology. Eager to begin a role in which I can apply my skills and learn from those who have expertise and knowledge to share. TECHNICAL SKILLS

Security Tools:Scripting, Metasploit, Snort, Splunk, Nmap, PowerShell, Wireshark; Networking: Firewalls; Operating Systems: Linux, Windows server, Active directory,Virtual Machines; Programming Languages: Python(Pandas, numpy, Matplotlib), SQL(SQL server,Mysql, Postgresql)

Additional skills:Data Validation · Data Warehousing · Data Cleaning · Tableau · Microsoft Excel(Vlookup, Conditional Formatting, Pivot tables) · Microsoft Office · Design ·Tableau

Certifications:

Data Analyst certificate 2023

TECHNICAL PROJECTS

The Permissions Problem/Career Simulation 1 04/2023

● Problem: Level 1 SOC Analyst inadvertently changed a configuration file named config.conf that is preventing me from looking at logs

● Solution: I know all the files are stored within the /opt/splunk directory. Resolved by using cd into the file, and using chmod to modify the configuration file so that I can properly view logs within Splunk Purple Team Presenter 08/2023

● A research project about a ransomware attack that caused a government to declare a state of emergency. Costa Rica completely lost control of their digital system and it caused an outrage that put the government in a jeopardized position.

https://youtu.be/o5fjbrqL_5U?si=XX TmVb 0X9 Gmq-

Mastercard Cybersecurity virtual experience program on Forage - December 2023

● Completed a job simulation where I served as an analyst on Mastercard’s Security Awareness Team

● Helped identify and report security threats such as phishing

● Analyzed and identified which areas of the business needed more robust security training and implemented training courses and procedures for those teams

EDUCATION

Fullstack Academy Cybersecurity Analytics Program 02/2023 Part-time immersive cyber security program designed to train in advanced red team/blue team skills and use of security tools. Cybersecurity Diploma (8/2023)

● Formed a solid foundation of computer knowledge including Windows client/server and various Linux distros

● Mastered common CLI navigation for Linux through Fullstack’s CTF challenges

● Learned Python basics and Bash scripting as well as PowerShell cmdlets

● Practiced offensive techniques and how to mitigate these threats using blue team industry tools to align with cybersecurity frameworks such as NIST and MITRE ATT&CK

● Wrote and modified rule sets for IPS/IDS such as Snort and ACLs for firewalls based on parameters provided

● Used packet capture tools such as Wireshark and TCPdump to investigate traffic for Indicators of Compromise

● Executed basic incident response procedures and gained familiarity with digital forensics tools and utilities

● Performed simulated threat hunting by analyzing large data sets in Splunk

● Gained familiarity with a variety of tools including Snort, Splunk, Wireshark, Burp Suite, Metasploit, Nessus, Nmap, and ping/netstat

EXPERIENCE

Data Analyst Task Impetus Inc New orleans, Louisiana 504-***-**** 07/2023 - Present

● Performed data manipulations and data validations for building reporting structure.

● Developed dashboards on Tableau to share insights on how delays affect performance and recommendations on customers.

● Worked extensively on Data Profiling, Data Mapping and Data Quality.

● Built a drill down Tableau dashboard to give a brief and detailed overview of card tables to customers.

● Ability to analyze models and interpret data for analytics.

● Imported the claims data into Python and performed various data analysis.

● Monitor, Track and resolve issues with the Excel, Power BI reports.

● Participates in special projects and performs other duties as assigned.

● Used R for graphically critiquing the datasets and to gain insights to interpret the nature of the data.

● Perform data manipulation, development and validation of data models using R and SQL.

● Performed Data Analysis and Data profiling using complex SQL.

● Used SAS for pre-processing data, data analysis, generating reports and statistical analyses. Past EXPERIENCE

Part Time Plant Engineer United Parcel Service Easton, Pennsylvania Manager: Quentel Ruffin 501-***-**** 08/2020 - 10/2022

● Oversaw plant electrical mechanical systems PLC’S, Programmable logic controllers, conveyor belts, Photo eyes, Camera tunnels from installation to troubleshooting to regular maintenance. Proficient at controlling equipment through HMI

● Trained and mentored new employees on machine operation and safety

● Conducted routine tests, evaluates plant machinery for optimal performance and safety

● Improved efficiency and increased production through upgrades to new technologies and equipment repair

● Sourced and selected vendors for system components

● Communicated issues, concerns, and status updates to team and collaborated to ensure maximum plant efficiency, productivity, and safety

VOLUNTEER EXPERIENCE

● Mentored coworkers by showing how to use the human machine interface, a dashboard that communicates information, data and metrics using graphics or visual representations of numbers. This screen is controlled by an operator who monitors and controls equipment and processes in factories and plants. PROFESSIONAL AFFILIATIONS

● Cyber Warrior Network, Member

● IAPP (International Association of Privacy Professionals), Student Member

● Security BSides

Personal

● Decent Physical fit. Achieved by doing heavy weight lifting.



Contact this candidate