SUMMARY

• 8+ years of IT experience in developing software applications using Oracle 11g/10g/9i and its products in wide range of applications including Manufacturing, Banking, Telecommunication applications and Vehicle Systems.
• Solid experience working on Oracle 11g /10g/9i/8i/8.0/7.x, Developer 2000/6i (Oracle Forms 6i and Reports 6i), PL/SQL, UNIX and Discoverer.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi - tier and client/server architectures.
• Experience in Data modeling, Data warehouse Design, Development and Testing using ETL and Data Migration life cycle using IBM Web Sphere Data Stage 8.x/7.x.
• Experience in ANSI SQL with composite.
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers.
• Used Query tuning techniques for better performance and execution through suitable indexes, primary-foreign key constraints.
• Experience in using SQL TRACE and TKPROF tools for SQL tuning.
• Designed and extensively worked on Project Documentation. Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Used Bulk Binds and Bulk Collect.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Having experience in working with SQL Server Reporting Tools (SSRS) and SQL Server Integration Management (SSIS).
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on the Tables and Stored procedures.
• Designed, structured and optimized using ANSI SQL, transact SQL queries, stored procedures using DDL and DML.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Experienced with SQL performance tuning and optimization using execution plans.
• Improved performance of PL/SQL program units by using Bulk Collect and Bulk Bind (ForAll) features with Collections instead of using cursors and FOR loops, and DBMS PROFILER package and GET TIME in DBMS UTILITY package.
• Experienced in OLTP and OLAP System Study, Analysis and E-R modeling.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2008, DB2, MS ACCESS 2007

Languages: SQL, PL/SQL, C, C++

Tools: TOAD, SQL Developer 3.0, Oracle Enterprise Manager 10g/11g, SQL*Plus, SQL*Loader, Oracle Forms and Reports 10g/9i/6i, Oracle Framework, Oracle EBS, MS Office 2007, Open Office 3.3

Internet Technology: HTML 5.0, JavaScript, XML, PHP 5.0, CSS 3, DHTML, .NET

Scripting: Unix Shell Scripting, Java Script, Perl

Operating Systems: HP-UX 11.0,UNIX, Windows 95/98/2000/NT/XP/Vista and AIX

ETL Tools: Informatica, DataStage 8, BOBJ Data Integrator 4.0

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Oracle Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and developed various Design documents according to the user requirements.
• Involved in Gen10 automation and reporting processes. Involved highly in the production support and development of Gen10 applications such as Remote Link.
• Preparing PL/SQL Packages, Procedures, Functions, Triggers and Views
• Performing Oracle SQL Performance Tuning on the Developed Code.
• Prepared and executed unit test cases
• Performing the code fixes for the developed code to meet the requirement
• Implemented multiple Change Requests in GC and prepared reports as and when required
• Worked in Performance and monitoring of Gen10 units.
• Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Worked with CLOB and LOB data types to load large XML documents into database tables.
• Developed UNIX Korn shell scripts to process file feeds.
• Used IBM Cognos Report studio to build complex reports using SQL Queries and scheduled them on a daily basis.
• Used Tableau for reporting and preparing dashboards for business visualization.
• Actively Involved in Integration and Deployment in Production Environment.
• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using ERWin and identified key features for scalability of the application.
• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• UsedIBMWebsphereData Stage as an ETL tool to extract data from sources and flat files and loaded to target tables.
• Responsible for developing XML documents to generate SQL dynamically for all the business roles.
• Involved in Performance Tuning of various custom PL/SQL reports and PL/SQL packages.
• Used UNIX Crontab for Job scheduling and automation of SQL queries and reports.

Environment: Oracle Database 11g/10g, TOAD, Microsoft Windows Server 2008 R2, UNIX, PUTTY, Erwin Data Modeler r7/r8, Tableau Desktop 8.1, Tableau Server, IBM Cognos 10.1 Report Studio, Unix Shell Scripting, PL/SQL, Oracle EBS, IBM information Server Web Sphere Datastage 8.0.

Confidential, Jersey City, NJ

Oracle PL/SQL Developer

Responsibilities:

