Senior PL/SQL Developer, Team Lead, Project Manager, Sr. Business Analyst, Systems Designer

• Designed and implemented an Oracle-based data warehouse (3+ Terabytes) for firm’s financial and administrative information. Led a team to develop and implement ETL process to load 850+ tables. Supported various business areas and systems for their cross dimensional reporting and other data requirements.

Business and Technology support for Firm's Tax group.

• Implemented PowerPlan Inc. software to process and pay firm’s property taxes (45K+ properties). Developed interfaces to integrate PowerPlan software with firm GL, AP and PO systems( (PowerBuilder, Oracle, PL/SQL technical platform).
• Designed and implemented Oracle Workflow based alerts system to notify Tax managers for user defined tax and assessment exceptions and deviations requiring resolution from them.
• Developed a data repository and reports to standardize and simplify filing of Property Tax returns across various states/counties.
• Installed Sales and use Tax processing system. Developed interfaces from Sales Tax system to the firm’s Oracle General Ledger, Accounts Payable and Project systems
• Worked with Corporate Tax department to install their cloud-based corporate Tax system. Developed an interface from Oracle GL for loading monthly balances. Developed several reports to support their account analysis functions.

Implemented Verint Inc. I360 Work Force Optimization software. Developed 70+ custom interfaces from various CSX systems to Verint software to capture employee productivity data. As Verint system administrator continued to provide business and technology support. (MS SQL Server, SSIS technical platform).

Designed, developed and implemented several custom work flow applications in Oracle environment for various business areas of the firm.

• Sidetrack Request (For new business development)
• Procard Statement Approval (For Internal Audit and Purchasing)
• Fast Track Car Scrap (Car Management group)
• External Reporting Tracking (Controllers Group)
• Account Reconciliation (Controllers group)
• Tenant Billing (Real Property and property tax groups)

Configured and set up of Oracle Financials G/L, Inventory and A/P modules. Developed procedures to migrate all existing data from various legacy systems to the Oracle business suite including Chart of Accounts, Item Master, Account balances, inventory, and vendors.

• Developed and implemented a client server based system to reconcile approximately 2500 bank accounts on a daily/monthly basis - PowerBuilder and Oracle database.
• Coordinated the move of Accounts Payable, Cash Control and Travel & Entertainment systems from Princeton NJ to Jacksonville FL.
• Migrated all management reporting for A/P, Cash Control and T&E systems from mainframe to client server based Oracle Financials environment.
• Implemented a Daily Posting Ledger for firm's largest subsidiary. Automated several areas to improve estimation process and productivity.
• Implemented a comprehensive foreign currency ledger system.
• Designed and implemented Universal Distribution system to provide an effective interface between various corporate areas and subsidiary general ledger systems.
• Implemented firm-wide standard chart of account system.