Information Technology Sql Developer

Renuka Surikanti

Senior Database Engineer

Phone: 201-***-****

Status: Permanent Resident/ Green Card (GC)

Email: ******************@*****.***

Summary of Experience:

Around 20 years of total IT experience in Business Requirements analysis, Application Design, Data Modeling, Data warehousing, Coding, Development, Tuning, Testing, Oracle EBS, and implementation of business applications with RDBMS, SQL, PL/SQL, PostgreSQL, Oracle Reports, UNIX Shell scripting, Java, and J2EE.

Expertise in PostgreSQL, Oracle 19c/11g/10g/9i/8i/8. x, Oracle 9iAS, Oracle 10g AS, Oracle Forms, and Oracle Reports.

Extensive experience writing SQL Queries, PL/SQL procedures, functions, packages, Triggers, Views, materialized views, and frontend Java.

Expertise in database migrations and working in an AWS cloud environment.

Well-experienced in Extracting, Transforming, and Loading (ETL) data for a data warehouse, and data migration using Excel spreadsheets and flat files (CSV) data, and other data conversions.

Worked on DML, DDL, TCL operations, and used DLLs.

Experience in data modeling with SQL Data Modeler and the Visio tool.

Expertise in designing reports and forms using Reports 6i, Discoverer and Forms 6i/9i.

Expertise in UNIX shells Scripting using Korn, Perl, sed, awk, and scheduling using crontab.

Proficient in Oracle Tools and Utilities for Extraction, Transformation, and Loading (ETL) such as Toad, DBArtisan Tool, SQL*Loader, Data Pump, Informatics, and UTL_FILE.

Worked in Java, Servlets, and Struts Framework using JDeveloper.

Experienced in Database Optimization techniques like Performance Tuning or query tuning for Oracle RDBMS using Explain Plan and TkProf.

Experienced in Oracle RICE (Reports, Interfaces, Conversions, and Extensions) development.

Worked in an Agile environment.

Worked on financial modules such as accounts payable, accounts receivable, purchase orders, and general ledger.

Adept at meeting deadlines, working under pressure, and managing multiple tasks simultaneously.

Possess excellent communication skills and a smooth client handling and interaction with end-user experience.

Strong proficiency in problem solving, Initiative taking, Time management.

Education Qualification:

Master of Science in Computer Science & Engineering, Osmania University, India, 2005.

Bachelor of Engineering in Computer Science & Engineering, Osmania University, India, 2002.

Achievements:

Received OCA (Oracle Certification Associate) (SQL, PL/SQL, Reports, and Forms) Certification.

Received SCJP (Sun Certification Java programming) Certification.

Technical Areas of Expertise:

Platforms

Windows 95/98/2000/NT/XP /Pro, UNIX, and Linux

Languages

SQL, PL/SQL, UNIX Shell ( sed, awk, korn) Scripting, Python, Perl Scripting, Java, J2EE, ADF, .Net, and COBOL

Databases

PostgreSQL, Oracle 8i/9i/10g/11g/19c, PostgreSQL, MS Access and SQL Server, Sybase

Tools

Forms 6i/9i, Reports 6i, TOAD, SQL Developer, DB Artisan, DB Visualizer, Visual Studio, Quest, Visio, Crystal Reports, Rapid SQL, Informatica 7.1, Erwin, Fogbugz

Utilities

SQL* Loader, Data Pump, Developer, SQL Navigator, Informatica, Formatter Plus, CVS, PVCS, Perforce

Technologies

ODBC, JDBC, ADO, EDI

Web Tools

HTML, XML, web toolkit, Mod PL/SQL, ASP, VBScript, and JavaScript

App Servers

Oracle 9iAS, Oracle 10g iAS,Apache, OC4J,IBM-Web Sphere, IIS, and Web logic

ERP

Oracle Apps R12/11i: OM, INV, PO, AR, AP, GL, AOL

WORK EXPERIENCE:

USDA&GSA Database Management Specialist III June’22 - Present

