SUMMARY

• Highly motivated SQL Server/BI Developer with 8 Years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server 2014/2012/2008 , SSRS and SSIS.
• Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T - SQL.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key, Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling.
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Experience in debugging the SSIS packages using breakpoints and checkpoints.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SSRS and Power BI.
• Strong experience in developing parameterized, Sub Reports, Matrix Reports, Charts, Drill down, Drill Through reports, using SQL Server Reporting Services (SSRS).
• Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar Graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and Global filters according to the end user requirement.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

TECHNICAL SKILLS

Operating Systems: Windows2010, 2008, 2007, 2003R2, 2003, 2000Advanced Server, Windows NT, Unix.

RDBMS: MSSQL SERVER 2016/ 2014/2012/2008 R2/2008.

BI TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ETL, Self BI with Excel, Tableau.

Languages: C, C#, T-SQL, Dynamic SQL.

Database Query Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2013/2015/2017 , SQL Profiler, DQS.

EDUCATION: Bachelors in Arts, Addis Ababa University, Ethiopia, 1993

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

MSBI Developer

Responsibilities:

• Expertise in analysis, design, and development of end to end business intelligence solutions using the MSBI suites such as SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS) & SQL Server Reporting Services(SSRS).
• Implemented and enhanced existing reports like Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multi-Value Parameters in SSRS.
• Perform database development that includes Schema development, Stored Procedures that could be used by different Windows Services.
• Used SSIS variables, parameters, & expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.
• Monitored and maintained existing ETL packages and Reports to fix issues and bugs and troubleshooting.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data
• Created various MSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Lookup, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging, and Development.
• Creation of ETL packages to load data from files into database by performing different kinds of transformations using SSIS
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• T-SQL development included queries using joins, sub queries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, constraints, and Database triggers.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Power BI and generate reports with different visualizations.
• Involved in development & amp; Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Creating SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Extensive reporting skills using SQL Server Reporting (SSRS).
• Created Data Models for each module of the current OLTP system and participating in the brain storming session to nail possible design challenges.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Worked on TFS for performing tasks.

Environment: Windows Server 2012 Operating System, MS SQL Server 2016, SQL Server Data Tools for Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, MS Visio, Excel PowerPivot, MS Excel 2010/2013.

Confidential, Boston, MA

MSBI/Power BI Developer

Responsibilities:

• Performed fine tuning of stored procedures and SSIS packages.
• Generated SQL queries for the reporting team.
• Written stored procedures which are used in the source for SSIS packages.
• Created extracts which generate file names dynamically using SSIS.
• Created complex Stored Procedures, Tables, Views, SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Experienced in slowly changing dimension in SSIS packages.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Was involved in the Design of Data Modelling and Implementation of database design.
• Created SSIS Packages to load data from sources like Excel (.xls, .xlsx), Flat Files, .csv files.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards.
• Extensively used DAX functions like SUM, MIN, AVG, COUNTROWS, DISTINCTCOUNT, IF, OR, SWITCH, ISFILETERD, ISCROSSFILTERED, CALCULATE, CALULATETABLE, ALL, VALUES, SUMMARIZE, ADDCOLUMNS, ROW in Power BI and Tabular reports.
• Generated Dynamic Reports from Cubes (SSAS) using SSRS 2012.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.
• Extensively used custom R-Visuals, Clustered Bar Charts, Clustered Column charts, Donut Charts, Hierarchy slicers, Waterfall charts, Scatter charts, Area charts in power BI reports.
• Involved in creating robust complex power BI models, writing complex DAX logics involving rank, filters and data massaging.
• Worked with visual filters, page filters, report filters and drill through filters in power BI reports.

Environment: MS SQL Server 2014/2012/2008 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Power BI, DAX.

Confidential, Los Angeles, CA

SQL BI Developer

Responsibilities:

• Collaborated and coordinated with business analysts to gather requirements for implementing data mart.
• Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application.
• Worked with various SSIS control flow tasks and data transformations like Data conversion, Derived, Column, Look-up, Fuzzy Look-up, Conditional Split, Aggregate transformations etc. as part of ETL.
• Created Event Handlers, Package Configurations, Logging, System and User-defined Variables Incorporated control for solution source control, project coordination, and task management.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS.
• Wrote various reporting queries for Billing, Accounts Payable, Claims, and Customer Service.
• BI team is responsible for development, enhancement & maintenance of various internal and external reports/applications to support claims, members, providers, compliance related processes.
• Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory and experience with Data Lake.
• Configured the cloud databases for HA solutions with Geo-replication.
• Designed and developed various analytical Dashboards from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Parameters, customized Calculations, Conditions, Groups, Sets, Bins, Context filters for various analytical reports and Dashboards.
• Generated context filters and data source filters while handling huge volume of data in Tableau.
• Created Tableau dashboards with Hierarchies, interactive views, drill downs with user level security.
• Experience in creating different visualizations using charts like Bars, Lines and Pies, Maps, Scatter plots.
• Developed Tableau workbooks to perform year over year, quarter over quarter type of analysis.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop and published them to server.
• Designed a database optimization plan like creation of table partitions and the use of appropriate Indexes.

Environment: Microsoft SQL Server 2012, SQL Server Integration Services (SSIS) 2012, Microsoft SQL Server Management Studio, BIDS, T-SQL, Tableau Desktop V8/V9, TFS, Azure