SUMMARY:

• An accomplished Oracle Professional with 20+ years experience in all phases of the system development in ocean shipping and logistics, financial and trading industries
• Proficient in applying best practices in Software Development Life Cycle (SDLC) and managing medium to large - scale projects
• Detail-oriented, resourceful in completing projects with practical skills of UAT/QA testing strategies
• Strong sense of analytical understanding in planning, organizing and coordination of Agile software development methodologies, practices along with iterative and incremental development, stand up meetings to improve communication and test-driven approach
• Conducted root cause analysis while resolving production and data issues
• Provided a proven technology solution in realistic time frames and managed multitasking effectively in a fast-paced environment with the strict deadlines while targeting the critical business problems
• Actively participated in vendor selection, project proposal, planning, scheduling, tracking, reporting, resource allocation, requirement identification and customer support
• Logical and Physical Data Modeling relational schemas, forward engineering into DDLs and executed on ORACLE to create needed objects
• Experience in developing complex packages, store procedures, efficient triggers, required functions, creating indexes and views
• Performed tuning, analyzing query plans in PL/SQL packages and procedures
• Complied with Financial Regulatory Compliance Sarbanes-Oxley Act (SOX) and worked closely with internal audit team with full responsibility to create monthly and quarterly SOX Audit Summary Reports for Account Payable (AP) application
• Proficient in design and development of OLTP and On-Line Analytical Processing (OLAP) systems based on Oracle RDBMS with good knowledge in Data warehouse concepts and ETL principals
• Managed 40+ developers during conversion of 450+ Oracle Forms from v4.5 to v6i using unique, high-performance development platform PITSS.CON
• Assessed and configured workflow and processes through analysis of existing architecture to improve the business logic
• Strong analytical skills with the ability to break down and communicate complex issues with solutions
• Structured the procedures and packages for database reorganization during conversion from Oracle 9 to Oracle 11g
• Trained new recruiters in the domestic and offshore teams(India), built a collaborative Team environment

SOFTWARE & LANGUAGES:

RDBMS: Oracle 11g R2, Oracle 10g, 9i, 8i, 8, 7, 6.

Development Tools: Oracle Forms 11g, 10g, 6i, 4.5, 3.0, Oracle Reports 10g, 6i, ERwin ERX 3.5, Developer/2000, SQL*Plus, SQL*Loader, SQL Developer, TOAD, PL/SQL Developer, Crystal Reports

Miscellaneous: Microsoft Visio, PVCS, FileHold v.7.2, MS SharePoint, Balsamiq Mockups

PROFESSIONAL EXPERIENCE:

Confidential, Woodbridge, NJ

Assistant Project Leader / Senior System Analyst

Responsibilities:

• Overall Analysis, Data Modeling, Creating Data flow and Design of the System main screens with multi level complexity and functionalities using Oracle Forms, development of the ETL processes using Oracle packages and DBMS Scheduler to automate different type of Purchase Orders (PO) generations.
• Complex PL/SQL object coding including packages, procedures, functions, database triggers for OLTP (On-Line Transaction Processing) and Data Warehouse System. Query performance improvement using partitioning.
• Detailed unit test, integration and regression test plans, preparation of the technical documentation for each module in Account Payable System.
• Supporting the users in global MOL agencies including daily requests and troubleshooting of the production issues.
• Gathering requirements from Corporate Trade Management Group.
• Designing the database and user interface prototypes (Balsamiq Mockups).
• Building the rules for advanced calculation and aggregation for forecast and allocations.
• Adopting the pre-calculation method to enhance performance.
• The system replaced the Oracle Financial Application. It provided data in XML format between MOL-IT system Confidential and Local Accounting Systems around the world for various MOL agencies.
• Design and Development of the Oracle packages to create a pilot WO file to test the system’s capability to accept XML files with WO information from Confidential to the Local Accounting Systems and Re-Extract WO files with Invoice or Remittance information.

Confidential, Stamford, CT

Assistant Vice President / Senior System Analyst

Responsibilities:

• Designed and coded Oracle PL/SQL packages for large international financial information systems such as
• Modules within these systems included customer and product profitability, regulatory reporting, cost & revenue allocation as well as feeds to the customer billing application. Information supported Confidential 's Cash Management, Trade, and World-Wide Securities divisions of the Global Consumer Bank.
• The system provided information about all Global Transaction Services ( Confidential ) expenses for management and financial controllers and extracted related data to prepare files to load into Multidimensional Database environment.
• This system provided data interface with different mainframe systems, supported data gathered from other countries for management analysis and reporting, critical information for the billing system and validation of raw data before input into the bank’s financial reporting book.

Confidential, Wayne, NJ

Senior Programmer Analyst / Programmer Analyst

Responsibilities:

• container management and cargo movement from pickup location to the port and/or between domestic locations by the trucks, trains or barges.
• forecast and cargo movement cost management
• receiving the invoices from the truckers, entering the invoice approval and sending out the checks to pay the invoices to service providers.