PROFESSIONAL SUMMARY:
About 8 years of experience in the development of client/server and multi tired applications using Oracle Database, SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux (Caldera).
· Involved in Design, development, implementation, Data migration, Data conversion, testing and documentation of business applications using Oracle technologies.
· An Oracle developer with extensive experience in data transformations, conversion and interface, data loading, database modeling and performance tuning
· Hands on experience in SQL, PL/SQL Programs, Packages, Stored Procedures, Triggers, Cursors, Dynamic SQL, Pro*C, SQL*Loader, SQL*Plus, UNIX shell scripting, Performance Tuning and Query Optimization
· Proficient in Oracle 10g/9i/8i/7.3, PL/SQL Development Toad, SQL Plus, PL/SQL Developer, UNIX, Perl and working knowledge of UNIX editors, Debuggers.
· Strong Experience in data Maintenance and Support which uses Oracle 9i database, SQL, PL/SQL, SQL* Loader, Shell Scripts, Business Objects in windows NT and Unix environment
· Extensively used PL/SQL to built Oracle Packages, stored procedures, functions, triggers, cursors, Oracle Reports and views for processing data, enforcing referential integrity and needed business rules.
· Strong Vertical Industry experience in implementing Financial services with Specialization
in Fixed Income Products, Credit Derivatives and also has understanding in front office, . middle office and back Office trading systems
· Knowledgeable in Client / Server architecture
· Have working knowledge of DBMS_JOB. DBMS_SESSION, DBMS_SQL, or UTL_SMTP
· Experience working with Data Scrubbing Software to Streamline Rebate Validation Processes and Minimize Compliance Risks
· Experienced in Tuning Queries for better performance with large volume of data.
· Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, V-arrays, Records, Types, Dynamic SQL, T-sql.
· Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
· Experience in using SQL TRACE and TKPROF tools for Explain Plan, SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns
· Involved in database design, tuning, triggers, functions, materialized views, Oracle Job Scheduler, Oracle Advanced Queuing
· Have working knowledge of ORACLE DBA at times.
· Solid hands on experience with Data warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
· Quick learner with ability to master new concepts and applications.
· Very good team player and ability to work under tight project schedules
· Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
· Proactively interacted with Business Analysts, technical analysts, Developers, Testers and External clients
· Expertise in Oracle AS 10g and migration of Oracle Reports from 4.x/6i/9i to Oracle 10g
· Experience in utilizing ETL tools like Informatica, Business Objects, Data Stage and Data Transformation Services
· Extensively worked with Oracle Utilities like Imports / Exports, SQL * Loader- Worked with very large databases in terms of Terabytes- Extensively used UNIX shell Scripts for automating batch programs
TECHNICAL PROFICIENCY:
Databases : Oracle 10g/9i/8i/7.3, Oracle Reports, Sql server 2005, DB-2, SQL Server 7.0/2000, My SQL, MS Access (2002, XP) and MS-Access
Languages : DB2, Sybase, SQL, PL/SQL, XML, UNIX Shell script, Editors, Debuggers, utilities and connectivity tools, Java, J2EE.
Tools & Utilities : TOAD, SQL* Plus, ETL, TK-Prof, UTL_File Packages, OLAP, Data flux
Utilities & Packages: MS Office XP, MS Visio
ETL: Informatica, Data Stage, BO
Data Modeling: Erwin
Reporting: ReportNet, MS Access, MS SQL Reporting Services, Business Objects
6.x/XI R2, Crystal Reports
Operating Systems : HP-UX, Linux (Caldera), Windows and DOS
Web technologies: HTML, VB-Script
Application Servers: Web logic 8i and Tomcat 6.
