SUMMARY

• 14+ years of IT experience with skills in Design, Development, Administration and implementation of various projects using Object Oriented and Multidimensional Analysis. Involved in full life cycle development including Design, ETL strategy and Troubleshooting. Worked extensively with Investment Confidential Domain.
• Working as Oracle PL/SQL and ETL Developer on variety of Window and UNIXplatforms withOracle 12c/11g/10g/9i/8i.
• Oracle Certified Associate (OCA) and Oracle Certified Professional (OCP)
• Worked with clients in different domains likeBanking, Investments, Finance and Telecom.
• Experienced on completeSoftware Development Life Cycle (SDLC)using various methodologies like Agile, Scrum and Kanban dashboard, Waterfall Model
• Strong experience in Data Migration, Data Conversion and Oracle PL/SQL scripts.
• Extensive hands - on experience in using database languages SQL and PL/SQL.
• In Depth Knowledge of Performance Tuning of Oracle procedures.
• Solid experience in loading data using tools like Export / Import/expdp/impdp, good knowledge on utilities like Tkprof.
• Sound experience in fine tuning the database using utilities like SQL Tuning, SQL trace, Explain plan.
• Expertise in stored procedures, Functions, Triggers and necessary test plans to ensure the successful execution of the data loading processes.
• Worked with database objects such as Views (including Materialized Views), Stored procedures, Functions, Triggers, Sequence Generators and Partitions on Oracle.
• Worked on Oracle Object types, analytics, BulkCollects, MultiSet.
• Worked with Various Oracle Developer tools such as Toad, PL/SQL Developer, SQL Tools, SQL Developer and PRO*C.
• Analyzed tables and indexes forCost Based Optimization(CBO)for improving performance and work efficiently
• 8+ years of Data warehousing ETL experience using Informatica Power Center and Oracle Warehouse Builder (OWB) tool, working in Master Data Management (MDM), Big Data and Data warehouse.
• Extensive experience in developing ETL processes to extract, transform and load data from various source systems into Data Warehouses and Data Marts.
• Proficient in using Informatica Workflow manager, Workflow monitor, Server manager, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Involved in analysis, design, testing and deployment and loading of data from heterogeneous source systems to the warehouse according to the end users requirements.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake schema, data vault modeling.
• Extensively used transformation such as Source Qualifier, Expression, Filter, Router, Aggregator, Rank, Joiner, Sequence Generator, Normalizer, Look Up and Update Strategy to implement complex business logic.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ER Studio and ERWIN.
• Team player, enthusiast and quick learner with excellent communication skills.
• Role included active interaction with Leads for Development, Technical, DBA, Configuration Management, Interfaces, Production Support, and entire Project management team. Primary POC providing daily and weekly status for functional testing via status calls, and status reports to Client and internal PMO team.
• Ability to work effectively in cross-functional team environments and experience of providing training to business users.
• Knowledge in JAVA/J2EE/AngularJS and JUnit creating web services development experience and testing in SOAP UI.
• Creating new screens by using Application Development Framework (ADF)
• Strong exposure in Crystal Reports XI/8.5/8.0. Business Objects development oriented reports for Banking, Investments, Telecom, financing, retail, insurance, costing, payroll and billing statements formatted in systems

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/9i/8i,MS SQL Server 2005, MS Access, MySQL

Database Tools: SQL* Loader, SQL* Plus, Toad, PL/SQL Developer, Oracle APEX 4.0,SQL Navigator, Oracle ADF Faces, Putty, ER Studio 9.5/11, ERWin 3.5.2

Reporting Tools: Crystal Reports 8.5, BI Publisher, BOXI

Environment: Windows XP/NT/2003, UNIX and Linux

Languages: SQL, PL/SQL, Java, EJP, PHP, VB.NET, VS 2005, C, C++, PRO*C, XML

ETL Tools: Informatics Power Center 10x/ 9.x/8.6/8.1, Oracle Warehouse Builder (OWB).ODI

Other Tools: Star Team, BMC (Magic Ticket), CONTROL-M, SOAP UI and hp Quality center, Rally, Confluence, Fittness, Docker, Jenkins, Source Tree and GIT Status, Fitnesse, WinSP

PROFESSIONAL EXPERIENCE

Confidential, Oaks PA

Tech Lead (Oracle PL/SQL and ETL Developer)

Responsibilities:

