SUMMARY

• Oracle PL/SQL Database Developer with over 8 years of international experience in implementing the full lifecycle of Database Development, Conversions, Migrations and Data Warehousing to suit client business requirements
• Extensive experience in Oracle 12c/11g, Oracle 12c reports, Oracle Forms, SQL, PL/SQL and working with third party database tools like TOAD, Oracle SQL Developer, SQL Plus
• Hands on experience in writing SQL Queries, PL/SQL Packages, Functions, Procedures, External Tables, Views, Materialized views, Indexes & Triggers, Cursors, Ref Cursors and Dynamic SQL to implement business logic
• Skillful in creating ETL packages to extract data from a variety of sources, transform and integrate it into a data warehouse/data mart model
• Proficient in production support, performance tuning using AWR reports and Explain plans, unit testing and bug fixing to provide high quality deliverables
• Competent in developing Unix Shell scripting and Perl Scripting for automation
• Efficient management skills in delivering projects autonomously, leading teams and mentoring junior associates

TECHNICAL SKILLS

• Databases: Oracle 10g/11g/12c, SQL Server
• Oracle Applications: Oracle Applications (EBS) R12 12.1.3,12,2,2, 11i 11.5.10/11.0.3, Oracle Apex
• Scripting: SQL, UNIX Shell Scripting and Perl Scripting
• GUI: Oracle Forms and Reports 11g/12c, BI Publisher, XML Publisher, OAF
• Languages: C, SQL, MySQL, PL/SQL, MongoDB, HTML, CORE JAVA, XML, SAS
• Cloud Technologies: HDFS, MapReduce, Hive, Pig, Zookeeper, AWS, Salesforce
• Tools: SQL Developer, PL/SQL Developer, SQL Loader, SQL plus, TOAD, Putty, Developer2000, Discoverer 10g, ETL Informatica, QlikView, ClearCase, ClearQuest, HP PPM,Eclipse, Numara, Oracle Enterprise Manager, Subversion
• Operating Systems: Windows 98/2000/XP/Vista/Win7, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Maryland, USA

Senior Oracle Application Developer

• Managed a $500K project to modernize and enhance the Port Commercial Transportation Management system
• Developed a way to replace mod plsql DAD (Database Access Descriptor) with ORDS (Oracle Rest Data Services) using a secure gateway to the database for accessing the image files(blobs)
• Remapped form workflows to move file processing from JBeans on the application server to the database server using webutil calls and created shell scripts to schedule batch jobs and generate reports using Crontab
• Developed a secure way to access mVisitor and Gate pass system applications using DBMS CRYPTO package
• Upgraded Oracle12c application and migrated forms and reports from 11g to 12c
• Developed a Salesforce app to authenticate profiles and establish ‘Salesforce to Outlook’ sync configuration
• Performed unit testing, root cause analysis and bug fixes for data corruption issues
• Evaluating and designing a migration plan for moving Oracle Forms applications to Oracle Apex

Confidential, Maryland, USA

Senior Oracle Database Developer

• Managed adverse event reporting system servers for Confidential using Oracle Enterprise Manager (OEM) and developed Oracle reports to report adverse events for drugs(protocols)
• Developed Oracle Forms for Confidential client evaluation assessment and fixed bugs
• Led a team in Confidential to develop queries for Web Services team and resolve QA testing issues
• Automated the processes to import medical patients’ data from multiple sources through SQL loader
• Developed SQL Scripts, Stored Procedures, Functions and Packages using PL/SQL and involved in code reviews
• Worked on extracting and loading large datasets using Informatica ETL

Confidential,

Senior Oracle E - Business Suite Techno-Functional Consultant

Responsibilities:

• Created Interface to generate invoices in Payables based on expense reports data for Expense Reporting & Employee Credit Cards (Known as Gcard)
• Configured and supported the expense reporting tool ‘Concur’ and customized the Outbound interface in PO module to send Payment Confirmation details file to Concur
• Coordinated with Citibank for payment solutions, Citi Direct, CFX (Citi File Exchange) & Wells Fargo Payment Gateways along with 170 Mark View Invoice Process Application Maintenance and upgrades
• Established the required setups for creating a new entity for payment gateways
• Enhanced and maintained requisition approval and PO approval workflow for client specific tool ‘PIVT’ (used in place of iProcurement) in Procurement Operations
• Worked on Enhancements, Maintenance and Bug Fixing of Procure to Pay modules in Oracle Applications 11.5.10.2 - Purchasing, Payables
• Developed high performance advanced SQL queries using Collections, Nested tables, REF Cursors and Analytic Functions
• Provided custom extensions and customizations to support Google's requirements and developed feature requests for existing objects, enhancing AP, PO custom modules, fixing issues in Procure to Pay cycles

Confidential

Senior Applications Engineer

• Implemented statutory changes in tax reports as per the directions of Income Tax and Service Tax Departments of Confidential, improved the efficiency of codes, resolved bugs and setup related Issues
• Handled the upgrades from 11i to R12 and 12.1.3 to 12.2.3
• Developed Forms, Reports, Procedures, Functions, Indexes, Triggers and Packages and prepared unit test plans
• Interacted with the clients on a regular basis, conducted feasibility analysis for all business requirements and resolved service requests and performance bugs to improve product efficiency and customer satisfaction
• Led the China team in designing and developing codes for withholding
• Created Technical design document for withholding regime
• Maintained the internal forums for techno-functional questions and provided an interactive platform

Confidential

Developer

• Created a command line interface to detect memory leaks in android app by collecting the native information and establishing a socket channel with device
• Created a HTML based web portal to interact with the PERL script