• Developed Forms based on Master-Detail and Master-Detail-Detail format. Used multiple canvases to display the data effectively and used buttons for navigation.
• Worked with Data warehouses, Data marts and subsets of data for reporting and data analysis purpose. Dealt with Data warehouse architectures and various concepts in data warehouses.
• Worked on Data Migrations, Extractions, Interfaces and customization ofOracleApplicationsEBS10.7, 11i and R12
• Developed Job sequencer with proper job dependencies, job control stages, triggers.
• Involved in writing backend Packages extensively in PL/SQL.
• Used descriptors for getting the input and output values in ANSI SQL.
• Involved in Code Reviews and preparing Unit test cases.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate the costly bugs and functional errors and used right data model for the data mart based on the requirements.
• Used web services manager for policy management and security of service infrastructure.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards besides reviewing the code.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Used Oracle forms 9i to create applications to enter, access, change and delete data from Oracle databases
• Extensively involved in preparing Detailed Technical Documents from the functional specifications.
• Used Key files to hide certain parameters from users and added key mapping entries to a key map file.
• Created stored procedures with ANSI SQL, DDL, and DML to remotely connect with database resources.
• Preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Separating Tables and Indexes on different locations for reducing Disk I/O Contention.
• Used Bulk Binds and Bulk Collect.
• Designed Pragma Autonomous Transactions.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Environment: Oracle Database 11g/10g, TOAD, Microsoft Windows Server 2008 R2, UNIX, PUTTY, PVCS, WinSCP, UNIX. Data Stage 8 Enterprise Edition, SQL Server -2005/2008, Erwin Data Modeler r7/r8, PL/SQL, Oracle EBS, IBM information Server Web Sphere Datastage 8.0, Windows NT/XP.

Confidential, Richmond, VA

Oracle PL/SQL Developer

Responsibilities:

• Design Technical Specifications from Functional Specification (Detail Design) documents.
• Mapped the extracted data from source systems and load it into the target systems after applying the required transformations using ETL tool Informatica Power Center.
• Use SQL*Loader/Perl Script to load data from various sources into an Oracle database.
• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling.
• Wrote PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Involved in Integration test, System test and Implementation.
• Proficiently developed test cases in Quality Center.
• Designed Query Only and Data Entry forms based on the user requirements and involved in meetings with End Users for the effective forms design.
• Extensively developed complex PL/SQL packages for Pricing.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update strategy.
• Used debugger to test the mapping and fixed the bugs.
• Worked with pmcmd to interact with Informatica Server from command mode
• Applied Performance Tuning logic to optimize session performance.
• Attended business user sessions to make changes in warehouse loads.
• Developed UNIX Korn shell scripts to process file feeds.
• Involved in production support during deployment.
• Developed shell scripts for batch processing and database transactions.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.

Environment: Oracle 9i/10g, Oracle Application Server 10g, PL/SQL Developer, TOAD, MS-Windows 2003, UNIX, PUTTY, PVCS, WinSCP, Unix Shell Scripting, Quality Center

Confidential, Jersey City, NJ

Oracle Developer

Responsibilities:

• Involved in Requirement Analysis and developing the Project Definition Document.
• Used XDB UTILITY packages to load XML documents into database tables.
• Worked with CLOB and LOB data types to load large XML documents into database tables.
• Responsible for developing PL/SQL database objects like Functions, Procedures and Packages.
• Developed a PL/SQL conversion program and SQL*Loader program for validating and migrating the legacy agents information into Oracle base tables.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Used Dynamic SQL and autonomous transactions for error handling.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Developed UNIX shell scripts for job scheduling.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Involved in unit testing the application code and database code for data integrity and application functionality.
• Debugged Packages, Procedures, and Functions and fixed them according to the business requirement.
• Tuned the existing SQL queries to improve the performance.
• Involved in the Data Modeling phase of the application.
• Also written UNIX shell scripts to automate the nightly data load from third party servers.

Environment: Oracle Database 10g, SQL, PL/SQL, Oracle Reports, Oracle Forms, PL/SQL Developer, SQL* Plus, Windows 2000, Java, Shell / PERL Scripting, UNIX, XML, FTP, SQL*Loader, Discoverer 4i.

Confidential

Jr. Oracle DBA/Developer

Responsibilities:

• Installing new versions of database software and perform maintenance functions of the database.
• Compiling and debugging packages with in-house code, and assisting the developers
• Wrote Scripts to perform HOT/COLD backups.
• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users using ERWin Data Modeler.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Created Users and maintained security with Roles and Privileges.
• Setup connectivity to databases using NET 8 for clients and server side.
• Developed and maintained the system using Oracle Forms, Oracle Reports, SQL*Plus and PL/SQL.
• Creating database objects such as tables, views, procedures and functions and executed them using SQL*Plus. Created indexes to improve the system performance.
• Various stored procedures were written to achieve the back end functionality.
• Analyzed performance bottlenecks and provides appropriate solutions.
• Wrote various scripts in PERL and SHELL for database health and space checks.

Environment: C/C++, Oracle 8i, 9i, Reports2.5, Oracle Designer, Solaris 5, Windows 2000/NT