SUMMARY

• Having 6.5 year’s experience with proven ability in the area of Distributed Multi - tier Application Development, Database Design, Data processing, Production Support mainly with Oracle Technology on different platforms.
• Having experience of leading and mentoring the team of 6 developers to understand the architecture, database design, functional and non-functional requirements of the project/product.
• Experience on ETL tools (Informatica 8.6) in a Data Warehouse environment.
• Extensive experience in Banking and Finance domains.
• Experience in implementing various query-optimization techniques and business rules with relational databases in data warehousing environment.
• Experience in monitoring Performance and Tuning of the database for optimization using Explain Plan, OEM, Tkprof Report, and AWR.
• Extensive experience in Data Analyst role, Involved in clarifying business requirement with customer, data analysis, creating mapping document source to target system in Informatica platform.
• Expertise on PL/SQL that includes Cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools etc.
• Expertise in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table and Calling Appropriate Interface tables and API’s.
• Worked on ETL tool Informatica Power Centre 8.6 using Oracle Data Integrator(ODI) with Oracle 10g database for end to end mapping from legacy database - IMS to oracle database
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
• Wrote complex batch process in PL/SQL for huge data.
• Experienced in working in a production support team and handling of issues on 24/7 batch environment.
• Experienced in working on UNIX platforms in file-handling and loading files into the Oracle and SQL Server databases.
• Handled large scale Multi-Terabyte databases.
• Skilful problem solver with excellent analytical skills.
• Has good experience in other tools like UNIX Shell Scripting, TOAD, XML, SQL Navigator
• Experience in Data flow Diagram, ER Diagrams using Oracle Designer.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.
• Experienced in all phases of the System Development Life Cycle (SDLC) and Best Practices (Oracle CDM) and Development Methodologies/Guidelines.
• Accomplished in working with users/upper-level management in translating their business needs into logical systems designs, as well as working in a technical team to implement the designs.
• Have experience in Relational and Dimensional Data modelling, Normalization, Denormalization, Data Architecture

TECHNICAL SKILLS

Languages: SQL, SQL plus, PL/SQL, C, C++,Informatica 8.6

RDBMS: Oracle 11g/10g/9i, MYSQL

Case tools: Oracle Designer 10g/9i/6i, ERwin 7.3

Methodology/Best Practice: Oracle CDM Advantage 2.0

Others Tools /Technologies: TOAD, SQL Navigator, SQL Loader, Oracle EXP, ODBC, FTP

Operating Systems: Unix, Windows

Version Control Tool: MS Visual Source Safe, SVN

GUI Tools: VB6.0, HTML

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

Oracle PL/SQL Consultant

Environment: Informatica 8.6, Oracle 10g

Responsibilities:

• As a data analyst prepared the Source to Target mapping design, validate the design templates.
• Developed SQL Scripts for data validations based on requirements.
• Report the data gaps due to acquired portfolios and data elements not present on systems.
• Daily meeting with business team to clarify the significant gaps/assumptions and ask business to made decisions.
• Identify all supporting data requirements like application interdependency and reference data requirements.
• Validate the RBCB data which Confidential has acquired for portfolios after mapping is implemented.
• Daily Status update and Notify the ETL team for implementation of corresponding RBCB data mapping provided.
• Data extraction and generate report for respective portfolio and provide to business for verification of the data.
• Provide RBCB merging data for 5 years which Confidential has acquired, Once data is verified by business.
• Executing the defined actions within the timeframe specified to ensure timely submission of RBCB data.
• Notify to ETL team for the impact of any major changes either in structure/data.
• Update the Impact Analysis Document for any data deviation, during validation.
• Validating data as part of QA1/QA2 and Mock testing
• Worked on ETL tool using Oracle Data Integreater(ODI) mapping and integrate data for various data servers.
• Worked extensively with Power Builder, Power Desingner for design purposes.
• Created PL/SQL & SQL scripts for the ETL Converting/Migrating data from Mainframe, DB2, Oracle, XML, Flat files into Oracle database tables for Data warehousing and BI purpose. Used external tables, Utl file and SQL LOADER for the purpose of loading flat file And XML data.
• Performing code review/analysis in a team environment and subsequent code testing in DEV and SIT environments.

