Resume
5.00/5 (Submit Your Rating)
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
ConsultantResponsibilities:
- 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.