Soumyashree Panigrahi
Pune
Summary
Results-driven professional with over 10 years of expertise in SQL/PLSQL development, Oracle Applications (OFSAA/Oracle ERP SCM module), OBIEE, and Oracle Forms and Reports. Proven track record in building customer-focused reports and code functionality through PLSQL collections, packages, functions, and Oracle analytical functions. Strong technical knowledge in data warehousing and design facilitates a comprehensive understanding of business requirements, consistently delivering solutions that prioritize customer satisfaction. Currently serving as a Programmer Analyst at Citi Services India Pvt Ltd, responsible for data design and developing customized solutions while ensuring compliance with banking regulatory standards.
Overview
10
10
years of professional experience
2
2
Certifications
1
1
Language
Work History
Programmer Analyst
Citi Services India Pvt Ltd
01.2025 - Current
- Developing and supporting scalable, extensible and highly available data solutions to support bank’s regulatory requirements.
- Deliver on-critical business priorities while ensuring alignment with wider architectural vision, by applying my technical knowledge of data architecture, data warehousing and business intelligence, which contributed to business outcomes on an agile Team.
- Using Database management, Database design and Data Warehousing concepts to design and deliver Application model thereby achieving cent percent customer satisfaction.
- Deploying the code to specific environment using RLM or Liquibase adhering to organization code standards.
- Planning strategic solutions for branching on GitHub Desktop, ensuring zero to least overwriting of code.
Principal Technical Analyst
Oracle
11.2021 - 01.2025
- Facilitated the implementation of a new software system, resulting in team productivity, using Oracle Forms and Reports.
- Troubleshooting and optimization of the PLSQL script which led to increased performance of the tool and Oracle EBS, ensuring reduction in Incidents.
- Building customized concurrent programs, and reports using the concept of Oracle forms and oracle report builder.
- Knowledge of Oracle ERP, SCM module. knowledge on O2C, P2P workflows. Concepts on Oracle HCM module.
- Working on RCA to enhance new features in the tool and improve scalability.
- Developed and delivered comprehensive technical training sessions for new employees, resulting, a smooth transition for the team members.
- Experience in DBMS_REEDEFINATION, UTL packages and Handing of LOB objects.
- Experience on customer-driven projects, understanding the business from technical and function aspect to achieve a cent percent delivery.
- Concepts on Partitions, indexes, partition pruning, Materialized views.
- Knowledge of AWR report, TKPROF, EXPLAIN PLAN, V$SESSION,V$SQL tables to understand the query plan output and optimize the result as required.
PLSQL Developer
Vodafone Shared Services India
02.2019 - 11.2021
- Building codes using the knowledge of Packages, Procedures, Functions, Triggers, Collections.
- Using the concept of Oracle Analytical functions to develop data driven reports.
- Knowledge on Cursors, bind Variables, Bulk collect, For All Concepts and SQL Query Performance tuning resulting in DB optimization.
- Good understanding on Oracle Architecture and different System views and cloud architecture.
PLSQL Developer
Tata Consultancy Services
07.2015 - 02.2019
- Worked as a team player in implementation of OFSAA for a leading banking Organization. A part of a migration team to upgrade the PFT module from 6.0 v to 8.01 version.
- Concepts on Data-migration, data-backup, DB-links.
- Knowledge on F2ts and T2Ts concept for loading the data.
- Understanding the STAR schema concept, ETL functionalities and data warehousing concepts.
- Using OBIEE to develop various reports as required by the customer.
Education
B.Tech/B.E. - Computers
Biju Patnaik University of Technology (BPUT)
01.2015
12th - undefined
01.2010
10th - undefined
01.2008
Skills
Oracle 11g (SQL/PLSQL)
Performance Tuning
SQL
Data Analytics
Java
Oracle Cloud Infrastructure
Oracle HCM Technical Consultant
undefinedCertification
Oracle Database SQL 12c Associate
Timeline
Programmer Analyst
Citi Services India Pvt Ltd
01.2025 - Current
Principal Technical Analyst
Oracle
11.2021 - 01.2025
PLSQL Developer
Vodafone Shared Services India
02.2019 - 11.2021
PLSQL Developer
Tata Consultancy Services
07.2015 - 02.2019
12th - undefined
10th - undefined
B.Tech/B.E. - Computers
Biju Patnaik University of Technology (BPUT)
Similar Profiles
PURNENDU MITRAPURNENDU MITRA
Test Manager VP at Citi Services India Pvt Ltd (CSIPL)Test Manager VP at Citi Services India Pvt Ltd (CSIPL)
Amit SrivastavaAmit Srivastava
Vice President - In Business Franchise Risk - Risk Monitoring Unit at Citi Services India Pvt LtdVice President - In Business Franchise Risk - Risk Monitoring Unit at Citi Services India Pvt Ltd
Ankit JainAnkit Jain
Assistant Vice President at Citi Services India Pvt. Ltd.Assistant Vice President at Citi Services India Pvt. Ltd.
Khushboo PanchalKhushboo Panchal
Partner Success Manager at ConnectWise LLPPartner Success Manager at ConnectWise LLP
Abhijeet KulkarniAbhijeet Kulkarni
Sr. Technical Leader at KPIT TechnologiesSr. Technical Leader at KPIT Technologies