SUMMARY:

• Possesses 10+ years of IT experience in all phases of SDLC, interacting with business users, Requirement gathering, creating functional and technical specifications/documentation, Data Migration, Application design, Architecture, Application Development, Testing, Implementation and production support.
• Possesses 10+ years of strong hands on experience in Oracle 12c/11g/10g/9i/8i, in writing SQL queries, PL/SQL subprograms, Oracle Reports Builder10g/9i/8i, Oracle BI Publisher.
• Strong hands on experience in creating and maintaining database objects like stored procedures, functions, packages, Triggers, tables, views, materialized views, indexes, sequences, synonyms, DB links, cursors, collections, records, REF cursors, bulk binds Confidential .
• Well experienced in data warehouse, data mart, data migration/data conversion from legacy systems.
• Proficient in using bulk loader like SQL*loader and BCP.
• Extensive experience in Performance Tuning SQL query and PL/SQL subprogram using Explain Plan, SQL Trace utilities, DBMS PROFILER, DBMS XPLAN.
• Crating XML data using DBMS XMLGEN package, parsing XML data using SQL function SYS XMLGEN, XML Query Confidential .
• Extensive experience in creating batch process, jobs, advance queues and Unix Shell Scriptings.
• Experienced in Data warehouse, Data Mart and Data Modeling.
• Experienced in writing custom Oracle PL/SQL subprogram for ETL purpose that extract data from an operational database and populate the staging and target tables in data warehouse and data mart schemas.
• Has good experience in designing Entity Relationship Diagram (ERD), Dimension table, Fact table, Schema, Logical and Physical data models and Data Flow Diagram (DFD) for Data Warehouses, Data mart (OLAP) and OLTP system.
• Oracle Certified Professional (OCP).

TECHNICAL SKILLS:

Languages: PL/SQL, Transact - SQL, Pro* C, JAVA, HTML, XML, Unix Shell Scripting.

Data Modeling Tools: Erwin 3.x/4.x, SQL Developer.

Databases: Oracle 12c/11g/10g/9i, MS-SQL SERVER, SYBASE.

Utilities: SQL*Loader, BCP.

Other Tools: Oracle Reports Builder, Crystal Reports, Tableau, 11g/10g/9i, Oracle BI Publisher, Autosys, Tidal.

Operating Systems: AIX, UNIX, Linux, Windows, MS-DOS.

IDE (Development Tools): PL/SQL developer, Toad, SQL Navigator, Rapid SQL.

Protocol: FTP, SFTP, NDM(Direct).

Version Control tool: PVCS, CVS, Subversion (SVN), Perforce, GIT.

Task management tool: JIRA, Elementool.

PROFESSIONAL EXPERIENCE:

Sr. Oracle PL/SQL and ETL Developer

Confidential, High Point, NC

Environment: Oracle Database 12c, Toad, GIT, Java J2EE, XML, Linux, SQL and PL/SQL, SQL * Loader, Oracle BI Publisher, Oracle Reports Builder, Agile methodologies (Scrum, Kanban), Agile tool - JIRA.

Responsibilities:

• Involved in all phases of system development lifecycle (SDLC) i.e. collecting user requirements, design (Architecture), development, testing, implementation and production support of the Inventory Management System.
• Participating in all aspects of database programming on Oracle SQL, PL/SQL and related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Table Partitions, Triggers, Materialized Views Confidential .
• Writing (ETL Scripts) PL/SQL scripts, custom PL/SQL subprograms that extract data from different systems and populate into the Data Mart and data warehouse schemas.
• Using Oracle 12c new features: Define and execute PL/SQL functions inside SQL statements using “WITH” clause, restrict access to program units through use of a “white list,” specified by the “ACCESSIBLE BY” clause, fine-tuned privileges for a program unit by granting roles to that unit, “DEFAULT ON NULL”, “IDENTITY” columns, Row limiting using “FETCH FIRST”, Invisible columns, Composite Trigger to avoid mutating error Confidential .
• Performing analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Unix Shell Scripts for Data Warehouses, Data mart and OLTP system.
• Using Bulk binds (FORALL, BULK COLLECT), Hints, Collections, bind variables and Dynamic SQL, and parallel processing to improve performance.
• Performing code review for other developers, providing suggestions to improve performance.
• Maintaining different versions of codes using GIT (version control software).
• Performing Unit test, UAT, creating test plan for QA and preparing production implementation scripts, rollback scripts.
• Creating XML data using DBMS XMLGEN package, parsing XML data using SQL function SYS XMLGEN, XML Query Confidential .
• Using Oracle supplied package DBMS CRYPTO for data masking/encryption and decryption purposes.
• Using Oracle Reports Builder, BI publisher to create reports.
• Working in Agile environment (Scrum, Kanban) using JIRA.
• Involved in performance tuning of SQL queries and PL/SQL subprogram using DBMS XPLAN.DISPLAY CURSOR, DBMS PROFILER, SQL Trace utility and Explain plan Confidential .
• Writing Shell Scripts for job automation and ETL purpose using External Table interface.

