Senior Oracle Developer Consultant Resume Profile
NY
SUMMARY
- Extensive experience of custom applications development, off the shelf products customization, products upgrades, performance tuning / optimization, data modeling, team management, data administration experience using Oracle RDBMS PL/SQL, SQL and tools in Unix, Linux, VAX/VMS and Windows environments. Multiple SDLCs projects. VLDB, DSS, DWH, OLTP, datafeeds, interfaces
- Expert knowledge of languages and internals of ORACLE RDBMS v6 11G, Oracle / ANSI SQL, ORACLE PL SQL, migration and upgrade techniques, performance optimization for RBO/CBO in Batch, Transactional and Data warehouse systems
- Expert knowledge of businesses such as banking, investments equities and fixed income , insurance.
TECHNICAL PROFICIENCY
Languages: | ORACLE PL SQL, SQL, CA NSQL, Unix Korn shell, LINUX Bash, Pro C, SQR, TSQL, Digital Command Language DCL , C K R , HTML, SED/AWK, JIL |
Database environments: | ORACLE 11g r2 /10g /9i/8/7/6, MS SQL Server, MySQL, FOCUS IB, DEC RDB |
Hardware: | Oracle Exadata, HP-UX 9000/899, SUN Solaris, Windows Server, VAX 6410, VAX Station 4000, DEC PDP-11/70, IBM Compatible PC's, SM 800. |
Operating systems: | HP-UX 9, Solaris 7/8, Linux , VAX/VMS 5.5, Windows 3.11/95/98/NT/2000/XP/7, MS-DOS. |
Applications: | MAXIMIS Accounting System UNISYS , SIEBEL Sales Force Automation, TSER, WebFocus IBD , Charles River, CA Clarity PPM, BlackRock Interfaces, MS Access/Excel/PowerPoint/Word, Visio, MS Project. |
Tools: | SQL Loader, Quest TOAD, SQL Developer, SQL PLUS, Oracle GoldenGate, ERWin 2/3.5, TKProf, Explain Plan, Oracle Forms 3.0, 4.5, Reports , SQLYog, ETL Informatica PowerMart, Crystal Reports, AUTOSYS, Oracle Application Express 3 APEX , Oracle Data Modeler 3, StatPack/AWR, SQL Tuning Advisor, SSIS, SSRS, SQL Server Management Studio, VI, VIM |
EXPERIENCE
Confidential
Senior ORACLE Developer Consultant
Fiserv CheckFree upgrade/ Oracle 9i to 11g upgrade with migration from UNIX to LINUX OS, SQL Server Reporting Services SSRS migration from Crystal Reports, implementation of automated SSRS reporting using SR.EXE utility and AUTOSYS scheduler, Batch / Reporting enhancement using regular expressions, Oracle analytical functions, Model clauses, partitioned outer joins, external tables SQL Loader and Data Pump types .
Confidential
Senior ORACLE PL SQL Developer
2004 Applications Architect2005 Senior Applications Architect / Technical Team Lead/ Business Liaison
Environment: ORACLE 8/9i/10g on HP-UX and SunSolaris