CAREER UMMARY:

• Over 8 Years of professional Experience in complete Software Development Life Cycle that includes analysis, software Design, Development,implementation, maintenanceand migration on Unix, Linux, Windows environment with proficiency in Oracle technologies like Oracle database 9i/10g/11g, Oracle Application server 10g, forms 9i/10g, Oracle reports 9i/10g, Oracle Discoverer, Teradata
• Expertise inRelational database development languages like SQL and PL/SQL Big-Data skills like Hadoop, Map-Reduce, PIG, HIVE IDEslike SQL developer, PLSQL developer, SQL navigator, TOAD, SQL developer Data Modeler, Teradata SQL Assistant, eclipse ETL tools like SSIS, Informatica, Pentaho, ESF data migration tool

EXPERTISE:

• Excellent communication, quantitative, analytical and leadership skills Ability to work individually as well as in big team Waterfall as well as Agile-scrum environment.
• Transforming business requirements into technical specifications, involved in creating and implementing Technical Documentation, Root Cause analysis, Defect fix.
• DBA duties like Installation and configuration of Oracle Database, App server Client-Server architecture, e.g. Oracle Forms Reports , Developer suite, monitoring DB load and performance using Oracle Enterprise Manager, Database backup using Oracle Import/Export, RMAN utilities.
• Creating and designing database, table space, datafiles, tables, views, Materialized views, roles, indexes, DB Links, Cursors, Stored Procedures, Packages, database Triggers.
• Tuning SQL queries using Tkprof, EXPLAIN PLAN, optimizer Hints and Indexes, Parallelism, Stored Outlinesetc.
• Windows batch processes and Unix Shell scripts e.g. crontab to automate processes e.g. exporting data form specific schema, importing Billions of rows using SQL Loader and External tables from flat files to Oracle tables.
• Data migration using ETL tools such as Pentaho, SSIS, Informatica as well as Oracle native SQL Loader and External tables
• Use ofscalar, groupand analytical functions like ROW NUMBER, RANK and DENSE RANK, LEAD, LAGetc.
• Frequent useof advanced PL/SQL features such as Collections Nested Tables, Associative Arrays, Varray , bulk-binding techniques like BULK-COLLECT, FORALL and BULK-DML operations BULK-insert/update/delete Records, Types, Objects, Dynamic SQL packages such asUTL FILE, UTL MAIL.
• Experience in Entity Relation ER diagram using SQL Developer data modeler.
• Development using applications such as ORACLE Forms, Reports, Discoverer etc.
• Development of master-detail, drill down, matrix, nested summary detail reports using Oracle Reports Builder which pulled thousands of records in different formats.
• Creating complex screens using Oracle forms Builder templates, calling reports from it.
• Experience in production support and trouble shooting of database applications.

TECHNICAL SKILLS

Programming : SQL, PL/SQL, Hive, Pig, Java, Map-Reduce, C, C , R, MATLAB, Python,

HTML, Unix Shell Scrip

Operating Systems : UNIX Solaris, HP-UX , Linux Red Hat , Windows Server 2008/XP/7

Development Tool : Oracle 9i/10g Forms, Reports, Discoverer, Enterprise Manager, SVN

RDBMS : Oracle 9i/10g/11g, Teradata-14, SQL Server 2008, MS Access

IDE :

• SQL developer, PLSQL developer, SQL navigator, TOAD, Oracle Development
• Suite, Informatica, SSIS, Teradata SQL Assistant, Eclipse, Pentaho, ESF Data
• Migration toolkit, SQL Developer Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential

Role: Oracle PL/SQL Lead

Description: Confidential program has been designed where group and corporation are parties to a Primary care physician PCP participation agreement whereby group participates in the carefirst Blue choice participating Provider network maintained by corporation which was established a voluntary medical primary care medical home programme for the purpose of rewarding primary care physician for providing, arranging, coordinating and managing quality, efficient, cost-effective, health care services for individuals enrolled in health benefit plan issues and administrated by corporation Members .

Role and Responsibilities:

• Attend Daily scrum meeting to discuss and report issues during implementation.
• PL/SQL coding and taking care of new enhancement and bug fixing if any after code deployment to SIT, UAT and Production.
• Follow coding standard and took maximum measure to avoid performance issue.
• New Change Requests for Application functionality and code perspective.
• Coding, Test Data Preparation, Test Case preparation, and Unit Testing of modules.
• Delivering the product successfully to SIT and UAT Phase and to maintain the Product Version Management. Responsibility is to address any data issues found during SIT and UAT testing.
• Performing code review/analysis in a team environment and subsequent code testing in DEV and SIT environments.
• Responsible to implement the product successfully in the Production environment.
• Deployed, troubleshoot, supported database after implementation.

Confidential

Description: The objective of the activity is to evaluate the existing FLEXCUBE infrastructure capacity based on projected business volumes and scenarios. Served as a key contributor in development and enhancement projects in wealth management, investment guidance modules and compliance. I have drove the transformation project for Excessive Commissions EC module, converting the AIS 3.6 code to oracle PL/SQL and AIS 4.10.

Responsibilities:

