Tsiyon Mazengia

Contact

240-***-****

ady0uz@r.postjobfree.com

Professional Experience

• 5 years of extensive experience and hands-on working knowledge in various domains of the IT industry as SQL/MSBI/Power BI Developer.

• Hands-on experience in different versions of MS SQL Server with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.

• Application knowledge in software development life cycle (SDLC), Agile and Scrum.

• Explored data in a variety of ways and across multiple visualizations using Power BI Desktop and Service.

• Experienced in creating multiple kinds of reports in Power BI and presenting them using Story Points.

• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX).

• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular models.

• In-depth understanding of client requirement Analysis, Logical design, development, Testing, deployment, Support, and Maintenance of business applications using SQL Server, SSIS, SSAS, and SSRS.

• Hands-on experience with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, user-defined functions, views, indexes, user profiles, and relational database models.

• Developing SSIS packages for data migration between different sources such as flat file, excel, MS accessing SQL Server SSIS.

• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.

• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV,Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union.

• Develop Analytic model & data visualization that delivers unique analyst productivity using Power BI.

• Strong analytical skills, the ability to define problems effectively and clearly.

Education

Bachelor’s Degree in computer

science

Key Skills

SQL

SSIS

Power BI

SSRS

SSAS

Experience

Jan 2021- present

BI Developer

Ford Motors

• Involved in Technical Specification Documentation.

• Involved in development of SQL, SSIS packages development and unit testing.

• Involved in Deployment of SSIS packages with VSO.

• Responsible for Motoring Monthly, weekly, daily scheduled jobs and checking status mails, taking course of action, if required.

• Backtracking failures and providing a fix to move the ETL.

• Helping job owner teams backtrack failures and resolving.

• Taking care of bugs in VSO with a max of two hours.

• Implemented custom logging in ETLs using SSIS 2015.

• Created highly complex SSIS packages using various Data transformations like conditional splitting, for each Loop, Multi Cast, data type conversion, Script Components, Error handling.

• Wrote and integrated stored procedures to generate the special reports per client’s need.

• Taking care of cube failures and processing manually post ETL if necessary, by generating XMLA or table wise.

• Backtracking issues and managing power bi reports as per users ask through ICM.

• Developed power BI reports, workspace, and apps. Setup scheduled refreshes using power BI gateway.

April 2018 – Dec 2020

BI Developer

Overhill Farms

• Working on multiple projects, Migration, and replication data from SSAS on Prem to Power BI Live, upgrading from SQL server 2016 to 2019 including SSIS packages and SSRS reports and paginated reports.

• Formulating and documenting ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations. Extract, transform and load the data from source into staging (SQL Server) and populate to data warehouse.

• Created Parameterized packages to create table mirroring from Prod to Dev.

• Creating sessions, batches for incremental load into staging tables and scheduled them to run daily.

• Troubleshooting technical issues in a variety of application environments, including researching issues related to system configuration, software and database systems, and data integrity.

• Creating SSIS packages to populate data from various data sources. Creating packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.

• Creating SSRS reports, Data sources in Reports and making changes in the Report Builder.

• Created and maintained and published several Power BI reports and dashboards following business rules.

• Created Workspaces and Apps in power BI service.

• Creating Paginated reports, Data source in Reports using Power BI report builder.

• Constructed a URL to change drill through Report from report to report to URL to publish in power BI service.

• Designing, developing, and maintaining daily, weekly, monthly, and year-end summary, trending, and benchmark reports repository.

• Migrating SSIS Packages from SQL Server 2016 to SQL Server 2017.Creating and maintaining various database objects like Stored Procedures, Views, Index, functions and triggers and constraints.

• Executing T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.

• Creating Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: MS-SQL Server 2016/2012/2008R2 Enterprise Manager, MS Business intelligence (BIDS) [SSIS,SSRS, SSAS], SharePoint Server 2010, MS Office 2013, MS Visio 2010, Visual Studio 2013/2010, Windows Server 2012, JIRA.

Contact this candidate