Business Intelligence Data Analytics

SWATHI N

NJ, USA ***** +1-201-***-**** ************@*****.***

PROFESSIONAL SUMMARY

•Over 5+ IT experience in reporting, content management, business intelligence, and data analytics, with a strong background in evaluating, cleansing, and visualizing large datasets to support strategic corporate decision-making.

•Knowledgeable in using Python libraries for data processing, statistical analysis, and creating powerful visualizations, including NumPy, Pandas, Matplotlib, and Seaborn.

•Experience in interpreting and applying feasibility studies, System Requirements Specification (SRS), Scope Document, Applications Architecture and Request for Proposal (RFP).

•Experience in providing analytical thinking, reporting process improvements, problem solving, time management, decision making and issue resolution.

•Understanding of structured data sets, data pipelines, ETL tools, data reduction, transformation and aggregation technique, Knowledge of tools such as DBT, DataStage

•Extensively worked on identifying problems, business context to perform analysis.

•Very keen in knowing newer techno stack that Google Cloud platform (GCP) adds.

•High ability to deal with ambiguity and business complexity and communicate complex analysis to leadership.

•Developed Workday-calculated fields and sub reports to enhance data granularity for diversity, equity, and inclusion (DEI) dashboards.

•Experience in providing multiple solutions to customers/clients due to rapidly changing strategic priorities.

•Expertise in Data Architecture, Data profiling, Data analysis, data mapping and Data architecture artifacts design.

•Automated ETL pipelines using BigQuery + Cloud Composer (Airflow), improving data freshness and reliability by 30%

•Strong experience in Data modeling - Conceptual, Logical/Physical, Relational and Multi-dimensional modeling, Data analysis for Decision Support Systems (DSS), Data Transformation (ETL) and Reporting.

•Design dimensional model, data lake architecture, data vault 2.0 on Snowflake and used Snowflake logical data warehouse for compute.

•Hands on experience with big data tools like Hadoop, Spark, Hive, Pig, PySpark, Spark SQL,PySpark

•Strong experience in working with developers for preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.

•Experience working on analytics data to visualize and analyze data and transform as per requirements.

•Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Synonyms, Sequences and Materialized views using SQL.

•Met daily with department managers, project manager, and Director of QA to ensure ongoing compliance with SOX, GxP, and all other applicable regulatory requirements.

•Developing data quality metrics and standards for different types of data to ensure that HPOne high quality and error-free

•Expertise in SCRUM Agile Framework and Methodology with experience in Daily Stand-up Meeting, Sprint Planning meeting and Sprint Retrospective meeting.

•Experience in Data Migration, Transformation, Integration.

•Solid experience in Data Warehousing best practices working with Metadata, repositories and experience within a disciplined lifecycle methodology.

•Used SQL for data extraction and data analysis, Qlik view dashboards has been made to increase the data visualization

•Extensive working experience in creating Conceptual, Logical and Physical data models using Star Schema and Snow flake schemas.

•Extensive experience in Database query tuning, performance tuning.

•Designed ETL Specification documents to load data from source to target using various transformations according to the business logic.

•Proficiency in database design concepts, architecture and ETL design strategies with Apteryx.

•Expertise in SCRUM Agile Framework and Methodology with experience in Daily Stand-up Meeting, Sprint Planning meeting and Sprint Retrospective meeting.

•Experienced in Performing User Acceptance Testing (UAT) for data verification.

•Excellent communication and presentation skills

•Practical experience with data visualization software, including Tableau, Power BI, and Microsoft Excel, to create dynamic dashboards and effectively convey findings to stakeholders.

•Shown experience in data querying, transformation, and reporting using relational and NoSQL databases, including MySQL, SQL Server, and MongoDB.

•Set up scheduled queries and BigQuery exports to Google Sheets or Cloud Storage to automate data sharing with business stakeholders.

•Strong grasp of data management best practices, automated reporting workflows, and business process improvements to enhance data accuracy, efficiency, and informed decision-making.

•Familiar with core Azure Data Engineering concepts such as Azure Data Factory, Azure SQL Database, and Azure Blob Storage for building scalable data pipelines and managing cloud-based data solutions.

•Basic knowledge of Azure Data Lake, Azure Synapse Analytics, and data security practices, with exposure to managing structured and unstructured data in a cloud ecosystem.

•Certified in Data Analytics, equipped with skills in data analysis, visualization, and driving actionable business insights.

SKILLS

Technologies: Python (NumPy, Pandas, Matplotlib), SQL, HTML

Visualization Tools: Tableau, Power BI, BigQuery, Microsoft Excel, Erwin, Alteryx design

Database: MySQL, SQL Server, MongoDB

Project & Collaboration Tools: SharePoint, ANCILE uPerform, Power Automate, Git (basic)

Software / Other Skills: Data Cleaning, Data Wrangling, Critical Thinking, Communication Skills,

Presentation Skills, Problem-solving, Decision-Making, Google Sheets, Information Management, ETL Process, ELT Process, Data Modeling

WORK EXPERIENCE

American Airlines, Dallas, TX

Data Analyst April 2025 - Present

•Analyzed and aligned business and technology needs to streamline and enhance data collection processes.

•Performed data manipulation, cleansing, and exploratory/statistical analysis using SQL, R, SAS, Power BI, Tableau, and Excel for business decision-making.

•Developed and tracked key performance indicators (KPIs) to measure campaign success and drive improvements.

•Collaborated with product teams to define KPIs and built real-time analytics reports using BigQuery Data Studio.

•Migrated legacy SQL scripts and reporting logic from on-premise data warehouse to BigQuery, improving scalability and maintainability.

•Partnered with HR, finance, and legal teams to gather reporting requirements and translate business needs into actionable Workday report designs.

•Used agile methodology for repeated testing.

•Utilized data-driven insights to assess campaign effectiveness and optimize strategies for future initiatives.

•Collaborated with cross-functional teams to define data requirements and improve operational efficiency.

•Created interactive dashboards and reports using Power BI, Tableau, and Excel to present actionable insights and support strategic decision-making.

Stevens Institute of Technology Teaching Assistant September 2023 - December 2023

•Conducted lab sessions and tutorials on SQL, Power BI, Tableau, and Excel for graduate-level Business Intelligence courses.

•Mentored students on data wrangling, modeling, dashboard design, and analytical problem-solving techniques.

•Assisted professors in creating course materials, real-world case studies, and technical assignments focused on data analysis.

•Reviewed student projects, ensuring adherence to ETL/ELT practices and data quality standards.

•Facilitated workshops on data visualization best practices and storytelling with data using Tableau and Power BI.

•Guided implementation of cloud-based solutions (Azure Data Factory, Azure SQL) into academic projects.

•Supported grading of final exams and capstone projects, maintaining fairness and consistency across evaluations.

•Collaborated with faculty to incorporate data governance concepts and documentation techniques into the curriculum.

Stevens Institute of Technology Grader Assistant January 2023 - May 2023

•Graded assignments, quizzes, and exams for Business Intelligence and Data Analytics courses with high accuracy.

•Provided constructive feedback on SQL querying, Python data analysis, and dashboard projects using Power BI and Tableau.

•Maintained meticulous records of grades and assignment submissions for over 150+ students.

•Reviewed coursework involving ETL workflows and database modeling to assess practical understanding.

•Worked closely with professors to refine rubrics, ensuring alignment with learning objectives and technical depth.

•Identified and escalated any academic integrity concerns observed during grading processes.

•Supported students during office hours by clarifying grading criteria and suggesting improvements.

•Contributed ideas to update assignments based on evolving data industry standards and tools.

Accenture Solution PVT & LTD

Senior Data Analyst April 2019 - December 2022

•Extracted, cleaned, and analyzed large datasets using SQL and Python (Pandas) to support business intelligence reporting and decision-making.

•Built and maintained dashboards in Power BI and Tableau, enabling business units to track KPIs and performance metrics with 30% faster turnaround.

•Collaborated with business stakeholders to define KPIs and develop reporting solutions, improving accuracy and adoption by 25%.

•Created documents like Business Requirements Specification, Technical Requirements Specification.

•Work with a diverse IT community to identify project data and detailed data requirements need to source data for the project.

•Created validation logic within Workday reports to identify data quality issues, reducing downstream errors in compensation planning cycles.

•Prioritized requirements to be developed according to Agile methodology.

•Identified the risks in schedule and marking them in the Use Cases.

•Worked in performing data profiling and analyzed data flows.

•Provided development and consultation for business plans, programs and initiatives.

•Having experience in Snowflake cloud data warehousing shared technology environment for providing stable infrastructure

•involved in creating Hive tables, loading with data and writing hive queries that run internally in map reduce

