Samuel Bernard Email & Phone Number

San Diego, Ca, Us

San Diego, California, United States

Technical Consulting lead of the data engineering team in charge of maintaining a data pipeline connecting streaming and transactional data from several data sources using Python, Spark, and SQL within the Databricks platform. On-the-job knowledge and responsibilities involve expertise in data governance, ETL processes, serverless architecture within Databricks, database automation, data lake/warehouse maintenance, ML model deployment, and ML predictive analytics, ● Developed and implemented ETL processes to transform semi-structured data for integration and ingestion into web apps and live dashboard displays for showcasing energy transfer routes and data.● Follow the Databricks’ medallion architecture pattern to organize data and improve data quality for Machine Learning and predictive data analytics.● Utilize the MLflow platform to track ML experiment runs, select and package models for deployment, and manage internal or external collaboration.● Designed and implemented an ML model to predict stock values resulting in an overall decrease in shortages for the fulfillment of purchase orders around the globe.● Practice the Agile (SAFe 5) methodology, tracking user stories in JIRA, participating in Agile ceremonies, and following a two-week sprint cycle.● Determine the level of effort (story points) for data engineering-related requirements using the JIRA dashboard.● Lead efforts to develop data processing jobs and workflows within Databricks to optimize all ETL processes.● Collaborate with data engineers, web app developers, functional analysts, and client user groups to develop and manage complex data warehouse solutions and databases.● Engage with a wide audience of clients and project stakeholders via email, presentations, and regularly scheduled calls or meetings.

Washington, District Of Columbia, United States - Seattle, Washington, United States (Remote)

Led a team of database server administrators and technical analysts that operate, maintain, and enhance a customized configuration management database (CMDB) system for IT asset management, software license management, and analytical dashboard delivery via integration to a web application.● Directed all work streams to enhance and maintain a customized (CMDB) system.● Delegated work-related tasks to team members according to client priority and team member experience.● Managed all work streams to enhance and maintain the custom (CMDB) system and signed off on cross-functional asks and efforts directly involving the CMDB or any dashboards or data sources that ingest its data.● Accurately forecasted project work hours, determined the level of effort for system changes, and calculated the budget for enterprise software contracts to meet client needs and requirements.● Interviewed and vetted candidates and made hiring decisions to fill open or new positions within the admin team.● Maintained healthy working relationships and often communicated with project clients as designated point-of-contact and subject matter expert for CMDB-related matters.● Designed and developed a relational SQL database with SQL Server and Oracle SQL Developer. Database object architecture, database connections, data imports, and data massaging were implemented for the final CMDB product.● Utilized different Symantec IT Management Suite components to function as the CMDB console for database organization and mapping, report generation, policy or task assignments, and network discovery.● Utilized Windows Server to operate and maintain 36 different web servers that are part of the CMDB.

Seattle, Washington, United States (Remote)

Coordinated all project efforts to implement and test a Single Sign-On solution to a web application accessible from both secure and open internet environments.● Managed project phases to create, implement, and test SAML single-sign-on protocol using an MS Azure active directory and existing web app user accounts for authentication.● Determined project milestones, project scope, and project costs to meet client requirements for system authorization to operate process.● Took measures to protect user account data and make the security of private identifying records a primary concern by detailing risks and planning work to mitigate them.● Utilized the MS Azure active directory to create user account credentials for web app users.● Utilized HTML and XML to generate metadata to designate Identity Provider endpoints and the certificates to secure SAML 2.0 exchanges via requests and responses for user authentication.● Coordinated transition of web app URL and hyperlinks to a secure hyperlink (HTTPS) to meet Azure AD conditions for single-sign-on implementation.

Washington, District Of Columbia, United States

Responsible for operations, system maintenance, and enhancements of 36 web servers that form a CMDB system utilized for IT asset and software license management via an analytics dashboard delivered from direct integration to a web application designed for asset management and inventory logistics.● Utilized SQL to query, import, format, and manage records of over 250,000 IT assets and software products.● Created database links between CMDB servers and external databases for data imports and exports.● Designed database infrastructure in the SQL Server by building relational data tables, views, and stored procedures with inter-connected columns and data values.● Streamlined team responsiveness to server outages or issues by utilizing the Splunk platform to monitor server health and then generate and send automated alerts via email and SMS messages.● Utilized the Splunk platform to generate live dashboards displaying server health, CPU usage, memory utilization, drive space, and uptime/downtime status.● Created auto-generated reports using stored SQL procedures and nested SQL jobs to sort and replicate data for interpolation and data analysis.● Normalized CMDB data from external systems by creating import rulesets and data governance policies to enforce a system-wide format for data.● Created automated tasks to perform database refreshes, database cloning, adjust database hierarchy, and perform data replication.● Performed routine backups and snapshots of database servers and distributed server backups in recovery efforts during a critical data loss incident.● Installed updated versions for database console tools, IT asset discovery software agents, SQL Server Management Studio, and different software plugins.

Reston, Virginia, United States

Designed and developed front-end and back-end solutions for mission-critical systems within websites and web applications.● Contributed to the software development lifecycle writing well-designed and testable code.● Developed back-end logic for different web pages using Java, JavaScript, and Linux.● Utilized JUnit testing framework to self-check code and peer review other team members’ code.● Utilized JIRA software to track and forecast coding task completion statuses.● Utilized GitHub to share and add code, evaluate other developers' code, and maintain version control.● Debugged coding errors and issues with built-in IDE debugger tools while understanding expected code smells. ● Operated under the Agile delivery model and participated in daily standups on a two-week sprint cycle.● Documented technical specifications and dependencies of applications.● Implemented webpage GUIs with HTML code and JavaScript.● Maintained, revised, and edited existing legacy code to meet project scope needs and increase code logic efficiency.● Involved in the Agile Development Team and having daily SCRUM meetings for updating and task distribution.● Worked closely and collaboratively with UX designers, Product Management, Business Analysts, and Client Stakeholders.● Created REST interfaces and services for API calls to return data and auto-generated responses.● Helped coordinate code migrations to developer, testing, staging, and production environments.● Ensure software designs are maintainable by taking into account the website's technology architecture, hardware capabilities, cross-environments, and future technological vision.● Work-related experience using the following programs/software: GitHub, JIRA, and Postman API platform.● Strong proficiency in the following languages: C++, Java (JDK 8), JavaScript, JSON, Linux (Red Hat)