SUMMARY

• About 10 years of I/T experience as an Oracle SQL & PL/SQL Developer in Analysis, Designing, coding, System Testing and Implementation of Applications using Oracle 11g/10g/9i/8i RDBMS software.
• Strong experience in creating database objects such as Complex SQL, PL/SQL Packages, Procedure, Function, Trigger (DML & Non - DML), Type, Table and Views using Toad, SQL Developer and SQL*Plus tools.
• Proficient in Performance tuning on Oracle PL/SQL batch Jobs, SQL queries using EXPLAIN PLAN, TKprof, AUTO TRASE and DBMS Profiler/Debug.
• Understanding and applying the various types of Indexes, Constraints and HINTS for best optimization rule.
• Expertise in Extraction Transformation Loading (ETL) using SQL*Loader, Oracle External Table and UTL FILE on OLTP database.
• Actively worked on Advanced SQL and Complex PL/SQL technologies using Collections, Dynamic SQL/REF Cursor, Analytical, REGEXP, Table Partitioning and Materialized Views (Data flow via Remote Database).
• Good knowledge on Oracle Data dictionary, Oracle Supplied DBMS, UTL and HTP packages.
• Experience in jobs scheduling using Oracle DBMS JOB, DBMS SCHEDULER and various TP Tools.
• Strong skills in Oracle Exception Handling, Normalization and Debugging technique with the complex stored procedure as well as PLSQL Wrapper and data obfuscation process.
• Having experience in MySQL to Oracle 9i data migration and Oracle 9i to 11g database upgrade project.
• Hands-on knowledge on Data transmission from MS SQL server to Oracle 10g database using ETL.
• Hand on experience in oracle web development using Mod PLSQL with Apache Tomcat Web server.
• Exposure in Oracle architecture, Database Administration by creating Schema, Directory, Table space, Roles and Export &Import the data dump.
• Exposure in Personal Insurance, finance and enterprise resource planning domain.
• Expertise in full Software development life cycle (SDLC) from the analysis, design, coding and implementation with timely deliverable.
• Expertise in Reverse Engineering, Data Modeling, Data Analysis, Data Masking, gathering business requirements and Release Managements.
• Having 5 years of experience in Informatica PowerCenter 8.6.1 development by creating workflows, mappings using various Transformation technique.
• Experience in data warehousing concept by creating fact tables and Dimensional modeling using Star and snowflake Schema.
• Good knowledge in Slowly Changing Dimensional Types (1/2/3) and workflow performance tunings.
• Hands-on experience in Report designer using Pentaho BI Tools and Oracle Report 6i.
• Excellent planning, problem solving, decision making, verbal & non-verbal communication and Interpersonal skills.Experience in Estimation, review process, status reports, matrix and project co-ordination
• Well versed in documentation on HLD & LLD, Integration Test, defect tracking and Implementation Plan.

TECHNICAL SKILLS

RDBMS: Oracle9i/10g/11g, MS SQL Server, MySQL.

Programming Languages: PL/SQL, Core Jave, Pro*C, UNIX Shell and Perl Scripting.

Front-end: PL/SQL Web Tool Kit (Mod PLSQL), Oracle Reports & Form 6i, HTML, Java Script.

Data processing Tools: Toad for Oracle, SQL Developer, SQL Navigator, SQL*Plus

ETL Tools: Informatica Power Center 8.x, Pentaho Report Designer.

Job Scheduler: PowerCenter Workflow Monitor, Autosys Job Scheduler, ESP.

Version Control Management: SVN, Visual Source Safe (VSS), PVCS, RTC.

Operating System: Windows Series, MS-Dos, UNIX, IBM AIX 4.3, Sun Solaris 2.6.

PROFESSIONAL EXPERIENCE

Confidential, Portsmouth, NH

Sr Oracle PL/SQL Developer

Responsibilities:

• Working as a Senior Oracle Developer and Leading with 2 onsite and 4 offshore members.
• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the business requirements and convert to Function Specification within the schedule.
• Developed various Oracle PL/SQL programming with stored procedures, packages, functions, triggers and other advance technologies.
• Worked on LIST, HASH Table Partitioning, STATS Gathering, Table Analysis and various Oracle Indexes.
• Developed complex ETL workflows using Informatica PowerCenter to maintain the Historical payee compensation records from various channels.
• Building Complex Oracle stored procedure with major business process.
• Created GLOBAL TEMPORARY TABLES to handing multilevel data staging operation.
• Worked on Dynamic SQL by using EXECUTE IMMEDIATE and DBMS SQL.
• Created TYPES, Collection and PL/SQL Tables for major batch process.
• Efficiently working with Perl Scripting program for Extraction, Loading and file managements.
• Extensively worked on Oracle Query Optimization, performances tuning using EXPLAIN PLAN, DBMS PROFILER and re-engineering the existing process with highly efficient and robust.
• Implemented various Oracle 11g features and created various Oracle Packages with new utilities.
• Provide supports, root cause identification for any Production issue during warranty period after post implementation, Conduct walk through meeting and guiding I/T support.
• Proficiently worked with Logical, conceptual and physical data models also created various dimension for warehousing data process.
• Developed various Complex ETL jobs using Informatica PowerCenter and designed workflows, mapping using various transformation and invoked SCD types as well.
• Frequently working with database administrator to perform DDL, database configuration setup as required.
• Involved all the phases in SDLC and good experience in agile methodologies for application developments.
• Direct and regular communication with Business partner for gathering the requirements and providing the existing app functionality by understanding the code logic (more 100 thousand LOC on each channel package).
• Hands-on experience on Release management from Production and non-prod deployments.
• Conducted project meeting and Weekly status meeting with Development Team and Business Partner.
• Have been the development point of contact for all Oracle enhancements and maintenance projects.
• Involved High Level trouble shoots in Share point and Microstrategy environments.
• Involved in Unit Testing and Integration Testing for all major and minor enhancements.

