| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateTigist B.E-mail: EMAIL AVAILABLECell: PHONE NUMBER AVAILABLESummaryOver 8+ years of experience in reporting solution development, ETL development, business intelligence solutions and enterprise data warehouses development involving multiple industries .Expert Knowledge in building and managing relational databases and tables normalization/denormalization using SQL Server Management Studio (SSMS).Expert with producing highly efficient and project-oriented T-SQL query statements.Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.Prepared the complete data mapping for all the migrated jobs using SSIS.Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.Proficient in tuning performance of query statements using Execution Plan, SQL Profiler, and Database Engine Tuning Advisor.Profoundly experience in feature design and flexible usage of tabular charts, donut charts, histograms, and maps to express business solutions comprehensively using visualization tools including Tableau, Power BI, MS SQL Server Reporting Service (SSRS) and Excel.Excellent knowledge of MS SQL Server Integration Service (SSIS) to perform ETL solutions for Data Migration, Data Conversion, Data Validation, Data Management, Reporting and supporting other analysis.Profound understanding of Enterprise Data Warehouses and Data Marts including OLTP/OLAP, Dimension/Fact Tables, Top-down/Bottom-up models, Star/Snowflake Schemas using Landing and Staging stages.Strong Skills in using SSIS Control Flow (Execute SQL task, Foreach Loop Containers, Script Task, File Task, Expression Task, etc.) and SSIS Data Flow (Derived Column, Count, Multicast, Conditional Split, Lookup, Data Conversion, etc.).Substantial experience in usage of Event Handlers, Loggings, Checkpoints, Breakpoints and Debugging in SSIS.Proficient in using skills like Slow Changing (Type 0/1/2/3) and Change Data Capture to load and transform data dynamically.Highly skilled with Agile/Scrum/Waterfall working methodologies along with phases of Software Development Lifecycle (SDLC).Effective problem solver with thorough analytics added to credible and concise presentations.Technical SkillsetRDBMS: MS SQL Server 2019/2017/2016/2012/2008R2/2008/2005, MySQL, Oracle.Reporting Tools: SQL Server Reporting Services (SSRS), Excel 2016/2013/2007, Power BI.Languages: T-SQL, PL/SQL, C++, C#ETL: Server Integration Service (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Data Quality Services.Data Warehouse/OLAP: SQL Server Analysis Services (SSAS).Development Platforms: Visual Studio 2017/2015/2010/2008, SharePoint 2013/2010.Project Management: JIRA, Slack, TFS, Microsoft Project, Microsoft Visio.Capital one McLeanSQL/Power BI Developer Jan 2020-PresentResponsibilitiesInvolved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.Worked on formatting SSRS reports using the Global variables and expressions.Created parameterized reports, Drill down and Drill through reports using SSRS.Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.Prepared the complete data mapping for all the migrated jobs using SSIS.Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.Bank of AmericaSQL/Power BI Developer Nov2018-Dec2019ResponsibilitiesWorked with Application Developers to design databases and tables to supportDevelopment activities and achieve optimal efficiency.Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.Create and Design Databases using MS Access.Import and Export Excel data to MS Access Tables and set compatible data types.Made use of SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.Made Child package using variables and Execute package task in SSIS.Deployed, Tested and Scheduled SSIS packages.Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformationsPNCSQL/SSIS Developer Aug2015 -Oct2018Responsibilities:Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL work flows to populate fact and dimension tables, and developed Cubes and reports for analysis.Developed complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.Troubleshooting and corrects production ETL issues.Optimizing stored procedures, T-SQL, views, and functions for the best performance.Refining and automates regular SQL processes, track issues, and document changes.Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server.Developed complex database objects like complex stored procedures and complex UDFs.Created database objects like tables, views, indexes, and triggers in MS SQL Server that support relational and dimensional database models.Developed script for data manipulation and ensuring data integrity.Designed, developed and maintained a data warehouse.Creating Tabular reports with SQL Server Reporting Services (SSRS).Generating parameterized reports, drill down drill through reports.Deployed reports created report schedules and subscriptions. Managing and securing reports using SSRS.Environment: SQL Server 2019/2017/2016/2012, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Excel, MS Office Suite 2010 (Excel, PowerPoint, Word), JIRA, WebEx, Agile/ScrumAcademic BackgroundBachelors Degree -2007Addis Ababa UniversityInformation SystemsLINKEDIN LINK AVAILABLE |
