Sql Server Microsoft
Resume:
MINALE YERDAW
************@*****.*** 703-***-****
PROFESSIONAL • 7+ years of overall IT experience in database development and Database
SUMMARY system Microsoft SQL Server. Administration, Design, Development, and
Support of MS SQL Server 2022/2019/2016/2014/2012 and Development
Environments.
• Extensive knowledge in ER Diagram and design of logical and physical data
modeling using Erwin tool and Visio.
• Expert in planning, modeling, designing, developing, implementing,
administering and maintaining Microsoft SQL- Server, Visual Studio
2019/2018.
• Designed and implemented database schemas, tables, and indexes using
DDL commands to optimize performance and ensure data integrity.
• Developed complex SQL queries, stored procedures, and triggers to support
business applications using DML.
• Highly proficient in the use of T- SQL for developing complex Stored
Procedures, indexes, Tables, Views, User Defined Functions, Relational
Database models, Data integrity and SQL joins.
• Extensive experience in designing de-normalized data warehouse including
Star Schema, Snow Flake Schema and data flow diagrams.
• Extensive experience in creating and using Stored Procedure, Views,
Triggers, schemas and Complex queries on SQL Server Management Studio.
• Experience in writing complex SQL queries involving multiple table's inner
and outer joins, stored procedures.
• Expertise in designing SQL Server SSIS packages to import and transform
data between databases and external data sources.
• Data Mapping based on business requirement for ETL with source to target
data mapping with physical naming standards, data types, domain
definitions, and corporate meta-data definitions and worked on Data
Conversion using SSIS.
• Extensive experience in implementing event driven Error handlings and
package logs.
• Expert in creating Dynamic SSIS Packages with Parameters, local and
environmental variables, XML configuration and check points.
• Expert in creating data visualizations such as dashboards, parameterized
reports, drill down reports, and interactive reports using SQL Server
Reporting Service.
• Hands on experience on developing Page level Reports, Dashboards, and
Stories Using Microsoft Power BI.
• Strong interpersonal & communication skills, Competitive analytical,
logical, and problem-solving skills, Strong management, administrative and
leadership skills to work in team.
• Expert ETL design, Expertise in migrating data from MS-Access, MS-
EXCEL and other external data sources.
• Experience in SQL Server DTS and SSIS (Integration Service) package
design, constructing, and deployment.
• Performed Data Scrubbing, Data Staging and Data Validation in preparation
of pushing data to production environment.
SKILLS • Databases: SQL Server • BI Tools: SSIS, SSAS, SSRS,
2022/2019/2016/2014/2012, Tableau, Crystal Reports, DTS,
Oracle, DB2 BCP, MS, Power BI, Alteryx
• Languages: SQL, T-SQL, • T-SQL Programming (DDL,
PL/SQL, .Net (C#, VB), XML, DML, DCL, TCL) (Stored
DMX, MDX Procedures, Cursors, Functions,
• Operating Systems: Windows Triggers) Data Modeling
Server2008/2003, Linux/Unix • Other Tools: Erwin, JSON,
Service, JIRA, Get Hub, SVN,
Agile Methodology
WORK HISTORY BI(SSRS/Tableau/Power BI/SSIS) Developer Atrium Health -
Charlotte, NC
Feb 2022 until now.
• 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 complex transformations using SSIS/DTS packages.
• Assisting end users with problems installing the power BI desktop, installing
and configuring the personal and on-Premises gateway, connecting to the data
sources and adding the different users.
• Extensively worked in creating ETL SSIS packages both design and code to
process data to target databases.
• Created different Power BI reports utilizing the desktop and online service and
schedule refresh.
• Use Tableau Desktop, Power BI or Alteryx to develop dashboards for various
purposes, functionalities and best practice measures to suit the requirement and
needs of the business.
• Created Complex ETL Packages using SSIS to extract data from staging tables
to partitioned tables with incremental load.
• Handled Tableau admin activities granting access, managing extracts and
Installations
• Created packages in SSIS with error handling and worked with different
methods of logging in SSIS
• Developed, Maintained, and Monitored all import/export and Data
Transformation into the Staging and Production environments.
• Used ETL to implement Slowly Changing Dimension to maintain historical
data in Data Warehouse.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored
procedures for performance.
• Migrate existing legacy reports into Tableau while building new reports from
our
• Created extensive dashboards using data blending.
• Experience in report writing using SQL Server Reporting Services (SSRS) and
creating various types of reports like Tabular, Matrix, Drill Down, Drill
Through and web reporting.
• Designed different kinds of reports from scratch depending upon the
requirements of the markets, vendors, providers and scanners.
• Created different visualization in the reports using custom visuals like bar chats,
pie charts, line charts, cards, slicers etc. also using different transformation
inside edit query and clean-up the data.
• Worked extensively on system analysis, design, development, testing and
implementation of projects (Complete SDLC).
• DAX expressions, analysis and business forecasts.
Environment: MS SQL Server 2019/2016/2012, SSRS, SSIS, SQL Query Analyzer,
SQL profiler, Windows Server, DTS, Share Point Portal Server, HTML, XML, C#,
.Net, ASP.NET, Visual Studio 2019/2017, MS Access, Crystal Reports 2013, MS
Excel 2016.
ETL/SSIS/SQL Developer Core Logic - Columbus, OH Oct 2021 –
Jan 2022
• Extensively worked in creating ETL SSIS packages both design and code to
process data to target databases.
• Created and optimized stored procedures, functions, and scripts using DML to
support business logic and data transformation.
• Designed and maintained database schemas using DDL, ensuring scalability
and performance.
• Created Complex ETL Packages using SSIS to extract data from staging tables
to partitioned tables with incremental load.
• Strongly worked in debugging and troubleshooting the technical issues while
implementing the applications.
• Created packages in SSIS with error handling and worked with different
methods of logging in SSIS
• Developed, Maintained, and Monitored all import/export and Data
Transformation into the Staging and Production environments.
• Experience in providing Logging, Error handling by using Event Handler, and
Custom Logging for SSIS Packages.
• 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 complex transformations using SSIS/DTS packages.
• Used ETL to implement Slowly Changing Dimension to maintain historical
data in Data Warehouse.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored
procedures for performance.
• Created Stored Procedures to transform the Data and worked extensively in T-
SQL for various needs of the transformations while loading the data.
• Created views to display required information on user interface, and triggers to
validate consistent data entry into the database.
• Experience in report writing using SQL Server Reporting Services (SSRS) and
creating various types of reports like Tabular, Matrix, Drill Down, Drill
Through and web reporting.
• Designed different kinds of reports from scratch depending upon the
requirements of the markets, vendors, providers and scanners.
• Documented all the work and all the process of integration and reporting
services for further references
• Worked extensively on system analysis, design, development, testing and
implementation of projects (Complete SDLC).
Environment: MS SQL Server 2019/2016/2012, SSRS, SSIS, SQL Query Analyzer,
SQL profiler, Windows Server, DTS, Share Point Portal Server, HTML, XML, C#,
.Net, ASP.NET, Visual Studio 2019/2017, MS Access, Crystal Reports 2013, MS
Excel 2016.
ETL/SQL/SSRS/SSIS Developer GEICO, Chevy chase, MD Mar
2019 – Sep 2021
• Wrote several SQL Scripts such as finding long running queries, blocking
sessions, archiving data from production to archive server and populating
reporting data.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which
did Data Scrubbing, including data validation checks during Staging, before
loading the data into the Data warehouse.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly,
monthly and quarterly Reports including current status.
• Worked with ETL to implement the slowly changing transformation, to
maintain Historical Data in Data warehouse.
• Leading and mentor the efforts of data quality completeness initiative for
Informatics based ETL architecture.
• Performed assessment of the Atomize system in order to find whether ETL best
practices were followed or not and submitted the recommendations of
improvement.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored
procedures and Triggers.
• Developed and designed cubes with calculated members, Design Dimensions
and using the MDX expressions for the various calculated members, actions and
KPI.
• Created an ActiveX control in .Net that will be used in Visual FoxPro front end.
Visual FoxPro front end will pass few parameters to an ActiveX control; control
then connects to the database and fetches records from DB.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized
and aggregate views of large sets of data and used Multi-Dimensional
Expression (MDX) to access them.
• Involved in Designing and deploying cubes in SSAS environment using
Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized
Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for
executing the reports.
• Rendered reports, managed subscriptions, created reports with report builder,
report snapshot and report Cache.
Tools & Technologies: SQL server 2019/2016/2014, Windows 2010/2011, T-SQL,
Microsoft Share point Portal Server, Fumigant Log Explorer, VSS, SQL Diagnostic
Manager
MS SQL Server (SSRS/SSIS/SSAS) / BI Developer
J.P. Morgan Chase, San Mateo, CA Apr 2017 – Feb 2019
• Designed and deployed reports with Drill Down, Drill Through and Drop-down
menu option and Parameterized and Linked reports.
• Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business
Rules.
• Created reports to retrieve data using database code objects, such as Stored
Procedures, views, functions and multiple T-SQL queries.
• Assisted in the development and maintenance of SQL databases, including
creating tables, views, and indexes using DDL.
• Wrote and optimized SQL queries for data retrieval and reporting purposes using
DML.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly,
monthly and quarterly Reports including current status.
• Developed SSIS package to load data into dimensions and fact tables using
slowly changing dimension.
• Developed Complex SSIS Packages to load data into Staging, ODS, and Data
Warehouse systems.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy
Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Involved with full development cycle of a Data Warehouse, including requirements
gathering, design, implementation, and maintenance.
• Generated test data and tested database to meet the functionalities deliverables in
the project documentation and specifications.
• Agile methodology was used throughout the project, performed pivotal role in
planning and developing as well as aligning with the assigned sprints.
• Developed logical and physical model using Erwin and implementing them to
SQL server.
• Used Execution Planer and Database Engine Tuning Advisor to optimize queries and
enhance the performance of databases.
• Responsible for performance tuning, optimizing the queries, removing redundant and
inconsistent data, joins from the database tables and normalizing them.
• Used Team Foundation Server (TFS) to provide a set of collaboration tools that
work with the existing IDE or editor, to work effectively on the project.
Environment: MS SQL Server 2019/2016/2014, Visual Studio 2018, COM/COM+,
VC++, C#, My SQL, Windows 2011, Windows XP, T-SQL, VB.NET, ADO.NET,
ASP.NET, Visual SourceSafe, XML, MDM, Crystal Reports, SSRS, ERWIN
EDUCATION Bachelor’s Degree in Mathematics minor in Information system.
Contact this candidate