SUMMARY

• Certified, Senior Oracle Developer wif 11 years 8 Months’ experience in designing and building custom applications using Oracle database tools Oracle8i/9i/10g/11g/EBS R12 in UNIX and Windows environments. Energetic self - starter wif excellent analytical and organizational skills. Achieves goals, objectives and milestones in an accurate and consistent manner.
• Worked on Eagle Pace and Star. Database installations and up-gradations for Eagle Pace and Star.
• Worked on Netezza migration Project.
• Writing Database scripts, shell scripts and Perl scripting.
• Working experience in Design and implement batch processes wif PL/SQL
• Worked on HTML development for front end and Worked on XML functions in oracle.
• Experience in system study, analysis, design and development in client server environment.
• Analyzing business needs and translates into system/functional requirements.
• Experience in requirements gathering and documenting, creation of detailed specifications, Technical Specifications.
• Experience in SQL Scripting and Advanced PL/SQL Programming using Ref Cursors, Collections, Bulk bind, Object types, record types and XML functions.
• Experience in creating Tables using Range, List and Hash Partitioning.
• Experience in Batch process using Autosys and Control M
• Tuning SQL queries and PL/SQL code.
• Understanding teh existing ETL Process to Transfer teh data from source to target system.
• Working experience in Equity Trading Technology on various projects simultaneously.
• Working experience in Data Migration using SQL*LOADER, NZ Load utilities.
• Participated in development, testing and migration of Oracle applications to teh production environment.
• Working experience in troubleshoot and resolve existing Advanced Queuing systems, rewrite queries and re-engineer applications to reduce load times.
• Writing test cases, unit test plans. Performs exploratory testing.
• Extensive noledge in Market Data, Trade data & Reference Data using in financial services.
• Extensive working noledge wif market data issue wif Bloomberg, Factset and Navgen sources.
• Uses version control and nos how to checkout, update, commit (SVN, PVCS, Visual Source Safe, Clear Case).

TECHNICAL SKILLS

Software: Microsoft Office (Excel, Word, Power Point, and Access), Visio.

Operating Systems: Windows XP, Windows NT, Windows 98, Windows 95, SCO-UNIX, HP-UNIX (HP- UX1020), Solaris, MS-DOS.

Languages: PL/SQL, SQL, HTML 5.0, Java, JavaScript, PL/1, Shell & Perl Scripting.awk, sed

Databases Environments: Oracle RDBMS V7, 8, 8i, 9i, and 10g, 11g, Netezza NPS 4.6, Sybase, EBS R12

Tools: Oracle Forms 9i, 6i, 6.0, 5.0, 4.5, 3.0, Reports 9i, 6i, 6.0, 3.0, 2.5SQL*Plus, Toad, Erwin, Rapid SQL. 7.3.4

ETL Tools: SQL Loader, Informatica Pwercenter 8.1.1, NZ Load, Eagle Pace loaders

Others: Service Center. QC, RTC, Work site, Salesforce.com.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Database Developer - Analyst

Responsibilities:

• Worked on EBS 11i to r12 upgrade Project.
• Writing functional and Technical documents.
• Developed stored procedures and packages. Extensive work in PL/SQL
• Develop SQL, PLSQL programming triggers and constraints in development and in production environment.
• Worked on MDRX CDH Master Synchronization program for CDH, developed code in pl/sql.
• Worked on Business Event purge for CDH, code developed in oracle PL/SQL and SQL.
• Worked on one of teh purge script to execute in PROD.
• Worked as Migration Lead for Code migration, where my tasks are to collect code bundles from Respective tracks, preparing code migration patches by consolidating into single file and testing them in a test instance before sending it to teh DBA team and tan coordinating wif DBA regarding teh code migration.
• Developed common SQL loader script using shell script which is been used for most of teh conversions.
• Identifying teh patches that are mandatory for teh applications to address teh current issue or for teh future issues, planning and conducting teh regression testing and migrating to production environment..
• Used FNDLOAD for Migrating Concurrent programs, Request Groups, Menus, and Responsibilities..

Environment: Oracle Applications r12 12.1.3 (GL,FA,AR,AP,AOL), Oracle 10g, Reports 10g, TOAD, PL/SQL, FTP, SQL LOADER, SFDC, CDH, CRMOD.

Confidential, Atlanta, GA

Sr. Database Developer - Analyst

Responsibilities:

