SQL BI DEVELOPER

Gather requirements from business stakeholders and translate them into technical specifications. Prepare a solution and design review session with all the stakeholder explaining the details on how the changes will be done and explain the affected End user due to the change. Develop Dashboards with rich visualizations using Tableau/Microsoft Power BI tool with wide variety of controls and converting big raw data into business useful insightsmetrics. Provide road map and leveraging cloud platforms for Advanced Analytics (BigData, Machine Learning, Azure data lake store, GCP, PySpark etc). Implement Azure data factories and child resources including datasets, linked services, triggers, and integration runtimes. Handle bigdata processing through Python (PySpark), Spark SQL and DataFrames. Manage Snowflake, Azure Data Factory and Data Lake Analytics to integrate with other on-premises and Azure Services. Design and develop ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations. Design and optimization, health check, audits, compliance, security, configurations, maintenance, optimization, performance tuning, scalability, integrations, backups/restore. Implement SSAS Multidimensional/Tabular Cubes as the reporting layer and Use both MDX/DAX scripting to access data from Multidimensional/Tabular Models. Responsible for building the continuous integration process using Hudson Jenkins and reporting the failures. Develop test cases and implement Referential Integrity rules and regulations through constraints, triggers, views and partitioned views. Develop and maintain the ADF, DTSX data pipelines for end to end reporting. Write custom scripts using PowerShell and C# to extract data from Third Party REST APIs, Websites, Device Compliance and Usage Data and Active Directory. Provide 24x7 on-call Support for critical production Databases. Provide analytical support including analysis and graphical representation of data, assisting with MBR and QBR reporting for executives with strong analytics and comments. Work on R application showcasing machine learning for improving the forecast of business and strong experience in RStudio. Using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance. Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard and SQL Sentry plan explorer. Use GIT STASH/TFS as version control tools. Review and update the servers using version control tool to maintain all versions of the codes in-order to maintain history, analyze whenever needed and revert or deploy a specific version whenever required. Knowledge acquired through academic coursework in data mining, analyzing and visualizing data, cloud computing, application security, and blockchain. Master's degree in Computer Science, Information Technology, or a related field is required. Work location: Irving, TX. Send Resume to HR Dept., PhiDimensions, Inc., 1303 W Walnut Hill Lane, Suite 103, Irving, TX 75038.