Data Retrieving Procedure (MSSQL)

od SergioAlfaroV
Data Retrieving Procedure (MSSQL)

T-SQL Stored procedure that processes and retrieves data from an existing table, using SQL Server. Notable features: - Dumps Exec Procedure contents in a table - Use of PIVOT command - Use of CURSOR - Use of RANK function

image of username SergioAlfaroV Flag of Peru Lima, Peru

O mně

15+ years of experience in Data Engineering, BI, SQL, reports/dashboards design and construction, ETL/ELT, Data Warehousing, Data Analytics, database administration/tuning/optimization, and related work. 7+ years of experience working remotely on project all around the world. Native Spanish speaker, and near-native English speaker, located in the American Central Timezone (GMT -05). Ideal for near-shore projects requiring constant communication during office hours. TECH STACK =========== MS SQL SERVER: - Transact-SQL - Administration - Tuning MS SQL SERVER BI ON PREM STACK: - Power BI: DAX, M - Reporting Services - Analysis Services: Tabular (DAX), OLAP(MDX) - Integration Services AZURE CLOUD DATA STACK: - Azure Data Factory - Synapse - Databricks - Data Lake SCRIPTING: - Python - VB.NET - C# - PowerShell OTHERS: - Snowflake - MS Excel: Formulas, VBA (Macros) - QlikView - Tableau - Oracle (PL/SQL) - MySQL - PostgreSQL - UNIX - XML - YML - JSON - Git - SCRUM ** Adjustable rates according to work complexity, urgency, and/or project size. **

$40 USD/hod.

31 recenze
6.1

Zkratky