Project: Conexus

Responsibilities:

Perform requirement analysis, system design, coding, testing, and support of applications.

Updated design and developed data model for existing and new systems.

Extensively worked on migrating all objects(Tables, sequences, views, Materialized views, Packages, procedures and functions) from Oracle 19c to PostgreSQL.

Created Oracle Packages, functions, and procedures as part of development.

Closely worked with the QA team to resolve post-production issues.

Worked on Reports, views, and materialized views.

Provided input of database objects and required schema changes to make consistent across both source and target databases.

Worked closely with Quality Assurance (QA) and Customer Support teams, including troubleshooting/fixing bugs/issue management.

Followed standard software development methodologies and SDLC and Agile practices to produce high-quality applications efficiently.

Worked on flexible hours and quick deliverables.

Provide process/technical training for the QA team to meet their project deadlines and DB support to developers.

Worked as a key team player in multitasking and supporting different team members.

Agile team environment, Communication, Change Management, and Collaborative Working.

Worked on job scheduling and batch processes scripts.

Environment: PostgreSQL, Oracle 19c, pgAdmin4, SQL Developer, VMware Workstation, GIT, Bitbucket, AWS RDS, UNIX, Putty, and FileZilla.

ConnectiveRx, Whippany, NJ Sr. Engineer, Application Development July’18 - Jun’2022

Projects: Buy & Bill Projects

Responsibilities:

Gathering requirements, system design, implementation, testing, deployment, and support of applications.

Participated in software design and design review, and contributed to Software Design Documentation (SDD).

DBA experience with strong SQL and PostgreSQL.

Updated design and developed data model for existing and new systems.

Worked on database setups for various clients (Pfizer, Takeda, Bayer, Amgen and Genentech products etc..) in AWS environments for different copay and procedural programs.

Worked on AWS ADF 1.0/2.0 Reports, triggering lambda, creating test events and scheduling reports in cloud watch in PCI/NON-PCI products.

Worked on development to support various types of patient enrollments, claims (Medical claims and PBM claims) and payment system.

Closely worked with the Help Desk team to help patients by resolving post-production issues.

Worked on Production release management /deployments.

Worked on ETL Reports using SQL queries, ADF, Dynamo DB and Lambda.

Worked on Adhoc-Reports.

Created database objects and required schema changes to make consistent across all products.

Worked with Quality Assurance (QA) and Customer Support teams, including bug tracking/issue management.

Performed end-user and technical support to a wide range of executives, management, and staff members.

Followed standard software development methodologies and SDLC and Agile practices to produce high-quality applications in an efficient manner.

Effectively manage multiple project deliverables concurrently.

Worked on flexible hours and quick deliverables.

Worked on DB checkouts for AWS patches.

Provide process training for new employees and DB support to developers and the QA team to improve their performance and meet project deadlines.

Worked as a key team player by participating in multi-tasking, multiple projects, and supporting different team members.

Agile team environment, Communication, Change Management, Commitment to Customer Excellence, Collaborative Working.

Problem Solving. Ability to identify trends and propose solutions to reduce production support demand.

Job scheduling and batch processes.

Environment: PostgreSQL,pgAdmin4, AWS RDS, Python 2.7.5, UNIX, Visual Studio, Azure Devops, Putty, and FileZilla.

Client :Samsung SDSA, Ridgefield Park, NJ Sr. Database Developer Feb’16-Jun’18

Projects: FSM+ and FMO

Responsibilities:

Perform requirement analysis, design, coding, and testing of required modules for the project.

Create and maintain the required SDLC documents needed for developing software modules.

Support the post-production processes to ensure the appropriate functioning of the deployed work products.

Worked on Cursors, Ref Cursors, Collections, Hints, Bulk Collect and PLSQL tables to improve the performance while working with thousands million rows of data.

Created required Oracle tables, indexes, Triggers, views, materialized views, global temporary tables, synonyms.

Worked on development of new modules, change requests, bug fixes and enhancements in existing code.

