Amrutha

Detail-oriented Sr. Data Analyst with 7 years of experience in Collecting data, transforming data, data modeling, and advanced analytics into actionable insights.

Strong Data

Warehousing, Data Marts, Data Analysis, Data Organization, Metadata and Data Modeling experience on RDBMS databases. Extensive knowledge in Designing, Developing and implementation of the Data marts, Data Structures using Stored Procedures, Functions, Data warehouse tables, views, Materialized Views, Indexes at Database level using PL/SQL and Oracle. Skilled in SQL and Tableau with a proven ability to collaborate with cross-functional teams to drive business decisions.

Strong background in SQL, Snowflake, Power BI, Tableau, Python, and ETL development, with proven experience building dashboards, optimizing queries, automating recurring reports, and developing scalable data models. Strong expertise in DAX, Power Query, SQL and data warehousing with a track record of improving reporting efficiency and supporting data-driven decision making. Expertise in data visualization and reporting using Power BI, Tableau, and Advanced Excel to deliver interactive dashboards and KPI tracking tools.

Strong background in Databricks, Delta Lake, Kafka, Airflow, and Snowflake with solid expertise in data modeling, streaming architectures, and warehouse optimization. Skilled in building and optimizing ETL pipelines using tools such as Apache Airflow, dbt, Talend, and Informatica, improving data ingestion and workflow efficiency. Maintain ethical standards with data by ensuring database integrity as well as compliance with legislative, regulatory and accrediting requirements.

Proficient in SQL-based data analysis, data validation, reconciliation, and building regulatory and management reports. Hands-on experience with large-scale data processing using PostgreSQL, SQL Server, My-SQL and Google BigQuery. Team Player as well as able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies.

Excellent

Communication and presentation skills along with good experience in communicating and working with various stake holders.

Sr. Data Analyst - Key Bank - Cleveland, OH

(2025-04)

• Designed and implemented complex ETL processes using Informatica to integrate data from various source systems into a centralized data warehouse.
• Designed and implemented detailed data models in Erwin to support policy administration, claims processing, and customer relationship management systems.
• Created interactive dashboards and reports using Power BI to visualize key performance indicators (KPIs) related to policy sales, renewals, and claims trends.
• Developed and maintained automation tools and workflows to optimize business processes, leveraging Power Automate and SQL queries to analyze data and extract actionable insights.
• Developed dashboards in Tableau and Power BI, visualizing key performance indicators to enhance decision-making and improve data management practices.
• Worked with Data Management team to analyze sales Data using tools like SQL, Access, Excel (Lookups, Pivot tables) and predicting any future impacts on business.
• Developed and maintained Power BI dashboards in the production analytics environment to track campaign, customer, and operational KPIs, enabling consistent performance monitoring and stakeholder reporting.
• Leads enterprise AI, data, and analytics architecture, delivering scalable, secure, and governed cloud data platforms aligned with business strategy.
• Establish reference architectures, design patterns, and standards for scalable, cloud-native and Snowflake-centric solutions.
• Lead data governance initiatives, including data quality, metadata, lineage, access control, and regulatory compliance.
• Established data governance with curated Snowflake layers, IMDM integration, and PII-compliant access for AI consumption.
• Executed scheduled data extraction and transformation workflows within the production pipeline using Apache Airflow, ensuring timely and reliable data availability for reporting.
• Designed and deployed a containerized data platform using Airflow and dbt on Google Cloud Platform to automate scalable ETL workflows.
• Implemented partitioning, indexing, and query optimization techniques in Azure Synapse, reducing reporting query runtime.
• Automated daily data refresh processes using Unix Shell Scripts and scheduled jobs in an AirFlow environment.
• Conducted comprehensive data profiling and quality assessments to maintain the accuracy and consistency of financial and policy-related information.
• Optimized existing Teradata queries, reducing report generation time by an average of 30%.
• Participated in Agile sprint planning and daily stand-ups, ensuring timely delivery of data solutions.
• Collating and cleaning structured and unstructured data and organizing data into usable formats in relational databases like Snowflake and SQL Server.
• Provided training and support to end-users on newly developed Power BI dashboards and reports.
• Monitored the performance of ETL jobs and OLAP cubes, proactively resolving issues.
• Collaborated with actuarial and underwriting teams to define data requirements for new product development and risk assessment models.

