A
Andrew Ezeamama
About
Detail
Rivers State, Nigeria
Résumé
Jobs
verified_user
0% verified
Senior Data EngineerBluechip Technologies AsiaSep 2024 - Current (2 years 2 months)• Build and automate ETL/ELT pipelines tasks include data ingestion, acquisition, modelling, and transformations, orchestration, consumption and code deployment using Python, SQL and Scripting. • Lead the planning and decision-making processes for data architecture and engineering initiatives. • Design and develop big-data solutions on RDBMS Databases and Hadoop Ecosystems. • Analyze business requirements and translate them into efficient data models. • Design and develop interactive dashboards and visualization reports • Investigate and resolve big-data, data-warehouse and database query performance issues. • Effectively communicate complex technical concepts to both technical and non-technical stakeholders.- ESenior Data EngineerESUSU FINANCIALS,Aug 2022 - Current (4 years 3 months)• Collaborate with other Software, Data Engineers, Data Scientists & other Stakeholders to gather requirements, deliver insights and build, manage back-end applications and data driven ETL pipelines. • Develop data flows, ETL pipelines, analyze, extracts, and loads data on cloud storage S3 buckets, RDBMS, NoSQL, and big data platforms. • Review, track, report and monitor defects using test-driven development to ensure they are adequately identified and resolved prior to go-live. • Optimizing existing data infrastructure and large-scale data processing pipelines using SQL, Python, Snowflake, Talend and cloud services. • Perform basic data/business analyst functions such as metrics requirements gathering, SQL based analysis, technical de
- ELead Data Engineer & AnalystEze Technologies Inc,Jun 2021 - Jul 2022 (1 year 2 months)• Building data pipelines and ETL systems using Python and Spark. Shaping integrations on AWS using Lambda, Glue, S3, Athena. • Analyzing, extracting, and loading data on cloud storage, buckets, NoSQL, and Big Data platforms. • Perform proactive data analysis to address key questions for stakeholders or self-initiated inquiries, identifying factors that drive business success and areas needing improvement in efficiency and productivity. • Develop and manage dynamic interactive visualizations, BI reports, dashboards to interpret trends and patterns using Excel, SQL, Looker, Power BI, and Metabase. • Maintain the accuracy, consistency, and reliability of data throughout its lifecycle, ensuring that decisions based on the data are valid a
- SSenior Database & Data EngineerSHELL PETROLEUM DEVELOPMENT COMPANY OF NIGERIAJun 2019 - May 2021 (2 years)• Monitor pipelines, troubleshoot and investigate data problems and conduct root cause analysis (RCA). • Architect and developed a data warehouse using on-premise ETL tools like SQL Server Integration Services (SSIS) and Azure cloud tools like Data Factory, Azure Data Bricks, Events, Blob Storage, Data lake and Synapse. • Responsible for installation, patching and upgrade of ETL and data-warehouse systems. • Work with IT Project Managers, Application Specialists & Well Scientist/Engineers to successfully delivery projects • Architect and developed ETL pipelines and data warehouse using Big Data tools (Hadoop ecosystem), Microsoft SSIS and Azure tools (Blob, Data Factory, Databricks, IOT Events, Synapse etc). • Develop custom scripts,
- SSenior Database Engineer (DBA)SHELL PETROLEUM DEVELOPMENT COMPANY OF NIGERIAJul 2013 - May 2019 (5 years 11 months)Job Description: Daily maintenance of over two hundred (Oracle, SQL Server, PostgreSQL, MySQL and MongoDB) on premise and cloud databases (Microsoft Azure, Oracle Cloud and Amazon Web Service) in production and test landscapes. Responsible for the following database administration activities
- SSoftware/IT Support EngineerShell Petroleum Development Company of Nigeria,Oct 2008 - Jun 2013 (4 years 9 months)Job Description: Application development, second and third-line support of production operations and logistics system: • Installing new applications and customizing existing applications to make them fit for purpose. • Carry out maintenance of onsite backup and restoration procedures. • Apply software patches, updates and go-live deployment. • Maintain application security of the systems. • Ensuring new systems in project/development phase are supported on go live. • Respond to user queries (1st line) and ensure responses by the team are timely and accurate. • Administer, maintain and provide user training. • Liaise with relevant ICT members of the Infrastructure and Backend teams. • Conduct UAT, parallel testing and regression tes
Education
verified_user
0% verified
- TCertificate in Information TechnologyThe British Computer Society (BCS)Jan 2019 - Jan 2020 (1 year 1 month)
- IImplementing a Data Warehouse with Microsoft SQL ServerJan 2012 - Jan 2014 (2 years 1 month)
- FBachelor of EngineeringFederal University of Technology Owerri (FUTO)Jan 2003 - Jan 2007 (4 years 1 month)
- SFirst School Leaving CertificateSedes Sapientiae NurseryPrimary School Onitsha (SSPS)Jan 1987 - Jan 1995 (8 years 1 month)
- IITIL v3 Foundation Certification (ITIL)
- DData Engineering on Microsoft Azure (DP-203)
- AAdministering SQL Server 2012/2014 Databases
- QQuerying Microsoft SQL Server 2012/2014
- MMCSA: SQL Server 2012/2014
- MMicrosoft SQL Server 2008: Implementation and Maintenance (MCTS 70-432)
- OOracle Database 11g: Administrator Certified Professional (OCP)
- OOracle Database 10g: Administrator Certified Associate (OCA)
- SSun Certified Mobile Application Developer (SCMAD)
- SSun Certified Java Programmer (SCJP)
- PProject Management Professional (PMP)
Projects (professional or personal)
verified_user
0% verified
- RReliability/Integrity Improvement ProcessTransport Application for managing land transport and taxi booking services PREMOB booking Software for land equipment PREMOB inspection and verification using barcode stickers and handheld mobile computer. v2: Software for fuel allocation, management and accountability Operational (ORIP): System mainly used by Production Maintenance team to identify, assess and rank unwanted events and situations, the issues are analyzed, and appropriate actions are selected to solve them Sustainable development management system: Application used to manage projects handled in host communities Scholarship Online Portal/Admin System: The application is designed for the sustainable development team; its major use is to collate undergraduate scholarship onlin
- IIn-vehicle monitoring