SUMMARY

• 10+ years of diversified IT experience in various phases of software development especially in analysis, design, development, testing and implementation as an Oracle Developer
• Proven experience in development and implementation of applications in various domains viz. Telecom, Finance, Banking and HealthCare
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Expertise in REVELEUS/OFSAAI part of Oracle Financial Services.
• Strong leader with experience training developers and advising technical groups on ETL best practices
• Experienced in all the phases of SDLC - Analysis and Design, Data Modeling - ER Diagrams and Normalization, Documentation, Development, Testing and Deployment in both Client/Server as well as Web-based environments
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e. Packages, Stored Procedures, Cursors and Views for processing data, Functions & Triggers enforcing referential integrity and needed business rules.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Involved in creating Schemas, Roles, and Tables. Migrating environment from TEST/DEV to QA to Prod. Granting privileges to users.
• Expertise in Format Triggers, Formula Columns, Summary Columns, Placeholder Columns and Ref Cursor Query for new report development and preparation of complex Data Models.
• Proficient in performance tuning using SQL Trace, Explain Plan, tkprof, DBMS PROFILER, Indexing and Hints which are used for gaining significant improvements in system response time and efficiency
• Involved in performance enhancement after migration of the databases from Oracle 10g to Oracle 11g on different servers
• Excellent working and conceptual knowledge of SQL, PL/SQL, Oracle Forms, Oracle Reports, UNIX Shell Scripting, XML,HTML
• Proficient in Oracle tools and utilities like SQL*PLUS, SQL developer, SQL Navigator, SQL*Loader and TOAD
• Worked with ETL tool Informatica.
• Experienced in relational and dimensional data modeling, physical and logical data modeling using ER-Win 7.1/7.3/4.0 and Data Migration using SQL*Loader.
• Experience as an Application DBA Oracle.

TECHNICAL SKILLS

Languages: Shell Scripting, SQL, PL/SQL, Java, C#, COBOL

Shell Front End: Visual Basic, ASP.NET, HTML, Oracle Forms

Databases: Oracle 8i, 9i, 10g, 11g, SQL Server 2005, 2008

ETL TOOL: REVELEUS /OFSAAI, Informatica Power Center 8.6.1

Operating Systems: UNIX, Linux, Windows

Reporting Tools: Developer Suite, Oracle Reports

Front-end: Developer-2000, Developer-6i, Forms, Reports, ASP, VB-6

Web Technologies: HTML,XML

Query Tools: Toad, SQL Plus, SQL Navigator, SQL Developer, PL/SQL Developer

Database Modeling: Erwin

PROFESSIONAL EXPERIENCE

Confidential

OFSAA Developer/ OFSAA Technical Consultant

Responsibilities:

• Bug Fixing and handling daily Production Issues in PL/SQL.
• Coding of Application Program from Specifications using PL/SQL.
• Analyze business requirements and create project specifications.
• Efficiently identify the columns associated for ETL and Transformations from Existing Tables and use Dynamic PL/SQL to extract them as to maintain Data integrity and Performance.
• Created Functions and Triggers, Procedures and Packages in PL/SQL.
• Extracted data from Flat Files and Loaded tables in Oracle database using SQL LOADER.
• Worked on Multiprocessing Model with (FTP, PFT, ALM, BSP)
• Worked on all aspects for OFSAA Allocation Engine for PFT and BSP.
• Created Partitions for Performance Tuning.
• Calculate NII using Benchmark Yield Curve
• Use T2T and compile procedures to calculate spread earned on assets & liabilities.
• Calculate interest rate RISK exposure as a result of the same.
• Involved in configuring the OFSAA Business Rules.
• Involved in Data Model changes for OFSAA using ERWIN.
• Effectively used AWR and ADDM reports for PT.

Environment: Oracle 12g, UNIX, TOAD.

Confidential, Strongsville, OH

Senior Software Developer

Responsibilities:

