Mikiyas Moges Asmare
202-***-**** ad1ale@r.postjobfree.com
Professional Summary:
Over 6+ years of working experience in MS SQL Server in various domains like Finance, HealthCare, Retail and Insurance with expertise in MS SQL Server […] SSIS, and SSRS.
Experienced in handling multiple tasks under strict deadline and capable of handling responsibilities independently as well as a proactive team member.
Highly proficient in using T-SQL, writing Stored Procedures, Triggers, Functions, XML and Cursors in SQL Server.
Expert in Data conversion, Data modeling, Normalization and SQL Server Enterprise manager.
Involved creating ETL process, Data warehousing, Operations Data Store concepts.
Expert in Creating, maintaining and Configuring SSIS packages.
Involved working with heterogeneous data source like Excel, Flat file and SQL Server.
Expert in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Involved creating operational reports in SSRS […] i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports for various domains.
worked on creating SSIS package, maintaining and troubleshooting the package.
Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks
Involved in Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
Defined and administered database standards, controls, procedures and documented them
Experienced in Creating report by using Power BI Desktop.
Expertise in Microsoft SQL Server BI reporting applications and tools (Management Studio, Reporting Services, Visual Studio/SSDT, Integration Services)
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Used the SSIS to migrate databases such as Excel files, flat files, and SQL Server database to centralized IT destination.
Environment: MS SQL Server 2014/2012, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Office
TECHNICAL SKILLS:
Cloud Technologies
Microsoft Azure
Databases
SQL Server 2008/2012/2014/2016/2017, Access
Programming Languages
T-SQL, HTML, XML
BI Tools
SSIS, SSAS, SSRS, Power BI
Operating Systems
Windows Server 2003, 2007, 2010, 2013, Windows 8/NT/XP/Professional, MS- DOS, Red Hat Linux
Version Control
TFS/GIT
Languages
T-SQL, PL/SQL, MS Access
Tools
SQL Server Management Studio
PROFESSIONAL EXPERIENCE
CareMetx - Bethesda, MD
SQL/SSIS/SSRS Developer
April 2019– present
Responsibilities:
Participated in daily agile scrum meetings to understand business logic and requirements of the company.
Involving in complete software development life cycle (SDLC) like Requirement Analysis and Specification, technical design and Implementation.
Writing Joins and sub-queries for complex queries involving multiple tables from different database.
Wrote different Validation Scripts to check the accuracy of data.
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables, SQL joins and other T-SQL code to implement business rules for SSRS reports. Implemented different types of constraints on tables for consistency.
Generated SSIS Packages using Fuzzy Lookup, Derived Columns, Conditional Splits, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
Creating reports subscriptions using SSRS to send data in PDF, Word and Excel format on Daily, weekly, monthly and yearly basis via emails and sending to shared folders.
Involved in designing and deploying Tabular, Matrix, List and Chart reports with Drill Down, Drop down menu option, Parameterized and Sub reports.
Responsible for designing, developing and deploying Drill through, conditional and dynamic reports.
Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Lookups, Aggregations, and Multitasking.
Designing, deploying, scheduling and maintaining various SSRS Reports in SQL Server in test, staging and production environments.
Michael Kors - Jersey City, NJ
MSBI Developer
March 2017 – March 2019
Responsibilities:
Participated in daily, weekly stand up meetings with PM and other leads to discuss the status of the project.
Developed complex stored procedures and user defined functions involving with multiple tables and views.
Wrote SQL scripts with different types of temp tables and common table expressions to carry out the business logic.
Improved performance of queries used as data sets for SSRS reports.
Adopted drill down, drill through, and parameter functionality for reports with multiple pages.
Delivered various reports in multiple rendering formats with data driven subscriptions to users.
Configured data Sources and used shared and embedded datasets in SSRS reports.
Created SSIS ETL packages to attach the letters to its respective events by extracting data from different sources and loading to the different destinations such as SQL server, flat file and excel file.
Developed new reports and optimized existing reports to meet the user needs.
Analyzed reports and used complex expressions and fixed bugs in stored
Procedures.
Managed development work on Team Foundation Server (TFS).
Developed reports using efficient data retrieval techniques and tested the reports.
Designed stylish Report Layouts and Deployed the Reports using SSRS 2012/ 2008r2.
Wrote Complex Stored Procedures, Triggers, Views and Queries.
Estes Express Lines - Richmond, VA
Database Developer
February 2016 – January 2017
Responsibilities:
Involved in DataMart planning meeting with Project Manager, Business Analyst and Team members to analyze the business requirements and outlined the proposed solutions.
Developed stored procedures for performing various tasks on databases.
Implemented execution plan, indexes and dynamic SQL to optimize queries such as stored procedures.
Implemented error handling in procedures utilizing try-catch block and raise error.
Created various data connections from data source to SSRS for report and dashboard development.
Created parameterized reports, drill down reports & summary reports by utilizing SSRS.
Created document map for easy navigation to the particular section of the SSRS report.
Scheduled reports execution on daily basis in order to support the incremental load of the databases in SSRS.
Developed best suitable user interface for management dashboards with Power Pivot.
Involved in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
Proficient with Excel and pivot tables, charts, dashboards.
Education
Bachelor’s Degree ( Textile Engineering) Wollo University kiot
Wollo Ethiopia 2010 – 2015