Saswati Bandana Sahoo
Bhubaneswar
Summary
- 8.4 years of experience in IT Industry as an SQL and PLSQL developer. Currently working with WIPRO Limited Bangalore. Experience with SQL, PL/SQL coding for creating packages, stored procedures, triggers, functions, UNIX Shell Scripting, Partitioning, Indexes, table design by following Normalization. Ability to write Complex and difficult SQL queries. Extensive experience on SQL Performance tuning. Experience in development, implementation and bug fixing in banking domain applications. Knowledge on database design – Creation of data models, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of the DB. 24
- 7 Production support to applications & end users. Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment. Experienced in development of E-LT and ETL Mapping in Oracle Data Integrator. ETL jobs creation & customization using Oracle Data Integrator (ODI). Interact with the customer through conference calls.
Overview
8
8
years of professional experience
Work History
PLSQL Developer
Wipro Technologies
Bangalore
03.2017 - Current
- As a PL/SQL developer my responsibility is to deliver the project according to the client requirements on time.
- Handling the PL SQL development team and working with the team to Expertise in solving problems on complex SQL queries.
- Working as PL/SQL developer for 24 / 7 production support to load the data from upstream and downstream systems, maintains day to day data with proper control mechanism and controlling the data growth in 150 TB database.
- Providing daily reports to business users by following the SLAs.
- Analyzed and provided RCA for various issues / incidents in production.
- Troubleshot and applied permanent fixes for production issues.
- Prepared reconciliation steps to validate the data before delivering to the business.
- Implemented multiple dynamic mappings/workflows and SCD2 Logic.
- Resolved production issues by modifying backend code as and when required.
- Performed the unit testing, system integration testing and assist with user acceptance testing.
- Adapt ETL code to accommodate changes in source data and new business requirements.
- Ensure compliance with regulatory requirements for data transmission, storage, and data access including documentation, testing, and remediation.
- Created new Packages for new business requirements.
- Worked in Error handling and tracking, by handling the exceptions and inserting the errors into log tables.
- Coding as well as bug fixing through Debug.
- My first project is called as Payroll Processing System(PPS).
- Project is mainly focuses on employees payroll processing.
- Payroll processing covers salary calculation, IT, additional components calculations.
- Project have two independent web applications.
- This is mainly for employees to declare IT components, IT Proof submission and fetching payroll reports such as Payslip, Form16, PF,Pension, QPLC,etc.
- In addition, mobile applications also developed for payroll web apps.
- Support activities for monthly payroll did posting and generated Payslips.
- Worked on Restoration Drill and DR Drill activities.
- Worked on Payroll Genie reports.
- Provided timely response for helpline tickets.
- Supported for Installation applications on clients system.
- Supported for sending Payslips, IT Proof Submission, Salary Register Report as per request.
Education
M TECH - IT
VIT University
Skills
- SQL
- PL/SQL
- Oracle 19c
- Oracle 12c
- Oracle 12c Data Integrator (ODI)
- Oracle Business Intelligence Enterprise Edition (OBIEE)
- Oracle SQL Loader
- PL SQL Developer
- Informatica PowerCenter
- UNIX Shell Scripting
- UNIX
- AIX
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge.
Personal Information
- Gender: Female
- Marital Status: Single
Languages
English
First Language
Hindi
Proficient
C2
Timeline
PLSQL Developer
Wipro Technologies
03.2017 - Current
M TECH - IT
VIT University