Business Intelligence Sql Server
Resume:
Rediet Shiferaw
*********@*****.***
PROFESSIONAL SUMMARY
Senior certified SQL/ETL developer with eight years of hands-on IT experience in Analysis, Design, Modeling, Development, Testing, and Maintenance of Business Intelligence Applications and CertifiedSAFe® Practitioner driving data pipeline innovation within Agile Release Trains. Worked in various domains such as Federal, Finance, Healthcare, Learning Solutions, and Retail using different versions of Microsoft SQL Services (SSMS, SSIS, SSRS, and SSAS) and related tools.
Highly expert in translating Business System Design document into a Technical Design document.
Experience in Installation, Upgrade, and Configuration of Microsoft SQL Server and databases.
Expertise in creating Cascading Parameterized and Non-Parameterized report involving Drill down, Drill through features with Matrix, Chart, and Sub-reports using SSRS.
In-depth knowledge of Transact-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User-defined data types, Cursors, and Indexes using Transact-SQL (T-SQL).
Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
Experience in Data Extraction, Transformation, loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
Experience in implementing SQL data cleansing routines that improved data accuracy for customer database.
Expertise in Designing, Developing, and Deploying SSIS packages using Control flow tasks and Data flow transformations.
Experience in enhancing and deploying SSIS Packages from Development server to Production server and Strong knowledge of using variables and expressions.
Proficient in implementing all transformations available on the SSIS toolbox.
Expert in resolving performance issues of T-SQL, PL/SQL scripts and SSIS packages.
Strong experience in Designing, Deployment, and Maintenance of SSRS Reports in SQL Server.
Experience in report writing using SQL Server Reporting Services like Matrix report, Chart report, Pie Charts, and column report.
Excellent technical and analytical skills with a clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
Experience in Requirement Analysis and Business Analysis with excellent Leadership skill.
Strong Experience working on Agile Projects with Multiple Sprint cycles and Scrum meetings.
Skilled in PI Planning, Agile ceremonies, and cross-team coordination within Agile Release Trains (ARTs).
Experience as a collaborative Agile team member delivering value in software development.
Experience designing and implementing server less workflows using AWS Step Functions. Proven expertise in building scalable, event-driven architectures with Step Functions integrations across Lambda, ECS, SQS, SNS, and other AWS services. Strong background in workflow orchestration, error handling, and state management.
Experience in designing AWS Quick Sight interactive dashboards, embedded analytics, and data visualization solutions. Proficient in SPICE datasets, ML Insights, custom calculations (calculated fields, parameters), and integrating Quick Sight with AWS data sources (S3, RDS, Athena, Redshift). Strong background in SQL, data modeling, and business intelligence best practices.
Energetic teamwork player with excellent organizational and problem-solving skills.
Exceptional versatility, and adaptability, extremely diligent with excellent communication skills, ability to work effectively in multi-cultural teams, across different time zones and an individual contributor.
TECHNICAL SKILLS
Top Skills: Microsoft SQL Server, Business Intelligence, BI Architecture, Extract, Transform, Load (ETL), Stored Procedure, Data warehousing, Data Modeling, Performance Tuning, SQL Tuning, Transact SQL, SSIS, SSRS.
Languages: Transact SQL (T-SQL), PL/SQL, XML, Visual Basic 6.0, and HTML.
Databases: SQL Server 2016/ 2014/2012, MS Access, MySQL
Analysis/Reporting Tools: SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS) AWS Quick sight report, Jupiter Notebook.
Embedded analytics (QuickSight SDK/APIs)
BI/ETL Tools: DTS, SSIS, Data Stage, Bulk Copy Program (BCP), Business Intelligence Development Studio (BIDS), Power BI.
AWS Services (EC2, S3, RDS, Lambda, etc.)
Cloud Infrastructure Design and Implementation
Design and develop serverless applications using AWS services such as Lambda and Step Functions
Data Modeling Tools: Erwin, Microsoft Visio.
AWS Step Functions: Standard & Express Workflows, State Machine Design, Error Handling, Retry Policies
Integrations: Lambda, ECS/Fargate, SQS, SNS, EventBridge, DynamoDB, S3, API Gateway
Operating Systems: Windows 98/XP/NT/2000/2003/2008/10, UNIX, LINUX, Mac OS.
Database Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server,SQL Server Data Quality Services.
Project Management Tools: TFS, Jira, share point.
PROFESSIONAL EXPERIENCE
Employer: Jaytech Corporation, Virginia
CLIENT: CFTC U.S.Commodity Futures Trading Commission
September 2021-present
Software Developer
Developed Stored Procedures, Tables, Views, and SQL Join statements for applications by using T-SQL and PL/SQL scripts.
Used SSIS and T-SQL Stored procedures to transfer data from source databases to a staging area and finally transfer into a data warehouse.
Developed and deployed data transfer packages to the appropriate destinations using SSIS.
Used SSIS transformations to implement Slowly Changing Transformations and to maintain Historical Data in a Data warehouse.
Created packages using various Control flow Elements such as Data Flow task, Execute SQL task, Execute Package task, File System task, For Loop Container, For each Loop Container and more.
Performed maintenance of Stored Procedures to improve the Performance of different front-end Applications and scheduled SSIS packages using SQL Server Agent.
Extracted data from various sources (CSV files, Fixml, Excel) and stored data into intermediate Staging Database using the SSIS ETL tool.
Applied several required transformations using Data Flow Task in a Staging Database and made the data ready to load into a cloud-based data warehouses and on-premises hybrid data warehouses.
Integrated various Data Sources like SQL Server, DB2, MS Access into a Staging area then to Data warehouses.
Designed high-level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse and created SQL server configurations for SSIS packages.
Scheduled Reports to run on a daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.
Used SSIS jobs for importing data from flat files sources to the application tables.
Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
Developed interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using AWS Quick sight report.
Designed and deployed 20+ interactive QuickSight dashboards for executive and operational reporting.
Implemented row-level security (RLS) to restrict data access based on user roles.
Automated report generation using QuickSight APIs and AWS Lambda.
Integrated QuickSight with **AWS Athena & Redshift** for real-time analytics.
Design and develop serverless applications using AWS services such as Lambada and Step Functions.
Verifying and reporting the Data migration process for different projects using Jupiter notebook.
Performed maintenance duties like Performance tuning and Optimization of Queries, Functions, and Stored procedures; Monitored and improved Performance using execution plans and Index Tuning.
Customized Team Foundation Server as per project requirements and generated TFS reports to serve company needs.
Maintained high-volume file routing systems processing 50,000+ files daily across SFTP, AS2, FTPS, AWS S3 and AIS protocols.
Environment: MS SQL Server 2014, MS SQL Server 2019, MS Excel 2013, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), AWS Quick sight, PostgreSQL, Visual Studio 2022, Visual Studio 2019, TFS, Microsoft Azure, Amazon Web Services (AWS), Azure Data Factory (ADF), Python, Jupiter Notebook, C#, .NET Framework.
CLIENT: VCU HEALTH SYSTEAMS, Richmond
APRIL2018 – September 2021
Senior SQL /ETL/SSRS /SSIS Developer
Developed Stored Procedures, Tables, Views, and SQL Join statements for applications by using T-SQL and PL/SQL scripts.
Used SSIS and T-SQL Stored procedures to transfer data from source databases to a staging area and finally transfer into a data warehouse.
Took Database Full Backup, Transaction log backup, and differential backup in a daily routine.
Developed and deployed data transfer packages to the appropriate destinations using SSIS.
Used SSIS transformations to implement Slowly Changing Transformations and to maintain Historical Data in a Data warehouse.
Created packages using various Control flow Elements such as Data Flow task, Execute SQL task, Execute Package task, File System task, For Loop Container, For each Loop Container and more.
Performed maintenance of Stored Procedures to improve the Performance of different front-end Applications and scheduled SSIS packages using SQL Server Agent.
Extracted data from various sources (CSV files, oracle, and MS SQL 2000) and stored data into intermediate Staging Database using the SSIS ETL tool.
Applied several required transformations using Data Flow Task in a Staging Database and made the data ready to load into a cloud-based data warehouses and on-premises hybrid data warehouses.
Designed high-level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse and created SQL server configurations for SSIS packages.
Scheduled Reports to run on a daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.
Used SSIS jobs for importing data from flat files sources to the application tables.
Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
Integrated various Data Sources like SQL Server, MySQL, Oracle 11g/10g/9i/8i, DB2, MS Access into a Staging area then to Azure Data warehouses.
Performed maintenance duties like Performance tuning and Optimization of Queries, Functions, and Stored procedures; Monitored and improved Performance using execution plans and Index Tuning.
Customized Team Foundation Server as per project requirements and generated TFS reports to serve company needs. Integrated TFS add-ins called Aggregator to ensure automation.
Environment: MS SQL Server 2016, T- SQL, Oracle 12c, MS Excel 2013, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Visual Studio 2019, Informatica, TFS, CRM, Jira, Microsoft Azure, Amazon Web Services (AWS), Azure Data Factory (ADF), Python, C#, .NET Framework.
CLIENT:AT&T Mobility, Boston, MA
March2017-March2018
SQL Server/Database Developer
Collaborated with Clients and Business Analysts to define data requirements for reporting warehouse.
Designed and developed SQL Server 2012 Databases, Tables, Indexes, Stored procedures, Views, and Triggers.
Involved in a comprehensive Data Analysis and developed Stored procedures and Triggers to manage complex business rules, history data, and audit analysis.
Written complex SQL and dynamic SQL statements using Joins, Sub-queries, and Correlated sub-queries.
Created SSIS packages using Import/Export Wizard.
Designed Packages in SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tools.
Designed and Built Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from a data warehouse and client systems.
Designed and developed ETL processes with SCD (slowly changing dimensions) with T-SQL, SSIS, and VBScript.
Performed Data Migration from an Access database to SQL Server 2012.
Designed packages to extract data from SQL databases, flat files, and loaded them into Oracle database.
Wrote and maintained database documentation, including data standards, procedures, definitions for a data dictionary, and logical and physical models of databases.
Involved in re-design, re-code, and deploy new data extractions using SSIS.
Designed and produced documentation of data transformations for all extractions.
Developed, deployed, and monitored SSIS Packages including upgrading DTS to SSIS.
Designed best practice documents for ETL and Reporting Systems using Data Warehouse concepts.
Created data pipelines using Microsoft Azure Data Factory to automate data movement and transformation.
Created multiple reports using SSRS in Drill mode using Tables, Financial tables, Crosses, Tabs, and Charts.
Designed, deployed, and maintained various SSRS Reports in SQL Server 2012
Involved in the preparation of detailed Unit Cost, Price and Volume Trends, Expense Variances, and Profitability Reports using SSRS.
Integrated SQL and PL/SQL scripts with Server-side Languages and Front-end technologies.
Created reports in both SQL and reporting tools such as Crystal Reports and Business Objects.
Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code and T-SQL code from developers and QA.
Used SQL Server Profiler to trace the slow running queries and Optimized SQL queries for improved performance and availability.
Extensively involved in all phases of software development life cycle (SDLC) including system analysis, design, and development.
Environment: SQL Server 2014/2012/2008/2005/2000R2, T-SQL, PL/SQL, SSRS, SSIS, SSAS, Visual Studio 2008, MS Office 2007/2003, MS VSS, XML, MS SharePoint 2007, Visual Basic 6.0, Java, JavaScript, HTML, Microsoft Azure Data Factory (ADF), Power BI, ERP.
CLIENT: Motorola Inc, Arlington Heights, IL
January 2016 – February 2017
MSBI Developer / SQL SSIS SSRS
Developed Logical and physical data model using ERWIN and mapped the data with database objects.
Created complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implement business rules based on business requirements.
Developed and maintained Stored Procedures, User Defined Functions, Views, TSQL Scripts for complex business logic.
Created reports from complex SQL queries and MDX queries.
Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
Optimized databases by creating various clustered indexes, non-clustered indexes, and indexed views.
Increased performance necessary for statistical reporting by 25% after performance monitoring, tuning, and optimizing indexes.
Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
Used various SSIS Data Flaw tasks such as Conditional Split and Derived Column for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, Bulk Insert task, Data Flow task, Send Mail task, Active Script task, and XML task.
Created SSIS Packages to export/import data from CSV files, Text files, and Excel Spreadsheets.
Created Ad-Hoc Reports, Summary Reports, and Sub Reports using SSRS.
Used Tableau for Data Analysis, Data Visualizations, report generation including Dashboard and Chart.
Scheduled reports for daily, weekly, monthly reports for executives, Business analysts and customer representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS).
Customized Team Foundation Server as per project requirements, generated TFS reports to serve company needs, and Integrated TFS add-ins called 'Aggregator' to ensure Automation.
Experienced with Problem identification, troubleshooting, resolution, and index tuning databases.
Took Database Full Backup, Transaction log backup and differential backup in daily Routine.
Diagnosed and tuned optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
Coordinated with a web development team in .Net framework programming solutions.
Environment: MS SQL Server 2008/2012 SSIS, SSRS, MS SQL Server 2012/2008, C#, ASP.Net, Visual studio 2008/2010, Tableau, MS Access, MS Excel, MS Office Access 2007.
EDUCATION/LICESNCE
Bachelor of arts
University of Gondar Ethiopia 2007
Certified SAFe® 6 Practitioner Scaled Agile
Microsoft certified database developer
Contact this candidate