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
2023.08 - 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
2016.08 - 2023.03
- 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
2016.01 - 2016.08
- 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
2013.05 - 2015.10
- 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
2023.08 - Current
Data Architect
QuidelOrtho
2016.08 - 2023.03
Sr. ETL Developer
Millennium Health
2016.01 - 2016.08
Sr. Database | BI Developer
TransCanada Corporation
2013.05 - 2015.10
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
Tamara MatagiTamara Matagi
Enrollment Processor at NelnetEnrollment Processor at Nelnet
Michael ColemanMichael Coleman
Software Engineer at NelnetSoftware Engineer at Nelnet
Sara SchlenderSara Schlender
Specialist I at NelnetSpecialist I at Nelnet