PROFESSIONAL SUMMARY

• Around 7 years of experience in software analysis, design, data modeling, development, testing, implementation, support and documentation of applications with specialization in Oracle technologies
• Extensive experience in Oracle SQL, PL/SQL, UNIX, Shell Scripting and preparing use cases, functional specifications technical design specifications.
• Competent in developing flowcharts, algorithms and UML diagrams required for design/development
• Extensive solid hands-on experience in Oracle Development - SQL, PL/SQL, Shell Scripting bash/ksh/csh , Java classes
• Proficient in creation of ODI objects and tailoring knowledge modules to suit publishing needs.
• Proficient in creation of database objects like stored procedures, functions, packages, tables, indexes, triggers, snapshots etc. Good experience in performing data migrations, data loads using ETL tools
• Experience in writing OOP PL/SQL codes for applications demanding type objects, nested tables
• Strong experience in performing SQL tuning and PL/SQL application performance tuning with SQL Trace TKPROF, SQL Analyze, DBMS traces and OEM/Diagnostics
• Good exposure to DBA routine tasks like managing users, roles, privileges, schema and objects, developing database triggers for user access audit and reporting
• Experience working with designing and reporting tools like Oracle Forms/Reports
• Good experience in database supporting languages like WMI, Perl, J/Python, and VBScript
• Experience in designing logical database models using Data Modeling tools like Oracle Designer, ERWin, WorkBench, SQL Developer
• Experience in job scheduling using CRON utilities, legacy AT scheduler, windows scheduler, Toad
• Self-motivated and committed team player with excellent communication and interpersonal skills.
• Quick learner, versatile, adaptable and process-oriented, with a high customer orientation.
• Team player to accomplish business Engineering, Integration, Deployment and Maintenance of e-business systems.

TECHNICAL SKILLS

ERP : Oracle Applications 11i/ R12 E-Business Suite

OPERATING SYSTEMS : WINDOWS98/NT/2000/XP, Solaris 5.8, UNIX, Linux

RDBMS : Database ORACLE 11g/10g/9i/8i, SQL Server 2008

SCRIPTING LANGUAGES : Shell, Perl, JavaScript, Python

LANGUAGES : SQL, PL/SQL, HTML, XML

DESIGN TOOLS : Oracle Forms Reports 6i/10g/11g

TOOLS : TOAD 9/10, SQL Developer, Informatica, Erwin r7/r4.5, Pro C, VSS, Clear Case

APPLICATION/WEB SERVERS: Oracle Application Server 10g, Tomcat

WORK SUMMARY

Confidential

Senior Oracle PL/SQL Developer

Confidential is an automobile insurance company providing services through agents and online. RTR is a service oriented application interacting with agent's dashboard to give the quote based on the coverage, vehicles, drivers included on the policy. It modifies the request according to the Bristol West BW rules, calls COBOL ALR, generatepayplans, calculates premium, applies discount.

Responsibilities

• Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
• Created data accuracy and consistency reports.
• Created complex relational database queries/SQL, dynamic SQL.
• Used various report items like tables, sub report and charts to develop standard and customized reports.
• Worked on designing, coding, testing and maintaining database objects, tables, views, packages, functions, procedures, indexes, sequences and triggers using Oracle PL/SQL.
• Developed the ETL mappings in PL/SQL via packages, procedures, functions, views and triggers.
• OWB repository creation/configuration/monitoring, mapping/process flow development.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Built physical data structures like tables, views, constraints Indexes.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Loaded the data into database tables using SQL loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Review modifications to existing software to improve efficiency and performance.
• Analyze Korn shell scripts on UNIX platforms.
• Involved in physical and logical data modeling using Erwin.
• Involved interfacing with the following tools: PL/SQL, Oracle Forms, Oracle Reports, Crystal Reports, and/or Oracle APEX.
• Part of a development team for creation and maintenance of custom apps/reports.
• Created complex stored procedures to collect, analyze, and report on data across multiple functional and line of business systems in response to customer requirements.
• Created ETL design specifications.
• Solid understanding of both the business and the technical aspects of BI Solutions.
• Created table partitioning based on the systems and date range.
• Used SQL Loader with both direct and indirect load methodologies.
• Query optimization using Explain Plan TK Prof utility.
• Developed extraction, transformation and loading scripts using SSIS.
• Created SQL and PL/SQL scripts to detect data defects/anomalies in systems.
• Converted T-SQL to PL/SQL or vice versa to report data consistency cross multiple databases.

