SUMMARY

• Over 8+ years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL Developer.
• Expertise in SQL and PL/SQL programming and strong knowledge on Oracle architecture and database design
• Expertise in loading data from flat files to the Database Tables using SQL*Loader, External Tables, UTL Utilities
• Strong experience in designing and developing SQL Queries, PL/SQL packages, Functions, Stored Procedures, Views, Triggers and Cursors, Oracle objects Views, Materialized Views, Sequences, Synonyms, Database Links, and table - spaces
• Experience in advanced PL/SQL programming using Records, Collections and Bulk collect, Nested tables, Types, V-arrays involving in Landscape of Database
• Experience in client-server application development using Oracle … Toad, SQL* Plus, SQL *LOADER and PL/SQL developer
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables
• Experienced in Unit testing and Integration Testing with excellent debugging skills
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning
• Experience in developing SQL Loader control programs and PL/SQL validation scripts for validating the data load from staging area to production.
• Sound knowledge in UNIX Shell scripting
• An expert with Excel/VBA and well aware of the close relationship Excel and Oracle have
• Extensive work experience in ETL processes consisting of data sourcing, data transformation, mapping and loading of data from multiple source systems into Data Warehouse
• Experience on the implementation of ETL Tools by using Oracle Warehouse Builder (OWB)
• Designed the Data Warehouse/ ETL processes using Informatica Power Center 9.6 to extract, transform and load data from multiple input sources
• Experience on Data Warehousing, developing strategies for Extraction, Transformation & Loading (ETL) mechanism-using Teradata and UNIX
• Developed UNIX Shell scripts to automate table creation, execute procedures using dyn amic SQL statements
• Integrated Excel spreadsheets into Oracle using SQL*Loader
• Exposure to Waterfall, AGILE software development methodologies
• Sound knowledge in PHP, Python and programming proficiency in .NET
• Expertise in Java, Algorithms, data structures and problem solving skills
• Experience with Software development life cycle (SDLC) process - performing detailed analysis, collecting requirements, documenting requirements, coding and unit testing, integration
• Developed normalized Logical and physical database models to design OLTP system
• Good understanding in the areas of Users, Roles, Privileges, Schema and Object management & Session monitoring
• Worked on production support, troubleshooting the application and resolving bugs
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings
• Facilitated user training to build skills in the advanced use of Microsoft Excel

TECHNICAL SKILLS

RDBMS: Oracle 12c/ 11g/10g/9i

Languages: SQL, PL/SQL,C#, Shell Scripting, Perl, Power Shell Scripting

Operating Systems: UNIX(AIX), Sun Solaris and Windows NT

Oracle Tools: SQL*Loader, TOAD, Forms Builder 10g/9i/6i, Reports Builder 10g/9i/6i

GUI: Developer/2000 Forms 10g/9i/6i, Reports 10g/9i/6i

Other tools: Sub Version (Microsoft), GIT,SVN, Putty

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

Sr. Oracle SQL Developer

Responsibilities:

• Support development, test and production environments using Oracle Forms and Reports.
• Understanding the functionality, design and client requirements Development of the queries in SQL and PL/SQL.
• Performed DB2 development, support and optimization activities.
• Performed code reviews and recommended improvements.
• Exceptional skills in Tuning and analyzing application code such as SQL, Triggers, Stored Procedures, CPU, I/O, Memory, Setting up Backup and recovery strategies, Scheduling jobs, developing database procedures, functions and packages
• Database Performance monitoring, tuning and capacity planning of Existing/new programs
• Coordinated with Manager to prepare technical estimates and timelines.
• Worked with Analysts to develop system requirements.
• Coordinated with testers to troubleshoot software defects.
• Developed database documentations based on PMO standards.
• Maintained database release deployment scripts.
• Reviewed and improvised database build procedures.

Environment: Oracle, PL/SQL, DB2, Oracle forms, reports, Ms Office

Confidential - Dublin, OH

Sr. Oracle SQL Developer

Responsibilities:

• Created Technical Design for the Back End PL/SQL based on Business Requirement Documents and the Functional System Design.
• Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using oracle tools like PL/SQL Developer.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API's like Java, .Net and Hierarchical databases like Oracle and Access.
• Built Complex queries using SQL and wrote stored procedures using PL/SQL.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Involved in moving the data from flat files to staging area tables using SQL *Loader.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE.
• Provide support to Front End and fix defects in various stages of Testing i.e IST, ET and UAT.
• Perform Technical Validation on production Release day and send a Success/ failure report accordingly.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL) program asynchronously.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
• Used Crontab to schedule the shellscripts to run at particular time on a particular day.
• Worked closely with users in gathering and analyzing requirements and providing solutions that meet their requirements.
• Worked on Oracle XML/BI Publisher Reports to show the Data from Custom tables as requested by the business.

Environment: Oracle 11g, PL/SQL, SQL Developer, TOAD, Unix Sun Solaris 2.6,Oracle Applications R11i/R12, WINDOWS NT Workstation.

Confidential, NYC

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in maintenance and enhancement of the application.
• Designed/developed tables, views, various SQL queries, stored procedures, functions and Packages to implement the business logic using PL/SQL.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Involved in front end enhancements using PowerBuilder.
• Handling production support activities like resolving L2, L1 and critical tickets within the SLA.
• Unit Testing/Peer review of Enhancements performed by me and my peers.
• Preparing TA Documents, Unit Test Case, Estimate and Review Report documents for the enhancements executed by me.
• Used PL/SQL tables, array structures as a part of oracle collections.
• Providing Application wise and Technical KT to new resources of the team and bringing them to the level quickly and Solving day-to-day problems, providing support to the users.
• Communicate confidently and proactively with customers throughout the project lifecycle.
• Identify Source tables (OLTP) and Target tables (OLAP) for Data mapping.
• Participate in Design Reviews of Data model and Informatica mapping design.
• Assisted in creating Logical and Physical data modeling.
• Worked on Mapping designer, workflow designer, workflow monitor etc. of Informatica.
• Development of mappings workflows and session tasks using Informatica Power Center.
• Examining the session logs if the workflows fail and fixing up the defect.
• Debugging mappings using Debugger tool in Designer.
• Participated in testing Data matching between Siebel and OBIEE Databases and Dashboards.

Environment: Oracle(11g) PL/SQL, SQL, Toad 9.7, XML, UNIX Shell scripting, Clear Case,Pro*C, Informatica

Confidential, Tampa, FL

Oracle PL/SQL Developer

Responsibilities:

• Created a procedure to move the data from the temporary tables to the main tables
• Involved in the development of the Canadian IShares created order file project. This was an extensive package involving the validation of the approved orders created for the current date.
• Quickly learned PowerBuilder and created PowerBuilder screens for the Underwriters project.

Environment: Oracle 11g, TOAD, SQL Plus, PL/SQL, PowerBuilder 9.0, VB.NET, JAVA, Net Beans, PVCS, Mercury