Mikyas Legesse
Raleigh,NC
Summary
Experienced MS SQL Server Developer with 7 years experience in Financial, Retail, and Insurance domains. Proficient in MS SQL Server 2014/2012/2008R2/2008/2005, SSIS, SSRS, SSAS, Power BI, and Tableau. Skilled in the entire SDLC, including analysis, design, programming, testing, and documentation. Expertise in data modeling, ETL, data warehousing, and BI tools. Strong in T-SQL, stored procedures, migration, and performance tuning. Detail-oriented designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Data Engineer
Tory Burch
01.2019 - Current
- Led the design, development, and deployment of SQL Server Integration Services SSIS packages, SQL Server Reporting Services SSRS reports, and OLAP cubes at Prosperity Bank, optimizing data transformation, maintenance, and reporting processes across diverse data sources and formats
- Collaborated on table design and report development with technical teams
- Developed SSIS packages for data transformation, including interface stored procedures
- Managed SSIS packages for Oracle and SQL Server instances, including data maintenance
- Deployed SSIS packages and SSRS reports to production servers
- Extracted and transformed data from various sources using SSIS ETL tool
- Designed functional and technical documents, report templates, and standards
- Migration of data from DB2, Oracle, and Sybase to MS SQL Server
- Developed complex SSRS reports and managed report authoring and delivery
- Created OLAP cubes, dimensions, and measures, optimizing data analysis
- Built and optimized cubes for production applications using SSAS
- Contributed to logical and physical data modeling, database design, and TSQL programming
- Developed complex SQL stored procedures for ad hoc report generation using SSRS
- Managed database queries and test cases for report validation.
Sr. SQL Developer
Marriott International
01.2017 - 01.2019
- Led Data Warehouse creation, SSIS package development, TSQL object implementation, DataMart creation, collaboration with Business Analysts, production job monitoring, post-production issue handling, SSRS report generation, OLAP cube implementation, and object deployment
- Led Data Warehouse creation and migration from IBM to Microsoft SQL Server, including SSIS package development for data loading
- Created TSQL objects for data transfer to transaction tables and established DataMart
- Managed SSIS packages for vendor data transfer, collaborated with Business Analysts, and monitored production jobs
- Addressed post-production issues, collaborated on SSRS report creation, implemented OLAP cubes, and oversaw object deployment across regions.
MSBI Developer
DataLab USA
01.2016 - 01.2017
- Created efficient SSIS packages, tune performance, monitor server jobs, resolve service tickets, lead SQL Server migrations, conduct design reviews, configure SSRS, train interns in ETL, and assist with C# programming and system design
- Develop SSIS packages for data extraction and transformation, including performance tuning
- Monitor server jobs, troubleshoot issues, and lead migration projects
- Handle service tickets, prioritize issue resolution, and assist with SSRS report configuration
- Train interns in ETL processes and create Azure Data Storage accounts in ADF
- Possess strong knowledge of C# programming, SDLC, system design, and database systems.
Education
Bachelor of Engineering in Software Engineering -
East Carolina University
Greenville, NC01.2021
Skills
- MS SQL Server 2016/2014/2012/2008R2
- Tableau 100
- Visual studio 2022/2019/2014/2010 (SSAS/SSIS/SSRS)
- ETL
- DB2
- Microsoft Access 2007/2003
- Microsoft Excel (Pivot Table and Chart), OLAP and OLTP
- MS SQL Profiler
- SQL Server Azure
- Atlassian JIRA
- SQL server Query Analyzer
- Index Tuning Wizard
- C# Net
- One Note
- Visio
- My SQL
- Problem Solver: Developed innovative solutions resulting in making processes environment independent to have smooth deployment
- Collaborative Team Player: Successfully collaborated with cross-functional teams to deliver projects on time and within budget
- Strong Analytical Skills: Utilized data analysis techniques to optimize system performance and automate manual processes resulting in a 20% improvement in response time and efficiency
Passions
Promoting Healthcare Access: Passionate about leveraging technology to improve access to healthcare services in underserved communities.
Certification
- Data Analytics, Google - 2016
- Advanced Database Systems, Stanford University - 2016
Timeline
Senior Data Engineer
Tory Burch
01.2019 - Current
Sr. SQL Developer
Marriott International
01.2017 - 01.2019
MSBI Developer
DataLab USA
01.2016 - 01.2017
Bachelor of Engineering in Software Engineering -
East Carolina University