Victor Chukwukere
Data Engineer
Houston,TX
Work Preference
Summary
Certified Data Engineer with over 7 years of experience in ETL development, database design, and data integration, leveraging tools such as MS SQL Server, Azure Data Factory, and Power BI. Highly proficient in utilizing SSIS for robust ETL processes, SSRS for designing and delivering comprehensive reporting solutions, and Snowflake for implementing scalable cloud-based data warehousing. Skilled in optimizing query performance to enhance database efficiency, as well as developing interactive Power BI dashboards that provide real-time analytics and actionable insights. Experienced in the financial and healthcare sectors, with a proven ability to extract, transform, and load data from diverse sources into cohesive data warehouses. Adept at data modeling and performance tuning to support business intelligence initiatives. A strong communicator, focused on understanding client requirements and delivering tailored solutions that drive decision-making. Currently learning Python and microsoft fabric skills to streamline Azure automation and enhance Analytics workflows.
Overview
8
8
years of professional experience
1
1
Certificate
1
1
year of post-secondary education
Work History
ETL Developer/Data Engineer II
Penn Entertainment
02.2022 - Current
- Designed and implemented ETL solutions using SSIS reducing data processing time by 30%.
- Developed complex stored procedures in SQL and implemented dynamic data extraction from SFTP, enabling data updates in SQL databases.
- Created and optimized Merge procedures for incremental data loads and backfills, cutting data warehouse processing time by 25%.
- Leveraged advanced SSIS transformations (Derived Columns, Conditional Split, Lookup).
- Scheduled and managed SSIS and SQL jobs using sql agent ensuring timely data availability for analytics.
- Authored efficient Snowflake queries to support analytics, reducing query execution time by 15%.
- Optimized SQL queries and stored procedures, enhancing ETL pipeline performance by 25% through indexing and query refactoring.
- Utilized GitHub for version control, ensuring seamless collaboration and code integrity across team projects.
- Contributed to team coding standards, improving code consistency and reducing development errors by 10%.
- Maintained comprehensive system documentation, facilitating knowledge transfer and onboarding for new team members.
- Collaborated with cross-functional teams to gather requirements and design data solutions, ensuring alignment with business objectives.
- Led the design and implementation of a data warehouse project, gathering requirements from stakeholders and delivering a solution that improved reporting capabilities by 40%.
Data Systems Developer
Kelsey-Seybold Clinic
05.2019 - 02.2022
- Designed and implemented ETL solutions to extract, transform, and load data from multiple sources, including SharePoint, to support various business functions.
- Developed interactive Power BI dashboards and SSRS reports, providing actionable insights tailored to business needs.
- Led the development, deployment, and support of ETL processes to ensure data accuracy, consistency, and efficiency.
- Converted SSRS and Excel reports into Power BI dashboards, enhancing visualization and usability.
- Designed and optimized SQL stored procedures for data transformation and business logic implementation, ensuring efficient processing.
- Created SSIS packages for data integration, leveraging Derived Columns, Sort, Conditional Split, Look-up Transformation, Aggregations, Multi-casting to streamline ETL workflows.
- Utilized SSIS to build ETL packages, integrating data from SharePoint, flat files, sql database and and export to SFTP locations or load into the data warehouse.
- Conducted SQL performance tuning, optimizing stored procedures, indexes, and queries to enhance ETL packages execution speed.
- Improved ETL package performance using indexing, query refactoring, and normalization techniques.
- Designed and developed SSRS reports, including sub-reports, drill-down reports, drill-through reports, parameterized reports, matrix reports, and interactive data visualizations.
- Built Power BI dashboards, integrating tabular, matrix reports, charts, graphs, and gauges to enhance data analysis and decision-making.
- Automated SSRS report scheduling, ensuring timely data delivery through email subscriptions and scheduled executions.
- Built and deployed SSIS packages across development and QA environments, ensuring proper version control and seamless integration.
- Monitored and managed SQL Server Agent scheduled jobs, optimizing execution times and troubleshooting failures.
- Integrated SharePoint as a data source in ETL pipelines, extracting and transforming structured and unstructured data for reporting purposes.
- Worked within environments including SQL Server 2019, SQL Server 2017, SQL Server 2015, and Visual Studio 2017, ensuring compatibility and optimal performance.
- Conducted rigorous testing methodologies to identify bugs, troubleshoot issues, and improve ETL stability.
- Partnered with product management teams to define data requirements, translating business needs into technical solutions.
- Led database performance optimization, reducing query execution times while maintaining data integrity.
- Developed and enforced team coding standards, ensuring consistency and accuracy in reporting and data processing.
- Continuously refined and upgraded SSIS packages to improve data processing performance and maintainability.
Programmer Analyst
LA Care Health Plan
10.2018 - 05.2019
- Engineered ETL solutions using SSIS to integrate healthcare data from diverse sources, enhancing data accessibility for enterprise analysis.
- Developed interactive Power BI dashboards and SSRS reports, providing real-time insights that drove business decision-making.
- Created and optimized stored procedures for QNXT and WEX data reconciliation, ensuring 100% accuracy in data synchronization.
- Led performance tuning initiatives, optimizing SQL queries and stored procedures to reduce ETL processing time by 30%.
- Utilized SSIS to design ETL packages for extracting, transforming, and loading data into OLEDB, SharePoint, and Excel destinations.
- Established team coding standards, improving code consistency and reducing errors by 15% through collaborative development practices.
- Enhanced database performance by implementing normalization, indexing, and query refactoring, boosting efficiency by 25%.
- Designed and deployed SSIS packages across development and QA environments, ensuring seamless integration and zero downtime.
- Automated SSRS report generation and distribution, scheduling weekly and monthly deliveries in PDF and Excel formats.
- Secured SSRS reports at item and folder levels, ensuring compliance with client data privacy requirements.
- Leveraged SQL triggers, linked servers, and dynamic coding to automate data workflows and improve system functionality.
- Documented ETL processes and system architectures, streamlining onboarding and knowledge transfer for new team members.
- Monitored and troubleshot SQL Server Agent jobs, maintaining 99% uptime for critical data pipelines.
- Utilized bulk insert techniques to load XML files into SQL tables, optimizing data ingestion speed by 20%.
- Conducted peer code reviews, enhancing code quality and reducing defects by 20% across the development team.
- Communicated complex technical concepts to non-technical stakeholders, ensuring alignment during project updates and discussions.
- Resolved programming errors in existing systems, improving pipeline efficiency and stability by 15%.
Education
Master of Science - Information Technology
Eastern Mediterranean University
Famagusta Cyprus 02.2014 - 10.2014
Skills
ETL development
Data pipeline design
Data modeling
Data warehousing
Data migration
Data pipeline control
SQL and databases
Business intelligence
Problem-solving
Certification
Microsoft Certified, SQL Server Database Developer– Microsoft.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English
Full Professional
Timeline
ETL Developer/Data Engineer II
Penn Entertainment
02.2022 - Current
Data Systems Developer
Kelsey-Seybold Clinic
05.2019 - 02.2022
Programmer Analyst
LA Care Health Plan
10.2018 - 05.2019
Microsoft Certified, SQL Server Database Developer– Microsoft.
03-2017
Master of Science - Information Technology
Eastern Mediterranean University
02.2014 - 10.2014