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, Philadelphia, PA

Senior Oracle PL/SQL Developer

Responsibilities:

• Work in Agile-Scrum environment, coordinating in a big group (20 people) located in multiple locations and time zones (On-shore, near-shore, off-shore model).
• Interact with the business specialists every Sprint in identifying the code defects, and providing fix by performing root cause analysis
• Transform business requirements into Technical specification, involved in root cause analysis, database design, coding and implementing, Unit as well as Regression testing
• Load Billions of rows from multiple kinds of sources (e.g National Data Warehouse - Teradata, Biller system - Oracle, CPOS - SQL Server) into oracle tables using DB Link, external table, SQL*Loaderas well as ETL tool Pentaho
• Tuned SQL queries using EXPLAIN PLAN, Optimizer Hints and Indexes (simple as well as Composite)
• Improved performance of large database (~ 10 TB) by creating index, partitioning tables, indexes, creating and tuning Materialized Viewsetc.
• Frequently used MS excel like Pivot tables, charts, VLOOKUP for reporting purpose
• Advanced Oracle and PL/SQL features like Collections, Bulk collect, Dynamic SQL, Analytic functions (e.g. row number, rank etc.) in the new routines as well as to modify the existing routines work more efficiently
• Load data to salesforce.com DB through complex Pentaho-Kettle job, transformations for advanced analytics
• Regularly involved in Testing, Integration, production deployment and documentation of the project

Environment: Oracle-11gR2, TOAD-11.5, SQL Developer-3.1, Windows 7, MS Excel 2013, Pentaho 4.4, Eclipse 4.3.2, Cygwin 1.7, Tortoise SVN

Confidential, Memphis, TN

Senior Oracle PL/SQL Developer

Responsibilities:

• Constantly interacted with the business analysts and managers for their requirements
• Transforming business requirements into Technical Documentation, involved in analysis, database design, coding and implementing
• Loaded Giga-bites of data into oracle tables using External table, Table partitioning, SQL*Loader, SSIS, Informatica and wrote batch scripts to automate the process.
• Extensively used Oracle PL/SQL language to develop complex stored packages, procedures, functions, triggers, Text queries & Text Indexes etc. to process raw data and prepare for the statistical analysis.
• Extensively used statistical language like R, Python, software like Spotfire, spreadsheet like MS-excel (statistical functions, pivot table etc.) to perform statistical analysis.
• Generated different kinds of reports e.g. drill down, nested summary detail reports as per management and business-analyst request using Oracle Report builder.
• Automated jobs using oracle supplied package DBMS SCHEDULER.
• Frequently used advanced Oracle and PL/SQL features like Dynamic SQL, Ref-Cursor, Bulk collect, Analytic functions (e.g. ratio-to-report, rank etc.) in the new routines as well as to modify the existing routines work more efficiently.
• Partitioned tables used Parallelism and created index to increase performance of large database (~ 5 TB).
• Tuned SQL queries using EXPLAIN PLAN, Optimizer Hints and Indexes.
• Used Java, web services to interact and pull data from XML DB.
• Frequently interacted with the business-analysts to understand their requirements, the problems they faced and providing necessary technical support.
• Held several quality control meetings to enforce standards, fixing bugs, presenting results, providing training.
• Actively involved in Testing, Integration, Implementation,Documentation, Mentoring

Environment: Oracle-11gR2, Teradata- 14.00.03.09 , Teradata Sql Assistant-13.11.0.3, SQL*Loader, Informatica-8.6, MS SQL-Server 2008, TOAD-11.5.0.56, SQL Developer-3.1.07, R-2.15.2, Windows7, MS Excel 2010, Python

Confidential, Phoenix, AZ

Oracle PL/SQL Developer& Administrator

Responsibilities:

