Business Intelligence Manager

• Aug 2020 - Present

Business Analyst

• Aug 2017 - Jul 2020

• Worked with business users to understand and define data visualization needs and reporting requirements• Analyzed current processes in conjunction with departmental heads and other IT team members to turn data into critical information that can be used to make sound business decisions• Created and published dashboards in Tableau to show variations in different KPI over time for various departments• Created data quality rules and audit reports in SQL for performing quality checks in Salesforce and SQL Server• Automated client/internal reports using SSRS by extensively using Views, Stored Procedures to build optimized reports• Managed Tableau Online as the Tableau Administrator by maintaining security access, uploading Tableau Dashboards and scheduling refreshes through Tableau Bridge• Designed and created different ETL packages to migrate data from various sources to SQL Server using SSIS• Improved business processes by automating the current practices and streamlining the workflow• Automated ad-hoc queries in SQL using Python for frequently requested reports increasing the efficiency of report generation by 30%

Data Analyst

• May 2016 - Dec 2016

• Worked with cross functional teams for extracting large data from different data sources into SAS environment and performed data manipulations using SAS, SQL in Agile environment• Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using SAS• Performed quality assurance to ensure data integrity and compliance with the business requirements• Used SAS program for generating summary and customized reports• Reconciled monthly data from reports with source data by querying the database• Built Tableau dashboards to summarize KPI for stakeholders to take data driven strategic decisions

Business Intelligence Analyst

• Aug 2013 - Dec 2015

• Automated the business process using excel macros which generated a savings of million dollars for the client resulting in 40% reduction in time• Analyzed historical data using SAS to identify anomalies in order to design accurate test scenarios• Collaborated with cross functional teams/stakeholders to perform root cause analysis of defects, to ensure test data quality and to identify gaps in functional requirements• Involved in gathering business requirements, translated business requirements into technical requirements documents and received sign-off from the business• Ad-hoc and regular scheduled data reports and visualizations were generated using Tableau/Pivot table to the senior management