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
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Expertise in REVELEUS/ Confidential (BASEL, LRM, PFT) part of Oracle Financial Services.
• Strong leader with experience developers and advising technical groups on ETL best practices
• Fully conversant with Functional Study, Requirement Gathering, Analysis, Design, Development, Testing and Deployment.
• 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.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Has proven record in managing end-to-end development life cycle of the complex projects.
• Experience in leading and managing teams up to 10 people.
• 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
• Proven experience in development and implementation of applications in various domains viz. Telecom, Finance, Banking and HealthCare
• 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.
• Experience as an Application DBA Oracle.
• Good team player with excellent interpersonal and leadership skills.
• Quick learning, committed and able to work under pressure.

TECHNICAL SKILLS:

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

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

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

ETL TOOL: REVELEUS / Confidential, Informatica Power Center 8.6.1.

Operating Systems: UNIX, Linux, Windows.

Servers: Apache Tomcat 6 & 7.

PROFESSIONAL EXPERIENCE:

Consultant

Confidential

Responsibilities:

• Involved in Entire SDLC for PD/LGD Credit Risk Project.
• Created the ETL architecture and provided strategy related to data cleansing, data validation and importing of data into the Confidential Download Specification format.
• 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.
• Identify requirements, interpret business logic, develop code and design the Architecture accordingly to meet the Business Logic.
• 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.
• 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.
• Created Partitions for Performance Tuning.
• Involved in developing Contractual Run, Business As Usual, Intraday Liquidity and Forecasting.
• Involved in configuring the Confidential LRM Business Rules.
• Involved in data model changes for Confidential LRM using ERWIN.
• Effectively used AWR and ADDM reports for PT.
• Involved in development of writing Data Base queries.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts
• Performed Unit, Integration, and Regression testing.
• Involved in METADATA Restore and Archive.

Environment: UNIX, Windows, Oracle 11g, TOAD, SQL Developer.

Confidential

Consultant

Responsibilities:

• Installed Confidential Infrastructure and Basel Solution.
• Involved in configuring the LRM Business Rules.
• General maintenance and change control identification impacts on the Capital Calculation System in the Oracle Financial Services Analytical Application Infrastructure Confidential /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 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
• Worked with AWR and ADDM reports.
• Involved in upgrade of Confidential servers and installation of patches.
• Worked on migration from BASEL II to BASEL III.
• Optimized code in Confidential to meet BASEL III requirements.
• Created DT, Rules and Runs in Confidential
• Involved in METADATA Restore and Archive.

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

Confidential

Consultant

Responsibilities:

• Create Package, Procedures and Functions to get current Products price-Tiers, and future pricing options to vendors.
• Production Support.
• Extract data from xml files and load in the tables. Created History tables for the same.
• Bug Fixing and Production support in agile environment.
• Write Shell Script to automate task for ETL process.
• Production support as required.
• Performed tuning of existing packages, to reduce the runtime and increase efficiency.
• 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 Cerner 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

Confidential

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.