Saniya Bansal
Mohali
Summary
Experienced SQL Developer with a strong background in L2/L3 support operations and a proven track record of collaborating effectively with cross-functional teams. Contributed to projects involving the migration of legacy application and database systems over 8 years. Possess 4 years of programming experience as an Oracle PL/SQL Developer, specializing in analysis, design, and implementation of business applications using the Oracle Relational Database Management System (RDBMS). Adept at articulating project requirements and effectively communicating findings to stakeholders, resulting in a notable 20% improvement in project clarity.
Overview
9
9
years of professional experience
Work History
Operations Engineer
Edifecs Technologies Pvt Ltd
09.2023 - 10.2023
- Developed 7 customized Stored Procedures to gather information about various Insurance providers which saved 15 hours monthly
- Curated 7 datasets, extracting valuable insights for senior leadership in healthcare systems
- Knowledge Transfer from Team members on US Healthcare Systems.
Team Lead
Accenture Solutions Pvt Limited
04.2021 - 11.2022
- Identified areas of application performance optimization on Oracle Databases, resulting in a 10% reduction in query execution time and enhanced end-user response time
- Collaborated with infrastructure team members to devise workaround solutions for application limitations, achieving a 12% increase in system functionality by reducing the system crash
- Led a team of 4 resources for application releases into production in migrating the application to Oracle Cloud, including deployment, test and implementation plan
- Ensured error-free data transfer of media product details by developing and executing PLSQL scripts, reducing data discrepancies for 1,000+ records weekly.
Application Senior Analyst
Accenture Solutions Pvt Limited
11.2018 - 03.2021
- Customized existing reports using Oracle BI Publisher to align with user specifications, resulting in a 15% increase in report accuracy and user satisfaction
- Upgradation of legacy middleware and database systems cutting maintenance costs by 8%
- Applied advanced database mechanisms such as triggers, packages, functions, and stored procedures which saved 12 hours monthly on manual data tasks
- Mentored new team members with knowledge transfer to ensure the smooth execution of Business-as-usual activities.
Application Analyst
Accenture Solutions Pvt Limited
05.2016 - 10.2018
- Developed and integrated new Java codes for three existing interfaces as per the client’s requirements
- Designed and maintained comprehensive documentation for seven critical business application components
- Upgraded client application from OMIPM version 3317 to 33201 and WebLogic servers to a higher patch version, improving system stability and performance by 30%
- Prepared and deployed 15 queries and 4 UNIX scripts which contributed to improved workflow efficiency
- Created indexes on tables to improve the performance by eliminating the full table scans and views to hide the actual tables and to eliminate the complexity of the large queries.
Application Development Associate
Accenture Solutions Pvt Limited
11.2014 - 04.2016
- Administered business-as-usual activities and conducted daily system health checks to monitor and maintain the existing client system
- Extracted data from the database according to client requirements, crafting 10-15 complex SQL queries a week
- Wrote Java code for 2 application components as per user’s requirements
- Complied approximately 15 reports from Oracle BI Publisher for user access
- Applied patch upgrades to WebLogic Server every quarter to optimize performance.
Education
B Tech (Computer Science) -
Punjab Technical University
Skills
- OMIPM – Oracle media intellectual Property Management
- Oracle PLSQL
- SQL Developer
- Toad
- Oracle BI Publisher
- Oracle WebLogic Server
- Unix Shell scripting
- ServiceNow
- Putty
- WINSCP
Timeline
Operations Engineer
Edifecs Technologies Pvt Ltd
09.2023 - 10.2023
Team Lead
Accenture Solutions Pvt Limited
04.2021 - 11.2022
Application Senior Analyst
Accenture Solutions Pvt Limited
11.2018 - 03.2021
Application Analyst
Accenture Solutions Pvt Limited
05.2016 - 10.2018
Application Development Associate
Accenture Solutions Pvt Limited
11.2014 - 04.2016
B Tech (Computer Science) -
Punjab Technical University
Similar Profiles
SUMANDEEP KAURSUMANDEEP KAUR
Senior Operations Executive at Edifecs Technologies Ltd.Senior Operations Executive at Edifecs Technologies Ltd.
Dipty VermaDipty Verma
SaaS Operations Engineer at Edifecs Technologies Private LimitedSaaS Operations Engineer at Edifecs Technologies Private Limited
Audry SappAudry Sapp
Sales Operations Intern at EdifecsSales Operations Intern at Edifecs