• Creating PL/SQL Packages, Stored Procedures, Functions, Cursor and Triggers to implement the Business Logic and developing various Transaction handlers for the web service application.
• Designed and Developed ETL Interfaces using PL/SQL Stored Procedures, UTL FILE, External Tables, SQL*Loader Oracle Utilities for the Staging Area and Target Database.
• Generated server side PL/SQL scripts for data manipulation, validation and created various snapshots and materialized views for remote instances.
• Created Test environment for data staging using SQL & PL/SQL scripts and optimized critical queries to eliminate Full Table scans & reduce Disk I/O.
• Optimize SQL queries for better performance. Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Tuning of stored procedures & developed business logic in database layer using PL/SQL. Performance tuned multiple SQL queries and PL/SQL blocks using Explain Plan, Hints and SQL Trace.
• Involved in exhaustive Performance Tuning using DBMS Profiler, Explain Plan, Monitoring and Optimization of PL/SQL blocks and Batch frame work process in both Development and Production environment for Oracle.
• Created and manipulated PL/SQL tables (i.e. Index-by Tables and Nested tables) and Varrays. Involved in creating Procedures, Packages and appropriate REF Cursors to handle BULK collects and BULK binds.
• Proficiently developed Design documents (HLD & LLD), Unit Test Cases (UTS) and project documentation (user guides, run book, standard report instructions, demos).
• Analyzed Oracle Objects & Created Partitions for very large tables in Production to reduce disk contention & improve performance.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors, UTL File I/O and Exception handling.
• Generated DDL scripts for new database objects like tables, views, sequences, functions, synonyms, indexes, triggers and granting privileges.
• Wrote Integrity Checks, Data Cleansing scripts, SQL Queries to fetch data from multiple tables that had millions of records using Joins that produced Reports & Logs.
• Wrote the Migration scripts satisfying the new Business Requirement converting the data from its present form into a new form.
• Wrote the validation script around the Migration done performing all the Business Validations as part of Pre & Post Migration.
• Experience on ETL workflows working in Informatica Power-Center/Power Exchange, working in Master Data Management (MDM), Big Data and Data warehouse.
• Pull data from one schema (EDB) to another schema (Data Warehouses) using ETL Informatica transformation tools.
• Using Service now ticket request and Incident for any issues tracking and resolve the problems.
• Creating Fitnesse fixture automation testing for developed Store Procedure.
• Handling UNIX/Linux server Oracle database via connecting Putty.
• Works independently to develop, configure, code and test programs from specifications.
• Presents all work in design review and code review sessions to senior team members, and must be able to explain and support decisions made and actions taken.
• Develop ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code.
• Estimates own work effort for input to project planning.
• Now we are doing upgrading Oracle Cloud Database.

Environment: Oracle 12c/11g, TOAD, SQL * Plus, PL/SQL developer, SQL * Loader, Export/Import, Informatica 9x and 10x, XML, JAVA/J2EE, Rally, ER Studio 9.5/11, Windows 7, DUDE, Fitnesse, Putty, WinSP, Source Tree, GIT Stash, Confluence, Dockers, Jenkins, Dynatrace, UNIX and Linux.

Confidential, Oaks PA

Senior Oracle PL/SQL Developer

Responsibilities:

• Creating PL/SQL Packages, Stored Procedures, Functions, Cursor and Triggers to implement the Business Logic and developing various Transaction handlers for the web service application.
• Designed and Developed ETL Interfaces using PL/SQL Stored Procedures, UTL FILE, External Tables, SQL*Loader and Oracle Utilities for the Staging Area and Target Database.
• Analyzed and Designed Data Marts according to User requirements identified various Dimensions and Measures and implemented the Star Schema.
• Facilitated migration of large volume of Oracle Data between the environments via Partitioned tablespaces and Transportable tablespaces
• Performed security operations like recreation of grants & synonyms, compiling invalid code objects after the change of primary objects and ensuring database security and integrity with auditing features.
• Generated server side PL/SQL scripts for data manipulation, validation and created various snapshots and materialized views for remote instances.
• Created Test environment for data staging using SQL & PL/SQL scripts and optimized critical queries to eliminate Full Table scans & reduce Disk I/O.
• Optimize SQL queries for better performance. Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Tuning of stored procedures & developed business logic in database layer using PL/SQL. Performance tuned multiple SQL queries and PL/SQL blocks using Explain Plan, Hints and SQL Trace.
• Involved in exhaustive Performance Tuning using DBMS Profiler, Explain Plan and TKPROF utility, Monitoring and Optimization of PL/SQL blocks in both Development and Production environment for Oracle.
• Created and manipulated PL/SQL tables (i.e. Index-by Tables and Nested tables) and Varrays. Involved in creating Procedures, Packages and appropriate REF Cursors to handle BULK collects and BULK binds.
• Proficiently developed Design documents (HLD & LLD), Unit Test Cases (UTS) and project documentation (user guides, run book, standard report instructions, demos).
• Analyzed Oracle Objects & Created Partitions for very large tables in Production to reduce disk contention & improve performance.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors, UTL File I/O and Exception handling.
• Generated DDL scripts for new database objects like tables, views, sequences, functions, synonyms, indexes, triggers and granting privileges.
• Wrote Integrity Checks, Data Cleansing scripts, SQL Queries to fetch data from multiple tables that had millions of records using Joins that produced Reports & Logs.
• Wrote the Migration scripts satisfying the new Business Requirement converting the data from its present form into a new form.
• Wrote the validation script around the Migration done performing all the Business Validations as part of Pre & Post Migration.
• Hands on experience on ETL workflows working in Informatica Power-Center/Power Exchange.
• Handling UNIX/Linux server Oracle database via connecting Putty.
• Interaction with the offshore team on a daily basis on the development activities.

