| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateE L E N I Z G E B R UAlexandria, Virginia, United States EMAIL AVAILABLE PHONE NUMBER AVAILABLEOver 5 years of experience in reporting solutions, ETL development, business intelligence, and enterprise data warehouses across multiple industries. Extensive experience with visualization tools like Tableau, PowerBI, Quicksight, SSRS, and Excel. Adept in MS SQL Server Integration Services (SSIS) for ETL solutions, including data migration, validation, and management. Strong understanding of Enterprise Data Warehouses, OLTP/OLAP, and data modeling (Star/Snowflake Schemas). Expert in relational database management, SQL Server Management Studio (SSMS), and crafting efficient TSQL queries. Skilled in using Dynamic SQL, Cursors, Views, Stored Procedures, UDFs, Triggers, and Temp Tables. Proficient in performance tuning with Execution Plan, SQL Profiler, and Database Engine Tuning Advisor. Experienced in SSIS Control Flow, Data Flow, Event Handlers, and debugging. Skilled in Agile/Scrum/Waterfall methodologies and SDLC phases. Effective problem solver with strong analytical skills and clear presentations.SKILLSLanguages: T-SQL, PL/SQL, C++, C#Reporting Tools: SQL Server Reporting Services (SSRS), Excel 2016/2013/2007, Tableau 10/9/8, Quick sight Power BI ETL: Server Integration Service (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Data Quality Services, TalendData Warehouse/OLAP: SQL Server Analysis Services (SSAS) Development Platforms: Visual Studio 2015/2010/2008, SharePoint 2013/2010, Atom, Jupyter, PhyCharm Project Management: JIRA, Slack, TFS, Microsoft Project, Microsoft Visio RDBMS: MS SQL Server 2016/2012/2008R2/2008/2005, MySQL, Oracle PROFESSIONAL EXPERIENCESQL/ETL Developer, Capital One May 2022 - Present RESPONSIBILITIES:SDLC Management: Led all phases of the Software Development Life Cycle, ensuring timely delivery and effective communication between stakeholders.Project Management: Planned, organized, and controlled projects using advanced tools and techniques. Data Warehousing & ETL: Designed and developed data warehouse architecture and ETL processes with SSIS, Informatica, and Azure Data Factory; handled data integration, transformation, and validation. Business Intelligence: Created and implemented BI solutions using Power BI, SSRS, SSAS, and Microsoft SQL Server. Custom Development: Developed T-SQL code, stored procedures, and custom ETL solutions for complex business rules and reporting.Data Modeling: Modeled and designed Dimension and Fact tables, including SCD implementation and data granularity. Environment: SQL Server 2016, T-SQL, SSIS, SSAS, SSRS, C#, VB.Net, TFS, Windows 10, Informatica, Windows Server 2016, Visual studio 2017, TFS, Git Hub, Azure, Point Services 2010, Microsoft office, T-SQL Database Developer, Erie Insurance August 2019 April 2022 RESPONSIBILITIES:Requirement Analysis: Documented and mapped project requirements for diverse data sources. T-SQL Development: Created stored procedures, functions, and views. Data Warehouse Design: Built and managed Data Warehouses and Data Marts using Star Schema. ETL Development: Designed SSIS packages for data import, incremental loading, and SCD implementation. Data Processing: Cleaned, validated, and transformed data; utilized various SSIS transformations. Reporting & Visualization: Developed reports in SSRS and advanced visualizations in Tableau. Environment: SQL Server 2010/2012, Oracle 10g, SQL Server Management Studio (SSMS), MS BI Suite(SSIS/SSRS), Business Intelligence Development Studio, Visual Studio 2008/2010, Tableau 8/9, MS Office Suite 2013(Excel/Access/Word/PowerPoint), TFSEDUCATIONBachelors in Applied science, Mekelle University Sept 2013 - Jul 2017 |
