Osora Nzeribe

Proven Senior Data Engineer | Helping Companies Translate Business Goals to Reality
Cell: 410-929-4054 Email: osora.nzeribe@gmail.com
PROFILE
Dynamic, detail-oriented, analytical professional with exceptional problem-solving and
communication skills. An excellent team player with a quick learning curve who is highly
motivated, can navigate working under time constraints and has the capability to work with
business users, project managers, team leads, architects and peers; thus, maintaining a healthy
environment in the project. Highly-qualified and ready to implement 5 years of experience and
extensive professional knowledge for the development of the organization.
SKILLS SUMMARY
 Knowledge and experience in HANDLING LARGE DATABASES and PERFORMING
COMPLEX MANIPULATIONS
 Experience in writing and testing SQL STATEMENTS, TRIGGERS, FUNCTIONS, and
STORED PROCEDURES
 Deliver high quality code to realize business requirements
 Extensive experience in DATA ANALYSIS, MIGRATION, CLEANSING,
TRANSFORMATION, MANIPULATION, CHART CREATION, RESEARCH AND
REPORTING, AND IMPORT/EXPORT through various ETL tools, different
visualization formats, and from various sources
 Input and Output files to Python
 Excel in delivering HIGH QUALITY LOGICAL, CONCEPTUAL, and PHYSICAL
models
 Great understanding of SDLC methodologies such as Waterfall and Agile
 Connect to data sources using Python
 Manipulate attributes in a DataFrame using methods
 Filtering rows and slicing data in Python
 Experience and knowledge in data modeling using Dimensional Data Modeling, Star
Schema, Snow-Flake, Fact and Dimension Table, Physical and Logical Data Modeling
using Erwin
 Extract and manipulate data from RDBMS to making cutting-edge and prudent decisions
to improve the outlook of the organizations
 Manipulate DataFrames using JOIN and MERGE
 Create a ProfileReport of the data
 Excellent knowledge and usage of reporting tools such as TABLEAU, SAS, and PowerBI
 Able to perform multiple duties in business analysis, project or program management,
and functional leadership
TECHNICAL EXPERTISE
Operating Systems Win XP, Vista, Windows Server 2003, 2008,
2010 (X32, X64), Unix
Databases MS SQL Server, MySQL, AWS RDS,
Snowflake
Cloud Computing Snowflake, AWS, Azure, Jupyter Notebook
Querying Tools/Language SQL Management Studio, TSQL
Business Intelligence Tools Tableau, PowerBI, Excel and PowerPivot
Programming Language/Data Mining SAS, Python, Jupyter Notebook
Tools
ETL/Data Modeling/Other Tools Python, Jira, Erwin Data Modeler, SSIS
Visual Studio, SAS
Microsoft Office: Word, Excel, PowerPoint,
Outlook
Cisco Administering and Implementing Cisco
Solutions
Matlab

WORK EXPERIENCE

Lowes
Morgantown, WV March, 2020 – present

Senior Data Analyst/BI Developer

 Conducted performance tuning and optimization of data queries and data models,
resulting in a 25% improvement in report generation speed and enhanced system
efficiency
 Developed and implemented a robust data visualization framework with Power BI,
enabling stakeholders to intuitively explore and understand complex data sets, leading to
a 20% increase in data-driven decision-making across the organization
 Wrote advanced queries to gather data from different tables by using JOINs, sub-queries,
correlated sub-queries and derived tables on SQL Server platform
 Collaborated with cross-functional teams to define data requirements and ensure data
quality and integrity, resulting in improved data accuracy and reliability across systems
 Create DTS Packages for migration of data between MS SQL Server database and other
databases like MS Access, MS Excel and Flat Files
 Led the development and implementation of a comprehensive enterprise-wide BI
solution, resulting in a 20% reduction in report generation time and increased data
accuracy across the organization
 Mentored and trained junior data analysts, fostering a culture of continuous learning and
enhancing the analytical capabilities of the team
  Developed and optimized complex ETL workflows in Microsoft Azure to ensure efficient
data extraction, transformation, and loading from various sources, resulting in
streamlined data integration processes and a 30% improvement in data accuracy
 Led a data-driven project that identified cost-saving opportunities, resulting in a 10%
reduction in operational expenses and improved efficiency across key business processes
 Created and automated daily, weekly, and monthly KPI dashboards, enabling real-time
