Data Specialist

• Jun 2023 - Present

Data Analyst

• Mar 2021 - Jun 2023

Created 50+ interactive and highly informative Power BI and Advanced Excel reports and dashboards for Business, enabling faster decision-making and improving efficiency. Developed 100+ database objects, including tables, views, and materialized views using PostgreSQL and MySQL, providing streamlined data management for the organization. Utilized programming languages like Python, Perl and SQL for Data Extraction, Cleaning and Visualization, increasing data accuracy and efficiency in data processing by 40-50%. Responsible for the development, maintenance, and delivery of various critical regulatory reports, ensuring 100% accuracy in report generation and compliance with regulatory requirements. Worked with ETL processes consisting of data transformation, sourcing, mapping, conversion, and loading on databases PostgreSQL, MySQL, Green-plum, and IBM DB2 using tools like DBArtisian, RapidSQl, and UNIX, saving 20-30% of time and resources. Worked with clients directly to handle requests regarding scripting and ETL, resulting in 90% customer satisfaction rate and the delivery of tailored solutions that met their specific needs. Worked in Agile methodology and delivery management, resulting in 30-40% faster project delivery and improved team collaboration. Automated internal daily, weekly, monthly processes which resulted in saving 60-70% time of manual work in the process, freeing up resources for more important tasks. Automated Excel, CSV, and xml report using Python, Shell, and Perl scripts which reduced 100% manual efforts and improved data accuracy. Worked with JIRA, Jenkins, and AutoSDLC as a project management tool to streamline workflows, enabling 20-30% faster project completion and improved efficiency in task management. Performed operations on database management systems, data wrangling, data modeling, data warehousing, data visualization, business intelligence database like PostgreSQL, MySQL, and DB2, providing comprehensive data management solutions. Show less

Design Engineer

• Apr 2019 - Oct 2019

Worked as Design Engineer in team using software such as CATIA V5 and Solidwork.Carried out manufacturing process and accounting of the vehicle. Secured AIR 29 in 10th edition of EFFI-CYCLE 2019,organised at LPU, Punjab. Worked as Design Engineer in team using software such as CATIA V5 and Solidwork.Carried out manufacturing process and accounting of the vehicle. Secured AIR 29 in 10th edition of EFFI-CYCLE 2019,organised at LPU, Punjab.