Project Controls Data Analyst

• Mar 2022 - Present

Data Analyst

• Sep 2021 - Feb 2022

• Design, deploy, and maintain a variety of Power BI dashboards as a part of Global Service Analytics team for different stakeholders. • Collaborated cross-functionally across multiple departments to fulfill internal ad-hoc reports and analysis requests. • Automate process for the reports - which are required to run on a monthly and weekly basis using Python script. • Developed ETL pipelines from transactional database to data warehouse using Informatica PowerCenter for Data Support. • Modify datasets using DAX query, Merge statements, Refresh Schedule, Row level security and Modelling within Power BI. • Create advanced SQL Queries, Views, Indexes using MySQL to pull specified data for analysis and report building. • Utilized API to get Customer feedback functional data to perform Sentiment analysis and topic modelling categorizing top- performing regions and clients that need attention using NLP. • Provided technical and Data Support to offshore Marketing and Finance and Operations Team using SQL and Python.

Data Analyst

• Jan 2017 - Jul 2019

• Analyze and translate data and research findings into business opportunities by requirement gathering at the level of detail required to solve specific problems. • Develop various statistical and analytical dashboards which focus on major business KPIs and help to establish insights and forecast trends of data over a time. • Work cross-functionally with engineering, product, marketing, business intelligence, customer support, senior management, and external stakeholders. • Extract and manipulate data from data warehouse and relational database and build data ETL process. • Unleash data trends and provide useful insights to the business users by developing various statistical reports and dynamic dashboards using Business Intelligence tools like Tableau Desktop. • Performed exploratory data analysis in Python to identify processes that need improvement for Product Cost Improvement. • Designed and developed weekly, monthly reports by using Tableau and Worked on CRM for handling the customer claim inquiries, Validation and Case Creation. • Develop advanced SQL queries for SQL Server leveraging Common Table Expressions (CTE), sub-queries, correlated subqueries, window functions and complex join logic to apply business rules.