Sr. Oracle PL/SQL Developer

Confidential, CA

Environment: Oracle Database 12c, Toad, GIT, Java J2EE, XML, Linux, SQL and PL/SQL, SQL * Loader, Oracle BI Publisher, Oracle Reports Builder, Agile methodologies (Scrum, Kanban), Agile tool - JIRA.

Responsibilities:

• Involved in all phases of system development lifecycle (SDLC) i.e. collecting user requirements, design (Architecture), development, testing, implementation and production support of the Inventory Management System.
• Participated in all aspects of database programming on Oracle SQL, PL/SQL and related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Table Partitions, Triggers, Materialized Views Confidential .
• Performed analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Unix Shell Scripts for Data Warehouses, Data mart and OLTP system.
• Used Bulk binds, Hints, Collections, bind variables and Dynamic SQL, and parallel processing to improve performance.
• Performed code review for other developers, providing suggestions to improve performance.
• Maintained different versions of codes using GIT.
• Used Oracle Reports Builder, BI publisher to create report in different format.
• Worked in Agile environment (Scrum, Kanban) using JIRA.
• Involved in performance tuning of SQL queries and PL/SQL subprogram using DBMS XPLAN.DISPLAY CURSOR, DBMS PROFILER, SQL Trace utility and Explain plan Confidential .

Sr. Oracle PL/SQL / ETL Developer

Confidential, Boston, MA

Environment: Exadata Oracle 12c/11g, SQL Server, Mongo DB, Toad, GIT, Java J2EE, UNIX, SQL, PL/SQL, SQL * Loader, Oracle BI Publisher, Oracle Reports Builder, Tableau, Agile methodologies (Scrum, Kanban), Agile tool - JIRA, Large data set, Big data technology, Hadoop, HDFS, Pig, Hive, HBase.

Responsibilities:

• As a team lead involved in the full development lifecycle (SDLC) and was responsible for collecting business requirements, system analysis, detailed technical design (Architecture), application development, data modeling, implementation and maintenance (production support) of Data Warehouses, Data mart and OLTP system.
• Used Erwin for Data modeling in OLAP (data warehousing) and OLTP environment.
• Used data visualization tool/BI tool Tableau to create interactive Dashboards, Worksheets and ad-hoc reports.
• Created different type of reports using Crystal Reports.
• Creating XML files using Oracle DBMS XMLGEN package.
• Wrote database objects like Tables, Views, Stored Procedures, Functions, Packages, Materialized views, DB triggers, Partitions, Indexes.
• Used batch processing techniques such as Bulk collections, dynamic SQL, and parallel processing.
• Used Bulk binds (FORALL, BULK COLLECT), Hints, Records, Collections, Parallel Processing, and Dynamic SQL to improve performance for Data Warehouses, Data mart and OLTP system. wrote Oracle ETL scripts that extract data from an operational database and populate the staging and target OLTP and data warehouse schemas.
• Involved in performance tuning of SQL and PL/SQL code using DBMS XPLAN, DBMS PROFILER, SQL Trace utility and Explain plan.
• Performed Unit testing, UAT, creating test plan for QA and preparing production implementation scripts, backup and rollback scripts.
• Used Oracle BI publisher to create report in pdf format.
• Wrote Korn shell scripts for production job automation in Linux/Unix.
• Wrote batch jobs, daily jobs, one time jobs and queues.
• Maintained different versions of codes using GIT.
• Performed ETL (extract, transform and load) using SQL * Loader, external files, external table interface, Unix shell script and custom Oracle PL/SQL program units.
• Working in Agile environment (Scrum, Kanban) using JIRA.

