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

Training Facilitation Trainer in Ghaziabad
Soumya
Ghaziabad , India
Trainer since
March, 2019
Training Facilitation
Mindful Leadership
+1 more...
Leadership Skills Trainer in Tokyo
Michael
Tokyo, Japan
Trainer since
October, 2011
Leadership Skills
Leadership for Managers Trainer in Baku
Alibaba
Baku, Azerbaijan
Trainer since
January, 2016
Leadership for Managers
Change Management
+2 more...
Product Roadmap Trainer in Berlin
Abdo
Berlin, Germany
Trainer since
January, 2013
Product Roadmap
Digital Product Management
+6 more...
Generative AI Trainer in Pune
Prashant
Pune, India
Trainer since
October, 2016
Soft Skills
Personality Development
+3 more...
Introduction to Machine Learning Trainer in Amman
Tarek
Amman, Jordan
Trainer since
June, 2019
Introduction to Machine Learning
Introduction to Deep Learning
+10 more...
Self Leadership Trainer in Pune
Sheetal
Pune, India
Trainer since
January, 2008
Self Leadership
Soft Skills
+4 more...
Managing Conflict with Emotional Intelligence Trainer in Moss Point
Loukisha
Moss Point, United States
Trainer since
January, 2016
Managing Conflict with Emotional Intelligence
Remote Leadership
+1 more...
Marketing Strategy and Planning Trainer in Montreal
Donald
Montreal, Canada
Trainer since
May, 2008
Marketing Strategy and Planning
Softskill Trainer in Hyderabad
Suja
Hyderabad, India
Trainer since
October, 2024
Softskill
Soft Skills Trainer Trainer in Bengaluru
Premlatha
Bengaluru, India
Trainer since
September, 2016
POSH(Prevention of Sexual Harassment)
Soft Skills Trainer
+1 more...
Soft Skills Trainer in Bangalore
Krishna
Bangalore, India
Trainer since
June, 2015
Soft Skills
Image Consulting
Generative AI Trainer in Pune
Kishor
Pune, India
Trainer since
March, 2014
Generative AI
ChatGPT Trainer
+3 more...
IELTS Trainer Trainer in Pune
Manisha
Pune, India
Trainer since
September, 2019
Soft Skills
IELTS Trainer
Business Communication Trainer in Ahmedabad
Reena
Ahmedabad, India
Trainer since
September, 2016
Seven Habits of Highly Effective People
Business Communication
+4 more...