PROFESSIONAL SUMMARY:

• 8+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Experience in Oil & Gas, Healthcare, Pharmacy, and Retail and Shipping - Logistics Management - Supply Chain Management domain.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, and Autonomous Transactions, Dynamic SQL, Object types and Records.
• Experience in Big Data Technologies like Hadoop, Hive, Apache Spark, Kafka, Sqoop and HDFS.
• Experience in AWS cloud platform using AWS EC2/S3 to retrieve data from S3 buckets and importing into database using Python.
• Experience with integrating various REST webservices into Database using JSON/XML functions.
• Expertise in implementing and optimizingDatastreamingtechniques using Apache Kafka/Amazon Kinesis.
• Experience in developing ETL pipelines using Python and Snowflake’s SnowSQL
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.
• Understanding of Oracle EBS AME development and configuration.
• Knowledge on Developing CI/CD pipelines for build, test and deployment.
• Written AWS Lambda code in Python for nested JSON files, converting, comparing, sorting etc.
• Used Python scripts to update content in the database and manipulate files.
• Good understanding of Partitions and bucketing concepts in hive and managed external tables in hive to optimize performance.
• Demonstrated expertise utilizing ETL tools, including Oracle Data Integrator (ODI), Informatica and DataStage.
• Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and Teradata DWH applications using STATSPACK, Explain Plan, TKPROF, and Hints.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Business/Data analysis, database administration, Microsoft Report Service SSRS configuration, website application configuration.
• Worked on version control tools like SVN, Team Foundation Server and GIT Hub. Experience with JIRA, Service Desk plus tool for working on defects raised on the existing components in production.

TECHNICAL SKILLS:

Databases: Oracle 12C/11g/10g/9i/8i, SQL Server 7.0 / 6.5, MS Access, Teradata, IBM DB2

ETL Tools: Informatica 9.1, IBM Data Stage 8.7

BI Tools: Microsoft Power BI, Pentaho 4.5, OBIEE 10.x

Cloud: Snowflake, Amazon Web Services

Big Data: Apache Spark, Hadoop, Kafka, Hive, HDFS, Sqoop, Pyspark

Languages: C, SQL, PL/SQL, HTML, XML, Java, MySQL

GUI Tools: DB2 connect, TOAD for oracle, SQL Developer

Scripting: UNIX, Shell Scripting, Python, JavaScript, XML, HTML

Operating System: Windows, HP-UX, SUN Solaris 7.x/8.0, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Oracle Developer

Responsibilities:

• Migrated Data from Oracle to Snowflake for Space Management Module.
• Involved in development of Web services using RESTFUL for sending and receiving data from external interface in JSON and XML format using Python.
• Worked on migrating data fromOracle to AWS Snowflakefor IWMS (Integrated Workplace Management System).
• Created stage for streaming in data from S3 object to Snowflake, also utilized snow PIPE with it.
• Worked on python Visualization Dashboards in web application using libraries Plotly, DashandPandas.
• Create business intelligence dashboards and visualizations to produce insights to complex program data in ways that assist in translating organizational problem statements into actionable decision-making practices
• Worked on creating multiple views/tables in AWS Snowflake and down streamed to Data Science team.
• Worked on integrations between AWS to Oracle using UTL HTTP packages and Python scripts.
• Worked on integrations for loading data from Microsoft Azure Blob storage explorer to Oracle.
• Worked on upload and download files from AWS S3 buckets.
• Implemented webservices to send order details to downstream systems using RESTFUL.
• Worked on BLOBS, CLOBS and BFILES using PL/SQL (DBMS LOB) packages.
• Extensively used UTL FILE to read and write files that are located on the server optimized the performance using PL/SQL table types and record types.
• Used Ref cursors and Collections for accessing complex data resulted from joining large number of tables.
• Document technical, testing and mapping documents for the components developed.
• Worked on production support tickets on daily basis.

Confidential, Fort Worth, TX

Oracle Developer/Solution Analyst

Responsibilities:

• Worked on python to get information from SQL server database and load into oracle database.
• Exported the analyzed data to relational databases using Sqoop for visualization and to generate reports for the R&D team.
• Imported data using Sqoop to load data from oracle to HDFS on regular basis.
• Worked on Hue interface for Loading the data into HDFS and querying the data.
• Partner with Source teams to source the data to Hadoop for supporting data science models.
• Used Spark-Streaming APIs to perform necessary transformations and actions on the fly for building an ETL pipeline which gets data from Kafka in near real time and persists into HDFS.
• Proficient in working with: Collection objects, Nested Tables, Record types, Cursors, Ref Cursors, Views, Materialized Views, Partitions, FORALL, Bulk Collect, Regular Expressions, Triggers, Instead of Triggers, Autonomous Transactions.
• Tune complex queries utilizing Indexes, Hints, and Explain Plan, to improve the performance of the application.
• Directly interact with business users during UAT to provide support and solicit feedback for improving the quality of the finished application.
• Involved in writing technical specs, unit test results, and user acceptance test scenarios for each project.
• Extensively worked on creating different MV for bringing in data from different source systems into oracle database.
• Provide application development, enhancements, modifications, performance tuning, and support services for assigned projects.
• Prepare specifications for new applications, enhancements, modifications, and support issues.
• Familiarity with Oracle RAC and Golden Gate
• Develop and support data models and a data dictionary that supports the business requirements for tactical and strategic information products.
• Worked on production support tickets daily and do monthly on-call support.

Confidential, TX

Sr. Oracle Developer

Responsibilities:

• Created the PL/SQL packages, procedures, functions applying the business logic to update the provider's database.
• Created the custom tables to import the Patient and provider's data and insert into the database tables.
• Involved in keeping track of previously Exported Claims, of providers and archived them for future purpose.
• Extensively worked in providing updated records of the providers and patients on weekly basis by comparing with the previously Exported records.
• Involved in analyzing the root cause for the missing data and providing the missing data from the Extracts for Testing.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Creating Unit test cases and plan for Unit testing approach
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Coming up with Design plan and preparing the ETL Design document and have knowledge on PBM module.
• Converting business rules into ETL technical specifications.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Scheduled the ETL jobs daily. Weekly and monthly based on the business requirement

Confidential, Pittsburgh, PA

Application developer

Responsibilities:

• Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 11g.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade.
• Designed and developed Oracle Forms Reports using Forms11g and Reports11 Including Forms based on stored procedures.
• Working on the ETL side of the process to load data into database from different servers.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Modify existing ETL jobs in Oracle Data Integrator (ODI) and worked with XSD and XML files generation through ETL process.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Programed in UNIX shell scripts to provide a user interface to Oracle forms and reports, also for job automation and daily backup.
• Created relevant staging tables to load the CSV files, identified the business validation rules.
• Involved in performance tuning using with TKPROF, HINTS and EXPLAIN PLAN.
• Developed data models for adding new tables and fields to the data warehouse.
• Maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view.

Confidential, Exton PA

Oracle Programmer/Developer

Responsibilities:

• Oracle data warehouse developer responsible for the technical design, development and testing of extract, transform, and load (ETL) programs.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Responsible for working with data architect and business analysts to design/build data loading and conversion programs.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.
• Used Workflow Manager for creating validating, testing and running sequential and concurrent batches.
• Loaded data using oracle database utilities such as data pump, SQL*loader and external tables.
• Developed PL/SQL package procedures using REF cursor, Collections and Dynamic SQL.
• Developed PL/SQL package procedures to fetch bulk rows from cursor variable to collections.
• Used Data Vault concept for loading data from data warehouse.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developeddata entry forms, complex and template forms. Creation of Pop-up Menus and maintaining Master Detail relationship.
• Enhanced database functionality using Oracle supplied PL/SQL packages.
• Primary ETL Developer for creating and enhancing multiple data feeds including standard feeds like Enrollment, s, Transactions, and Coupons etc.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Developed UNIX Korn shell scripts to process file feed.

Confidential, Harrisburg PA

Oracle PL/SQL developer

Responsibilities:

• Database performance monitoring and identifying bottlenecks hindering the performance of the existing applications.
• Involved in creation of various indexes on relational tables, which are BTREE, BITMAP, FUNCTION BASED.
• Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
• Design and implementation of stored procedures and triggers for automating tasks
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Formulated SQL queries, functions and processes as per customization requirement for APEX
• Supported APEX applications and conducted performance tuning for PLSQL.
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Maintained a series of UNIX Shell Scripts to manage batch order processing.
• Used ETL tools to extract and load data from SQ L Server and flat files to Oracle database.

Confidential, Jacksonville Florida

Oracle PL/SQL developer

Responsibilities:

• Primary responsibilities included system analysis, coding, testing, debugging and deploying.
• Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to product of forms.
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage
• Used SQL*LOADER and UTIL file loader to upload bulk data by writing scripts for the Control file.
• Design and implementation of stored procedures and triggers for automating tasks
• Developed the UNIX scripts using KORN shell to automate jobs.
• Analyze the source data structure and perform the Logical mappings.