Sr. Oracle PL/SQL and ETL Developer

Confidential, Denver, CO

Environment: Oracle Database 12c/11g XE, Toad, SQL Developer, SVN, GIT, Java J2EE, Windows 7, UNIX, PL/SQL, SQL * Loader, Oracle BI Publisher, Crystal Reports, Oracle Reports Builder, Informatica, Agile methodologies (Scrum, Kanban), Agile tool - JIRA.

Responsibilities:

• Worked as a team lead, coordinated onsite and offshore teams.
• Collected and documented user requirements and creating mapping documents to support the implementation of the extraction, transformation, loading (ETL) and validation of data moving from legacy systems into vendor management system (VMS) and managed service provider (MSP) system.
• Involved in the design, development and testing of custom data migration scripts using Oracle PL/SQL in an optimized manner.
• Created and assisted in data modeling using SQL Developer.
• Wrote database objects like Tables, Views, Procedures, Functions, Packages, Materialized views, DB triggers, Partitions, Indexes for Data Warehouses, Data mart and OLTP system and for ETL purposes.
• Did analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Korn Shell Scripts for Data Warehouses, Data mart and OLTP system.
• Used advanced Bulk techniques (FORALL, BULK COLLECT), Hints, Records, Collections, and Dynamic SQL to improve performance of Data Warehouses, Data mart and OLTP system.
• Performed code review for other developers, provided suggestions to improve performance.
• Wrote Oracle ETL scripts that extract data from an operational database and populate the staging and target OLTP and data warehouse schemas.
• Helped other developers in tuning queries or programs and trained them to write well-tuned code.
• Provided expertise to development managers in design or preparing proof-of-concept testing.
• Created XML report using Oracle PL/SQL code.
• Involved in performance tuning of SQL and PL/SQL code using DBMS XPLAN.DISPLAY CURSOR, DBMS PROFILER, SQL Trace utility and Explain plan.
• Wrote Korn shell scripts for production job automation in Linux.
• Maintained different versions of codes using SVN, Perforce.
• Used SQL * Loader to load data from external files.
• Worked in Agile environment (Scrum, Kanban) using JIRA.

Sr. Oracle PL/SQL and ETL Developer

Confidential, Denver, CO

Environment: Oracle 10g, Oracle Reports Builder 10g, SQL Server, Sybase, DB2, Windows NT/2000, Linux, UNIX, AIX, Subversion, Perl, ElemenTool - Task management tool, PL/SQL, Transact-SQL, ERWIN, Autosys.

Responsibilities:

• As a team lead involved in collecting user requirements and design the mapping documents.
• Involved in designing Entity Relationship Diagram (ERD), Dimension table, Fact table, Schema, Logical and Physical data models and Data Flow Diagram (DFD) for Data Warehouses, Data mart and OLTP system.
• Involved in design and development of ETL mappings and custom PL/SQL subprograms (package, procedure, functions Confidential .) in an optimized manner.
• Migrated data from customer’s legacy systems into Facets database (Oracle) and into Data warehouse.
• Wrote PL/SQL code (procedures, functions, packages, triggers, views, materialized views, batch jobs, Confidential .) for Data Warehouses, Data mart and OLTP system.
• Performed SQL and PL/SQL tuning using Explain Plan, Execution plan, SQL Trace utility & DBMS PROFILER.
• Wrote Oracle ETL scripts that extract data from an operational database and populate the staging and target OLTP and data warehouse schemas.
• Wrote Korn shell scripts for production job automation in Linux/Unix.
• Carried out code review of other developers.
• Maintained different versions of codes using SVN.
• Used SQL*Loader, BCP (bulk loader), Informatica Powercenter to load data from external files.
• Wrote perl script for data cleaning.
• Used DBMS JOBS, DBMS SCHEDULER to automate jobs.
• Wrote Batch jobs, daily jobs, one time jobs and queues.
• Used Oracle Reports Builder for reporting.

Oracle PL/SQL Developer