monitoring of key metrics and providing actionable insights to senior management
 Stayed abreast of industry trends and emerging analytical tools and techniques,
proactively implementing new methodologies to enhance data analysis capabilities and
drive continuous improvement
 Kept up-to-date with emerging trends in business intelligence, data visualization, and
self-service analytics, proactively incorporating new technologies and methodologies to
enhance BI capabilities and user experience
 Develop advanced stored procedures, views, triggers, execute test cases and defect
management for ETL and BI systems
 Design and drive experiments to form actionable recommendations to grow adoption.
Present to business teams in both ad-hoc forums and routine monthly and weekly
business reviews to drive decisions
 Collaborated with business stakeholders to gather requirements, analyze data needs, and
translate them into scalable and user-friendly BI solutions that met their specific needs

Footaction
White Marsh, MD May 2019 – August 2019

Data Scientist/SAS Programmer

 Applied natural language processing (NLP) techniques to analyze customer feedback
data, resulting in sentiment analysis models that automated sentiment classification with
an accuracy of 90%
 Experience in utilizing SAS Procedures, Macros, and other SAS applications for data
extraction, data cleansing, data loading and reporting
 Used data visualization tools to provide an easy-to-understand interface for end users to
quickly identify key themes within their data
 Pool resources with cross-functional teams to design and implement A/B testing
frameworks, leading to data-driven optimization of marketing campaigns and a 20%
improvement in conversion rates
 Communicated complex technical concepts to non-technical stakeholders, translating
data insights into actionable business recommendations that directly influenced strategic
decision-making
 Integrated Spark in a Python environment
 Utilized SAS to provide ad hoc reporting, tables and listings and graphs, regulatory
submissions, Risk Based Monitoring, and publications
  Developed and produced peer quality metric performance: validated data and processes
to ensure accuracy, completeness, and consistency of data using SAS
 Prepared high level analysis reports utilizing Snowflake and Excel
 Created complex reports like Detail Level Transaction report's, monthly Aging, YTD
cash goal Reports, Quarterly reports by creating multiple queries
 Conducted exploratory data analysis and feature engineering, identifying key drivers of
customer satisfaction and presenting actionable insights that led to a 20% increase in
overall customer satisfaction scores

5 Below
White Marsh, MD May 2015 – December 2016

Data Engineer/Architect
 United data scientists and analysts to optimize data models and schema designs, resulting
in a 20% improvement in data query performance
 Involved in discussions with business users and data architects to define metadata for
tables to perform ETL process using SSIS
 Implemented and deployed complex ETL processes with AWS resulting in a streamlined
and automated data integration workflow that improved efficiency by 40%
 Developed, validated, published, and maintained LOGICAL and PHYSICAL data
models using Erwin Data Modeler
 Led the migration of on-premises data infrastructure to cloud-based platform AWS,
reducing infrastructure costs by 30% while improving scalability and availability
 Used Pivot tables to create reports that performed dicing and slicing functions on data.
This is called dimensional analysis and provides a 360 view of what is going on
 Mentored and coached junior data engineers in advanced cloud-computing concepts and
practices, fostering a culture of excellence and continuous learning within the team
 Created easy-to-understand but insightful Tableau Dashboards with interactive views,
trends and drill downs along with user level security
 Spearheaded the development of a self-service data analytics platform, empowering
business users to access and analyze data independently, resulting in a 50% reduction in
data access requests
 Architected a robust and scalable data warehouse solution that handled large volumes of
data, enabling timely and accurate business intelligence reporting for executive decision-
making
 Experience in utilizing advanced SAS Procedures, Macros, and other SAS applications
for data extraction, data cleansing, data loading and reporting
 Involved in data analysis, DB creation, applying database constraints and making the data
ready to load onto database
  Stayed abreast of emerging trends and technologies in data engineering, proactively
recommending and implementing innovative solutions to improve data infrastructure and
processes
 Enhanced complex SAS Macros to simplify SAS code and effectively reduce coding time
 Imported data using LIBNAME and PROC SQL Pass-Thru facility to reduce processing
time
 Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase
by analyzing the raw data and writing SAS Program and creating complex reusable
Macros
EDUCATIONAL EXPERIENCE
B.S. - Petroleum and Natural Gas Engineering at West Virginia University’s Benjamin Statler
College of Engineering and Mineral Resources