SUMMARY

• Proficient in Oracle 11g/10g/9i/8i, PL/SQL Developer, MySQL, Perl, Sun Solaris and HP UNIX, Korn Shell Scripting.
• Strong Experience in data warehouse Building, OLAP and OLTP systems, Maintenance and Support which uses ORACLE 8i/9i/10g/11g Databases, MySQL, SQL, PL/SQL, SQL* Loader, Shell Scripts, Business Objects, Oracle Express Language in windows NT and Unix environment.
• Strong Knowledge of Data Warehousing concepts, RDBMS and Dimensional modeling primarily Star & snowflake schemas using ERWIN, Fact and Dimension Tables, De - normalization, Normalization, Logical & Physical Data Modeling.
• Expertise in Tuning of Procedures, Packages, SQL
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors, Ref Cursors, Dynamic SQL, Oracle Analytical Functions, Exception Handling, Materialized views and views for processing data, enforcing referential integrity and needed business rules.
• Designing, Coding, Testing and implementation of High Availability Distributed System.
• Extensively worked on Table Partitioning, Bulk Binds and Bulk Collects.
• Involved in Data modeling, E/R diagrams, normalization and de-normalization as per business requirements.
• Experience in Data Migration, SQL Loader.
• Experience with Crystal Reports, Business Objects
• Strong experience in financial industry.
• Excellent analytical and problem solving skills and can work independently.
• Excellent Communication and responsible team player.
• Quick learner with ability to master new concepts and applications.

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/2003, Solaris 10, HP-UX 10/11, AIX, Linux

Programming languages: C, C++, VC++,C#, Java, PL/SQL programming, RDJ 8.3.2, Axway Accounting Integrator

Web Technologies: HTML, JSP

Script Languages: JavaScript, Shell scripting, Perl

Tools: Toad, OEM, PL/SQL, Crystal Reports, Citrix, Reflections for Unix, Business Objects, Datastage, Informatica Powercentre 8.6

Database: Oracle 11g/10G/9i/8i/8, MS Access 2000, MySQL

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Oracle PLSQL Developer

Responsibilities:

• Analyze the functional & technical requirements of the project.
• Discuss with business users, BA's to finalize and understand requirements and scope of the project.
• Design the Database and ETL framework for the RCT tool.
• Design and provide Database service call contracts to Java/UI team
• Create new tables, views, materialized views, Packages, Stored Procedures and functions per the requirements.
• Extensively used PL/SQL Collections, BULK Collect, For ALL, Table Types, and Record Types.
• Wrote complex stored procedures and packages.
• Extensively used Execute Immediate for dynamic sql.
• Extensively used Analytical functions Rank, Dense Rank for complex reporting purposes and hierarchial data
• Extensively worked on Cursor, RefCursor for data processing.
• Used Exception Handling to handle runtime & user defined exceptions.
• Modified existing Shell Scripts and created new Shell Scripts.
• Optimize the code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve the performance
• Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested.
• Plan production deployment activities, raise RFCs and coordinate with various teams like DBAs, Unix Admins.
• Used PIVOT, UNPIVOT, LISTAGG and many functions in Oracle 11G to transform complex source data.
• Create new Tableau dashboard and adhoc reports as per the user requirements
• Create data extracts for Tableau.

Environment: Oracle 11.0.2, Oracle 10G, PL/SQL, Rapid SQL 7.6, PLSQL Developer, Windows Server 2008, Tableau 8

Confidential, Moorsvillie, NC

Sr. Oracle PLSQL Developer

Responsibilities:

