SUMMARY

• 9+ years of Experience working wif 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 teh 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 noledge 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 teh 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 teh data, defining data source and subtotals for teh 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 teh management, development.
• Team player wif 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, Bethpage, NY

Senior Oracle PL/SQL Developer

Responsibilities:

• Strong experience wif 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 teh application.
• Understanding teh requirements and carrying out impact analysis.
• Coded complex SQL queries to retrieve data from teh database depending on teh need.
• Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.
• Created database objects liketables, views, indexesandsequences.
• Responsible for teh 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 wif 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 wif 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 teh data needs for teh customized reports. Mapping teh data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.
• Coded complex SQL queries to retrieve data from teh database depending on teh 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 wif complex logic using pre-defined sequences.
• Developed other database objects such as indexes and views when needed.
• Coordinate wif teh front-end design team to provide them wif teh necessary stored procedures, packages and teh necessary data.
• Provided daily support for multi-task development, and worked on DEV/QA testing and interacting job between DEV/ QA/ PROD environment. Work wif QA team to debug/fix issues.
• Involved in Unit Testing Stored Procedures and Functions.
• Worked wif 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, Austin, TX

Oracle PL/SQL Developer

Responsibilities:

• Responsible in requirements gathering, analysis, design and development of any enhancements in teh application.
• Responsible for analysis, design, development, and testing of database forFRTBimplementation.
• Coded complex SQL queries to retrieve data from teh database depending on teh 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 wif XML to do data extracts, data retrieval and data storage.
• Creating and working wif GTT (Global Temporary Table).
• Created database objects liketables, views, synonyms, indexesandsequences.
• Analyzing teh data needs for teh customized reports. Mapping teh 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 teh 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 teh 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

Oracle Developer

Responsibilities:

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

Confidential, Plano, TX

Oracle PL/SQL Developer

Responsibilities:

• Developed various PL/SQL objects likeprocedures, functions, packages, Cursors, pipeline functionsandtriggersin accordance wif teh business needs.
• Created database objects liketables, views, synonyms, indexes,views, materialized views andsequences.
• Involved in interacting wif theend-user (client)to gather business requirements and modeling thebusiness requirements.
• Define and represent entities, functions and flows between teh entities.
• Participated in analyzing teh requirements for thelogical and physicaldesign of teh 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 teh business analyst to perform QA testing using SQL Loader utility andData pumputility.
• Experience wif merging data files coming from teh customer into teh existing data warehouse.
• Performed exception handling for data dat did not conform to teh required format.
• Implemented purging techniques on teh data which is not required by teh clients.
• Responsible for making teh merged data in turn available to other clients.
• ImplementedPL/SQL scriptsin accordance wif teh 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.