Menlilk Fissha
Sr Sql Ssis Developer @GSK
Signup · Get unlimited contacts
WORK HISTORY
Sr Sql Ssis Developer @GSK
Rockville, MD, US
Design and develop ETL process to integrate data among business systems and Data warehouses in Oracle and MS SQL Server.• Develop physical data models using ERWIN and created DDL scripts for database schema and objects. • Maintain and develop system integrations among enterprise front and back end applications (ERP, CRM, EDI, Demand Planning, Manufacturing Control Systems)• Modify SSAS cubes in order to resolve production issues or as per requirements by the business.• Extracted data from data sources Oracle, CSV files, text files, SQL-Server and applied required transformations to clean the data. • Work directly with the business users in order to gather requirements and understand their usage of the data in depth.• Work with VB script in SSIS packages in order to ensure the data flow according to the business requirements.• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and T-SQL code.• Check daily jobs and verify databases in order to ensure the correct flow of data from different systems like IFS (Industrial and Financial Systems) which is a Oracle Financial ERP system for Silgan, WMS (Warehouse Management system), Pivotal system which holds retail and distributor data.• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2014.• Design, code and test and trouble shoot business reporting for end users in Business objects Crystal Reports, SSRS and Tableau.• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.• Created Dashboards with interactive views, trends and drill downs.
EDUCATION
Haramaya University
Bachelor's degree
ABOUT MENLILK FISSHA
8+ years of IT experience in all phase of Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance. • Proficient as SQL developer and involved in database design, development and administration with Microsoft SQL Server 2017/2016/2014/2012 using SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS) in Healthcare, Finance, and Banking domains.• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2017/2016/2014 /2012 databases and scheduled them as per requirements.• Efficient in up-gradation and migration from MS SQL Server 2012 to MS SQL Server 2016• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy Program (BCP)• Proficient in Logical and Physical database design & development (using Erwin, normalization, dimension modeling, Data Modeling, and SQL Server Enterprise manager).• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column and Data Conversion Transformations• Experienced in Importing/Exporting Data from various data sources like Excel, and Flat file using DTS, ETL tools and SSIS services. • Experience in developing Custom Report, different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). • Extensive experience in creating enterprise reports using SSRS 2012 using Report Manager, Report Builder, and BIDS• Scheduled reports for Daily, Weekly, Monthly reports on information for various categories and regions based on business needs using Reporting services (SSRS).• Developed complex Stored Procedures and views to generate various Drill-through, Drill through reports, parameterized reports and linked reports using SSRS. • Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008R2/2012.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.