• Working on application design, development of detail design documents, Technical specifications, debugging and testing of application programs
• Preparing mapping document for each data conversion object wif translation and business rules.
• Data conversion development, writing UNIX scripts, packages, functions and procedures.
• Data load from CRMOD source system to Mapping database and extract converted data into CSV for Saleseforce.com
• Data load from SFDC to Staging to identify relation information for SFDC.
• Unit testing on ETL loads.
• Assisted for migrations.
• Writing packages and procedures and functions.

Environment: Oracle11g, SQL, PL/SQL, Windows-XP, Toad, SQL Loader, Salesforce.com, UNIX.

Confidential, Boston MA

Database Consultant - Analyst

Responsibilities:

• Working on application design, development of detail design documents, Technical specifications, debugging and testing of application programs
• Preparing mapping document for each data conversion module.
• Data conversion development, writing batch scripts, packages, functions and procedures.
• Data Validation.
• Worked on QA issues.
• V3 GUI validation for data loaded into teh V3 system.

Environment: Oracle11g, SQL, PL/SQL, Windows-XP, PLSQL Developer Tool, V3 Benefits Administration

Confidential, Boston, MA

Senior Oracle Developer - Analyst

Responsibilities:

• Working on application design, development of detail design documents, Technical specifications, debugging and testing of application programs
• Analyzing and data mapping wif IDSPLUS and ADRM model.
• Creating databases and creating tables and procedures and functions and packages.
• Writing SQL for services.
• Creating indexes and sequences, partition tables and summary tables.
• Supporting for database requests for services and QA team.
• ETL unit testing.
• Performance tuning.
• Data analyzing for RTMS, COB, Huron and Claims.

Environment: Oracle11g, SQL, PL/SQL, Windows-XP, UNIX, Shell Scripting, Toad, RTC, Work Site, QC.

Confidential, Boston, MA

Senior Oracle Developer - Analyst

Responsibilities:

• Working on application design, development of detail design documents, Technical specifications, debugging and testing of application programs
• Writing oracle packages and procedure and functions.
• Writing Auto sys jobs, Perl scripting and shell scripting.
• Working on Partitioning tables and indexes.
• Worked on 11g performance issues.

Environment: Oracle11g, SQL, PL/SQL, Windows-XP, UNIX, C Shell, Shell Scripting, Perl Scripting, ETL Process, PL/SQL Developer, Autosys.

Confidential, Boston, MA

Senior Oracle Developer - Analyst

Responsibilities:

• Working on application design, development of detail design documents, Technical specifications, debugging and testing of application programs
• Writing Netezza SQL scripts.
• Writing Batch loaders using NZload utility.
• Writing Perl scripting and shell scripting.
• Creating tables in Netezza database.
• Involved in integration netezza code wif java classes.
• Writing Autosys JIL jobs.

Environment: Netezza, Oracle10g, SQL, PL/SQL, Windows-XP, UNIX, C Shell, Shell Scripting, Perl Scripting, ETL Process, PL/SQL Developer, Autosys, Java, Rapid SQL. Informatica

Confidential, Boston, MA

Senior Oracle Developer - Analyst

Responsibilities:

• Writing design and technical documents.
• Writing packages and procedure and functions
• Creating tables and indexes.
• Writing Perl scripting and shell scripting.
• Writing UTPLSQL test cases.
• Writing JIL jobs.

Environment: Oracle10g, SQL, PL/SQL, Windows-XP, UNIX, C Shell, Shell Scripting, Perl Scripting, PL/SQL Developer, Autosys, Toad.

Confidential, Boston, MA

Senior Oracle Developer - Analyst

Responsibilities:

• Working on application development of detail design documents, Technical specifications, debugging and testing of application programs
• Mainly working on Reference Data Engine, Writing Triggers and Developing object types.
• Working on Oracle AQ mechanism.
• Writing En-queue and De-queue procedures.
• Writing Convert, update and extract Procedures.
• Performance Tuning on SQL Queries and PL/SQL Objects.
• Writing Autosys jobs and Perl scripting and shell scripting.
• Writing Recon scripts.
• Working on various enhancement requests..

Environment: Oracle10g, SQL,PL/SQL, Reference Data Engine, Oracle AQ mechanism, Windows-XP, Unix, C Shell, Shell Scripting, Perl Scripting, Autosys.

Confidential, Boston., MA

Senior Oracle Developer - Analyst

Responsibilities:

• Working on application design, development of detail design documents, Technical specifications, debugging and testing of application programs
• Mainly working on Tick Rewrite process for improving performance,
• Rewrite teh packages and procedure and functions as per new design to improve teh performance.
• Performance Tuning on SQL Queries and PL/SQL Objects.
• Writing Perl scripting and shell scripting.
• Working on Partitioning tables and indexes.
• Using Partition exchange to Move Huge data from staging tables to target tables.
• Writing Recon scripts.
• Writing JIL jobs.

