SUMMARY

• Over 11 years of programming experience as an Oracle SQL, PL/SQL, ETL Developer in Analysis, Design, Support and Implementation of Business Applications in OLTP, Client/Server architecture and data warehouse applications.
• Strong Knowledge on oracle architecture and database design.
• 3+ years of Microsoft SQL programming, 3+ years of experience in Production Support. Worked in 24X7 environments and resolved the issues in the prescribed SLA limits.
• 2+ years of experience in Oracle BI Publisher 11g
• Solid experience in translating business requirements into creation of Database Objects.
• Good Experience in developing PLSQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors Ref Cursors, Analytical Functions, Collections, Exception Handling.
• Extensive experience in analysis and design of database ER Diagrams,
• Experience working on Onsite/Offshore Model, Production Support, Release management, documentation.
• Extensive experience in Relational database analysis, design, development, testing support, project management and implementation of applications primarily using Client/Server, Middleware, Enterprise Application Integration, RDBMS and Object Oriented technology to accommodate client’s distinct business needs.
• Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
• Good experience as Data analyst for migrating data from Oracle to CSV files or Excel.
• Tuned SQL queries using Explain Plan and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Expertise in loading data from legacy systems using SQL*Loader.
• Have in - depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, PL/SQL scripts.
• Extensively worked with third party database tools like TOAD & SQL Developer.
• Worked with various performance tuning techniques using tools provided by Oracle like SQL*TRACE, TKPROF, HINTS etc.
• Used DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Used DBMS XMLGEN to Parse and Fetch XML data.
• Good understanding of Relational database design and developed various data models using ERWIN.
• Experience in using oracle long data types like CLOB
• Experience in Handling Exceptions.
• Experience with software Development life cycle (SDLC) process performing detailed analysis, collecting requirements, documents requirements, coding and unit testing, integration and system testing.
• Experience in Coordinating with off-shore and on-site teams to explain client requirement.
• Experience in Understanding complex performance issues and worked with DBA’s to to fix the problem.
• Experience in query optimization (executions plans, hints, indexes, etc.), partitioning, materialized views and using analytical functions.
• Knowledge in creating webpages using HTML, JSP and EJB.
• Experience in ETL to load data from Flat files to Data Warehouse.
• Worked on creating SQL*Loader control programs, PL/SQL validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle Applications.
• Prepared BRS (Business Requirement Specifications) document dat gives the detailed information about the requirements.
• Creating RTF reports using Oracle BI Publisher 11g.
• Creating RPD, doing modifications to the repository.
• Creating of new Analysis, Dashboards and modifying existing Analysis and Dashboards.
• Adding BI Publisher reports in Dashboards.
• Programming work experience with Batch Scripting and shell scripting as a part of Batch Processing.
• Professional experience in using External Tables and Temporary tables.
• Extensive knowledge and experience in SQL Queries.
• Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers.
• Has experience in export & import of databases.
• 6 months experience in Oracle Applications in creating and customizing Reports.
• Have Knowledge in Reports 6i, XML Publisher
• Has knowledge on creating Dashboards, and integrating BI Publisher reports in OBIEE 11g.
• Strong analytical skills.
• Have experience in converting sql server 2008 database to oracle 11g.
• Possess excellent oral / written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

RDBMS: Oracle 9i/10g/11g/12c, SQL SERVER 2008Languages SQL, PL/SQL, TSQL, Unix shell scripting, Core Java

Operating Systems: Windows Server 2000/2003, Oracle Enterprise Linux, Red hat Linux

Development Tools: SQL*Plus, TOAD, SQL *Loader, SQL Developer

Oracle utilities: SQL Loader, EXP/IMP, EXPDP/IMPDP, RMAN

Reporting Tools: Oracle BI Publisher 11g, BO XI R3, OBIEE 11g

PROFESSIONAL EXPERIENCE

Confidential, MI

Programmer Analyst

Responsibilities:

• Identify data entities for migration into new CPR system and architect database for new system.
• Normalize and structure database objects for new CPR system, construct data load scripts and load data from mainframe through nightly batches.
• Design and develop database procedures handling and validating all business logics.
• Assist front end team in understanding table structures and business logics handled at database level and help write complex queries, review and performance tune queries.
• Updating Management team on latest Database features and help them in making decisions.
• Interact with corporate Architect group, Review current system architecture and recommend on design changes.
• Prepare application design with detail impact specifying impact on data flow, change in business logic of Shell Scripts, Oracle Pl/sql, performance/testing consideration, change in data volume & dependency.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Understanding requirements and discussing requirements with Business Analyst.
• Data Loads using the SQL* Loader
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.
• Creating PL/SQL packages, procedures, functions and triggers as per the business requirements.
• Preparing build scripts by release to higher environments.
• Monitoring the databases and identifying the long running queries and tuning the SQL
• Writing PL/SQL packages, procedures and functions as per the business needs.
• Creating triggers for auditing the data.
• Fixing the issues dat are reported by the client.
• Created database objects such as tables, views, indexes and sequences according to business requirements.
• Created & maintained jobs using Shell Scripts..
• Responsible for validation and creation of supporting documentation of new products and services delivered to our internal customers.
• Performed load and integration tests on all programs created and applied version control procedures to ensure dat programs are properly implemented in production.
• Imported data from various sources (oracle, fixed width flat files) transformed and loaded into targets.
• Worked with business analysts for business requirements, analysis and technical specifications.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Developed and maintained UNIX and Shell scripts for database process and conversions.

Confidential, Lake Forest, CA

PL/SQL Developer

Responsibilities:

• Identify data entities for migration into new CPR system and architect database for new system.
• Normalize and structure database objects for new CPR system, construct data load scripts and load data from mainframe through nightly batches.
• Design and develop database procedures handling and validating all business logics.
• Assist front end team in understanding table structures and business logics handled at database level and help write complex queries, review and performance tune queries.
• Updating Management team on latest Database features and help them in making decisions.
• Interact with corporate Architect group, Review current system architecture and recommend on design changes.
• Prepare application design with detail impact specifying impact on data flow, change in business logic of Shell Scripts, Oracle Pl/sql, performance/testing consideration, change in data volume & dependency.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Understanding requirements and discussing requirements with Business Analyst.
• Data Loads using the SQL* Loader
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.
• Creating PL/SQL packages, procedures, functions and triggers as per the business requirements.
• Preparing build scripts by release to higher environments.
• Monitoring the databases and identifying the long running queries and tuning the SQL
• Writing PL/SQL packages, procedures and functions as per the business needs.
• Creating triggers for auditing the data.
• Fixing the issues dat are reported by the client.
• Created database objects such as tables, views, indexes and sequences according to business requirements.
• Created & maintained jobs using Shell Scripts..
• Responsible for validation and creation of supporting documentation of new products and services delivered to our internal customers.
• Performed load and integration tests on all programs created and applied version control procedures to ensure dat programs are properly implemented in production.
• Imported data from various sources (oracle, fixed width flat files) transformed and loaded into targets.
• Worked with business analysts for business requirements, analysis and technical specifications.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Analyze Business and Technical Requirements.
• Involved in gathering elements from different data marts to consolidate in to single data mart.
• Prepare application design with detail impact specifying impact on data flow, change in business logic of Shell Scripts, Oracle Pl/sql, performance/testing consideration, change in data volume & dependency.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Understanding requirements and discussing requirements with Business Analyst.
• Writing stored procedures, triggers and functions using PL/SQL.
• Data Loads using the SQL* Loader
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.
• Rebuilding the Indexes for performance of SQL Queries.
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Production Support for the nightly cycle jobs to load financial data into the system.
• Creating PL/SQL packages, procedures, functions and triggers as per the business requirements.
• Backup of all the databases (development and QA databases).
• Preparing build scripts by release to higher environments.
• Monitoring the databases and identifying the long running queries and tuning the SQL
• Queries, identifying the deadlock queries and informing to the development team.
• Writing PL/SQL packages, procedures and functions as per the business needs.
• Creating triggers for auditing the data.
• Fixing the issues dat are reported by the client.
• Creating reports using Oracle BI Publisher 11g.
• Modifying Oracle 6i Reports. Migrating Oracle 6i Reports to BI Publisher.
• Created database objects such as tables, views, indexes and sequences according to business requirements.
• Created & maintained jobs using Shell Scripts..
• Participate in mock deployment of every release, help to prepare release plan, identify the dependencies.
• As part of the Production Support team resolved failures in production data processing.
• Responsible for validation and creation of supporting documentation of new products and services delivered to our internal customers.
• Performed load and integration tests on all programs created and applied version control procedures to ensure dat programs are properly implemented in production.
• Imported data from various sources (oracle, fixed width flat files) transformed and loaded into targets.
• Worked with business analysts for business requirements, analysis and technical specifications.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Developed and maintained UNIX and Shell scripts for database process and conversions.