• Managing Oracle databases in environments with stringent SLA requirements for performance and scalability.
• Involved in Creation of New Logical /Physical Data Model using Erwin.
• Involved in preparing the functional specification, technical documentation, schema documents, flow charts and user support documents.
• Business requirement gathering, analyzed legacy data management and production issues, finalized correctness criteria and designed corrective solutions, prioritized issues, and designed data quality improvements.
• Establish deliverables and meeting Business and SME's by ensuring timely and efficient completion of procedures and deployment packages for reporting purpose.
• Enhancements, adding new features and upgrading existing guidance models using PLSQL stored procedures, AIS 4.10 and XML.
• Unit and system testing.
• Loaded the data using SQL loader, imports UTL files based on file formats.
• Loaded the data from MS Excel to Oracle table and vice versa.
• Coding and Implementation of modules required for migration of data.
• Extensively used Dynamic SQL, PL/SQL Packages, Procedures and Database Triggers.
• Database performance bottlenecks, performance turning, SQL/Query optimization, RAC, ADDM, ADR and provided support to developers during development and post-implementation cycles.
• Created the Shell and Perl Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Responsible for ensuring high-availability and performance of the databases that support the systems in Oracle 10g and 11g RAC and Disaster recovery.
• Troubleshooting and application tuning experience
• Setup a Performance Testing environment equivalent to UAT environment including ETL database schemas, FLEXCUBE application, and various interfaces.
• Performance Tuning recommendations were made at different levels like database parameters, database code, end of day batch programs, and transaction save / update operations.
• Recommend SQL tuning for report queries in order for them to work efficiently on high volume scenarios.
• Code PL-SQL scripts for dynamic redistribution of tables into various tablespaces based on the size of the tables.
• Identify performance bottlenecks, rewrite, and test and recommend tuning changes for end of day batch operations.
• Monitor the performance outcomes of Interfaces and tune the same for efficiency.
• Documentation of the performance tuning analysis, re commendations and deployment strategy.

Environment: Oracle SQL PL/SQL, Actimize 4.10, Shell, XML, HTML, UNIX, Toad, Agile.

Confidential

Senior Lead Oracle PL/SQL Developer

Description: The system validates the rebate submission files generated by various vendors for the rebate validation rules defined in the system and the business rules defined by the business team.. It finally produces a return/results file with program, promotion and contact information, reject reason if rejected and sent to vendor in order to take further course of action.

• Understanding the existing application architecture, flow of the system and making changes for incorporating business needs.
• Provide parallel solution to new business requirements for the Second Brand 2nd Brand Customer without impacting the existing process by analyzing and replicating code incorporating necessary changes for dynamically created parameter table with required values populated.
• Written PL/SQL stored procedure to Identify Bridge To Value BTV customers from the historical data using analytical queries and processing it.
• Written ad-hoc Queries on the historical data to retrieve business critical needs.
• Written merge statement for bulk data updates and inserts.
• Exporting database using expdp data pump , exp export utility.
• Retrieving and loading the from external file using External table SQL Loader utility.
• Preparation of sample data for unit and integrated testing.
• Making changes to Unix shell scripts as per the requirement.
• Environment: Unix, MS Windows 7 professional, Informatica, Golden Gate, Toad.

Database : Oracle 10g, Oracle 11g

Confidential

Role: Oracle PL/SQL Consultant

Role and Responsibilities:

• 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. Created database objects, Developed and modified PL/SQL packages, functions, procedures, triggers.
• Converted Sybase code to oracle as part of migration of older to new version of database and new business requirement.
• 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.
• Performing code review/analysis in a team environment and subsequent code testing in DEV and SIT environments.
• Responsible to implement the product successfully in the Production environment.
• New Change Requests for Application functionality and code perspective.
• Unit Testing PL/SQL procedures with test cases and building Test Scripts accordingly.
• Tested, debugged and took measures for maximum performance utilizing query optimization.
• Modified shell scripts to call different procedures and functions in different environments .Created and modified Perl scripts for various functionality.
• Deployed, troubleshoot, supported database after implementation.

Environment:

Oracle 11g, Autosys, SVN, Unix Shell Scripting, Linux and AIX boxes, Eclipse, OmniGraffle, Crucible, Radar, SQL Developer, SQL Loader, Expdp, Impdp,PL SQL

Confidential

PL/SQL developer

Description: Confidential is a comprehensive Bank Automation Solution OLTP addressing the entire gamut of operations of a bank including Retail and Risk Management activities. It is based on client server technology and Branch Banking, Credits, Asset management NPA , User security and Standing Instruction. Some of the features are Signature/Document scanning and retrieval, Tele-banking, ATM interface, Any Branch Banking etc.

• Written PL/SQL stored procedures for converting the bank's legacy data to the retail banking format.
• Involved in ETL activities like Data extraction, Transformation logic as per business rule using PL/SQL stored procedure, data mapping, cleansing, standardizing
• Developed new modules using the application frame work, business frame work in n-tier architectures.
• Involved in QA, implementing the application, doing parallel run and day to day support activities.
• Escalate critical issues to seniors to take necessary actions.
• Written ad-hoc SQL queries, for testing end-to-end process.
• Revisit stored procedures/views for identified client needs.
• Verifying business object documents, database design documents. ER Diagrams and maintaining database objects.
• Involved in Enhancements and Customization of modules.
• Given demonstration and user training to end user.

Environment: VB 6.0, MS Windows NT/2000, Novell Netware 4.xDatabase: SQL Server 2000