Abel Egnet

Experience

1. Ms Sql Bi Developer

   The World Bank Group

   Jan 2019 — Present · Washington, DC, US

   Developed various T-SQL stored procedures, triggers, views, and adding/changing tables and Table valued Functions for data extraction, data load and transformations. Created Reports with different Output formats such as Excel file, fixed width text file, PDF, tab- delimited and pipe-delimited. Worked on several State Reports and used SSIS to create multiple destination files from single/multiple sources. Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc. and scheduled SSIS packages. Created SSRS (SQL Server Reporting Services) reports having multiple Parameters and cascading parameters, Navigation to a sub reports and created book marks when report is exported to PDF or EXCEL File. Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS. Responsible to build Reports for different Markets and AD HOC reports as per request. Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS (SQL Server Integration Services) Documented Back out Implementation Plan for all the work done and also created the CMD files. Worked with Team foundation server version Control to maintain the different versions of Code, RDL Files, Back out Scripts, CMD files & SSIS Packages. Created Subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis. Provided 24/7 Production Support for the maintenance & scheduling of reports.