Provide timely status updates on project activities.

Writing Business logic for Batch jobs, packages and procedures.

Performance Improvement of Samsung applications by Query optimization.

Performed Unit and integration testing of Target data.

Data load, analysis, and query changes as per the requirement.

Sales dashboard implementation for fsm view, district view, region view and national view.

Mentoring team members in database concepts and helped other teams by resolving the database issues and tuning queries.

KPI dashboard report implementation.

Meet tight deadlines.

Environment: Oracle 11g, SQL Developer, MACH Framework, Weblogic server, MS SQL 2012 R2, Tomcat 7.0, Java, SQL Data Modeler, JIRA, SVN, Eclipse.

Client: Ralph Lauren, NYC, NY Sr. Oracle Developer sMay’ 15- Feb ’ 16

Project: Everest

Responsibilities:

Worked on gathering and analyzing the requirements for BDM(Base Data Management) by inviting various department team members to the meeting.

Worked on Functional specification documents and detailed design documents for Reports in the departments of Digital Operations, Planning, Financial, and HPD.

Designed the master tables for BDM.

Worked on developing packages, procedures, functions, created tables, constraints, PL/SQL tables, sequences and views.

Written shell scripts to run all the processes in sequence.

Developed control files to load the PMC data feed in BDM staging tables.

Developed code for Demand sales Report, Hourly Sales Report, and NOW(Not on web) Report.

Helped the QA team by explaining the requirements and developing the code.

provided queries to QA team to test the developed process.

Worked on tight deadlines.

Communicated with OMS and Hybris team members to gather the mapping information required for the reports by inviting them to meetings.

Worked on SQL queries to develop the reports.

Meet tight deadlines.

Environment: Oracle11g, Putty, UNIX, Linux, SQL Data Modeler, JIRA, CVS.

Client: Fidelity, NJ Sr. PL/SQL Developer Jul'13- Sep’14

Project: PB Optimize

Responsibilities:

Worked on analyzing the requirement and designing for PBO(prime brokerage optimize) project

worked on Ingestion, Performance attribution(PA).

Developed code for security matching process using SEDOL, CUSIP, ISIN, and ticker.

Developed required reports for shorts and long positions for the business.

Developed code for PA calculations for shorts and long positions.

Developed code for security master changes by normalizing the existing process.

Worked on developing packages, procedures, functions, created tables, partitioning tables, indexes, constraints, PL/SQL tables, sequences, synonyms, and views.

worked on partitioning tables, used sql loader and external tables to feed data as part of ingestion process.

Created Oracle jobs using Oracle Job Scheduler and scheduled jobs as per the requirement.

Done research on event based jobs, created agent and created jobs for PA.

Created required UI procedures for the application in Position, broker and security pages.

Worked on performance tuning by checking explain plan for the sql queries.

worked on the ingestion process to the UI level.

Helped the QA and support teams by explaining the developed code and solving prod and UAT issues by fixing bugs.

provided check queries to QA team to test the developed process and provided supports packages to support team.

worked on process to keep held security information and removed unheld ones as part normalization.

used pl/sql tables to improve the performance.

developed packages to migrate provider data, client data for shorts, longs, and indications.

Worked closely with DBA.

have meet the tight deadlines.

Environment: Oracle11g, SQL Developer, UNIX, Linux,Putty, SQL Data Modeler, Quality Center, CVS.

Client: New York City Fire Department /FDNY, NY Sr. PL/SQL Developer Nov’12-Apr'13

Project: RBIS Application

Responsibilities:

Worked on analyzing the requirement and created the task list in RBIS application.

Developed PL/SQL Packages, Stored Procedures and Functions for CDA and Child Care Inspection.

Utilized advanced features available in Oracle 11g to improve the performance.

Created required tables, views, triggers and indexes.

Worked on Oracle Exadata for child care inspections.

Worked on PL/SQL development for enforcement actions if existed for CDA and Child Care Inspections.

