Samuel Lazarus
Data engineer
Omaha,NE
Summary
5+ years of experience developing and optimizing ETL processes(SSIS), data models, and Power BI solutions. Designed and developed interactive Power BI dashboards and reports visualizing key business metrics and KPIs, resulting in significant improvements in business performance in 6 months. Conducted data analysis, and identified trends, patterns, and insights from loan application data sources. Provided training and support to users, enabling them to leverage Power BI for self-service analytics.
Overview
5
5
years of professional experience
Work History
Power BI Developer
Colaberry INC
Plano, TX
02.2022 - Current
- Optimized data gathering processes, analysis procedures and visualization strategies.
- Designed and developed interactive Power BI dashboards and reports to visualize key business metrics and KPIs.
- Created data models and implemented efficient data transformations using Power Query and M languages.
- Collaborated with business stakeholders to gather requirements, understand data needs, and translate them into technical solutions. Conducted data analysis, identified trends, patterns, and insights, and presented actionable recommendations to improve business performance.
- Worked closely with cross-functional teams, including data engineers and business analysts, to ensure data integrity, accuracy, and consistency.
- Optimized Power BI solutions for performance, incorporating best practices for data modeling and DAX calculations.
- Provided training and support to end-users, enabling them to leverage Power BI for self-service analytics.
SQL/ETL Developer
COLABERRY INC
Plano , TX
06.2018 - Current
- Design complex ETL processes (SSIS packages) to consolidate loan application data from various sources into staging tables and data warehouse using Kimball methodology.
- Created complex SSIS packages using various transformations and tasks like sequence containers, for loop and for each loop containers, execute SQL package, file system task, conditional split, data conversion, derived column, lookup, merge join, union all along with flat file, CSV, XML, OLE DB and excel sources and destinations.
- Conduct failed SSIS packages troubleshooting by enabling Checkpoint, Logging, and Event Handlers. Update the data dictionary, upon creating a new package and when loading the data into the target destination.
- Perform SSIS packages deployment into SQL Server Management System and conduct packages execution through the scheduler by adding email notifications.
- Establishing referential integrity, data consistency, and indexing, and data cleanup procedures to maintain high quality data that can be used for reporting.
- Developed various types of reports including Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, and Sub-Reports along with a dashboard using SSRS.
- Interact with various clients and stakeholders to gather business requirements for upcoming projects.
- Work closely with Business Analysts to explore business requirements, design documents, and technical specification documents.
- Responsible for providing business requirements within an AGILE software development SCRUM environment.
- Involve in loan applications data quality checking, completeness, consistency, accuracy, and validation.
- Develop complex SQL queries involving sub-queries, correlated queries, and stored procedures.
- Perform optimization and performance tuning of SQL queries and Stored Procedures using SQL Profiler, Database engine tuning advisor, and Extended Events for data analysis purposes.
Education
Bachelor of Science - Communication Studies
Bellevue University
Bellevue, NE06.2019
Skills
- T-SQL SSMS
- Microsoft SQL (SSMS)
- Oracle Database
- Microsoft Power BI
- Data Modeling: Microsoft Visio, L
- ETL Tools: MS Visual Studio (SSIS)
- Reporting Tools: MS Visual Studio (SSRS)
- Analysis Services: MS Visual Studio (SSAS)
- Database Tools: SQL Server Management Studio (SSMS)
- Excel Pivot Tables
- Office Tools: MS Word, Power Point, MS Excel, Access, Adobe Acrobat Pro Processes: Agile Methodologies (SDLC)
- Database Analysis
- Good Work Ethic
- Data Management
- Critical Thinking
- People Skills Team Building
- Developer collaboration
- Cultural Awareness
- Flexible and Adaptable
- Multitasking Abilities
- First Aid/CPR
- Decision-Making
- Self-Motivated
- Attention to Detail
- Interpersonal Communication
- Planning and Coordination
Languages
English
Professional
Arabic
Professional
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
Every problem is a gift—without problems we would not grow.
Tony Robbins
Timeline
Power BI Developer
Colaberry INC
02.2022 - Current
SQL/ETL Developer
COLABERRY INC
06.2018 - Current
Bachelor of Science - Communication Studies
Bellevue University
Similar Profiles
Yonathan WolezgYonathan Wolezg
Power BI Developer/Data Analyst at Colaberry IncPower BI Developer/Data Analyst at Colaberry Inc
EFE AGBONAYEEFE AGBONAYE
Power BI Developer at Colaberry IncPower BI Developer at Colaberry Inc
SHAHAD JAWADSHAHAD JAWAD
BI/Power BI Developer at Colaberry IncBI/Power BI Developer at Colaberry Inc