SUMMARY

• Over 8+ years of professional experience in IT industry as Oracle SQL/PLSQL developer, Analysis, Design and Modeling.Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually
• Strong knowledge on oracle architecture and data base design.
• Excellent skills in designing and development of applications using Oracle, SQL,PL/SQL Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD in many development projects.
• Experienced in all phases of Software Development Life Cycle (SDLC).
• Excellent SQL skills, experience writing complex queries and working with database objectslike tables, views, sequences, synonyms.
• Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
• Experience in Bulk Data loading using Oracle utilities namely SQL* Loader and External Tables.
• Expertise inQuery Performance Tuningby Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collectfeature,Materialized Viewsand Troubleshooting Oracle database issues.
• Working Knowledge on Unix and Windows..
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.
• Excellent experience in implementing Change Data Capture (CDC), Slowly Changing Dimension (SCD) type 1, type 2, type 3 using ODI.
• Implemented the Change Data Capture (CDC) feature of ODI to minimize the data load times.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Hands on experience on dealing with ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
• Good knowledge of Data modeling using ETL tools, LAP tools, Star Schema, Snowflake Schema, and Entity - Relationship Diagrams.
• Developing reports using Informatica ETL tool.
• Created Database constraints like Primary key and foreign key using RDBMS concepts.
• In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL,T-SQL using database tools like Toad, SQL Navigator.
• Worked on Version Control Software.
• Expertise in Mathematical and Modeling and Numerical Analysis.
• Excellent planning, analytical, written communication and Interpersonal skills.

TECHNICAL SKILLS

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake ModelingFACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin

Front-end tools: TOAD, SQL Developer, PLSQL Developer.

Databases: Oracle 11g/10g/9i/8i.

GUI: Sales Force, .net and Java.

ETL & BI Tools: Informatica, ETL, ODI. Basic knowledge of SAS

Programming: SQL, PL/SQL, T-SQL, UNIX Scripting.

Operating Systems: Windows XP/2003/2000/NT/98/95, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Rensselaer, NY

Oracle PL/SQL Developer

Responsibilities:

• Participated in requirement and design sessions.
• Participated in database design within an existing Oracle database structure.
• Helping Application Development team in preparing technical designs and perform construction activities.
• Work with developers to design and write complex packages to support their needs.
• Perform team lead tasks when necessary.
• Wrote complex functions and procedures for new packages and update existing packages in an established Oracle database using pre-defined business rules.
• Work with Database Administrators to implement design changes and new packages.
• Performance testing and rewriting of production code/SQL statements & procedures performing badly, identified by Database Administrators.
• Provide database support to developers who write code using WCF, WPF and .Net.
• Support the application through the testing and implementation phases, including product test, stress/load test etc.
• Working with Oracle, with a thorough understanding of the architecture and processes of an Oracle server, including Oracle 10g or higher.
• Writing complex packages, SQL, PL/SQL, stored procedures, functions, and triggers.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus, SQL Developer, PL/SQL Developer and TOAD.
• Created Database constraints like Primary key and foreign key using RDBMS concepts.
• Converted VB code into PL/SQL packages and discuss with the .net developers to change according to their requirement.
• Data fixes for all the existing functionalities like (INV, INT, FSI, FSS, FAR and FAD) Stages. Preparing Analysis documents for data fixes.
• Preparing Analysis and testing documents for testers. Functionality testing.
• Experience monitoring and tuning the general performance of the Oracle database.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Worked on Global temporary table to generate the data dynamically for reporting purpose.
• Experience Converting VB into PL/SQL packages.
• Experience in database designs based upon identified business rules and using Oracle 10g/11g or higher.
• Experience working in a development and/or production database environment for a large scale, complex application involving on-line and batch environments.
• Experience in performing knowledge transfers to client staff of Oracle database administrator techniques supporting the development of database structure for the new architecture.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model and physical model.
• Experience Building and Maintaining Oracle Tables.
• Writing SQL*Loader and External table scripts for the DDL's. Fixing bugs in .txt,.csv and .dmo files.
• Implemented a variety of ODIinterfaces, packages, procedures, scenarios for extracting and loading data into target sources
• Developing Slowly Changing Dimensions mappings using Change Data capture (CDC) Type1, Type2 and Type3 as a part of Performance Tuning in ODI.
• Configuring the ODI Master and Work repositories, ODI models, and ODI Change Data Capture (CDC) mechanism.

Environment: ODI 11.1.1, Oracle 11g r2, TOAD, TFS, Quality Center, UNIX, SSH Putty, SQL Developer, TOAD, Citrix.

Confidential, Pittsburgh, PA

Oracle PL/SQL Developer

Responsibilities:

• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Writing Technical design documentation.
• SQL tuning of queries.
• Complex queries like inline views and Sub queries.
• Initializing TIBCO jobs by using Data Base.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus, SQL Developer, PL/SQL Developer and TOAD.
• Defined database requirements and designed data model
• Created Forced Views.
• Extensively used Dynamic SQL for calling procedures
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
• Worked on performance tuning and used Explain Plan, TKPROF and SQL trace for tuning the queries.
• Writing SQL*Loader scripts for the DDL's. Fixing bugs in .txt,.csv and .dmo files.
• Running explain plan for tuning the SQL queries.
• Import and export of data from Xl sheets.
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
• Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI and CDC.
• Developing Slowly Changing Dimensions mappings using Change Data capture (CDC) Type1, Type2 and Type3 as a part of Performance Tuning in ODI.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.
• Extensively used Apex DATA loader to load data into Sales Force.
• Import /export scripts.
• UAT testing for the one of the functionality for sales force app.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Table Partitioned by creating a table in to smaller level partitions based on date. Usually we do for Saving storage space and Performance issues instead of querying whole big table.
• Implemented a variety of ODIinterfaces, packages, procedures, scenarios for extracting and loading data into target sources

Environment: ODI 11.1.1, Oracle 11g/10g, PL/SQL, SQL Navigator, UNIX, Windows XP, WINCVS, SSH, SQL Developer, PLSQL Developer, TOAD.

Confidential, Roseland, NJ

Oracle PL/SQL Developer

Responsibilities:

• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Writing Technical design documentation.
• SQL tuning of queries.
• Complex queries like inline views and Sub queries
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus, SQL Developer, PL/SQL and TOAD.
• Defined database requirements and designed data model.
• Extracting data from Sql server database to oracle database using Informatica.
• Created Schema Using the XML schema.
• Generated XML using the Procedures, Functions and Packages.
• Extensively used Dynamic SQL for calling procedures
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
• Worked on performance tuning and used Explain Plan, TKPROF and SQL trace for tuning the queries.
• Writing SQL*Loader scripts for the DDL's. Fixing bugs in .txt,.csv and .dmo files.
• Running explain plan for tuning the SQL queries.
• Import and export of data from Xl sheets.
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
• Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
• Implementing Change Data Capture (CDC), Slowly Changing Dimension (SCD) type 1, type 2, type 3 using ODI.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI and CDC
• Building UNIX shell scripts for data migration and batch processing.

Environment: ODI 11.1.1, Oracle 11g/10g, PL/SQL, Oracle Forms 10g, Reports10g, SQL Navigator, UNIX, Windows XP, WINCVS,XMLSpy, SSH, SQL Developer, PLSQL Developer, TOAD.

Confidential, Stamford, CT

Oracle Developer

Responsibilities:

• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• SQL tuning of queries.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus, PL/SQL and TOAD.
• Generated XML using the Procedures, Functions and Packages.
• Running explain plan for tuning the SQL quires.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
• Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
• Worked on performance tuning and used Explain Plan, TKPROF and SQL trace for tuning the queries.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.
• Developing Slowly Changing Dimensions mappings using Change Data capture (CDC) Type1, Type2 and Type3 as a part of Performance Tuning in ODI.
• Configuring the ODI Master and Work repositories, ODI models, and ODI Change Data Capture (CDC) mechanism.
• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI and CDC.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Environment: ODI 11g, Oracle 11g/10g, PL/SQL, SQL Navigator, UNIX, Windows XP,T-SQL, Putty, Serena Team Track, AIX and, WINCVS

Confidential, Phoenix, AZ

Oracle Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Extracting data from Sql server database to oracle database using ODI.
• Worked with multiple sources such as Relational database, Flat files for Extraction, Transforming and Loading data into target tables.
• Used ODI Knowledge Modules to create interfaces to cleanse, Load and transform the Data from Sources to Target.
• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI and CDC.
• Analyse the current data management procedures in practice and suggest ways for automating the process or improving the existing system.
• Developed stored procedures to pull the data from the distributed systems.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Developed and implemented complex data models and logical database designs.
• Involved in unit testing and integrated testing.
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing.
• Defined database requirements and designed data model.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Integrated the mailing system to alert various group on the status of data pulls and data processing.
• Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Involved in importing the production data to work environment through TOAD.
• Involved in handling the changes in compiling scripts according to the database changes.

Environment: ODI 11g, Oracle 10g/11g, UNIX Shell Scripts, PL/SQL, Toad, PL/SQL Developer, SQL Optimizer, Putty.

Confidential, Cincinnati, OH

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Worked as part of the development team, along with the Systems Analysts/Business Analysts.
• Analyzed and fixed the data discrepancies between various systems and identified bad data caused due the data migration from various legacy systems.
• Created PL/SQL Stored Procedures, Functions, Packages, and Triggers; extensively used Cursors, REF cursors, User-defined object types, Records, forms and reports in PL/SQL programming
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance
• Improved performance by creating Unique and Range Indexes based on the cost returned by EXPLAIN PLAN.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers
• Effectively used Triggers to track the user profile updates and to send the messages to downstream systems
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model and physical model.
• Experienced in defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions, and knowledge modules
• Configuring the ODI Master and Work repositories, ODI models, and ODI Change Data Capture (CDC) mechanism.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, db links and privileges

Environment: ODI 10.1.3.5, Oracle 11g/10g/9i, Oracle Forms 10g, Reports10g, PL/SQL, SQL Server, UNIX Shell Scripting, Toad, ER-Win Windows XP,.Net.

Confidential

Oracle Developer

Responsibilities:

• Analyzed business requirements and coordinated with the business analyst to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc based on technical and functional specification documents.
• Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• Used batch scripts to loop from database to database, to perform system-wide functions.
• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.
• Expertise in developing Strategies for Extraction, Transformation and Loading mechanisms using ODI.
• Created Master/Work repositories and developed the ODI mappings for migrating RAW tables into desired targets.
• Customized Knowledge modules LKM, RKM, IKM and JKM.

Environment: ODI 10.1.3.5, Oracle 9i, TOAD, SQL Navigator, Putty, Windows XP.