BI Specialist & Data Analyst
Royal Group
مجموع سنوات الخبرة :12 years, 6 أشهر
• Provided effective and powerful BI solutions to group companies by designing fully functional
BI & ML server includes Enterprise Data Lake on MySQL, ETL pipelines on Talend and reporting
on PowerBI.
• Trained three team members during the period of above setup to ensure continuous support
to the end customers.
• Ensured the quality of analysis and data accuracy and demonstrated results to users with
the help of customised charts in PowerBI. Functioned as the liaison between the business and
technology to ensure operational success.
• Delivered Data Analysis projects using advanced features on Informatica PowerCenter ETL
pipelines, Tableau and PowerBI at Business Planning and Analytics team and Analytics Centre
of Excellence.
• Achieved 8% improvement in operational excellency during the COVID time with personalised
automated dashboards.
• Built and deployed Automated data quality utility which improved MIS team’s efficiency by
reducing 1 hour overhead daily.
• In this position I managed Supply Chain Management division’s data warehouse. Analysed
Inventory control processes such as stock replenishments and adjustments to accommodate
their purchase patterns.
• Implemented alternate approach on tool’s most complex scenario (notification of long
running ETLs) and ensured timely completion of the daily change data capture into data
warehouse.
• Designed and implemented high preforming 200+ workflows in informatica which produces
data for oracle lease and finance management at CISCO.
• Tuned low performing SQL Queries by creating necessary indexes on columns which reduced
ETL execution time by 70%.
Acquired immense knowledge on Core Technical skills at this university with 78% of passing percentage considered as distinction with 8 CGPA Grade.