SUMMARY:

• Over 6+ Years of working experience as an Oracle PL/SQL Developer with proven ability in the area of Client/Server and Application Development, Data modeling, Design, Development, Data processing, System Analysis, Deployment and Support with Oracle technology on different platforms.
• Experience in Oracle PL/SQL Development using various Oracle key components such as Stored Procedures, Functions, Packages, DB Triggers, Views, Materialized Views, DBlinks, Exception handling, Oracle Supplied Packages, Collections, PL/SQL Types, External Tables, Merge Statements, Autonomous transactions, Global Temporary Tables (GTT), Bulk Load, Cursor, Ref Cursors, Partitioned Tables, Dynamic SQL, SQL*Loader, Data Pump, UTL FILE, Database Links etc.
• Expertise in Creating and Maintaining Database objects like Tables, Views, Indexes, Constraints, Materialized Views, Synonyms, and Sequences.
• Proficient in writing and tuning Complex SQL statements, complex joins co - related sub-queries and SQL statements with Analytical Functions (ROW NUMBER, RANK, DENSE RANK, Lag, Lead, Connect by level etc).
• Experience in writing Dynamic SQL Statements using EXECUTE IMMEDIATE and DBMS SQL.
• Worked in extensively on Query Level Performance tuning using Explain Plan, SQL Trace and TKPROF utilities to pin point time consuming SQL's and tuned them by creating indexes and forcing specific plans.
• Experience in CI (Continuous Integration) and CD (Continuous Delivery) methodologies using Jenkins for End-to-End automation for all build and deployments of oracle applications.
• Working knowledge on using new partitioning techniques like Interval, Reference and Extended Composite (List-List, List-Range) Partitioning.
• Extensive experience in developing multi-threaded database processes using Oracle packages like DBMS SCHEDULER, DBMS STATS.
• Strong experience with Oracle Data Warehouse, ETL Process, Data analysis for ODS, Online Transactional Processing (OLTP) and Data Warehouse logical/physical, relational and multi-dimensional modeling (Star Schema, Snowflake Schema), Optimization, Partitioning, Archiving and capacity planning.
• Expertise in all phases of Software Development Life Cycle (SDLC) and Best Practices ( Oracle CDM) and Development Methodologies/Guidelines.
• Experience in using Oracle concepts Like Table Partitioning, Optimizer hints and Materialized Views (Snapshots).
• Experience in code migrations from Development to QA, QA to UAT (Stage) and Stage to Production Environment.
• Good understanding in the areas of Users, Roles, Privileges, Schema and Object Management & Session monitoring.
• Designed and developed Business Intelligence Solutions using Informatica Power Center (Client tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor), Informatica Cloud and SQL Server Management Studio using SSIS (SQL Server Integration Services).
• Working Knowledge of UNIX Shell Scripting and Scheduling Jobs for Automation and tools like WINSCP, PUTTY, FTP/SFTP, and CONNECT DIRECT etc.
• Responsible for Query Optimization, troubleshooting, debugging, problem solving and Tuning for improving performance of the applications.
• Experience in writing complex batch processes in PL/SQL and used Autosys for Job Scheduling.
• Excellent communication skills, problem solving and logical methodology. Work well in the team environment, Self-motivated, quick learner, able to work well under tight deadlines.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, XML, JAVA, C, C++, Visual Basic.

Operating System: Windows XP, Linux, Unix.

Oracle Tools: PL/SQL Developer, SQL Developer, SQL *Plus, SQL * Loader, TOAD for Oracle, Visual Studio, My SQL Forms Developer

Databases: Oracle 11g/10g/9i, MS Access, MySQL, Microsoft SQL Server, Teradata.

ETL Tools: Informatica 8.x/9.x/10.x, Informatica Cloud, MDM, IDQ, SSIS, SSRS, Power BI, Tableau, SAS Enterprise, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential - Merrimack, NH

Oracle PL/SQL - Informatica Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Responsible for Analyzing requirements, designing, maintaining and updating data models.
• Analyze the current data management procedures in practice and suggest ways for automating the process or improving the existing system .
• Worked on Data Migration for Fixed Income and Analytics Data available to AMWH using PL SQL procedures, functions, triggers, Packages, DDL actions.
• Worked as part of the development team, along with the Systems Analysts/Business Analysts.
• Involved in Developing and handling the SQL Packages, Procedures and Database Triggers.
• Optimized and modified the triggers, complex store functions, user base data type etc.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable.
• Migrated the codes from Dev to QA, Dev to UAT, UAT to Prod environment and wrote up the Team Based Development technical documents to the smooth transfer of the project.
• Encouraged the use of Version One to track individual work load and their responsibilities of the scheduled AGILE sprints.
• Customized Autosys JIL Scripts to schedule data load activities and other Informatica workflows according to the Service Level Agreement (SLA’s).
• Prepared Unit Testing, Integration testing of the developed workflows before they are pushed to the higher environments and resolving production problems for the applications.
• Experience with DBA activities like creating Tablespaces, granting and revoking privileges on database objects.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Created the indexes on the tables to retrieve the data fast and also to improve the database performance.
• Performed data analysis to identify/ validate the data for accuracy, quality and integrity.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for Packages.
• Experience in setting up CI/CD pipeline integrating various tools with Jenkins and deployed through IBM Urban Code deploy.
• Configured Jenkins Monitor, List and Build views to displays the status and progress of selected jobs with build version information.
• Configured and administered Jenkins pipelines for automated builds and responsible for installing Jenkins master and slave nodes.
• Reduced Informatica sessions & workflows by combining them to single one’s based on the derivation dependency.
• Performed Tuning of mappings in Informatica to reduce the load on the server.
• Guided use of Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 10.1.1.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Created various customized tasks like executing dynamic SQL, running Excel Macros etc. using script task.
• Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.

