Data Analyst

Bessy Tabe

Phone: 763-***-****

*********@*****.***

SUMMARY

Almost five years of experience in database design, development, and implementation of business intelligence solutions. Having expertise in writing T-SQL Queries, sub-queries, Views, Functions, and Stored Procedures. Adept in using SSIS to create ETL Packages for data extraction, data integration, data transformation, data validation from heterogeneous sources and loading into database tables. Efficient in designing developing and deploying SSRS reports, Power BI dashboards, Data Visualizations in Tableau.

TECHNICAL / FUNCTIONAL SKILLS

Efficient in MS BI and SQL Server 2012/2014/2016 suite including SSIS, SSRS and SSAS.

Working knowledge on T-SQL queries (DDL and DML) for developing complex stored procedures, triggers, tables, views, relational database models.

Capabilities in working on OLAP environment and OLTP platforms.

Advanced SSRS development, validation and deployment capabilities using Report Builder 3.0.

Adept in performing data cleansing, data scrubbing, and data migration related tasks using SSIS.

Efficiencies in developing SQL Server SSIS packages for importing, transforming, and loading data from diverse heterogeneous sources into intended destination tables.

Working knowledge on cube partition creation, attribute hierarchy creation, within SSAS cubes dimensions and then processing and deploying the SSAS objects.

Experience in gathering business requirements and converting them into technical requirements.

Develops and maintains SSRS reports including interactive drill down and parameterized reports.

Effective on report authoring, report management and report delivery using SSRS.

Excellent communication skills, organizing skills, highly punctual and an excellent listener.

PROFESSIONAL EXPERIENCE

Data Analyst / SQL Developer

BIANALYTIXS, New Brighton, MN (02/2018 – Present)

Creates and optimizes database objects such as views, functions, and stored procedures.

Develops SQL scripts to insert, update and delete data in MS SQL Server OLTP database tables.

Creates different SSRS reports based on requirements provided by these various business units.

Create standardized SSRS portrait and landscape report templates used in report development.

Develops and maintains SSRS reports including interactive drill down and parameterized reports.

Designs and creates ETL Packages in SSIS to extract, transform, validate and loading data.

Optimizes TSQL query performance by modifying dataset extract queries, removing unnecessary columns, and eliminates redundant and inconsistent data.

Transfer data from MS Excel, MS Access, flat files to SQL Server using SSIS.

Create and deploys SSIS packages and scheduled the jobs to run automatically.

Create dashboard visualization using Tableau.

Environment: SQL Server 2012/2014/2016, SSIS, T-SQL, SSMS, SQL Server Data Tools, Excel 2013/2016, SharePoint, Visual Studio 2013/2015, Tableau, Microsoft Teams.

Junior ETL Developer

MATRIX AGGREGATIONS, Fridley, MN (03/2016 – 02/2018)

Extensively used T-SQL to manipulate, query and extract data per user requirements.

Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.

Developed SQL Queries used in fetching complex data from different database tables using joins and using output in SSRS Created Tabular report dataset.

Used Excel, in data pre-processing and cleansing prior to meet user requirements.

Used SSIS in creating ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases.

Assisted in designing and deploying SSIS packages for data transformation and loading.

Created SSIS packages to retrieve data from Flat files, CSVs, and Legacy sources daily basis.

Created dashboards and reports using Power BI Desktop.

Environment: SQL Server Management Studio, SQL Server Profiler, Advanced Excel, Import & Export Wizard, MS Visual Studio, Power BI, SQL Server Data Tools, MS Visio.

EDUCATION

Colorado Technical University

Master’s degree in computer sciences – Data Science

Bachelor’s Degree in Arts.

Contact this candidate