•Implemented data validation checks and anomaly detection in BigQuery pipelines using scheduled queries and alerts.

•Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.

•Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.

•Involved in data governance, defined data mapping from source to target (for all the three heritages).

•Handled the detail execution of data gathering, dashboard implementation and bug fixing.

•Gathered metadata and created data analysis repository (spreadsheet), which includes following metadata information: data source, hierarchy, fact, dimension, data attribute, data integration, data model, data acquisition etc.

•Involved in the Data Mining, Profiling and Data Modeling.

•Wrote the test cases and technical requirements and got them electronically signed off.

•Created new reports based on requirements.

•Performed data mapping from source to target.

•used SQL for accessing and manipulating database systems

•Participated in Design walk-through with SMEs to baseline the business architecture.

•Facilitated in the overall management of the project including and mitigation, status reports, client

•Presentations, defining milestones, deliverables and establishing critical success factors.

•Was jointly responsible for monitoring the progress of the development and QA team.

•Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.

•Having experience in Snowflake cloud data warehousing shared technology environment for providing stable infrastructure

•involved in creating Hive tables, loading with data and writing hive queries that run internally in map reduce

•carried out data transformation and cleansing using SQL queries, Python and Pyspark.

•Build data pipelines in airflow in GCP for ETL related jobs using different airflow operators.

•Extensively worked on creating data mappings between 2 different sources.

•Created Data Flows to load data from flat file, CSV files with various formats into Data Warehouse.

•Worked on data residing in heterogeneous data sources to be consolidated onto target database.

•Designed and developed conceptual, logical and physical data models.

•Created and integrated new and old data models into the data warehouse using snow flake schema.

•Worked on relational database concepts, stored procedures, functions, triggers and scalability analysis.

•Designed and developed weekly, monthly reports related to the marketing and financial departments using SQL

•Created Use Case Diagrams using UML to define the Functional requirements of the application.

•Performed Acceptance Testing (UAT), Unit Testing and Documenting.

•Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.

•Carried out data transformation and cleansing using SQL queries, Python and Pyspark.

•Build data pipelines in airflow in GCP for ETL related jobs using different airflow operators.

•Extensively worked on creating data mappings between 2 different sources.

•Created Data Flows to load data from flat file, CSV files with various formats into Data Warehouse.

•Worked on data residing in heterogeneous data sources to be consolidated onto target database.

•Designed and developed conceptual, logical and physical data models.

•Created and integrated new and old data models into the data warehouse using snow flake schema.

•Worked on relational database concepts, stored procedures, functions, triggers and scalability analysis.

•Designed and developed weekly, monthly reports related to the marketing and financial departments using SQL.

•Served as a Subject Matter Expert (SME) for data visualization supported client teams and internal staff on reporting best practices.

•Mentored new joiners and junior analysts on SQL, Power BI, and Tableau, contributing to faster onboarding and stronger team productivity.

•Received the Core Value Champion Award for demonstrating integrity, excellence, and collaborative leadership on key client engagements.

Infor (India) PVT & LTD Junior Data Analyst April 2018 - August 2018

•Collected and prepared data from multiple sources, improving data reliability and supporting accurate business analysis across departments.

•Performed data cleaning and preprocessing, which enhanced data quality by 25% and reduced reporting errors in key dashboards.

•Conducted exploratory data analysis (EDA), helping uncover actionable trends that led to a 10% increase in campaign performance.

•Wrote and optimized complex SQL queries, reducing data retrieval time by 40% and streamlining access to operational metrics.

•Developed interactive dashboards in Power BI, Tableau, and Excel, enabling leadership to monitor KPIs and make faster, data-backed decisions.

•Collaborated with cross-functional teams to translate data needs into insights, contributing to the success of 3+ cross-departmental projects.

•Created and maintained documentation for queries and reporting workflows, reducing onboarding time for new analysts by 30%.

•Designed visualizations that clarified trends and performance metrics, improving stakeholder understanding and alignment in strategy meetings.

•Automated routine reporting tasks using Python and Excel macros, saving 6+ hours weekly and improving team productivity.

•Continuously applied feedback to refine analytics processes, resulting in higher-quality insights and better support for business goals.

EDUCATION

•Stevens Institute of Technology – NJ, USA

•Master of Science in Business Intelligence and Analytics - (GPA 3.8/4.0)

•Kasturba Gandhi Degree & PG College for Women

•Bachelor of Science in Mathematics, Electronics & Computer Science

Contact this candidate