Uploaded File
add photo
Surendra
suruheda@gmail.com
904-612-4408
13046 Sandwedge Ct.
Atlantic Beach, FL 32224
Oracle Architect
36 years experience W2
0
Recommendations
Average rating
152
Profile views
Summary

Extensive experience in all phases of project life cycle for technology projects - working with business areas identifying issues and providing viable cost effective solutions, gathering requirements, preparing work estimates, requirements analysis, systems design, development, testing, implementation, training and support. Proficient at directing and coordinating design, development and implementation of application systems.

  • Extensive experience in Oracle Database environment – SQL*Plus, PLSQL, Oracle Forms, Reports, performance tuning, TOAD and other Oracle development tools.
  • Oracle workflow Software
  • Business Objects - Crystal Reports
  • Oracle Applications suite ( GL, PO, Accounts Payable, Inventory, Projects & Fixed Assets modules)
  • Microsoft SQL Server, SSIS, BIDS
  • Verint I360 - Work Force Optimization Productivity Software (Avaya)
  • Vendor Software - Power Plan (Property Tax), STS ( Sales & Us Tax), Cop Tax (Income Tax)
  • Unix, Citrix environment

Experience
Independent IT Consultant
Transportation
Feb 1998 - May 2017

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)
SQL Server SQL PowerBuilder PL/SQL Oracle ETL Data Warehousing Business Analysis System Administration Auditing Project Management SQL Developer SSIS Analysis System Analysis Oracle SQL*Plus Oracle Forms Oracle Reports Performance Tuning TOAD Business Objects Crystal Reports UNIX Citrix
Remove Skill
Project Manager
Utilities/Energy
Feb 1997 - Feb 1998

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.

Project Management Oracle Oracle Financials
Remove Skill
Senior Systems Engineer
Banking/Financial
Oct 1985 - Feb 1997
  • 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.
PowerBuilder Oracle Systems Engineering Oracle Financials Database Design
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Business Management
NITIE Bombay, India
Bachelor's in Electrical and Electronics Engineering
NITIE Bombay, India
Skills
Oracle
2017
31
PowerBuilder
2017
30
Project Management
2017
20
Analysis
2017
19
Auditing
2017
19
Business Analysis
2017
19
Business Objects
2017
19
Citrix
2017
19
Crystal Reports
2017
19
Data Warehousing
2017
19
ETL
2017
19
Oracle Forms
2017
19
Oracle Reports
2017
19
Oracle SQL*Plus
2017
19
Performance Tuning
2017
19
PL/SQL
2017
19
SQL
2017
19
SQL Developer
2017
19
SQL Server
2017
19
SSIS
2017
19
System Administration
2017
19
System Analysis
2017
19
TOAD
2017
19
UNIX
2017
19
Database Design
1997
12
Oracle Financials
1998
12
Systems Engineering
1997
11
Requirement Analysis
0
1
Requirements Gathering
0
1
System Design
0
1