| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSolomon TEmail: EMAIL AVAILABLE Phone: Street Address 796 98 PHONE NUMBER AVAILABLE Bethesda, MDPage 1 of 5Professional Summary Power BI / SQL BI Developer with 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. Goal-oriented usage of features such as Dynamic SQLs, Cursors, Views, Stored Procedures, User- Defined Functions (UDFs), Triggers, Indexes, Temp Table in SSMS to provide convenience for front-end applications or reporting purposes. 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 SkillRDBMS MS SQL Server 2022/2019/2017/2016/2012/2008R2, MySQL, Oracle, PostgreSQL, MS AccessReporting Tools Power BI, SQL Server Reporting Services (SSRS), Excel, Tableau 10/9/8, Microsoft Report Builder, Power BI Report BuilderLanguages T-SQL, XML, C#, JS, HTML, CSS, Python, R (Programming Language), Power ShellETL Server Integration Service (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Data Quality Services, Talend, Azure Data Factory, AWS GlueDataWarehouse/OLAPSQL Server Analysis Services (SSAS)DevelopmentPlatformsVisual Studio 2015/2010/2008, SharePoint 2013/2010, Atom, Jupiter, PyCharm, SnowflakeProject Management JIRA, Slack, TFS, Microsoft Project, Microsoft Visio Tools/ Utility Enterprise Manager, SQL Server Management Studio (SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SQL Server BIDS, DAX Studio, Tabular EditorSolomon TEmail: EMAIL AVAILABLE Phone: 240 796 98 PHONE NUMBER AVAILABLE Bethesda, MD Page 2 of 5Certifications Power BI Data Analyst Associate Power Platform FundamentalsExperiencesData Analytics April 2024 PresentLeidos, MarylandResponsibilities: Developed and managed ETL processes using AWS Glue to perform data extraction, transformation, and loading from PostgreSQL via AWS DMS. Designed and managed data pipelines involving AWS Glue, Glue Data Catalog, AWS Lambda, and Step Functions. Utilized AWS S3 for data storage and management, ensuring data integrity and security. Implemented data analysis and query optimization using AWS Athena. Developed and published interactive dashboards and reports using AWS Quick Sight. Managed IAM roles and policies to ensure secure access to AWS resources. Conducted performance tuning and optimization for ETL jobs in the AWS environment. Collaborated with cross-functional teams to understand business requirements and translate them into technical solutions. Implemented best practices for data warehousing and data management in AWS. Optimized query performance and data transformations using AWS tools. Integrated data from various sources including S3, RDS, into cohesive reports. Ensured data integrity and accuracy through data validation and cleansing processes.Solomon TEmail: EMAIL AVAILABLE Phone: 240 796 98 PHONE NUMBER AVAILABLE Bethesda, MD Page 3 of 5ExperiencesPower BI Developer/SQL BI May 2020 March 2024United Airlines Dallas TXResponsibilities: Developed visual reports, dashboards, and KPI scorecards using Power BI desktop. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards. Imported data from various sources such as SQL Server, SQL Server Analysis Services (Tabular Model), Multi-Dimensional Model, and MS Excel to generate reports. Created DAX Queries to generate computed columns in Power BI. Developed SQL queries using common table expressions (CTEs), views, temporary tables to support the Power BI report. Wrote Calculated Columns, Measures query is in Power BI desktop to show good data analysis techniques. Utilized Power Query for data cleansing and data transformation. Worked on all types of transformations that are available in Power bi query editor. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Explored data in a variety of ways and across multiple visualizations using Power BI. Integrated Custom Visuals based on business requirements using Power BI desktop. Used different types of slicers available in Power BI for creating reports. Created Row Level Security with Power BI and integration with Power BI Service portal. Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services. Experienced in publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and get quick insights about datasets. Involved in the full Software Development Lifecycle (agile methodologies, SCRUM) phases including requirements, design, development, troubleshooting, document design, testing, and training. Created SSIS packages using package logging, Breakpoints, Checkpoints, and Event handling to fix the errors. Worked with a business in the design, loading, and tuning of our Data Warehouse, Data Mart, and Data Vault environments. Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues. Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes. Involved in performance monitoring, tuning and capacity planning using DMVs and third-party tools. Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database. Translated business requirements into BI application designs and solutions. Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension. Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.Solomon TEmail: EMAIL AVAILABLE Phone: 240 796 98 PHONE NUMBER AVAILABLE Bethesda, MD Page 4 of 5 Implemented data viewers, Logging, error configurations for error handling the packages. Involved in the complete life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production). Created and maintained data flow diagrams for existing and future ETL processes. Environment: Power BI desktop, SQL, SQL Server Analysis Services, Agile methodologies, SCRUM, SSIS.ExperiencesBI Developer Dec 2017- Feb 2020Molina Health, Long Beach, CAResponsibilities: Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL workflows 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. Troubleshot and corrected production ETL issues. Optimized stored procedures, T-SQL, views, and functions for the best performance. Refined and automated 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. Created Tabular reports with SQL Server Reporting Services (SSRS). Generated parameterized reports, drill down drill through reports. Demonstrated expertise in health care industry data standards, including X12, CPT/HCPCS, and ICD-10, ensuring precision and compliance in data management and reporting Applied in depth knowledge of health care coding system such as CPT/HCPCS and ICD-10 to drive accurate representation and interpretation of medical information in reporting solution. Successfully navigated health care data intricacies, incorporating X12,CPT/HCPCS and ICD-10 standards to optimize ETL processes and enhance overall data quality Environment: SQL Server 2008/2012/2016, SQL Server Management Studio (SSMS), Oracle, MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Visual Studio 2010, MS Office Suite 2010 (Excel, PowerPoint, Word), Tableau 8/10, Agile/Scrum, JIRA, Microsoft Visio. Solomon TEmail: EMAIL AVAILABLE Phone: 240 796 98 PHONE NUMBER AVAILABLE Bethesda, MD Page 5 of 5ExperiencesBI Developer / SQL Developer June 2016- Nov 2017US Bank, MNResponsibilities: Gathered and documented project requirements from stakeholders and translated them into functional and non-functional specifications for BI reports and applications and transformed them into deliverable solutions. Participated in the data mapping process, figuring out and documenting meanings of columns and tables as well as relationships among them. Extracted data from EHR, EMR, some pharmacies and other external resources using T-SQL and PL/SQL based on business requirements such as Stored Procedures, User Defined Functions(UDFs) and Views Tuned the performance of query statements by analyzing execution plans and logs/statistics in SQL Server Profiler/Database Engine Tuning Advisor Designed and developed ETL packages to realize full loading and incremental loading to convert and migrate data, transform data using lookup, merge joins, derived columns, and built the target data warehouse and data marts based on Star Schema Involved in designing ETL packages using breakpoints and analyzing progress to catch error information by SQL command in SSIS that sends an e-mail message when an error or a warning occurs or when a task fails. Developed reporting solutions for different stakeholders from mock-up demos till deployment to analyze different dimensions as claims, transactions, appointments, supply, assets, and properties both in SSRS and Tableau Developed reporting solutions including tabular reports, matrix reports, using cascading parameters to achieve Drill-down Reports, Drill-through Reports, as well as Linked Reports for security concerns in SSRS 2008/2012 for the front-end application usage. Worked with QA team, clarified and solved the issues, delivered to the project manager for approval and feedback. Optimized SSRS report performance by snapshots and indexes while writing query statements. Environment: SQL Server 2008/2012/2016, ETL, EMR, SQL Server Management Studio, Oracle, MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Visual Studio 2010, MS Office Suite 2010 (Excel, PowerPoint, Word), Tableau 8/10, Agile/Scrum, JIRA, Microsoft Visio. Education BSc in Engineering, Mekelle University MSC in Engineering, Mekelle University |
