Key Contributions:Healthcare Data Integration: Designed and maintained comprehensive healthcare systems using Oracle PL/SQL, enabling effective patient record management, appointment scheduling, and billing.Automation & Optimization: Automated key processes like medical billing and insurance claims using Unix Shell Scripts, reducing manual workloads and improving efficiency by 20%.Database Performance Tuning: Applied indexing, execution plan analysis, and query tuning techniques to optimize database performance, improving query efficiency by 30%.User Interface Development: Created Oracle Forms and Reports applications for data entry and reporting, enhancing user experience and accuracy.• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.• Worked with the team to design, develop, test & implement the system. Creation of database objects like tables, and procedures using Oracle tools like PL/SQL, and TOAD. Written Stored Procedures using PL/SQL.• Worked in preparing functional documents, user documents, process flow diagrams, and flow charts. • Developed PL/SQL Packages, Procedures, and Functions in accordance with Business Requirements. • Rich experience in writing SQL queries, Views, Materialized views, cursors, collections, Ref cursor, cursor variables, System reference cursor, and Dynamic SQL. • Performed data extract, transform and load between DB2 and oracle using the data stage.• Created DB2 Stored Procedures, called by Web Services to replace VB6 screen scrapers• Created DB2 Stored Procedures, called by Web Services, called by IVR.• Worked as an Informatica developer to design and develop Informatica mapping, to perform the Extraction, Transform, and Load process by studying the business requirement of the users and the mapping documents. • Developed Scripts for the creation of database objects like tables, views, indexes, etc.

Key Contributions:Core Banking Solutions: Developed and enhanced PL/SQL packages, procedures, and triggers for Fiserv’s core banking applications, handling high-volume transactions and financial reporting.ETL Optimization: Led ETL processes with Oracle Data Integrator (ODI) to transform and load large volumes of financial data, improving data processing speed and accuracy.Process Automation: Automated database maintenance and data migration tasks using Unix Shell Scripts and scheduling tools, reducing processing time by 40%.Cross-Functional Collaboration: Worked closely with teams to ensure seamless integration between banking modules and financial reports, contributing to regulatory compliance and audit readiness.• Gather requirements for change requests with the Business team and create design documents. • Provide User Access to Business End Users to the Front-end tools after getting the required approvals • Create PL/SQL packages for implementing Change Requests for adding new functionality to the application. • Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers. • Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries, and SQL Statements with Analytical Functions • Performed SQL and PL/SQL tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE• Extensively used Oracle Hints to direct the optimizer to choose an optimum query Execution Plan• Extensively used Bulk Collection in PL/SQL Objects for improving the performance • Handled errors using Exception Handling extensively for debugging and maintainability. • Automated Oracle and Informatica workflows using Unix Cron Utility in Unix Environment. • Worked on Sessions & workflows for a variety of loads starting from Source to Target.

• Involved in interacting with the end-user (client) to gather business requirements and modelling the business requirements.• Created mapping document between database objects and website objects for both front-end and back-end team to use.• Created database objects like tables, views, synonyms, indexes and sequences.• Analysing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.• Coded complex SQL queries to retrieve data from the database depending on the need.• Created Cursors and Ref cursors to retrieve data needed.• Built and maintained sequences.• Experience in developing various kinds of triggers and used sequences to generate values for surrogate keys in data warehouse tables.• Wrote complex functions to output group ids with complex logic using pre-defined sequences.• Developed other database objects such as indexes and views when needed.• Coordinate with the front-end design team to provide them with the necessary stored procedures, packages and the necessary data.• Provided daily support for multi-task development, and worked on DEV/QA testing and interacting job between DEV/ QA/ PROD environment. Work with QA team to debug/fix issues.• Involved in Unit Testing Stored Procedures and Functions.• Worked with front-end team to handle QA move & Prod move, create moving sheets to make sure FE and BE are in sync.• Creating Problem Ticket, LCM JIRA request for DBA to execute the script in the database.• Use Git and SVN as versioning tool.• End to End application development right from ingesting the data feeds from upstream, Extraction, transformation and loading, Data enrichment using PL/SQL and python.

Project Overview:Contributed to the development and maintenance of Intuit's financial management and accounting applications. Designed and implemented complex database solutions using SQL Server and Oracle, integrating seamlessly with application layers. Leveraged PL/SQL, Unix scripting, and Oracle Integration Cloud (OIC) for ETL processes and real-time data synchronization. Created Oracle Forms and Reports for financial data entry and reporting.Key Responsibilities:Developed database objects like tables, views, indexes, synonyms, sequences, stored procedures, and triggers to manage financial transactions and business logic.Collaborated with front-end teams to provide necessary database integration and maintained synchronization.Built ETL processes to extract, transform, and load data from multiple sources into the data warehouse using PL/SQL and Unix scripts.Created technical documentation, including mapping documents and test cases for QA.Designed and developed ADF-based web applications and custom security modules.Utilized Oracle Integration Cloud (OIC) for real-time data synchronization and ERP integrations.Performed performance tuning for SQL queries and ADF applications.Wrote Python scripts for data processing using libraries like NumPy, Pandas, and SQLAlchemy.Conducted unit testing of stored procedures and functions and coordinated migrations across environments.Automated routine tasks using Unix shell scripting, SQL Loader, and spool jobs.Environment:Oracle 10g, SQL Server, PL/SQL, Unix/Linux, SQL Loader, TOAD, Oracle ADF, OIC, Python, Git, SVN, MS Communicator.

• Developed and maintained complex ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS) for seamless integration with Snowflake.• Worked on Visual Studio / .Net CORE Framework to implement Business Logic.• Created Web API/ REST API for accessing business as JSON object for admin portal.• Worked mainly with Python scripting to code predictive models and data wrangling. Monitored and analysed daily/monthly/quarterly/yearly sales reports to understand product and market trends.• Created and optimized complex T-SQL queries and stored procedures to encapsulate reporting logic.• Manage the end-to-end Middleware functionality and data load in salesforce data loader for Veeva CRM application.• Expertise in writing complex DAX functions in Power BI and Power Pivot. • Designed and documented Architecture of Power BI POC.• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into report.• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle.• Used OAuth authentication in the Asp.Net MVC web pages for authentication against user’s credentials.• Developed SQL/SSIS-based data integration solutions to synchronize Salesforce CRM data with on-premises databases, ensuring seamless data exchange and consistency between Salesforce and internal systems.• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants, and synonyms.• Used different transformations like looping, data formatting, check points, error handling, email notification, etc. in SSIS packages.