Environment: Oracle 11g/10g, TOAD, SQL * Plus, PL/SQL developer, SQL * Loader, Export/Import, Informatica 8.5, Python, XML, JAVA/J2EE, SOAP UI, Star Team, HP Quality Center, Rally, Windows XP and UNIX.

Confidential

Technical Associate (Oracle PL/SQL Developer)

Responsibilities:

• Worked on PL/SQL programming Packages, Stored Procedures, Functions, Cursors and Triggers.
• Developing PL/SQL codes for various Work Packages as well as Change Requests.
• Responsible for preparing Low Level Design (LLD), UTP (Unit Test Planning) documents, Unit testing of the codes and Preparing Release notes, Deployment and Support for product builds and Maintenance of database.
• Worked in Data Warehousing for OWB (ETL) tool extracting the data like .csv format creating various kinds of reports data analyzing, reconciliations, data validation, quality checking, Matching report data to Data Base data (Count the Data), Consolidation and DWH testing. Handling Customers wise and country wise reports. Pull the data from one schema to another schema. Developing Pro*C, SQL*Loader scripts like Control file, Log file and BAT file, work on it External tables (flat file) exports (Transform) and imports (Load).
• Generate the report from OWB consolidated report, Discrepancy report like .xls format, creating the Hyperlinks in .xls spread sheet reports send to Client.
• Creating new Objects, Joins table, structures and altering existing entity’s and attributes, Materialized Views, Sequences and Indexes changing in design descriptions as per Client requirements.
• Expanded Physical Data Model (PDM) for the OLTP application using ERwin.
• Provide Oracle Application Server and Oracle APEX implementation and support.
• Interacting with business regarding solving various codes issues and preparing daily, weekly reports and process performance monitors / Reports consolidated entity lists.
• Responsible for Analysis, Design, Development, Deployment and Support for product builds and Maintenance of database. It consists of BT Customers, Suppliers, Contracts, Sites, and Products and Inventory information.

Environment: Oracle 10g, Oracle Warehouse Builder (OWB) Tool, SQL Developer, Toad, hp Quality Centre, Oracle J Developer 10g, Oracle ADF Faces, BMC Remedy, PHP, Oracle APEX 4.0, ERWIN 3.5.2, Java, J2EE, PRO*C, Windows and Unix.

Confidential

Software Engineer

Responsibilities:

• Worked on PL/SQL programming Packages, Stored Procedures, Functions, Cursors and Triggers.
• Using UNIX (Shell Scripting) environment.
• Worked for data warehousing tool in Informatica (ETL) Extracting reports from process flow identified and data validation the business requirements for data Analysis, Quality, Matching, Consolidation various kind of reports for data warehousing testing.
• Gathered knowledge from the client side and reverse transitioned to the team.
• Assisting the Test Team during the functional testing and Unit testing.
• Worked on designing the logical model and Oracle ERP application.
• Performed impact analysis on the change requests from clients and proposed solutions.

Environment: Oracle 10g, Toad, Crystal Reports 8.5, Informatica (ETL), Pro*C, Oracle ADF Faces, Windows and UNIX.

Confidential

Developer

Responsibilities:

• Data Base Designing, Writing Stored Procedure & Trigger.
• Creating Report Module using in Crystal Reports 8.5.
• A central database or web location where sales and marketing indicators and reports can be easily retrieved.
• Provides self-service to information, and reduces the time and staff needed for reporting.
• Involved in design and development of data model (star schema).

Environment: Oracle 9i, SQL Developer, SQL Server, T-SQL, MS Access, VB.NET, ADO.NET, ASP.NET (VS 2005), PRO C, Crystal Reports 8.5, Forms 6i & Reports 6i, Window XP