SUMMARY

• Over 8 years of IT experience in Analysis, Design, Modeling, Development, Testing and Implementation of Data Warehousing Business Applications.
• Excellent skills in designing and development of applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL good knowledge on Oracle tools like SQL*PLUS, PL/SQL, SQL, T - SQL scripts, and used TOAD in many development projects.
• In depth Knowledge and experience of Data Warehouse/Data Mart design and implantation concepts.
• ExcellentSQL skills, experience writing complex queries and working with database objectslike tables, views, sequences, synonyms.
• Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
• Experience in Bulk Data loading using Oracle utilities namely SQL*Loader, External Tables, working on both OLTP and OLAP databases and creating performance benchmarks and generating SQL*Plus reports.
• Extensive experience inQuery Performance TuningbyAnalyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collectfeature,Materialized View, DBMS packages and exception handling, Global Temporary tables and TroubleshootingOracle database issues.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader, UTL File Utilities and worked on External Tables and Transportable table spaces.
• Good knowledge of Data Modeling using ETL tools, OLAP and OLTP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Excellent in developing reports using Cognos Tool.
• In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL and PL/SQL using database tools like Toad, SQL Navigator.
• Profound knowledge in UNIX shell scripting of files and process manipulation.
• Proficient knowledge of PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections and creation of database objects like tables, views, synonyms, sequences, Indexes, Triggers, Table partitions, Sub-partitioning, Database links etc.
• Refined database reports to extract selected data useful for creating training monitoring plan.
• Experience in creating ETL transformations and jobs using Pentaho and Pentaho Data Integration Designer and scheduling them on Pentaho
• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.

TECHNICAL SKILLS

• Dimensional Data Modeling
• Star and Snow-Flake Schema Modeling
• FACT and Dimensions Tables
• Physical and Logical Data Modeling
• Erwin
• TOAD
• SQL Navigator
• Oracle 11g/10g/9i/8i
• SQL Server
• Sybase
• SQL
• PL/SQL
• UNIX Shell Scripting
• Windows XP/2003/2000/NT/98/95
• UNIX
• Control M
• AutoSys
• ETL (Pentaho).

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Ensure conformance to code standards and documentation requirements. Used Dynamic SQL programming technique to build and process SQL statements.
• Creation of database objects like Tables, Indexes, Views, Stored Procedures, Functions, Triggers, and Synonyms.
• Used TOAD, PL/SQL developer tools for faster application development.
• Constructed standard and materialized views for viewing and extracting usable data from various sources to get a clear real-time view of business-critical information
• Extensively involved in developing PL/SQL packages that includes advanced PL/SQL concepts like REF CURSOR, BULK COLLECTS, for all, etc.
• Used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data form staging tables into base tables.
• Performed exception handling and analyzed table structures and integrity constraints for report-creation strategies.
• Production support for data fixes and debugging aborted processes.
• Extensively involved in Oracle query (SQL) tuning, PL/SQL execution optimization, Explain Plan, SQL Trace, tipoff, Stats Pack and SQL*PLUS Auto trace.
• Performed functional testing for the procedures and packages.
• Extensive use of UC4 in windows environment for scheduling routine tasks.

Environment: Oracle 11g, PL/SQL, TOAD, PL/SQL Developer, SQL*Loader, Windows, SQL*PLUS, Windows XP/07, MS Excel, Solaris, SQL Navigator, UC4.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked with the Business Analysts and Users in understanding the business requirements for the project.
• Participated in different phases of a project analysis phase, preparing the technical specification, development and testing.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Created database objects like tables, views, procedures, packages, and cursor using TOAD.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Handled Exception extensively for the ease of debugging and displaying the error messages in the application.
• Interacted with Business Users in creating Unit and System Testing for new development application.
• Application support in resolving production problems for existing application and ensure all issues get resolved accordingly.
• Delivered tasks accurately in time provided.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic SQL.
• Developed Oracle partitions, and performance tuning/query tuning.
• Experience in creating ETL transformations and jobs using Pentaho and Pentaho Data Integration Designer and scheduling them on Pentaho.

