SUMMARY

• 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
• 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, PythonHTML, 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, Owings Mills, MD

Oracle PL/SQL Lead

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, Boston, MA

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, Bellevue, WA

Senior Lead Oracle PL/SQL Developer

Responsibilities:

• 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.

Confidential, Durham, NC

Oracle PL/SQL Consultant

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

Responsibilities:

• 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
• Verifying business object documents, database design documents. ER Diagrams and maintaining database objects.
• Revisit stored procedures/views for identified client needs.
• Written ad-hoc SQL queries, for testing end-to-end process.
• Escalate critical issues to seniors to take necessary actions.
• Involved in QA, implementing the application, doing parallel run and day to day support activities.
• Developed new modules using the application frame work, business frame work in n-tier architectures.
• 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