BI & Data Analyst with over 16 years of experience in analyzing, designing and transforming data. Expert in Microsoft BI tools. A highly motivated team player with strong communication, relationship management and problem-solving skills. Strong collaboration, team building, interpersonal, communication skills with proficiency at grasping new technical concepts quickly & utilizing the same in a productive manner.
Overview
15
15
years of professional experience
3
3
Certifications
Work History
BI & Data Analyst cum Project Accounting Lead
Worley
Al Khobar
11.2014 - Current
Part of the TFT13 implementation project, responsible for developing the new Data Mart
Data mart will act as a centralized repository for the whole of company source systems
My responsibilities include:
Analyzing existing data across multiple different source systems
Designing data model for the new Data Mart
Designing transformation logic to standardize data in Data Mart
Data Mapping between source and target system
Data analysis using Python Pandas module
Data Modelling and writing T-SQL queries and performance tuning of existing SQL
Coding in Microsoft SQL Server database using TOAD tool
Data analysis and data cleansing using Python and data visualization using Power BI.
Technical Leader
Agile Financial Technologies Pvt. Ltd
Mumbai
05.2013 - 11.2014
Part of the team responsible for developing and maintaining Financial Lending software application for Mint Capital LLC in UAE
Lending System consisting of Loan Origination (LOS), Loan Management (LMS), Loan Collection System (LCS) based on 3-Tier Architecture Model of ASP.NET Development of Web based Applications
My responsibilities included:
Understanding functional specification document and provide technical approach to client
Requirements gathering and data analysis
Developing new features to the software application using ASP.Net & SQL
Designing of Database (Tables, Views, Indexes, Triggers, Stored Procedures and Other Database Objects) for many modules
Involve in all phases of software development life cycle: Design, implementation, and testing
Developing reports using SSRS reports.
Project Leader
Osource India Pvt. Ltd
Mumbai
01.2008 - 12.2012
Part of the Forensic team responsible for fraud detection, evidence gathering, analyzing and presenting data for short term projects across the globe
My responsibilities included:
Data Modelling and writing T-SQL queries and performance tuning of existing SQL
Coding in Microsoft SQL Server database using TOAD tool
Data analysis and data cleansing using Python and data visualization using Power BI.
Education
Bachelor of Science - Computer Science
Master of Science - Information Technology
Skills
Microsoft Tools: Office Suite, Power Query, Power Pivotundefined
Accomplishments
Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
Certification
Business Intelligence & Data Analyst (BIDA) - CFI Institute
Additional Information
Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
Handled massive quantities of business intelligence data, personally managing as much as 2 Gigabytes.
Designed customized data collection models for specific visualization tasks.
Developed intelligence-sharing dashboards, providing company-wide access to collected data.
Optimized BI reporting capabilities for secure server environment.
Collected data from wide-ranging sources.
Mapped current business and operational processes and recommended areas for improvement.
Researched and compiled tailored monthly analytics and reports for senior management with MS Power BI.