Data Analyst

• Nov 2022 - Present

Data Support Engineer

• May 2022 - Oct 2022

IT Specialist- Reporting

• Apr 2021 - May 2022

SQL, SSIS, SSRS, Tableau, Big data Hadoop SQL, SSIS, SSRS, Tableau, Big data Hadoop

Data Migration Analyst

• Jan 2020 - Feb 2021

Business Intelligence Developer ( Data Analyst )

• Apr 2019 - Jan 2020

I was working on a Cloud based project, specifically targeting the Data Integration, Data Analysis & Data Visualization. I was also responsible for designing the Data Warehouse. My responsibilities are as follows: • Integration of various data sources and performing Data standardisation and ETL process. • Database design and development using Microsoft SQL Server and Microsoft BI Stack. • Development of Customer reports & Dashboards using SSRS and Power BI. • Implementing various DAX functions and Power Query features. • Client interactions and demonstrating of Dashboards and adhoc reports. • Mentoring Junior BI Developers and assisting them in completing their Tasks as per the schedule. • Aid other team members and peer review co-workers’ reports. • Created Data Warehouse using Kimball Methodology

Power BI Developer

• Jun 2018 - Dec 2018

• Involved in data gathering. • Developed Power BI reports and dashboard from multiple data sources. • Wrote SQL queries and stored procedures to validate data such as duplicates and nulls. • Created Power BI gateway. • Worked on Power BI services for publishing the data. • Explored data in verity of visualization in Power BI reports and dashboard. • Designed Power BI data visualization utilised Drill through, Pie, Bar and Maps. • Worked on agile environment.

Intern

• Oct 2017 - Jan 2018

Computer Science Tutor

• Aug 2016 - Dec 2016

Data Analyst

• Feb 2013 - Mar 2015

Specialties: Business Intelligence Architecture/Development •Technologies used – SQL Server, SQL Server Reporting Services(SSRS),SSIS,SSAS Crystal Reports • Developed standard and customized reports using SSRS for data feed and for Reports on the server. • Integration of raw data collected in Excel sheets from stakeholders into company databases. • Design of the Data Warehouse for application. • Designing of SQL queries, stored procedures and functions to implement medium-to-complex business logic for reporting and analysis purposes. • Performance optimization and tuning of the database objects like procedures, views and functions. • Provided support by troubleshooting and solving the issues. • Created the technical requirement Documentation for Row-level Security and Role Based Security ETL’s.

Software Developer

• Jun 2008 - Jun 2010

My responsibilities are • Designing and development of windows applications using Microsoft technologies. • Involve in complete SDLC including transforming business requirements into software design, implementation, enhancement and support. • Designed Web services using Rest API & SOAP. • Working with onsite business analysts on client requirement details. • Responsible for the deployment of projects to staging and UAT environments. • Unit testing, Integration testing and System testing • Communicating with the customers/clients and solve the issues