Developed the UNIX Shell script automated the process of loading the Connection Pool data using SQLLDR and scheduled daily using CRONTAB utility.

Partitioned the tables to improve the performance.

Analyzed the DIVISION Schedule documents received from the user and Developed SQL Scripts for Divisions (3, 8, 11, 13 and 14) deployment.

Developed a Data model for the Childcare Inspection Process using SQL Data Modeler.

Written Test Scripts for CDA Change request Page, Manully Loaded CDA Building page and Daycare project.

Developed SQL queries to develop Pre-Inspection and Post-Inspection Reports.

Worked on performance tuning for SQL and PL/SQL code.

Worked on production support.

Done unit testing for developed SQL and PL/SQL code.

Environment: Oracle11g,UNIX Shell scripting, TOAD,SQL*Loader,Linux,Putty, SQL Data Modeler, Quality Center, Perforce

Client: Investor Analytics, NY DB Migration Lead May’12-Oct’12

Project: DB Migration

Responsibilities:

Analyzed the requirement and created the DB Migration project plan.

Created the Oracle SQL scripts, PL/SQL Procedures, functions and triggers from Postgres SQL scripts.

Done SQL query tuning and optimized PL/SQL code.

Worked on Import, Scan, mapper, Value Account and Value Composite account.

Worked on Value drill process.

Created DB Reports, Jasper Reports and CSV reports

Created check queries for comparison and reused the queries for same functionality.

Written shell scripts to run all the processes in sequence.

Tested all java processes involved in project and sql processes.

Done documentation.

Used GIT and SVN repositories.

Created Cases in fogbugz and assign work to team members.

Created the performance matrix for Oracle and Postgres sql databases using job log.

Working in Agile environment, Following sprint planning and tight deadlines.

Environment: Oracle10g, PostgreSQL, UNIX Shell scripting, Linux, Visual Studio,Fogbugz,Java,Spring framework,Hybernate,GIT,SVN.

Client: Barclays Capital, NYC Sr. Oracle PLSQL Developer May’11-April’12

Project: Conversion to Oracle

Responsibilities:

Involved in meetings to receive the client's requirements and analyzed based on available system resources and business rules.

Developed required Oracle PLSQL Packages, Stored Procedures, Functions for PNL in Credit Risk Management which is migrated to Oracle11g from Perl code interacting with Sybase.

Migrated the SFF (Security Funding Framework) 2nd phase procedures from Sybase to Oracle.