Confidential, Irving, TX

Environment: Oracle 10g, PL/SQL, Pro*C, Oracle Reports Builder 10g, Crystal Reports, PL/SQL Developer, SQL * Loader, Version control software CVS, Linux, Unix, Korn Shell script, COGNOS 8.0 - Query Studio, Report studio, eclipse, performance tuning, data transfer using FTP, SFTP, NDM (Direct), Export, Import, JAVA, Windows NT, AIX.

Responsibilities:

• Created high performance queries and PL/SQL codes using Bulk Binds, Collections, REF Cursors Confidential for OLTP and ETL.
• Wrote high performance procedures, functions, triggers, packages, Korn shell scripts for ETL process.
• Wrote Data Cleaning scripts.
• Used SQL * Loader to upload data into the staging files from external files, using Export, Import, for data transfer from one domain to another domain using FTP, SFTP, NDM (Direct), JAVA interfacing class.
• Helped other developers in tuning queries and trained them to write well-tuned code.
• Did code review, checking code standard of other junior developers.
• Created and tuned various feeds/downloads, nightly jobs, and other daily/monthly reports/download.
• Did performance tuning using Explain Plan, Execution plan, SQL Trace utility, DBMS PROFILER.
• Wrote Korn Shell Scripts (.ksh) wrapper for Linux and Unix environment.
• Maintained different versions of codes using CVS, Starteam, multiple task using JIRA.
• Performed Unit testing, UAT, created test plan for QA and prepared production implementation scripts.
• Did analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Korn Shell Scripts.
• Created rollback scripts.

Oracle PL/SQL Developer

Confidential, Richardson, TX

Environment: Oracle 10g, PL/SQL, Oracle Reports Builder, Window NT, FTP, SFTP, PL/SQL Developer, Toad 8.5, SQL*Loader, Version Control Software CVS, ElemenTool for Production Support.

Responsibilities:

• Involved in the full development lifecycle and was responsible for collecting business requirements, system analysis, functional specifications, detailed technical design, application development, data modeling, implementation and maintenance using Oracle SQL & PL/SQL.
• Created PL/SQL Packages, Procedures, Functions and Triggers.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions Confidential .
• Created Batch jobs, daily jobs, one time jobs and queues.
• Performed SQL performance tuning using Explain plan, Trace utility & TKProf.
• Documented all Oracle Reports, Packages, Procedures and Functions development specifications.
• Maintained different version of software (version control) using CVS.
• Provided production support solving Tickets created using the software named ElemenTool.
• Prepared test plan for QA for testing before moving from PreProd to Production environment.
• Prepared production implementation plan & scripts.

Oracle PL/SQL Developer

Confidential, Dallas, TX

Environment: Oracle 10g, PL/SQL, Oracle Reports Builder 10g, HTML, Korn Shell Script, Window NT, AIX, JAVA, FTP, SFTP, NDM (Direct), SQL Navigator 4.5, Version Control Software PVCS.

Responsibilities:

• Have been involved in Design, Development, Testing, Integration, Implementation and Maintenance of financial system using Oracle Database 10g, Oracle PL/SQL, JAVA, Korn shell script, Oracle Reports Builder, Oracle Database 10g, Windows NT, AIX. Involved in backend development.
• Wrote complicated stored Procedures, Functions, Database Triggers and Packages, Korn Shell Scripts.
• Analyzed, created new and modified existing reports, scheduled reports, oracle jobs using AIX, Oracle 10g, Oracle Web Toolkit, Reports (10g/9i), PL/SQL, Stored Procedures, Functions, Packages, Korn Shell Scripting, FTP, SFTP, NDM (direct).
• Did code reviews of other developers and provided suggestions to improve performance
• Wrote high performance queries/programs using Bulk Binds, REF Cursors Confidential .
• Helped other developers in tuning queries or programs and trained them to write well-tuned code.
• Converted Reports from 9i to 10g.
• Designed and Developed FTP, SFTP and NDM (direct) processes using Java, Java Script, PL/SQL and Korn Shell Script wrapper for AIX, Unix and Linux.
• Created various feeds/downloads, nightly batch jobs and other daily/monthly reports/downloads.
• Tuned batch jobs and other daily/monthly reports/downloads.