• Involved in analysis, database design, coding and implementing.
• Installed and configured Oracle Database 10g/11g, Oracle Application server 9i/10g, Oracle Developer suite 10g in production environment.
• During database migration used Stored Outlines to preserve Oracle Hints and benefit query performance.
• Created Windows batch processes to automate loading data from flat file into Oracle table using SQL*Loader.
• Regularly performed SQL query tuning using EXPLAIN PLAN, optimizer Hints and Indexes, Tkprof, Autotrace.
• Wrote numerous DBA scripts using V$ views (e.g. V$sessions, V$parameters) to analyze the system load, monitor number of users logged on.
• Used Oracle Import/Export, RMAN utilities to backup database.
• Extensively used SQL, PL/SQL to develop packages, procedure, functions andtriggers.
• Used Oracle Forms, Reports to customize according to the customer’s need.
• Extensively used ORACLE Discoverer for ad-hoc querying and reporting.
• Developed drill down, group above, matrix, nested summary detail reports, using Reports 10g, which pulled the thousands of records in different formats.
• Designed & developed major input screen using Forms 10g.
• Created complex forms which called reports; used stacked, tab canvas on a content canvas; used master-detailsrelationship triggers in several forms.
• Migrated data from non-Oracle such as MS Access database to Oracle database using ESF data migration tool kit.
• Interacted with end user for problems faced and providing necessary technical support by fixing the bugs.
• Testing, Integration System test, Implementation (test with users) and documented the entire project.

Environment: Oracle 10g/11g(SQL, PL/SQL), SQL Navigator 5.0, ORACLE Forms and Report builder 10g, Oracle Discoverer 10.1.2, SQL Developer data modeler 3.0, Windows server 2008,XP Professional.

Confidential, Madison, WI

Oracle PL/SQL Consultant

Responsibilities:

• Involved in writing complex SQL statements to implement the business requirements.
• Heavily involvedin developingPL/SQL packages, DMLtriggers, stored procedures to insert data in Oracle tables, checkdata consistency, calculate tax etc.
• Wrote Cron jobs to automate SQL Loaderto load data from text files into the database.
• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT/UPDATE/DELETE features.
• Advanced features in PL/SQL such as Nested Tables, Records, Types, Varrays, Collections were extensively used for high performance of stored procedures.
• Wrote complex SQL query with various Joins, sub-query, and nested query to create new reports and modified existing reports (group above, matrix) using Oracle Reports.
• Involved in cleaning and maintaining migrated data by using Partitioned Tables and Indexes.
• Involved in developing procedures using oracle supplied UTL FILE package to read, write from ASCII files load it into Oracle forms through database tables.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and package.
• Involved in daily monitoring and maintaining the IPAS database using Performance Analyzer, AWR snapshot and ADDM reportin OEM.
• Extensive experience working with users/vendors and turning their requests into results.

Environment: Oracle 9i/10g(SQL, PL/SQL), Oracle Forms/Reports 9i, SQL developer 2.1, PL/SQL developer 8.0, SQL Developer data modeler 2.0, HP-Unix, Bash/CShell scripting

Confidential

Oracle PL/SQL Developer, Credit Information System

Responsibilities:

• Incorporating all the business rules, writing code in SQL, PL/SQL.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Used SQL Loader to load data into different tables from flat files.
• Wrote stored procedures, functions and database triggers to perform and verify accounting.
• Extensively used complex SQL queries with various Joins, sub-queriesto validate data.
• Created reports using MS access tool according to specific guideline.

Environment: Oracle database 9i, SQL, PL/SQL, SQL*PLUS, SQL*Loader, MS Access, Redhat enterprise Linux, Bash Shell scripting.

Confidential

Oracle PL/SQL Intern

Responsibilities:

• Configured and maintained Red Hat enterprise Linux systems to streamline day-to-day operationsat GMRT, e.g. automatic astronomical data accusation, signal processing.
• Installed and configuredOracle database 9i in development environment and monitor database performance using Oracle Enterprise Manager.
• Used SQL Loader to load big (millions of rows) astronomical data set from ASCII files into different Oracle tables.
• Wrote Linux shell scripts (Cron job) to automate data loading process.
• Extensively coded in SQL and PL/SQL to develop stored procedures, functions and database triggers for data entry and validation.
• Wrote software in C/C++, Java to process, analyze and visualize scientific quantities.
• Role also included designingand testing Oracle database.

Environment: Oracle database 9i, SQL*Plus, PL/SQL, SQL*Loader, Exp, Imp, C/C++, Redhat enterprise Linux, Bash/C Shell scripting, Python