EXPERIENCE SUMMARY

• 15 Years of IT experience with expertise in Oracle Technology. Experience working on different phases of SDLC, from Systems Analysis, Design, Programming, Testing and Debugging to Implementation, Maintenance and Production Support.
• Expertise using Oracle Databases (7.3, 8i, 9i, 10g, 11g,12c). Experience using Microsoft SQL Server, Microsoft Access.
• Proficient in writing and Performance Tuning of SQL queries and PL/SQL (Procedures, Functions, Packages & Triggers).
• Experience working on Oracle Forms, Oracle Reports, Oracle Discoverer, Oracle Designer, Oracle BI/XML Publisher, SQL Plus, TOAD, Oracle Application Express (APEX) - formerly called HTML DB. Able to create from scratch or modify existing modules.
• Experience as Techno-Functional in Oracle E-Business Suite Financials R12. Experience in Oracle 11i EBS Applications - HRMS implementation.
• Knowledge and experience in creating Java Scripts, JQuery.
• Experience in working with Microsoft Visual Studio and Crystal Reports.
• Good background in Database Administration.
• Industry experience in Insurance, Healthcare, Retail, HRMS, Accounting, and Financials domain.
• Adept in writing Advanced PL/SQL (dynamic SQL, Bulk Binding, Exception Handling).
• Involvement in Data Migration from various Legacy Systems to Oracle.
• Experience with Data Flow diagrams, Entity Relationship models, Data Dictionary, Database Normalization concepts.
• Experience with ETL and Business Intelligence.
• Able to perform as a Team Lead, a Self-Starter and can work as an Individual Contributor.
• Strong communication skills (written and oral) and interpersonal skills.
• Knowledge of IBM IMS Database, DB2.
• Excellent problem solving skills.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX, LINUX

Languages: Oracle SQL*Plus, PL/SQL, C++

RDBMS: Oracle Database versions 7.3 - 11g.

Developer Tools: Oracle Forms 4.5-10g, Oracle Reports 2.5-10g, SQL*Plus, Oracle Designer 9iDS/6i, Oracle Discoverer 2000/9iAS, TOAD, SQL Navigator, PL/SQL Developer Tool, Benthic, Visual Basic 3.0/4.0, Microsoft Visual Studio 5.0, Crystal Reports, Microsoft SQL Server Reporting Services, XML/BI Publisher, Oracle Workflow

Applications: Oracle 11i Applications - HRMS (Human Resource Management System) Application, Oracle E-Business Suite Financials R12

PROFESSIONAL EXPERIENCE

Confidential, Jersey City

Data Architect/Oracle Developer

Responsibilities:

• Works with teh Tactical team that halps in teh company’s Data Validation process and generation of Federal Report Requirements.
• Responsible for upgrading teh database with new Releases of Data Validation Rules, Products, Chart of Accounts, Exception Allocation Ownership as per teh company’s Financial Data Standard (FDS). dis includes data loading using SQL*Loader, creation of Control Files, develops/edits Oracle Procedures, Functions and Packages to adhere to teh current rules of teh company. Collaborates with .NET colleagues for teh upgrades.
• Responsible for teh Exception Allocation Process. dis process halps streamline teh process of teh Financial Data Warehouse data quality remediation by identifying teh owners of these Exception data. dis includes getting data from teh FTP server, loading of data to tables, execution of batch jobs and generation of Exception Allocation Reports.
• Supports SAP late entries module, Adjustments to DBPs, Contract and Counter Party modules.
• Reviews current system documentations and creates KOPs (Key Operating Procedures) documents, Process Flow/Workflow Diagrams for Data Validations like Exception Allocation and Rule Validations.
• Involved in teh Analysis, Development and Testing of teh IHC Federal Report requirements (TIC Form D - Derivatives, TIC Forms BC/BL1/BL2/BQ3, TIC Form SLT, TIC Forms SHCA/SHLA)
• Knowledgeable of FRY9C,14A Federal Reports generation process, CCAR.
• Helps in teh decommission of database servers process, migration of data to new databases, creation of database links between our database and teh Financial Data Warehouse system. dis includes creation of new users, roles/privileges. Coordinates with different stakeholders of teh company for teh approvals and implementation.

Environment: Oracle Database 11g &12c, SQL Developer, PL/SQL Developer, SQL Plus, TOAD, WINSCP, SQL*Loader, UNIX Scripting, Control- M Batch Scheduling, Java Scripts, Microsoft Excel Reporting, Visual Studio - .Net, SAP, Linux, Financial DataWarehouse