• Involved in Entire SDLC for PD/LGD Credit Risk Project.
• Involved in set up of Greenfield Bridge a new Database, created Schemas, tables, roles, Granted Privileges for users to access the DB. Promoted Schema from DEV/TEST to QA to PROD.
• Submitted DTG request to promote schemas, tables, roles to different environments.
• Efficiently identify the columns associated for ETL and Transformations from Existing Tables and use Dynamic PL/SQL to extract them as to maintain Data integrity and Performance.
• Created Functions and Triggers, Procedures and Packages in PL/SQL.
• Used Shell Scripting and SQL along with PL/SQL for automation of jobs in UNIX.
• Worked on PERFORMANCE TUNING issues to efficiently reduce the RUNTIME of batches by PARTITIONING tables, creating and dropping index, using BULK collect.
• Extracted data from Flat Files and Loaded tables in Oracle database using SQL LOADER.
• Bug Fixing and handling daily Production Issues in PL/SQL.
• Created Partitions for Performance Tuning.
• Effectively used AWR and ADDM reports for PT.
• Creation of testing scenarios to support the validation of the continued effectiveness of the data submission, data validation with accompanying exposure-level data.
• Verification of resultant output from testing scenarios to ensure accuracy in PD/LGD.
• Definition and verification of data quality validation checks for the work-stream file-level data integrity
• Involved in creating test scenarios for PD/LGD CREDIT RISK Project.
• Involved in Metadata Restore and Archive.

Environment: UNIX, Windows, Oracle 11g, OFSAA.

Confidential, San Francisco, CA

OFSAA Developer

Responsibilities:

• General maintenance and change control identification impacts on the Capital Calculation System in the Oracle Financial Services Analytical Application Infrastructure OFSAAI/REVELEUS
• Worked closely with Project Team, SME and Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications.
• Created Functions and Triggers in PL/SQL.
• Used Shell Scripting and SQL along with PL/SQL for automation of jobs in UNIX.
• Worked on PERFORMANCE TUNING issues to efficiently reduce the RUNTIME of batches by PARTITIONING tables, creating and dropping index, using BULK collect.
• MIGRATED database to Oracle 11g from 10g.
• Extracted data from Flat Files and Loaded tables in Oracle database using SQL LOADER.
• Bug Fixing and handling daily Production Issues in PL/SQL.
• Authorizing Change Controls, describing technical and business requirements impacting upstream (Data Collection System- DCS) to downstream (Reporting System).
• Creation of testing scenarios to support the validation of the continued effectiveness of the data submission, data validation, capital calculation, with accompanying exposure-level data
• Verification of resultant output from testing scenarios to ensure accuracy in capital calculation
• Definition and verification of data quality validation checks for the work-stream file-level data integrity
• Responsible for Training of file submitters across USA as well as DI officers from L.O.B. to ensure efficient submissions for the quarterly production data submission through the DCS
• Involved in SDLC for BASEL III Project.
• Involved in upgrade of OFSAA servers and installation of patches.
• Worked on migration from BASEL II to BASEL III.
• Optimized code in OFSAA to meet BASEL III requirements.
• Created Hierarchies and Business Processors & Business Measures in OFSAA.
• Created DT, Rules and Runs in OFSAA
• Involved in METADATA Restore and Archive.

Environment: UNIX, Windows, Oracle 11g, UNIX, PL/SQL, OFSAA/REVELEUS

Confidential, Irving, TX

Software Engineer

Responsibilities:

• Create Package, Procedures and Functions to get current Products price-Tiers, and future pricing options to vendors.
• Extract data from xml files and load in the tables. Created History tables for the same.
• MIGRATED database to Oracle 11g from 10g.
• Bug Fixing and handling daily Production Issues in PL/SQL
• Created Functions and Triggers in PL/SQL.
• Bug Fixing and Production support in agile environment.
• Production support as required.
• Performed tuning of existing packages, to reduce the runtime and increase efficiency.
• Involved in METADATA Restore and Archive

