SUMMARY:

• Oracle Certified Application developer with 10+ years of experience in oracle Technologies having diversified experience in the area of Energy, Oil and Gas, Security, Financials, Construction, Manufacturing, Medical and Biotechnology area with added skills in Access, Visual Basic, JavaScript, HTML, Java and SQL Reporting Services and SSIS and ETL tools and Data warehouse with complete SDLC experience with end to end implementation.

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12c, SQL Server, Access

GUI/Tools: Developer Forms 6.0, 6i, 9iDs Oracle Reports 6.0, 6i, Oracle Developer Suite

10g, Discoverer, Jdeveloper, JBuilder Toad, Procedure Builder, SQL

Navigator, SQL Loader, Rapid SQL, Crystal Report, SQL Reporting ServicesPVCS version manager, ClearCase, ClearQuest, Remedy, Visual SourceSafeSSIS, SSRS

Portal Development: Visual Basic 6.0, Microsoft.net technology

Applications: Oracle EBS R12.2.4, AR, AP, CRM, GL, FA, iProcurement, Getpaid, VertexServiceNow, Transportation System, Custom Billing System

Web Servers: Oracle Application Server, Tomcat, Apache, Microsoft IIS server

Computer Languages: PL/SQL, .NET, Visual Basic, HTML, XML, JavaScript, Java and visual C#, Python

Operating Systems: Unix, Linux, Windows10, Windows Server

WORK EXPERIENCE:

Confidential

Team lead/Solution Architect

Responsibilities:

• Technical lead for iProcurement, Vertex user tax, AP automation. Worked with implementation team and removed many obstacles on the way, helped implement Vertex user tax.
• Technical lead for successful implementation of r12 EBS and Tax software and Vertex indirect tax.
• Implemented API between ServiceNow and Oracle through SSIS integration for customer, site and pricing data from oracle master data.
• Developed several SSRS reports for reconciliation of data between Service Now and Oracle EBS.
• Trained in Power BI and involved in providing necessary data for tableau and qlikview for the company.
• Lead Complete billing automation of Confidential Cash Management System into oracle AR system. This project when completely rolled out into all branches has a projected savings of 12 million dollars per year.
• Lead an integration project between oracle and Ortec route optimization software to completion
• Lead Coinstar Data import/ticketing and billing integration to Oracle to completion
• Lead Implementation and support of Sungard Get Paid TM collection system with data feed from Oracle AR system through daily ETL. This project was implemented on time and well within the budget with projected recouping of cost of investment ahead of time.
• Involved in ATM Access control project and developed very efficient, simple but powerful front end interface that received rave reviews from the customers.
• Supported Month end invoicing support and identified and resolved many issues with the invoice process.
• Provided extensive support for oracle 10g Upgrade and performance enhanced various modules.
• Took ownership of change tendering form and developed new oracle workflows to support it.
• Provided valuable data analysis to the team and identified increased source of revenue generated from handhelds from premise time.
• Identified and rectified a billing bug in the systems, reversing a revenue loss of 15k per month.
• Developed numerous business critical oracle reports.

Tools: and Technologies used: Oracle R12 EBS 12.2.4, Oracle 11i EBS, Oracle Database 11g, SQL Server 2013, Oracle Forms and Reports, SQL Server reporting tools, PL/SQL, Oracle Workflow

Confidential

Senior Application Specialist

Responsibilities:

• Production Support: Solving day to day problems and taking on call support on a rotation basis.
• Receiving the product patches from the vender and applying the patches to the database and application server. Performing initial health check of the patches/ enhancements and releasing the product for further testing.
• Providing enhancements around the existing application that involves providing alternate views and functions to correct/enhance business logics around Cheniere requirements.
• Provided numerous custom reports that also required packaging and deploying the reports to the oracle application server.
• Doing the initial evaluation of the issues/bugs and at times providing the vendor with the possible solutions so that they could in corporate the solution in the next release.
• Providing technical guidance to the team in oracle technology.

Tools: and Technologies used: 11i EBS, 12 R, Oracle10g database, Oracle Application Server, Oracle Developer Suite 10g, PL/SQL, JAVA, Visual C#, TOAD, PL/SQL Developer, Remedy and VSS

Confidential

Senior Oracle Developer

Responsibilities:

• Reliant Resources was undertaking a massive effort to streamline their gas deal entry, scheduling and risk management systems and integrate it to the existing Sungard Epsilon product.
• They adopted asynchronous message propagation technique using Oracle advanced queue for data flow from deal, transportation, and pool and scheduling tables into the various risk - management tables and End of day Processing tables.
• Responsibilities include maintaining, setting, streamlining and trouble shooting the oracle AQ message propagation.
• Developing and maintaining many program units that de-normalize and compute the data such as forward month and current month valuation of transport deals, bringing various deals into the common tables to be fed into risk management system that will be used in various reporting.
• Re wrote many risk management packages that did the MTM analysis for performance enhancement and improved the performance many folds by implementing oracle bulk insert features, using materialized views in place of views to improve query performance and maintainability where real time data was not required.
• Providing technical assistance and guidance to the team as an oracle specialist.

Tools: and Technologies Used: Oracle 9i, Advanced Queuing, TOAD, Pl/SQL Developer, DB Artisan, Dimensions tracking and version manager

