Deji A. Adewumi

404-***-**** ad20gk@r.postjobfree.com

PROFESSIONAL SUMMARY:

● A dependable and diligent professional offering several years of diversified customer service/ IT Experience.

● Dedicated to achieving customer satisfaction as well as meeting or surpassing company expectations. Strong rapport with personnel, customers, and associates based on knowledge, professionalism, and integrity.

● Manage multiple tasks, experienced in envisioning and implementing cost effective and result oriented strategy to create and boost awareness of business products and services.

● Using Agile methodology best practices to build, implement and maintain BI solutions to meet business needs.

● Modeling of organization Data based on BI solution requirements, Data cleansing, transformation, building of views, tables, stored procedures, functions, and development of related dashboards.

EDUCATION:

Electrical/Electronic Engineering Degree Acquired 08/8/2000.

The Ibadan Polytechnic- Ibadan, Nigeria. First Degree

CCNA – Cisco Certified Network Associate

MCP – Microsoft Certified Professional

AWS CCP – Certified Cloud Practitioner

TECHNICAL SKILLS:

Tools and Technologies: Windows Server 2000/2003/2008/2012/2016/2023, Windows 2000 Professional, Windows NT/2000/XP/Vista/7/8/10/11

Software:

Databases:

Reporting Tools:

Data Modeling Tools:

ETL Tools:

DevOps Tools and Methodology: MS Project, MS Visio, Adobe Acrobat, Microsoft Office (2007, 2010, 2013, 2016, 2019, 2021) Management studio, SQL, EXCEL. Access (2013, 2016, 2019, 2021), QA Testing tool, test direction version

MySQL–version 5.5 and 5.6, Microsoft SQL Server- version 2005,2008,2012 and 2014, MS Access, Oracle Database 9i, 10g, 11g and 12c Edition

SQL Server Reporting Services (SSRS), SAP WEBI Intelligence, SAP Crystal Reports 10, Power BI Report Server (2017, 2020, 2022), SalesForce, Tableau Server.

Oracle SQL Developer, TOAD Data Modeler, PowerBI, SAP Business Intelligence Suite, Tableau.

SSIS (SQL Server Integration Services), Talend Data Integration, DTS (Data Transformation Services), Jitterbit Data Integration (Harmony Platform) and Jitterbit Cloud Data Loader for Salesforce. Informatica Data Quality (IDQ).

Agile Methodology, Jira, DbUp, Octopus, TeamCity, Git, GitHub

WORK EXPERIENCE:

Senior Data warehouse ETL Developer/Azure Developer Consultant

C.H. Robinson – MN September 2022 – Present

● Designed and developed ETL/ELT pipelines with Azure Data Factory, Azure Databricks (Spark), Azure Data Lake, Azure SQL Database.

●

● Proficient in Microsoft BI platform technologies, SQL Server, SSIS, SSRS, Power BI, Azure Data Factory, Azure Synapse.

● Designed and developed an operational data store (ODS) in Azure SQL.

● Designed and developed data warehouse and operational databases in Azure Synapse.

● Designed and developed extraction, transformation, and loading (ETL) processes in Azure Data Factory (ADF).

● Engaged in end-to-end implementation of a new data warehouse, including all design, development, testing, and support phases.

● Engaged in data modeling and architecture related to target and auditing tables used in ETL loads.

● Designed, created ETL code extraction and cleansing information from several system sources, including files, SAP, and databases. Included support for clear and load, incremental processing and status updates.

● Ensured data accuracy and consistency within the organization and up to date details by meeting with business analysts and management in multiple locales.

● Provided key details and insightful information in performance metrics dashboard to help stakeholders make critical business decisions.

● Conversions of Microsoft Access based system, flat files and multiple source system files to SQL Server.

Enterprise Datawarehouse Engineer (EDW)

Aaron’s Inc – Kennesaw GA September 2017 – August 2022

● The project was focused on Designing and Implementing a Data Warehouse for the organization and the Data Warehouse must support the Business Objectives according to the Data requirements.

