SUMMARY:

• 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.
• Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database.
• Develop, support and maintenance for the ETL (Extract, Transform and Load) processes using  Informatica PowerCenter.
• 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 using   Informatica 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

PROFESSIONAL EXPERIENCE:

Confidential, Bethpage, NY

Senior Data Warehouse Developer

Responsibilities:

• 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 like tables, views, indexes and sequences.
• 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 the end-user (client) to gather business requirements and modeling the business requirements.
• Created mapping document between database objects and website objects for both front-end and back-end team to use.
• Created database objects like tables, views, synonyms, indexes and sequences.
• 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 of triggers and used sequences to generate values for surrogate keys in 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.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using   Informatica PowerCenter .
• 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 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 the application.
• Responsible for analysis, design, development, and testing of the application.
• 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 like tables, views, synonyms, indexes and sequences.
• 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

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.

Confidential, Plano, TX

Oracle PL/ SQL Developer

Responsibilities: 

• Developed various PL/SQL objects like procedures, functions, packages, Cursors, pipeline functions and triggers in accordance with the business needs.
•  Created database objects like tables, views, synonyms, indexes, views, materialized views and sequences.
•  Involved in interacting with the end-user (client) to gather business requirements and modeling the business requirements.
•  Define and represent entities, functions and flows between the entities.
•  Participated in analyzing the requirements for the logical and physical design of the database.
•  Knowledge of Normalization, Data Warehousing, and data transfer, documentation, preventive maintenance, code review, automation, store procedures etc.
•  Loading data into test warehouse for the business analyst to perform QA testing using SQL Loader utility and Data pump utility.
•  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.
•  Responsible for making the merged data in turn available to other clients.
•  Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
•  Presented several technical presentations on Oracle database operation.
•  Scheduled html reports using UTL SMTP, UTL MAIL and DBMS SCHEDULER.
•  Optimized SQL statements and PL/SQL blocks by using Oracle Hints, Explain plans, profiling, collecting statistics and Trace sessions for 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.