Confidential

Oracle PL/SQL Consultant

Environment: Oracle 10g,PL/SQL,ETL,BO,.NET3.5.

Responsibilities:

• Involved in the Requirement gatherings (SRS) and Development of the Project.
• PL/SQL coding, Developing procedures, Functions, database triggers, creation of tables, Views, cursors..etc
• New Change Requests for Application functionality and code perspective.
• Responsible to create / modify reports to meet changing business needs.
• Provide complex queries for Data extraction by BO for Report generation.
• Tuning of SQL queries and PL/SQL Performed performance tuning.
• Coding, Test Data Preparation, Test Case preparation, and Unit Testing of modules.
• Delivering the product successfully for the UAT Phase and to maintain the Product Version Management. Responsibility is to address any data issues found during UAT testing.
• Responsible to implement the product successfully in the Production environment.
• Involved in the Requirement gatherings (SRS) and Development of the Project.
• Created database objects, Developed and modified PL/SQL packages, functions, procedures, triggers.
• New Change Requests for Application functionality and code perspective.
• Responsible to create / modify reports to meet changing business needs.
• Provided complex queries for Data extraction by Business Objects tool for Report generation.
• Unit Testing PL/SQL procedures with test cases and building Test Scripts accordingly.
• Tested, debugged and took measures for maximum performance utilizing query optimization.
• Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Modified shell scripts to call different procedures and functions in different environments to run in different time periods.
• Deployed, troubleshoot, supported database after implementation.
• Performing code review/analysis in a team environment and subsequent code testing in DEV and SIT environments.

Confidential

Oracle PL/SQL Consultant

Environment: Oracle 10g,PL/SQL,TOAD,Windows 2003, Web Logic 8.1.

Responsibilities:

• Requirements analysis and solution preparation by co-ordination with client and onsite coordinator.
• Understanding the user request doing changes to the Current application codes to make sure after deployment the applications run smooth.
• PL/SQL coding, Developing procedures, Functions, database triggers, creation of tables, Views, cursors..etc.
• New Change Requests for Application functionality and code perspective.
• Data extraction through sql queries for Report generation.
• Tuning of SQL queries and PL/SQL. Performed performance tuning.
• Involved in the Development and maintenance of the several parts of the Project.
• Coding, Test Data Preparation, Test Case preparation, and Unit Testing of modules.
• Delivering the product successfully for the UAT Phase and to maintain the Product Version Management. Provide the UAT Support. Responsibility is to address any data issues found during UAT testing.
• Responsible to implement the product successfully in the Production environment.
• Develop pl/sql interface packages and modified existing pl/sql interface processes
• Wrote UNIX shell scripts
• Loading data using SQL*Loader
• Created DDL, DMLand DCL scripts
• Wrote database triggers, created database links, synonyms. snapshots
• Technical documentations(MD 70/MD60), Creating test cases/test plan/test result documentations

Confidential

Oracle PL/SQL Consultant

Environment: Oracle 10g,PL/SQL,TOAD,Windows 2003,Asp.net.

Responsibilities:

• Requirements analysis and solution preparation by co-ordination with client and offshore Team Lead.
• Understanding the user request doing changes to the Current application codes to make sure after deployment the applications run smooth.
• PL/SQL coding, Developing procedures, Functions, database triggers, creation of tables, Views, cursors..etc.
• New Change Requests for Application functionality and code perspective.
• Involved in the Development and maintenance of the several parts of the Project.
• Coding, Test Data Preparation, Test Case preparation, and Unit Testing of modules.
• Delivering the product successfully for the UAT Phase and to maintain the Product Version Management. Provide the UAT Support. Responsibility is to address any data issues found during UAT testing.
• Responsible to implement the product successfully in the Production environment.
• Created database objects And Developed and modified PL/SQL packages, functions, procedures, triggers.
• Wrote PL/SQL code for Oracle Job Scheduling and Maintain Batch jobs.
• Load data into Oracle table using SQL*LOADER and EXTERNAL Table.
• Wrote Complex SQL script, Analytical Function.
• Improved query performance by query optimization - tracing the query execution plan (explain plan).
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.