Data Analyst - SQL, Python, Tableau, Power BI

Amarasai Kotta

Email: ***********@*****.***

Mobile: +1-978-***-****

LinkedIn: www.linkedin.com/in/amarasai-kotta/

Business Analyst

PROFESSIONAL SUMMARY

Data Analyst with 5+ years of experience specializing in SQL, Python, Tableau, Power BI dashboards, data quality, stakeholder reporting, and actionable business insights delivery.

Analyzes complex datasets across healthcare, finance, operations, supply-chain domains, translating business requirements into validated metrics, executive reports, governed dashboards, plus decision insights for leaders.

Designs scalable ETL workflows, dimensional models, reconciliations, improving data accuracy while strengthening analytics delivery through Agile documentation plus cross-functional collaboration across enterprise stakeholders consistently.

Optimizes SQL queries, Power BI reporting, Tableau visualizations, plus automated validation routines to reduce manual effort, accelerate analysis, support compliance controls enterprise audits reliably.

Demonstrated minimal supervision by independently managing a high-stakes project, resulting in a 20 percent increase in efficiency and fostering a culture of accountability among team members.

Delivered executive-ready presentations to senior management, effectively communicating strategic goals and aligning team efforts, which led to a 15 percent improvement in project alignment and stakeholder engagement.

Crafted concise decision-ready presentations with actionable insights, empowering leadership communications that enhanced decision-making processes, resulting in a 25 percent reduction in project turnaround time through informed strategies.

TECHNICAL SKILLS

Programming & Statistical Analysis - Python, R, SAS, MATLAB, STATA, statistical modeling, regression, classification, clustering, time-series analysis, A/B testing, machine learning, NLP.

Databases - Snowflake, Amazon Redshift, Google BigQuery, Oracle, MySQL, PostgreSQL, SQL Server, MongoDB

Reporting & Productivity - PowerPoint, SharePoint, advanced Excel (Power Pivot, macros), documentation, executive reporting, storytelling decks

Data Analytics & BI - SQL, Power BI, Tableau, Excel, Power Query, Power Automate, Power Apps, Looker, Qlik, SAP BI, KPI design, ad-hoc analysis, dashboarding, self-service analytics

Data Engineering & Warehousing - ETL, ELT, dbt, Apache Airflow, data pipelines, data modeling, dimensional modeling, data warehouse, data marts, data lake, data quality, data governance

Cloud & Big Data Platforms - AWS, Azure, GCP, Hadoop, Spark, S3, Databricks

Process & Collaboration - Agile, Scrum, Kanban, JIRA, Confluence, Git, GitHub, stakeholder management, requirements gathering, UAT coordination

Cybersecurity & Compliance - Identity Governance, OT Security, OT/ICS Cybersecurity, Risk Management, Crisis Management

PROFESSIONAL EXPERIENCE

Northern Trust September 2024 – Present

Sr. Data Analyst Chicago, IL, USA

Spearheaded crisis management initiatives by architecting a real-time monitoring system that preemptively identified bottlenecks, achieving 99.99% platform availability and reducing incident response time by 50%.

Orchestrated cross-functional alignment with operational stakeholders by delivering executive communications that streamlined incident response protocols, resulting in a 50% improvement in response times during production outages.

Spearheaded OT/ICS Cybersecurity initiatives by implementing advanced Identity Governance frameworks that enhanced access control measures, resulting in a 30% reduction in unauthorized access incidents across critical infrastructure.

Designed investment reporting dashboards with Tableau and SQL, consolidating portfolio metrics, strengthening executive visibility, and improving decision support for asset management stakeholders enterprise-wide reliably.

Engineered ETL reconciliation workflows with Python, SQL Server, and data validation rules, reducing manual review effort and increasing audit-ready reporting accuracy for controllers consistently.

Standardized business requirements, data lineage documentation, and KPI definitions in Confluence, aligning risk reporting outputs with governance controls and stakeholder expectations across teams consistently.

Validated SQL extracts, source-to-target mappings, and financial datasets through structured QA checks, preventing downstream discrepancies and improving trusted analytics consumption for leadership review cycles. McKesson January 2023 – August 2024

Data Analyst Irving, TX, USA

Modernized governance processes by implementing robust performance reporting frameworks that provided actionable insights, leading to a 35% increase in operational efficiency across multiple business units.

Engineered a seamless integration between application engineering and product management processes, optimizing workflows and reducing time-to-market by 25% through automated deployment pipelines and enhanced collaboration tools.

Analyzed healthcare claims, inventory, and revenue cycle data with SQL and Excel, identifying operational variances and improving service-level reporting for business teams monthly reviews.

Automated Power BI dashboards and data refresh routines, integrating clinical, supply chain, and finance metrics to accelerate decision-making across healthcare operations and analytics governance.

Streamlined data quality monitoring with SQL profiling, exception reports, and reconciliation checks, improving accuracy for compliance, procurement, and patient support analytics across departments enterprise-wide.

Integrated Salesforce, SAP, and source system datasets into governed reporting models, enhancing stakeholder transparency and supporting timely operational insights for McKesson teams nationwide effectively. Capgemini May 2020 – June 2022

Data Analyst Hyderabad, India

Optimized reporting standards and scorecards by automating data aggregation and visualization, which enhanced decision-making capabilities and improved stakeholder engagement metrics by 20% across the organization.

Pioneered OT Security enhancements by developing a comprehensive Risk Management strategy that fortified system defenses, achieving a 40% decrease in vulnerabilities identified during routine security assessments.

Configured Tableau and Power BI semantic models for consulting engagements, translating client requirements into scalable dashboards and reusable analytics assets that improved delivery consistency.

Optimized SQL queries, stored procedures, and warehouse views across Snowflake and SQL Server, improving report performance and reducing recurring production defects for client deliverables.

Facilitated Agile ceremonies, UAT cycles, and Jira documentation, aligning developers, data stewards, and business users around validated analytics releases for enterprise transformation programs successfully.

Delivered dimensional modeling, ETL mapping, and executive reporting solutions with dbt, Alteryx, and SQL, enabling repeatable analysis across client environments while strengthening data governance. CERTIFICATIONS

Microsoft Certified - Power BI Data Analyst Associate (PL-300)

Microsoft Azure Data Fundamentals (DP-900)

AWS Certified Cloud Practitioner

Microsoft Power Platform

EDUCATION

Master's in Computer Information Systems - Rivier University

Contact this candidate