Data Reporting Analyst
Current● Developed reports in Excel and Access from datasets as per business needs.● Manual review and correction of numerous errors and gaps for client’s dataset using Data Analysis Expressions. ● Wrote complex SQL queries using various joins, unions, and functions for report purposes.● Worked with the Business users to understand what reports were critical, non-critical and not needed. ● Developed interactive Microsoft Power BI dashboards for presentations purpose to drive business goals and profitability.● Manually modified the SQL in Report Studio to tune and/or to write complicated reports.● Spearheaded the Analysis and development of Reports across multiple Sales Transaction Projects for various clients which in turn helped them generate almost over 50% increase in Profit.● Collaborated with Database Admins and Data Engineers to develop Data Collection systems using Microsoft Power Apps and Automating them to Excel, Access and SharePoint using Microsoft Data Connectors.● Pioneered implementation of Databases, Data Collection Systems, Analytics, and other strategies that will optimize statistical efficiency and quality.● Facilitated the Interpretation of Large datasets and analyzing results using statistical techniques to provide reports.● Identifying and Interpreting trends and patterns in complex datasets to make useful recommendations to senior management.● Communicated Daily with the Engineering team, Product Managers and Vendors on ETAs.● Invented Insightful and automated dashboards to track key business metrics.● Implemented Use of complex SQL queries to explore, analyze, and perform various data modelling techniques used for reports which increased Revenue by over 30% in the First three month.● Systematized Performing Trend analysis of Transactions for Decision making.● Collaborating hand in hand with multiple departments to synergize data in a multidisciplinary field.