Confidential, California

Oracle EBS Functional/Technical Consultant

Responsibilities:

• Review teh current Oracle R12 Applications Systems of teh Department of General Services to analyze requirements for Fi$cal PeopleSoft implementation. dis includes Oracle Financials, Projects, Human Resources (ABMS), Payroll and PAL - customized Project Accounting & Leave Information system.
• Create Functional & Technical specifications and checklist of teh current PAL Modules and upload documents in Sharepoint.
• Work with teh DGS Staff and contractors to design teh “To-Be” architecture of teh new Project Accounting & Leave System with Oracle R12 HR.
• Analyze current ABMS system to disconnect Oracle HR with Oracle Financials & Projects as these would be converted to PeopleSoft system. Document impacted Oracle database objects like tables, columns, views, procedures, functions, packages.
• Provide Production support for Oracle Financials, Projects, HR issues/incidents as needed using Oracle Forms, Reports, Oracle Application Express (APEX) 5 with JavaScripts/JQuery/CSS, SQL Navigator, Oracle E-Business Suite.
• Meet with Business Subject-Matter Experts for Human Resources & PAL to get current requirements and future requirements.
• Give analysis on teh HR/PAL, Payroll interfaces like Leave Usage, Shift Differential, Positive Pay, Overtime to SCO Leave Acctg. Sub-System LAS, SCO Payroll, Maximo, E-Tracker, Accounts Receivables, General Ledger, Projects.
• Meet with System Architecture manager and DGS development team on Development, Unit Testing, UAT Mock Testing and Production server requirements for Oracle HR/PAL database & applications requirements.
• Assists teh conversion & migration team in creating SQL scripts to convert existing system data to PeopleSoft.
• Provides status updates of deliverables to Project Management/Stakeholders. Attend meetings for Fi$cal updates.
• Attended online trainings: Ethics Training, Security & Privacy Training, ISO Training.

Environment: Oracle Forms & Reports 11g, Oracle Application Express (APEX) 5, Oracle BI/XML Publisher, Oracle Discoverer 11g Administrator and Desktop, LINUX, SQL Navigator, Oracle RDBMS 11g/12c, Unix, Oracle E-Business Suite R12 (Financials, Human Resources, Projects), PeopleSoft

Confidential

IT Leader

Duties and Responsibilities:

• Work with users in teh identification of business requirements, and design application solutions to halp meet these requirements.
• Development of Oracle Functions, Procedures and Packages for checking movements and replenishments of items in Warehouse and Stores.
• Customized several Forms and Reports modules to meet user’s needs using Oracle APEX (JQuery, HTML, CSS).
• Creation of Oracle Reports to monitor Store and Warehouse orders. These are usually called in created Batch scripts.
• Helps teh team trouble-shoot complex errors that results from teh Production batch runs and related processes.
• Responsible for SQL Query Tuning and Performance Optimization.
• Developed UNIX shell scripts to create HKMS Oracle database user and grant access privileges.
• Customized Oracle Discoverer reports used for Data Warehousing.
• Helps teh team in teh Corporate Data Warehouse housekeeping - develops and executes SQL scripts to drop/rebuild table partitions, rebuild indexes.
• Used SQL Loader and TOAD utility to move data in between databases.
• Develop SSRS reports for Legacy systems.
• Serves as System Administrator for setting up new users in Oracle EBS Financials, and managing Concurrent Processing.
• Develops ad-hoc reports using SQL scripts for customers of Oracle Financials 11i/R12.
• Work with teh team in providing on-call support to users and meeting SLAs.
• Apply ITIL concepts in aligning IT services with teh needs of business.

Environment: Oracle Forms & Reports, Oracle Discoverer, SQL*Plus, PL/SQL, Oracle 11g/12c RDMS, LINUX, Unix, Oracle E-Business Suite Financials R12, Oracle E-Business Suite Order Management (Supply Chain), Oracle Application Express (APEX) 4.2.5, Putty, WinSCP, SQL Loader, Microsoft SSRS

Confidential

Oracle EBS Developer

Duties and Responsibilities:

