Data Analyst Senior

Amuthanraj Mohanraj

Senior Data Analyst

Plano, Texas ************@*****.*** +1-469-***-****

PROFESSIONAL SUMMARY

Results-driven Senior Data Analyst with 13+ years of experience delivering scalable analytics solutions and business intelligence tools across financial, manufacturing, and insurance domains. Proven track record of optimizing data pipelines, migrating BI systems to cloud platforms, and building interactive dashboards that reduce reporting latency and increase business adoption. Expert in SQL, Tableau, Python, and Snowflake with strong cross-functional collaboration and data governance skills.

CORE COMPETENCIES

• Data Engineering: SQL Optimization (T-SQL, PL/SQL), SSIS, Star & Snowflake Schemas, Stored Procedures

• BI & Visualization: Tableau (Desktop, Server, Cloud), Power BI (DAX), OBIEE, D3.js Visualizations

• Cloud & Databases: Snowflake, SQL Server, Oracle, AWS S3, IBM DB2

• Automation & Scripting: Python (Pandas, NumPy), SAS, Shell Scripts, SQL Server Agent

• Agile Delivery: Data Governance, KPI Design, Performance Tuning, Stakeholder Communication

PROFESSIONAL EXPERIENCE

Senior Data Analyst

Optum, Healthcare Company, USA June 2024 – Present (Remote)

• Built an end-to-end analytics solution for auto loan KPIs; optimized 200+ SQL queries using CTEs/indexed views, reducing data retrieval time by 40%

• Designed D3.js-enhanced Tableau dashboards with geo and heat maps, enabling real-time insights into a $500M loan portfolio

• Developed Python ETL pipelines for Snowflake/S3 data, automating cleansing and reducing manual effort by 15 hours/week

• Automated Tableau data source reconciliation, resolving 95% of pipeline discrepancies within SLA

• Reduced ad-hoc reporting by 25% via parameter-driven dashboard interactivity

Senior Data Analyst

Wipro Technologies, Chennai, India Feb 2017 – May 2024

Client: Citi Bank (Feb 2022 -May 2024)

• Developed Tableau dashboards using SQL CTEs, filters, parameters, and visualizations (Geo Maps, Dual Axis, Bubble Charts)

• Automated data pipelines using Python and Snowflake, improving efficiency and data accuracy

• Migrated on-prem Tableau to Tableau Cloud, implemented governance, version control, and audit trails

• Monitored dashboard performance and resource usage in Tableau Cloud, reducing load time and operational costs

• Partnered with business teams to create self-service BI assets used by 300+ global users.

Client: Standard Chartered Bank (Jan 2019 – Feb 2022)

• Collaborated with business analysts and stakeholders to gather requirements and deliver BI reports and Tableau dashboards tailored to key business functions and KPIs.

• Designed and implemented ETL workflows using SQL Server SSIS to load data from Excel, CSV, and SQL sources into a star-schema model supporting enterprise reporting.

• Developed and optimized Tableau dashboards with calculated fields, parameters, and sheet selectors; enabled secure access via user-level filters and published workbooks.

• Monitored Tableau Cloud usage, implemented version control and audit trails, and ensured performance optimization for cost-effective cloud operations.

• Automated data pipeline processes and job scheduling via SQL Server Agent, increasing report delivery efficiency and reducing manual effort.

• Conducted performance tuning using SQL Profiler and parallel testing to ensure system reliability.

Client: Central Bank of India (Feb 2017- Dec 2018)

• Created scalable Power BI models integrating SQL Server, Snowflake, and Excel for 50+ enterprise reports

• Automated data refresh using Power BI Service with RLS for 300+ users, ensuring 99.9% availability

• Optimized DAX expressions, improving report load speed by 30% and boosting user adoption by 45%

SQL/Tableau Developer

Middle East Insulation LLC, Dubai, UAE Sept 2013 – Sept 2016

• Migrated legacy data to star-schema warehouse via SSIS, improving claims processing speed by 35%

• Built drillable Tableau dashboards with dynamic filters for regional sales performance

• Automated 20+ SQL Agent jobs for ETL/report delivery, achieving 0% unplanned downtime

SQL/MSBI Developer

Info Services, India May 2011 – Feb 2013

• Developed stored procedures and triggers for real-time financial reporting compliance

• Managed Tableau Server deployments and ensured data source security for 100+ users

EDUCATION

Bachelor of Engineering in Computer Science

Anna University, Chennai, India

,

Contact this candidate