• Proposed changes to the existing Database Architecture as per requirements and Involved in redesign of database.
• Modified existing ETL processes as per new requirements.
• Upgrade financial reports according to the specifications of different Service Managers and Customer Advisors.
• Created new Tables, Indexes, Views, Materialized Views, Table Partitions as per the requirement.
• Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema using SQLLDR, Export/Import.
• Modified existing and created new SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.
• Extensively used PL/SQL Collections, Table Types and Record Types.
• Used Bulk Collect and For All for processing huge volumes of data.
• Extensively used UTL FILE, DBMS XMLGen for creating flat files and XML files used by the downstream systems.
• Extensively performed Unit Testing & Integration Testing with different test cases.
• Used Hummingbird Exceed to connect to the UNIX server.
• Used TortoiseCVS control version for synchronizing the upgradations.
• Coordinated with the team of java developers to accomplish complex financial calculations.
• 24/7 oncall production support.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Toad, MySQL 5.0.27, Tableau 7, Java, Sun Solaris, Unix Shell Scripting

Confidential, New York

Sr. Oracle PL/SQL ETL Developer

Responsibilities:

• Replace the existing local OMR system (in US) with “Calypso”, the standard implemented in the Paris head-quarters.
• Analyze the functional & technical requirements of project.
• Involved in Logical and physical modeling.
• Designed and developed ETL process from scratch for this new system using Oracle, PL/SQL and Unix.
• Designed Fact and dimension tables and handled slowly changing dimensions.
• Create new Tables, Indexes, Views, Materialized Views, Table Partitions as per the requirement.
• Create SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.
• Extensively used PL/SQL Collections, BULK Collect, Table Types, And Record Types, UTL FILE
• Wrote complex stored procedures and packages.
• Create new Structures, Input/Output Events, and Sources in RDJ for new rules.
• Create & Modify Transformation, Change, Balancing, Aggregate & Audit rules in RDJ8.3.2 as per the requirement.
• Validate, extract and send the rules to File Manager, compile and move them to production.
• Move data between databases using Import/Export.
• Extensively used Explain Plan and TKProf utilities to fine tune and improve the performance of application.
• Extensively used hints to tune & optimize queries using DB links.
• Used DRIVING SITE, HASH, INDEX, NO USE NL, etc hints to optimize queries.
• Wrote complex shell scripts for processing of rules.
• Used $UNIVERSE scheduler to schedule ORACLE & non oracle jobs.
• Created Test scripts and involved in Unit, Integration and System testing.
• Wrote FTP scripts for transferring files between different machines
• FTP checks to ensure complete file transfers, new Daily backup scripts to copy last 5 days of files to disaster recovery (DR) system.
• Used PUTTY & Reflections to connect to UNIX machines.
• Used Rapid SQL & SQL Developer to access DB, write packages, procedures & functions.
• Guide/help team members in resolving technical issues.
• Create adhoc reports using Business Objects XI, for Finance users.
• Provide 24/7 oncall production support, resolve P1, P2 issues immediately

Environment: Oracle 9i(9.2.0.1.0), Oracle 10.0.2, SQL, PL/SQL, Rapid SQL 7.6, SQL Developer, UNIX, SH, Windows NT, Reflection for UNIX, RDJ 8.3.2/9, Oracle Apps 11.5

Confidential

Oracle PL/SQL Database Developer

Responsibilities:

• Performed design, coding, implementation and support.
• Wrote Stored Procedure, Package and Triggers for back end validations
• Wrote Procedures using Oracle supplied Packages
• Designed Front-end interfaces and created reports as per the requirements using Forms/Reports 6i.
• Code base consists of complex package logic that uses DML and writes all SQL executed to log tables for troubleshooting
• And logic that processes logistical data for optimizing selecting a particular product and its features available across different companies.
• Measuring and reporting product list using Excel, PL/SQL scripts.
• Wrote complex SQL queries using joins and correlated sub queries
• Validations have done in front-end and as will in backend using triggers.
• Analyzing the tables
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality
• And improve processing time through code optimizations and indexes.

Environment: Oracle 8i, Oracle Forms/Reports 6i, (SQL*Plus, PL/SQL Developer), Windows XP Pro, MS Office 2003 (Excel, Word), Perl, UNIX