• Worked closely with Financial Times’ accountants to get user requirements for report design and development. Create a variety of outputs (customer ready PDF documents, HTML output for optimum online viewing, Excel spreadsheet).
• Tasked to develop/revise high priority BI Publisher reports for Financial Times. dis includes developing report requirements for teh Finance Controller (mostly Tax Reporting to teh Government Bureau) and various global managers.
• Uses SQL*Plus, SQL Developer, Oracle BI Publisher tool, Unix, Oracle Reports to build or edit reports for Financial Times following Development, Documentation, Testing and Acceptance Standards.
• Acts as XML Publisher Administrator - creates Data Definitions, templates or layouts (.RTF files), and register these Concurrent Programs.
• Write ad hoc SQL scripts to quickly produce extracts or reports needed to expedite some business processes.
• Uses Oracle FNDLOAD built-in to migrate Concurrent Programs/Executables, Value Sets/Values, Responsibilities setups from development to UAT/Production environment.
• Assists team members to determine teh root cause of an incident by creating several SQL queries/scripts. Give Functional analysis.
• Creates customized Forms and Reports using Oracle APEX 4.2 (JQuery, HTML, CSS).
• Creation of MD050 (Application Extensions Functional Design) & MD070 (Application Extensions Technical Design) documents.
• Review and revise BR100 documentation for teh Oracle Financials R12 application set-up.
• Provides status updates of deliverables to Project Management/Stakeholders.

Environment: Oracle Forms & Reports, Oracle BI/XML Publisher, SQL Navigator, Oracle RDBMS 11g, Unix, Oracle E-Business Suite R12, Oracle Application Express (APEX), UNIX

Confidential

Project Lead

Duties and Responsibilities:

• Meets with users to gather requirements, work with project team in designing, coding and testing teh applications.
• Attended HCO (Health Care Orientation) to familiarize with HIPAA (Health Insurance Portability and Accountability Act) and other health care standards.
• Creates Oracle packages, functions and procedures for Medical Claims logging.
• Develop and revise Oracle Forms and Reports for Provider Entry, Claims Entry
• Creates and revises UNIX shell scripts, Pro-C programs for Oxford Applications.
• Develop dynamic SQL scripts for purging of data since only 7 years of data are required to be retained in teh database.
• Involved in Performance Tuning using Explain Plan and SQL Statement analysis.
• Manages teh team of Oracle & Java developers.
• Provide timely updates on risks, issues and escalations along with an action plan to teh stakeholders.
• Adherence to all production support - service operation & transition processes like Problem Management, Incident Management, Change Management, Release & Deployment Management. Participate in war rooms and provide on-call support. Ensure audit compliance with organization and project defined standards and processes.
• Identify and propose application performance & process improvement initiatives using ITIL methodologies.
• Participates in CMMI initiatives to attain CMMI for Services Version 1.3.
• Develops reports for SSRS from Legacy Systems.

Environment: Oracle Forms/Reports, Oracle10/11g RDBMS, Unix, Java, Pro-C, SQL*Plus, PL/SQL, Microsoft SSRS, TOAD, LINUX

Oracle Developer

Confidential

Duties and Responsibilities:

• Worked extensively for Oracle EBS Financials applications development & support mostly in Oracle Payables, Receivables & Payments modules.
• Supports custom applications integrated in EBS like Staff Receivables.
• Uses Metalink to coordinate with Oracle Support for teh resolution of various bugs/issues encountered. Logs Service Requests and checks teh Oracle Patches.
• Maintains Custom Workflows for teh Quick Invoice/RFP Approval and AP Invoice Approval.
• Supports users for Purchase Orders, Receivables, Payables, Payments, GL Reconciliation.
• Design, build and implement SQL*Loader scripts, PL/SQL packages, SQL scripts, Oracle Forms, Oracle Forms Personalization, Oracle Reports, HTML DB, XML reports, Oracle Workflow, Oracle APIs, Alerts.
• Developed and customized existing Discoverer reports.
• Use Subversion (Tortoise SVN v1.4.8) to manage Custom objects.
• Creation of MD050 & MD070 (Application Extensions Functional & Technical Design) documents.
• Review and revise BR100 documentation for teh Oracle Financials R12 application set-up.

Environment: Oracle Forms/Reports, Oracle RDBMS 10g, Unix, Oracle E-Business Suite R12 (Financials, Order Management - Supply Chain), TOAD, SQL*Plus, PL/SQL, XML, SQL*Loader, Oracle APEX 4.0, LINUX, IMS Database.

Consultant

Duties and Responsibilities:

• Helps teh team with AGIS modules and security setup for Indonesia and Hong Kong.
• Revises Oracle Forms and Reports as per user’s needs.
• Debugs PL/SQL packages using TOAD and SQL*Plus.
• Works with teh team in teh optimization of SQL scripts.

Environment: Oracle RDBMS 9i/10g, Oracle Forms/Reports 6i, TOAD 8.0, SQL*Plus, PL/SQL