We provide IT Staff Augmentation Services!

Resume

ConsultanT

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

Consultant

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.

Hire Now