Confidential

Senior Oracle Developer

Responsibilities:

• Analyze Business and Technical Requirements.
• Involved in gathering elements from different data marts to consolidate in to single data mart.
• Prepare application design with detail impact specifying impact on data flow, change in business logic of Shell Scripts, Oracle Pl/sql, performance/testing consideration, change in data volume & dependency.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Developed PLSQL Packages/Procedures/Functions for massaging the data as per business requirement.
• Created Shell Scripts to automate batch jobs.
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.
• Rebuilding the Indexes for performance of SQL Queries.
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Involved in Developing and handling the PL/SQL Packages, Procedures and functions.
• Involved in tuning SQL queries by using EXPLAIN PLAN.
• Development, test specification creation and unit testing for various changes.
• Review design, code, and unit test cases.
• Participate in mock deployment of every release, help to prepare release plan, identify the dependencies.
• As part of the Production Support team resolved failures in production data processing. Resolving an average of 5 tickets per day.
• Responsible for validation and creation of supporting documentation of new products and services delivered to our internal customers
• Performed load and integration tests on all programs created and applied version control procedures to ensure dat programs are properly implemented in production.
• Migrating SQL Server 2008 Database to Oracle 11g.
• Assigning tasks to other team members in accomplishing the deadlines for the CRs.
• Handling multiple projects.
• Involved in gathering elements from different data marts to consolidate in to single data mart.
• Developed PLSQL Packages/Procedures/Functions for massaging the data as per business requirement.
• Created Shell Scripts to automate batch jobs.
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.
• Rebuilding the Indexes for performance of SQL Queries.
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Involved in tuning SQL queries by using EXPLAIN PLAN.
• Involved in database upgrade & impact on application.
• Development, test specification creation and unit testing for various changes.
• Review design, code, and unit test cases.
• Participate in mock deployment of every release, help to prepare release plan, identify the dependencies.
• Provided on-call production support for several applications
• Responsible for all aspects of product engineering, release management and production support
• Provided Production support by tracking issues and monitoring the processes running.
• Unit testing, User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: Oracle11g, XML, TOAD,ETL, DWH, Java, UNIX Scheduler, MS SQL Server 2008.

Confidential

PL/SQL Developer

Responsibilities:

• Performance Tuning of SQL Queries.
• Creating PL/SQL packages, procedures, functions and triggers as per the business requirements.
• Taking backup of all the databases (development and QA databases).
• Preparing build scripts by release and sending to US office for testing.
• Fixing the issues dat are reported by the client.
• Creating and modifying the reports using BO XI R3 as per the business logic.
• Monitoring the databases and identifying the long running queries and tuning the SQL
• Queries, identifying the deadlock queries and informing to the development team.
• Writing PL/SQL packages, procedures and functions as per the business needs.
• Creating triggers for auditing the data.
• Monitoring Disk usage and free space.
• Has fixed errors proactively and reduced the number of iterations in processing the data
• Involved in tuning the performance of the long running queries.
• Designed Report for Logistics, manufacturing and lots module. Specifically in shipment requests, transfer requests, pick and pack, returns, site reconciliations, manufacturing requests, treatment kits, lot inventory, lot quality, assign kits, lot ordering and lot regulatory.
• Designed Universe and report using webi rich client and desktop intelligence.
• Implemented cascading list of values. Used @variable ( ) and @prompt ( ) functions. Set cardinalities and defined contexts. Created derived tables. Implemented sort and ALL in list of values.
• Created classes, objects, define condition objects in universe level.
• Created complicated condition and combined queries in query filters. Implemented optional prompt and pattern matching in query filters.
• Designed multiple section wise display of record in report.

Confidential

Programmer Analyst

Responsibilities:

• Writing SQL queries, Triggers and stored procedures development
• Daily Jobs analysis and
• SQL queries, Triggers and stored procedures development
• Daily Jobs analysis and constructions.
• PL/SQL Scripts for the backfill and yearly database maintenance.
• Impact analysis.
• Release Management
• Unit Testing and Documentation.
• Production support.
• Creating Webpages using JSP, EJB
• Creating Database Tables
• PL/SQL Packages to Populate data from Stage Tables to Base Tables
• Schedule the Scripts
• Creating RTF Reports
• Customizing RTF Reports
• Customizing RDF’s ( reports 6i)
• Performance Tuning of SQL Queries, Loading Data using SQL Loader
• Unit Testing and Documentation.