EXPERIENCE SUMMARY

• 7 years of extensive experience in the complete Software Development Life Cycle SDLC covering Requirements Management, System Analysis, Architecture and Design, Development, Testing and Deployment of business applications.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace and TOAD. Good knowledge of key Oracle performance-related features, such as cost-based optimizer, execution plans, hints, indexes, clusters and partitioning.
• Hands on experience in writing, maintaining, testing and debugging code in applicable programming languages
• Transferred data using FTP File Transfer Protocol and storing the back-ups of data using SCP Secured Copy .
• Prepared Technical design document, Use cases, Test cases and User manuals for various projects and good at Bug fixing, Code reviews, and Unit System testing
• Created Materialized Views to calculate and store summary data beforehand, dramatically speeding up 'aggregate' queries
• Experience on Oracle backups, generally through Export Import utilities, Full, User, and Table
• Comprehensive knowledge of Relational Database Management Systems RDBMS and relational and normalized databases
• Experienced in ETL techniques and Analysis and Reporting including hand on experience with the Reporting tools such as Business objects, Crystal Reports and SQL Server Reporting Services SSRS
• Expertise in handling errors using Exceptions
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Varrays, Nested tables and Dynamic SQL.
• Extensively used package like DBMS STATS, UTL FILE,DBMS SCHEDULER and UTL SMTP
• Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table
• Strong knowledge in Oracle utilities like SQL Loader, Export/Import and data pump utilities like EXPDP/IMPDP
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing
• Highly self-motivated, strong software background and ability to take challenges.
• Strong analytical and problem-solving skills and ability to handle pressure and work in a dynamic, team-oriented environment.
• ComprehensiveExperience in various types of oracle technology based projects in multi-tierenvironment for sectors like Banking, Insurance and Manufacturing

TECHNICAL SKILLS:

Oracle Certified Professional

PROFESSIONAL EXPERIENCE

Confidential

Title: Oracle PL/SQL Developer

Confidential having presence in more than 16 countries. It manufactures and sells books, magazines, newspapers, novels etc. It has enterprise wise SAP data warehouse system and Business Objects, for reporting information to more than 3000 internal and external users. Currently company is in phase of upgrading Business object to XI R2 from its prior version.

Responsibilities:

• Designed the process flow diagrams using MS Visio and power point presentation for user demo
• Developed ER Diagrams for merchant tablesand products section for the merchants
• Used UTL FILE package to check if the flat file existed before the SQLLDR script was executed, and also to check the log file to find the number of bad row inserts
• Fine tuned procedures for maximum efficiency in various schemas across databases using Oracle Hints, execution plan
• Created control files and load data using SQL Loader from external flat files to Oracle Server.
• Used Explain Plan, SQL Trace and TKPROF to tune SQL Queries.
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
• Used Migration Tool / Import Wizard to migrate the Universes, BO Reports, Webi Reports and Users from BO E 6.5.1 to BO XIR2 and also resolved the Issues that resulted from the Migration.
• Wrote complex SQL queries, Sub queries and nested loops for faster data retrieval
• Created Classes, Objects and also tested them to ensure the accuracy of the data model.
• Migrated multiple Clients from Solaris, Windows, and Linux to different platforms with Oracle 10g, 9i, 11g
• Plan, document and implement configuration of Oracle 10g and 11g RAC databases to support document and information storage for DOD client.
• Created List of Values in the Universe Dimension Objects for specific report requirements.
• Made use of Subquery-Factoring WITH clause to make complex SQL statements simple and make them more efficient
• Resolved loops in the Universe by creating Aliases and Contexts.
• Implemented ETL routine for merchant boarding from external Sales Agent using VB and Oracle procedures.
• Involved in data analysis for the boarded merchants to make sure it adheres to business standards.
• Used TOAD SQL Developer for debugging application.
• Performed data cleansing using MS Excel and Oracle procedures and data mapping from source to target tables.
• Provided timely Production Support by quickly analyzing the root cause and by providing alternatives to resolve issues
• Finished Unit testing and Integration testing in two testing environments 83 and 239 servers after every change.
• Maintained the source code using Clear Case.

Environment: Oracle 11g/10g, TOAD, HTML , LINUX ,PL/SQL Developer-5.1, Autosys, SOA, Informatica, Putty

Confidential

Title: Oracle PL/SQL Developer

Confidential is diversified financial services company providing banking, insurance, investments, mortgage and consumer finance through almost 6,000 stores, the internet and other distribution channels across North America and internationally. This project was for development of an application to help provide the online corporate banking solutions. This included Cash Management, Trade Finance and Lock box.

Responsibilities:

• Gathering business requirements
• Created PL/SQL program units to include DML, DDL statements using dynamic SQL
• Worked to load OLTP data into the Staging Area and Data Warehouse using transformation
• Creating database objects like tables, synonyms, sequences and views
• Experience with merging data files coming from the customer into the existing data warehouse
• Created, edited procedures and functions to suite the improved business requirements
• Created records and nested tables in the procedures for handling of data
• Used export/ import and expdp/impdp database utilities for data transfer
• Used crystal reports to generate reports.
• Extracting data from the Customer Interaction Center and creating a ',' separated file flat file by writing SQL queries
• Coded complex SQL queries to retrieve data from the database depending on the need
• Participated in developing login system using Java and HTML.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Performed Unit Testing on the scripts and ensured all the exceptions are handled according to the business logic
• Creating and working with GTT Global Temporary Table
• Used exception handling methods along with pragma exception init in order to associate our own created exception names
• Made use of Sub query-Factoring WITH clause to make complex SQL statements simple and make them more efficient
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Performed exception handling for the procedures created
• Created indexes for faster retrieval and improved query performance
• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database performance
• Supportedthe development, test and the production databases
• Used SQL plus and TOAD to develop database applications
• Documentation of the technical work done