Environment: Oracle 12c, Toad for Oracle, MS Access, SQL Developer, Informatica Power Center 10.1.1, Putty, MS Excel, Query Analyzer, Source tree, Stash, Microsoft Power BI, Jenkins, TFS, HP Quality Center, Visual Studio 2012/2015.

Confidential - Charlotte, NC

Oracle PL/SQL Developer

Responsibilities:

• Obtained business requirements from the Confidential ’s Enterprise Collections and Recovery team to implement the enhancements to the application modules.
• Prepared Functional Specification Documents and Technical Design documents from the understandings post business discussions.
• Sourcing of delinquent account data from different products for the Confidential Enterprise using SQL Loader gen scripts and Autosys scripts.
• Created Packages and related Functions, Procedures with respect to the business application needs and enhancements modules.
• Extensive use of BULK COLLECT and file handling methods for loading data to various transaction tables.
• Code fixes and enhancements, database security by authenticating users, using logon triggers, materialized views, performance tuning and query optimization.
• Handled errors using exception handler extensively for the ease of debugging and displaying the error messages in the application.
• Developed mappings for multiple extracts, stage lookup data using Informatica Power Center.
• Built application screen specific functional procedures to fulfil the requirements of the specific modules and supportive procedures for the front-end Java.
• Developed the complete documentation of the project based on the analysis of tables and Columns.
• Created DDL scripts to create, alter, drop tables, views, synonyms and sequences.
• Worked on PL/ SQL Tables, Records and Collections.
• Wrote PL/ SQL Procedures, Functions, and Triggers for Insert, Update and Delete transactions and optimized for maximum performance.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Utilized tools like PL/ SQL Developer during development of the application.
• Developed SQL queries to fetch complex data from different tables in remote databases using database links.
• Implemented Optimization/ Performance tuning techniques to identify bottle necks- Query tuning (Explain Plan), memory tuning, Cache Management.
• Used Bind Variables while writing Dynamic SQL to improve performance.
• Researched and implemented Agile work flow for continuous integration (CI) and testing of applications using Jenkins. Administered and Engineered Jenkins to manage weekly Build.
• Developed Jenkins Plugin to automate artifact upload to Nexus (Repo) through Jenkins.

Environment: SQL* Loader, PL/SQL Developer, Toad Data Point, MS Access, MS Excel, Oracle SQL Server, Query Analyzer, WINSCP, File Net Enterprise Manager, SVN, HP Quality Center, Visual Studio 2012/2015.

Confidential - St.Louis, MO

Oracle PL\SQL Developer

Responsibilities:

• Involved and interacted with business analysts to know the user requirements in analyzing and collecting the business requirements.
• Worked with the front end design team to support them with the necessary stored procedures and packages also the insight into the data.
• Can able to create procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref and Traditional Cursors, Dynamic SQL, Table functions as a part of project requirements.
• Used SQL, PL/ SQL tuning and Application tuning with the various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• According to the new business requirements can able to modify the existing packages, procedures, functions and triggers using UNIX Shell Scripting for the automate the backend jobs.
• Writing PL/ SQL blocks to test the flow involved in the business.
• Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/ SQL to populate the tables in database.
• Created Informatica mappings, workflows and application using Informatics BDE developer.
• Performed Unit testing, Integration testing and System testing of Informatica mappings and applications.
• Implemented slowly changing dimension in various mappings.
• Created Test plans for unit-test, System Integration Test and UAT and tested code in all Development and ensuring whether all the components work perfectly when integrated.
• Prepared ETL standards, Naming Conventions and wrote ETL flow documentation.
• Handful of experience in optimization of SQL statements and PL/ SQL blocks by analyzing the execution of SQL plan statements and created and modified triggers, SQL queries, stored procedures for the better performance.
• Experience in developing the SQL and Shell scripts in creating the temporary tables and can write the SQL*Loader scripts to load the data into temporary staging tables.
• To maintain the end user customer relation effectively and efficiently designed and developed forms by using Oracle forms 10g.
• With the help of Oracle Reports Builder 10g built the customized existing reports according to the client requirements.
• Developed UNIX Shell scripts that will interact with the PL/ SQL Objects.
• Documented and performed unit testing for all components prior to migrating them to production.

Environment: Oracle 11gR2, UNIX Shell Scripting, Informatica Power Center 9.5.1, PL/ SQL, TOAD, SQL Navigator, SQL *Loader, Flat files, Putty, Bit Bucket, Forms Builder 11g, Reports Builder 10g, Informatica Power center 9.5.1.

Confidential

SQL Developer

Responsibilities:

• Actively involved in all stages of Software Development Life Cycle from requirement gathering to maintenance of databases.
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Implemented one to one and one to many relationships between the tables in the database.
• Identified and implemented the tables with Primary Key, foreign Key and Identity columns.
• Maintained the Referential integrity between the tables using Triggers and Stored Procedures.
• Created and manipulated the indexes for faster access of database tables.
• Wrote several SQL Scripts to query the tables to enforce constraints on tables with Identity and Primary Key.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Created views to restrict access to data in a table for security.
• Created T-SQL queries, dynamic Stored Procedures that calculate by taking the customer details as input.
• Created views and indexed views to reduce database complexities for the end users.
• Design and develop SSIS package for loading data from OLTP to Data Warehouse.
• Used ETL to implement Slowly Changing Dimension (SCD) to maintain historical data in Data Warehouse.
• Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
• Improved Performance of the database by creating clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Unit testing and Integration testing for various modules using Test Director.

Environment: MS SQL SERVER 2008/2005, Microsoft Business Intelligence Development Studio (BIDS), SSIS, SSRS, DTS, OLTP, OLAP, XML, SQL Server Profiler.