Environment: UNIX, Oracle 11g, TOAD, PL/SQL Developer.

Confidential, KANSAS CITY, MISSOURI

Software Engineer / PL/SQL Developer

Responsibilities:

• Involved in gathering requirements and created mapping document and design document.
• Involved in development of complex ETL Mappings and Stored Procedures in Optimized manner.
• Created and modified existing packages, Procedures for ORACLE to meet Business Requirements.
• Imported data from flat files and database tables to create mappings in INFORMATICA.
• Involved in unit testing and system testing.
• Worked on bug fixing on existing Informatica Mapping to produce correct output.
• Worked with Confidential Command Language (CCL).
• Worked with Quality Center testing tool.
• Worked extensively with Data Modeling team & Architects to create Data Model using ERWIN.
• Created INFORMATICA Workflows.

Environment: UNIX, WINDOWS XP, Oracle 11g, INFORMATICA, Quality Center testing tool

Confidential, Phoenix, AZ

Oracle PL/SQL Developer

Responsibilities:

• Involved in the entire SDLC of the HIPAA 5010 Encounters project.
• Experienced in Fundamentals of Health Care Management such as Encounters, Enrollments and Demographics.
• Extensive coding to generate Capitation Reports and automation of the same.
• Used Shell Scripting and SQL along with PL/SQL for automation of jobs in UNIX.
• Created Packages and Procedures to check client eligibility as well as the RBHA enrollment eligibility for a given time period.
• Made use of Java Web Services and Oracle Coherence.
• Monitor Batch Processing and update tables concurrently in production environment.
• Imported data into tables from XML and flat files using Excel, SQL Loader etc.
• Converted an existing Package into PL/SQL and reduced the run time from 3 days to 1 day.
• SME in Health care domain for claims processing including 820, 834, 837 claims.

Environment: UNIX, Oracle 11g, WINDOWS.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Coding of Application Program from Specifications using PL/SQL.
• Analyze business requirements and create project specifications.
• Efficiently identify the columns associated for ETL and Transformations from Existing Tables and use Dynamic PL/SQL to extract them as to maintain Data integrity and Performance.
• Created Functions and Triggers, Procedures and Packages in PL/SQL.
• Extracted data from Flat Files and Loaded tables in Oracle database using SQL LOADER.
• Involved in writing procedures, collections, functions, cursors, triggers, and packages for new requirements.
• Imported data into tables from XML and flat files using Excel, SQL Loader etc.
• Wrote SQL queries for data validation, extraction and loading.
• Tuning SQL queries used in the applications to improve performance.

Environment: Windows, Oracle 9.1.0, UNIX.

Confidential

Oracle Pl/SQL Developer

Responsibilities:

• Coding of Application Program from Specifications using Oracle Pl/SQL and Pro*C.
• Analyze business requirements and create project specifications.
• Coding of Application Program from the Specifications using Pl/SQL.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL.
• Tuned performance of existing SQL statements and PL/SQL code and Performed code review with team members
• Wrote SQL Queries for data validation, extraction and loading.
• Developed test plans and participated in unit testing, system testing and implementation.

Environment: Linux, Oracle 8.1.7, TOAD, UNIX.

Confidential

Oracle Pl/SQL Developer

Responsibilities:

• Experienced on fundamentals of the investment management, such as Securities, Financial Instruments (Stocks, Bonds, and Mutual Funds).
• Analyze Business requirements and create project specifications.
• Coding of Application Program from the Specifications using Pl/SQL.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL.
• Tuned performance of existing SQL statements and PL/SQL code and Performed code review with team members.
• Involved in EOD (End of the Day) support issues.
• Wrote Stored Procedures and Scripts for moving data into central repository for client and account.
• Efficiently used Explain Plan to tune code for performance.

Environment: Windows, Linux, Oracle 8.1.7, Oracle SQL DEVELOPER.