● Strongly involved in designing and development of a new data warehouse to store data from multiple line-of-business applications to provide end-users with calculated metrics.

● Lead the development of and documentation of ETL processes for all data warehouse subject areas.

● Lead ETL design sessions with the data teams and project stakeholders.

● Work with Data Management Analysts to ensure proper documentation and definitions are incorporated into the Enterprise Data Dictionary.

● Development of extraction, transformation and loading (ETL) processes using SSIS packages and maintaining ETL framework for consistency within ETL processes.

● Responsible for the analysis, data profiling, development, and integration of disparate systems throughout all phases of the life cycle.

● Design and development of multi-dimensional model data mart for related BI solution for aggregated dashboards to meet business critical needs.

● Provide technical knowledge of extract, transform and load (ETL) solutions for different departments project and best implementation practices and tune automation and optimization.

SQL DBA/Data Integration Analyst/ETL Developer Consultant

Resources Global Professionals (RGP - Atlanta) July 2016 – July 2017

● The project was focused on Designing and Implementing a Data Warehouse for the organization and the Data Warehouse must support the Business Objectives according to the Data requirements.

● Responsible for identifying business requirements of Data Warehouse and

● Planning, Designing, Scheduling and Coordinating Data Warehouse analysis, design, development, and deployment.

● Experience in Data Models-Data Warehouse modeling using Oracle SQL Developer and Toad Data modeler.

● Acquiring Data from primary and secondary sources and maintain Data systems.

● Supports in the Data design, end-to-end development processes of Data extraction, transforming and loading operation data (ETL), as well as Data integration processes like Data Replication and Data Synchronization using Talend Data Integration tool.

● Responsible for designing, building, and supporting all components of data warehouse, such as (ETL) processes, databases, reports, and reporting environments and data sources files.

● Develops and automates (ETL) processes that involve error and reconciliation handling, utilizing Microsoft SQL Server Integration Services (SSIS) and Talend Data Integration tools.

● Performing Data profiling and Source to Target Mappings (While capturing ELT and business metadata).

● Perform testing in Development environment that Data inputs meets business user’s requirements and conduct appropriate functional and performance testing to identify bottlenecks and Data quality issues.

● Experience in Designing and Developing BO Universe using SAP Business Objects Information Design Tool (IDT)

● Experience in Designing and Developing analytical and AD-hoc reports using SAP WEBI Intelligence and SAP Crystal Report tools.

● Responsible for matching patterns using multiple data points and implementing logic to insure data correctness, data validation, constraint testing and duplicate check within Enterprise Informatica Data Quality (IDQ).

● Experience in performing data mapping, data manipulation, data profiling and data cleansing using Informatica Data Quality (IDQ) tools.

● Experienced in all phases of Data Migration from multiple OLTP Data sources using Informatica PowerCenter.

SQL Server Database Administrator/Integration Developer

Victory International Group

Atlanta, GA August 2012 – June 2016

● Design, create and maintain database objects including all physical and logical primary objects such as tablespaces, data files, tables, clusters, indexes, views, sequences, packages, procedures, etc.

● Create and maintain coding standards for stored procedures, triggers, logical and physical DB schema design.

● Responsible for designing, developing and optimizing company databases.

● Constantly provide support for test and company production Database environments to include problem identification, reporting, tracking, analysis and resolution.

● Constantly manage and coordinate (ETL) processes and tasks.

● Performs capacity planning, supporting, troubleshooting, and (ETL) performance modification.

● Experience in creating metadata, developing (ETL) processes, and using several reporting tools; and performing data validation and data cleansing functions.

● Constantly monitor the SQL Database performance and space utilization.

● Have Experience in Microsoft SQL Server 2005, 2008, 2012 and 2014.

● Constantly establish, maintain and monitor database backups, database security, user-role assignments, and individual logins per company security policies and procedures.

● Experienced in SQL Server Management Studio (SSMS) to access, configure, manage, administer and development of all components of SQL Server objects.

● Experienced in using SQL Server Integration Service (SSIS) extensively to solve critical business problems, updating data warehouse, cleaning and mining data.

