Ats Da
Ashburn
Summary
Detail-oriented Data Analyst with around 5 years of hands-on experience in data analysis, visualization, and reporting. Proficient in SQL, Excel, and Power BI for extracting, cleaning, and analyzing data to support business decisions. Skilled in data preparation, dashboard development, and ETL concepts, with a strong focus on accuracy and problem-solving.
Data analysis professional prepared to deliver impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach. Skilled in Python, SQL, and Excel, ensuring robust data solutions and strategic recommendations.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Analyst
Horizon Reservation | SITA
06.2024 - Current
- Collected, cleaned, and analyzed large volumes of reservation, ticketing, and pricing data to ensure accuracy and consistency across airline systems.
- Wrote SQL queries to extract and reconcile booking (PNR), fare, and passenger transaction data for reporting and validation purposes.
- Developed Excel and Power BI dashboards to visualize key KPIs such as booking success rate, ticketing errors, and transaction performance trends, improving reporting accuracy and visibility.
- Supported data validation, normalization, and enrichment to improve system reliability and enhance booking accuracy.
- Partnered with QA and business teams to identify data quality issues, define performance metrics, and track resolution trends.
- Assisted in maintaining ETL workflows to standardize and refresh reservation data, reducing manual processing effort by ~25%.
- Created data summaries and trend reports to highlight fare anomalies, route-wise booking trends, and peak transaction hours, supporting business insights.
- Documented data sources, mapping logic, and reporting standards to support knowledge sharing and audit readiness.
Data Analyst
Data & Analytics Transformation | SMBC Group (America Region)
10.2021 - 06.2024
- Analyzed financial and credit risk data using SQL and Excel, identifying patterns and KPIs such as loan default trends, portfolio exposure, and revenue growth, supporting risk assessment activities.
- Created Tableau dashboards to visualize credit exposure, liquidity ratios, and profitability metrics, improving report accuracy and accessibility for senior management.
- Supported data cleaning and validation processes, reducing data discrepancies by 15% and improving consistency across financial reports.
- Conducted ad-hoc analysis and built summary reports to support quarterly business reviews and credit risk assessments, enhancing decision-making timeliness.
Associate Data Analyst
InCentive Inc.
05.2020 - 10.2021
- Assisted in managing Agile backlog items and supporting development of analytical tasks to meet business requirements.
- Contributed to creating database models, data flow diagrams and entity relationship diagrams to document data structure.
- Performed analysis on healthcare and operational datasets (for internal pilot use) using SQL to identify patterns and trends supporting improved reporting accuracy.
- Built and maintained Tableau dashboards to visualize key performance indicators, helping stakeholders access data more readily.
- Utilized Excel and SharePoint for data mapping, data migration tasks and to support organization of data feeds.
Education
Master of Computer Applications [MCA] -
ATS-DA
India06.2008
Bachelor of Computer Applications [BCA] - undefined
ATS-DA University
India06.2005
Skills
- SQL – Commands and Functions, Joins, Aggregation, Subqueries, Views, Window Functions, CTE
- Data sources used – MS-Excel, MySQL
- Dataverse – Tables, Columns, Relationships, Forms, Views, Charts, Keys, Dashboards, Models, and Business Rules
- Data Analysis – Advanced Excel – Pivot Tables, Charts, Lookups, Power Query
- Power BI – Extract Transform & Load [ETL], Data Modeling, DAX, Parameters, Row Level Security [RLS], Publishing, Scheduled Refresh, Dataflows, Datamart’s, Reports, and Dashboards, Power Query, Trend Analysis and Forecasting
- Tableau – ETL, Dashboard Building, Trend Analysis, LOD’s
- Databases – Oracle 19c, SQL Server, MySQL
- Additional Skills – Atlassian JIRA, ALM, Agile Methodology
- Domains – Travel/Airline, Banking/Financial, Insurance
- Power BI dashboards
- Data visualization
- SQL queries
- Data analysis
Certification
- Oracle Cloud and AI Foundations Certified
- HIPAA Certified
Timeline
Data Analyst
Horizon Reservation | SITA
06.2024 - Current
Data Analyst
Data & Analytics Transformation | SMBC Group (America Region)
10.2021 - 06.2024
Associate Data Analyst
InCentive Inc.
05.2020 - 10.2021
Bachelor of Computer Applications [BCA] - undefined
ATS-DA University
Master of Computer Applications [MCA] -
ATS-DA
Additional Information
- Career Break - To manage key personal responsibilities and for professional learning & development | 09/2014 - 10/2021
- Prior Experience with Coforge Inc. as Data Quality Analyst in banking, Insurance & Aviation domain | 09/2008 - 08/2014