Nagaharsha H A
Verified Expert in Engineering
Data Analyst and BI Developer
Nagaharsha is a highly analytical BI and data analyst with nine years of industry experience organizing, interpreting, and disseminating statistical figures. He is an expert at providing realistic projections and establishing scenarios to determine viable process strategies. Nagaharsha uses strategic insights, analytics, and business intelligence to advance opportunity identification, process re-engineering, and organization growth with clients.
Portfolio
Experience
Availability
Preferred Environment
Azure, Data Reporting, Microsoft Power BI, T-SQL (Transact-SQL), Static Analysis, SQL Server Integration Services (SSIS), Data Analysis, ETL, Database Design, Data Warehouse Design
The most amazing...
...warehouse I built integrates data from 200+ source systems and day-to-day analytical reporting.
Work Experience
Manager BI and Data
DAMAC Properties
- Led, created, and maintained data-driven insights that helped different businesses within DAMAC to make better decisions.
- Performed BI solution strategy development aligned with business goals and objectives in conjunction with data and digital leadership teams. Advanced strategies for gathering, reviewing, and analyzing data requirements.
- Designing and building data architectures, including the design and set up of scalable data lakes and scheduled transformations.
- Projected and programmed estimation, proposal preparation, requirements gathering, business modeling, development and testing, and deployment.
- Collaborated with businesses to perform business analysis, investigate problems, and create plans as needed. Managed, led, and supported the team. Managed outsourced partner solutions around build and delivery, where applicable.
BI and Analytics Lead
Maritime and mercantile International
- Leading the analytics agenda across two organizations and more than five countries to drive, accelerate and scale analytical maturity across data, business intelligence, and decision support.
- Key roles and responsibilities include setting, communicating, and cascading data, BI, and analytics vision and strategy. Own analytics maturity assessment to objectively understand the current state and drive change.
- Streamline collaboration through organizational structure and governance. Drive capability building and change management through workshops. Set a course for Azure migration, and cloud-based strategy to govern budget utilization.
BI and Data Analyst
Majid Al Futtaim
- Built a data warehouse that integrates data from 200+ source systems and day-to-day analytical reporting.
- Created statistical models to facilitate the requirements in the areas of acquisitions, retention, recommendation, cross-sell, and delivery in the form of Power BI reporting.
- Designed and developed data quality metrics in Power BI to interpret and measure the data by correlating business issues with the defined metrics, understanding these metrics, and proposing improvements in data captures.
- Completed analytical reporting in Power BI, such as customer affinity, segmenting customers based on RFM, ROPO analysis on brick-and-mortar stores, incentivizing store staff based on their performance, and identifying website behavior patterns.
- Delivered CDC-enabled near-real-time reporting in Power BI and Microsoft Steam Analytics to show real-time business performance.
- Owned the delivery of insights and business intelligence solutions across different operating companies.
BI and Data Engineer
Wipro Technologies
- Created and deployed SSIS packages for transferring data from flat files, Excel spreadsheets, and heterogeneous data to and from the SQL Server.
- Developed matrix reports, drill down, drill through, sub reports, chart reports, and multi-parameterized reports using SSRS.
- Identified performance gaps in SQL Server and created required indexes such as ColumnStore or row and increase the performance.
- Led a team of five supporting technical challenges and assigning tasks on each sprint.
- Maintained the DWH system, performed an RCA, and ensured the SLA was not breached.
Experience
Power BI - Statistical Analysis
https://bit.ly/2NeH3fLRFM Segmentation: Do all customers in an organization need to be treated similarly? The answer is no. RFM segmentation helps segment customers based on how recent they are, how frequent, and how much he/she has spent. Segmentation is done based on these values and helps businesses retain their best customers, bring back customers, and cross-sell.
Recommendation: Do businesses need to promote new products? If so, using the product clustering approach based on product characteristics helps to identify the right target of customers and make a personalized recommendation based on his/her interest.
Data Quality: Sometimes, it's critical for businesses to understand how customer data is captured for analytical use cases. Data quality metrics help shed light on the quality of data and plan the next steps.
Power BI - Operational Reports
https://bit.ly/2NeH3fLAn HR-driven initiative for incentive report/dashboard were created for store staff to motivate them and achieve even more.
The marketing team could do ad-hoc composition in the reports, enabling them to customize their approach to each customer.
The compliance team was always informed through Power BI reports, which allowed them to monitor the daily routine that a store manager has to meet.
Product-level performance reports (Power BI/report connected to Excel) were available for sales/stock mix and helped inform their buying decisions.
With the latest Power BI features, the leadership team was provided with mobile reports/dashboards with near real-time operational reporting to assist them in making key decisions.
Data Warehouse Design
I was also involved in building a massive financial consolidation DWH and customized the reporting based on finance. Due to heavy gigabytes of data, I chose the best infrastructure and implemented the specific indexes (such as Columnar) to improve performance.
A customer-centric DWH was built to provide a 360 analysis for the customer. This DWH had the ability to analyze POS-related metrics as well as consolidated levels (MDM match and merge process). I was the key decision-maker on data modeling and architecture for the project.
Skills
Languages
T-SQL (Transact-SQL), SQL, Python 3
Tools
Microsoft Power BI, Microsoft Power Apps, Google Analytics, Microsoft Excel
Paradigms
ETL, Database Design, Business Intelligence (BI), Agile, Scrum
Platforms
Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), Azure, Azure Synapse
Storage
SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Database Modeling, Database Management Systems (DBMS), Microsoft SQL Server, Databases
Other
MSBI, Statistical Analysis, Dashboard Design, Data Modeling, Data Analysis, Data Warehouse Design, Data Warehousing, Data Architecture, DAX, Google BigQuery, Azure Data Factory, Azure Stream Analytics, Data, Integration, Strategy, Data Visualization, Excel 365, Google Data Studio, Data Analytics, Sales
Libraries/APIs
Azure Cognitive Services
Education
Postgraduate Diploma in Data Science
International Institute of Information Technology Bangalore - India
Master's Degree in Computer Science
Birla Institute of Technology and Science, Pilani - India
Certifications
Microsoft Certified Data Analyst Associate
Microsoft
Microsoft Certified Solutions Associate
Microsoft
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring