Aishwarya Bengaluru India

Aishwarya

SQL and ETL Testing Trainer in Bengaluru
Location
Bengaluru, India
Trainer Since
January, 2020
Data Analysis Expressions
ETL Testing
SQL
Location
Bengaluru, India
Trainer Since
January, 2020
Data Analysis Expressions
ETL Testing
SQL

SQL and ETL Testing Trainer in Bengaluru

About Aishwarya

Aishwarya is a highly accomplished professional with an impressive track record of over 5 years in the field of data management. With vast expertise in various aspects of data management, Aishwarya has extensive knowledge and experience in data modeling, data analysis, data pipeline, data profiling, data quality, ETL, data warehouses, data marts, and data lakes. She is a seasoned data management professional capable of delivering efficient and effective solutions for businesses to consume data through reports and dashboards, which can be used for everyday decision-making processes.

With a strong foundation in data management and an ability to work with large datasets, Aishwarya has demonstrated a knack for identifying and addressing business data-related issues. Her expertise in data modeling, data analysis, and data quality has helped her develop a comprehensive understanding of the complex data landscape, allowing her to make informed decisions about data warehousing, data marts, and data lakes.

Aishwarya is a Corporate Trainer For

Data Analysis Expressions

Training Since:
January, 2022

ETL Testing

Training Since:
January, 2020

SQL

Training Since:
January, 2020

Work Experience

Senior Software Engineer

Energy and Power:
August, 2022 - present

Roles & Responsibilities

  • Responsible for data pipeline, data quality, and data analysis and provided ETL / DW design and enhancements as part of technology migration for various ETL / DW components currently using GCP and Azure
  • Responsible for successful design, development, and delivery of ETL, database, and reporting projects
  • Built a digital hygiene dashboard to bring transparency to the system across the globe
  • Reduced the mismatch between supply -demand in electricity generation & distribution
  • Utilized data mining tools to apply different cost layering methods to reconstruct and validate average cost and sales pricing of electricity sold with negative margins to customers, leading to leaked revenues or losses.
  • Built many Python-based auto e-mailers for reporting and solved ad hoc analyses
  • Created multiple dashboards for tracking important KPIs and metrics daily

Senior Software Engineer

Healthcare:
March, 2020 - March, 2021

Roles & Responsibilities

  • Worked closely with the quality assurance, operations, and production support group to devise the test plans, answer questions, and solve any data issues
  • Prepared and automated the SQL Scripts for validating data pipelines
  • Defined, configured, and optimized various MDM processes, including landing, staging, base objects, hierarchies, foreign-key relationships, lookups, and query groups
  • Verified the mapping, process flow, business logic, calculations, exception handling, and transformations rules and built a data dictionary
  • Used stored procedures, triggers, and views to provide structured data to business units by combining millions of rows of data from 19 disparate data sources
  • Performed operations like data reconciliation, validation, and error handling after extracting data into SQL Server twice a week

Quality Analyst

Hospitality and Tourism:
June, 2017 - March, 2020

Roles & Responsibilities

  • Integrated and standardized customer/transactional data in visualization dashboards to provide more visibility and quickly analyze, develop, and test potential use cases
  • Executed end-to-end analytics to extract, clean, standardize, and analyze voluminous booking data such as booking, payment, onboarding, sales, discount, and inventory and provide new insights
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse)
  • Worked on fast-paced agile development environment projects that provided real-time and historical analysis, decision support, and reporting services
  • Understood the project scope, identified activities/ tasks, task level estimates, schedule, dependencies, and risks, and provided inputs to the module lead for review
  • Participated in all SDLC levels of testing to provide SME validation and recommendations for corrections or improvement
  • Used data profiling, data quality tools, and database queries to uncover and determine the root causes of data quality issues
  • Reached testing goals by performing ETL process flow validation, error handling, and error logging validation, data completeness, business logic validation, IBM cognos report testing, and SCD types validation to ensure the accuracy of data
  • Wrote test cases in rally and defect report generation using rally (Application Lifecycle Management) experience in integrating various data sources with multiple relational databases like Oracle, SQL Server, SSMS, and Flat Files

