Professional Summary:

•* years of experience in Information Technology, System analysis, design, and development on both transactional and analytical applications. Worked on providing Business Intelligence solutions using MSBI tools (SSIS, SSRS, SSAS) and Power BI and Tableau.

•Extensive exposure in overall SDLC including requirement gathering, design, development, testing, debugging, deployment, documentation, and warranty support.

•Work with business users at various levels and coordinate meetings at different stages of the project's life cycle.

•Strong experience developing and implementing Power BI visualizations including parameters, and report optimization.

•Experienced in Data Import, Data Analysis, Data Migration, Data Cleansing, Transformation, and Integration

•Proficient in using Power BI data visualization tool to analyze and obtain insights from large datasets, creating visually compelling and actionable interactive reports and dashboards.

•In-depth knowledge of SQL queries and working with RDBMS like Oracle, SQL Server, and MySQL in Agile project methodology.

•Experienced working with ETL teams on Data Migration using SQL, SQL Azure, Azure storage, Azure Data Factory, and SSIS.

•Involved in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Snowflake.

•Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.

•Worked with Microsoft Power BI, DAX expressions, Power View and Power Query integrated with SharePoint.

•Experience creating Filters, quick filters, table calculations, calculated measures, and parameters in Power BI.

•Have good experience in creating advanced chart types, visualizations, and complex calculations to prepare the data as per business need through Power BI.

•Experience utilizing DAX functions like Aggregation, Counting, Logical, Information, Text, and date functions. Good understanding of the Data modeling (Dimensional & Relational) concepts like Star Schema Modeling and well versed in query optimization for performance tuning.

•Experience Working on complex KPI scorecards, heat maps, tree views, circle views, bar charts. Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.

•Proficient in data blending and increased the dashboard performance by extracting data.

•Strong commitment to organizational work ethics, decision-making and managerial skills.

•Familiar with Waterfall and Agile development environments and participated in different agile ceremonies including PI planning, sprint planning, and backlog grooming.

EDUCATION: BSC in Computer Science

Tools and Technologies

Database: MS SQL Server, MS Access, Oracle, DB2, PostgreSQL, SQL Server Management, Snowflake

Programming Languages: T-SQL, DAX, PL/SQL, Snow SQL, C#.Net, Python

ETL Tools: SQL Server Integration Services (SSIS), IBM DataStage, Informatica Cloud

Reporting Tools: Power BI, Tableau, SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report builder

Operating Systems: Windows 7/10, Windows 2008, 2003R2, Windows Server 2012/2014/2016, Windows XP, Windows Vista

PROFESSIONAL EXPERIENCE:

Role: SQL Snowflake Power BI developer May 2021- Present

Client: Costar Group, Washington DC

●Experienced in Analyzing and understanding the business requirements, definition and design of the data sourcing and data flows Involved in creating functional and technical specification documents after gathering requirements from business.

●Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications.

●Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.

●Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.

●Worked on Snow SQL and Created Snowpipe for continuous data load.

●Develop stored procedures/views in Snowflake and use in Talend for loading Dimensions and Facts.

●Worked with DAX/MDX queries in building expressions for various business calculations.

●Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.

●Involved in Developing Power BI visualizations and dashboards using Power BI Desktop.

●By using Power BI desktop connected to various data sources, working with different visualizations.

●Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.

●Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

●Created several user roles and groups to the end - user and provided row level security to them.

●Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.

●Worked with table and matrix visuals, worked with different level of filters like report level, visual level, and page level filters.

●Used various data visualizations including imported or custom visuals.

●Configured incremental refresh and deployment pipelines in Power BI.

●Designed, developed, and deployed different reports like Matrix and Tabular reports with Top N, Cascaded, Parameterized, and pie chart reports using SSRS with Report Builder.

●Used parameters to configure URL report filters and capture last data refresh date and time in Power BI.

