Darlington Nwemeh
San Diego,San Diego
Summary
Practical database engineer and architect, possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system. Offering several-year background managing various aspects of development, design and delivery of database solutions. Tech-savvy and independent professional bringing outstanding communication and organizational abilities.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Sr Data Engineer | Data Warehouse Architect
Nelnet
Lincoln, NE
08.2023 - Current
- Developed data pipelines to ingest and process large datasets.
- Developed and managed enterprise-wide data analytics environments.
- Created conceptual, logical and physical data models for use in different business areas.
- Developed Data Warehouse architecture and data models to support business requirements.
- Designed logical and physical databases to ensure efficient access of stored data.
- Engineered and launched warehouse database structures.
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Designed, built, and maintained high-performance databases for reporting and analysis purposes.
- Developed scripts to extract, transform, cleanse, validate and load large volumes of structured and unstructured data from multiple sources into target systems.
- Created dimensional models for star schema design and optimized ETL processes for loading data into the warehouse.
- Managed end-to-end operations of ETL data pipelines, maintaining uptime.
- Applied Conceptual, Logical, and Physical & Dimensional/Relational model designs to ETL tasks.
- Created ETL scripts to move and transform data from various sources into a centralized repository such as Snowflake and SQL Server.
- Optimized SQL queries used in reporting solutions by using indexing strategies, query optimization techniques.
- Cleaned and manipulated raw data.
- Integrated multiple heterogeneous sources into one unified source via ETL processes.
- Tuned existing databases for better performance by optimizing indexes, query plans.
- Implemented automated processes to monitor performance and integrity of the Data Warehouse environment.
- Collaborated with professionals to define data extraction methodologies and data source tracking protocols.
- Documented all aspects of the Data Warehouse implementation including architecture diagrams, process flows.
- Performed impact analysis on existing database objects due to changes in business requirements or new initiatives.
- Assisted in troubleshooting issues related to Data Warehouse performance or reliability.
- Provided technical guidance to junior developers on Data Warehousing concepts such as OLAP cubes, ETL processes, Dimensional Modeling.
- Tested, validated and reformulated models to foster accurate prediction of outcomes.
- Provided technical support in troubleshooting issues related to data processing or storage systems.
- Provided training sessions on various Data Warehousing topics such as ETL development and optimization, report building.
- Identified gaps in existing ETL processes and developed solutions as needed.
- Collaborated with stakeholders across the organization to understand their needs and develop appropriate solutions accordingly.
- Developed tools and applications for monitoring data quality and integrity across all applications and databases.
- Maintained system security by ensuring proper user access rights are set up according to organizational policies.
- Managed security protocols and access control policies within the organization's databases and systems.
- Automated manual processes by creating custom scripts and programs using scripting languages like Bash, PowerShell.
- Followed industry innovations and emerging trends through scientific articles, conference papers or self-directed research.
- Recommended data analysis tools to address business issues.
Data Architect
QuidelOrtho
San Diego, CA
08.2016 - 03.2023
- Architected, setup, and configured Operational Data Store for Distributor Data handling over $200M in yearly transactions from distributors such as McKesson, Cardinal, and Fisher LifeScience.
- Implemented an Architectural Framework to resolve advanced data security issues by utilizing a distributive and decentralized data ownership and structure, in collaboration with our Solution Architect (Network).
- Addressed service-line requests by conducting troubleshooting to maintain data and network performance levels.
- Developed and managed enterprise-wide data analytics environments, implementing solutions like Alteryx, PoweBI, Tableau, Synapse, and Snowflake for data wrangling.
- Architected and designed an extensive dataset, comprising daily data of over 6TB, for a diverse range of database systems including Mongo-DB, SQL Server, Data Lakes, and open-source platforms.
- Architected and designed Azure setup
- Worked with Azure SQL on an enterprise level at QuidelOrtho.
- Designed and Implemented Open-Source Container App and Clusters, leveraging Kubernetes Services for efficient utilization of Container Pods.
- Successfully incorporated different Azure services such as Azure Functions, Logic Apps, Azure Active Directory, Key Vault, and Event Hub into our data processes across development and resource management scenarios.
- Assisted with the maintenance of Azure-SQL, SQL Server, and DB2 databases in collaboration with data development and software engineering teams.
- Developed and implemented conceptual, logical, physical, and dimensional/relational model designs for ETL|ELT workflows using Azure Data Factory.
- Managed performance monitoring and tuning, identifying and resolving issues in applications and databases.
- Collaborated with solution architects to develop effective engagement strategies for databases and analytics within operational territories and key accounts.
- Guided (8-10) Developers through systems designs, code development, and implementation processes. Provided support during conceptualization, design, and execution stages of software projects within the SDLC cycle.
- Promoted customer success in building and migrating applications, software and services on Azure platform.
- Crafted comprehensive data models suitable for application in various business sectors.
- Led design processes to ensure efficient implementation of projects.
- Utilized statistical software to effectively analyze and process large data sets.
- Stayed updated with industry innovations and emerging trends by reading scientific articles, conference papers, and conducting self-directed research.
- Leveraged knowledge of Agile Methodology to optimize processes, scale solutions, and perform hardware and software tasks in database architecture.
- Recommended data analysis tools to resolve business problems.
- Delivered global thought leadership in analytics solutions, benefiting customers.
- Shared captured best-practice knowledge with developers community.
- Developed and implemented new functions and applications to effectively conduct various analyses.
- Tested, validated and optimized models for accurate outcome prediction.
- Proficient troubleshooter with a talent for identifying and resolving current issues effectively.
Sr. ETL Developer
Millennium Health
San Diego, CA
01.2016 - 08.2016
- Managed end-to-end operations of ETL data pipelines and achieved a 96% uptime.
- Implemented Dimensional and Relational model designs for ETL operations
- Evaluated code for potential glitches and bugs, ensuring 98% fix-time efficiency.
- Analyzed user needs and software requirements, resulting in the determination of design feasibility.
- Completed functional specifications by designing tailored technical solutions for Millennium Health database customers.
- Implemented custom solutions from vendors, such as Pragmatic Works, to establish effective data mapping plans using SSIS ETL and Windows PowerShell scripting.
- Worked collaboratively with support team to provide assistance to client stakeholders in addressing immediate technical challenges and creating optimal resolutions.
- Worked in close coordination with systems analysts, engineers and programmers to gain insight into restrictions, enhance functionalities and resolve software glitches.
- Worked alongside Architects to create strategies for efficient data retrieval and monitoring of data sources.
- Utilized established design patterns to optimize software development and ensure consistent performance results.
- Integrated object-oriented design and development techniques to enhance project performance.
- Analyzed and optimized code, resulting in a 90% increase in output.
- Identified and implemented process improvements resulting in a 95% satisfaction rate among end users/business partners and decreased support calls.
- Resolved customer issues through implementing workarounds and solutions for debugging and creating defect fixes.
- Used object-oriented languages to develop applications and tools focused on code abstraction, stability, and reusability.
- Played a key role in User Acceptance Testing for Millennium customers, validating the conformity of ETL jobs with specified parameters and achieving desired execution outcomes.
- Ensured adherence to internal language policies by applying prescribed programming syntax.
- Modified existing software to rectify errors, adapt to recently introduced hardware, and enhance interfaces.
- Leveraged Agile methodologies for rapid development lifecycle progression from initial prototyping to enterprise-quality testing and final implementation
- Outlined necessary criteria for modifying systems and implementing new systems.
- Facilitation of team and project workflow were improved through my recommendations.
- Coordinated testing and validation procedures throughout the software development lifecycle.
- Collaborated with project managers and stakeholders to comprehensively grasp software design specifications, fostering efficient development strategies.
- Developed protocols for automating processes, as well as implementing backup and recovery measures to preserve and secure data.
Sr. Database | BI Developer
TransCanada Corporation
Boston, MA
05.2013 - 10.2015
- Oversaw the administration of high-value financial management systems like customer and production databases, inventory control, as well as production equipment and editing systems with a trading value exceeding US$20M per day.
- Created database specifications through thorough analysis and development efforts.
- Created and ensured the accuracy of database technology-related documentation for the finance department and trading platform.
- Built integrations from various data sources such as Salesforce, SQL Server, Oracle, DB2 and ERP Systems.
- Identified underperforming databases and implemented effective solutions to enhance performance by 92%.
- Evaluated, designed, implemented and optimized databases and database applications using diverse skills.
- Supported clients in data manipulation and value extraction using SQL, ETL processes, and visual analytics tools.
- Managed all internal analytics practice including ETL, database administration, report development, and integration.
- Achieved flawless execution of a complex database project by effectively addressing and resolving any issues through troubleshooting.
- Worked closely with project management teams to define scope and establish timelines.
- Enhanced client understanding and utilization of data through expertise in SQL, ETL processes, and visual analytics tools.
- Developed data models and database designs for project planning.
- Implemented security initiatives to safeguard critical company information and mitigate data risks.
- Enhanced data integrity by streamlining various data sources and eliminating unverified queries through the construction of a centralized database and warehouse.
- Developed scripts and streamlined processes to enhance data integration and resolve bugs.
- Implemented efficient data structures for analytic purposes.
- Trained and mentored new developers in system operations, code development, design patterns, and implementation.
Education
Bachelor of Science - Electrical Electronics Engineering
University Of Leicester
Leicestershire, England 07.2006
Skills
- Database Design
- Data Warehousing
- Database Structures
- Data Analysis
- Data Migration
- Business Intelligence
- Data Visualization
- Relational Databases
- Database Administration
- Data Security
- SQL and Databases
- Python Programming
- SQL transactional replications
- Big Data Technologies
- API Development
- Continuous Integration
- Data Modeling
- Performance Tuning
Accomplishments
- Modernized Data Warehouse at QuidelOrtho that supports over $500M plus in yearly transactional amount for Finance Team.
- Negotiated with vendors, saving companies over US$1M annually.
- Managed Financial management systems and daily trading platform with over $20M in daily transactional value.
- Led team to achieve overhaul and enhancement of our Operational Data Store as well as upgrade to our Cognos Application, earning recognition from upper management and financial reward.
- Improved delivery of Data for data driven decisions by modernizing our application/systems, realizing overall increase in customer satisfaction and cost efficiency by over 95%.
Certification
- Microsoft Professional, SQL Server 2008R2 - 2010
- Microsoft Azure Data Engineer - 2020
- Microsoft Azure Architect - 2020
- Microsoft Azure Fundamentals
- Microsoft Azure Data Fundamentals
- Microsoft Azure AI Fundamentals
Affiliations
- Endurance runner - runs 18-20miles on a weekly basis
- Camping and outdoors enthusiast
- Interested in volunteering activities where permissible
Timeline
Sr Data Engineer | Data Warehouse Architect
Nelnet
08.2023 - Current
Data Architect
QuidelOrtho
08.2016 - 03.2023
Sr. ETL Developer
Millennium Health
01.2016 - 08.2016
Sr. Database | BI Developer
TransCanada Corporation
05.2013 - 10.2015
Bachelor of Science - Electrical Electronics Engineering
University Of Leicester
- Microsoft Professional, SQL Server 2008R2 - 2010
- Microsoft Azure Data Engineer - 2020
- Microsoft Azure Architect - 2020
- Microsoft Azure Fundamentals
- Microsoft Azure Data Fundamentals
- Microsoft Azure AI Fundamentals
Similar Profiles
ALEX TWOREKALEX TWOREK
Software Engineer II at NelnetSoftware Engineer II at Nelnet
Tamara MatagiTamara Matagi
Enrollment Processor at NelnetEnrollment Processor at Nelnet
Michael ColemanMichael Coleman
Software Engineer at NelnetSoftware Engineer at Nelnet