Profile:

Twelve Years' experience in the area of Client/Server and Distributed Multi-tier Application Development including Banking and Insurance applications , Data modelling, Database Design, Data Processing, Data Warehouse and Support mainly with Oracle technology on different platforms.

Professional Summary:

• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance and production support with timely delivery against aggressive deadlines.
• Exclusively followed Best Practices Oracle CDM and Development methodologies/Guidelines.
• Excellent experience on PL/SQL that includes Cursors, Ref-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.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.
• Expertise in developing Data Conversions/Migration from Legacy System of various sources XML, flat files, Oracle, Non Oracle Database to Oracle system Using Utl file, SQL LOADER , External table and Calling Appropriate Interface tables and API's.
• Experienced in OLTP and OLAP System Study, Analysis and E-R modeling.
• Experience in creating and registering Concurrent executables, Concurrent Programs, Tables, developing Descriptive Flex fields in Custom Applications and defining profile values using Application Object Library AOL , System Administration in Oracle E-Business Suite Applications.
• Excellent experience in accessing Webservices using oracle API's Oracle Net Services and HTTP . Created common interface to access webservices in other modules.
• Very good experience in Using AQ-MQ Messaging Process to send message to MQ Server.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Expert on Dynamic SQL, Analytic functions, Parallel execution, Process scheduling, Table partitioning, Oracle supplied packages, Collections , Exception handling , Oracle Hints, PIVOT.
• Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace , Cost-Based Optimization CBO and TKprof.
• Developed materialized views for data replication in distributed environments.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Familiar Oracle DBA activities: Managing schema and Maintenance Table space, Data Files, Tables, Indexes etc. , Database security Row level security, User Privileges Roles .
• Data warehousing and Business Intelligence: Data modeling in dimensional structures - Star/Snowflake schema, ETL, Change Data Capture CDC , OLAP, OLTP mostly using PL/SQL as manual ETL.
• Experience with SQL Server Analysis Services SSAS .
• Experience in extracting and transforming ETL process data using DTS/SSIS Import Export Data from various sources.
• Proficient in using UNIX, Shell Scripting, SFTP. Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Skills and Knowledge:

Professional Experience:

Confidential

Senior Database Developer

Charleston County promote and protect the quality of life in Charleston County by delivering services of value to the community.

Roles Responsibilities: Lead Developer and Designing application and modules

• As a Senior Database Developer, I am responsible for Development, Customization Implementation and production Support of the Oracle based Custom Charleston County Applications.
• Created data warehouse objects Fact tables, dimension tables, table partitions, sub-partitions, normal and bitmap indexes, summary tables, materialized views, dimensions, cubes, stored packages, functions and procedures with parallel queries, making indexes unusable and rebuilding local indexes for partition exchange loading PEL . Modeled Data Warehouse in dimensional structure Star schema.
• Created PL/SQL SQL scripts for the ETL Converting/Migrating data from other systems, Oracle, XML and Flat files into Oracle database tables for Data warehousing and BI purpose. Used Sql loader, external tables and Utl file for the purpose of loading flat file And XML data.
• Created composite SQL script using Dynamic SQL, Analytical function, PIVOT.
• Used aggregate routines for views, summary tables, materialized views, reports etc.
• Utilized business rules for data profiling, data analysing and cleansing.
• Created ETL procedures to transfer data from legacy sources to staging area and from staging area to data warehouse using Oracle Warehouse Builder.
• Prepared shell scripts for ETL to run in batch.
• Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
• Extract data into Oracle table using SQL LOADER and EXTERNAL Table.
• Writing 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.
• Loading data from various claim management application such as Facets, Cosmos, Diamond, DBP and RX Solution etc. for encounter submission.
• Tested and took measures for maximum performance utilizing optimization hints, processors, storages and query optimization.
• Resolved Query Level Performance tuning issues using Explain Plan, SQL Trace and TKPROF utilities to pin point time consuming SQLs and tuned them by creating indexes and forcing specific plans.

Environment: Linux Server for Database, Oracle 11g Database, Oracle 11g Web Logic Server, PL/SQL, TOAD, OEM, Shell Scripts.

Confidential

Senior Database Developer

Rwanda Revenue Authority is to provide most of its services through Internet in order to enhance service efficiency and prohibit tax evasion.

Roles Responsibilities: Lead Developer and Designing application and modules

• As a Senior Database Developer, I am responsible for Development, Customization Implementation and production Support of the Oracle based Rwanda Revenue Authority Applications.
• Designing and modifying of Database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Converting/Migrating data from SQL Server, XML and Flat files into Oracle database tables for Data warehousing and BI purpose.
• Created Oracle procedures to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Improved query performance by Query Optimization, Debugging and Tuning using Explain Plan, SQL Trace and TKprof.
• Created data entry Forms using oracle Forms 10g for entering data related to Engineering Information and inventory.
• Using Webutil to Create forms that Validate Application Login through LDAP Sever.
• Support Data warehouse, ETL Process.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
• Involved in handling Database Security Related issues as suggested by the guidelines set by the company.

Environment: Linux Server for Database, Oracle 11g Database, Oracle 11g Web Logic Server, PL/SQL, TOAD, OEM, Shell Scripts

Database Developer

Roles Responsibilities: As a Database Developer, I am responsible for Development and Support of the Oracle based Applications in CMC Projects.

• Application Database Performance Tuning Troubleshooting.
• Prepare DB Scripts for DML and DDL.
• Writing PL/SQL programs for Java and .Net applications.
• Writing PL/SQL programs for Batch process. Involved in writing Shell Scripts also.

Environment: Oracle Database, PL/SQL, TOAD, Shell Scripts.

Projects:

• Developer December'
• CHOLA: Cholamandalam MS General Insurance Company Ltd is an Indian assurance firm and a joint venture between the Murugappa Group, an Indian conglomerate, and the Mitsui Sumitomo Insurance Group, a Japanese assurance company.
• Database Developer
• Confidential is an Indian assurance firm and a joint venture between the Murugappa Group, an Indian conglomerate, and the Mitsui Sumitomo Insurance Group, a Japanese assurance company.
• Database Developer
• Confidentialis an Information Technology services, consulting and software company having its Headquarters in New Delhi, India. CMC is part of the TATA Group and is a subsidiary of Tata Consultancy Services.
• Database Developer
• Confidential, formerly known as Gujarat Ambuja Cement Limited, is a major cement producing company in India. The Group's principal activity is to manufacture and market cement and clinker for both domestic and export markets.