Confidential

Oracle Developer

Responsibilities:

• Undertook a major enhancement project for the risk management group for Strategy Standardization that involved changing 72 forms, 55 reports, 34 triggers and 15 stored procedures/packages.
• Developed a solution to the FAS group for bulk loading the deal information from the excel spreadsheet and querying and mass updating the portfolio information
• Proposed and developed a solution to archive and query the risk management position calculation data using oracle 9i external table concepts.
• Enhanced several risk calculation reports for the advanced calculation methods.

Tools: and Technologies Used: Oracle 9i database, forms and reports, Pl/SQL developer, Merant version Manager and version control, Remedy

Confidential

Application Support Analyst

Responsibilities:

• The Application comprised of Microsoft .Net based Front Office System (FOS) for deal entry and oracle form 9i web based nucleus R-14 for risk management and invoicing modules that are hosted on 9iAS.Responsibilities included documenting the current application support functionality, proposing new model for the support, taking the trader calls, trouble shooting the day today application related issues, narrowing down the issues and routing the network and database related issues to proper personnel, helping the Business Analysts in data analysis, logging the production related issues in Sungard iTrak database, and at times helping the BA's in regression testing and issue testing the latest patches from Sungard.

Tools: and Technologies used: Oracle 9i Forms and Reports, Oracle 9iAs, Microsoft .netJava, RapidSql, ClearCase, ClearQuest, Remedy and Microsoft Visio.

Senior Analyst

Confidential

Responsibilities:

• Gave Guidelines to team member in successful migration of the Oracle applications from Biscom fax server to RightFax.
• Assisted the team member in setting up crystal report and overcoming the problem of basing the crystal report on oracle-stored procedure.
• Frequently helped the help desk support team in resolving oracle installation and connection related issues such as:
• Application crashing while printing from oracle reports.
• Oracle connection issues
• ODBC connection problems to the Oracle
• Trained the help desk team in proper installation of oracle client.
• Frequently helped the team members in solving their technical challenges.
• Aided the energy traders and schedulers in resolving the day- to-day data related problems.
• Gas Scheduling/ Nucleus Production Support (Oracle8i/Forms 6i): Took ownership of the gas nomination entry screen where the schedulers manage the creation and modification of nominations and paths. Did several enhancements that aided the schedulers in most efficient and flexible way to create and manage nominations.
• Implemented volume bucket concepts system wide to give the ability for the schedulers to cut and adjust the energy deals.
• Implemented trading points/scheduling point concepts system wide, where in the scheduler can change the trading point to any scheduling point.
• Implemented the functionality to calculate bi-directional transmission losses and in doing so corrected a major blockage in the Nucleus design that would have impeded the ability to input manual losses.
• Took complete ownership of a key module, Improved its response time 5 fold by using oracle advanced features like dynamic SQL, and by tuning the SQL.
• As a key player in the performance team, ran SQL traces for all the modules (forms and reports) and corrected weak SQL queries that were the performance bottlenecks.
• Worked with the DBA in putting together table indexes that dramatically improved performance in many screens.
• Worked together with the performance team and identified a missing foreign key index that solved a major locking problem in the production environment.
• Gave technical consultancies to the transmission redirect group with regarding to the data model and new advanced oracle features
• Gave technical consultancies and guidance to the team in implementing the CA-ISO pooling screen that allowed the schedulers to attach any required transmission to the CA-ISO deals and pooling them and sending them to nMarket. The same screen allowed them to un-schedule the transmission deals and handle any cancelled deals from nMarket for that day. Background work included developing two-way interface between power Scheduling and nMarket. Necessary shadow tables were created so that nMarket would pull the information from the power Scheduling. Also implemented the ability to change the inter-tie points on CA-ISO screens.

Staff Consultant

Confidential

Responsibilities:

• Web development Project: Took a leading role in SQL Technologies web development that comprised of three developers. We took an integrated approach utilizing Oracle Application Server as the main Web server along with cold Fusion and Microsoft IIS servers. Oracle 8.0 was used as the back end. PL/SQL cartridge, Perl, Coldfusion, Java, CGI programs and Javascript were used to develop various interfaces.
• Responsibilities included installing the NT sever, configuring the network, Installing IIS server, coldfusion server, coldfusion studio, Oracle application server, Oracle client, Oracle 8.0, configuring the ODBC and Net 8 and deciding the design and functionality of the web, conducting a through research, meeting with the users to understand and implement their needs and finally the web development itself.
• Office Management system: Developed office management application for the SQL Technology office using forms 6.0 and reports 6.0.
• Client Project (TEPPCO): TEPPCO Inventory Management system (TIMS) supports tracking of product movement, physical tank inventory, balancing and relay of scheduled order information to field personnel. Project had to integrate existing field input physical inventory system (FIPI) with the existing TISA system through a single menu.
• Major processes involved maintaining shipper, schedule orders, operations reports, tickets, and physical inventory, end of day processing, utilities and interphases. The development team consisted of 8 developers, 4- user support team and 2 DBA. Project comprised of 130 Forms 5.0 modules, 46 reports 3.0 and 167 tables and many complex views in oracle 7.3 database.