Environment: Oracle 11g (SQL*PLUS), Java J2EE, External Table, UNIX, PL/SQL Developer, Toad, SQL/Plus, MS Office, Windows XP/07, Erwin r8, Crystal 6, MS Visio, ETL (Pentaho), Control M, Linux, SQL, PL/SQL.

Confidential

Oracle developer

Responsibilities:

• Worked with Oracle database consisted of more than 50GB sized tables.
• Extensively used EXPLAIN PLAN and TKPROF for SQL tuning.
• Tuned approximately 100 complex SQL queries.
• Used Optimizer HINT for tuning SQL and Advanced PL/SQL.
• Generated the trace files for more than 40 batch jobs to find the optimal queries.
• Tuned auto generated SQL - created INDEX based on the requirement of the table.
• Worked with DBMS PROFILER to tune PL/SQL Procedures.
• Created log on trigger and new user to run batch jobs for collecting the trace files.
• Used cursor, ref cursor, bulk collect and bulk insert (Bulk Binding) in procedure to reduce its execution time.
• Created packages and stored procedures for data conversion by using DBMS RANDOM package
• Worked with DBMS SCHEDULER to schedule jobs.
• Created Materialized Views to reduce the network load.
• Extensively used TOAD for tuning, for database monitoring.
• Created UNIX shell scripts for regular tasks and used UNIX commands as per needed.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
• Optimize existing T-SQL code.
• Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
• PARTITION 4 to 5 tables (size of those tables are more than 100GB) to manage database and to improve the performance.
• Experienced in using AutoSys tool to set up scheduled jobs within a Windows environment that runOracle PL/SQL.
• Experience in creating ETL transformations and jobs using Pentaho and Pentaho Data Integration Designer and scheduling them on Pentaho.

Environment: Oracle 11g, Oracle SQL Developer, SMS Office (Excel, Word), TOAD, SQL*Loader, FTP, Windows XP, AutoSys, Linux, Pentaho, SQL.

Confidential, Jacksonville, FL

Oracle Developer

Responsibilities:

• Involved in gathering Business Requirements and implementing the Conversion and Implementation of Software Development Life Cycle (SDLC).
• Responsible for creating and maintaining the stored procedures, Function, Packages and Triggers.
• Interacted with the business users on a regular basis to collect business requirements and specifications.
• Provided Security for the Oracle database objects.
• Created database objects such as tables, views, synonyms, indexes, clusters,
• Sequences and database link as per business requirements.
• Involved Database Administration of database objects, including tables, clusters, Indexes, views, sequences, packages and procedures Troubleshoots with regards to database problems and QA defects.
• Maintaining the Database changes according to the client’s requirements.
• Tested new enhancements and bug fixes before deployment into the production Environment.
• Worked as part of a team to launch new releases under strict time deadlines.
• Developed Control files using SQL*Loader to perform bulk data loads into database Tables from external data files.
• Generated Dashboards by joining multiple complex tables.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.

Environment: Oracle 10g, Oracle SQL Developer, SMS Office (Excel, Word), TOAD, SQL*Loader, FTP, Windows XP.BI Software/ Programming languages Tableau, T-SQL.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Monitored Usage Processing of Billing System.
• Extensively Performed back end database development tasks such as PL/SQL, Trigger, SQL Queries, Functions and Packages.
• Involved in performance tuning and monitoring, tuned SQL queries using Explain plan.
• Added hints, indexes and parallel processing techniques for the queries.
• Created SQL to delete the duplicate values from the datable table.
• Extensively used UNIX commands as per requirement.
• Used DDL statements to create new database objects like tables, views, sequences, functions, synonyms, roles and granting privileges by incorporating business standards

Environment: ORACLE 9i, TOAD, UNIX, C#, Windows NT, SQL