Sr. PL/SQL Programmer. Resume NJ - Hire IT People

SUMMARY:

Over Nine years of expertise in design, development, and support of applications in relational database, client server and web - enabled environments.
2 years of Team Lead experience.
Extensive experience in Data Modeling, Schema Design (transactional and data warehouse environments), SQL, PL/SQL, SQL tuning, Database Package, Stored Procedures, Functions, Triggers, Materialized Views, Partitions and Indexes.
Experienced in Oracle development database administration, schema maintenance, schema backup, Import, Export, SQL* Loader, ETL AB INITIO, Data conversion, data scrubbing/cleansing, performance tuning, performance monitoring.
1.5 years expertise in AB INITIO an Extraction Transformation and Loading tool as a programmer and DB Migration expert.
Multi-platform experience including Windows 2000, NT and UNIX, Linux platforms. Big DATA
Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Coding and implementing business applications.
Excellent technical abilities possessing strong oral and written communications skills, analytical and interpersonal skills.
Well versed with agile philosophy for project execution.
Worked closely with users to get business requirement, convert it into tech design and data architecture and design

TECHNICAL EXPERTISE:

Languages: SQL, PL/SQL

Tools: SQL Plus, SQL Loader, TOAD, Oracle Designer, Oracle Enterprise Manager, Oracle Reports, Data Pump, Auto-sys, Control M, SFTP and FTP, AB INITIO, Perl

Databases: Oracle 8i,9i,10g,11g

O/S: UNIX, Linux, WINDOWS

Web Servers: Apache, Oracle Web Logic Server

Development: Developer 2000 (Forms /Reports 6i, 10g), Oracle Middleware (Forms /Reports 11g)

Domain: BFSI, (specialization in Investment/Private banking/Payment processing )

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. PL/SQL Programmer.

Responsibilities:

Technical and Requirement Gap Analysis of New/existing requirements for teh Modules/applications.
Solution mapping, designing and effort estimation.
Database designing by using logical and relational models.
Creating shell scripts for scheduling jobs.
Develop new packages, stored procedures and functions for new databases and maintaince of teh existing systems.
Prepare database migration plans and strategies for testing (SIT/UAT/ Production parallel and disaster recovery environments).
Performance tuning of Oracle databases by identify high-impact SQLs, verify optimal index usage, analyze and rebuild indexes, determine teh execution plan for SQL and tune SQL statement.
Data conversion and integration of front end application to teh data warehouse using SQL, PL/SQL and Stored Procedures
Prepare Hadoop query for oracle to Hadoop migration
Familiar
Creating common Library functions and templates that can be used by various projects.
Co-ordination within support teams for BAU/Hyper.
Reconciliation between FO and BO.

Environment: Oracle 11g, SQL, PL/SQL, Linux, Oracle Web Logic Server, Auto-sys, Unix, Perl, shell scripting

Confidential

Sr. Programmer for Oracle PL/SQL, AB INITIO, BW, Optima Data Archive

Responsibilities:

Identify high-impact SQL, verify optimal index usage, analyze and rebuild indexes, determine teh execution plan for SQL and tune SQL statement.
Data conversion and integration of front end application to teh data warehouse using SQL, PL/SQL and Stored Procedures.
Developed Integration and ETL scripts and stored procedures.
Developed packages, stored procedures and functions for ETL function.
Reconciliation between FO and MO.

Environment: Oracle 11g, SQL, PL/SQL, Linux, Oracle Web Logic Server, Auto-sys, unix, shell scripting

Confidential

DB Migration Expert

Responsibilities:

Migration plans and strategies for testing (SIT/UAT/ Production parallel and disaster recovery environments).
Solution mapping, designing and effort estimation.
Technical and Requirement Gap Analysis of New/existing requirements for teh Modules.
Writing PL/SQL stored packages, procedures, functions, triggers views, indexes etc.
Creating common Library functions and templates that can be used by various projects.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, shell script. Cron-tab

Confidential

Sr. Developer

Responsibilities:

Analysis of client requirements
Impact Analysis and Estimation
Code Review, System Testing/UAT/Production Implementation as on incremental basis.
Deployment/Rollback plan strategies
Client interaction for requirement gathering, system analysis, gathering of technical & functional for teh application development.
Design, development, testing, troubleshooting and debugging of teh application.
Provide post implementation, application development & maintenance support to teh client.
Programmer, Responsible for Coding, Designing, manual testing and Customization

Environment: Oracle 10g, SQL, Forms 6i, Report 6i, Unix and shell script. Autosys, Ab Initio

We provide IT Staff Augmentation Services!

Sr. Pl/sql Programmer. Resume

NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship