SUMMARY

• Over 7+ years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle in Oracle PL/SQL including requirements, Analysis, Design, Development, Testing and Implementation.
• Extensively worked in Client - Server application development using Oracle 8.0/8i, 9i, 10/g, 11g, PL/SQL and SQL *PLUS, Reports 2.5/3.0/6i and SQL* Net.
• Extensive experience in application data modeling and building data warehouse architecture (Star & Snowflake schemas) and ER Diagrams using Microsoft Visio, Erwin and IBM Rational Rose data modeler tool.
• Extensively worked in PL/SQL for creating stored procedures, clusters, packages, database triggers, exception handlers, cursors, cursor variables, SQL test cases.
• Extensively Worked on Oracle Database creation, Tablespace management, (Export & Import) Backup, Performance tuning.
• Working knowledge of SQL Trace, TK-Prof, Explain Plan, Pro*C, SQL Loader for performance tuning and database optimization.
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
• Expert in maintaining data integrity using various constraints and database triggers.
• Expertise in data migration with both (target - source) same database as well as with heterogeneous databases.
• Proficient in interpersonal relations, project management, communication, outsourcing partner teamwork and organization with excellent communication and presentation skills.
• Worked the Hadoop Echo System for data migration to Big Data platform and ETL.

TECHNICAL SKILLS

Operating Systems: Windows 98/NT/2000/XP/2003, MS-DOS, UNIX, RH Linux

Languages: SQL, PL/SQL, Shell Scripting, Perl, XML, C, C #, Java, HTML, MATLAB, Python

RDBMS: Oracle 9i/10g/11g, MS Access, Teradata

BIG DATA: Hadoop 2.6.0, HDP 2.2.4, Hue2.6.1-1, Hive-Hcatalog 0.14.0, Oozie4.1.0, Sqoop 1.4.5

GUI: Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Crystal Report, XML Publisher

Utilities: Toad, SQL*Plus, SQL*Loader, PUTTY, Super PUTTY, MobaXterm, MS Office, PL/SQL Developer, Oracle SQL Developer, Oracle CRM EBS, Erwin Data Modeler, Oracle SQL Developer Data Modeler, SSH v-1.99, SFTP v-4, Cron/Crontab

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL-SQL Developer/Oracle DBA/Hadoop Developer

Responsibilities:

• Worked as a DBA for the Development team and on logical and physical data models using Erwin Data Modeler, and metadata repository.
• Performed structural changes to database objects according to business logic.
• Performed application SQL Tuning using SQL Trace and Explain plan for existing queries used in application development.
• Created indexes as a part of tuning exercises.
• Performed data partitioning on existing objects for the Cartwheel Database.
• Wrote PL/SQL Stored Procedures, Functions, Packages and Triggersto implement Business Rules for the Reporting Database.
• Created various simple and complex Views and Materialized view for in the Reporting Database.
• Created Oracle Schedules and Control-M jobs for execution of some Oracle Stored Procedures on a scheduled basis.
• Used the External Table concepts and Oracle Directories for large data imports from flat files provided by reporting team into the reporting Database.
• Used collection concepts, Bulk Collections, bulk insert, update and delete concepts for large data imports from flat files and other Databases.
• Created Database Links to easy establish connections to other Database to which the Reporting Database interacted with.
• Assisted in Installing and implementing GoldenGate for replication and promoted this implementation from Development Environment through to the Production Environment.
• Wrote high-level specifications and detailed specifications for the Reporting Database.
• Tuned the Cartwheel Oracle Database in preparation for peak seasons.
• Worked with Hive for a new Analytics platform on Hadoop.
• Developed Oozie Workflows for data migration of Cartwheel analytics data from Oracle and Teradata to Hadoop HDFS.
• Developed Oozie Workflows for ETL jobs for analytics data on Hadoop HDFS.
• Wrote shell scripts to work with Oozie Workflows.
• Developed Cron jobs using Crontab commands and SFTP scripts to automate File transfer from externally hosted servers to Target hosted servers for ingestion into Hadoop HDFS.
• Used the Sqoop utility for data import from Oracle and Teradata to the Hadoop HDFS and export of analytics data to Teradata
• Worked on Github for version/source control and integrated with Jenkins for code deployment to higher environments.

Environment: Oracle Database 11g Release 2, PL/SQL Developer, Oracle SQL Developer, Oracle GoldenGate, Control-M scheduler, ERwin Data Modeler 8, JIRA, CONFLUENCE, Team Foundation Server (TFS), Hadoop 2.6.0, HDP 2.2.4, Hue 2.6.1-1, Hive-Hcatalog 0.14.0, Oozie 4.1.0, Sqoop 1.4.5, Shell scripts, SFTP, Crontab, Github, PUTTY, MobaXterm

Confidential, Laurel, NJ

Oracle PL/SQL Developer

Responsibilities:

• Worked with the BA team in providing a backend perspective in requirements gatheringand modules development according to the project specifications.
• Involved in the database administration and creating objects such as database, users, schema and table spaces.
• Worked extensively in creating logical and physical Data Models to support various functionalities specified in Project requirements.
• Employed the RDBMS (normalization) concepts in Data modeling.
• Developed Back End Data Base algorithms in conjunction with Front End C Sharp Algorithms to implement functionalities specified in Project requirements and developing detailed Technical Documentations on their implementation.
• Wrote PL/SQLStored Procedures, Functions, Packages and Database triggersto implement Business Rules specified in Project requirements.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Extensively used XMLs for data parsing between Backend and Front End, reading data form the XML and creating XMLs to be used by both Front End and in Stored Procedures.
• Used External Table for data imports from files from daily feed and created directories used for these feed, granting the requisite permissions to them.
• Created Views and Materialized Views for stored queries employed and used between different databases, users and schema and to make data access from warehouse simpler.
• Developed dynamic SQL used in procedures and function for the data extraction and loading process from External Tables, XMLs and physical tables.
• Used Global Temporary Tables in some Backend developments to hold data when required.
• Worked on Unix Shell Scripts for scheduling Batch Jobs and automating some execution process in daily vendor payment and client billing processes.
• Supported Front End Development using the .NET Framework.
• Worked with Team Foundation Server (TFS)for version/source control

Environment: Oracle Database 11g Release 2, PL/SQL Developer, Oracle SQL Developer, Toad 8.5, SQL*Plus, SQL*LOADER, UNIX shell scripting, Microsoft Visual Studio, Team Foundation Server (TFS)

Confidential, Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

• Involved extensively in requirements gathering and developing modules according to the customer’s specifications and drafting detailed documentation for the same.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in Staging and Destination schemas.
• Created ETL mechanism to transform the data from OLTP source to the newly created OLAP model.
• Developed a package with stored procedures, functions and database triggers for transferring the date from Source to warehouse.
• Developed dynamic SQL used in procedures and function for the data extraction and loading process.
• Created dynamic procedures to drop and create Index for the Staging environment to facilitate faster loading of data.
• Involved in Tuning SQL queries using Explain Plan and Tkprof utility to improve performance of the queries.
• Created the documentation for explaining all the process involved in the ETL mechanism.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL to test the model.
• Involved in the database administration and creating objects such as database, users, schema and table spaces.
• Involved in managing security, granting and revoking privileges on database objects.
• Performed regular backups on the database using RMAN utility.
• Used Perl 5 together with Cron for scheduled FTP transfer of data files.
• Provided Customer/Production support for Oracle Customer Relationship Management module EBS.
• Used Oracle Customer Relationship Management EBS for managing company and client relationship.

Environment: Oracle 9i, Oracle Data Modeler, Oracle SQL Developer, Erwin, Sun Solaris, Perl 5.16.1, Crontab, Windows 2000, MS Outlook 2007,MS Office 2007.

Confidential, Marlton, NJ

PL/SQL Developer

Responsibilities:

• Worked on data export and import wizard to transfer data between different schemas in oracle using TOAD.
• Worked with various complex queries, sub queries and joins to check the validity of loaded and imported data Worked and developed many procedures and functions according the requirement, and developed brand new packages with cursors.
• Sound Knowledge in understanding already existed packages, and worked with them to create updated versions to solve the issues.
• Involved in creating stored procedures, functions, triggers and developed monthly and weekly reports.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
• Worked with dynamic SQL, developed many procedures and function with dynamic SQL.
• Prepared the technical documentation and user support documents.

Environment: Oracle 8i/8.1.7/9i (Enterprise Edition), SQL*Plus, SQL Navigator, PL/SQL, Erwin 4.1, Oracle Designer 2000, Toad 7.6,MS Excel 2003, Windows 2003 Server, Crystal Reports 8/ 8.5.

Confidential, San Francisco, CA

Oracle Developer

Responsibilities:

• Wrote high-level specifications and detailed specifications.
• Wrote PL/SQL Database triggers to implement business rules.
• Used ETL software to extract, transform and load needed data.
• Gathered and analyzed business requirements from end users.
• Worked with applications specialists to understand the new data requirements.
• Collaborated with the DBA in creating tables required for the application.
• Used SQL*loader to load the data from the files provided by the interfacing applications.
• Performed staging, and cleansing on data per requirement.
• Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.
• Worked with DBA on logical and physical data models, and metadata repository.
• Trained analysts and developers in design tools and data modeling techniques.
• Extensively used SQL to create Insert programs for loading data.
• Modified existing procedures according to new enhancements.
• Performed data partitioning.
• Used explain plan to increase performance of SQL statements.
• Modified SQL statements to increase the overall performance as a part of performance tuning.
• Merged data from one database to another database.
• Created indexes as a part of tuning.
• Documented every phase like Technical specifications, source to target mappings, data models (using ERWIN), UAT (tests cases and results), and release notes.
• Used Informatica to extract data from different types of sources and load to oracle database.
• Knowledge of full life cycle implementation in building a Data Warehouse.
• DataExtraction Transformation and Loading (ETL) Using Informatica Power center
• Migrated enhancement from appropriate dev Area to Test Areas/prod Areas.
• Issued Grants to the business users for appropriate DM tables to design their Universes.
• Used File Transfer Protocol (FTP) tool to transfer files from one server to other.
• Used Export/Import Oracle utilities of Data Pump to move data to different testing environments.
• Worked on Unix Shell Scripting for load dataand scheduling Batch Jobs using Crontab.
• Interacted with production support team regarding production issues.
• Documented and transferred knowledge regarding the various projects.
• Attended meeting with business analyst to get new requirements for the application.

Environment: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, ERWIN, UNIX, BODI, Informatica Power Center 8.1, Shell scripts, SQL*Loader, Crontab