Environment: Oracle 10g, Windows, PL/SQL, SQL Loader, HTML , Shell Scripting

Confidential

Title: Senior Oracle PL/SQL Developer

Confidential a normalized view of client account data model that can hold information persisted in various legacy reference data repositories. Separate the globally known information about a client from the JPMC-specific information. Demonstrate ability to look up the various Account s that a specific Client is associated with and the specific role s it plays within each. Support for managing client-to-client relationship. We are Merging Heritage JPM system with Heritage Bear world and Integrating 600 client and account system.

Responsibilities:

• Designed and developed database tables and loaded into new target Databases
• Developed Packages, SQL Scripts and Database Triggers to populate the historic data in the tables
• Used SQL Loader and external tables for moving the data from flat files to staging area tables.
• Used PL/SQL tables, PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database trigger
• Extensive use of PL/SQL Collections and Records,Partition methods for oracle tables and indexes
• As-Is system analysis with special emphasis on system integration and data migration needs.
• Implemented Join conditions, group by functions, correlated subqueries, nested subqueries.
• Designed the overall architecture for the system integration and data migration based on functional requirement.
• Arranged the review for the solution design to ensure it conforms to the Enterprise Architecture.
• Reviewed the developed code to check for non-compliance to the technical specification and the coding standards and suggesting improvements to the same.
• Worked with Bulk Collect Bulk Bind to improve the retrieval of multi row.
• Organized and managed routine jobs using packages like DBMS SCHEDULER to schedule tasks.
• Reviewedthe performance testing results and providing inputs to the developers on how to modify the code to improve the performance.
• Provided the technical inputs to the DBAs and Data Modelers on the release.
• Fulfilledaforementioned responsibilities and technical assessment on the developed application in time to time.
• Fixed the defects/bugs uncovered during the development.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS.
• Attained daily client meeting and providing reports to the project manager on the development quality.
• Automated the scripts to monitor the system performance on a daily basis
• Optimized the Oracle PL/SQL queries by Performance Tuning.

Environment: Unix, Oracle 9i, Oracle PL/SQL, Pro C, Micro-Strategy, IMS Partner, Data-View and Teletype

Confidential

Title: Senior Developer

Description: Confidential provides consolidated client account information from over 80 different financial institutions including clearing firms, mutual fund firms and insurance companies. The application is a fully integrated web-based environment. The system also provides reps with daily trade information, transaction information, internal and client approved reports.

Responsibilities:

• Interacted with Business to understand business requirements and define project scope.
• Prepared project plan, estimate efforts
• Processed Onsite/Offshore coordination.
• Made use of Sub query-Factoring WITH clause to make complex SQL statements simple and make them more efficient
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT
• Involved in the analysis of Physical Data modelfor ETL mapping and processedflow diagrams to develop Data mart design.
• Developed programs using Oracle PL/SQLprocedures, packages and SQL queries.
• Created B-tree and Bitmapindexes.
• Loaded data by using SQL Loader and import/export utilities.
• Preparedunit test cases and test script documents for end-to-end testing.
• Documented program specifications and communicating requirements to offshore team, analyzing design documents, design and code reviews.
• Involved in code walkthrough, system testing and regression testing.
• Implemented table partitioning and sub-partitioning to improve performance and data management
• Tuned of SQL queries.
• Reported different levels of management on project status weekly.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures
• Conductedaudits and reviews to ensure compliance with specific quality guidelines.
• Integrated all components, test and deploy in production.
• Providedpostproduction support.
• Documented the whole process flow, PL/SQL packages, locations and descriptions, and possible error messages

Environment: Windows XP, Oracle 9i, Oracle PL/SQL, Visual Basic

Confidential

Title: Oracle PL/SQL Developer

Description: Confidential is a world leader in convenient snacks, foods and beverages with revenues of more than 60 billion and over 285,000 employees. The project involved the creation of the Database, wherein the data existed mostly in the form of Excel Sheets and text files. The job involved collecting of the data from different sources and then transformation of the data to be loaded into the Oracle Database, which would be used for the creation of the reports for analysis. This project effectively handled the information about the customers all over the world and consumable products with an effective reporting system

Responsibilities:

• Created data warehouse objects Fact tables, dimension tables, table partitions, sub-partitions, normal and bitmap indexes, summary tables, materialized views, stored packages, functions and procedures with parallel queries, making indexes unusable and rebuilding local indexes for partition exchange loading PEL .
• Worked in Rapid Application Development through APEX to develop end to end web application development using Web 2.0 AJAX
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Created PL/SQL based ETL process to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Create SDLC Documentation.
• Used SQL plus and TOAD to develop database applications
• Used various Shell Scripts and Scheduled jobs on Crontab in UNIX environment on a routine basis
• Prepared shell scripts for ETL to run in batch.
• Createddatabase objects and modified PL/SQL packages, functions, and procedures.
• Extracted data into Oracle table using SQL Loader.
• Used exception handling methods along with pragma exception init in order to associate our own created exception names
• Created B-tree and Bitmapindexes.
• Wrote Complex SQL script, Analytical Function.
• Finished UNIX shell scripting and used job scheduling tool like Cron job.
• Improved query performance by query optimization - tracing the query execution plan explain plan .
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.

Environment: Oracle Application Server 11g, TOAD, UNIX