Giru Adir

About Giru Adir

Over Six years of experience transforming data into actionable insights for a range of industries, including banking, finance, health care, and consulting. Experience creating and managing data models, ETL pipelines, and Power BI reports and dashboards that give timely, accurate, and relevant information to business stakeholders. Extensive experience analyzing large datasets to drive corporate insights and decision-making. Extensive expertise developing and delivering data models, ETL processes, and reporting solutions to help organizations make data-driven decisions. Hard skills :Data Analysis, Data Visualizations, Python, SQL, R(Programing Language), Excel and Power BI, Power Query, Dax and PostgreSQL.

Experience

1. Sr Data Analyst

   First Citizens Bank

   Aug 2021 — Present

   Created Python code to extract data from an external source, read unstructured data, and extract required details using a keyword match to generate CSV output that is uploaded to Azure blob storage for analytics insight.• Reading big Excel files and retrieving relevant data as needed using Panda libraries.• Gathering requirements in a dynamic setting using the Agile Model.• Examining large amounts of banking data, such as client transactions, account balances, loan portfolios, and financial performance.• Extract, clean, and convert data from multiple sources utilizing tools such as Python, SQL, Power BI, and Tableau to support business decisions.• Collect stakeholder requirements and transform them into technical specifications.• Take part in agile development methods such as sprint planning, stand-up meetings, and retrospectives.• Work with team members and other stakeholders to guarantee the quality and consistency of data.• Responsible for writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and create clustered and non-clustered indexes.Skills: SQL · Python, Product Development · Product Management · Agile Testing · Data Warehousing · Statistical Data Analysis · Analytical Skills · Big Data Analytics · Data Science · Extract, Transform, Load (ETL) · Data Visualization

Education

• VIJAY Computer Academy

  Certificate

• Amazon Web Services (AWS)

  Cloud Acquisition

• Coursera

  Google Data Analytics Professional Certificate

• -

  Bachelor's degree