Giru Adir

Experience

• 

  CHRISTUS Health

  Feb 2018 - Mar 2019

  SQL Developer

  • Analyze design documents and requirements to understand the functionality of both source and target • systems, and design optimized SQL queries to retrieve data.• Develop and optimize T-SQL stored procedures, functions, triggers, and views for efficient data extraction, transformation, and loading processes.• Identify and troubleshoot SQL Server performance issues by optimizing queries, indexing, and database configuration.• Create and manage SQL Server Agent jobs to automate tasks such as backup, restore, data transfer, and data import/export.• Write complex SQL queries to extract data from diverse sources, including flat files, Excel spreadsheets, and Oracle databases.• Develop and manage SSIS packages for data integration and transformation.• Provide technical support to end-users, troubleshoot issues related to SQL Server, SSIS, and SSRS.SkillsOracle Database, T-SQL, MS Access, SQL Server Management Studio, SQL Server 2008/2012, SSASMicrosoft SQL Server 2008/2014, visual studio, SSRS Show less

• 

  Labcorp

  May 2019 - Jul 2021

  Data Analyst / Power BI Developer

  • Design, develop, and maintain Power BI reports and dashboards to track business performance metrics.• Participate in Agile Scrum ceremonies to facilitate collaboration and teamwork among cross-functional teams.• Create ad-hoc reports to evaluate specific business requirements and perform data analysis.• Develop data models in Power BI based on business requirements and integrate them with Python scripts for advanced analytics.• Develop mobile-optimized Power BI customized reports, dashboards, and interactive reporting tools to support data-driven decision making.• Develop and maintain data pipelines to extract, transform, and load data using Python scripts and Power Query.Skills: Data Modeling · Data Visualization · Azure Data Factory · Extract, Transform, Load (ETL) · DAX · Data Warehousing · SQL · Microsoft Power BI · Python Show less

• 

  First Citizens Bank

  Aug 2021 - now

  Sr. Data Analyst

  • 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 Show less