Sashi (Sashidhara) Andra Email & Phone Number

Melbourne, VIC, AU

Melbourne, Victoria, Australia

Melbourne, Victoria, Australia

• Designed and developed generic framework using Python and Oracle DB to perform Audit Control and Data Governance for Informatica batch jobs, as an individual contributor.
• Audit Control framework offers one stop solution for monitoring jobs’ status with load status, pre and post rules execution on source & target objects, job performances, point-to-point reconciliation and rejection.
• Built Python data masking solution to substitute PII information with meaningful masking data on tables and files in bulk, with audit logging for monitoring, as an individual contributor.
• Provisioned independent source and target locations for table masking to mask data from production and load to stage/development environment tables.

Melbourne, Australia

• Developed pipeline to import and export data to and from Oracle database for PySpark jobs.
• End to end pipeline (On-prem to BigQuery) using frameworks.
• Data pipeline to export schema file with data and tag file using Python.
• Standardized Bigdata file format for Datastage transformation output file formats.

Bengaluru, Karnataka, India

• Designed, Implemented YouTube Analytics and Cluster Insights projects.
• YouTube Analytics: Completely automated the process of ETL using Python, AWS S3 and Snowflake database to gather viewership information for Data Analytics team.
• Cluster Insights: Automation of cluster health check process with ELT on semi-structured data to highlight performance issues and track capacity trends for clusters deployed across geography.
• Implementation of CI/CD pipeline.

Bengaluru, Karnataka, India

• Led and worked in royalty calculation of client music application data.
• Designed metadata driven architecture to reduce future development and testing effort.
• De-duplication of everyday listeners data, stitching multiple records into single play and calculate subsequent royalties.
• Royalty reports generation using Hive, Shell scripting, Python; Oozie for workflow and Autosys for Jobscheduling respectively; export using Sqoop and Semantic framework to Vault for storing.

Bengaluru, Karnataka, India

• Worked on royalty calculation for client music application data.
• Migrated billing application from Teradata to Hadoop by importing data using Sqoop and implemented Teradata equivalent Hive queries.
• Worked on cross cluster replication to synchronize data between primary and backup clusters.

Bengaluru Area, India

• Implementation of Data Warehousing migration from Oracle to Hadoop for Production CreditReporting application.
• Data import from Oracle to Hadoop using Sqoop and equivalent Hive implementation.

Bengaluru, Karnataka, India

• L2/L3 Support Engineer for GRCM and Radar and responsible for loading data using SQL Loader, monitoring application/jobs and fixing bugs using SQL and Java.
• Effectively involved in release activities, post-release and regression testing, release/application documentation, report generation and coordination with development team on change requests.
• Responsible for end user subscription access, GRCM document reprocessing and DR & BCP activities.