EXPERIENCE SUMMARY

• 7 years experience in IT industry.
• Extensive work experience in Oracle 9i,10g,11g, PL/SQL, TOAD, SQL* PLUS and SQL*Loader, developing back-end modules for multi-tier business applications, both Data Warehousing and OLTP systems, in SQL and PL/SQL.
• Experience in all phases of Software Development Life Cycle(SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Support.
• Experience in building up the Database architecture and models.
• Extensively worked on the ETL mappings, data analysis and documentation of OLAP reports requirements.
• Experience in SQL*loader, UTL_FILE and UNIX Shell scripting.
• Hands on experience in writing, maintaining, testing and debugging code in applicable programming languages.
• Experienced in writing SQL queries and SQL tuning, understanding requirements, writing functional specs, writing test specs and plans.
• Strong development and support knowledge on Oracle, SQL, PL/SQL queries programming and creating objects such as Stored procedures, packages, functions, triggers, tables, and views
• Expertise in Optimizing Database performance, Hints, Indexing, Materialized View, Partitioning, Parallel processing, pipelining, managing locking scenarios for multiple users.
• Comprehensive Experience in various types of oracle technology based projects in multi-tier environment for sectors like Finance, Insurance and Manufacturing.
• Excellent writing, presentation, documentation and communication skills for the management, development.
• Highly self-motivated, strong software background and ability to take challenges.

TECHNICAL SKILLS:

Oracle 8i, 9i, 10g, 11g, ODI

Languages:

C++, Java J2EE, Visual Basic, SQL, PL/SQL, HTML

Operating Systems:

Windows, Linux, Unix, Shell, PERL

DB Dev. Tools:

TOAD, SQL Developer, SQL*Plus, SQL Loader, Warehouse Builder

PROFESSIONAL EXPERIENCE

Client : Confidential,New York Jan 2011-Current
Title : Senior Developer
Project : Risk Management System
Description: Risk Management System helps the bankers to analyze the risk associated with insight into global market. It offers historical or projected financial data to calculate market risk as potential changes in fair values of financial instruments in response to market movements. It also used for scenario analyses to estimate the potential economic loss that could arise from extreme, but plausible, stress events.

• Responsibilities:
• Participated in design discussions with the application architects and suggest design changes for improved database performance.
• Responsible for analysis, design, development, and testing of the application.
• Develop stored packages, procedures, and functions; create tables, views, constraints, foreign keys and indexes.
• Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Worked with users for data analysis and support
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions, Views and Triggers.
• Partitioned tables and indexes for better performance of application.
• Created and modified several views on tables which will be populating the Warehouse system. Also involved in creation on aggregate materialized views on Data Warehousing.
• Wrote complex queries and sub queries to do analysis work and generate reports to validate the results produced.
• Performed Oracle Performance tuning using SQL Trace and EXPLAIN PLAN.

Environment: UNIX, Oracle 11g, OWB, Windows NT, PL/SQL, SQL*PLUS, SQL, SQL*Loader, Toad, Java J2EE.

Client: Confidential,New Jersey Jul 2009-Nov 2010
Position: Oracle Developer
Project : Wealth Management System
Description: Wealth Management System helps large-scale asset manager with businesses well-diversified across regions, capabilities and distribution channels. It offers asset data for multi-asset strategies analysis, including equity, fixed income, currency, hedge fund, real estate, infrastructure and private equity investment capabilities. It also records major, detailed information of private clients, financial intermediaries and institutional investors based on various asset classes.

Responsibilities:

• Responsible for analysis, design, development, and testing of the application.
• Created table definitions, indexes, primary and foreign keys, constraints, triggers, functions, views, procedures and data to Oracle using SQL Developer.
• Analyzed and designed tables based on small and large database transactions.
• Optimized SQL queries tuning by analyzing different query options and indexing strategies.
• Used SQL*Loader utilities to Export and Import Large Volumes of Data in the Excel Sheets into the Tables.
• Created and Modified primary database objects, such as Triggers, Procedures, Functions, Packages and bulk collections using PL/SQL.
• Developed PL/SQL Views and Materialized Views with fast and incremental Refresh Rates using PL/SQL to enhance read operation.
• Involved in performance tuning using HINTS, EXPLAIN PLAN.
• Worked on SQLPLUS and SQLLDR calls from shell scripts and perl script.

Environment: UNIX, Oracle 10g/11g, Windows NT, PL/SQL, SQL*PLUS, SQL, SQL*Loader, Toad, Java J2EE.

Client : Confidential,New Jersey Jan 2008-Jun 2009
Position: Oracle Developer
Project : Claim Processing System
Description: Claim Processing System provides function to support much of the processing and management of customers’ insurance claims. It can handle or support the sharing of information and tracking of communications for business and strategy analysis.

Responsibilities:

• Involved in DESIGNING & CREATING an ETL Framework that works based on a table driven approach.
• Involved in ETL jobs to extract, cleansing, transforming, integrating and loading data.
• Involved in documenting users requirements, technical specifications and Reporting manuals.
• Automated loading and processing of servicer provided Loss Mitigation data that was provided from servicer portal.
• Created various PL/SQL packages, procedures and function.
• Created triggers on database objects to perform automatic updates and insertions in OLTP.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Enhanced performance of large complex SQL queries using explains plan, indexes and hints.

Environment: Windows XP, Oracle 10g, PL/SQL, HTML, Java, Unix, Linux.

Client : Confidential,China Jun 2006-Oct 2007
Title : PL/SQL Developer
Project : Supply Chain Logistics System
Description: The Supply Chain Logistics System concerns on planning and tracking goods deliveries in order to maximize the efficiency and keep inventory at the optimal level. It will ensure that the status of deliveries is up-to-date and visible at all times.

Responsibilities:

• Involved in developing a platform of databases supporting supply chain management, order management, inventory, Data warehousing management system, and purchasing.
• Created DDL scripts, Created database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Created stored database procedures, packages, function, triggers, tables, views, constraints, foreign keys and indexes using Oracle 9i across the application for manipulating data.
• Used ETL to load data into SQL Server database from Oracle database.
• Utilized SQL*Loader to load flat files database tables.
• Used triggers for automatic audit creation for all the major master databases.
• Designed and implemented error checking and correction protocols and programs.

Environment: Oracle 9i, Oracle PL/SQL, SQL*Loader, Java, Unix, Linux.

EDUCATION:

• Bachelors of Management in Management Science