Andrew Edorh
Plano,TX
Summary
A professional business intelligence developer with over 7+ years of experience in SQL and BI reporting tools such SQL, SSIS and as a Business Analyst. Currently seeking growth-oriented opportunities in Business intelligence in industries like Manufacturing, Health, Education, Logistics, Retail, Technology etc. Enthusiastic team player, dedicated to streamlining processes and efficiently resolving project issues with experience and understanding of SDLC.
Overview
9
9
years of professional experience
1
1
Certification
Work History
SQL/Senior ETL Developer
Maxim Healthcare
Dallas , TX
07.2022 - Current
- Developed ETL processes and objects such as jobs, transformations, mappings, sessions using Informatica PowerCenter 9.6.
- Designed and developed complex mappings with multiple sources and targets to extract data from multiple systems.
- Created error handling logic for all the mappings to capture any errors during the ETL process.
- Applied Conceptual, Logical and Physical & Dimensional/Relational model designs to ETL tasks.
- Analyzed code and corrected errors to optimize output.
- Assessed code during testing stage to determine potential glitches and bugs.
- Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.
- Optimized existing queries for better performance using SQL query tuning techniques.
- Participated in code reviews with other developers to ensure quality assurance standards are met.
- Collaborated with business analysts to understand project requirements, customer expectations and timelines.
SQL/ETL Developer
Encompass Health Rehabilitation Hospital
Plano , TX
01.2021 - 10.2024
- Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources
- Involved in creating database objects such as tables, views, indexes based on business requirements.
- Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server
- Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application
- Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts
- Created stored procedures to build Fact tables in data mart for multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and create super user reports using (SSRS)
- Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS
- Created components, tools, techniques, methods, and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS
- Created SSIS packages for File Transfer from one location to the other using FTP task
- Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project
- Using reporting services (SSRS) generated various reports
- Work directly with Quality Assurance associates to ensure all deliverables are accurate and of the highest quality
- Good database knowledge and experience writing Oracle SQL and Microsoft SQL server SQL queries
- Extensive experience in Tableau Server and Tableau Desktop in various versions of Tableau
- Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
- Tableau design, development, and process documentation to produce required reporting, analytics, and visualization deliverables
- Ability to perform data analysis, troubleshoot data integrity issues and trend data analysis in Tableau
- Development of new Reports / Dashboards/Story using Tableau and relevant data sources (Oracle, Excel, SQL Server, Teradata, Data warehouse etc.)
- Able to creatively stretch the capability of Tableau to customize and develop creatively stunning and dynamic visualizations
- Monitored performance of the ETL processes by creating log files with SSIS logging features.
- Identify and reconcile errors in client data to ensure accurate business requirements
- Configured SSIS package variables, parameters and expressions for dynamic package execution.
- Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
- Created SQL Server Integration Services packages for incremental and full loads of data from various sources.
- Resolved complex issues related to ETL process through debugging existing code or writing new programs.
Business analyst
Code Analytics
06.2018 - 11.2020
- Engage users and stakeholders to gather software requirements/business rules and ensure alignment with development teams
- Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user stories, user cases, workflow/process diagrams, flowcharts and model diagrams
- Identify and reconcile errors in client data to ensure accurate business requirements
- Draft and maintain business requirements and align them with functional and technical requirements
- Lead stakeholder meetings and JAD sessions
- Prepares documentations and stores them on the organizations shared drive or sharepoints
- Interacted with business users to gather business requirement documents
- Analyzed user stories to produced functional and technical requirement document
- Converted user stories into deliverable modules
- Performed Unit, Stress, Regression and UAT Testing
- Created project plans in accordance with project management framework standards and procedures
- Identified ongoing issues and gap within projects plan
- Lead various stakeholder meetings, joint application development meetings and very instrumental in training and preparing training manuals.
SQL Developer
US SECURITY ASSOCIATES
Irving , TX
05.2015 - 11.2018
- Developed stored procedures, functions and triggers to support application requirements.
- Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.
- Optimized existing queries for better performance using SQL query tuning techniques.
- Designed complex reports using SQL Server Reporting Services.
- Implemented data migration from legacy systems to new databases.
- Performed backup and recovery of databases on a regular basis.
- Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
- Maintained security by creating user accounts and granting appropriate privileges as needed.
- Provided technical assistance in the form of SQL coding advice to other team members.
- Analyzed business requirements and translated them into logical data models.
- Configured high availability solutions such as clustering, log shipping and replication for mission critical applications.
- Resolved customer service requests related to database errors or performance issues quickly and efficiently.
- Tested changes to ensure that the system works correctly after implementation.
- Integrated multiple data sources into one unified view using views or joins in SQL queries.
- Collaborated with software developers on designing efficient database structures that meet application requirements.
- Participated in code reviews with other developers to ensure quality assurance standards are met.
- Conducted unit testing of all database objects before deploying them into production environment.
- Generated ad hoc reports upon request from stakeholders utilizing Microsoft Excel Pivot Tables or Access Queries.
- Tested databases and performed bug fixes.
- Developed database dictionaries and schemas.
Education
Bachelor of Science - Computer Engineering
UNIVERSITY OF GHANA
01.2011
Skills
- Microsoft Office (Word, Access, Excel, PowerPoint, Outlook, and Teams)
- Database Management
- Tableau
- C#
- SQL
- AS400
- SAP
- Oracle 11g and 12c
- IBM DB2
- SQL Server
- SQL Developer
- PLSQL
- TSQL
- VISIO
- ERWIN
- SDLC
- Agile methodology
- Control-M
- Autosys
Certification
- SQL certification
- CPR certified through American Heart Association
References
- Jessie Taylor, Supervisor, US Security Associates, 972-522-9204
- Gregory Asamoah, CEO, Code Analytics, 469-222-9162
- Umar, Supervisor, Encompass Health Company, 469-856-3171
Timeline
SQL/Senior ETL Developer
Maxim Healthcare
07.2022 - Current
SQL/ETL Developer
Encompass Health Rehabilitation Hospital
01.2021 - 10.2024
Business analyst
Code Analytics
06.2018 - 11.2020
SQL Developer
US SECURITY ASSOCIATES
05.2015 - 11.2018
Bachelor of Science - Computer Engineering
UNIVERSITY OF GHANA