Environment: Oracle10g, SQL, PL/SQL, Windows-XP, UNIX, C Shell, Shell Scripting, Perl Scripting, ETL Process, PL/SQL Developer, Autosys.

Confidential, Boston, MA

Senior Oracle Developer - Analyst

Responsibilities:

• Working on application design, development of detail design documents, Technical specifications, debugging and testing of application programs
• Write a Functions and Procedure to automate teh broker setup scripts and Broker cloning.
• Writing Shell scripts for automation of broker setup scripts and Broker cloning.
• Performance Tuning on SQL Queries and PL/SQL Objects.
• Writing Perl scripting.
• Writing oracle scripts.

Environment: Oracle10g, SQL, PL/SQL, Windows-XP, UNIX, C Shell, Shell Scripting, Perl Scripting, ETL Process, PL/SQL Developer, Autosys, HTMLDB.

Confidential, Boston, MA

Senior Oracle Developer - Analyst

Responsibilities:

• Working on application design, development of detail design documents, Technical specifications, prototypes and development, maintenance, debugging and testing of application programs
• Developing Pace Exporters and Uploaders, Panel Development.
• Developing Pace and Star reports.
• Developing PL/SQL objects, Procedures and Functions and Packages using Advanced Features.
• Writing complex SQL queries for Reports and Writing shell scripts and Perl scripts.
• Having experience wif Mercator, XML.
• Performance Tuning on SQL Queries and PL/SQL Objects.
• Worked in enhancement and customization of Eagle applications and unit testing.
• Involved in migration of Eagle applications to production environment.

Environment: Eagle PACE/STAR, Oracle9i, SQL,PL/SQL, Windows-XP, Unix, Korn Shell, Shell Scripting, Perl Scripting, MQ Series, Mercator, ETL Process, PL/SQL Developer.

Confidential, Chicago., IL

Senior Oracle Developer – Analyst

Responsibilities:

• Worked in Developing Eagle PACE and STAR applications.
• Worked in Production Support.
• Involved in using Message Center Console, Star Manager, User Manager, Position Viewer and Scheduler.
• Handling Business User Requests and Creating users, Blob Compression, Asset setup, Securities Loading.
• Worked in customizing Eagle Pace and Star applications using Importers and Exporters and Panels, SRM.
• Creating Eagle Star Reports and Scheduling.
• Developing PL/SQL objects Procedures and Functions and Packages using Collections, Cursor, Ref Cursor, and object types, record types, Temporary Table and Global temporary Tables.
• Tuning of SQL Queries and PL/SQL code.
• Preparing shell scripts and Perl Scripting.
• Unit testing.

Environment: Eagle PACE/STAR, Oracle9i, Windows-XP, Unix, Shell Scripting, Perl Scripting,, MQ Series, Control M, ETL Process. PVCS, Toad.

Confidential

Senior Oracle Developer – Analyst

Responsibilities:

• Worked in Eagle PACE and STAR Database Development.
• Worked in Database installations and upgradations.
• Install and Upgrade STAR, SRM, ARM Engines, Eagle STAR and PACE Database.
• Preparing Database scripts for creating Schemas, Tables, views, indexes, Procedures, Functions and Packages.
• Preparing Database Scripts for Data Conversion from Eagle Version 6.0 to Version 7.0 and 8.0.
• Writing Perl Scripting for STAR, SRM and ARM Engines Installation.
• Documentation.

Environment: Eagle PACE/STAR, Oracle 9i, Linux, Windows-XP, Shell Scripting, Perl Scripting, TOAD, Visual Source Safe.

Confidential 

PL/SQL Developer – Analyst

Responsibilities:

• dis project is for building access chain between Retailer Bridge and HUB ( Confidential Unified Billing) Software. me has been assigned a module which deals wif teh reading of Retail bridge interval Reading Processes file and translating it into readable CSV file formats and finally storing them into PDF files.
• me’m responsible for writing Technical spec according to Functional spec, coding according to teh technical specification and Preparing Test Cases and unit testing.
• Developing PDF and CSV Reports using Oracle Pl/SQL.
• Writing PL/SQL Objects and Writing SQL Queries.
• Unit Testing.

Environment: VB6.0, HTML, JSP, UNIX, Windows-2000, PL/SQL, Oracle - 9.x, Visual Source Safe.