SUMMARY:

• Experience of programming in Oracle PL/SQL.
• Experience of programming in Oracle Forms 6i & Reports 6i.
• Experienced in working with Oracle (9i, 10g, 11g), DB2, MS SQL Server 2000/2005, MySQL, Sybase databases on various platforms like UNIX (Solaris, AIX), Linux (RHEL, Fedora, SUSE) and Microsoft NT/2000/2003 Server.
• Excellent skills in designing and development of applications using SQL, PL/SQL, Oracle Database 9i, Designer 2000, SQL*Loader
• Expertise in PL/SQL functions, stored procedures/packages, triggers, constraints, cursors and views, writing test scripts, creating alerts.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Strong development experience in SQL Server, SSIS, SSRS. Ability to tune queries to optimize performance
• Expertise in loading data from legacy systems using SQL*Loader.
• Worked in Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Knowledge of UNIX Shell scripting.
• Experience with Performance Tuning.
• Vast experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by working in development area in using AWR as the main tool to tune SQL queries
• Implemented database monitoring and tuning, application, and queries using TKPROF, Explain Plan, OEM, and custom scripts for optimum performance within testing, development, and production environments.
• Working knowledge of different versions of Oracle database including 9i, 10g and 11g.
• Knowledge of Oracle tools e.g. TOAD.
• Knowledge of Oracle partitioning, hints and dynamic SQL.
• Experience in training, mentoring and leading a development team.
• Knowledge of quality processes.
• Working knowledge of transportation and warehousing functions.
• Experience of working in an AGILE environment.
• Experience of customizing Alerts into Oracle HRMS 11i for multiple clients.
• Experienced in creating configuration files, Logging, Error handling using Event Handlers in SSIS.
• Experienced in writing Vb.net, C#.net, code for SSIS 2005/2008 packages
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
• Working knowledge of Oracle HRMS 11i.
• Proficient in SQL, database concept, data warehouse and data modeling methodologies.
• Extensive experience conducting Manual Testing and using defect management tools like Quality Center and Microsoft Excel.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Java,Hadoop, Salesforce, SQL Server

Scripting Languages: Unix Shell Scripting

Markup Languages: XML

Database: Oracle 12c, 11g, 10g, 9i,8

Database Tools: Toad, SQL Developer, PL/SQL Developer, SQL * Plus

Version Control: Poly Version Control System(PVCS)

Data Migration Tools: SQL Loader

ETL Tool: Informatica

Operating Systems: Windows 8, Windows 7, Windows 2008/2003/2000/ NT/XP

CAREER EXPERIENCE

Confidential, Woodland Hills, CA

Oracle Developer/ Team Lead

Responsibilities:

• Worked on production Support for the maintenance project by creating Change Requests.
• Coordinated with and Managed Off - Shore and On-Site Team.
• Supported development and deployment activities with full coordination with technical consultants.
• Analyzed the issues during and after deployment and participated in data validation.
• Created Change request and Impact analysis documents.
• Worked with dimensional modeling, updating the fact and dimensional tables.
• Worked as Transformation Analyst by analyzing the business logic and transforming the data before loading into target tables.
• Tuned existing procedures to improve performance.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out the projects.
• Created packages to identify the duplicate customer numbers and updating the customer with new values
• Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Extensively used bulk collection in PL/SQL objects for improving the performing
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Worked Used SQL*Loader as an ETL tool to load data into the staging tables Test case/data preparation, execution and verification of the test results..

Environment: Oracle/PL/SQL, Oracle 12c, Unix, TOAD, SQL*Plus, SQL*Loader, Shell Scripting.

Confidential, Agoura Hills, CA

Application Developer

Responsibilities:

• Reviewing of BRD and HLD with Business and system analyst.
• Created stored procedures to Load the data.
• Worked with dimensional modeling, updating the fact and dimensional tables.
• Worked on tuning slow running sql queries based on the AWR Report.
• Worked as Transformation Analyst by analyzing the business logic and transforming the data before loading into target tables.
• Responsible for design and development of ETL Process for data extraction
• Worked on Proof of Concept of Sql server to Oracle Migration
• Worked closely with Cognos developer and helped to tune the reports from the backend.
• Mentored the new intern and trained him in Oracle.
• Mentored and lead the team for the deployment.
• Used Oracle SQL Developer Translator to convert MS-SQL Stored Procedure to Oracle.
• Extracted all DDLs (like Global Temp Tables and any support objects) and Converted the additional objects in Oracle compatible
• Deployed all Pre-Requisite objects and Converted Oracle SP in DB for Data warehousing applications.
• Loaded the Day 0 data and verified the output

Environment: Oracle 11g, TOAD, SQL * Loader, Windows XP

Confidential, Champaign, IL

PL/SQL and UNIX developer

Responsibilities:

• Responsible for creating UNIX shell scripts that modifies the existed procedures.
• Worked on production Support for the maintenance project by creating Change Requests.
• Coordinated with and Managed Off-Shore and On-Site Team.
• Supported development and deployment activities with full coordination with technical consultants.
• Analyzed the issues during and after deployment and participated in data validation.
• Created Change request and Impact analysis documents.
• Created adhoc scripts that updates/deletes/inserts records <500
• Worked on Bulk Collect and Materialized Views
• Worked on creating clean-up scripts
• Worked on creating new scripts that cancels the subscribers or expires the existed records.
• Created various Unix Shell scripts to create wrappers, customization of SQL queries, PL/SQL blocks and implementation of parallel execution (multi-threading) of SQL and PL/SQL scripts.
• Responsible for Production Maintenance and change controls (CCs) and tracking all the problems/requests with production processes through Unified Ticketing System (Remedy) tool.

Environment: Oracle 11g, TOAD, SQL * Loader, Linux

