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)