Environment:Oracle 11g, RHEL 5, SQL Developer, PLSQL Developer, ODI, Putty, Perl, Python/Jython, HP-Unix, Oracle Enterprise Manager, VSS, Toad Data Modeler

Senior PL/SQL Developer

Confidential is the second-largest pharmaceutical company in the world. As with all drug-makers, research and development is the engine of its business. Pfizer Data Services project was initiated to store the Dimensional and transactional data of Pfizer Pharma. The dimensional data included the doctor's details/Pharmaceutical products etc.

Responsibilities

• Used SQL hints and Indexes as needed to improve SQL performance.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Involved development in Oracle Warehouse Builder out of 11i source system.
• Develop data models according to company standards.
• Worked with several tools to access and perform several operations on database
• Modify existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application.
• Part of a development team for creation and maintenance of custom apps/reports.
• Coordinate with the DBA for Table creation and other administrative activities.
• Responsible for analyzing tables and indexes regularly to keep the STATS up-to-date.
• Involve in Data Extraction, Transformation and Loading ETL process from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Deliver solutions that are reliable, easy to maintain and meet or exceed established performance measures.
• Knowledge of developing BI solutions for enterprise processes such as financials, supply-chain etc.
• Create new database objects like tables, Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment in Oracle PL/SQL.
• Extensive experience with building application using Oracle APEX.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Involved in writing several Queries and Procedures.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Designing of ER diagrams for Data Modeling was done using ERWIN Tools.
• Develop and maintain Perl scripts that process data from vendors and other sources
• Application Development may involve interfacing with the following tools: PL/SQL, Oracle Forms, Oracle Reports, Crystal Reports, and/or Oracle APEX.
• Worked on Korn shell scripts on UNIX platforms.
• Involve in the continuous enhancements and fixing of production problems.
• Worked with different teams to set up the development and test Autosys environments.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Solving the offshore technical issues and co-coordinating between offshore team and client.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Created Work Instruction Manual listing the possible failures and Recovery steps for each and every new job added as part of the project.

Environment: Oracle 11g, PL/SQL Developer, UNIX, Windows XP, Java v1.6, PowerBuilder.

Confidential

ETL / Informatica Developer

Confidential The project was initiated to store the data in the Data warehouse related to products , Insurance Quotations, Customers Individual and Businesses and Services that meet the insurance, protection, savings, retirement and financial planning needs of millions of customers throughout the

Responsibilities

• Work with business to gather system requirements and produce detailed requirement and functional specification documents to solve moderately complex problems within information systems.
• Perform analysis, process design, mapping and re-engineering, gap analysis and resolution.
• Conduct system testing with development teams and business to validate requirements
• Worked in Oracle E-Business Suite and implemented to ease the payment system.
• Experience in logical data modeling and schema export/import
• Involved in creating user authentication module for web based reports used PHP/HTML for front-end development and Oracle as RDBMS
• Implemented Oracle Modules on Accounts Receivables.
• Created function and technical specification documentation.
• Worked on various backend Procedures, Functions and Cursors.
• Developed PL/SQL Triggers to monitor the database activities and to implement some database constraints.
• Extensively used UTL FILE to read and write files that are located on the server, Optimized the performance using PL/SQL table types and record types.
• Worked on customizations requested by users as part of the production support.
• Worked directly with the end users and resolved production issues.
• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Developed batch programs in Pro C and wrote Scripts to run them on Unix Cron Scheduler.
• Extracted data from Flat files, Oracle and SQL server sources.

Environment:ORACLE 10/9i, MySQL 5.0, RHEL 2.1 ES, SQL Plus, TOAD, SQL Loader, SQL, PL/SQL Developer, UNIX, Linux, Windows XP.

Jr. Developer

Responsibilities

• Used Oracle Developer to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API's like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Used Oracle Developer to support JAVA, JSP and HTML codes used in modules.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Strong analytical and problem solving skills.
• Creating database objects like tables, indexes, views, packages and procedures using PL/SQL Developer.
• Sequences packages and procedures.
• Involved in Logical Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Worked on XML along with PL/SQL to modify/create interface between system Performed Database Administration of all database objects including tables, clusters, indexes, views, Performance tuning of Oracle Databases and User applications.
• Used SQL Loader as an ETL tool to load data into the staging tables.
• Provided user training and production support.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment:Oracle 8i, Solaris 5.9, SQL Developer 1.1, Serena PVCS, Oracle Enterprise Manager, Oracle forms 6i, Windows 2000