SUMMARY

• Having 8+years of IT experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms
• Extensive experience in writing/debugging Oracle SQL, Dynamic SQL, PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links (DBLINKS), Sequences, Synonyms, and Global Temporary tables, Cursor management, Exception handling etc.
• Proficient in Data Analysis, Data Validation, Data Lineage Data Cleansing, Data Verification and identifying data mismatch in data loading process.
• Extensively involved in writing SQL Queries (Sub queries and Join conditions), PL/SQL subprograms and Query Level Performance tuning.
• Strong understanding of end - to-end project management, SDLC methodologies of Waterfall and Agile.
• Performed tuning of an application using Explain Plan.
• Expert in Client-Server application development using Oracle 19c/11g, PL/SQL, SQL *PLUS, TOAD, SQL *LOADER.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Exposure in using Tools like TOAD, SQL Developer and SQL*Plus for writing PL/SQL Programs.
• Experience in creating complex triggers or generate packages and indexes to increase performance and complex SQL queries for joining multiple tables.
• Extensive experience developing External tables and using Oracle utility tools like SQL*Loader, Import and Export programs.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Developed Test Scripts, Test Cases and SQL QA Scripts to perform Unit Testing, System and Load Testing.
• Solid understanding of relational databases.
• Experience with data migration using BULK COLLECT.
• Strong SQL Server DDL, DML skills with expertise in writing efficient queries and troubleshooting complex queries.
• Experienced and fully engaged in Software Development Life Cycle (SDLC) which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the applications and providing production support.
• Knowledge in the design and development of interactive data, data visualizations, graphical dashboards and reports using any tools like Tableau.
• Extensive Knowledge on Tableau Desktop, Tableau Public, Tableau Reader and Tableau Server.
• Comfortable with advanced tableau topics such as complex calculations, table calculations, Filters, parameters, data blending, extract optimization.
• Knowledge in Designing & Formatting Dashboards using Tableau.
• Excellent skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Cursors, DDL/DML Triggers, Temporary tables, User Defined Data types (UDF) and Functions.
• Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

TECHNICAL SKILLS

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

Languages: SQL, PL/SQL, Shell Scripting, XML, C, C #, HTML, PERL, Python

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

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

Utilities: Toad, SQL*Plus, SQL*Loader, PUTTY, MS Office, WinSCP, SQL Developer, Autosys.

Data Warehousing/ETL: IBM Data Stage 8.5,8.1.1, 8.1, 8.0.1 /7.5.1 , Quality Stage 8.1, Informatica Power Center, SSIS.

MDM: IBM InfoSphere MDM 9x/11x

PROFESSIONAL EXPERIENCE

Sr. Oracle PL/SQL Developer

Confidential, Madison, NJ

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX, shell Scripts according to the changing needs of the project and client requirements.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Involved in the continuous enhancements and fixing of production problems.
• Coordinated and delegated work to Offshore team.
• Reviewed the deliverables from offshore and communicated changes to developers.
• Actively participated in Clarification Meetings with the Clients.
• Design and develop PL/SQL packages.
• Prepared application logic; Developed PL/SQL Packages and procedure; and also provided Target Load Order Dependencies.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Used PLSQL Stored Procedures, Packages, Database Triggers, SQL and Oracle Utilities in this development process time.
• Expertise in tuning, designing and developing ETL informatica Mapping, sessions and workflow using Informatica 7.1, 8.1, 8.6, 8.6.1 and 9.6.1

Environment: : Oracle 11g/19c, Erwin, SQL*Plus, Solaris, PUTTY, DB2, Git, svn, python, Jenkins,RMAN.

PL/SQL Developer

Confidential, Indianapolis, IN

Responsibilities:

• Worked on the bulk uploading of huge amounts of statistical data to the database.
• Wrote Loader scripts using SQL Loader/External tables to load large tables.
• Actively involved in troubleshooting database issues.
• Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications.
• Developed Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules.
• Worked with Dynamic SQL, Global Temporary Tables.
• Created materialized views, Inline Views & normal views where business requirements needed.
• Worked in Oracle reports and forms version 6i and 10g.
• Worked on Pro*C programs and PL/SQL Scripts to generate full extracts of large tables.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Developed stored procedures and packages. Extensive work in PL/SQL.
• Developed Reports and forms using Oracle Designer.
• Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.
• Worked on developing/supporting Oracle APEX applications.
• Our group supports numerous Oracle APEX applications.
• Resources are needed to help support additional applications that will be acquired by our team. They will need to provide run the engine and production support.
• They will also be asked to perform risk assessments and add needed controls to close any control gaps.
• Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Designed and developed the classes using core Java for thread safety in money transactions using Multithreading.
• Responsible for developing and modifying several PL/SQL packages, procedures, functions, views and triggers using PL/SQL.
• Optimized queries by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes on tables where required.
• Expertise in optimizing ETL tuning and excellent in designing, developing and testing of ETL jobs and mappings in server and parallel jobs using Data stage to populate tables in Data Warehouse and Data marts

Environment: : Oracle 11g/10g,Erwin, SQL*Plus, TOAD, Autosys, Unix, PUTTY, Data stage, Siebel, HP life cycle, Star Team, Java RTC, Sql Server.

PL/SQL Developer

Confidential

Responsibilities:

• Created materialized views on remote source database and automated scheduler of refreshing of materialized view on source side.
• Created the DB-Links pointing to the remote database to access the source materialized views.
• Created or Modified the Sequel Script (.sql file) to point to the current source.
• Extracted data from the source views by writing the procedures to load the data into staging tables.
• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Created the tables and sequences for the experimental data load capture.
• As a Senior Data Analyst, I analyzed, designed and implemented ODS, Data marts, Data warehouse and operational databases.
• Loaded the Contracts, Products, Customers & Sales data into the created tables using SQL Loader script.
• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from staging tables to the target schema.
• Built Perl programming/libraries to acquire and process multiple varied data formats.
• Enhanced it with creating exceptions for error handling.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Database security by authenticating users, using logon triggers.
• Created indexes on tables and optimized procedure queries.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
• Responsible for Unit, System and UAT testing the data and provided the test evidence reports.
• Involved in UAT testing, Bugs fixing, and the code was sent to Production.

Environment: : Oracle 11g/10g, Erwin, SQL*Plus, TOAD, Autosys, Unix, PUTTY, MS Office, SSIS.

P L/SQL Developer

Confidential

Responsibilities:

• Created materialized views on remote source database and automated scheduler of refreshing of materialized view on source side.
• Created the DB-Links pointing to the remote database to access the source materialized views.
• Created or Modified the Sequel Script (.sql file) to point to the current source.
• Extracted data from the source views by writing the procedures to load the data into staging tables.
• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Created the tables and sequences for the experimental data load capture.

Environment: : Oracle 10g, SQL*Plus, PUTTY, MS Office