Confidential, Los Angeles, CA

Oracle Developer/Business Analyst

Responsibilities:

• Interacted with the Business Analysts to get design requirements.
• Interacted with the User’s and Subject Matter Expert’s to Created Spec’s.
• Initiating design and code walkthrough sessions with the stakeholders and user groups.
• Analyzing existing code and data for performance bottle necks.
• Tuning and optimization of the existing as well as new code as needed using Oracle hints.
• Conducting peer review for the scope items developed by team members.
• Utilized SQL*Loader to load flat files into database tables.
• Created PL/SQL based ETL process to transfer data from sources.
• Used PL/SQL developing to load data from the source table to the target table based on the business logic.
• Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
• Created PL/SQL blocks using Cursors, REF Cursors, Collections - Nested Table, various Complex Trigger.
• Extensive knowledge of Unified Modeling Language (UML). Modeled views in Rational Rose and Microsoft Visio.
• Created packages to identify the duplicate customer numbers and updating the customer with new values
• Worked as Transformation Analyst by analyzing the business logic and transforming the data before loading into target tables
• Proficient in creating Use Cases, Context diagram, Activity diagram, Class Diagram and Sequence Diagram.
• Created Activity diagrams, ER diagrams, Sequence diagrams in Microsoft Visio.
• Developing of PL/SQL packages, stored procedures and functions for the project as per the requirements using performance enhancement techniques like partitioning, dynamic Sql in Oracle 11g.
• Developing ETL process for the data warehouse in Oracle 11g
• Unit testing of the modules of the project.
• Tested new enhancements and bug fixes before Deployment into the Production environment.
• Worked on Agile methodologies

Environment: Oracle database 10g, PL/SQL, SQL Plus, SQL*LOADER, Windows 2000 Professionaland UNIX.

Confidential, Los Angeles, CA

Sr PL/SQL Developer

Responsibilities:

• Worked in System Analysis, Design, Coding, Testing, Development and Documentation.
• Worked in validating and developing the design and logical phase of the requirement.
• Extensively worked in developing many packages with procedures, functions with cursors.
• Worked with PL/SQL advanced features like collections and records and PL/SQL objects types, involved in performance tuning and development.
• Worked in writing many stored procedures, various functions, triggers and developed monthly and weekly reports.
• Created views, materialized views and indexes on tables as a matter of performance improvement and optimization.
• Worked with Native dynamic SQL in various stored procedures and functions.
• Export and Text IO packages and Written many Stored Procedures and in many Forms and Reports. Worked with UNIX shell scripts and PERL scripts to generate daily reports.
• Good knowledge in database links, Worked on tables, various types of views like inline and materialized views in different databases by linking the databases.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
• Writing Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* loader utility. Embedded programming using Pro*C.
• Merging & updating of Tables using Merge features of SQL*PLUS.
• Worked with Export and Text IO packages and wrote many Stored Procedures in many Forms and Reports. Worked with UNIX shell scripts and PERL scripts to generate daily reports.
• Worked on tables in various databases by linking the databases.
• Worked in data transfer and retrieval through various schemas used TOAD and MySQL.
• Worked with many complex SQL queries with joins, date functions, inline functions, sub queries to generate reports.

Environment: Oracle database 10g, Linux, Toad, Filezilla, Oracle Developer Suite 10g, PUTTY.

Confidential

PL/SQL Developer/ Business Analyst

Responsibilities:

• Interacted with the business users on a regular basis to collect Business Requirements and Specifications.
• Liaison between stakeholders, system users, clients and managers, software development team and the QA team to gather requirements
• Created Business Requirements Document and converted them into System Requirement specifications Document.
• Responsible for the development of Reports using SSRS.
• Writing queries and Stored Procedures in SQL Server 2005.
• Developing client side reports using SSRS and integrating with Windows Applications using Report Viewer
• Used Rational Clear Quest for defect tracking and change management request and reported them.
• Tested new enhancements and bug fixes before Deployment into the Production environment.
• Worked as part of a team to launch new Application Releases under strict time deadlines
• Coded database Triggers, Package, Functions, and Procedures using PL/SQL and maintained the scripts for various data feeds.
• Optimized and Tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Responsible for designing and maintaining fully integrated and multiple levels help system for the modules.
• Experienced in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
• Writing Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* loader utility.
• Well versed in creating Dynamic SSIS packages, using containers & variables, configuring the packages, and scheduling the packages.
• Experienced in creating configuration files, Logging, Error handling using Event Handlers in SSIS.
• Experienced in writing Vb.net, C#.net, code for SSIS 2005/2008 packages
• Prepared functional specifications, release notes, training materials and other documentation.
• Prepare Test Plan, Test schedules and release estimates.
• Expertise in development of test plan, test cases, test scenarios and test data based on the business rules and functional requirements.
• Attend and update daily testing activity in the scrum meeting.
• Participate and contribute in Sprint planning, Sprint review and retrospect.
• Participate in QA/Dev meetings to discuss issues on current release testing.
• Reviewed unit test plan with developers, QA manager, and team and execute entrance criteria of system testing with developer.
• Prepared weekly status reports to the project management team that reflects the progress of testing and bug fixes.
• Worked proactively with client to handle all issues and resolved them in a timely fashion.
• Export and Text IO packages and wrote many Stored Procedures in many Forms and Reports. Worked with UNIX shell scripts and PERL scripts to generate daily reports.
• Managed, documented and controlled all test cases, test script and test results.
• Managed Defect Tracking and Defect impact via Rational Clear Quest during the testing phase.
• Review of Security policies in the SQL Server and ensuring its effective implementation
• Maintenance of up-to-date documentation

Environment: Windows XP, UNIX, ORACLE (11g), PL/SQL, AGILE methodology, SVN.