JUNIOUR MSBI DEVELOPER Resume

SUMMARY:

Motivated, teamwork - oriented and responsible MSBI Developer with four years of experience in ETL, Data Modeling and strengths using T-SQL. Committed to personal and professional excellence with a bachelorette in International Business. Looking to leverage proven technical and creative thinking skills in an innovative company.

TECHNICAL (IT) SKILLS:

Languages:

Proficient in: T-SQL (Transact SQL), PL/SQL, My/SQL

Knowledgeable in: Microsoft Visual Basic®, Tableau, Power BI

Software:

Database tools: SQL Profiler, Database Engine Tuning Advisor, SSMS, SQL Agents, MS SQL Server® 2005/2008/2008 R2/2012/2014, Oracle Data molder®

ETL Tools: DTS, SSIS and Informatica.

Reporting Tools: SSRS, Report Builder 2.0/3.0, Tableau, and Power BI.

Data Mining Tools: SSAS

Operating Systems: Windows 2000/XP/7/8/10

EXPERIENCE:

Confidential

JUNIOUR MSBI DEVELOPER

Responsibilities:

Designing conceptual, Logical, and Physical Data Modeling for a successful library system.
Developing complex but efficient packages to extract, transform and load data from diverse data sources such as CSV, Excel, and Text file.
Performing data conversions from various files into a normalized database structure
Migrating ETL objects from development to production and maintaining the ETL environments.
Effectively generating package configurations for SSIS packages from one environment to another Implementing Error Handlings, Event Handlers, and loggings.
Utilizing SSIS with proper Control Flow and Data Flow tasks elements to develop and deploy an ETL process.
Successfully building ETL packages through SCD to create Type 1 and Type 2 attributes.
Writing, modifying and maintaining complex T-SQL queries using Functions, DDL, DML, Views, Indexes, Triggers, and Stored procedures for faster execution.
Creating and sustaining DTS packages from migrating data and Scheduling Jobs.
Effectually used SSRS configuration manager to design and deploy reports in MS SQL Server environment.
Efficiently modeled dimension and fact table using star schema.
Developing Tableau, and Power BI graphical and visualization solutions with business requirements for creating dashboards.
Solid understanding in MS SQL analysis Service SSAS, Dimensional Modeling, Data Warehousing, and SSAS performance tuning

Environment: MSSQL, SQL Server 2014, Visual Studio 2015, Oracle Data Modeler, SharePoint 2007, Oracle, ADO.NET, Visual Studio Debugger, etc.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship