SUMMARY

• More than 8 years of experience as an Oracle PL/SQL Developer, System Analysis, Design, Development & Support of Oracle Database 11g/10g in Production, Staging, Development, and Testing Environments.
• Experience with all phases of the Software Development Life Cycle (SDLC) including analysis, Physical and Logical Design, Code Development, Testing, Implementing and Maintenance.
• Extensive knowledge of UNIX Shell scripting, Relational Database Management Systems,SQL and PLSQL.
• Proficient in creating PL/SQL Packages, Procedures, Functions, Exceptions, Views, Triggers, Dynamic SQL, Collections Exception Handling, Materialized views, REF Cursors, Partitioning, Indexes, Hints, Grants and Synonyms.
• Exposure on writing and debugging UNIX korn shell scripting.
• Exposure on writing shell script by using sed, awk command and vi editor.
• Working knowledge on UNIX and Data Warehousing/ETL concepts - created Shell scripts for invoking SQL scripts.
• Experience in query level performance tuning using Explain Plan.
• Extensive experience of Oracle tools like TOAD, SQL*PLUS, and PL/SQL Developer.
• Optimization experience using DBMS STATS to gather statistics, and Analyzing DB objects.
• Experience in UNIX Shell Scripting, knowledge of Crontab in UNIX environment for scheduling routine tasks.
• Experience in Batch Scripting to execute On Demand as well as EOD Jobs.
• Experience in data loading from other databases and text files into Oracle database using SQL*Loader.
• Working knowledge of Data Warehousing concepts like Star Schema and Snowflake Schema, and Data Marts used in relational and dimensional modeling.
• Knowledge of DBMS SCHEDULER, DBMS JOB, DBMS DATAPUMP, and UTL FILE packages
• Good understanding of the concept of Normalization.
• Worked with the technical teams, DBAs, and offshore teams for issues related to code changes, data fixes, testing, and database changes.
• Experience in maintaining different versions of code using various Version Control tools.
• Experience in unit testing, writing test plans and test cases.
• Possess excellent communication, interpersonal and presentation skills.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Excellent team player with the ability to work independently and interact with people at all levels.
• Experience in working under high stress environment to meet the project deadlines.
• Extensively involved in Query Performance Tuning by creating the Indexes and rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statement.

TECHNICAL SKILLS

Environment: Windows, Unix(Solaris)

Database: Oracle 10g,11g,12c,MySQL

Languages: Java, J2EE, SQL, PL/SQL, Unix Shell scripting

ETL: Informatica, Abinitio

BI Tools: Cognos,Qlik view

Others Tools and Tech: R, Erwin, Control M/Cron tab/Autosys, SVN,Toad,PuTTY

Web Tech: J2EE, C#.NET,C++,PHP,CSS,HTML

PROFESSIONAL EXPERIENCE

Confidential, New Brunswick, NJ

Oracle PL/SQL Developer

Responsibilities:

• Understanding the business requirements, writing functional specs, test specs and plans.
• Translation of business requirements to an Enterprise Data model.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, synonyms, indexes, triggers.
• Developed stored procedures, packages and functions for workflow validation and verification.
• Prepared procedures to update the internal structures to reflect the newly loaded data.
• Created Cursors, Collections and Triggers.
• Experience in enforcing data integrity using integrity constraints.
• Loaded the data into database using the SQL*Loader from various sources.
• Using UNIX environment for performing the testing.
• Experience in Loading external files (Excel, XML) into database using SQL*Loader.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment.
• Involved in Data Analysis and reducing data discrepancy for the source and target schemas.

Environment: Oracle, SQL, PL/SQL, Oracle, Windows XP, UNIX Shell Scripting. Java, J2EE

Confidential - Stamford CT

Oracle Developer

Responsibilities:

• Involved in creation of databases, moved databases by recreating control files, export/import, and complete backups. Created and maintained Oracle schema objects like Table spaces, Tables, Rollback segments, Indexes, Sequences and Synonyms.
• Design Logical and Physical data, define relationships, and implement business rules as constraints for normalization / demoralization of entities.
• Wrote SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the intermediate tables.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Used Toad 8.0 for database monitoring and tuning.
• Generated XML files for data transfer. Used XML parser to parse the data.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Interacted with users regarding the proposed solution and design for customization and the migration strategy.
• Wrote stored procedures and Shell Scripts for automating (batch process) the execution of sessions.
• Created UNIX Shell Scripts for automating the execution process.

Environment: SQL, PL/SQL, SQL* Loader, Shell Scripting, SQL Developer, Oracle 11g, Java, J2EE

Confidential, NYC

Oracle PL/SQL Developer

Responsibilities:

• Developing highly complex applications using Oracle 10g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Created UNIX Shell Scripts for automating the execution process.
• Participated in system analysis and data modeling, which included creating Tables, Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• Wrote UNIX shell scripts to schedule time based loads for the Cron jobs.
• Writing Shell scripts to call stored procedures and packages to load data files using external tables.
• Created relevant staging tables to load the CSV files, identified the Business validation rules. Created SQL Loader script generator Application using UNIX shell scripting and PL/SQL.
• Designed and created ETL processes to transfer data from multiple operational data sources to Data warehouse Tables based on business requirements.
• Utilized SQL*Loader to load flat files into database tables.
• Used PL/SQL developing to load data from the source table to the target table based on the business logic.
• Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
• Created PL/SQL blocks using Cursors, REF Cursors, Collections - Nested Table, various Complex Triggers
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Responsible for performance tuning activities in oracle.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Used Materialized Views in order to improve the performance.

Environment: UNIX Shell Scripting, Oracle Database 10g, TOAD,PL/SQL, Oracle Developer Suite 10g, PuTTY

Confidential

PL/SQL Developer

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Developed the SQL*Loader script, and most of PL/SQL stored procedures, Triggers, and views to handle the Online and Batch processes.
• Developed PL/SQL packages, Oracle tables, stored procedures, triggers and UNIX shell scripts.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file.
• Used Oracle snapshots for replication between various sub branches.
• Creating SQL, Object Views, and PL/SQL database objects. Developed the stored procedures for data transformation purposes.
• Tuned the SQL Queries with the output of Oracle Tools like Explain Plan, TKPROF.
• Fixing bugs according to the software change requirement.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Responsible for unit testing, and documentation of the interfaces.

Environment: Oracle database 9i, PL/SQL, SQL Plus, SQL*LOADER, Windows 2000 Professional, and UNIX Shell Scripting.