| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
PHONE NUMBER AVAILABLE
EMAIL AVAILABLE
PROFILE SUMMARY
Dynamic and motivated MS Business Intelligence Report Developer with more than 5+ years of experience in
designing and development of database and business intelligence applications utilizing Microsoft BI stack
(SSIS/SSAS/SSRS) and Poer BI, in complex working environment Including creating and migrating stored procedures
from on-premises SPs to Databricks notebooks.
Hand-on experience of writing SQL Queries, SQL objects - stored procedure, functions, triggers, cursors, and
optimizing performance.
Ensure process efficiencies and maintain data quality, Develop, design, tune and maintain SSIS packages to
perform ETL operations.
Possess industry-wise experience in developing entire ETL framework and executing ETL strategies utilizing SSIS
packages.
In-depth knowledge of developing SSAS cubes with dimensions, perspectives, hierarchies, groups, measures and
KPIs to analyze business units. Export Microsoft Analysis Services cubes
Proficient in creating and modifying reports, utilizing MS SQL Server Reporting Services (SSRS) and Power BI and
Work with the entire Microsoft SQL Server stack.
Adaptable, able to work independently to meet organizational goals with minimal supervision.
TECHNICAL SKILLS
Database Programming: T-SQL, Dynamic SQL, Scala, Python, Snow SQL, MDX, DAX,
Development Tools: SSDT, SSMS, BIDS
Integration Tool: SSIS, ADF
Analysis Services: SSAS, OLAP Cubes, Tabular Model
Reporting Tools: SSRS, Excel Adins (Power Pivot, Power View, Master Data Service (MDS) and Excel Data
Loader (EDL)), Power BI
Source Control & Collaboration: Git, SharePoint, Azure DevOps
Cloud Experience: Azure SQL, Azure Data Warehouses, Azure Data Factory, PowerShell, Azure Storage (Data
Lake), Databricks and Synapse
Database: SQL Server2022,2019, 2017, 2016, 2014, 2012, 2008/R2, Poly-base, Synapse Serverless pool
SDLC: Agile, Scrum, Waterfall, and Spiral
Data Modeling: ER-win, MS Visio
PROFESSIONAL EXPERIENCE
Joyin Inc.| Phoenix, AZ May 2021- Now
Data Analyst
Tools & Environment: MS SQL Server 2022, T-SQL, SQL Profiler, ETL, SSIS, SSDT, SSRS, TFS
Performed analysis, gathered requirements, and documented requirements in JRD sessions.
Created ER diagrams for the proposed data mart with the help of Erwin.
Performed data analysis during development and reported findings to the team.
Provided scalable solutions for handling large data volumes in context to data mart for reporting purposes.
Lead data analytics projects from requirement stage, scope analysis, developing models, deployment and support.
Performed data analysis during development and reported findings to the team.
Designed various artifacts for projects including specification documents for data mapping and data analysis.
Performed complex data analysis in support of ad-hoc, standard, and project related requests.
Recommend SQL tuning for report queries for them to work efficiently on high volume scenarios.
Utilized DMVs and DMFs for metadata and code management in SQL Server as per requirements.
Optimized the performance of slow running T-SQL queries by analyzing execution plans, as well resolving issues
related to stored procedures.
Utilized various SSIS components such as conditional split, derived column, script task and script component for
data scrubbing, data validation and advanced data transformation during the ETL process.
Created summary and detail reports utilizing drill down and drill through functionalities in SSRS.
Managed TFS (Team Foundation Server) to synchronize data with various sources
UHAUL| PHOENIX, AZ Aug. 2018 April. 2021
SQL/ETL Developer
Tools & Environment: SQL Server 2016, Erwin, ETL, SSMS, SSDT, SSIS, DAX, Power BI, Power BI Desktop, T-SQL, TFS,
DTA
Worked in coordination with business users to clarify business requirements about database application.
Participated in all phases of SDLC methodologies throughout the project life cycle.
Wrote complex stored procedures, functions, and SQL constructs to implement business logics in the OLTP
database.
Developed database objects such as tables, views, indexes, stored procedures and constraints with T-SQL.
Wrote objects such as stored procedures, functions, DDL/DML triggers, and indexes with SQL/T-SQL.
Evaluated execution plan for T-SQL queries and stored procedures to improve performance based on which created
indexing/partitioning strategy with re-structuring of SQL logics.
Formulated custom T-SQL triggers for improving performance, preserving referential integrity, and adding
functions.
Performed analysis of huge data stores and uncover insights using Snowflake SQL abilities.
Wrote dynamic SQL scripts with table variables & temporary tables to improve the code reuse factor as a part of
application.
Designed complex ETL packages using SSIS to extract data from pre-staging tables to OLAP with incremental load.
Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to facilitate strategic planning.
Produced drill through filter, usage-based matrix, dataset insights and subscriptions in Power BI service.
Implemented actions, measures, calculations, bookmarks, and hierarchies in Power BI data models.
Developed multitude of dashboards with Power BI and depicted differing KPIs for business analysis as per the
business requirements.
Wrote calculated columns, measure queries in Power BI Desktop to show good data analysis techniques.
-----------------------------------------------------------------------------------------------------------------
Rural Postal Carrier/ USPS
07/2013 05/2018
Daisy Mountain Post Office
Anthem, Arizona
Responsible for the safe and efficient delivery and collection of the U.S. Mail
Manage problems, conduct RCA investigations, and deliver completed documentation.
Map appropriate routes using GPS and standard maps.
Complete forms, coding memorization, address memorization.
responsible for memorization, orderliness, and time management
Provide customers with postal information on policies and procedures regarding USPS
responsibilities.
Provide professional interaction and friendly enthusiasm with USPS customers to establish total
customer satisfaction are implemented.
ACADEMIC DETAILS
Bachelor degree in information technology from Kuyera Adventist College (Ethiopia)
Bachelor degree in Mechanical Engineering from Jimma University (Ethiopia)
|
