SUMMARY:

• 11 years of Oracle database experience in ORACLE 11g/10g/9i /Microsoft SQL Server 2005/2008/2012 Database Developer/Administration in Production/Development environments, which includes design, development, coding and testing, database creation, upgrades, tuning, maintenance, backups and recovery in both Unix (Sun Solaris, IBM AIX, Confidential - UX & Red Hat Linux) and Windows Environments.
• Experience working in different areas like E-commerce, Financial, Manufacturing to deliver new products.
• Skilled in all dimensions of functionality, usability, reliability and Agile Methodology
• Resolve application problems to maintain high level of customer satisfaction.
• Extensively worked in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Proficient in data migrations, data loads, data conversions, interface (Inbound/Outbound) programs, workflows and using Oracle ETL Utility tools like SQL Loader, External Tables, export, import and data pump.
• Innovative professional with proven ability to identify, analyze, and solve problems to increase customer satisfaction through expertise knowledge in database programming using PL/SQL Collections, Cursors, Bulk Processes (DML), Merge, Dynamic SQL (DDL), Exceptions handling, Autonomous transactions, Pipelined Table Functions, Partitioning, Materialized views.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
• Experience in creating Data Marts, Data warehousing, Operational Data Store (ODS), Data Modeling like Dimensional Data Modeling, Star Schema Modeling, snowflake schema Modeling and good understanding about Fact and Dimensions
• Very Good Experience in Data Warehouse Created start schema and snow flake schema data model and populated data using ETL tools.
• Experience in creating SQL server SSIS using Microsoft visual studio
• Good exposure to DBA routine tasks like managing users, roles, privileges, schema and objects, developing PL/SQL triggers for user access audit.
• Very proficient knowledge in installing and Implementing Physical Data Guard.
• Experience in Installing and Configuring Automatic storage management (ASM) Instance
• Good experience in Installation and configuration of RAC (Real Application Cluster) on different nodes.
• Familiar with Oracle backup utility RMAN to implement Oracle backup.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Widely used SQL*Loader to load files into database and Written shell scripts to automate loading file into database.
• Experience working with Business Intelligence Tools and Reporting tools like Business Objects XI (XI 3.x) and Crystal Reports.
• Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills and excellent interpersonal and communication skills, self-starter and a quick learner.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i, MS SQL Server 2005/2008/R2, MongoDB, MS Access

DB Utilities: SQL*LOADER, EXP, IMP, RMAN, RAC, Oracle Enterprise Manager (OEM), Business Objects (XI 3.x), Crystal Reports, Erwin, Toad, Confidential Archival Designer 6.3, Talend, Apatar, Informatica

Other Tools: Putty, Mobaxterm, FileZilla, CuteFTP, Eclipse, Smart FTP 1.0, MS Word, Excel, PowerPoint, MS VISIO, MS Project

Operating System: Red Hat Linux 5.0/4.0, IBM AIX 4.3/5.2, Sun Solaris 5.8/5.9/5.10, Confidential -UX 9.0, Windows 95/98/2000/XP/7, Windows Server 2003/2008.

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Programming, Basic Java, HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

• Designed data governance framework
• Working very closely with Supply change team
• Developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages.
• Designed package to extract data in text file and send business user to daily/weekly.
• Used Oracle java utilities to send email with multiple attachment.
• Developed various reports on tableau desktop.
• Created operational metrics on tableau.
• Developed ETL process to extract data from legacy ERP to Staging environment.
• Developed Database Triggers for audit and validation purpose.
• Working extensively on exception handling, to trouble-shoot PL/SQL code.
• Migrated MySQL, MS Access data to Oracle

Environment: Oracle 12c/11g,, SQL developer, SQL Plus, SQL* Loader

Confidential, San Jose, CA

Sr. PL/SQL Developer

• Working on Agile Methodology
• Coordinated with the front end design/JAVA team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages.
• Extensively used Dynamic SQL.
• Daily receiving flat file from different vendor and loading into Oracle database using SQLLOADER.
• Working on Oracle Total Recall to get history data for compliance audit process.
• Created various triggers for Audit process.
• Developing data archival process with merging/exchanging table partition.
• Experience in Merging Partition, Exchange Partition and Drop Partition
• Involved in PL/SQL code review and modification for the development of new requirements.
• Working with DevOps team
• Working closely with DBAs in monitoring the performance related issues.
• Involved in the continuous enhancements and fixing of production problems.
• Developing Auto-sys jobs and Shell Scripting in UNIX environment for scheduling routine task.

Environment: Oracle 12c, Jira, SQL developer, Putty, SQL Plus, SQL* Loader, FileZilla

Confidential, Needham, MA

Sr.PL/SQL Developer

• Involved in the implementation and maintenance of the application.
• Maintained good rapport with Business Analyst & Business Users to identify information needs as per business requirements.
• Migrated Oracle Siebel CRM data to PTC Integrity defect management application
• Worked on multiple Salesforce data migration project
• Responsible for data validation as per business logic before migrating to new application
• Responsible to validate migrated data with new application interface
• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Created Materialized view on staging database to get up-to-date data
• Responsible for creating a complete process and developing subsequent SQLLOADER scripts for data transformation from old legacy systems to new application.
• Created complex views over real time data for tech support team
• Extracted data from various data source using open source ETL tool like - Apatar, Talend
• Exporting and Importing data using Data pump utilities
• Created java program to update various tables on multiple database for Post data migration activities.
• Associated with DBA’s in monitoring the performance related issues using Explain Plan, SQL Trace.
• Working extensively on exception handling, to trouble-shoot PL/SQL code.
• Extensively used TOAD for database access and PL/SQL Development and SQL tuning.

Environment: Oracle 11g, Linux / Confidential -UX, RAC, SQL developer, Talend, Apatar, Informatica, TOAD, OLTP, Putty, SQL Plus, SQL* Loader, Data Pump

Confidential, Framingham, MA

PL/SQL Developer

• Worked on Confidential Customer Royalty Service ( Confidential Rewards System)
• Involved in debugging various defects relating to implementation of business logic.
• Developed/modified tables, views, functions, Stored Procedures and Package as Business requirement.
• Created complex stored procedure to calculate reward program
• Developed and modified UNIX scripts to wrap PL/SQL code
• Extensively used TOAD and SQL Developer for database access and PL/SQL Development and SQL tuning.
• Involved in the data extraction and data conversion of fixed format and comma separated files using SQLLOADER to perform daily data load, provided by the Sales team.
• Developed and modified UNIX scripts
• Worked on Java and HTML to modified front end application banners
• Used Microsoft visual studio to create SSIS package
• Created SSIS package to export data from Oracle to SQL server
• Created Stored procedure on SQL server using T-SQL
• Partitioned database tables using Range, List and Composite partitioning.
• Responsible for prepare test data for various test scenario.
• Involved in performance tuning on stored procedure and SQL queries

Environment: Oracle 11g/10g, MS SQL Server 2005, Confidential -UX, SSIS, SQL developer, TOAD, Putty, SQL Plus, SQL* Loader

Confidential, Philadelphia, PA

PL/SQL Developer

• Involved in SDLC gathering requirements from end users.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Developed SSIS package to export data from Oracle to SQL server
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Created materialized views using different clauses.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts

Environment: Oracle 11g/10g, SQL Server 2005, SSIS, Linux/Windows, Toad, SQL* Plus, Putty, SQL Loader

Confidential, Houston, TX

PL/SQL Developer/Analyst

• Involved in all stage of system Development Life Cycle (SDLC): Scoping, Analysis, Design, Construction and testing
• Worked very closely with Business Analyst and Participated in business process evaluation/improvement activities
• Created Technical Design documents for major developments and attended Technical Design Reviews.
• Designed and developed database stored procedure, package, functions and triggers
• Performed data modeling including reverse engineering using the Toad Data Modeling tool
• Designed archival job business flow using Confidential designer 6.3
• Loaded data in base tables from temporary tables using BULK COLLECT in stored procedures
• Used PL/SQL tables, array structures as a part of oracle collections.
• Involved in data Integration send/load received data from different source
• Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
• Daily monitoring Tidal Job
• Worked in data migration from old SharePoint list to new SharePoint list
• Maintained document for development, testing, implementation, data integration, Tidal jobs in SharePoint list
• Working closely with quantitative analysts in a highly fast-paced environment to fix production issues and provide enhancements as per requirements

Environment: Confidential -UX/Linux/Windows, Toad, Erwin, Confidential Designer 6.3, Confidential ALM, OBI, Informatica, PeopleSoft, Workday, SQL* Plus, SharePoint, CaliberRM, Oracle 11g, SQL Server 2008

Confidential, King of Prussia, PA

Oracle PL/SQL Developer/DBA

• Created and managed users, roles and profiles, audited and monitored databases and user access
• Created database objects, managed partitioned tables, managed table spaces.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Developed Unix shell scripts for automating many tasks.
• Tuned Report performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
• Modify existing codes to optimize Oracle applications
• Extensively used exp, imp and data pump utilities to build changes.
• Responsible for Partitions on tables and Indexes for managing large tables.
• Wrote shell scripts for monitoring the database.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Worked with Development team to fulfill the requirements of applications with Database design
• Maintaining data integrity and tune database for optimum performance and availability.

Environment: Oracle 10g/ 11g, Red hat Linux 5.0, SQL Plus, OEM, Confio Ignite, Putty, Toad, SmartFTP, SQL server 2005, Business Objects XI (3.x), Crystal Reports XI.

Confidential, Burlington, MA

PL/SQL Developer

• Involved in the implementation and maintenance of the application.
• Maintained good rapport with Business Analyst & Business Users to identify information needs as per business requirements.
• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.
• Performed discussions with data modeler to update the data model for new requirements.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Associated with DBA’s in monitoring the performance related issues using Explain Plan, SQL Trace.
• Worked extensively on exception handling, to trouble-shoot PL/SQL code.
• Extensively used TOAD for database access and PL/SQL Development and SQL tuning.
• Extensive use of several Oracle provided packages such as UTL FILE, DBMS JOB, and DBMS SCHEDULER, DBMS Sessions.
• Extensive use of CRONTAB and Shell Scripting in UNIX environment for scheduling routine task.
• Developed and modified UNIX scripts to wrap PL/SQL code, FTP files, send emails, automate batch processing and upload data. Extensively used BLOB and CLOB to store images and large documents.

Environment: Oracle 11g/10g, Linux 3.0, RAC, ASM, TOAD, OLTP, Putty, Mobaxterm, SQL Plus, SQL* Loader FileZilla, Crystal Reports.

Confidential, Williston, VT

Oracle PL/SQL Developer/Administrator

• Created PL/SQL Stored Procedures and Functions in order to validate various new orders, it includes validating the entire packages using Exceptions, constraints, DBMS Auditing tools as well.
• Created and scheduled numerous Shell (Korn) scripts using VI editor which will be useful for loading files into database. Also involved in automating the file transfer process, report generation process.
• Involved in the data extraction and data conversion of fixed format and comma separated files using Oracle EXTERNAL TABLES, writing it into another file using UTL FILE concepts.
• Extracted data from various databases and loaded into Oracle Database on a monthly basis using SQL LOADER and External table utilities.
• Used XML for data transfer across the components.
• Developed a Custom Package which parses and compares fields from a xml using DBMS XMLDOM package
• Created Data Validation procedures and functions for verifying and uploading into respective schemas.
• Involved in the Proactive and Reactive tuning for SQL Queries in order to enhance the retrieval of data, using EXPLAIN PLAN and TKPROF, SQL Trace.
• Involved in creation of tablespaces, users, privileges, indexes, constraints, triggers, and synonyms, roles in order to facilitate and upload new products.
• Partitioned database tables using Range, Hash, List and Composite partitioning. Implemented bulk loading techniques like Exchange Partitioning, Bulk Collect, Parallel/Append Hints, external tables and SQL loader.

Environment: Oracle 10g/11g, Quest Toad Ver8.5, SQL*Loader, Windows, Sun Solaris 5.8, Erwin4.0, Data Guard, OEM, RMAN, Exp/Imp, SmartFTP, Putty, SQL Trace, People Soft

Confidential

PL/SQL Developer

• Created data model, logical design, and physical design of the database.
• Involved in various stages like development, system Analysis, and design for new application.
• Developed stored procedures, functions, views and triggers.
• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirements
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer (execution Plan).
• Used DDL and DML to writing triggers, stored procedure to check the data entry and payment verification.

Environment: Oracle 9i/ 10g, Red hat Linux 4, Windows 2000/NT, SQL Plus, SQL Developer, TOAD 8.5