| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Charlotte, NCPHONE NUMBER AVAILABLEPHONE NUMBER AVAILABLEhttps://LINKEDIN LINK AVAILABLE(5) Candidate's Name hiwet LinkedInOBJECTIVEA curious SQL Developer with 10+ years of IT experience in designing SQL database in premise and Azure SQL developer. Confident in querying in ETL, T-SQL, SSIS, SSAS, SQL server. Profficient in report Software SSRS, Power BI, Tableau and Python. Good team player, communicative, Resourceful, organized, and dependable problem solver seeking a career opportunity at your company to build winning environments that consistently add value, deliver measurable results, and enhance organizational viability and growth.SUMMARYHighly motivated SQL server, SSAS, SSIS Developer on premises and in Azure environment.Designed SQL database, Tables, views, stored procedures, common table expressions. and functions.SQL server security at server, database, and object level.Experience in writing TSQL queries, DDL, triggers and DML operations.Proficient in data architecture, designing data relationships, data modeling, normalization and denormalization of data tables.Proficient in ETL tools SSIS, Power query editor, Azure Data Factory, Integrate,Python and Excell.Performance tuning, optimizing queries, creating indexes and statistics.Have developed complicated T_SQL using windows functions, string functions, and time intelligence functions.Troubleshooting and maintenance of SQL server, database and T_SQL queries.Optimization and performance improvement of T-SQL queries.Experienced in Azure SQL, Azure data lake, Azure blob.Hands on Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.Exported to/Imported from data from Azure blobs and azure data lakes.Applied Azure Data factory to move data and to transform data.Created SSIS packages and deployed them that collect data from many sources to the SQL data warehouse.Created inner join, left joins, right joins, unions, and intersects.Performed data migration using tools like Data import/export, BULK INSERT and BCP between different heterogeneous systems and SQL Server.Proficient in using SSMS studio, visual SSDT studio, and SSMS Azure studio.Designed and developed a new ETL SSIS package, ADF that loads data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.Experience in Agile project management techniques.Effective Communications skills, Team player and Problem-solving skillsExcellent problem-solving and troubleshooting abilities.EDUCATION& CERTIFICATIONBachelor of Science in Electrical Engineering from Mekelle, Ethiopia in July 2007Microsoft SQL Server Database administrationTECHNICAL SKILLSSQL Server Tools:SQL Server Management Studio, Azure SQL, T_SQL.ETL ToolsSSIS, Power Query Editor, MS excel, Azure Data Factory, PythonData Modeling:SQL table diagrams, Power BI Data ModelOperating Systems:Windows Server 2012/2008r2/ 2016/2019 ServerProgramming:T-SQL, HXML, XML, #C, PythonData modelingStar schema and snowflake in SSMS, SSAS, power pivot, power BI desktopReporting and Data analysisSSRS, Power BI, Tableau, Python and quick basePROFESSIONAL EXPERIENCESQL Developer 06/2022 to CurrentClient: Mutual of OmahaCollaborated with application developers in creating databases and tables to support development activities and drive optimal efficiency.Worked on projects as Data architect and business users to understand business processes.Imported data from SQL Server DB, CSV file, MS Excel, and MS Access to Power BI.Migrated data from SQL on premises to Azure SQL.Designed SQL server, databases and table relationships using T-SQL programming.Created an index on the table to improve performance.Transformed and imported data using SSIS and deployed the packages.Created SSAS projects in dimensional and tabular modeling.Applied security on SQL and database level.Designed tables in SQL Server in snowflake and star schema data modeling.Involved in creating new stored procedures and optimizing existing queries and stored procedures.Normalized and normalized tables based on the company requirements.Used power apps to import data from different locations using T_SQL queries.Created and deployed, maintained SSIS packages.SQL Server Developer 02/2019 05/2022Client: Intellectual Technology Inc, Fort Wayne, INInvolved in requirement gathering meetings and documented business requirements.Created SSIS packages and deployed them in SQL Server.Have written many queries as part of the programming T_SQL.Using Azure data factory to transform and move data in Azure.Have written many T-SQL queries, SQL stored procedures and SQL functions.Instituted complex stored procedures, triggers, functions, indexes, tables, views, SQL joins, and other T-SQL code for business rules implementation.Working in SQL server 2016 environment.Processed XML, JSON Data, CSV file and flat file data using SSIS tool.Created joins, unions and T-SQL queries and subqueries.Created cursors, triggers, indexes, and functions and common table expressions.Expertise Normalization and De-Normalization, Constraints, Data Import and Export etc.Scheduled SSIS packages to run in periodical times.Designed data warehouse, table diagrams, star schema model and relationship between the tables.SQL Developer 07/2017 to 01/2019Client: PCU (Point Comfort Underwriters), Indianapolis, IndianaWrote complex stored procedures and SQL functions.Applied SQL security and data encryption.Wrote stored procedures and functions.Wrote common table expressions and temporary tables.Performance Tuning, optimization and indexing.Improved tuning methods to improve performance in SQL 2116 and SQL server 19.Migrated data from premise SQL server to Azure SQL server.Executed type conversion functions in Power BI connected relational data sources.Deployed windows and SQL patches and hot fixes.SQL Developer 08/2007 to 06/2017Client: Ethio Telecom, Addis Ababa, EthiopiaResponsibilities:Had written and modified stored procedures and functions.Normalized and denormalized data and created relationships.Developed SSIS packages and transformed data.Designed data structure and relations of tables.Have written many complicated computed columns.Created indexes and improved performance.Created common table expressions and derived table.Have developed complicated T_SQL using windows functions, string functions, and time intelligence functions. |
