SUMMARY

• Around 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 .
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments
• Performed tuning of an application using Explain Plan.
• Expert in Client-Server application development using Oracle 12i/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.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
• 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 .
• Formulated a comprehensive data migration plan with different conversion strategies, detailed object and field mappings including its transformations and business rules for converting legacy parolee data from Lotus Notes into Oracle.
• Migrated databases using Golden Gate and RMAN for 2 node RAC Automating tasks using cron for Golden Gate restart
• 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.
• Experience in installation of Agents on Hosts in both OEM12c & OEM 13c, Database Health checkup & Performance tuning running AWR report taking backups creating users by OEM 13c
• Experience in Upgrading of Databases from 11g to 12c And Configuring the Golden Gate on 12c databases.
• Experience in Migration of Databases from one platform to another platform using export import datapump.
• Data integration and migration specialist with over 5 years of extensive experience in leading the conversion of multiple legacy data systems from different sources into Oracle databases.
• 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 .
• Pre-Migration testing and validation of all data elements been converted.
• Extensive Knowledge on Tableau Desktop, Tableau Public, Tableau Reader and Tableau Server.
• Extensive experience with MS SQL SERVER 2016, 2014, 2012, 2008 R2, 2008 and 2005 Versions.
• Good Experience In MySQL ETL Tool SSIS, SSRS, SSAS .
• 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

Web Technologies: HTML/HTML5, CSS2/CSS3, DHTML, XML, XHTML, XSLT, Java, JavaScript, AJAX, jQuery, JSON, Apache, PHP, Responsive Design

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl programming, Java

Tools: PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, SQL Navigator, PUTTY (Unix/Linux Utilities), Solaris, FileZilla, WinSCP, Jira, ERWIN, APEX

Development Tools: Adobe Photoshop CS5, Google Ad Words, Yahoo Search Marketing (spring tool suite)

Oracle Tools/GUI: Forms 9i/10g, Reports 9i/10g, Discoverer 11g

Databases: Oracle 12c/11g/10g, PL/SQL (oracle), MySQL, MSSQL2008/2012

Operating Systems: Windows XP/Vista/7/8, MAC OS X, Linux

PROFESSIONAL EXPERIENCE

Confidential, AR

Sr. Oracle Developer

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• Functional experience in configuration, setup, unit and integration testing of Advanced Pricing, Oracle Order Management, Purchasing, Inventory, customizations on Cycle Count, and Standard Costing solutions designed for meeting gaps in client requirement and application.
• Good knowledge of Financial Modules like Account Receivable AR, General Ledger GL, Account Payables AP, Cash Management CM, I-Expenses, I-Procurement, Project Accounting PA, Oracle Trade Management OTM and Oracle Lease Management OLFM modules.
• Data integration and migration specialist with over 5 years of extensive experience in leading the conversion of multiple legacy data systems from different sources into Oracle databases.
• 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.
• Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC with EMC.
• Experienced in setting up/installation and configuration of release 11g RAC/10g R1 RAC with EMC Storage.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan .
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM
• Datapump Export & Import useage for the Migration of databases from one platform to another platform generation of code from TOAD.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL script s to extract the data from the operational database into simple flat text files using UTL FILE package .
• Conducted gap analysis and developed data migration and integration plans for conversion of Historical Rivers and Streams water quality data from 1988 into a centralized Oracle Surface water monitoring repository.
• Setup Oracle Enterprise Manager (OEM) 12c & Grid Control (11g) for database monitoring/performance/diagnostics.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Extensive uses of Oracle Data pump Exports/Imports utility for moving data among the servers.
• Implementation of database security procedures, maintenance of Oracle databases using OEM, ASM configuration and movement of data across databases using data pump export/import utilities.
• Installation, configuration, upgrade and performance tuning of Oracle RAC.
• Reviewed the deliverables from offshore and communicated changes to developers.
• Develops best practice, processes, and standards for effectively carrying out data migration activities
• Developed multiple logical and physical data models for the parolee database and the staging environments to support migration. 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 : UNIX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Oracle Pro*C, Microsoft Excel, TOAD, APEX 4.4.2 SQL, PL/SQL, CVS, XML., Golden Gate,RAC,DataPump,DataGuard,S hell Script

Confidential, AR

Sr. Oracle Pl/SQL Developer

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.
• Designed and developed the classes using core Java for thread safety in money transactions using Multithreading.
• Create new Oracle databases using DBCA or database scripts. Creating new ASM disk group or raw devices for RAC DBs
• Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and Develop Envinorment.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• 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.
• Actively involved in troubleshooting database issues. Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications.
• Responsible in Configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Experience on Script Programming using Korn shell, bash shell, Perl, Awk and knowledge on archiving tolls like tar, gunzip, backup, auditing both external auditing and internal auditing, experience on various UNIX platform like Redhat, AIX
• Developed Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules. Worked with Dynamic SQL, Global Temporary Tables.
• Good knowledge of maintaining SQL authenticated and Windows authenticated logins /users and grant proper privilege in MS SQL server’s
• Created materialized views, Inline Views & normal views where business requirements needed.
• Worked in Oracle reports and forms version 6i and 10g., 11g,12c
• 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.
• 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.
• 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, SQL, PL/SQL, ETL, SQL Developer, Toad, SQL*Loader, Shell Scripts, OEM 12c,MS SQL, Golden Gate,Data Pump.

Confidential, CA

Oracle Pl/SQL Developer

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• Configured and implemented Oracle 11g ACTIVE DATA GUARD for Database Disaster Recovery by using DATA GUARD
• 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.
• Experience with Data Analysis, Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques
• Expertise in Client-Server application development using Oracle 12c/11g/10g/9i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• 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.
• Created indexes on the tables for faster retrieval of the data to enhance database performance Tuning
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Involved in the continuous enhancements and fixing of production problems. Co-ordinated 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 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. Developed Unix Shell Scripts for scheduling the jobs and created pre and post session commands.

Environment: Oracle 11g, UNIX, Informatica Power Center 9.1