Environment: MS SQL Server 2016/2014/2012/2008, Microsoft Visual Studio 2010, MS Access, MS Excel, MS Visio, SQL Server Profiler, Windows Server 2014/2016

Role: SQL/Power BI developer/Analyst Feb 2020- April 2021

Client: Kaiser Permanente, Silver Spring, MD

●Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the reporting needs.

●Discussed with stakeholder teams to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.

●Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables, user defined table types in codes developed)

●Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2016/2017.

●Wrote complex SQL queries to read data from source databases to analyses source system after joining multiple tables.

●Worked with data modeler to understand data model from different source system, also involved in creating dashboards by extracting data from different sources Prepared STTM (source to target mapping) for ETL and Report development.

●Created data visualizations, applied various actions (URL, Filter, Parameters) in Power BI desktop ● Develop, Organize, manage, and maintain graphs, tables, and document templates for the reports.

●Used SQL, PowerPoint, Info View, and Excel daily to generate various performance reports for analysis.

●Developed different types of visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts Waterfall and funnel charts, Gauges and single-number cards, Visual hierarchies and drill-down in the tableau reports.

●Used different functions like number, string, date, Type conversions and Aggregate functions.

●Developed custom SQL queries to minimize the data to improve the performance in power BI.

●Utilized advanced features of Tableau software like linking data from different data sources together on one dashboard to filter data in multiple views.

●Developed Power BI dashboards and published them on to Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

●Scheduled data refresh on for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.

●Used Excel sheet for multiple purposes such as data analysis, data comparison, reporting, data mapping etc.

Environment: Power BI 2.7, MS Office Suite, Oracle 12c, MySQL 7.1, SQL Server 2016/2017, PowerPoint

Role: Database/BI Developer March 2017 - Jan 2020

Client: Exelon, Chicago, Illinois

●Involved in gathering, analyzing, and documenting business requirements, functional requirements, and data specifications.

●Reviewed the data warehouse Star Schema Model and wrote SQL queries joining multiple dimensions, fact tables and reference table.

●Prepared STTM (source to target mapping) for report development.

●Analyzed data using statistical features in Power BI to develop Trend Analysis reports.

●Extract data from different sources RDBMS and CSV through Power BI.

●Created visually compelling and actionable interactive reports and dashboards in Power BI and worked on performance tuning of Power BI.

●Performed data mining on data using very complex SQL queries and discovered Claims pattern.

●Worked with different types of visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts Waterfall and funnel charts, Gauges and single-number cards, Visual hierarchies and drill-down in the tableau reports.

●Refreshed and republish reports and datasets manually and created ad-hoc reports as per need.

●Involved in extensive DATA validation by writing several SQL queries.

●Created individual Worksheets and incorporated them into Dashboards with the appropriate filters.

●Scheduled frequency and time to refresh data for the data sources.

●Troubleshoot any performance issues or performance bottlenecks.

Environment: Power BI Desktop 2.29, MS Office Suite, SQL Server 2014, UNIX.

Role: Business Intelligence Developer (SQL/SSIS/SSRS/SSAS) April 2015- Feb 2017

Client: Ethiopian Airlines, Addis Ababa, Ethiopia

●Worked closely with internal and external users to understand and gather business requirements.

●Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2005.

●Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraints.

●Regular monitoring of SQL server, analyzing the logs, troubleshooting SQL Server problems such as SQL Server service, Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems.

●Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

●Used Merge replication to update the publisher from the subscribers as well as from the subscriber to the publisher in periodically.

●Log shipping database for reporting server within the firms’ latency objective.

●Mirrored one of our critical databases with zero latency/synchronized- with witness/for critical Database on SQL 2008.

●Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.

●Worked with XML configuration files and variables for deploying SSIS packages into various environment.

Environments: Oracle, MS SQL Server 2016, Power BI, SSIS/SSAS/SSRS, ETL, T-SQL, Visual Studio 2016, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT).

Contact this candidate