Siddhi Bankar

SQL Developer, Data Analysis

ATOS

Mumbai

09.2021 - Current

Improved Hyperion Planning, Essbase, and ODI modules by gathering requirements from stakeholders, designing comprehensive implementations that led to a 40% reduction in processing times during testing phases, resulting in a 20% increase in system efficiency.
Developed and optimized complex SQL queries, improving query speed by 35%
Created 40+ comprehensive reports analyzing business operations and trends
Assisted with the creation and maintenance of large scale data platforms, honing SQL knowledge.
Implemented ETL operations in a high-volume data environment, reducing data load time by 25%
Implemented automated retests reducing debugging time by 20%
Executed SSIS migration tasks, leading to a 15% optimization in system performance.
Designed and implemented SSIS packages to seamlessly transfer data from flat files to SQL Server, and Business Intelligence Development Studio.
Prepared comprehensive data mapping for all migrated jobs using SSIS, ensuring accuracy and efficiency in data transfer processes.
Spearheaded the resolution of metadata and data issues in various Hyperion Planning and Essbase applications as part of BAU activities, resulting in a 25% reduction in data discrepancies.
Conducted technical requirements meetings, increasing client satisfaction by 30%
Managed maintenance and server administration tasks for multiple planning and Essbase applications, ensuring seamless operations and minimal downtime.
Automated and optimized processes significantly improve daily maintenance tasks for diverse Essbase applications, resulting in a 30% reduction in processing time.
Executed an end-to-end testing strategy during migration projects that encompassed more than ten interconnected systems, reducing post-migration issues reported by users by at least 50%, and ensuring smoother transitions with minimal downtime.
Collaborated on Oracle EBS integration, ensuring seamless data flow and system compatibility.
Performed data loads using Essbase load rules, streamlining data management processes, and enhancing system performance.
Modified the existing outlines to implement the new functionality based on the user requirements.
Extensively involved in designing and modifying the outlines for ESSBASE cubes.
Incorporated new functionality into existing outlines to align with user requirements.
Developed simple to complex calculation scripts, MDX, MaxL scripts, and modified the existing calc scripts to suit the end user's needs.

Overview

Work History

SQL Developer, Data Analysis

Education

Bachelor of Technology - CSE

Skills

Timeline

SQL Developer, Data Analysis

Bachelor of Technology - CSE

Similar Profiles

Daniel Gálvez ReyesDaniel Gálvez Reyes

Heemali MallavHeemali Mallav

Kshitij BhatnagarKshitij Bhatnagar

CHEIKH TIDJANE SAOCHEIKH TIDJANE SAO

Priti SharmaPriti Sharma