Sql Server Ms
Resume:
Yohannis Hailu
Phone number: 202-***-****
E-mail:adzbm7@r.postjobfree.com
SUMMARY
10+ years of IT industry experience in Database Design, Development, and Business Intelligence utilizing Microsoft SQL Server 2012/2014/2016/2017/2019, SSIS/SSRS/ETL and OLAP as SQL Developer.
Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
Extensive knowledge and experience in dealing with Relational Database Management Systems covering Normalization, Stored Procedures, Constraints, Joins, Indexes, Data Import/Export, and Triggers.
Expert at data transformations like lookups, Derived Column, Conditional Splits, Sort, Data Conversation, Multicast and Union All, Merge Joins, Merge, Fuzzy Lookup, Pivot, Un-pivot and SCD to load data in SQL Server destination.
Experience using Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
Experience writing complex SQL queries for verifying data integrity in Dimension and Fact tables, as well as created and have in-depth knowledge in various RDBMS concepts.
Very good understanding and experience in SSIS, SSAS and SSRS.
Familiar with Agile development and waterfall methodologies.
Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
Developed ETL process using SSIS with various Control flow, and Stored Procedures for the work order validation process.
Expertise in Data Modeling, Normalization and building Referential Integrity Constraints, Database Design and Programming, Development and Implementation of Client-Server Applications and Database systems using MS SQL 2012/2014/2016/2017 for both OLTP and Business Intelligence applications.
Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like Dynamic, Linked, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Document Map, Sub-Reports, and Healthcare QNXT.
Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
Scheduled Automatic refresh and scheduling refresh in Power BI service.
Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Tableau and Spot fire.
Strong foundation of knowledge around Azure and AWS cloud services as well as the cloud ecosystem.
Served as a hands-on subject matter expert for DevOps and Automation in an Azure and AWS infrastructure environment.
Performed database/code migrations and tracked the requests within JIRA.
Developed and analyzed the project requirement specifications, data mapping, diagrams, and flowcharts for developers and testers to carry out the work.
Experienced in generating reports for OLTP and OLAP databases.
Experience in general data mapping of Claim Encounter EDI files including coding, translation, development, testing and deployment.
Collaborated with business users, collected requests, and updated the set of existing BI reports to accommodate business needs.
Developing BI reports and providing invaluable insights. Page 2 of 4
TECHNICAL SKILLS
App / Web Programming C#, ASP, .NET, XML, HTML, HTTP, Dynamic SQL, Visual Studio, Visual Basic Business Analytics
MS SQL Server Reporting Services, Business Intelligence Development Studio, Microsoft Power BI, Crystal Reports, PowerPivot, ProClarity
Database / OLAP / Hadoop
T-SQL, PL/SQL, MDX, MS SQL Server 2012/2014/2016/2017/2019, SQL, MS SQL Server Integration Services, MS SQL Server Analysis Services, Azure Data Factory, Erwin 4.5/4.0, DataStage, Teradata, MS Access
Other Relevant
Microsoft Office SharePoint Server (MOSS) 2012, Microsoft Performance Point Server 2012, UNIX, Azure, AWS, JIRA, Team Foundation Server (TFS) Industry Experience Transportation, Financial Services, Retail, Telecommunications EXPERIENCE
UPS Innovation Center, Parsippany, NJ Mar 2021 - Current MSBI Developer/ Power BI:
Established expertise in designing, developing, and deploying Business Intelligence solutions using SSIS, SSRS, and SSAS
Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI & MDX Queries using SQL Server 2005 Analysis Services.
Broad experience in Query Optimization and performance tuning of stored procedures and functions.
Extensive experience in ETL design/development using MS DTS and SSIS Packages.
Extensive experience in report generation using SQL Server Reporting Services (SSRS) from relational databases and OLAP cubes.
Proven background in translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for the finance industry.
Experienced in creating complex SSIS packages using proper control and data flow elements with error handling.
Provided a wide range of value-added services, including implementation and training, operational management services, health care data analysis, transaction processing, employer health centers, and third-party administrator services for employer-based health plans.
Designed and developed SSIS packages to move data from various sources into destination flat files and databases.
Troubleshoot previous SSIS packages to solve issues. Performance tuning existing scripts and processes.
Developing BI reports and providing invaluable insights.
Comprehend business requirements in a BI context and developed 10+ data models to convert raw data into actionable insights.
Identify 10+ KPIs with outlined objectives and consistently monitor them
Develop 20+ reports using knowledge of SQL queries, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
Collaborated with business users, collected requests, and updated the set of existing BI reports to accommodate business needs.
Implemented three fully functional data schemes and 10+ data flow optimization processes for reporting Performance and enhancements.
Generated and delivered quality reports to customers by conducting quality assurance checks and recorded a 65% increase in customer satisfaction.
Developed four reporting systems that provide accessible information for accurate decision-making. Technologies Used: SQL Developer 2017/2019, SSIS, SSRS, Visual Studio 2017/2019, Oracle, Teradata, DBeaver, MS Excel, MS Office Access 2016, Power BI, Azure Data Factory.
Page 3 of 4
PennyMac Financial Services, Los Angeles, California February 2018 - February 2021
MSBI Developer / SQL /SSIS/ SSRS:
Developed Logical and physical data model using ERwin and mapped the data into database objects.
Extensive work experience on Web based and Windows applications using C#, VB. NET, ASP. NET.
Completed web module development and deployment using ASP.net.
Based on business requirements, developed the complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implement the business rules and transformations.
Developed and optimized Stored Procedures, User Defined Functions, Views, T-SQL Scripting 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 the database by creating various clustered, non-clustered indexes and indexed views.
Increased the performance for statistical reporting by 25% after performance monitoring and optimizing indexes.
Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
Used SSIS to implement the slowly Changing Transformation, to maintain Historical Data in 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, file system task, send mail task, active script task, and xml task.
Created SSIS Packages/ETL to export and import data from CSV files, Text files and Excel Spreadsheets.
Designed and developed matrix and tabular reports with drill down, drill through and drop-down option using SSRS.
Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS and Healthcare QNXT.
Scheduled reports for daily, weekly, monthly reports for executives, Business analyst 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.
Customized and generated TFS reports to serve company needs.
Integrated and customized TFS add-ins called 'Aggregator' to ensure automation.
Identified problems, did troubleshooting, found resolutions, and index tuned databases.
Successfully took Database Full Backup, Transaction log backup and differential backup in daily Routine.
Created Alerts for successful or unsuccessful completion of scheduled Jobs.
Tuned the server for optimal performance using SQL Server 2008, SQL Profiler and Database Engine Tuning Wizards.
Coordinated with web development team in .Net framework programming solutions.
Integrated ASP.Net Web Pages to the SQL Server 2012 Back End. Technologies Used: MS SQL Server 2012/2014 SSIS, SSRS, MS SQL Server 2012, C#, ASP.Net, Visual studio 2012, MS Access, MS Excel, MS Office Access 2012
Rodan & Fields, San Ramon, California May 2016 - January 2018 SQL Server Developer:
Involved in new databases design and creation using Rational Rose.
Created Database Diagrams using third party tool ERwin in beginning of the project. Identified database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
Worked on creation and improving the stored procedures and triggers performance.
Experienced in Design of OLAP Data warehouse using Star Schema and Snowflake Schemas.
Extensively used Microsoft SQL Server, BPS, SQL Basic, Healthcare Payer, Healthcare Domain.
Developed, analyzed the project requirement specifications, data mapping, diagrams, and flowcharts for developers and testers to carry out the work.
Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions.
Page 4 of 4
Created Database Diagrams using third party tool ERwin in beginning of the project. Defined relationship between tables and enforced the referential integrity constraints.
Responsible for Query Performance tuning and Optimization.
Created views, SQL joins DTS packages and statements for applications.
Designed and implemented stored procedures and triggers for automating tasks.
Generated T-SQL code for creating cursor and handling the data validations.
Created SQL server Analysis Projects using MS SQL Server 2012.
ETL packages are created to extract, transform and load data to data ware house using SSIS.
Using SSIS the data/ETL was transferred to and from flat files, MS Excel, MS Access and SQL Server 2012.
Implemented the calculations to aggregate physical measures using management studio.
Involved in creating Multidimensional Cubes and Relational Cubes.
Used BCP techniques, Stored Procedures, Triggers, Cursors and Transaction management, T-SQL to convert data from various sources to MS SQL 6.5/7.0 databases.
Supported development of a speciation control documents for an MS Access Project Management Database. Technologies Used: SQL Server 2012, MS-SQL Server Management Studio 2000/2012, T-SQL, DTS, Replication, SSIS 2012, SSRS2012, Rational Rose, Windows 9x/Windows NT, MS SQL Reporting Services 2012, MS SQL Server Analysis Services 2012, MS SQL Server Integration Services 2012, MS Access, ERwin, SQL Query Analyzer Charter Communications, Denver, Colorado February 2013 - April 2016 SQL Server Developer:
Worked with stakeholders, and translated requirements to design and build a solution that met Business needs and integrated seamlessly with the EDW (Reservation, customer service, Ground service, Maintenance & Engineering, corporate, inflight etc.)
Involved in designing the technical deliverable artifacts such as source-to-target mappings, implementation run books etc. needed for project implementation.
Conducted ETL, Data Warehouse Modelling, OLAP, processes documentation and BI solution delivery.
Gained experience in Extract, Transform & load (ETL) data from various sources like Flat File, Excel, and RDBM’s using SSIS tools.
Created various database objects such as Tables, Views, Stored Procedures and Indexes and wrote T-SQL queries to retrieve data from various tables.
Gained a practical understanding of the Data modeling (Dimensional & Relational) concepts like Star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Modified the existing SSIS packages to meet the changes specified by the users.
Developed, tested, and deployed codes (Packages, procedures, functions) in the backend using SQL for any enhancement based on the business requirements for the existing applications.
Participated in system integration, regression testing and UAT.
Involved in developing various operational reports such as Sub Reports, Charts, Matrix reports, Drill-through, Drill Down and parameterized reports and Created report models on Ad-hoc reports.
Provided recommendations to improve system functionality and processes within the BI environment.
Compiled verify accuracy and sort information according to priorities to prepare source data for computer entry.
Prepared quotes, covered telephones, provided customer support, maintained administrative records, and verified the installation and end-to-end, as well as kept all the information confidential.
Reviewed data for deficiencies or errors, corrected any incompatibilities if possible, and checked the output. Technologies Used: MS SQL Server 2012, Windows 2000, MS Access, T-SQL, DTS, VB 6.0
Contact this candidate