Data Analyst - NJM Insurance Group - West Trenton, NJ

(2023-02 - 2025-03)

• Designed and implemented ETL solutions using SSIS to integrate transactional data from various banking systems into the enterprise data warehouse.
• Developed conceptual and logical data models for new data marts supporting credit risk and fraud detection.
• Optimized Power BI reports by improving data models, report interactivity, and backend query performance for a more efficient user experience.
• Created interactive dashboards and reports using Tableau to monitor key financial metrics, customer behavior, and operational efficiency.
• Created and maintained Power BI dashboards and advanced Excel reports to support liquidity risk monitoring, KPI tracking, and regulatory reporting.
• Oversee data modeling, ingestion, transformation, and optimization across Snowflake and cloud data ecosystems.
• Performed data analysis and visualization to compare machine learning results with traditional active outperformance metrics.
• Used SSIS for ETL, data migration, and data modeling to support reporting and analytical workflows.
• Developed reports and visualizations in Power BI and QlikView to communicate healthcare performance metrics and trends to stakeholders.
• Extracted and analyzed data from MS SQL Server and DB2 databases using complex SQL queries.
• Developed and maintained reports using Cognos for executive dashboards and detailed financial analysis.
• Implemented data governance policies to ensure data quality and integrity across critical banking applications.
• Automated data validation processes and reconciliation procedures using Unix Shell Scripts.
• Performed extensive data profiling to identify data quality issues and anomalies in customer and transaction data.
• Participated in data migration projects, moving legacy data to Azure Data Lake and SQL Data Warehouse.
• Optimized existing SSIS packages, improving data loading times by 25%.
• Supported data analysts and business users in creating ad-hoc reports and queries.
• Documented ETL processes, data mappings, and data flow diagrams.
• Developed routines in Java for custom data transformations and integrations.
• Conducted performance tuning of MS SQL Server databases for optimal report generation.
• Analyzed large datasets to identify patterns and trends related to customer churn and product uptake.
• Ensured compliance with data privacy regulations (e.g., GDPR, CCPA) within data solutions.
• Mentored junior data analysts on best practices for data extraction and reporting.

Data Analyst - Genesis Health Systems - Davenport, IA

(2019-03 - 2023-01)

• Designed, developed, and maintained complex data integration solutions using Ab Initio to consolidate operational data from various ERP systems.
• Created detailed data models for supply chain, logistics, and inventory management systems.
• Delivered dynamic dashboards in Power BI and Tableau, improving reporting turnaround time and providing actionable insights to stakeholders across sales, operations, and compliance teams for informed decision making.
• Assisted in migrating data warehouses to GCP BigQuery, leveraging its scalable architecture.
• Developed and published interactive dashboards using Tableau to track inventory levels, shipment status, and supplier performance.
• Designed enterprise-level data models using Erwin for portfolio management, risk analytics, and client reporting.
• Generated comprehensive financial reports and analyses using MicroStrategy OLAP Suite for internal and external stakeholders.
• Optimized DataStage jobs for performance and scalability, handling terabytes of data daily.
• Worked extensively with PostgreSQL and Oracle databases to store and retrieve financial instruments and trading data.
• Performed data analysis and data validation using SQL to support trading and reporting initiatives.
• Facilitated cloud-based data migrations to AWS, validating data integrity post migration and supporting scalable analytics for higher user and transaction volumes with minimal operational disruption.
• Assisted with data mapping, ETL documentation, and integration testing activities.
• Utilize My-SQL platform to gather and analyze data, to determine accuracy of data reports and create reports in Power BI and Excel.
• Monitored the performance of production ETL jobs and resolved incidents promptly.
• Participated in Agile methodology, including sprint reviews and retrospectives.
• Conducted weekly review of data ingestion pipelines to ensure accuracy, validity, and format of incoming data to enable accurate downstream analysis.