Lawson Ekane

Email: adheh9@r.postjobfree.com

Tel: 202-***-****

Skills Summary

•Detail-oriented, efficient and organized professional with 7-year experience in ETL, Data warehouse, Data Integration and SQL development.

•Organized, take-charge professional with willingness to fill in as needed, eagerness to quickly self-learn new technologies, exceptional follow through abilities and detail orientation; a drive and dependable performance to doing things right.

•Possess strong analytical and problem-solving skills, with the ability to make well thought out decisions.

•Excellent communication skills in data management, listening and assessing required Business needs.

Professional Experience

RTI International – Raleigh, NC June 2019 to Present

Data Architect / Data Warehouse Engineer

•Develop technical best practices for data movement, data quality, data cleansing, and other ETL related activities.

•Engineer and develop across various integration technologies (Data Integration, Application Integration, Business Process Integration, UI Integration, etc.)

•Ensure adherence to locally defined standards for all developed components

•Design, develop and implement enterprise-class Data Warehousing solutions, including a Standard Integration Framework.

•Provide data analysis and technical documentation for both Source and Target mappings

•Automates manual tasks and implements stabile, reliable and self-correcting data movement solutions.

•Ensure that the ETL requirements are adequately understood and documented; participate in requirements, design and development reviews.

•Conduct/participate in meetings with key system owners to understand current data and systems environments, resolve source data issues and refine transformation rules.

•Analyze source system data to assess data quality; work with technical and business representatives to determine strategies for handling data anomalies identified

•Design ETL processes and develop source to target data mappings, Integration Workflows and load processes.

•Develop, test, integrate and deploy ETL routines using ETL tools and external programming/scripting languages, as necessary.

•Administer and maintain the ETL environment, including performing configuration management activities related to the ETL environment.

•Assist with performing source data quality assessments.

Local Government Federal Credit Union – Raleigh, NC Dec 2018 to June 2019

ETL / Data Warehouse Developer

•Design and create a Data Warehouse to meet the need of the company

•Designing databases and ensuring their stability, reliability, and performance.

•Design, create, and implement database systems based on the end user's requirements.

•Improve application's performances.

•Prepare documentations for database applications.

•Develop database schemas, tables and dictionaries.

•Ensure the data quality and integrity in databases.

•Fix any issues related to database performance and provide corrective measures.

•Create complex functions, scripts, stored procedures and triggers to support application development.

•Perform root cause analysis on all processes and resolve all production issues, validate all data and perform routine tests on databases, and provide support to all ETL applications, including developing of SSIS packages using SSDT and scheduling jobs in the SSISDB.

•Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.

•Coordinate with ETL team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.

•Create Change or Issue (incident) request to resolve issues with applications using

SAMANAGE, JIRA and or SERVICE NOW

TD Bank NA - Greenville, SC Apr 2013 to Dec 2018 ETL Developer

•Install, upgrade and configure SQL Servers from SQL Server 2005 to SQL Server 2017 R2enterprise edition and enabling SSIS/SSRS/SSAS on Client machines, Development, Production servers.

•Create stored procedures, views, triggers and constrains to implement the database consistency and integrity.

•Implement indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.

•Create SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.

•Schedule SSIS packages Created as Agent jobs using SSMS.

•Perform tuning at source, transformation, target, and workflow levels.

•Analyze and executed the test cases for various phases of testing - integration, regression and user.

•Develop and maintained ETL (Data Extraction, Transformation and Loading) mappings using SSIS to extract the data from multiple source systems that comprise databases like SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.

•Create stored procedures using SQL Server management Studio to carry out required task.

•Prepare Change Orders for monthly Deployments to Production Environment.

•Create, INSERT and UPDATE tables within the development environments and push for deployment into Production environment.

•Capture business information needs from stake holders and translated into requirements and functional specifications. Evaluated and recommended best form of delivery - report manager report, refreshable Excel spreadsheets, or SSAS Cube.

•Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

•Experience in working with SSAS in creating cubes, 7.0, Oracle, MS Access, data source views, named queries, dimensions and deploying of analysis services projects.

•Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.

•Involve in designing cubes in SSAS environment using Snowflake and Star Schemas.

Technical Skills

SQL Server Management studio (SSMS), SQL Server Data Tools (SSDT), Visual Studio,

JiRA, ServiceNOW, Samanage, C#, Python, SalesForce, Costpoint, Tableau, Power BI, Source Control for Team Foundation server(TFS), DevOps Github, Cognos reporting, Presto

Education

Harvard Business School – Business Analytics 2019 to 2020

Grand Canyon University - MBA 2017 to Present

University Of Buea - BSC. Accounting 2005 to 2009

Contact this candidate