SUMMARY

• 8+ years of Experience working with Oracle 11g/10g/9i, Toad, SQL*plus, SQL * developer, SQL*loader, MS SQL Server and Business Intelligence products.
• Experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Support.
• Experienced in writing SQL statements, PL/SQL code for the database objects such as tables, views, indexes, sequences, procedures, functions, packages, and triggers.
• Perform XML operations for data extracts, data retrieval and data storage.
• Hands on experience in writing, maintaining, testing and debugging code in applicable programming languages.
• Worked extensively on Erwin and ER Studio in bothOLAP and OLTPapplications.
• Practical understanding of theData modeling(Dimensional & Relational)concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• 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,T-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.
• Expert in Developing SSIS (SQL Server Integration Services) Packages Extracting, Transforming and Loading (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Experience in all major versions of technology stack including Database, Forms, Reports, PL/SQL.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS (SQL Server Reporting Services) 2005/2008/2008 R2.
• Comprehensive Experience in various types of oracle technology based projects in multi-tier environment for sectors like Banking, Insurance and Manufacturing.
• Excellent writing, presentation, documentation and communication skills for the management, development.
• Team player with proven ability to introduce change and move an organization towards and innovative Technology.
• Experience in Data Warehousing and ETL usingInformatica Power Center.

TECHNICAL SKILLS:

Databases: Oracle 11g, 10g, 9i, MS SQL Server

Languages: SQL, PL/SQL, T-SQL, Java, HTML,C#,.NET

Operating Systems: Windows, Linux, Unix, Shell

DB Dev. Tools: TOAD, SQL Developer, SQL*Plus, Informatica Power Center, SQL Loader, Warehouse Builder, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Oracle PL/SQL Developer

Responsibilities:

• Responsible in requirements gathering, analysis, design and development of any enhancements in the application.
• Responsible for analysis, design, development, and testing of database forFRTBimplementation.
• Coded complex SQL queries to retrieve data from the database depending on the need.
• Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.
• Perform XML operations for data extracts, data retrieval and data storage.
• Loading of data from Moody’s using SQL* Loader.
• Working with XML to do data extracts, data retrieval and data storage.
• Creating and working with GTT (Global Temporary Table).
• Created database objects liketables, views, synonyms, indexesandsequences.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.
• Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• 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.
• Participated in Functional Testing and Unit Testing.
• Wrote complex queries and sub queries to do analysis work and generate reports to validate the results produced.
• Extensively worked on PL/SQL Error/Exception handling.
• Performed Oracle Performance tuning using SQL Trace and Explain Plan.

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

Confidential, New York

Senior Oracle PL/SQL Developer

Responsibilities:

• Strong experience with Very Large Databases, over 8terabytes.
• Database developing using Oracle 11g and UNIX shell script.
• Responsible in requirements gathering, analysis, design and development of any enhancements in the application.
• Understanding the requirements and carrying out impact analysis.
• Coded complex SQL queries to retrieve data from the database depending on the need.
• Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.
• Created database objects liketables, views, indexesandsequences.
• Responsible for the design, construction, unit test, code review and bug fix.
• Participated in Functional Testing and Unit Testing.
• Creating data mapping documents, technical documents as well as QA/production release notes.
• Use and maintain all version of codes in PVCS.
• Wrote complex functions and stored procedures to populate time dimension values with complex logic.

Environment: Oracle 11g, TOAD for Oracle, Netezza, Aginity Workbench for Netezza, Putty, UNIX, PVCS Version Manager, SBM, MS Communicator

Confidential, New York, NY

Oracle PL/SQL Developer

Responsibilities:

• Database developing using Oracle 11g and UNIX shell script.
• Involved in interacting with theend-user (client)to gather business requirements and modeling thebusiness requirements.
• Created mapping document between database objects and website objects for both front-end and back-end team to use.
• Created database objects liketables, views, synonyms, indexesandsequences.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.
• Coded complex SQL queries to retrieve data from the database depending on the need.
• Created Cursors and Ref cursors to retrieve data needed.
• Built and maintained sequences.
• Experience in developing various kinds oftriggersand used sequences to generate values forsurrogate keysin data warehouse tables.
• Wrote complex functions to output group ids with complex logic using pre-defined sequences.
• Developed other database objects such as indexes and views when needed.
• Coordinate with the front-end design team to provide them with the necessary stored procedures, packages and the necessary data.
• Provided daily support for multi-task development, and worked on DEV/QA testing and interacting job between DEV/ QA/ PROD environment. Work with QA team to debug/fix issues.
• Involved in Unit Testing Stored Procedures and Functions.
• Worked with front-end team to handle QA move & Prod move, create moving sheets to make sure FE and BE are in sync.
• Perform database tuning, make complex SQL statements simple and easy to read, and make queries more efficient.
• Worked on PL/SQL Error/Exception handling.
• Wrote shell scripts to load data (SQLLDR), run spool jobs, retrieve data from database and create daily jobs to automatically updating tables and views.
• Created technical Documents including task processing document updating and test case preparing.

Environment: Oracle 11g, TOAD, Oracle Navigator, Putty, PL-SQL, UNIX/Linux, SQL Loader, MS Communicator

Confidential, Plano, TX

OraclePL/SQL Developer

Responsibilities:

• Developed various PL/SQL objects likeprocedures, functions, packages, Cursors, pipeline functionsandtriggersin accordance with the business needs.
• Created database objects liketables, views, synonyms, indexes,views, materialized views andsequences.
• Involved in interacting with theend-user (client)to gather business requirements and modeling thebusiness requirements.
• Define and represent entities, functions and flows between the entities.
• Participated in analyzing the requirements for thelogical and physicaldesign of the database.
• Knowledge ofNormalization, Data Warehousing, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Loading data into test warehouse for the business analyst to perform QA testing using SQL Loader utility andData pumputility.
• Experience with merging data files coming from the customer into the existing data warehouse.
• Performed exception handling for data that did not conform to the required format.
• Implemented purging techniques on the data which is not required by the clients.
• Responsible for making the merged data in turn available to other clients.
• ImplementedPL/SQL scriptsin accordance with the necessary Business rules and procedures.
• Presented several technical presentations on Oracle database operation.
• Scheduled html reports usingUTL SMTP,UTL MAILand DBMS SCHEDULER.
• Optimized SQL statements and PL/SQL blocks byusingOracle Hints, Explain plans, profiling,collecting statisticsandTrace sessionsfor Cost based Optimization.

Environment: Oracle 10g, PL/SQL,Oracle FMW, xml,.Net, Visio, UNIX Shell scripts, SVN, Toad, SQL Developer, HP Quality Center, SQL *Loader, Import Export.

Confidential

Oracle Developer

Responsibilities:

• Responsible in requirements gathering, analysis, design and development of any enhancements in the application.
• Extracted data from oracle database and spreadsheets, staged into a single place, and applied business logic to load them in the central oracle database.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.
• Experienced in migrating and loading data from different sources to SQL server databases and performing all types of transformations during the process using SSIS Control-Flow and Data-Flow.
• Involved in maintaining and updating the procedure for ETL process.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Experienced in creating various types of reports such as complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SSRS based on client.
• Developed complex mappings in Informatica to load the data from various sources.
• Created and maintained database objects like tables, views, materialized views, and synonyms to meet the business requirements.
• Executed upload and load procedures to check the data feed is correctly getting loaded in to the tables.
• Understanding the business logic to modify existing SQL Code and Performance Tuning, indexing, table partitioning.
• Modification of the existing forms and reports and registering those in Application.
• Direct interaction with users and helped in the development of functional specifications.
• Written technical specifications for all the procedures developed in the module. Maintained log files during analysis and subsequently report any performance defects.
• Coordinate with the front-end design team to provide them with the necessary stored procedures, packages and the necessary data.
• Provided knowledge transfer to other team members about the new technology and allocation of tasks to the team.

Environment: PL/SQL, TOAD, SQL*Loader, Oracle 11g, UNIX,XML, Informatica Power Center,Erwin, SQL* Plus, and Oracle Forms, Microsoft SQL SERVER, SSIS,SSRS