● Experienced in using SQL Server Agent (SSA) to automate and schedule the execution of SSIS packages, scheduling daily Back-ups and updating the database.

● Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).

● Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).

● SQL Server Reporting Service (SSRS) was extensively used in generating, deploying and managing reports for the organization.

● Experience in data warehousing and supporting high volume production OLTP and OLAP databases.

● Tuning T-SQL queries to improve performance.

● Experienced in Installation of PHP, Apache, and Perl DBI support in MySQL Server version 5.5 and 5.6.

● Experienced in Tuning MySQL Server using Mysqladmin, variable command, setting variables and default parameters.

● Experienced in running multiple servers on a single data directory in MYSQL.

● Experienced in backing up entire database, compressed backup files, backing up individual tables, and using MySQLDUMP to transfer database to another server in MYSQL.

● Experienced in Installation of PHP, Apache, and Perl DBI support in MYSQL Server version 5.5 and 5.6.

SQL Server Database Analyst/Administrator

MasTec Advanced Technology, Atlanta GA March 2010 - June 2012

● Install and configure new SQL Servers.

● Created new tables, views, functions, triggers and stored procedures.

● Data migration from pre-existing and legacy data from Excel to MS SQL Server.

● Experience in Microsoft SQL Server 2005,2008 and 2012

● As new systems are brought in-house, choose whether to use clustering, log shipping, Replication & mirroring, Windows Azure, or other technologies.

● Advise developers on the most efficient database designs (Tables, Data types, Stored Procedures, Functions, etc.)

● Design indexes for existing applications, choosing when to add or remove indexes.

● When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes.

● Conduct SQL Server lunch-and-learn sessions for application developers.

● Deciding whether clustering, log shipping, mirroring, replication, etc. are the right fit to solve a business problem.

● When performance issues arise, determine the most effective way to increase performance including moving objects from staging to production SQL Servers, tests all patches before deploying to production hardware purchases, server configuration changes, or index/query changes.

● Pro-actively ensure database systems are maintained at the highest level of support; plan/set procedures; provide reliable and secure systems for business applications.

● Contribute to project team efforts to ensure operational support requirements are implemented.

● Schedule, monitor, and maintain database backup and recovery procedures which will protect the business.

● Work closely with operations staff to ensure stable performance for the database environments, monitors, analyzes, identifies and resolves bottlenecks and resolves problems.

● Ensure change management procedures and methodologies are implemented and followed.

● Using ETL Development tools in Database Migration to meet the company target etc. (Data Migrator, SSIS, SSDT and Talend Studio) solve company unexpected complex problems in Data Analytical and visualization format.

SQL Server Analyst

Ron’s TV, Austell GA January 2008 – Feb. 2010

● Installs and configures SQL Database setups.

● Manages SQL Server security and logins.

● Manages SQL Database cluster, replication and mirroring.

● Configure SQL Server monitoring utilities to minimize false alarms.

● Designs disaster recovery strategies.

● On-call troubleshooting for SQL Server service outages.

● Designing tables and picking datatypes.

● Using Profiler traces and other tools to find the most frequently run queries.

● Coordinates backups and restore functions.

● Maintained a backup and recovery option to retrieve the lost data.

● Ensure that the new database code meets company standards for readability, reliability, and performance.

● Assisted in building strategies for installing and improving the database.

● Draw up disaster recovery plans for critical and non-critical database.

SKILLS:

.

● A dependable and diligent professional offering several years of diversified customer service/ IT Experience.

● Dedicated to achieving customer satisfaction as well as meeting or surpassing company expectations.

● Strong rapport with personnel, customers, and associates based on knowledge, professionalism, and integrity.

● Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical issues.

● Quickly learn and master new technology; equally successful in both team and self-directed settings; and proficient in a range of computer systems, tools and testing methodologies.

● Understand the technical aspects of database organization, and how database organization affects computer and performance.

● Good communication with users to ensure that all of the data requirements are met in the database design.

● Excellent experience as a leader and a computer technician and troubleshooting.

● Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical issues.

Contact this candidate