Saloni Anandpara
Development
south australia, Australia
Skills
Data Engineering
About
SALONI ANANDPARA's skills align with Programmers (Information and Communication Technology). SALONI also has skills associated with Database Specialists (Information and Communication Technology). SALONI ANANDPARA has 10 years of work experience, with 4 years of management experience, including a low-level position.
View more
Work Experience
Senior Data Engineer
Scope Group
January 2023 - Present
- Designed and implemented 6 ETL pipelines using Azure Data Factory (ADF) to integrate data from 25+ data sources into data warehouse, resulting in 50% reduction in processing time and improving data accuracy. Designed and built new data model for an application storing 4k+ attributes, to optimize performance and reduce data storage costs by 40%. Collaborated with 5 technical and non-technical Product Owners to articulate 10+ specific data requirements. Presented 3 comprehensive solutions to provide insights into data analytics behaviour and trends. Revamped data models for 6 projects/systems by constructing and sustaining data modelling layers with T-SQL in SQL Server, while adhering to SQL best practices. Created 20 PowerBI reports for financial end users and CTO/CFO for data quality, historical deals won/lost and estimated annual revenue, using PowerBI DAX functions Managed and sustained the data warehouse environment using version control systems such as GIT, GitHub, and Azure DevOps. Proficient in utilizing JIRA for efficient ticket management. Mentored 2 junior data engineers in data engineering and SQL and Azure best practices, resulting in improved data pipeline efficiency and data accuracy
Senior Consultant
Deloitte US India Pvt. Ltd
January 2017 - April 2022
- Building solutions that utilise data pipelines to provide actionable insights into operational efficiency and other key business performance metrics. Supporting business stakeholders, SMEs, project teams and business analysts with design, development, and solution management. Lead a technical team of 6 resources that encompasses analysing requirements, design, development, testing, documentation, peer code reviews, support. Analysed 50+ requirements within Data and Analytics team to deliver analytical and reporting solutions using SQL/PLSQL objects like packages, procedures, views, etc. Designed and developed over 7 innovative analytics solutions leveraging the Microsoft Azure platform, seamlessly integrating with an on-premise Oracle database. Participated in 100% Agile project management methodologies to support 100+ user stories in all aspects of Software Development Life Cycle (SDLC) through TFS (Team Foundation Server). Create 5+ Data layers in Oracle for Tableau dashboard reporting and maintaining Data warehouse of all source systems using ETL migration tools such as DataStage Engage with business users, collaborated with stakeholders, lead initiatives for smooth delivery, and support testing phases (SIT, UAT) for successful go-live and post-production support and exceeded customer requirements Designed and developed critical conversions in Oracle ERP, including pricing, channel revenue management, and master data (customer, Items, Suppliers) support for seamless integration from legacy systems.
Technical Lead
Capgemini
March 2013 - December 2016
- Analysing, redesigning, remediating and unit testing of 6 PLSQL objects in Payables/Fixed assets modules of Oracle R12 which hold Chart of Accounts (COA) related data in Oracle EBS R12 Owned end-to-end delivery of applications to the Oracle business unit, subsequently receiving appreciation and support to take it forward to Oracle Open World 2014 as a representative of iGATE (Capgemini) Designing and implementing the UI of 3 dashboards using OA Framework and ADF solely amongst the team for which got highly appreciated by the Customer and Delivery Manager and later worked as a deal maker; client started an engagement to provide the required infrastructure to support ADF development.
Education