Ran the Production Credit Liquidity reports (CLR Trsy and CLR Credit by connecting to Oracle database from Excel.

Created workflow (Support document) of Autosys jobs in each box.

Worked on Cursors, Ref Cursors, Collections, Hints, Bulk Collect and PLSQL tables to improve the performance while working with thousands million rows of data.

Created required Oracle tables, indexes, Triggers, views, materialized views, global temporary tables, and synonyms.

Worked on Curves, tenor, and amounts related procedures, converted the above code to Oracle to send the output to the front end (.Net framework), and optimized the code by removing temporary tables.

Optimized the code in Oracle while migrating from Sybase to Oracle.

Received the Data Warehouse feed files daily, weekly and loaded into Oracle tables using SQL Loader and DBArtisan tools.

Helped the team in Oracle concepts.

Tuned the sql queries usng Explain Plan and toad debug utility.

Tested Credit Liquidity Risk data and maintained the code.

Written stored procedures for SFL (Security funding limit) which were migrated from Sybase to Oracle.

Optimized the balance sheet procedures.

Done unit testing, integration testing.

Worked with DBA team.

Provided production support.

Managed offshore team.

Environment: SQL, PL/SQL, Oracle11g, Sybase, UNIX Shell scripting, Linux, Visio tools, .Net Framework, C#, DBArtsan, TOAD, SQL*Loader, Perforce, SQL*Plus.

Client: Edward Jones, St. Louis, MO Sr. Programmer Analyst Nov’08-April’11

Project: Data Migration and Reports

Responsibilities:

Involved in the business requirements gathering and analysis, understanding client’s requirements and system analysis.

Analyzed business process workflows and developed procedures for moving data from source to target systems.

Extensively involved in developing various PL/SQL Packages, Functions, Stored Procedures, Triggers and views in VLDB

Extensively worked on Cusrors, Ref cusrsors, indexes, triggers, collections and bulk collections.

Developed Linux Scripts to automate data manipulation and data loading procedures.

Used Data Pump utility for exporting and importing data.

Developed scripts for loading data from various systems using UNIX Shell, Oracle, PLSQL, SQL*Loader.

Used ETL tool informatica for extracting, transforming and loading the data.

Involved in Performance Tuning using various tools provided by Oracle like SQL Trace and Explain Plan.

Created indexes, views to improve the performance of Pl/SQL procedures.

Provided technical leadership and complete complex system level assignments.

Developed and modified complex procedures considering equipment capacity and limitations.

Formulated and defined system scope and objectives.

Prepared detailed software specifications and test plans.

Provided quality assurance reviews, conducted meetings with IS Management and end users.

Done research and prepared system time/cost estimates.

Performed Unit and integration testing of Target data.

Environment:SQL,PL/SQL,Oracle10g,SCCS,UNIX Shell scripting,Linux Shell scripting, slick Edit,TOAD,Informatica, XML, SQL*Loader,SQL*Plus.

Client: CIENA Corporation, MD Oracle Developer Feb’08-Oct’08

Project: Oracle Applications Implementation

Responsibilities:

Gathering requirements, identifying business rules, and preparing technical specs based on user requirements and use cases.

Worked on logical and physical data modeling.

Worked on stored procedures and triggers.

Developed several Oracle Objects PL/SQL Packages, Procedures, functions to implement the business logic based on the type of labels for different customers.

Developed the Oracle Form for ship validation which will validate the correct numbers items shipping for each delivery or not.

Created and managed stored procedures, indexes, views, user defined functions, triggers, database constraints to meet business requirements and policies.

Worked on Cusrors, Ref cusrsors, collections and bulk collections.

Developed Oracle reports and integrated with RTF files to get the required format properly.

Developed XML Reports, Discoverer reports.

Improved Query performance by using EXPALIN PLAN and TKPOF and SQL Trace tuning tools.

Developed UNIX Shell scripts using Kshell, awk, and sed execute the PL/SQL procedures and trap the errors, and send mail using Mailx utility

Created indexes, views and materialized views to improve the performance of Pl/SQL procedures.

Performance tuning of SQL, PL/SQL Procs using Explain Plan.

Debugged the PL/SQL procs using Toad debug utility.

Created Test plans for Unit Test, Regression Test, and UAT and reviewed the test cases with the Project Manager...

Done Data conversions for financial data.

Environment: SQL, PL/SQL, Reports 6i, Oracle 10g, UNIX Shell scripting, Forms 6i,Discoverer Reports, XML Publisher Reports, SQL Navigator 5.0, Java, J2EE, Quest Software, TOAD, EJB, SQL*Plus, SQL*Loader, Oracle Applications 11i (OM,INV, Shipping, Publisher Administrator).

Apps Associates, Hyderabad, India Oracle Developer Aug’05- Feb’07

Client: Smiths Medical, St Paul, MN

Project: Oracle Apps 11i implementation (Legacy system conversion and Reports):

Responsibilities:

Involved in high-level design, development, and implementation of all the interfaces.

Prepared program specifications for PL/SQL Packages, procedures, and functions to do the data cleansing, migration and conversion.

Designed and developed Oracle reports in modules involved in Order to cash flow.

Developed Control Files for loading staging tables from Flat Files using SQL*Loader.

Developed Pl/SQL Packages, procedures, functions to validate third party shipment file before posting into Store Order Processing System.

Wrote and integrated stored procedures to generate the special reports according to the client’s needs.

Participated in Performance Tuning using Explain Plan and TkProf.

Developed pseudo-XML for the inbound interface using Informatica Designer.

Have done UNIX shell scripting korn, awk, sed to process the data and scheduled them to run using crontab utility

Participated in Performance Tuning using Explain Plan and TkProf.

Performed Unit, Regression, System test, and document test plan and test results.

24/7 on-call production support

Converted financial data and inventory data.

Worked on tuning the SQL Queries by code review.

Developed and customized the front-end interfaces for the users, using Forms 6i

Environment: SQL, PL/SQL, Oracle 10g, Oracle 9i AS, SQL*Plus, UNIX Shell scripting, Informatica, Reports 6i, Forms 6i, JDeveloper, XML, EJB, Quest Software, SQL*Loader, TOAD, Oracle applications 11i (OM, INV, AP, AR, GL).

Project: Ship Console: Ship Console is an on top of Oracle applications product in Apps Associates; it is useful for any Supply Chain Organization.

Responsibilities:

Analysis of the specifications provided by the clients.

Created custom tables and triggers.

Worked on data modeling.

Developed Packages, procedures and functions to retrieve data from Oracle apps tables and updated in custom tables of the product.

Created the Pl/SQL tables, Varrays and Records.

Worked on performance tuning on existing stored procedures and reports for faster processing of reports.

Used the TOAD tool for data modeling and designed ER-Diagrams for the product.

Developed the PL/SQL package and called the public API’s to ship confirm, wrote a Shell script to call OS commands from Java.

Designed and developed Oracle Reports to display product information in the required format.

Developed the code in Java, given the Database connection, and integrated the database package with the JSP front page of the Ship console product.

Developed front page using HTML and JSP code for AD-Hoc orders.

I have written JavaScript to validate business logic.

Tested the print labels and performed tuning of SQL Queries.

Provide the functional inputs to the Tech team for enhancements / Bug Fixes, etc

Environment: Oracle 9i, Oracle 10g, SQL, PL/SQL, Quest Software, Oracle Applications 11i (Order Management), Apache Server, Tomcat, UNIX Shell Scripting, Java, J2EE, XML, HTML, JSP, EJB, SQL*PLUS, SQL*LOADER, Toad, Rational Clear Case, UNIX, Discoverer 4i, Oracle streams, PL/SQL, Reports 6i, Forms 6i.

Project: EMS (Expense Management System ) Client: Kaz, NY, USA

Kaz believes the company's growth and prosperity depend on its employees' motivation, successes, and achievements. We also feel that it is essential for all employees to work together as a team to guarantee success.

Responsibilities:

Created the PL/SQL procedures and packages for the automation process of sending the notification to the manager to approve or reject the invoice.

Created the triggers to remove the hold on invoices if invoices are approved, or to retain the hold if invoices are rejected by the manager, and developed a form to show the information.

Created purchase orders and invoices for each purchase order to test the process.

I worked on the attachments to send the invoice attachment to get approval from a manager.

Created hundreds of attachments in the testing process.

Created hundreds of purchase orders and invoices against the Pos while testing the process.

Customized the product as per their requirements.

Solved the issues in the production instance.

Environment: Oracle9i, UNIX, SQL, PL/SQL, SQL*PLUS, TOAD, SQL*Loader, Forms 6i.

Project: Oracle reports, Discoverer Reports Client : Peach Direct, Los Angeles, CA

Responsibilities:

Designed and developed 20 Oracle Reports as per the requirement.

Developed some of the reports in Discoverer.

Displayed the information related to Sales orders, Customers, Purchase orders, and vendors.

Created the DFF fields and assigned the values to the DFF fields

Worked on Oracle 10g database for Discoverer reports.

Created the concurrent program for each report.

Created the required parameters for the reports, assigned the default values provided by the client, and tested. Environment: Oracle Reports 6i, SQL, PL/SQL, Oracle 10g Database, Oracle 10g AS, Discoverer Reports, TOAD, SQL Navigator, Formatter Plus, Oracle Applications

Contact this candidate