PATRICE LEKE
DATA ENGINEER
Clarksville,TN
Summary
Dependable ETL Developer with 4 years creating reliable and accurate data transformation tools. Well-versed in technologies such as Azure Data Factory (ADF) and Data Lake. Designs ETL tools to scale overwhelming data transition tasks into manageable projects with realistic timeframes and achievable budgets.
Overview
8
8
years of professional experience
5
5
years of post-secondary education
Work History
ETL Developer
UA Army
Clarksville, TN
03.2019 - 10.2022
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
- Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
- Wrote and optimized in-application SQL statements.
- Trained in coding for numerous Data Warehousing solutions.
- Interpreted data models for conversion into ETL diagrams and code.
- Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Utilized code versioning systems such as [Type] to reduce development times.
- Directed data transformations and transitions using Pentaho.
- Verified performance and reliability of development database transformation solutions via extensive simulation testing.
- Optimized broken and inefficient assets through effectively troubleshooting technical processes and workflows.
- Developed and delivered business information solutions.
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Managed identification, protection and use of data assets.
- Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
- Established and secured enterprise-wide data analytics structures.
- Designed data models for complex analysis needs.
- Documented and communicated database schemas using accepted notations.
- Planned and installed upgrades of database management system software to enhance database performance.
Associate Data Engineer
ACM Technologies
Silver Spring, MD
03.2017 - 01.2022
- Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
- Developed, implemented and maintained data analytics protocols, standards and documentation.
- Used JavaScript, Bash/Linux shell scripting and Python to design and update databases.
- Designed and implemented effective database solutions and models to store and retrieve data.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Performed large-scale data conversions for integration into [Product or Service].
- Designed and developed analytical data structures.
- Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
- Communicated new or updated data requirements to global team.
- Explained data results and discussed how best to use data to support project objectives.
- Employed data cleansing methods, significantly Enhanced data quality.
- Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
- Prepared written summaries to accompany results and maintain documentation.
- Used GDP on validation protocols, test cases and changed control documents.
- Monitored incoming data analytics requests and distributed results to support [Type] strategies.
- Designed advanced analytics ranging from descriptive to predictive models to machine learning techniques.
- Built databases and table structures for web applications.
- Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
- Contributed to internal activities for overall process improvements, efficiencies and innovation.
- Ran statistical analyses within software to process large datasets.
- Applied loss functions and variance explanation techniques to compare performance metrics.
- Implemented randomized sampling techniques for optimized surveys.
- Improved data collection methods by designing surveys, polls and other instruments.
- Tested and validated models for accuracy of predictions in outcomes of interest.
- Leveraged mathematical techniques to develop engineering and scientific solutions.
- Compiled, cleaned and manipulated data for proper handling.
- Presented findings orally and in writing with advanced mathematical models.
- Modeled predictions with feature selection algorithms.
- Developed polished visualizations to share results of data analyses.
Education
Bachelor of Science - Cybersecurity And Managerial Policy
University of Maryland - University College
Hyattsville, MD 01.2018 - 12.2022
Skills
Data Warehousing Management
SQL Programming
Staging tables
RDBMS
Excellent Communication
Planning and Coordination
Critical Thinking
Solution development
Organization and Time Management
Good Telephone Etiquette
Report generation
Timeline
ETL Developer
UA Army
03.2019 - 10.2022
Bachelor of Science - Cybersecurity And Managerial Policy
University of Maryland - University College
01.2018 - 12.2022
Associate Data Engineer
ACM Technologies
03.2017 - 01.2022