Jan 2025 – Apr 2025 · 3 mos · Bangalore Urban, Karnataka, India · Hybrid

Jun 2023 – Jan 2025 · 1 yr 7 mos · India

May 2021 – Mar 2023 · 1 yr 10 mos · Bengaluru, Karnataka, India · Hybrid

• Commbiz is an application where business related transactions happen. It is better suited to a business where payments need to be authorized by more than one person. It provides the clients a high level of control over the entitlements of their staff and other delegates. Mostly it’s used to move funds within your accounts, monitor account balance, view transaction details and export information.
• Role:
• Analysis and gathering the Business Requirements.
• Conducting planning, backlog and retrospection meetings and look into people management.
• Interaction with Product owners for clear understanding of business needs.
• Involved in development of new projects, enhancement, bug tasks and support testing by product owners in various environment till rollout.
• Existing sql query tunning and debugging Production issues.
• Ensure all quality related activities are logged and shared.
• Involved in Production bug fixes and supported peers to achieve the SLA’s.

May 2020 – Feb 2021 · 9 mos · Bengaluru, Karnataka, India · Remote

• Description : LifeSphere MultiVigilance is an end-to-end, automated safety system
• that helps hundreds of pharmacovigilance teams around the world save time and effort,
• ensure future-proof compliance and keep global teams aligned.
• This is a migration project from existing Arisg to LSMV application.
• Post migration all the application related customization happened as per the business requirements.
• Role:
• Provide ongoing maintenance and support of database schemas and views.
• Rewritten multiple queries for Performance Tuning.
• Participated in technical discussions and providing feedback depending on the needs of the team.
• Involved in testing, release support and check out process.
• Crated multiple index to enhance performance.
• Ensured compliance with development methodology and technical process.

Aug 2019 – Apr 2020 · 8 mos · Bengaluru, Karnataka, India · On-site

• Sales Data Management: Here we have to deal with asset and transactional data of Business. We manage the data adding business logic and prepare it for Reporting Team.
• Role:
• Develop Extraction, Transformation, Loading (ETL) processes with Informatica Power Center leading to full life cycle development including requirement gathering, analysis, design, development, testing and documentation.
• Worked with logical and physical database designs using model viewer
• Involved in writing the SQL and PL/SQL procedures and program blocks for data extraction, transformation and loading Extensively worked with Transformations like Router, Normalizer, Lookup, Aggregator, Expression and Update Strategy Transformations
• Actively participated in requirement gathering with PO and provided the HLE and LLE.
• Involved in Support and Maintenance of the application.
• Supervised code reviews and ensured the solution met the specifications.
• Used bulk collect in pl/sql to improve performance.
• Supported peers for troubleshooting and issue identification.

Jan 2017 – Apr 2019 · 2 yrs 3 mos · Bengaluru, Karnataka, India · On-site

• MR-Adoption is a process where RDS will access the referential data of MYRIAD applications by trigger and materialized view based approach through db-link. Tables having huge data and frequently updated are part of the trigger based approach whereas tables having less volume and rarely updated are part of the materialized view implementation.
• Role:
• Created trigger, packages as per the business requirement.
• Monitoring db health via OEM.
• Created materialized view logs so that fast refresh can happen easily.
• Tuning the query applying index and partitions.
• Assisted new members with database activities.
• Involved in unit testing of the code.

Mar 2016 – Dec 2016 · 9 mos

• Petra, IFRS9 and Saqarah Extractions: These are the reports generated for different down-streams as per the business. IFRS9, Saqarah and Petra are different clients previously it was known as I-process, which referential data were initially stored in a single DB. Now they need their separate data relevant to each one. So used intelligence on DB to separate their corresponding data for each-one. Created PL/SQL packages for their extraction in starware application.
• Role:
• Actively involved in database design, development & writing business functionality.
• Developed Construction Module and written stored procedures and packages.
• Supported peers for any techincal questions, troubleshooting and issue identification.

Jul 2014 – Mar 2016 · 1 yr 8 mos

• ESI Payment Interface and Master View Creation: It’s an interface between ESI and ARIBA. It sends payment request to ARIBA interface as a.csv file format generated by PL/SQL package. This interface calculates rebate of all drugs. The rebated amount is adjusted through the business validation and calculation is made as net amount.
• Role:
• Developed application code mostly in oracle sql and pl/sql.
• Participated in technical discussions and provided feedback depending on the needs of the team.
• Involved in Support and Maintenance of the application.

Jun 2012 – May 2014 · 1 yr 11 mos · Bangalore Urban, Karnataka, India · On-site