Confidential, Simsbury, CT

Sr. Oracle PL/SQL Developer

Responsibilities:

• Oracle PL/SQL Developer and Team Lead for the team of 4 people in offshore.
• Involved for gathering business requirements, performed gap analysis and preparing the design document and converting HLD to LLD, Effort Estimation and Resource allocation phase.
• Involved in the transition from different vendor and educating the team members.
• Developed various Web user interface using Oracle MOD PLSQL (HTP and HTTP packages) and Apache Tomcat web service.
• Developed various Java scripts for Front end UI validation.
• Created database objects like packages, procedures, functions, triggers, tables, views, materialized View and synonyms, Directory and Various type of Indexes.
• Extensively worked on Oracle Performing tuning using EXPLAIN PLAN and TKPROF for tuning the complex SQL and validating the new SQL and PL/SQL code changes before and after implementation.
• Worked with Bulk Collects, FORALL and PL/SQL Tables to improve the performance of multi-row queries by reducing the context switching.
• Developed and maintained Oracle Table Partitioning and Partitioning Indexes.
• Efficiently worked on Database migration from Oracle 9i to Oracle 11g database.
• Created various Extraction transformation loading (ETL) jobs using SQL*LOADER and Informatica PowerCenter to process Flat files to RDBMS and database tables to Flat file Feeds.
• Worked on various Automation process and batch jobs using UNIX shell scripting.
• Worked on data modeling and prepared the Entity Relationship diagram for various enhancements.
• Created Star schema, snowflake schema with multi-dimensional on OLAP.
• Data profiling to assess compatibility to the business rules, define rules to handle exceptions
• Involved in QA and production code release and performed release management activities.
• Performed integration and functional test.

Confidential

Sr. Oracle Consultant

Responsibilities:

• Worked as an Oracle PL/SQL Developer and Lead for the team of 5 members in offshore.
• Analyzed business requirements and coordinated with the business analyst to develop forms, reports and process that confirm to the enterprise standards while maintaining consistency across all Modules in the systems.
• Knowledge on Enterprise resource planning from Industrial standard module like, HR, AP, AR, Sales Order, Purchase Order, Material management and General Ledger.
• Developed various procedures, packages, functions, trigger, tables, views and Materialized views.
• Worked on complex views and SQL reports using REGEXP, Analytical function and standard Oracle pre-defined functions.
• Created advance PL/SQL program using Nested Tables, Records, SYS REF Cursors, DBMS PIPELINE, BULK COLLECT, FORALL, DBMS XML and various features.
• Developed many batch process and complex reports for Sales, purchase, Invoice, material management, Financial and Bank reconciliation statements.
• Created various automation tools using Oracle PL/SQL, materialized view log and batch script.
• Extensively worked on SQL performance tuning and table stats gathering.
• Involved for Oracle database migration from Oracle 9i to Oracle 10g version.
• Involved data migration through ETL from MS SQL server to Oracle 10g.
• Developed various graphical reports using Pentaho BI reporting tools.
• Worked on customizing the Pentaho report setup with existing java application and managing Admin role.
• Hand-on experience in DBA activities for Database Upgrade, imp & exp schema, Multilingual setup, Tablespace maintenance and minor troubleshoot.
• Creating Design Document Preparation, Unit Test Case Preparation, and Object level Unit Tracker Preparation. Requirement Traceability Matrix Preparation, Reports, Process and Window as part of a core development team, cleaned up existing code, fixed problems and achieved in making the system production ready in remarkably short time.
• Provided Development, supporting, maintenance, Requirement gathering and Work allocation.

Confidential, Mumbai, MH

Assistant Manager - Oracle Developer

Responsibilities:

• Analyzed business requirements and coordinated with the business analyst and end user to develop and maintaining consistency across all applications and systems.
• DevelopedOraclePL/SQLcode based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Developed and modifiedOraclePL/SQLcodes like stored Procedures, Functions, Triggers etc based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• CreatedSQL*Loader control files for moving the data from Flat Files to staging area tables.
• UsedPL/SQLTables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process andOracleObjects including Collections, Types and creating objects.
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• Used batch scripts to loop from database to database, to perform system-wide functions.
• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.
• Involved primary responsible for the HRMS and Payroll system to ensure the problem free for end users.
• Involved for data migration from MySQL to Oracle 9i.
• Efficiently working with performance tuning using oracle utilities.
• Hands-on experience in Oracle Forms to clone the un-editable existing products.
• Review of code changes, test procedure, test plans and other deliverables.

Confidential

Oracle Developer

Responsibilities:

• Worked as a programmer and effectively created Oracle PL/SQL programming using Packages, Procedures, functions, triggers, materialized views and views.
• Extensively worked on Oracle Report 6i & Form 6i and Pro*C for various enhancements.
• Worked on various report migration from Pro*C to oracle 6i.
• Re-write the exiting program with oracle new features such as Dynamic SQL, PL/SQL tables and collections.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Wrote many simple and complex ad-hoc reports usingSQLPlus and SQL Navigator for the business users.
• Processed data Using both implicit cursors and explicit cursors and their attributes.
• Implemented complex SQLs using joins, sub queries and correlated sub queries.
• Prepare Unit test Cases based on Functional Requirements.Create templates for status reports, test summary and defect reports.