Data analyst with experience using SQL Server, SSIS, SSRS and Power BI for data visualization. In Power BI, experienced creating attractive reports for desktop and mobile viewing according to business requirements and publishing reports to testing and production environments. Proficient in creating DAX queries to perform complex calculations, create measures and calculated columns. In SQL, experienced creating, maintaining, and troubleshooting existing tables and views, stored procedures, functions, and triggers. Also experienced optimizing queries and stored procedures, performing table joins, and using variables, and temp tables. In SSIS, experienced loading data from various sources and creating a staging environment to clean, validate, and perform error handling on data. Experienced in automating packages to run on schedule through SQL Server Agent and troubleshooting control flow and data flow. In SSRS, experienced creating attractive parameterized reports and Sub Reports according to business requirements and deploying to Report Server.
Power BI Developer
Colaberry Consultant Firm
July 2020 - Present
Handling Power BI development and administration roles.
Developing custom visual reports, dashboards and KPI scorecards using Power BI desktop.
Connecting to data sources (Sql Datawarehouse, flat file, CSV, Excel), importing data for business intelligence.
Excellent in analytical thinking for translating data into informative visuals and reports.
Creating queries using DAX functions in power BI Desktop.
Good understanding of writing SQL queries and pulling data from sql server.
Analyzing and modifying existing SSRS reports and SSRS packages, inserting and update records into SQL server table.
Designing methodology and project documentation.
Able to understand the business requirements and develop data models accordingly by taking care of the resources.
Working directly with business users providing design and support for key business reporting.
Developing strategy for report implementation, data acquisition and archive recovery.
Collaborating with application developers, business owners and operations to ensure the creation of production business intelligence and implementations.