Samuel Chekol
Sr. MSBI Developer at Aumvis PharmaTec- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Aumvis PharmaTec
-
United States
-
Pharmaceutical Manufacturing
-
1 - 100 Employee
-
Sr. MSBI Developer
-
Jan 2020 - Present
-
-
-
-
SQL Developer
-
Jan 2017 - Present
• Experience with all phases of software development life cycle (SDLC) and project methodologies • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures. • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules • Experience with all phases of software development life cycle (SDLC) and project methodologies • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures. • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
-
-
-
NET & COM P.L.C
-
Addis Ababa, Ethiopia
-
SQL Developer
-
Feb 2015 - Oct 2016
• Manage and resolve trouble tickets for database-related issues submitted by customers. • Debugging of application and parsing the SQL query within the SQL Index Tuning Wizard. • Develop and maintain database functionality to support multiple SQL databases. • ETL processes include migrating data from a DB2 database to SQL Server. Implemented high availability on the various servers using replication/mirroring. • Performed routine DBA activities like backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management, Creation of SSIS packages for data loading and applying service packs. • Used stored procedure in a backup and restore process to copy data from Development node to a production node. Show less
-
-
-
USAID
-
United States
-
International Affairs
-
700 & Above Employee
-
SQL Developer
-
Nov 2013 - Jan 2015
• Collected business requirements from users and translated them as technical specs and design docs for development. • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results. • Used Data profiling task to analyze the quality of the customer data from various sources and created SSIS packages to store consistent data in central repository. • Collected business requirements from users and translated them as technical specs and design docs for development. • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results. • Used Data profiling task to analyze the quality of the customer data from various sources and created SSIS packages to store consistent data in central repository.
-
-
-
Bank of Abyssinia S.C.
-
Ethiopia
-
Financial Services
-
100 - 200 Employee
-
SQL Developer/DBA
-
Apr 2011 - Oct 2013
• Experience with all phases of software development life cycle (SDLC) and project methodologies • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures. • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules • Created a CRM Entity Modification tool , functional diagrams, and workflow diagrams • Updated design documents as necessary to reflect changes necessitated by change requests and implementation issues(MS Dynamics CRM) Show less
-
-