SUMMARY:

• Possesses 10+ years of IT experience in all phases of SDLC/project such as 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, PL/SQL , Oracle Reports 10g/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 etc.
• Well experienced in data warehouse, data migration/data conversion from legacy systems.
• Proficient in using bulk loader like SQL*loader and BCP using through batch file.
• Extensive experience in Performance Tuning using Explain Plan, SQL Trace utilities, DBMS PROFILER, DBMS XPLAN.
• Extensive experience in creating batch process, jobs and advance queues.
• Experienced in Data warehousing and Erwin Data Modeler.
• Experienced in writing Oracle ETL scripts that extract data from an operational database and populate the staging and target OLTP and data warehouse 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 and OLTP system.
• Oracle Certified Professional (OCP).

TECHNICAL SKILLS:

Languages: PL/SQL, Transact - SQL, Pro* C, JAVA, HTML, 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, Crystal Reports, Tableau, 11g/10g/9i, Oracle BI Publisher, Autosys, Tidal, Tableau.

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 Developer

Confidential, Boston, MA

Environment: Oracle 12c/11g, SQL Server, Mongo DB, Toad, GIT, Java J2EE, UNIX, PL/SQL, SQL * Loader, Oracle BI Publisher, Oracle Reports, 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.
• Using Erwin for Data modeling in OLAP (data warehousing) and OLTP environment.
• Using data visualization tool/BI tool Tableau to create interactive Dashboards, Worksheets and ad-hoc reports.
• Creating different type of reports using Crystal Reports.
• Writing database objects like Tables, Views, Stored Procedures, Functions, Packages, Materialized views, DB triggers, Partitions, Indexes.
• Performing analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Shell Scripts for Data Warehouses, Data mart and OLTP system.
• Using advanced Bulk techniques (FOR ALL, BULK COLLECT), Hints, Records, Collections, and Dynamic SQL to improve performance for Data Warehouses, Data mart and OLTP system.
• Writing 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.
• Performing code review for other developers and providing suggestions to improve performance.
• 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-tune 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 etc.
• Helping other developers in tuning queries or programs and trained them to write well-tuned code.
• Performing Unit testing, UAT, creating test plan for QA and preparing production implementation scripts, backup and rollback scripts.
• Creating XML report using Oracle PL/SQL code.
• Using Oracle BI publisher to create report in pdf format.
• Writing Korn shell scripts for production job automation
• Writing batch jobs, daily jobs, one time jobs and queues.
• Maintaining different versions of codes using GIT.
• Doing ETL (extract, transform and load) Using SQL * Loader, external files, external tables, shell script and Oracle PL/SQL program units.
• Working in Agile environment (Scrum, Kanban) using JIRA.
• Participating in the production support.

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, Informatica, Agile methodologies (Scrum, Kanban), Agile tool - JIRA.

Responsibilities:

• 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 (Architecture), 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 (FOR ALL, BULK COLLECT), Hints, Records, Collections, and Dynamic SQL to improve performance of Data Warehouses, Data mart and OLTP system performance .
• Performed code review for other developers and 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.
• Performed Unit testing, UAT, creating test plan for QA and preparing production implementation scripts, rollback scripts.
• Created XML report using Oracle PL/SQL code.
• Used Oracle BI publisher to create report in pdf format.
• Used DBMS SCHEDULER to automate jobs.
• 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
• Maintained different versions of codes using SVN, Perforce.
• Used SQL * Loader to load data from external files, external tables.
• Worked in Agile environment (Scrum, Kanban) using JIRA.
• Participated in the production support.

Sr. Oracle PL/SQL and ETL Developer

Confidential, Denver, CO

Environment: Oracle 10g, Oracle Reports 10g, SQL Server, Sybase, Windows NT/2000, 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 designs 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 stored subprograms (package, procedure, functions etc.) 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, etc.) 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.
• 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, external tables.
• 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 for reporting.

Oracle PL/SQL Developer

Confidential, Irving, TX

Environment: Oracle 10g, PL/SQL, Pro*C, Oracle Reports 10g, Crystal Reports, PL/SQL Developer, SQL * Loader, Version control software CVS, 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 etc 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.
• 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, 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 etc.
• 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 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, 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 etc.
• 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.
• 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.
• Created various feeds/downloads, nightly batch jobs and other daily/monthly reports/downloads.
• Tuned batch jobs and other daily/monthly reports/downloads.