Executive Summary

Result-oriented professional having vast experience in the IT industry who excels at managing and executing mainly Database oriented assignments and client/server custom development projects, across the entire project lifecycle SDLC , collaborating with project teams, interfacing with clients, and deploying technology to build successful solutions for customers. I have used a variety of development tools like oracle forms developer 6i,10g, oracle report builder 6i,10g, OWB, OWF, Oracle discoverer ,OBIEE and I am also a Oracle certified SQL Expert. The Major Strengths include strong leadership, excellent communication skills, competent, strong team player, attention to detail, dutiful respect for compliance in all regulated environment, as well as supervisory skills and a clear vision to accomplish the company goals.

Professional Summary

• More than 14 years of experience in Information Technology in the field of Systems Development, Software Development, Web Development, Systems Integration, Shared Services and Project Resource Management with about last 5 years of experience in ERP system.
• Technically competent with several years of hands-on development experience with Oracle
• Database administration and maintenance such as db creation, user and roles creation, stored procedures, triggers, maintenance plan, DTS and replication using Oracle.
• Super Knowledge on data modeling for both OLTP OLAP.
• Solid experience in application development Oracle forms developer Oracle developer suite 10g 6i .
• 8 years experience in Oracle PL/SQL, SQL tuning and overall database performance tuning, advance PL/SQL techniques i.e. collection, REF cursor, table function etc .
• Expert hands on analytic functions.
• Hands on Experience on PLSQL Web Toolkit
• Clear concept on data warehouse design i.e. Star schema snow flake
• Super Knowledge on handling large volume of data Multi terabyte
• Hands on experience on parallel execution, table partitioning, process scheduling.
• Very much expert on developing database trigger, procedure, package, functions and have some more expertise on scheduling with dbms package and implement RLS row level security .
• Expert on Dynamic SQL
• Expert hands on oracle built in packages i.e. DBMS ,UTL etc
• Super knowledge on Data Pump.
• Expert hands on data loading with SQL loader and external tables.
• Expert hands on AWR snapshots, database space administration, Query optimization, CBO Cost based optimizer , SQL tuning with STA Sql tuning advisor , ADDM, Temporary segment monitoring, long running process monitoring and oracle wait events.
• Hands on experience on data migration from test server to production server.
• Duplicate database.
• Hands on experience on OEM.
• Experience on data movement with transportable tablespace, expdp, impdp, exp, imp.
• Experience in Object Oriented Analysis and Design OOAD techniques like Unified Modeling Language UML , IT Security and Controls Authentication Authorization
• Worked with different reporting tools Oracle Report, Crystal Report .
• Extensive Knowledge on Oracle 10g 11g
• Technical experience in architecting and building client / server applications and handling on-site/offshore models
• Knowledgeable in Data Modeling/Database Design using SD-pro and MS Visio
• Expertise on working in Linux environment
• Experience working in virtual teams and multi-cultural environment.

Managerial Skills

• Effective leadership experience driving process improvements
• Excellent Oral/written communication, presentation and documentation skills

Technical skills

Projects

Confidential

Senior Software Engineer

Responsibilities Development :

• Requirement collection for ESA, ODS and EDW system from the business analyst.
• Data modeling for ESA, ODS and EDW
• Satisfy the other team like SOA, WEB and ETL with the data model.
• Identify the data loading strategy
• Design the PL/SQL process flow for ODS and EDW.
• Develop the engine using oracle advance PL/SQL Bulk collection, Ref cursor, table function etc to load the data in ODS and EDW in a Multilanguage environment.
• Develop advance level SQL using Analytical Function for the other teams like SOA, WEB etc
• Java Classes as a external routine in this project for building processes

Responsibilities Production Support :

• Identify the process tables that are candidate of partitioning.
• SQL tuning
• PL/SQL process tuning
• Query optimization
• Database tuning with the standard diagnostic tools i.e. AWR, ADDM, STA etc .
• Data loading by using SQL Loader and External Tables
• Data movement by using data pump
• Optimize the database performance by introducing index, partition table, and materialized view by using ORACLE 11g new features.
• Monitor the process execution in all the environment Development, QA, Production
• Database tuning with the standard diagnostic tools i.e. AWR, ADDM, STA etc .
• Be on call in off hour and holidays for any production related issues.
• Maintain all the documents and coding using version control system like CVS, SVN.
• Check alert log file on daily basis.

Technology: Oracle 10g, Oracle 11g, Linux, Toad, shell scripting, MS Visio, CVS, SVN, data pump

Confidential

Software Engineer

Responsibilities:

• Data Modeling both Logical and Physical.
• Develop required PL/SQL procedure, function and package to incorporate the business requirements.
• Develop necessary process with PL/SQL to prepare data for BI reporting
• Review the PL/SQL codes from the point of data accuracy and performance before deploy those codes in production.
• Develop required PL/SQL using general and advanced level PL/SQL techniques i.e. Bulk collection, REF cursor, table function etc
• Advanced level SQL development using analytic functions.
• Query Optimization
• Develop Procedures, functions using Oracle 10g for accounting calculation
• Create many packages for different operations and all related functions and procedures bind with packages
• Create Java classes as a external routine in this module which is co-related in different function and procedures
• PL/SQL process tuning
• Also fine tuning Oracle 11g for faster query execution
• Prepared technical documentation like business processes and requirements, Functional Technical Design,
• Participated in User Acceptance Testing UAT and Implementation.
• Preparing Unit Test Cases and User Test Cases and performing Integration/Systems Testing

Environment: Oracle 11g, Windows, JSP as frontend, Java2 Microsoft Visio, Microsoft Project