Consultant

Healthcare:
March, 2021 - August, 2022

Roles & Responsibilities

  • Applied project methodology to lead the project team through the process of defining and documenting project scope and objectives
  • Drove direction from strategy to execution of applying data analytics, including data scoping, analysis, visualization, and delivering actionable insights
  • Prepared and created analytic reports on customer insights such as user geographic location, age groups, and gender using SQL, Python, and PowerPoint
  • Designed analytics database integrating large volumes of data from disparate systems to build holistic views of medicare data and reporting.
  • Worked with business SMEs to identify and provide recommended resolutions for data quality issues identified by: interrogating legacy data/data profiling and identification of business rules to support requirements and mappings
  • Collaborated with offshore and onshore developers and stakeholders for technical and business peers on development efforts, requirement analyzing, and designing
  • Worked on data warehousing & data lake, analyzing data issues at the initial stages, their implementation approach in production, and automated the process
  • Identified methods of improving performance in ETL design and ensured that the ETL design includes restart-ability, error handling, and audit throughout ETL processes.
  • Implemented logical and physical data modeling using SQL database modeler with snowflake schema in data marts, ensuring that correct mappings and data quality

Skills

SQL
Python
Linux
GCP
IBM Infosphere
Datastage
Power BI
Azure
Cognos
SQL
MySQL
Communication Skills
Team Management
Team Leading

Education

B.Tech

Electronics and Instrumentation:
2013-2017

Projects

Posts

Courses

Data Analysis Expressions
ETL Testing
SQL

Want Aishwarya for your Next Training?

Request a Demo

Other Trainers

Red Hat System Administration Trainer in Bangalore
Ananya
Bangalore , India
Trainer since
November, 2013
Red Hat System Administration
Artificial Intelligence - AI Trainer in Mumbai
Junaid
Mumbai, India
Trainer since
January, 2009
Python
Introduction to Machine Learning
+2 more...
Leadership for Managers Trainer in Kingston
Natalie
Kingston, Jamaica
Trainer since
May, 2010
Time Management
Self Awareness
+12 more...
Telephone Etiquette Trainer in London
Laura
London, United Kingdom
Trainer since
July, 2014
Telephone Etiquette
Project Management Fundamentals Trainer in Angeles city
Nandakumar
Angeles city, Philippines
Trainer since
September, 1994
Project Management Fundamentals
Artificial Intelligence - AI Trainer in Denver
Matt
Denver, United States
Trainer since
January, 2011
Artificial Intelligence - AI
Performance Coach Trainer in Ahmedabad
Mithilesh
Ahmedabad, India
Trainer since
September, 2009
Performance Coach
AWS Trainer in Delhi
Disha
Delhi, India
Trainer since
September, 2018
AWS
Generative AI
+1 more...
Presentation Skills Trainer in Madrid
David
Madrid, Spain
Trainer since
February, 2013
Presentation Skills
ITIL Trainer in Mandaluyong City
Joy
Mandaluyong City, Philippines
Trainer since
September, 2018
ITIL
Snowflake
+1 more...
Leading with Kindness Trainer in Toronto
Roxana
Toronto, Canada
Trainer since
January, 2011
Time Management
Emotional Intelligence for Game-Changing Leaders
+7 more...
SAP HANA Trainer in Bangalore
Sumit
Bangalore, India
Trainer since
September, 2019
SAP HANA
Oracle Fusion HCM Trainer in Dubai
Ammar
Dubai, United Arab Emirates
Trainer since
January, 2017
Oracle Fusion HCM
Oracle Fusion SCM
+1 more...
Body Language Trainer in Ahmedabad
Sudeep
Ahmedabad, India
Trainer since
June, 2018
Body Language
Senior Defense Management Course Trainer in Ahmedabad
Arvind
Ahmedabad, India
Trainer since
May, 1998
Senior Defense Management Course
Higher Defense Orientation Course
+3 more...