Location : Jaipur, India
Experience : Year
Rate: $20 / Hourly
Availability : 1 Week
Work From : Any
Category : Information Technology & Services
Single point of accountability to drive end-to-end implementation of BI projects for enterprise clients.
Keep abreast of new BI related technology and trends and assess if new technology is needed.
Working closely with project stakeholders to deliver projects on time, maintaining the highest quality of development.
Evaluate business intelligence technology partners and plan to incorporate them into the consulting practices.
Provide consulting to clients for process improvements to drive efficiency and effectiveness of BI solutions
Assist Data Engineers in designing, developing and implement ETL workflows.
Develop Ad-hoc, Standard Dashboards and other reports using BI tools from a variety of data sources including data marts and relational databases.
Worked on over 8 different projects with varying team sizes, technology and project scopes.
Project Name: Welspun Textiles
Technology: Power BI, SSIS, SQL Server on Azure VM, Azure ADF.
Roles & Responsibilities:
Consulted and deployed BI solution for Welspun which is spanned over 3 countries.
Led team of 8 members and delivered more than 15+ Power BI dashboards to 100+ users.
Designed BI architecture and ETL strategies to create data pipelines from SAP and Online Websites.
Developed SSIS packages and SQL queries to transfer data from SAP to SQL Data Mart.
Developed and deployed 10+ quality Power BI data models using star and snowflake schema.
Configured data gateway to streamline data refresh schedules of Power BI dashboards.
Migrated more than 20 SSIS jobs to Azure Data Factory pipelines.
Administered and optimized development/ production MSSQL environments.
Provided training to 20+ pro users and enabled them for self-service BI.