Business Data Analyst
Current• Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers• Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification• Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources• Setup jobs from SSIS Packages• Used Imp/Exp. Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources• Maintain, review and constantly improve existing reporting sets and dashboards (using Microsoft Power BI and SSIS)• Combine data from multiple data sets to provide a comprehensive picture and analysis of client usage and trends• Develop clear, accurate and timely reporting solutions for both internal and external customers• Used python pandas to automate monthly and year end reports processing.