Banner Image

All Services

Programming & Development

SQL BI/Power BI Developer

$8/hr Starting at $25

A results driven software professional with 8+ years of progressively responsible experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2016/2012/2008R2 /2008/2005, SSIS, SSRS and SSAS. Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation. Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies. Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools. Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation. Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, Physical, logical database design and Performance tuning. Expertise in Power BI, Power BI Pro, power BI desktop.

About

$8/hr Ongoing

Download Resume

A results driven software professional with 8+ years of progressively responsible experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2016/2012/2008R2 /2008/2005, SSIS, SSRS and SSAS. Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation. Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies. Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools. Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation. Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, Physical, logical database design and Performance tuning. Expertise in Power BI, Power BI Pro, power BI desktop.

Skills & Expertise

ASP.NETC# ProgrammingMicrosoft Dynamics 365Power BISQLSql Server 2012SsasSsisSSRS

0 Reviews

This Freelancer has not received any feedback.